Spend Over £25,000 In MHRA
Medicines and Healthcare products Regulatory Agency
@ukgov.financial_transactions_data_mhra
Medicines and Healthcare products Regulatory Agency
@ukgov.financial_transactions_data_mhra
A monthly updated list of all financial transactions spending over £25,000 made by The Medicines and Healthcare Products Regulatory Agency (MHRA), as part of the Government's commitment to transparency in expenditure.
Publisher name: Medicines and Healthcare products Regulatory Agency
Last updated: 2024-09-24T19:10:54Z
CREATE TABLE mhra_spending_over_25_000_data_for_december_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
);CREATE TABLE mhra_spending_over_25_000_data_for_february_2024 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"vat_registration_number" DOUBLE
);CREATE TABLE mhra_spending_over_25_000_data_for_january_2024 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"vat_registration_number" DOUBLE
);CREATE TABLE mhra_spending_over_25_000_data_for_july_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
);CREATE TABLE mhra_spending_over_25_000_data_for_june_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
);CREATE TABLE mhra_spending_over_25_000_data_for_march_2024 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"vat_registration_number" DOUBLE
);CREATE TABLE mhra_spending_over_25_000_data_for_may_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
);CREATE TABLE mhra_spending_over_25_000_data_for_november_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
);CREATE TABLE mhra_spending_over_25_000_data_for_october_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
);CREATE TABLE mhra_spending_over_25_000_data_for_september_2023 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"vat_registration_number" BIGINT
);CREATE TABLE november_2018 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"vat_registration_number" BIGINT
);CREATE TABLE november_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
);CREATE TABLE october_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
);CREATE TABLE october_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
);CREATE TABLE october_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
);CREATE TABLE october_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
);CREATE TABLE september_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
);CREATE TABLE september_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
);CREATE TABLE september_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
);CREATE TABLE spend_over_25_000_in_mhra (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" BIGINT,
"amount" DOUBLE,
"vat_registration_number" BIGINT
);Anyone who has the link will be able to view this.