administrative_division
34 rows where type = "rescue_district" sorted by end descending
This data as json, CSV (advanced)
Suggested facets: modified_at (date)
id | origin_id | ocd_id | service_point_id | start | end ▲ | modified_at | type | parent | municipality | name_fi | name_sv | name |
---|---|---|---|---|---|---|---|---|---|---|---|---|
1252 | 101 | ocd-division/country:fi/kunta:helsinki/suojelulohko:vironniemi | 2020-12-07T13:38:34.747694+02:00 | rescue_district | 32 | helsinki | Vironniemi | Estnäs | ||||
1253 | 102 | ocd-division/country:fi/kunta:helsinki/suojelulohko:ullanlinna | 2020-12-07T13:38:34.753557+02:00 | rescue_district | 32 | helsinki | Ullanlinna | Ulrikasborg | ||||
1254 | 103 | ocd-division/country:fi/kunta:helsinki/suojelulohko:kampinmalmi | 2020-12-07T13:38:34.759669+02:00 | rescue_district | 32 | helsinki | Kampinmalmi | Kampmalmen | ||||
1255 | 104 | ocd-division/country:fi/kunta:helsinki/suojelulohko:taka-töölö | 2020-12-07T13:38:34.764019+02:00 | rescue_district | 32 | helsinki | Taka-Töölö | Bortre Tölö | ||||
1256 | 105 | ocd-division/country:fi/kunta:helsinki/suojelulohko:lauttasaari | 2020-12-07T13:38:34.768014+02:00 | rescue_district | 32 | helsinki | Lauttasaari | Drumsö | ||||
1257 | 201 | ocd-division/country:fi/kunta:helsinki/suojelulohko:reijola | 2020-12-07T13:38:34.771768+02:00 | rescue_district | 32 | helsinki | Reijola | Grejus | ||||
1258 | 202 | ocd-division/country:fi/kunta:helsinki/suojelulohko:munkkiniemi | 2020-12-07T13:38:34.776528+02:00 | rescue_district | 32 | helsinki | Munkkiniemi | Munksnäs | ||||
1259 | 203 | ocd-division/country:fi/kunta:helsinki/suojelulohko:haaga | 2020-12-07T13:38:34.780727+02:00 | rescue_district | 32 | helsinki | Haaga | Haga | ||||
1260 | 204 | ocd-division/country:fi/kunta:helsinki/suojelulohko:pitäjänmäki | 2020-12-07T13:38:34.785627+02:00 | rescue_district | 32 | helsinki | Pitäjänmäki | Sockenbacka | ||||
1261 | 205 | ocd-division/country:fi/kunta:helsinki/suojelulohko:kaarela | 2020-12-07T13:38:34.792293+02:00 | rescue_district | 32 | helsinki | Kaarela | Kårböle | ||||
1262 | 301 | ocd-division/country:fi/kunta:helsinki/suojelulohko:kallio | 2020-12-07T13:38:34.798001+02:00 | rescue_district | 32 | helsinki | Kallio | Berghäll | ||||
1263 | 302 | ocd-division/country:fi/kunta:helsinki/suojelulohko:alppiharju | 2020-12-07T13:38:34.802199+02:00 | rescue_district | 32 | helsinki | Alppiharju | Åshöjden | ||||
1264 | 303 | ocd-division/country:fi/kunta:helsinki/suojelulohko:vallila | 2020-12-07T13:38:34.805743+02:00 | rescue_district | 32 | helsinki | Vallila | Vallgård | ||||
1265 | 304 | ocd-division/country:fi/kunta:helsinki/suojelulohko:pasila | 2020-12-07T13:38:34.809720+02:00 | rescue_district | 32 | helsinki | Pasila | Böle | ||||
1266 | 305 | ocd-division/country:fi/kunta:helsinki/suojelulohko:vanhakaupunki | 2020-12-07T13:38:34.813967+02:00 | rescue_district | 32 | helsinki | Vanhakaupunki | Gammelstaden | ||||
1267 | 401 | ocd-division/country:fi/kunta:helsinki/suojelulohko:maunula | 2020-12-07T13:38:34.818034+02:00 | rescue_district | 32 | helsinki | Maunula | Månsas | ||||
1268 | 402 | ocd-division/country:fi/kunta:helsinki/suojelulohko:länsi-pakila | 2020-12-07T13:38:34.823521+02:00 | rescue_district | 32 | helsinki | Länsi-Pakila | Västra Baggböle | ||||
1269 | 403 | ocd-division/country:fi/kunta:helsinki/suojelulohko:tuomarinkylä | 2020-12-07T13:38:34.829782+02:00 | rescue_district | 32 | helsinki | Tuomarinkylä | Domarby | ||||
1270 | 404 | ocd-division/country:fi/kunta:helsinki/suojelulohko:oulunkylä | 2020-12-07T13:38:34.836462+02:00 | rescue_district | 32 | helsinki | Oulunkylä | Åggelby | ||||
1271 | 405 | ocd-division/country:fi/kunta:helsinki/suojelulohko:itä-pakila | 2020-12-07T13:38:34.841687+02:00 | rescue_district | 32 | helsinki | Itä-Pakila | Östra Baggböle | ||||
1272 | 501 | ocd-division/country:fi/kunta:helsinki/suojelulohko:latokartano | 2020-12-07T13:38:34.846385+02:00 | rescue_district | 32 | helsinki | Latokartano | Ladugården | ||||
1273 | 502 | ocd-division/country:fi/kunta:helsinki/suojelulohko:pukinmäki | 2020-12-07T13:38:34.851035+02:00 | rescue_district | 32 | helsinki | Pukinmäki | Bocksbacka | ||||
1274 | 503 | ocd-division/country:fi/kunta:helsinki/suojelulohko:malmi | 2020-12-07T13:38:34.855801+02:00 | rescue_district | 32 | helsinki | Malmi | Malm | ||||
1275 | 504 | ocd-division/country:fi/kunta:helsinki/suojelulohko:suutarila | 2020-12-07T13:38:34.861110+02:00 | rescue_district | 32 | helsinki | Suutarila | Skomakarböle | ||||
1276 | 505 | ocd-division/country:fi/kunta:helsinki/suojelulohko:puistola | 2020-12-07T13:38:34.867163+02:00 | rescue_district | 32 | helsinki | Puistola | Parkstad | ||||
1277 | 506 | ocd-division/country:fi/kunta:helsinki/suojelulohko:jakomäki | 2020-12-07T13:38:34.873011+02:00 | rescue_district | 32 | helsinki | Jakomäki | Jakobacka | ||||
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ö | ||||
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 | ||||
1280 | 603 | ocd-division/country:fi/kunta:helsinki/suojelulohko:laajasalo | 2020-12-07T13:38:34.885418+02:00 | rescue_district | 32 | helsinki | Laajasalo | Degerö | ||||
1281 | 701 | ocd-division/country:fi/kunta:helsinki/suojelulohko:vartiokylä | 2020-12-07T13:38:34.889354+02:00 | rescue_district | 32 | helsinki | Vartiokylä | Botby | ||||
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 | ||||
1283 | 703 | ocd-division/country:fi/kunta:helsinki/suojelulohko:mellunkylä | 2020-12-07T13:38:34.899546+02:00 | rescue_district | 32 | helsinki | Mellunkylä | Mellungsby | ||||
1284 | 704 | ocd-division/country:fi/kunta:helsinki/suojelulohko:vuosaari | 2020-12-07T13:38:34.904422+02:00 | rescue_district | 32 | helsinki | Vuosaari | Nordsjö | ||||
1285 | 801 | ocd-division/country:fi/kunta:helsinki/suojelulohko:östersundom | 2020-12-07T13:38:34.909488+02:00 | rescue_district | 32 | helsinki | Östersundom | Östersundom |
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 );