administrative_division
4 rows where "modified_at" is on date 2020-09-16 and name_fi = "Espoonlahden oppilasalue"
This data as json, CSV (advanced)
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
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 );