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

MHRA Spending Over £25,000 Data For December 2023

@ukgov.financial_transactions_data_mhra.mhra_spending_over_25_000_data_for_december_2023

10.54 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

10.02 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

11.02 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.88 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

9.07 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.3 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.36 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.3 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.7 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.57 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.63 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.77 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.49 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.23 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.38 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.69 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.35 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.59 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

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

Spend Over £25,000 In MHRA

@ukgov.financial_transactions_data_mhra.spend_over_25_000_in_mhra

9.23 kB
69 rows
9 columns

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

Tables