UK Statistics On Waste
Department for Environment, Food and Rural Affairs
@ukgov.uk_statistics_on_waste
Department for Environment, Food and Rural Affairs
@ukgov.uk_statistics_on_waste
CREATE TABLE biodegradable_municipal_waste_to_landfill_uk_and_count_fc1de854 (
"year" BIGINT,
"measure_thousand_tonnes" VARCHAR,
"uk" BIGINT,
"england" BIGINT,
"ni" BIGINT,
"scotland" BIGINT,
"wales" BIGINT
);
CREATE TABLE bmw_to_landfill_by_main_ewc_codes_uk_and_country_split_2010_22 (
"year" BIGINT,
"ewc_code" VARCHAR,
"measure_thousand_tonnes" VARCHAR,
"uk" BIGINT,
"england" BIGINT,
"ni" BIGINT,
"scotland" BIGINT,
"wales" BIGINT
);
CREATE TABLE capacity_of_permitted_final_treatment_facilities_uk_an_1c5c2175 (
"year" BIGINT,
"measure" VARCHAR,
"geographical_coverage" VARCHAR,
"energy_recovery" DOUBLE,
"incineration" DOUBLE,
"recovery_other_than_energy_recovery_includes_backfilling" DOUBLE,
"deposit_onto_or_into_land_landfill" DOUBLE
);
CREATE TABLE commercial_and_industrial_waste_uk_and_england_2010_22 (
"year" BIGINT,
"measure_million_tonnes" VARCHAR,
"uk" DOUBLE,
"england" DOUBLE
);
CREATE TABLE non_hazardous_construction_and_demolition_waste_uk_and_2ba34261 (
"year" BIGINT,
"measure_million_tonnes" VARCHAR,
"uk" DOUBLE,
"england" DOUBLE
);
CREATE TABLE notes_for_uk_statistics_on_waste_dataset_september_2024 (
"notes" 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 packaging_waste_recycling_and_recovery_by_material_uk_2012_2023 (
"year" VARCHAR,
"material" VARCHAR,
"packaging_waste_arising_thousand_tonnes" DOUBLE,
"total_recovered_recycled_thousand_tonnes" DOUBLE,
"achieved_recovery_recycling_rate" VARCHAR
);
CREATE TABLE total_generation_of_waste_by_nace_and_ewc_stat_2010_20_uk (
"year" DOUBLE,
"ewc_stat_code" VARCHAR,
"ewc_stat_description" VARCHAR,
"hazardous_non_hazardous_split" VARCHAR,
"a_agriculture_forestry_and_fishing" DOUBLE,
"b_mining_and_quarrying" DOUBLE,
"c10_c12_manufacture_of_food_products_beverages_and_tob_ff6306e2" DOUBLE,
"c13_c15_manufacture_of_textiles_wearing_apparel_leathe_c0337262" DOUBLE,
"c16_manufacture_of_wood_and_of_products_of_wood_and_co_64fd2538" DOUBLE,
"c17_c18_manufacture_of_paper_and_paper_products_printi_6d929ef4" DOUBLE,
"c19_manufacture_of_coke_and_refined_petroleum_products" DOUBLE,
"c20_c22_manufacture_of_chemical_pharmaceutical_rubber__d8be62a5" DOUBLE,
"c23_manufacture_of_other_non_metallic_mineral_products" DOUBLE,
"c24_c25_manufacture_of_basic_metals_and_fabricated_met_cb3e237e" DOUBLE,
"c26_c30_manufacture_of_computer_electronic_and_optical_c5fbdac5" DOUBLE,
"c31_c33_manufacture_of_furniture_jewellery_musical_ins_7b22c30f" DOUBLE,
"d_electricity_gas_steam_and_air_conditioning_supply" DOUBLE,
"e36_e37_e39_water_collection_treatment_and_supply_sewe_656ead62" DOUBLE,
"f_construction" DOUBLE,
"g_u_x_g4677_services_except_wholesale_of_waste_and_scrap" DOUBLE,
"ep_hh_households" DOUBLE
);
CREATE TABLE total_generation_of_waste_by_nace_and_ewc_stat_2010_22_england (
"year" BIGINT,
"ewc_stat_code" VARCHAR,
"ewc_stat_description" VARCHAR,
"hazardous_non_hazardous_split" VARCHAR,
"a_agriculture_forestry_and_fishing" DOUBLE,
"b_mining_and_quarrying" DOUBLE,
"c10_c12_manufacture_of_food_products_beverages_and_tob_ff6306e2" DOUBLE,
"c13_c15_manufacture_of_textiles_wearing_apparel_leathe_c0337262" DOUBLE,
"c16_manufacture_of_wood_and_of_products_of_wood_and_co_64fd2538" DOUBLE,
"c17_c18_manufacture_of_paper_and_paper_products_printi_6d929ef4" DOUBLE,
"c19_manufacture_of_coke_and_refined_petroleum_products" DOUBLE,
"c20_c22_manufacture_of_chemical_pharmaceutical_rubber__d8be62a5" DOUBLE,
"c23_manufacture_of_other_non_metallic_mineral_products" DOUBLE,
"c24_c25_manufacture_of_basic_metals_and_fabricated_met_cb3e237e" DOUBLE,
"c26_c30_manufacture_of_computer_electronic_and_optical_c5fbdac5" DOUBLE,
"c31_c33_manufacture_of_furniture_jewellery_musical_ins_7b22c30f" DOUBLE,
"d_electricity_gas_steam_and_air_conditioning_supply" DOUBLE,
"e36_e37_e39_water_collection_treatment_and_supply_sewe_656ead62" DOUBLE,
"f_construction" DOUBLE,
"g_u_x_g4677_services_except_wholesale_of_waste_and_scrap" DOUBLE,
"ep_hh_households" DOUBLE
);
CREATE TABLE total_waste_sent_to_final_treatment_by_ewc_stat_2010_20_uk (
"year" BIGINT,
"ewc_stat_code" VARCHAR,
"ewc_stat_description" VARCHAR,
"hazardous_non_hazardous_split" VARCHAR,
"energy_recovery" DOUBLE,
"incineration" DOUBLE,
"recovery_other_than_energy_recovery_except_backfilling" DOUBLE,
"recovery_other_than_energy_recovery_backfilling" DOUBLE,
"deposit_onto_or_into_land" DOUBLE,
"land_treatment_and_release_into_water_bodies" DOUBLE
);
CREATE TABLE total_waste_sent_to_final_treatment_by_ewc_stat_2010_22_england (
"year" BIGINT,
"ewc_stat_code" VARCHAR,
"ewc_stat_description" VARCHAR,
"hazardous_non_hazardous_split" VARCHAR,
"energy_recovery" DOUBLE,
"incineration" DOUBLE,
"recovery_other_than_energy_recovery_except_backfilling" DOUBLE,
"recovery_other_than_energy_recovery_backfilling" DOUBLE,
"deposit_onto_or_into_land" DOUBLE,
"land_treatment_and_release_into_water_bodies" DOUBLE
);
CREATE TABLE waste_from_households_uk_and_country_split_2010_2022 (
"year" BIGINT,
"measure_thousand_tonnes" VARCHAR,
"uk" BIGINT,
"england" BIGINT,
"ni" BIGINT,
"scotland" BIGINT,
"wales" BIGINT
);
Anyone who has the link will be able to view this.