34 rows where type = "rescue_district"

View and edit SQL

Suggested facets: modified_at (date)

type

  • rescue_district · 34
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

CSV options:

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
);