administrative_division
356 rows where "modified_at" is on date 2020-10-02 sorted by origin_id
This data as json, CSV (advanced)
Suggested facets: type, parent, municipality
id | origin_id ▼ | ocd_id | service_point_id | start | end | modified_at | type | parent | municipality | name_fi | name_sv | name |
---|---|---|---|---|---|---|---|---|---|---|---|---|
5433 | 235-001 | ocd-division/country:fi/kunta:kauniainen/kaupunginosa:001 | 2020-10-02T09:50:47.246885+03:00 | neighborhood | 84 | kauniainen | 1 | 1 | ||||
5434 | 235-002 | ocd-division/country:fi/kunta:kauniainen/kaupunginosa:002 | 2020-10-02T09:50:47.253766+03:00 | neighborhood | 84 | kauniainen | 2 | 2 | ||||
5435 | 235-003 | ocd-division/country:fi/kunta:kauniainen/kaupunginosa:003 | 2020-10-02T09:50:47.260423+03:00 | neighborhood | 84 | kauniainen | 3 | 3 | ||||
5436 | 235-004 | ocd-division/country:fi/kunta:kauniainen/kaupunginosa:004 | 2020-10-02T09:50:47.269769+03:00 | neighborhood | 84 | kauniainen | 4 | 4 | ||||
5437 | 235-005 | ocd-division/country:fi/kunta:kauniainen/kaupunginosa:005 | 2020-10-02T09:50:47.279288+03:00 | neighborhood | 84 | kauniainen | 5 | 5 | ||||
5438 | 235-006 | ocd-division/country:fi/kunta:kauniainen/kaupunginosa:006 | 2020-10-02T09:50:47.292873+03:00 | neighborhood | 84 | kauniainen | 6 | 6 | ||||
5439 | 235-007 | ocd-division/country:fi/kunta:kauniainen/kaupunginosa:007 | 2020-10-02T09:50:47.300202+03:00 | neighborhood | 84 | kauniainen | 7 | 7 | ||||
5440 | 235-008 | ocd-division/country:fi/kunta:kauniainen/kaupunginosa:008 | 2020-10-02T09:50:47.306652+03:00 | neighborhood | 84 | kauniainen | 8 | 8 | ||||
5256 | 49-010 | ocd-division/country:fi/kunta:espoo/kaupunginosa:010 | 2020-10-02T09:50:45.815086+03:00 | neighborhood | 11 | espoo | Otaniemi | Otnäs | ||||
5257 | 49-012 | ocd-division/country:fi/kunta:espoo/kaupunginosa:012 | 2020-10-02T09:50:45.832606+03:00 | neighborhood | 11 | espoo | Tapiola | Hagalund | ||||
5258 | 49-013 | ocd-division/country:fi/kunta:espoo/kaupunginosa:013 | 2020-10-02T09:50:45.840055+03:00 | neighborhood | 11 | espoo | Westend | Westend | ||||
5259 | 49-014 | ocd-division/country:fi/kunta:espoo/kaupunginosa:014 | 2020-10-02T09:50:45.846890+03:00 | neighborhood | 11 | espoo | Haukilahti | Gäddvik | ||||
5260 | 49-015 | ocd-division/country:fi/kunta:espoo/kaupunginosa:015 | 2020-10-02T09:50:45.853459+03:00 | neighborhood | 11 | espoo | Niittykumpu | Ängskulla | ||||
5261 | 49-016 | ocd-division/country:fi/kunta:espoo/kaupunginosa:016 | 2020-10-02T09:50:45.860433+03:00 | neighborhood | 11 | espoo | Pohjois-Tapiola | Norra Hagalund | ||||
5262 | 49-017 | ocd-division/country:fi/kunta:espoo/kaupunginosa:017 | 2020-10-02T09:50:45.867770+03:00 | neighborhood | 11 | espoo | Laajalahti | Bredvik | ||||
5263 | 49-020 | ocd-division/country:fi/kunta:espoo/kaupunginosa:020 | 2020-10-02T09:50:45.877304+03:00 | neighborhood | 11 | espoo | Kuurinniitty | Kurängen | ||||
5264 | 49-021 | ocd-division/country:fi/kunta:espoo/kaupunginosa:021 | 2020-10-02T09:50:45.885626+03:00 | neighborhood | 11 | espoo | Henttaa | Hemtans | ||||
5562 | 49-02100 | ocd-division/country:fi/kunta:espoo/postinumero:02100 | 2020-10-02T09:50:52.444846+03:00 | postcode_area | 11 | espoo | 02100 | |||||
5563 | 49-02110 | ocd-division/country:fi/kunta:espoo/postinumero:02110 | 2020-10-02T09:50:52.451383+03:00 | postcode_area | 11 | espoo | 02110 | |||||
5564 | 49-02120 | ocd-division/country:fi/kunta:espoo/postinumero:02120 | 2020-10-02T09:50:52.458904+03:00 | postcode_area | 11 | espoo | 02120 | |||||
5565 | 49-02130 | ocd-division/country:fi/kunta:espoo/postinumero:02130 | 2020-10-02T09:50:52.468973+03:00 | postcode_area | 11 | espoo | 02130 | |||||
5566 | 49-02140 | ocd-division/country:fi/kunta:espoo/postinumero:02140 | 2020-10-02T09:50:52.479210+03:00 | postcode_area | 11 | espoo | 02140 | |||||
5567 | 49-02150 | ocd-division/country:fi/kunta:espoo/postinumero:02150 | 2020-10-02T09:50:52.486799+03:00 | postcode_area | 11 | espoo | 02150 | |||||
5568 | 49-02160 | ocd-division/country:fi/kunta:espoo/postinumero:02160 | 2020-10-02T09:50:52.493684+03:00 | postcode_area | 11 | espoo | 02160 | |||||
5569 | 49-02170 | ocd-division/country:fi/kunta:espoo/postinumero:02170 | 2020-10-02T09:50:52.500313+03:00 | postcode_area | 11 | espoo | 02170 | |||||
5570 | 49-02180 | ocd-division/country:fi/kunta:espoo/postinumero:02180 | 2020-10-02T09:50:52.506798+03:00 | postcode_area | 11 | espoo | 02180 | |||||
5265 | 49-022 | ocd-division/country:fi/kunta:espoo/kaupunginosa:022 | 2020-10-02T09:50:45.894861+03:00 | neighborhood | 11 | espoo | Olari | Olars | ||||
5571 | 49-02200 | ocd-division/country:fi/kunta:espoo/postinumero:02200 | 2020-10-02T09:50:52.513112+03:00 | postcode_area | 11 | espoo | 02200 | |||||
5572 | 49-02210 | ocd-division/country:fi/kunta:espoo/postinumero:02210 | 2020-10-02T09:50:52.519523+03:00 | postcode_area | 11 | espoo | 02210 | |||||
5573 | 49-02230 | ocd-division/country:fi/kunta:espoo/postinumero:02230 | 2020-10-02T09:50:52.527087+03:00 | postcode_area | 11 | espoo | 02230 | |||||
5574 | 49-02240 | ocd-division/country:fi/kunta:espoo/postinumero:02240 | 2020-10-02T09:50:52.534294+03:00 | postcode_area | 11 | espoo | 02240 | |||||
5575 | 49-02250 | ocd-division/country:fi/kunta:espoo/postinumero:02250 | 2020-10-02T09:50:52.541676+03:00 | postcode_area | 11 | espoo | 02250 | |||||
5576 | 49-02260 | ocd-division/country:fi/kunta:espoo/postinumero:02260 | 2020-10-02T09:50:52.548028+03:00 | postcode_area | 11 | espoo | 02260 | |||||
5577 | 49-02270 | ocd-division/country:fi/kunta:espoo/postinumero:02270 | 2020-10-02T09:50:52.554521+03:00 | postcode_area | 11 | espoo | 02270 | |||||
5578 | 49-02280 | ocd-division/country:fi/kunta:espoo/postinumero:02280 | 2020-10-02T09:50:52.566619+03:00 | postcode_area | 11 | espoo | 02280 | |||||
5579 | 49-02290 | ocd-division/country:fi/kunta:espoo/postinumero:02290 | 2020-10-02T09:50:52.573807+03:00 | postcode_area | 11 | espoo | 02290 | |||||
5266 | 49-023 | ocd-division/country:fi/kunta:espoo/kaupunginosa:023 | 2020-10-02T09:50:45.908089+03:00 | neighborhood | 11 | espoo | Matinkylä | Mattby | ||||
5580 | 49-02300 | ocd-division/country:fi/kunta:espoo/postinumero:02300 | 2020-10-02T09:50:52.579606+03:00 | postcode_area | 11 | espoo | 02300 | |||||
5581 | 49-02320 | ocd-division/country:fi/kunta:espoo/postinumero:02320 | 2020-10-02T09:50:52.585792+03:00 | postcode_area | 11 | espoo | 02320 | |||||
5582 | 49-02330 | ocd-division/country:fi/kunta:espoo/postinumero:02330 | 2020-10-02T09:50:52.591942+03:00 | postcode_area | 11 | espoo | 02330 | |||||
5583 | 49-02340 | ocd-division/country:fi/kunta:espoo/postinumero:02340 | 2020-10-02T09:50:52.597889+03:00 | postcode_area | 11 | espoo | 02340 | |||||
5584 | 49-02360 | ocd-division/country:fi/kunta:espoo/postinumero:02360 | 2020-10-02T09:50:52.603809+03:00 | postcode_area | 11 | espoo | 02360 | |||||
5585 | 49-02380 | ocd-division/country:fi/kunta:espoo/postinumero:02380 | 2020-10-02T09:50:52.609548+03:00 | postcode_area | 11 | espoo | 02380 | |||||
5586 | 49-02510 | ocd-division/country:fi/kunta:espoo/postinumero:02510 | 2020-10-02T09:50:52.615716+03:00 | postcode_area | 11 | espoo | 02510 | |||||
5267 | 49-026 | ocd-division/country:fi/kunta:espoo/kaupunginosa:026 | 2020-10-02T09:50:45.916894+03:00 | neighborhood | 11 | espoo | Mankkaa | Mankans | ||||
5587 | 49-02600 | ocd-division/country:fi/kunta:espoo/postinumero:02600 | 2020-10-02T09:50:52.622118+03:00 | postcode_area | 11 | espoo | 02600 | |||||
5588 | 49-02610 | ocd-division/country:fi/kunta:espoo/postinumero:02610 | 2020-10-02T09:50:52.628867+03:00 | postcode_area | 11 | espoo | 02610 | |||||
5589 | 49-02620 | ocd-division/country:fi/kunta:espoo/postinumero:02620 | 2020-10-02T09:50:52.635326+03:00 | postcode_area | 11 | espoo | 02620 | |||||
5590 | 49-02630 | ocd-division/country:fi/kunta:espoo/postinumero:02630 | 2020-10-02T09:50:52.642415+03:00 | postcode_area | 11 | espoo | 02630 | |||||
5591 | 49-02650 | ocd-division/country:fi/kunta:espoo/postinumero:02650 | 2020-10-02T09:50:52.650889+03:00 | postcode_area | 11 | espoo | 02650 | |||||
5592 | 49-02660 | ocd-division/country:fi/kunta:espoo/postinumero:02660 | 2020-10-02T09:50:52.659467+03:00 | postcode_area | 11 | espoo | 02660 | |||||
5593 | 49-02680 | ocd-division/country:fi/kunta:espoo/postinumero:02680 | 2020-10-02T09:50:52.667680+03:00 | postcode_area | 11 | espoo | 02680 | |||||
5594 | 49-02700 | ocd-division/country:fi/kunta:espoo/postinumero:02700 | 2020-10-02T09:50:52.675327+03:00 | postcode_area | 11 | espoo | 02700 | |||||
5595 | 49-02710 | ocd-division/country:fi/kunta:espoo/postinumero:02710 | 2020-10-02T09:50:52.682380+03:00 | postcode_area | 11 | espoo | 02710 | |||||
5596 | 49-02720 | ocd-division/country:fi/kunta:espoo/postinumero:02720 | 2020-10-02T09:50:52.689020+03:00 | postcode_area | 11 | espoo | 02720 | |||||
5597 | 49-02730 | ocd-division/country:fi/kunta:espoo/postinumero:02730 | 2020-10-02T09:50:52.694894+03:00 | postcode_area | 11 | espoo | 02730 | |||||
5598 | 49-02740 | ocd-division/country:fi/kunta:espoo/postinumero:02740 | 2020-10-02T09:50:52.700810+03:00 | postcode_area | 11 | espoo | 02740 | |||||
5599 | 49-02750 | ocd-division/country:fi/kunta:espoo/postinumero:02750 | 2020-10-02T09:50:52.707855+03:00 | postcode_area | 11 | espoo | 02750 | |||||
5600 | 49-02760 | ocd-division/country:fi/kunta:espoo/postinumero:02760 | 2020-10-02T09:50:52.714690+03:00 | postcode_area | 11 | espoo | 02760 | |||||
5601 | 49-02770 | ocd-division/country:fi/kunta:espoo/postinumero:02770 | 2020-10-02T09:50:52.721605+03:00 | postcode_area | 11 | espoo | 02770 | |||||
5602 | 49-02780 | ocd-division/country:fi/kunta:espoo/postinumero:02780 | 2020-10-02T09:50:52.728825+03:00 | postcode_area | 11 | espoo | 02780 | |||||
5603 | 49-02810 | ocd-division/country:fi/kunta:espoo/postinumero:02810 | 2020-10-02T09:50:52.736667+03:00 | postcode_area | 11 | espoo | 02810 | |||||
5604 | 49-02820 | ocd-division/country:fi/kunta:espoo/postinumero:02820 | 2020-10-02T09:50:52.743566+03:00 | postcode_area | 11 | espoo | 02820 | |||||
5605 | 49-02860 | ocd-division/country:fi/kunta:espoo/postinumero:02860 | 2020-10-02T09:50:52.751588+03:00 | postcode_area | 11 | espoo | 02860 | |||||
5606 | 49-02920 | ocd-division/country:fi/kunta:espoo/postinumero:02920 | 2020-10-02T09:50:52.759990+03:00 | postcode_area | 11 | espoo | 02920 | |||||
5607 | 49-02940 | ocd-division/country:fi/kunta:espoo/postinumero:02940 | 2020-10-02T09:50:52.767218+03:00 | postcode_area | 11 | espoo | 02940 | |||||
5608 | 49-02970 | ocd-division/country:fi/kunta:espoo/postinumero:02970 | 2020-10-02T09:50:52.775276+03:00 | postcode_area | 11 | espoo | 02970 | |||||
5609 | 49-02980 | ocd-division/country:fi/kunta:espoo/postinumero:02980 | 2020-10-02T09:50:52.782548+03:00 | postcode_area | 11 | espoo | 02980 | |||||
5268 | 49-030 | ocd-division/country:fi/kunta:espoo/kaupunginosa:030 | 2020-10-02T09:50:45.924743+03:00 | neighborhood | 11 | espoo | Nöykkiö | Nöykis | ||||
5269 | 49-031 | ocd-division/country:fi/kunta:espoo/kaupunginosa:031 | 2020-10-02T09:50:45.933806+03:00 | neighborhood | 11 | espoo | Kaitaa | Kaitans | ||||
5270 | 49-032 | ocd-division/country:fi/kunta:espoo/kaupunginosa:032 | 2020-10-02T09:50:45.941980+03:00 | neighborhood | 11 | espoo | Suvisaaristo | Sommaröarna | ||||
5271 | 49-033 | ocd-division/country:fi/kunta:espoo/kaupunginosa:033 | 2020-10-02T09:50:45.951351+03:00 | neighborhood | 11 | espoo | Soukka | Sökö | ||||
5272 | 49-034 | ocd-division/country:fi/kunta:espoo/kaupunginosa:034 | 2020-10-02T09:50:45.962510+03:00 | neighborhood | 11 | espoo | Espoonlahti | Esboviken | ||||
5273 | 49-040 | ocd-division/country:fi/kunta:espoo/kaupunginosa:040 | 2020-10-02T09:50:45.973395+03:00 | neighborhood | 11 | espoo | Espoon Keskus | Esbo Centrum | ||||
5274 | 49-041 | ocd-division/country:fi/kunta:espoo/kaupunginosa:041 | 2020-10-02T09:50:45.984418+03:00 | neighborhood | 11 | espoo | Kaupunginkallio | Stadsberget | ||||
5275 | 49-042 | ocd-division/country:fi/kunta:espoo/kaupunginosa:042 | 2020-10-02T09:50:45.993547+03:00 | neighborhood | 11 | espoo | Saunalahti | Bastvik | ||||
5276 | 49-043 | ocd-division/country:fi/kunta:espoo/kaupunginosa:043 | 2020-10-02T09:50:46.002215+03:00 | neighborhood | 11 | espoo | Vanttila | Fantsby | ||||
5277 | 49-044 | ocd-division/country:fi/kunta:espoo/kaupunginosa:044 | 2020-10-02T09:50:46.010619+03:00 | neighborhood | 11 | espoo | Kauklahti | Köklax | ||||
5278 | 49-045 | ocd-division/country:fi/kunta:espoo/kaupunginosa:045 | 2020-10-02T09:50:46.018119+03:00 | neighborhood | 11 | espoo | Kurttila | Kurtby | ||||
5279 | 49-046 | ocd-division/country:fi/kunta:espoo/kaupunginosa:046 | 2020-10-02T09:50:46.026161+03:00 | neighborhood | 11 | espoo | Latokaski | Ladusved | ||||
5280 | 49-047 | ocd-division/country:fi/kunta:espoo/kaupunginosa:047 | 2020-10-02T09:50:46.033331+03:00 | neighborhood | 11 | espoo | Muurala | Morby | ||||
5281 | 49-050 | ocd-division/country:fi/kunta:espoo/kaupunginosa:050 | 2020-10-02T09:50:46.040559+03:00 | neighborhood | 11 | espoo | Lintuvaara | Fågelberga | ||||
5282 | 49-051 | ocd-division/country:fi/kunta:espoo/kaupunginosa:051 | 2020-10-02T09:50:46.050032+03:00 | neighborhood | 11 | espoo | Leppävaara | Alberga | ||||
5283 | 49-054 | ocd-division/country:fi/kunta:espoo/kaupunginosa:054 | 2020-10-02T09:50:46.060961+03:00 | neighborhood | 11 | espoo | Kilo | Kilo | ||||
5284 | 49-055 | ocd-division/country:fi/kunta:espoo/kaupunginosa:055 | 2020-10-02T09:50:46.069040+03:00 | neighborhood | 11 | espoo | Sepänkylä | Smedsby | ||||
5285 | 49-057 | ocd-division/country:fi/kunta:espoo/kaupunginosa:057 | 2020-10-02T09:50:46.076214+03:00 | neighborhood | 11 | espoo | Karakallio | Karabacka | ||||
5286 | 49-060 | ocd-division/country:fi/kunta:espoo/kaupunginosa:060 | 2020-10-02T09:50:46.082812+03:00 | neighborhood | 11 | espoo | Laaksolahti | Dalsvik | ||||
5287 | 49-061 | ocd-division/country:fi/kunta:espoo/kaupunginosa:061 | 2020-10-02T09:50:46.090743+03:00 | neighborhood | 11 | espoo | Viherlaakso | Gröndal | ||||
5288 | 49-062 | ocd-division/country:fi/kunta:espoo/kaupunginosa:062 | 2020-10-02T09:50:46.098619+03:00 | neighborhood | 11 | espoo | Lippajärvi | Klappträsk | ||||
5289 | 49-063 | ocd-division/country:fi/kunta:espoo/kaupunginosa:063 | 2020-10-02T09:50:46.108059+03:00 | neighborhood | 11 | espoo | Järvenperä | Träskända | ||||
5290 | 49-064 | ocd-division/country:fi/kunta:espoo/kaupunginosa:064 | 2020-10-02T09:50:46.116476+03:00 | neighborhood | 11 | espoo | Karvasmäki | Karvasbacka | ||||
5291 | 49-065 | ocd-division/country:fi/kunta:espoo/kaupunginosa:065 | 2020-10-02T09:50:46.123630+03:00 | neighborhood | 11 | espoo | Högnäs | Högnäs | ||||
5292 | 49-070 | ocd-division/country:fi/kunta:espoo/kaupunginosa:070 | 2020-10-02T09:50:46.136665+03:00 | neighborhood | 11 | espoo | Espoonkartano | Esbogård | ||||
5293 | 49-071 | ocd-division/country:fi/kunta:espoo/kaupunginosa:071 | 2020-10-02T09:50:46.149165+03:00 | neighborhood | 11 | espoo | Gumböle | Gumböle | ||||
5294 | 49-072 | ocd-division/country:fi/kunta:espoo/kaupunginosa:072 | 2020-10-02T09:50:46.160256+03:00 | neighborhood | 11 | espoo | Karhusuo | Björnkärr | ||||
5295 | 49-073 | ocd-division/country:fi/kunta:espoo/kaupunginosa:073 | 2020-10-02T09:50:46.172812+03:00 | neighborhood | 11 | espoo | Kunnarla | Gunnars | ||||
5296 | 49-074 | ocd-division/country:fi/kunta:espoo/kaupunginosa:074 | 2020-10-02T09:50:46.181907+03:00 | neighborhood | 11 | espoo | Nupuri | Nupurböle | ||||
5297 | 49-075 | ocd-division/country:fi/kunta:espoo/kaupunginosa:075 | 2020-10-02T09:50:46.193270+03:00 | neighborhood | 11 | espoo | Kolmperä | Kolmpers | ||||
5298 | 49-076 | ocd-division/country:fi/kunta:espoo/kaupunginosa:076 | 2020-10-02T09:50:46.204615+03:00 | neighborhood | 11 | espoo | Siikajärvi | Siikajärvi | ||||
5299 | 49-078 | ocd-division/country:fi/kunta:espoo/kaupunginosa:078 | 2020-10-02T09:50:46.212498+03:00 | neighborhood | 11 | espoo | Nuuksio | Noux |
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 );