administrative_division
404 rows where type = "small_district" sorted by modified_at
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 635 | 1 | ocd-division/country:fi/kunta:helsinki/osa-alue:vattuniemi/pienalue:1 | 2020-12-07T13:38:29.199341+02:00 | small_district | 417 | helsinki | ||||||
| 626 | 1 | ocd-division/country:fi/kunta:helsinki/osa-alue:kyläsaari/pienalue:1 | 2020-12-07T13:38:29.202270+02:00 | small_district | 391 | 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 | ||||||
| 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 | ||||||
| 639 | 1 | ocd-division/country:fi/kunta:helsinki/osa-alue:puistola/pienalue:1 | 2020-12-07T13:38:29.211405+02:00 | small_district | 449 | 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 617 | 1 | ocd-division/country:fi/kunta:helsinki/osa-alue:suomenlinna/pienalue:1 | 2020-12-07T13:38:29.240481+02:00 | small_district | 485 | 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 613 | 1 | ocd-division/country:fi/kunta:helsinki/osa-alue:latokartano/pienalue:1 | 2020-12-07T13:38:29.257084+02:00 | small_district | 434 | 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 | ||||||
| 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 | ||||||
| 646 | 1 | ocd-division/country:fi/kunta:helsinki/osa-alue:länsisaaret/pienalue:1 | 2020-12-07T13:38:29.266267+02:00 | small_district | 486 | 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 | ||||||
| 640 | 1 | ocd-division/country:fi/kunta:helsinki/osa-alue:kruunuvuorenranta/pienalue:1 | 2020-12-07T13:38:29.272872+02:00 | small_district | 481 | helsinki | ||||||
| 619 | 1 | ocd-division/country:fi/kunta:helsinki/osa-alue:munkkivuori/pienalue:1 | 2020-12-07T13:38:29.276157+02:00 | small_district | 413 | 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 | ||||||
| 628 | 1 | ocd-division/country:fi/kunta:helsinki/osa-alue:torpparinmäki/pienalue:1 | 2020-12-07T13:38:29.283393+02:00 | small_district | 430 | helsinki | ||||||
| 637 | 1 | ocd-division/country:fi/kunta:helsinki/osa-alue:länsi-pakila/pienalue:1 | 2020-12-07T13:38:29.287398+02:00 | small_district | 427 | helsinki | ||||||
| 624 | 1 | ocd-division/country:fi/kunta:helsinki/osa-alue:vesala/pienalue:1 | 2020-12-07T13:38:29.290934+02:00 | small_district | 473 | 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 620 | 1 | ocd-division/country:fi/kunta:helsinki/osa-alue:kotkavuori/pienalue:1 | 2020-12-07T13:38:29.306888+02:00 | small_district | 416 | 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 | ||||||
| 629 | 1 | ocd-division/country:fi/kunta:helsinki/osa-alue:pirkkola/pienalue:1 | 2020-12-07T13:38:29.313774+02:00 | small_district | 399 | 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 |
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 );