4 rows where "modified_at" is on date 2020-09-16 and name_fi = "Espoonlahden oppilasalue"

View and edit SQL

Suggested facets: origin_id, start, end, type, start (date), end (date), modified_at (date)

id ▼ origin_id ocd_id service_point_id start end modified_at type parent municipality name_fi name_sv name
3897 431976899 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu:431976899   2020-08-01 2021-08-01 2020-09-16T22:30:47.999099+03:00 lower_comprehensive_school_district_fi 11 espoo Espoonlahden oppilasalue    
3916 431976899 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_ylakoulu:431976899   2020-08-01 2021-08-01 2020-09-16T22:30:55.435631+03:00 upper_comprehensive_school_district_fi 11 espoo Espoonlahden oppilasalue    
3949 431976899_1 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu_seuraava:431976899_1   2021-08-01 2022-08-01 2020-09-16T22:30:49.826244+03:00 lower_comprehensive_school_district_fi 11 espoo Espoonlahden oppilasalue    
3968 431976899_1 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_ylakoulu_seuraava:431976899_1   2021-08-01 2022-08-01 2020-09-16T22:30:57.252610+03:00 upper_comprehensive_school_district_fi 11 espoo Espoonlahden oppilasalue    

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