Baselight

Department Of Health Government Procurement Card Spend - Transactions Over £500

Department of Health and Social Care

@ukgov.dh_gpc_spend_over_500

Loading...
Loading...

About this Dataset

Department Of Health Government Procurement Card Spend - Transactions Over £500

The data published includes transactions that have a single transaction value of £500 or above.
Publisher name: Department of Health and Social Care
Last updated: 2023-02-06T01:09:32Z

Tables

April 2019

@ukgov.dh_gpc_spend_over_500.april_2019
  • 3.75 kB
  • 14 rows
  • 3 columns
Loading...
CREATE TABLE april_2019 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE  -- FIN.TRANSACTION AMOUNT,
  "mch_merchant_name" VARCHAR
);

April 2020

@ukgov.dh_gpc_spend_over_500.april_2020
  • 3.6 kB
  • 14 rows
  • 3 columns
Loading...
CREATE TABLE april_2020 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE  -- FIN.TRANSACTION AMOUNT,
  "mch_merchant_name" VARCHAR
);

April 2021

@ukgov.dh_gpc_spend_over_500.april_2021
  • 3.91 kB
  • 20 rows
  • 3 columns
Loading...
CREATE TABLE april_2021 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE  -- FIN.TRANSACTION AMOUNT,
  "mch_merchant_name" VARCHAR
);

April 2022

@ukgov.dh_gpc_spend_over_500.april_2022
  • 3.75 kB
  • 13 rows
  • 3 columns
Loading...
CREATE TABLE april_2022 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE  -- FIN.TRANSACTION AMOUNT,
  "mch_merchant_name" VARCHAR
);

August 2019

@ukgov.dh_gpc_spend_over_500.august_2019
  • 3.58 kB
  • 8 rows
  • 3 columns
Loading...
CREATE TABLE august_2019 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE  -- FIN.TRANSACTION AMOUNT,
  "mch_merchant_name" VARCHAR
);

August 2020

@ukgov.dh_gpc_spend_over_500.august_2020
  • 3.75 kB
  • 10 rows
  • 3 columns
Loading...
CREATE TABLE august_2020 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE  -- FIN.TRANSACTION AMOUNT,
  "mch_merchant_name" VARCHAR
);

August 2021

@ukgov.dh_gpc_spend_over_500.august_2021
  • 3.91 kB
  • 20 rows
  • 3 columns
Loading...
CREATE TABLE august_2021 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE  -- FIN.TRANSACTION AMOUNT,
  "mch_merchant_name" VARCHAR
);

August 2022

@ukgov.dh_gpc_spend_over_500.august_2022
  • 3.69 kB
  • 9 rows
  • 3 columns
Loading...
CREATE TABLE august_2022 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE  -- FIN.TRANSACTION AMOUNT,
  "mch_merchant_name" VARCHAR
);

December 2018

@ukgov.dh_gpc_spend_over_500.december_2018
  • 3.69 kB
  • 9 rows
  • 3 columns
Loading...
CREATE TABLE december_2018 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE  -- FIN.TRANSACTION AMOUNT,
  "mch_merchant_name" VARCHAR
);

December 2019

@ukgov.dh_gpc_spend_over_500.december_2019
  • 3.66 kB
  • 13 rows
  • 3 columns
Loading...
CREATE TABLE december_2019 (
  "fin_posting_date" TIMESTAMP,
  "fin_transaction_amount" DOUBLE,
  "mch_merchant_name" VARCHAR
);

December 2020

@ukgov.dh_gpc_spend_over_500.december_2020
  • 3.81 kB
  • 19 rows
  • 3 columns
Loading...
CREATE TABLE december_2020 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE  -- FIN.TRANSACTION AMOUNT,
  "mch_merchant_name" VARCHAR
);

December 2021

@ukgov.dh_gpc_spend_over_500.december_2021
  • 3.58 kB
  • 12 rows
  • 3 columns
Loading...
CREATE TABLE december_2021 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" VARCHAR  -- FIN.TRANSACTION AMOUNT,
  "mch_merchant_name" VARCHAR
);

Department Of Health Government Procurement Card Spend - Transactions Over £500

@ukgov.dh_gpc_spend_over_500.department_of_health_government_procurement_card_spend_939c7df9
  • 3.64 kB
  • 6 rows
  • 3 columns
Loading...
CREATE TABLE department_of_health_government_procurement_card_spend_939c7df9 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE  -- FIN.TRANSACTION AMOUNT,
  "mch_merchant_name" VARCHAR
);

February 2019

@ukgov.dh_gpc_spend_over_500.february_2019
  • 3.72 kB
  • 14 rows
  • 3 columns
Loading...
CREATE TABLE february_2019 (
  "fin_posting_date" TIMESTAMP,
  "fin_transaction_amount" DOUBLE,
  "mch_merchant_name" VARCHAR
);

February 2020

@ukgov.dh_gpc_spend_over_500.february_2020
  • 3.84 kB
  • 22 rows
  • 3 columns
Loading...
CREATE TABLE february_2020 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE  -- FIN.TRANSACTION AMOUNT,
  "mch_merchant_name" VARCHAR
);

February 2021

@ukgov.dh_gpc_spend_over_500.february_2021
  • 3.68 kB
  • 13 rows
  • 3 columns
Loading...
CREATE TABLE february_2021 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE  -- FIN.TRANSACTION AMOUNT,
  "mch_merchant_name" VARCHAR
);

February 2022

@ukgov.dh_gpc_spend_over_500.february_2022
  • 3.79 kB
  • 11 rows
  • 3 columns
Loading...
CREATE TABLE february_2022 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" VARCHAR  -- FIN.TRANSACTION AMOUNT,
  "mch_merchant_name" VARCHAR
);

January 2020

@ukgov.dh_gpc_spend_over_500.january_2020
  • 3.73 kB
  • 13 rows
  • 3 columns
Loading...
CREATE TABLE january_2020 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE  -- FIN.TRANSACTION AMOUNT,
  "mch_merchant_name" VARCHAR
);

January 2021

@ukgov.dh_gpc_spend_over_500.january_2021
  • 3.45 kB
  • 3 rows
  • 3 columns
Loading...
CREATE TABLE january_2021 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE  -- FIN.TRANSACTION AMOUNT,
  "mch_merchant_name" VARCHAR
);

January 2022

@ukgov.dh_gpc_spend_over_500.january_2022
  • 3.64 kB
  • 9 rows
  • 3 columns
Loading...
CREATE TABLE january_2022 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" VARCHAR  -- FIN.TRANSACTION AMOUNT,
  "mch_merchant_name" VARCHAR
);

July 2019

@ukgov.dh_gpc_spend_over_500.july_2019
  • 3.73 kB
  • 14 rows
  • 3 columns
Loading...
CREATE TABLE july_2019 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE  -- FIN.TRANSACTION AMOUNT,
  "mch_merchant_name" VARCHAR
);

July 2020

@ukgov.dh_gpc_spend_over_500.july_2020
  • 3.48 kB
  • 5 rows
  • 3 columns
Loading...
CREATE TABLE july_2020 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE  -- FIN.TRANSACTION AMOUNT,
  "mch_merchant_name" VARCHAR
);

July 2021

@ukgov.dh_gpc_spend_over_500.july_2021
  • 3.73 kB
  • 15 rows
  • 3 columns
Loading...
CREATE TABLE july_2021 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE  -- FIN.TRANSACTION AMOUNT,
  "mch_merchant_name" VARCHAR
);

July 2022

@ukgov.dh_gpc_spend_over_500.july_2022
  • 3.89 kB
  • 19 rows
  • 3 columns
Loading...
CREATE TABLE july_2022 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE  -- FIN.TRANSACTION AMOUNT,
  "mch_merchant_name" VARCHAR
);

June 2019

@ukgov.dh_gpc_spend_over_500.june_2019
  • 3.57 kB
  • 5 rows
  • 3 columns
Loading...
CREATE TABLE june_2019 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE  -- FIN.TRANSACTION AMOUNT,
  "mch_merchant_name" VARCHAR
);

Share link

Anyone who has the link will be able to view this.