administrative_division
404 rows where type = "small_district" sorted by parent
This data as json, CSV (advanced)
Suggested facets: origin_id
modified_at (date) ✖
- 2020-12-07 404
| id | origin_id | ocd_id | service_point_id | start | end | modified_at | type | parent ▼ | municipality | name_fi | name_sv | name |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 641 | 1 | ocd-division/country:fi/kunta:helsinki/osa-alue:kruununhaka/pienalue:1 | 2020-12-07T13:38:29.492521+02:00 | small_district | 356 | helsinki | ||||||
| 668 | 2 | ocd-division/country:fi/kunta:helsinki/osa-alue:kruununhaka/pienalue:2 | 2020-12-07T13:38:29.778286+02:00 | small_district | 356 | 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 | ||||||
| 815 | 4 | ocd-division/country:fi/kunta:helsinki/osa-alue:kruununhaka/pienalue:4 | 2020-12-07T13:38:30.192451+02:00 | small_district | 356 | helsinki | ||||||
| 609 | 1 | ocd-division/country:fi/kunta:helsinki/osa-alue:kluuvi/pienalue:1 | 2020-12-07T13:38:29.310043+02:00 | small_district | 357 | 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 | ||||||
| 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 | ||||||
| 826 | 4 | ocd-division/country:fi/kunta:helsinki/osa-alue:kluuvi/pienalue:4 | 2020-12-07T13:38:30.136511+02:00 | small_district | 357 | helsinki | ||||||
| 871 | 5 | ocd-division/country:fi/kunta:helsinki/osa-alue:kluuvi/pienalue:5 | 2020-12-07T13:38:30.367280+02:00 | small_district | 357 | helsinki | ||||||
| 883 | 6 | ocd-division/country:fi/kunta:helsinki/osa-alue:kluuvi/pienalue:6 | 2020-12-07T13:38:30.451325+02:00 | small_district | 357 | helsinki | ||||||
| 896 | 7 | ocd-division/country:fi/kunta:helsinki/osa-alue:kluuvi/pienalue:7 | 2020-12-07T13:38:30.495698+02:00 | small_district | 357 | helsinki | ||||||
| 611 | 1 | ocd-division/country:fi/kunta:helsinki/osa-alue:kaartinkaupunki/pienalue:1 | 2020-12-07T13:38:29.527533+02:00 | small_district | 358 | helsinki | ||||||
| 651 | 2 | ocd-division/country:fi/kunta:helsinki/osa-alue:kaartinkaupunki/pienalue:2 | 2020-12-07T13:38:29.734251+02:00 | small_district | 358 | 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 | ||||||
| 608 | 1 | ocd-division/country:fi/kunta:helsinki/osa-alue:kamppi/pienalue:1 | 2020-12-07T13:38:29.462686+02:00 | small_district | 359 | helsinki | ||||||
| 662 | 2 | ocd-division/country:fi/kunta:helsinki/osa-alue:kamppi/pienalue:2 | 2020-12-07T13:38:29.781534+02:00 | small_district | 359 | 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 | ||||||
| 830 | 4 | ocd-division/country:fi/kunta:helsinki/osa-alue:kamppi/pienalue:4 | 2020-12-07T13:38:30.247187+02:00 | small_district | 359 | helsinki | ||||||
| 862 | 5 | ocd-division/country:fi/kunta:helsinki/osa-alue:kamppi/pienalue:5 | 2020-12-07T13:38:30.341625+02:00 | small_district | 359 | helsinki | ||||||
| 889 | 6 | ocd-division/country:fi/kunta:helsinki/osa-alue:kamppi/pienalue:6 | 2020-12-07T13:38:30.419686+02:00 | small_district | 359 | helsinki | ||||||
| 897 | 7 | ocd-division/country:fi/kunta:helsinki/osa-alue:kamppi/pienalue:7 | 2020-12-07T13:38:30.484504+02:00 | small_district | 359 | helsinki | ||||||
| 904 | 8 | ocd-division/country:fi/kunta:helsinki/osa-alue:kamppi/pienalue:8 | 2020-12-07T13:38:30.517113+02:00 | small_district | 359 | helsinki | ||||||
| 560 | 1 | ocd-division/country:fi/kunta:helsinki/osa-alue:punavuori/pienalue:1 | 2020-12-07T13:38:29.436634+02:00 | small_district | 360 | helsinki | ||||||
| 703 | 2 | ocd-division/country:fi/kunta:helsinki/osa-alue:punavuori/pienalue:2 | 2020-12-07T13:38:29.558959+02:00 | small_district | 360 | 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 | ||||||
| 852 | 4 | ocd-division/country:fi/kunta:helsinki/osa-alue:punavuori/pienalue:4 | 2020-12-07T13:38:30.156793+02:00 | small_district | 360 | helsinki | ||||||
| 532 | 0 | ocd-division/country:fi/kunta:helsinki/osa-alue:eira/pienalue:0 | 2020-12-07T13:38:29.061980+02:00 | small_district | 361 | helsinki | ||||||
| 600 | 1 | ocd-division/country:fi/kunta:helsinki/osa-alue:ullanlinna/pienalue:1 | 2020-12-07T13:38:29.263364+02:00 | small_district | 362 | helsinki | ||||||
| 649 | 2 | ocd-division/country:fi/kunta:helsinki/osa-alue:ullanlinna/pienalue:2 | 2020-12-07T13:38:29.730802+02:00 | small_district | 362 | 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 | ||||||
| 590 | 1 | ocd-division/country:fi/kunta:helsinki/osa-alue:katajanokka/pienalue:1 | 2020-12-07T13:38:29.233407+02:00 | small_district | 363 | 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 | ||||||
| 509 | 0 | ocd-division/country:fi/kunta:helsinki/osa-alue:kaivopuisto/pienalue:0 | 2020-12-07T13:38:29.149784+02:00 | small_district | 364 | helsinki | ||||||
| 551 | 1 | ocd-division/country:fi/kunta:helsinki/osa-alue:vilhonvuori/pienalue:1 | 2020-12-07T13:38:29.347934+02:00 | small_district | 365 | 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 | ||||||
| 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 | ||||||
| 552 | 1 | ocd-division/country:fi/kunta:helsinki/osa-alue:kalasatama/pienalue:1 | 2020-12-07T13:38:29.269713+02:00 | small_district | 366 | helsinki | ||||||
| 665 | 2 | ocd-division/country:fi/kunta:helsinki/osa-alue:kalasatama/pienalue:2 | 2020-12-07T13:38:29.579500+02:00 | small_district | 366 | 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 | ||||||
| 829 | 4 | ocd-division/country:fi/kunta:helsinki/osa-alue:kalasatama/pienalue:4 | 2020-12-07T13:38:30.164444+02:00 | small_district | 366 | helsinki | ||||||
| 859 | 5 | ocd-division/country:fi/kunta:helsinki/osa-alue:kalasatama/pienalue:5 | 2020-12-07T13:38:30.358440+02:00 | small_district | 366 | helsinki | ||||||
| 589 | 1 | ocd-division/country:fi/kunta:helsinki/osa-alue:sompasaari/pienalue:1 | 2020-12-07T13:38:29.511857+02:00 | small_district | 367 | 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 | ||||||
| 533 | 0 | ocd-division/country:fi/kunta:helsinki/osa-alue:hanasaari/pienalue:0 | 2020-12-07T13:38:29.001211+02:00 | small_district | 368 | helsinki | ||||||
| 592 | 1 | ocd-division/country:fi/kunta:helsinki/osa-alue:siltasaari/pienalue:1 | 2020-12-07T13:38:29.336616+02:00 | small_district | 369 | 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 | ||||||
| 636 | 1 | ocd-division/country:fi/kunta:helsinki/osa-alue:linjat/pienalue:1 | 2020-12-07T13:38:29.187554+02:00 | small_district | 370 | 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 | ||||||
| 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 | ||||||
| 514 | 0 | ocd-division/country:fi/kunta:helsinki/osa-alue:torkkelinmäki/pienalue:0 | 2020-12-07T13:38:29.095086+02:00 | small_district | 371 | helsinki | ||||||
| 506 | 0 | ocd-division/country:fi/kunta:helsinki/osa-alue:harju/pienalue:0 | 2020-12-07T13:38:29.117063+02:00 | small_district | 372 | helsinki | ||||||
| 576 | 1 | ocd-division/country:fi/kunta:helsinki/osa-alue:alppila/pienalue:1 | 2020-12-07T13:38:29.183919+02:00 | small_district | 373 | 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 | ||||||
| 625 | 1 | ocd-division/country:fi/kunta:helsinki/osa-alue:etu-töölö/pienalue:1 | 2020-12-07T13:38:29.208366+02:00 | small_district | 374 | 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 | ||||||
| 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 | ||||||
| 825 | 4 | ocd-division/country:fi/kunta:helsinki/osa-alue:etu-töölö/pienalue:4 | 2020-12-07T13:38:30.223149+02:00 | small_district | 374 | helsinki | ||||||
| 861 | 5 | ocd-division/country:fi/kunta:helsinki/osa-alue:etu-töölö/pienalue:5 | 2020-12-07T13:38:30.327831+02:00 | small_district | 374 | helsinki | ||||||
| 632 | 1 | ocd-division/country:fi/kunta:helsinki/osa-alue:taka-töölö/pienalue:1 | 2020-12-07T13:38:29.488945+02:00 | small_district | 375 | 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 | ||||||
| 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 | ||||||
| 814 | 4 | ocd-division/country:fi/kunta:helsinki/osa-alue:taka-töölö/pienalue:4 | 2020-12-07T13:38:30.174422+02:00 | small_district | 375 | helsinki | ||||||
| 875 | 5 | ocd-division/country:fi/kunta:helsinki/osa-alue:taka-töölö/pienalue:5 | 2020-12-07T13:38:30.299451+02:00 | small_district | 375 | helsinki | ||||||
| 888 | 6 | ocd-division/country:fi/kunta:helsinki/osa-alue:taka-töölö/pienalue:6 | 2020-12-07T13:38:30.414116+02:00 | small_district | 375 | helsinki | ||||||
| 644 | 1 | ocd-division/country:fi/kunta:helsinki/osa-alue:meilahti/pienalue:1 | 2020-12-07T13:38:29.190533+02:00 | small_district | 376 | helsinki | ||||||
| 656 | 2 | ocd-division/country:fi/kunta:helsinki/osa-alue:meilahti/pienalue:2 | 2020-12-07T13:38:29.752099+02:00 | small_district | 376 | 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 | ||||||
| 839 | 4 | ocd-division/country:fi/kunta:helsinki/osa-alue:meilahti/pienalue:4 | 2020-12-07T13:38:30.131427+02:00 | small_district | 376 | helsinki | ||||||
| 627 | 1 | ocd-division/country:fi/kunta:helsinki/osa-alue:vanha_ruskeasuo/pienalue:1 | 2020-12-07T13:38:29.535746+02:00 | small_district | 377 | 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 | ||||||
| 610 | 1 | ocd-division/country:fi/kunta:helsinki/osa-alue:pikku_huopalahti/pienalue:1 | 2020-12-07T13:38:29.279771+02:00 | small_district | 378 | helsinki | ||||||
| 667 | 2 | ocd-division/country:fi/kunta:helsinki/osa-alue:pikku_huopalahti/pienalue:2 | 2020-12-07T13:38:29.774259+02:00 | small_district | 378 | 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 | ||||||
| 583 | 1 | ocd-division/country:fi/kunta:helsinki/osa-alue:länsi-pasila/pienalue:1 | 2020-12-07T13:38:29.250117+02:00 | small_district | 379 | 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 | ||||||
| 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 | ||||||
| 511 | 0 | ocd-division/country:fi/kunta:helsinki/osa-alue:pohjois-pasila/pienalue:0 | 2020-12-07T13:38:29.120271+02:00 | small_district | 380 | helsinki | ||||||
| 515 | 0 | ocd-division/country:fi/kunta:helsinki/osa-alue:itä-pasila/pienalue:0 | 2020-12-07T13:38:29.168552+02:00 | small_district | 381 | helsinki | ||||||
| 563 | 1 | ocd-division/country:fi/kunta:helsinki/osa-alue:keski-pasila/pienalue:1 | 2020-12-07T13:38:29.505969+02:00 | small_district | 382 | helsinki | ||||||
| 663 | 2 | ocd-division/country:fi/kunta:helsinki/osa-alue:keski-pasila/pienalue:2 | 2020-12-07T13:38:29.845889+02:00 | small_district | 382 | helsinki | ||||||
| 642 | 1 | ocd-division/country:fi/kunta:helsinki/osa-alue:laakso/pienalue:1 | 2020-12-07T13:38:29.485504+02:00 | small_district | 383 | helsinki | ||||||
| 673 | 2 | ocd-division/country:fi/kunta:helsinki/osa-alue:laakso/pienalue:2 | 2020-12-07T13:38:29.547442+02:00 | small_district | 383 | 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 | ||||||
| 601 | 1 | ocd-division/country:fi/kunta:helsinki/osa-alue:mustikkamaa-korkeasaari/pienalue:1 | 2020-12-07T13:38:29.399725+02:00 | small_district | 384 | helsinki | ||||||
| 650 | 2 | ocd-division/country:fi/kunta:helsinki/osa-alue:mustikkamaa-korkeasaari/pienalue:2 | 2020-12-07T13:38:29.850990+02:00 | small_district | 384 | helsinki | ||||||
| 505 | 0 | ocd-division/country:fi/kunta:helsinki/osa-alue:ruoholahti/pienalue:0 | 2020-12-07T13:38:28.995586+02:00 | small_district | 385 | helsinki | ||||||
| 518 | 0 | ocd-division/country:fi/kunta:helsinki/osa-alue:lapinlahti/pienalue:0 | 2020-12-07T13:38:29.105923+02:00 | small_district | 386 | helsinki | ||||||
| 621 | 1 | ocd-division/country:fi/kunta:helsinki/osa-alue:jätkäsaari/pienalue:1 | 2020-12-07T13:38:29.448857+02:00 | small_district | 387 | helsinki | ||||||
| 700 | 2 | ocd-division/country:fi/kunta:helsinki/osa-alue:jätkäsaari/pienalue:2 | 2020-12-07T13:38:29.641828+02:00 | small_district | 387 | helsinki | ||||||
| 807 | 3 | ocd-division/country:fi/kunta:helsinki/osa-alue:jätkäsaari/pienalue:3 | 2020-12-07T13:38:29.897963+02:00 | small_district | 387 | helsinki | ||||||
| 838 | 4 | ocd-division/country:fi/kunta:helsinki/osa-alue:jätkäsaari/pienalue:4 | 2020-12-07T13:38:30.167614+02:00 | small_district | 387 | helsinki | ||||||
| 868 | 5 | ocd-division/country:fi/kunta:helsinki/osa-alue:jätkäsaari/pienalue:5 | 2020-12-07T13:38:30.312645+02:00 | small_district | 387 | helsinki | ||||||
| 890 | 6 | ocd-division/country:fi/kunta:helsinki/osa-alue:jätkäsaari/pienalue:6 | 2020-12-07T13:38:30.408630+02:00 | small_district | 387 | helsinki | ||||||
| 894 | 7 | ocd-division/country:fi/kunta:helsinki/osa-alue:jätkäsaari/pienalue:7 | 2020-12-07T13:38:30.509369+02:00 | small_district | 387 | helsinki | ||||||
| 638 | 1 | ocd-division/country:fi/kunta:helsinki/osa-alue:hernesaari/pienalue:1 | 2020-12-07T13:38:29.180781+02:00 | small_district | 388 | helsinki | ||||||
| 682 | 2 | ocd-division/country:fi/kunta:helsinki/osa-alue:hernesaari/pienalue:2 | 2020-12-07T13:38:29.601853+02:00 | small_district | 388 | helsinki | ||||||
| 812 | 3 | ocd-division/country:fi/kunta:helsinki/osa-alue:hernesaari/pienalue:3 | 2020-12-07T13:38:29.955386+02:00 | small_district | 388 | helsinki | ||||||
| 579 | 1 | ocd-division/country:fi/kunta:helsinki/osa-alue:hermanninmäki/pienalue:1 | 2020-12-07T13:38:29.220409+02:00 | small_district | 389 | 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 | ||||||
| 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 |
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 );