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.83 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.79 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.56 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.43 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.5 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.49 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.77 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.77 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.06 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

6.89 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.45 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.7 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.64 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.18 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

6.87 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.67 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.3 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.58 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

5.94 KB
14 rows
5 columns


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