databases

4 rows where datasette_id = 3 sorted by id descending

View and edit SQL

id ▲ datasette_id name
5 San Francisco 3 sf-trees
4 San Francisco 3 sf-film-locations
3 San Francisco 3 registered-business-locations
2 San Francisco 3 food-trucks

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 8.246ms