administrative_division
318 rows where "modified_at" is on date 2020-06-15 sorted by origin_id
This data as json, CSV (advanced)
type ✖
- muni 313
- voting_district 5
id | origin_id ▼ | ocd_id | service_point_id | start | end | modified_at | type | parent | municipality | name_fi | name_sv | name |
---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||
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 | ||||
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 | ||||
1116 | 047K | ocd-division/country:fi/kunta:helsinki/äänestysalue:047k | 52480 | 2020-06-15T15:06:16.253083+03:00 | voting_district | 32 | helsinki | Kivikko | ||||
1122 | 051A | ocd-division/country:fi/kunta:helsinki/äänestysalue:051a | 52761 | 2020-06-15T15:06:16.274146+03:00 | voting_district | 32 | helsinki | Santahamina | ||||
3 | 10 | ocd-division/country:fi/kunta:alavus | 2020-06-15T15:05:54.610677+03:00 | muni | Alavus | Alavus | ||||||
37 | 102 | ocd-division/country:fi/kunta:huittinen | 2020-06-15T15:05:54.850778+03:00 | muni | Huittinen | Huittinen | ||||||
38 | 103 | ocd-division/country:fi/kunta:humppila | 2020-06-15T15:05:54.856471+03:00 | muni | Humppila | Humppila | ||||||
39 | 105 | ocd-division/country:fi/kunta:hyrynsalmi | 2020-06-15T15:05:54.861850+03:00 | muni | Hyrynsalmi | Hyrynsalmi | ||||||
40 | 106 | ocd-division/country:fi/kunta:hyvinkää | 2020-06-15T15:05:54.867147+03:00 | muni | Hyvinkää | Hyvinge | ||||||
41 | 108 | ocd-division/country:fi/kunta:hämeenkyrö | 2020-06-15T15:05:54.872468+03:00 | muni | Hämeenkyrö | Tavastkyro | ||||||
42 | 109 | ocd-division/country:fi/kunta:hämeenlinna | 2020-06-15T15:05:54.878192+03:00 | muni | Hämeenlinna | Tavastehus | ||||||
303 | 111 | ocd-division/country:fi/kunta:heinola | 2020-06-15T15:05:56.734262+03:00 | muni | Heinola | Heinola | ||||||
43 | 139 | ocd-division/country:fi/kunta:ii | 2020-06-15T15:05:54.884256+03:00 | muni | Ii | Ii | ||||||
44 | 140 | ocd-division/country:fi/kunta:iisalmi | 2020-06-15T15:05:54.890684+03:00 | muni | Iisalmi | Idensalmi | ||||||
45 | 142 | ocd-division/country:fi/kunta:iitti | 2020-06-15T15:05:54.898685+03:00 | muni | Iitti | Iitti | ||||||
46 | 143 | ocd-division/country:fi/kunta:ikaalinen | 2020-06-15T15:05:54.904609+03:00 | muni | Ikaalinen | Ikalis | ||||||
47 | 145 | ocd-division/country:fi/kunta:ilmajoki | 2020-06-15T15:05:54.910112+03:00 | muni | Ilmajoki | Ilmajoki | ||||||
48 | 146 | ocd-division/country:fi/kunta:ilomantsi | 2020-06-15T15:05:54.915836+03:00 | muni | Ilomantsi | Ilomants | ||||||
49 | 148 | ocd-division/country:fi/kunta:inari | 2020-06-15T15:05:54.921817+03:00 | muni | Inari | Enare | ||||||
50 | 149 | ocd-division/country:fi/kunta:inkoo | 2020-06-15T15:05:54.928267+03:00 | muni | Inkoo | Ingå | ||||||
51 | 151 | ocd-division/country:fi/kunta:isojoki | 2020-06-15T15:05:54.933721+03:00 | muni | Isojoki | Storå | ||||||
52 | 152 | ocd-division/country:fi/kunta:isokyrö | 2020-06-15T15:05:54.939662+03:00 | muni | Isokyrö | Storkyro | ||||||
53 | 153 | ocd-division/country:fi/kunta:imatra | 2020-06-15T15:05:54.946056+03:00 | muni | Imatra | Imatra | ||||||
4 | 16 | ocd-division/country:fi/kunta:asikkala | 2020-06-15T15:05:54.618920+03:00 | muni | Asikkala | Asikkala | ||||||
54 | 165 | ocd-division/country:fi/kunta:janakkala | 2020-06-15T15:05:54.953398+03:00 | muni | Janakkala | Janakkala | ||||||
55 | 167 | ocd-division/country:fi/kunta:joensuu | 2020-06-15T15:05:54.959264+03:00 | muni | Joensuu | Joensuu | ||||||
56 | 169 | ocd-division/country:fi/kunta:jokioinen | 2020-06-15T15:05:54.965852+03:00 | muni | Jokioinen | Jockis | ||||||
57 | 170 | ocd-division/country:fi/kunta:jomala | 2020-06-15T15:05:54.971936+03:00 | muni | Jomala | Jomala | ||||||
58 | 171 | ocd-division/country:fi/kunta:joroinen | 2020-06-15T15:05:54.978318+03:00 | muni | Joroinen | Jorois | ||||||
59 | 172 | ocd-division/country:fi/kunta:joutsa | 2020-06-15T15:05:54.985508+03:00 | muni | Joutsa | Joutsa | ||||||
60 | 174 | ocd-division/country:fi/kunta:juankoski | 2020-06-15T15:05:54.991851+03:00 | muni | Juankoski | Juankoski | ||||||
61 | 176 | ocd-division/country:fi/kunta:juuka | 2020-06-15T15:05:54.998117+03:00 | muni | Juuka | Juuka | ||||||
62 | 177 | ocd-division/country:fi/kunta:juupajoki | 2020-06-15T15:05:55.004714+03:00 | muni | Juupajoki | Juupajoki | ||||||
63 | 178 | ocd-division/country:fi/kunta:juva | 2020-06-15T15:05:55.010338+03:00 | muni | Juva | Juva | ||||||
64 | 179 | ocd-division/country:fi/kunta:jyväskylä | 2020-06-15T15:05:55.015946+03:00 | muni | Jyväskylä | Jyväskylä | ||||||
5 | 18 | ocd-division/country:fi/kunta:askola | 2020-06-15T15:05:54.625382+03:00 | muni | Askola | Askola | ||||||
65 | 181 | ocd-division/country:fi/kunta:jämijärvi | 2020-06-15T15:05:55.021432+03:00 | muni | Jämijärvi | Jämijärvi | ||||||
66 | 182 | ocd-division/country:fi/kunta:jämsä | 2020-06-15T15:05:55.026596+03:00 | muni | Jämsä | Jämsä | ||||||
67 | 186 | ocd-division/country:fi/kunta:järvenpää | 2020-06-15T15:05:55.032407+03:00 | muni | Järvenpää | Träskända | ||||||
6 | 19 | ocd-division/country:fi/kunta:aura | 2020-06-15T15:05:54.631847+03:00 | muni | Aura | Aura | ||||||
306 | 20 | ocd-division/country:fi/kunta:akaa | 2020-06-15T15:05:56.752985+03:00 | muni | Akaa | Akaa | ||||||
68 | 202 | ocd-division/country:fi/kunta:kaarina | 2020-06-15T15:05:55.040937+03:00 | muni | Kaarina | S:t Karins | ||||||
69 | 204 | ocd-division/country:fi/kunta:kaavi | 2020-06-15T15:05:55.048523+03:00 | muni | Kaavi | Kaavi | ||||||
70 | 205 | ocd-division/country:fi/kunta:kajaani | 2020-06-15T15:05:55.056278+03:00 | muni | Kajaani | Kajana | ||||||
71 | 208 | ocd-division/country:fi/kunta:kalajoki | 2020-06-15T15:05:55.064122+03:00 | muni | Kalajoki | Kalajoki | ||||||
72 | 211 | ocd-division/country:fi/kunta:kangasala | 2020-06-15T15:05:55.073069+03:00 | muni | Kangasala | Kangasala | ||||||
73 | 213 | ocd-division/country:fi/kunta:kangasniemi | 2020-06-15T15:05:55.080977+03:00 | muni | Kangasniemi | Kangasniemi | ||||||
74 | 214 | ocd-division/country:fi/kunta:kankaanpää | 2020-06-15T15:05:55.089289+03:00 | muni | Kankaanpää | Kankaanpää | ||||||
75 | 216 | ocd-division/country:fi/kunta:kannonkoski | 2020-06-15T15:05:55.097708+03:00 | muni | Kannonkoski | Kannonkoski | ||||||
76 | 217 | ocd-division/country:fi/kunta:kannus | 2020-06-15T15:05:55.105279+03:00 | muni | Kannus | Kannus | ||||||
77 | 218 | ocd-division/country:fi/kunta:karijoki | 2020-06-15T15:05:55.113069+03:00 | muni | Karijoki | Bötom | ||||||
78 | 224 | ocd-division/country:fi/kunta:karkkila | 2020-06-15T15:05:55.120781+03:00 | muni | Karkkila | Högfors | ||||||
79 | 226 | ocd-division/country:fi/kunta:karstula | 2020-06-15T15:05:55.128686+03:00 | muni | Karstula | Karstula | ||||||
80 | 230 | ocd-division/country:fi/kunta:karvia | 2020-06-15T15:05:55.137628+03:00 | muni | Karvia | Karvia | ||||||
81 | 231 | ocd-division/country:fi/kunta:kaskinen | 2020-06-15T15:05:55.147035+03:00 | muni | Kaskinen | Kaskö | ||||||
82 | 232 | ocd-division/country:fi/kunta:kauhajoki | 2020-06-15T15:05:55.155806+03:00 | muni | Kauhajoki | Kauhajoki | ||||||
83 | 233 | ocd-division/country:fi/kunta:kauhava | 2020-06-15T15:05:55.164619+03:00 | muni | Kauhava | Kauhava | ||||||
84 | 235 | ocd-division/country:fi/kunta:kauniainen | 2020-06-15T15:05:55.172303+03:00 | muni | Kauniainen | Grankulla | ||||||
85 | 236 | ocd-division/country:fi/kunta:kaustinen | 2020-06-15T15:05:55.179019+03:00 | muni | Kaustinen | Kaustby | ||||||
86 | 239 | ocd-division/country:fi/kunta:keitele | 2020-06-15T15:05:55.185228+03:00 | muni | Keitele | Keitele | ||||||
87 | 240 | ocd-division/country:fi/kunta:kemi | 2020-06-15T15:05:55.191447+03:00 | muni | Kemi | Kemi | ||||||
88 | 241 | ocd-division/country:fi/kunta:keminmaa | 2020-06-15T15:05:55.197978+03:00 | muni | Keminmaa | Keminmaa | ||||||
89 | 244 | ocd-division/country:fi/kunta:kempele | 2020-06-15T15:05:55.206483+03:00 | muni | Kempele | Kempele | ||||||
90 | 245 | ocd-division/country:fi/kunta:kerava | 2020-06-15T15:05:55.213885+03:00 | muni | Kerava | Kervo | ||||||
91 | 249 | ocd-division/country:fi/kunta:keuruu | 2020-06-15T15:05:55.221049+03:00 | muni | Keuruu | Keuruu | ||||||
92 | 250 | ocd-division/country:fi/kunta:kihniö | 2020-06-15T15:05:55.228789+03:00 | muni | Kihniö | Kihniö | ||||||
93 | 256 | ocd-division/country:fi/kunta:kinnula | 2020-06-15T15:05:55.237160+03:00 | muni | Kinnula | Kinnula | ||||||
94 | 257 | ocd-division/country:fi/kunta:kirkkonummi | 2020-06-15T15:05:55.244739+03:00 | muni | Kirkkonummi | Kyrkslätt | ||||||
95 | 260 | ocd-division/country:fi/kunta:kitee | 2020-06-15T15:05:55.251141+03:00 | muni | Kitee | Kitee | ||||||
96 | 261 | ocd-division/country:fi/kunta:kittilä | 2020-06-15T15:05:55.258913+03:00 | muni | Kittilä | Kittilä | ||||||
97 | 263 | ocd-division/country:fi/kunta:kiuruvesi | 2020-06-15T15:05:55.265000+03:00 | muni | Kiuruvesi | Kiuruvesi | ||||||
98 | 265 | ocd-division/country:fi/kunta:kivijärvi | 2020-06-15T15:05:55.271141+03:00 | muni | Kivijärvi | Kivijärvi | ||||||
99 | 271 | ocd-division/country:fi/kunta:kokemäki | 2020-06-15T15:05:55.277269+03:00 | muni | Kokemäki | Kumo | ||||||
100 | 272 | ocd-division/country:fi/kunta:kokkola | 2020-06-15T15:05:55.283428+03:00 | muni | Kokkola | Karleby | ||||||
101 | 273 | ocd-division/country:fi/kunta:kolari | 2020-06-15T15:05:55.290120+03:00 | muni | Kolari | Kolari | ||||||
102 | 275 | ocd-division/country:fi/kunta:konnevesi | 2020-06-15T15:05:55.298636+03:00 | muni | Konnevesi | Konnevesi | ||||||
103 | 276 | ocd-division/country:fi/kunta:kontiolahti | 2020-06-15T15:05:55.306193+03:00 | muni | Kontiolahti | Kontiolahti | ||||||
104 | 280 | ocd-division/country:fi/kunta:korsnäs | 2020-06-15T15:05:55.312969+03:00 | muni | Korsnäs | Korsnäs | ||||||
105 | 284 | ocd-division/country:fi/kunta:koski_tl | 2020-06-15T15:05:55.319228+03:00 | muni | Koski Tl | Koski Tl | ||||||
106 | 285 | ocd-division/country:fi/kunta:kotka | 2020-06-15T15:05:55.325799+03:00 | muni | Kotka | Kotka | ||||||
107 | 286 | ocd-division/country:fi/kunta:kouvola | 2020-06-15T15:05:55.331845+03:00 | muni | Kouvola | Kouvola | ||||||
108 | 287 | ocd-division/country:fi/kunta:kristiinankaupunki | 2020-06-15T15:05:55.340177+03:00 | muni | Kristiinankaupunki | Kristinestad | ||||||
109 | 288 | ocd-division/country:fi/kunta:kruunupyy | 2020-06-15T15:05:55.349360+03:00 | muni | Kruunupyy | Kronoby | ||||||
110 | 290 | ocd-division/country:fi/kunta:kuhmo | 2020-06-15T15:05:55.356965+03:00 | muni | Kuhmo | Kuhmo | ||||||
111 | 291 | ocd-division/country:fi/kunta:kuhmoinen | 2020-06-15T15:05:55.364767+03:00 | muni | Kuhmoinen | Kuhmoinen | ||||||
112 | 295 | ocd-division/country:fi/kunta:kumlinge | 2020-06-15T15:05:55.373863+03:00 | muni | Kumlinge | Kumlinge | ||||||
113 | 297 | ocd-division/country:fi/kunta:kuopio | 2020-06-15T15:05:55.382394+03:00 | muni | Kuopio | Kuopio | ||||||
114 | 300 | ocd-division/country:fi/kunta:kuortane | 2020-06-15T15:05:55.391358+03:00 | muni | Kuortane | Kuortane | ||||||
115 | 301 | ocd-division/country:fi/kunta:kurikka | 2020-06-15T15:05:55.400048+03:00 | muni | Kurikka | Kurikka | ||||||
116 | 304 | ocd-division/country:fi/kunta:kustavi | 2020-06-15T15:05:55.410814+03:00 | muni | Kustavi | Gustavs | ||||||
117 | 305 | ocd-division/country:fi/kunta:kuusamo | 2020-06-15T15:05:55.421592+03:00 | muni | Kuusamo | Kuusamo | ||||||
118 | 309 | ocd-division/country:fi/kunta:outokumpu | 2020-06-15T15:05:55.429891+03:00 | muni | Outokumpu | Outokumpu | ||||||
119 | 312 | ocd-division/country:fi/kunta:kyyjärvi | 2020-06-15T15:05:55.439258+03:00 | muni | Kyyjärvi | Kyyjärvi | ||||||
120 | 316 | ocd-division/country:fi/kunta:kärkölä | 2020-06-15T15:05:55.448374+03:00 | muni | Kärkölä | Kärkölä | ||||||
121 | 317 | ocd-division/country:fi/kunta:kärsämäki | 2020-06-15T15:05:55.458022+03:00 | muni | Kärsämäki | Kärsämäki | ||||||
122 | 318 | ocd-division/country:fi/kunta:kökar | 2020-06-15T15:05:55.466947+03:00 | muni | Kökar | Kökar | ||||||
123 | 320 | ocd-division/country:fi/kunta:kemijärvi | 2020-06-15T15:05:55.475396+03:00 | muni | Kemijärvi | Kemijärvi | ||||||
307 | 322 | ocd-division/country:fi/kunta:kemiönsaari | 2020-06-15T15:05:56.758532+03:00 | muni | Kemiönsaari | Kimitoön | ||||||
7 | 35 | ocd-division/country:fi/kunta:brändö | 2020-06-15T15:05:54.640099+03:00 | muni | Brändö | Brändö |
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 );