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

6.93 KB
143 rows
9 columns


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

PLOS Junior 2016

@ukgov.pupil_level_outcome_summary_junior.plos_junior_2016

7.02 KB
138 rows
9 columns


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

PLOS Junior 2017

@ukgov.pupil_level_outcome_summary_junior.plos_junior_2017

7.06 KB
145 rows
9 columns


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

PLOS Junior 2018

@ukgov.pupil_level_outcome_summary_junior.plos_junior_2018

7.07 KB
142 rows
9 columns


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

PLOS Junior 2019

@ukgov.pupil_level_outcome_summary_junior.plos_junior_2019

6.97 KB
136 rows
9 columns


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

PLOS Junior 2020

@ukgov.pupil_level_outcome_summary_junior.plos_junior_2020

6.74 KB
119 rows
9 columns


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

PLOS Junior 2021

@ukgov.pupil_level_outcome_summary_junior.plos_junior_2021

7.43 KB
143 rows
9 columns


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

PLOS Junior 2022

@ukgov.pupil_level_outcome_summary_junior.plos_junior_2022

7 KB
112 rows
9 columns


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

PLOS Junior 2023

@ukgov.pupil_level_outcome_summary_junior.plos_junior_2023

7.25 KB
183 rows
9 columns


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

PLOS Junior 2024

@ukgov.pupil_level_outcome_summary_junior.plos_junior_2024

16.73 KB
1667 rows
9 columns


CREATE TABLE plos_junior_2024 (
  "allocated" DOUBLE,
  "n_1st_pref" DOUBLE,
  "n_2nd_pref" DOUBLE,
  "n_3rd_pref" DOUBLE,
  "n_4th_pref" DOUBLE,
  "n_5th_pref" DOUBLE,
  "catch_primary" VARCHAR,
  "catch_prim" DOUBLE,
  "year" BIGINT
);

PLOS Junior 2025

@ukgov.pupil_level_outcome_summary_junior.plos_junior_2025

7.09 KB
76 rows
9 columns


CREATE TABLE plos_junior_2025 (
  "allocated" DOUBLE,
  "n_1st_preference" DOUBLE,
  "n_2nd_preference" VARCHAR,
  "n_3rd_preference" VARCHAR,
  "n_4th_preference" VARCHAR,
  "n_5th_preference" VARCHAR,
  "catchment_name" VARCHAR,
  "catchment_code" DOUBLE,
  "year" BIGINT
);