administrative_division
2,760 rows sorted by name_fi descending
This data as json, CSV (advanced)
Suggested facets: end, type, municipality, start (date), end (date), modified_at (date)
start ✖
- 2021-07-01 263
- 2021-08-01 190
- 2020-08-01 186
- 2020-07-01 70
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 );