table1
Data license: http://open.canada.ca/en/open-government-licence-canada · Data source: https://open.canada.ca/data/en/dataset/90fed587-1364-4f33-a9ee-208181dc0b97
1 row where notes = "Walk-in appointments are unavailable" and website = "http://www.servicecanada.gc.ca/tbsc-fsco/sc-dsp.jsp?rc=4318&lang=eng"
This data as json, CSV (advanced)
| Link | rowid ▼ | city_ascii | label | country | website | biometrics | notes | latitude | longitude | id |
|---|---|---|---|---|---|---|---|---|---|---|
| 374 | 374 | Saskatoon, Saskatchewan Service Canada Centre and passport services SCO | SCO | Canada | http://www.servicecanada.gc.ca/tbsc-fsco/sc-dsp.jsp?rc=4318&lang=eng | By appointment only Click here to make an appointment | Walk-in appointments are unavailable |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "table1" (city_ascii TEXT, label TEXT, country TEXT, website TEXT, biometrics TEXT, notes TEXT, latitude REAL, longitude REAL, id INTEGER);