School Level Data For All Preferences In Primary Admissions Rounds
City of York Council
@ukgov.admissions_summary_all_primary
City of York Council
@ukgov.admissions_summary_all_primary
This dataset contains details of all preferences 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 by preference status (allocated, refused, withdrawn) and by admissions criteria group (catchment, religion, sibling etc). 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 admissions_summary_all_primary_2012 (
"dfenumber" BIGINT,
"schoolname" VARCHAR,
"year" BIGINT,
"places" BIGINT,
"placeallocated" BIGINT,
"placerefused" BIGINT,
"placewithdrawn" BIGINT,
"withdrawnfromprocess" BIGINT,
"n_1stpref" BIGINT -- 1stPref,
"n_2ndpref" BIGINT -- 2ndPref,
"n_3rdpref" BIGINT -- 3rdPref,
"n_4thpref" BIGINT -- 4thPref,
"n_5thpref" BIGINT -- 5thPref,
"unplaced" BIGINT,
"sle" BIGINT,
"catchment" BIGINT,
"sibling" BIGINT,
"distance" BIGINT,
"outsidespecifiedarea" BIGINT,
"insidespecifiedarea" BIGINT,
"religion" BIGINT,
"feeder" BIGINT,
"other" BIGINT,
"total" BIGINT
);CREATE TABLE admissions_summary_all_primary_2013 (
"dfenumber" BIGINT,
"schoolname" VARCHAR,
"year" BIGINT,
"places" BIGINT,
"placeallocated" BIGINT,
"placerefused" BIGINT,
"placewithdrawn" BIGINT,
"withdrawnfromprocess" BIGINT,
"n_1stpref" BIGINT -- 1stPref,
"n_2ndpref" BIGINT -- 2ndPref,
"n_3rdpref" BIGINT -- 3rdPref,
"n_4thpref" BIGINT -- 4thPref,
"n_5thpref" BIGINT -- 5thPref,
"unplaced" BIGINT,
"sle" BIGINT,
"catchment" BIGINT,
"sibling" BIGINT,
"distance" BIGINT,
"outsidespecifiedarea" BIGINT,
"insidespecifiedarea" BIGINT,
"religion" BIGINT,
"feeder" BIGINT,
"other" BIGINT,
"total" BIGINT
);CREATE TABLE admissions_summary_all_primary_2014 (
"dfenumber" BIGINT,
"schoolname" VARCHAR,
"year" BIGINT,
"places" BIGINT,
"placeallocated" BIGINT,
"placerefused" BIGINT,
"placewithdrawn" BIGINT,
"withdrawnfromprocess" BIGINT,
"n_1stpref" BIGINT -- 1stPref,
"n_2ndpref" BIGINT -- 2ndPref,
"n_3rdpref" BIGINT -- 3rdPref,
"n_4thpref" BIGINT -- 4thPref,
"n_5thpref" BIGINT -- 5thPref,
"unplaced" BIGINT,
"sle" BIGINT,
"catchment" BIGINT,
"sibling" BIGINT,
"distance" BIGINT,
"outsidespecifiedarea" BIGINT,
"insidespecifiedarea" BIGINT,
"religion" BIGINT,
"feeder" BIGINT,
"other" BIGINT,
"total" BIGINT
);CREATE TABLE admissions_summary_all_primary_2015 (
"dfenumber" BIGINT,
"schoolname" VARCHAR,
"year" BIGINT,
"places" BIGINT,
"placeallocated" BIGINT,
"placerefused" BIGINT,
"placewithdrawn" BIGINT,
"withdrawnfromprocess" BIGINT,
"n_1stpref" BIGINT -- 1stPref,
"n_2ndpref" BIGINT -- 2ndPref,
"n_3rdpref" BIGINT -- 3rdPref,
"n_4thpref" BIGINT -- 4thPref,
"n_5thpref" BIGINT -- 5thPref,
"unplaced" BIGINT,
"sle" BIGINT,
"catchment" BIGINT,
"sibling" BIGINT,
"distance" BIGINT,
"outsidespecifiedarea" BIGINT,
"insidespecifiedarea" BIGINT,
"religion" BIGINT,
"feeder" BIGINT,
"other" BIGINT,
"total" BIGINT
);CREATE TABLE admissions_summary_all_primary_2016 (
"dfenumber" BIGINT,
"schoolname" VARCHAR,
"year" BIGINT,
"places" BIGINT,
"placeallocated" BIGINT,
"placerefused" BIGINT,
"placewithdrawn" BIGINT,
"withdrawn_from_process" BIGINT,
"n_1stpref" BIGINT -- 1stPref,
"n_2ndpref" BIGINT -- 2ndPref,
"n_3rdpref" BIGINT -- 3rdPref,
"n_4thpref" BIGINT -- 4thPref,
"n_5thpref" BIGINT -- 5thPref,
"unplaced" BIGINT,
"sle" BIGINT,
"catchment" BIGINT,
"sibling" BIGINT,
"distance" BIGINT,
"outsidespecifiedarea" BIGINT,
"insidespecifiedarea" BIGINT,
"religion" BIGINT,
"feeder" BIGINT,
"other" BIGINT,
"total" BIGINT
);CREATE TABLE admissions_summary_all_primary_2017 (
"dfenumber" BIGINT,
"schoolname" VARCHAR,
"year" BIGINT,
"places" BIGINT,
"placeallocated" BIGINT,
"placerefused" BIGINT,
"placewithdrawn" BIGINT,
"withdrawn_from_process" BIGINT,
"n_1stpref" BIGINT -- 1stPref,
"n_2ndpref" BIGINT -- 2ndPref,
"n_3rdpref" BIGINT -- 3rdPref,
"n_4thpref" BIGINT -- 4thPref,
"n_5thpref" BIGINT -- 5thPref,
"unplaced" BIGINT,
"sle" BIGINT,
"catchment" BIGINT,
"sibling" BIGINT,
"distance" BIGINT,
"outsidespecifiedarea" BIGINT,
"insidespecifiedarea" BIGINT,
"religion" BIGINT,
"feeder" BIGINT,
"other" BIGINT,
"total" BIGINT
);CREATE TABLE admissions_summary_all_primary_2018 (
"dfenumber" BIGINT,
"schoolname" VARCHAR,
"year" BIGINT,
"places" BIGINT,
"placeallocated" BIGINT,
"placerefused" BIGINT,
"placewithdrawn" BIGINT,
"withdrawn_from_process" BIGINT,
"n_1stpref" BIGINT -- 1stPref,
"n_2ndpref" BIGINT -- 2ndPref,
"n_3rdpref" BIGINT -- 3rdPref,
"n_4thpref" BIGINT -- 4thPref,
"n_5thpref" BIGINT -- 5thPref,
"unplaced" BIGINT,
"sle" BIGINT,
"catchment" BIGINT,
"sibling" BIGINT,
"distance" BIGINT,
"outsidespecifiedarea" BIGINT,
"insidespecifiedarea" BIGINT,
"religion" BIGINT,
"feeder" BIGINT,
"other" BIGINT,
"total" BIGINT
);CREATE TABLE admissions_summary_all_primary_2019 (
"dfenumber" BIGINT,
"schoolname" VARCHAR,
"year" BIGINT,
"places" BIGINT,
"placeallocated" BIGINT,
"placerefused" BIGINT,
"placewithdrawn" BIGINT,
"withdrawn_from_process" BIGINT,
"n_1stpref" BIGINT -- 1stPref,
"n_2ndpref" BIGINT -- 2ndPref,
"n_3rdpref" BIGINT -- 3rdPref,
"n_4thpref" BIGINT -- 4thPref,
"n_5thpref" BIGINT -- 5thPref,
"unplaced" BIGINT,
"sle" BIGINT,
"catchment" BIGINT,
"sibling" BIGINT,
"distance" BIGINT,
"outsidespecifiedarea" BIGINT,
"insidespecifiedarea" BIGINT,
"religion" BIGINT,
"feeder" BIGINT,
"other" BIGINT,
"total" BIGINT
);CREATE TABLE admissions_summary_all_primary_2020 (
"dfenumber" BIGINT,
"schoolname" VARCHAR,
"year" BIGINT,
"places" BIGINT,
"placeallocated" BIGINT,
"placerefused" BIGINT,
"placewithdrawn" BIGINT,
"withdrawn_from_process" BIGINT,
"n_1stpref" BIGINT -- 1stPref,
"n_2ndpref" BIGINT -- 2ndPref,
"n_3rdpref" BIGINT -- 3rdPref,
"n_4thpref" DOUBLE -- 4thPref,
"n_5thpref" DOUBLE -- 5thPref,
"unplaced" BIGINT,
"sle" BIGINT,
"catchment" BIGINT,
"sibling" BIGINT,
"distance" BIGINT,
"outsidespecifiedarea" BIGINT,
"insidespecifiedarea" BIGINT,
"religion" BIGINT,
"feeder" BIGINT,
"other" BIGINT,
"total" BIGINT
);CREATE TABLE admissions_summary_all_primary_2021 (
"dfenumber" BIGINT,
"schoolname" VARCHAR,
"year" BIGINT,
"places" BIGINT,
"place_allocated" BIGINT,
"place_refused" DOUBLE,
"place_withdrawn" BIGINT,
"withdrawn_from_process" DOUBLE,
"n_1st_preference" BIGINT -- 1st Preference,
"n_2nd_preference" BIGINT -- 2nd Preference,
"n_3rd_preference" BIGINT -- 3rd Preference,
"n_4th_preference" DOUBLE -- 4th Preference,
"n_5th_preference" DOUBLE -- 5th Preference,
"unplaced" DOUBLE,
"sle" BIGINT,
"catchment" BIGINT,
"sibling" BIGINT,
"distance" BIGINT,
"outsidespecifiedarea" BIGINT,
"insidespecifiedarea" BIGINT,
"religion" BIGINT,
"feeder" BIGINT,
"other" BIGINT,
"total" BIGINT
);CREATE TABLE admissions_summary_all_primary_2022 (
"dfenumber" DOUBLE,
"schoolname" VARCHAR,
"year" DOUBLE,
"places" DOUBLE,
"place_allocated" DOUBLE,
"place_refused" DOUBLE,
"place_withdrawn" DOUBLE,
"withdrawn_from_process" DOUBLE,
"n_1st_preference" DOUBLE -- 1st Preference,
"n_2nd_preference" DOUBLE -- 2nd Preference,
"n_3rd_preference" DOUBLE -- 3rd Preference,
"n_4th_preference" DOUBLE -- 4th Preference,
"n_5th_preference" DOUBLE -- 5th Preference,
"unplaced" DOUBLE,
"sle" DOUBLE,
"catchment" DOUBLE,
"sibling" DOUBLE,
"distance" DOUBLE,
"outsidespecifiedarea" DOUBLE,
"insidespecifiedarea" DOUBLE,
"religion" DOUBLE,
"total" DOUBLE
);CREATE TABLE admissions_summary_all_primary_2023 (
"dfenumber" BIGINT,
"schoolname" VARCHAR,
"year" BIGINT,
"places" BIGINT,
"place_allocated" BIGINT,
"place_refused" DOUBLE,
"place_withdrawn" BIGINT,
"withdrawn_from_process" DOUBLE,
"n_1st_preference" BIGINT -- 1st Preference,
"n_2nd_preference" BIGINT -- 2nd Preference,
"n_3rd_preference" BIGINT -- 3rd Preference,
"n_4th_preference" DOUBLE -- 4th Preference,
"n_5th_preference" DOUBLE -- 5th Preference,
"unplaced" DOUBLE,
"sle" BIGINT,
"catchment" BIGINT,
"sibling" DOUBLE,
"distance" BIGINT,
"outsidespecifiedarea" VARCHAR,
"insidespecifiedarea" DOUBLE,
"religion" BIGINT,
"total" BIGINT
);CREATE TABLE admissions_summary_all_primary_2024 (
"sch_code" BIGINT,
"preference_school_name" VARCHAR,
"year" BIGINT,
"places" BIGINT,
"place_allocated" BIGINT,
"place_refused" DOUBLE,
"place_withdrawn" BIGINT,
"withdrawn_from_process" DOUBLE,
"n_1st_preference" BIGINT -- 1st Preference,
"n_2nd_preference" BIGINT -- 2nd Preference,
"n_3rd_preference" BIGINT -- 3rd Preference,
"unnamed_11" VARCHAR -- Unnamed: 11,
"n_4th_preference" DOUBLE -- 4th Preference,
"n_5th_preference" DOUBLE -- 5th Preference,
"n_6th_preference" DOUBLE -- 6th Preference,
"unplaced" DOUBLE,
"sle" BIGINT,
"catchment" BIGINT,
"sibling" DOUBLE,
"distance" BIGINT,
"religion" BIGINT,
"outside_specified_area" VARCHAR,
"inside_specified_area" DOUBLE,
"rc" VARCHAR,
"total" BIGINT
);CREATE TABLE admissions_summary_all_primary_2025 (
"dfe_number" BIGINT,
"school_name" VARCHAR,
"year" BIGINT,
"places" BIGINT,
"place_allocated" BIGINT,
"place_refused" BIGINT,
"place_withdrawn" BIGINT,
"withdrawn_from_process" BIGINT,
"n_1st_preference" BIGINT -- 1st Preference,
"n_2nd_preference" BIGINT -- 2nd Preference,
"n_3rd_preference" BIGINT -- 3rd Preference,
"n_4th_preference" BIGINT -- 4th Preference,
"n_5th_preference" BIGINT -- 5th Preference,
"unplaced" BIGINT,
"sle" BIGINT,
"catchment" BIGINT,
"sibling" BIGINT,
"distance" BIGINT,
"inside_specified_area" BIGINT,
"religion" BIGINT,
"other" BIGINT,
"total" BIGINT
);Anyone who has the link will be able to view this.