Housing Land Supply In Leeds
Leeds City Council
@ukgov.housing_land_supply_in_leeds
Leeds City Council
@ukgov.housing_land_supply_in_leeds
CREATE TABLE n_01_03_2015 (
"housing_land_monitor_site_schedule" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" 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
);
CREATE TABLE n_30_06_2017 (
"site_ref" BIGINT,
"type" VARCHAR,
"planning_ref" VARCHAR,
"shlaa_ref" VARCHAR,
"location" VARCHAR,
"status" VARCHAR,
"site_area" DOUBLE,
"capacity" BIGINT,
"outline" BIGINT,
"detailed" BIGINT,
"pp_units" BIGINT,
"started" BIGINT,
"complete" BIGINT,
"under_construction" BIGINT,
"not_yet_started" BIGINT,
"identified_date" BIGINT,
"outline_date" DOUBLE,
"detailed_date" DOUBLE,
"first_pp_date" DOUBLE,
"expiry_pp_date" DOUBLE,
"start_date" DOUBLE,
"completion_date" DOUBLE,
"owner" VARCHAR,
"applicant" VARCHAR,
"n_2004_ward" VARCHAR,
"n_1_bed_flat" DOUBLE,
"n_2_bed_flat" DOUBLE,
"n_3_bed_flat" DOUBLE,
"mix_flat" DOUBLE,
"n_1_bed_house" DOUBLE,
"n_2_bed_house" DOUBLE,
"n_3_bed_house" DOUBLE,
"n_4_bed_house" DOUBLE,
"n_5_bed_house" DOUBLE,
"mix_house" DOUBLE,
"brownfield" VARCHAR,
"adopted_udp_policy" VARCHAR,
"post_code_sector" VARCHAR,
"core_strategy_zone" VARCHAR,
"x" BIGINT,
"y" BIGINT
);
CREATE TABLE n_30_06_2018 (
"housing_land_availability_current_sites_and_completed__a4a6708e" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" 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,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"unnamed_29" VARCHAR,
"unnamed_30" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"unnamed_38" VARCHAR,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR,
"unnamed_41" VARCHAR,
"unnamed_42" VARCHAR,
"unnamed_43" VARCHAR,
"unnamed_44" VARCHAR,
"unnamed_45" VARCHAR,
"unnamed_46" VARCHAR,
"unnamed_47" VARCHAR,
"unnamed_48" VARCHAR,
"unnamed_49" VARCHAR,
"unnamed_50" VARCHAR,
"unnamed_51" VARCHAR,
"unnamed_52" VARCHAR,
"unnamed_53" VARCHAR,
"unnamed_54" VARCHAR,
"unnamed_55" VARCHAR
);
CREATE TABLE n_30_06_2019 (
"housing_land_availability_current_sites_and_completed__8d3e41d3" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" 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,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"unnamed_29" VARCHAR,
"unnamed_30" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"unnamed_38" VARCHAR,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR,
"unnamed_41" VARCHAR,
"unnamed_42" VARCHAR,
"unnamed_43" VARCHAR,
"unnamed_44" VARCHAR,
"unnamed_45" VARCHAR,
"unnamed_46" VARCHAR,
"unnamed_47" VARCHAR,
"unnamed_48" VARCHAR,
"unnamed_49" VARCHAR,
"unnamed_50" VARCHAR,
"unnamed_51" VARCHAR,
"unnamed_52" VARCHAR,
"unnamed_53" VARCHAR,
"unnamed_54" VARCHAR,
"unnamed_55" VARCHAR
);
CREATE TABLE n_30_09_2015 (
"site" VARCHAR,
"planning_ref" VARCHAR,
"udp_policy" VARCHAR,
"location" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"outstanding_capacity_at_30_september_2015" 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
);
CREATE TABLE n_30_09_2016 (
"site_ref" BIGINT,
"type" VARCHAR,
"planning_ref" VARCHAR,
"shlaa_ref" VARCHAR,
"location" VARCHAR,
"status" VARCHAR,
"site_area" DOUBLE,
"capacity" BIGINT,
"outline" BIGINT,
"detailed" BIGINT,
"pp_units" BIGINT,
"started" BIGINT,
"complete" BIGINT,
"under_construction" BIGINT,
"not_yet_started" BIGINT,
"identified_date" VARCHAR,
"outline_date" VARCHAR,
"detailed_date" VARCHAR,
"first_pp_date" VARCHAR,
"expiry_pp_date" VARCHAR,
"start_date" VARCHAR,
"completion_date" VARCHAR,
"owner" VARCHAR,
"applicant" VARCHAR,
"n_2004_ward" VARCHAR,
"n_1_bed_flat" DOUBLE,
"n_2_bed_flat" DOUBLE,
"n_3_bed_flat" DOUBLE,
"mix_flat" DOUBLE,
"n_1_bed_house" DOUBLE,
"n_2_bed_house" DOUBLE,
"n_3_bed_house" DOUBLE,
"n_4_bed_house" DOUBLE,
"n_5_bed_house" DOUBLE,
"mix_house" DOUBLE,
"brownfield" VARCHAR,
"adopted_udp_policy" VARCHAR,
"post_code_sector" VARCHAR,
"core_strategy_zone" VARCHAR,
"x" BIGINT,
"y" BIGINT
);
CREATE TABLE n_30_09_2018 (
"housing_land_availability_current_sites_and_completed__8b85f3d3" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" 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,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"unnamed_29" VARCHAR,
"unnamed_30" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"unnamed_38" VARCHAR,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR,
"unnamed_41" VARCHAR,
"unnamed_42" VARCHAR,
"unnamed_43" VARCHAR,
"unnamed_44" VARCHAR,
"unnamed_45" VARCHAR,
"unnamed_46" VARCHAR,
"unnamed_47" VARCHAR,
"unnamed_48" VARCHAR,
"unnamed_49" VARCHAR,
"unnamed_50" VARCHAR,
"unnamed_51" VARCHAR,
"unnamed_52" VARCHAR,
"unnamed_53" VARCHAR,
"unnamed_54" VARCHAR,
"unnamed_55" VARCHAR
);
CREATE TABLE n_30_09_2020 (
"housing_land_availability_current_sites_and_completed__db792da3" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" 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,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"unnamed_29" VARCHAR,
"unnamed_30" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"unnamed_38" VARCHAR,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR,
"unnamed_41" VARCHAR,
"unnamed_42" DOUBLE,
"unnamed_43" VARCHAR
);
CREATE TABLE n_31_03_2017 (
"site_ref" BIGINT,
"type" VARCHAR,
"planning_ref" VARCHAR,
"shlaa_ref" VARCHAR,
"location" VARCHAR,
"status" VARCHAR,
"site_area" DOUBLE,
"capacity" BIGINT,
"outline" BIGINT,
"detailed" BIGINT,
"pp_units" BIGINT,
"started" BIGINT,
"complete" BIGINT,
"under_construction" BIGINT,
"not_yet_started" BIGINT,
"identified_date" VARCHAR,
"outline_date" VARCHAR,
"detailed_date" VARCHAR,
"first_pp_date" VARCHAR,
"expiry_pp_date" VARCHAR,
"start_date" VARCHAR,
"completion_date" VARCHAR,
"owner" VARCHAR,
"applicant" VARCHAR,
"n_2004_ward" VARCHAR,
"n_1_bed_flat" DOUBLE,
"n_2_bed_flat" DOUBLE,
"n_3_bed_flat" DOUBLE,
"mix_flat" DOUBLE,
"n_1_bed_house" DOUBLE,
"n_2_bed_house" DOUBLE,
"n_3_bed_house" DOUBLE,
"n_4_bed_house" DOUBLE,
"n_5_bed_house" DOUBLE,
"mix_house" DOUBLE,
"brownfield" VARCHAR,
"adopted_udp_policy" VARCHAR,
"post_code_sector" VARCHAR,
"core_strategy_zone" VARCHAR,
"x" BIGINT,
"y" BIGINT
);
CREATE TABLE n_31_03_2018 (
"housing_land_availability_current_sites_and_completed__2a570be1" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" 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,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"unnamed_29" VARCHAR,
"unnamed_30" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"unnamed_38" VARCHAR,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR,
"unnamed_41" VARCHAR,
"unnamed_42" VARCHAR,
"unnamed_43" VARCHAR,
"unnamed_44" VARCHAR,
"unnamed_45" VARCHAR,
"unnamed_46" VARCHAR,
"unnamed_47" VARCHAR,
"unnamed_48" VARCHAR,
"unnamed_49" VARCHAR,
"unnamed_50" VARCHAR,
"unnamed_51" VARCHAR,
"unnamed_52" VARCHAR,
"unnamed_53" VARCHAR,
"unnamed_54" VARCHAR,
"unnamed_55" VARCHAR
);
CREATE TABLE n_31_03_2020 (
"housing_land_availability_current_sites_and_completed__a96a2dd5" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" 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,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"unnamed_29" VARCHAR,
"unnamed_30" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"unnamed_38" VARCHAR,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR,
"unnamed_41" VARCHAR,
"unnamed_42" VARCHAR,
"unnamed_43" VARCHAR
);
CREATE TABLE n_31_12_2018 (
"housing_land_availability_current_sites_and_completed__643ad69b" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" 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,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"unnamed_29" VARCHAR,
"unnamed_30" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"unnamed_38" VARCHAR,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR,
"unnamed_41" VARCHAR,
"unnamed_42" VARCHAR,
"unnamed_43" VARCHAR,
"unnamed_44" VARCHAR,
"unnamed_45" VARCHAR,
"unnamed_46" VARCHAR,
"unnamed_47" VARCHAR,
"unnamed_48" VARCHAR,
"unnamed_49" VARCHAR,
"unnamed_50" VARCHAR,
"unnamed_51" VARCHAR,
"unnamed_52" VARCHAR,
"unnamed_53" VARCHAR,
"unnamed_54" VARCHAR,
"unnamed_55" VARCHAR
);
Anyone who has the link will be able to view this.