Return For November 2018

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_november_2018

5.4 kB
7 rows
6 columns

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

Return For November 2019

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_november_2019

5.44 kB
2 rows
6 columns

CREATE TABLE return_for_november_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 November 2020

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_november_2020

6.42 kB
11 rows
8 columns

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

Return For November 2021

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_november_2021

5.42 kB
5 rows
6 columns

CREATE TABLE return_for_november_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 November 2022

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_november_2022

5.31 kB
7 rows
6 columns

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

Return For November 2024

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_november_2024

7.65 kB
51 rows
6 columns

CREATE TABLE return_for_november_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 October 2018

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_october_2018

5.34 kB
8 rows
6 columns

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

Return For October 2019

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_october_2019

5.63 kB
5 rows
6 columns

CREATE TABLE return_for_october_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 October 2020

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_october_2020

5.12 kB
6 rows
6 columns

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

Return For October 2021

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_october_2021

5.45 kB
6 rows
6 columns

CREATE TABLE return_for_october_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 October 2022

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_october_2022

5.04 kB
6 rows
6 columns

CREATE TABLE return_for_october_2022 (
  "unnamed_0" VARCHAR  -- Unnamed: 0,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "n_20th_oct_19th_nov_2022" VARCHAR  -- 20th Oct - 19th Nov 2022,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5
);

Return For October 2023

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_october_2023

5.61 kB
21 rows
6 columns

CREATE TABLE return_for_october_2023 (
  "unnamed_0" VARCHAR  -- Unnamed: 0,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "september_20th_october_19th" VARCHAR  -- September 20th - October 19th,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5
);

Return For October 2024

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_october_2024

8.93 kB
61 rows
6 columns

CREATE TABLE return_for_october_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 September 2019

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_september_2019

5.43 kB
2 rows
6 columns

CREATE TABLE return_for_september_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 September 2020

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_september_2020

5.38 kB
10 rows
6 columns

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

Return For September 2021

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_september_2021

5.6 kB
2 rows
6 columns

CREATE TABLE return_for_september_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 September 2022

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_september_2022

5.07 kB
6 rows
6 columns

CREATE TABLE return_for_september_2022 (
  "unnamed_0" VARCHAR  -- Unnamed: 0,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "sept_20th_oct_19th" VARCHAR  -- Sept 20th - OCt 19th,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5
);

Return For September 2023

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_september_2023

5.87 kB
41 rows
6 columns

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

Return For September 2024

@ukgov.dwp_government_procurement_card_payments_over_500.return_for_september_2024

7.24 kB
64 rows
6 columns

CREATE TABLE return_for_september_2024 (
  "september_20th_october_19th_2024" VARCHAR  -- September 20th - October 19th 2024,
  "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
);

DWP Government Procurement Card Payments

About this Dataset