administrative_division

2,760 rows sorted by ocd_id descending

✎ View and edit SQL

This data as json, CSV (advanced)

municipality ✖

id origin_id ocd_id ▲ service_point_id start end modified_at type parent municipality name_fi name_sv name
1881 0916603500 ocd-division/country:fi/tilastoalue:0916603500       2020-12-07T13:38:51.925926+02:00 statistical_district     Villinki    
1880 0916603495 ocd-division/country:fi/tilastoalue:0916603495       2020-12-07T13:38:51.922092+02:00 statistical_district     Hevossalmi    
1879 0916603494 ocd-division/country:fi/tilastoalue:0916603494       2020-12-07T13:38:51.917868+02:00 statistical_district     Kruunuvuorenranta    
1854 0916603493 ocd-division/country:fi/tilastoalue:0916603493       2020-12-07T13:38:51.800926+02:00 statistical_district     Tullisaari    
1853 0916603492 ocd-division/country:fi/tilastoalue:0916603492       2020-12-07T13:38:51.794772+02:00 statistical_district     Jollas    
1852 0916603491 ocd-division/country:fi/tilastoalue:0916603491       2020-12-07T13:38:51.788982+02:00 statistical_district     Yliskylä    
1851 0916603480 ocd-division/country:fi/tilastoalue:0916603480       2020-12-07T13:38:51.783005+02:00 statistical_district     Vartiosaari    
1941 0916602440 ocd-division/country:fi/tilastoalue:0916602440       2020-12-07T13:38:52.170195+02:00 statistical_district     Tammisalo    
1940 0916602434 ocd-division/country:fi/tilastoalue:0916602434       2020-12-07T13:38:52.166045+02:00 statistical_district     Herttoniemenranta    
1939 0916602433 ocd-division/country:fi/tilastoalue:0916602433       2020-12-07T13:38:52.161522+02:00 statistical_district     Herttoniemen yritysalue    
1938 0916602432 ocd-division/country:fi/tilastoalue:0916602432       2020-12-07T13:38:52.156797+02:00 statistical_district     Roihuvuori    
1937 0916602431 ocd-division/country:fi/tilastoalue:0916602431       2020-12-07T13:38:52.152177+02:00 statistical_district     Länsi-Herttoniemi    
1936 0916601420 ocd-division/country:fi/tilastoalue:0916601420       2020-12-07T13:38:52.147659+02:00 statistical_district     Kulosaari    
1957 0916601190 ocd-division/country:fi/tilastoalue:0916601190       2020-12-07T13:38:52.233927+02:00 statistical_district     Mustikkamaa-Korkeasaari    
1935 0915506414 ocd-division/country:fi/tilastoalue:0915506414       2020-12-07T13:38:52.143059+02:00 statistical_district     Jakomäki    
1861 0915505415 ocd-division/country:fi/tilastoalue:0915505415       2020-12-07T13:38:51.830367+02:00 statistical_district     Alppikylä    
1934 0915505413 ocd-division/country:fi/tilastoalue:0915505413       2020-12-07T13:38:52.674471+02:00 statistical_district     Tattarisuo    
1933 0915505412 ocd-division/country:fi/tilastoalue:0915505412       2020-12-07T13:38:52.138950+02:00 statistical_district     Heikinlaakso    
1932 0915505411 ocd-division/country:fi/tilastoalue:0915505411       2020-12-07T13:38:52.668801+02:00 statistical_district     Puistola    
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    
1913 0915504401 ocd-division/country:fi/tilastoalue:0915504401       2020-12-07T13:38:52.057466+02:00 statistical_district     Siltamäki    
1912 0915503392 ocd-division/country:fi/tilastoalue:0915503392       2020-12-07T13:38:52.696488+02:00 statistical_district     Tapanila    
1911 0915503391 ocd-division/country:fi/tilastoalue:0915503391       2020-12-07T13:38:52.053114+02:00 statistical_district     Tapaninvainio    
1909 0915503385 ocd-division/country:fi/tilastoalue:0915503385       2020-12-07T13:38:52.469362+02:00 statistical_district     Malmin lentokenttä    
1908 0915503384 ocd-division/country:fi/tilastoalue:0915503384       2020-12-07T13:38:52.045444+02:00 statistical_district     Tattariharju    
1906 0915503382 ocd-division/country:fi/tilastoalue:0915503382       2020-12-07T13:38:52.765424+02:00 statistical_district     Ala-Malmi    
1905 0915503381 ocd-division/country:fi/tilastoalue:0915503381       2020-12-07T13:38:52.743310+02:00 statistical_district     Ylä-Malmi    
1904 0915502370 ocd-division/country:fi/tilastoalue:0915502370       2020-12-07T13:38:52.037786+02:00 statistical_district     Pukinmäki    
1910 0915501386 ocd-division/country:fi/tilastoalue:0915501386       2020-12-07T13:38:52.049198+02:00 statistical_district     Pihlajisto    
1907 0915501383 ocd-division/country:fi/tilastoalue:0915501383       2020-12-07T13:38:52.041715+02:00 statistical_district     Pihlajamäki    
1903 0915501364 ocd-division/country:fi/tilastoalue:0915501364       2020-12-07T13:38:52.033527+02:00 statistical_district     Viikinmäki    
1902 0915501363 ocd-division/country:fi/tilastoalue:0915501363       2020-12-07T13:38:52.028367+02:00 statistical_district     Viikin tiedepuisto    
1921 0915501362 ocd-division/country:fi/tilastoalue:0915501362       2020-12-07T13:38:52.095084+02:00 statistical_district     Latokartano    
1920 0915501361 ocd-division/country:fi/tilastoalue:0915501361       2020-12-07T13:38:52.090988+02:00 statistical_district     Viikinranta    
1918 0914405353 ocd-division/country:fi/tilastoalue:0914405353       2020-12-07T13:38:52.082690+02:00 statistical_district     Tuomarinkartano    
1901 0914405342 ocd-division/country:fi/tilastoalue:0914405342       2020-12-07T13:38:52.024330+02:00 statistical_district     Itä-Pakila    
1990 0914404287 ocd-division/country:fi/tilastoalue:0914404287       2020-12-07T13:38:52.403369+02:00 statistical_district     Veräjälaakso    
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    
1919 0914403354 ocd-division/country:fi/tilastoalue:0914403354       2020-12-07T13:38:52.086794+02:00 statistical_district     Haltiala    
1917 0914403352 ocd-division/country:fi/tilastoalue:0914403352       2020-12-07T13:38:52.078755+02:00 statistical_district     Torpparinmäki    
1916 0914403351 ocd-division/country:fi/tilastoalue:0914403351       2020-12-07T13:38:52.074620+02:00 statistical_district     Paloheinä    
1900 0914402341 ocd-division/country:fi/tilastoalue:0914402341       2020-12-07T13:38:52.015714+02:00 statistical_district     Länsi-Pakila    
1989 0914401286 ocd-division/country:fi/tilastoalue:0914401286       2020-12-07T13:38:52.398739+02:00 statistical_district     Maunulanpuisto    
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    
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    
1962 0913303220 ocd-division/country:fi/tilastoalue:0913303220       2020-12-07T13:38:52.258430+02:00 statistical_district     Vallila    
1857 0913303213 ocd-division/country:fi/tilastoalue:0913303213       2020-12-07T13:38:51.806606+02:00 statistical_district     Kyläsaari    
1856 0913303212 ocd-division/country:fi/tilastoalue:0913303212       2020-12-07T13:38:52.727511+02:00 statistical_district     Hermanninranta    
1855 0913303211 ocd-division/country:fi/tilastoalue:0913303211       2020-12-07T13:38:52.721783+02:00 statistical_district     Hermanninmäki    
1948 0913302122 ocd-division/country:fi/tilastoalue:0913302122       2020-12-07T13:38:52.197690+02:00 statistical_district     Alppila    
1947 0913302121 ocd-division/country:fi/tilastoalue:0913302121       2020-12-07T13:38:52.193958+02:00 statistical_district     Harju    
1946 0913301113 ocd-division/country:fi/tilastoalue:0913301113       2020-12-07T13:38:52.190245+02:00 statistical_district     Torkkelinmäki    
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    
1873 0913301104 ocd-division/country:fi/tilastoalue:0913301104       2020-12-07T13:38:51.889064+02:00 statistical_district     Hanasaari    
1872 0913301103 ocd-division/country:fi/tilastoalue:0913301103       2020-12-07T13:38:51.884173+02:00 statistical_district     Sompasaari    
1871 0913301102 ocd-division/country:fi/tilastoalue:0913301102       2020-12-07T13:38:51.897425+02:00 statistical_district     Kalasatama    
1870 0913301101 ocd-division/country:fi/tilastoalue:0913301101       2020-12-07T13:38:51.878097+02:00 statistical_district     Vilhonvuori    
1860 0912205336 ocd-division/country:fi/tilastoalue:0912205336       2020-12-07T13:38:51.824237+02:00 statistical_district     Honkasuo    
1899 0912205335 ocd-division/country:fi/tilastoalue:0912205335       2020-12-07T13:38:52.011635+02:00 statistical_district     Kuninkaantammi    
1898 0912205334 ocd-division/country:fi/tilastoalue:0912205334       2020-12-07T13:38:52.007012+02:00 statistical_district     Hakuninmaa    
1931 0912205333 ocd-division/country:fi/tilastoalue:0912205333       2020-12-07T13:38:52.134742+02:00 statistical_district     Malminkartano    
1930 0912205332 ocd-division/country:fi/tilastoalue:0912205332       2020-12-07T13:38:52.130622+02:00 statistical_district     Maununneva    
1929 0912205331 ocd-division/country:fi/tilastoalue:0912205331       2020-12-07T13:38:52.126519+02:00 statistical_district     Kannelmäki    
1845 0912204465 ocd-division/country:fi/tilastoalue:0912204465       2020-12-07T13:38:51.742985+02:00 statistical_district     Pitäjänmäen yritysalue    
1844 0912204464 ocd-division/country:fi/tilastoalue:0912204464       2020-12-07T13:38:51.738787+02:00 statistical_district     Marttila    
1878 0912204463 ocd-division/country:fi/tilastoalue:0912204463       2020-12-07T13:38:51.913670+02:00 statistical_district     Reimarla    
1877 0912204462 ocd-division/country:fi/tilastoalue:0912204462       2020-12-07T13:38:51.909487+02:00 statistical_district     Tali    
1876 0912204461 ocd-division/country:fi/tilastoalue:0912204461       2020-12-07T13:38:51.905667+02:00 statistical_district     Pajamäki    
1928 0912204320 ocd-division/country:fi/tilastoalue:0912204320       2020-12-07T13:38:52.122299+02:00 statistical_district     Konala    
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    
1991 0912203291 ocd-division/country:fi/tilastoalue:0912203291       2020-12-07T13:38:52.407043+02:00 statistical_district     Etelä-Haaga    
1927 0912202306 ocd-division/country:fi/tilastoalue:0912202306       2020-12-07T13:38:52.118181+02:00 statistical_district     Talinranta    
1926 0912202305 ocd-division/country:fi/tilastoalue:0912202305       2020-12-07T13:38:52.114474+02:00 statistical_district     Niemenmäki    
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    
1956 0912201180 ocd-division/country:fi/tilastoalue:0912201180       2020-12-07T13:38:52.228489+02:00 statistical_district     Laakso    
1859 0912201162 ocd-division/country:fi/tilastoalue:0912201162       2020-12-07T13:38:51.818318+02:00 statistical_district     Pikku Huopalahti    
1858 0912201161 ocd-division/country:fi/tilastoalue:0912201161       2020-12-07T13:38:51.812139+02:00 statistical_district     Vanha Ruskeasuo    
1951 0912201150 ocd-division/country:fi/tilastoalue:0912201150       2020-12-07T13:38:52.211509+02:00 statistical_district     Meilahti    
1869 0911105314 ocd-division/country:fi/tilastoalue:0911105314       2020-12-07T13:38:51.871496+02:00 statistical_district     Koivusaari    
1868 0911105313 ocd-division/country:fi/tilastoalue:0911105313       2020-12-07T13:38:51.865962+02:00 statistical_district     Myllykallio    
1867 0911105312 ocd-division/country:fi/tilastoalue:0911105312       2020-12-07T13:38:51.862057+02:00 statistical_district     Vattuniemi    
1866 0911105311 ocd-division/country:fi/tilastoalue:0911105311       2020-12-07T13:38:51.857916+02:00 statistical_district     Kotkavuori    

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