24 rows where "modified_at" is on date 2020-09-16 and type = "upper_comprehensive_school_district_sv" sorted by origin_id

View and edit SQL

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

type

  • upper_comprehensive_school_district_sv · 24

modified_at (date)

  • 2020-09-16 · 24
id origin_id ▼ ocd_id service_point_id start end modified_at type parent municipality name_fi name_sv name
3932 131580844 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_ylakoulu:131580844   2020-08-01 2021-08-01 2020-09-16T22:30:59.149764+03:00 upper_comprehensive_school_district_sv 11 espoo   Rödskog  
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  
3927 131580845 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_ylakoulu:131580845   2020-08-01 2021-08-01 2020-09-16T22:30:59.127117+03:00 upper_comprehensive_school_district_sv 11 espoo   Lagstad  
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  
3923 131583486 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_ylakoulu:131583486   2020-08-01 2021-08-01 2020-09-16T22:30:59.108252+03:00 upper_comprehensive_school_district_sv 11 espoo   Bemböle  
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  
3926 131583487 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_ylakoulu:131583487   2020-08-01 2021-08-01 2020-09-16T22:30:59.122514+03:00 upper_comprehensive_school_district_sv 11 espoo   Smedsby  
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  
3924 131583488 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_ylakoulu:131583488   2020-08-01 2021-08-01 2020-09-16T22:30:59.113105+03:00 upper_comprehensive_school_district_sv 11 espoo   Karamalmen  
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  
3921 131583489 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_ylakoulu:131583489   2020-08-01 2021-08-01 2020-09-16T22:30:59.097291+03:00 upper_comprehensive_school_district_sv 11 espoo   Boställ  
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  
3925 131583490 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_ylakoulu:131583490   2020-08-01 2021-08-01 2020-09-16T22:30:59.117919+03:00 upper_comprehensive_school_district_sv 11 espoo   Kungsgård  
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  
3931 131583641 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_ylakoulu:131583641   2020-08-01 2021-08-01 2020-09-16T22:30:59.145469+03:00 upper_comprehensive_school_district_sv 11 espoo   Storängen  
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  
3930 131583642 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_ylakoulu:131583642   2020-08-01 2021-08-01 2020-09-16T22:30:59.141125+03:00 upper_comprehensive_school_district_sv 11 espoo   Finno  
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  
3922 131583643 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_ylakoulu:131583643   2020-08-01 2021-08-01 2020-09-16T22:30:59.103494+03:00 upper_comprehensive_school_district_sv 11 espoo   Mattliden  
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  
3928 131583644 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_ylakoulu:131583644   2020-08-01 2021-08-01 2020-09-16T22:30:59.132218+03:00 upper_comprehensive_school_district_sv 11 espoo   Vindängen  
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  
3929 131584175 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_ylakoulu:131584175   2020-08-01 2021-08-01 2020-09-16T22:30:59.136789+03:00 upper_comprehensive_school_district_sv 11 espoo   Bemböle  
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  

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