administrative_division

2,760 rows sorted by origin_id

✎ View and edit SQL

This data as json, CSV (advanced)

municipality ✖

id origin_id ▼ ocd_id service_point_id start end modified_at type parent municipality name_fi name_sv name
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    
358 030 ocd-division/country:fi/kunta:helsinki/osa-alue:kaartinkaupunki       2020-12-07T13:38:25.152388+02:00 sub_district 323 helsinki Kaartinkaupunki Gardesstaden  
1289 030 ocd-division/country:fi/kunta:helsinki/suojelualalohko:kaartinkaupunki       2020-12-07T13:38:35.505345+02:00 rescue_sub_district 32 helsinki Kaartinkaupunki Gardesstaden  
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    
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    
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    
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    
359 040 ocd-division/country:fi/kunta:helsinki/osa-alue:kamppi       2020-12-07T13:38:25.175135+02:00 sub_district 324 helsinki Kamppi Kampen  
1290 040 ocd-division/country:fi/kunta:helsinki/suojelualalohko:kamppi       2020-12-07T13:38:35.509549+02:00 rescue_sub_district 32 helsinki Kamppi Kampen  
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    
3945 043C ocd-division/country:fi/kunta:helsinki/äänestysalue:043c       2020-12-07T13:38:32.150131+02:00 voting_district 32 helsinki Herttoniemi C    
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    

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