administrative_division
30 rows where end = "2022-08-01" and type = "lower_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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3954 | 131583489_1 | ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu_seuraava:131583489_1 | 2021-08-01 | 2022-08-01 | 2020-09-16T22:30:53.610784+03:00 | lower_comprehensive_school_district_sv | 11 | espoo | Boställ | |||
| 3955 | 131583643_1 | ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu_seuraava:131583643_1 | 2021-08-01 | 2022-08-01 | 2020-09-16T22:30:53.615513+03:00 | lower_comprehensive_school_district_sv | 11 | espoo | Mattliden | |||
| 3956 | 131583486_1 | ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu_seuraava:131583486_1 | 2021-08-01 | 2022-08-01 | 2020-09-16T22:30:53.619093+03:00 | lower_comprehensive_school_district_sv | 11 | espoo | Bemböle | |||
| 3957 | 131583488_1 | ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu_seuraava:131583488_1 | 2021-08-01 | 2022-08-01 | 2020-09-16T22:30:53.622508+03:00 | lower_comprehensive_school_district_sv | 11 | espoo | Karamalmen | |||
| 3958 | 131583490_1 | ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu_seuraava:131583490_1 | 2021-08-01 | 2022-08-01 | 2020-09-16T22:30:53.626358+03:00 | lower_comprehensive_school_district_sv | 11 | espoo | Kungsgård | |||
| 3959 | 131583487_1 | ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu_seuraava:131583487_1 | 2021-08-01 | 2022-08-01 | 2020-09-16T22:30:53.629630+03:00 | lower_comprehensive_school_district_sv | 11 | espoo | Smedsby | |||
| 3960 | 131580845_1 | ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu_seuraava:131580845_1 | 2021-08-01 | 2022-08-01 | 2020-09-16T22:30:53.633250+03:00 | lower_comprehensive_school_district_sv | 11 | espoo | Lagstad | |||
| 3961 | 131583644_1 | ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu_seuraava:131583644_1 | 2021-08-01 | 2022-08-01 | 2020-09-16T22:30:53.637062+03:00 | lower_comprehensive_school_district_sv | 11 | espoo | Vindängen | |||
| 3962 | 131584175_1 | ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu_seuraava:131584175_1 | 2021-08-01 | 2022-08-01 | 2020-09-16T22:30:53.640450+03:00 | lower_comprehensive_school_district_sv | 11 | espoo | Bemböle | |||
| 3963 | 131583642_1 | ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu_seuraava:131583642_1 | 2021-08-01 | 2022-08-01 | 2020-09-16T22:30:53.643741+03:00 | lower_comprehensive_school_district_sv | 11 | espoo | Finno | |||
| 3964 | 131583641_1 | ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu_seuraava:131583641_1 | 2021-08-01 | 2022-08-01 | 2020-09-16T22:30:53.646809+03:00 | lower_comprehensive_school_district_sv | 11 | espoo | Storängen | |||
| 3965 | 131580844_1 | ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu_seuraava:131580844_1 | 2021-08-01 | 2022-08-01 | 2020-09-16T22:30:53.650003+03:00 | lower_comprehensive_school_district_sv | 11 | espoo | Rödskog | |||
| 4567 | 115126 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu_sv:115126 | 7188 | 2021-08-01 | 2022-08-01 | 2020-12-07T13:38:40.328111+02:00 | lower_comprehensive_school_district_sv | 32 | helsinki | Kottby lågstadieskola 2021-2022 | ||
| 4568 | 115127 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu_sv:115127 | 7024 | 2021-08-01 | 2022-08-01 | 2020-12-07T13:38:40.333257+02:00 | lower_comprehensive_school_district_sv | 32 | helsinki | Månsas lågstadieskola 2021-2022 | ||
| 4569 | 115177 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu_sv:115177 | 52349 | 2021-08-01 | 2022-08-01 | 2020-12-07T13:38:40.337355+02:00 | lower_comprehensive_school_district_sv | 32 | helsinki | Grundskolan Norsen 2021-2022 | ||
| 4570 | 115189 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu_sv:115189 | 7150 | 2021-08-01 | 2022-08-01 | 2020-12-07T13:38:40.341100+02:00 | lower_comprehensive_school_district_sv | 32 | helsinki | Zacharias Topeliusskolan 2021-2022 | ||
| 4571 | 115190 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu_sv:115190 | 34371 | 2021-08-01 | 2022-08-01 | 2020-11-18T05:51:22.198598+02:00 | lower_comprehensive_school_district_sv | 32 | helsinki | Västra distrikt, Hoplaxskolan, Kårböle-enheten 1-5 2021-2022 | ||
| 4572 | 115197 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu_sv:115197 | 17040 | 2021-08-01 | 2022-08-01 | 2020-12-07T13:38:40.344015+02:00 | lower_comprehensive_school_district_sv | 32 | helsinki | Botby grundskola 2021-2022 | ||
| 4573 | 115198 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu_sv:115198 | 7053 | 2021-08-01 | 2022-08-01 | 2020-12-07T13:38:40.351375+02:00 | lower_comprehensive_school_district_sv | 32 | helsinki | Brändö lågstadieskola 2021-2022 | ||
| 4574 | 115200 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu_sv:115200 | 6828 | 2021-08-01 | 2022-08-01 | 2020-12-07T13:38:40.354518+02:00 | lower_comprehensive_school_district_sv | 32 | helsinki | Degerö lågstadieskola 2021-2022 | ||
| 4575 | 115201 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu_sv:115201 | 34368 | 2021-08-01 | 2022-08-01 | 2020-12-07T13:38:40.357571+02:00 | lower_comprehensive_school_district_sv | 32 | helsinki | Hoplaxskolan 2021-2022 | ||
| 4576 | 115226 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu_sv:115226 | 7128 | 2021-08-01 | 2022-08-01 | 2020-12-07T13:38:40.361014+02:00 | lower_comprehensive_school_district_sv | 32 | helsinki | Minervaskolan 2021-2022 | ||
| 4577 | 115227 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu_sv:115227 | 6993 | 2021-08-01 | 2022-08-01 | 2020-12-07T13:38:40.363867+02:00 | lower_comprehensive_school_district_sv | 32 | helsinki | Åshöjdens grundskola 2021-2022 | ||
| 4578 | 115228 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu_sv:115228 | 43924 | 2021-08-01 | 2022-08-01 | 2020-11-18T05:51:22.227978+02:00 | lower_comprehensive_school_district_sv | 32 | helsinki | Västra distrikt, Hoplaxskolan, Munksnäs-enheten 0-5 2021-2022 | ||
| 4579 | 115241 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu_sv:115241 | 52361 | 2021-08-01 | 2022-08-01 | 2020-11-18T05:51:22.231120+02:00 | lower_comprehensive_school_district_sv | 32 | helsinki | Grundskolan Norsen, Grundskolan Norsen, Kronohagen-enheten 1-4 2021-2022 | ||
| 4580 | 115252 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu_sv:115252 | 6718 | 2021-08-01 | 2022-08-01 | 2020-12-07T13:38:40.366841+02:00 | lower_comprehensive_school_district_sv | 32 | helsinki | Drumsö lågstadieskola 2021-2022 | ||
| 4581 | 115254 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu_sv:115254 | 9289 | 2021-08-01 | 2022-08-01 | 2020-12-07T13:38:40.369534+02:00 | lower_comprehensive_school_district_sv | 32 | helsinki | Östersundom skola 2021-2022 | ||
| 4582 | 115263 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu_sv:115263 | 7042 | 2021-08-01 | 2022-08-01 | 2020-12-07T13:38:40.372672+02:00 | lower_comprehensive_school_district_sv | 32 | helsinki | Nordsjö lågstadieskola 2021-2022 | ||
| 4583 | 115264 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu_sv:115264 | 7085 | 2021-08-01 | 2022-08-01 | 2020-12-07T13:38:40.375604+02:00 | lower_comprehensive_school_district_sv | 32 | helsinki | Staffansby lågstadieskola 2021-2022 | ||
| 4584 | 115265 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu_sv:115265 | 34376 | 2021-08-01 | 2022-08-01 | 2020-11-18T05:51:22.246218+02:00 | lower_comprehensive_school_district_sv | 32 | helsinki | Västra distrikt, Hoplaxskolan, Sockenbacka-enheten 1-2 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 );