About this Dataset

School Level Data For All Preferences In Junior Admissions Rounds

This dataset contains details of all 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 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

Tables

Admissions Summary All - Junior 2015

@ukgov.admissions_summary_all_junior.admissions_summary_all_junior_2015

17.22 kB
2 rows
24 columns

CREATE TABLE admissions_summary_all_junior_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 - Junior 2016

@ukgov.admissions_summary_all_junior.admissions_summary_all_junior_2016

17.31 kB
2 rows
24 columns

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

Admissions Summary All - Junior 2017

@ukgov.admissions_summary_all_junior.admissions_summary_all_junior_2017

17.29 kB
2 rows
24 columns

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

Admissions Summary All - Junior 2018

@ukgov.admissions_summary_all_junior.admissions_summary_all_junior_2018

17.32 kB
2 rows
24 columns

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

Admissions Summary All - Junior 2019

@ukgov.admissions_summary_all_junior.admissions_summary_all_junior_2019

17.3 kB
2 rows
24 columns

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

Admissions Summary All - Junior 2020

@ukgov.admissions_summary_all_junior.admissions_summary_all_junior_2020

17.29 kB
2 rows
24 columns

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

Admissions Summary All - Junior 2021

@ukgov.admissions_summary_all_junior.admissions_summary_all_junior_2021

16.52 kB
2 rows
23 columns

CREATE TABLE admissions_summary_all_junior_2021 (
  "dfenumber" BIGINT,
  "schoolname" VARCHAR,
  "year" BIGINT,
  "places" BIGINT,
  "place_allocated" BIGINT,
  "placerefused" BIGINT,
  "placewithdrawn" 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,
  "feederschool" BIGINT,
  "other" BIGINT,
  "total" BIGINT
);

Admissions Summary All - Junior 2022

@ukgov.admissions_summary_all_junior.admissions_summary_all_junior_2022

17.21 kB
2 rows
24 columns

CREATE TABLE admissions_summary_all_junior_2022 (
  "dfe_number" BIGINT,
  "schoolname" VARCHAR,
  "year" BIGINT,
  "places" BIGINT,
  "place_allocated" BIGINT,
  "placerefused" BIGINT,
  "place_withdrawn" BIGINT,
  "n_1st_preference" BIGINT  -- 1st Preference,
  "n_2nd_preference" BIGINT  -- 2nd Preference,
  "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_school" BIGINT,
  "other" BIGINT,
  "total" BIGINT,
  "unnamed_23" VARCHAR  -- Unnamed: 23
);

Admissions Summary All - Junior 2023

@ukgov.admissions_summary_all_junior.admissions_summary_all_junior_2023

16.68 kB
2 rows
23 columns

CREATE TABLE admissions_summary_all_junior_2023 (
  "dfe_number" BIGINT,
  "schoolname" VARCHAR,
  "year" BIGINT,
  "places" BIGINT,
  "place_allocated" BIGINT,
  "placerefused" BIGINT,
  "place_withdrawn" BIGINT,
  "n_1st_preference" BIGINT  -- 1st Preference,
  "n_2nd_preference" BIGINT  -- 2nd Preference,
  "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_school" BIGINT,
  "other" BIGINT,
  "total" BIGINT
);

Admissions Summary All - Junior 2024

@ukgov.admissions_summary_all_junior.admissions_summary_all_junior_2024

11.87 kB
2 rows
16 columns

CREATE TABLE admissions_summary_all_junior_2024 (
  "sch_code" BIGINT,
  "school_name" VARCHAR,
  "year" BIGINT,
  "places" BIGINT,
  "place_allocated" BIGINT,
  "place_withdrawn" DOUBLE,
  "withdrawn_from_process" DOUBLE,
  "n_1st_preference" BIGINT  -- 1st Preference,
  "n_2nd_preference" DOUBLE  -- 2nd Preference,
  "sle" BIGINT,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "catchment" BIGINT,
  "sibling" BIGINT,
  "feeder_school" BIGINT,
  "distance" BIGINT,
  "total" BIGINT
);

Admissions Summary All - Junior 2025

@ukgov.admissions_summary_all_junior.admissions_summary_all_junior_2025

15.5 kB
2 rows
21 columns

CREATE TABLE admissions_summary_all_junior_2025 (
  "dfe_number" BIGINT,
  "school_name" VARCHAR,
  "year" BIGINT,
  "places" BIGINT,
  "place_allocated" BIGINT,
  "place_refused" BIGINT,
  "place_withdrawn" 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,
  "feeder_school" BIGINT,
  "total" BIGINT
);