administrative_division

1 row where "modified_at" is on date 2020-11-18 and type = "preschool_education_sv"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: start (date), end (date)

type ✖

  • preschool_education_sv · 1 ✖

modified_at (date) ✖

  • 2020-11-18 · 1 ✖
id ▼ origin_id ocd_id service_point_id start end modified_at type parent municipality name_fi name_sv name
3884   ocd-division/country:fi/kunta:helsinki/esiopetuksen_oppilaaksiottoalue_sv:   2020-07-01 2021-08-01 2020-11-18T05:51:36.406681+02:00 preschool_education_sv 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
);