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
123 rows where notes = "The VAC will provide limited services until further notice . Visit the VAC’s website before you go to find out what services are available."
This data as json, CSV (advanced)
| Link | rowid ▼ | city_ascii | label | country | website | biometrics | notes | latitude | longitude | id |
|---|---|---|---|---|---|---|---|---|---|---|
| 105 | 105 | Erbil | VAC Open with limited services | Iraq | https://visa.vfsglobal.com/irq/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.1911 | 44.0094 | 1368578192 |
| 120 | 120 | Guatemala City | VAC Open with limited services | Guatemala | https://www.vfsglobal.ca/canada/Guatemala/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. | 14.6099 | -90.5252 | 1320197916 |
| 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 |
| 138 | 138 | Hyderabad | VAC Open with limited services | India | https://www.vfsglobal.ca/canada/india/ | By appointment only Biometrics appointments are free . Don’t pay anyone for an appointment. | 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.3667 | 78.4667 | 1356871768 |
| 140 | 140 | Islamabad | VAC Open with limited services | Pakistan | https://www.vfsglobal.ca/Canada/Pakistan/ | 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.6989 | 73.0369 | 1586306717 |
| 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 |
| 144 | 144 | Jakarta | 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. | -6.2146 | 106.8451 | 1360771077 |
| 145 | 145 | Jalandhar | VAC Open with limited services | India | https://www.vfsglobal.ca/canada/india/ | By appointment only Biometrics appointments are free . Don’t pay anyone for an appointment. | 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.3256 | 75.5792 | 1356494816 |
| 152 | 152 | Karachi | VAC Open with limited services | Pakistan | https://www.vfsglobal.ca/Canada/Pakistan/ | 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.86 | 67.01 | 1586129469 |
| 153 | 153 | Kathmandu | VAC Open with limited services | Nepal | http://www.vfsglobal.ca/canada/nepal/ | 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. | 27.7167 | 85.3667 | 1524589448 |
| 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 |
| 158 | 158 | Kingston | VAC Open with limited services | Jamaica | https://www.vfsglobal.ca/Canada/Jamaica/ | 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.9714 | -76.7931 | 1388709177 |
| 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. | |||
| 160 | 160 | Kinshasa | VAC Open with limited services | Democratic Rep. of Congo | https://visa.vfsglobal.com/cod/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. | |||
| 161 | 161 | Kolkata | VAC Open with limited services | India | https://www.vfsglobal.ca/canada/india/ | By appointment only Biometrics appointments are free . Don’t pay anyone for an appointment. | The VAC will provide limited services until further notice . Visit the VAC’s website before you go to find out what services are available. | 22.5411 | 88.3378 | 1356060520 |
| 162 | 162 | Kuala Lumpur | VAC Open with limited services | Malaysia | https://www.vfsglobal.ca/canada/malaysia/english/ | 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. | 3.1478 | 101.6953 | 1458988644 |
| 164 | 164 | Kuwait City | VAC Open with limited services | Kuwait | https://visa.vfsglobal.com/kwt/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. | 29.375 | 47.98 | 1414102075 |
| 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 |
| 166 | 166 | La Paz | VAC Open with limited services | Bolivia | http://www.vfsglobal.ca/Canada/Bolivia/English/ | 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. | -16.4942 | -68.1475 | 1068000064 |
| 167 | 167 | Lagos | 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. | 6.45 | 3.4 | 1566593751 |
| 168 | 168 | Lahore | VAC Open with limited services | Pakistan | https://www.vfsglobal.ca/Canada/Pakistan/ | 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.5497 | 74.3436 | 1586801463 |
| 175 | 175 | Lima | VAC Open with limited services | Peru | http://www.vfsglobal.ca/canada/peru/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. | -12.05 | -77.0333 | 1604728603 |
| 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 |
| 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 |
| 185 | 185 | Lyon | VAC Open with limited services | France | https://visa.vfsglobal.com/fra/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. | 45.76 | 4.84 | 1250196189 |
| 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 |
| 187 | 187 | Managua | VAC Open with limited services | Nicaragua | http://www.vfsglobal.ca/canada/Nicaragua/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. | 12.15 | -86.2667 | 1558296252 |
| 188 | 188 | Manama | VAC Open with limited services | Bahrain | https://visa.vfsglobal.com/bhr/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. | 26.2167 | 50.5831 | 1048989486 |
| 189 | 189 | Manila | 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. | 14.5958 | 120.9772 | 1608618140 |
| 192 | 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 |
| 193 | 193 | Mendoza | 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. | -32.8833 | -68.8333 | 1032433516 |
| 200 | 200 | Montego Bay | VAC Open with limited services | Jamaica | https://www.vfsglobal.ca/Canada/Jamaica/ | 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.4667 | -77.9167 | 1388955058 |
| 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 |
| 205 | 205 | Mumbai | VAC Open with limited services | India | https://www.vfsglobal.ca/canada/india/ | By appointment only Biometrics appointments are free . Don’t pay anyone for an appointment. | 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.9667 | 72.8333 | 1356226629 |
| 206 | 206 | Muscat | VAC Open with limited services | Oman | https://visa.vfsglobal.com/omn/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. | 23.6139 | 58.5922 | 1512035506 |
| 207 | 207 | Nairobi | VAC Open with limited services | Kenya | https://visa.vfsglobal.com/ken/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.2864 | 36.8172 | 1404000661 |
| 211 | 211 | New Delhi | VAC Open with limited services | India | https://www.vfsglobal.ca/canada/india/ | By appointment only Biometrics appointments are free . Don’t pay anyone for an appointment. | 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.7 | 77.2 | 1356215164 |
| 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 |
| 216 | 216 | Niamey | VAC Open with limited services | Niger | https://visa.vfsglobal.com/ner/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. | 13.5086 | 2.1111 | 1562932886 |
| 221 | 221 | Nur-Sultan | 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. | 51.1333 | 71.4333 | 1398516045 |
| 222 | 222 | Novosibirsk | 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. | 55.0333 | 82.9167 | 1643399240 |
| 227 | 227 | Osaka | VAC Open with limited services | Japan | http://www.vfsglobal.ca/canada/japan/ | 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.6936 | 135.5019 | 1392419823 |
| 233 | 233 | Panama City | VAC Open with limited services | Panama | http://www.vfsglobal.ca/canada/panama/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. | 9.0 | -79.5 | 1591672475 |
| 234 | 234 | Paris | VAC Open with limited services | France | https://visa.vfsglobal.com/fra/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. | 48.8566 | 2.3522 | 1250015082 |
| 235 | 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 |
| 238 | 238 | Phnom Penh | VAC Open with limited services | Cambodia | http://www.vfsglobal.ca/canada/cambodia/ | 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. | 11.5696 | 104.921 | 1116260534 |
| 245 | 245 | Port Louis | VAC Open with limited services | Mauritius | https://visa.vfsglobal.com/mus/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. | -20.1667 | 57.5 | 1480131261 |
| 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. | |||
| 247 | 247 | Port-au-Prince | VAC Open with limited services | Haiti | https://www.vfsglobal.ca/Canada/Haiti/ | 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.5425 | -72.3386 | 1332401940 |
| 249 | 249 | Porto Alegre | 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. | -30.0328 | -51.23 | 1076658221 |
| 252 | 252 | Pristina | VAC Open with limited services | Kosovo | https://visa.vfsglobal.com/xkx/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.6667 | 21.1667 | 1901760068 |
| 253 | 253 | Pune | VAC Open with limited services | India | https://www.vfsglobal.ca/canada/india/ | By appointment only Biometrics appointments are free . Don’t pay anyone for an appointment. | 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.5196 | 73.8553 | 1356081074 |
| 256 | 256 | Quito | VAC Open with limited services | Ecuador | http://www.vfsglobal.ca/canada/ecuador/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. | -0.2186 | -78.5097 | 1218441993 |
| 261 | 261 | Recife | 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. | -8.0539 | -34.8808 | 1076137337 |
| 267 | 267 | Rio de Janeiro | 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. | -22.9083 | -43.1964 | 1076887657 |
| 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 |
| 271 | 271 | Rome | VAC Open with limited services | Italy | https://visa.vfsglobal.com/ita/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.8931 | 12.4828 | 1380382862 |
| 272 | 272 | Rostov-on-Don | 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. | |||
| 273 | 273 | Saint Petersburg | 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. | 59.95 | 30.3167 | 1643616350 |
| 281 | 281 | San Jose | VAC Open with limited services | Costa Rica | http://www.vfsglobal.ca/canada/costarica/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. | 9.9333 | -84.0833 | 1188749877 |
| 284 | 284 | San Salvador | VAC Open with limited services | El Salvador | http://www.vfsglobal.ca/canada/elsalvador/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. | 13.6989 | -89.1914 | 1222647454 |
| 287 | 287 | Santo Domingo | VAC Open with limited services | Dominican Republic | https://www.vfsglobal.ca/Canada/DominicanRepublic/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. | 18.4764 | -69.8933 | 1214636202 |
| 288 | 288 | Santiago | VAC Open with limited services | Chile | https://www.vfsglobal.ca/Canada/Chile/ | 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.45 | -70.6667 | 1152554349 |
| 289 | 289 | Sao Paulo | 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. | -23.5504 | -46.6339 | 1076532519 |
| 301 | 301 | Skopje | VAC Open with limited services | Macedonia | https://visa.vfsglobal.com/mkd/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.9833 | 21.4333 | 1807600615 |
| 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 |
| 317 | 317 | Suva | VAC Open with limited services | Fiji | http://www.vfsglobal.ca/canada/fiji/ | 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.1333 | 178.4333 | 1242615095 |
| 318 | 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 |
| 319 | 319 | Sylhet | 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. | 24.9 | 91.8667 | 1050646703 |
| 323 | 323 | Tbilisi | VAC Open with limited services | Georgia | https://visa.vfsglobal.com/geo/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.7225 | 44.7925 | 1268203191 |
| 324 | 324 | Tegucigalpa | VAC Open with limited services | Honduras | http://www.vfsglobal.ca/canada/honduras/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. | 14.0942 | -87.2067 | 1340344059 |
| 325 | 325 | Tel Aviv | VAC Open with limited services | Israel | https://visa.vfsglobal.com/isr/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. | |||
| 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. | |||
| 328 | 328 | Tokyo | VAC Open with limited services | Japan | http://www.vfsglobal.ca/canada/japan/ | 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. | 35.6897 | 139.6922 | 1392685764 |
| 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 |
| 334 | 334 | Ulaanbaatar | VAC Open with limited services | Mongolia | http://www.vfsglobal.ca/canada/mongolia/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. | 47.9203 | 106.9172 | 1496024767 |
| 338 | 338 | Vienna | VAC Open with limited services | Austria | https://visa.vfsglobal.com/aut/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. | 48.2083 | 16.3731 | 1040261752 |
| 339 | 339 | Vladivostok | 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. | 43.1167 | 131.9 | 1643832017 |
| 340 | 340 | Warsaw | VAC Open with limited services | Poland | https://visa.vfsglobal.com/pol/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.2167 | 21.0333 | 1616024847 |
| 351 | 351 | Wuhan | VAC Open with limited services | China | https://www.vfsglobal.ca/canada/china/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. | 30.5872 | 114.2881 | 1156117184 |
| 353 | 353 | Yaoundé | VAC Open with limited services | Cameroon | https://visa.vfsglobal.com/cmr/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. | |||
| 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 |
| 356 | 356 | Yerevan | VAC Open with limited services | Armenia | https://visa.vfsglobal.com/arm/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.1814 | 44.5144 | 1051074169 |
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);