administrative_division
23 rows where "modified_at" is on date 2020-12-07 and type = "health_station_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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
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 );