Northern Ireland Office (NIO) Spending Over £25,000
Northern Ireland Office
@ukgov.nio_transparency_on_gpc_and_spending_over_f25_000_january_2022
Northern Ireland Office
@ukgov.nio_transparency_on_gpc_and_spending_over_f25_000_january_2022
A monthly-updated list of all financial transactions spending over £25,000 made by NIO, as part of the Government's commitment to transparency in expenditure.
Publisher name: Northern Ireland Office
Last updated: 2025-04-12T04:00:13Z
CREATE TABLE nio_spending_over_25_000_april_2024 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date_paid_cleared" TIMESTAMP -- Date Paid / Cleared,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier_name" VARCHAR,
"transaction_number" VARCHAR,
"individual_line_amount" VARCHAR,
"invoice_date" TIMESTAMP
);CREATE TABLE nio_spending_over_25_000_august_2023 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date_paid_cleared" VARCHAR -- Date Paid / Cleared,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier_name" VARCHAR,
"transaction_number" VARCHAR,
"individual_line_amount" VARCHAR,
"invoice_date" VARCHAR
);CREATE TABLE nio_spending_over_25_000_august_2024 (
"publication" VARCHAR,
"unnamed_1" VARCHAR -- Unnamed: 1,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7,
"unnamed_8" VARCHAR -- Unnamed: 8
);CREATE TABLE nio_spending_over_25_000_december_2023 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date_paid_cleared" TIMESTAMP -- Date Paid / Cleared,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier_name" VARCHAR,
"transaction_number" VARCHAR,
"individual_line_amount" VARCHAR,
"invoice_date" TIMESTAMP
);CREATE TABLE nio_spending_over_25_000_february_2024 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date_paid_cleared" TIMESTAMP -- Date Paid / Cleared,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier_name" VARCHAR,
"transaction_number" VARCHAR,
"individual_line_amount" VARCHAR,
"invoice_date" TIMESTAMP
);CREATE TABLE nio_spending_over_25_000_july_2022 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date_paid_cleared" TIMESTAMP -- Date Paid / Cleared,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier_name" VARCHAR,
"transaction_number" VARCHAR,
"individual_line_amount" DOUBLE,
"invoice_date" TIMESTAMP
);CREATE TABLE nio_spending_over_25_000_july_2023 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date_paid_cleared" TIMESTAMP -- Date Paid / Cleared,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier_name" VARCHAR,
"transaction_number" VARCHAR,
"individual_line_amount" VARCHAR,
"invoice_date" TIMESTAMP
);CREATE TABLE nio_spending_over_25_000_july_2024 (
"publication" VARCHAR,
"unnamed_1" VARCHAR -- Unnamed: 1,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7,
"unnamed_8" VARCHAR -- Unnamed: 8
);CREATE TABLE nio_spending_over_25_000_june_2023 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date_paid_cleared" TIMESTAMP -- Date Paid / Cleared,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier_name" VARCHAR,
"transaction_number" VARCHAR,
"individual_line_amount" VARCHAR,
"invoice_date" TIMESTAMP
);CREATE TABLE nio_spending_over_25_000_june_2024 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date_paid_cleared" TIMESTAMP -- Date Paid / Cleared,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier_name" VARCHAR,
"transaction_number" VARCHAR,
"individual_line_amount" VARCHAR,
"invoice_date" TIMESTAMP
);CREATE TABLE nio_spending_over_25_000_march_2022 (
"publication" VARCHAR,
"unnamed_1" VARCHAR -- Unnamed: 1,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7,
"unnamed_8" VARCHAR -- Unnamed: 8
);CREATE TABLE nio_spending_over_25_000_march_2023 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date_paid_cleared" TIMESTAMP -- Date Paid / Cleared,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier_name" VARCHAR,
"transaction_number" VARCHAR,
"individual_line_amount" DOUBLE,
"invoice_date" TIMESTAMP
);CREATE TABLE nio_spending_over_25_000_march_2024 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date_paid_cleared" TIMESTAMP -- Date Paid / Cleared,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier_name" VARCHAR,
"transaction_number" VARCHAR,
"individual_line_amount" VARCHAR,
"invoice_date" VARCHAR
);CREATE TABLE nio_spending_over_25_000_may_2023 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date_paid_cleared" TIMESTAMP -- Date Paid / Cleared,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier_name" VARCHAR,
"transaction_number" VARCHAR,
"individual_line_amount" VARCHAR,
"invoice_date" TIMESTAMP
);CREATE TABLE nio_spending_over_25_000_may_2024 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date_paid_cleared" TIMESTAMP -- Date Paid / Cleared,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier_name" VARCHAR,
"transaction_number" VARCHAR,
"individual_line_amount" VARCHAR,
"invoice_date" TIMESTAMP
);CREATE TABLE nio_spending_over_25_000_november_2023 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date_paid_cleared" TIMESTAMP -- Date Paid / Cleared,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier_name" VARCHAR,
"transaction_number" VARCHAR,
"individual_line_amount" VARCHAR,
"invoice_date" TIMESTAMP
);CREATE TABLE nio_spending_over_25_000_october_2023 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date_paid_cleared" TIMESTAMP -- Date Paid / Cleared,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier_name" VARCHAR,
"transaction_number" VARCHAR,
"individual_line_amount" VARCHAR,
"invoice_date" TIMESTAMP
);CREATE TABLE nio_spending_over_25_000_october_2024 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date_paid_cleared" TIMESTAMP -- Date Paid / Cleared,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier_name" VARCHAR,
"transaction_number" VARCHAR,
"individual_line_amount" VARCHAR,
"invoice_date" TIMESTAMP
);CREATE TABLE nio_spending_over_25_000_september_2023 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date_paid_cleared" TIMESTAMP -- Date Paid / Cleared,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier_name" VARCHAR,
"transaction_number" VARCHAR,
"individual_line_amount" VARCHAR,
"invoice_date" TIMESTAMP
);CREATE TABLE nio_spending_over_25_000_september_2024 (
"publication" VARCHAR,
"unnamed_1" VARCHAR -- Unnamed: 1,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7,
"unnamed_8" VARCHAR -- Unnamed: 8
);CREATE TABLE nio_s_spending_over_25_000_april_2023 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date_paid_cleared" TIMESTAMP -- Date Paid / Cleared,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier_name" VARCHAR,
"transaction_number" VARCHAR,
"individual_line_amount" DOUBLE,
"invoice_date" TIMESTAMP
);CREATE TABLE nio_transparency_on_gpc_and_spending_over_25_000_january_2022 (
"invoices_with_a_value_of_25k_or_greater_paid_between_1_8328b549" VARCHAR -- Invoices With A Value Of £25k Or Greater Paid Between 1 Jan 2022 And 31 Jan 2022,
"unnamed_1" VARCHAR -- Unnamed: 1,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7,
"unnamed_8" VARCHAR -- Unnamed: 8
);CREATE TABLE northern_ireland_office_central_government_spending_ov_5ae50349 (
"invoices_with_a_value_of_25k_or_greater_paid_between_1_6eeea38f" VARCHAR -- Invoices With A Value Of £25k Or Greater Paid Between 1 Feb 2022 And 28 Feb 2022,
"unnamed_1" VARCHAR -- Unnamed: 1,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7,
"unnamed_8" VARCHAR -- Unnamed: 8
);Anyone who has the link will be able to view this.