administrative_division
2,760 rows sorted by ocd_id descending
This data as json, CSV (advanced)
Suggested facets: end, type, municipality, end (date), modified_at (date)
start (date) ✖
- 2021-07-01 263
- 2021-08-01 190
- 2020-08-01 186
- 2020-07-01 70
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 |
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 );