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.66 KB
14 rows
3 columns


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

April 2020

@ukgov.dh_gpc_spend_over_500.april_2020

3.51 KB
14 rows
3 columns


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

April 2021

@ukgov.dh_gpc_spend_over_500.april_2021

3.81 KB
20 rows
3 columns


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

April 2022

@ukgov.dh_gpc_spend_over_500.april_2022

3.67 KB
13 rows
3 columns


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

August 2019

@ukgov.dh_gpc_spend_over_500.august_2019

3.49 KB
8 rows
3 columns


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

August 2020

@ukgov.dh_gpc_spend_over_500.august_2020

3.67 KB
10 rows
3 columns


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

August 2021

@ukgov.dh_gpc_spend_over_500.august_2021

3.82 KB
20 rows
3 columns


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

August 2022

@ukgov.dh_gpc_spend_over_500.august_2022

3.6 KB
9 rows
3 columns


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

December 2018

@ukgov.dh_gpc_spend_over_500.december_2018

3.6 KB
9 rows
3 columns


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

December 2019

@ukgov.dh_gpc_spend_over_500.december_2019

3.58 KB
13 rows
3 columns


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.72 KB
19 rows
3 columns


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

December 2021

@ukgov.dh_gpc_spend_over_500.december_2021

3.5 KB
12 rows
3 columns


CREATE TABLE december_2021 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" VARCHAR,
  "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.55 KB
6 rows
3 columns


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

February 2019

@ukgov.dh_gpc_spend_over_500.february_2019

3.64 KB
14 rows
3 columns


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.75 KB
22 rows
3 columns


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

February 2021

@ukgov.dh_gpc_spend_over_500.february_2021

3.59 KB
13 rows
3 columns


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

February 2022

@ukgov.dh_gpc_spend_over_500.february_2022

3.71 KB
11 rows
3 columns


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

January 2020

@ukgov.dh_gpc_spend_over_500.january_2020

3.64 KB
13 rows
3 columns


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

January 2021

@ukgov.dh_gpc_spend_over_500.january_2021

3.37 KB
3 rows
3 columns


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

January 2022

@ukgov.dh_gpc_spend_over_500.january_2022

3.56 KB
9 rows
3 columns


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

July 2019

@ukgov.dh_gpc_spend_over_500.july_2019

3.65 KB
14 rows
3 columns


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

July 2020

@ukgov.dh_gpc_spend_over_500.july_2020

3.4 KB
5 rows
3 columns


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

July 2021

@ukgov.dh_gpc_spend_over_500.july_2021

3.64 KB
15 rows
3 columns


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

July 2022

@ukgov.dh_gpc_spend_over_500.july_2022

3.8 KB
19 rows
3 columns


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

June 2019

@ukgov.dh_gpc_spend_over_500.june_2019

3.49 KB
5 rows
3 columns


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