administrative_division
110 rows where type = "upper_comprehensive_school_district_fi"
This data as json, CSV (advanced)
start ✖
- 2020-08-01 6
- 2021-08-01 4
id ▼ | origin_id | ocd_id | service_point_id | start | end | modified_at | type | parent | municipality | name_fi | name_sv | name |
---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 );