administrative_division

305 rows where type = "statistical_district" sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: modified_at (date)

type ✖

  • statistical_district · 305 ✖
id ▲ origin_id ocd_id service_point_id start end modified_at type parent municipality name_fi name_sv name
2052 0921017000 ocd-division/country:fi/tilastoalue:0921017000       2020-12-07T13:38:52.738049+02:00 statistical_district     Martinlaakso    
2051 0921018000 ocd-division/country:fi/tilastoalue:0921018000       2020-12-07T13:38:52.748801+02:00 statistical_district     Vantaanlaakso    
2050 0921010000 ocd-division/country:fi/tilastoalue:0921010000       2020-12-07T13:38:52.716598+02:00 statistical_district     Linnainen    
2049 0921011000 ocd-division/country:fi/tilastoalue:0921011000       2020-12-07T13:38:52.711436+02:00 statistical_district     Hämevaara    
2048 0921012000 ocd-division/country:fi/tilastoalue:0921012000       2020-12-07T13:38:52.701765+02:00 statistical_district     Hämeenkylä    
2047 0921015000 ocd-division/country:fi/tilastoalue:0921015000       2020-12-07T13:38:52.691225+02:00 statistical_district     Myyrmäki    
2046 0923052000 ocd-division/country:fi/tilastoalue:0923052000       2020-12-07T13:38:52.685710+02:00 statistical_district     Veromies    
2045 0923053000 ocd-division/country:fi/tilastoalue:0923053000       2020-12-07T13:38:52.679996+02:00 statistical_district     Lentokenttä    
2044 0923041000 ocd-division/country:fi/tilastoalue:0923041000       2020-12-07T13:38:52.662074+02:00 statistical_district     Viinikkala    
2043 0921026000 ocd-division/country:fi/tilastoalue:0921026000       2020-12-07T13:38:52.061969+02:00 statistical_district     Petikko    
2042 0922024000 ocd-division/country:fi/tilastoalue:0922024000       2020-12-07T13:38:52.655796+02:00 statistical_district     Lapinkylä    
2041 0922032000 ocd-division/country:fi/tilastoalue:0922032000       2020-12-07T13:38:52.641954+02:00 statistical_district     Riipilä    
2040 0924062000 ocd-division/country:fi/tilastoalue:0924062000       2020-12-07T13:38:52.635401+02:00 statistical_district     Jokiniemi    
2039 0924066000 ocd-division/country:fi/tilastoalue:0924066000       2020-12-07T13:38:52.649026+02:00 statistical_district     Hakkila    
2038 0925071000 ocd-division/country:fi/tilastoalue:0925071000       2020-12-07T13:38:52.631160+02:00 statistical_district     Ilola    
2037 0925072000 ocd-division/country:fi/tilastoalue:0925072000       2020-12-07T13:38:52.626832+02:00 statistical_district     Asola    
2036 0926085000 ocd-division/country:fi/tilastoalue:0926085000       2020-12-07T13:38:52.622491+02:00 statistical_district     Jokivarsi    
2035 0927090000 ocd-division/country:fi/tilastoalue:0927090000       2020-12-07T13:38:52.617830+02:00 statistical_district     Länsisalmi    
2034 0927091000 ocd-division/country:fi/tilastoalue:0927091000       2020-12-07T13:38:51.840211+02:00 statistical_district     Länsimäki    
2033 0927095000 ocd-division/country:fi/tilastoalue:0927095000       2020-12-07T13:38:51.764933+02:00 statistical_district     Rajakylä    
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    
2030 0927094000 ocd-division/country:fi/tilastoalue:0927094000       2020-12-07T13:38:52.598402+02:00 statistical_district     Hakunila    
2029 0926088000 ocd-division/country:fi/tilastoalue:0926088000       2020-12-07T13:38:52.592661+02:00 statistical_district     Vallinoja    
2028 0926081000 ocd-division/country:fi/tilastoalue:0926081000       2020-12-07T13:38:52.587163+02:00 statistical_district     Korso    
2027 0926087000 ocd-division/country:fi/tilastoalue:0926087000       2020-12-07T13:38:52.582468+02:00 statistical_district     Vierumäki    
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    
2024 0925070000 ocd-division/country:fi/tilastoalue:0925070000       2020-12-07T13:38:52.563488+02:00 statistical_district     Koivukylä    
2023 0924060000 ocd-division/country:fi/tilastoalue:0924060000       2020-12-07T13:38:52.557936+02:00 statistical_district     Hiekkaharju    
2022 0924065000 ocd-division/country:fi/tilastoalue:0924065000       2020-12-07T13:38:52.550963+02:00 statistical_district     Simonkylä    
2021 0924067000 ocd-division/country:fi/tilastoalue:0924067000       2020-12-07T13:38:52.543775+02:00 statistical_district     Ruskeasanta    
2020 0923051000 ocd-division/country:fi/tilastoalue:0923051000       2020-12-07T13:38:52.535335+02:00 statistical_district     Pakkala    
2019 0923040000 ocd-division/country:fi/tilastoalue:0923040000       2020-12-07T13:38:52.523146+02:00 statistical_district     Ylästö    
2018 0925073000 ocd-division/country:fi/tilastoalue:0925073000       2020-12-07T13:38:52.517032+02:00 statistical_district     Rekola    
2017 0926082000 ocd-division/country:fi/tilastoalue:0926082000       2020-12-07T13:38:51.554882+02:00 statistical_district     Mikkola    
2016 0926080000 ocd-division/country:fi/tilastoalue:0926080000       2020-12-07T13:38:51.540012+02:00 statistical_district     Matari    
2015 0926083000 ocd-division/country:fi/tilastoalue:0926083000       2020-12-07T13:38:52.511178+02:00 statistical_district     Metsola    
2014 0926084000 ocd-division/country:fi/tilastoalue:0926084000       2020-12-07T13:38:52.505391+02:00 statistical_district     Leppäkorpi    
2013 0926086000 ocd-division/country:fi/tilastoalue:0926086000       2020-12-07T13:38:52.499351+02:00 statistical_district     Nikinmäki    
2012 0923050000 ocd-division/country:fi/tilastoalue:0923050000       2020-12-07T13:38:52.492738+02:00 statistical_district     Tammisto    
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    
2009 0924063000 ocd-division/country:fi/tilastoalue:0924063000       2020-12-07T13:38:52.480312+02:00 statistical_district     Viertola    
2008 0924061000 ocd-division/country:fi/tilastoalue:0924061000       2020-12-07T13:38:52.474908+02:00 statistical_district     Tikkurila    
2007 0924064000 ocd-division/country:fi/tilastoalue:0924064000       2020-12-07T13:38:52.770719+02:00 statistical_district     Kuninkaala    
2006 0927096000 ocd-division/country:fi/tilastoalue:0927096000       2020-12-07T13:38:52.464039+02:00 statistical_district     Itä-Hakkila    
2005 0927097000 ocd-division/country:fi/tilastoalue:0927097000       2020-12-07T13:38:52.458323+02:00 statistical_district     Kuninkaanmäki    
2004 0927098000 ocd-division/country:fi/tilastoalue:0927098000       2020-12-07T13:38:52.452962+02:00 statistical_district     Sotunki    
2003 0922034000 ocd-division/country:fi/tilastoalue:0922034000       2020-12-07T13:38:52.447506+02:00 statistical_district     Kiila    
2002 0922025000 ocd-division/country:fi/tilastoalue:0922025000       2020-12-07T13:38:52.442232+02:00 statistical_district     Myllymäki    
2001 0921013000 ocd-division/country:fi/tilastoalue:0921013000       2020-12-07T13:38:52.436791+02:00 statistical_district     Vapaala    
2000 0921014000 ocd-division/country:fi/tilastoalue:0921014000       2020-12-07T13:38:52.732598+02:00 statistical_district     Varisto    
1999 0921020000 ocd-division/country:fi/tilastoalue:0921020000       2020-12-07T13:38:52.020051+02:00 statistical_district     Askisto    
1998 0922022000 ocd-division/country:fi/tilastoalue:0922022000       2020-12-07T13:38:52.429652+02:00 statistical_district     Keimola    
1997 0921016000 ocd-division/country:fi/tilastoalue:0921016000       2020-12-07T13:38:52.425247+02:00 statistical_district     Kaivoksela    
1996 0922033000 ocd-division/country:fi/tilastoalue:0922033000       2020-12-07T13:38:52.420153+02:00 statistical_district     Seutula    
1995 0922030000 ocd-division/country:fi/tilastoalue:0922030000       2020-12-07T13:38:52.415935+02:00 statistical_district     Vestra    
1994 0922031000 ocd-division/country:fi/tilastoalue:0922031000       2020-12-07T13:38:52.411391+02:00 statistical_district     Luhtaanmäki    
1993 0922021000 ocd-division/country:fi/tilastoalue:0922021000       2020-12-07T13:38:52.760023+02:00 statistical_district     Piispankylä    
1992 0922023000 ocd-division/country:fi/tilastoalue:0922023000       2020-12-07T13:38:52.754373+02:00 statistical_district     Kivistö    
1991 0912203291 ocd-division/country:fi/tilastoalue:0912203291       2020-12-07T13:38:52.407043+02:00 statistical_district     Etelä-Haaga    
1990 0914404287 ocd-division/country:fi/tilastoalue:0914404287       2020-12-07T13:38:52.403369+02:00 statistical_district     Veräjälaakso    
1989 0914401286 ocd-division/country:fi/tilastoalue:0914401286       2020-12-07T13:38:52.398739+02:00 statistical_district     Maunulanpuisto    
1988 0914404285 ocd-division/country:fi/tilastoalue:0914404285       2020-12-07T13:38:52.394535+02:00 statistical_district     Veräjämäki    
1987 0914404284 ocd-division/country:fi/tilastoalue:0914404284       2020-12-07T13:38:52.389687+02:00 statistical_district     Patola    
1986 0914401283 ocd-division/country:fi/tilastoalue:0914401283       2020-12-07T13:38:52.384102+02:00 statistical_district     Metsälä    
1985 0914401282 ocd-division/country:fi/tilastoalue:0914401282       2020-12-07T13:38:52.379058+02:00 statistical_district     Maunula    
1984 0914401281 ocd-division/country:fi/tilastoalue:0914401281       2020-12-07T13:38:52.374100+02:00 statistical_district     Pirkkola    
1983 0913305270 ocd-division/country:fi/tilastoalue:0913305270       2020-12-07T13:38:52.365848+02:00 statistical_district     Vanhakaupunki    
1982 0913305260 ocd-division/country:fi/tilastoalue:0913305260       2020-12-07T13:38:52.360981+02:00 statistical_district     Koskela    
1981 0913305250 ocd-division/country:fi/tilastoalue:0913305250       2020-12-07T13:38:52.356027+02:00 statistical_district     Käpylä    
1980 0913305240 ocd-division/country:fi/tilastoalue:0913305240       2020-12-07T13:38:52.351011+02:00 statistical_district     Kumpula    
1979 0913305232 ocd-division/country:fi/tilastoalue:0913305232       2020-12-07T13:38:52.346244+02:00 statistical_district     Arabianranta    
1978 0913305231 ocd-division/country:fi/tilastoalue:0913305231       2020-12-07T13:38:52.341531+02:00 statistical_district     Toukola    
1977 0912202304 ocd-division/country:fi/tilastoalue:0912202304       2020-12-07T13:38:52.336626+02:00 statistical_district     Munkkivuori    
1976 0912202303 ocd-division/country:fi/tilastoalue:0912202303       2020-12-07T13:38:52.331960+02:00 statistical_district     Lehtisaari    
1975 0912202302 ocd-division/country:fi/tilastoalue:0912202302       2020-12-07T13:38:52.327388+02:00 statistical_district     Kuusisaari    
1974 0912202301 ocd-division/country:fi/tilastoalue:0912202301       2020-12-07T13:38:52.322775+02:00 statistical_district     Vanha Munkkiniemi    
1973 0912203294 ocd-division/country:fi/tilastoalue:0912203294       2020-12-07T13:38:52.317487+02:00 statistical_district     Lassila    
1971 0912203292 ocd-division/country:fi/tilastoalue:0912203292       2020-12-07T13:38:52.302079+02:00 statistical_district     Kivihaka    
1970 0913301112 ocd-division/country:fi/tilastoalue:0913301112       2020-12-07T13:38:52.296997+02:00 statistical_district     Linjat    
1969 0913301111 ocd-division/country:fi/tilastoalue:0913301111       2020-12-07T13:38:52.291869+02:00 statistical_district     Siltasaari    
1968 0911102090 ocd-division/country:fi/tilastoalue:0911102090       2020-12-07T13:38:52.286873+02:00 statistical_district     Kaivopuisto    
1967 0911101080 ocd-division/country:fi/tilastoalue:0911101080       2020-12-07T13:38:52.281747+02:00 statistical_district     Katajanokka    
1966 0911102070 ocd-division/country:fi/tilastoalue:0911102070       2020-12-07T13:38:52.276776+02:00 statistical_district     Ullanlinna    
1965 0911102060 ocd-division/country:fi/tilastoalue:0911102060       2020-12-07T13:38:52.273030+02:00 statistical_district     Eira    
1964 0911102050 ocd-division/country:fi/tilastoalue:0911102050       2020-12-07T13:38:52.269179+02:00 statistical_district     Punavuori    
1963 0911103040 ocd-division/country:fi/tilastoalue:0911103040       2020-12-07T13:38:52.262727+02:00 statistical_district     Kamppi    
1962 0913303220 ocd-division/country:fi/tilastoalue:0913303220       2020-12-07T13:38:52.258430+02:00 statistical_district     Vallila    
1961 0911102204 ocd-division/country:fi/tilastoalue:0911102204       2020-12-07T13:38:52.254629+02:00 statistical_district     Hernesaari    
1960 0911103203 ocd-division/country:fi/tilastoalue:0911103203       2020-12-07T13:38:52.250811+02:00 statistical_district     Jätkäsaari    
1959 0911103202 ocd-division/country:fi/tilastoalue:0911103202       2020-12-07T13:38:52.246752+02:00 statistical_district     Lapinlahti    
1958 0911103201 ocd-division/country:fi/tilastoalue:0911103201       2020-12-07T13:38:52.238183+02:00 statistical_district     Ruoholahti    
1957 0916601190 ocd-division/country:fi/tilastoalue:0916601190       2020-12-07T13:38:52.233927+02:00 statistical_district     Mustikkamaa-Korkeasaari    
1956 0912201180 ocd-division/country:fi/tilastoalue:0912201180       2020-12-07T13:38:52.228489+02:00 statistical_district     Laakso    
1955 0913304174 ocd-division/country:fi/tilastoalue:0913304174       2020-12-07T13:38:52.706696+02:00 statistical_district     Keski-Pasila    
1954 0913304173 ocd-division/country:fi/tilastoalue:0913304173       2020-12-07T13:38:52.224083+02:00 statistical_district     Itä-Pasila    
1953 0913304172 ocd-division/country:fi/tilastoalue:0913304172       2020-12-07T13:38:52.215451+02:00 statistical_district     Pohjois-Pasila    
1952 0913304171 ocd-division/country:fi/tilastoalue:0913304171       2020-12-07T13:38:52.219410+02:00 statistical_district     Länsi-Pasila    

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