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

13.3 kB
1,781 rows
9 columns

CREATE TABLE plos_secondary_2012 (
  "allocated" DOUBLE,
  "n_1stpref" DOUBLE  -- 1stPref,
  "n_2ndpref" DOUBLE  -- 2ndPref,
  "n_3rdpref" DOUBLE  -- 3rdPref,
  "n_4thpref" DOUBLE  -- 4thPref,
  "n_5thpref" DOUBLE  -- 5thPref,
  "catchmentname" VARCHAR,
  "catchmentcode" DOUBLE,
  "year" BIGINT
);

PLOS Secondary 2013

@ukgov.pupil_level_outcome_summary_secondary.plos_secondary_2013

13.01 kB
1,795 rows
9 columns

CREATE TABLE plos_secondary_2013 (
  "allocated" DOUBLE,
  "n_1stpref" DOUBLE  -- 1stPref,
  "n_2ndpref" DOUBLE  -- 2ndPref,
  "n_3rdpref" DOUBLE  -- 3rdPref,
  "n_4thpref" DOUBLE  -- 4thPref,
  "n_5thpref" DOUBLE  -- 5thPref,
  "catchmentname" VARCHAR,
  "catchmentcode" DOUBLE,
  "year" BIGINT
);

PLOS Secondary 2014

@ukgov.pupil_level_outcome_summary_secondary.plos_secondary_2014

13.45 kB
1,894 rows
9 columns

CREATE TABLE plos_secondary_2014 (
  "allocated" DOUBLE,
  "n_1stpref" DOUBLE  -- 1stPref,
  "n_2ndpref" DOUBLE  -- 2ndPref,
  "n_3rdpref" DOUBLE  -- 3rdPref,
  "n_4thpref" DOUBLE  -- 4thPref,
  "n_5thpref" DOUBLE  -- 5thPref,
  "catchmentname" VARCHAR,
  "catchmentcode" DOUBLE,
  "year" BIGINT
);

PLOS Secondary 2015

@ukgov.pupil_level_outcome_summary_secondary.plos_secondary_2015

13.51 kB
1,950 rows
9 columns

CREATE TABLE plos_secondary_2015 (
  "allocated" DOUBLE,
  "n_1stpref" DOUBLE  -- 1stPref,
  "n_2ndpref" DOUBLE  -- 2ndPref,
  "n_3rdpref" DOUBLE  -- 3rdPref,
  "n_4thpref" DOUBLE  -- 4thPref,
  "n_5thpref" DOUBLE  -- 5thPref,
  "catchmentname" VARCHAR,
  "catchmentcode" DOUBLE,
  "year" BIGINT
);

PLOS Secondary 2016

@ukgov.pupil_level_outcome_summary_secondary.plos_secondary_2016

23.38 kB
2,004 rows
9 columns

CREATE TABLE plos_secondary_2016 (
  "allocated" DOUBLE,
  "n_1stpref" DOUBLE  -- 1stPref,
  "n_2ndpref" DOUBLE  -- 2ndPref,
  "n_3rdpref" DOUBLE  -- 3rdPref,
  "n_4thpref" DOUBLE  -- 4thPref,
  "n_5thpref" DOUBLE  -- 5thPref,
  "catchmentname" VARCHAR,
  "catchmentcode" BIGINT,
  "year" BIGINT
);

PLOS Secondary 2017

@ukgov.pupil_level_outcome_summary_secondary.plos_secondary_2017

13.59 kB
2,145 rows
9 columns

CREATE TABLE plos_secondary_2017 (
  "allocated" DOUBLE,
  "n_1stpref" DOUBLE  -- 1stPref,
  "n_2ndpref" DOUBLE  -- 2ndPref,
  "n_3rdpref" DOUBLE  -- 3rdPref,
  "n_4thpref" DOUBLE  -- 4thPref,
  "n_5thpref" DOUBLE  -- 5thPref,
  "catchmentname" VARCHAR,
  "catchmentcode" DOUBLE,
  "year" BIGINT
);

PLOS Secondary 2018

@ukgov.pupil_level_outcome_summary_secondary.plos_secondary_2018

13.54 kB
2,073 rows
9 columns

CREATE TABLE plos_secondary_2018 (
  "allocated" DOUBLE,
  "n_1stpref" DOUBLE  -- 1stPref,
  "n_2ndpref" DOUBLE  -- 2ndPref,
  "n_3rdpref" DOUBLE  -- 3rdPref,
  "n_4thpref" DOUBLE  -- 4thPref,
  "n_5thpref" DOUBLE  -- 5thPref,
  "catchmentname" VARCHAR,
  "catchmentcode" DOUBLE,
  "year" BIGINT
);

PLOS Secondary 2019

@ukgov.pupil_level_outcome_summary_secondary.plos_secondary_2019

14.08 kB
2,162 rows
9 columns

CREATE TABLE plos_secondary_2019 (
  "allocated" DOUBLE,
  "n_1stpref" DOUBLE  -- 1stPref,
  "n_2ndpref" DOUBLE  -- 2ndPref,
  "n_3rdpref" DOUBLE  -- 3rdPref,
  "n_4thpref" DOUBLE  -- 4thPref,
  "n_5thpref" DOUBLE  -- 5thPref,
  "catchmentname" DOUBLE,
  "catchmentcode" VARCHAR,
  "year" BIGINT
);

PLOS Secondary 2020

@ukgov.pupil_level_outcome_summary_secondary.plos_secondary_2020

14.79 kB
2,160 rows
9 columns

CREATE TABLE plos_secondary_2020 (
  "allocated" DOUBLE,
  "n_1stpref" DOUBLE  -- 1stPref,
  "n_2ndpref" DOUBLE  -- 2ndPref,
  "n_3rdpref" DOUBLE  -- 3rdPref,
  "n_4thpref" DOUBLE  -- 4thPref,
  "n_5thpref" DOUBLE  -- 5thPref,
  "catchmentname" DOUBLE,
  "catchmentcode" VARCHAR,
  "year" BIGINT
);

PLOS Secondary 2021

@ukgov.pupil_level_outcome_summary_secondary.plos_secondary_2021

14.13 kB
2,093 rows
9 columns

CREATE TABLE plos_secondary_2021 (
  "allocated" DOUBLE,
  "n_1st_pref" DOUBLE  -- 1st Pref,
  "n_2nd_pref" DOUBLE  -- 2nd Pref,
  "n_3rd_pref" DOUBLE  -- 3rd Pref,
  "n_4th_pref" DOUBLE  -- 4th Pref,
  "n_5th_pref" DOUBLE  -- 5th Pref,
  "catchmentcode" DOUBLE,
  "catchmentname" VARCHAR,
  "year" BIGINT
);

PLOS Secondary 2022

@ukgov.pupil_level_outcome_summary_secondary.plos_secondary_2022

13.96 kB
2,195 rows
9 columns

CREATE TABLE plos_secondary_2022 (
  "allocated" DOUBLE,
  "n_1st_pref" DOUBLE  -- 1st Pref,
  "n_2nd_pref" DOUBLE  -- 2nd Pref,
  "n_3rd_pref" DOUBLE  -- 3rd Pref,
  "n_4th_pref" DOUBLE  -- 4th Pref,
  "n_5th_pref" DOUBLE  -- 5th Pref,
  "column1" DOUBLE,
  "catch_secondary" VARCHAR,
  "year" BIGINT
);

PLOS Secondary 2023

@ukgov.pupil_level_outcome_summary_secondary.plos_secondary_2023

14.31 kB
2,154 rows
9 columns

CREATE TABLE plos_secondary_2023 (
  "allocated" DOUBLE,
  "n_1st_pref" DOUBLE  -- 1st Pref,
  "n_2nd_pref" DOUBLE  -- 2nd Pref,
  "n_3rd_pref" DOUBLE  -- 3rd Pref,
  "n_4th_pref" DOUBLE  -- 4th Pref,
  "n_5th_pref" DOUBLE  -- 5th Pref,
  "catchmentcode" VARCHAR,
  "catchmentname" VARCHAR,
  "year" BIGINT
);

PLOS Secondary 2024

@ukgov.pupil_level_outcome_summary_secondary.plos_secondary_2024

14.48 kB
2,199 rows
9 columns

CREATE TABLE plos_secondary_2024 (
  "allocated" DOUBLE,
  "n_1st_pref" DOUBLE  -- 1st Pref,
  "n_2nd_pref" DOUBLE  -- 2nd Pref,
  "n_3rd_pref" DOUBLE  -- 3rd Pref,
  "n_4th_pref" DOUBLE  -- 4th Pref,
  "n_5th_pref" DOUBLE  -- 5th Pref,
  "catchmentcode" DOUBLE,
  "catchmentname" VARCHAR,
  "year" BIGINT
);

PLOS Secondary 2025

@ukgov.pupil_level_outcome_summary_secondary.plos_secondary_2025

14.17 kB
2,140 rows
9 columns

CREATE TABLE plos_secondary_2025 (
  "allocated" DOUBLE,
  "n_1st_pref" DOUBLE  -- 1st Pref,
  "n_2nd_pref" DOUBLE  -- 2nd Pref,
  "n_3rd_pref" DOUBLE  -- 3rd Pref,
  "n_4th_pref" DOUBLE  -- 4th Pref,
  "n_5th_pref" DOUBLE  -- 5th Pref,
  "catch_sec" DOUBLE,
  "catch_secondary" VARCHAR,
  "year" BIGINT
);