datasettes

1 row where source_hash = "c30bdfb1"

descending

id ▼	title	url	about_url	description	source_hash	license_hash
12	Ministry of Defence MERLIN Vehicle Database	http://mod-merlin.herokuapp.com/			c30bdfb1

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)
        );