administrative_division
2,760 rows sorted by name_fi descending
This data as json, CSV (advanced)
Suggested facets: start, end, type, municipality, start (date), modified_at (date)
end (date) ✖
- 2022-08-01 453
- 2021-08-01 256
| id | origin_id | ocd_id | service_point_id | start | end | modified_at | type | parent | municipality | name_fi ▲ | name_sv | name |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5681 | 41 | ocd-division/country:fi/kunta:helsinki/luonnonsuojelualue:41 | 2020-12-07T13:39:00.209778+02:00 | nature_reserve | 32 | helsinki | Östersundomin lintuvedet | |||||
| 321 | 8 | ocd-division/country:fi/kunta:helsinki/suurpiiri:östersundom | 2020-12-07T13:38:22.324794+02:00 | major_district | 32 | helsinki | Östersundom | Östersundom | ||||
| 355 | 801 | ocd-division/country:fi/kunta:helsinki/peruspiiri:östersundom | 2020-12-07T13:38:23.866605+02:00 | district | 321 | helsinki | Östersundom | Östersundom | ||||
| 498 | 550 | ocd-division/country:fi/kunta:helsinki/osa-alue:östersundom | 2020-12-07T13:38:27.650189+02:00 | sub_district | 355 | helsinki | Östersundom | Östersundom | ||||
| 1132 | 055A | ocd-division/country:fi/kunta:helsinki/äänestysalue:055a | 52535 | 2020-12-07T13:38:32.343959+02:00 | voting_district | 32 | helsinki | Östersundom | ||||
| 1224 | 8 | ocd-division/country:fi/kunta:helsinki/suojelupiiri:östersundom | 8957 | 2021-01-04T23:02:57.937901+02:00 | rescue_area | 32 | helsinki | Östersundom | Östersundom | |||
| 1285 | 801 | ocd-division/country:fi/kunta:helsinki/suojelulohko:östersundom | 2020-12-07T13:38:34.909488+02:00 | rescue_district | 32 | helsinki | Östersundom | Östersundom | ||||
| 1413 | 550 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:östersundom | 2020-12-07T13:38:36.103013+02:00 | rescue_sub_district | 32 | helsinki | Östersundom | Östersundom | ||||
| 1896 | 0918801550 | ocd-division/country:fi/tilastoalue:0918801550 | 2020-12-07T13:38:51.993629+02:00 | statistical_district | Östersundom | |||||||
| 3884 | ocd-division/country:fi/kunta:helsinki/esiopetuksen_oppilaaksiottoalue_sv: | 2020-07-01 | 2021-08-01 | 2020-11-18T05:51:36.406681+02:00 | preschool_education_sv | 32 | helsinki | Östersundom | Östersundom | |||
| 5366 | 91-055 | ocd-division/country:fi/kunta:helsinki/kaupunginosa:055 | 2020-10-02T09:50:46.734835+03:00 | neighborhood | 32 | helsinki | Östersundom | Östersundom | ||||
| 3881 | 442 | ocd-division/country:fi/kunta:helsinki/esiopetuksen_oppilaaksiottoalue_sv:442 | 442 | 2020-07-01 | 2021-08-01 | 2020-12-07T13:38:55.676522+02:00 | preschool_education_sv | 32 | helsinki | Åshöjdens förskola | Åshöjdens förskola | |
| 302 | 992 | ocd-division/country:fi/kunta:äänekoski | 2020-06-15T15:05:56.728593+03:00 | muni | Äänekoski | Äänekoski | ||||||
| 1759 | 0496064645 | ocd-division/country:fi/tilastoalue:0496064645 | 2020-12-07T13:38:51.396100+02:00 | statistical_district | Ämmässuo | |||||||
| 5311 | 49-091 | ocd-division/country:fi/kunta:espoo/kaupunginosa:091 | 2020-10-02T09:50:46.308632+03:00 | neighborhood | 11 | espoo | Ämmässuo | Käringmossen | ||||
| 301 | 989 | ocd-division/country:fi/kunta:ähtäri | 2020-06-15T15:05:56.723420+03:00 | muni | Ähtäri | Etseri | ||||||
| 300 | 981 | ocd-division/country:fi/kunta:ypäjä | 2020-06-15T15:05:56.718087+03:00 | muni | Ypäjä | Ypäjä | ||||||
| 1801 | 0496061616 | ocd-division/country:fi/tilastoalue:0496061616 | 2020-12-07T13:38:51.562271+02:00 | statistical_district | Ymmersta | |||||||
| 299 | 980 | ocd-division/country:fi/kunta:ylöjärvi | 2020-06-15T15:05:56.711916+03:00 | muni | Ylöjärvi | Ylöjärvi | ||||||
| 2019 | 0923040000 | ocd-division/country:fi/tilastoalue:0923040000 | 2020-12-07T13:38:52.523146+02:00 | statistical_district | Ylästö | |||||||
| 5393 | 92-040 | ocd-division/country:fi/kunta:vantaa/kaupunginosa:040 | 2020-10-02T09:50:46.938488+03:00 | neighborhood | 33 | vantaa | Ylästö | Övitsböle | ||||
| 1073 | 038G | ocd-division/country:fi/kunta:helsinki/äänestysalue:038g | 52562 | 2020-12-07T13:38:32.092191+02:00 | voting_district | 32 | helsinki | Ylä-Malmi B | ||||
| 1072 | 038F | ocd-division/country:fi/kunta:helsinki/äänestysalue:038f | 52803 | 2020-12-07T13:38:32.089020+02:00 | voting_district | 32 | helsinki | Ylä-Malmi A | ||||
| 438 | 381 | ocd-division/country:fi/kunta:helsinki/osa-alue:ylä-malmi | 2020-12-07T13:38:26.451255+02:00 | sub_district | 344 | helsinki | Ylä-Malmi | Övre Malm | ||||
| 1355 | 381 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:ylä-malmi | 2020-12-07T13:38:35.841991+02:00 | rescue_sub_district | 32 | helsinki | Ylä-Malmi | Övre Malm | ||||
| 1905 | 0915503381 | ocd-division/country:fi/tilastoalue:0915503381 | 2020-12-07T13:38:52.743310+02:00 | statistical_district | Ylä-Malmi | |||||||
| 298 | 977 | ocd-division/country:fi/kunta:ylivieska | 2020-06-15T15:05:56.705349+03:00 | muni | Ylivieska | Ylivieska | ||||||
| 297 | 976 | ocd-division/country:fi/kunta:ylitornio | 2020-06-15T15:05:56.697215+03:00 | muni | Ylitornio | Övertorneå | ||||||
| 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 | ||||
| 1852 | 0916603491 | ocd-division/country:fi/tilastoalue:0916603491 | 2020-12-07T13:38:51.788982+02:00 | statistical_district | Yliskylä | |||||||
| 4479 | 115240 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115240 | 6913 | 2021-08-01 | 2022-08-01 | 2020-12-07T13:38:37.770936+02:00 | lower_comprehensive_school_district_fi | 32 | helsinki | Yhtenäiskoulu 2021-2022 | ||
| 4635 | 115236 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:115236 | 6913 | 2021-08-01 | 2022-08-01 | 2020-12-07T13:38:42.762117+02:00 | upper_comprehensive_school_district_fi | 32 | helsinki | Yhtenäiskoulu 2021-2022 | ||
| 4564 | 114823 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:114823 | 6913 | 2020-08-01 | 2021-08-01 | 2020-12-07T13:38:39.254387+02:00 | lower_comprehensive_school_district_fi | 32 | helsinki | Yhtenäiskoulu 2020-2021 | ||
| 4693 | 114822 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:114822 | 6913 | 2020-08-01 | 2021-08-01 | 2020-12-07T13:38:47.517658+02:00 | upper_comprehensive_school_district_fi | 32 | helsinki | Yhtenäiskoulu 2020-2021 | ||
| 1831 | 0492023231 | ocd-division/country:fi/tilastoalue:0492023231 | 2020-12-07T13:38:51.684431+02:00 | statistical_district | Westend | |||||||
| 5258 | 49-013 | ocd-division/country:fi/kunta:espoo/kaupunginosa:013 | 2020-10-02T09:50:45.840055+03:00 | neighborhood | 11 | espoo | Westend | Westend | ||||
| 313 | 946 | ocd-division/country:fi/kunta:vöyri | 2020-06-15T15:05:56.799283+03:00 | muni | Vöyri | Vörå | ||||||
| 296 | 941 | ocd-division/country:fi/kunta:vårdö | 2020-06-15T15:05:56.690551+03:00 | muni | Vårdö | Vårdö | ||||||
| 5665 | 27 | ocd-division/country:fi/kunta:helsinki/luonnonsuojelualue:27 | 2020-12-07T13:39:00.149498+02:00 | nature_reserve | 32 | helsinki | Välikarit | |||||
| 3946 | 054J | ocd-division/country:fi/kunta:helsinki/äänestysalue:054j | 2020-12-07T13:38:32.340485+02:00 | voting_district | 32 | helsinki | Vuosaari J | |||||
| 1131 | 054H | ocd-division/country:fi/kunta:helsinki/äänestysalue:054h | 52618 | 2020-12-07T13:38:32.336860+02:00 | voting_district | 32 | helsinki | Vuosaari H | ||||
| 1130 | 054G | ocd-division/country:fi/kunta:helsinki/äänestysalue:054g | 52735 | 2020-12-07T13:38:32.333792+02:00 | voting_district | 32 | helsinki | Vuosaari G | ||||
| 1129 | 054F | ocd-division/country:fi/kunta:helsinki/äänestysalue:054f | 52590 | 2020-12-07T13:38:32.329607+02:00 | voting_district | 32 | helsinki | Vuosaari F | ||||
| 1128 | 054E | ocd-division/country:fi/kunta:helsinki/äänestysalue:054e | 52744 | 2020-12-07T13:38:32.325916+02:00 | voting_district | 32 | helsinki | Vuosaari E | ||||
| 1127 | 054D | ocd-division/country:fi/kunta:helsinki/äänestysalue:054d | 52713 | 2020-12-07T13:38:32.320956+02:00 | voting_district | 32 | helsinki | Vuosaari D | ||||
| 1126 | 054C | ocd-division/country:fi/kunta:helsinki/äänestysalue:054c | 2020-12-07T13:38:32.314365+02:00 | voting_district | 32 | helsinki | Vuosaari C | |||||
| 1125 | 054B | ocd-division/country:fi/kunta:helsinki/äänestysalue:054b | 2020-12-07T13:38:32.308829+02:00 | voting_district | 32 | helsinki | Vuosaari B | |||||
| 1124 | 054A | ocd-division/country:fi/kunta:helsinki/äänestysalue:054a | 52805 | 2020-12-07T13:38:32.303836+02:00 | voting_district | 32 | helsinki | Vuosaari A | ||||
| 354 | 704 | ocd-division/country:fi/kunta:helsinki/peruspiiri:vuosaari | 2020-12-07T13:38:23.852867+02:00 | district | 320 | helsinki | Vuosaari | Nordsjö | ||||
| 1249 | VUOSAARI | ocd-division/country:fi/kunta:helsinki/terveysasema-alue:vuosaari | 4313 | 2020-12-07T13:38:33.122627+02:00 | health_station_district | 32 | helsinki | Vuosaari | ||||
| 1284 | 704 | ocd-division/country:fi/kunta:helsinki/suojelulohko:vuosaari | 2020-12-07T13:38:34.904422+02:00 | rescue_district | 32 | helsinki | Vuosaari | Nordsjö | ||||
| 3579 | VUOSAARI | ocd-division/country:fi/kunta:helsinki/neuvola-alue:vuosaari | 11623 | 2020-12-07T13:38:50.339671+02:00 | maternity_clinic_district | 32 | helsinki | Vuosaari | ||||
| 5365 | 91-054 | ocd-division/country:fi/kunta:helsinki/kaupunginosa:054 | 2020-10-02T09:50:46.727914+03:00 | neighborhood | 32 | helsinki | Vuosaari | Nordsjö | ||||
| 5675 | 36 | ocd-division/country:fi/kunta:helsinki/luonnonsuojelualue:36 | 2020-12-07T13:39:00.187643+02:00 | nature_reserve | 32 | helsinki | Vuorilahdenpaadet | |||||
| 4413 | 115130 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115130 | 51483 | 2021-08-01 | 2022-08-01 | 2020-12-07T13:38:37.451363+02:00 | lower_comprehensive_school_district_fi | 32 | helsinki | Vuoniityn peruskoulu 2021-2022 | ||
| 4618 | 115157 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:115157 | 51483 | 2021-08-01 | 2022-08-01 | 2020-12-07T13:38:42.700774+02:00 | upper_comprehensive_school_district_fi | 32 | helsinki | Vuoniityn peruskoulu 2021-2022 | ||
| 4508 | 114719 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:114719 | 51483 | 2020-08-01 | 2021-08-01 | 2020-12-07T13:38:39.007773+02:00 | lower_comprehensive_school_district_fi | 32 | helsinki | Vuoniityn peruskoulu 2020-2021 | ||
| 4660 | 114704 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:114704 | 51483 | 2020-08-01 | 2021-08-01 | 2020-12-07T13:38:47.368126+02:00 | upper_comprehensive_school_district_fi | 32 | helsinki | Vuoniityn peruskoulu 2020-2021 | ||
| 295 | 936 | ocd-division/country:fi/kunta:virrat | 2020-06-15T15:05:56.684284+03:00 | muni | Virrat | Virdois | ||||||
| 322 | 101 | ocd-division/country:fi/kunta:helsinki/peruspiiri:vironniemi | 2020-12-07T13:38:23.375944+02:00 | district | 314 | helsinki | Vironniemi | Estnäs | ||||
| 1252 | 101 | ocd-division/country:fi/kunta:helsinki/suojelulohko:vironniemi | 2020-12-07T13:38:34.747694+02:00 | rescue_district | 32 | helsinki | Vironniemi | Estnäs | ||||
| 294 | 935 | ocd-division/country:fi/kunta:virolahti | 2020-06-15T15:05:56.678367+03:00 | muni | Virolahti | Virolahti | ||||||
| 293 | 934 | ocd-division/country:fi/kunta:vimpeli | 2020-06-15T15:05:56.672015+03:00 | muni | Vimpeli | Vimpeli | ||||||
| 483 | 500 | ocd-division/country:fi/kunta:helsinki/osa-alue:villinki | 2020-12-07T13:38:27.337970+02:00 | sub_district | 350 | helsinki | Villinki | Villinge | ||||
| 1398 | 500 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:villinki | 2020-12-07T13:38:36.033700+02:00 | rescue_sub_district | 32 | helsinki | Villinki | Villinge | ||||
| 1881 | 0916603500 | ocd-division/country:fi/tilastoalue:0916603500 | 2020-12-07T13:38:51.925926+02:00 | statistical_district | Villinki | |||||||
| 5361 | 91-050 | ocd-division/country:fi/kunta:helsinki/kaupunginosa:050 | 2020-10-02T09:50:46.698895+03:00 | neighborhood | 32 | helsinki | Villinki | Villinge | ||||
| 365 | 101 | ocd-division/country:fi/kunta:helsinki/osa-alue:vilhonvuori | 2020-12-07T13:38:25.278657+02:00 | sub_district | 332 | helsinki | Vilhonvuori | Vilhemsberg | ||||
| 1423 | 101 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:vilhonvuori | 2020-12-07T13:38:36.155441+02:00 | rescue_sub_district | 32 | helsinki | Vilhonvuori | Vilhemsberg | ||||
| 1870 | 0913301101 | ocd-division/country:fi/tilastoalue:0913301101 | 2020-12-07T13:38:51.878097+02:00 | statistical_district | Vilhonvuori | |||||||
| 5684 | 44 | ocd-division/country:fi/kunta:helsinki/luonnonsuojelualue:44 | 2020-12-07T13:39:00.221462+02:00 | nature_reserve | 32 | helsinki | Vikkulla-Kasaberget | |||||
| 292 | 931 | ocd-division/country:fi/kunta:viitasaari | 2020-06-15T15:05:56.663905+03:00 | muni | Viitasaari | Viitasaari | ||||||
| 1230 | VIISKULMA | ocd-division/country:fi/kunta:helsinki/terveysasema-alue:viiskulma | 6365 | 2020-12-07T13:38:33.055839+02:00 | health_station_district | 32 | helsinki | Viiskulma | ||||
| 3587 | VIISKULMA | ocd-division/country:fi/kunta:helsinki/neuvola-alue:viiskulma | 11700 | 2020-12-07T13:38:50.362844+02:00 | maternity_clinic_district | 32 | helsinki | Viiskulma | ||||
| 2044 | 0923041000 | ocd-division/country:fi/tilastoalue:0923041000 | 2020-12-07T13:38:52.662074+02:00 | statistical_district | Viinikkala | |||||||
| 5394 | 92-041 | ocd-division/country:fi/kunta:vantaa/kaupunginosa:041 | 2020-10-02T09:50:46.947773+03:00 | neighborhood | 33 | vantaa | Viinikkala | Vinikby | ||||
| 5657 | 2 | ocd-division/country:fi/kunta:helsinki/luonnonsuojelualue:2 | 2020-12-07T13:39:00.115961+02:00 | nature_reserve | 32 | helsinki | Viikki-Vanhankaupunginlahti | |||||
| 2775 | 036D | ocd-division/country:fi/kunta:helsinki/äänestysalue:036d | 59231 | 2020-12-07T13:38:32.057781+02:00 | voting_district | 32 | helsinki | Viikki D | ||||
| 1064 | 036C | ocd-division/country:fi/kunta:helsinki/äänestysalue:036c | 52597 | 2020-12-07T13:38:32.052732+02:00 | voting_district | 32 | helsinki | Viikki C | ||||
| 1063 | 036B | ocd-division/country:fi/kunta:helsinki/äänestysalue:036b | 52520 | 2020-12-07T13:38:32.047136+02:00 | voting_district | 32 | helsinki | Viikki B | ||||
| 1062 | 036A | ocd-division/country:fi/kunta:helsinki/äänestysalue:036a | 52718 | 2020-12-07T13:38:32.042234+02:00 | voting_district | 32 | helsinki | Viikki A | ||||
| 5347 | 91-036 | ocd-division/country:fi/kunta:helsinki/kaupunginosa:036 | 2020-10-02T09:50:46.587791+03:00 | neighborhood | 32 | helsinki | Viikki | Vik | ||||
| 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 | ||||
| 1920 | 0915501361 | ocd-division/country:fi/tilastoalue:0915501361 | 2020-12-07T13:38:52.090988+02:00 | statistical_district | Viikinranta | |||||||
| 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 | ||||
| 1903 | 0915501364 | ocd-division/country:fi/tilastoalue:0915501364 | 2020-12-07T13:38:52.033527+02:00 | statistical_district | Viikinmäki | |||||||
| 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 | ||||
| 1902 | 0915501363 | ocd-division/country:fi/tilastoalue:0915501363 | 2020-12-07T13:38:52.028367+02:00 | statistical_district | Viikin tiedepuisto | |||||||
| 291 | 927 | ocd-division/country:fi/kunta:vihti | 2020-06-15T15:05:56.657736+03:00 | muni | Vihti | Vichtis | ||||||
| 3942 | 15740 | ocd-division/country:fi/kunta:espoo/terveysasema-alue:15740 | 15740 | 2020-09-16T22:31:01.919554+03:00 | health_station_district | 11 | espoo | Viherlaakson terveysasema | Gröndals hälsostation | |||
| 1805 | 0491015151 | ocd-division/country:fi/tilastoalue:0491015151 | 2020-12-07T13:38:51.578041+02:00 | statistical_district | Viherlaakso | |||||||
| 5287 | 49-061 | ocd-division/country:fi/kunta:espoo/kaupunginosa:061 | 2020-10-02T09:50:46.090743+03:00 | neighborhood | 11 | espoo | Viherlaakso | Gröndal | ||||
| 2027 | 0926087000 | ocd-division/country:fi/tilastoalue:0926087000 | 2020-12-07T13:38:52.582468+02:00 | statistical_district | Vierumäki | |||||||
| 5422 | 92-087 | ocd-division/country:fi/kunta:vantaa/kaupunginosa:087 | 2020-10-02T09:50:47.167081+03:00 | neighborhood | 33 | vantaa | Vierumäki | |||||
| 2009 | 0924063000 | ocd-division/country:fi/tilastoalue:0924063000 | 2020-12-07T13:38:52.480312+02:00 | statistical_district | Viertola | |||||||
| 5402 | 92-063 | ocd-division/country:fi/kunta:vantaa/kaupunginosa:063 | 2020-10-02T09:50:47.007925+03:00 | neighborhood | 33 | vantaa | Viertola | Bäckby |
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 );