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

416 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ city_ascii label country website biometrics notes latitude longitude id
401 401 Ottawa, Ontario Ottawa East Service Canada Centre SCO Canada   By appointment only Click here to make an appointment Walk-in appointments are unavailable      
402 402 Hamilton, Ontario Passport Services Centre SCO Canada   By appointment only Click here to make an appointment Walk-in appointments are unavailable      
403 403 St. Catharines, Ontario Passport Services Centre SCO Canada   By appointment only Click here to make an appointment Walk-in appointments are unavailable      
404 404 Whitby, Ontario Passport Services Centre SCO Canada   By appointment only Click here to make an appointment Walk-in appointments are unavailable      
405 405 Brampton, Ontario Passport Services Centre SCO Canada   By appointment only Click here to make an appointment Walk-in appointments are unavailable      
406 406 Mississauga, Ontario Passport Services Centre SCO Canada   By appointment only Click here to make an appointment Walk-in appointments are unavailable      
407 407 Toronto, Ontario Passport Services Centre SCO Canada   By appointment only Click here to make an appointment Walk-in appointments are unavailable      
408 408 Scarborough, Ontario Passport Services Centre SCO Canada   By appointment only Click here to make an appointment Walk-in appointments are unavailable      
409 409 North York, Ontario Passport Services Centre SCO Canada   By appointment only Click here to make an appointment Walk-in appointments are unavailable      
410 410 Toronto, Ontario Toronto - West Humber Service Canada Centre SCO Canada   By appointment only Click here to make an appointment Walk-in appointments are unavailable      
411 411 Toronto, Ontario Toronto - College Street Service Canada Centre SCO Canada   By appointment only Click here to make an appointment Walk-in appointments are unavailable      
412 412 Windsor, Ontario Passport Services Centre SCO Canada http://www.servicecanada.gc.ca/tbsc-fsco/sc-dsp.jsp?rc=3000&lang=eng By appointment only Click here to make an appointment Walk-in appointments are unavailable      
413 413 Kitchener, Ontario Passport Services Centre SCO Canada   By appointment only Click here to make an appointment Walk-in appointments are unavailable      
414 414 London, Ontario Passport Services Centre SCO Canada   By appointment only Click here to make an appointment Walk-in appointments are unavailable      
415 415 Sudbury, Ontario Service Canada Centre SCO Canada   By appointment only Click here to make an appointment Walk-in appointments are unavailable      
416 416 Thunder Bay, Ontario Passport Services Centre SCO Canada   By appointment only Click here to make an appointment Walk-in appointments are unavailable      

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "table1" (city_ascii TEXT, label TEXT, country TEXT, website TEXT, biometrics TEXT, notes TEXT, latitude REAL, longitude REAL, id INTEGER);