Leeds Schools All Information
Leeds City Council
@ukgov.leeds_schools_all_information
Leeds City Council
@ukgov.leeds_schools_all_information
CREATE TABLE n_25_06_2015 (
"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,
"numberofpupils" BIGINT,
"numberofplacesavailable" BIGINT,
"area" VARCHAR,
"agerangeminimum" BIGINT,
"agerangemaximum" BIGINT,
"nearest" DOUBLE,
"non_nearest" DOUBLE,
"priority_1a" DOUBLE,
"priority_1b" DOUBLE,
"priority_2" DOUBLE,
"priority_3" DOUBLE,
"priority_4" DOUBLE,
"priority_5" DOUBLE,
"allocated" VARCHAR,
"ehcp_statement" DOUBLE,
"lac" DOUBLE,
"nearest_placed" DOUBLE,
"non_nearest_placed" DOUBLE,
"placed" DOUBLE,
"sen" DOUBLE,
"siblings" DOUBLE,
"notes" VARCHAR,
"better_access" DOUBLE,
"breakfast_club" DOUBLE,
"childrens_centre" DOUBLE,
"cycle_storage" DOUBLE,
"designated_school_bus" DOUBLE,
"free_foundation_education" DOUBLE,
"fully_integrated_early_education" DOUBLE,
"out_of_school_care" DOUBLE,
"parents_waiting_shelter" DOUBLE,
"reduction_in_car_travel" DOUBLE,
"road_safety_training" DOUBLE,
"safe_route_to_school" DOUBLE,
"school_crossing_patrol" DOUBLE,
"school_travel_plan" DOUBLE,
"sif_required" DOUBLE,
"special_needs" DOUBLE,
"walking_initiative" DOUBLE,
"yellow_bus" DOUBLE
);
CREATE TABLE n_29_04_2016 (
"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" DOUBLE,
"placed" DOUBLE,
"sen" DOUBLE,
"siblings" DOUBLE,
"notes" VARCHAR
);
Anyone who has the link will be able to view this.