2,760 rows sorted by origin_id

View and edit SQL

Suggested facets: start, end, type, start (date), end (date), modified_at (date)

municipality

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    

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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
);