administrative_division
57 rows where "end" is on date 2022-08-01 and type = "upper_comprehensive_school_district_fi"
This data as json, CSV (advanced)
Suggested facets: parent, municipality, start (date), modified_at (date)
| id ▼ | origin_id | ocd_id | service_point_id | start | end | modified_at | type | parent | municipality | name_fi | name_sv | name |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 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 | ||
| 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 | ||
| 4605 | 115131 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:115131 | 6994 | 2021-08-01 | 2022-08-01 | 2020-12-07T13:38:42.652316+02:00 | upper_comprehensive_school_district_fi | 32 | helsinki | Pitäjänmäen peruskoulu 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 | ||
| 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 | ||
| 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 | ||
| 4609 | 115140 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:115140 | 6979 | 2021-08-01 | 2022-08-01 | 2020-12-07T13:38:42.667065+02:00 | upper_comprehensive_school_district_fi | 32 | helsinki | Puistolan 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 | ||
| 4611 | 115142 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:115142 | 6971 | 2021-08-01 | 2022-08-01 | 2020-12-07T13:38:42.675389+02:00 | upper_comprehensive_school_district_fi | 32 | helsinki | Maunulan yhteiskoulu ja Hgin matematiikkalukio 2021-2022 | ||
| 4612 | 115143 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:115143 | 6711 | 2021-08-01 | 2022-08-01 | 2020-12-07T13:38:42.678651+02:00 | upper_comprehensive_school_district_fi | 32 | helsinki | Torpparinmäen 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 | ||
| 4614 | 115147 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:115147 | 7163 | 2021-08-01 | 2022-08-01 | 2020-12-07T13:38:42.685388+02:00 | upper_comprehensive_school_district_fi | 32 | helsinki | Aurinkolahden 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 | ||
| 4616 | 115154 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:115154 | 7048 | 2021-08-01 | 2022-08-01 | 2020-12-07T13:38:42.694033+02:00 | upper_comprehensive_school_district_fi | 32 | helsinki | Helsingin normaalilyseo 2021-2022 | ||
| 4617 | 115156 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:115156 | 6915 | 2021-08-01 | 2022-08-01 | 2020-12-07T13:38:42.697444+02:00 | upper_comprehensive_school_district_fi | 32 | helsinki | Kruununhaan yläasteen koulu 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 | ||
| 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 | ||
| 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 | ||
| 4621 | 115164 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:115164 | 6958 | 2021-08-01 | 2022-08-01 | 2020-12-07T13:38:42.710854+02:00 | upper_comprehensive_school_district_fi | 32 | helsinki | Helsingin yhteislyseo 2021-2022 | ||
| 4622 | 115167 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:115167 | 7096 | 2021-08-01 | 2022-08-01 | 2020-12-07T13:38:42.714459+02:00 | upper_comprehensive_school_district_fi | 32 | helsinki | Aleksis Kiven 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 | ||
| 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 | ||
| 4625 | 115171 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:115171 | 7068 | 2021-08-01 | 2022-08-01 | 2020-12-07T13:38:42.724805+02:00 | upper_comprehensive_school_district_fi | 32 | helsinki | Lauttasaaren yhteiskoulu 2021-2022 | ||
| 4626 | 115172 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:115172 | 6806 | 2021-08-01 | 2022-08-01 | 2020-12-07T13:38:42.727914+02:00 | upper_comprehensive_school_district_fi | 32 | helsinki | Oulunkylän yhteiskoulu 2021-2022 | ||
| 4627 | 115173 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:115173 | 6927 | 2021-08-01 | 2022-08-01 | 2020-12-07T13:38:42.731546+02:00 | upper_comprehensive_school_district_fi | 32 | helsinki | Käpylän 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 | ||
| 4629 | 115182 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:115182 | 6880 | 2021-08-01 | 2022-08-01 | 2020-12-07T13:38:42.738201+02:00 | upper_comprehensive_school_district_fi | 32 | helsinki | Helsingin yliopiston Viikin normaalikoulu 2021-2022 | ||
| 4630 | 115183 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:115183 | 6920 | 2021-08-01 | 2022-08-01 | 2020-12-07T13:38:42.741491+02:00 | upper_comprehensive_school_district_fi | 32 | helsinki | Vartiokylän yläasteen koulu 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 | ||
| 4632 | 115188 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:115188 | 6946 | 2021-08-01 | 2022-08-01 | 2020-12-07T13:38:42.750240+02:00 | upper_comprehensive_school_district_fi | 32 | helsinki | Herttoniemen yhteiskoulu 2021-2022 | ||
| 4633 | 115229 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:115229 | 6900 | 2021-08-01 | 2022-08-01 | 2020-12-07T13:38:42.754863+02:00 | upper_comprehensive_school_district_fi | 32 | helsinki | Haagan peruskoulu 2021-2022 | ||
| 4634 | 115230 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:115230 | 6780 | 2021-08-01 | 2022-08-01 | 2020-12-07T13:38:42.758878+02:00 | upper_comprehensive_school_district_fi | 32 | helsinki | Kulosaaren yhteiskoulu 2021-2022 | ||
| 4635 | 115236 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:115236 | 6913 | 2021-08-01 | 2022-08-01 | 2020-12-07T13:38:42.762117+02:00 | upper_comprehensive_school_district_fi | 32 | helsinki | Yhtenäiskoulu 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 | ||
| 4637 | 115244 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:115244 | 7038 | 2021-08-01 | 2022-08-01 | 2020-12-07T13:38:42.768987+02:00 | upper_comprehensive_school_district_fi | 32 | helsinki | Pakilan yläasteen koulu 2021-2022 | ||
| 4638 | 115245 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:115245 | 7166 | 2021-08-01 | 2022-08-01 | 2020-12-07T13:38:42.772356+02:00 | upper_comprehensive_school_district_fi | 32 | helsinki | Töölön yhteiskoulu 2021-2022 | ||
| 4639 | 115247 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:115247 | 6779 | 2021-08-01 | 2022-08-01 | 2020-12-07T13:38:42.775523+02:00 | upper_comprehensive_school_district_fi | 32 | helsinki | Taivallahden peruskoulu 2021-2022 | ||
| 4640 | 115249 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:115249 | 6764 | 2021-08-01 | 2022-08-01 | 2020-12-07T13:38:42.778902+02:00 | upper_comprehensive_school_district_fi | 32 | helsinki | Meilahden yläasteen koulu 2021-2022 | ||
| 4641 | 115250 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:115250 | 6728 | 2021-08-01 | 2022-08-01 | 2020-12-07T13:38:42.782105+02:00 | upper_comprehensive_school_district_fi | 32 | helsinki | Helsingin Uusi Yhteiskoulu 2021-2022 | ||
| 4642 | 115253 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:115253 | 9509 | 2021-08-01 | 2022-08-01 | 2020-12-07T13:38:42.785424+02:00 | upper_comprehensive_school_district_fi | 32 | helsinki | Kankarepuiston 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 | ||
| 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 | ||
| 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 | ||
| 4646 | 115259 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:115259 | 6926 | 2021-08-01 | 2022-08-01 | 2020-11-18T05:51:24.548293+02:00 | upper_comprehensive_school_district_fi | 32 | helsinki | Hiidenkiven peruskoulu 2021-2022 | ||
| 4647 | 115260 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:115260 | 7020 | 2021-08-01 | 2022-08-01 | 2020-12-07T13:38:42.798381+02:00 | upper_comprehensive_school_district_fi | 32 | helsinki | Pohjois-Haagan yhteiskoulu 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 | ||
| 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 | |||
| 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 | ||
| 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 | |||
| 5644 | 115285 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu:115285 | 6926 | 2021-08-01 | 2022-08-01 | 2020-12-07T13:38:42.819454+02:00 | upper_comprehensive_school_district_fi | 32 | helsinki | Hiidenkiven peruskoulu 2021-2022 |
Advanced export
JSON shape: default, array, newline-delimited, object
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 );