administrative_division
169 rows where type = "voting_district"
This data as json, CSV (advanced)
id ▼ | origin_id | ocd_id | service_point_id | start | end | modified_at | type | parent | municipality | name_fi | name_sv | name |
---|---|---|---|---|---|---|---|---|---|---|---|---|
1069 | 038C | ocd-division/country:fi/kunta:helsinki/äänestysalue:038c | 52549 | 2020-12-07T13:38:32.077946+02:00 | voting_district | 32 | helsinki | Pihlajamäki B | ||||
1070 | 038D | ocd-division/country:fi/kunta:helsinki/äänestysalue:038d | 52481 | 2020-12-07T13:38:32.081979+02:00 | voting_district | 32 | helsinki | Ala-Malmi A | ||||
1071 | 038E | ocd-division/country:fi/kunta:helsinki/äänestysalue:038e | 52514 | 2020-12-07T13:38:32.085583+02:00 | voting_district | 32 | helsinki | Ala-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 | ||||
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 | ||||
1074 | 039A | ocd-division/country:fi/kunta:helsinki/äänestysalue:039a | 52547 | 2020-12-07T13:38:32.095077+02:00 | voting_district | 32 | helsinki | Tapaninvainio | ||||
1075 | 039B | ocd-division/country:fi/kunta:helsinki/äänestysalue:039b | 52732 | 2020-12-07T13:38:32.098086+02:00 | voting_district | 32 | helsinki | Tapaninkylä | ||||
1076 | 039C | ocd-division/country:fi/kunta:helsinki/äänestysalue:039c | 52513 | 2020-12-07T13:38:32.101127+02:00 | voting_district | 32 | helsinki | Tapanila A | ||||
1077 | 039D | ocd-division/country:fi/kunta:helsinki/äänestysalue:039d | 52571 | 2020-12-07T13:38:32.104247+02:00 | voting_district | 32 | helsinki | Tapanila B | ||||
1078 | 040A | ocd-division/country:fi/kunta:helsinki/äänestysalue:040a | 52523 | 2020-12-07T13:38:32.107419+02:00 | voting_district | 32 | helsinki | Siltamäki | ||||
1079 | 040B | ocd-division/country:fi/kunta:helsinki/äänestysalue:040b | 52476 | 2020-12-07T13:38:32.110916+02:00 | voting_district | 32 | helsinki | Suutarila | ||||
1080 | 040C | ocd-division/country:fi/kunta:helsinki/äänestysalue:040c | 52748 | 2020-12-07T13:38:32.114422+02:00 | voting_district | 32 | helsinki | Töyrynummi | ||||
1081 | 040D | ocd-division/country:fi/kunta:helsinki/äänestysalue:040d | 52674 | 2020-12-07T13:38:32.117744+02:00 | voting_district | 32 | helsinki | Tapulikaupunki A | ||||
1082 | 040E | ocd-division/country:fi/kunta:helsinki/äänestysalue:040e | 52602 | 2020-12-07T13:38:32.120864+02:00 | voting_district | 32 | helsinki | Tapulikaupunki B | ||||
1083 | 041A | ocd-division/country:fi/kunta:helsinki/äänestysalue:041a | 52528 | 2020-12-07T13:38:32.124160+02:00 | voting_district | 32 | helsinki | Puistola | ||||
1084 | 041B | ocd-division/country:fi/kunta:helsinki/äänestysalue:041b | 52484 | 2020-12-07T13:38:32.127765+02:00 | voting_district | 32 | helsinki | Heikinlaakso | ||||
1085 | 041C | ocd-division/country:fi/kunta:helsinki/äänestysalue:041c | 52553 | 2020-12-07T13:38:32.131104+02:00 | voting_district | 32 | helsinki | Jakomäki A | ||||
1086 | 041D | ocd-division/country:fi/kunta:helsinki/äänestysalue:041d | 52515 | 2020-12-07T13:38:32.134916+02:00 | voting_district | 32 | helsinki | Jakomäki B | ||||
1087 | 042A | ocd-division/country:fi/kunta:helsinki/äänestysalue:042a | 52605 | 2020-12-07T13:38:32.138680+02:00 | voting_district | 32 | helsinki | Kulosaari | ||||
1088 | 043A | ocd-division/country:fi/kunta:helsinki/äänestysalue:043a | 52524 | 2020-12-07T13:38:32.142461+02:00 | voting_district | 32 | helsinki | Herttoniemi A | ||||
1089 | 043B | ocd-division/country:fi/kunta:helsinki/äänestysalue:043b | 2020-12-07T13:38:32.146103+02:00 | voting_district | 32 | helsinki | Herttoniemi B | |||||
1090 | 043D | ocd-division/country:fi/kunta:helsinki/äänestysalue:043d | 52816 | 2020-12-07T13:38:32.153931+02:00 | voting_district | 32 | helsinki | Roihuvuori A | ||||
1091 | 043E | ocd-division/country:fi/kunta:helsinki/äänestysalue:043e | 52743 | 2020-12-07T13:38:32.157741+02:00 | voting_district | 32 | helsinki | Roihuvuori B | ||||
1092 | 043F | ocd-division/country:fi/kunta:helsinki/äänestysalue:043f | 52824 | 2020-12-07T13:38:32.161509+02:00 | voting_district | 32 | helsinki | Herttoniemenranta A | ||||
1093 | 043G | ocd-division/country:fi/kunta:helsinki/äänestysalue:043g | 52504 | 2020-12-07T13:38:32.165347+02:00 | voting_district | 32 | helsinki | Herttoniemenranta B | ||||
1094 | 044A | ocd-division/country:fi/kunta:helsinki/äänestysalue:044a | 52738 | 2020-12-07T13:38:32.168611+02:00 | voting_district | 32 | helsinki | Tammisalo | ||||
1095 | 045A | ocd-division/country:fi/kunta:helsinki/äänestysalue:045a | 52659 | 2020-12-07T13:38:32.171923+02:00 | voting_district | 32 | helsinki | Vartioharju A | ||||
1096 | 045B | ocd-division/country:fi/kunta:helsinki/äänestysalue:045b | 52786 | 2020-12-07T13:38:32.175475+02:00 | voting_district | 32 | helsinki | Vartioharju B | ||||
1097 | 045C | ocd-division/country:fi/kunta:helsinki/äänestysalue:045c | 52774 | 2020-12-07T13:38:32.178637+02:00 | voting_district | 32 | helsinki | Puotila | ||||
1098 | 045D | ocd-division/country:fi/kunta:helsinki/äänestysalue:045d | 52483 | 2020-12-07T13:38:32.182007+02:00 | voting_district | 32 | helsinki | Puotinharju | ||||
1099 | 045E | ocd-division/country:fi/kunta:helsinki/äänestysalue:045e | 52503 | 2020-12-07T13:38:32.185499+02:00 | voting_district | 32 | helsinki | Myllypuro A | ||||
1100 | 045F | ocd-division/country:fi/kunta:helsinki/äänestysalue:045f | 52690 | 2020-12-07T13:38:32.188700+02:00 | voting_district | 32 | helsinki | Myllypuro B | ||||
1101 | 045G | ocd-division/country:fi/kunta:helsinki/äänestysalue:045g | 52638 | 2020-12-07T13:38:32.191970+02:00 | voting_district | 32 | helsinki | Myllypuro C | ||||
1102 | 045H | ocd-division/country:fi/kunta:helsinki/äänestysalue:045h | 52570 | 2020-12-07T13:38:32.195302+02:00 | voting_district | 32 | helsinki | Marjaniemi | ||||
1103 | 045J | ocd-division/country:fi/kunta:helsinki/äänestysalue:045j | 52711 | 2020-06-15T15:06:16.196556+03:00 | voting_district | 32 | helsinki | Itäkeskus | ||||
1104 | 046A | ocd-division/country:fi/kunta:helsinki/äänestysalue:046a | 52614 | 2020-12-07T13:38:32.198395+02:00 | voting_district | 32 | helsinki | Pitäjänmäki A | ||||
1105 | 046B | ocd-division/country:fi/kunta:helsinki/äänestysalue:046b | 52508 | 2020-12-07T13:38:32.206406+02:00 | voting_district | 32 | helsinki | Pitäjänmäki B | ||||
1106 | 046C | ocd-division/country:fi/kunta:helsinki/äänestysalue:046c | 52677 | 2020-12-07T13:38:32.210801+02:00 | voting_district | 32 | helsinki | Pitäjänmäki C | ||||
1107 | 047A | ocd-division/country:fi/kunta:helsinki/äänestysalue:047a | 2020-12-07T13:38:32.216601+02:00 | voting_district | 32 | helsinki | Kivikko A | |||||
1108 | 047B | ocd-division/country:fi/kunta:helsinki/äänestysalue:047b | 2020-12-07T13:38:32.222649+02:00 | voting_district | 32 | helsinki | Kivikko B | |||||
1109 | 047C | ocd-division/country:fi/kunta:helsinki/äänestysalue:047c | 52503 | 2020-12-07T13:38:32.228051+02:00 | voting_district | 32 | helsinki | Kontula A | ||||
1110 | 047D | ocd-division/country:fi/kunta:helsinki/äänestysalue:047d | 52610 | 2020-12-07T13:38:32.234079+02:00 | voting_district | 32 | helsinki | Kontula B | ||||
1111 | 047E | ocd-division/country:fi/kunta:helsinki/äänestysalue:047e | 52485 | 2020-12-07T13:38:32.240596+02:00 | voting_district | 32 | helsinki | Vesala A | ||||
1112 | 047F | ocd-division/country:fi/kunta:helsinki/äänestysalue:047f | 2020-12-07T13:38:32.246770+02:00 | voting_district | 32 | helsinki | Vesala B | |||||
1113 | 047G | ocd-division/country:fi/kunta:helsinki/äänestysalue:047g | 52670 | 2020-12-07T13:38:32.253311+02:00 | voting_district | 32 | helsinki | Mellunkylä | ||||
1114 | 047H | ocd-division/country:fi/kunta:helsinki/äänestysalue:047h | 52753 | 2020-12-07T13:38:32.259818+02:00 | voting_district | 32 | helsinki | Mellunmäki A | ||||
1115 | 047J | ocd-division/country:fi/kunta:helsinki/äänestysalue:047j | 52683 | 2020-12-07T13:38:32.265600+02:00 | voting_district | 32 | helsinki | Mellunmäki B | ||||
1116 | 047K | ocd-division/country:fi/kunta:helsinki/äänestysalue:047k | 52480 | 2020-06-15T15:06:16.253083+03:00 | voting_district | 32 | helsinki | Kivikko | ||||
1117 | 049A | ocd-division/country:fi/kunta:helsinki/äänestysalue:049a | 52501 | 2020-12-07T13:38:32.271076+02:00 | voting_district | 32 | helsinki | Laajasalo A | ||||
1118 | 049B | ocd-division/country:fi/kunta:helsinki/äänestysalue:049b | 2020-12-07T13:38:32.275437+02:00 | voting_district | 32 | helsinki | Laajasalo B | |||||
1119 | 049C | ocd-division/country:fi/kunta:helsinki/äänestysalue:049c | 52639 | 2020-12-07T13:38:32.281233+02:00 | voting_district | 32 | helsinki | Laajasalo C | ||||
1120 | 049D | ocd-division/country:fi/kunta:helsinki/äänestysalue:049d | 52654 | 2020-12-07T13:38:32.287346+02:00 | voting_district | 32 | helsinki | Laajasalo D | ||||
1121 | 049E | ocd-division/country:fi/kunta:helsinki/äänestysalue:049e | 2020-12-07T13:38:32.292836+02:00 | voting_district | 32 | helsinki | Laajasalo E | |||||
1122 | 051A | ocd-division/country:fi/kunta:helsinki/äänestysalue:051a | 52761 | 2020-06-15T15:06:16.274146+03:00 | voting_district | 32 | helsinki | Santahamina | ||||
1123 | 052A | ocd-division/country:fi/kunta:helsinki/äänestysalue:052a | 52767 | 2020-12-07T13:38:32.298242+02:00 | voting_district | 32 | helsinki | Suomenlinna | ||||
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 | ||||
1125 | 054B | ocd-division/country:fi/kunta:helsinki/äänestysalue:054b | 2020-12-07T13:38:32.308829+02:00 | voting_district | 32 | helsinki | Vuosaari B | |||||
1126 | 054C | ocd-division/country:fi/kunta:helsinki/äänestysalue:054c | 2020-12-07T13:38:32.314365+02:00 | voting_district | 32 | helsinki | Vuosaari C | |||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
1132 | 055A | ocd-division/country:fi/kunta:helsinki/äänestysalue:055a | 52535 | 2020-12-07T13:38:32.343959+02:00 | voting_district | 32 | helsinki | Östersundom | ||||
2774 | 006D | ocd-division/country:fi/kunta:helsinki/äänestysalue:006d | 52542 | 2020-12-07T13:38:31.718033+02:00 | voting_district | 32 | helsinki | Jätkäsaari C | ||||
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 | ||||
3944 | 010D | ocd-division/country:fi/kunta:helsinki/äänestysalue:010d | 2020-12-07T13:38:31.742411+02:00 | voting_district | 32 | helsinki | Kalastatama B | |||||
3945 | 043C | ocd-division/country:fi/kunta:helsinki/äänestysalue:043c | 2020-12-07T13:38:32.150131+02:00 | voting_district | 32 | helsinki | Herttoniemi C | |||||
3946 | 054J | ocd-division/country:fi/kunta:helsinki/äänestysalue:054j | 2020-12-07T13:38:32.340485+02:00 | voting_district | 32 | helsinki | Vuosaari J |
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 );