administrative_division

169 rows where type = "voting_district" sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: modified_at (date)

type ✖

  • voting_district · 169 ✖
id ▲ origin_id ocd_id service_point_id start end modified_at type parent municipality name_fi name_sv name
3946 054J ocd-division/country:fi/kunta:helsinki/äänestysalue:054j       2020-12-07T13:38:32.340485+02:00 voting_district 32 helsinki Vuosaari J    
3945 043C ocd-division/country:fi/kunta:helsinki/äänestysalue:043c       2020-12-07T13:38:32.150131+02:00 voting_district 32 helsinki Herttoniemi C    
3944 010D ocd-division/country:fi/kunta:helsinki/äänestysalue:010d       2020-12-07T13:38:31.742411+02:00 voting_district 32 helsinki Kalastatama B    
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    
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    
1132 055A ocd-division/country:fi/kunta:helsinki/äänestysalue:055a 52535     2020-12-07T13:38:32.343959+02:00 voting_district 32 helsinki Östersundom    
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    
1123 052A ocd-division/country:fi/kunta:helsinki/äänestysalue:052a 52767     2020-12-07T13:38:32.298242+02:00 voting_district 32 helsinki Suomenlinna    
1122 051A ocd-division/country:fi/kunta:helsinki/äänestysalue:051a 52761     2020-06-15T15:06:16.274146+03:00 voting_district 32 helsinki Santahamina    
1121 049E ocd-division/country:fi/kunta:helsinki/äänestysalue:049e       2020-12-07T13:38:32.292836+02:00 voting_district 32 helsinki Laajasalo E    
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    
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    
1118 049B ocd-division/country:fi/kunta:helsinki/äänestysalue:049b       2020-12-07T13:38:32.275437+02:00 voting_district 32 helsinki Laajasalo B    
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    
1116 047K ocd-division/country:fi/kunta:helsinki/äänestysalue:047k 52480     2020-06-15T15:06:16.253083+03:00 voting_district 32 helsinki Kivikko    
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    
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    
1113 047G ocd-division/country:fi/kunta:helsinki/äänestysalue:047g 52670     2020-12-07T13:38:32.253311+02:00 voting_district 32 helsinki Mellunkylä    
1112 047F ocd-division/country:fi/kunta:helsinki/äänestysalue:047f       2020-12-07T13:38:32.246770+02:00 voting_district 32 helsinki Vesala 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    
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    
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    
1108 047B ocd-division/country:fi/kunta:helsinki/äänestysalue:047b       2020-12-07T13:38:32.222649+02:00 voting_district 32 helsinki Kivikko B    
1107 047A ocd-division/country:fi/kunta:helsinki/äänestysalue:047a       2020-12-07T13:38:32.216601+02:00 voting_district 32 helsinki Kivikko A    
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    
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    
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    
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    
1102 045H ocd-division/country:fi/kunta:helsinki/äänestysalue:045h 52570     2020-12-07T13:38:32.195302+02:00 voting_district 32 helsinki Marjaniemi    
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    
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    
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    
1098 045D ocd-division/country:fi/kunta:helsinki/äänestysalue:045d 52483     2020-12-07T13:38:32.182007+02:00 voting_district 32 helsinki Puotinharju    
1097 045C ocd-division/country:fi/kunta:helsinki/äänestysalue:045c 52774     2020-12-07T13:38:32.178637+02:00 voting_district 32 helsinki Puotila    
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    
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    
1094 044A ocd-division/country:fi/kunta:helsinki/äänestysalue:044a 52738     2020-12-07T13:38:32.168611+02:00 voting_district 32 helsinki Tammisalo    
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    
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    
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    
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    
1089 043B ocd-division/country:fi/kunta:helsinki/äänestysalue:043b       2020-12-07T13:38:32.146103+02:00 voting_district 32 helsinki Herttoniemi B    
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    
1087 042A ocd-division/country:fi/kunta:helsinki/äänestysalue:042a 52605     2020-12-07T13:38:32.138680+02:00 voting_district 32 helsinki Kulosaari    
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    
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    
1084 041B ocd-division/country:fi/kunta:helsinki/äänestysalue:041b 52484     2020-12-07T13:38:32.127765+02:00 voting_district 32 helsinki Heikinlaakso    
1083 041A ocd-division/country:fi/kunta:helsinki/äänestysalue:041a 52528     2020-12-07T13:38:32.124160+02:00 voting_district 32 helsinki Puistola    
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    
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    
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    
1079 040B ocd-division/country:fi/kunta:helsinki/äänestysalue:040b 52476     2020-12-07T13:38:32.110916+02:00 voting_district 32 helsinki Suutarila    
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    
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    
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    
1075 039B ocd-division/country:fi/kunta:helsinki/äänestysalue:039b 52732     2020-12-07T13:38:32.098086+02:00 voting_district 32 helsinki Tapaninkylä    
1074 039A ocd-division/country:fi/kunta:helsinki/äänestysalue:039a 52547     2020-12-07T13:38:32.095077+02:00 voting_district 32 helsinki Tapaninvainio    
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    
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    
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    
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    
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    
1067 038A ocd-division/country:fi/kunta:helsinki/äänestysalue:038a 52548     2020-12-07T13:38:32.070252+02:00 voting_district 32 helsinki Pihlajisto    
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    
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    
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    
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    
1060 035A ocd-division/country:fi/kunta:helsinki/äänestysalue:035a 52621     2020-12-07T13:38:32.032549+02:00 voting_district 32 helsinki Paloheinä    
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    
1058 034B ocd-division/country:fi/kunta:helsinki/äänestysalue:034b 52551     2020-12-07T13:38:32.025105+02:00 voting_district 32 helsinki Pakila    
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    
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    
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    
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    
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    
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    
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    
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    
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    
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    
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    
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    
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    
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    
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    
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    
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    
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    
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    
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    

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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
);