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_november_2018 (
"unnamed_0" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"nov_18" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR
);
CREATE TABLE return_for_november_2019 (
"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_november_2020 (
"unnamed_0" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"november_2020" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR
);
CREATE TABLE return_for_november_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_november_2022 (
"unnamed_0" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"november_20th_december_19th" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR
);
CREATE TABLE return_for_november_2024 (
"line_number" VARCHAR,
"posting_date" TIMESTAMP,
"mch_merchant_category_code_mcc" BIGINT,
"mch_merchant_name" VARCHAR,
"fin_transaction_amount" DOUBLE,
"description" VARCHAR
);
CREATE TABLE return_for_october_2018 (
"unnamed_0" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"oct_18" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR
);
CREATE TABLE return_for_october_2019 (
"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_october_2020 (
"unnamed_0" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"october_2020" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR
);
CREATE TABLE return_for_october_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_october_2022 (
"unnamed_0" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"n_20th_oct_19th_nov_2022" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR
);
CREATE TABLE return_for_october_2023 (
"unnamed_0" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"september_20th_october_19th" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR
);
CREATE TABLE return_for_october_2024 (
"line_number" VARCHAR,
"posting_date" TIMESTAMP,
"mch_merchant_category_code_mcc" BIGINT,
"mch_merchant_name" VARCHAR,
"fin_transaction_amount" DOUBLE,
"description" VARCHAR
);
CREATE TABLE return_for_september_2019 (
"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_september_2020 (
"unnamed_0" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"september_2020" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR
);
CREATE TABLE return_for_september_2021 (
"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_september_2022 (
"unnamed_0" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"sept_20th_oct_19th" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR
);
CREATE TABLE return_for_september_2023 (
"unnamed_0" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"august_20th_september_19th" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR
);
CREATE TABLE return_for_september_2024 (
"september_20th_october_19th_2024" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR
);
Anyone who has the link will be able to view this.