administrative_division
404 rows where type = "small_district" sorted by ocd_id
This data as json, CSV (advanced)
Suggested facets: origin_id, modified_at (date)
| id | origin_id | ocd_id ▼ | service_point_id | start | end | modified_at | type | parent | municipality | name_fi | name_sv | name |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 571 | 1 | ocd-division/country:fi/kunta:helsinki/osa-alue:ala-malmi/pienalue:1 | 2020-12-07T13:38:29.223738+02:00 | small_district | 439 | 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 | ||||||
| 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 | ||||||
| 824 | 4 | ocd-division/country:fi/kunta:helsinki/osa-alue:ala-malmi/pienalue:4 | 2020-12-07T13:38:30.289452+02:00 | small_district | 439 | helsinki | ||||||
| 860 | 5 | ocd-division/country:fi/kunta:helsinki/osa-alue:ala-malmi/pienalue:5 | 2020-12-07T13:38:30.319897+02:00 | small_district | 439 | helsinki | ||||||
| 516 | 0 | ocd-division/country:fi/kunta:helsinki/osa-alue:alppikylä/pienalue:0 | 2020-12-07T13:38:29.141541+02:00 | small_district | 453 | 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 | ||||||
| 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 | ||||||
| 504 | 0 | ocd-division/country:fi/kunta:helsinki/osa-alue:arabianranta/pienalue:0 | 2020-12-07T13:38:29.113155+02:00 | small_district | 394 | 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 | ||||||
| 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 | ||||||
| 616 | 1 | ocd-division/country:fi/kunta:helsinki/osa-alue:etelä-haaga/pienalue:1 | 2020-12-07T13:38:29.432799+02:00 | small_district | 406 | 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 | ||||||
| 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 | ||||||
| 817 | 4 | ocd-division/country:fi/kunta:helsinki/osa-alue:etelä-haaga/pienalue:4 | 2020-12-07T13:38:30.145885+02:00 | small_district | 406 | helsinki | ||||||
| 869 | 5 | ocd-division/country:fi/kunta:helsinki/osa-alue:etelä-haaga/pienalue:5 | 2020-12-07T13:38:30.350318+02:00 | small_district | 406 | 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 | ||||||
| 587 | 1 | ocd-division/country:fi/kunta:helsinki/osa-alue:hakuninmaa/pienalue:1 | 2020-12-07T13:38:29.358415+02:00 | small_district | 424 | 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 | ||||||
| 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 | ||||||
| 527 | 0 | ocd-division/country:fi/kunta:helsinki/osa-alue:haltiala/pienalue:0 | 2020-12-07T13:38:29.013363+02:00 | small_district | 432 | 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 | ||||||
| 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 | ||||||
| 537 | 0 | ocd-division/country:fi/kunta:helsinki/osa-alue:heikinlaakso/pienalue:0 | 2020-12-07T13:38:29.058389+02:00 | small_district | 450 | 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 | ||||||
| 557 | 1 | ocd-division/country:fi/kunta:helsinki/osa-alue:hermanninranta/pienalue:1 | 2020-12-07T13:38:29.300365+02:00 | small_district | 390 | 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 | ||||||
| 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 | ||||||
| 561 | 1 | ocd-division/country:fi/kunta:helsinki/osa-alue:herttoniemen_yritysalue/pienalue:1 | 2020-12-07T13:38:29.226973+02:00 | small_district | 457 | 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 | ||||||
| 618 | 1 | ocd-division/country:fi/kunta:helsinki/osa-alue:herttoniemenranta/pienalue:1 | 2020-12-07T13:38:29.342229+02:00 | small_district | 458 | 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 | ||||||
| 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 | ||||||
| 531 | 0 | ocd-division/country:fi/kunta:helsinki/osa-alue:honkasuo/pienalue:0 | 2020-12-07T13:38:29.026555+02:00 | small_district | 426 | helsinki | ||||||
| 634 | 1 | ocd-division/country:fi/kunta:helsinki/osa-alue:itä-pakila/pienalue:1 | 2020-12-07T13:38:29.474289+02:00 | small_district | 428 | helsinki | ||||||
| 681 | 2 | ocd-division/country:fi/kunta:helsinki/osa-alue:itä-pakila/pienalue:2 | 2020-12-07T13:38:29.599138+02:00 | small_district | 428 | 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 | ||||||
| 834 | 4 | ocd-division/country:fi/kunta:helsinki/osa-alue:itä-pakila/pienalue:4 | 2020-12-07T13:38:30.265799+02:00 | small_district | 428 | helsinki | ||||||
| 867 | 5 | ocd-division/country:fi/kunta:helsinki/osa-alue:itä-pakila/pienalue:5 | 2020-12-07T13:38:30.306123+02:00 | small_district | 428 | helsinki | ||||||
| 892 | 6 | ocd-division/country:fi/kunta:helsinki/osa-alue:itä-pakila/pienalue:6 | 2020-12-07T13:38:30.437628+02:00 | small_district | 428 | 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 598 | 1 | ocd-division/country:fi/kunta:helsinki/osa-alue:jakomäki/pienalue:1 | 2020-12-07T13:38:29.322083+02:00 | small_district | 452 | helsinki | ||||||
| 693 | 2 | ocd-division/country:fi/kunta:helsinki/osa-alue:jakomäki/pienalue:2 | 2020-12-07T13:38:29.619768+02:00 | small_district | 452 | 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 607 | 1 | ocd-division/country:fi/kunta:helsinki/osa-alue:kannelmäki/pienalue:1 | 2020-12-07T13:38:29.509068+02:00 | small_district | 421 | 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 | ||||||
| 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 | ||||||
| 828 | 4 | ocd-division/country:fi/kunta:helsinki/osa-alue:kannelmäki/pienalue:4 | 2020-12-07T13:38:30.160703+02:00 | small_district | 421 | 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 |
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 );