administrative_division
2,760 rows sorted by parent descending
This data as json, CSV (advanced)
Suggested facets: start, type, municipality, start (date), end (date), modified_at (date)
end ✖
- 2022-08-01 453
- 2021-08-01 256
| id | origin_id | ocd_id | service_point_id | start | end | modified_at | type | parent ▲ | municipality | name_fi | name_sv | name |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 517 | 0 | ocd-division/country:fi/kunta:helsinki/osa-alue:puroniitty/pienalue:0 | 2020-12-07T13:38:29.088533+02:00 | small_district | 503 | helsinki | ||||||
| 523 | 0 | ocd-division/country:fi/kunta:helsinki/osa-alue:landbo/pienalue:0 | 2020-12-07T13:38:29.132048+02:00 | small_district | 502 | helsinki | ||||||
| 512 | 0 | ocd-division/country:fi/kunta:helsinki/osa-alue:karhusaari/pienalue:0 | 2020-12-07T13:38:29.072317+02:00 | small_district | 501 | helsinki | ||||||
| 522 | 0 | ocd-division/country:fi/kunta:helsinki/osa-alue:talosaari/pienalue:0 | 2020-12-07T13:38:29.036345+02:00 | small_district | 500 | helsinki | ||||||
| 536 | 0 | ocd-division/country:fi/kunta:helsinki/osa-alue:salmenkallio/pienalue:0 | 2020-12-07T13:38:29.039994+02:00 | small_district | 499 | helsinki | ||||||
| 541 | 0 | ocd-division/country:fi/kunta:helsinki/osa-alue:östersundom/pienalue:0 | 2020-12-07T13:38:29.018002+02:00 | small_district | 498 | helsinki | ||||||
| 510 | 0 | ocd-division/country:fi/kunta:helsinki/osa-alue:mustavuori/pienalue:0 | 2020-12-07T13:38:29.075738+02:00 | small_district | 497 | helsinki | ||||||
| 643 | 1 | ocd-division/country:fi/kunta:helsinki/osa-alue:niinisaari/pienalue:1 | 2020-12-07T13:38:29.495970+02:00 | small_district | 496 | helsinki | ||||||
| 725 | 2 | ocd-division/country:fi/kunta:helsinki/osa-alue:niinisaari/pienalue:2 | 2020-12-07T13:38:29.700079+02:00 | small_district | 496 | helsinki | ||||||
| 757 | 3 | ocd-division/country:fi/kunta:helsinki/osa-alue:niinisaari/pienalue:3 | 2020-12-07T13:38:29.969229+02:00 | small_district | 496 | helsinki | ||||||
| 605 | 1 | ocd-division/country:fi/kunta:helsinki/osa-alue:rastila/pienalue:1 | 2020-12-07T13:38:29.517733+02:00 | small_district | 495 | helsinki | ||||||
| 698 | 2 | ocd-division/country:fi/kunta:helsinki/osa-alue:rastila/pienalue:2 | 2020-12-07T13:38:29.820340+02:00 | small_district | 495 | helsinki | ||||||
| 566 | 1 | ocd-division/country:fi/kunta:helsinki/osa-alue:aurinkolahti/pienalue:1 | 2020-12-07T13:38:29.453417+02:00 | small_district | 494 | helsinki | ||||||
| 679 | 2 | ocd-division/country:fi/kunta:helsinki/osa-alue:aurinkolahti/pienalue:2 | 2020-12-07T13:38:29.588067+02:00 | small_district | 494 | helsinki | ||||||
| 758 | 3 | ocd-division/country:fi/kunta:helsinki/osa-alue:aurinkolahti/pienalue:3 | 2020-12-07T13:38:30.022616+02:00 | small_district | 494 | helsinki | ||||||
| 575 | 1 | ocd-division/country:fi/kunta:helsinki/osa-alue:kallahti/pienalue:1 | 2020-12-07T13:38:29.385489+02:00 | small_district | 493 | helsinki | ||||||
| 720 | 2 | ocd-division/country:fi/kunta:helsinki/osa-alue:kallahti/pienalue:2 | 2020-12-07T13:38:29.724146+02:00 | small_district | 493 | helsinki | ||||||
| 798 | 3 | ocd-division/country:fi/kunta:helsinki/osa-alue:kallahti/pienalue:3 | 2020-12-07T13:38:30.001974+02:00 | small_district | 493 | helsinki | ||||||
| 622 | 1 | ocd-division/country:fi/kunta:helsinki/osa-alue:meri-rastila/pienalue:1 | 2020-12-07T13:38:29.478394+02:00 | small_district | 492 | helsinki | ||||||
| 734 | 2 | ocd-division/country:fi/kunta:helsinki/osa-alue:meri-rastila/pienalue:2 | 2020-12-07T13:38:29.585210+02:00 | small_district | 492 | helsinki | ||||||
| 759 | 3 | ocd-division/country:fi/kunta:helsinki/osa-alue:meri-rastila/pienalue:3 | 2020-12-07T13:38:29.891348+02:00 | small_district | 492 | helsinki | ||||||
| 832 | 4 | ocd-division/country:fi/kunta:helsinki/osa-alue:meri-rastila/pienalue:4 | 2020-12-07T13:38:30.261818+02:00 | small_district | 492 | helsinki | ||||||
| 546 | 0 | ocd-division/country:fi/kunta:helsinki/osa-alue:uutela/pienalue:0 | 2020-12-07T13:38:29.005343+02:00 | small_district | 491 | helsinki | ||||||
| 526 | 0 | ocd-division/country:fi/kunta:helsinki/osa-alue:nordsjön_kartano/pienalue:0 | 2020-12-07T13:38:29.158484+02:00 | small_district | 490 | helsinki | ||||||
| 577 | 1 | ocd-division/country:fi/kunta:helsinki/osa-alue:keski-vuosaari/pienalue:1 | 2020-12-07T13:38:29.236802+02:00 | small_district | 489 | helsinki | ||||||
| 669 | 2 | ocd-division/country:fi/kunta:helsinki/osa-alue:keski-vuosaari/pienalue:2 | 2020-12-07T13:38:29.841705+02:00 | small_district | 489 | helsinki | ||||||
| 850 | 4 | ocd-division/country:fi/kunta:helsinki/osa-alue:keski-vuosaari/pienalue:4 | 2020-12-07T13:38:30.270559+02:00 | small_district | 489 | helsinki | ||||||
| 884 | 6 | ocd-division/country:fi/kunta:helsinki/osa-alue:keski-vuosaari/pienalue:6 | 2020-12-07T13:38:30.459298+02:00 | small_district | 489 | helsinki | ||||||
| 903 | 8 | ocd-division/country:fi/kunta:helsinki/osa-alue:keski-vuosaari/pienalue:8 | 2020-12-07T13:38:30.521233+02:00 | small_district | 489 | helsinki | ||||||
| 907 | 9 | ocd-division/country:fi/kunta:helsinki/osa-alue:keski-vuosaari/pienalue:9 | 2020-12-07T13:38:30.528583+02:00 | small_district | 489 | helsinki | ||||||
| 543 | 0 | ocd-division/country:fi/kunta:helsinki/osa-alue:aluemeri/pienalue:0 | 2020-12-07T13:38:29.091894+02:00 | small_district | 488 | helsinki | ||||||
| 603 | 1 | ocd-division/country:fi/kunta:helsinki/osa-alue:itäsaaret/pienalue:1 | 2020-12-07T13:38:29.393079+02:00 | small_district | 487 | helsinki | ||||||
| 732 | 2 | ocd-division/country:fi/kunta:helsinki/osa-alue:itäsaaret/pienalue:2 | 2020-12-07T13:38:29.708972+02:00 | small_district | 487 | helsinki | ||||||
| 646 | 1 | ocd-division/country:fi/kunta:helsinki/osa-alue:länsisaaret/pienalue:1 | 2020-12-07T13:38:29.266267+02:00 | small_district | 486 | helsinki | ||||||
| 684 | 2 | ocd-division/country:fi/kunta:helsinki/osa-alue:länsisaaret/pienalue:2 | 2020-12-07T13:38:29.607779+02:00 | small_district | 486 | helsinki | ||||||
| 617 | 1 | ocd-division/country:fi/kunta:helsinki/osa-alue:suomenlinna/pienalue:1 | 2020-12-07T13:38:29.240481+02:00 | small_district | 485 | helsinki | ||||||
| 655 | 2 | ocd-division/country:fi/kunta:helsinki/osa-alue:suomenlinna/pienalue:2 | 2020-12-07T13:38:29.748026+02:00 | small_district | 485 | helsinki | ||||||
| 787 | 3 | ocd-division/country:fi/kunta:helsinki/osa-alue:suomenlinna/pienalue:3 | 2020-12-07T13:38:29.905380+02:00 | small_district | 485 | helsinki | ||||||
| 520 | 0 | ocd-division/country:fi/kunta:helsinki/osa-alue:santahamina/pienalue:0 | 2020-12-07T13:38:29.009337+02:00 | small_district | 484 | helsinki | ||||||
| 574 | 1 | ocd-division/country:fi/kunta:helsinki/osa-alue:villinki/pienalue:1 | 2020-12-07T13:38:29.362276+02:00 | small_district | 483 | helsinki | ||||||
| 729 | 2 | ocd-division/country:fi/kunta:helsinki/osa-alue:villinki/pienalue:2 | 2020-12-07T13:38:29.808859+02:00 | small_district | 483 | helsinki | ||||||
| 555 | 1 | ocd-division/country:fi/kunta:helsinki/osa-alue:hevossalmi/pienalue:1 | 2020-12-07T13:38:29.294890+02:00 | small_district | 482 | helsinki | ||||||
| 677 | 2 | ocd-division/country:fi/kunta:helsinki/osa-alue:hevossalmi/pienalue:2 | 2020-12-07T13:38:29.596279+02:00 | small_district | 482 | helsinki | ||||||
| 640 | 1 | ocd-division/country:fi/kunta:helsinki/osa-alue:kruunuvuorenranta/pienalue:1 | 2020-12-07T13:38:29.272872+02:00 | small_district | 481 | helsinki | ||||||
| 692 | 2 | ocd-division/country:fi/kunta:helsinki/osa-alue:kruunuvuorenranta/pienalue:2 | 2020-12-07T13:38:29.616665+02:00 | small_district | 481 | helsinki | ||||||
| 808 | 3 | ocd-division/country:fi/kunta:helsinki/osa-alue:kruunuvuorenranta/pienalue:3 | 2020-12-07T13:38:29.961233+02:00 | small_district | 481 | helsinki | ||||||
| 833 | 4 | ocd-division/country:fi/kunta:helsinki/osa-alue:kruunuvuorenranta/pienalue:4 | 2020-12-07T13:38:30.282503+02:00 | small_district | 481 | helsinki | ||||||
| 870 | 5 | ocd-division/country:fi/kunta:helsinki/osa-alue:kruunuvuorenranta/pienalue:5 | 2020-12-07T13:38:30.363407+02:00 | small_district | 481 | helsinki | ||||||
| 882 | 6 | ocd-division/country:fi/kunta:helsinki/osa-alue:kruunuvuorenranta/pienalue:6 | 2020-12-07T13:38:30.425578+02:00 | small_district | 481 | helsinki | ||||||
| 901 | 7 | ocd-division/country:fi/kunta:helsinki/osa-alue:kruunuvuorenranta/pienalue:7 | 2020-12-07T13:38:30.504458+02:00 | small_district | 481 | helsinki | ||||||
| 573 | 1 | ocd-division/country:fi/kunta:helsinki/osa-alue:tullisaari/pienalue:1 | 2020-12-07T13:38:29.425514+02:00 | small_district | 480 | helsinki | ||||||
| 678 | 2 | ocd-division/country:fi/kunta:helsinki/osa-alue:tullisaari/pienalue:2 | 2020-12-07T13:38:29.555108+02:00 | small_district | 480 | helsinki | ||||||
| 599 | 1 | ocd-division/country:fi/kunta:helsinki/osa-alue:jollas/pienalue:1 | 2020-12-07T13:38:29.196574+02:00 | small_district | 479 | helsinki | ||||||
| 741 | 2 | ocd-division/country:fi/kunta:helsinki/osa-alue:jollas/pienalue:2 | 2020-12-07T13:38:29.855201+02:00 | small_district | 479 | helsinki | ||||||
| 804 | 3 | ocd-division/country:fi/kunta:helsinki/osa-alue:jollas/pienalue:3 | 2020-12-07T13:38:30.019354+02:00 | small_district | 479 | helsinki | ||||||
| 572 | 1 | ocd-division/country:fi/kunta:helsinki/osa-alue:yliskylä/pienalue:1 | 2020-12-07T13:38:29.369322+02:00 | small_district | 478 | helsinki | ||||||
| 654 | 2 | ocd-division/country:fi/kunta:helsinki/osa-alue:yliskylä/pienalue:2 | 2020-12-07T13:38:29.744768+02:00 | small_district | 478 | helsinki | ||||||
| 801 | 3 | ocd-division/country:fi/kunta:helsinki/osa-alue:yliskylä/pienalue:3 | 2020-12-07T13:38:30.015794+02:00 | small_district | 478 | helsinki | ||||||
| 844 | 4 | ocd-division/country:fi/kunta:helsinki/osa-alue:yliskylä/pienalue:4 | 2020-12-07T13:38:30.254589+02:00 | small_district | 478 | helsinki | ||||||
| 866 | 5 | ocd-division/country:fi/kunta:helsinki/osa-alue:yliskylä/pienalue:5 | 2020-12-07T13:38:30.295997+02:00 | small_district | 478 | helsinki | ||||||
| 886 | 6 | ocd-division/country:fi/kunta:helsinki/osa-alue:yliskylä/pienalue:6 | 2020-12-07T13:38:30.404086+02:00 | small_district | 478 | helsinki | ||||||
| 902 | 7 | ocd-division/country:fi/kunta:helsinki/osa-alue:yliskylä/pienalue:7 | 2020-12-07T13:38:30.499887+02:00 | small_district | 478 | helsinki | ||||||
| 521 | 0 | ocd-division/country:fi/kunta:helsinki/osa-alue:vartiosaari/pienalue:0 | 2020-12-07T13:38:29.098339+02:00 | small_district | 477 | helsinki | ||||||
| 525 | 0 | ocd-division/country:fi/kunta:helsinki/osa-alue:kurkimäki/pienalue:0 | 2020-12-07T13:38:29.023346+02:00 | small_district | 476 | helsinki | ||||||
| 593 | 1 | ocd-division/country:fi/kunta:helsinki/osa-alue:kivikko/pienalue:1 | 2020-12-07T13:38:29.318071+02:00 | small_district | 475 | helsinki | ||||||
| 672 | 2 | ocd-division/country:fi/kunta:helsinki/osa-alue:kivikko/pienalue:2 | 2020-12-07T13:38:29.550815+02:00 | small_district | 475 | helsinki | ||||||
| 772 | 3 | ocd-division/country:fi/kunta:helsinki/osa-alue:kivikko/pienalue:3 | 2020-12-07T13:38:30.052327+02:00 | small_district | 475 | helsinki | ||||||
| 816 | 4 | ocd-division/country:fi/kunta:helsinki/osa-alue:kivikko/pienalue:4 | 2020-12-07T13:38:30.274712+02:00 | small_district | 475 | helsinki | ||||||
| 614 | 1 | ocd-division/country:fi/kunta:helsinki/osa-alue:mellunmäki/pienalue:1 | 2020-12-07T13:38:29.457999+02:00 | small_district | 474 | helsinki | ||||||
| 744 | 2 | ocd-division/country:fi/kunta:helsinki/osa-alue:mellunmäki/pienalue:2 | 2020-12-07T13:38:29.573420+02:00 | small_district | 474 | helsinki | ||||||
| 810 | 3 | ocd-division/country:fi/kunta:helsinki/osa-alue:mellunmäki/pienalue:3 | 2020-12-07T13:38:29.991806+02:00 | small_district | 474 | helsinki | ||||||
| 624 | 1 | ocd-division/country:fi/kunta:helsinki/osa-alue:vesala/pienalue:1 | 2020-12-07T13:38:29.290934+02:00 | small_district | 473 | helsinki | ||||||
| 722 | 2 | ocd-division/country:fi/kunta:helsinki/osa-alue:vesala/pienalue:2 | 2020-12-07T13:38:29.570210+02:00 | small_district | 473 | helsinki | ||||||
| 761 | 3 | ocd-division/country:fi/kunta:helsinki/osa-alue:vesala/pienalue:3 | 2020-12-07T13:38:29.930641+02:00 | small_district | 473 | helsinki | ||||||
| 823 | 4 | ocd-division/country:fi/kunta:helsinki/osa-alue:vesala/pienalue:4 | 2020-12-07T13:38:30.181677+02:00 | small_district | 473 | helsinki | ||||||
| 562 | 1 | ocd-division/country:fi/kunta:helsinki/osa-alue:kontula/pienalue:1 | 2020-12-07T13:38:29.205345+02:00 | small_district | 472 | helsinki | ||||||
| 670 | 2 | ocd-division/country:fi/kunta:helsinki/osa-alue:kontula/pienalue:2 | 2020-12-07T13:38:29.838402+02:00 | small_district | 472 | helsinki | ||||||
| 796 | 3 | ocd-division/country:fi/kunta:helsinki/osa-alue:kontula/pienalue:3 | 2020-12-07T13:38:29.995244+02:00 | small_district | 472 | helsinki | ||||||
| 877 | 6 | ocd-division/country:fi/kunta:helsinki/osa-alue:kontula/pienalue:6 | 2020-12-07T13:38:30.442467+02:00 | small_district | 472 | helsinki | ||||||
| 567 | 1 | ocd-division/country:fi/kunta:helsinki/osa-alue:pitäjänmäen_yritysalue/pienalue:1 | 2020-12-07T13:38:29.260344+02:00 | small_district | 471 | helsinki | ||||||
| 701 | 2 | ocd-division/country:fi/kunta:helsinki/osa-alue:pitäjänmäen_yritysalue/pienalue:2 | 2020-12-07T13:38:29.817537+02:00 | small_district | 471 | helsinki | ||||||
| 777 | 3 | ocd-division/country:fi/kunta:helsinki/osa-alue:pitäjänmäen_yritysalue/pienalue:3 | 2020-12-07T13:38:30.075986+02:00 | small_district | 471 | helsinki | ||||||
| 547 | 0 | ocd-division/country:fi/kunta:helsinki/osa-alue:marttila/pienalue:0 | 2020-12-07T13:38:29.173402+02:00 | small_district | 470 | helsinki | ||||||
| 558 | 1 | ocd-division/country:fi/kunta:helsinki/osa-alue:reimarla/pienalue:1 | 2020-12-07T13:38:29.217521+02:00 | small_district | 469 | helsinki | ||||||
| 718 | 2 | ocd-division/country:fi/kunta:helsinki/osa-alue:reimarla/pienalue:2 | 2020-12-07T13:38:29.687491+02:00 | small_district | 469 | helsinki | ||||||
| 795 | 3 | ocd-division/country:fi/kunta:helsinki/osa-alue:reimarla/pienalue:3 | 2020-12-07T13:38:29.987907+02:00 | small_district | 469 | helsinki | ||||||
| 647 | 1 | ocd-division/country:fi/kunta:helsinki/osa-alue:tali/pienalue:1 | 2020-12-07T13:38:29.499176+02:00 | small_district | 468 | helsinki | ||||||
| 674 | 2 | ocd-division/country:fi/kunta:helsinki/osa-alue:tali/pienalue:2 | 2020-12-07T13:38:29.590914+02:00 | small_district | 468 | helsinki | ||||||
| 784 | 3 | ocd-division/country:fi/kunta:helsinki/osa-alue:tali/pienalue:3 | 2020-12-07T13:38:30.091179+02:00 | small_district | 468 | helsinki | ||||||
| 548 | 0 | ocd-division/country:fi/kunta:helsinki/osa-alue:pajamäki/pienalue:0 | 2020-12-07T13:38:29.068753+02:00 | small_district | 467 | helsinki | ||||||
| 554 | 1 | ocd-division/country:fi/kunta:helsinki/osa-alue:itäkeskus/pienalue:1 | 2020-12-07T13:38:29.481829+02:00 | small_district | 466 | helsinki | ||||||
| 746 | 2 | ocd-division/country:fi/kunta:helsinki/osa-alue:itäkeskus/pienalue:2 | 2020-12-07T13:38:29.867614+02:00 | small_district | 466 | helsinki | ||||||
| 781 | 3 | ocd-division/country:fi/kunta:helsinki/osa-alue:itäkeskus/pienalue:3 | 2020-12-07T13:38:30.122002+02:00 | small_district | 466 | helsinki | ||||||
| 549 | 0 | ocd-division/country:fi/kunta:helsinki/osa-alue:roihupelto/pienalue:0 | 2020-12-07T13:38:29.163502+02:00 | small_district | 465 | helsinki | ||||||
| 544 | 0 | ocd-division/country:fi/kunta:helsinki/osa-alue:marjaniemi/pienalue:0 | 2020-12-07T13:38:29.177481+02:00 | small_district | 464 | helsinki | ||||||
| 724 | 2 | ocd-division/country:fi/kunta:helsinki/osa-alue:myllypuro/pienalue:2 | 2020-12-07T13:38:29.697347+02:00 | small_district | 463 | helsinki | ||||||
| 802 | 3 | ocd-division/country:fi/kunta:helsinki/osa-alue:myllypuro/pienalue:3 | 2020-12-07T13:38:30.072761+02:00 | small_district | 463 | helsinki | ||||||
| 819 | 4 | ocd-division/country:fi/kunta:helsinki/osa-alue:myllypuro/pienalue:4 | 2020-12-07T13:38:30.178230+02:00 | small_district | 463 | helsinki | ||||||
| 864 | 5 | ocd-division/country:fi/kunta:helsinki/osa-alue:myllypuro/pienalue:5 | 2020-12-07T13:38:30.375487+02:00 | small_district | 463 | helsinki | ||||||
| 878 | 6 | ocd-division/country:fi/kunta:helsinki/osa-alue:myllypuro/pienalue:6 | 2020-12-07T13:38:30.393923+02:00 | small_district | 463 | helsinki |
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 );