databases

2 rows where name = "food-trucks"

descending

id ▼	datasette_id	name
2	San Francisco 3	food-trucks
6	VICE News Police Shootings 4	food-trucks

Advanced export

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

CREATE TABLE databases (
            id integer PRIMARY KEY,
            datasette_id integer,
            name text,
            -- TODO: source_hash, license_hash etc
            FOREIGN KEY (datasette_id) REFERENCES datasettes(id)
        );