UK Statistics On Waste

CREATE TABLE biodegradable_municipal_waste_to_landfill_uk_and_count_fc1de854 (
  "year" BIGINT,
  "measure_thousand_tonnes" VARCHAR  -- Measure (thousand Tonnes),
  "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  -- Measure (thousand Tonnes),
  "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  -- Recovery Other Than Energy Recovery (includes Backfilling),
  "deposit_onto_or_into_land_landfill" DOUBLE  -- Deposit Onto Or Into Land (landfill)
);

CREATE TABLE commercial_and_industrial_waste_uk_and_england_2010_22 (
  "year" BIGINT,
  "measure_million_tonnes" VARCHAR  -- Measure (million Tonnes),
  "uk" DOUBLE,
  "england" DOUBLE
);

CREATE TABLE non_hazardous_construction_and_demolition_waste_uk_and_2ba34261 (
  "year" BIGINT,
  "measure_million_tonnes" VARCHAR  -- Measure (million Tonnes),
  "uk" DOUBLE,
  "england" DOUBLE
);

CREATE TABLE notes_for_uk_statistics_on_waste_dataset_september_2024 (
  "notes" VARCHAR,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9
);

CREATE TABLE packaging_waste_recycling_and_recovery_by_material_uk_2012_2023 (
  "year" VARCHAR,
  "material" VARCHAR,
  "packaging_waste_arising_thousand_tonnes" DOUBLE  -- Packaging Waste Arising (thousand Tonnes),
  "total_recovered_recycled_thousand_tonnes" DOUBLE  -- Total Recovered / Recycled (thousand Tonnes),
  "achieved_recovery_recycling_rate" VARCHAR  -- Achieved Recovery / Recycling Rate (%)
);

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  -- A: Agriculture, Forestry And Fishing,
  "b_mining_and_quarrying" DOUBLE  -- B: Mining And Quarrying,
  "c10_c12_manufacture_of_food_products_beverages_and_tob_ff6306e2" DOUBLE  -- C10-C12: Manufacture Of Food Products, Beverages And Tobacco Products,
  "c13_c15_manufacture_of_textiles_wearing_apparel_leathe_c0337262" DOUBLE  -- C13-C15: Manufacture Of Textiles, Wearing Apparel, Leather And Related Products,
  "c16_manufacture_of_wood_and_of_products_of_wood_and_co_64fd2538" DOUBLE  -- C16: Manufacture Of Wood And Of Products Of Wood And Cork, Except Furniture, Manufacture Of Articles Of Straw And Plaiting Materials,
  "c17_c18_manufacture_of_paper_and_paper_products_printi_6d929ef4" DOUBLE  -- C17 C18: Manufacture Of Paper And Paper Products, Printing And Reproduction Or Recorded Media,
  "c19_manufacture_of_coke_and_refined_petroleum_products" DOUBLE  -- C19: Manufacture Of Coke And Refined Petroleum Products,
  "c20_c22_manufacture_of_chemical_pharmaceutical_rubber__d8be62a5" DOUBLE  -- C20-C22: Manufacture Of Chemical, Pharmaceutical, Rubber And Plastic Products,
  "c23_manufacture_of_other_non_metallic_mineral_products" DOUBLE  -- C23: Manufacture Of Other Non-metallic Mineral Products,
  "c24_c25_manufacture_of_basic_metals_and_fabricated_met_cb3e237e" DOUBLE  -- C24 C25: Manufacture Of Basic Metals And Fabricated Metal Products, Except Machinery And Equipment,
  "c26_c30_manufacture_of_computer_electronic_and_optical_c5fbdac5" DOUBLE  -- C26-C30: Manufacture Of Computer, Electronic And Optical Products, Electrical Equipment, Motor Vehicles And Other Transport Equipment,
  "c31_c33_manufacture_of_furniture_jewellery_musical_ins_7b22c30f" DOUBLE  -- C31-C33: Manufacture Of Furniture, Jewellery, Musical Instruments, Toys, Repair And Installation Or Machinery And Equipment,
  "d_electricity_gas_steam_and_air_conditioning_supply" DOUBLE  -- D: Electricity, Gas, Steam And Air Conditioning Supply,
  "e36_e37_e39_water_collection_treatment_and_supply_sewe_656ead62" DOUBLE  -- E36 E37 E39: Water Collection, Treatment And Supply, Sewerage, Remediation Activities And Other Waste Management Services,
  "f_construction" DOUBLE  -- F: Construction,
  "g_u_x_g4677_services_except_wholesale_of_waste_and_scrap" DOUBLE  -- G-U X G4677: Services (except Wholesale Of Waste And Scrap),
  "ep_hh_households" DOUBLE  -- EP HH: Households
);

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  -- A: Agriculture, Forestry And Fishing,
  "b_mining_and_quarrying" DOUBLE  -- B: Mining And Quarrying,
  "c10_c12_manufacture_of_food_products_beverages_and_tob_ff6306e2" DOUBLE  -- C10-C12: Manufacture Of Food Products, Beverages And Tobacco Products,
  "c13_c15_manufacture_of_textiles_wearing_apparel_leathe_c0337262" DOUBLE  -- C13-C15: Manufacture Of Textiles, Wearing Apparel, Leather And Related Products,
  "c16_manufacture_of_wood_and_of_products_of_wood_and_co_64fd2538" DOUBLE  -- C16: Manufacture Of Wood And Of Products Of Wood And Cork, Except Furniture, Manufacture Of Articles Of Straw And Plaiting Materials,
  "c17_c18_manufacture_of_paper_and_paper_products_printi_6d929ef4" DOUBLE  -- C17 C18: Manufacture Of Paper And Paper Products, Printing And Reproduction Or Recorded Media,
  "c19_manufacture_of_coke_and_refined_petroleum_products" DOUBLE  -- C19: Manufacture Of Coke And Refined Petroleum Products,
  "c20_c22_manufacture_of_chemical_pharmaceutical_rubber__d8be62a5" DOUBLE  -- C20-C22: Manufacture Of Chemical, Pharmaceutical, Rubber And Plastic Products,
  "c23_manufacture_of_other_non_metallic_mineral_products" DOUBLE  -- C23: Manufacture Of Other Non-metallic Mineral Products,
  "c24_c25_manufacture_of_basic_metals_and_fabricated_met_cb3e237e" DOUBLE  -- C24 C25: Manufacture Of Basic Metals And Fabricated Metal Products, Except Machinery And Equipment,
  "c26_c30_manufacture_of_computer_electronic_and_optical_c5fbdac5" DOUBLE  -- C26-C30: Manufacture Of Computer, Electronic And Optical Products, Electrical Equipment, Motor Vehicles And Other Transport Equipment,
  "c31_c33_manufacture_of_furniture_jewellery_musical_ins_7b22c30f" DOUBLE  -- C31-C33: Manufacture Of Furniture, Jewellery, Musical Instruments, Toys, Repair And Installation Or Machinery And Equipment,
  "d_electricity_gas_steam_and_air_conditioning_supply" DOUBLE  -- D: Electricity, Gas, Steam And Air Conditioning Supply,
  "e36_e37_e39_water_collection_treatment_and_supply_sewe_656ead62" DOUBLE  -- E36 E37 E39: Water Collection, Treatment And Supply, Sewerage, Remediation Activities And Other Waste Management Services,
  "f_construction" DOUBLE  -- F: Construction,
  "g_u_x_g4677_services_except_wholesale_of_waste_and_scrap" DOUBLE  -- G-U X G4677: Services (except Wholesale Of Waste And Scrap),
  "ep_hh_households" DOUBLE  -- EP HH: Households
);

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 - Except Backfilling,
  "recovery_other_than_energy_recovery_backfilling" DOUBLE  -- Recovery Other Than Energy Recovery - Backfilling,
  "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 - Except Backfilling,
  "recovery_other_than_energy_recovery_backfilling" DOUBLE  -- Recovery Other Than Energy Recovery - Backfilling,
  "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  -- Measure (thousand Tonnes),
  "uk" BIGINT,
  "england" BIGINT,
  "ni" BIGINT,
  "scotland" BIGINT,
  "wales" BIGINT
);