This data as json, CSV (advanced)
id ▼ | datasette_id | name |
---|---|---|
3 | San Francisco 3 | registered-business-locations |
7 | VICE News Police Shootings 4 | registered-business-locations |
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) );