administrative_division

2,760 rows sorted by ocd_id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: start, type, municipality, start (date), end (date), modified_at (date)

end ✖

id origin_id ocd_id ▲ service_point_id start end modified_at type parent municipality name_fi name_sv name
1748 2351004009 ocd-division/country:fi/tilastoalue:2351004009       2020-12-07T13:38:51.354546+02:00 statistical_district          
1755 2351004008 ocd-division/country:fi/tilastoalue:2351004008       2020-12-07T13:38:51.380595+02:00 statistical_district          
1753 2351003007 ocd-division/country:fi/tilastoalue:2351003007       2020-12-07T13:38:51.372675+02:00 statistical_district          
1747 2351003006 ocd-division/country:fi/tilastoalue:2351003006       2020-12-07T13:38:51.350056+02:00 statistical_district          
1754 2351002005 ocd-division/country:fi/tilastoalue:2351002005       2020-12-07T13:38:51.376754+02:00 statistical_district          
1752 2351002004 ocd-division/country:fi/tilastoalue:2351002004       2020-12-07T13:38:51.368965+02:00 statistical_district          
1749 2351001003 ocd-division/country:fi/tilastoalue:2351001003       2020-12-07T13:38:51.358335+02:00 statistical_district          
1750 2351001002 ocd-division/country:fi/tilastoalue:2351001002       2020-12-07T13:38:51.361899+02:00 statistical_district          
1751 2351001001 ocd-division/country:fi/tilastoalue:2351001001       2020-12-07T13:38:51.365468+02:00 statistical_district          
2004 0927098000 ocd-division/country:fi/tilastoalue:0927098000       2020-12-07T13:38:52.452962+02:00 statistical_district     Sotunki    
2005 0927097000 ocd-division/country:fi/tilastoalue:0927097000       2020-12-07T13:38:52.458323+02:00 statistical_district     Kuninkaanmäki    
2006 0927096000 ocd-division/country:fi/tilastoalue:0927096000       2020-12-07T13:38:52.464039+02:00 statistical_district     Itä-Hakkila    
2033 0927095000 ocd-division/country:fi/tilastoalue:0927095000       2020-12-07T13:38:51.764933+02:00 statistical_district     Rajakylä    
2030 0927094000 ocd-division/country:fi/tilastoalue:0927094000       2020-12-07T13:38:52.598402+02:00 statistical_district     Hakunila    
2032 0927093000 ocd-division/country:fi/tilastoalue:0927093000       2020-12-07T13:38:52.612156+02:00 statistical_district     Vaarala    
2031 0927092000 ocd-division/country:fi/tilastoalue:0927092000       2020-12-07T13:38:52.605376+02:00 statistical_district     Ojanko    
2034 0927091000 ocd-division/country:fi/tilastoalue:0927091000       2020-12-07T13:38:51.840211+02:00 statistical_district     Länsimäki    
2035 0927090000 ocd-division/country:fi/tilastoalue:0927090000       2020-12-07T13:38:52.617830+02:00 statistical_district     Länsisalmi    
2029 0926088000 ocd-division/country:fi/tilastoalue:0926088000       2020-12-07T13:38:52.592661+02:00 statistical_district     Vallinoja    
2027 0926087000 ocd-division/country:fi/tilastoalue:0926087000       2020-12-07T13:38:52.582468+02:00 statistical_district     Vierumäki    
2013 0926086000 ocd-division/country:fi/tilastoalue:0926086000       2020-12-07T13:38:52.499351+02:00 statistical_district     Nikinmäki    
2036 0926085000 ocd-division/country:fi/tilastoalue:0926085000       2020-12-07T13:38:52.622491+02:00 statistical_district     Jokivarsi    
2014 0926084000 ocd-division/country:fi/tilastoalue:0926084000       2020-12-07T13:38:52.505391+02:00 statistical_district     Leppäkorpi    
2015 0926083000 ocd-division/country:fi/tilastoalue:0926083000       2020-12-07T13:38:52.511178+02:00 statistical_district     Metsola    
2017 0926082000 ocd-division/country:fi/tilastoalue:0926082000       2020-12-07T13:38:51.554882+02:00 statistical_district     Mikkola    
2028 0926081000 ocd-division/country:fi/tilastoalue:0926081000       2020-12-07T13:38:52.587163+02:00 statistical_district     Korso    
2016 0926080000 ocd-division/country:fi/tilastoalue:0926080000       2020-12-07T13:38:51.540012+02:00 statistical_district     Matari    
2026 0925075000 ocd-division/country:fi/tilastoalue:0925075000       2020-12-07T13:38:52.577372+02:00 statistical_district     Päiväkumpu    
2025 0925074000 ocd-division/country:fi/tilastoalue:0925074000       2020-12-07T13:38:52.569890+02:00 statistical_district     Havukoski    
2018 0925073000 ocd-division/country:fi/tilastoalue:0925073000       2020-12-07T13:38:52.517032+02:00 statistical_district     Rekola    
2037 0925072000 ocd-division/country:fi/tilastoalue:0925072000       2020-12-07T13:38:52.626832+02:00 statistical_district     Asola    
2038 0925071000 ocd-division/country:fi/tilastoalue:0925071000       2020-12-07T13:38:52.631160+02:00 statistical_district     Ilola    
2024 0925070000 ocd-division/country:fi/tilastoalue:0925070000       2020-12-07T13:38:52.563488+02:00 statistical_district     Koivukylä    
2011 0924069000 ocd-division/country:fi/tilastoalue:0924069000       2020-12-07T13:38:52.776318+02:00 statistical_district     Helsingin pitäjän kirkonkylä    
2010 0924068000 ocd-division/country:fi/tilastoalue:0924068000       2020-12-07T13:38:52.486056+02:00 statistical_district     Koivuhaka    
2021 0924067000 ocd-division/country:fi/tilastoalue:0924067000       2020-12-07T13:38:52.543775+02:00 statistical_district     Ruskeasanta    
2039 0924066000 ocd-division/country:fi/tilastoalue:0924066000       2020-12-07T13:38:52.649026+02:00 statistical_district     Hakkila    
2022 0924065000 ocd-division/country:fi/tilastoalue:0924065000       2020-12-07T13:38:52.550963+02:00 statistical_district     Simonkylä    
2007 0924064000 ocd-division/country:fi/tilastoalue:0924064000       2020-12-07T13:38:52.770719+02:00 statistical_district     Kuninkaala    
2009 0924063000 ocd-division/country:fi/tilastoalue:0924063000       2020-12-07T13:38:52.480312+02:00 statistical_district     Viertola    
2040 0924062000 ocd-division/country:fi/tilastoalue:0924062000       2020-12-07T13:38:52.635401+02:00 statistical_district     Jokiniemi    
2008 0924061000 ocd-division/country:fi/tilastoalue:0924061000       2020-12-07T13:38:52.474908+02:00 statistical_district     Tikkurila    
2023 0924060000 ocd-division/country:fi/tilastoalue:0924060000       2020-12-07T13:38:52.557936+02:00 statistical_district     Hiekkaharju    
2045 0923053000 ocd-division/country:fi/tilastoalue:0923053000       2020-12-07T13:38:52.679996+02:00 statistical_district     Lentokenttä    
2046 0923052000 ocd-division/country:fi/tilastoalue:0923052000       2020-12-07T13:38:52.685710+02:00 statistical_district     Veromies    
2020 0923051000 ocd-division/country:fi/tilastoalue:0923051000       2020-12-07T13:38:52.535335+02:00 statistical_district     Pakkala    
2012 0923050000 ocd-division/country:fi/tilastoalue:0923050000       2020-12-07T13:38:52.492738+02:00 statistical_district     Tammisto    
2044 0923041000 ocd-division/country:fi/tilastoalue:0923041000       2020-12-07T13:38:52.662074+02:00 statistical_district     Viinikkala    
2019 0923040000 ocd-division/country:fi/tilastoalue:0923040000       2020-12-07T13:38:52.523146+02:00 statistical_district     Ylästö    
2003 0922034000 ocd-division/country:fi/tilastoalue:0922034000       2020-12-07T13:38:52.447506+02:00 statistical_district     Kiila    
1996 0922033000 ocd-division/country:fi/tilastoalue:0922033000       2020-12-07T13:38:52.420153+02:00 statistical_district     Seutula    
2041 0922032000 ocd-division/country:fi/tilastoalue:0922032000       2020-12-07T13:38:52.641954+02:00 statistical_district     Riipilä    
1994 0922031000 ocd-division/country:fi/tilastoalue:0922031000       2020-12-07T13:38:52.411391+02:00 statistical_district     Luhtaanmäki    
1995 0922030000 ocd-division/country:fi/tilastoalue:0922030000       2020-12-07T13:38:52.415935+02:00 statistical_district     Vestra    
2002 0922025000 ocd-division/country:fi/tilastoalue:0922025000       2020-12-07T13:38:52.442232+02:00 statistical_district     Myllymäki    
2042 0922024000 ocd-division/country:fi/tilastoalue:0922024000       2020-12-07T13:38:52.655796+02:00 statistical_district     Lapinkylä    
1992 0922023000 ocd-division/country:fi/tilastoalue:0922023000       2020-12-07T13:38:52.754373+02:00 statistical_district     Kivistö    
1998 0922022000 ocd-division/country:fi/tilastoalue:0922022000       2020-12-07T13:38:52.429652+02:00 statistical_district     Keimola    
1993 0922021000 ocd-division/country:fi/tilastoalue:0922021000       2020-12-07T13:38:52.760023+02:00 statistical_district     Piispankylä    
2043 0921026000 ocd-division/country:fi/tilastoalue:0921026000       2020-12-07T13:38:52.061969+02:00 statistical_district     Petikko    
1999 0921020000 ocd-division/country:fi/tilastoalue:0921020000       2020-12-07T13:38:52.020051+02:00 statistical_district     Askisto    
2051 0921018000 ocd-division/country:fi/tilastoalue:0921018000       2020-12-07T13:38:52.748801+02:00 statistical_district     Vantaanlaakso    
2052 0921017000 ocd-division/country:fi/tilastoalue:0921017000       2020-12-07T13:38:52.738049+02:00 statistical_district     Martinlaakso    
1997 0921016000 ocd-division/country:fi/tilastoalue:0921016000       2020-12-07T13:38:52.425247+02:00 statistical_district     Kaivoksela    
2047 0921015000 ocd-division/country:fi/tilastoalue:0921015000       2020-12-07T13:38:52.691225+02:00 statistical_district     Myyrmäki    
2000 0921014000 ocd-division/country:fi/tilastoalue:0921014000       2020-12-07T13:38:52.732598+02:00 statistical_district     Varisto    
2001 0921013000 ocd-division/country:fi/tilastoalue:0921013000       2020-12-07T13:38:52.436791+02:00 statistical_district     Vapaala    
2048 0921012000 ocd-division/country:fi/tilastoalue:0921012000       2020-12-07T13:38:52.701765+02:00 statistical_district     Hämeenkylä    
2049 0921011000 ocd-division/country:fi/tilastoalue:0921011000       2020-12-07T13:38:52.711436+02:00 statistical_district     Hämevaara    
2050 0921010000 ocd-division/country:fi/tilastoalue:0921010000       2020-12-07T13:38:52.716598+02:00 statistical_district     Linnainen    
1865 0918801592 ocd-division/country:fi/tilastoalue:0918801592       2020-12-07T13:38:51.853689+02:00 statistical_district     Puroniitty    
1864 0918801591 ocd-division/country:fi/tilastoalue:0918801591       2020-12-07T13:38:51.849271+02:00 statistical_district     Landbo    
1863 0918801580 ocd-division/country:fi/tilastoalue:0918801580       2020-12-07T13:38:51.844533+02:00 statistical_district     Karhusaari    
1862 0918801570 ocd-division/country:fi/tilastoalue:0918801570       2020-12-07T13:38:51.835943+02:00 statistical_district     Talosaari    
1897 0918801560 ocd-division/country:fi/tilastoalue:0918801560       2020-12-07T13:38:52.000147+02:00 statistical_district     Salmenkallio    
1896 0918801550 ocd-division/country:fi/tilastoalue:0918801550       2020-12-07T13:38:51.993629+02:00 statistical_district     Östersundom    
1895 0917704549 ocd-division/country:fi/tilastoalue:0917704549       2020-12-07T13:38:51.988862+02:00 statistical_district     Mustavuori    
1894 0917704548 ocd-division/country:fi/tilastoalue:0917704548       2020-12-07T13:38:51.984111+02:00 statistical_district     Niinisaari    
1893 0917704547 ocd-division/country:fi/tilastoalue:0917704547       2020-12-07T13:38:51.979017+02:00 statistical_district     Rastila    
1892 0917704546 ocd-division/country:fi/tilastoalue:0917704546       2020-12-07T13:38:51.973848+02:00 statistical_district     Aurinkolahti    
1891 0917704545 ocd-division/country:fi/tilastoalue:0917704545       2020-12-07T13:38:51.969077+02:00 statistical_district     Kallahti    
1890 0917704544 ocd-division/country:fi/tilastoalue:0917704544       2020-12-07T13:38:51.964712+02:00 statistical_district     Meri-Rastila    
1889 0917704543 ocd-division/country:fi/tilastoalue:0917704543       2020-12-07T13:38:51.960420+02:00 statistical_district     Uutela    
1888 0917704542 ocd-division/country:fi/tilastoalue:0917704542       2020-12-07T13:38:51.955332+02:00 statistical_district     Nordsjön kartano    
1887 0917704541 ocd-division/country:fi/tilastoalue:0917704541       2020-12-07T13:38:51.950222+02:00 statistical_district     Keski-Vuosaari    
1850 0917703475 ocd-division/country:fi/tilastoalue:0917703475       2020-12-07T13:38:51.777200+02:00 statistical_district     Kurkimäki    
1849 0917703474 ocd-division/country:fi/tilastoalue:0917703474       2020-12-07T13:38:51.771022+02:00 statistical_district     Kivikko    
1848 0917703473 ocd-division/country:fi/tilastoalue:0917703473       2020-12-07T13:38:51.758981+02:00 statistical_district     Mellunmäki    
1847 0917703472 ocd-division/country:fi/tilastoalue:0917703472       2020-12-07T13:38:51.752641+02:00 statistical_district     Vesala    
1846 0917703471 ocd-division/country:fi/tilastoalue:0917703471       2020-12-07T13:38:51.747281+02:00 statistical_district     Kontula    
1925 0917702454 ocd-division/country:fi/tilastoalue:0917702454       2020-12-07T13:38:52.110557+02:00 statistical_district     Myllypuro    
1942 0917701457 ocd-division/country:fi/tilastoalue:0917701457       2020-12-07T13:38:52.174194+02:00 statistical_district     Itäkeskus    
1875 0917701456 ocd-division/country:fi/tilastoalue:0917701456       2020-12-07T13:38:51.901504+02:00 statistical_district     Roihupelto    
1874 0917701455 ocd-division/country:fi/tilastoalue:0917701455       2020-12-07T13:38:51.893183+02:00 statistical_district     Marjaniemi    
1924 0917701453 ocd-division/country:fi/tilastoalue:0917701453       2020-12-07T13:38:52.106752+02:00 statistical_district     Puotinharju    
1923 0917701452 ocd-division/country:fi/tilastoalue:0917701452       2020-12-07T13:38:52.103080+02:00 statistical_district     Puotila    
1922 0917701451 ocd-division/country:fi/tilastoalue:0917701451       2020-12-07T13:38:52.099187+02:00 statistical_district     Vartioharju    
1886 0916603533 ocd-division/country:fi/tilastoalue:0916603533       2020-12-07T13:38:51.946074+02:00 statistical_district     Aluemeri    
1885 0916603532 ocd-division/country:fi/tilastoalue:0916603532       2020-12-07T13:38:51.942207+02:00 statistical_district     Itäsaaret    
1882 0916603510 ocd-division/country:fi/tilastoalue:0916603510       2020-12-07T13:38:51.929971+02:00 statistical_district     Santahamina    

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