administrative_division
2,760 rows sorted by name_fi
This data as json, CSV (advanced)
start (date) ✖
- 2021-07-01 263
- 2021-08-01 190
- 2020-08-01 186
- 2020-07-01 70
| id | origin_id | ocd_id | service_point_id | start | end | modified_at | type | parent | municipality | name_fi ▼ | name_sv | name |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 704 | 2 | ocd-division/country:fi/kunta:helsinki/osa-alue:pukinmäki/pienalue:2 | 2020-12-07T13:38:29.814828+02:00 | small_district | 437 | helsinki | ||||||
| 705 | 2 | ocd-division/country:fi/kunta:helsinki/osa-alue:länsi-pasila/pienalue:2 | 2020-12-07T13:38:29.631873+02:00 | small_district | 379 | helsinki | ||||||
| 706 | 2 | ocd-division/country:fi/kunta:helsinki/osa-alue:myllykallio/pienalue:2 | 2020-12-07T13:38:29.648849+02:00 | small_district | 418 | helsinki | ||||||
| 707 | 2 | ocd-division/country:fi/kunta:helsinki/osa-alue:pihlajamäki/pienalue:2 | 2020-12-07T13:38:29.811800+02:00 | small_district | 440 | helsinki | ||||||
| 708 | 2 | ocd-division/country:fi/kunta:helsinki/osa-alue:kannelmäki/pienalue:2 | 2020-12-07T13:38:29.655718+02:00 | small_district | 421 | helsinki | ||||||
| 709 | 2 | ocd-division/country:fi/kunta:helsinki/osa-alue:lehtisaari/pienalue:2 | 2020-12-07T13:38:29.659465+02:00 | small_district | 412 | helsinki | ||||||
| 710 | 2 | ocd-division/country:fi/kunta:helsinki/osa-alue:tattarisuo/pienalue:2 | 2020-12-07T13:38:29.652346+02:00 | small_district | 451 | helsinki | ||||||
| 711 | 2 | ocd-division/country:fi/kunta:helsinki/osa-alue:siltamäki/pienalue:2 | 2020-12-07T13:38:29.666168+02:00 | small_district | 446 | helsinki | ||||||
| 712 | 2 | ocd-division/country:fi/kunta:helsinki/osa-alue:maununneva/pienalue:2 | 2020-12-07T13:38:29.672281+02:00 | small_district | 422 | helsinki | ||||||
| 713 | 2 | ocd-division/country:fi/kunta:helsinki/osa-alue:kluuvi/pienalue:2 | 2020-12-07T13:38:29.675422+02:00 | small_district | 357 | helsinki | ||||||
| 714 | 2 | ocd-division/country:fi/kunta:helsinki/osa-alue:etelä-haaga/pienalue:2 | 2020-12-07T13:38:29.678382+02:00 | small_district | 406 | helsinki | ||||||
| 715 | 2 | ocd-division/country:fi/kunta:helsinki/osa-alue:sompasaari/pienalue:2 | 2020-12-07T13:38:29.681430+02:00 | small_district | 367 | helsinki | ||||||
| 716 | 2 | ocd-division/country:fi/kunta:helsinki/osa-alue:pohjois-haaga/pienalue:2 | 2020-12-07T13:38:29.662925+02:00 | small_district | 408 | helsinki | ||||||
| 717 | 2 | ocd-division/country:fi/kunta:helsinki/osa-alue:ala-malmi/pienalue:2 | 2020-12-07T13:38:29.684274+02:00 | small_district | 439 | 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 | ||||||
| 719 | 2 | ocd-division/country:fi/kunta:helsinki/osa-alue:torpparinmäki/pienalue:2 | 2020-12-07T13:38:29.566809+02:00 | small_district | 430 | 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 | ||||||
| 721 | 2 | ocd-division/country:fi/kunta:helsinki/osa-alue:herttoniemenranta/pienalue:2 | 2020-12-07T13:38:29.691141+02:00 | small_district | 458 | 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 | ||||||
| 723 | 2 | ocd-division/country:fi/kunta:helsinki/osa-alue:vanha_ruskeasuo/pienalue:2 | 2020-12-07T13:38:29.694356+02:00 | small_district | 377 | 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 | ||||||
| 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 | ||||||
| 726 | 2 | ocd-division/country:fi/kunta:helsinki/osa-alue:metsälä/pienalue:2 | 2020-12-07T13:38:29.784825+02:00 | small_district | 401 | helsinki | ||||||
| 727 | 2 | ocd-division/country:fi/kunta:helsinki/osa-alue:vilhonvuori/pienalue:2 | 2020-12-07T13:38:29.669409+02:00 | small_district | 365 | helsinki | ||||||
| 728 | 2 | ocd-division/country:fi/kunta:helsinki/osa-alue:hakuninmaa/pienalue:2 | 2020-12-07T13:38:29.702956+02:00 | small_district | 424 | 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 | ||||||
| 730 | 2 | ocd-division/country:fi/kunta:helsinki/osa-alue:alppila/pienalue:2 | 2020-12-07T13:38:29.706094+02:00 | small_district | 373 | helsinki | ||||||
| 731 | 2 | ocd-division/country:fi/kunta:helsinki/osa-alue:taka-töölö/pienalue:2 | 2020-12-07T13:38:29.562610+02:00 | small_district | 375 | 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 | ||||||
| 733 | 2 | ocd-division/country:fi/kunta:helsinki/osa-alue:vartioharju/pienalue:2 | 2020-12-07T13:38:29.805854+02:00 | small_district | 460 | 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 | ||||||
| 735 | 2 | ocd-division/country:fi/kunta:helsinki/osa-alue:linjat/pienalue:2 | 2020-12-07T13:38:29.802705+02:00 | small_district | 370 | helsinki | ||||||
| 736 | 2 | ocd-division/country:fi/kunta:helsinki/osa-alue:hermanninranta/pienalue:2 | 2020-12-07T13:38:29.799672+02:00 | small_district | 390 | helsinki | ||||||
| 737 | 2 | ocd-division/country:fi/kunta:helsinki/osa-alue:kumpula/pienalue:2 | 2020-12-07T13:38:29.712057+02:00 | small_district | 395 | helsinki | ||||||
| 738 | 2 | ocd-division/country:fi/kunta:helsinki/osa-alue:siltasaari/pienalue:2 | 2020-12-07T13:38:29.715335+02:00 | small_district | 369 | helsinki | ||||||
| 739 | 2 | ocd-division/country:fi/kunta:helsinki/osa-alue:etu-töölö/pienalue:2 | 2020-12-07T13:38:29.796149+02:00 | small_district | 374 | helsinki | ||||||
| 740 | 2 | ocd-division/country:fi/kunta:helsinki/osa-alue:hermanninmäki/pienalue:2 | 2020-12-07T13:38:29.718250+02:00 | small_district | 389 | 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 | ||||||
| 742 | 2 | ocd-division/country:fi/kunta:helsinki/osa-alue:katajanokka/pienalue:2 | 2020-12-07T13:38:29.543935+02:00 | small_district | 363 | helsinki | ||||||
| 743 | 2 | ocd-division/country:fi/kunta:helsinki/osa-alue:veräjämäki/pienalue:2 | 2020-12-07T13:38:29.792552+02:00 | small_district | 403 | 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 | ||||||
| 745 | 2 | ocd-division/country:fi/kunta:helsinki/osa-alue:herttoniemen_yritysalue/pienalue:2 | 2020-12-07T13:38:29.727022+02:00 | small_district | 457 | 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 | ||||||
| 747 | 3 | ocd-division/country:fi/kunta:helsinki/osa-alue:kamppi/pienalue:3 | 2020-12-07T13:38:29.871482+02:00 | small_district | 359 | helsinki | ||||||
| 748 | 3 | ocd-division/country:fi/kunta:helsinki/osa-alue:myllykallio/pienalue:3 | 2020-12-07T13:38:30.044838+02:00 | small_district | 418 | helsinki | ||||||
| 749 | 3 | ocd-division/country:fi/kunta:helsinki/osa-alue:etelä-haaga/pienalue:3 | 2020-12-07T13:38:29.908900+02:00 | small_district | 406 | helsinki | ||||||
| 750 | 3 | ocd-division/country:fi/kunta:helsinki/osa-alue:linjat/pienalue:3 | 2020-12-07T13:38:30.098461+02:00 | small_district | 370 | helsinki | ||||||
| 751 | 3 | ocd-division/country:fi/kunta:helsinki/osa-alue:malmin_lentokenttä/pienalue:3 | 2020-12-07T13:38:30.048974+02:00 | small_district | 442 | helsinki | ||||||
| 752 | 3 | ocd-division/country:fi/kunta:helsinki/osa-alue:kalasatama/pienalue:3 | 2020-12-07T13:38:30.040810+02:00 | small_district | 366 | helsinki | ||||||
| 753 | 3 | ocd-division/country:fi/kunta:helsinki/osa-alue:hermanninmäki/pienalue:3 | 2020-12-07T13:38:30.036517+02:00 | small_district | 389 | helsinki | ||||||
| 754 | 3 | ocd-division/country:fi/kunta:helsinki/osa-alue:töyrynummi/pienalue:3 | 2020-12-07T13:38:30.012098+02:00 | small_district | 448 | helsinki | ||||||
| 755 | 3 | ocd-division/country:fi/kunta:helsinki/osa-alue:vanha_munkkiniemi/pienalue:3 | 2020-12-07T13:38:29.980432+02:00 | small_district | 410 | helsinki | ||||||
| 756 | 3 | ocd-division/country:fi/kunta:helsinki/osa-alue:patola/pienalue:3 | 2020-12-07T13:38:29.976054+02:00 | small_district | 402 | 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 760 | 3 | ocd-division/country:fi/kunta:helsinki/osa-alue:kulosaari/pienalue:3 | 2020-12-07T13:38:29.878645+02:00 | small_district | 454 | 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 | ||||||
| 762 | 3 | ocd-division/country:fi/kunta:helsinki/osa-alue:pohjois-haaga/pienalue:3 | 2020-12-07T13:38:29.924506+02:00 | small_district | 408 | helsinki | ||||||
| 763 | 3 | ocd-division/country:fi/kunta:helsinki/osa-alue:vilhonvuori/pienalue:3 | 2020-12-07T13:38:29.920599+02:00 | small_district | 365 | helsinki | ||||||
| 764 | 3 | ocd-division/country:fi/kunta:helsinki/osa-alue:hakuninmaa/pienalue:3 | 2020-12-07T13:38:29.901847+02:00 | small_district | 424 | helsinki | ||||||
| 765 | 3 | ocd-division/country:fi/kunta:helsinki/osa-alue:tapanila/pienalue:3 | 2020-12-07T13:38:29.894620+02:00 | small_district | 445 | helsinki | ||||||
| 766 | 3 | ocd-division/country:fi/kunta:helsinki/osa-alue:latokartano/pienalue:3 | 2020-12-07T13:38:29.888127+02:00 | small_district | 434 | helsinki | ||||||
| 767 | 3 | ocd-division/country:fi/kunta:helsinki/osa-alue:tattarisuo/pienalue:3 | 2020-12-07T13:38:30.117716+02:00 | small_district | 451 | helsinki | ||||||
| 768 | 3 | ocd-division/country:fi/kunta:helsinki/osa-alue:tapulikaupunki/pienalue:3 | 2020-12-07T13:38:30.102370+02:00 | small_district | 447 | helsinki | ||||||
| 769 | 3 | ocd-division/country:fi/kunta:helsinki/osa-alue:siltamäki/pienalue:3 | 2020-12-07T13:38:30.094747+02:00 | small_district | 446 | helsinki | ||||||
| 770 | 3 | ocd-division/country:fi/kunta:helsinki/osa-alue:kumpula/pienalue:3 | 2020-12-07T13:38:30.086681+02:00 | small_district | 395 | helsinki | ||||||
| 771 | 3 | ocd-division/country:fi/kunta:helsinki/osa-alue:pukinmäki/pienalue:3 | 2020-12-07T13:38:30.083156+02:00 | small_district | 437 | 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 | ||||||
| 773 | 3 | ocd-division/country:fi/kunta:helsinki/osa-alue:laakso/pienalue:3 | 2020-12-07T13:38:30.063106+02:00 | small_district | 383 | helsinki | ||||||
| 774 | 3 | ocd-division/country:fi/kunta:helsinki/osa-alue:pikku_huopalahti/pienalue:3 | 2020-12-07T13:38:30.056411+02:00 | small_district | 378 | helsinki | ||||||
| 775 | 3 | ocd-division/country:fi/kunta:helsinki/osa-alue:kaartinkaupunki/pienalue:3 | 2020-12-07T13:38:30.059681+02:00 | small_district | 358 | helsinki | ||||||
| 776 | 3 | ocd-division/country:fi/kunta:helsinki/osa-alue:taka-töölö/pienalue:3 | 2020-12-07T13:38:30.069582+02:00 | small_district | 375 | 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 | ||||||
| 778 | 3 | ocd-division/country:fi/kunta:helsinki/osa-alue:ala-malmi/pienalue:3 | 2020-12-07T13:38:30.079698+02:00 | small_district | 439 | helsinki | ||||||
| 779 | 3 | ocd-division/country:fi/kunta:helsinki/osa-alue:roihuvuori/pienalue:3 | 2020-12-07T13:38:30.109203+02:00 | small_district | 456 | helsinki | ||||||
| 780 | 3 | ocd-division/country:fi/kunta:helsinki/osa-alue:vartioharju/pienalue:3 | 2020-12-07T13:38:30.113105+02:00 | small_district | 460 | 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 | ||||||
| 782 | 3 | ocd-division/country:fi/kunta:helsinki/osa-alue:meilahti/pienalue:3 | 2020-12-07T13:38:30.125877+02:00 | small_district | 376 | helsinki | ||||||
| 783 | 3 | ocd-division/country:fi/kunta:helsinki/osa-alue:länsi-pakila/pienalue:3 | 2020-12-07T13:38:29.875074+02:00 | small_district | 427 | 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 | ||||||
| 785 | 3 | ocd-division/country:fi/kunta:helsinki/osa-alue:länsi-pasila/pienalue:3 | 2020-12-07T13:38:29.881742+02:00 | small_district | 379 | helsinki | ||||||
| 786 | 3 | ocd-division/country:fi/kunta:helsinki/osa-alue:etu-töölö/pienalue:3 | 2020-12-07T13:38:29.884964+02:00 | small_district | 374 | 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 | ||||||
| 788 | 3 | ocd-division/country:fi/kunta:helsinki/osa-alue:punavuori/pienalue:3 | 2020-12-07T13:38:29.912473+02:00 | small_district | 360 | helsinki | ||||||
| 789 | 3 | ocd-division/country:fi/kunta:helsinki/osa-alue:ullanlinna/pienalue:3 | 2020-12-07T13:38:29.916217+02:00 | small_district | 362 | helsinki | ||||||
| 790 | 3 | ocd-division/country:fi/kunta:helsinki/osa-alue:puotinharju/pienalue:3 | 2020-12-07T13:38:29.949584+02:00 | small_district | 462 | helsinki | ||||||
| 791 | 3 | ocd-division/country:fi/kunta:helsinki/osa-alue:kluuvi/pienalue:3 | 2020-12-07T13:38:29.934798+02:00 | small_district | 357 | helsinki | ||||||
| 792 | 3 | ocd-division/country:fi/kunta:helsinki/osa-alue:puistola/pienalue:3 | 2020-12-07T13:38:29.965367+02:00 | small_district | 449 | helsinki | ||||||
| 793 | 3 | ocd-division/country:fi/kunta:helsinki/osa-alue:ylä-malmi/pienalue:3 | 2020-12-07T13:38:29.943823+02:00 | small_district | 438 | helsinki | ||||||
| 794 | 3 | ocd-division/country:fi/kunta:helsinki/osa-alue:itä-pakila/pienalue:3 | 2020-12-07T13:38:29.972490+02:00 | small_district | 428 | 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 | ||||||
| 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 | ||||||
| 797 | 3 | ocd-division/country:fi/kunta:helsinki/osa-alue:vattuniemi/pienalue:3 | 2020-12-07T13:38:29.998744+02:00 | small_district | 417 | 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 | ||||||
| 799 | 3 | ocd-division/country:fi/kunta:helsinki/osa-alue:kruununhaka/pienalue:3 | 2020-12-07T13:38:30.005176+02:00 | small_district | 356 | helsinki | ||||||
| 800 | 3 | ocd-division/country:fi/kunta:helsinki/osa-alue:konala/pienalue:3 | 2020-12-07T13:38:30.008314+02:00 | small_district | 420 | 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 | ||||||
| 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 | ||||||
| 803 | 3 | ocd-division/country:fi/kunta:helsinki/osa-alue:kannelmäki/pienalue:3 | 2020-12-07T13:38:30.025919+02:00 | small_district | 421 | 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 );