About this Dataset

MHRA GPC Transactions

Medicines & Healthcare Products Regulatory Agency (MHRA) Government Procurement Card expenditure over £500
Publisher name: Medicines and Healthcare products Regulatory Agency
Last updated: 2024-09-04T14:29:17Z

Tables

April 2019

@ukgov.mhra_gpc_transactions.april_2019

6.99 kB
22 rows
5 columns

CREATE TABLE april_2019 (
  "date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" VARCHAR,
  "type" VARCHAR,
  "description" VARCHAR
);

April 2020

@ukgov.mhra_gpc_transactions.april_2020

5.92 kB
15 rows
5 columns

CREATE TABLE april_2020 (
  "date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" DOUBLE,
  "type" VARCHAR,
  "description" VARCHAR
);

August 2018

@ukgov.mhra_gpc_transactions.august_2018

6.72 kB
19 rows
5 columns

CREATE TABLE august_2018 (
  "date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" VARCHAR,
  "type" VARCHAR,
  "description" VARCHAR
);

August 2019

@ukgov.mhra_gpc_transactions.august_2019

6.58 kB
15 rows
5 columns

CREATE TABLE august_2019 (
  "date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" VARCHAR,
  "type" VARCHAR,
  "description" VARCHAR
);

December 2018

@ukgov.mhra_gpc_transactions.december_2018

6.65 kB
11 rows
5 columns

CREATE TABLE december_2018 (
  "date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" VARCHAR,
  "type" VARCHAR,
  "description" VARCHAR
);

February 2019

@ukgov.mhra_gpc_transactions.february_2019

6.64 kB
16 rows
5 columns

CREATE TABLE february_2019 (
  "date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" VARCHAR,
  "type" VARCHAR,
  "description" VARCHAR
);

January 2019

@ukgov.mhra_gpc_transactions.january_2019

5.91 kB
11 rows
5 columns

CREATE TABLE january_2019 (
  "date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" VARCHAR,
  "type" VARCHAR,
  "description" VARCHAR
);

July 2019

@ukgov.mhra_gpc_transactions.july_2019

6.94 kB
19 rows
5 columns

CREATE TABLE july_2019 (
  "date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" VARCHAR,
  "type" VARCHAR,
  "description" VARCHAR
);

July 2020

@ukgov.mhra_gpc_transactions.july_2020

5.18 kB
2 rows
5 columns

CREATE TABLE july_2020 (
  "date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" DOUBLE,
  "type" VARCHAR,
  "description" VARCHAR
);

June 2019

@ukgov.mhra_gpc_transactions.june_2019

7.06 kB
23 rows
5 columns

CREATE TABLE june_2019 (
  "date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" VARCHAR,
  "type" VARCHAR,
  "description" VARCHAR
);

June 2020

@ukgov.mhra_gpc_transactions.june_2020

5.58 kB
7 rows
5 columns

CREATE TABLE june_2020 (
  "date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" DOUBLE,
  "type" VARCHAR,
  "description" VARCHAR
);

March 2019

@ukgov.mhra_gpc_transactions.march_2019

6.87 kB
20 rows
5 columns

CREATE TABLE march_2019 (
  "date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" VARCHAR,
  "type" VARCHAR,
  "description" VARCHAR
);

May 2019

@ukgov.mhra_gpc_transactions.may_2019

6.8 kB
19 rows
5 columns

CREATE TABLE may_2019 (
  "date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" VARCHAR,
  "type" VARCHAR,
  "description" VARCHAR
);

May 2020

@ukgov.mhra_gpc_transactions.may_2020

5.31 kB
5 rows
5 columns

CREATE TABLE may_2020 (
  "date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" DOUBLE,
  "type" VARCHAR,
  "description" VARCHAR
);

MHRA GPC Transactions

@ukgov.mhra_gpc_transactions.mhra_gpc_transactions

7.04 kB
26 rows
5 columns

CREATE TABLE mhra_gpc_transactions (
  "date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" VARCHAR,
  "type" VARCHAR,
  "description" VARCHAR
);

November 2018

@ukgov.mhra_gpc_transactions.november_2018

6.83 kB
19 rows
5 columns

CREATE TABLE november_2018 (
  "date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" VARCHAR,
  "type" VARCHAR,
  "description" VARCHAR
);

October 2018

@ukgov.mhra_gpc_transactions.october_2018

6.45 kB
13 rows
5 columns

CREATE TABLE october_2018 (
  "date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" VARCHAR,
  "type" VARCHAR,
  "description" VARCHAR
);

September 2018

@ukgov.mhra_gpc_transactions.september_2018

6.74 kB
18 rows
5 columns

CREATE TABLE september_2018 (
  "date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" VARCHAR,
  "type" VARCHAR,
  "description" VARCHAR
);

September 2019

@ukgov.mhra_gpc_transactions.september_2019

6.08 kB
14 rows
5 columns

CREATE TABLE september_2019 (
  "date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" VARCHAR,
  "type" VARCHAR,
  "description" VARCHAR
);