administrative_division
1,928 rows where "modified_at" is on date 2020-12-07 sorted by parent
This data as json, CSV (advanced)
Suggested facets: start, end, type, start (date), end (date)
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 |
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 );