administrative_division
30 rows where end = "2021-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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3902 | 131583489 | ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu:131583489 | 2020-08-01 | 2021-08-01 | 2020-09-16T22:30:51.661607+03:00 | lower_comprehensive_school_district_sv | 11 | espoo | Boställ | |||
| 3903 | 131583643 | ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu:131583643 | 2020-08-01 | 2021-08-01 | 2020-09-16T22:30:51.666667+03:00 | lower_comprehensive_school_district_sv | 11 | espoo | Mattliden | |||
| 3904 | 131583486 | ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu:131583486 | 2020-08-01 | 2021-08-01 | 2020-09-16T22:30:51.671365+03:00 | lower_comprehensive_school_district_sv | 11 | espoo | Bemböle | |||
| 3905 | 131583488 | ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu:131583488 | 2020-08-01 | 2021-08-01 | 2020-09-16T22:30:51.676538+03:00 | lower_comprehensive_school_district_sv | 11 | espoo | Karamalmen | |||
| 3906 | 131583490 | ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu:131583490 | 2020-08-01 | 2021-08-01 | 2020-09-16T22:30:51.682246+03:00 | lower_comprehensive_school_district_sv | 11 | espoo | Kungsgård | |||
| 3907 | 131583487 | ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu:131583487 | 2020-08-01 | 2021-08-01 | 2020-09-16T22:30:51.687145+03:00 | lower_comprehensive_school_district_sv | 11 | espoo | Smedsby | |||
| 3908 | 131580845 | ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu:131580845 | 2020-08-01 | 2021-08-01 | 2020-09-16T22:30:51.691351+03:00 | lower_comprehensive_school_district_sv | 11 | espoo | Lagstad | |||
| 3909 | 131583644 | ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu:131583644 | 2020-08-01 | 2021-08-01 | 2020-09-16T22:30:51.695636+03:00 | lower_comprehensive_school_district_sv | 11 | espoo | Vindängen | |||
| 3910 | 131584175 | ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu:131584175 | 2020-08-01 | 2021-08-01 | 2020-09-16T22:30:51.699634+03:00 | lower_comprehensive_school_district_sv | 11 | espoo | Bemböle | |||
| 3911 | 131583642 | ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu:131583642 | 2020-08-01 | 2021-08-01 | 2020-09-16T22:30:51.703560+03:00 | lower_comprehensive_school_district_sv | 11 | espoo | Finno | |||
| 3912 | 131583641 | ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu:131583641 | 2020-08-01 | 2021-08-01 | 2020-09-16T22:30:51.712473+03:00 | lower_comprehensive_school_district_sv | 11 | espoo | Storängen | |||
| 3913 | 131580844 | ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu:131580844 | 2020-08-01 | 2021-08-01 | 2020-09-16T22:30:51.716533+03:00 | lower_comprehensive_school_district_sv | 11 | espoo | Rödskog | |||
| 4585 | 114715 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu_sv:114715 | 7188 | 2020-08-01 | 2021-08-01 | 2020-12-07T13:38:41.472620+02:00 | lower_comprehensive_school_district_sv | 32 | helsinki | Kottby lågstadieskola 2020-2021 | ||
| 4586 | 114716 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu_sv:114716 | 7024 | 2020-08-01 | 2021-08-01 | 2020-12-07T13:38:41.479332+02:00 | lower_comprehensive_school_district_sv | 32 | helsinki | Månsas lågstadieskola 2020-2021 | ||
| 4587 | 114728 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu_sv:114728 | 52349 | 2020-08-01 | 2021-08-01 | 2020-12-07T13:38:41.484843+02:00 | lower_comprehensive_school_district_sv | 32 | helsinki | Grundskolan Norsen, Grundskolan Norsen, Cygnaeus-enheten 1-4 2020-2021 | ||
| 4588 | 114740 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu_sv:114740 | 7150 | 2020-08-01 | 2021-08-01 | 2020-12-07T13:38:41.489354+02:00 | lower_comprehensive_school_district_sv | 32 | helsinki | Zacharias Topeliusskolan 2020-2021 | ||
| 4589 | 114741 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu_sv:114741 | 34371 | 2020-08-01 | 2021-08-01 | 2020-12-07T13:38:41.493906+02:00 | lower_comprehensive_school_district_sv | 32 | helsinki | Västra distrikt, Hoplaxskolan, Kårböle-enheten 1-5 2020-2021 | ||
| 4590 | 114753 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu_sv:114753 | 7128 | 2020-08-01 | 2021-08-01 | 2020-12-07T13:38:41.498647+02:00 | lower_comprehensive_school_district_sv | 32 | helsinki | Minervaskolan 2020-2021 | ||
| 4591 | 114754 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu_sv:114754 | 6993 | 2020-08-01 | 2021-08-01 | 2020-12-07T13:38:41.502048+02:00 | lower_comprehensive_school_district_sv | 32 | helsinki | Åshöjdens grundskola 2020-2021 | ||
| 4592 | 114755 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu_sv:114755 | 43924 | 2020-08-01 | 2021-08-01 | 2020-12-07T13:38:41.505506+02:00 | lower_comprehensive_school_district_sv | 32 | helsinki | Västra distrikt, Hoplaxskolan, Munksnäs-enheten 0-5 2020-2021 | ||
| 4593 | 114774 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu_sv:114774 | 6718 | 2020-08-01 | 2021-08-01 | 2020-12-07T13:38:41.509249+02:00 | lower_comprehensive_school_district_sv | 32 | helsinki | Drumsö lågstadieskola 2020-2021 | ||
| 4594 | 114776 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu_sv:114776 | 9289 | 2020-08-01 | 2021-08-01 | 2020-12-07T13:38:41.512612+02:00 | lower_comprehensive_school_district_sv | 32 | helsinki | Östersundom skola 2020-2021 | ||
| 4595 | 114785 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu_sv:114785 | 7042 | 2020-08-01 | 2021-08-01 | 2020-12-07T13:38:41.516284+02:00 | lower_comprehensive_school_district_sv | 32 | helsinki | Nordsjö lågstadieskola 2020-2021 | ||
| 4596 | 114786 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu_sv:114786 | 7085 | 2020-08-01 | 2021-08-01 | 2020-12-07T13:38:41.522493+02:00 | lower_comprehensive_school_district_sv | 32 | helsinki | Staffansby lågstadieskola 2020-2021 | ||
| 4597 | 114787 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu_sv:114787 | 34376 | 2020-08-01 | 2021-08-01 | 2020-12-07T13:38:41.527322+02:00 | lower_comprehensive_school_district_sv | 32 | helsinki | Västra distrikt, Hoplaxskolan, Sockenbacka-enheten 1-2 2020-2021 | ||
| 4598 | 114792 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu_sv:114792 | 17040 | 2020-08-01 | 2021-08-01 | 2020-12-07T13:38:41.531447+02:00 | lower_comprehensive_school_district_sv | 32 | helsinki | Botby grundskola 2020-2021 | ||
| 4599 | 114793 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu_sv:114793 | 7053 | 2020-08-01 | 2021-08-01 | 2020-12-07T13:38:41.535709+02:00 | lower_comprehensive_school_district_sv | 32 | helsinki | Brändö lågstadieskola 2020-2021 | ||
| 4600 | 114795 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu_sv:114795 | 6828 | 2020-08-01 | 2021-08-01 | 2020-12-07T13:38:41.539276+02:00 | lower_comprehensive_school_district_sv | 32 | helsinki | Degerö lågstadieskola 2020-2021 | ||
| 4601 | 114796 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu_sv:114796 | 34368 | 2020-08-01 | 2021-08-01 | 2020-12-07T13:38:41.543137+02:00 | lower_comprehensive_school_district_sv | 32 | helsinki | Västra distrikt, Hoplaxskolan, Haga-enheten 1-5 2020-2021 | ||
| 4602 | 114824 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu_sv:114824 | 52361 | 2020-08-01 | 2021-08-01 | 2020-12-07T13:38:41.547366+02:00 | lower_comprehensive_school_district_sv | 32 | helsinki | Grundskolan Norsen, Grundskolan Norsen, Kronohagen-enheten 1-4 2020-2021 |
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 );