administrative_division
1,928 rows where "modified_at" is on date 2020-12-07 sorted by origin_id descending
This data as json, CSV (advanced)
Suggested facets: start, end, type, start (date), end (date)
| id | origin_id ▲ | ocd_id | service_point_id | start | end | modified_at | type | parent | municipality | name_fi | name_sv | name |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1249 | VUOSAARI | ocd-division/country:fi/kunta:helsinki/terveysasema-alue:vuosaari | 4313 | 2020-12-07T13:38:33.122627+02:00 | health_station_district | 32 | helsinki | Vuosaari | ||||
| 3579 | VUOSAARI | ocd-division/country:fi/kunta:helsinki/neuvola-alue:vuosaari | 11623 | 2020-12-07T13:38:50.339671+02:00 | maternity_clinic_district | 32 | helsinki | Vuosaari | ||||
| 1230 | VIISKULMA | ocd-division/country:fi/kunta:helsinki/terveysasema-alue:viiskulma | 6365 | 2020-12-07T13:38:33.055839+02:00 | health_station_district | 32 | helsinki | Viiskulma | ||||
| 3587 | VIISKULMA | ocd-division/country:fi/kunta:helsinki/neuvola-alue:viiskulma | 11700 | 2020-12-07T13:38:50.362844+02:00 | maternity_clinic_district | 32 | helsinki | Viiskulma | ||||
| 1237 | TÖÖLÖ | ocd-division/country:fi/kunta:helsinki/terveysasema-alue:töölö | 6320 | 2020-12-07T13:38:33.086339+02:00 | health_station_district | 32 | helsinki | Töölö | ||||
| 3572 | TÖÖLÖ | ocd-division/country:fi/kunta:helsinki/neuvola-alue:töölö | 11689 | 2020-12-07T13:38:50.308009+02:00 | maternity_clinic_district | 32 | helsinki | Töölö | ||||
| 5707 | Sipoo | ocd-division/country:fi/kunta:helsinki/luonnonsuojelualue:sipoo | 2020-12-07T13:39:00.321429+02:00 | nature_reserve | 32 | helsinki | Eestiluodon Alörsörnen-Alören | |||||
| 1238 | SUUTARILA | ocd-division/country:fi/kunta:helsinki/terveysasema-alue:suutarila | 4598 | 2020-12-07T13:38:33.090952+02:00 | health_station_district | 32 | helsinki | Suutarila | ||||
| 3573 | SUUTARILA | ocd-division/country:fi/kunta:helsinki/neuvola-alue:suutarila | 12000 | 2020-12-07T13:38:50.312451+02:00 | maternity_clinic_district | 32 | helsinki | Suutarila | ||||
| 1240 | PUISTOLA | ocd-division/country:fi/kunta:helsinki/terveysasema-alue:puistola | 4759 | 2020-12-07T13:38:33.097688+02:00 | health_station_district | 32 | helsinki | Puistola | ||||
| 3575 | PUISTOLA | ocd-division/country:fi/kunta:helsinki/neuvola-alue:puistola | 11611 | 2020-12-07T13:38:50.321440+02:00 | maternity_clinic_district | 32 | helsinki | Puistola | ||||
| 1242 | PITÄJÄNMÄKI | ocd-division/country:fi/kunta:helsinki/terveysasema-alue:pitäjänmäki | 6398 | 2020-12-07T13:38:33.101137+02:00 | health_station_district | 32 | helsinki | Pitäjänmäki | ||||
| 3577 | PITÄJÄNMÄKI | ocd-division/country:fi/kunta:helsinki/neuvola-alue:pitäjänmäki | 11999 | 2020-12-07T13:38:50.330066+02:00 | maternity_clinic_district | 32 | helsinki | Pitäjänmäki | ||||
| 1246 | PIHLAJAMÄKI | ocd-division/country:fi/kunta:helsinki/terveysasema-alue:pihlajamäki | 5465 | 2020-12-07T13:38:33.109009+02:00 | health_station_district | 32 | helsinki | Pihlajamäki | ||||
| 3583 | PIHLAJAMÄKI | ocd-division/country:fi/kunta:helsinki/neuvola-alue:pihlajamäki | 11946 | 2020-12-07T13:38:50.351411+02:00 | maternity_clinic_district | 32 | helsinki | Pihlajamäki | ||||
| 1235 | PALOHEINÄ | ocd-division/country:fi/kunta:helsinki/terveysasema-alue:paloheinä | 6385 | 2020-12-07T13:38:33.075722+02:00 | health_station_district | 32 | helsinki | Paloheinä | ||||
| 3569 | PALOHEINÄ | ocd-division/country:fi/kunta:helsinki/neuvola-alue:paloheinä | 11638 | 2020-12-07T13:38:50.295939+02:00 | maternity_clinic_district | 32 | helsinki | Paloheinä | ||||
| 1239 | OULUNKYLÄ | ocd-division/country:fi/kunta:helsinki/terveysasema-alue:oulunkylä | 6065 | 2020-12-07T13:38:33.094446+02:00 | health_station_district | 32 | helsinki | Oulunkylä | ||||
| 3574 | OULUNKYLÄ | ocd-division/country:fi/kunta:helsinki/neuvola-alue:oulunkylä | 11716 | 2020-12-07T13:38:50.317584+02:00 | maternity_clinic_district | 32 | helsinki | Oulunkylä | ||||
| 1247 | MYLLYPURO | ocd-division/country:fi/kunta:helsinki/terveysasema-alue:myllypuro | 31791 | 2020-12-07T13:38:33.112519+02:00 | health_station_district | 32 | helsinki | Myllypuro | ||||
| 1243 | MUNKKINIEMI | ocd-division/country:fi/kunta:helsinki/terveysasema-alue:munkkiniemi | 5852 | 2020-12-07T13:38:33.029852+02:00 | health_station_district | 32 | helsinki | Munkkiniemi | ||||
| 3580 | MUNKKINIEMI | ocd-division/country:fi/kunta:helsinki/neuvola-alue:munkkiniemi | 11953 | 2020-12-07T13:38:50.344237+02:00 | maternity_clinic_district | 32 | helsinki | Munkkiniemi | ||||
| 1234 | MAUNULA | ocd-division/country:fi/kunta:helsinki/terveysasema-alue:maunula | 5644 | 2020-12-07T13:38:33.018116+02:00 | health_station_district | 32 | helsinki | Maunula | ||||
| 3568 | MAUNULA | ocd-division/country:fi/kunta:helsinki/neuvola-alue:maunula | 11884 | 2020-12-07T13:38:50.291378+02:00 | maternity_clinic_district | 32 | helsinki | Maunula | ||||
| 1233 | MALMINKARTANO | ocd-division/country:fi/kunta:helsinki/terveysasema-alue:malminkartano | 5743 | 2020-12-07T13:38:33.070929+02:00 | health_station_district | 32 | helsinki | Malminkartano | ||||
| 3571 | MALMINKARTANO | ocd-division/country:fi/kunta:helsinki/neuvola-alue:malminkartano | 11984 | 2020-12-07T13:38:50.304010+02:00 | maternity_clinic_district | 32 | helsinki | Malminkartano | ||||
| 1248 | MALMI | ocd-division/country:fi/kunta:helsinki/terveysasema-alue:malmi | 4029 | 2020-12-07T13:38:33.118401+02:00 | health_station_district | 32 | helsinki | Malmi | ||||
| 3578 | MALMI | ocd-division/country:fi/kunta:helsinki/neuvola-alue:malmi | 11799 | 2020-12-07T13:38:50.334779+02:00 | maternity_clinic_district | 32 | helsinki | Malmi | ||||
| 1236 | LAUTTASAARI | ocd-division/country:fi/kunta:helsinki/terveysasema-alue:lauttasaari | 5332 | 2020-12-07T13:38:33.080891+02:00 | health_station_district | 32 | helsinki | Lauttasaari | ||||
| 3570 | LAUTTASAARI | ocd-division/country:fi/kunta:helsinki/neuvola-alue:lauttasaari | 11596 | 2020-12-07T13:38:50.300415+02:00 | maternity_clinic_district | 32 | helsinki | Lauttasaari | ||||
| 1231 | LAAKSO | ocd-division/country:fi/kunta:helsinki/terveysasema-alue:laakso | 5552 | 2020-12-07T13:38:33.061226+02:00 | health_station_district | 32 | helsinki | Laakso | ||||
| 3588 | LAAKSO | ocd-division/country:fi/kunta:helsinki/neuvola-alue:laakso | 11868 | 2020-12-07T13:38:50.366537+02:00 | maternity_clinic_district | 32 | helsinki | Laakso | ||||
| 1225 | LAAJASALO | ocd-division/country:fi/kunta:helsinki/terveysasema-alue:laajasalo | 6247 | 2020-12-07T13:38:33.035079+02:00 | health_station_district | 32 | helsinki | Laajasalo | ||||
| 3586 | LAAJASALO | ocd-division/country:fi/kunta:helsinki/neuvola-alue:laajasalo | 12030 | 2020-12-07T13:38:50.359212+02:00 | maternity_clinic_district | 32 | helsinki | Laajasalo | ||||
| 1229 | KONTULA | ocd-division/country:fi/kunta:helsinki/terveysasema-alue:kontula | 6129 | 2020-12-07T13:38:33.050590+02:00 | health_station_district | 32 | helsinki | Kontula | ||||
| 1228 | KIVIKKO | ocd-division/country:fi/kunta:helsinki/terveysasema-alue:kivikko | 5493 | 2020-12-07T13:38:33.045265+02:00 | health_station_district | 32 | helsinki | Kivikko | ||||
| 1232 | KANNELMÄKI | ocd-division/country:fi/kunta:helsinki/terveysasema-alue:kannelmäki | 5163 | 2020-12-07T13:38:33.066158+02:00 | health_station_district | 32 | helsinki | Kannelmäki | ||||
| 3581 | KALLIO | ocd-division/country:fi/kunta:helsinki/neuvola-alue:kallio | 11933 | 2020-12-07T13:38:50.347528+02:00 | maternity_clinic_district | 32 | helsinki | Kallio | ||||
| 2776 | KALASATAMA | ocd-division/country:fi/kunta:helsinki/terveysasema-alue:kalasatama | 5846 | 2020-12-07T13:38:33.105175+02:00 | health_station_district | 32 | helsinki | Kalasatama | ||||
| 1241 | JAKOMÄKI | ocd-division/country:fi/kunta:helsinki/terveysasema-alue:jakomäki | 6416 | 2020-12-07T13:38:33.024805+02:00 | health_station_district | 32 | helsinki | Jakomäki | ||||
| 3576 | JAKOMÄKI | ocd-division/country:fi/kunta:helsinki/neuvola-alue:jakomäki | 11821 | 2020-12-07T13:38:50.325789+02:00 | maternity_clinic_district | 32 | helsinki | Jakomäki | ||||
| 3894 | ITÄKATU | ocd-division/country:fi/kunta:helsinki/neuvola-alue:itäkatu | 56147 | 2020-12-07T13:38:50.355262+02:00 | maternity_clinic_district | 32 | helsinki | Itäkatu | ||||
| 1227 | HAAGA | ocd-division/country:fi/kunta:helsinki/terveysasema-alue:haaga | 4367 | 2020-12-07T13:38:33.039547+02:00 | health_station_district | 32 | helsinki | Haaga | ||||
| 3589 | HAAGA | ocd-division/country:fi/kunta:helsinki/neuvola-alue:haaga | 11750 | 2020-12-07T13:38:50.370079+02:00 | maternity_clinic_district | 32 | helsinki | Haaga | ||||
| 907 | 9 | ocd-division/country:fi/kunta:helsinki/osa-alue:keski-vuosaari/pienalue:9 | 2020-12-07T13:38:30.528583+02:00 | small_district | 489 | helsinki | ||||||
| 5706 | 9 | ocd-division/country:fi/kunta:helsinki/luonnonsuojelualue:9 | 2020-12-07T13:39:00.316850+02:00 | nature_reserve | 32 | helsinki | Ruutinkosken lehto | |||||
| 355 | 801 | ocd-division/country:fi/kunta:helsinki/peruspiiri:östersundom | 2020-12-07T13:38:23.866605+02:00 | district | 321 | helsinki | Östersundom | Östersundom | ||||
| 1285 | 801 | ocd-division/country:fi/kunta:helsinki/suojelulohko:östersundom | 2020-12-07T13:38:34.909488+02:00 | rescue_district | 32 | helsinki | Östersundom | Östersundom | ||||
| 321 | 8 | ocd-division/country:fi/kunta:helsinki/suurpiiri:östersundom | 2020-12-07T13:38:22.324794+02:00 | major_district | 32 | helsinki | Östersundom | Östersundom | ||||
| 903 | 8 | ocd-division/country:fi/kunta:helsinki/osa-alue:keski-vuosaari/pienalue:8 | 2020-12-07T13:38:30.521233+02:00 | small_district | 489 | helsinki | ||||||
| 904 | 8 | ocd-division/country:fi/kunta:helsinki/osa-alue:kamppi/pienalue:8 | 2020-12-07T13:38:30.517113+02:00 | small_district | 359 | helsinki | ||||||
| 905 | 8 | ocd-division/country:fi/kunta:helsinki/osa-alue:patola/pienalue:8 | 2020-12-07T13:38:30.513459+02:00 | small_district | 402 | helsinki | ||||||
| 906 | 8 | ocd-division/country:fi/kunta:helsinki/osa-alue:myllypuro/pienalue:8 | 2020-12-07T13:38:30.524587+02:00 | small_district | 463 | helsinki | ||||||
| 5705 | 8 | ocd-division/country:fi/kunta:helsinki/luonnonsuojelualue:8 | 2020-12-07T13:39:00.311954+02:00 | nature_reserve | 32 | helsinki | Kivisaaren luodot ja luotoja ympäröivä vesialue | |||||
| 354 | 704 | ocd-division/country:fi/kunta:helsinki/peruspiiri:vuosaari | 2020-12-07T13:38:23.852867+02:00 | district | 320 | helsinki | Vuosaari | Nordsjö | ||||
| 1284 | 704 | ocd-division/country:fi/kunta:helsinki/suojelulohko:vuosaari | 2020-12-07T13:38:34.904422+02:00 | rescue_district | 32 | helsinki | Vuosaari | Nordsjö | ||||
| 353 | 703 | ocd-division/country:fi/kunta:helsinki/peruspiiri:mellunkylä | 2020-12-07T13:38:23.841864+02:00 | district | 320 | helsinki | Mellunkylä | Mellungsby | ||||
| 1283 | 703 | ocd-division/country:fi/kunta:helsinki/suojelulohko:mellunkylä | 2020-12-07T13:38:34.899546+02:00 | rescue_district | 32 | helsinki | Mellunkylä | Mellungsby | ||||
| 352 | 702 | ocd-division/country:fi/kunta:helsinki/peruspiiri:myllypuro | 2020-12-07T13:38:23.826457+02:00 | district | 320 | helsinki | Myllypuro | Kvarnbäcken | ||||
| 1282 | 702 | ocd-division/country:fi/kunta:helsinki/suojelulohko:myllypuro | 2020-12-07T13:38:34.894638+02:00 | rescue_district | 32 | helsinki | Myllypuro | Kvarnbäcken | ||||
| 351 | 701 | ocd-division/country:fi/kunta:helsinki/peruspiiri:vartiokylä | 2020-12-07T13:38:23.817661+02:00 | district | 320 | helsinki | Vartiokylä | Botby | ||||
| 1281 | 701 | ocd-division/country:fi/kunta:helsinki/suojelulohko:vartiokylä | 2020-12-07T13:38:34.889354+02:00 | rescue_district | 32 | helsinki | Vartiokylä | Botby | ||||
| 320 | 7 | ocd-division/country:fi/kunta:helsinki/suurpiiri:itäinen | 2020-12-07T13:38:22.320208+02:00 | major_district | 32 | helsinki | Itäinen | Östra | ||||
| 894 | 7 | ocd-division/country:fi/kunta:helsinki/osa-alue:jätkäsaari/pienalue:7 | 2020-12-07T13:38:30.509369+02:00 | small_district | 387 | helsinki | ||||||
| 895 | 7 | ocd-division/country:fi/kunta:helsinki/osa-alue:patola/pienalue:7 | 2020-12-07T13:38:30.474122+02:00 | small_district | 402 | helsinki | ||||||
| 896 | 7 | ocd-division/country:fi/kunta:helsinki/osa-alue:kluuvi/pienalue:7 | 2020-12-07T13:38:30.495698+02:00 | small_district | 357 | helsinki | ||||||
| 897 | 7 | ocd-division/country:fi/kunta:helsinki/osa-alue:kamppi/pienalue:7 | 2020-12-07T13:38:30.484504+02:00 | small_district | 359 | helsinki | ||||||
| 898 | 7 | ocd-division/country:fi/kunta:helsinki/osa-alue:tapaninvainio/pienalue:7 | 2020-12-07T13:38:30.488084+02:00 | small_district | 444 | helsinki | ||||||
| 899 | 7 | ocd-division/country:fi/kunta:helsinki/osa-alue:myllypuro/pienalue:7 | 2020-12-07T13:38:30.492220+02:00 | small_district | 463 | helsinki | ||||||
| 900 | 7 | ocd-division/country:fi/kunta:helsinki/osa-alue:vallila/pienalue:7 | 2020-12-07T13:38:30.479307+02:00 | small_district | 392 | helsinki | ||||||
| 901 | 7 | ocd-division/country:fi/kunta:helsinki/osa-alue:kruunuvuorenranta/pienalue:7 | 2020-12-07T13:38:30.504458+02:00 | small_district | 481 | helsinki | ||||||
| 902 | 7 | ocd-division/country:fi/kunta:helsinki/osa-alue:yliskylä/pienalue:7 | 2020-12-07T13:38:30.499887+02:00 | small_district | 478 | helsinki | ||||||
| 5704 | 7 | ocd-division/country:fi/kunta:helsinki/luonnonsuojelualue:7 | 2020-12-07T13:39:00.307554+02:00 | nature_reserve | 32 | helsinki | Mustavuori-Porvarinlahti | |||||
| 1251 | 6361 | ocd-division/country:fi/kunta:helsinki/päivystysalue:marian_päivystysalue | 2020-12-07T13:38:33.700935+02:00 | emergency_care_district | 32 | helsinki | Marian päivystysalue | |||||
| 1250 | 6360 | ocd-division/country:fi/kunta:helsinki/päivystysalue:haartmanin_päivystysalue | 2020-12-07T13:38:33.692677+02:00 | emergency_care_district | 32 | helsinki | Haartmanin päivystysalue | |||||
| 5703 | 61 | ocd-division/country:fi/kunta:helsinki/luonnonsuojelualue:61 | 2020-12-07T13:39:00.302679+02:00 | nature_reserve | 32 | helsinki | Haltialanmetsä | |||||
| 350 | 603 | ocd-division/country:fi/kunta:helsinki/peruspiiri:laajasalo | 2020-12-07T13:38:23.808503+02:00 | district | 319 | helsinki | Laajasalo | Degerö | ||||
| 1280 | 603 | ocd-division/country:fi/kunta:helsinki/suojelulohko:laajasalo | 2020-12-07T13:38:34.885418+02:00 | rescue_district | 32 | helsinki | Laajasalo | Degerö | ||||
| 349 | 602 | ocd-division/country:fi/kunta:helsinki/peruspiiri:herttoniemi | 2020-12-07T13:38:23.798964+02:00 | district | 319 | helsinki | Herttoniemi | Hertonäs | ||||
| 1279 | 602 | ocd-division/country:fi/kunta:helsinki/suojelulohko:herttoniemi | 2020-12-07T13:38:34.881257+02:00 | rescue_district | 32 | helsinki | Herttoniemi | Hertonäs | ||||
| 348 | 601 | ocd-division/country:fi/kunta:helsinki/peruspiiri:kulosaari | 2020-12-07T13:38:23.785115+02:00 | district | 319 | helsinki | Kulosaari | Brändö | ||||
| 1278 | 601 | ocd-division/country:fi/kunta:helsinki/suojelulohko:kulosaari | 2020-12-07T13:38:34.877460+02:00 | rescue_district | 32 | helsinki | Kulosaari | Brändö | ||||
| 5702 | 60 | ocd-division/country:fi/kunta:helsinki/luonnonsuojelualue:60 | 2020-12-07T13:39:00.298115+02:00 | nature_reserve | 32 | helsinki | Pormestarinluodot | |||||
| 319 | 6 | ocd-division/country:fi/kunta:helsinki/suurpiiri:kaakkoinen | 2020-12-07T13:38:22.316767+02:00 | major_district | 32 | helsinki | Kaakkoinen | Sydöstra | ||||
| 877 | 6 | ocd-division/country:fi/kunta:helsinki/osa-alue:kontula/pienalue:6 | 2020-12-07T13:38:30.442467+02:00 | small_district | 472 | helsinki | ||||||
| 878 | 6 | ocd-division/country:fi/kunta:helsinki/osa-alue:myllypuro/pienalue:6 | 2020-12-07T13:38:30.393923+02:00 | small_district | 463 | helsinki | ||||||
| 879 | 6 | ocd-division/country:fi/kunta:helsinki/osa-alue:tapanila/pienalue:6 | 2020-12-07T13:38:30.455057+02:00 | small_district | 445 | helsinki | ||||||
| 880 | 6 | ocd-division/country:fi/kunta:helsinki/osa-alue:länsi-herttoniemi/pienalue:6 | 2020-12-07T13:38:30.468725+02:00 | small_district | 455 | helsinki | ||||||
| 881 | 6 | ocd-division/country:fi/kunta:helsinki/osa-alue:patola/pienalue:6 | 2020-12-07T13:38:30.430904+02:00 | small_district | 402 | helsinki | ||||||
| 882 | 6 | ocd-division/country:fi/kunta:helsinki/osa-alue:kruunuvuorenranta/pienalue:6 | 2020-12-07T13:38:30.425578+02:00 | small_district | 481 | helsinki | ||||||
| 883 | 6 | ocd-division/country:fi/kunta:helsinki/osa-alue:kluuvi/pienalue:6 | 2020-12-07T13:38:30.451325+02:00 | small_district | 357 | helsinki | ||||||
| 884 | 6 | ocd-division/country:fi/kunta:helsinki/osa-alue:keski-vuosaari/pienalue:6 | 2020-12-07T13:38:30.459298+02:00 | small_district | 489 | helsinki | ||||||
| 885 | 6 | ocd-division/country:fi/kunta:helsinki/osa-alue:vallila/pienalue:6 | 2020-12-07T13:38:30.446657+02:00 | small_district | 392 | helsinki | ||||||
| 886 | 6 | ocd-division/country:fi/kunta:helsinki/osa-alue:yliskylä/pienalue:6 | 2020-12-07T13:38:30.404086+02:00 | small_district | 478 | helsinki | ||||||
| 887 | 6 | ocd-division/country:fi/kunta:helsinki/osa-alue:tapaninvainio/pienalue:6 | 2020-12-07T13:38:30.398976+02:00 | small_district | 444 | helsinki | ||||||
| 888 | 6 | ocd-division/country:fi/kunta:helsinki/osa-alue:taka-töölö/pienalue:6 | 2020-12-07T13:38:30.414116+02:00 | small_district | 375 | helsinki | ||||||
| 889 | 6 | ocd-division/country:fi/kunta:helsinki/osa-alue:kamppi/pienalue:6 | 2020-12-07T13:38:30.419686+02:00 | small_district | 359 | helsinki | ||||||
| 890 | 6 | ocd-division/country:fi/kunta:helsinki/osa-alue:jätkäsaari/pienalue:6 | 2020-12-07T13:38:30.408630+02:00 | small_district | 387 | helsinki | ||||||
| 891 | 6 | ocd-division/country:fi/kunta:helsinki/osa-alue:siltamäki/pienalue:6 | 2020-12-07T13:38:30.464337+02:00 | small_district | 446 | helsinki | ||||||
| 892 | 6 | ocd-division/country:fi/kunta:helsinki/osa-alue:itä-pakila/pienalue:6 | 2020-12-07T13:38:30.437628+02:00 | small_district | 428 | 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 );