administrative_division
34 rows where type = "health_station_district"
This data as json, CSV (advanced)
Suggested facets: municipality, name_sv, modified_at (date)
id ▼ | origin_id | ocd_id | service_point_id | start | end | modified_at | type | parent | municipality | name_fi | name_sv | name |
---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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ä | ||||
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 | ||||
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ö | ||||
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 | ||||
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ä | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
3933 | 15537 | ocd-division/country:fi/kunta:espoo/terveysasema-alue:15537 | 15537 | 2020-09-16T22:31:01.884788+03:00 | health_station_district | 11 | espoo | Kalajärven terveysasema | Kalajärvi hälsostation | |||
3934 | 15433 | ocd-division/country:fi/kunta:espoo/terveysasema-alue:15433 | 15433 | 2020-09-16T22:31:01.890893+03:00 | health_station_district | 11 | espoo | Kilon terveysasema | Kilo hälsostation | |||
3935 | 33168 | ocd-division/country:fi/kunta:espoo/terveysasema-alue:33168 | 33168 | 2020-09-16T22:31:01.895149+03:00 | health_station_district | 11 | espoo | Samaria terveysasema | Samaria hälsostation | |||
3936 | 15452 | ocd-division/country:fi/kunta:espoo/terveysasema-alue:15452 | 15452 | 2020-09-16T22:31:01.898631+03:00 | health_station_district | 11 | espoo | Samaria terveysasema | Samaria hälsostation | |||
3937 | 15708 | ocd-division/country:fi/kunta:espoo/terveysasema-alue:15708 | 15708 | 2020-09-16T22:31:01.902186+03:00 | health_station_district | 11 | espoo | Kivenlahden terveysasema | Stensviks hälsostation | |||
3938 | 15479 | ocd-division/country:fi/kunta:espoo/terveysasema-alue:15479 | 15479 | 2020-09-16T22:31:01.905330+03:00 | health_station_district | 11 | espoo | Oma Lääkärisi Matinkylä | Oma Lääkärisi Mattby | |||
3939 | 15628 | ocd-division/country:fi/kunta:espoo/terveysasema-alue:15628 | 15628 | 2020-09-16T22:31:01.909531+03:00 | health_station_district | 11 | espoo | Ison Omenan terveysasema | Iso Omena hälsostation | |||
3940 | 15753 | ocd-division/country:fi/kunta:espoo/terveysasema-alue:15753 | 15753 | 2020-09-16T22:31:01.912839+03:00 | health_station_district | 11 | espoo | Tapiolan terveysasema | Hagalunds hälsostation | |||
3941 | 15649 | ocd-division/country:fi/kunta:espoo/terveysasema-alue:15649 | 15649 | 2020-09-16T22:31:01.916151+03:00 | health_station_district | 11 | espoo | Espoonlahden terveysasema | Esbovikens hälsostation | |||
3942 | 15740 | ocd-division/country:fi/kunta:espoo/terveysasema-alue:15740 | 15740 | 2020-09-16T22:31:01.919554+03:00 | health_station_district | 11 | espoo | Viherlaakson terveysasema | Gröndals hälsostation | |||
3943 | 15744 | ocd-division/country:fi/kunta:espoo/terveysasema-alue:15744 | 15744 | 2020-09-16T22:31:01.923212+03:00 | health_station_district | 11 | espoo | Leppävaaran terveysasema | Alberga hälsostation |
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 );