Primary School Allocations
Leeds City Council
@ukgov.primary_school_allocations
Leeds City Council
@ukgov.primary_school_allocations
CREATE TABLE september_2015_entry (
"school" VARCHAR,
"school_type" VARCHAR,
"nearest" DOUBLE,
"non_nearest" VARCHAR,
"priority_1a" DOUBLE,
"priority_1b" DOUBLE,
"priority_2" DOUBLE,
"priority_3" DOUBLE,
"priority_4" DOUBLE,
"priority_5" DOUBLE,
"sen" DOUBLE,
"ehcp_statement" DOUBLE,
"siblings" DOUBLE,
"notes" VARCHAR
);
CREATE TABLE september_2016_entry (
"schoolcode" BIGINT,
"phase" VARCHAR,
"type" VARCHAR,
"school" VARCHAR,
"addressline1" VARCHAR,
"addressline2" VARCHAR,
"addressline3" VARCHAR,
"postcode" VARCHAR,
"x_ref" VARCHAR,
"y_ref" VARCHAR,
"telephone" VARCHAR,
"email" VARCHAR,
"website" VARCHAR,
"headteacher" VARCHAR,
"area" VARCHAR,
"agerangeminimum" BIGINT,
"agerangemaximum" BIGINT,
"nearest" DOUBLE,
"non_nearest" DOUBLE,
"priority_1a" DOUBLE,
"priority_1b" DOUBLE,
"priority_2" DOUBLE,
"priority_3" VARCHAR,
"priority_4" DOUBLE,
"priority_5" DOUBLE,
"ehcp_statement" DOUBLE,
"lac" DOUBLE,
"nearest_placed" DOUBLE,
"non_nearest_placed" VARCHAR,
"placed" DOUBLE,
"sen" DOUBLE,
"siblings" DOUBLE,
"notes" VARCHAR
);
CREATE TABLE september_2018_entry (
"schoolcode" DOUBLE,
"phase" VARCHAR,
"type" VARCHAR,
"school" VARCHAR,
"nearest" DOUBLE,
"non_nearest" VARCHAR,
"priority_1a_cla" VARCHAR,
"priority_1b" DOUBLE,
"priority_2_sibling" DOUBLE,
"priority_3_infant_junior_link" VARCHAR,
"priority_4_nearest" DOUBLE,
"priority_5_non_nearest" DOUBLE,
"ehcp" VARCHAR,
"number_admitted_agreed_admission_number" VARCHAR
);
CREATE TABLE september_2019_entry (
"schoolcode" BIGINT,
"phase" VARCHAR,
"type" VARCHAR,
"school" VARCHAR,
"addressline1" VARCHAR,
"addressline2" VARCHAR,
"addressline3" VARCHAR,
"postcode" VARCHAR,
"telephone" VARCHAR,
"email" VARCHAR,
"website" VARCHAR,
"area" VARCHAR,
"agerangeminimum" BIGINT,
"agerangemaximum" BIGINT,
"reception_19_20_furthest_distance_in_miles" VARCHAR,
"last_criteria_admitted" VARCHAR,
"ehcp" DOUBLE,
"priority_1a_cla" DOUBLE,
"priority_1b" DOUBLE,
"priority_2" DOUBLE,
"priority_3" DOUBLE,
"priority_4" DOUBLE,
"priority_5" DOUBLE,
"total_allocated_places_available" VARCHAR,
"published_admission_number" BIGINT,
"ab" VARCHAR,
"ac" VARCHAR,
"x_ref" DOUBLE,
"y_ref" DOUBLE
);
CREATE TABLE september_2021_entry (
"unnamed_0" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"n_2021_allocation_for_reception_and_junior_school_plac_3ff2251a" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR
);
Anyone who has the link will be able to view this.