1 row where datasette_id = 2

View and edit SQL


  • UK Registers of Members Interest · 1
id ▼ datasette_id name
1 UK Registers of Members Interest 2 regmem

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.618ms