administrative_division
356 rows where "modified_at" is on date 2020-10-02 sorted by name
This data as json, CSV (advanced)
Suggested facets: parent, municipality
type ✖
- neighborhood 185
- postcode_area 171
id | origin_id | ocd_id | service_point_id | start | end | modified_at | type | parent | municipality | name_fi | name_sv | name ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||
5265 | 49-022 | ocd-division/country:fi/kunta:espoo/kaupunginosa:022 | 2020-10-02T09:50:45.894861+03:00 | neighborhood | 11 | espoo | Olari | Olars | ||||
5266 | 49-023 | ocd-division/country:fi/kunta:espoo/kaupunginosa:023 | 2020-10-02T09:50:45.908089+03:00 | neighborhood | 11 | espoo | Matinkylä | Mattby | ||||
5267 | 49-026 | ocd-division/country:fi/kunta:espoo/kaupunginosa:026 | 2020-10-02T09:50:45.916894+03:00 | neighborhood | 11 | espoo | Mankkaa | Mankans | ||||
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 | ||||
5300 | 49-080 | ocd-division/country:fi/kunta:espoo/kaupunginosa:080 | 2020-10-02T09:50:46.220191+03:00 | neighborhood | 11 | espoo | Vanhakartano | Gammelgård | ||||
5301 | 49-081 | ocd-division/country:fi/kunta:espoo/kaupunginosa:081 | 2020-10-02T09:50:46.226739+03:00 | neighborhood | 11 | espoo | Niipperi | Nipert | ||||
5302 | 49-082 | ocd-division/country:fi/kunta:espoo/kaupunginosa:082 | 2020-10-02T09:50:46.233180+03:00 | neighborhood | 11 | espoo | Perusmäki | Grandbacka | ||||
5303 | 49-083 | ocd-division/country:fi/kunta:espoo/kaupunginosa:083 | 2020-10-02T09:50:46.242303+03:00 | neighborhood | 11 | espoo | Bodom | Bodom | ||||
5304 | 49-084 | ocd-division/country:fi/kunta:espoo/kaupunginosa:084 | 2020-10-02T09:50:46.249171+03:00 | neighborhood | 11 | espoo | Röylä | Rödskog | ||||
5305 | 49-085 | ocd-division/country:fi/kunta:espoo/kaupunginosa:085 | 2020-10-02T09:50:46.256075+03:00 | neighborhood | 11 | espoo | Kalajärvi | Kalajärvi | ||||
5306 | 49-086 | ocd-division/country:fi/kunta:espoo/kaupunginosa:086 | 2020-10-02T09:50:46.264258+03:00 | neighborhood | 11 | espoo | Luukki | Luk | ||||
5307 | 49-087 | ocd-division/country:fi/kunta:espoo/kaupunginosa:087 | 2020-10-02T09:50:46.273226+03:00 | neighborhood | 11 | espoo | Lahnus | Lahnus | ||||
5308 | 49-088 | ocd-division/country:fi/kunta:espoo/kaupunginosa:088 | 2020-10-02T09:50:46.282398+03:00 | neighborhood | 11 | espoo | Velskola | Vällskog | ||||
5309 | 49-089 | ocd-division/country:fi/kunta:espoo/kaupunginosa:089 | 2020-10-02T09:50:46.290468+03:00 | neighborhood | 11 | espoo | Lakisto | Lakisto | ||||
5310 | 49-090 | ocd-division/country:fi/kunta:espoo/kaupunginosa:090 | 2020-10-02T09:50:46.297831+03:00 | neighborhood | 11 | espoo | Vanha-Nuuksio | Gamla Noux | ||||
5311 | 49-091 | ocd-division/country:fi/kunta:espoo/kaupunginosa:091 | 2020-10-02T09:50:46.308632+03:00 | neighborhood | 11 | espoo | Ämmässuo | Käringmossen | ||||
5312 | 91-001 | ocd-division/country:fi/kunta:helsinki/kaupunginosa:001 | 2020-10-02T09:50:46.318089+03:00 | neighborhood | 32 | helsinki | Kruununhaka | Kronohagen | ||||
5313 | 91-002 | ocd-division/country:fi/kunta:helsinki/kaupunginosa:002 | 2020-10-02T09:50:46.326816+03:00 | neighborhood | 32 | helsinki | Kluuvi | Gloet | ||||
5314 | 91-003 | ocd-division/country:fi/kunta:helsinki/kaupunginosa:003 | 2020-10-02T09:50:46.335518+03:00 | neighborhood | 32 | helsinki | Kaartinkaupunki | Gardesstaden | ||||
5315 | 91-004 | ocd-division/country:fi/kunta:helsinki/kaupunginosa:004 | 2020-10-02T09:50:46.343397+03:00 | neighborhood | 32 | helsinki | Kamppi | Kampen | ||||
5316 | 91-005 | ocd-division/country:fi/kunta:helsinki/kaupunginosa:005 | 2020-10-02T09:50:46.351410+03:00 | neighborhood | 32 | helsinki | Punavuori | Rödbergen | ||||
5317 | 91-006 | ocd-division/country:fi/kunta:helsinki/kaupunginosa:006 | 2020-10-02T09:50:46.359529+03:00 | neighborhood | 32 | helsinki | Eira | Eira | ||||
5318 | 91-007 | ocd-division/country:fi/kunta:helsinki/kaupunginosa:007 | 2020-10-02T09:50:46.367257+03:00 | neighborhood | 32 | helsinki | Ullanlinna | Ulrikasborg | ||||
5319 | 91-008 | ocd-division/country:fi/kunta:helsinki/kaupunginosa:008 | 2020-10-02T09:50:46.375424+03:00 | neighborhood | 32 | helsinki | Katajanokka | Skatudden | ||||
5320 | 91-009 | ocd-division/country:fi/kunta:helsinki/kaupunginosa:009 | 2020-10-02T09:50:46.383236+03:00 | neighborhood | 32 | helsinki | Kaivopuisto | Brunnsparken | ||||
5321 | 91-010 | ocd-division/country:fi/kunta:helsinki/kaupunginosa:010 | 2020-10-02T09:50:46.391180+03:00 | neighborhood | 32 | helsinki | Sörnäinen | Sörnäs | ||||
5322 | 91-011 | ocd-division/country:fi/kunta:helsinki/kaupunginosa:011 | 2020-10-02T09:50:46.399528+03:00 | neighborhood | 32 | helsinki | Kallio | Berghäll | ||||
5323 | 91-012 | ocd-division/country:fi/kunta:helsinki/kaupunginosa:012 | 2020-10-02T09:50:46.407639+03:00 | neighborhood | 32 | helsinki | Alppiharju | Åshöjden | ||||
5324 | 91-013 | ocd-division/country:fi/kunta:helsinki/kaupunginosa:013 | 2020-10-02T09:50:46.414419+03:00 | neighborhood | 32 | helsinki | Etu-Töölö | Främre Tölö | ||||
5325 | 91-014 | ocd-division/country:fi/kunta:helsinki/kaupunginosa:014 | 2020-10-02T09:50:46.421477+03:00 | neighborhood | 32 | helsinki | Taka-Töölö | Bortre Tölö | ||||
5326 | 91-015 | ocd-division/country:fi/kunta:helsinki/kaupunginosa:015 | 2020-10-02T09:50:46.428104+03:00 | neighborhood | 32 | helsinki | Meilahti | Mejlans | ||||
5327 | 91-016 | ocd-division/country:fi/kunta:helsinki/kaupunginosa:016 | 2020-10-02T09:50:46.434852+03:00 | neighborhood | 32 | helsinki | Ruskeasuo | Brunakärr | ||||
5328 | 91-017 | ocd-division/country:fi/kunta:helsinki/kaupunginosa:017 | 2020-10-02T09:50:46.442499+03:00 | neighborhood | 32 | helsinki | Pasila | Böle | ||||
5329 | 91-018 | ocd-division/country:fi/kunta:helsinki/kaupunginosa:018 | 2020-10-02T09:50:46.450530+03:00 | neighborhood | 32 | helsinki | Laakso | Dal | ||||
5330 | 91-019 | ocd-division/country:fi/kunta:helsinki/kaupunginosa:019 | 2020-10-02T09:50:46.457386+03:00 | neighborhood | 32 | helsinki | Mustikkamaa-Korkeasaari | Blåbärslandet-Högholmen | ||||
5331 | 91-020 | ocd-division/country:fi/kunta:helsinki/kaupunginosa:020 | 2020-10-02T09:50:46.464549+03:00 | neighborhood | 32 | helsinki | Länsisatama | Västra Hamnen | ||||
5332 | 91-021 | ocd-division/country:fi/kunta:helsinki/kaupunginosa:021 | 2020-10-02T09:50:46.471828+03:00 | neighborhood | 32 | helsinki | Hermanni | Hermanstad | ||||
5333 | 91-022 | ocd-division/country:fi/kunta:helsinki/kaupunginosa:022 | 2020-10-02T09:50:46.479622+03:00 | neighborhood | 32 | helsinki | Vallila | Vallgård | ||||
5334 | 91-023 | ocd-division/country:fi/kunta:helsinki/kaupunginosa:023 | 2020-10-02T09:50:46.488096+03:00 | neighborhood | 32 | helsinki | Toukola | Majstad | ||||
5335 | 91-024 | ocd-division/country:fi/kunta:helsinki/kaupunginosa:024 | 2020-10-02T09:50:46.496281+03:00 | neighborhood | 32 | helsinki | Kumpula | Gumtäkt | ||||
5336 | 91-025 | ocd-division/country:fi/kunta:helsinki/kaupunginosa:025 | 2020-10-02T09:50:46.504281+03:00 | neighborhood | 32 | helsinki | Käpylä | Kottby | ||||
5337 | 91-026 | ocd-division/country:fi/kunta:helsinki/kaupunginosa:026 | 2020-10-02T09:50:46.512505+03:00 | neighborhood | 32 | helsinki | Koskela | Forsby | ||||
5338 | 91-027 | ocd-division/country:fi/kunta:helsinki/kaupunginosa:027 | 2020-10-02T09:50:46.519783+03:00 | neighborhood | 32 | helsinki | Vanhakaupunki | Gammelstaden | ||||
5339 | 91-028 | ocd-division/country:fi/kunta:helsinki/kaupunginosa:028 | 2020-10-02T09:50:46.528164+03:00 | neighborhood | 32 | helsinki | Oulunkylä | Åggelby | ||||
5340 | 91-029 | ocd-division/country:fi/kunta:helsinki/kaupunginosa:029 | 2020-10-02T09:50:46.536104+03:00 | neighborhood | 32 | helsinki | Haaga | Haga | ||||
5341 | 91-030 | ocd-division/country:fi/kunta:helsinki/kaupunginosa:030 | 2020-10-02T09:50:46.543999+03:00 | neighborhood | 32 | helsinki | Munkkiniemi | Munksnäs | ||||
5342 | 91-031 | ocd-division/country:fi/kunta:helsinki/kaupunginosa:031 | 2020-10-02T09:50:46.552290+03:00 | neighborhood | 32 | helsinki | Lauttasaari | Drumsö | ||||
5343 | 91-032 | ocd-division/country:fi/kunta:helsinki/kaupunginosa:032 | 2020-10-02T09:50:46.559057+03:00 | neighborhood | 32 | helsinki | Konala | Kånala | ||||
5344 | 91-033 | ocd-division/country:fi/kunta:helsinki/kaupunginosa:033 | 2020-10-02T09:50:46.566221+03:00 | neighborhood | 32 | helsinki | Kaarela | Kårböle | ||||
5345 | 91-034 | ocd-division/country:fi/kunta:helsinki/kaupunginosa:034 | 2020-10-02T09:50:46.573757+03:00 | neighborhood | 32 | helsinki | Pakila | Baggböle | ||||
5346 | 91-035 | ocd-division/country:fi/kunta:helsinki/kaupunginosa:035 | 2020-10-02T09:50:46.581332+03:00 | neighborhood | 32 | helsinki | Tuomarinkylä | Domarby | ||||
5347 | 91-036 | ocd-division/country:fi/kunta:helsinki/kaupunginosa:036 | 2020-10-02T09:50:46.587791+03:00 | neighborhood | 32 | helsinki | Viikki | Vik | ||||
5348 | 91-037 | ocd-division/country:fi/kunta:helsinki/kaupunginosa:037 | 2020-10-02T09:50:46.593929+03:00 | neighborhood | 32 | helsinki | Pukinmäki | Bocksbacka | ||||
5349 | 91-038 | ocd-division/country:fi/kunta:helsinki/kaupunginosa:038 | 2020-10-02T09:50:46.600784+03:00 | neighborhood | 32 | helsinki | Malmi | Malm | ||||
5350 | 91-039 | ocd-division/country:fi/kunta:helsinki/kaupunginosa:039 | 2020-10-02T09:50:46.612940+03:00 | neighborhood | 32 | helsinki | Tapaninkylä | Staffansby | ||||
5351 | 91-040 | ocd-division/country:fi/kunta:helsinki/kaupunginosa:040 | 2020-10-02T09:50:46.620872+03:00 | neighborhood | 32 | helsinki | Suutarila | Skomakarböle | ||||
5352 | 91-041 | ocd-division/country:fi/kunta:helsinki/kaupunginosa:041 | 2020-10-02T09:50:46.627938+03:00 | neighborhood | 32 | helsinki | Suurmetsä | Storskog | ||||
5353 | 91-042 | ocd-division/country:fi/kunta:helsinki/kaupunginosa:042 | 2020-10-02T09:50:46.635127+03:00 | neighborhood | 32 | helsinki | Kulosaari | Brändö | ||||
5354 | 91-043 | ocd-division/country:fi/kunta:helsinki/kaupunginosa:043 | 2020-10-02T09:50:46.641932+03:00 | neighborhood | 32 | helsinki | Herttoniemi | Hertonäs | ||||
5355 | 91-044 | ocd-division/country:fi/kunta:helsinki/kaupunginosa:044 | 2020-10-02T09:50:46.648547+03:00 | neighborhood | 32 | helsinki | Tammisalo | Tammelund |
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 );