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 rowid descending
This data as json, CSV (advanced)
| Link | rowid ▲ | city_ascii | label | country | website | biometrics | notes | latitude | longitude | id |
|---|---|---|---|---|---|---|---|---|---|---|
| 90 | 90 | Doha | VAC Open with limited services | Qatar | https://visa.vfsglobal.com/qat/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.3 | 51.5333 | 1634459660 |
| 89 | 89 | Dhaka | VAC Open with limited services | Bangladesh | http://www.vfsglobal.ca/Canada/bangladesh/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. | 23.7161 | 90.3961 | 1050529279 |
| 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 |
| 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 |
| 79 | 79 | Conakry | VAC Open with limited services | Guinea | https://visa.vfsglobal.com/gin/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. | 9.5092 | -13.7122 | 1324568159 |
| 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 |
| 71 | 71 | Chisinau | VAC | Moldova | https://visa.vfsglobal.com/mda/en/can | By appointment only | Starting November 2, 2019: New set of services Offers other services in local languages | 47.0056 | 28.8575 | 1498011437 |
| 64 | 64 | Cebu | VAC Open with limited services | Philippines | https://www.vfsglobal.ca/canada/Philippines/ | 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. | |||
| 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 |
| 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 |
| 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 |
| 59 | 59 | Cali | VAC Open with limited services | Colombia | https://www.vfsglobal.ca/Canada/Colombia/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 | 3.44 | -76.5197 | 1170417589 |
| 57 | 57 | Cairo | VAC | Egypt | https://visa.vfsglobal.com/egy/en/can | By appointment only | Starting November 2, 2019: New set of services Offers other services in local languages | 30.0561 | 31.2394 | 1818253931 |
| 54 | 54 | Buenos Aires | VAC Open with limited services | Argentina | http://www.vfsglobal.ca/canada/argentina/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.5997 | -58.3819 | 1032717330 |
| 52 | 52 | Bucharest | VAC Open with limited services | Romania | https://visa.vfsglobal.com/rou/en/can | By appointment only | The VAC will provide only limited services until further notice . Visit the VAC’s website before you go to find out what services are available. | 44.4 | 26.0833 | 1642414442 |
| 49 | 49 | Bridgetown | VAC Open with limited services | Barbados | https://www.vfsglobal.ca/Canada/Barbados/ | 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.0975 | -59.6167 | 1052274244 |
| 48 | 48 | Brasilia | VAC Open with limited services | Brazil | http://www.vfsglobal.ca/canada/brazil/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. | -15.7744 | -48.0773 | 1076144436 |
| 45 | 45 | Bogota | VAC Open with limited services | Colombia | https://www.vfsglobal.ca/Canada/Colombia/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. | 4.6126 | -74.0705 | 1170483426 |
| 43 | 43 | Bishkek | VAC Open with limited services | Kyrgyzstan | https://visa.vfsglobal.com/kgz/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. | 42.8667 | 74.5667 | 1417191971 |
| 40 | 40 | Berlin | VAC Open with limited services | Germany | https://visa.vfsglobal.com/deu/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. | 52.5167 | 13.3833 | 1276451290 |
| 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 |
| 37 | 37 | Beirut | VAC Open with limited services | Lebanon | https://visa.vfsglobal.com/lbn/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.8869 | 35.5131 | 1422847713 |
| 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 |
| 30 | 30 | Bamako | VAC Open with limited services | Mali | https://visa.vfsglobal.com/mli/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. | 12.6458 | -7.9922 | 1466965925 |
| 29 | 29 | Bali | VAC Open with limited services | Indonesia | http://www.vfsglobal.ca/canada/indonesia/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. | |||
| 28 | 28 | Baku | VAC | Azerbaijan | https://visa.vfsglobal.com/aze/en/can | By appointment only | Offers other services in local languages | 40.3667 | 49.8352 | 1031946365 |
| 24 | 24 | Auckland | VAC Open with limited services | New Zealand | http://www.vfsglobal.ca/canada/newzealand/ | 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.85 | 174.7833 | 1554435911 |
| 22 | 22 | Athens | VAC Open with limited services | Greece | https://visa.vfsglobal.com/grc/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. | 37.9794 | 23.7161 | 1300715560 |
| 21 | 21 | Asuncion | VAC Open with limited services | Paraguay | https://www.vfsglobal.ca/canada/paraguay/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. | -25.3 | -57.6333 | 1600057911 |
| 19 | 19 | Antananarivo | VAC Open with limited services | Madagascar | https://visa.vfsglobal.com/mdg/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. | -18.9386 | 47.5214 | 1450978461 |
| 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 |
| 14 | 14 | Almaty | VAC Open with limited services | Kazakhstan | https://visa.vfsglobal.com/kaz/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. | 43.25 | 76.9 | 1398351701 |
| 13 | 13 | Algiers | VAC Open with limited services | Algeria | https://visa.vfsglobal.com/dza/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.7764 | 3.0586 | 1012973369 |
| 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. | |||
| 7 | 7 | Addis Ababa | VAC | Ethiopia | https://visa.vfsglobal.com/eth/en/can | By appointment only | Starting November 2, 2019: New set of services Offers other services in local languages | 9.0272 | 38.7369 | 1231824991 |
| 6 | 6 | Accra | VAC Open with limited services | Ghana | https://visa.vfsglobal.com/gha/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. | 5.6037 | -0.187 | 1288299415 |
| 5 | 5 | Abuja | VAC Open with limited services | Nigeria | https://visa.vfsglobal.com/nga/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. | 9.0556 | 7.4914 | 1566342270 |
| 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 |
| 3 | 3 | Abidjan | VAC Open with limited services | Ivory Coast | https://visa.vfsglobal.com/civ/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. |
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);