Applicant Level Data For Primary Admissions Rounds
City of York Council
@ukgov.pupil_level_outcome_summary_primary
City of York Council
@ukgov.pupil_level_outcome_summary_primary
This dataset contains details of all applicants in past primary admissions rounds - that is when applications are received for York children starting primary or infant school in Reception 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
CREATE TABLE plos_primary_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
);CREATE TABLE plos_primary_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" DOUBLE
);CREATE TABLE plos_primary_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
);CREATE TABLE plos_primary_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
);CREATE TABLE plos_primary_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" DOUBLE,
"year" BIGINT
);CREATE TABLE plos_primary_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
);CREATE TABLE plos_primary_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
);CREATE TABLE plos_primary_2019 (
"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
);CREATE TABLE plos_primary_2020 (
"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
);CREATE TABLE plos_primary_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,
"catchmentname" VARCHAR,
"catchmentcode" DOUBLE,
"year" BIGINT
);CREATE TABLE plos_primary_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,
"catchmentname" VARCHAR,
"catchmentcode" DOUBLE,
"year" BIGINT
);CREATE TABLE plos_primary_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,
"catchmentname" VARCHAR,
"catchmentcode" BIGINT,
"year" BIGINT
);CREATE TABLE plos_primary_2024 (
"allocated" DOUBLE,
"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,
"catch_primary" VARCHAR,
"catch_prim" DOUBLE,
"year" BIGINT
);CREATE TABLE plos_primary_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,
"catchment_primary_name" VARCHAR,
"catchment_primary_code" DOUBLE,
"year" BIGINT
);Anyone who has the link will be able to view this.