administrative_division

305 rows where type = "statistical_district" sorted by name_fi

✎ 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
1747 2351003006 ocd-division/country:fi/tilastoalue:2351003006       2020-12-07T13:38:51.350056+02:00 statistical_district          
1748 2351004009 ocd-division/country:fi/tilastoalue:2351004009       2020-12-07T13:38:51.354546+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          
1752 2351002004 ocd-division/country:fi/tilastoalue:2351002004       2020-12-07T13:38:51.368965+02:00 statistical_district          
1753 2351003007 ocd-division/country:fi/tilastoalue:2351003007       2020-12-07T13:38:51.372675+02:00 statistical_district          
1754 2351002005 ocd-division/country:fi/tilastoalue:2351002005       2020-12-07T13:38:51.376754+02:00 statistical_district          
1755 2351004008 ocd-division/country:fi/tilastoalue:2351004008       2020-12-07T13:38:51.380595+02:00 statistical_district          
1906 0915503382 ocd-division/country:fi/tilastoalue:0915503382       2020-12-07T13:38:52.765424+02:00 statistical_district     Ala-Malmi    
1861 0915505415 ocd-division/country:fi/tilastoalue:0915505415       2020-12-07T13:38:51.830367+02:00 statistical_district     Alppikylä    
1948 0913302122 ocd-division/country:fi/tilastoalue:0913302122       2020-12-07T13:38:52.197690+02:00 statistical_district     Alppila    
1886 0916603533 ocd-division/country:fi/tilastoalue:0916603533       2020-12-07T13:38:51.946074+02:00 statistical_district     Aluemeri    
1979 0913305232 ocd-division/country:fi/tilastoalue:0913305232       2020-12-07T13:38:52.346244+02:00 statistical_district     Arabianranta    
1999 0921020000 ocd-division/country:fi/tilastoalue:0921020000       2020-12-07T13:38:52.020051+02:00 statistical_district     Askisto    
2037 0925072000 ocd-division/country:fi/tilastoalue:0925072000       2020-12-07T13:38:52.626832+02:00 statistical_district     Asola    
1892 0917704546 ocd-division/country:fi/tilastoalue:0917704546       2020-12-07T13:38:51.973848+02:00 statistical_district     Aurinkolahti    
1797 0494043432 ocd-division/country:fi/tilastoalue:0494043432       2020-12-07T13:38:51.543674+02:00 statistical_district     Eestinmalmi    
1965 0911102060 ocd-division/country:fi/tilastoalue:0911102060       2020-12-07T13:38:52.273030+02:00 statistical_district     Eira    
1758 0495051512 ocd-division/country:fi/tilastoalue:0495051512       2020-12-07T13:38:51.392123+02:00 statistical_district     Espoonkartano    
1781 0494041411 ocd-division/country:fi/tilastoalue:0494041411       2020-12-07T13:38:51.477426+02:00 statistical_district     Espoonlahden Keskus    
1991 0912203291 ocd-division/country:fi/tilastoalue:0912203291       2020-12-07T13:38:52.407043+02:00 statistical_district     Etelä-Haaga    
1834 0491011112 ocd-division/country:fi/tilastoalue:0491011112       2020-12-07T13:38:51.699048+02:00 statistical_district     Etelä-Leppävaara    
1949 0911103130 ocd-division/country:fi/tilastoalue:0911103130       2020-12-07T13:38:52.201392+02:00 statistical_district     Etu-Töölö    
1802 0493032321 ocd-division/country:fi/tilastoalue:0493032321       2020-12-07T13:38:51.565793+02:00 statistical_district     Friisilä    
1766 0496062622 ocd-division/country:fi/tilastoalue:0496062622       2020-12-07T13:38:51.421759+02:00 statistical_district     Gumböle    
2039 0924066000 ocd-division/country:fi/tilastoalue:0924066000       2020-12-07T13:38:52.649026+02:00 statistical_district     Hakkila    
2030 0927094000 ocd-division/country:fi/tilastoalue:0927094000       2020-12-07T13:38:52.598402+02:00 statistical_district     Hakunila    
1898 0912205334 ocd-division/country:fi/tilastoalue:0912205334       2020-12-07T13:38:52.007012+02:00 statistical_district     Hakuninmaa    
1919 0914403354 ocd-division/country:fi/tilastoalue:0914403354       2020-12-07T13:38:52.086794+02:00 statistical_district     Haltiala    
1873 0913301104 ocd-division/country:fi/tilastoalue:0913301104       2020-12-07T13:38:51.889064+02:00 statistical_district     Hanasaari    
1795 0494044442 ocd-division/country:fi/tilastoalue:0494044442       2020-12-07T13:38:51.532950+02:00 statistical_district     Hannus    
1790 0494044443 ocd-division/country:fi/tilastoalue:0494044443       2020-12-07T13:38:51.513302+02:00 statistical_district     Hannusjärvi    
1947 0913302121 ocd-division/country:fi/tilastoalue:0913302121       2020-12-07T13:38:52.193958+02:00 statistical_district     Harju    
1827 0492023232 ocd-division/country:fi/tilastoalue:0492023232       2020-12-07T13:38:51.669152+02:00 statistical_district     Haukilahti    
2025 0925074000 ocd-division/country:fi/tilastoalue:0925074000       2020-12-07T13:38:52.569890+02:00 statistical_district     Havukoski    
1933 0915505412 ocd-division/country:fi/tilastoalue:0915505412       2020-12-07T13:38:52.138950+02:00 statistical_district     Heikinlaakso    
2011 0924069000 ocd-division/country:fi/tilastoalue:0924069000       2020-12-07T13:38:52.776318+02:00 statistical_district     Helsingin pitäjän kirkonkylä    
1799 0493033331 ocd-division/country:fi/tilastoalue:0493033331       2020-12-07T13:38:51.551118+02:00 statistical_district     Henttaa    
1855 0913303211 ocd-division/country:fi/tilastoalue:0913303211       2020-12-07T13:38:52.721783+02:00 statistical_district     Hermanninmäki    
1856 0913303212 ocd-division/country:fi/tilastoalue:0913303212       2020-12-07T13:38:52.727511+02:00 statistical_district     Hermanninranta    
1961 0911102204 ocd-division/country:fi/tilastoalue:0911102204       2020-12-07T13:38:52.254629+02:00 statistical_district     Hernesaari    
1939 0916602433 ocd-division/country:fi/tilastoalue:0916602433       2020-12-07T13:38:52.161522+02:00 statistical_district     Herttoniemen yritysalue    
1940 0916602434 ocd-division/country:fi/tilastoalue:0916602434       2020-12-07T13:38:52.166045+02:00 statistical_district     Herttoniemenranta    
1880 0916603495 ocd-division/country:fi/tilastoalue:0916603495       2020-12-07T13:38:51.922092+02:00 statistical_district     Hevossalmi    
2023 0924060000 ocd-division/country:fi/tilastoalue:0924060000       2020-12-07T13:38:52.557936+02:00 statistical_district     Hiekkaharju    
1860 0912205336 ocd-division/country:fi/tilastoalue:0912205336       2020-12-07T13:38:51.824237+02:00 statistical_district     Honkasuo    
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    
1787 0496063633 ocd-division/country:fi/tilastoalue:0496063633       2020-12-07T13:38:51.500646+02:00 statistical_district     Högnäs    
1798 0494044441 ocd-division/country:fi/tilastoalue:0494044441       2020-12-07T13:38:51.547481+02:00 statistical_district     Iivisniemi    
2038 0925071000 ocd-division/country:fi/tilastoalue:0925071000       2020-12-07T13:38:52.631160+02:00 statistical_district     Ilola    
2006 0927096000 ocd-division/country:fi/tilastoalue:0927096000       2020-12-07T13:38:52.464039+02:00 statistical_district     Itä-Hakkila    
1901 0914405342 ocd-division/country:fi/tilastoalue:0914405342       2020-12-07T13:38:52.024330+02:00 statistical_district     Itä-Pakila    
1954 0913304173 ocd-division/country:fi/tilastoalue:0913304173       2020-12-07T13:38:52.224083+02:00 statistical_district     Itä-Pasila    
1942 0917701457 ocd-division/country:fi/tilastoalue:0917701457       2020-12-07T13:38:52.174194+02:00 statistical_district     Itäkeskus    
1885 0916603532 ocd-division/country:fi/tilastoalue:0916603532       2020-12-07T13:38:51.942207+02:00 statistical_district     Itäsaaret    
1935 0915506414 ocd-division/country:fi/tilastoalue:0915506414       2020-12-07T13:38:52.143059+02:00 statistical_district     Jakomäki    
2040 0924062000 ocd-division/country:fi/tilastoalue:0924062000       2020-12-07T13:38:52.635401+02:00 statistical_district     Jokiniemi    
2036 0926085000 ocd-division/country:fi/tilastoalue:0926085000       2020-12-07T13:38:52.622491+02:00 statistical_district     Jokivarsi    
1853 0916603492 ocd-division/country:fi/tilastoalue:0916603492       2020-12-07T13:38:51.794772+02:00 statistical_district     Jollas    
1822 0491014143 ocd-division/country:fi/tilastoalue:0491014143       2020-12-07T13:38:51.647174+02:00 statistical_district     Jupperi    
1793 0496063632 ocd-division/country:fi/tilastoalue:0496063632       2020-12-07T13:38:51.525196+02:00 statistical_district     Järvenperä    
1960 0911103203 ocd-division/country:fi/tilastoalue:0911103203       2020-12-07T13:38:52.250811+02:00 statistical_district     Jätkäsaari    
1945 0911102030 ocd-division/country:fi/tilastoalue:0911102030       2020-12-07T13:38:52.186166+02:00 statistical_district     Kaartinkaupunki    
1997 0921016000 ocd-division/country:fi/tilastoalue:0921016000       2020-12-07T13:38:52.425247+02:00 statistical_district     Kaivoksela    
1968 0911102090 ocd-division/country:fi/tilastoalue:0911102090       2020-12-07T13:38:52.286873+02:00 statistical_district     Kaivopuisto    
1804 0497072721 ocd-division/country:fi/tilastoalue:0497072721       2020-12-07T13:38:51.574047+02:00 statistical_district     Kalajärvi    
1871 0913301102 ocd-division/country:fi/tilastoalue:0913301102       2020-12-07T13:38:51.897425+02:00 statistical_district     Kalasatama    
1891 0917704545 ocd-division/country:fi/tilastoalue:0917704545       2020-12-07T13:38:51.969077+02:00 statistical_district     Kallahti    
1963 0911103040 ocd-division/country:fi/tilastoalue:0911103040       2020-12-07T13:38:52.262727+02:00 statistical_district     Kamppi    
1929 0912205331 ocd-division/country:fi/tilastoalue:0912205331       2020-12-07T13:38:52.126519+02:00 statistical_district     Kannelmäki    
1826 0491013133 ocd-division/country:fi/tilastoalue:0491013133       2020-12-07T13:38:51.665048+02:00 statistical_district     Karakallio    
1863 0918801580 ocd-division/country:fi/tilastoalue:0918801580       2020-12-07T13:38:51.844533+02:00 statistical_district     Karhusaari    
1768 0496063634 ocd-division/country:fi/tilastoalue:0496063634       2020-12-07T13:38:51.429285+02:00 statistical_district     Karhusuo    
1783 0496063631 ocd-division/country:fi/tilastoalue:0496063631       2020-12-07T13:38:51.484975+02:00 statistical_district     Karvasmäki    
1967 0911101080 ocd-division/country:fi/tilastoalue:0911101080       2020-12-07T13:38:52.281747+02:00 statistical_district     Katajanokka    
1774 0494042421 ocd-division/country:fi/tilastoalue:0494042421       2020-12-07T13:38:51.451425+02:00 statistical_district     Kattilalaakso    
1763 0495051511 ocd-division/country:fi/tilastoalue:0495051511       2020-12-07T13:38:51.410913+02:00 statistical_district     Kauklahti    
1773 0496061615 ocd-division/country:fi/tilastoalue:0496061615       2020-12-07T13:38:51.447673+02:00 statistical_district     Kaupunginkallio    
1998 0922022000 ocd-division/country:fi/tilastoalue:0922022000       2020-12-07T13:38:52.429652+02:00 statistical_district     Keimola    
1955 0913304174 ocd-division/country:fi/tilastoalue:0913304174       2020-12-07T13:38:52.706696+02:00 statistical_district     Keski-Pasila    
1887 0917704541 ocd-division/country:fi/tilastoalue:0917704541       2020-12-07T13:38:51.950222+02:00 statistical_district     Keski-Vuosaari    
2003 0922034000 ocd-division/country:fi/tilastoalue:0922034000       2020-12-07T13:38:52.447506+02:00 statistical_district     Kiila    
1779 0496061611 ocd-division/country:fi/tilastoalue:0496061611       2020-12-07T13:38:51.469770+02:00 statistical_district     Kirkkojärvi    
1769 0494041413 ocd-division/country:fi/tilastoalue:0494041413       2020-12-07T13:38:51.433321+02:00 statistical_district     Kivenlahti    
1971 0912203292 ocd-division/country:fi/tilastoalue:0912203292       2020-12-07T13:38:52.302079+02:00 statistical_district     Kivihaka    
1849 0917703474 ocd-division/country:fi/tilastoalue:0917703474       2020-12-07T13:38:51.771022+02:00 statistical_district     Kivikko    
1992 0922023000 ocd-division/country:fi/tilastoalue:0922023000       2020-12-07T13:38:52.754373+02:00 statistical_district     Kivistö    
1944 0911101020 ocd-division/country:fi/tilastoalue:0911101020       2020-12-07T13:38:52.182160+02:00 statistical_district     Kluuvi    
2010 0924068000 ocd-division/country:fi/tilastoalue:0924068000       2020-12-07T13:38:52.486056+02:00 statistical_district     Koivuhaka    
2024 0925070000 ocd-division/country:fi/tilastoalue:0925070000       2020-12-07T13:38:52.563488+02:00 statistical_district     Koivukylä    
1869 0911105314 ocd-division/country:fi/tilastoalue:0911105314       2020-12-07T13:38:51.871496+02:00 statistical_district     Koivusaari    
1928 0912204320 ocd-division/country:fi/tilastoalue:0912204320       2020-12-07T13:38:52.122299+02:00 statistical_district     Konala    
1846 0917703471 ocd-division/country:fi/tilastoalue:0917703471       2020-12-07T13:38:51.747281+02:00 statistical_district     Kontula    
2028 0926081000 ocd-division/country:fi/tilastoalue:0926081000       2020-12-07T13:38:52.587163+02:00 statistical_district     Korso    
1982 0913305260 ocd-division/country:fi/tilastoalue:0913305260       2020-12-07T13:38:52.360981+02:00 statistical_district     Koskela    
1866 0911105311 ocd-division/country:fi/tilastoalue:0911105311       2020-12-07T13:38:51.857916+02:00 statistical_district     Kotkavuori    
1943 0911101010 ocd-division/country:fi/tilastoalue:0911101010       2020-12-07T13:38:52.178345+02:00 statistical_district     Kruununhaka    
1879 0916603494 ocd-division/country:fi/tilastoalue:0916603494       2020-12-07T13:38:51.917868+02:00 statistical_district     Kruunuvuorenranta    

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