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

3 rows where country = "Australia"

View and edit SQL

Link rowid ▼ city_ascii label country website biometrics notes latitude longitude id
192 Melbourne VAC Open with limited services Australia http://www.vfsglobal.ca/canada/australia/ By appointment only The VAC will provide limited services until further notice . Visit the VAC’s website before you go to find out what services are available. -37.8136 144.9631 1036533631
235 Perth VAC Open with limited services Australia http://www.vfsglobal.ca/canada/australia/ By appointment only The VAC will provide limited services until further notice . Visit the VAC’s website before you go to find out what services are available. -31.9522 115.8589 1036178956
318 Sydney VAC Open with limited services Australia http://www.vfsglobal.ca/canada/australia/ By appointment only The VAC will provide limited services until further notice . Visit the VAC’s website before you go to find out what services are available. -33.865 151.2094 1036074917

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);