Fly-tipping In England
Department for Environment, Food and Rural Affairs
@ukgov.fly_tipping_in_england
Department for Environment, Food and Rural Affairs
@ukgov.fly_tipping_in_england
CREATE TABLE fly_tipping_in_england (
"title" VARCHAR,
"fly_tipping_incidents_and_actions_reported_by_local_au_c32c0f02" 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
);
CREATE TABLE la_fly_tipping_league_table_data_2021_22_to_2022_23 (
"year" VARCHAR,
"ons_code" VARCHAR,
"la_name" VARCHAR,
"region" VARCHAR,
"total_incidents" BIGINT,
"total_actions" BIGINT,
"total_fixed_penalty_notice_actions" BIGINT,
"prosecution_actions" BIGINT,
"fpns_per_incident" VARCHAR,
"rank_fpn_per_incidents" VARCHAR,
"rank_fpn" BIGINT
);
CREATE TABLE local_authority_fly_tipping_actions_2012_13_to_2023_24 (
"fly_tipping_actions_reported_by_local_authorities_in_england" 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
);
CREATE TABLE local_authority_fly_tipping_incidents_2012_13_to_2023_24 (
"fly_tipping_incidents_reported_by_local_authorities_in_england" 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
);
CREATE TABLE national_fly_tipping_actions_costs_2007_08_to_2023_24 (
"actions_cost" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR
);
CREATE TABLE national_fly_tipping_actions_fines_2007_08_to_2023_24 (
"actions_fines_issued_by_courts" 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
);
CREATE TABLE national_fly_tipping_actions_outcome_2007_08_to_2023_24 (
"actions_outcome" 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
);
CREATE TABLE national_fly_tipping_actions_type_2007_08_to_2023_24 (
"actions_type" 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
);
CREATE TABLE national_fly_tipping_fixed_penalty_notice_fpn_breakdow_b9db0079 (
"actions_fixed_penalty_notice_breakdown" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR
);
CREATE TABLE national_fly_tipping_incidents_land_type_2007_08_to_2023_24 (
"incidents_land_type" 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
);
CREATE TABLE national_fly_tipping_incidents_size_2007_08_to_2023_24 (
"incidents_size" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR
);
CREATE TABLE national_fly_tipping_incidents_waste_type_2007_08_to_2023_24 (
"incidents_waste_type" 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
);
Anyone who has the link will be able to view this.