administrative_division

169 rows where type = "voting_district" sorted by name_fi

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: modified_at (date)

type ✖

  • voting_district · 169 ✖

start (date) ✖

id origin_id ocd_id service_point_id start end modified_at type parent municipality name_fi ▼ name_sv name
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    
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    
976 005C ocd-division/country:fi/kunta:helsinki/äänestysalue:005c 52641     2020-12-07T13:38:31.706848+02:00 voting_district 32 helsinki Eira    
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    
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    
1031 029D ocd-division/country:fi/kunta:helsinki/äänestysalue:029d 52812     2020-12-07T13:38:31.914119+02:00 voting_district 32 helsinki Haaga    
1084 041B ocd-division/country:fi/kunta:helsinki/äänestysalue:041b 52484     2020-12-07T13:38:32.127765+02:00 voting_district 32 helsinki Heikinlaakso    
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    
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    
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    
3945 043C ocd-division/country:fi/kunta:helsinki/äänestysalue:043c       2020-12-07T13:38:32.150131+02:00 voting_district 32 helsinki Herttoniemi C    
972 004B ocd-division/country:fi/kunta:helsinki/äänestysalue:004b 52613     2020-12-07T13:38:31.695115+02:00 voting_district 32 helsinki Hietalahti    
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    
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    
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    
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    
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    
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    
970 003A ocd-division/country:fi/kunta:helsinki/äänestysalue:003a 52636     2020-12-07T13:38:31.689064+02:00 voting_district 32 helsinki Kaartinkaupunki    
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    
3944 010D ocd-division/country:fi/kunta:helsinki/äänestysalue:010d       2020-12-07T13:38:31.742411+02:00 voting_district 32 helsinki Kalastatama B    
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    
971 004A ocd-division/country:fi/kunta:helsinki/äänestysalue:004a 52486     2020-12-07T13:38:31.692145+02:00 voting_district 32 helsinki Kamppi    
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    
983 008A ocd-division/country:fi/kunta:helsinki/äänestysalue:008a 52773     2020-12-07T13:38:31.727473+02:00 voting_district 32 helsinki Katajanokka    
1116 047K ocd-division/country:fi/kunta:helsinki/äänestysalue:047k 52480     2020-06-15T15:06:16.253083+03:00 voting_district 32 helsinki Kivikko    
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    
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    
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    
1021 026A ocd-division/country:fi/kunta:helsinki/äänestysalue:026a 52568     2020-12-07T13:38:31.877868+02:00 voting_district 32 helsinki Koskela    
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    
1087 042A ocd-division/country:fi/kunta:helsinki/äänestysalue:042a 52605     2020-12-07T13:38:32.138680+02:00 voting_district 32 helsinki Kulosaari    
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    
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    
973 004C ocd-division/country:fi/kunta:helsinki/äänestysalue:004c 52789     2020-12-07T13:38:31.698080+02:00 voting_district 32 helsinki Lapinlahti    
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    
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    
988 011B ocd-division/country:fi/kunta:helsinki/äänestysalue:011b 52587     2020-12-07T13:38:31.750202+02:00 voting_district 32 helsinki Linjat    
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    
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    
1102 045H ocd-division/country:fi/kunta:helsinki/äänestysalue:045h 52570     2020-12-07T13:38:32.195302+02:00 voting_district 32 helsinki Marjaniemi    
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    
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    
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    
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    
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    
985 010B ocd-division/country:fi/kunta:helsinki/äänestysalue:010b 52702     2020-12-07T13:38:31.734064+02:00 voting_district 32 helsinki Merihaka    
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    
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    
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    
1058 034B ocd-division/country:fi/kunta:helsinki/äänestysalue:034b 52551     2020-12-07T13:38:32.025105+02:00 voting_district 32 helsinki Pakila    

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