Secondary School Allocations
Leeds City Council
@ukgov.secondary_school_allocations
Leeds City Council
@ukgov.secondary_school_allocations
CREATE TABLE september_2014_entry (
"school" VARCHAR,
"school_type" VARCHAR,
"nearest_school" DOUBLE,
"other_schools" VARCHAR,
"additional_information" VARCHAR,
"unnamed_5" VARCHAR
);
CREATE TABLE september_2016_entry (
"n_5400" BIGINT,
"secondary" VARCHAR,
"academy" VARCHAR,
"abbey_grange_church_of_england" VARCHAR,
"butcher_hill" VARCHAR,
"unnamed_5" VARCHAR,
"leeds" VARCHAR,
"ls16_5ea" VARCHAR,
"n_425647" BIGINT,
"n_437660" BIGINT,
"n_0113_275_7877" VARCHAR,
"info_abbeygrangeacademy_co_uk" VARCHAR,
"http_www_abbeygrangeschool_co_uk" VARCHAR,
"ms_c_kitson" VARCHAR,
"nw" VARCHAR,
"n_11" BIGINT,
"n_18" BIGINT,
"unnamed_17" DOUBLE,
"unnamed_18" DOUBLE,
"unnamed_19" DOUBLE,
"unnamed_20" VARCHAR,
"unnamed_21" DOUBLE,
"unnamed_22" VARCHAR,
"unnamed_23" DOUBLE,
"unnamed_24" DOUBLE,
"unnamed_25" DOUBLE,
"unnamed_26" DOUBLE,
"unnamed_27" DOUBLE,
"unnamed_28" DOUBLE,
"unnamed_29" DOUBLE,
"unnamed_30" DOUBLE,
"unnamed_31" DOUBLE
);
CREATE TABLE september_2017_entry (
"school_name" VARCHAR,
"school_type" VARCHAR,
"priority" VARCHAR,
"non_priority" VARCHAR,
"sen" VARCHAR,
"lac" DOUBLE,
"siblings" DOUBLE,
"placed" DOUBLE,
"priority_1" DOUBLE,
"non_priority_1" DOUBLE,
"allocated" VARCHAR,
"notes" VARCHAR
);
CREATE TABLE september_2019_entry (
"schoolcode" DOUBLE,
"phase" VARCHAR,
"type" VARCHAR,
"school" VARCHAR,
"addressline1" VARCHAR,
"addressline2" VARCHAR,
"addressline3" VARCHAR,
"postcode" VARCHAR,
"x_ref" DOUBLE,
"y_ref" DOUBLE,
"telephone" VARCHAR,
"email" VARCHAR,
"website" VARCHAR,
"area" VARCHAR,
"agerangeminimum" DOUBLE,
"agerangemaximum" DOUBLE,
"nearest" VARCHAR,
"non_nearest" VARCHAR,
"ehcp" DOUBLE,
"priority_1a_cla" DOUBLE,
"priority_1b" DOUBLE,
"priority_2" DOUBLE,
"priority_3" DOUBLE,
"priority_4" DOUBLE,
"priority_5" DOUBLE,
"priority_6" VARCHAR,
"priority_7" VARCHAR,
"total_allocated_places_available" VARCHAR,
"published_admission_number" VARCHAR,
"unnamed_29" VARCHAR,
"unnamed_30" VARCHAR
);
CREATE TABLE september_2021_entry (
"schoolcode" DOUBLE,
"phase" VARCHAR,
"type" VARCHAR,
"school" VARCHAR,
"addressline1" VARCHAR,
"addressline2" VARCHAR,
"addressline3" VARCHAR,
"postcode" VARCHAR,
"x_ref" DOUBLE,
"y_ref" DOUBLE,
"telephone" VARCHAR,
"email" VARCHAR,
"website" VARCHAR,
"area" VARCHAR,
"agerangeminimum" DOUBLE,
"agerangemaximum" DOUBLE,
"catchment" VARCHAR,
"non_catchment" VARCHAR,
"ehcp" DOUBLE,
"priority_1a_cla" DOUBLE,
"priority_1b" DOUBLE,
"priority_2" DOUBLE,
"priority_3" DOUBLE,
"priority_4" DOUBLE,
"total_allocated_places_available" VARCHAR,
"published_admission_number" DOUBLE,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR
);
Anyone who has the link will be able to view this.