Applicant Level Data For Primary Admissions Rounds
City of York Council
@ukgov.pupil_level_outcome_summary_primary
City of York Council
@ukgov.pupil_level_outcome_summary_primary
CREATE TABLE plos_primary_2012 (
"allocated" DOUBLE,
"n_1stpref" DOUBLE,
"n_2ndpref" DOUBLE,
"n_3rdpref" DOUBLE,
"n_4thpref" DOUBLE,
"n_5thpref" DOUBLE,
"catchmentname" VARCHAR,
"catchmentcode" DOUBLE,
"year" BIGINT
);
CREATE TABLE plos_primary_2013 (
"allocated" DOUBLE,
"n_1stpref" DOUBLE,
"n_2ndpref" DOUBLE,
"n_3rdpref" DOUBLE,
"n_4thpref" DOUBLE,
"n_5thpref" DOUBLE,
"catchmentname" VARCHAR,
"catchmentcode" DOUBLE,
"year" DOUBLE
);
CREATE TABLE plos_primary_2014 (
"allocated" DOUBLE,
"n_1stpref" DOUBLE,
"n_2ndpref" DOUBLE,
"n_3rdpref" DOUBLE,
"n_4thpref" DOUBLE,
"n_5thpref" DOUBLE,
"catchmentname" VARCHAR,
"catchmentcode" DOUBLE,
"year" BIGINT
);
CREATE TABLE plos_primary_2015 (
"allocated" DOUBLE,
"n_1stpref" DOUBLE,
"n_2ndpref" DOUBLE,
"n_3rdpref" DOUBLE,
"n_4thpref" DOUBLE,
"n_5thpref" DOUBLE,
"catchmentname" VARCHAR,
"catchmentcode" DOUBLE,
"year" BIGINT
);
CREATE TABLE plos_primary_2016 (
"allocated" DOUBLE,
"n_1stpref" DOUBLE,
"n_2ndpref" DOUBLE,
"n_3rdpref" DOUBLE,
"n_4thpref" DOUBLE,
"n_5thpref" DOUBLE,
"catchmentname" VARCHAR,
"catchmentcode" DOUBLE,
"year" BIGINT
);
CREATE TABLE plos_primary_2017 (
"allocated" DOUBLE,
"n_1stpref" DOUBLE,
"n_2ndpref" DOUBLE,
"n_3rdpref" DOUBLE,
"n_4thpref" DOUBLE,
"n_5thpref" DOUBLE,
"catchmentname" VARCHAR,
"catchmentcode" DOUBLE,
"year" BIGINT
);
CREATE TABLE plos_primary_2018 (
"allocated" DOUBLE,
"n_1stpref" DOUBLE,
"n_2ndpref" DOUBLE,
"n_3rdpref" DOUBLE,
"n_4thpref" DOUBLE,
"n_5thpref" DOUBLE,
"catchmentname" VARCHAR,
"catchmentcode" DOUBLE,
"year" BIGINT
);
CREATE TABLE plos_primary_2019 (
"allocated" DOUBLE,
"n_1stpref" DOUBLE,
"n_2ndpref" DOUBLE,
"n_3rdpref" DOUBLE,
"n_4thpref" DOUBLE,
"n_5thpref" DOUBLE,
"catchmentname" VARCHAR,
"catchmentcode" DOUBLE,
"year" BIGINT
);
CREATE TABLE plos_primary_2020 (
"allocated" DOUBLE,
"n_1stpref" DOUBLE,
"n_2ndpref" DOUBLE,
"n_3rdpref" DOUBLE,
"n_4thpref" DOUBLE,
"n_5thpref" DOUBLE,
"catchmentname" VARCHAR,
"catchmentcode" DOUBLE,
"year" BIGINT
);
CREATE TABLE plos_primary_2021 (
"allocated" DOUBLE,
"n_1st_pref" DOUBLE,
"n_2nd_pref" DOUBLE,
"n_3rd_pref" DOUBLE,
"n_4th_pref" DOUBLE,
"n_5th_pref" DOUBLE,
"catchmentname" VARCHAR,
"catchmentcode" DOUBLE,
"year" BIGINT
);
CREATE TABLE plos_primary_2022 (
"allocated" DOUBLE,
"n_1st_pref" DOUBLE,
"n_2nd_pref" DOUBLE,
"n_3rd_pref" DOUBLE,
"n_4th_pref" DOUBLE,
"n_5th_pref" DOUBLE,
"catchmentname" VARCHAR,
"catchmentcode" DOUBLE,
"year" BIGINT
);
CREATE TABLE plos_primary_2023 (
"allocated" DOUBLE,
"n_1st_pref" DOUBLE,
"n_2nd_pref" DOUBLE,
"n_3rd_pref" DOUBLE,
"n_4th_pref" DOUBLE,
"n_5th_pref" DOUBLE,
"catchmentname" VARCHAR,
"catchmentcode" BIGINT,
"year" BIGINT
);
CREATE TABLE plos_primary_2024 (
"allocated" DOUBLE,
"n_1st_pref" BIGINT,
"n_2nd_pref" DOUBLE,
"n_3rd_pref" VARCHAR,
"n_4th_pref" VARCHAR,
"n_5th_pref" VARCHAR,
"catch_primary" VARCHAR,
"catch_prim" DOUBLE,
"year" BIGINT
);
CREATE TABLE plos_primary_2025 (
"allocated" DOUBLE,
"n_1st_pref" DOUBLE,
"n_2nd_pref" DOUBLE,
"n_3rd_pref" DOUBLE,
"n_4th_pref" DOUBLE,
"n_5th_pref" DOUBLE,
"catchment_primary_name" VARCHAR,
"catchment_primary_code" DOUBLE,
"year" BIGINT
);
Anyone who has the link will be able to view this.