administrative_division

305 rows where type = "statistical_district"

✎ View and edit SQL

This data as json, CSV (advanced)

type ✖

  • statistical_district · 205 ✖
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    

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