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

June 2020

@ukgov.dh_gpc_spend_over_500.june_2020

3.49 KB
8 rows
3 columns


CREATE TABLE june_2020 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE,
  "mch_merchant_name" VARCHAR
);

June 2021

@ukgov.dh_gpc_spend_over_500.june_2021

3.74 KB
14 rows
3 columns


CREATE TABLE june_2021 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE,
  "mch_merchant_name" VARCHAR
);

June 2022

@ukgov.dh_gpc_spend_over_500.june_2022

3.45 KB
7 rows
3 columns


CREATE TABLE june_2022 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE,
  "mch_merchant_name" VARCHAR
);

March 2019

@ukgov.dh_gpc_spend_over_500.march_2019

3.58 KB
15 rows
3 columns


CREATE TABLE march_2019 (
  "fin_posting_date" TIMESTAMP,
  "fin_transaction_amount" DOUBLE,
  "mch_merchant_name" VARCHAR
);

March 2020

@ukgov.dh_gpc_spend_over_500.march_2020

3.6 KB
13 rows
3 columns


CREATE TABLE march_2020 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE,
  "mch_merchant_name" VARCHAR
);

March 2021

@ukgov.dh_gpc_spend_over_500.march_2021

3.63 KB
19 rows
3 columns


CREATE TABLE march_2021 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE,
  "mch_merchant_name" VARCHAR
);

March 2022

@ukgov.dh_gpc_spend_over_500.march_2022

3.62 KB
11 rows
3 columns


CREATE TABLE march_2022 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE,
  "mch_merchant_name" VARCHAR
);

May 2019

@ukgov.dh_gpc_spend_over_500.may_2019

3.59 KB
10 rows
3 columns


CREATE TABLE may_2019 (
  "fin_posting_date" TIMESTAMP,
  "fin_transaction_amount" DOUBLE,
  "mch_merchant_name" VARCHAR
);

May 2020

@ukgov.dh_gpc_spend_over_500.may_2020

3.33 KB
8 rows
3 columns


CREATE TABLE may_2020 (
  "n_11_05_2020" TIMESTAMP,
  "n__944_00" DOUBLE,
  "the_wheatsheaf" VARCHAR
);

May 2021

@ukgov.dh_gpc_spend_over_500.may_2021

3.98 KB
27 rows
3 columns


CREATE TABLE may_2021 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE,
  "mch_merchant_name" VARCHAR
);

May 2022

@ukgov.dh_gpc_spend_over_500.may_2022

3.69 KB
13 rows
3 columns


CREATE TABLE may_2022 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE,
  "mch_merchant_name" VARCHAR
);

November 2019

@ukgov.dh_gpc_spend_over_500.november_2019

3.67 KB
13 rows
3 columns


CREATE TABLE november_2019 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE,
  "mch_merchant_name" VARCHAR
);

November 2020

@ukgov.dh_gpc_spend_over_500.november_2020

3.65 KB
14 rows
3 columns


CREATE TABLE november_2020 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE,
  "mch_merchant_name" VARCHAR
);

November 2021

@ukgov.dh_gpc_spend_over_500.november_2021

3.43 KB
4 rows
3 columns


CREATE TABLE november_2021 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE,
  "mch_merchant_name" VARCHAR
);

November 2022

@ukgov.dh_gpc_spend_over_500.november_2022

3.59 KB
11 rows
3 columns


CREATE TABLE november_2022 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE,
  "mch_merchant_name" VARCHAR
);

October 2019

@ukgov.dh_gpc_spend_over_500.october_2019

3.86 KB
17 rows
3 columns


CREATE TABLE october_2019 (
  "fin_posting_date" TIMESTAMP,
  "fin_transaction_amount" DOUBLE,
  "mch_merchant_name" VARCHAR
);

October 2020

@ukgov.dh_gpc_spend_over_500.october_2020

3.55 KB
11 rows
3 columns


CREATE TABLE october_2020 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE,
  "mch_merchant_name" VARCHAR
);

October 2021

@ukgov.dh_gpc_spend_over_500.october_2021

3.58 KB
11 rows
3 columns


CREATE TABLE october_2021 (
  "fin_posting_date" TIMESTAMP,
  "fin_transaction_amount" DOUBLE,
  "mch_merchant_name" VARCHAR
);

October 2022

@ukgov.dh_gpc_spend_over_500.october_2022

3.8 KB
18 rows
3 columns


CREATE TABLE october_2022 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE,
  "mch_merchant_name" VARCHAR
);

September 2019

@ukgov.dh_gpc_spend_over_500.september_2019

3.78 KB
19 rows
3 columns


CREATE TABLE september_2019 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE,
  "mch_merchant_name" VARCHAR
);

September 2020

@ukgov.dh_gpc_spend_over_500.september_2020

3.38 KB
5 rows
3 columns


CREATE TABLE september_2020 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE,
  "mch_merchant_name" VARCHAR
);

September 2021

@ukgov.dh_gpc_spend_over_500.september_2021

3.65 KB
20 rows
3 columns


CREATE TABLE september_2021 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE,
  "mch_merchant_name" VARCHAR
);

September 2022

@ukgov.dh_gpc_spend_over_500.september_2022

3.78 KB
22 rows
3 columns


CREATE TABLE september_2022 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE,
  "mch_merchant_name" VARCHAR
);