School Level Data For Allocated Preferences In Junior Admissions Rounds
City of York Council
@ukgov.admissions_summary_allocated_junior
City of York Council
@ukgov.admissions_summary_allocated_junior
This dataset contains details of allocated preferences 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 only those preferences allocated on National Offer Day 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_allocated_junior_2015 (
"dfenumber" BIGINT,
"schoolname" VARCHAR,
"year" BIGINT,
"places" BIGINT,
"placeallocated" 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_allocated_junior_2016 (
"dfenumber" BIGINT,
"schoolname" VARCHAR,
"year" BIGINT,
"places" BIGINT,
"placeallocated" 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_sibling" BIGINT,
"sibling" BIGINT,
"distance" BIGINT,
"outsidespecifiedarea" BIGINT,
"insidespecifiedarea" BIGINT,
"religion" BIGINT,
"feeder" BIGINT,
"other" BIGINT,
"total" BIGINT
);CREATE TABLE admissions_summary_allocated_junior_2017 (
"dfenumber" BIGINT,
"schoolname" VARCHAR,
"year" BIGINT,
"places" BIGINT,
"placeallocated" 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_sibling" BIGINT,
"sibling" BIGINT,
"distance" BIGINT,
"outsidespecifiedarea" BIGINT,
"insidespecifiedarea" BIGINT,
"religion" BIGINT,
"feeder" BIGINT,
"other" BIGINT,
"total" BIGINT
);CREATE TABLE admissions_summary_allocated_junior_2018 (
"dfenumber" BIGINT,
"schoolname" VARCHAR,
"year" BIGINT,
"places" BIGINT,
"placeallocated" 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_sibling" BIGINT,
"sibling" BIGINT,
"distance" BIGINT,
"outsidespecifiedarea" BIGINT,
"insidespecifiedarea" BIGINT,
"religion" BIGINT,
"feeder" BIGINT,
"other" BIGINT,
"total" BIGINT
);CREATE TABLE admissions_summary_allocated_junior_2019 (
"dfenumber" BIGINT,
"schoolname" VARCHAR,
"year" BIGINT,
"places" BIGINT,
"placeallocated" 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_sibling" BIGINT,
"sibling" BIGINT,
"distance" BIGINT,
"outsidespecifiedarea" BIGINT,
"insidespecifiedarea" BIGINT,
"religion" BIGINT,
"feeder" BIGINT,
"other" BIGINT,
"total" BIGINT
);CREATE TABLE admissions_summary_allocated_junior_2020 (
"dfenumber" BIGINT,
"schoolname" VARCHAR,
"year" BIGINT,
"places" BIGINT,
"placeallocated" 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_sibling" BIGINT,
"sibling" BIGINT,
"outsidespecifiedarea" BIGINT,
"insidespecifiedarea" BIGINT,
"religion" BIGINT,
"feeder" BIGINT,
"other" BIGINT,
"total" BIGINT
);CREATE TABLE admissions_summary_allocated_junior_2021 (
"dfenumber" BIGINT,
"schoolname" VARCHAR,
"year" BIGINT,
"places" BIGINT,
"place_allocated" 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,
"outsidespecifiedarea" BIGINT,
"insidespecifiedarea" BIGINT,
"religion" BIGINT,
"feederschool" BIGINT,
"other" BIGINT,
"total" BIGINT
);CREATE TABLE admissions_summary_allocated_junior_2022 (
"dfenumber" BIGINT,
"schoolname" VARCHAR,
"year" BIGINT,
"places" BIGINT,
"place_allocated" BIGINT,
"n_1st_preference" BIGINT -- 1st Preference,
"n_2ndpref" BIGINT -- 2ndPref,
"n_3rdpref" BIGINT -- 3rdPref,
"n_4thpref" BIGINT -- 4thPref,
"n_5thpref" BIGINT -- 5thPref,
"unplaced" BIGINT,
"sle" BIGINT,
"catchment" BIGINT,
"sibling" BIGINT,
"outsidespecifiedarea" BIGINT,
"insidespecifiedarea" BIGINT,
"religion" BIGINT,
"feeder_school" BIGINT,
"other" BIGINT,
"total" BIGINT
);CREATE TABLE admissions_summary_allocated_junior_2023 (
"dfenumber" BIGINT,
"schoolname" VARCHAR,
"year" BIGINT,
"places" BIGINT,
"place_allocated" BIGINT,
"n_1st_preference" BIGINT -- 1st Preference,
"n_2ndpref" BIGINT -- 2ndPref,
"n_3rdpref" BIGINT -- 3rdPref,
"n_4thpref" BIGINT -- 4thPref,
"n_5thpref" BIGINT -- 5thPref,
"unplaced" BIGINT,
"sle" BIGINT,
"catchment" BIGINT,
"sibling" BIGINT,
"outsidespecifiedarea" BIGINT,
"insidespecifiedarea" BIGINT,
"religion" BIGINT,
"feeder_school" BIGINT,
"other" BIGINT,
"total" BIGINT
);CREATE TABLE admissions_summary_allocated_junior_2024 (
"sch_code" BIGINT,
"name" VARCHAR,
"year" BIGINT,
"places" BIGINT,
"place_allocated" BIGINT,
"n_1st_preference" BIGINT -- 1st Preference,
"sle" BIGINT,
"catchment" BIGINT,
"sibling" BIGINT,
"feeder_school" BIGINT,
"total" BIGINT
);CREATE TABLE admissions_summary_allocated_junior_2025 (
"dfe_number" BIGINT,
"school_name" VARCHAR,
"year" BIGINT,
"places" BIGINT,
"place_allocated" 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,
"inside_specified_area" BIGINT,
"religion" BIGINT,
"feeder_school" BIGINT,
"total" BIGINT
);Anyone who has the link will be able to view this.