About this Dataset

Applicant Level Data For Secondary Admissions Rounds

This dataset contains details of all applicants in past secondary admissions rounds - that is when applications are received for York children starting secondary school in Year 7 for the first time. It includes all preferences, allocated school and the catchment school for each application. For further information and advice on school admissions you may wish to consult the Guide for Parents or School Admissions at CYC's webpage
Publisher name: City of York Council
Last updated: 2025-03-11T04:02:16Z

Tables

PLOS Secondary 2012

@ukgov.pupil_level_outcome_summary_secondary.plos_secondary_2012

12.99 KB
1781 rows
9 columns


CREATE TABLE plos_secondary_2012 (
  "allocated" DOUBLE,
  "n_1stpref" DOUBLE,
  "n_2ndpref" DOUBLE,
  "n_3rdpref" DOUBLE,
  "n_4thpref" DOUBLE,
  "n_5thpref" DOUBLE,
  "catchmentname" VARCHAR,
  "catchmentcode" DOUBLE,
  "year" BIGINT
);

PLOS Secondary 2013

@ukgov.pupil_level_outcome_summary_secondary.plos_secondary_2013

12.71 KB
1795 rows
9 columns


CREATE TABLE plos_secondary_2013 (
  "allocated" DOUBLE,
  "n_1stpref" DOUBLE,
  "n_2ndpref" DOUBLE,
  "n_3rdpref" DOUBLE,
  "n_4thpref" DOUBLE,
  "n_5thpref" DOUBLE,
  "catchmentname" VARCHAR,
  "catchmentcode" DOUBLE,
  "year" BIGINT
);

PLOS Secondary 2014

@ukgov.pupil_level_outcome_summary_secondary.plos_secondary_2014

13.13 KB
1894 rows
9 columns


CREATE TABLE plos_secondary_2014 (
  "allocated" DOUBLE,
  "n_1stpref" DOUBLE,
  "n_2ndpref" DOUBLE,
  "n_3rdpref" DOUBLE,
  "n_4thpref" DOUBLE,
  "n_5thpref" DOUBLE,
  "catchmentname" VARCHAR,
  "catchmentcode" DOUBLE,
  "year" BIGINT
);

PLOS Secondary 2015

@ukgov.pupil_level_outcome_summary_secondary.plos_secondary_2015

13.19 KB
1950 rows
9 columns


CREATE TABLE plos_secondary_2015 (
  "allocated" DOUBLE,
  "n_1stpref" DOUBLE,
  "n_2ndpref" DOUBLE,
  "n_3rdpref" DOUBLE,
  "n_4thpref" DOUBLE,
  "n_5thpref" DOUBLE,
  "catchmentname" VARCHAR,
  "catchmentcode" DOUBLE,
  "year" BIGINT
);

PLOS Secondary 2016

@ukgov.pupil_level_outcome_summary_secondary.plos_secondary_2016

22.83 KB
2004 rows
9 columns


CREATE TABLE plos_secondary_2016 (
  "allocated" DOUBLE,
  "n_1stpref" DOUBLE,
  "n_2ndpref" DOUBLE,
  "n_3rdpref" DOUBLE,
  "n_4thpref" DOUBLE,
  "n_5thpref" DOUBLE,
  "catchmentname" VARCHAR,
  "catchmentcode" BIGINT,
  "year" BIGINT
);

PLOS Secondary 2017

@ukgov.pupil_level_outcome_summary_secondary.plos_secondary_2017

13.27 KB
2145 rows
9 columns


CREATE TABLE plos_secondary_2017 (
  "allocated" DOUBLE,
  "n_1stpref" DOUBLE,
  "n_2ndpref" DOUBLE,
  "n_3rdpref" DOUBLE,
  "n_4thpref" DOUBLE,
  "n_5thpref" DOUBLE,
  "catchmentname" VARCHAR,
  "catchmentcode" DOUBLE,
  "year" BIGINT
);

PLOS Secondary 2018

@ukgov.pupil_level_outcome_summary_secondary.plos_secondary_2018

13.22 KB
2073 rows
9 columns


CREATE TABLE plos_secondary_2018 (
  "allocated" DOUBLE,
  "n_1stpref" DOUBLE,
  "n_2ndpref" DOUBLE,
  "n_3rdpref" DOUBLE,
  "n_4thpref" DOUBLE,
  "n_5thpref" DOUBLE,
  "catchmentname" VARCHAR,
  "catchmentcode" DOUBLE,
  "year" BIGINT
);

PLOS Secondary 2019

@ukgov.pupil_level_outcome_summary_secondary.plos_secondary_2019

13.75 KB
2162 rows
9 columns


CREATE TABLE plos_secondary_2019 (
  "allocated" DOUBLE,
  "n_1stpref" DOUBLE,
  "n_2ndpref" DOUBLE,
  "n_3rdpref" DOUBLE,
  "n_4thpref" DOUBLE,
  "n_5thpref" DOUBLE,
  "catchmentname" DOUBLE,
  "catchmentcode" VARCHAR,
  "year" BIGINT
);

PLOS Secondary 2020

@ukgov.pupil_level_outcome_summary_secondary.plos_secondary_2020

14.44 KB
2160 rows
9 columns


CREATE TABLE plos_secondary_2020 (
  "allocated" DOUBLE,
  "n_1stpref" DOUBLE,
  "n_2ndpref" DOUBLE,
  "n_3rdpref" DOUBLE,
  "n_4thpref" DOUBLE,
  "n_5thpref" DOUBLE,
  "catchmentname" DOUBLE,
  "catchmentcode" VARCHAR,
  "year" BIGINT
);

PLOS Secondary 2021

@ukgov.pupil_level_outcome_summary_secondary.plos_secondary_2021

13.8 KB
2093 rows
9 columns


CREATE TABLE plos_secondary_2021 (
  "allocated" DOUBLE,
  "n_1st_pref" DOUBLE,
  "n_2nd_pref" DOUBLE,
  "n_3rd_pref" DOUBLE,
  "n_4th_pref" DOUBLE,
  "n_5th_pref" DOUBLE,
  "catchmentcode" DOUBLE,
  "catchmentname" VARCHAR,
  "year" BIGINT
);

PLOS Secondary 2022

@ukgov.pupil_level_outcome_summary_secondary.plos_secondary_2022

13.64 KB
2195 rows
9 columns


CREATE TABLE plos_secondary_2022 (
  "allocated" DOUBLE,
  "n_1st_pref" DOUBLE,
  "n_2nd_pref" DOUBLE,
  "n_3rd_pref" DOUBLE,
  "n_4th_pref" DOUBLE,
  "n_5th_pref" DOUBLE,
  "column1" DOUBLE,
  "catch_secondary" VARCHAR,
  "year" BIGINT
);

PLOS Secondary 2023

@ukgov.pupil_level_outcome_summary_secondary.plos_secondary_2023

13.98 KB
2154 rows
9 columns


CREATE TABLE plos_secondary_2023 (
  "allocated" DOUBLE,
  "n_1st_pref" DOUBLE,
  "n_2nd_pref" DOUBLE,
  "n_3rd_pref" DOUBLE,
  "n_4th_pref" DOUBLE,
  "n_5th_pref" DOUBLE,
  "catchmentcode" VARCHAR,
  "catchmentname" VARCHAR,
  "year" BIGINT
);

PLOS Secondary 2024

@ukgov.pupil_level_outcome_summary_secondary.plos_secondary_2024

14.14 KB
2199 rows
9 columns


CREATE TABLE plos_secondary_2024 (
  "allocated" DOUBLE,
  "n_1st_pref" DOUBLE,
  "n_2nd_pref" DOUBLE,
  "n_3rd_pref" DOUBLE,
  "n_4th_pref" DOUBLE,
  "n_5th_pref" DOUBLE,
  "catchmentcode" DOUBLE,
  "catchmentname" VARCHAR,
  "year" BIGINT
);

PLOS Secondary 2025

@ukgov.pupil_level_outcome_summary_secondary.plos_secondary_2025

13.84 KB
2140 rows
9 columns


CREATE TABLE plos_secondary_2025 (
  "allocated" DOUBLE,
  "n_1st_pref" DOUBLE,
  "n_2nd_pref" DOUBLE,
  "n_3rd_pref" DOUBLE,
  "n_4th_pref" DOUBLE,
  "n_5th_pref" DOUBLE,
  "catch_sec" DOUBLE,
  "catch_secondary" VARCHAR,
  "year" BIGINT
);