MHRA Spending Over £25,000 Data For December 2023

@ukgov.financial_transactions_data_mhra.mhra_spending_over_25_000_data_for_december_2023

10.29 KB
66 rows
9 columns


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
);

MHRA Spending Over £25,000 Data For February 2024

@ukgov.financial_transactions_data_mhra.mhra_spending_over_25_000_data_for_february_2024

9.79 KB
53 rows
9 columns


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
);

MHRA Spending Over £25,000 Data For January 2024

@ukgov.financial_transactions_data_mhra.mhra_spending_over_25_000_data_for_january_2024

10.76 KB
83 rows
9 columns


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
);

MHRA Spending Over £25,000 Data For July 2023

@ukgov.financial_transactions_data_mhra.mhra_spending_over_25_000_data_for_july_2023

9.65 KB
58 rows
9 columns


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
);

MHRA Spending Over £25,000 Data For June 2023

@ukgov.financial_transactions_data_mhra.mhra_spending_over_25_000_data_for_june_2023

8.86 KB
31 rows
9 columns


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
);

MHRA Spending Over £25,000 Data For March 2024

@ukgov.financial_transactions_data_mhra.mhra_spending_over_25_000_data_for_march_2024

11.04 KB
107 rows
9 columns


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
);

MHRA Spending Over £25,000 Data For May 2023

@ukgov.financial_transactions_data_mhra.mhra_spending_over_25_000_data_for_may_2023

9.14 KB
36 rows
9 columns


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
);

MHRA Spending Over £25,000 Data For November 2023

@ukgov.financial_transactions_data_mhra.mhra_spending_over_25_000_data_for_november_2023

10.05 KB
65 rows
9 columns


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
);

MHRA Spending Over £25,000 Data For October 2023

@ukgov.financial_transactions_data_mhra.mhra_spending_over_25_000_data_for_october_2023

10.45 KB
72 rows
9 columns


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
);

MHRA Spending Over £25,000 Data For September 2023

@ukgov.financial_transactions_data_mhra.mhra_spending_over_25_000_data_for_september_2023

9.35 KB
46 rows
9 columns


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
);

November 2018

@ukgov.financial_transactions_data_mhra.november_2018

8.42 KB
32 rows
9 columns


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
);

November 2021

@ukgov.financial_transactions_data_mhra.november_2021

9.54 KB
58 rows
9 columns


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
);

October 2018

@ukgov.financial_transactions_data_mhra.october_2018

9.27 KB
48 rows
9 columns


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
);

October 2019

@ukgov.financial_transactions_data_mhra.october_2019

9.01 KB
32 rows
9 columns


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
);

October 2020

@ukgov.financial_transactions_data_mhra.october_2020

9.16 KB
50 rows
9 columns


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
);

October 2021

@ukgov.financial_transactions_data_mhra.october_2021

9.46 KB
50 rows
9 columns


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
);

September 2018

@ukgov.financial_transactions_data_mhra.september_2018

9.13 KB
51 rows
9 columns


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
);

September 2019

@ukgov.financial_transactions_data_mhra.september_2019

8.39 KB
30 rows
9 columns


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
);

September 2020

@ukgov.financial_transactions_data_mhra.september_2020

8.96 KB
32 rows
9 columns


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
);