Single-use Plastic Carrier Bags Charge Data For England
Department for Environment, Food and Rural Affairs
@ukgov.single_use_plastic_carrier_bags_charge_data_for_england
Department for Environment, Food and Rural Affairs
@ukgov.single_use_plastic_carrier_bags_charge_data_for_england
These datasets provide the information submitted to government about single use carrier bag charging in England, including the number and proceeds of single-use plastic carrier bags issued/charged by retailers. It includes mandatory data on bags sold under the charge and voluntary data on submitted by retailers.
Publisher name: Department for Environment, Food and Rural Affairs
Last updated: 2024-09-20T04:00:08Z
CREATE TABLE single_use_plastic_carrier_bag_england_data_2016_17_to_2018_19 (
"year" VARCHAR,
"company_name" VARCHAR,
"reporting_on_a_mandatory_basis" VARCHAR,
"number_of_single_use_plastic_bags_issued" DOUBLE,
"gross_proceeds_of_charge" DOUBLE -- Gross Proceeds Of Charge (£),
"vat" VARCHAR -- VAT (£),
"costs_deducted" VARCHAR -- Costs Deducted (£),
"n__cost_of_changing_till_systems" VARCHAR -- Cost Of Changing Till Systems (£),
"cost_of_staff_communications" VARCHAR -- Cost Of Staff Communications (£),
"cost_of_customer_communications" VARCHAR -- Cost Of Customer Communications (£),
"cost_of_obtaining_advice_on_charge" VARCHAR -- Cost Of Obtaining Advice On Charge (£),
"cost_of_administering_donations" VARCHAR -- Cost Of Administering Donations (£),
"other_costs_associated_with_implementing_charge" VARCHAR -- Other Costs Associated With Implementing Charge (£),
"n__description_of_other_costs" VARCHAR -- Description Of Other Costs,
"net_proceeds_gross_less_vat_and_costs" VARCHAR -- Net Proceeds (£) (Gross Less VAT And Costs),
"use_of_net_proceeds" VARCHAR,
"other_use_of_net_proceeds" VARCHAR,
"amount_donated_to_good_causes" VARCHAR -- Amount Donated To Good Causes (£),
"good_causes_in_receipt_of_proceed_donation" VARCHAR,
"number_of_paper_bags_issued" VARCHAR,
"number_of_bags_for_life_issued" VARCHAR,
"any_other_information" VARCHAR
);CREATE TABLE single_use_plastic_carrier_bag_england_data_2016_17_to_2019_20 (
"year" VARCHAR,
"company_name" VARCHAR,
"reporting_on_a_mandatory_basis" VARCHAR,
"n__number_of_single_use_plastic_bags_issued" BIGINT -- Number Of Single Use Plastic Bags Issued,
"n__gross_proceeds_of_charge" DOUBLE -- Gross Proceeds Of Charge (£),
"vat" VARCHAR -- VAT (£),
"costs_deducted" VARCHAR -- Costs Deducted (£),
"n__cost_of_changing_till_systems" VARCHAR -- Cost Of Changing Till Systems (£),
"cost_of_staff_communications" VARCHAR -- Cost Of Staff Communications (£),
"cost_of_customer_communications" VARCHAR -- Cost Of Customer Communications (£),
"cost_of_obtaining_advice_on_charge" VARCHAR -- Cost Of Obtaining Advice On Charge (£),
"cost_of_administering_donations" VARCHAR -- Cost Of Administering Donations (£),
"other_costs_associated_with_implementing_charge" VARCHAR -- Other Costs Associated With Implementing Charge (£),
"n__description_of_other_costs" VARCHAR -- Description Of Other Costs,
"n__net_proceeds_gross_less_vat_and_costs" VARCHAR -- Net Proceeds (£) (Gross Less VAT And Costs),
"use_of_net_proceeds" VARCHAR,
"other_use_of_net_proceeds" VARCHAR,
"amount_donated_to_good_causes" VARCHAR -- Amount Donated To Good Causes (£),
"good_causes_in_receipt_of_proceed_donation" VARCHAR,
"number_of_paper_bags_issued" VARCHAR,
"number_of_bags_for_life_issued" VARCHAR,
"number_of_fabric_bags_issued" VARCHAR,
"any_other_information" VARCHAR
);CREATE TABLE single_use_plastic_carrier_bag_england_data_2016_17_to_2020_21 (
"year" VARCHAR,
"company_name" VARCHAR,
"reporting_on_a_mandatory_basis" VARCHAR,
"n__number_of_single_use_plastic_bags_issued" BIGINT -- Number Of Single Use Plastic Bags Issued,
"n__gross_proceeds_of_charge" DOUBLE -- Gross Proceeds Of Charge (£),
"vat" VARCHAR -- VAT (£),
"costs_deducted" VARCHAR -- Costs Deducted (£),
"n__cost_of_changing_till_systems" VARCHAR -- Cost Of Changing Till Systems (£),
"cost_of_staff_communications" VARCHAR -- Cost Of Staff Communications (£),
"cost_of_customer_communications" VARCHAR -- Cost Of Customer Communications (£),
"cost_of_obtaining_advice_on_charge" VARCHAR -- Cost Of Obtaining Advice On Charge (£),
"cost_of_administering_donations" VARCHAR -- Cost Of Administering Donations (£),
"other_costs_associated_with_implementing_charge" VARCHAR -- Other Costs Associated With Implementing Charge (£),
"n__description_of_other_costs" VARCHAR -- Description Of Other Costs,
"n__net_proceeds_gross_less_vat_and_costs" VARCHAR -- Net Proceeds (£) (Gross Less VAT And Costs),
"use_of_net_proceeds" VARCHAR,
"other_use_of_net_proceeds" VARCHAR,
"amount_donated_to_good_causes" VARCHAR -- Amount Donated To Good Causes (£),
"good_causes_in_receipt_of_proceed_donation" VARCHAR,
"number_of_paper_bags_issued" VARCHAR,
"number_of_bags_for_life_issued" VARCHAR,
"number_of_fabric_bags_issued" VARCHAR,
"number_of_other_bags_issued" VARCHAR,
"any_other_information" VARCHAR
);CREATE TABLE single_use_plastic_carrier_bag_england_data_2016_17_to_2021_22 (
"year" VARCHAR,
"company_name" VARCHAR,
"reporting_on_a_mandatory_basis" VARCHAR,
"n__number_of_single_use_plastic_bags_issued" BIGINT -- Number Of Single Use Plastic Bags Issued,
"n__gross_proceeds_of_charge" DOUBLE -- Gross Proceeds Of Charge (£),
"vat" VARCHAR -- VAT (£),
"costs_deducted" VARCHAR -- Costs Deducted (£),
"n__cost_of_changing_till_systems" VARCHAR -- Cost Of Changing Till Systems (£),
"cost_of_staff_communications" VARCHAR -- Cost Of Staff Communications (£),
"cost_of_customer_communications" VARCHAR -- Cost Of Customer Communications (£),
"cost_of_obtaining_advice_on_charge" VARCHAR -- Cost Of Obtaining Advice On Charge (£),
"cost_of_administering_donations" VARCHAR -- Cost Of Administering Donations (£),
"other_costs_associated_with_implementing_charge" VARCHAR -- Other Costs Associated With Implementing Charge (£),
"n__description_of_other_costs" VARCHAR -- Description Of Other Costs,
"n__net_proceeds_gross_less_vat_and_costs" VARCHAR -- Net Proceeds (£) (Gross Less VAT And Costs),
"use_of_net_proceeds" VARCHAR,
"other_use_of_net_proceeds" VARCHAR,
"amount_donated_to_good_causes" VARCHAR -- Amount Donated To Good Causes (£),
"good_causes_in_receipt_of_proceed_donation" VARCHAR,
"number_of_paper_bags_issued" VARCHAR,
"number_of_bags_for_life_issued" VARCHAR,
"number_of_fabric_bags_issued" VARCHAR,
"number_of_other_bags_issued" VARCHAR,
"any_other_information" VARCHAR
);CREATE TABLE single_use_plastic_carrier_bag_england_data_2016_17_to_2022_23 (
"year" VARCHAR,
"company_name" VARCHAR,
"reporting_on_a_mandatory_basis" VARCHAR,
"n__number_of_single_use_plastic_bags_issued" BIGINT -- Number Of Single Use Plastic Bags Issued,
"n__gross_proceeds_of_charge" DOUBLE -- Gross Proceeds Of Charge (ú),
"vat" VARCHAR -- VAT (ú),
"costs_deducted" VARCHAR -- Costs Deducted (ú),
"n__cost_of_changing_till_systems" VARCHAR -- Cost Of Changing Till Systems (ú),
"cost_of_staff_communications" VARCHAR -- Cost Of Staff Communications (ú),
"cost_of_customer_communications" VARCHAR -- Cost Of Customer Communications (ú),
"cost_of_obtaining_advice_on_charge" VARCHAR -- Cost Of Obtaining Advice On Charge (ú),
"cost_of_administering_donations" VARCHAR -- Cost Of Administering Donations (ú),
"other_costs_associated_with_implementing_charge" VARCHAR -- Other Costs Associated With Implementing Charge (ú),
"n__description_of_other_costs" VARCHAR -- Description Of Other Costs,
"n__net_proceeds_gross_less_vat_and_costs" VARCHAR -- Net Proceeds (ú) (Gross Less VAT And Costs),
"use_of_net_proceeds" VARCHAR,
"other_use_of_net_proceeds" VARCHAR,
"amount_donated_to_good_causes" VARCHAR -- Amount Donated To Good Causes (ú),
"good_causes_in_receipt_of_proceed_donation" VARCHAR,
"number_of_paper_bags_issued" VARCHAR,
"number_of_bags_for_life_issued" VARCHAR,
"number_of_fabric_bags_issued" VARCHAR,
"number_of_other_bags_issued" VARCHAR,
"any_other_information" VARCHAR
);CREATE TABLE single_use_plastic_carrier_bag_england_data_2016_17_to_2023_24 (
"year" VARCHAR,
"company_name" VARCHAR,
"reporting_on_a_mandatory_basis" VARCHAR,
"n__number_of_single_use_plastic_bags_issued" BIGINT -- Number Of Single Use Plastic Bags Issued,
"n__gross_proceeds_of_charge" DOUBLE -- Gross Proceeds Of Charge (£),
"vat" VARCHAR -- VAT (£),
"costs_deducted" VARCHAR -- Costs Deducted (£),
"n__cost_of_changing_till_systems" VARCHAR -- Cost Of Changing Till Systems (£),
"cost_of_staff_communications" VARCHAR -- Cost Of Staff Communications (£),
"cost_of_customer_communications" VARCHAR -- Cost Of Customer Communications (£),
"cost_of_obtaining_advice_on_charge" VARCHAR -- Cost Of Obtaining Advice On Charge (£),
"cost_of_administering_donations" VARCHAR -- Cost Of Administering Donations (£),
"other_costs_associated_with_implementing_charge" VARCHAR -- Other Costs Associated With Implementing Charge (£),
"n__description_of_other_costs" VARCHAR -- Description Of Other Costs,
"n__net_proceeds_gross_less_vat_and_costs" VARCHAR -- Net Proceeds (£) (Gross Less VAT And Costs),
"use_of_net_proceeds" VARCHAR,
"other_use_of_net_proceeds" VARCHAR,
"amount_donated_to_good_causes" VARCHAR -- Amount Donated To Good Causes (£),
"good_causes_in_receipt_of_proceed_donation" VARCHAR,
"number_of_paper_bags_issued" VARCHAR,
"number_of_bags_for_life_issued" VARCHAR,
"number_of_fabric_bags_issued" VARCHAR,
"number_of_other_bags_issued" VARCHAR,
"any_other_information" VARCHAR
);CREATE TABLE single_use_plastic_carrier_bags_charge_data_for_england (
"company_name" VARCHAR,
"n__number_of_single_use_plastic_bags_issued" DOUBLE -- Number Of Single Use Plastic Bags Issued,
"n__gross_proceeds_of_charge" DOUBLE -- Gross Proceeds Of Charge (£),
"vat" DOUBLE -- VAT (£),
"costs_deducted" VARCHAR,
"n__cost_of_changing_till_systems" VARCHAR -- Cost Of Changing Till Systems (£),
"cost_of_staff_communications" VARCHAR -- Cost Of Staff Communications (£),
"cost_of_customer_communications" VARCHAR -- Cost Of Customer Communications (£),
"cost_of_obtaining_advice_on_charge" VARCHAR -- Cost Of Obtaining Advice On Charge (£),
"cost_of_administering_donations" VARCHAR -- Cost Of Administering Donations (£),
"other_costs_associated_with_implementing_charge" VARCHAR -- Other Costs Associated With Implementing Charge (£),
"n__description_of_other_costs" VARCHAR -- Description Of Other Costs,
"net_proceeds_gross_less_vat_and_costs" DOUBLE -- Net Proceeds (£) (Gross Less VAT And Costs),
"use_of_net_proceeds" VARCHAR,
"other_use_of_net_proceeds" VARCHAR,
"amount_donated_to_good_causes" DOUBLE -- Amount Donated To Good Causes (£),
"good_causes_in_receipt_of_proceed_donation" VARCHAR,
"number_of_paper_bags_issued" VARCHAR,
"number_of_bags_for_life" VARCHAR,
"any_other_information" VARCHAR
);CREATE TABLE single_use_plastic_carrier_bags_england_2016_17_to_201_5c7ca88f (
"single_use_plastic_carrier_bags_england_2018_19_2017_1_c98298fa" VARCHAR -- Single Use Plastic Carrier Bags, England Data (2018-19, 2017-18 And 2016-17),
"unnamed_1" VARCHAR -- Unnamed: 1
);CREATE TABLE single_use_plastic_carrier_bags_england_2016_17_to_201_f624619f (
"n_1_poundland_submitted_only_their_total_number_of_sin_eced11b1" VARCHAR -- 1),Poundland Submitted Only Their Total Number Of Single-use Carrier Bags For 2017/18 So Their Gross Proceeds Have Been Estimated On The Assumption That Single-use Carrier Bags Are Charged At 5p Each,
"n__vat_estimated_at_20_of_gross_proceeds" VARCHAR -- VAT Estimated At 20% Of Gross Proceeds,
"n__and_net_proceeds_estimated_as_the_esitmated_gross_p_97da1cb5" VARCHAR -- And Net Proceeds Estimated As The Esitmated Gross Proceeds Minus Estimated VAT.
);CREATE TABLE single_use_plastic_carrier_bags_england_2016_17_to_202_1b5fee68 (
"n_1_poundland_submitted_only_their_total_number_of_sin_eced11b1" VARCHAR -- 1),Poundland Submitted Only Their Total Number Of Single-use Carrier Bags For 2017/18 So Their Gross Proceeds Have Been Estimated On The Assumption That Single-use Carrier Bags Are Charged At 5p Each,
"n__vat_estimated_at_20_of_gross_proceeds" VARCHAR -- VAT Estimated At 20% Of Gross Proceeds,
"n__and_net_proceeds_estimated_as_the_esitmated_gross_p_97da1cb5" VARCHAR -- And Net Proceeds Estimated As The Esitmated Gross Proceeds Minus Estimated VAT.
);CREATE TABLE single_use_plastic_carrier_bags_england_2016_17_to_202_76a5e89d (
"n_1_poundland_submitted_only_their_total_number_of_sin_eced11b1" VARCHAR -- 1),Poundland Submitted Only Their Total Number Of Single-use Carrier Bags For 2017/18 So Their Gross Proceeds Have Been Estimated On The Assumption That Single-use Carrier Bags Are Charged At 5p Each,
"n__vat_estimated_at_20_of_gross_proceeds" VARCHAR -- VAT Estimated At 20% Of Gross Proceeds,
"n__and_net_proceeds_estimated_as_the_esitmated_gross_p_97da1cb5" VARCHAR -- And Net Proceeds Estimated As The Esitmated Gross Proceeds Minus Estimated VAT.
);CREATE TABLE single_use_plastic_carrier_bags_england_2016_17_to_202_c7fe6d33 (
"n_1_poundland_submitted_only_their_total_number_of_sin_eced11b1" VARCHAR -- 1),Poundland Submitted Only Their Total Number Of Single-use Carrier Bags For 2017/18 So Their Gross Proceeds Have Been Estimated On The Assumption That Single-use Carrier Bags Are Charged At 5p Each,
"n__vat_estimated_at_20_of_gross_proceeds" VARCHAR -- VAT Estimated At 20% Of Gross Proceeds,
"n__and_net_proceeds_estimated_as_the_esitmated_gross_p_97da1cb5" VARCHAR -- And Net Proceeds Estimated As The Esitmated Gross Proceeds Minus Estimated VAT.
);CREATE TABLE single_use_plastic_carrier_bags_england_2016_17_to_202_ca6df0dc (
"n_1_poundland_submitted_only_their_total_number_of_sin_eced11b1" VARCHAR -- 1),Poundland Submitted Only Their Total Number Of Single-use Carrier Bags For 2017/18 So Their Gross Proceeds Have Been Estimated On The Assumption That Single-use Carrier Bags Are Charged At 5p Each,
"n__vat_estimated_at_20_of_gross_proceeds" VARCHAR -- VAT Estimated At 20% Of Gross Proceeds,
"n__and_net_proceeds_estimated_as_the_esitmated_gross_p_97da1cb5" VARCHAR -- And Net Proceeds Estimated As The Esitmated Gross Proceeds Minus Estimated VAT.
);Anyone who has the link will be able to view this.