administrative_division
305 rows where type = "statistical_district" sorted by municipality
This data as json, CSV (advanced)
id | origin_id | ocd_id | service_point_id | start | end | modified_at | type | parent | municipality ▼ | name_fi | name_sv | name |
---|---|---|---|---|---|---|---|---|---|---|---|---|
1847 | 0917703472 | ocd-division/country:fi/tilastoalue:0917703472 | 2020-12-07T13:38:51.752641+02:00 | statistical_district | Vesala | |||||||
1848 | 0917703473 | ocd-division/country:fi/tilastoalue:0917703473 | 2020-12-07T13:38:51.758981+02:00 | statistical_district | Mellunmäki | |||||||
1849 | 0917703474 | ocd-division/country:fi/tilastoalue:0917703474 | 2020-12-07T13:38:51.771022+02:00 | statistical_district | Kivikko | |||||||
1850 | 0917703475 | ocd-division/country:fi/tilastoalue:0917703475 | 2020-12-07T13:38:51.777200+02:00 | statistical_district | Kurkimäki | |||||||
1851 | 0916603480 | ocd-division/country:fi/tilastoalue:0916603480 | 2020-12-07T13:38:51.783005+02:00 | statistical_district | Vartiosaari | |||||||
1852 | 0916603491 | ocd-division/country:fi/tilastoalue:0916603491 | 2020-12-07T13:38:51.788982+02:00 | statistical_district | Yliskylä | |||||||
1853 | 0916603492 | ocd-division/country:fi/tilastoalue:0916603492 | 2020-12-07T13:38:51.794772+02:00 | statistical_district | Jollas | |||||||
1854 | 0916603493 | ocd-division/country:fi/tilastoalue:0916603493 | 2020-12-07T13:38:51.800926+02:00 | statistical_district | Tullisaari | |||||||
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 | |||||||
1857 | 0913303213 | ocd-division/country:fi/tilastoalue:0913303213 | 2020-12-07T13:38:51.806606+02:00 | statistical_district | Kyläsaari | |||||||
1858 | 0912201161 | ocd-division/country:fi/tilastoalue:0912201161 | 2020-12-07T13:38:51.812139+02:00 | statistical_district | Vanha Ruskeasuo | |||||||
1859 | 0912201162 | ocd-division/country:fi/tilastoalue:0912201162 | 2020-12-07T13:38:51.818318+02:00 | statistical_district | Pikku Huopalahti | |||||||
1860 | 0912205336 | ocd-division/country:fi/tilastoalue:0912205336 | 2020-12-07T13:38:51.824237+02:00 | statistical_district | Honkasuo | |||||||
1861 | 0915505415 | ocd-division/country:fi/tilastoalue:0915505415 | 2020-12-07T13:38:51.830367+02:00 | statistical_district | Alppikylä | |||||||
1862 | 0918801570 | ocd-division/country:fi/tilastoalue:0918801570 | 2020-12-07T13:38:51.835943+02:00 | statistical_district | Talosaari | |||||||
1863 | 0918801580 | ocd-division/country:fi/tilastoalue:0918801580 | 2020-12-07T13:38:51.844533+02:00 | statistical_district | Karhusaari | |||||||
1864 | 0918801591 | ocd-division/country:fi/tilastoalue:0918801591 | 2020-12-07T13:38:51.849271+02:00 | statistical_district | Landbo | |||||||
1865 | 0918801592 | ocd-division/country:fi/tilastoalue:0918801592 | 2020-12-07T13:38:51.853689+02:00 | statistical_district | Puroniitty | |||||||
1866 | 0911105311 | ocd-division/country:fi/tilastoalue:0911105311 | 2020-12-07T13:38:51.857916+02:00 | statistical_district | Kotkavuori | |||||||
1867 | 0911105312 | ocd-division/country:fi/tilastoalue:0911105312 | 2020-12-07T13:38:51.862057+02:00 | statistical_district | Vattuniemi | |||||||
1868 | 0911105313 | ocd-division/country:fi/tilastoalue:0911105313 | 2020-12-07T13:38:51.865962+02:00 | statistical_district | Myllykallio | |||||||
1869 | 0911105314 | ocd-division/country:fi/tilastoalue:0911105314 | 2020-12-07T13:38:51.871496+02:00 | statistical_district | Koivusaari | |||||||
1870 | 0913301101 | ocd-division/country:fi/tilastoalue:0913301101 | 2020-12-07T13:38:51.878097+02:00 | statistical_district | Vilhonvuori | |||||||
1871 | 0913301102 | ocd-division/country:fi/tilastoalue:0913301102 | 2020-12-07T13:38:51.897425+02:00 | statistical_district | Kalasatama | |||||||
1872 | 0913301103 | ocd-division/country:fi/tilastoalue:0913301103 | 2020-12-07T13:38:51.884173+02:00 | statistical_district | Sompasaari | |||||||
1873 | 0913301104 | ocd-division/country:fi/tilastoalue:0913301104 | 2020-12-07T13:38:51.889064+02:00 | statistical_district | Hanasaari | |||||||
1874 | 0917701455 | ocd-division/country:fi/tilastoalue:0917701455 | 2020-12-07T13:38:51.893183+02:00 | statistical_district | Marjaniemi | |||||||
1875 | 0917701456 | ocd-division/country:fi/tilastoalue:0917701456 | 2020-12-07T13:38:51.901504+02:00 | statistical_district | Roihupelto | |||||||
1876 | 0912204461 | ocd-division/country:fi/tilastoalue:0912204461 | 2020-12-07T13:38:51.905667+02:00 | statistical_district | Pajamäki | |||||||
1877 | 0912204462 | ocd-division/country:fi/tilastoalue:0912204462 | 2020-12-07T13:38:51.909487+02:00 | statistical_district | Tali | |||||||
1878 | 0912204463 | ocd-division/country:fi/tilastoalue:0912204463 | 2020-12-07T13:38:51.913670+02:00 | statistical_district | Reimarla | |||||||
1879 | 0916603494 | ocd-division/country:fi/tilastoalue:0916603494 | 2020-12-07T13:38:51.917868+02:00 | statistical_district | Kruunuvuorenranta | |||||||
1880 | 0916603495 | ocd-division/country:fi/tilastoalue:0916603495 | 2020-12-07T13:38:51.922092+02:00 | statistical_district | Hevossalmi | |||||||
1881 | 0916603500 | ocd-division/country:fi/tilastoalue:0916603500 | 2020-12-07T13:38:51.925926+02:00 | statistical_district | Villinki | |||||||
1882 | 0916603510 | ocd-division/country:fi/tilastoalue:0916603510 | 2020-12-07T13:38:51.929971+02:00 | statistical_district | Santahamina | |||||||
1883 | 0911102520 | ocd-division/country:fi/tilastoalue:0911102520 | 2020-12-07T13:38:51.933948+02:00 | statistical_district | Suomenlinna | |||||||
1884 | 0911102531 | ocd-division/country:fi/tilastoalue:0911102531 | 2020-12-07T13:38:51.937738+02:00 | statistical_district | Länsisaaret | |||||||
1885 | 0916603532 | ocd-division/country:fi/tilastoalue:0916603532 | 2020-12-07T13:38:51.942207+02:00 | statistical_district | Itäsaaret | |||||||
1886 | 0916603533 | ocd-division/country:fi/tilastoalue:0916603533 | 2020-12-07T13:38:51.946074+02:00 | statistical_district | Aluemeri | |||||||
1887 | 0917704541 | ocd-division/country:fi/tilastoalue:0917704541 | 2020-12-07T13:38:51.950222+02:00 | statistical_district | Keski-Vuosaari | |||||||
1888 | 0917704542 | ocd-division/country:fi/tilastoalue:0917704542 | 2020-12-07T13:38:51.955332+02:00 | statistical_district | Nordsjön kartano | |||||||
1889 | 0917704543 | ocd-division/country:fi/tilastoalue:0917704543 | 2020-12-07T13:38:51.960420+02:00 | statistical_district | Uutela | |||||||
1890 | 0917704544 | ocd-division/country:fi/tilastoalue:0917704544 | 2020-12-07T13:38:51.964712+02:00 | statistical_district | Meri-Rastila | |||||||
1891 | 0917704545 | ocd-division/country:fi/tilastoalue:0917704545 | 2020-12-07T13:38:51.969077+02:00 | statistical_district | Kallahti | |||||||
1892 | 0917704546 | ocd-division/country:fi/tilastoalue:0917704546 | 2020-12-07T13:38:51.973848+02:00 | statistical_district | Aurinkolahti | |||||||
1893 | 0917704547 | ocd-division/country:fi/tilastoalue:0917704547 | 2020-12-07T13:38:51.979017+02:00 | statistical_district | Rastila | |||||||
1894 | 0917704548 | ocd-division/country:fi/tilastoalue:0917704548 | 2020-12-07T13:38:51.984111+02:00 | statistical_district | Niinisaari | |||||||
1895 | 0917704549 | ocd-division/country:fi/tilastoalue:0917704549 | 2020-12-07T13:38:51.988862+02:00 | statistical_district | Mustavuori | |||||||
1896 | 0918801550 | ocd-division/country:fi/tilastoalue:0918801550 | 2020-12-07T13:38:51.993629+02:00 | statistical_district | Östersundom | |||||||
1897 | 0918801560 | ocd-division/country:fi/tilastoalue:0918801560 | 2020-12-07T13:38:52.000147+02:00 | statistical_district | Salmenkallio | |||||||
1898 | 0912205334 | ocd-division/country:fi/tilastoalue:0912205334 | 2020-12-07T13:38:52.007012+02:00 | statistical_district | Hakuninmaa | |||||||
1899 | 0912205335 | ocd-division/country:fi/tilastoalue:0912205335 | 2020-12-07T13:38:52.011635+02:00 | statistical_district | Kuninkaantammi | |||||||
1900 | 0914402341 | ocd-division/country:fi/tilastoalue:0914402341 | 2020-12-07T13:38:52.015714+02:00 | statistical_district | Länsi-Pakila | |||||||
1901 | 0914405342 | ocd-division/country:fi/tilastoalue:0914405342 | 2020-12-07T13:38:52.024330+02:00 | statistical_district | Itä-Pakila | |||||||
1902 | 0915501363 | ocd-division/country:fi/tilastoalue:0915501363 | 2020-12-07T13:38:52.028367+02:00 | statistical_district | Viikin tiedepuisto | |||||||
1903 | 0915501364 | ocd-division/country:fi/tilastoalue:0915501364 | 2020-12-07T13:38:52.033527+02:00 | statistical_district | Viikinmäki | |||||||
1904 | 0915502370 | ocd-division/country:fi/tilastoalue:0915502370 | 2020-12-07T13:38:52.037786+02:00 | statistical_district | Pukinmäki | |||||||
1905 | 0915503381 | ocd-division/country:fi/tilastoalue:0915503381 | 2020-12-07T13:38:52.743310+02:00 | statistical_district | Ylä-Malmi | |||||||
1906 | 0915503382 | ocd-division/country:fi/tilastoalue:0915503382 | 2020-12-07T13:38:52.765424+02:00 | statistical_district | Ala-Malmi | |||||||
1907 | 0915501383 | ocd-division/country:fi/tilastoalue:0915501383 | 2020-12-07T13:38:52.041715+02:00 | statistical_district | Pihlajamäki | |||||||
1908 | 0915503384 | ocd-division/country:fi/tilastoalue:0915503384 | 2020-12-07T13:38:52.045444+02:00 | statistical_district | Tattariharju | |||||||
1909 | 0915503385 | ocd-division/country:fi/tilastoalue:0915503385 | 2020-12-07T13:38:52.469362+02:00 | statistical_district | Malmin lentokenttä | |||||||
1910 | 0915501386 | ocd-division/country:fi/tilastoalue:0915501386 | 2020-12-07T13:38:52.049198+02:00 | statistical_district | Pihlajisto | |||||||
1911 | 0915503391 | ocd-division/country:fi/tilastoalue:0915503391 | 2020-12-07T13:38:52.053114+02:00 | statistical_district | Tapaninvainio | |||||||
1912 | 0915503392 | ocd-division/country:fi/tilastoalue:0915503392 | 2020-12-07T13:38:52.696488+02:00 | statistical_district | Tapanila | |||||||
1913 | 0915504401 | ocd-division/country:fi/tilastoalue:0915504401 | 2020-12-07T13:38:52.057466+02:00 | statistical_district | Siltamäki | |||||||
1914 | 0915505402 | ocd-division/country:fi/tilastoalue:0915505402 | 2020-12-07T13:38:52.066027+02:00 | statistical_district | Tapulikaupunki | |||||||
1915 | 0915504403 | ocd-division/country:fi/tilastoalue:0915504403 | 2020-12-07T13:38:52.070394+02:00 | statistical_district | Töyrynummi | |||||||
1916 | 0914403351 | ocd-division/country:fi/tilastoalue:0914403351 | 2020-12-07T13:38:52.074620+02:00 | statistical_district | Paloheinä | |||||||
1917 | 0914403352 | ocd-division/country:fi/tilastoalue:0914403352 | 2020-12-07T13:38:52.078755+02:00 | statistical_district | Torpparinmäki | |||||||
1918 | 0914405353 | ocd-division/country:fi/tilastoalue:0914405353 | 2020-12-07T13:38:52.082690+02:00 | statistical_district | Tuomarinkartano | |||||||
1919 | 0914403354 | ocd-division/country:fi/tilastoalue:0914403354 | 2020-12-07T13:38:52.086794+02:00 | statistical_district | Haltiala | |||||||
1920 | 0915501361 | ocd-division/country:fi/tilastoalue:0915501361 | 2020-12-07T13:38:52.090988+02:00 | statistical_district | Viikinranta | |||||||
1921 | 0915501362 | ocd-division/country:fi/tilastoalue:0915501362 | 2020-12-07T13:38:52.095084+02:00 | statistical_district | Latokartano | |||||||
1922 | 0917701451 | ocd-division/country:fi/tilastoalue:0917701451 | 2020-12-07T13:38:52.099187+02:00 | statistical_district | Vartioharju | |||||||
1923 | 0917701452 | ocd-division/country:fi/tilastoalue:0917701452 | 2020-12-07T13:38:52.103080+02:00 | statistical_district | Puotila | |||||||
1924 | 0917701453 | ocd-division/country:fi/tilastoalue:0917701453 | 2020-12-07T13:38:52.106752+02:00 | statistical_district | Puotinharju | |||||||
1925 | 0917702454 | ocd-division/country:fi/tilastoalue:0917702454 | 2020-12-07T13:38:52.110557+02:00 | statistical_district | Myllypuro | |||||||
1926 | 0912202305 | ocd-division/country:fi/tilastoalue:0912202305 | 2020-12-07T13:38:52.114474+02:00 | statistical_district | Niemenmäki | |||||||
1927 | 0912202306 | ocd-division/country:fi/tilastoalue:0912202306 | 2020-12-07T13:38:52.118181+02:00 | statistical_district | Talinranta | |||||||
1928 | 0912204320 | ocd-division/country:fi/tilastoalue:0912204320 | 2020-12-07T13:38:52.122299+02:00 | statistical_district | Konala | |||||||
1929 | 0912205331 | ocd-division/country:fi/tilastoalue:0912205331 | 2020-12-07T13:38:52.126519+02:00 | statistical_district | Kannelmäki | |||||||
1930 | 0912205332 | ocd-division/country:fi/tilastoalue:0912205332 | 2020-12-07T13:38:52.130622+02:00 | statistical_district | Maununneva | |||||||
1931 | 0912205333 | ocd-division/country:fi/tilastoalue:0912205333 | 2020-12-07T13:38:52.134742+02:00 | statistical_district | Malminkartano | |||||||
1932 | 0915505411 | ocd-division/country:fi/tilastoalue:0915505411 | 2020-12-07T13:38:52.668801+02:00 | statistical_district | Puistola | |||||||
1933 | 0915505412 | ocd-division/country:fi/tilastoalue:0915505412 | 2020-12-07T13:38:52.138950+02:00 | statistical_district | Heikinlaakso | |||||||
1934 | 0915505413 | ocd-division/country:fi/tilastoalue:0915505413 | 2020-12-07T13:38:52.674471+02:00 | statistical_district | Tattarisuo | |||||||
1935 | 0915506414 | ocd-division/country:fi/tilastoalue:0915506414 | 2020-12-07T13:38:52.143059+02:00 | statistical_district | Jakomäki | |||||||
1936 | 0916601420 | ocd-division/country:fi/tilastoalue:0916601420 | 2020-12-07T13:38:52.147659+02:00 | statistical_district | Kulosaari | |||||||
1937 | 0916602431 | ocd-division/country:fi/tilastoalue:0916602431 | 2020-12-07T13:38:52.152177+02:00 | statistical_district | Länsi-Herttoniemi | |||||||
1938 | 0916602432 | ocd-division/country:fi/tilastoalue:0916602432 | 2020-12-07T13:38:52.156797+02:00 | statistical_district | Roihuvuori | |||||||
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 | |||||||
1941 | 0916602440 | ocd-division/country:fi/tilastoalue:0916602440 | 2020-12-07T13:38:52.170195+02:00 | statistical_district | Tammisalo | |||||||
1942 | 0917701457 | ocd-division/country:fi/tilastoalue:0917701457 | 2020-12-07T13:38:52.174194+02:00 | statistical_district | Itäkeskus | |||||||
1943 | 0911101010 | ocd-division/country:fi/tilastoalue:0911101010 | 2020-12-07T13:38:52.178345+02:00 | statistical_district | Kruununhaka | |||||||
1944 | 0911101020 | ocd-division/country:fi/tilastoalue:0911101020 | 2020-12-07T13:38:52.182160+02:00 | statistical_district | Kluuvi | |||||||
1945 | 0911102030 | ocd-division/country:fi/tilastoalue:0911102030 | 2020-12-07T13:38:52.186166+02:00 | statistical_district | Kaartinkaupunki | |||||||
1946 | 0913301113 | ocd-division/country:fi/tilastoalue:0913301113 | 2020-12-07T13:38:52.190245+02:00 | statistical_district | Torkkelinmäki |
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 );