DWP Government Procurement Card Payments

@ukgov.dwp_government_procurement_card_payments_over_500.dwp_government_procurement_card_payments

4.3 KB
4 rows
4 columns


CREATE TABLE dwp_government_procurement_card_payments (
  "transaction_date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "n__transaction_amount" BIGINT,
  "expense_description" VARCHAR
);

Return For April 2019

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_april_2019

5.72 KB
7 rows
6 columns


CREATE TABLE return_for_april_2019 (
  "line_number" BIGINT,
  "posting_date" TIMESTAMP,
  "mch_merchant_category_code_mcc" BIGINT,
  "mch_merchant_name" VARCHAR,
  "fin_transaction_amount" VARCHAR,
  "description" VARCHAR
);

Return For April 2020

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_april_2020

6.45 KB
23 rows
8 columns


CREATE TABLE return_for_april_2020 (
  "unnamed_0" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "april_2020" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR
);

Return For April 2021

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_april_2021

4.96 KB
7 rows
6 columns


CREATE TABLE return_for_april_2021 (
  "apr_21" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR
);

Return For April 2022

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_april_2022

5.56 KB
4 rows
6 columns


CREATE TABLE return_for_april_2022 (
  "line_number" BIGINT,
  "posting_date" TIMESTAMP,
  "mch_merchant_category_code_mcc" BIGINT,
  "mch_merchant_name" VARCHAR,
  "fin_transaction_amount" DOUBLE,
  "description" VARCHAR
);

Return For April 2023

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_april_2023

5.84 KB
18 rows
6 columns


CREATE TABLE return_for_april_2023 (
  "line_number" BIGINT,
  "posting_date" TIMESTAMP,
  "mch_merchant_category_code_mcc" BIGINT,
  "mch_merchant_name" VARCHAR,
  "fin_transaction_amount" VARCHAR,
  "description" VARCHAR
);

Return For April 2024

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_april_2024

6.1 KB
32 rows
6 columns


CREATE TABLE return_for_april_2024 (
  "unnamed_0" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "march_20th_april_19th_2024" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR
);

Return For August 2019

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_august_2019

5.25 KB
1 row
6 columns


CREATE TABLE return_for_august_2019 (
  "line_number" BIGINT,
  "posting_date" VARCHAR,
  "mch_merchant_category_code_mcc" BIGINT,
  "mch_merchant_name" VARCHAR,
  "fin_transaction_amount" VARCHAR,
  "description" VARCHAR
);

Return For August 2020

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_august_2020

5.04 KB
7 rows
6 columns


CREATE TABLE return_for_august_2020 (
  "unnamed_0" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "august_2020" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR
);

Return For August 2021

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_august_2021

5.6 KB
4 rows
6 columns


CREATE TABLE return_for_august_2021 (
  "line_number" BIGINT,
  "posting_date" TIMESTAMP,
  "mch_merchant_category_code_mcc" BIGINT,
  "mch_merchant_name" VARCHAR,
  "fin_transaction_amount" VARCHAR,
  "description" VARCHAR
);

Return For August 2022

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_august_2022

5.43 KB
7 rows
6 columns


CREATE TABLE return_for_august_2022 (
  "unnamed_0" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "aug_20th_sept_19th_2022" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR
);

Return For August 2023

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_august_2023

5.88 KB
35 rows
6 columns


CREATE TABLE return_for_august_2023 (
  "unnamed_0" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "july_20th_august_19th" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR
);

Return For August 2024

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_august_2024

6.78 KB
50 rows
6 columns


CREATE TABLE return_for_august_2024 (
  "line_number" VARCHAR,
  "posting_date" TIMESTAMP,
  "mch_merchant_category_code_mcc" BIGINT,
  "mch_merchant_name" VARCHAR,
  "fin_transaction_amount" DOUBLE,
  "description" VARCHAR
);

Return For December 2018

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_december_2018

5.88 KB
10 rows
6 columns


CREATE TABLE return_for_december_2018 (
  "line_number" BIGINT,
  "posting_date" VARCHAR,
  "mch_merchant_category_code_mcc" BIGINT,
  "mch_merchant_name" VARCHAR,
  "fin_transaction_amount" VARCHAR,
  "description" VARCHAR
);

Return For December 2020

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_december_2020

6.22 KB
9 rows
8 columns


CREATE TABLE return_for_december_2020 (
  "unnamed_0" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "december_2020" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR
);

Return For December 2022

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_december_2022

4.93 KB
6 rows
6 columns


CREATE TABLE return_for_december_2022 (
  "unnamed_0" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "december_20th_january_19th" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR
);

Return For February 2019

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_february_2019

5.99 KB
12 rows
6 columns


CREATE TABLE return_for_february_2019 (
  "line_number" BIGINT,
  "posting_date" TIMESTAMP,
  "mch_merchant_category_code_mcc" BIGINT,
  "mch_merchant_name" VARCHAR,
  "fin_transaction_amount" VARCHAR,
  "description" VARCHAR
);

Return For February 2020

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_february_2020

6.33 KB
16 rows
8 columns


CREATE TABLE return_for_february_2020 (
  "unnamed_0" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "february_2020" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR
);

Return For February 2021

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_february_2021

5.99 KB
6 rows
8 columns


CREATE TABLE return_for_february_2021 (
  "unnamed_0" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "february_2021" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR
);

Return For February 2023

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_february_2023

5.57 KB
6 rows
6 columns


CREATE TABLE return_for_february_2023 (
  "line_number" DOUBLE,
  "posting_date" TIMESTAMP,
  "mch_merchant_category_code_mcc" DOUBLE,
  "mch_merchant_name" VARCHAR,
  "fin_transaction_amount" DOUBLE,
  "description" VARCHAR
);

Return For February 2024

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_february_2024

5.18 KB
7 rows
6 columns


CREATE TABLE return_for_february_2024 (
  "january_20th_february_19th" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR
);

Return For January 2019

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_january_2019

5.54 KB
4 rows
6 columns


CREATE TABLE return_for_january_2019 (
  "line_number" BIGINT,
  "posting_date" VARCHAR,
  "mch_merchant_category_code_mcc" BIGINT,
  "mch_merchant_name" VARCHAR,
  "fin_transaction_amount" VARCHAR,
  "description" VARCHAR
);

Return For January 2020

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_january_2020

6.43 KB
28 rows
7 columns


CREATE TABLE return_for_january_2020 (
  "line_number" BIGINT,
  "posting_date" VARCHAR,
  "mch_merchant_name" VARCHAR,
  "fin_transaction_amount" VARCHAR,
  "description" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR
);

Return For January 2021

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_january_2021

5.73 KB
5 rows
6 columns


CREATE TABLE return_for_january_2021 (
  "line_number" BIGINT,
  "posting_date" TIMESTAMP,
  "mch_merchant_category_code_mcc" BIGINT,
  "mch_merchant_name" VARCHAR,
  "fin_transaction_amount" DOUBLE,
  "description" VARCHAR
);

Return For January 2022

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_january_2022

5.3 KB
1 row
6 columns


CREATE TABLE return_for_january_2022 (
  "line_number" BIGINT,
  "posting_date" VARCHAR,
  "mch_merchant_category_code_mcc" BIGINT,
  "mch_merchant_name" VARCHAR,
  "fin_transaction_amount" VARCHAR,
  "description" VARCHAR
);

DWP Government Procurement Card Payments

About this Dataset