administrative_division
6 rows where "modified_at" is on date 2020-11-18
This data as json, CSV (advanced)
Suggested facets: start, end, type, start (date), end (date), modified_at (date)
id ▼ | origin_id | ocd_id | service_point_id | start | end | modified_at | type | parent | municipality | name_fi | name_sv | name |
---|---|---|---|---|---|---|---|---|---|---|---|---|
3884 | ocd-division/country:fi/kunta:helsinki/esiopetuksen_oppilaaksiottoalue_sv: | 2020-07-01 | 2021-08-01 | 2020-11-18T05:51:36.406681+02:00 | preschool_education_sv | 32 | helsinki | Östersundom | Östersundom | |||
4571 | 115190 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu_sv:115190 | 34371 | 2021-08-01 | 2022-08-01 | 2020-11-18T05:51:22.198598+02:00 | lower_comprehensive_school_district_sv | 32 | helsinki | Västra distrikt, Hoplaxskolan, Kårböle-enheten 1-5 2021-2022 | ||
4578 | 115228 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu_sv:115228 | 43924 | 2021-08-01 | 2022-08-01 | 2020-11-18T05:51:22.227978+02:00 | lower_comprehensive_school_district_sv | 32 | helsinki | Västra distrikt, Hoplaxskolan, Munksnäs-enheten 0-5 2021-2022 | ||
4579 | 115241 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu_sv:115241 | 52361 | 2021-08-01 | 2022-08-01 | 2020-11-18T05:51:22.231120+02:00 | lower_comprehensive_school_district_sv | 32 | helsinki | Grundskolan Norsen, Grundskolan Norsen, Kronohagen-enheten 1-4 2021-2022 | ||
4584 | 115265 | ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_alakoulu_sv:115265 | 34376 | 2021-08-01 | 2022-08-01 | 2020-11-18T05:51:22.246218+02:00 | lower_comprehensive_school_district_sv | 32 | helsinki | Västra distrikt, Hoplaxskolan, Sockenbacka-enheten 1-2 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 |
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 );