administrative_division
2,760 rows sorted by origin_id
This data as json, CSV (advanced)
Suggested facets: start, municipality, start (date), end (date)
type ✖
- small_district 404
- preschool_education_fi 314
- muni 313
- statistical_district 305
- neighborhood 185
- lower_comprehensive_school_district_fi 174
- postcode_area 171
- voting_district 169
- rescue_sub_district 148
- sub_district 148
- upper_comprehensive_school_district_fi 110
- nature_reserve 62
- lower_comprehensive_school_district_sv 60
- district 34
- health_station_district 34
- rescue_district 34
- upper_comprehensive_school_district_sv 32
- maternity_clinic_district 26
- preschool_education_sv 19
- major_district 8
- rescue_area 8
- emergency_care_district 2
modified_at (date) ✖
- 2020-12-07 1,928
- 2020-10-02 356
- 2020-06-15 318
- 2020-09-16 87
- 2020-09-28 51
- 2021-01-04 8
- 2020-03-04 6
- 2020-11-18 6
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
3884 | ocd-division/country:fi/kunta:helsinki/esiopetuksen_oppilaaksiottoalue_sv: | 2020-07-01 | 2021-08-01 | 2020-11-18T05:51:36.406681+02:00 | preschool_education_sv | 32 | helsinki | Östersundom | Östersundom | |||
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 | ||||||
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 | ||||||
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 | ||||||
507 | 0 | ocd-division/country:fi/kunta:helsinki/osa-alue:tammisalo/pienalue:0 | 2020-12-07T13:38:29.102197+02:00 | small_district | 459 | helsinki | ||||||
508 | 0 | ocd-division/country:fi/kunta:helsinki/osa-alue:toukola/pienalue:0 | 2020-12-07T13:38:29.081858+02:00 | small_district | 393 | 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 | ||||||
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 | ||||||
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 | ||||||
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 | ||||||
513 | 0 | ocd-division/country:fi/kunta:helsinki/osa-alue:puotila/pienalue:0 | 2020-12-07T13:38:29.033096+02:00 | small_district | 461 | 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 | ||||||
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 | ||||||
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 | ||||||
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 | ||||||
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 | ||||||
519 | 0 | ocd-division/country:fi/kunta:helsinki/osa-alue:kuusisaari/pienalue:0 | 2020-12-07T13:38:29.085405+02:00 | small_district | 411 | 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 | ||||||
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 | ||||||
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 | ||||||
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 | ||||||
524 | 0 | ocd-division/country:fi/kunta:helsinki/osa-alue:tattariharju/pienalue:0 | 2020-12-07T13:38:29.045126+02:00 | small_district | 441 | 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 | ||||||
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 | ||||||
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 | ||||||
528 | 0 | ocd-division/country:fi/kunta:helsinki/osa-alue:lassila/pienalue:0 | 2020-12-07T13:38:29.029592+02:00 | small_district | 409 | helsinki | ||||||
529 | 0 | ocd-division/country:fi/kunta:helsinki/osa-alue:talinranta/pienalue:0 | 2020-12-07T13:38:29.065375+02:00 | small_district | 415 | helsinki | ||||||
530 | 0 | ocd-division/country:fi/kunta:helsinki/osa-alue:niemenmäki/pienalue:0 | 2020-12-07T13:38:29.054867+02:00 | small_district | 414 | 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 | ||||||
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 | ||||||
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 | ||||||
534 | 0 | ocd-division/country:fi/kunta:helsinki/osa-alue:tuomarinkartano/pienalue:0 | 2020-12-07T13:38:29.145706+02:00 | small_district | 431 | helsinki | ||||||
535 | 0 | ocd-division/country:fi/kunta:helsinki/osa-alue:veräjälaakso/pienalue:0 | 2020-12-07T13:38:29.154076+02:00 | small_district | 405 | 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 | ||||||
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 | ||||||
538 | 0 | ocd-division/country:fi/kunta:helsinki/osa-alue:pihlajisto/pienalue:0 | 2020-12-07T13:38:29.109708+02:00 | small_district | 443 | helsinki | ||||||
539 | 0 | ocd-division/country:fi/kunta:helsinki/osa-alue:maunulanpuisto/pienalue:0 | 2020-12-07T13:38:29.078872+02:00 | small_district | 404 | helsinki | ||||||
540 | 0 | ocd-division/country:fi/kunta:helsinki/osa-alue:viikinmäki/pienalue:0 | 2020-12-07T13:38:29.137102+02:00 | small_district | 436 | 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 | ||||||
542 | 0 | ocd-division/country:fi/kunta:helsinki/osa-alue:koivusaari/pienalue:0 | 2020-12-07T13:38:29.123416+02:00 | small_district | 419 | 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 | ||||||
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 | ||||||
545 | 0 | ocd-division/country:fi/kunta:helsinki/osa-alue:vanhakaupunki/pienalue:0 | 2020-12-07T13:38:29.126938+02:00 | small_district | 398 | 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 | ||||||
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 | ||||||
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 | ||||||
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 | ||||||
550 | 0 | ocd-division/country:fi/kunta:helsinki/osa-alue:kivihaka/pienalue:0 | 2020-12-07T13:38:29.050683+02:00 | small_district | 407 | helsinki | ||||||
968 | 001A | ocd-division/country:fi/kunta:helsinki/äänestysalue:001a | 52808 | 2020-12-07T13:38:31.680661+02:00 | voting_district | 32 | helsinki | Kruununhaka A | ||||
969 | 002A | ocd-division/country:fi/kunta:helsinki/äänestysalue:002a | 52768 | 2020-12-07T13:38:31.685878+02:00 | voting_district | 32 | helsinki | Kruununhaka B | ||||
970 | 003A | ocd-division/country:fi/kunta:helsinki/äänestysalue:003a | 52636 | 2020-12-07T13:38:31.689064+02:00 | voting_district | 32 | helsinki | Kaartinkaupunki | ||||
971 | 004A | ocd-division/country:fi/kunta:helsinki/äänestysalue:004a | 52486 | 2020-12-07T13:38:31.692145+02:00 | voting_district | 32 | helsinki | Kamppi | ||||
972 | 004B | ocd-division/country:fi/kunta:helsinki/äänestysalue:004b | 52613 | 2020-12-07T13:38:31.695115+02:00 | voting_district | 32 | helsinki | Hietalahti | ||||
973 | 004C | ocd-division/country:fi/kunta:helsinki/äänestysalue:004c | 52789 | 2020-12-07T13:38:31.698080+02:00 | voting_district | 32 | helsinki | Lapinlahti | ||||
974 | 005A | ocd-division/country:fi/kunta:helsinki/äänestysalue:005a | 52626 | 2020-12-07T13:38:31.701068+02:00 | voting_district | 32 | helsinki | Punavuori A | ||||
975 | 005B | ocd-division/country:fi/kunta:helsinki/äänestysalue:005b | 52706 | 2020-12-07T13:38:31.703991+02:00 | voting_district | 32 | helsinki | Punavuori B | ||||
976 | 005C | ocd-division/country:fi/kunta:helsinki/äänestysalue:005c | 52641 | 2020-12-07T13:38:31.706848+02:00 | voting_district | 32 | helsinki | Eira | ||||
977 | 006A | ocd-division/country:fi/kunta:helsinki/äänestysalue:006a | 52518 | 2020-12-07T13:38:31.709766+02:00 | voting_district | 32 | helsinki | Ruoholahti | ||||
978 | 006B | ocd-division/country:fi/kunta:helsinki/äänestysalue:006b | 52642 | 2020-12-07T13:38:31.712548+02:00 | voting_district | 32 | helsinki | Jätkäsaari A | ||||
979 | 006C | ocd-division/country:fi/kunta:helsinki/äänestysalue:006c | 59230 | 2020-12-07T13:38:31.715239+02:00 | voting_district | 32 | helsinki | Jätkäsaari B | ||||
2774 | 006D | ocd-division/country:fi/kunta:helsinki/äänestysalue:006d | 52542 | 2020-12-07T13:38:31.718033+02:00 | voting_district | 32 | helsinki | Jätkäsaari C | ||||
980 | 007A | ocd-division/country:fi/kunta:helsinki/äänestysalue:007a | 52742 | 2020-12-07T13:38:31.721087+02:00 | voting_district | 32 | helsinki | Ullanlinna A | ||||
981 | 007B | ocd-division/country:fi/kunta:helsinki/äänestysalue:007b | 52775 | 2020-12-07T13:38:31.724465+02:00 | voting_district | 32 | helsinki | Ullanlinna B | ||||
983 | 008A | ocd-division/country:fi/kunta:helsinki/äänestysalue:008a | 52773 | 2020-12-07T13:38:31.727473+02:00 | voting_district | 32 | helsinki | Katajanokka | ||||
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 | ||||
1287 | 010 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:kruununhaka | 2020-12-07T13:38:35.496660+02:00 | rescue_sub_district | 32 | helsinki | Kruununhaka | Kronohagen | ||||
984 | 010A | ocd-division/country:fi/kunta:helsinki/äänestysalue:010a | 52667 | 2020-12-07T13:38:31.730611+02:00 | voting_district | 32 | helsinki | Sörnäinen | ||||
985 | 010B | ocd-division/country:fi/kunta:helsinki/äänestysalue:010b | 52702 | 2020-12-07T13:38:31.734064+02:00 | voting_district | 32 | helsinki | Merihaka | ||||
986 | 010C | ocd-division/country:fi/kunta:helsinki/äänestysalue:010c | 52647 | 2020-12-07T13:38:31.738348+02:00 | voting_district | 32 | helsinki | Kalastatama A | ||||
3944 | 010D | ocd-division/country:fi/kunta:helsinki/äänestysalue:010d | 2020-12-07T13:38:31.742411+02:00 | voting_district | 32 | helsinki | Kalastatama B | |||||
987 | 011A | ocd-division/country:fi/kunta:helsinki/äänestysalue:011a | 52727 | 2020-12-07T13:38:31.746505+02:00 | voting_district | 32 | helsinki | Siltasaari | ||||
988 | 011B | ocd-division/country:fi/kunta:helsinki/äänestysalue:011b | 52587 | 2020-12-07T13:38:31.750202+02:00 | voting_district | 32 | helsinki | Linjat | ||||
989 | 011C | ocd-division/country:fi/kunta:helsinki/äänestysalue:011c | 52687 | 2020-12-07T13:38:31.754338+02:00 | voting_district | 32 | helsinki | Kallio A | ||||
990 | 011D | ocd-division/country:fi/kunta:helsinki/äänestysalue:011d | 52603 | 2020-12-07T13:38:31.758617+02:00 | voting_district | 32 | helsinki | Kallio B | ||||
991 | 011E | ocd-division/country:fi/kunta:helsinki/äänestysalue:011e | 52506 | 2020-12-07T13:38:31.762350+02:00 | voting_district | 32 | helsinki | Kallio C | ||||
992 | 011F | ocd-division/country:fi/kunta:helsinki/äänestysalue:011f | 52809 | 2020-06-15T15:06:15.768224+03:00 | voting_district | 32 | helsinki | Kallio D | ||||
993 | 012A | ocd-division/country:fi/kunta:helsinki/äänestysalue:012a | 52797 | 2020-12-07T13:38:31.765945+02:00 | voting_district | 32 | helsinki | Alppila A | ||||
994 | 012B | ocd-division/country:fi/kunta:helsinki/äänestysalue:012b | 52517 | 2020-12-07T13:38:31.770225+02:00 | voting_district | 32 | helsinki | Alppila B | ||||
995 | 012C | ocd-division/country:fi/kunta:helsinki/äänestysalue:012c | 52533 | 2020-12-07T13:38:31.775168+02:00 | voting_district | 32 | helsinki | Alppila C | ||||
996 | 012D | ocd-division/country:fi/kunta:helsinki/äänestysalue:012d | 52673 | 2020-12-07T13:38:31.780156+02:00 | voting_district | 32 | helsinki | Alppila D | ||||
997 | 013A | ocd-division/country:fi/kunta:helsinki/äänestysalue:013a | 52611 | 2020-12-07T13:38:31.785099+02:00 | voting_district | 32 | helsinki | Etu-Töölö A | ||||
998 | 013B | ocd-division/country:fi/kunta:helsinki/äänestysalue:013b | 52622 | 2020-12-07T13:38:31.790152+02:00 | voting_district | 32 | helsinki | Etu-Töölö B | ||||
999 | 013C | ocd-division/country:fi/kunta:helsinki/äänestysalue:013c | 52699 | 2020-12-07T13:38:31.795102+02:00 | voting_district | 32 | helsinki | Etu-Töölö C | ||||
1000 | 013D | ocd-division/country:fi/kunta:helsinki/äänestysalue:013d | 52507 | 2020-12-07T13:38:31.799456+02:00 | voting_district | 32 | helsinki | Etu-Töölö D | ||||
1001 | 014A | ocd-division/country:fi/kunta:helsinki/äänestysalue:014a | 52692 | 2020-12-07T13:38:31.802381+02:00 | voting_district | 32 | helsinki | Taka-Töölö A | ||||
1002 | 014B | ocd-division/country:fi/kunta:helsinki/äänestysalue:014b | 52572 | 2020-12-07T13:38:31.805288+02:00 | voting_district | 32 | helsinki | Taka-Töölö B | ||||
1003 | 014C | ocd-division/country:fi/kunta:helsinki/äänestysalue:014c | 52787 | 2020-12-07T13:38:31.808315+02:00 | voting_district | 32 | helsinki | Taka-Töölö C | ||||
1004 | 014D | ocd-division/country:fi/kunta:helsinki/äänestysalue:014d | 52693 | 2020-12-07T13:38:31.811619+02:00 | voting_district | 32 | helsinki | Taka-Töölö D | ||||
1005 | 015A | ocd-division/country:fi/kunta:helsinki/äänestysalue:015a | 52546 | 2020-12-07T13:38:31.814943+02:00 | voting_district | 32 | helsinki | Meilahti A | ||||
1006 | 015B | ocd-division/country:fi/kunta:helsinki/äänestysalue:015b | 52781 | 2020-12-07T13:38:31.817687+02:00 | voting_district | 32 | helsinki | Meilahti B | ||||
1007 | 016A | ocd-division/country:fi/kunta:helsinki/äänestysalue:016a | 52694 | 2020-12-07T13:38:31.820482+02:00 | voting_district | 32 | helsinki | Ruskeasuo | ||||
1008 | 016B | ocd-division/country:fi/kunta:helsinki/äänestysalue:016b | 52796 | 2020-12-07T13:38:31.823519+02:00 | voting_district | 32 | helsinki | Pikku Huopalahti | ||||
1009 | 017A | ocd-division/country:fi/kunta:helsinki/äänestysalue:017a | 52509 | 2020-12-07T13:38:31.827054+02:00 | voting_district | 32 | helsinki | Pasila A | ||||
1010 | 017B | ocd-division/country:fi/kunta:helsinki/äänestysalue:017b | 52705 | 2020-12-07T13:38:31.831435+02:00 | voting_district | 32 | helsinki | Itä-Pasila | ||||
1011 | 017C | ocd-division/country:fi/kunta:helsinki/äänestysalue:017c | 52675 | 2020-12-07T13:38:31.835702+02:00 | voting_district | 32 | helsinki | Pasila B | ||||
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 | ||||
1288 | 020 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:kluuvi | 2020-12-07T13:38:35.500689+02:00 | rescue_sub_district | 32 | helsinki | Kluuvi | Gloet | ||||
1012 | 021A | ocd-division/country:fi/kunta:helsinki/äänestysalue:021a | 52596 | 2020-12-07T13:38:31.839829+02:00 | voting_district | 32 | helsinki | Hermanni A | ||||
1013 | 021B | ocd-division/country:fi/kunta:helsinki/äänestysalue:021b | 52619 | 2020-12-07T13:38:31.844109+02:00 | voting_district | 32 | helsinki | Hermanni B | ||||
1014 | 022A | ocd-division/country:fi/kunta:helsinki/äänestysalue:022a | 52689 | 2020-12-07T13:38:31.848129+02:00 | voting_district | 32 | helsinki | Vallila A |
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 );