administrative_division
148 rows where type = "rescue_sub_district"
This data as json, CSV (advanced)
| id ▼ | origin_id | ocd_id | service_point_id | start | end | modified_at | type | parent | municipality | name_fi | name_sv | name |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1386 | 465 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:pitäjänmäen_yritysalue | 2020-12-07T13:38:35.982597+02:00 | rescue_sub_district | 32 | helsinki | Pitäjänmäen yritysalue | Sockenbacka företagsområde | ||||
| 1387 | 471 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:kontula | 2020-12-07T13:38:35.986865+02:00 | rescue_sub_district | 32 | helsinki | Kontula | Gårdsbacka | ||||
| 1388 | 472 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:vesala | 2020-12-07T13:38:35.991708+02:00 | rescue_sub_district | 32 | helsinki | Vesala | Ärvings | ||||
| 1389 | 473 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:mellunmäki | 2020-12-07T13:38:35.995709+02:00 | rescue_sub_district | 32 | helsinki | Mellunmäki | Mellungsbacka | ||||
| 1390 | 474 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:kivikko | 2020-12-07T13:38:36.000932+02:00 | rescue_sub_district | 32 | helsinki | Kivikko | Stensböle | ||||
| 1391 | 475 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:kurkimäki | 2020-12-07T13:38:36.005976+02:00 | rescue_sub_district | 32 | helsinki | Kurkimäki | Tranbacka | ||||
| 1392 | 480 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:vartiosaari | 2020-12-07T13:38:36.009493+02:00 | rescue_sub_district | 32 | helsinki | Vartiosaari | Vårdö | ||||
| 1393 | 491 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:yliskylä | 2020-12-07T13:38:36.013135+02:00 | rescue_sub_district | 32 | helsinki | Yliskylä | Uppby | ||||
| 1394 | 492 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:jollas | 2020-12-07T13:38:36.017773+02:00 | rescue_sub_district | 32 | helsinki | Jollas | Jollas | ||||
| 1395 | 493 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:tullisaari | 2020-12-07T13:38:36.022680+02:00 | rescue_sub_district | 32 | helsinki | Tullisaari | Turholm | ||||
| 1396 | 494 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:kruunuvuorenranta | 2020-12-07T13:38:36.026657+02:00 | rescue_sub_district | 32 | helsinki | Kruunuvuorenranta | Kronbergsstranden | ||||
| 1397 | 495 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:hevossalmi | 2020-12-07T13:38:36.029937+02:00 | rescue_sub_district | 32 | helsinki | Hevossalmi | Hästnässund | ||||
| 1398 | 500 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:villinki | 2020-12-07T13:38:36.033700+02:00 | rescue_sub_district | 32 | helsinki | Villinki | Villinge | ||||
| 1399 | 510 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:santahamina | 2020-12-07T13:38:36.037237+02:00 | rescue_sub_district | 32 | helsinki | Santahamina | Sandhamn | ||||
| 1400 | 520 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:suomenlinna | 2020-12-07T13:38:36.040938+02:00 | rescue_sub_district | 32 | helsinki | Suomenlinna | Sveaborg | ||||
| 1401 | 531 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:länsisaaret | 2020-12-07T13:38:36.044532+02:00 | rescue_sub_district | 32 | helsinki | Länsisaaret | Västra holmarna | ||||
| 1402 | 532 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:itäsaaret | 2020-12-07T13:38:36.048881+02:00 | rescue_sub_district | 32 | helsinki | Itäsaaret | Östra holmarna | ||||
| 1403 | 533 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:aluemeri | 2020-12-07T13:38:36.052197+02:00 | rescue_sub_district | 32 | helsinki | Aluemeri | Territorialhavet | ||||
| 1404 | 541 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:keski-vuosaari | 2020-12-07T13:38:36.056297+02:00 | rescue_sub_district | 32 | helsinki | Keski-Vuosaari | Mellersta Nordsjö | ||||
| 1405 | 542 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:nordsjön_kartano | 2020-12-07T13:38:36.061198+02:00 | rescue_sub_district | 32 | helsinki | Nordsjön kartano | Nordsjö gård | ||||
| 1406 | 543 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:uutela | 2020-12-07T13:38:36.066140+02:00 | rescue_sub_district | 32 | helsinki | Uutela | Nybondas | ||||
| 1407 | 544 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:meri-rastila | 2020-12-07T13:38:36.070315+02:00 | rescue_sub_district | 32 | helsinki | Meri-Rastila | Havsrastböle | ||||
| 1408 | 545 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:kallahti | 2020-12-07T13:38:36.075161+02:00 | rescue_sub_district | 32 | helsinki | Kallahti | Kallvik | ||||
| 1409 | 546 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:aurinkolahti | 2020-12-07T13:38:36.080251+02:00 | rescue_sub_district | 32 | helsinki | Aurinkolahti | Solvik | ||||
| 1410 | 547 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:rastila | 2020-12-07T13:38:36.085495+02:00 | rescue_sub_district | 32 | helsinki | Rastila | Rastböle | ||||
| 1411 | 548 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:niinisaari | 2020-12-07T13:38:36.091024+02:00 | rescue_sub_district | 32 | helsinki | Niinisaari | Bastö | ||||
| 1412 | 549 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:mustavuori | 2020-12-07T13:38:36.097073+02:00 | rescue_sub_district | 32 | helsinki | Mustavuori | Svarta backen | ||||
| 1413 | 550 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:östersundom | 2020-12-07T13:38:36.103013+02:00 | rescue_sub_district | 32 | helsinki | Östersundom | Östersundom | ||||
| 1414 | 560 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:salmenkallio | 2020-12-07T13:38:36.110813+02:00 | rescue_sub_district | 32 | helsinki | Salmenkallio | Sundberg | ||||
| 1415 | 570 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:talosaari | 2020-12-07T13:38:36.117876+02:00 | rescue_sub_district | 32 | helsinki | Talosaari | Husö | ||||
| 1416 | 580 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:karhusaari | 2020-12-07T13:38:36.124083+02:00 | rescue_sub_district | 32 | helsinki | Karhusaari | Björnsö | ||||
| 1417 | 591 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:landbo | 2020-12-07T13:38:36.128769+02:00 | rescue_sub_district | 32 | helsinki | Landbo | Landbo | ||||
| 1418 | 592 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:puroniitty | 2020-12-07T13:38:36.133129+02:00 | rescue_sub_district | 32 | helsinki | Puroniitty | Bäckängen | ||||
| 1419 | 311 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:kotkavuori | 2020-12-07T13:38:36.137325+02:00 | rescue_sub_district | 32 | helsinki | Kotkavuori | Örnberget | ||||
| 1420 | 312 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:vattuniemi | 2020-12-07T13:38:36.141889+02:00 | rescue_sub_district | 32 | helsinki | Vattuniemi | Hallonnäs | ||||
| 1421 | 313 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:myllykallio | 2020-12-07T13:38:36.146545+02:00 | rescue_sub_district | 32 | helsinki | Myllykallio | Kvarnberget | ||||
| 1422 | 314 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:koivusaari | 2020-12-07T13:38:36.151597+02:00 | rescue_sub_district | 32 | helsinki | Koivusaari | Björkholmen | ||||
| 1423 | 101 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:vilhonvuori | 2020-12-07T13:38:36.155441+02:00 | rescue_sub_district | 32 | helsinki | Vilhonvuori | Vilhemsberg | ||||
| 1424 | 102 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:kalasatama | 2020-12-07T13:38:36.159709+02:00 | rescue_sub_district | 32 | helsinki | Kalasatama | Fiskehamnen | ||||
| 1425 | 103 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:sompasaari | 2020-12-07T13:38:36.163201+02:00 | rescue_sub_district | 32 | helsinki | Sompasaari | Sumparn | ||||
| 1426 | 104 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:hanasaari | 2020-12-07T13:38:36.166797+02:00 | rescue_sub_district | 32 | helsinki | Hanasaari | Hanaholmen | ||||
| 1427 | 211 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:hermanninmäki | 2020-12-07T13:38:36.172190+02:00 | rescue_sub_district | 32 | helsinki | Hermanninmäki | Hermanstadsbacken | ||||
| 1428 | 212 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:hermanninranta | 2020-12-07T13:38:36.176816+02:00 | rescue_sub_district | 32 | helsinki | Hermanninranta | Hermanstadsstranden | ||||
| 1429 | 213 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:kyläsaari | 2020-12-07T13:38:36.180970+02:00 | rescue_sub_district | 32 | helsinki | Kyläsaari | Byholmen | ||||
| 1430 | 161 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:vanha_ruskeasuo | 2020-12-07T13:38:36.185461+02:00 | rescue_sub_district | 32 | helsinki | Vanha Ruskeasuo | Gamla Brunakärr | ||||
| 1431 | 162 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:pikku_huopalahti | 2020-12-07T13:38:36.189810+02:00 | rescue_sub_district | 32 | helsinki | Pikku Huopalahti | Lillhoplax | ||||
| 1432 | 336 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:honkasuo | 2020-12-07T13:38:36.194748+02:00 | rescue_sub_district | 32 | helsinki | Honkasuo | Hongasmossa | ||||
| 1433 | 415 | ocd-division/country:fi/kunta:helsinki/suojelualalohko:alppikylä | 2020-12-07T13:38:36.199341+02:00 | rescue_sub_district | 32 | helsinki | Alppikylä | Alpbyn |
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 );