administrative_division

169 rows where type = "voting_district"

✎ 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
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    

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