2,760 rows sorted by name_fi

View and edit SQL

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

id origin_id ocd_id service_point_id start end modified_at type parent municipality name_fi ▼ name_sv name
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      
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      
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      
553 1 ocd-division/country:fi/kunta:helsinki/osa-alue:maunula/pienalue:1       2020-12-07T13:38:29.502783+02:00 small_district 400 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      
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      
556 1 ocd-division/country:fi/kunta:helsinki/osa-alue:tapulikaupunki/pienalue:1       2020-12-07T13:38:29.326450+02:00 small_district 447 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      
558 1 ocd-division/country:fi/kunta:helsinki/osa-alue:reimarla/pienalue:1       2020-12-07T13:38:29.217521+02:00 small_district 469 helsinki      
559 1 ocd-division/country:fi/kunta:helsinki/osa-alue:myllykallio/pienalue:1       2020-12-07T13:38:29.303522+02:00 small_district 418 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      
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      
562 1 ocd-division/country:fi/kunta:helsinki/osa-alue:kontula/pienalue:1       2020-12-07T13:38:29.205345+02:00 small_district 472 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      
564 1 ocd-division/country:fi/kunta:helsinki/osa-alue:pohjois-haaga/pienalue:1       2020-12-07T13:38:29.229994+02:00 small_district 408 helsinki      
565 1 ocd-division/country:fi/kunta:helsinki/osa-alue:veräjämäki/pienalue:1       2020-12-07T13:38:29.524265+02:00 small_district 403 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      
567 1 ocd-division/country:fi/kunta:helsinki/osa-alue:pitäjänmäen_yritysalue/pienalue:1       2020-12-07T13:38:29.260344+02:00 small_district 471 helsinki      
568 1 ocd-division/country:fi/kunta:helsinki/osa-alue:ylä-malmi/pienalue:1       2020-12-07T13:38:29.409109+02:00 small_district 438 helsinki      
569 1 ocd-division/country:fi/kunta:helsinki/osa-alue:pukinmäki/pienalue:1       2020-12-07T13:38:29.428657+02:00 small_district 437 helsinki      
570 1 ocd-division/country:fi/kunta:helsinki/osa-alue:maununneva/pienalue:1       2020-12-07T13:38:29.405941+02:00 small_district 422 helsinki      
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      
572 1 ocd-division/country:fi/kunta:helsinki/osa-alue:yliskylä/pienalue:1       2020-12-07T13:38:29.369322+02:00 small_district 478 helsinki      
573 1 ocd-division/country:fi/kunta:helsinki/osa-alue:tullisaari/pienalue:1       2020-12-07T13:38:29.425514+02:00 small_district 480 helsinki      
574 1 ocd-division/country:fi/kunta:helsinki/osa-alue:villinki/pienalue:1       2020-12-07T13:38:29.362276+02:00 small_district 483 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      
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      
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      
578 1 ocd-division/country:fi/kunta:helsinki/osa-alue:metsälä/pienalue:1       2020-12-07T13:38:29.247238+02:00 small_district 401 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      
580 1 ocd-division/country:fi/kunta:helsinki/osa-alue:lehtisaari/pienalue:1       2020-12-07T13:38:29.372692+02:00 small_district 412 helsinki      
581 1 ocd-division/country:fi/kunta:helsinki/osa-alue:patola/pienalue:1       2020-12-07T13:38:29.243724+02:00 small_district 402 helsinki      
582 1 ocd-division/country:fi/kunta:helsinki/osa-alue:vallila/pienalue:1       2020-12-07T13:38:29.193584+02:00 small_district 392 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      
584 1 ocd-division/country:fi/kunta:helsinki/osa-alue:tapanila/pienalue:1       2020-12-07T13:38:29.380264+02:00 small_district 445 helsinki      
585 1 ocd-division/country:fi/kunta:helsinki/osa-alue:kumpula/pienalue:1       2020-12-07T13:38:29.214447+02:00 small_district 395 helsinki      
586 1 ocd-division/country:fi/kunta:helsinki/osa-alue:käpylä/pienalue:1       2020-12-07T13:38:29.531234+02:00 small_district 396 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      
588 1 ocd-division/country:fi/kunta:helsinki/osa-alue:pihlajamäki/pienalue:1       2020-12-07T13:38:29.365592+02:00 small_district 440 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      
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      
591 1 ocd-division/country:fi/kunta:helsinki/osa-alue:koskela/pienalue:1       2020-12-07T13:38:29.353314+02:00 small_district 397 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      
593 1 ocd-division/country:fi/kunta:helsinki/osa-alue:kivikko/pienalue:1       2020-12-07T13:38:29.318071+02:00 small_district 475 helsinki      
594 1 ocd-division/country:fi/kunta:helsinki/osa-alue:viikin_tiedepuisto/pienalue:1       2020-12-07T13:38:29.253264+02:00 small_district 435 helsinki      
595 1 ocd-division/country:fi/kunta:helsinki/osa-alue:tattarisuo/pienalue:1       2020-12-07T13:38:29.416746+02:00 small_district 451 helsinki      
596 1 ocd-division/country:fi/kunta:helsinki/osa-alue:tapaninvainio/pienalue:1       2020-12-07T13:38:29.331478+02:00 small_district 444 helsinki      
597 1 ocd-division/country:fi/kunta:helsinki/osa-alue:puotinharju/pienalue:1       2020-12-07T13:38:29.440183+02:00 small_district 462 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      
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      
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      
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      
602 1 ocd-division/country:fi/kunta:helsinki/osa-alue:malmin_lentokenttä/pienalue:1       2020-12-07T13:38:29.389560+02:00 small_district 442 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      

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