datasettes

2 rows where license_hash = "953f8894"

descending

id ▼	title	url	about_url	description	source_hash	license_hash
1	Global Power Plant Database	https://global-power-plants.datasettes.com/	https://github.com/simonw/global-power-plants-datasette		65ef650f	953f8894
6	Five Thirty Eight	https://fivethirtyeight.datasettes.com/			e2bdbdb5	953f8894

Advanced export

JSON shape: default, array, newline-delimited, object

CREATE TABLE datasettes (
            id integer PRIMARY KEY,
            title text,
            url text,
            about_url text,
            description text,
            source_hash text,
            license_hash text,
            FOREIGN KEY (source_hash) REFERENCES sources(hash),
            FOREIGN KEY (license_hash) REFERENCES licenses(hash)
        );