About this Dataset

School Level Data For Allocated Preferences In Secondary Admissions Rounds

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

Tables

Admissions Summary Allocated - Secondary 2012

@ukgov.admissions_summary_allocated_secondary.admissions_summary_allocated_secondary_2012

15.49 kB
9 rows
21 columns

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

Admissions Summary Allocated - Secondary 2013

@ukgov.admissions_summary_allocated_secondary.admissions_summary_allocated_secondary_2013

15.51 kB
9 rows
21 columns

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

Admissions Summary Allocated - Secondary 2014

@ukgov.admissions_summary_allocated_secondary.admissions_summary_allocated_secondary_2014

15.61 kB
11 rows
21 columns

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

Admissions Summary Allocated - Secondary 2015

@ukgov.admissions_summary_allocated_secondary.admissions_summary_allocated_secondary_2015

15.64 kB
11 rows
21 columns

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

Admissions Summary Allocated - Secondary 2016

@ukgov.admissions_summary_allocated_secondary.admissions_summary_allocated_secondary_2016

15.6 kB
9 rows
21 columns

CREATE TABLE admissions_summary_allocated_secondary_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" BIGINT,
  "sibling" BIGINT,
  "distance" BIGINT,
  "outsidespecifiedarea" BIGINT,
  "insidespecifiedarea" BIGINT,
  "religion" BIGINT,
  "feeder" BIGINT,
  "other" BIGINT,
  "total" BIGINT
);

Admissions Summary Allocated - Secondary 2017

@ukgov.admissions_summary_allocated_secondary.admissions_summary_allocated_secondary_2017

15.6 kB
9 rows
21 columns

CREATE TABLE admissions_summary_allocated_secondary_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" BIGINT,
  "sibling" BIGINT,
  "distance" BIGINT,
  "outsidespecifiedarea" BIGINT,
  "insidespecifiedarea" BIGINT,
  "religion" BIGINT,
  "feeder" BIGINT,
  "other" BIGINT,
  "total" BIGINT
);

Admissions Summary Allocated - Secondary 2018

@ukgov.admissions_summary_allocated_secondary.admissions_summary_allocated_secondary_2018

15.64 kB
9 rows
21 columns

CREATE TABLE admissions_summary_allocated_secondary_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" BIGINT,
  "sibling" BIGINT,
  "distance" BIGINT,
  "outsidespecifiedarea" DOUBLE,
  "insidespecifiedarea" BIGINT,
  "religion" BIGINT,
  "feeder" BIGINT,
  "other" BIGINT,
  "total" BIGINT
);

Admissions Summary Allocated - Secondary 2019

@ukgov.admissions_summary_allocated_secondary.admissions_summary_allocated_secondary_2019

15.62 kB
9 rows
21 columns

CREATE TABLE admissions_summary_allocated_secondary_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" BIGINT,
  "sibling" BIGINT,
  "distance" BIGINT,
  "outsidespecifiedarea" BIGINT,
  "insidespecifiedarea" BIGINT,
  "religion" BIGINT,
  "feeder" BIGINT,
  "other" BIGINT,
  "total" BIGINT
);

Admissions Summary Allocated - Secondary 2020

@ukgov.admissions_summary_allocated_secondary.admissions_summary_allocated_secondary_2020

14.86 kB
9 rows
20 columns

CREATE TABLE admissions_summary_allocated_secondary_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" BIGINT,
  "sibling" BIGINT,
  "distance" BIGINT,
  "insidespecifiedarea" BIGINT,
  "religion" BIGINT,
  "feeder" BIGINT,
  "other" BIGINT,
  "total" BIGINT
);

Admissions Summary Allocated - Secondary 2021

@ukgov.admissions_summary_allocated_secondary.admissions_summary_allocated_secondary_2021

14.24 kB
9 rows
19 columns

CREATE TABLE admissions_summary_allocated_secondary_2021 (
  "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,
  "insidespecifiedarea" BIGINT,
  "religion" BIGINT,
  "feeder_school" BIGINT,
  "total" BIGINT
);

Admissions Summary Allocated - Secondary 2022

@ukgov.admissions_summary_allocated_secondary.admissions_summary_allocated_secondary_2022

14.51 kB
9 rows
19 columns

CREATE TABLE admissions_summary_allocated_secondary_2022 (
  "dfenumber" BIGINT,
  "schoolname" 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,
  "unplaced" BIGINT,
  "sle" BIGINT,
  "catchment" BIGINT,
  "sibling" BIGINT,
  "distance" BIGINT,
  "inside_specifiedarea" BIGINT,
  "religion" BIGINT,
  "feeder_school" BIGINT,
  "other" BIGINT,
  "total" BIGINT
);

Admissions Summary Allocated - Secondary 2023

@ukgov.admissions_summary_allocated_secondary.admissions_summary_allocated_secondary_2023

15.32 kB
9 rows
20 columns

CREATE TABLE admissions_summary_allocated_secondary_2023 (
  "dfenumber" BIGINT,
  "schoolname" VARCHAR,
  "year" BIGINT,
  "places" BIGINT,
  "place_allocated" BIGINT,
  "n_1st_preference" BIGINT  -- 1st Preference,
  "n_2nd_preference" BIGINT  -- 2nd Preference,
  "n_3rd_preference" DOUBLE  -- 3rd Preference,
  "n_4th_preference" BIGINT  -- 4th Preference,
  "unplaced" BIGINT,
  "sle" BIGINT,
  "catchment" BIGINT,
  "catchment_sibling" BIGINT,
  "sibling" BIGINT,
  "distance" BIGINT,
  "inside_specifiedarea" BIGINT,
  "religion" BIGINT,
  "feeder_school" BIGINT,
  "other" BIGINT,
  "total" BIGINT
);

Admissions Summary Allocated - Secondary 2024

@ukgov.admissions_summary_allocated_secondary.admissions_summary_allocated_secondary_2024

15.18 kB
9 rows
20 columns

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

Admissions Summary Allocated - Secondary 2025

@ukgov.admissions_summary_allocated_secondary.admissions_summary_allocated_secondary_2025

16.81 kB
13 rows
22 columns

CREATE TABLE admissions_summary_allocated_secondary_2025 (
  "dfenumber" BIGINT,
  "schoolname" VARCHAR,
  "band_name" VARCHAR,
  "places" BIGINT,
  "place_allocated" BIGINT,
  "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,
  "total_1" BIGINT,
  "sle" DOUBLE,
  "catchment" DOUBLE,
  "sibling" DOUBLE,
  "feeder_school" DOUBLE,
  "distance" DOUBLE,
  "religion" DOUBLE,
  "inside_specified_area" DOUBLE,
  "other" DOUBLE,
  "total_2" BIGINT
);