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.57 kB
8 rows
3 columns

CREATE TABLE june_2020 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE  -- FIN.TRANSACTION AMOUNT,
  "mch_merchant_name" VARCHAR
);

June 2021

@ukgov.dh_gpc_spend_over_500.june_2021

3.83 kB
14 rows
3 columns

CREATE TABLE june_2021 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE  -- FIN.TRANSACTION AMOUNT,
  "mch_merchant_name" VARCHAR
);

June 2022

@ukgov.dh_gpc_spend_over_500.june_2022

3.53 kB
7 rows
3 columns

CREATE TABLE june_2022 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE  -- FIN.TRANSACTION AMOUNT,
  "mch_merchant_name" VARCHAR
);

March 2019

@ukgov.dh_gpc_spend_over_500.march_2019

3.66 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.69 kB
13 rows
3 columns

CREATE TABLE march_2020 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE  -- FIN.TRANSACTION AMOUNT,
  "mch_merchant_name" VARCHAR
);

March 2021

@ukgov.dh_gpc_spend_over_500.march_2021

3.72 kB
19 rows
3 columns

CREATE TABLE march_2021 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE  -- FIN.TRANSACTION AMOUNT,
  "mch_merchant_name" VARCHAR
);

March 2022

@ukgov.dh_gpc_spend_over_500.march_2022

3.71 kB
11 rows
3 columns

CREATE TABLE march_2022 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE  -- FIN.TRANSACTION AMOUNT,
  "mch_merchant_name" VARCHAR
);

May 2019

@ukgov.dh_gpc_spend_over_500.may_2019

3.68 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.41 kB
8 rows
3 columns

CREATE TABLE may_2020 (
  "n_11_05_2020" TIMESTAMP  -- 11/05/2020,
  "n__944_00" DOUBLE  -- 944.00,
  "the_wheatsheaf" VARCHAR
);

May 2021

@ukgov.dh_gpc_spend_over_500.may_2021

4.07 kB
27 rows
3 columns

CREATE TABLE may_2021 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE  -- FIN.TRANSACTION AMOUNT,
  "mch_merchant_name" VARCHAR
);

May 2022

@ukgov.dh_gpc_spend_over_500.may_2022

3.78 kB
13 rows
3 columns

CREATE TABLE may_2022 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE  -- FIN.TRANSACTION AMOUNT,
  "mch_merchant_name" VARCHAR
);

November 2019

@ukgov.dh_gpc_spend_over_500.november_2019

3.76 kB
13 rows
3 columns

CREATE TABLE november_2019 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE  -- FIN.TRANSACTION AMOUNT,
  "mch_merchant_name" VARCHAR
);

November 2020

@ukgov.dh_gpc_spend_over_500.november_2020

3.74 kB
14 rows
3 columns

CREATE TABLE november_2020 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE  -- FIN.TRANSACTION AMOUNT,
  "mch_merchant_name" VARCHAR
);

November 2021

@ukgov.dh_gpc_spend_over_500.november_2021

3.51 kB
4 rows
3 columns

CREATE TABLE november_2021 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE  -- FIN.TRANSACTION AMOUNT,
  "mch_merchant_name" VARCHAR
);

November 2022

@ukgov.dh_gpc_spend_over_500.november_2022

3.68 kB
11 rows
3 columns

CREATE TABLE november_2022 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE  -- FIN.TRANSACTION AMOUNT,
  "mch_merchant_name" VARCHAR
);

October 2019

@ukgov.dh_gpc_spend_over_500.october_2019

3.95 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.63 kB
11 rows
3 columns

CREATE TABLE october_2020 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE  -- FIN.TRANSACTION AMOUNT,
  "mch_merchant_name" VARCHAR
);

October 2021

@ukgov.dh_gpc_spend_over_500.october_2021

3.66 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.89 kB
18 rows
3 columns

CREATE TABLE october_2022 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE  -- FIN.TRANSACTION AMOUNT,
  "mch_merchant_name" VARCHAR
);

September 2019

@ukgov.dh_gpc_spend_over_500.september_2019

3.88 kB
19 rows
3 columns

CREATE TABLE september_2019 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE  -- FIN.TRANSACTION AMOUNT,
  "mch_merchant_name" VARCHAR
);

September 2020

@ukgov.dh_gpc_spend_over_500.september_2020

3.46 kB
5 rows
3 columns

CREATE TABLE september_2020 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE  -- FIN.TRANSACTION AMOUNT,
  "mch_merchant_name" VARCHAR
);

September 2021

@ukgov.dh_gpc_spend_over_500.september_2021

3.74 kB
20 rows
3 columns

CREATE TABLE september_2021 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE  -- FIN.TRANSACTION AMOUNT,
  "mch_merchant_name" VARCHAR
);

September 2022

@ukgov.dh_gpc_spend_over_500.september_2022

3.87 kB
22 rows
3 columns

CREATE TABLE september_2022 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE  -- FIN.TRANSACTION AMOUNT,
  "mch_merchant_name" VARCHAR
);