DWP Government Procurement Card Payments
Department for Work and Pensions
@ukgov.dwp_government_procurement_card_payments_over_500
Department for Work and Pensions
@ukgov.dwp_government_procurement_card_payments_over_500
CREATE TABLE return_for_january_2023 (
"line_number" BIGINT,
"posting_date" TIMESTAMP,
"mch_merchant_category_code_mcc" BIGINT,
"mch_merchant_name" VARCHAR,
"fin_transaction_amount" DOUBLE,
"description" VARCHAR
);
CREATE TABLE return_for_january_2024 (
"december_20th_to_january_19th_2024" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR
);
CREATE TABLE return_for_july_2019 (
"unnamed_0" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"dwp_and_cmg_spending_over_500_july_2019" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR
);
CREATE TABLE return_for_july_2020 (
"unnamed_0" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"july_2020" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR
);
CREATE TABLE return_for_july_2021 (
"line_number" DOUBLE,
"posting_date" VARCHAR,
"mch_merchant_category_code_mcc" DOUBLE,
"mch_merchant_name" VARCHAR,
"fin_transaction_amount" VARCHAR,
"description" VARCHAR
);
CREATE TABLE return_for_july_2022 (
"unnamed_0" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"may_20th_june_19th" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR
);
CREATE TABLE return_for_july_2023 (
"unnamed_0" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"june_20th_july_19th" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR
);
CREATE TABLE return_for_july_2024 (
"unnamed_0" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"a2b_july_20th_august_19th_2024" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR
);
CREATE TABLE return_for_june_2019 (
"unnamed_0" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"dwp_and_cmg_epcs_spending_over_500_for_june_2019" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR
);
CREATE TABLE return_for_june_2020 (
"unnamed_0" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"june_2020" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR
);
CREATE TABLE return_for_june_2021 (
"line_number" BIGINT,
"posting_date" VARCHAR,
"mch_merchant_category_code_mcc" BIGINT,
"mch_merchant_name" VARCHAR,
"fin_transaction_amount" VARCHAR,
"description" VARCHAR
);
CREATE TABLE return_for_june_2022 (
"line_number" BIGINT,
"posting_date" VARCHAR,
"mch_merchant_category_code_mcc" BIGINT,
"mch_merchant_name" VARCHAR,
"fin_transaction_amount" DOUBLE,
"description" VARCHAR
);
CREATE TABLE return_for_june_2023 (
"unnamed_0" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"may_20th_june_19th" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR
);
CREATE TABLE return_for_june_2024 (
"unnamed_0" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"june_20th_july_19th_2024" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR
);
CREATE TABLE return_for_march_2019 (
"mch_merchant_category_code_mcc" BIGINT,
"mch_merchant_name" VARCHAR,
"fin_transaction_amount" VARCHAR,
"description" VARCHAR
);
CREATE TABLE return_for_march_2020 (
"unnamed_0" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"march_2020" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR
);
CREATE TABLE return_for_march_2021 (
"unnamed_0" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"march_2021" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR
);
CREATE TABLE return_for_march_2022 (
"line_number" DOUBLE,
"posting_date" TIMESTAMP,
"mch_merchant_category_code_mcc" DOUBLE,
"mch_merchant_name" VARCHAR,
"fin_transaction_amount" VARCHAR,
"description" VARCHAR
);
CREATE TABLE return_for_march_2023 (
"unnamed_0" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"feb_20th_march_19th" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR
);
CREATE TABLE return_for_may_2019 (
"line_number" BIGINT,
"posting_date" TIMESTAMP,
"mch_merchant_category_code_mcc" BIGINT,
"mch_merchant_name" VARCHAR,
"fin_transaction_amount" VARCHAR,
"description" VARCHAR
);
CREATE TABLE return_for_may_2020 (
"unnamed_0" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"may_2020" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR
);
CREATE TABLE return_for_may_2021 (
"n_01_05_2021" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR
);
CREATE TABLE return_for_may_2022 (
"line_number" BIGINT,
"posting_date" TIMESTAMP,
"mch_merchant_category_code_mcc" BIGINT,
"mch_merchant_name" VARCHAR,
"fin_transaction_amount" DOUBLE,
"description" VARCHAR
);
CREATE TABLE return_for_may_2023 (
"unnamed_0" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"april_20th_may_19th" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR
);
CREATE TABLE return_for_may_2024 (
"unnamed_0" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"may_20th_june_19th_2024" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR
);
Anyone who has the link will be able to view this.