DWP Government Procurement Card Payments

@ukgov.dwp_government_procurement_card_payments_over_500.dwp_government_procurement_card_payments

4.4 kB
4 rows
4 columns

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

Return For April 2019

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_april_2019

5.86 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 Category Code (MCC),
  "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.61 kB
23 rows
8 columns

CREATE TABLE return_for_april_2020 (
  "unnamed_0" VARCHAR  -- Unnamed: 0,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "april_2020" VARCHAR,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7
);

Return For April 2021

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_april_2021

5.08 kB
7 rows
6 columns

CREATE TABLE return_for_april_2021 (
  "apr_21" VARCHAR,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5
);

Return For April 2022

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_april_2022

5.7 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 Category Code (MCC),
  "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.98 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 Category Code (MCC),
  "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.25 kB
32 rows
6 columns

CREATE TABLE return_for_april_2024 (
  "unnamed_0" VARCHAR  -- Unnamed: 0,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "march_20th_april_19th_2024" VARCHAR  -- March 20th - April 19th 2024,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5
);

Return For August 2019

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_august_2019

5.38 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 Category Code (MCC),
  "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.16 kB
7 rows
6 columns

CREATE TABLE return_for_august_2020 (
  "unnamed_0" VARCHAR  -- Unnamed: 0,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "august_2020" VARCHAR,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5
);

Return For August 2021

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_august_2021

5.74 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 Category Code (MCC),
  "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.57 kB
7 rows
6 columns

CREATE TABLE return_for_august_2022 (
  "unnamed_0" VARCHAR  -- Unnamed: 0,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "aug_20th_sept_19th_2022" VARCHAR  -- Aug 20th - Sept 19th 2022,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5
);

Return For August 2023

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_august_2023

6.02 kB
35 rows
6 columns

CREATE TABLE return_for_august_2023 (
  "unnamed_0" VARCHAR  -- Unnamed: 0,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "july_20th_august_19th" VARCHAR  -- July 20th - August 19th,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5
);

Return For August 2024

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_august_2024

6.94 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 Category Code (MCC),
  "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

6.02 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 Category Code (MCC),
  "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.37 kB
9 rows
8 columns

CREATE TABLE return_for_december_2020 (
  "unnamed_0" VARCHAR  -- Unnamed: 0,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "december_2020" VARCHAR,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7
);

Return For December 2022

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_december_2022

5.04 kB
6 rows
6 columns

CREATE TABLE return_for_december_2022 (
  "unnamed_0" VARCHAR  -- Unnamed: 0,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "december_20th_january_19th" VARCHAR  -- December 20th - January 19th,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5
);

Return For February 2019

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_february_2019

6.13 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 Category Code (MCC),
  "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.48 kB
16 rows
8 columns

CREATE TABLE return_for_february_2020 (
  "unnamed_0" VARCHAR  -- Unnamed: 0,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "february_2020" VARCHAR,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7
);

Return For February 2021

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_february_2021

6.14 kB
6 rows
8 columns

CREATE TABLE return_for_february_2021 (
  "unnamed_0" VARCHAR  -- Unnamed: 0,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "february_2021" VARCHAR,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7
);

Return For February 2023

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_february_2023

5.7 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 Category Code (MCC),
  "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.31 kB
7 rows
6 columns

CREATE TABLE return_for_february_2024 (
  "january_20th_february_19th" VARCHAR  -- January 20th - February 19th,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5
);

Return For January 2019

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_january_2019

5.67 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 Category Code (MCC),
  "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.59 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: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6
);

Return For January 2021

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_january_2021

5.87 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 Category Code (MCC),
  "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.43 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 Category Code (MCC),
  "mch_merchant_name" VARCHAR,
  "fin_transaction_amount" VARCHAR,
  "description" VARCHAR
);

DWP Government Procurement Card Payments

About this Dataset