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
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,
"vat" VARCHAR,
"costs_deducted" VARCHAR,
"n__cost_of_changing_till_systems" VARCHAR,
"cost_of_staff_communications" VARCHAR,
"cost_of_customer_communications" VARCHAR,
"cost_of_obtaining_advice_on_charge" VARCHAR,
"cost_of_administering_donations" VARCHAR,
"other_costs_associated_with_implementing_charge" VARCHAR,
"n__description_of_other_costs" VARCHAR,
"net_proceeds_gross_less_vat_and_costs" VARCHAR,
"use_of_net_proceeds" VARCHAR,
"other_use_of_net_proceeds" VARCHAR,
"amount_donated_to_good_causes" VARCHAR,
"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,
"n__gross_proceeds_of_charge" DOUBLE,
"vat" VARCHAR,
"costs_deducted" VARCHAR,
"n__cost_of_changing_till_systems" VARCHAR,
"cost_of_staff_communications" VARCHAR,
"cost_of_customer_communications" VARCHAR,
"cost_of_obtaining_advice_on_charge" VARCHAR,
"cost_of_administering_donations" VARCHAR,
"other_costs_associated_with_implementing_charge" VARCHAR,
"n__description_of_other_costs" VARCHAR,
"n__net_proceeds_gross_less_vat_and_costs" VARCHAR,
"use_of_net_proceeds" VARCHAR,
"other_use_of_net_proceeds" VARCHAR,
"amount_donated_to_good_causes" VARCHAR,
"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,
"n__gross_proceeds_of_charge" DOUBLE,
"vat" VARCHAR,
"costs_deducted" VARCHAR,
"n__cost_of_changing_till_systems" VARCHAR,
"cost_of_staff_communications" VARCHAR,
"cost_of_customer_communications" VARCHAR,
"cost_of_obtaining_advice_on_charge" VARCHAR,
"cost_of_administering_donations" VARCHAR,
"other_costs_associated_with_implementing_charge" VARCHAR,
"n__description_of_other_costs" VARCHAR,
"n__net_proceeds_gross_less_vat_and_costs" VARCHAR,
"use_of_net_proceeds" VARCHAR,
"other_use_of_net_proceeds" VARCHAR,
"amount_donated_to_good_causes" VARCHAR,
"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,
"n__gross_proceeds_of_charge" DOUBLE,
"vat" VARCHAR,
"costs_deducted" VARCHAR,
"n__cost_of_changing_till_systems" VARCHAR,
"cost_of_staff_communications" VARCHAR,
"cost_of_customer_communications" VARCHAR,
"cost_of_obtaining_advice_on_charge" VARCHAR,
"cost_of_administering_donations" VARCHAR,
"other_costs_associated_with_implementing_charge" VARCHAR,
"n__description_of_other_costs" VARCHAR,
"n__net_proceeds_gross_less_vat_and_costs" VARCHAR,
"use_of_net_proceeds" VARCHAR,
"other_use_of_net_proceeds" VARCHAR,
"amount_donated_to_good_causes" VARCHAR,
"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,
"n__gross_proceeds_of_charge" DOUBLE,
"vat" VARCHAR,
"costs_deducted" VARCHAR,
"n__cost_of_changing_till_systems" VARCHAR,
"cost_of_staff_communications" VARCHAR,
"cost_of_customer_communications" VARCHAR,
"cost_of_obtaining_advice_on_charge" VARCHAR,
"cost_of_administering_donations" VARCHAR,
"other_costs_associated_with_implementing_charge" VARCHAR,
"n__description_of_other_costs" VARCHAR,
"n__net_proceeds_gross_less_vat_and_costs" VARCHAR,
"use_of_net_proceeds" VARCHAR,
"other_use_of_net_proceeds" VARCHAR,
"amount_donated_to_good_causes" VARCHAR,
"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,
"n__gross_proceeds_of_charge" DOUBLE,
"vat" VARCHAR,
"costs_deducted" VARCHAR,
"n__cost_of_changing_till_systems" VARCHAR,
"cost_of_staff_communications" VARCHAR,
"cost_of_customer_communications" VARCHAR,
"cost_of_obtaining_advice_on_charge" VARCHAR,
"cost_of_administering_donations" VARCHAR,
"other_costs_associated_with_implementing_charge" VARCHAR,
"n__description_of_other_costs" VARCHAR,
"n__net_proceeds_gross_less_vat_and_costs" VARCHAR,
"use_of_net_proceeds" VARCHAR,
"other_use_of_net_proceeds" VARCHAR,
"amount_donated_to_good_causes" VARCHAR,
"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,
"n__gross_proceeds_of_charge" DOUBLE,
"vat" DOUBLE,
"costs_deducted" VARCHAR,
"n__cost_of_changing_till_systems" VARCHAR,
"cost_of_staff_communications" VARCHAR,
"cost_of_customer_communications" VARCHAR,
"cost_of_obtaining_advice_on_charge" VARCHAR,
"cost_of_administering_donations" VARCHAR,
"other_costs_associated_with_implementing_charge" VARCHAR,
"n__description_of_other_costs" VARCHAR,
"net_proceeds_gross_less_vat_and_costs" DOUBLE,
"use_of_net_proceeds" VARCHAR,
"other_use_of_net_proceeds" VARCHAR,
"amount_donated_to_good_causes" DOUBLE,
"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,
"unnamed_1" VARCHAR
);
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,
"n__vat_estimated_at_20_of_gross_proceeds" VARCHAR,
"n__and_net_proceeds_estimated_as_the_esitmated_gross_p_97da1cb5" VARCHAR
);
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,
"n__vat_estimated_at_20_of_gross_proceeds" VARCHAR,
"n__and_net_proceeds_estimated_as_the_esitmated_gross_p_97da1cb5" VARCHAR
);
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,
"n__vat_estimated_at_20_of_gross_proceeds" VARCHAR,
"n__and_net_proceeds_estimated_as_the_esitmated_gross_p_97da1cb5" VARCHAR
);
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,
"n__vat_estimated_at_20_of_gross_proceeds" VARCHAR,
"n__and_net_proceeds_estimated_as_the_esitmated_gross_p_97da1cb5" VARCHAR
);
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,
"n__vat_estimated_at_20_of_gross_proceeds" VARCHAR,
"n__and_net_proceeds_estimated_as_the_esitmated_gross_p_97da1cb5" VARCHAR
);
Anyone who has the link will be able to view this.