2,760 rows

View and edit SQL

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ä  

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