administrative_division
2,760 rows
This data as json, CSV (advanced)
start (date) ✖
- 2021-07-01 263
- 2021-08-01 190
- 2020-08-01 186
- 2020-07-01 70
end (date) ✖
- 2022-08-01 453
- 2021-08-01 256
id ▼ | origin_id | ocd_id | service_point_id | start | end | modified_at | type | parent | municipality | name_fi | name_sv | name |
---|---|---|---|---|---|---|---|---|---|---|---|---|
201 | 615 | ocd-division/country:fi/kunta:pudasjärvi | 2020-06-15T15:05:56.085605+03:00 | muni | Pudasjärvi | Pudasjärvi | ||||||
202 | 616 | ocd-division/country:fi/kunta:pukkila | 2020-06-15T15:05:56.092249+03:00 | muni | Pukkila | Pukkila | ||||||
203 | 619 | ocd-division/country:fi/kunta:punkalaidun | 2020-06-15T15:05:56.100367+03:00 | muni | Punkalaidun | Punkalaidun | ||||||
204 | 620 | ocd-division/country:fi/kunta:puolanka | 2020-06-15T15:05:56.108986+03:00 | muni | Puolanka | Puolanka | ||||||
205 | 623 | ocd-division/country:fi/kunta:puumala | 2020-06-15T15:05:56.116884+03:00 | muni | Puumala | Puumala | ||||||
206 | 624 | ocd-division/country:fi/kunta:pyhtää | 2020-06-15T15:05:56.124764+03:00 | muni | Pyhtää | Pyttis | ||||||
207 | 625 | ocd-division/country:fi/kunta:pyhäjoki | 2020-06-15T15:05:56.132198+03:00 | muni | Pyhäjoki | Pyhäjoki | ||||||
208 | 626 | ocd-division/country:fi/kunta:pyhäjärvi | 2020-06-15T15:05:56.139685+03:00 | muni | Pyhäjärvi | Pyhäjärvi | ||||||
209 | 630 | ocd-division/country:fi/kunta:pyhäntä | 2020-06-15T15:05:56.147409+03:00 | muni | Pyhäntä | Pyhäntä | ||||||
210 | 631 | ocd-division/country:fi/kunta:pyhäranta | 2020-06-15T15:05:56.155677+03:00 | muni | Pyhäranta | Pyhäranta | ||||||
211 | 635 | ocd-division/country:fi/kunta:pälkäne | 2020-06-15T15:05:56.165602+03:00 | muni | Pälkäne | Pälkäne | ||||||
212 | 636 | ocd-division/country:fi/kunta:pöytyä | 2020-06-15T15:05:56.174680+03:00 | muni | Pöytyä | Pöytyä | ||||||
213 | 678 | ocd-division/country:fi/kunta:raahe | 2020-06-15T15:05:56.182900+03:00 | muni | Raahe | Brahestad | ||||||
214 | 680 | ocd-division/country:fi/kunta:raisio | 2020-06-15T15:05:56.191326+03:00 | muni | Raisio | Reso | ||||||
215 | 681 | ocd-division/country:fi/kunta:rantasalmi | 2020-06-15T15:05:56.200693+03:00 | muni | Rantasalmi | Rantasalmi | ||||||
216 | 683 | ocd-division/country:fi/kunta:ranua | 2020-06-15T15:05:56.208369+03:00 | muni | Ranua | Ranua | ||||||
217 | 684 | ocd-division/country:fi/kunta:rauma | 2020-06-15T15:05:56.215050+03:00 | muni | Rauma | Raumo | ||||||
218 | 686 | ocd-division/country:fi/kunta:rautalampi | 2020-06-15T15:05:56.221213+03:00 | muni | Rautalampi | Rautalampi | ||||||
219 | 687 | ocd-division/country:fi/kunta:rautavaara | 2020-06-15T15:05:56.229573+03:00 | muni | Rautavaara | Rautavaara | ||||||
220 | 689 | ocd-division/country:fi/kunta:rautjärvi | 2020-06-15T15:05:56.237769+03:00 | muni | Rautjärvi | Rautjärvi | ||||||
221 | 691 | ocd-division/country:fi/kunta:reisjärvi | 2020-06-15T15:05:56.243975+03:00 | muni | Reisjärvi | Reisjärvi | ||||||
222 | 694 | ocd-division/country:fi/kunta:riihimäki | 2020-06-15T15:05:56.249562+03:00 | muni | Riihimäki | Riihimäki | ||||||
223 | 697 | ocd-division/country:fi/kunta:ristijärvi | 2020-06-15T15:05:56.255125+03:00 | muni | Ristijärvi | Ristijärvi | ||||||
224 | 698 | ocd-division/country:fi/kunta:rovaniemi | 2020-06-15T15:05:56.260614+03:00 | muni | Rovaniemi | Rovaniemi | ||||||
225 | 700 | ocd-division/country:fi/kunta:ruokolahti | 2020-06-15T15:05:56.266488+03:00 | muni | Ruokolahti | Ruokolahti | ||||||
226 | 702 | ocd-division/country:fi/kunta:ruovesi | 2020-06-15T15:05:56.272323+03:00 | muni | Ruovesi | Ruovesi | ||||||
227 | 704 | ocd-division/country:fi/kunta:rusko | 2020-06-15T15:05:56.277504+03:00 | muni | Rusko | Rusko | ||||||
228 | 707 | ocd-division/country:fi/kunta:rääkkylä | 2020-06-15T15:05:56.283303+03:00 | muni | Rääkkylä | Rääkkylä | ||||||
229 | 729 | ocd-division/country:fi/kunta:saarijärvi | 2020-06-15T15:05:56.288447+03:00 | muni | Saarijärvi | Saarijärvi | ||||||
230 | 732 | ocd-division/country:fi/kunta:salla | 2020-06-15T15:05:56.293973+03:00 | muni | Salla | Salla | ||||||
231 | 734 | ocd-division/country:fi/kunta:salo | 2020-06-15T15:05:56.301353+03:00 | muni | Salo | Salo | ||||||
232 | 736 | ocd-division/country:fi/kunta:saltvik | 2020-06-15T15:05:56.307109+03:00 | muni | Saltvik | Saltvik | ||||||
233 | 738 | ocd-division/country:fi/kunta:sauvo | 2020-06-15T15:05:56.312380+03:00 | muni | Sauvo | Sagu | ||||||
234 | 739 | ocd-division/country:fi/kunta:savitaipale | 2020-06-15T15:05:56.318712+03:00 | muni | Savitaipale | Savitaipale | ||||||
235 | 740 | ocd-division/country:fi/kunta:savonlinna | 2020-06-15T15:05:56.325547+03:00 | muni | Savonlinna | Nyslott | ||||||
236 | 742 | ocd-division/country:fi/kunta:savukoski | 2020-06-15T15:05:56.332564+03:00 | muni | Savukoski | Savukoski | ||||||
237 | 743 | ocd-division/country:fi/kunta:seinäjoki | 2020-06-15T15:05:56.338875+03:00 | muni | Seinäjoki | Seinäjoki | ||||||
238 | 746 | ocd-division/country:fi/kunta:sievi | 2020-06-15T15:05:56.345260+03:00 | muni | Sievi | Sievi | ||||||
239 | 747 | ocd-division/country:fi/kunta:siikainen | 2020-06-15T15:05:56.351296+03:00 | muni | Siikainen | Siikainen | ||||||
240 | 748 | ocd-division/country:fi/kunta:siikajoki | 2020-06-15T15:05:56.357694+03:00 | muni | Siikajoki | Siikajoki | ||||||
241 | 749 | ocd-division/country:fi/kunta:siilinjärvi | 2020-06-15T15:05:56.363732+03:00 | muni | Siilinjärvi | Siilinjärvi | ||||||
242 | 751 | ocd-division/country:fi/kunta:simo | 2020-06-15T15:05:56.370028+03:00 | muni | Simo | Simo | ||||||
243 | 753 | ocd-division/country:fi/kunta:sipoo | 2020-06-15T15:05:56.376422+03:00 | muni | Sipoo | Sibbo | ||||||
244 | 755 | ocd-division/country:fi/kunta:siuntio | 2020-06-15T15:05:56.382717+03:00 | muni | Siuntio | Sjundeå | ||||||
245 | 758 | ocd-division/country:fi/kunta:sodankylä | 2020-06-15T15:05:56.390059+03:00 | muni | Sodankylä | Sodankylä | ||||||
246 | 759 | ocd-division/country:fi/kunta:soini | 2020-06-15T15:05:56.399023+03:00 | muni | Soini | Soini | ||||||
247 | 761 | ocd-division/country:fi/kunta:somero | 2020-06-15T15:05:56.406044+03:00 | muni | Somero | Somero | ||||||
248 | 762 | ocd-division/country:fi/kunta:sonkajärvi | 2020-06-15T15:05:56.412662+03:00 | muni | Sonkajärvi | Sonkajärvi | ||||||
249 | 765 | ocd-division/country:fi/kunta:sotkamo | 2020-06-15T15:05:56.419451+03:00 | muni | Sotkamo | Sotkamo | ||||||
250 | 766 | ocd-division/country:fi/kunta:sottunga | 2020-06-15T15:05:56.427225+03:00 | muni | Sottunga | Sottunga | ||||||
251 | 768 | ocd-division/country:fi/kunta:sulkava | 2020-06-15T15:05:56.434387+03:00 | muni | Sulkava | Sulkava | ||||||
252 | 771 | ocd-division/country:fi/kunta:sund | 2020-06-15T15:05:56.443406+03:00 | muni | Sund | Sund | ||||||
253 | 777 | ocd-division/country:fi/kunta:suomussalmi | 2020-06-15T15:05:56.450806+03:00 | muni | Suomussalmi | Suomussalmi | ||||||
254 | 778 | ocd-division/country:fi/kunta:suonenjoki | 2020-06-15T15:05:56.458027+03:00 | muni | Suonenjoki | Suonenjoki | ||||||
255 | 781 | ocd-division/country:fi/kunta:sysmä | 2020-06-15T15:05:56.465725+03:00 | muni | Sysmä | Sysmä | ||||||
256 | 783 | ocd-division/country:fi/kunta:säkylä | 2020-06-15T15:05:56.471531+03:00 | muni | Säkylä | Säkylä | ||||||
257 | 785 | ocd-division/country:fi/kunta:vaala | 2020-06-15T15:05:56.477483+03:00 | muni | Vaala | Vaala | ||||||
258 | 831 | ocd-division/country:fi/kunta:taipalsaari | 2020-06-15T15:05:56.483245+03:00 | muni | Taipalsaari | Taipalsaari | ||||||
259 | 832 | ocd-division/country:fi/kunta:taivalkoski | 2020-06-15T15:05:56.488277+03:00 | muni | Taivalkoski | Taivalkoski | ||||||
260 | 833 | ocd-division/country:fi/kunta:taivassalo | 2020-06-15T15:05:56.493115+03:00 | muni | Taivassalo | Tövsala | ||||||
261 | 834 | ocd-division/country:fi/kunta:tammela | 2020-06-15T15:05:56.499640+03:00 | muni | Tammela | Tammela | ||||||
262 | 837 | ocd-division/country:fi/kunta:tampere | 2020-06-15T15:05:56.505049+03:00 | muni | Tampere | Tammerfors | ||||||
263 | 844 | ocd-division/country:fi/kunta:tervo | 2020-06-15T15:05:56.510134+03:00 | muni | Tervo | Tervo | ||||||
264 | 845 | ocd-division/country:fi/kunta:tervola | 2020-06-15T15:05:56.515186+03:00 | muni | Tervola | Tervola | ||||||
265 | 846 | ocd-division/country:fi/kunta:teuva | 2020-06-15T15:05:56.519745+03:00 | muni | Teuva | Östermark | ||||||
266 | 848 | ocd-division/country:fi/kunta:tohmajärvi | 2020-06-15T15:05:56.526463+03:00 | muni | Tohmajärvi | Tohmajärvi | ||||||
267 | 849 | ocd-division/country:fi/kunta:toholampi | 2020-06-15T15:05:56.531338+03:00 | muni | Toholampi | Toholampi | ||||||
268 | 850 | ocd-division/country:fi/kunta:toivakka | 2020-06-15T15:05:56.536365+03:00 | muni | Toivakka | Toivakka | ||||||
269 | 851 | ocd-division/country:fi/kunta:tornio | 2020-06-15T15:05:56.541165+03:00 | muni | Tornio | Torneå | ||||||
270 | 853 | ocd-division/country:fi/kunta:turku | 2020-06-15T15:05:56.546956+03:00 | muni | Turku | Åbo | ||||||
271 | 854 | ocd-division/country:fi/kunta:pello | 2020-06-15T15:05:56.551979+03:00 | muni | Pello | Pello | ||||||
272 | 857 | ocd-division/country:fi/kunta:tuusniemi | 2020-06-15T15:05:56.557087+03:00 | muni | Tuusniemi | Tuusniemi | ||||||
273 | 858 | ocd-division/country:fi/kunta:tuusula | 2020-06-15T15:05:56.562152+03:00 | muni | Tuusula | Tusby | ||||||
274 | 859 | ocd-division/country:fi/kunta:tyrnävä | 2020-06-15T15:05:56.566935+03:00 | muni | Tyrnävä | Tyrnävä | ||||||
275 | 886 | ocd-division/country:fi/kunta:ulvila | 2020-06-15T15:05:56.571996+03:00 | muni | Ulvila | Ulvsby | ||||||
276 | 887 | ocd-division/country:fi/kunta:urjala | 2020-06-15T15:05:56.577450+03:00 | muni | Urjala | Urjala | ||||||
277 | 889 | ocd-division/country:fi/kunta:utajärvi | 2020-06-15T15:05:56.583762+03:00 | muni | Utajärvi | Utajärvi | ||||||
278 | 890 | ocd-division/country:fi/kunta:utsjoki | 2020-06-15T15:05:56.589320+03:00 | muni | Utsjoki | Utsjoki | ||||||
279 | 892 | ocd-division/country:fi/kunta:uurainen | 2020-06-15T15:05:56.594508+03:00 | muni | Uurainen | Uurainen | ||||||
280 | 893 | ocd-division/country:fi/kunta:uusikaarlepyy | 2020-06-15T15:05:56.599400+03:00 | muni | Uusikaarlepyy | Nykarleby | ||||||
281 | 895 | ocd-division/country:fi/kunta:uusikaupunki | 2020-06-15T15:05:56.604258+03:00 | muni | Uusikaupunki | Nystad | ||||||
282 | 905 | ocd-division/country:fi/kunta:vaasa | 2020-06-15T15:05:56.609665+03:00 | muni | Vaasa | Vasa | ||||||
283 | 908 | ocd-division/country:fi/kunta:valkeakoski | 2020-06-15T15:05:56.614193+03:00 | muni | Valkeakoski | Valkeakoski | ||||||
284 | 911 | ocd-division/country:fi/kunta:valtimo | 2020-06-15T15:05:56.618891+03:00 | muni | Valtimo | Valtimo | ||||||
285 | 915 | ocd-division/country:fi/kunta:varkaus | 2020-06-15T15:05:56.623629+03:00 | muni | Varkaus | Varkaus | ||||||
286 | 918 | ocd-division/country:fi/kunta:vehmaa | 2020-06-15T15:05:56.628844+03:00 | muni | Vehmaa | Vehmaa | ||||||
287 | 921 | ocd-division/country:fi/kunta:vesanto | 2020-06-15T15:05:56.634027+03:00 | muni | Vesanto | Vesanto | ||||||
288 | 922 | ocd-division/country:fi/kunta:vesilahti | 2020-06-15T15:05:56.638782+03:00 | muni | Vesilahti | Vesilahti | ||||||
289 | 924 | ocd-division/country:fi/kunta:veteli | 2020-06-15T15:05:56.645039+03:00 | muni | Veteli | Vetil | ||||||
290 | 925 | ocd-division/country:fi/kunta:vieremä | 2020-06-15T15:05:56.651419+03:00 | muni | Vieremä | Vieremä | ||||||
291 | 927 | ocd-division/country:fi/kunta:vihti | 2020-06-15T15:05:56.657736+03:00 | muni | Vihti | Vichtis | ||||||
292 | 931 | ocd-division/country:fi/kunta:viitasaari | 2020-06-15T15:05:56.663905+03:00 | muni | Viitasaari | Viitasaari | ||||||
293 | 934 | ocd-division/country:fi/kunta:vimpeli | 2020-06-15T15:05:56.672015+03:00 | muni | Vimpeli | Vimpeli | ||||||
294 | 935 | ocd-division/country:fi/kunta:virolahti | 2020-06-15T15:05:56.678367+03:00 | muni | Virolahti | Virolahti | ||||||
295 | 936 | ocd-division/country:fi/kunta:virrat | 2020-06-15T15:05:56.684284+03:00 | muni | Virrat | Virdois | ||||||
296 | 941 | ocd-division/country:fi/kunta:vårdö | 2020-06-15T15:05:56.690551+03:00 | muni | Vårdö | Vårdö | ||||||
297 | 976 | ocd-division/country:fi/kunta:ylitornio | 2020-06-15T15:05:56.697215+03:00 | muni | Ylitornio | Övertorneå | ||||||
298 | 977 | ocd-division/country:fi/kunta:ylivieska | 2020-06-15T15:05:56.705349+03:00 | muni | Ylivieska | Ylivieska | ||||||
299 | 980 | ocd-division/country:fi/kunta:ylöjärvi | 2020-06-15T15:05:56.711916+03:00 | muni | Ylöjärvi | Ylöjärvi | ||||||
300 | 981 | ocd-division/country:fi/kunta:ypäjä | 2020-06-15T15:05:56.718087+03:00 | muni | Ypäjä | Ypäjä |
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 );