190 rows where "start" is on date 2021-08-01 sorted by name_sv descending

View and edit SQL

Suggested facets: type, parent, municipality, end (date), modified_at (date)

start (date)

  • 2021-08-01 · 190
id origin_id ocd_id service_point_id start end modified_at type parent municipality name_fi name_sv ▲ name
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
3947 431976549_1 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu_seuraava:431976549_1   2021-08-01 2022-08-01 2020-09-16T22:30:49.815630+03:00 lower_comprehensive_school_district_fi 11 espoo Tapiolan oppilasalue    
3948 431976647_1 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu_seuraava:431976647_1   2021-08-01 2022-08-01 2020-09-16T22:30:49.821704+03:00 lower_comprehensive_school_district_fi 11 espoo Itäisen Leppävaaran oppilasalue    
3949 431976899_1 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu_seuraava:431976899_1   2021-08-01 2022-08-01 2020-09-16T22:30:49.826244+03:00 lower_comprehensive_school_district_fi 11 espoo Espoonlahden oppilasalue    
3950 431976731_1 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu_seuraava:431976731_1   2021-08-01 2022-08-01 2020-09-16T22:30:49.829846+03:00 lower_comprehensive_school_district_fi 11 espoo Läntisen Leppävaaran oppilasalue    
3951 431976820_1 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu_seuraava:431976820_1   2021-08-01 2022-08-01 2020-09-16T22:30:49.833417+03:00 lower_comprehensive_school_district_fi 11 espoo Matinkylän-Olarin oppilasalue    
3952 431977071_1 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu_seuraava:431977071_1   2021-08-01 2022-08-01 2020-09-16T22:30:49.836950+03:00 lower_comprehensive_school_district_fi 11 espoo Pohjois-Espoon oppilasalue    
3953 431977176_1 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu_seuraava:431977176_1   2021-08-01 2022-08-01 2020-09-16T22:30:49.841270+03:00 lower_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    
4407 115120 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115120 6926 2021-08-01 2022-08-01 2020-12-07T13:38:37.413456+02:00 lower_comprehensive_school_district_fi 32 helsinki Hiidenkiven peruskoulu 2021-2022    
4408 115122 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115122 6899 2021-08-01 2022-08-01 2020-12-07T13:38:37.421330+02:00 lower_comprehensive_school_district_fi 32 helsinki Vattuniemen ala-asteen koulu 2021-2022    
4409 115123 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115123 6791 2021-08-01 2022-08-01 2020-12-07T13:38:37.428101+02:00 lower_comprehensive_school_district_fi 32 helsinki Keinutien ala-asteen koulu 2021-2022    
4410 115124 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115124 46536 2021-08-01 2022-08-01 2020-12-07T13:38:37.434028+02:00 lower_comprehensive_school_district_fi 32 helsinki Myllypuron peruskoulu 2021-2022    
4411 115125 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115125 6800 2021-08-01 2022-08-01 2020-12-07T13:38:37.439626+02:00 lower_comprehensive_school_district_fi 32 helsinki Kontulan ala-asteen koulu 2021-2022    
4412 115128 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115128 7163 2021-08-01 2022-08-01 2020-12-07T13:38:37.445269+02:00 lower_comprehensive_school_district_fi 32 helsinki Aurinkolahden peruskoulu 2021-2022    
4413 115130 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115130 51483 2021-08-01 2022-08-01 2020-12-07T13:38:37.451363+02:00 lower_comprehensive_school_district_fi 32 helsinki Vuoniityn peruskoulu 2021-2022    
4414 115133 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115133 6734 2021-08-01 2022-08-01 2020-12-07T13:38:37.458053+02:00 lower_comprehensive_school_district_fi 32 helsinki Meilahden ala-asteen koulu 2021-2022    
4415 115134 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115134 6757 2021-08-01 2022-08-01 2020-12-07T13:38:37.463881+02:00 lower_comprehensive_school_district_fi 32 helsinki Pihlajiston ala-asteen koulu 2021-2022    
4416 115135 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115135 7060 2021-08-01 2022-08-01 2020-12-07T13:38:37.470261+02:00 lower_comprehensive_school_district_fi 32 helsinki Pihlajamäen ala-asteen koulu 2021-2022    
4417 115136 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115136 51486 2021-08-01 2022-08-01 2020-12-07T13:38:37.476146+02:00 lower_comprehensive_school_district_fi 32 helsinki Puistopolun peruskoulu 2021-2022    
4418 115137 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115137 24820 2021-08-01 2022-08-01 2020-12-07T13:38:37.481442+02:00 lower_comprehensive_school_district_fi 32 helsinki Santahaminan ala-asteen koulu 2021-2022    
4419 115144 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115144 6927 2021-08-01 2022-08-01 2020-12-07T13:38:37.486787+02:00 lower_comprehensive_school_district_fi 32 helsinki Käpylän peruskoulu 2021-2022    
4420 115145 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115145 6866 2021-08-01 2022-08-01 2020-12-07T13:38:37.492031+02:00 lower_comprehensive_school_district_fi 32 helsinki Koskelan ala-asteen koulu 2021-2022    
4421 115149 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115149 30395 2021-08-01 2022-08-01 2020-12-07T13:38:37.497263+02:00 lower_comprehensive_school_district_fi 32 helsinki Puistolanraitin ala-asteen koulu 2021-2022    
4422 115150 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115150 7186 2021-08-01 2022-08-01 2020-12-07T13:38:37.502415+02:00 lower_comprehensive_school_district_fi 32 helsinki Tapanilan ala-asteen koulu 2021-2022    
4423 115151 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115151 6796 2021-08-01 2022-08-01 2020-12-07T13:38:37.507952+02:00 lower_comprehensive_school_district_fi 32 helsinki Kallion ala-asteen koulu 2021-2022    
4424 115152 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115152 6685 2021-08-01 2022-08-01 2020-12-07T13:38:37.513634+02:00 lower_comprehensive_school_district_fi 32 helsinki Tehtaankadun ala-asteen koulu 2021-2022    
4425 115153 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115153 7011 2021-08-01 2022-08-01 2020-12-07T13:38:37.519012+02:00 lower_comprehensive_school_district_fi 32 helsinki Strömbergin ala-asteen koulu 2021-2022    
4426 115155 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115155 7076 2021-08-01 2022-08-01 2020-12-07T13:38:37.524392+02:00 lower_comprehensive_school_district_fi 32 helsinki Roihuvuoren ala-asteen koulu 2021-2022    
4427 115158 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115158 6675 2021-08-01 2022-08-01 2020-12-07T13:38:37.529820+02:00 lower_comprehensive_school_district_fi 32 helsinki Katajanokan ala-asteen koulu 2021-2022    
4428 115159 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115159 6970 2021-08-01 2022-08-01 2020-12-07T13:38:37.534858+02:00 lower_comprehensive_school_district_fi 32 helsinki Snellmanin ala-asteen koulu 2021-2022    
4429 115160 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115160 6926 2021-08-01 2022-08-01 2020-12-07T13:38:37.540716+02:00 lower_comprehensive_school_district_fi 32 helsinki Hiidenkiven peruskoulu 2021-2022    
4430 115161 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115161 24877 2021-08-01 2022-08-01 2020-12-07T13:38:37.545013+02:00 lower_comprehensive_school_district_fi 32 helsinki Itäkeskuksen peruskoulu 2021-2022    
4431 115165 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115165 6667 2021-08-01 2022-08-01 2020-12-07T13:38:37.548957+02:00 lower_comprehensive_school_district_fi 32 helsinki Ressun peruskoulu 2021-2022    
4432 115166 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115166 46514 2021-08-01 2022-08-01 2020-12-07T13:38:37.552598+02:00 lower_comprehensive_school_district_fi 32 helsinki Lauttasaaren ala-asteen koulu 2021-2022    
4433 115168 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115168 6709 2021-08-01 2022-08-01 2020-12-07T13:38:37.556677+02:00 lower_comprehensive_school_district_fi 32 helsinki Maunulan ala-asteen koulu 2021-2022    
4434 115174 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115174 6768 2021-08-01 2022-08-01 2020-12-07T13:38:37.561596+02:00 lower_comprehensive_school_district_fi 32 helsinki Kulosaaren ala-asteen koulu 2021-2022    
4435 115175 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115175 51476 2021-08-01 2022-08-01 2020-12-07T13:38:37.566672+02:00 lower_comprehensive_school_district_fi 32 helsinki Vesalan peruskoulu 2021-2022    
4436 115176 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115176 7177 2021-08-01 2022-08-01 2020-12-07T13:38:37.571664+02:00 lower_comprehensive_school_district_fi 32 helsinki Ruoholahden ala-asteen koulu 2021-2022    
4437 115178 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115178 6936 2021-08-01 2022-08-01 2020-12-07T13:38:37.576448+02:00 lower_comprehensive_school_district_fi 32 helsinki Puotilan ala-asteen koulu 2021-2022    
4438 115179 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115179 50230 2021-08-01 2022-08-01 2020-12-07T13:38:37.581573+02:00 lower_comprehensive_school_district_fi 32 helsinki Pohjois-Haagan ala-asteen koulu 2021-2022    
4439 115180 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115180 43448 2021-08-01 2022-08-01 2020-12-07T13:38:37.587017+02:00 lower_comprehensive_school_district_fi 32 helsinki Hertsikan ala-asteen koulu 2021-2022    
4440 115185 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115185 6674 2021-08-01 2022-08-01 2020-12-07T13:38:37.591748+02:00 lower_comprehensive_school_district_fi 32 helsinki Oulunkylän ala-asteen koulu 2021-2022    
4441 115186 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115186 24862 2021-08-01 2022-08-01 2020-12-07T13:38:37.596045+02:00 lower_comprehensive_school_district_fi 32 helsinki Arabian peruskoulu 2021-2022    
4442 115187 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115187 7052 2021-08-01 2022-08-01 2020-12-07T13:38:37.599830+02:00 lower_comprehensive_school_district_fi 32 helsinki Konalan ala-asteen koulu 2021-2022    
4443 115191 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115191 7031 2021-08-01 2022-08-01 2020-12-07T13:38:37.603537+02:00 lower_comprehensive_school_district_fi 32 helsinki Munkkivuoren ala-asteen koulu 2021-2022    
4444 115192 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115192 6795 2021-08-01 2022-08-01 2020-12-07T13:38:37.607401+02:00 lower_comprehensive_school_district_fi 32 helsinki Metsolan ala-asteen koulu 2021-2022    
4445 115193 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115193 6726 2021-08-01 2022-08-01 2020-12-07T13:38:37.610832+02:00 lower_comprehensive_school_district_fi 32 helsinki Herttoniemenrannan ala-asteen koulu 2021-2022    
4446 115194 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115194 6923 2021-08-01 2022-08-01 2020-12-07T13:38:37.614377+02:00 lower_comprehensive_school_district_fi 32 helsinki Vartiokylän ala-asteen koulu 2021-2022    

Next page

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