administrative_division
14 rows where "modified_at" is on date 2020-09-16 and type = "upper_comprehensive_school_district_fi"
This data as json, CSV (advanced)
Suggested facets: start, end, name_fi, start (date), end (date)
| id ▼ | origin_id | ocd_id | service_point_id | start | end | modified_at | type | parent | municipality | name_fi | name_sv | name |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3914 | 431976549 | ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_ylakoulu:431976549 | 2020-08-01 | 2021-08-01 | 2020-09-16T22:30:55.427517+03:00 | upper_comprehensive_school_district_fi | 11 | espoo | Tapiolan oppilasalue | |||
| 3915 | 431976647 | ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_ylakoulu:431976647 | 2020-08-01 | 2021-08-01 | 2020-09-16T22:30:55.431811+03:00 | upper_comprehensive_school_district_fi | 11 | espoo | Itäisen Leppävaaran 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 | |||
| 3917 | 431976731 | ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_ylakoulu:431976731 | 2020-08-01 | 2021-08-01 | 2020-09-16T22:30:55.439026+03:00 | upper_comprehensive_school_district_fi | 11 | espoo | Läntisen Leppävaaran oppilasalue | |||
| 3918 | 431976820 | ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_ylakoulu:431976820 | 2020-08-01 | 2021-08-01 | 2020-09-16T22:30:55.442167+03:00 | upper_comprehensive_school_district_fi | 11 | espoo | Matinkylän-Olarin oppilasalue | |||
| 3919 | 431977071 | ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_ylakoulu:431977071 | 2020-08-01 | 2021-08-01 | 2020-09-16T22:30:55.445442+03:00 | upper_comprehensive_school_district_fi | 11 | espoo | Pohjois-Espoon oppilasalue | |||
| 3920 | 431977176 | ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_ylakoulu:431977176 | 2020-08-01 | 2021-08-01 | 2020-09-16T22:30:55.448647+03:00 | upper_comprehensive_school_district_fi | 11 | espoo | Keski-Espoon oppilasalue | |||
| 3966 | 431976549_1 | ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_ylakoulu_seuraava:431976549_1 | 2021-08-01 | 2022-08-01 | 2020-09-16T22:30:57.244394+03:00 | upper_comprehensive_school_district_fi | 11 | espoo | Tapiolan oppilasalue | |||
| 3967 | 431976647_1 | ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_ylakoulu_seuraava:431976647_1 | 2021-08-01 | 2022-08-01 | 2020-09-16T22:30:57.248999+03:00 | upper_comprehensive_school_district_fi | 11 | espoo | Itäisen Leppävaaran 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 | |||
| 3969 | 431976731_1 | ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_ylakoulu_seuraava:431976731_1 | 2021-08-01 | 2022-08-01 | 2020-09-16T22:30:57.256205+03:00 | upper_comprehensive_school_district_fi | 11 | espoo | Läntisen Leppävaaran oppilasalue | |||
| 3970 | 431976820_1 | ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_ylakoulu_seuraava:431976820_1 | 2021-08-01 | 2022-08-01 | 2020-09-16T22:30:57.259661+03:00 | upper_comprehensive_school_district_fi | 11 | espoo | Matinkylän-Olarin oppilasalue | |||
| 3971 | 431977071_1 | ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_ylakoulu_seuraava:431977071_1 | 2021-08-01 | 2022-08-01 | 2020-09-16T22:30:57.263100+03:00 | upper_comprehensive_school_district_fi | 11 | espoo | Pohjois-Espoon oppilasalue | |||
| 3972 | 431977176_1 | ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_ylakoulu_seuraava:431977176_1 | 2021-08-01 | 2022-08-01 | 2020-09-16T22:30:57.266732+03:00 | upper_comprehensive_school_district_fi | 11 | espoo | Keski-Espoon 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 );