administrative_division
318 rows where "modified_at" is on date 2020-06-15 sorted by id descending
This data as json, CSV (advanced)
id ▲ | origin_id | ocd_id | service_point_id | start | end | modified_at | type | parent | municipality | name_fi | name_sv | name |
---|---|---|---|---|---|---|---|---|---|---|---|---|
1122 | 051A | ocd-division/country:fi/kunta:helsinki/äänestysalue:051a | 52761 | 2020-06-15T15:06:16.274146+03:00 | voting_district | 32 | helsinki | Santahamina | ||||
1116 | 047K | ocd-division/country:fi/kunta:helsinki/äänestysalue:047k | 52480 | 2020-06-15T15:06:16.253083+03:00 | voting_district | 32 | helsinki | Kivikko | ||||
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 | ||||
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 | ||||
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 | ||||
313 | 946 | ocd-division/country:fi/kunta:vöyri | 2020-06-15T15:05:56.799283+03:00 | muni | Vöyri | Vörå | ||||||
312 | 791 | ocd-division/country:fi/kunta:siikalatva | 2020-06-15T15:05:56.792447+03:00 | muni | Siikalatva | Siikalatva | ||||||
311 | 445 | ocd-division/country:fi/kunta:parainen | 2020-06-15T15:05:56.784569+03:00 | muni | Parainen | Pargas | ||||||
310 | 790 | ocd-division/country:fi/kunta:sastamala | 2020-06-15T15:05:56.778283+03:00 | muni | Sastamala | Sastamala | ||||||
309 | 508 | ocd-division/country:fi/kunta:mänttä-vilppula | 2020-06-15T15:05:56.773129+03:00 | muni | Mänttä-Vilppula | Mänttä-Vilppula | ||||||
308 | 710 | ocd-division/country:fi/kunta:raasepori | 2020-06-15T15:05:56.767271+03:00 | muni | Raasepori | Raseborg | ||||||
307 | 322 | ocd-division/country:fi/kunta:kemiönsaari | 2020-06-15T15:05:56.758532+03:00 | muni | Kemiönsaari | Kimitoön | ||||||
306 | 20 | ocd-division/country:fi/kunta:akaa | 2020-06-15T15:05:56.752985+03:00 | muni | Akaa | Akaa | ||||||
305 | 638 | ocd-division/country:fi/kunta:porvoo | 2020-06-15T15:05:56.746305+03:00 | muni | Porvoo | Borgå | ||||||
304 | 444 | ocd-division/country:fi/kunta:lohja | 2020-06-15T15:05:56.739937+03:00 | muni | Lohja | Lojo | ||||||
303 | 111 | ocd-division/country:fi/kunta:heinola | 2020-06-15T15:05:56.734262+03:00 | muni | Heinola | Heinola | ||||||
302 | 992 | ocd-division/country:fi/kunta:äänekoski | 2020-06-15T15:05:56.728593+03:00 | muni | Äänekoski | Äänekoski | ||||||
301 | 989 | ocd-division/country:fi/kunta:ähtäri | 2020-06-15T15:05:56.723420+03:00 | muni | Ähtäri | Etseri | ||||||
300 | 981 | ocd-division/country:fi/kunta:ypäjä | 2020-06-15T15:05:56.718087+03:00 | muni | Ypäjä | Ypäjä | ||||||
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 | ||||||
298 | 977 | ocd-division/country:fi/kunta:ylivieska | 2020-06-15T15:05:56.705349+03:00 | muni | Ylivieska | Ylivieska | ||||||
297 | 976 | ocd-division/country:fi/kunta:ylitornio | 2020-06-15T15:05:56.697215+03:00 | muni | Ylitornio | Övertorneå | ||||||
296 | 941 | ocd-division/country:fi/kunta:vårdö | 2020-06-15T15:05:56.690551+03:00 | muni | Vårdö | Vårdö | ||||||
295 | 936 | ocd-division/country:fi/kunta:virrat | 2020-06-15T15:05:56.684284+03:00 | muni | Virrat | Virdois | ||||||
294 | 935 | ocd-division/country:fi/kunta:virolahti | 2020-06-15T15:05:56.678367+03:00 | muni | Virolahti | Virolahti | ||||||
293 | 934 | ocd-division/country:fi/kunta:vimpeli | 2020-06-15T15:05:56.672015+03:00 | muni | Vimpeli | Vimpeli | ||||||
292 | 931 | ocd-division/country:fi/kunta:viitasaari | 2020-06-15T15:05:56.663905+03:00 | muni | Viitasaari | Viitasaari | ||||||
291 | 927 | ocd-division/country:fi/kunta:vihti | 2020-06-15T15:05:56.657736+03:00 | muni | Vihti | Vichtis | ||||||
290 | 925 | ocd-division/country:fi/kunta:vieremä | 2020-06-15T15:05:56.651419+03:00 | muni | Vieremä | Vieremä | ||||||
289 | 924 | ocd-division/country:fi/kunta:veteli | 2020-06-15T15:05:56.645039+03:00 | muni | Veteli | Vetil | ||||||
288 | 922 | ocd-division/country:fi/kunta:vesilahti | 2020-06-15T15:05:56.638782+03:00 | muni | Vesilahti | Vesilahti | ||||||
287 | 921 | ocd-division/country:fi/kunta:vesanto | 2020-06-15T15:05:56.634027+03:00 | muni | Vesanto | Vesanto | ||||||
286 | 918 | ocd-division/country:fi/kunta:vehmaa | 2020-06-15T15:05:56.628844+03:00 | muni | Vehmaa | Vehmaa | ||||||
285 | 915 | ocd-division/country:fi/kunta:varkaus | 2020-06-15T15:05:56.623629+03:00 | muni | Varkaus | Varkaus | ||||||
284 | 911 | ocd-division/country:fi/kunta:valtimo | 2020-06-15T15:05:56.618891+03:00 | muni | Valtimo | Valtimo | ||||||
283 | 908 | ocd-division/country:fi/kunta:valkeakoski | 2020-06-15T15:05:56.614193+03:00 | muni | Valkeakoski | Valkeakoski | ||||||
282 | 905 | ocd-division/country:fi/kunta:vaasa | 2020-06-15T15:05:56.609665+03:00 | muni | Vaasa | Vasa | ||||||
281 | 895 | ocd-division/country:fi/kunta:uusikaupunki | 2020-06-15T15:05:56.604258+03:00 | muni | Uusikaupunki | Nystad | ||||||
280 | 893 | ocd-division/country:fi/kunta:uusikaarlepyy | 2020-06-15T15:05:56.599400+03:00 | muni | Uusikaarlepyy | Nykarleby | ||||||
279 | 892 | ocd-division/country:fi/kunta:uurainen | 2020-06-15T15:05:56.594508+03:00 | muni | Uurainen | Uurainen | ||||||
278 | 890 | ocd-division/country:fi/kunta:utsjoki | 2020-06-15T15:05:56.589320+03:00 | muni | Utsjoki | Utsjoki | ||||||
277 | 889 | ocd-division/country:fi/kunta:utajärvi | 2020-06-15T15:05:56.583762+03:00 | muni | Utajärvi | Utajärvi | ||||||
276 | 887 | ocd-division/country:fi/kunta:urjala | 2020-06-15T15:05:56.577450+03:00 | muni | Urjala | Urjala | ||||||
275 | 886 | ocd-division/country:fi/kunta:ulvila | 2020-06-15T15:05:56.571996+03:00 | muni | Ulvila | Ulvsby | ||||||
274 | 859 | ocd-division/country:fi/kunta:tyrnävä | 2020-06-15T15:05:56.566935+03:00 | muni | Tyrnävä | Tyrnävä | ||||||
273 | 858 | ocd-division/country:fi/kunta:tuusula | 2020-06-15T15:05:56.562152+03:00 | muni | Tuusula | Tusby | ||||||
272 | 857 | ocd-division/country:fi/kunta:tuusniemi | 2020-06-15T15:05:56.557087+03:00 | muni | Tuusniemi | Tuusniemi | ||||||
271 | 854 | ocd-division/country:fi/kunta:pello | 2020-06-15T15:05:56.551979+03:00 | muni | Pello | Pello | ||||||
270 | 853 | ocd-division/country:fi/kunta:turku | 2020-06-15T15:05:56.546956+03:00 | muni | Turku | Åbo | ||||||
269 | 851 | ocd-division/country:fi/kunta:tornio | 2020-06-15T15:05:56.541165+03:00 | muni | Tornio | Torneå | ||||||
268 | 850 | ocd-division/country:fi/kunta:toivakka | 2020-06-15T15:05:56.536365+03:00 | muni | Toivakka | Toivakka | ||||||
267 | 849 | ocd-division/country:fi/kunta:toholampi | 2020-06-15T15:05:56.531338+03:00 | muni | Toholampi | Toholampi | ||||||
266 | 848 | ocd-division/country:fi/kunta:tohmajärvi | 2020-06-15T15:05:56.526463+03:00 | muni | Tohmajärvi | Tohmajärvi | ||||||
265 | 846 | ocd-division/country:fi/kunta:teuva | 2020-06-15T15:05:56.519745+03:00 | muni | Teuva | Östermark | ||||||
264 | 845 | ocd-division/country:fi/kunta:tervola | 2020-06-15T15:05:56.515186+03:00 | muni | Tervola | Tervola | ||||||
263 | 844 | ocd-division/country:fi/kunta:tervo | 2020-06-15T15:05:56.510134+03:00 | muni | Tervo | Tervo | ||||||
262 | 837 | ocd-division/country:fi/kunta:tampere | 2020-06-15T15:05:56.505049+03:00 | muni | Tampere | Tammerfors | ||||||
261 | 834 | ocd-division/country:fi/kunta:tammela | 2020-06-15T15:05:56.499640+03:00 | muni | Tammela | Tammela | ||||||
260 | 833 | ocd-division/country:fi/kunta:taivassalo | 2020-06-15T15:05:56.493115+03:00 | muni | Taivassalo | Tövsala | ||||||
259 | 832 | ocd-division/country:fi/kunta:taivalkoski | 2020-06-15T15:05:56.488277+03:00 | muni | Taivalkoski | Taivalkoski | ||||||
258 | 831 | ocd-division/country:fi/kunta:taipalsaari | 2020-06-15T15:05:56.483245+03:00 | muni | Taipalsaari | Taipalsaari | ||||||
257 | 785 | ocd-division/country:fi/kunta:vaala | 2020-06-15T15:05:56.477483+03:00 | muni | Vaala | Vaala | ||||||
256 | 783 | ocd-division/country:fi/kunta:säkylä | 2020-06-15T15:05:56.471531+03:00 | muni | Säkylä | Säkylä | ||||||
255 | 781 | ocd-division/country:fi/kunta:sysmä | 2020-06-15T15:05:56.465725+03:00 | muni | Sysmä | Sysmä | ||||||
254 | 778 | ocd-division/country:fi/kunta:suonenjoki | 2020-06-15T15:05:56.458027+03:00 | muni | Suonenjoki | Suonenjoki | ||||||
253 | 777 | ocd-division/country:fi/kunta:suomussalmi | 2020-06-15T15:05:56.450806+03:00 | muni | Suomussalmi | Suomussalmi | ||||||
252 | 771 | ocd-division/country:fi/kunta:sund | 2020-06-15T15:05:56.443406+03:00 | muni | Sund | Sund | ||||||
251 | 768 | ocd-division/country:fi/kunta:sulkava | 2020-06-15T15:05:56.434387+03:00 | muni | Sulkava | Sulkava | ||||||
250 | 766 | ocd-division/country:fi/kunta:sottunga | 2020-06-15T15:05:56.427225+03:00 | muni | Sottunga | Sottunga | ||||||
249 | 765 | ocd-division/country:fi/kunta:sotkamo | 2020-06-15T15:05:56.419451+03:00 | muni | Sotkamo | Sotkamo | ||||||
248 | 762 | ocd-division/country:fi/kunta:sonkajärvi | 2020-06-15T15:05:56.412662+03:00 | muni | Sonkajärvi | Sonkajärvi | ||||||
247 | 761 | ocd-division/country:fi/kunta:somero | 2020-06-15T15:05:56.406044+03:00 | muni | Somero | Somero | ||||||
246 | 759 | ocd-division/country:fi/kunta:soini | 2020-06-15T15:05:56.399023+03:00 | muni | Soini | Soini | ||||||
245 | 758 | ocd-division/country:fi/kunta:sodankylä | 2020-06-15T15:05:56.390059+03:00 | muni | Sodankylä | Sodankylä | ||||||
244 | 755 | ocd-division/country:fi/kunta:siuntio | 2020-06-15T15:05:56.382717+03:00 | muni | Siuntio | Sjundeå | ||||||
243 | 753 | ocd-division/country:fi/kunta:sipoo | 2020-06-15T15:05:56.376422+03:00 | muni | Sipoo | Sibbo | ||||||
242 | 751 | ocd-division/country:fi/kunta:simo | 2020-06-15T15:05:56.370028+03:00 | muni | Simo | Simo | ||||||
241 | 749 | ocd-division/country:fi/kunta:siilinjärvi | 2020-06-15T15:05:56.363732+03:00 | muni | Siilinjärvi | Siilinjärvi | ||||||
240 | 748 | ocd-division/country:fi/kunta:siikajoki | 2020-06-15T15:05:56.357694+03:00 | muni | Siikajoki | Siikajoki | ||||||
239 | 747 | ocd-division/country:fi/kunta:siikainen | 2020-06-15T15:05:56.351296+03:00 | muni | Siikainen | Siikainen | ||||||
238 | 746 | ocd-division/country:fi/kunta:sievi | 2020-06-15T15:05:56.345260+03:00 | muni | Sievi | Sievi | ||||||
237 | 743 | ocd-division/country:fi/kunta:seinäjoki | 2020-06-15T15:05:56.338875+03:00 | muni | Seinäjoki | Seinäjoki | ||||||
236 | 742 | ocd-division/country:fi/kunta:savukoski | 2020-06-15T15:05:56.332564+03:00 | muni | Savukoski | Savukoski | ||||||
235 | 740 | ocd-division/country:fi/kunta:savonlinna | 2020-06-15T15:05:56.325547+03:00 | muni | Savonlinna | Nyslott | ||||||
234 | 739 | ocd-division/country:fi/kunta:savitaipale | 2020-06-15T15:05:56.318712+03:00 | muni | Savitaipale | Savitaipale | ||||||
233 | 738 | ocd-division/country:fi/kunta:sauvo | 2020-06-15T15:05:56.312380+03:00 | muni | Sauvo | Sagu | ||||||
232 | 736 | ocd-division/country:fi/kunta:saltvik | 2020-06-15T15:05:56.307109+03:00 | muni | Saltvik | Saltvik | ||||||
231 | 734 | ocd-division/country:fi/kunta:salo | 2020-06-15T15:05:56.301353+03:00 | muni | Salo | Salo | ||||||
230 | 732 | ocd-division/country:fi/kunta:salla | 2020-06-15T15:05:56.293973+03:00 | muni | Salla | Salla | ||||||
229 | 729 | ocd-division/country:fi/kunta:saarijärvi | 2020-06-15T15:05:56.288447+03:00 | muni | Saarijärvi | Saarijärvi | ||||||
228 | 707 | ocd-division/country:fi/kunta:rääkkylä | 2020-06-15T15:05:56.283303+03:00 | muni | Rääkkylä | Rääkkylä | ||||||
227 | 704 | ocd-division/country:fi/kunta:rusko | 2020-06-15T15:05:56.277504+03:00 | muni | Rusko | Rusko | ||||||
226 | 702 | ocd-division/country:fi/kunta:ruovesi | 2020-06-15T15:05:56.272323+03:00 | muni | Ruovesi | Ruovesi | ||||||
225 | 700 | ocd-division/country:fi/kunta:ruokolahti | 2020-06-15T15:05:56.266488+03:00 | muni | Ruokolahti | Ruokolahti | ||||||
224 | 698 | ocd-division/country:fi/kunta:rovaniemi | 2020-06-15T15:05:56.260614+03:00 | muni | Rovaniemi | Rovaniemi | ||||||
223 | 697 | ocd-division/country:fi/kunta:ristijärvi | 2020-06-15T15:05:56.255125+03:00 | muni | Ristijärvi | Ristijärvi | ||||||
222 | 694 | ocd-division/country:fi/kunta:riihimäki | 2020-06-15T15:05:56.249562+03:00 | muni | Riihimäki | Riihimäki | ||||||
221 | 691 | ocd-division/country:fi/kunta:reisjärvi | 2020-06-15T15:05:56.243975+03:00 | muni | Reisjärvi | Reisjärvi | ||||||
220 | 689 | ocd-division/country:fi/kunta:rautjärvi | 2020-06-15T15:05:56.237769+03:00 | muni | Rautjärvi | Rautjärvi | ||||||
219 | 687 | ocd-division/country:fi/kunta:rautavaara | 2020-06-15T15:05:56.229573+03:00 | muni | Rautavaara | Rautavaara |
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 );