2 rows where type = "emergency_care_district"

View and edit SQL

Suggested facets: modified_at (date)

type

  • emergency_care_district · 2
id ▼ origin_id ocd_id service_point_id start end modified_at type parent municipality name_fi name_sv name
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    
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    

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