60 rows where type = "lower_comprehensive_school_district_sv"

View and edit SQL

Suggested facets: service_point_id, start, end, parent, municipality, start (date), end (date), modified_at (date)

type

  • lower_comprehensive_school_district_sv · 60
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  
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  
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

CSV options:

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
);