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
139 rows where biometrics = "By appointment only" sorted by country
This data as json, CSV (advanced)
| Link | rowid | city_ascii | label | country ▼ | website | biometrics | notes | latitude | longitude | id |
|---|---|---|---|---|---|---|---|---|---|---|
| 355 | 355 | Yekaterinburg | VAC Open with limited services | Russia | https://visa.vfsglobal.com/rus/en/can | 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. | 56.8356 | 60.6128 | 1643582706 |
| 156 | 156 | Kigali | VAC Open with limited services | Rwanda | https://visa.vfsglobal.com/rwa/en/can | 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. | -1.9536 | 30.0606 | 1646923541 |
| 63 | 63 | Castries | VAC Open with limited services | Saint Lucia | http://www.vfsglobal.ca/Canada/Saint-Lucia | 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. | 14.0167 | -60.9833 | 1662922505 |
| 159 | 159 | Kingstown | VAC Open with limited services | Saint Vincent and the Grenadines | http://www.vfsglobal.ca/Canada/Saint-Vincent-and-the-Grenadines | 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. | |||
| 9 | 9 | Al Khobar | VAC Open with limited services | Saudi Arabia | https://visa.vfsglobal.com/sau/en/can | 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. | |||
| 147 | 147 | Jeddah | VAC Open with limited services | Saudi Arabia | https://visa.vfsglobal.com/sau/en/can | 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. | 21.5428 | 39.1728 | 1682926944 |
| 269 | 269 | Riyadh | VAC Open with limited services | Saudi Arabia | https://visa.vfsglobal.com/sau/en/can | 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. | 24.65 | 46.71 | 1682999334 |
| 83 | 83 | Dakar | VAC Open with limited services | Senegal | https://visa.vfsglobal.com/sen/en/can | 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. | 14.7319 | -17.4572 | 1686604760 |
| 38 | 38 | Belgrade | VAC Open with limited services | Serbia | https://visa.vfsglobal.com/srb/en/can | 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. | 44.8167 | 20.4667 | 1688374696 |
| 299 | 299 | Singapore | VAC Open with limited services | Singapore | http://www.vfsglobal.ca/canada/singapore/ | 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 | 1.3 | 103.8 | 1702341327 |
| 60 | 60 | Cape Town | VAC Open with limited services | South Africa | https://visa.vfsglobal.com/zaf/en/can | 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.925 | 18.425 | 1710680650 |
| 251 | 251 | Pretoria | VAC Open with limited services | South Africa | https://visa.vfsglobal.com/zaf/en/can | 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. | -25.7464 | 28.1881 | 1710176249 |
| 296 | 296 | Seoul | VAC | South Korea | http://www.vfsglobal.ca/canada/korea/english/index.html | By appointment only | Offers other services in local languages | |||
| 186 | 186 | Madrid | VAC Open with limited services | Spain | https://visa.vfsglobal.com/esp/en/can | 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. | 40.4189 | -3.6919 | 1724616994 |
| 78 | 78 | Colombo | VAC Open with limited services | Sri Lanka | http://www.vfsglobal.ca/canada/srilanka/ | 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. | 6.9167 | 79.8333 | 1144251314 |
| 315 | 315 | Stockholm | VAC Open with limited services | Sweden | https://visa.vfsglobal.com/swe/en/can | 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. | 59.3294 | 18.0686 | 1752425602 |
| 321 | 321 | Taipei | VAC | Taiwan | http://www.vfsglobal.ca/canada/taiwan/english/index.html | By appointment only | Offers other services in local languages | 25.0478 | 121.5319 | 1158881289 |
| 96 | 96 | Dushanbe | VAC Open with limited services | Tajikistan | https://visa.vfsglobal.com/tjk/en/can | 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. | 38.5731 | 68.7864 | 1762930616 |
| 85 | 85 | Dar es Salaam | VAC | Tanzania | https://visa.vfsglobal.com/tza/en/can | By appointment only | Starting November 2, 2019: New set of services Offers other services in local languages | -6.8 | 39.2833 | 1834843853 |
| 32 | 32 | Bangkok | VAC Open with limited services | Thailand | https://www.vfsglobal.ca/canada/thailand/ | 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. | 13.75 | 100.5167 | 1764068610 |
| 326 | 326 | The Hague | VAC Open with limited services | The Netherlands | https://visa.vfsglobal.com/nld/en/can | 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. | |||
| 246 | 246 | Port of Spain | VAC Open with limited services | Trinidad and Tobago | https://www.vfsglobal.ca/Canada/Trinidad-and-Tobago/ | 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. | |||
| 332 | 332 | Tunis | VAC Open with limited services | Tunisia | https://visa.vfsglobal.com/tun/en/can | 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. | 36.8008 | 10.18 | 1788742103 |
| 18 | 18 | Ankara | VAC Open with limited services | Turkey | https://visa.vfsglobal.com/tur/en/can | 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. | 39.93 | 32.85 | 1792572891 |
| 141 | 141 | Istanbul | VAC Open with limited services | Turkey | https://visa.vfsglobal.com/tur/en/can | 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. | 41.01 | 28.9603 | 1792756324 |
| 150 | 150 | Kampala | VAC Open with limited services | Uganda | https://visa.vfsglobal.com/uga/en/can | 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. | 0.3136 | 32.5811 | 1800406299 |
| 165 | 165 | Kyiv | VAC Open with limited services | Ukraine | https://visa.vfsglobal.com/ukr/en/can | 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. | 50.45 | 30.5236 | 1804382913 |
| 184 | 184 | Lviv | VAC Open with limited services | Ukraine | https://visa.vfsglobal.com/ukr/en/can | 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. | 49.8419 | 24.0315 | 1804939658 |
| 4 | 4 | Abu Dhabi | VAC Open with limited services | United Arab Emirates | https://visa.vfsglobal.com/are/en/can | 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. | 24.4781 | 54.3686 | 1784176710 |
| 93 | 93 | Dubai | VAC Open with limited services | United Arab Emirates | https://visa.vfsglobal.com/are/en/can | 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. | 25.2697 | 55.3094 | 1784736618 |
| 176 | 176 | London | VAC Open with limited services | United Kingdom | https://visa.vfsglobal.com/gbr/en/can | 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. | 51.5072 | -0.1275 | 1826645935 |
| 179 | 179 | Los Angeles | VAC Open with limited services | United States | https://www.vfsglobal.ca/Canada/USA/ | 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. | 34.1139 | -118.4068 | 1840020491 |
| 213 | 213 | New York | VAC Open with limited services | United States | https://www.vfsglobal.ca/Canada/USA/ | 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. | 40.6943 | -73.9249 | 1840034016 |
| 279 | 279 | San Francisco | Temporary VAC For biometrics only Closing November 19, 2021 | United States | https://www.vfsglobal.ca/Canada/USA/ | By appointment only | This VAC is open temporarily only to collect biometrics . This VAC will close permanently on November 19, 2021. | |||
| 294 | 294 | Seattle | Temporary VAC For biometrics only Closing November 19, 2021 | United States | https://www.vfsglobal.ca/Canada/USA/ | By appointment only | This VAC is open temporarily only to collect biometrics . This VAC will close permanently on November 19, 2021. | 47.6211 | -122.3244 | 1840021117 |
| 201 | 201 | Montevideo | VAC Open with limited services | Uruguay | http://www.vfsglobal.ca/canada/uruguay/english/index.html | 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. | -34.8667 | -56.1667 | 1858107000 |
| 61 | 61 | Caracas | VAC Open with limited services | Venezuela | https://www.vfsglobal.ca/Canada/Venezuela/English/index.html | 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. | 10.5 | -66.9333 | 1862748204 |
| 125 | 125 | Hanoi | VAC | Vietnam | https://www.vfsglobal.ca/canada/vietnam/index.html | By appointment only | Offers other services in local languages | 21.0245 | 105.8412 | 1704413791 |
| 126 | 126 | Harare | VAC Open with limited services | Zimbabwe | https://visa.vfsglobal.com/zwe/en/can | 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. | -17.8292 | 31.0522 | 1716196799 |
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);