administrative_division
2,760 rows sorted by type descending
This data as json, CSV (advanced)
Suggested facets: start, end, municipality, start (date), end (date), modified_at (date)
type ✖
- small_district 404
- preschool_education_fi 314
- muni 313
- statistical_district 305
- neighborhood 185
- lower_comprehensive_school_district_fi 174
- postcode_area 171
- voting_district 169
- rescue_sub_district 148
- sub_district 148
- upper_comprehensive_school_district_fi 110
- nature_reserve 62
- lower_comprehensive_school_district_sv 60
- district 34
- health_station_district 34
- rescue_district 34
- upper_comprehensive_school_district_sv 32
- maternity_clinic_district 26
- preschool_education_sv 19
- major_district 8
- rescue_area 8
- emergency_care_district 2
id | origin_id | ocd_id | service_point_id | start | end | modified_at | type ▲ | parent | municipality | name_fi | name_sv | name |
---|---|---|---|---|---|---|---|---|---|---|---|---|
968 | 001A | ocd-division/country:fi/kunta:helsinki/äänestysalue:001a | 52808 | 2020-12-07T13:38:31.680661+02:00 | voting_district | 32 | helsinki | Kruununhaka A | ||||
969 | 002A | ocd-division/country:fi/kunta:helsinki/äänestysalue:002a | 52768 | 2020-12-07T13:38:31.685878+02:00 | voting_district | 32 | helsinki | Kruununhaka B | ||||
970 | 003A | ocd-division/country:fi/kunta:helsinki/äänestysalue:003a | 52636 | 2020-12-07T13:38:31.689064+02:00 | voting_district | 32 | helsinki | Kaartinkaupunki | ||||
971 | 004A | ocd-division/country:fi/kunta:helsinki/äänestysalue:004a | 52486 | 2020-12-07T13:38:31.692145+02:00 | voting_district | 32 | helsinki | Kamppi | ||||
972 | 004B | ocd-division/country:fi/kunta:helsinki/äänestysalue:004b | 52613 | 2020-12-07T13:38:31.695115+02:00 | voting_district | 32 | helsinki | Hietalahti | ||||
973 | 004C | ocd-division/country:fi/kunta:helsinki/äänestysalue:004c | 52789 | 2020-12-07T13:38:31.698080+02:00 | voting_district | 32 | helsinki | Lapinlahti | ||||
974 | 005A | ocd-division/country:fi/kunta:helsinki/äänestysalue:005a | 52626 | 2020-12-07T13:38:31.701068+02:00 | voting_district | 32 | helsinki | Punavuori A | ||||
975 | 005B | ocd-division/country:fi/kunta:helsinki/äänestysalue:005b | 52706 | 2020-12-07T13:38:31.703991+02:00 | voting_district | 32 | helsinki | Punavuori B | ||||
976 | 005C | ocd-division/country:fi/kunta:helsinki/äänestysalue:005c | 52641 | 2020-12-07T13:38:31.706848+02:00 | voting_district | 32 | helsinki | Eira | ||||
977 | 006A | ocd-division/country:fi/kunta:helsinki/äänestysalue:006a | 52518 | 2020-12-07T13:38:31.709766+02:00 | voting_district | 32 | helsinki | Ruoholahti | ||||
978 | 006B | ocd-division/country:fi/kunta:helsinki/äänestysalue:006b | 52642 | 2020-12-07T13:38:31.712548+02:00 | voting_district | 32 | helsinki | Jätkäsaari A | ||||
979 | 006C | ocd-division/country:fi/kunta:helsinki/äänestysalue:006c | 59230 | 2020-12-07T13:38:31.715239+02:00 | voting_district | 32 | helsinki | Jätkäsaari B | ||||
980 | 007A | ocd-division/country:fi/kunta:helsinki/äänestysalue:007a | 52742 | 2020-12-07T13:38:31.721087+02:00 | voting_district | 32 | helsinki | Ullanlinna A | ||||
981 | 007B | ocd-division/country:fi/kunta:helsinki/äänestysalue:007b | 52775 | 2020-12-07T13:38:31.724465+02:00 | voting_district | 32 | helsinki | Ullanlinna B | ||||
983 | 008A | ocd-division/country:fi/kunta:helsinki/äänestysalue:008a | 52773 | 2020-12-07T13:38:31.727473+02:00 | voting_district | 32 | helsinki | Katajanokka | ||||
984 | 010A | ocd-division/country:fi/kunta:helsinki/äänestysalue:010a | 52667 | 2020-12-07T13:38:31.730611+02:00 | voting_district | 32 | helsinki | Sörnäinen | ||||
985 | 010B | ocd-division/country:fi/kunta:helsinki/äänestysalue:010b | 52702 | 2020-12-07T13:38:31.734064+02:00 | voting_district | 32 | helsinki | Merihaka | ||||
986 | 010C | ocd-division/country:fi/kunta:helsinki/äänestysalue:010c | 52647 | 2020-12-07T13:38:31.738348+02:00 | voting_district | 32 | helsinki | Kalastatama A | ||||
987 | 011A | ocd-division/country:fi/kunta:helsinki/äänestysalue:011a | 52727 | 2020-12-07T13:38:31.746505+02:00 | voting_district | 32 | helsinki | Siltasaari | ||||
988 | 011B | ocd-division/country:fi/kunta:helsinki/äänestysalue:011b | 52587 | 2020-12-07T13:38:31.750202+02:00 | voting_district | 32 | helsinki | Linjat | ||||
989 | 011C | ocd-division/country:fi/kunta:helsinki/äänestysalue:011c | 52687 | 2020-12-07T13:38:31.754338+02:00 | voting_district | 32 | helsinki | Kallio A | ||||
990 | 011D | ocd-division/country:fi/kunta:helsinki/äänestysalue:011d | 52603 | 2020-12-07T13:38:31.758617+02:00 | voting_district | 32 | helsinki | Kallio B | ||||
991 | 011E | ocd-division/country:fi/kunta:helsinki/äänestysalue:011e | 52506 | 2020-12-07T13:38:31.762350+02:00 | voting_district | 32 | helsinki | Kallio C | ||||
992 | 011F | ocd-division/country:fi/kunta:helsinki/äänestysalue:011f | 52809 | 2020-06-15T15:06:15.768224+03:00 | voting_district | 32 | helsinki | Kallio D | ||||
993 | 012A | ocd-division/country:fi/kunta:helsinki/äänestysalue:012a | 52797 | 2020-12-07T13:38:31.765945+02:00 | voting_district | 32 | helsinki | Alppila A | ||||
994 | 012B | ocd-division/country:fi/kunta:helsinki/äänestysalue:012b | 52517 | 2020-12-07T13:38:31.770225+02:00 | voting_district | 32 | helsinki | Alppila B | ||||
995 | 012C | ocd-division/country:fi/kunta:helsinki/äänestysalue:012c | 52533 | 2020-12-07T13:38:31.775168+02:00 | voting_district | 32 | helsinki | Alppila C | ||||
996 | 012D | ocd-division/country:fi/kunta:helsinki/äänestysalue:012d | 52673 | 2020-12-07T13:38:31.780156+02:00 | voting_district | 32 | helsinki | Alppila D | ||||
997 | 013A | ocd-division/country:fi/kunta:helsinki/äänestysalue:013a | 52611 | 2020-12-07T13:38:31.785099+02:00 | voting_district | 32 | helsinki | Etu-Töölö A | ||||
998 | 013B | ocd-division/country:fi/kunta:helsinki/äänestysalue:013b | 52622 | 2020-12-07T13:38:31.790152+02:00 | voting_district | 32 | helsinki | Etu-Töölö B | ||||
999 | 013C | ocd-division/country:fi/kunta:helsinki/äänestysalue:013c | 52699 | 2020-12-07T13:38:31.795102+02:00 | voting_district | 32 | helsinki | Etu-Töölö C | ||||
1000 | 013D | ocd-division/country:fi/kunta:helsinki/äänestysalue:013d | 52507 | 2020-12-07T13:38:31.799456+02:00 | voting_district | 32 | helsinki | Etu-Töölö D | ||||
1001 | 014A | ocd-division/country:fi/kunta:helsinki/äänestysalue:014a | 52692 | 2020-12-07T13:38:31.802381+02:00 | voting_district | 32 | helsinki | Taka-Töölö A | ||||
1002 | 014B | ocd-division/country:fi/kunta:helsinki/äänestysalue:014b | 52572 | 2020-12-07T13:38:31.805288+02:00 | voting_district | 32 | helsinki | Taka-Töölö B | ||||
1003 | 014C | ocd-division/country:fi/kunta:helsinki/äänestysalue:014c | 52787 | 2020-12-07T13:38:31.808315+02:00 | voting_district | 32 | helsinki | Taka-Töölö C | ||||
1004 | 014D | ocd-division/country:fi/kunta:helsinki/äänestysalue:014d | 52693 | 2020-12-07T13:38:31.811619+02:00 | voting_district | 32 | helsinki | Taka-Töölö D | ||||
1005 | 015A | ocd-division/country:fi/kunta:helsinki/äänestysalue:015a | 52546 | 2020-12-07T13:38:31.814943+02:00 | voting_district | 32 | helsinki | Meilahti A | ||||
1006 | 015B | ocd-division/country:fi/kunta:helsinki/äänestysalue:015b | 52781 | 2020-12-07T13:38:31.817687+02:00 | voting_district | 32 | helsinki | Meilahti B | ||||
1007 | 016A | ocd-division/country:fi/kunta:helsinki/äänestysalue:016a | 52694 | 2020-12-07T13:38:31.820482+02:00 | voting_district | 32 | helsinki | Ruskeasuo | ||||
1008 | 016B | ocd-division/country:fi/kunta:helsinki/äänestysalue:016b | 52796 | 2020-12-07T13:38:31.823519+02:00 | voting_district | 32 | helsinki | Pikku Huopalahti | ||||
1009 | 017A | ocd-division/country:fi/kunta:helsinki/äänestysalue:017a | 52509 | 2020-12-07T13:38:31.827054+02:00 | voting_district | 32 | helsinki | Pasila A | ||||
1010 | 017B | ocd-division/country:fi/kunta:helsinki/äänestysalue:017b | 52705 | 2020-12-07T13:38:31.831435+02:00 | voting_district | 32 | helsinki | Itä-Pasila | ||||
1011 | 017C | ocd-division/country:fi/kunta:helsinki/äänestysalue:017c | 52675 | 2020-12-07T13:38:31.835702+02:00 | voting_district | 32 | helsinki | Pasila B | ||||
1012 | 021A | ocd-division/country:fi/kunta:helsinki/äänestysalue:021a | 52596 | 2020-12-07T13:38:31.839829+02:00 | voting_district | 32 | helsinki | Hermanni A | ||||
1013 | 021B | ocd-division/country:fi/kunta:helsinki/äänestysalue:021b | 52619 | 2020-12-07T13:38:31.844109+02:00 | voting_district | 32 | helsinki | Hermanni B | ||||
1014 | 022A | ocd-division/country:fi/kunta:helsinki/äänestysalue:022a | 52689 | 2020-12-07T13:38:31.848129+02:00 | voting_district | 32 | helsinki | Vallila A | ||||
1015 | 022B | ocd-division/country:fi/kunta:helsinki/äänestysalue:022b | 52612 | 2020-12-07T13:38:31.852267+02:00 | voting_district | 32 | helsinki | Vallila B | ||||
1016 | 023A | ocd-division/country:fi/kunta:helsinki/äänestysalue:023a | 52478 | 2020-12-07T13:38:31.856962+02:00 | voting_district | 32 | helsinki | Toukola A | ||||
1017 | 023B | ocd-division/country:fi/kunta:helsinki/äänestysalue:023b | 52650 | 2020-12-07T13:38:31.861132+02:00 | voting_district | 32 | helsinki | Toukola B | ||||
1018 | 024A | ocd-division/country:fi/kunta:helsinki/äänestysalue:024a | 52820 | 2020-12-07T13:38:31.865486+02:00 | voting_district | 32 | helsinki | Kumpula | ||||
1019 | 025A | ocd-division/country:fi/kunta:helsinki/äänestysalue:025a | 52521 | 2020-12-07T13:38:31.869480+02:00 | voting_district | 32 | helsinki | Käpylä A | ||||
1020 | 025B | ocd-division/country:fi/kunta:helsinki/äänestysalue:025b | 52708 | 2020-12-07T13:38:31.873773+02:00 | voting_district | 32 | helsinki | Käpylä B | ||||
1021 | 026A | ocd-division/country:fi/kunta:helsinki/äänestysalue:026a | 52568 | 2020-12-07T13:38:31.877868+02:00 | voting_district | 32 | helsinki | Koskela | ||||
1022 | 028A | ocd-division/country:fi/kunta:helsinki/äänestysalue:028a | 52695 | 2020-12-07T13:38:31.881191+02:00 | voting_district | 32 | helsinki | Maunula A | ||||
1023 | 028B | ocd-division/country:fi/kunta:helsinki/äänestysalue:028b | 52482 | 2020-12-07T13:38:31.884968+02:00 | voting_district | 32 | helsinki | Maunula B | ||||
1024 | 028D | ocd-division/country:fi/kunta:helsinki/äänestysalue:028d | 52740 | 2020-12-07T13:38:31.888296+02:00 | voting_district | 32 | helsinki | Oulunkylä A | ||||
1025 | 028E | ocd-division/country:fi/kunta:helsinki/äänestysalue:028e | 52488 | 2020-12-07T13:38:31.891370+02:00 | voting_district | 32 | helsinki | Oulunkylä B | ||||
1026 | 028F | ocd-division/country:fi/kunta:helsinki/äänestysalue:028f | 52731 | 2020-12-07T13:38:31.894505+02:00 | voting_district | 32 | helsinki | Oulunkylä C | ||||
1027 | 028G | ocd-division/country:fi/kunta:helsinki/äänestysalue:028g | 52721 | 2020-12-07T13:38:31.897882+02:00 | voting_district | 32 | helsinki | Veräjämäki | ||||
1028 | 029A | ocd-division/country:fi/kunta:helsinki/äänestysalue:029a | 52497 | 2020-12-07T13:38:31.901198+02:00 | voting_district | 32 | helsinki | Etelä-Haaga A | ||||
1029 | 029B | ocd-division/country:fi/kunta:helsinki/äänestysalue:029b | 52819 | 2020-12-07T13:38:31.905235+02:00 | voting_district | 32 | helsinki | Etelä-Haaga B | ||||
1030 | 029C | ocd-division/country:fi/kunta:helsinki/äänestysalue:029c | 52494 | 2020-12-07T13:38:31.910109+02:00 | voting_district | 32 | helsinki | Etelä-Haaga C | ||||
1031 | 029D | ocd-division/country:fi/kunta:helsinki/äänestysalue:029d | 52812 | 2020-12-07T13:38:31.914119+02:00 | voting_district | 32 | helsinki | Haaga | ||||
1032 | 029E | ocd-division/country:fi/kunta:helsinki/äänestysalue:029e | 52601 | 2020-12-07T13:38:31.920066+02:00 | voting_district | 32 | helsinki | Pohjois-Haaga A | ||||
1033 | 029F | ocd-division/country:fi/kunta:helsinki/äänestysalue:029f | 52592 | 2020-12-07T13:38:31.924590+02:00 | voting_district | 32 | helsinki | Pohjois-Haaga B | ||||
1034 | 029G | ocd-division/country:fi/kunta:helsinki/äänestysalue:029g | 52505 | 2020-12-07T13:38:31.929137+02:00 | voting_district | 32 | helsinki | Lassila A | ||||
1035 | 029H | ocd-division/country:fi/kunta:helsinki/äänestysalue:029h | 52669 | 2020-12-07T13:38:31.934062+02:00 | voting_district | 32 | helsinki | Lassila B | ||||
1036 | 030A | ocd-division/country:fi/kunta:helsinki/äänestysalue:030a | 52745 | 2020-12-07T13:38:31.939231+02:00 | voting_district | 32 | helsinki | Munkkiniemi A | ||||
1037 | 030B | ocd-division/country:fi/kunta:helsinki/äänestysalue:030b | 52623 | 2020-12-07T13:38:31.943708+02:00 | voting_district | 32 | helsinki | Munkkiniemi B | ||||
1038 | 030C | ocd-division/country:fi/kunta:helsinki/äänestysalue:030c | 52688 | 2020-12-07T13:38:31.948241+02:00 | voting_district | 32 | helsinki | Munkkiniemi C | ||||
1039 | 030D | ocd-division/country:fi/kunta:helsinki/äänestysalue:030d | 52566 | 2020-12-07T13:38:31.952884+02:00 | voting_district | 32 | helsinki | Munkkivuori A | ||||
1040 | 030E | ocd-division/country:fi/kunta:helsinki/äänestysalue:030e | 52609 | 2020-12-07T13:38:31.957677+02:00 | voting_district | 32 | helsinki | Munkkivuori B | ||||
1041 | 031A | ocd-division/country:fi/kunta:helsinki/äänestysalue:031a | 52531 | 2020-12-07T13:38:31.962109+02:00 | voting_district | 32 | helsinki | Lauttasaari A | ||||
1042 | 031B | ocd-division/country:fi/kunta:helsinki/äänestysalue:031b | 52543 | 2020-12-07T13:38:31.966156+02:00 | voting_district | 32 | helsinki | Lauttasaari B | ||||
1043 | 031C | ocd-division/country:fi/kunta:helsinki/äänestysalue:031c | 52799 | 2020-12-07T13:38:31.970002+02:00 | voting_district | 32 | helsinki | Lauttasaari C | ||||
1044 | 031D | ocd-division/country:fi/kunta:helsinki/äänestysalue:031d | 52534 | 2020-12-07T13:38:31.973658+02:00 | voting_district | 32 | helsinki | Lauttasaari D | ||||
1045 | 031E | ocd-division/country:fi/kunta:helsinki/äänestysalue:031e | 52540 | 2020-12-07T13:38:31.977402+02:00 | voting_district | 32 | helsinki | Lauttasaari E | ||||
1046 | 031F | ocd-division/country:fi/kunta:helsinki/äänestysalue:031f | 52777 | 2020-12-07T13:38:31.981225+02:00 | voting_district | 32 | helsinki | Lauttasaari F | ||||
1047 | 032A | ocd-division/country:fi/kunta:helsinki/äänestysalue:032a | 52633 | 2020-12-07T13:38:31.984969+02:00 | voting_district | 32 | helsinki | Konala A | ||||
1048 | 032B | ocd-division/country:fi/kunta:helsinki/äänestysalue:032b | 52686 | 2020-12-07T13:38:31.989455+02:00 | voting_district | 32 | helsinki | Konala B | ||||
1049 | 033A | ocd-division/country:fi/kunta:helsinki/äänestysalue:033a | 52490 | 2020-12-07T13:38:31.994222+02:00 | voting_district | 32 | helsinki | Kannelmäki A | ||||
1050 | 033B | ocd-division/country:fi/kunta:helsinki/äänestysalue:033b | 52594 | 2020-12-07T13:38:31.998125+02:00 | voting_district | 32 | helsinki | Kannelmäki B | ||||
1051 | 033C | ocd-division/country:fi/kunta:helsinki/äänestysalue:033c | 52788 | 2020-12-07T13:38:32.001398+02:00 | voting_district | 32 | helsinki | Kannelmäki C | ||||
1052 | 033D | ocd-division/country:fi/kunta:helsinki/äänestysalue:033d | 52801 | 2020-06-15T15:06:15.984986+03:00 | voting_district | 32 | helsinki | Kannelmäki D | ||||
1053 | 033E | ocd-division/country:fi/kunta:helsinki/äänestysalue:033e | 52793 | 2020-12-07T13:38:32.005535+02:00 | voting_district | 32 | helsinki | Maununneva A | ||||
1054 | 033F | ocd-division/country:fi/kunta:helsinki/äänestysalue:033f | 52782 | 2020-12-07T13:38:32.009433+02:00 | voting_district | 32 | helsinki | Malminkartano A | ||||
1055 | 033G | ocd-division/country:fi/kunta:helsinki/äänestysalue:033g | 52664 | 2020-12-07T13:38:32.013137+02:00 | voting_district | 32 | helsinki | Malminkartano B | ||||
1056 | 033H | ocd-division/country:fi/kunta:helsinki/äänestysalue:033h | 52765 | 2020-12-07T13:38:32.017069+02:00 | voting_district | 32 | helsinki | Maununneva B | ||||
1057 | 034A | ocd-division/country:fi/kunta:helsinki/äänestysalue:034a | 52502 | 2020-12-07T13:38:32.021333+02:00 | voting_district | 32 | helsinki | Länsi-Pakila | ||||
1058 | 034B | ocd-division/country:fi/kunta:helsinki/äänestysalue:034b | 52551 | 2020-12-07T13:38:32.025105+02:00 | voting_district | 32 | helsinki | Pakila | ||||
1059 | 034C | ocd-division/country:fi/kunta:helsinki/äänestysalue:034c | 52746 | 2020-12-07T13:38:32.028308+02:00 | voting_district | 32 | helsinki | Itä-Pakila | ||||
1060 | 035A | ocd-division/country:fi/kunta:helsinki/äänestysalue:035a | 52621 | 2020-12-07T13:38:32.032549+02:00 | voting_district | 32 | helsinki | Paloheinä | ||||
1061 | 035B | ocd-division/country:fi/kunta:helsinki/äänestysalue:035b | 52630 | 2020-12-07T13:38:32.037016+02:00 | voting_district | 32 | helsinki | Torpparinmäki | ||||
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 | ||||
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 | ||||
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 | ||||
1065 | 037A | ocd-division/country:fi/kunta:helsinki/äänestysalue:037a | 52739 | 2020-12-07T13:38:32.062253+02:00 | voting_district | 32 | helsinki | Pukinmäki A | ||||
1066 | 037B | ocd-division/country:fi/kunta:helsinki/äänestysalue:037b | 52710 | 2020-12-07T13:38:32.066282+02:00 | voting_district | 32 | helsinki | Pukinmäki B | ||||
1067 | 038A | ocd-division/country:fi/kunta:helsinki/äänestysalue:038a | 52548 | 2020-12-07T13:38:32.070252+02:00 | voting_district | 32 | helsinki | Pihlajisto | ||||
1068 | 038B | ocd-division/country:fi/kunta:helsinki/äänestysalue:038b | 52680 | 2020-12-07T13:38:32.074078+02:00 | voting_district | 32 | helsinki | Pihlajamäki A |
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 );