About this Dataset

School Level Data For All Preferences In Secondary Admissions Rounds

This dataset contains details of all preferences in past secondary admissions rounds - that is when applications are received for York children starting secondary school in Year 7 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-03-11T04:02:19Z

Tables

Admissions Summary All - Secondary 2012

@ukgov.admissions_summary_all_secondary.admissions_summary_all_secondary_2012

17.98 kB
10 rows
24 columns

CREATE TABLE admissions_summary_all_secondary_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
);

Admissions Summary All - Secondary 2013

@ukgov.admissions_summary_all_secondary.admissions_summary_all_secondary_2013

17.88 kB
9 rows
24 columns

CREATE TABLE admissions_summary_all_secondary_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
);

Admissions Summary All - Secondary 2014

@ukgov.admissions_summary_all_secondary.admissions_summary_all_secondary_2014

17.98 kB
11 rows
24 columns

CREATE TABLE admissions_summary_all_secondary_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
);

Admissions Summary All - Secondary 2015

@ukgov.admissions_summary_all_secondary.admissions_summary_all_secondary_2015

18.01 kB
11 rows
24 columns

CREATE TABLE admissions_summary_all_secondary_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
);

Admissions Summary All - Secondary 2016

@ukgov.admissions_summary_all_secondary.admissions_summary_all_secondary_2016

17.93 kB
9 rows
24 columns

CREATE TABLE admissions_summary_all_secondary_2016 (
  "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
);

Admissions Summary All - Secondary 2017

@ukgov.admissions_summary_all_secondary.admissions_summary_all_secondary_2017

17.95 kB
9 rows
24 columns

CREATE TABLE admissions_summary_all_secondary_2017 (
  "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
);

Admissions Summary All - Secondary 2018

@ukgov.admissions_summary_all_secondary.admissions_summary_all_secondary_2018

18 kB
9 rows
24 columns

CREATE TABLE admissions_summary_all_secondary_2018 (
  "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
);

Admissions Summary All - Secondary 2019

@ukgov.admissions_summary_all_secondary.admissions_summary_all_secondary_2019

31.58 kB
9 rows
49 columns

CREATE TABLE admissions_summary_all_secondary_2019 (
  "dfenumber" BIGINT,
  "schoolname" VARCHAR,
  "year" BIGINT,
  "places" BIGINT,
  "placeallocated" BIGINT,
  "placerefused" BIGINT,
  "placewithdrawn" BIGINT,
  "withdrawnfromprocess" BIGINT,
  "total" 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_1" BIGINT,
  "unnamed_25" VARCHAR  -- Unnamed: 25,
  "unnamed_26" VARCHAR  -- Unnamed: 26,
  "unnamed_27" VARCHAR  -- Unnamed: 27,
  "unnamed_28" VARCHAR  -- Unnamed: 28,
  "unnamed_29" VARCHAR  -- Unnamed: 29,
  "unnamed_30" VARCHAR  -- Unnamed: 30,
  "unnamed_31" VARCHAR  -- Unnamed: 31,
  "unnamed_32" VARCHAR  -- Unnamed: 32,
  "unnamed_33" VARCHAR  -- Unnamed: 33,
  "unnamed_34" VARCHAR  -- Unnamed: 34,
  "unnamed_35" VARCHAR  -- Unnamed: 35,
  "unnamed_36" VARCHAR  -- Unnamed: 36,
  "unnamed_37" VARCHAR  -- Unnamed: 37,
  "unnamed_38" VARCHAR  -- Unnamed: 38,
  "unnamed_39" VARCHAR  -- Unnamed: 39,
  "unnamed_40" VARCHAR  -- Unnamed: 40,
  "unnamed_41" VARCHAR  -- Unnamed: 41,
  "unnamed_42" VARCHAR  -- Unnamed: 42,
  "unnamed_43" VARCHAR  -- Unnamed: 43,
  "unnamed_44" VARCHAR  -- Unnamed: 44,
  "unnamed_45" VARCHAR  -- Unnamed: 45,
  "unnamed_46" VARCHAR  -- Unnamed: 46,
  "unnamed_47" VARCHAR  -- Unnamed: 47,
  "unnamed_48" VARCHAR  -- Unnamed: 48
);

Admissions Summary All - Secondary 2020

@ukgov.admissions_summary_all_secondary.admissions_summary_all_secondary_2020

18.55 kB
9 rows
25 columns

CREATE TABLE admissions_summary_all_secondary_2020 (
  "dfenumber" BIGINT,
  "schoolname" VARCHAR,
  "year" BIGINT,
  "places" BIGINT,
  "placeallocated" BIGINT,
  "placerefused" BIGINT,
  "placewithdrawn" BIGINT,
  "withdrawnfromprocess" BIGINT,
  "total" 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,
  "staff" BIGINT,
  "insidespecifiedarea" BIGINT,
  "religion" BIGINT,
  "feeder" BIGINT,
  "other" BIGINT,
  "total_1" BIGINT
);

Admissions Summary All - Secondary 2021

@ukgov.admissions_summary_all_secondary.admissions_summary_all_secondary_2021

17.36 kB
9 rows
23 columns

CREATE TABLE admissions_summary_all_secondary_2021 (
  "dfenumber" BIGINT,
  "schoolname" VARCHAR,
  "year" BIGINT,
  "places" BIGINT,
  "place_allocated" BIGINT,
  "place_refused" DOUBLE,
  "place_withdrawn" BIGINT,
  "withdrawnfromprocess" DOUBLE,
  "total" BIGINT,
  "n_1stpref" BIGINT  -- 1stPref,
  "n_2ndpref" BIGINT  -- 2ndPref,
  "n_3rdpref" BIGINT  -- 3rdPref,
  "n_4thpref" BIGINT  -- 4thPref,
  "n_5thpref" BIGINT  -- 5thPref,
  "unplaced" DOUBLE,
  "sle" BIGINT,
  "catchment" BIGINT,
  "sibling" BIGINT,
  "feeder_school" DOUBLE,
  "distance" BIGINT,
  "insidespecifiedarea" BIGINT,
  "religion" BIGINT,
  "total_1" BIGINT
);

Admissions Summary All - Secondary 2022

@ukgov.admissions_summary_all_secondary.admissions_summary_all_secondary_2022

18.06 kB
9 rows
24 columns

CREATE TABLE admissions_summary_all_secondary_2022 (
  "dfenumber" BIGINT,
  "schoolname" VARCHAR,
  "year" BIGINT,
  "places" BIGINT,
  "place_allocated" BIGINT,
  "place_refused" BIGINT,
  "place_withdrawn" BIGINT,
  "withdrawn_from_process" DOUBLE,
  "total" 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,
  "unplaced" BIGINT,
  "sle" BIGINT,
  "catchment" BIGINT,
  "sibling" BIGINT,
  "feeder_school" BIGINT,
  "distance" BIGINT,
  "inside_specified_area" BIGINT,
  "religion" BIGINT,
  "other" BIGINT,
  "total_1" BIGINT
);

Admissions Summary All - Secondary 2023

@ukgov.admissions_summary_all_secondary.admissions_summary_all_secondary_2023

18.81 kB
9 rows
25 columns

CREATE TABLE admissions_summary_all_secondary_2023 (
  "dfenumber" BIGINT,
  "schoolname" VARCHAR,
  "year" BIGINT,
  "places" BIGINT,
  "place_allocated" BIGINT,
  "place_refused" BIGINT,
  "place_withdrawn" BIGINT,
  "withdrawn_from_process" BIGINT,
  "total" 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,
  "unplaced" BIGINT,
  "sle" BIGINT,
  "catchment" BIGINT,
  "catchment_sibling" BIGINT,
  "sibling" BIGINT,
  "feeder_school" BIGINT,
  "distance" BIGINT,
  "inside_specified_area" BIGINT,
  "religion" BIGINT,
  "other" BIGINT,
  "total_1" BIGINT
);

Admissions Summary All - Secondary 2024

@ukgov.admissions_summary_all_secondary.admissions_summary_all_secondary_2024

18.35 kB
9 rows
24 columns

CREATE TABLE admissions_summary_all_secondary_2024 (
  "dfenumber" BIGINT,
  "schoolname" VARCHAR,
  "year" BIGINT,
  "places" BIGINT,
  "place_allocated" BIGINT,
  "place_refused" DOUBLE,
  "place_withdrawn" BIGINT,
  "withdrawn_from_process" BIGINT,
  "total" 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" DOUBLE,
  "sle" BIGINT,
  "catchment" BIGINT,
  "sibling" DOUBLE,
  "feeder_school" DOUBLE,
  "distance" BIGINT,
  "inside_specified_area" BIGINT,
  "religion" BIGINT,
  "other" DOUBLE,
  "total_1" BIGINT
);

Admissions Summary All - Secondary 2025

@ukgov.admissions_summary_all_secondary.admissions_summary_all_secondary_2025

20.57 kB
13 rows
27 columns

CREATE TABLE admissions_summary_all_secondary_2025 (
  "dfecode" BIGINT,
  "schoolname" VARCHAR,
  "band_name" VARCHAR,
  "places" BIGINT,
  "place_allocated" BIGINT,
  "place_refused" DOUBLE,
  "place_withdrawn" DOUBLE,
  "withdrawn_from_process" DOUBLE,
  "total" BIGINT,
  "n_1st_preference" BIGINT  -- 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,
  "non_preference" DOUBLE,
  "n_6th" DOUBLE  -- 6th,
  "total_1" BIGINT,
  "sle" DOUBLE,
  "catchment" DOUBLE,
  "sibling" DOUBLE,
  "feeder_school" DOUBLE,
  "distance" DOUBLE,
  "unplaced" DOUBLE,
  "religion" DOUBLE,
  "inside_sepcified_area" DOUBLE,
  "other" DOUBLE,
  "total_2" BIGINT
);