columns

5 rows where table_id = 15

View and edit SQL

id ▼ table_id name
63 Mobile_Food_Facility_Permit_fts 15 Applicant
64 Mobile_Food_Facility_Permit_fts 15 FacilityType
65 Mobile_Food_Facility_Permit_fts 15 Address
66 Mobile_Food_Facility_Permit_fts 15 LocationDescription
67 Mobile_Food_Facility_Permit_fts 15 FoodItems

Advanced export

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

CSV options:

CREATE TABLE columns (
            id integer PRIMARY KEY,
            table_id integer,
            name text,
            FOREIGN KEY (table_id) REFERENCES tables(id)
        );
Powered by Datasette · Query took 8.771ms