453 rows where "end" is on date 2022-08-01

View and edit SQL

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

end (date)

  • 2022-08-01 · 453
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  
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    
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    
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    
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    
4450 115202 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115202 6906 2021-08-01 2022-08-01 2020-12-07T13:38:37.631830+02:00 lower_comprehensive_school_district_fi 32 helsinki Laakavuoren ala-asteen koulu 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    
4452 115204 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115204 6967 2021-08-01 2022-08-01 2020-12-07T13:38:37.640574+02:00 lower_comprehensive_school_district_fi 32 helsinki Poikkilaakson ala-asteen koulu 2021-2022    
4453 115205 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115205 6964 2021-08-01 2022-08-01 2020-12-07T13:38:37.644872+02:00 lower_comprehensive_school_district_fi 32 helsinki Paloheinän ala-asteen koulu 2021-2022    
4454 115206 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115206 7096 2021-08-01 2022-08-01 2020-12-07T13:38:37.650070+02:00 lower_comprehensive_school_district_fi 32 helsinki Aleksis Kiven peruskoulu 2021-2022    
4455 115207 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115207 6687 2021-08-01 2022-08-01 2020-12-07T13:38:37.654473+02:00 lower_comprehensive_school_district_fi 32 helsinki Suutarilan ala-asteen koulu 2021-2022    
4456 115208 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115208 6788 2021-08-01 2022-08-01 2020-12-07T13:38:37.659584+02:00 lower_comprehensive_school_district_fi 32 helsinki Siltamäen 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    
4458 115210 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115210 7073 2021-08-01 2022-08-01 2020-12-07T13:38:37.669909+02:00 lower_comprehensive_school_district_fi 32 helsinki Hietakummun ala-asteen koulu 2021-2022    
4459 115211 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115211 6880 2021-08-01 2022-08-01 2020-12-07T13:38:37.675589+02:00 lower_comprehensive_school_district_fi 32 helsinki Helsingin yliopiston Viikin normaalikoulu 2021-2022    
4460 115212 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115212 6744 2021-08-01 2022-08-01 2020-12-07T13:38:37.680093+02:00 lower_comprehensive_school_district_fi 32 helsinki Kaisaniemen ala-asteen koulu 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    
4462 115214 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115214 7091 2021-08-01 2022-08-01 2020-12-07T13:38:37.689544+02:00 lower_comprehensive_school_district_fi 32 helsinki Mellunmäen ala-asteen koulu 2021-2022    
4463 115215 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115215 6865 2021-08-01 2022-08-01 2020-12-07T13:38:37.694141+02:00 lower_comprehensive_school_district_fi 32 helsinki Vallilan ala-asteen koulu 2021-2022    
4464 115216 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115216 6711 2021-08-01 2022-08-01 2020-12-07T13:38:37.699233+02:00 lower_comprehensive_school_district_fi 32 helsinki Torpparinmäen peruskoulu 2021-2022    
4465 115217 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115217 6979 2021-08-01 2022-08-01 2020-12-07T13:38:37.704360+02:00 lower_comprehensive_school_district_fi 32 helsinki Puistolan 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    
4467 115220 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115220 7112 2021-08-01 2022-08-01 2020-12-07T13:38:37.713878+02:00 lower_comprehensive_school_district_fi 32 helsinki Munkkiniemen ala-asteen koulu 2021-2022    
4468 115221 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu:115221 6742 2021-08-01 2022-08-01 2020-12-07T13:38:37.718615+02:00 lower_comprehensive_school_district_fi 32 helsinki Pakilan 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
);