April 2019

@ukgov.financial_transactions_data_mhra.april_2019

9.28 kB
35 rows
9 columns

CREATE TABLE april_2019 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount" DOUBLE,
  "vat_registration_number" DOUBLE
);

April 2020

@ukgov.financial_transactions_data_mhra.april_2020

8.82 kB
32 rows
9 columns

CREATE TABLE april_2020 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount" DOUBLE,
  "vat_registration_number" DOUBLE
);

April 2022

@ukgov.financial_transactions_data_mhra.april_2022

10.65 kB
70 rows
9 columns

CREATE TABLE april_2022 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount" DOUBLE,
  "vat_registration_number" DOUBLE
);

August 2018

@ukgov.financial_transactions_data_mhra.august_2018

9.06 kB
51 rows
9 columns

CREATE TABLE august_2018 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount" DOUBLE,
  "vat_registration_number" DOUBLE
);

August 2020

@ukgov.financial_transactions_data_mhra.august_2020

8.9 kB
26 rows
9 columns

CREATE TABLE august_2020 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount" DOUBLE,
  "vat_registration_number" BIGINT
);

August 2022

@ukgov.financial_transactions_data_mhra.august_2022

9.39 kB
50 rows
9 columns

CREATE TABLE august_2022 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount" DOUBLE,
  "vat_registration_number" DOUBLE
);

December 2018

@ukgov.financial_transactions_data_mhra.december_2018

9.12 kB
42 rows
9 columns

CREATE TABLE december_2018 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount" DOUBLE,
  "vat_registration_number" DOUBLE
);

December 2021

@ukgov.financial_transactions_data_mhra.december_2021

10.02 kB
61 rows
9 columns

CREATE TABLE december_2021 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount" DOUBLE,
  "vat_registration_number" DOUBLE
);

February 2019

@ukgov.financial_transactions_data_mhra.february_2019

8.7 kB
26 rows
9 columns

CREATE TABLE february_2019 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount" DOUBLE,
  "vat_registration_number" BIGINT
);

February 2022

@ukgov.financial_transactions_data_mhra.february_2022

10 kB
51 rows
9 columns

CREATE TABLE february_2022 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount" DOUBLE,
  "vat_registration_number" DOUBLE
);

January 2019

@ukgov.financial_transactions_data_mhra.january_2019

8.89 kB
27 rows
9 columns

CREATE TABLE january_2019 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount" DOUBLE,
  "vat_registration_number" BIGINT
);

January 2022

@ukgov.financial_transactions_data_mhra.january_2022

10.91 kB
75 rows
9 columns

CREATE TABLE january_2022 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount" DOUBLE,
  "vat_registration_number" DOUBLE
);

July 2018

@ukgov.financial_transactions_data_mhra.july_2018

9.62 kB
51 rows
9 columns

CREATE TABLE july_2018 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount" DOUBLE,
  "vat_registration_number" DOUBLE
);

July 2019

@ukgov.financial_transactions_data_mhra.july_2019

9.63 kB
57 rows
9 columns

CREATE TABLE july_2019 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount" DOUBLE,
  "vat_registration_number" BIGINT
);

July 2020

@ukgov.financial_transactions_data_mhra.july_2020

7.81 kB
7 rows
9 columns

CREATE TABLE july_2020 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" BIGINT,
  "amount" DOUBLE,
  "vat_registration_number" DOUBLE
);

July 2022

@ukgov.financial_transactions_data_mhra.july_2022

8.28 kB
20 rows
9 columns

CREATE TABLE july_2022 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount" DOUBLE,
  "vat_registration_number" BIGINT
);

June 2019

@ukgov.financial_transactions_data_mhra.june_2019

8.37 kB
12 rows
9 columns

CREATE TABLE june_2019 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount" DOUBLE,
  "vat_registration_number" DOUBLE
);

June 2020

@ukgov.financial_transactions_data_mhra.june_2020

8.44 kB
27 rows
9 columns

CREATE TABLE june_2020 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount" DOUBLE,
  "vat_registration_number" BIGINT
);

June 2022

@ukgov.financial_transactions_data_mhra.june_2022

9 kB
37 rows
9 columns

CREATE TABLE june_2022 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount" DOUBLE,
  "vat_registration_number" DOUBLE
);

March 2019

@ukgov.financial_transactions_data_mhra.march_2019

9.98 kB
45 rows
9 columns

CREATE TABLE march_2019 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount" DOUBLE,
  "vat_registration_number" DOUBLE
);

March 2022

@ukgov.financial_transactions_data_mhra.march_2022

11.44 kB
86 rows
9 columns

CREATE TABLE march_2022 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount" DOUBLE,
  "vat_registration_number" DOUBLE
);

May 2019

@ukgov.financial_transactions_data_mhra.may_2019

8.62 kB
19 rows
9 columns

CREATE TABLE may_2019 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount" DOUBLE,
  "vat_registration_number" DOUBLE
);

May 2020

@ukgov.financial_transactions_data_mhra.may_2020

8.5 kB
14 rows
9 columns

CREATE TABLE may_2020 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount" DOUBLE,
  "vat_registration_number" DOUBLE
);

May 2022

@ukgov.financial_transactions_data_mhra.may_2022

9.1 kB
33 rows
9 columns

CREATE TABLE may_2022 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount" DOUBLE,
  "vat_registration_number" DOUBLE
);

MHRA Spending Over £25,000 Data For August 2023

@ukgov.financial_transactions_data_mhra.mhra_spending_over_25_000_data_for_august_2023

9.26 kB
40 rows
9 columns

CREATE TABLE mhra_spending_over_25_000_data_for_august_2023 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount" DOUBLE,
  "vat_registration_number" DOUBLE
);

Spend Over £25,000 In MHRA

About this Dataset