administrative_division

2 rows where service_point_id = 46979 and type = "upper_comprehensive_school_district_sv"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: start (date), end (date), modified_at (date)

type ✖

  • upper_comprehensive_school_district_sv · 2 ✖

service_point_id ✖

  • 46979 · 2 ✖
id ▼ origin_id ocd_id service_point_id start end modified_at type parent municipality name_fi name_sv name
4698 115261 ocd-division/country:fi/kunta:helsinki/oppilaaksiottoalue_ylakoulu_sv:115261 46979 2021-08-01 2022-08-01 2020-12-07T13:38:48.560627+02:00 upper_comprehensive_school_district_sv 32 helsinki   Hoplaxskolan, Munksnäs-enheten 6-9 2021-2022  
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  

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
);