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

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
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    
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  
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    
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  
5641 115280 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:115280   2021-08-01 2022-08-01 2020-12-07T13:38:42.806089+02:00 upper_comprehensive_school_district_fi 32 helsinki Kruunuvuorenrannan peruskoulu 2021-2022    
5643 115284 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:115284   2021-08-01 2022-08-01 2020-12-07T13:38:42.815780+02:00 upper_comprehensive_school_district_fi 32 helsinki Maatullin peruskoulu 2021-2022    
4476 115235 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115235 16711 2021-08-01 2022-08-01 2020-12-07T13:38:37.757604+02:00 lower_comprehensive_school_district_fi 32 helsinki Laajasalon peruskoulu 2021-2022    
4648 115262 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:115262 16711 2021-08-01 2022-08-01 2020-12-07T13:38:42.801685+02:00 upper_comprehensive_school_district_fi 32 helsinki Laajasalon peruskoulu 2021-2022    
4466 115218 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115218 16759 2021-08-01 2022-08-01 2020-12-07T13:38:37.708606+02:00 lower_comprehensive_school_district_fi 32 helsinki Latokartanon peruskoulu 2021-2022    
4624 115170 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:115170 16759 2021-08-01 2022-08-01 2020-12-07T13:38:42.721575+02:00 upper_comprehensive_school_district_fi 32 helsinki Latokartanon peruskoulu 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  
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    
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    
4636 115243 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:115243 24862 2021-08-01 2022-08-01 2020-12-07T13:38:42.765624+02:00 upper_comprehensive_school_district_fi 32 helsinki Arabian 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    
4604 115129 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:115129 24877 2021-08-01 2022-08-01 2020-12-07T13:38:42.648584+02:00 upper_comprehensive_school_district_fi 32 helsinki Itäkeskuksen peruskoulu 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    
4447 115195 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115195 33979 2021-08-01 2022-08-01 2020-12-07T13:38:37.618318+02:00 lower_comprehensive_school_district_fi 32 helsinki Sakarinmäen peruskoulu 2021-2022    
4607 115138 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:115138 33979 2021-08-01 2022-08-01 2020-12-07T13:38:42.659796+02:00 upper_comprehensive_school_district_fi 32 helsinki Sakarinmäen peruskoulu 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  
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  
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  
4644 115257 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:115257 34961 2021-08-01 2022-08-01 2020-12-07T13:38:42.791898+02:00 upper_comprehensive_school_district_fi 32 helsinki Munkkiniemen yhteiskoulu 2021-2022    
4606 115132 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:115132 35019 2021-08-01 2022-08-01 2020-12-07T13:38:42.655915+02:00 upper_comprehensive_school_district_fi 32 helsinki Apollon Yhteiskoulu 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    
4473 115231 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115231 43612 2021-08-01 2022-08-01 2020-12-07T13:38:37.743816+02:00 lower_comprehensive_school_district_fi 32 helsinki Porolahden peruskoulu 2021-2022    
4608 115139 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:115139 43612 2021-08-01 2022-08-01 2020-12-07T13:38:42.663375+02:00 upper_comprehensive_school_district_fi 32 helsinki Porolahden peruskoulu 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  
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    
4449 115199 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115199 46515 2021-08-01 2022-08-01 2020-12-07T13:38:37.626121+02:00 lower_comprehensive_school_district_fi 32 helsinki Pasilan peruskoulu 2021-2022    
4631 115184 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:115184 46515 2021-08-01 2022-08-01 2020-12-07T13:38:42.745774+02:00 upper_comprehensive_school_district_fi 32 helsinki Pasilan peruskoulu 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    
4619 115162 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:115162 46536 2021-08-01 2022-08-01 2020-12-07T13:38:42.704056+02:00 upper_comprehensive_school_district_fi 32 helsinki Myllypuron peruskoulu 2021-2022    
4448 115196 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115196 46547 2021-08-01 2022-08-01 2020-12-07T13:38:37.622306+02:00 lower_comprehensive_school_district_fi 32 helsinki Pihkapuiston ala-asteen koulu 2021-2022    
4457 115209 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115209 46600 2021-08-01 2022-08-01 2020-12-07T13:38:37.664737+02:00 lower_comprehensive_school_district_fi 32 helsinki Suutarinkylän peruskoulu 2021-2022    
4643 115255 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:115255 46600 2021-08-01 2022-08-01 2020-12-07T13:38:42.788605+02:00 upper_comprehensive_school_district_fi 32 helsinki Suutarinkylän peruskoulu 2021-2022    
4461 115213 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115213 46604 2021-08-01 2022-08-01 2020-12-07T13:38:37.684716+02:00 lower_comprehensive_school_district_fi 32 helsinki Malmin peruskoulu 2021-2022    
4615 115148 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:115148 46604 2021-08-01 2022-08-01 2020-12-07T13:38:42.689048+02:00 upper_comprehensive_school_district_fi 32 helsinki Malmin peruskoulu 2021-2022    
4474 115232 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115232 46633 2021-08-01 2022-08-01 2020-12-07T13:38:37.748160+02:00 lower_comprehensive_school_district_fi 32 helsinki Kannelmäen peruskoulu 2021-2022    
4610 115141 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:115141 46633 2021-08-01 2022-08-01 2020-12-07T13:38:42.671198+02:00 upper_comprehensive_school_district_fi 32 helsinki Kannelmäen peruskoulu 2021-2022    
4486 115267 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115267 46665 2021-08-01 2022-08-01 2020-12-07T13:38:37.807848+02:00 lower_comprehensive_school_district_fi 32 helsinki Pukinmäenkaaren peruskoulu 2021-2022    
4645 115258 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:115258 46665 2021-08-01 2022-08-01 2020-12-07T13:38:42.795022+02:00 upper_comprehensive_school_district_fi 32 helsinki Pukinmäenkaaren peruskoulu 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  
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  
4484 115256 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115256 47291 2021-08-01 2022-08-01 2020-12-07T13:38:37.797749+02:00 lower_comprehensive_school_district_fi 32 helsinki Kalasataman peruskoulu 2021-2022    
5642 115281 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:115281 47291 2021-08-01 2022-08-01 2020-12-07T13:38:42.811908+02:00 upper_comprehensive_school_district_fi 32 helsinki Kalasataman peruskoulu 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    
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    
4620 115163 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:115163 51476 2021-08-01 2022-08-01 2020-12-07T13:38:42.707053+02:00 upper_comprehensive_school_district_fi 32 helsinki Vesalan peruskoulu 2021-2022    
4451 115203 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115203 51478 2021-08-01 2022-08-01 2020-12-07T13:38:37.636331+02:00 lower_comprehensive_school_district_fi 32 helsinki Jätkäsaaren peruskoulu 2021-2022    
4603 115121 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:115121 51478 2021-08-01 2022-08-01 2020-12-07T13:38:42.641308+02:00 upper_comprehensive_school_district_fi 32 helsinki Jätkäsaaren 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    
4618 115157 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:115157 51483 2021-08-01 2022-08-01 2020-12-07T13:38:42.700774+02:00 upper_comprehensive_school_district_fi 32 helsinki Vuoniityn peruskoulu 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    
4628 115181 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:115181 51486 2021-08-01 2022-08-01 2020-12-07T13:38:42.735060+02:00 upper_comprehensive_school_district_fi 32 helsinki Puistopolun peruskoulu 2021-2022    
4478 115238 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115238 51489 2021-08-01 2022-08-01 2020-12-07T13:38:37.766965+02:00 lower_comprehensive_school_district_fi 32 helsinki Merilahden peruskoulu 2021-2022    
4623 115169 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:115169 51489 2021-08-01 2022-08-01 2020-12-07T13:38:42.718164+02:00 upper_comprehensive_school_district_fi 32 helsinki Merilahden peruskoulu 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  
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  
4475 115233 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115233 6666 2021-08-01 2022-08-01 2020-12-07T13:38:37.752955+02:00 lower_comprehensive_school_district_fi 32 helsinki Suomenlinnan ala-asteen koulu 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    
4613 115146 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:115146 6667 2021-08-01 2022-08-01 2020-12-07T13:38:42.682207+02:00 upper_comprehensive_school_district_fi 32 helsinki Ressun peruskoulu 2021-2022    
4472 115225 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115225 6669 2021-08-01 2022-08-01 2020-12-07T13:38:37.739221+02:00 lower_comprehensive_school_district_fi 32 helsinki Tahvonlahden 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    
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    

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