186 rows where "start" is on date 2020-08-01 sorted by origin_id descending

View and edit SQL

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

start (date)

  • 2020-08-01 · 186
id origin_id ▲ ocd_id service_point_id start end modified_at type parent municipality name_fi name_sv name
3901 431977176 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu:431977176   2020-08-01 2021-08-01 2020-09-16T22:30:48.012785+03:00 lower_comprehensive_school_district_fi 11 espoo Keski-Espoon oppilasalue    
3920 431977176 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_ylakoulu:431977176   2020-08-01 2021-08-01 2020-09-16T22:30:55.448647+03:00 upper_comprehensive_school_district_fi 11 espoo Keski-Espoon oppilasalue    
3900 431977071 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu:431977071   2020-08-01 2021-08-01 2020-09-16T22:30:48.009361+03:00 lower_comprehensive_school_district_fi 11 espoo Pohjois-Espoon oppilasalue    
3919 431977071 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_ylakoulu:431977071   2020-08-01 2021-08-01 2020-09-16T22:30:55.445442+03:00 upper_comprehensive_school_district_fi 11 espoo Pohjois-Espoon oppilasalue    
3897 431976899 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu:431976899   2020-08-01 2021-08-01 2020-09-16T22:30:47.999099+03:00 lower_comprehensive_school_district_fi 11 espoo Espoonlahden oppilasalue    
3916 431976899 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_ylakoulu:431976899   2020-08-01 2021-08-01 2020-09-16T22:30:55.435631+03:00 upper_comprehensive_school_district_fi 11 espoo Espoonlahden oppilasalue    
3899 431976820 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu:431976820   2020-08-01 2021-08-01 2020-09-16T22:30:48.005819+03:00 lower_comprehensive_school_district_fi 11 espoo Matinkylän-Olarin oppilasalue    
3918 431976820 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_ylakoulu:431976820   2020-08-01 2021-08-01 2020-09-16T22:30:55.442167+03:00 upper_comprehensive_school_district_fi 11 espoo Matinkylän-Olarin oppilasalue    
3898 431976731 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu:431976731   2020-08-01 2021-08-01 2020-09-16T22:30:48.002357+03:00 lower_comprehensive_school_district_fi 11 espoo Läntisen Leppävaaran oppilasalue    
3917 431976731 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_ylakoulu:431976731   2020-08-01 2021-08-01 2020-09-16T22:30:55.439026+03:00 upper_comprehensive_school_district_fi 11 espoo Läntisen Leppävaaran oppilasalue    
3896 431976647 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu:431976647   2020-08-01 2021-08-01 2020-09-16T22:30:47.995485+03:00 lower_comprehensive_school_district_fi 11 espoo Itäisen Leppävaaran oppilasalue    
3915 431976647 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_ylakoulu:431976647   2020-08-01 2021-08-01 2020-09-16T22:30:55.431811+03:00 upper_comprehensive_school_district_fi 11 espoo Itäisen Leppävaaran oppilasalue    
3895 431976549 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu:431976549   2020-08-01 2021-08-01 2020-09-16T22:30:47.985845+03:00 lower_comprehensive_school_district_fi 11 espoo Tapiolan oppilasalue    
3914 431976549 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_ylakoulu:431976549   2020-08-01 2021-08-01 2020-09-16T22:30:55.427517+03:00 upper_comprehensive_school_district_fi 11 espoo Tapiolan oppilasalue    
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  
3929 131584175 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_ylakoulu:131584175   2020-08-01 2021-08-01 2020-09-16T22:30:59.136789+03:00 upper_comprehensive_school_district_sv 11 espoo   Bemböle  
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  
3928 131583644 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_ylakoulu:131583644   2020-08-01 2021-08-01 2020-09-16T22:30:59.132218+03:00 upper_comprehensive_school_district_sv 11 espoo   Vindängen  
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  
3922 131583643 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_ylakoulu:131583643   2020-08-01 2021-08-01 2020-09-16T22:30:59.103494+03:00 upper_comprehensive_school_district_sv 11 espoo   Mattliden  
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  
3930 131583642 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_ylakoulu:131583642   2020-08-01 2021-08-01 2020-09-16T22:30:59.141125+03:00 upper_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  
3931 131583641 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_ylakoulu:131583641   2020-08-01 2021-08-01 2020-09-16T22:30:59.145469+03:00 upper_comprehensive_school_district_sv 11 espoo   Storängen  
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  
3925 131583490 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_ylakoulu:131583490   2020-08-01 2021-08-01 2020-09-16T22:30:59.117919+03:00 upper_comprehensive_school_district_sv 11 espoo   Kungsgård  
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  
3921 131583489 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_ylakoulu:131583489   2020-08-01 2021-08-01 2020-09-16T22:30:59.097291+03:00 upper_comprehensive_school_district_sv 11 espoo   Boställ  
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  
3924 131583488 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_ylakoulu:131583488   2020-08-01 2021-08-01 2020-09-16T22:30:59.113105+03:00 upper_comprehensive_school_district_sv 11 espoo   Karamalmen  
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  
3926 131583487 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_ylakoulu:131583487   2020-08-01 2021-08-01 2020-09-16T22:30:59.122514+03:00 upper_comprehensive_school_district_sv 11 espoo   Smedsby  
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  
3923 131583486 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_ylakoulu:131583486   2020-08-01 2021-08-01 2020-09-16T22:30:59.108252+03:00 upper_comprehensive_school_district_sv 11 espoo   Bemböle  
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  
3927 131580845 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_ylakoulu:131580845   2020-08-01 2021-08-01 2020-09-16T22:30:59.127117+03:00 upper_comprehensive_school_district_sv 11 espoo   Lagstad  
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  
3932 131580844 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_ylakoulu:131580844   2020-08-01 2021-08-01 2020-09-16T22:30:59.149764+03:00 upper_comprehensive_school_district_sv 11 espoo   Rödskog  
4566 114941 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:114941 6899 2020-08-01 2021-08-01 2020-12-07T13:38:39.261305+02:00 lower_comprehensive_school_district_fi 32 helsinki Lauttasaaren ala-asteen koulu, Vattuniemenkadun toimipiste 2020-2021    
4565 114842 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:114842 7048 2020-08-01 2021-08-01 2020-12-07T13:38:39.257916+02:00 lower_comprehensive_school_district_fi 32 helsinki Helsingin normaalilyseo 2020-2021    
4694 114841 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:114841 51478 2020-08-01 2021-08-01 2020-12-07T13:38:47.521773+02:00 upper_comprehensive_school_district_fi 32 helsinki Jätkäsaaren peruskoulu 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  
4564 114823 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:114823 6913 2020-08-01 2021-08-01 2020-12-07T13:38:39.254387+02:00 lower_comprehensive_school_district_fi 32 helsinki Yhtenäiskoulu 2020-2021    
4693 114822 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:114822 6913 2020-08-01 2021-08-01 2020-12-07T13:38:47.517658+02:00 upper_comprehensive_school_district_fi 32 helsinki Yhtenäiskoulu 2020-2021    
4563 114821 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:114821 16711 2020-08-01 2021-08-01 2020-12-07T13:38:39.250784+02:00 lower_comprehensive_school_district_fi 32 helsinki Laajasalon peruskoulu 2020-2021    
4562 114820 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:114820 6669 2020-08-01 2021-08-01 2020-12-07T13:38:39.247272+02:00 lower_comprehensive_school_district_fi 32 helsinki Tahvonlahden ala-asteen koulu 2020-2021    
4561 114819 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:114819 9509 2020-08-01 2021-08-01 2020-12-07T13:38:39.243570+02:00 lower_comprehensive_school_district_fi 32 helsinki Jakomäen peruskoulu 2020-2021    
4560 114818 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:114818 6994 2020-08-01 2021-08-01 2020-12-07T13:38:39.239561+02:00 lower_comprehensive_school_district_fi 32 helsinki Pitäjänmäen peruskoulu 2020-2021    
4559 114817 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:114817 6980 2020-08-01 2021-08-01 2020-12-07T13:38:39.235697+02:00 lower_comprehensive_school_district_fi 32 helsinki Malminkartanon ala-asteen koulu 2020-2021    
4558 114816 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:114816 6742 2020-08-01 2021-08-01 2020-12-07T13:38:39.231336+02:00 lower_comprehensive_school_district_fi 32 helsinki Pakilan ala-asteen koulu 2020-2021    
4557 114815 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:114815 7112 2020-08-01 2021-08-01 2020-12-07T13:38:39.227283+02:00 lower_comprehensive_school_district_fi 32 helsinki Munkkiniemen ala-asteen koulu 2020-2021    
4556 114814 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:114814 16759 2020-08-01 2021-08-01 2020-12-07T13:38:39.223350+02:00 lower_comprehensive_school_district_fi 32 helsinki Latokartanon peruskoulu 2020-2021    
4555 114813 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:114813 6979 2020-08-01 2021-08-01 2020-12-07T13:38:39.219452+02:00 lower_comprehensive_school_district_fi 32 helsinki Puistolan peruskoulu 2020-2021    
4554 114812 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:114812 6711 2020-08-01 2021-08-01 2020-12-07T13:38:39.214522+02:00 lower_comprehensive_school_district_fi 32 helsinki Torpparinmäen peruskoulu 2020-2021    
4553 114811 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:114811 6865 2020-08-01 2021-08-01 2020-12-07T13:38:39.210004+02:00 lower_comprehensive_school_district_fi 32 helsinki Vallilan ala-asteen koulu 2020-2021    
4552 114810 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:114810 7091 2020-08-01 2021-08-01 2020-12-07T13:38:39.205970+02:00 lower_comprehensive_school_district_fi 32 helsinki Mellunmäen ala-asteen koulu 2020-2021    
4551 114809 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:114809 46604 2020-08-01 2021-08-01 2020-12-07T13:38:39.202530+02:00 lower_comprehensive_school_district_fi 32 helsinki Malmin peruskoulu 2020-2021    
4550 114808 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:114808 6744 2020-08-01 2021-08-01 2020-12-07T13:38:39.198710+02:00 lower_comprehensive_school_district_fi 32 helsinki Kaisaniemen ala-asteen koulu 2020-2021    
4549 114807 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:114807 6926 2020-08-01 2021-08-01 2020-12-07T13:38:39.195061+02:00 lower_comprehensive_school_district_fi 32 helsinki Hiidenkiven peruskoulu 2020-2021    
4548 114806 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:114806 6880 2020-08-01 2021-08-01 2020-12-07T13:38:39.191291+02:00 lower_comprehensive_school_district_fi 32 helsinki Helsingin yliopiston Viikin normaalikoulu 2020-2021    
4547 114805 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:114805 7073 2020-08-01 2021-08-01 2020-12-07T13:38:39.187286+02:00 lower_comprehensive_school_district_fi 32 helsinki Hietakummun ala-asteen koulu 2020-2021    
4546 114804 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:114804 46600 2020-08-01 2021-08-01 2020-12-07T13:38:39.183560+02:00 lower_comprehensive_school_district_fi 32 helsinki Suutarinkylän peruskoulu 2020-2021    
4545 114803 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:114803 6788 2020-08-01 2021-08-01 2020-12-07T13:38:39.179914+02:00 lower_comprehensive_school_district_fi 32 helsinki Siltamäen ala-asteen koulu 2020-2021    
4544 114802 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:114802 6687 2020-08-01 2021-08-01 2020-12-07T13:38:39.175922+02:00 lower_comprehensive_school_district_fi 32 helsinki Suutarilan ala-asteen koulu 2020-2021    
4543 114801 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:114801 7096 2020-08-01 2021-08-01 2020-12-07T13:38:39.171492+02:00 lower_comprehensive_school_district_fi 32 helsinki Aleksis Kiven peruskoulu 2020-2021    
4542 114800 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:114800 6964 2020-08-01 2021-08-01 2020-12-07T13:38:39.167443+02:00 lower_comprehensive_school_district_fi 32 helsinki Paloheinän ala-asteen koulu 2020-2021    
4541 114799 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:114799 6967 2020-08-01 2021-08-01 2020-12-07T13:38:39.163850+02:00 lower_comprehensive_school_district_fi 32 helsinki Poikkilaakson ala-asteen koulu 2020-2021    
4540 114798 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:114798 51478 2020-08-01 2021-08-01 2020-12-07T13:38:39.160239+02:00 lower_comprehensive_school_district_fi 32 helsinki Jätkäsaaren peruskoulu 2020-2021    
4539 114797 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:114797 6906 2020-08-01 2021-08-01 2020-12-07T13:38:39.156349+02:00 lower_comprehensive_school_district_fi 32 helsinki Laakavuoren ala-asteen koulu 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  
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  
4538 114794 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:114794 46515 2020-08-01 2021-08-01 2020-12-07T13:38:39.152100+02:00 lower_comprehensive_school_district_fi 32 helsinki Pasilan peruskoulu 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  
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  
4702 114791 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu_sv:114791 46978 2020-08-01 2021-08-01 2020-12-07T13:38:49.609453+02:00 upper_comprehensive_school_district_sv 32 helsinki   Grundskolan Norsen, 5-9 2020-2021  
4537 114790 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:114790 46547 2020-08-01 2021-08-01 2020-12-07T13:38:39.148548+02:00 lower_comprehensive_school_district_fi 32 helsinki Pihkapuiston ala-asteen koulu 2020-2021    
4536 114789 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:114789 46665 2020-08-01 2021-08-01 2020-12-07T13:38:39.144687+02:00 lower_comprehensive_school_district_fi 32 helsinki Pukinmäenkaaren peruskoulu 2020-2021    
4535 114788 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:114788 9468 2020-08-01 2021-08-01 2020-12-07T13:38:39.140835+02:00 lower_comprehensive_school_district_fi 32 helsinki Pikku Huopalahden ala-asteen koulu 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  
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  
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  
4692 114784 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:114784 16711 2020-08-01 2021-08-01 2020-12-07T13:38:47.513120+02:00 upper_comprehensive_school_district_fi 32 helsinki Laajasalon peruskoulu 2020-2021    
4701 114783 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu_sv:114783 46979 2020-08-01 2021-08-01 2020-12-07T13:38:49.603721+02:00 upper_comprehensive_school_district_sv 32 helsinki   Hoplaxskolan, Munksnäs-enheten 6-9 2020-2021  
4691 114782 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:114782 7020 2020-08-01 2021-08-01 2020-12-07T13:38:47.508819+02:00 upper_comprehensive_school_district_fi 32 helsinki Pohjois-Haagan yhteiskoulu 2020-2021    
4690 114781 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:114781 6926 2020-08-01 2021-08-01 2020-12-07T13:38:47.504186+02:00 upper_comprehensive_school_district_fi 32 helsinki Hiidenkiven peruskoulu 2020-2021    
4689 114780 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:114780 46665 2020-08-01 2021-08-01 2020-12-07T13:38:47.499818+02:00 upper_comprehensive_school_district_fi 32 helsinki Pukinmäenkaaren peruskoulu 2020-2021    
4688 114779 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:114779 34961 2020-08-01 2021-08-01 2020-12-07T13:38:47.495866+02:00 upper_comprehensive_school_district_fi 32 helsinki Munkkiniemen yhteiskoulu 2020-2021    
4534 114778 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:114778 47291 2020-08-01 2021-08-01 2020-12-07T13:38:39.136180+02:00 lower_comprehensive_school_district_fi 32 helsinki Kalasataman peruskoulu 2020-2021    
4687 114777 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:114777 46600 2020-08-01 2021-08-01 2020-12-07T13:38:47.491266+02:00 upper_comprehensive_school_district_fi 32 helsinki Suutarinkylän peruskoulu 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  
4686 114775 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:114775 9509 2020-08-01 2021-08-01 2020-12-07T13:38:47.486506+02:00 upper_comprehensive_school_district_fi 32 helsinki Jakomäen peruskoulu 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  
4533 114773 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:114773 6900 2020-08-01 2021-08-01 2020-12-07T13:38:39.128984+02:00 lower_comprehensive_school_district_fi 32 helsinki Haagan peruskoulu 2020-2021    
4685 114772 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:114772 6728 2020-08-01 2021-08-01 2020-12-07T13:38:47.481182+02:00 upper_comprehensive_school_district_fi 32 helsinki Helsingin Uusi Yhteiskoulu 2020-2021    
4684 114771 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:114771 6764 2020-08-01 2021-08-01 2020-12-07T13:38:47.476497+02:00 upper_comprehensive_school_district_fi 32 helsinki Meilahden yläasteen koulu 2020-2021    
4532 114770 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:114770 6779 2020-08-01 2021-08-01 2020-12-07T13:38:39.124109+02:00 lower_comprehensive_school_district_fi 32 helsinki Taivallahden peruskoulu 2020-2021    
4683 114769 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:114769 6779 2020-08-01 2021-08-01 2020-12-07T13:38:47.471363+02:00 upper_comprehensive_school_district_fi 32 helsinki Taivallahden peruskoulu 2020-2021    
4531 114768 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:114768 7113 2020-08-01 2021-08-01 2020-12-07T13:38:39.119874+02:00 lower_comprehensive_school_district_fi 32 helsinki Maatullin ala-asteen koulu 2020-2021    
4682 114767 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:114767 7166 2020-08-01 2021-08-01 2020-12-07T13:38:47.466801+02:00 upper_comprehensive_school_district_fi 32 helsinki Töölön yhteiskoulu 2020-2021    
4681 114766 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:114766 7038 2020-08-01 2021-08-01 2020-12-07T13:38:47.456945+02:00 upper_comprehensive_school_district_fi 32 helsinki Pakilan yläasteen koulu 2020-2021    

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