columns

18 rows where table_id = 55

View and edit SQL

id ▼ table_id name
204 Street_Tree_List 55 TreeID
205 Street_Tree_List 55 qLegalStatus
206 Street_Tree_List 55 qSpecies
207 Street_Tree_List 55 qAddress
208 Street_Tree_List 55 SiteOrder
209 Street_Tree_List 55 qSiteInfo
210 Street_Tree_List 55 PlantType
211 Street_Tree_List 55 qCaretaker
212 Street_Tree_List 55 qCareAssistant
213 Street_Tree_List 55 PlantDate
214 Street_Tree_List 55 DBH
215 Street_Tree_List 55 PlotSize
216 Street_Tree_List 55 PermitNotes
217 Street_Tree_List 55 XCoord
218 Street_Tree_List 55 YCoord
219 Street_Tree_List 55 Latitude
220 Street_Tree_List 55 Longitude
221 Street_Tree_List 55 Location

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