About this Dataset

Applicant Level Data For Junior Admissions Rounds

This dataset contains details of all applicants in past junior admissions rounds - that is when applications are received for York children starting junior school in Year 3 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-04-26T04:03:06Z

Tables

PLOS Junior 2015

@ukgov.pupil_level_outcome_summary_junior.plos_junior_2015

7.1 kB
143 rows
9 columns

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

PLOS Junior 2016

@ukgov.pupil_level_outcome_summary_junior.plos_junior_2016

7.19 kB
138 rows
9 columns

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

PLOS Junior 2017

@ukgov.pupil_level_outcome_summary_junior.plos_junior_2017

7.23 kB
145 rows
9 columns

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

PLOS Junior 2018

@ukgov.pupil_level_outcome_summary_junior.plos_junior_2018

7.24 kB
142 rows
9 columns

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

PLOS Junior 2019

@ukgov.pupil_level_outcome_summary_junior.plos_junior_2019

7.14 kB
136 rows
9 columns

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

PLOS Junior 2020

@ukgov.pupil_level_outcome_summary_junior.plos_junior_2020

6.91 kB
119 rows
9 columns

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

PLOS Junior 2021

@ukgov.pupil_level_outcome_summary_junior.plos_junior_2021

7.6 kB
143 rows
9 columns

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

PLOS Junior 2022

@ukgov.pupil_level_outcome_summary_junior.plos_junior_2022

7.17 kB
112 rows
9 columns

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

PLOS Junior 2023

@ukgov.pupil_level_outcome_summary_junior.plos_junior_2023

7.42 kB
183 rows
9 columns

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

PLOS Junior 2024

@ukgov.pupil_level_outcome_summary_junior.plos_junior_2024

17.14 kB
1,667 rows
9 columns

CREATE TABLE plos_junior_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,
  "catch_primary" VARCHAR,
  "catch_prim" DOUBLE,
  "year" BIGINT
);

PLOS Junior 2025

@ukgov.pupil_level_outcome_summary_junior.plos_junior_2025

7.26 kB
76 rows
9 columns

CREATE TABLE plos_junior_2025 (
  "allocated" DOUBLE,
  "n_1st_preference" DOUBLE  -- 1st Preference,
  "n_2nd_preference" VARCHAR  -- 2nd Preference,
  "n_3rd_preference" VARCHAR  -- 3rd Preference,
  "n_4th_preference" VARCHAR  -- 4th Preference,
  "n_5th_preference" VARCHAR  -- 5th Preference,
  "catchment_name" VARCHAR,
  "catchment_code" DOUBLE,
  "year" BIGINT
);