This data as json, CSV (advanced)
id ▼ | datasette_id | name |
---|---|---|
2 | San Francisco 3 | food-trucks |
3 | San Francisco 3 | registered-business-locations |
4 | San Francisco 3 | sf-film-locations |
5 | San Francisco 3 | sf-trees |
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) );