April 2019

@ukgov.financial_transactions_data_mhra.april_2019

9.07 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.62 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.4 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

8.85 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.69 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.17 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

8.91 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

9.78 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.5 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

9.76 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.68 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.65 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.4 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.41 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.63 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.09 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.18 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.24 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

8.79 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.75 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.17 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.41 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.3 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

8.88 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.04 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