administrative_division
2,760 rows sorted by name_sv descending
This data as json, CSV (advanced)
end ✖
- 2022-08-01 444
- 2021-08-01 244
| id | origin_id | ocd_id | service_point_id | start | end | modified_at | type | parent | municipality | name_fi | name_sv ▲ | name |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 433 | 361 | ocd-division/country:fi/kunta:helsinki/osa-alue:viikinranta | 2020-12-07T13:38:26.373605+02:00 | sub_district | 342 | helsinki | Viikinranta | Viksstranden | ||||
| 1350 | 361 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:viikinranta | 2020-12-07T13:38:35.814461+02:00 | rescue_sub_district | 32 | helsinki | Viikinranta | Viksstranden | ||||
| 436 | 364 | ocd-division/country:fi/kunta:helsinki/osa-alue:viikinmäki | 2020-12-07T13:38:26.419075+02:00 | sub_district | 342 | helsinki | Viikinmäki | Viksbacka | ||||
| 1353 | 364 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:viikinmäki | 2020-12-07T13:38:35.832367+02:00 | rescue_sub_district | 32 | helsinki | Viikinmäki | Viksbacka | ||||
| 435 | 363 | ocd-division/country:fi/kunta:helsinki/osa-alue:viikin_tiedepuisto | 2020-12-07T13:38:26.404735+02:00 | sub_district | 342 | helsinki | Viikin tiedepuisto | Viks forskarpark | ||||
| 1352 | 363 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:viikin_tiedepuisto | 2020-12-07T13:38:35.827852+02:00 | rescue_sub_district | 32 | helsinki | Viikin tiedepuisto | Viks forskarpark | ||||
| 5347 | 91-036 | ocd-division/country:fi/kunta:helsinki/kaupunginosa:036 | 2020-10-02T09:50:46.587791+03:00 | neighborhood | 32 | helsinki | Viikki | Vik | ||||
| 292 | 931 | ocd-division/country:fi/kunta:viitasaari | 2020-06-15T15:05:56.663905+03:00 | muni | Viitasaari | Viitasaari | ||||||
| 290 | 925 | ocd-division/country:fi/kunta:vieremä | 2020-06-15T15:05:56.651419+03:00 | muni | Vieremä | Vieremä | ||||||
| 291 | 927 | ocd-division/country:fi/kunta:vihti | 2020-06-15T15:05:56.657736+03:00 | muni | Vihti | Vichtis | ||||||
| 289 | 924 | ocd-division/country:fi/kunta:veteli | 2020-06-15T15:05:56.645039+03:00 | muni | Veteli | Vetil | ||||||
| 288 | 922 | ocd-division/country:fi/kunta:vesilahti | 2020-06-15T15:05:56.638782+03:00 | muni | Vesilahti | Vesilahti | ||||||
| 287 | 921 | ocd-division/country:fi/kunta:vesanto | 2020-06-15T15:05:56.634027+03:00 | muni | Vesanto | Vesanto | ||||||
| 286 | 918 | ocd-division/country:fi/kunta:vehmaa | 2020-06-15T15:05:56.628844+03:00 | muni | Vehmaa | Vehmaa | ||||||
| 282 | 905 | ocd-division/country:fi/kunta:vaasa | 2020-06-15T15:05:56.609665+03:00 | muni | Vaasa | Vasa | ||||||
| 285 | 915 | ocd-division/country:fi/kunta:varkaus | 2020-06-15T15:05:56.623629+03:00 | muni | Varkaus | Varkaus | ||||||
| 5376 | 92-014 | ocd-division/country:fi/kunta:vantaa/kaupunginosa:014 | 2020-10-02T09:50:46.809348+03:00 | neighborhood | 33 | vantaa | Varisto | Varistorna | ||||
| 5380 | 92-018 | ocd-division/country:fi/kunta:vantaa/kaupunginosa:018 | 2020-10-02T09:50:46.837702+03:00 | neighborhood | 33 | vantaa | Vantaanlaakso | Vandadalen | ||||
| 33 | 92 | ocd-division/country:fi/kunta:vantaa | 2020-06-15T15:05:54.825574+03:00 | muni | Vantaa | Vanda | ||||||
| 284 | 911 | ocd-division/country:fi/kunta:valtimo | 2020-06-15T15:05:56.618891+03:00 | muni | Valtimo | Valtimo | ||||||
| 334 | 303 | ocd-division/country:fi/kunta:helsinki/peruspiiri:vallila | 2020-12-07T13:38:23.569082+02:00 | district | 316 | helsinki | Vallila | Vallgård | ||||
| 392 | 220 | ocd-division/country:fi/kunta:helsinki/osa-alue:vallila | 2020-12-07T13:38:25.716364+02:00 | sub_district | 334 | helsinki | Vallila | Vallgård | ||||
| 1264 | 303 | ocd-division/country:fi/kunta:helsinki/suojelulohko:vallila | 2020-12-07T13:38:34.805743+02:00 | rescue_district | 32 | helsinki | Vallila | Vallgård | ||||
| 1314 | 220 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:vallila | 2020-12-07T13:38:35.626181+02:00 | rescue_sub_district | 32 | helsinki | Vallila | Vallgård | ||||
| 5333 | 91-022 | ocd-division/country:fi/kunta:helsinki/kaupunginosa:022 | 2020-10-02T09:50:46.479622+03:00 | neighborhood | 32 | helsinki | Vallila | Vallgård | ||||
| 283 | 908 | ocd-division/country:fi/kunta:valkeakoski | 2020-06-15T15:05:56.614193+03:00 | muni | Valkeakoski | Valkeakoski | ||||||
| 257 | 785 | ocd-division/country:fi/kunta:vaala | 2020-06-15T15:05:56.477483+03:00 | muni | Vaala | Vaala | ||||||
| 279 | 892 | ocd-division/country:fi/kunta:uurainen | 2020-06-15T15:05:56.594508+03:00 | muni | Uurainen | Uurainen | ||||||
| 5364 | 91-053 | ocd-division/country:fi/kunta:helsinki/kaupunginosa:053 | 2020-10-02T09:50:46.721461+03:00 | neighborhood | 32 | helsinki | Ulkosaaret | Utöarna | ||||
| 278 | 890 | ocd-division/country:fi/kunta:utsjoki | 2020-06-15T15:05:56.589320+03:00 | muni | Utsjoki | Utsjoki | ||||||
| 277 | 889 | ocd-division/country:fi/kunta:utajärvi | 2020-06-15T15:05:56.583762+03:00 | muni | Utajärvi | Utajärvi | ||||||
| 276 | 887 | ocd-division/country:fi/kunta:urjala | 2020-06-15T15:05:56.577450+03:00 | muni | Urjala | Urjala | ||||||
| 478 | 491 | ocd-division/country:fi/kunta:helsinki/osa-alue:yliskylä | 2020-12-07T13:38:27.235751+02:00 | sub_district | 350 | helsinki | Yliskylä | Uppby | ||||
| 1393 | 491 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:yliskylä | 2020-12-07T13:38:36.013135+02:00 | rescue_sub_district | 32 | helsinki | Yliskylä | Uppby | ||||
| 275 | 886 | ocd-division/country:fi/kunta:ulvila | 2020-06-15T15:05:56.571996+03:00 | muni | Ulvila | Ulvsby | ||||||
| 5370 | 91-059 | ocd-division/country:fi/kunta:helsinki/kaupunginosa:059 | 2020-10-02T09:50:46.766080+03:00 | neighborhood | 32 | helsinki | Ultuna | Ultuna | ||||
| 323 | 102 | ocd-division/country:fi/kunta:helsinki/peruspiiri:ullanlinna | 2020-12-07T13:38:23.384149+02:00 | district | 314 | helsinki | Ullanlinna | Ulrikasborg | ||||
| 362 | 070 | ocd-division/country:fi/kunta:helsinki/osa-alue:ullanlinna | 2020-12-07T13:38:25.234465+02:00 | sub_district | 323 | helsinki | Ullanlinna | Ulrikasborg | ||||
| 1253 | 102 | ocd-division/country:fi/kunta:helsinki/suojelulohko:ullanlinna | 2020-12-07T13:38:34.753557+02:00 | rescue_district | 32 | helsinki | Ullanlinna | Ulrikasborg | ||||
| 1293 | 070 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:ullanlinna | 2020-12-07T13:38:35.523732+02:00 | rescue_sub_district | 32 | helsinki | Ullanlinna | Ulrikasborg | ||||
| 5318 | 91-007 | ocd-division/country:fi/kunta:helsinki/kaupunginosa:007 | 2020-10-02T09:50:46.367257+03:00 | neighborhood | 32 | helsinki | Ullanlinna | Ulrikasborg | ||||
| 180 | 564 | ocd-division/country:fi/kunta:oulu | 2020-06-15T15:05:55.928282+03:00 | muni | Oulu | Uleåborg | ||||||
| 260 | 833 | ocd-division/country:fi/kunta:taivassalo | 2020-06-15T15:05:56.493115+03:00 | muni | Taivassalo | Tövsala | ||||||
| 274 | 859 | ocd-division/country:fi/kunta:tyrnävä | 2020-06-15T15:05:56.566935+03:00 | muni | Tyrnävä | Tyrnävä | ||||||
| 272 | 857 | ocd-division/country:fi/kunta:tuusniemi | 2020-06-15T15:05:56.557087+03:00 | muni | Tuusniemi | Tuusniemi | ||||||
| 273 | 858 | ocd-division/country:fi/kunta:tuusula | 2020-06-15T15:05:56.562152+03:00 | muni | Tuusula | Tusby | ||||||
| 480 | 493 | ocd-division/country:fi/kunta:helsinki/osa-alue:tullisaari | 2020-12-07T13:38:27.276621+02:00 | sub_district | 350 | helsinki | Tullisaari | Turholm | ||||
| 1395 | 493 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:tullisaari | 2020-12-07T13:38:36.022680+02:00 | rescue_sub_district | 32 | helsinki | Tullisaari | Turholm | ||||
| 67 | 186 | ocd-division/country:fi/kunta:järvenpää | 2020-06-15T15:05:55.032407+03:00 | muni | Järvenpää | Träskända | ||||||
| 5289 | 49-063 | ocd-division/country:fi/kunta:espoo/kaupunginosa:063 | 2020-10-02T09:50:46.108059+03:00 | neighborhood | 11 | espoo | Järvenperä | Träskända | ||||
| 476 | 475 | ocd-division/country:fi/kunta:helsinki/osa-alue:kurkimäki | 2020-12-07T13:38:27.198071+02:00 | sub_district | 353 | helsinki | Kurkimäki | Tranbacka | ||||
| 1391 | 475 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:kurkimäki | 2020-12-07T13:38:36.005976+02:00 | rescue_sub_district | 32 | helsinki | Kurkimäki | Tranbacka | ||||
| 430 | 352 | ocd-division/country:fi/kunta:helsinki/osa-alue:torpparinmäki | 2020-12-07T13:38:26.318980+02:00 | sub_district | 339 | helsinki | Torpparinmäki | Torparbacken | ||||
| 1347 | 352 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:torpparinmäki | 2020-12-07T13:38:35.800540+02:00 | rescue_sub_district | 32 | helsinki | Torpparinmäki | Torparbacken | ||||
| 269 | 851 | ocd-division/country:fi/kunta:tornio | 2020-06-15T15:05:56.541165+03:00 | muni | Tornio | Torneå | ||||||
| 371 | 113 | ocd-division/country:fi/kunta:helsinki/osa-alue:torkkelinmäki | 2020-12-07T13:38:25.391475+02:00 | sub_district | 332 | helsinki | Torkkelinmäki | Torkelsbacken | ||||
| 1298 | 113 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:torkkelinmäki | 2020-12-07T13:38:35.546025+02:00 | rescue_sub_district | 32 | helsinki | Torkkelinmäki | Torkelsbacken | ||||
| 3878 | 424 | ocd-division/country:fi/kunta:helsinki/esiopetuksen_oppilaaksiottoalue_sv:424 | 424 | 2020-07-01 | 2021-08-01 | 2020-12-07T13:38:55.664963+02:00 | preschool_education_sv | 32 | helsinki | Toppans förskola | Toppans förskola | |
| 432 | 354 | ocd-division/country:fi/kunta:helsinki/osa-alue:haltiala | 2020-12-07T13:38:26.354144+02:00 | sub_district | 339 | helsinki | Haltiala | Tomtbacka | ||||
| 1349 | 354 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:haltiala | 2020-12-07T13:38:35.809921+02:00 | rescue_sub_district | 32 | helsinki | Haltiala | Tomtbacka | ||||
| 268 | 850 | ocd-division/country:fi/kunta:toivakka | 2020-06-15T15:05:56.536365+03:00 | muni | Toivakka | Toivakka | ||||||
| 267 | 849 | ocd-division/country:fi/kunta:toholampi | 2020-06-15T15:05:56.531338+03:00 | muni | Toholampi | Toholampi | ||||||
| 266 | 848 | ocd-division/country:fi/kunta:tohmajärvi | 2020-06-15T15:05:56.526463+03:00 | muni | Tohmajärvi | Tohmajärvi | ||||||
| 264 | 845 | ocd-division/country:fi/kunta:tervola | 2020-06-15T15:05:56.515186+03:00 | muni | Tervola | Tervola | ||||||
| 263 | 844 | ocd-division/country:fi/kunta:tervo | 2020-06-15T15:05:56.510134+03:00 | muni | Tervo | Tervo | ||||||
| 488 | 533 | ocd-division/country:fi/kunta:helsinki/osa-alue:aluemeri | 2020-12-07T13:38:27.430318+02:00 | sub_district | 350 | helsinki | Aluemeri | Territorialhavet | ||||
| 1403 | 533 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:aluemeri | 2020-12-07T13:38:36.052197+02:00 | rescue_sub_district | 32 | helsinki | Aluemeri | Territorialhavet | ||||
| 5371 | 91-099 | ocd-division/country:fi/kunta:helsinki/kaupunginosa:099 | 2020-10-02T09:50:46.774767+03:00 | neighborhood | 32 | helsinki | Aluemeri | Territorialhavet | ||||
| 41 | 108 | ocd-division/country:fi/kunta:hämeenkyrö | 2020-06-15T15:05:54.872468+03:00 | muni | Hämeenkyrö | Tavastkyro | ||||||
| 42 | 109 | ocd-division/country:fi/kunta:hämeenlinna | 2020-06-15T15:05:54.878192+03:00 | muni | Hämeenlinna | Tavastehus | ||||||
| 5374 | 92-012 | ocd-division/country:fi/kunta:vantaa/kaupunginosa:012 | 2020-10-02T09:50:46.795998+03:00 | neighborhood | 33 | vantaa | Hämeenkylä | Tavastby | ||||
| 5373 | 92-011 | ocd-division/country:fi/kunta:vantaa/kaupunginosa:011 | 2020-10-02T09:50:46.789695+03:00 | neighborhood | 33 | vantaa | Hämevaara | Tavastberga | ||||
| 441 | 384 | ocd-division/country:fi/kunta:helsinki/osa-alue:tattariharju | 2020-12-07T13:38:26.507457+02:00 | sub_district | 344 | helsinki | Tattariharju | Tattaråsen | ||||
| 1358 | 384 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:tattariharju | 2020-12-07T13:38:35.854670+02:00 | rescue_sub_district | 32 | helsinki | Tattariharju | Tattaråsen | ||||
| 451 | 413 | ocd-division/country:fi/kunta:helsinki/osa-alue:tattarisuo | 2020-12-07T13:38:26.704551+02:00 | sub_district | 346 | helsinki | Tattarisuo | Tattarmossen | ||||
| 1368 | 413 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:tattarisuo | 2020-12-07T13:38:35.901885+02:00 | rescue_sub_district | 32 | helsinki | Tattarisuo | Tattarmossen | ||||
| 262 | 837 | ocd-division/country:fi/kunta:tampere | 2020-06-15T15:05:56.505049+03:00 | muni | Tampere | Tammerfors | ||||||
| 459 | 440 | ocd-division/country:fi/kunta:helsinki/osa-alue:tammisalo | 2020-12-07T13:38:26.866491+02:00 | sub_district | 349 | helsinki | Tammisalo | Tammelund | ||||
| 1375 | 440 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:tammisalo | 2020-12-07T13:38:35.931387+02:00 | rescue_sub_district | 32 | helsinki | Tammisalo | Tammelund | ||||
| 5355 | 91-044 | ocd-division/country:fi/kunta:helsinki/kaupunginosa:044 | 2020-10-02T09:50:46.648547+03:00 | neighborhood | 32 | helsinki | Tammisalo | Tammelund | ||||
| 261 | 834 | ocd-division/country:fi/kunta:tammela | 2020-06-15T15:05:56.499640+03:00 | muni | Tammela | Tammela | ||||||
| 415 | 306 | ocd-division/country:fi/kunta:helsinki/osa-alue:talinranta | 2020-12-07T13:38:26.089263+02:00 | sub_district | 328 | helsinki | Talinranta | Talistranden | ||||
| 1337 | 306 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:talinranta | 2020-12-07T13:38:35.752503+02:00 | rescue_sub_district | 32 | helsinki | Talinranta | Talistranden | ||||
| 468 | 462 | ocd-division/country:fi/kunta:helsinki/osa-alue:tali | 2020-12-07T13:38:27.047871+02:00 | sub_district | 330 | helsinki | Tali | Tali | ||||
| 1383 | 462 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:tali | 2020-12-07T13:38:35.970180+02:00 | rescue_sub_district | 32 | helsinki | Tali | Tali | ||||
| 259 | 832 | ocd-division/country:fi/kunta:taivalkoski | 2020-06-15T15:05:56.488277+03:00 | muni | Taivalkoski | Taivalkoski | ||||||
| 258 | 831 | ocd-division/country:fi/kunta:taipalsaari | 2020-06-15T15:05:56.483245+03:00 | muni | Taipalsaari | Taipalsaari | ||||||
| 5321 | 91-010 | ocd-division/country:fi/kunta:helsinki/kaupunginosa:010 | 2020-10-02T09:50:46.391180+03:00 | neighborhood | 32 | helsinki | Sörnäinen | Sörnäs | ||||
| 5271 | 49-033 | ocd-division/country:fi/kunta:espoo/kaupunginosa:033 | 2020-10-02T09:50:45.951351+03:00 | neighborhood | 11 | espoo | Soukka | Sökö | ||||
| 406 | 291 | ocd-division/country:fi/kunta:helsinki/osa-alue:etelä-haaga | 2020-12-07T13:38:25.969815+02:00 | sub_district | 329 | helsinki | Etelä-Haaga | Södra Haga | ||||
| 1328 | 291 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:etelä-haaga | 2020-12-07T13:38:35.705012+02:00 | rescue_sub_district | 32 | helsinki | Etelä-Haaga | Södra Haga | ||||
| 314 | 1 | ocd-division/country:fi/kunta:helsinki/suurpiiri:eteläinen | 2020-12-07T13:38:22.286895+02:00 | major_district | 32 | helsinki | Eteläinen | Södra | ||||
| 1217 | 1 | ocd-division/country:fi/kunta:helsinki/suojelupiiri:eteläinen | 8953 | 2021-01-04T23:02:57.942462+02:00 | rescue_area | 32 | helsinki | Eteläinen | Södra | |||
| 256 | 783 | ocd-division/country:fi/kunta:säkylä | 2020-06-15T15:05:56.471531+03:00 | muni | Säkylä | Säkylä | ||||||
| 255 | 781 | ocd-division/country:fi/kunta:sysmä | 2020-06-15T15:05:56.465725+03:00 | muni | Sysmä | Sysmä | ||||||
| 319 | 6 | ocd-division/country:fi/kunta:helsinki/suurpiiri:kaakkoinen | 2020-12-07T13:38:22.316767+02:00 | major_district | 32 | helsinki | Kaakkoinen | Sydöstra | ||||
| 1222 | 6 | ocd-division/country:fi/kunta:helsinki/suojelupiiri:kaakkoinen | 8958 | 2021-01-04T23:02:57.938949+02:00 | rescue_area | 32 | helsinki | Kaakkoinen | Sydöstra | |||
| 429 | 351 | ocd-division/country:fi/kunta:helsinki/osa-alue:paloheinä | 2020-12-07T13:38:26.305671+02:00 | sub_district | 339 | helsinki | Paloheinä | Svedängen | ||||
| 1346 | 351 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:paloheinä | 2020-12-07T13:38:35.795987+02:00 | rescue_sub_district | 32 | helsinki | Paloheinä | Svedängen | ||||
| 485 | 520 | ocd-division/country:fi/kunta:helsinki/osa-alue:suomenlinna | 2020-12-07T13:38:27.376163+02:00 | sub_district | 323 | helsinki | Suomenlinna | Sveaborg |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [administrative_division] ( [id] INTEGER PRIMARY KEY, [origin_id] TEXT, [ocd_id] TEXT, [service_point_id] TEXT, [start] TEXT, [end] TEXT, [modified_at] TEXT, [type] TEXT, [parent] INTEGER, [municipality] TEXT, [name_fi] TEXT, [name_sv] TEXT, [name] TEXT );