Return For January 2023

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_january_2023

5.55 kB
1 row
6 columns

CREATE TABLE return_for_january_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" DOUBLE,
  "description" VARCHAR
);

Return For January 2024

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_january_2024

6.63 kB
25 rows
6 columns

CREATE TABLE return_for_january_2024 (
  "december_20th_to_january_19th_2024" 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 July 2019

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_july_2019

5.38 kB
7 rows
6 columns

CREATE TABLE return_for_july_2019 (
  "unnamed_0" VARCHAR  -- Unnamed: 0,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "dwp_and_cmg_spending_over_500_july_2019" VARCHAR  -- DWP And CMG: Spending Over Ł500, July 2019,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5
);

Return For July 2020

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_july_2020

5.03 kB
5 rows
6 columns

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

Return For July 2021

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_july_2021

5.44 kB
6 rows
6 columns

CREATE TABLE return_for_july_2021 (
  "line_number" DOUBLE,
  "posting_date" VARCHAR,
  "mch_merchant_category_code_mcc" DOUBLE  -- MCH.Merchant Category Code (MCC),
  "mch_merchant_name" VARCHAR,
  "fin_transaction_amount" VARCHAR,
  "description" VARCHAR
);

Return For July 2022

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_july_2022

5.15 kB
6 rows
6 columns

CREATE TABLE return_for_july_2022 (
  "unnamed_0" VARCHAR  -- Unnamed: 0,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "may_20th_june_19th" VARCHAR  -- May 20th - June 19th,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5
);

Return For July 2023

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_july_2023

5.52 kB
14 rows
6 columns

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

Return For July 2024

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_july_2024

6.47 kB
36 rows
6 columns

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

Return For June 2019

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_june_2019

5.58 kB
9 rows
6 columns

CREATE TABLE return_for_june_2019 (
  "unnamed_0" VARCHAR  -- Unnamed: 0,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "dwp_and_cmg_epcs_spending_over_500_for_june_2019" VARCHAR  -- DWP And CMG EPCS Spending Over £500 For June 2019,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5
);

Return For June 2020

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_june_2020

6.09 kB
6 rows
8 columns

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

Return For June 2021

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_june_2021

5.63 kB
6 rows
6 columns

CREATE TABLE return_for_june_2021 (
  "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 June 2022

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_june_2022

5.58 kB
4 rows
6 columns

CREATE TABLE return_for_june_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" DOUBLE,
  "description" VARCHAR
);

Return For June 2023

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_june_2023

5.25 kB
15 rows
6 columns

CREATE TABLE return_for_june_2023 (
  "unnamed_0" VARCHAR  -- Unnamed: 0,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "may_20th_june_19th" VARCHAR  -- May 20th - June 19th,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5
);

Return For June 2024

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_june_2024

5.78 kB
15 rows
6 columns

CREATE TABLE return_for_june_2024 (
  "unnamed_0" VARCHAR  -- Unnamed: 0,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "june_20th_july_19th_2024" VARCHAR  -- June 20th - July 19th 2024,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5
);

Return For March 2019

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_march_2019

4.14 kB
3 rows
4 columns

CREATE TABLE return_for_march_2019 (
  "mch_merchant_category_code_mcc" BIGINT  -- MCH.Merchant Category Code (MCC),
  "mch_merchant_name" VARCHAR,
  "fin_transaction_amount" VARCHAR,
  "description" VARCHAR
);

Return For March 2020

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_march_2020

6.43 kB
14 rows
8 columns

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

Return For March 2021

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_march_2021

6.29 kB
9 rows
8 columns

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

Return For March 2022

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_march_2022

5.36 kB
5 rows
6 columns

CREATE TABLE return_for_march_2022 (
  "line_number" DOUBLE,
  "posting_date" TIMESTAMP,
  "mch_merchant_category_code_mcc" DOUBLE  -- MCH.Merchant Category Code (MCC),
  "mch_merchant_name" VARCHAR,
  "fin_transaction_amount" VARCHAR,
  "description" VARCHAR
);

Return For March 2023

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_march_2023

5.13 kB
7 rows
6 columns

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

Return For May 2019

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_may_2019

5.76 kB
4 rows
6 columns

CREATE TABLE return_for_may_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 May 2020

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_may_2020

6.12 kB
6 rows
8 columns

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

Return For May 2021

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_may_2021

4.9 kB
3 rows
6 columns

CREATE TABLE return_for_may_2021 (
  "n_01_05_2021" VARCHAR  -- 01/05/2021,
  "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 May 2022

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_may_2022

5.67 kB
5 rows
6 columns

CREATE TABLE return_for_may_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 May 2023

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_may_2023

5.68 kB
34 rows
6 columns

CREATE TABLE return_for_may_2023 (
  "unnamed_0" VARCHAR  -- Unnamed: 0,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "april_20th_may_19th" VARCHAR  -- April 20th - May 19th,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5
);

Return For May 2024

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_may_2024

5.92 kB
25 rows
6 columns

CREATE TABLE return_for_may_2024 (
  "unnamed_0" VARCHAR  -- Unnamed: 0,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "may_20th_june_19th_2024" VARCHAR  -- May 20th - June 19th 2024,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5
);

DWP Government Procurement Card Payments

About this Dataset