columns

1,690 rows

View and edit SQL

id ▼ table_id name
201 qCareAssistant 53 value
202 qLegalStatus 54 id
203 qLegalStatus 54 value
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
222 Street_Tree_List_fts 56 qLegalStatus
223 Street_Tree_List_fts 56 qSpecies
224 Street_Tree_List_fts 56 qAddress
225 Street_Tree_List_fts 56 qSiteInfo
226 Street_Tree_List_fts 56 PlantType
227 Street_Tree_List_fts 56 qCaretaker
228 Street_Tree_List_fts 56 qCareAssistant
229 Street_Tree_List_fts 56 PermitNotes
230 Street_Tree_List_fts_segments 57 blockid
231 Street_Tree_List_fts_segments 57 block
232 Street_Tree_List_fts_segdir 58 level
233 Street_Tree_List_fts_segdir 58 idx
234 Street_Tree_List_fts_segdir 58 start_block
235 Street_Tree_List_fts_segdir 58 leaves_end_block
236 Street_Tree_List_fts_segdir 58 end_block
237 Street_Tree_List_fts_segdir 58 root
238 Street_Tree_List_fts_docsize 59 docid
239 Street_Tree_List_fts_docsize 59 size
240 Street_Tree_List_fts_stat 60 id
241 Street_Tree_List_fts_stat 60 value
242 Applicant 61 id
243 Applicant 61 value
244 FacilityType 62 id
245 FacilityType 62 value
246 block 63 id
247 block 63 value
248 Status 64 id
249 Status 64 value
250 Mobile_Food_Facility_Permit 65 locationid
251 Mobile_Food_Facility_Permit 65 Applicant
252 Mobile_Food_Facility_Permit 65 FacilityType
253 Mobile_Food_Facility_Permit 65 cnn
254 Mobile_Food_Facility_Permit 65 LocationDescription
255 Mobile_Food_Facility_Permit 65 Address
256 Mobile_Food_Facility_Permit 65 blocklot
257 Mobile_Food_Facility_Permit 65 block
258 Mobile_Food_Facility_Permit 65 lot
259 Mobile_Food_Facility_Permit 65 permit
260 Mobile_Food_Facility_Permit 65 Status
261 Mobile_Food_Facility_Permit 65 FoodItems
262 Mobile_Food_Facility_Permit 65 X
263 Mobile_Food_Facility_Permit 65 Y
264 Mobile_Food_Facility_Permit 65 Latitude
265 Mobile_Food_Facility_Permit 65 Longitude
266 Mobile_Food_Facility_Permit 65 Schedule
267 Mobile_Food_Facility_Permit 65 dayshours
268 Mobile_Food_Facility_Permit 65 NOISent
269 Mobile_Food_Facility_Permit 65 Approved
270 Mobile_Food_Facility_Permit 65 Received
271 Mobile_Food_Facility_Permit 65 PriorPermit
272 Mobile_Food_Facility_Permit 65 ExpirationDate
273 Mobile_Food_Facility_Permit 65 Location
274 Mobile_Food_Facility_Permit_fts 66 Applicant
275 Mobile_Food_Facility_Permit_fts 66 FacilityType
276 Mobile_Food_Facility_Permit_fts 66 Address
277 Mobile_Food_Facility_Permit_fts 66 LocationDescription
278 Mobile_Food_Facility_Permit_fts 66 FoodItems
279 Mobile_Food_Facility_Permit_fts_segments 67 blockid
280 Mobile_Food_Facility_Permit_fts_segments 67 block
281 Mobile_Food_Facility_Permit_fts_segdir 68 level
282 Mobile_Food_Facility_Permit_fts_segdir 68 idx
283 Mobile_Food_Facility_Permit_fts_segdir 68 start_block
284 Mobile_Food_Facility_Permit_fts_segdir 68 leaves_end_block
285 Mobile_Food_Facility_Permit_fts_segdir 68 end_block
286 Mobile_Food_Facility_Permit_fts_segdir 68 root
287 Mobile_Food_Facility_Permit_fts_docsize 69 docid
288 Mobile_Food_Facility_Permit_fts_docsize 69 size
289 Mobile_Food_Facility_Permit_fts_stat 70 id
290 Mobile_Food_Facility_Permit_fts_stat 70 value
291 Mail City 71 id
292 Mail City 71 value
293 City 72 id
294 City 72 value
295 NAICS Code Description 73 id
296 NAICS Code Description 73 value
297 NAICS Code 74 id
298 NAICS Code 74 value
299 State 75 id
300 State 75 value

Next page

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