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
);

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
);

Tables