305 rows where type = "statistical_district"

View and edit SQL

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          
1756 0496064643 ocd-division/country:fi/tilastoalue:0496064643       2020-12-07T13:38:51.384358+02:00 statistical_district     Siikajärvi    
1757 0496064644 ocd-division/country:fi/tilastoalue:0496064644       2020-12-07T13:38:51.388357+02:00 statistical_district     Nuuksionpää    
1758 0495051512 ocd-division/country:fi/tilastoalue:0495051512       2020-12-07T13:38:51.392123+02:00 statistical_district     Espoonkartano    
1759 0496064645 ocd-division/country:fi/tilastoalue:0496064645       2020-12-07T13:38:51.396100+02:00 statistical_district     Ämmässuo    
1760 0496064642 ocd-division/country:fi/tilastoalue:0496064642       2020-12-07T13:38:51.399834+02:00 statistical_district     Vanha-Nuuksio-Nupuri    
1761 0497072725 ocd-division/country:fi/tilastoalue:0497072725       2020-12-07T13:38:51.403735+02:00 statistical_district     Velskola    
1762 0495052521 ocd-division/country:fi/tilastoalue:0495052521       2020-12-07T13:38:51.407273+02:00 statistical_district     Kurttila    
1763 0495051511 ocd-division/country:fi/tilastoalue:0495051511       2020-12-07T13:38:51.410913+02:00 statistical_district     Kauklahti    
1764 0494042423 ocd-division/country:fi/tilastoalue:0494042423       2020-12-07T13:38:51.414637+02:00 statistical_district     Saunaniemi    
1765 0495052522 ocd-division/country:fi/tilastoalue:0495052522       2020-12-07T13:38:51.418140+02:00 statistical_district     Vanttila    
1766 0496062622 ocd-division/country:fi/tilastoalue:0496062622       2020-12-07T13:38:51.421759+02:00 statistical_district     Gumböle    
1767 0497072724 ocd-division/country:fi/tilastoalue:0497072724       2020-12-07T13:38:51.425394+02:00 statistical_district     Lakisto    
1768 0496063634 ocd-division/country:fi/tilastoalue:0496063634       2020-12-07T13:38:51.429285+02:00 statistical_district     Karhusuo    
1769 0494041413 ocd-division/country:fi/tilastoalue:0494041413       2020-12-07T13:38:51.433321+02:00 statistical_district     Kivenlahti    
1770 0496062621 ocd-division/country:fi/tilastoalue:0496062621       2020-12-07T13:38:51.436794+02:00 statistical_district     Muurala    
1771 0494042422 ocd-division/country:fi/tilastoalue:0494042422       2020-12-07T13:38:51.440646+02:00 statistical_district     Tillinmäki    
1772 0496063635 ocd-division/country:fi/tilastoalue:0496063635       2020-12-07T13:38:51.444218+02:00 statistical_district     Kunnarla    
1773 0496061615 ocd-division/country:fi/tilastoalue:0496061615       2020-12-07T13:38:51.447673+02:00 statistical_district     Kaupunginkallio    
1774 0494042421 ocd-division/country:fi/tilastoalue:0494042421       2020-12-07T13:38:51.451425+02:00 statistical_district     Kattilalaakso    
1775 0494041414 ocd-division/country:fi/tilastoalue:0494041414       2020-12-07T13:38:51.455105+02:00 statistical_district     Laurinlahti    
1776 0497071711 ocd-division/country:fi/tilastoalue:0497071711       2020-12-07T13:38:51.458970+02:00 statistical_district     Röylä    
1777 0494041415 ocd-division/country:fi/tilastoalue:0494041415       2020-12-07T13:38:51.462465+02:00 statistical_district     Soukanniemi    
1778 0494041412 ocd-division/country:fi/tilastoalue:0494041412       2020-12-07T13:38:51.466128+02:00 statistical_district     Soukanmäki    
1779 0496061611 ocd-division/country:fi/tilastoalue:0496061611       2020-12-07T13:38:51.469770+02:00 statistical_district     Kirkkojärvi    
1780 0494043431 ocd-division/country:fi/tilastoalue:0494043431       2020-12-07T13:38:51.473558+02:00 statistical_district     Latokaskenmäki    
1781 0494041411 ocd-division/country:fi/tilastoalue:0494041411       2020-12-07T13:38:51.477426+02:00 statistical_district     Espoonlahden Keskus    
1782 0494045452 ocd-division/country:fi/tilastoalue:0494045452       2020-12-07T13:38:51.481354+02:00 statistical_district     Ulkosaaret    
1783 0496063631 ocd-division/country:fi/tilastoalue:0496063631       2020-12-07T13:38:51.484975+02:00 statistical_district     Karvasmäki    
1784 0494043434 ocd-division/country:fi/tilastoalue:0494043434       2020-12-07T13:38:51.488965+02:00 statistical_district     Nöykkiönlaakso    
1785 0496061613 ocd-division/country:fi/tilastoalue:0496061613       2020-12-07T13:38:51.493203+02:00 statistical_district     Suvela    
1786 0497072722 ocd-division/country:fi/tilastoalue:0497072722       2020-12-07T13:38:51.496700+02:00 statistical_district     Luukki    
1787 0496063633 ocd-division/country:fi/tilastoalue:0496063633       2020-12-07T13:38:51.500646+02:00 statistical_district     Högnäs    
1788 0497071712 ocd-division/country:fi/tilastoalue:0497071712       2020-12-07T13:38:51.504760+02:00 statistical_district     Puotinen    
1789 0497072723 ocd-division/country:fi/tilastoalue:0497072723       2020-12-07T13:38:51.508798+02:00 statistical_district     Lahnus    
1790 0494044443 ocd-division/country:fi/tilastoalue:0494044443       2020-12-07T13:38:51.513302+02:00 statistical_district     Hannusjärvi    
1791 0494043433 ocd-division/country:fi/tilastoalue:0494043433       2020-12-07T13:38:51.518013+02:00 statistical_district     Malminmäki    
1792 0496061614 ocd-division/country:fi/tilastoalue:0496061614       2020-12-07T13:38:51.521615+02:00 statistical_district     Kuurinniitty    
1793 0496063632 ocd-division/country:fi/tilastoalue:0496063632       2020-12-07T13:38:51.525196+02:00 statistical_district     Järvenperä    
1794 0496061612 ocd-division/country:fi/tilastoalue:0496061612       2020-12-07T13:38:51.529399+02:00 statistical_district     Tuomarila    
1795 0494044442 ocd-division/country:fi/tilastoalue:0494044442       2020-12-07T13:38:51.532950+02:00 statistical_district     Hannus    
1796 0494045451 ocd-division/country:fi/tilastoalue:0494045451       2020-12-07T13:38:51.536537+02:00 statistical_district     Suvisaaret    
1797 0494043432 ocd-division/country:fi/tilastoalue:0494043432       2020-12-07T13:38:51.543674+02:00 statistical_district     Eestinmalmi    
1798 0494044441 ocd-division/country:fi/tilastoalue:0494044441       2020-12-07T13:38:51.547481+02:00 statistical_district     Iivisniemi    
1799 0493033331 ocd-division/country:fi/tilastoalue:0493033331       2020-12-07T13:38:51.551118+02:00 statistical_district     Henttaa    
1800 0491015152 ocd-division/country:fi/tilastoalue:0491015152       2020-12-07T13:38:51.558465+02:00 statistical_district     Lippajärvi    
1801 0496061616 ocd-division/country:fi/tilastoalue:0496061616       2020-12-07T13:38:51.562271+02:00 statistical_district     Ymmersta    
1802 0493032321 ocd-division/country:fi/tilastoalue:0493032321       2020-12-07T13:38:51.565793+02:00 statistical_district     Friisilä    
1803 0497071714 ocd-division/country:fi/tilastoalue:0497071714       2020-12-07T13:38:51.569902+02:00 statistical_district     Perusmäki    
1804 0497072721 ocd-division/country:fi/tilastoalue:0497072721       2020-12-07T13:38:51.574047+02:00 statistical_district     Kalajärvi    
1805 0491015151 ocd-division/country:fi/tilastoalue:0491015151       2020-12-07T13:38:51.578041+02:00 statistical_district     Viherlaakso    
1806 0497071713 ocd-division/country:fi/tilastoalue:0497071713       2020-12-07T13:38:51.582223+02:00 statistical_district     Vanhakartano    
1807 0493031312 ocd-division/country:fi/tilastoalue:0493031312       2020-12-07T13:38:51.586207+02:00 statistical_district     Tiistilä    
1808 0493032323 ocd-division/country:fi/tilastoalue:0493032323       2020-12-07T13:38:51.589763+02:00 statistical_district     Kuitinmäki    
1809 0491016161 ocd-division/country:fi/tilastoalue:0491016161       2020-12-07T13:38:51.593187+02:00 statistical_district     Sepänkylä    
1810 0491014142 ocd-division/country:fi/tilastoalue:0491014142       2020-12-07T13:38:51.596795+02:00 statistical_district     Lähderanta    
1811 0493033332 ocd-division/country:fi/tilastoalue:0493033332       2020-12-07T13:38:51.600292+02:00 statistical_district     Suurpelto    
1812 0493032322 ocd-division/country:fi/tilastoalue:0493032322       2020-12-07T13:38:51.604458+02:00 statistical_district     Olarinmäki    
1813 0493031315 ocd-division/country:fi/tilastoalue:0493031315       2020-12-07T13:38:51.608559+02:00 statistical_district     Nuottaniemi    
1814 0497071715 ocd-division/country:fi/tilastoalue:0497071715       2020-12-07T13:38:51.612195+02:00 statistical_district     Niipperi    
1815 0493031314 ocd-division/country:fi/tilastoalue:0493031314       2020-12-07T13:38:51.616079+02:00 statistical_district     Matinkylän Keskus    
1816 0493031311 ocd-division/country:fi/tilastoalue:0493031311       2020-12-07T13:38:51.620017+02:00 statistical_district     Matinmetsä    
1817 0491014141 ocd-division/country:fi/tilastoalue:0491014141       2020-12-07T13:38:51.624097+02:00 statistical_district     Veininlaakso    
1818 0493031316 ocd-division/country:fi/tilastoalue:0493031316       2020-12-07T13:38:51.627906+02:00 statistical_district     Miessaari    
1819 0492024242 ocd-division/country:fi/tilastoalue:0492024242       2020-12-07T13:38:51.635525+02:00 statistical_district     Taavinkylä    
1820 0493031313 ocd-division/country:fi/tilastoalue:0493031313       2020-12-07T13:38:51.639675+02:00 statistical_district     Matinlahti    
1821 0492024241 ocd-division/country:fi/tilastoalue:0492024241       2020-12-07T13:38:51.643489+02:00 statistical_district     Vanha-Mankkaa    
1822 0491014143 ocd-division/country:fi/tilastoalue:0491014143       2020-12-07T13:38:51.647174+02:00 statistical_district     Jupperi    
1823 0491013131 ocd-division/country:fi/tilastoalue:0491013131       2020-12-07T13:38:51.651239+02:00 statistical_district     Nuijala    
1824 0491013132 ocd-division/country:fi/tilastoalue:0491013132       2020-12-07T13:38:51.655842+02:00 statistical_district     Kuninkainen    
1825 0492021214 ocd-division/country:fi/tilastoalue:0492021214       2020-12-07T13:38:51.660604+02:00 statistical_district     Niittykumpu    
1826 0491013133 ocd-division/country:fi/tilastoalue:0491013133       2020-12-07T13:38:51.665048+02:00 statistical_district     Karakallio    
1827 0492023232 ocd-division/country:fi/tilastoalue:0492023232       2020-12-07T13:38:51.669152+02:00 statistical_district     Haukilahti    
1828 0492025252 ocd-division/country:fi/tilastoalue:0492025252       2020-12-07T13:38:51.673046+02:00 statistical_district     Pohjois-Laajalahti    
1829 0492021215 ocd-division/country:fi/tilastoalue:0492021215       2020-12-07T13:38:51.677008+02:00 statistical_district     Pohjois-Tapiola    
1830 0492021212 ocd-division/country:fi/tilastoalue:0492021212       2020-12-07T13:38:51.680622+02:00 statistical_district     Länsikorkee    
1831 0492023231 ocd-division/country:fi/tilastoalue:0492023231       2020-12-07T13:38:51.684431+02:00 statistical_district     Westend    
1832 0491011111 ocd-division/country:fi/tilastoalue:0491011111       2020-12-07T13:38:51.688382+02:00 statistical_district     Pohjois-Leppävaara    
1833 0491011114 ocd-division/country:fi/tilastoalue:0491011114       2020-12-07T13:38:51.692130+02:00 statistical_district     Lintukorpi    
1834 0491011112 ocd-division/country:fi/tilastoalue:0491011112       2020-12-07T13:38:51.699048+02:00 statistical_district     Etelä-Leppävaara    
1835 0491011117 ocd-division/country:fi/tilastoalue:0491011117       2020-12-07T13:38:51.702755+02:00 statistical_district     Lintumetsä    
1836 0492021211 ocd-division/country:fi/tilastoalue:0492021211       2020-12-07T13:38:51.706739+02:00 statistical_district     Tapiolan Keskus    
1837 0492022222 ocd-division/country:fi/tilastoalue:0492022222       2020-12-07T13:38:51.710808+02:00 statistical_district     Otaniemi    
1838 0492025251 ocd-division/country:fi/tilastoalue:0492025251       2020-12-07T13:38:51.714737+02:00 statistical_district     Ruukinranta    
1839 0492021213 ocd-division/country:fi/tilastoalue:0492021213       2020-12-07T13:38:51.718261+02:00 statistical_district     Otsolahti    
1840 0491011118 ocd-division/country:fi/tilastoalue:0491011118       2020-12-07T13:38:51.721988+02:00 statistical_district     Perkkaa    
1841 0491011113 ocd-division/country:fi/tilastoalue:0491011113       2020-12-07T13:38:51.726290+02:00 statistical_district     Mäkkylä    
1842 0491011115 ocd-division/country:fi/tilastoalue:0491011115       2020-12-07T13:38:51.730716+02:00 statistical_district     Lintulaakso    
1843 0491011116 ocd-division/country:fi/tilastoalue:0491011116       2020-12-07T13:38:51.734720+02:00 statistical_district     Uusmäki    
1844 0912204464 ocd-division/country:fi/tilastoalue:0912204464       2020-12-07T13:38:51.738787+02:00 statistical_district     Marttila    
1845 0912204465 ocd-division/country:fi/tilastoalue:0912204465       2020-12-07T13:38:51.742985+02:00 statistical_district     Pitäjänmäen yritysalue    
1846 0917703471 ocd-division/country:fi/tilastoalue:0917703471       2020-12-07T13:38:51.747281+02:00 statistical_district     Kontula    

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