administrative_division
148 rows where type = "sub_district" sorted by modified_at
This data as json, CSV (advanced)
Suggested facets: modified_at (date)
id | origin_id | ocd_id | service_point_id | start | end | modified_at ▼ | type | parent | municipality | name_fi | name_sv | name |
---|---|---|---|---|---|---|---|---|---|---|---|---|
356 | 010 | ocd-division/country:fi/kunta:helsinki/osa-alue:kruununhaka | 2020-12-07T13:38:25.110948+02:00 | sub_district | 322 | helsinki | Kruununhaka | Kronohagen | ||||
357 | 020 | ocd-division/country:fi/kunta:helsinki/osa-alue:kluuvi | 2020-12-07T13:38:25.132372+02:00 | sub_district | 322 | helsinki | Kluuvi | Gloet | ||||
358 | 030 | ocd-division/country:fi/kunta:helsinki/osa-alue:kaartinkaupunki | 2020-12-07T13:38:25.152388+02:00 | sub_district | 323 | helsinki | Kaartinkaupunki | Gardesstaden | ||||
359 | 040 | ocd-division/country:fi/kunta:helsinki/osa-alue:kamppi | 2020-12-07T13:38:25.175135+02:00 | sub_district | 324 | helsinki | Kamppi | Kampen | ||||
360 | 050 | ocd-division/country:fi/kunta:helsinki/osa-alue:punavuori | 2020-12-07T13:38:25.196254+02:00 | sub_district | 323 | helsinki | Punavuori | Rödbergen | ||||
361 | 060 | ocd-division/country:fi/kunta:helsinki/osa-alue:eira | 2020-12-07T13:38:25.214439+02:00 | sub_district | 323 | helsinki | Eira | Eira | ||||
362 | 070 | ocd-division/country:fi/kunta:helsinki/osa-alue:ullanlinna | 2020-12-07T13:38:25.234465+02:00 | sub_district | 323 | helsinki | Ullanlinna | Ulrikasborg | ||||
363 | 080 | ocd-division/country:fi/kunta:helsinki/osa-alue:katajanokka | 2020-12-07T13:38:25.251144+02:00 | sub_district | 322 | helsinki | Katajanokka | Skatudden | ||||
364 | 090 | ocd-division/country:fi/kunta:helsinki/osa-alue:kaivopuisto | 2020-12-07T13:38:25.264236+02:00 | sub_district | 323 | helsinki | Kaivopuisto | Brunnsparken | ||||
365 | 101 | ocd-division/country:fi/kunta:helsinki/osa-alue:vilhonvuori | 2020-12-07T13:38:25.278657+02:00 | sub_district | 332 | helsinki | Vilhonvuori | Vilhemsberg | ||||
366 | 102 | ocd-division/country:fi/kunta:helsinki/osa-alue:kalasatama | 2020-12-07T13:38:25.302141+02:00 | sub_district | 332 | helsinki | Kalasatama | Fiskehamnen | ||||
367 | 103 | ocd-division/country:fi/kunta:helsinki/osa-alue:sompasaari | 2020-12-07T13:38:25.321184+02:00 | sub_district | 332 | helsinki | Sompasaari | Sumparn | ||||
368 | 104 | ocd-division/country:fi/kunta:helsinki/osa-alue:hanasaari | 2020-12-07T13:38:25.341607+02:00 | sub_district | 332 | helsinki | Hanasaari | Hanaholmen | ||||
369 | 111 | ocd-division/country:fi/kunta:helsinki/osa-alue:siltasaari | 2020-12-07T13:38:25.362679+02:00 | sub_district | 332 | helsinki | Siltasaari | Broholmen | ||||
370 | 112 | ocd-division/country:fi/kunta:helsinki/osa-alue:linjat | 2020-12-07T13:38:25.376023+02:00 | sub_district | 332 | helsinki | Linjat | Linjerna | ||||
371 | 113 | ocd-division/country:fi/kunta:helsinki/osa-alue:torkkelinmäki | 2020-12-07T13:38:25.391475+02:00 | sub_district | 332 | helsinki | Torkkelinmäki | Torkelsbacken | ||||
372 | 121 | ocd-division/country:fi/kunta:helsinki/osa-alue:harju | 2020-12-07T13:38:25.406328+02:00 | sub_district | 333 | helsinki | Harju | Ås | ||||
373 | 122 | ocd-division/country:fi/kunta:helsinki/osa-alue:alppila | 2020-12-07T13:38:25.419999+02:00 | sub_district | 333 | helsinki | Alppila | Alphyddan | ||||
374 | 130 | ocd-division/country:fi/kunta:helsinki/osa-alue:etu-töölö | 2020-12-07T13:38:25.435310+02:00 | sub_district | 324 | helsinki | Etu-Töölö | Främre Tölö | ||||
375 | 140 | ocd-division/country:fi/kunta:helsinki/osa-alue:taka-töölö | 2020-12-07T13:38:25.450214+02:00 | sub_district | 325 | helsinki | Taka-Töölö | Bortre Tölö | ||||
376 | 150 | ocd-division/country:fi/kunta:helsinki/osa-alue:meilahti | 2020-12-07T13:38:25.465634+02:00 | sub_district | 327 | helsinki | Meilahti | Mejlans | ||||
377 | 161 | ocd-division/country:fi/kunta:helsinki/osa-alue:vanha_ruskeasuo | 2020-12-07T13:38:25.482221+02:00 | sub_district | 327 | helsinki | Vanha Ruskeasuo | Gamla Brunakärr | ||||
378 | 162 | ocd-division/country:fi/kunta:helsinki/osa-alue:pikku_huopalahti | 2020-12-07T13:38:25.498948+02:00 | sub_district | 327 | helsinki | Pikku Huopalahti | Lillhoplax | ||||
379 | 171 | ocd-division/country:fi/kunta:helsinki/osa-alue:länsi-pasila | 2020-12-07T13:38:25.520581+02:00 | sub_district | 335 | helsinki | Länsi-Pasila | Västra Böle | ||||
380 | 172 | ocd-division/country:fi/kunta:helsinki/osa-alue:pohjois-pasila | 2020-12-07T13:38:25.535630+02:00 | sub_district | 335 | helsinki | Pohjois-Pasila | Norra Böle | ||||
381 | 173 | ocd-division/country:fi/kunta:helsinki/osa-alue:itä-pasila | 2020-12-07T13:38:25.551747+02:00 | sub_district | 335 | helsinki | Itä-Pasila | Östra Böle | ||||
382 | 174 | ocd-division/country:fi/kunta:helsinki/osa-alue:keski-pasila | 2020-12-07T13:38:25.567147+02:00 | sub_district | 335 | helsinki | Keski-Pasila | Mellersta Böle | ||||
383 | 180 | ocd-division/country:fi/kunta:helsinki/osa-alue:laakso | 2020-12-07T13:38:25.581847+02:00 | sub_district | 327 | helsinki | Laakso | Dal | ||||
384 | 190 | ocd-division/country:fi/kunta:helsinki/osa-alue:mustikkamaa-korkeasaari | 2020-12-07T13:38:25.594394+02:00 | sub_district | 348 | helsinki | Mustikkamaa-Korkeasaari | Blåbärslandet-Högholmen | ||||
385 | 201 | ocd-division/country:fi/kunta:helsinki/osa-alue:ruoholahti | 2020-12-07T13:38:25.606036+02:00 | sub_district | 324 | helsinki | Ruoholahti | Gräsviken | ||||
386 | 202 | ocd-division/country:fi/kunta:helsinki/osa-alue:lapinlahti | 2020-12-07T13:38:25.622837+02:00 | sub_district | 324 | helsinki | Lapinlahti | Lappviken | ||||
387 | 203 | ocd-division/country:fi/kunta:helsinki/osa-alue:jätkäsaari | 2020-12-07T13:38:25.634537+02:00 | sub_district | 324 | helsinki | Jätkäsaari | Busholmen | ||||
388 | 204 | ocd-division/country:fi/kunta:helsinki/osa-alue:hernesaari | 2020-12-07T13:38:25.652562+02:00 | sub_district | 323 | helsinki | Hernesaari | Ärtholmen | ||||
389 | 211 | ocd-division/country:fi/kunta:helsinki/osa-alue:hermanninmäki | 2020-12-07T13:38:25.665674+02:00 | sub_district | 334 | helsinki | Hermanninmäki | Hermanstadsbacken | ||||
390 | 212 | ocd-division/country:fi/kunta:helsinki/osa-alue:hermanninranta | 2020-12-07T13:38:25.677235+02:00 | sub_district | 334 | helsinki | Hermanninranta | Hermanstadsstranden | ||||
391 | 213 | ocd-division/country:fi/kunta:helsinki/osa-alue:kyläsaari | 2020-12-07T13:38:25.689767+02:00 | sub_district | 334 | helsinki | Kyläsaari | Byholmen | ||||
392 | 220 | ocd-division/country:fi/kunta:helsinki/osa-alue:vallila | 2020-12-07T13:38:25.716364+02:00 | sub_district | 334 | helsinki | Vallila | Vallgård | ||||
393 | 231 | ocd-division/country:fi/kunta:helsinki/osa-alue:toukola | 2020-12-07T13:38:25.731479+02:00 | sub_district | 336 | helsinki | Toukola | Majstad | ||||
394 | 232 | ocd-division/country:fi/kunta:helsinki/osa-alue:arabianranta | 2020-12-07T13:38:25.752252+02:00 | sub_district | 336 | helsinki | Arabianranta | Arabiastranden | ||||
395 | 240 | ocd-division/country:fi/kunta:helsinki/osa-alue:kumpula | 2020-12-07T13:38:25.770687+02:00 | sub_district | 336 | helsinki | Kumpula | Gumtäkt | ||||
396 | 250 | ocd-division/country:fi/kunta:helsinki/osa-alue:käpylä | 2020-12-07T13:38:25.791584+02:00 | sub_district | 336 | helsinki | Käpylä | Kottby | ||||
397 | 260 | ocd-division/country:fi/kunta:helsinki/osa-alue:koskela | 2020-12-07T13:38:25.810499+02:00 | sub_district | 336 | helsinki | Koskela | Forsby | ||||
398 | 270 | ocd-division/country:fi/kunta:helsinki/osa-alue:vanhakaupunki | 2020-12-07T13:38:25.827943+02:00 | sub_district | 336 | helsinki | Vanhakaupunki | Gammelstaden | ||||
399 | 281 | ocd-division/country:fi/kunta:helsinki/osa-alue:pirkkola | 2020-12-07T13:38:25.841996+02:00 | sub_district | 337 | helsinki | Pirkkola | Britas | ||||
400 | 282 | ocd-division/country:fi/kunta:helsinki/osa-alue:maunula | 2020-12-07T13:38:25.859538+02:00 | sub_district | 337 | helsinki | Maunula | Månsas | ||||
401 | 283 | ocd-division/country:fi/kunta:helsinki/osa-alue:metsälä | 2020-12-07T13:38:25.873627+02:00 | sub_district | 337 | helsinki | Metsälä | Krämertsskog | ||||
402 | 284 | ocd-division/country:fi/kunta:helsinki/osa-alue:patola | 2020-12-07T13:38:25.893571+02:00 | sub_district | 340 | helsinki | Patola | Dammen | ||||
403 | 285 | ocd-division/country:fi/kunta:helsinki/osa-alue:veräjämäki | 2020-12-07T13:38:25.907855+02:00 | sub_district | 340 | helsinki | Veräjämäki | Grindbacka | ||||
404 | 286 | ocd-division/country:fi/kunta:helsinki/osa-alue:maunulanpuisto | 2020-12-07T13:38:25.929660+02:00 | sub_district | 337 | helsinki | Maunulanpuisto | Månsasparken | ||||
405 | 287 | ocd-division/country:fi/kunta:helsinki/osa-alue:veräjälaakso | 2020-12-07T13:38:25.948345+02:00 | sub_district | 340 | helsinki | Veräjälaakso | Grinddal | ||||
406 | 291 | ocd-division/country:fi/kunta:helsinki/osa-alue:etelä-haaga | 2020-12-07T13:38:25.969815+02:00 | sub_district | 329 | helsinki | Etelä-Haaga | Södra Haga | ||||
407 | 292 | ocd-division/country:fi/kunta:helsinki/osa-alue:kivihaka | 2020-12-07T13:38:25.985092+02:00 | sub_district | 329 | helsinki | Kivihaka | Stenhagen | ||||
408 | 293 | ocd-division/country:fi/kunta:helsinki/osa-alue:pohjois-haaga | 2020-12-07T13:38:26.004154+02:00 | sub_district | 329 | helsinki | Pohjois-Haaga | Norra Haga | ||||
409 | 294 | ocd-division/country:fi/kunta:helsinki/osa-alue:lassila | 2020-12-07T13:38:26.018861+02:00 | sub_district | 329 | helsinki | Lassila | Lassas | ||||
410 | 301 | ocd-division/country:fi/kunta:helsinki/osa-alue:vanha_munkkiniemi | 2020-12-07T13:38:26.031777+02:00 | sub_district | 328 | helsinki | Vanha Munkkiniemi | Gamla Munksnäs | ||||
411 | 302 | ocd-division/country:fi/kunta:helsinki/osa-alue:kuusisaari | 2020-12-07T13:38:26.043044+02:00 | sub_district | 328 | helsinki | Kuusisaari | Granö | ||||
412 | 303 | ocd-division/country:fi/kunta:helsinki/osa-alue:lehtisaari | 2020-12-07T13:38:26.053960+02:00 | sub_district | 328 | helsinki | Lehtisaari | Lövö | ||||
413 | 304 | ocd-division/country:fi/kunta:helsinki/osa-alue:munkkivuori | 2020-12-07T13:38:26.066501+02:00 | sub_district | 328 | helsinki | Munkkivuori | Munkshöjden | ||||
414 | 305 | ocd-division/country:fi/kunta:helsinki/osa-alue:niemenmäki | 2020-12-07T13:38:26.078506+02:00 | sub_district | 328 | helsinki | Niemenmäki | Näshöjden | ||||
415 | 306 | ocd-division/country:fi/kunta:helsinki/osa-alue:talinranta | 2020-12-07T13:38:26.089263+02:00 | sub_district | 328 | helsinki | Talinranta | Talistranden | ||||
416 | 311 | ocd-division/country:fi/kunta:helsinki/osa-alue:kotkavuori | 2020-12-07T13:38:26.103080+02:00 | sub_district | 326 | helsinki | Kotkavuori | Örnberget | ||||
417 | 312 | ocd-division/country:fi/kunta:helsinki/osa-alue:vattuniemi | 2020-12-07T13:38:26.116092+02:00 | sub_district | 326 | helsinki | Vattuniemi | Hallonnäs | ||||
418 | 313 | ocd-division/country:fi/kunta:helsinki/osa-alue:myllykallio | 2020-12-07T13:38:26.129461+02:00 | sub_district | 326 | helsinki | Myllykallio | Kvarnberget | ||||
419 | 314 | ocd-division/country:fi/kunta:helsinki/osa-alue:koivusaari | 2020-12-07T13:38:26.141316+02:00 | sub_district | 326 | helsinki | Koivusaari | Björkholmen | ||||
420 | 320 | ocd-division/country:fi/kunta:helsinki/osa-alue:konala | 2020-12-07T13:38:26.156155+02:00 | sub_district | 330 | helsinki | Konala | Kånala | ||||
421 | 331 | ocd-division/country:fi/kunta:helsinki/osa-alue:kannelmäki | 2020-12-07T13:38:26.172362+02:00 | sub_district | 331 | helsinki | Kannelmäki | Gamlas | ||||
422 | 332 | ocd-division/country:fi/kunta:helsinki/osa-alue:maununneva | 2020-12-07T13:38:26.190448+02:00 | sub_district | 331 | helsinki | Maununneva | Magnuskärr | ||||
423 | 333 | ocd-division/country:fi/kunta:helsinki/osa-alue:malminkartano | 2020-12-07T13:38:26.209109+02:00 | sub_district | 331 | helsinki | Malminkartano | Malmgård | ||||
424 | 334 | ocd-division/country:fi/kunta:helsinki/osa-alue:hakuninmaa | 2020-12-07T13:38:26.224540+02:00 | sub_district | 331 | helsinki | Hakuninmaa | Håkansåker | ||||
425 | 335 | ocd-division/country:fi/kunta:helsinki/osa-alue:kuninkaantammi | 2020-12-07T13:38:26.238069+02:00 | sub_district | 331 | helsinki | Kuninkaantammi | Kungseken | ||||
426 | 336 | ocd-division/country:fi/kunta:helsinki/osa-alue:honkasuo | 2020-12-07T13:38:26.249625+02:00 | sub_district | 331 | helsinki | Honkasuo | Hongasmossa | ||||
427 | 341 | ocd-division/country:fi/kunta:helsinki/osa-alue:länsi-pakila | 2020-12-07T13:38:26.269646+02:00 | sub_district | 338 | helsinki | Länsi-Pakila | Västra Baggböle | ||||
428 | 342 | ocd-division/country:fi/kunta:helsinki/osa-alue:itä-pakila | 2020-12-07T13:38:26.289545+02:00 | sub_district | 341 | helsinki | Itä-Pakila | Östra Baggböle | ||||
429 | 351 | ocd-division/country:fi/kunta:helsinki/osa-alue:paloheinä | 2020-12-07T13:38:26.305671+02:00 | sub_district | 339 | helsinki | Paloheinä | Svedängen | ||||
430 | 352 | ocd-division/country:fi/kunta:helsinki/osa-alue:torpparinmäki | 2020-12-07T13:38:26.318980+02:00 | sub_district | 339 | helsinki | Torpparinmäki | Torparbacken | ||||
431 | 353 | ocd-division/country:fi/kunta:helsinki/osa-alue:tuomarinkartano | 2020-12-07T13:38:26.334224+02:00 | sub_district | 341 | helsinki | Tuomarinkartano | Domargård | ||||
432 | 354 | ocd-division/country:fi/kunta:helsinki/osa-alue:haltiala | 2020-12-07T13:38:26.354144+02:00 | sub_district | 339 | helsinki | Haltiala | Tomtbacka | ||||
433 | 361 | ocd-division/country:fi/kunta:helsinki/osa-alue:viikinranta | 2020-12-07T13:38:26.373605+02:00 | sub_district | 342 | helsinki | Viikinranta | Viksstranden | ||||
434 | 362 | ocd-division/country:fi/kunta:helsinki/osa-alue:latokartano | 2020-12-07T13:38:26.389944+02:00 | sub_district | 342 | helsinki | Latokartano | Ladugården | ||||
435 | 363 | ocd-division/country:fi/kunta:helsinki/osa-alue:viikin_tiedepuisto | 2020-12-07T13:38:26.404735+02:00 | sub_district | 342 | helsinki | Viikin tiedepuisto | Viks forskarpark | ||||
436 | 364 | ocd-division/country:fi/kunta:helsinki/osa-alue:viikinmäki | 2020-12-07T13:38:26.419075+02:00 | sub_district | 342 | helsinki | Viikinmäki | Viksbacka | ||||
437 | 370 | ocd-division/country:fi/kunta:helsinki/osa-alue:pukinmäki | 2020-12-07T13:38:26.435617+02:00 | sub_district | 343 | helsinki | Pukinmäki | Bocksbacka | ||||
438 | 381 | ocd-division/country:fi/kunta:helsinki/osa-alue:ylä-malmi | 2020-12-07T13:38:26.451255+02:00 | sub_district | 344 | helsinki | Ylä-Malmi | Övre Malm | ||||
439 | 382 | ocd-division/country:fi/kunta:helsinki/osa-alue:ala-malmi | 2020-12-07T13:38:26.473364+02:00 | sub_district | 344 | helsinki | Ala-Malmi | Nedre Malm | ||||
440 | 383 | ocd-division/country:fi/kunta:helsinki/osa-alue:pihlajamäki | 2020-12-07T13:38:26.491167+02:00 | sub_district | 342 | helsinki | Pihlajamäki | Rönnbacka | ||||
441 | 384 | ocd-division/country:fi/kunta:helsinki/osa-alue:tattariharju | 2020-12-07T13:38:26.507457+02:00 | sub_district | 344 | helsinki | Tattariharju | Tattaråsen | ||||
442 | 385 | ocd-division/country:fi/kunta:helsinki/osa-alue:malmin_lentokenttä | 2020-12-07T13:38:26.523145+02:00 | sub_district | 344 | helsinki | Malmin lentokenttä | Malms flygfält | ||||
443 | 386 | ocd-division/country:fi/kunta:helsinki/osa-alue:pihlajisto | 2020-12-07T13:38:26.539376+02:00 | sub_district | 342 | helsinki | Pihlajisto | Rönninge | ||||
444 | 391 | ocd-division/country:fi/kunta:helsinki/osa-alue:tapaninvainio | 2020-12-07T13:38:26.559743+02:00 | sub_district | 344 | helsinki | Tapaninvainio | Staffansslätten | ||||
445 | 392 | ocd-division/country:fi/kunta:helsinki/osa-alue:tapanila | 2020-12-07T13:38:26.575932+02:00 | sub_district | 344 | helsinki | Tapanila | Mosabacka | ||||
446 | 401 | ocd-division/country:fi/kunta:helsinki/osa-alue:siltamäki | 2020-12-07T13:38:26.599731+02:00 | sub_district | 345 | helsinki | Siltamäki | Brobacka | ||||
447 | 402 | ocd-division/country:fi/kunta:helsinki/osa-alue:tapulikaupunki | 2020-12-07T13:38:26.624236+02:00 | sub_district | 346 | helsinki | Tapulikaupunki | Stapelstaden | ||||
448 | 403 | ocd-division/country:fi/kunta:helsinki/osa-alue:töyrynummi | 2020-12-07T13:38:26.642449+02:00 | sub_district | 345 | helsinki | Töyrynummi | Lidmalmen | ||||
449 | 411 | ocd-division/country:fi/kunta:helsinki/osa-alue:puistola | 2020-12-07T13:38:26.666037+02:00 | sub_district | 346 | helsinki | Puistola | Parkstad | ||||
450 | 412 | ocd-division/country:fi/kunta:helsinki/osa-alue:heikinlaakso | 2020-12-07T13:38:26.683908+02:00 | sub_district | 346 | helsinki | Heikinlaakso | Henriksdal | ||||
451 | 413 | ocd-division/country:fi/kunta:helsinki/osa-alue:tattarisuo | 2020-12-07T13:38:26.704551+02:00 | sub_district | 346 | helsinki | Tattarisuo | Tattarmossen | ||||
452 | 414 | ocd-division/country:fi/kunta:helsinki/osa-alue:jakomäki | 2020-12-07T13:38:26.727230+02:00 | sub_district | 347 | helsinki | Jakomäki | Jakobacka | ||||
453 | 415 | ocd-division/country:fi/kunta:helsinki/osa-alue:alppikylä | 2020-12-07T13:38:26.751505+02:00 | sub_district | 346 | helsinki | Alppikylä | Alpbyn | ||||
454 | 420 | ocd-division/country:fi/kunta:helsinki/osa-alue:kulosaari | 2020-12-07T13:38:26.774501+02:00 | sub_district | 348 | helsinki | Kulosaari | Brändö | ||||
455 | 431 | ocd-division/country:fi/kunta:helsinki/osa-alue:länsi-herttoniemi | 2020-12-07T13:38:26.798760+02:00 | sub_district | 349 | helsinki | Länsi-Herttoniemi | Västra Hertonäs |
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 );