administrative_division
313 rows where type = "muni" sorted by origin_id
This data as json, CSV (advanced)
Suggested facets: modified_at (date)
| id | origin_id ▼ | ocd_id | service_point_id | start | end | modified_at | type | parent | municipality | name_fi | name_sv | name |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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ö | ||||||
| 124 | 398 | ocd-division/country:fi/kunta:lahti | 2020-06-15T15:05:55.484215+03:00 | muni | Lahti | Lahtis | ||||||
| 125 | 399 | ocd-division/country:fi/kunta:laihia | 2020-06-15T15:05:55.492203+03:00 | muni | Laihia | Laihela | ||||||
| 126 | 400 | ocd-division/country:fi/kunta:laitila | 2020-06-15T15:05:55.500171+03:00 | muni | Laitila | Laitila | ||||||
| 127 | 402 | ocd-division/country:fi/kunta:lapinlahti | 2020-06-15T15:05:55.509575+03:00 | muni | Lapinlahti | Lapinlahti | ||||||
| 128 | 403 | ocd-division/country:fi/kunta:lappajärvi | 2020-06-15T15:05:55.517535+03:00 | muni | Lappajärvi | Lappajärvi |
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 );