256 rows where end = "2021-08-01" sorted by name_fi

View and edit SQL

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

end

  • 2021-08-01 · 256
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
4699 114761 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu_sv:114761 17040 2020-08-01 2021-08-01 2020-12-07T13:38:49.589340+02:00 upper_comprehensive_school_district_sv 32 helsinki   Botby grundskola 2020-2021  
4700 114764 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu_sv:114764 6993 2020-08-01 2021-08-01 2020-12-07T13:38:49.596723+02:00 upper_comprehensive_school_district_sv 32 helsinki   Åshöjdens grundskola 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  
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  
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    
4675 114749 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:114749 7096 2020-08-01 2021-08-01 2020-12-07T13:38:47.433776+02:00 upper_comprehensive_school_district_fi 32 helsinki Aleksis Kiven peruskoulu 2020-2021    
4666 114721 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:114721 35019 2020-08-01 2021-08-01 2020-12-07T13:38:47.398654+02:00 upper_comprehensive_school_district_fi 32 helsinki Apollon Yhteiskoulu 2020-2021    
4516 114737 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:114737 24862 2020-08-01 2021-08-01 2020-12-07T13:38:39.038316+02:00 lower_comprehensive_school_district_fi 32 helsinki Arabian peruskoulu 2020-2021    
4680 114765 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:114765 24862 2020-08-01 2021-08-01 2020-12-07T13:38:47.453170+02:00 upper_comprehensive_school_district_fi 32 helsinki Arabian peruskoulu 2020-2021    
4507 114717 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:114717 7163 2020-08-01 2021-08-01 2020-12-07T13:38:39.003518+02:00 lower_comprehensive_school_district_fi 32 helsinki Aurinkolahden peruskoulu 2020-2021    
4656 114694 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:114694 7163 2020-08-01 2021-08-01 2020-12-07T13:38:47.350356+02:00 upper_comprehensive_school_district_fi 32 helsinki Aurinkolahden peruskoulu 2020-2021    
3888 48923 ocd-division/country:fi/kunta:helsinki/esiopetuksen_oppilaaksiottoalue_sv:48923 48923 2020-07-01 2021-08-01 2020-12-07T13:38:55.707422+02:00 preschool_education_sv 32 helsinki Botby förskola Botby förskola  
5180 112048.8424 ocd-division/country:fi/kunta:helsinki/esiopetuksen_oppilaaksiottoalue_fi:112048.8424 8424 2020-07-01 2021-08-01 2020-09-28T09:29:41.922176+03:00 preschool_education_fi 32 helsinki Daghemmet Bamse Ankas Språkbad    
3889 50579 ocd-division/country:fi/kunta:helsinki/esiopetuksen_oppilaaksiottoalue_sv:50579 50579 2020-07-01 2021-08-01 2020-12-07T13:38:55.712165+02:00 preschool_education_sv 32 helsinki Domus förskola Domus förskola  
3883 29859 ocd-division/country:fi/kunta:helsinki/esiopetuksen_oppilaaksiottoalue_sv:29859 29859 2020-07-01 2021-08-01 2020-12-07T13:38:55.684484+02:00 preschool_education_sv 32 helsinki Drumsö daghems förskola Drumsö daghems förskola  
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    
3875 54098 ocd-division/country:fi/kunta:helsinki/esiopetuksen_oppilaaksiottoalue_sv:54098 54098 2020-07-01 2021-08-01 2020-12-07T13:38:55.650473+02:00 preschool_education_sv 32 helsinki Fenix förskola Fenix förskola  
3877 44 ocd-division/country:fi/kunta:helsinki/esiopetuksen_oppilaaksiottoalue_sv:44 44 2020-07-01 2021-08-01 2020-12-07T13:38:55.661160+02:00 preschool_education_sv 32 helsinki Grundskolan Norsen, Cygnaeus förskola Grundskolan Norsen, Cygnaeus förskola  
3892 21455 ocd-division/country:fi/kunta:helsinki/esiopetuksen_oppilaaksiottoalue_sv:21455 21455 2020-07-01 2021-08-01 2020-12-07T13:38:55.727196+02:00 preschool_education_sv 32 helsinki Grundskolan Norsen, Kronohagens förskola Grundskolan Norsen, Kronohagens förskola  
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    
4678 114756 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:114756 6900 2020-08-01 2021-08-01 2020-12-07T13:38:47.445497+02:00 upper_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    
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    
4658 114701 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:114701 7048 2020-08-01 2021-08-01 2020-12-07T13:38:47.357945+02:00 upper_comprehensive_school_district_fi 32 helsinki Helsingin normaalilyseo 2020-2021    
4663 114711 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:114711 6958 2020-08-01 2021-08-01 2020-12-07T13:38:47.382152+02:00 upper_comprehensive_school_district_fi 32 helsinki Helsingin yhteislyseo 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    
4671 114733 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:114733 6880 2020-08-01 2021-08-01 2020-12-07T13:38:47.417318+02:00 upper_comprehensive_school_district_fi 32 helsinki Helsingin yliopiston Viikin normaalikoulu 2020-2021    
4514 114731 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:114731 43448 2020-08-01 2021-08-01 2020-12-07T13:38:39.028308+02:00 lower_comprehensive_school_district_fi 32 helsinki Hertsikan ala-asteen koulu 2020-2021    
4674 114739 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:114739 6946 2020-08-01 2021-08-01 2020-12-07T13:38:47.429159+02:00 upper_comprehensive_school_district_fi 32 helsinki Herttoniemen yhteiskoulu 2020-2021    
4520 114744 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:114744 6726 2020-08-01 2021-08-01 2020-12-07T13:38:39.061304+02:00 lower_comprehensive_school_district_fi 32 helsinki Herttoniemenrannan ala-asteen koulu 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    
4502 114707 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:114707 6926 2020-08-01 2021-08-01 2020-12-07T13:38:38.972571+02:00 lower_comprehensive_school_district_fi 32 helsinki Hiidenkiven peruskoulu 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    
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    
3891 29849 ocd-division/country:fi/kunta:helsinki/esiopetuksen_oppilaaksiottoalue_sv:29849 29849 2020-07-01 2021-08-01 2020-12-07T13:38:55.722114+02:00 preschool_education_sv 32 helsinki Hoplaxskolan, Haga förskola Hoplaxskolan, Haga förskola  
3879 29844 ocd-division/country:fi/kunta:helsinki/esiopetuksen_oppilaaksiottoalue_sv:29844 29844 2020-07-01 2021-08-01 2020-12-07T13:38:55.668505+02:00 preschool_education_sv 32 helsinki Hoplaxskolan, Malmgårds förskola Hoplaxskolan, Malmgårds förskola  
3882 56614 ocd-division/country:fi/kunta:helsinki/esiopetuksen_oppilaaksiottoalue_sv:56614 56614 2020-07-01 2021-08-01 2020-12-07T13:38:55.680404+02:00 preschool_education_sv 32 helsinki Hoplaxskolan, Munksnäs förskola Hoplaxskolan, Munksnäs förskola  
3887 29854 ocd-division/country:fi/kunta:helsinki/esiopetuksen_oppilaaksiottoalue_sv:29854 29854 2020-07-01 2021-08-01 2020-12-07T13:38:55.702531+02:00 preschool_education_sv 32 helsinki Hoplaxskolan, Sockenstugans förskola Hoplaxskolan, Sockenstugans förskola  
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    
4503 114708 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:114708 24877 2020-08-01 2021-08-01 2020-12-07T13:38:38.976738+02:00 lower_comprehensive_school_district_fi 32 helsinki Itäkeskuksen peruskoulu 2020-2021    
4664 114718 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:114718 24877 2020-08-01 2021-08-01 2020-12-07T13:38:47.386336+02:00 upper_comprehensive_school_district_fi 32 helsinki Itäkeskuksen peruskoulu 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    
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    
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    
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    
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    
5211 112207.31224 ocd-division/country:fi/kunta:helsinki/esiopetuksen_oppilaaksiottoalue_fi:112207.31224 31224 2020-07-01 2021-08-01 2020-09-28T09:29:42.043887+03:00 preschool_education_fi 32 helsinki Kaivopuisto International Kindergarten    
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    
4497 114699 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:114699 6796 2020-08-01 2021-08-01 2020-12-07T13:38:38.953961+02:00 lower_comprehensive_school_district_fi 32 helsinki Kallion ala-asteen koulu 2020-2021    
4527 114759 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:114759 46633 2020-08-01 2021-08-01 2020-12-07T13:38:39.102877+02:00 lower_comprehensive_school_district_fi 32 helsinki Kannelmäen peruskoulu 2020-2021    
4652 114688 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:114688 46633 2020-08-01 2021-08-01 2020-12-07T13:38:47.331486+02:00 upper_comprehensive_school_district_fi 32 helsinki Kannelmäen peruskoulu 2020-2021    
4500 114705 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:114705 6675 2020-08-01 2021-08-01 2020-12-07T13:38:38.965691+02:00 lower_comprehensive_school_district_fi 32 helsinki Katajanokan ala-asteen koulu 2020-2021    
4504 114712 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:114712 6791 2020-08-01 2021-08-01 2020-12-07T13:38:38.989573+02:00 lower_comprehensive_school_district_fi 32 helsinki Keinutien ala-asteen koulu 2020-2021    
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    
4517 114738 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:114738 7052 2020-08-01 2021-08-01 2020-12-07T13:38:39.043041+02:00 lower_comprehensive_school_district_fi 32 helsinki Konalan ala-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
);