administrative_division
16 rows where start = "2021-08-01" and type = "upper_comprehensive_school_district_sv"
This data as json, CSV (advanced)
Suggested facets: parent, municipality, name_sv, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3973 | 131583489_1 | ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_ylakoulu_seuraava:131583489_1 | 2021-08-01 | 2022-08-01 | 2020-09-16T22:31:00.955393+03:00 | upper_comprehensive_school_district_sv | 11 | espoo | Boställ | |||
| 3974 | 131583643_1 | ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_ylakoulu_seuraava:131583643_1 | 2021-08-01 | 2022-08-01 | 2020-09-16T22:31:00.960139+03:00 | upper_comprehensive_school_district_sv | 11 | espoo | Mattliden | |||
| 3975 | 131583486_1 | ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_ylakoulu_seuraava:131583486_1 | 2021-08-01 | 2022-08-01 | 2020-09-16T22:31:00.963731+03:00 | upper_comprehensive_school_district_sv | 11 | espoo | Bemböle | |||
| 3976 | 131583488_1 | ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_ylakoulu_seuraava:131583488_1 | 2021-08-01 | 2022-08-01 | 2020-09-16T22:31:00.967583+03:00 | upper_comprehensive_school_district_sv | 11 | espoo | Karamalmen | |||
| 3977 | 131583490_1 | ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_ylakoulu_seuraava:131583490_1 | 2021-08-01 | 2022-08-01 | 2020-09-16T22:31:00.971911+03:00 | upper_comprehensive_school_district_sv | 11 | espoo | Kungsgård | |||
| 3978 | 131583487_1 | ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_ylakoulu_seuraava:131583487_1 | 2021-08-01 | 2022-08-01 | 2020-09-16T22:31:00.976466+03:00 | upper_comprehensive_school_district_sv | 11 | espoo | Smedsby | |||
| 3979 | 131580845_1 | ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_ylakoulu_seuraava:131580845_1 | 2021-08-01 | 2022-08-01 | 2020-09-16T22:31:00.980504+03:00 | upper_comprehensive_school_district_sv | 11 | espoo | Lagstad | |||
| 3980 | 131583644_1 | ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_ylakoulu_seuraava:131583644_1 | 2021-08-01 | 2022-08-01 | 2020-09-16T22:31:00.984617+03:00 | upper_comprehensive_school_district_sv | 11 | espoo | Vindängen | |||
| 3981 | 131584175_1 | ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_ylakoulu_seuraava:131584175_1 | 2021-08-01 | 2022-08-01 | 2020-09-16T22:31:00.988404+03:00 | upper_comprehensive_school_district_sv | 11 | espoo | Bemböle | |||
| 3982 | 131583642_1 | ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_ylakoulu_seuraava:131583642_1 | 2021-08-01 | 2022-08-01 | 2020-09-16T22:31:00.992152+03:00 | upper_comprehensive_school_district_sv | 11 | espoo | Finno | |||
| 3983 | 131583641_1 | ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_ylakoulu_seuraava:131583641_1 | 2021-08-01 | 2022-08-01 | 2020-09-16T22:31:00.995744+03:00 | upper_comprehensive_school_district_sv | 11 | espoo | Storängen | |||
| 3984 | 131580844_1 | ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_ylakoulu_seuraava:131580844_1 | 2021-08-01 | 2022-08-01 | 2020-09-16T22:31:00.999602+03:00 | upper_comprehensive_school_district_sv | 11 | espoo | Rödskog | |||
| 4695 | 115219 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu_sv:115219 | 46978 | 2021-08-01 | 2022-08-01 | 2020-12-07T13:38:48.544737+02:00 | upper_comprehensive_school_district_sv | 32 | helsinki | Grundskolan Norsen, 5-9 2021-2022 | ||
| 4696 | 115234 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu_sv:115234 | 17040 | 2021-08-01 | 2022-08-01 | 2020-12-07T13:38:48.549980+02:00 | upper_comprehensive_school_district_sv | 32 | helsinki | Botby grundskola 2021-2022 | ||
| 4697 | 115239 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu_sv:115239 | 6993 | 2021-08-01 | 2022-08-01 | 2020-12-07T13:38:48.554946+02:00 | upper_comprehensive_school_district_sv | 32 | helsinki | Åshöjdens grundskola 2021-2022 | ||
| 4698 | 115261 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu_sv:115261 | 46979 | 2021-08-01 | 2022-08-01 | 2020-12-07T13:38:48.560627+02:00 | upper_comprehensive_school_district_sv | 32 | helsinki | Hoplaxskolan, Munksnäs-enheten 6-9 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 );