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
CREATE TABLE nio_spending_over_25_000_april_2024 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date_paid_cleared" TIMESTAMP,
"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,
"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_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR
);
CREATE TABLE nio_spending_over_25_000_december_2023 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date_paid_cleared" TIMESTAMP,
"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,
"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,
"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,
"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_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR
);
CREATE TABLE nio_spending_over_25_000_june_2023 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date_paid_cleared" TIMESTAMP,
"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,
"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_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR
);
CREATE TABLE nio_spending_over_25_000_march_2023 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date_paid_cleared" TIMESTAMP,
"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,
"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,
"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,
"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,
"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,
"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,
"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,
"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_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR
);
CREATE TABLE nio_s_spending_over_25_000_april_2023 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date_paid_cleared" TIMESTAMP,
"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,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR
);
CREATE TABLE northern_ireland_office_central_government_spending_ov_5ae50349 (
"invoices_with_a_value_of_25k_or_greater_paid_between_1_6eeea38f" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR
);
Anyone who has the link will be able to view this.