databases

4 rows where datasette_id = 3 sorted by datasette_id

View and edit SQL

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

Advanced export

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

CSV options:

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)
        );
Powered by Datasette · Query took 7.373ms