administrative_division
1 row where "modified_at" is on date 2020-11-18 and type = "upper_comprehensive_school_district_fi"
This data as json, CSV (advanced)
Suggested facets: start (date), end (date)
| id ▼ | origin_id | ocd_id | service_point_id | start | end | modified_at | type | parent | municipality | name_fi | name_sv | name |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4646 | 115259 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:115259 | 6926 | 2021-08-01 | 2022-08-01 | 2020-11-18T05:51:24.548293+02:00 | upper_comprehensive_school_district_fi | 32 | helsinki | Hiidenkiven peruskoulu 2021-2022 |
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 );