Department For Infrastructure (DfI) Departmental Spend Over £25,000 - 2024/25
OpenDataNI
@ukgov.department_for_infrastructure_dfi_departmental_spend_o_e0dd5601
OpenDataNI
@ukgov.department_for_infrastructure_dfi_departmental_spend_o_e0dd5601
CREATE TABLE dfi_departmental_spend_over_25000_for_april_2024 (
"department" VARCHAR,
"organisation" VARCHAR,
"check_date" TIMESTAMP,
"expense_type" VARCHAR,
"supplier" VARCHAR,
"invoice_number" VARCHAR,
"invoice_amount" VARCHAR,
"postcode" VARCHAR
);
CREATE TABLE dfi_departmental_spend_over_25000_for_august_2024 (
"department" VARCHAR,
"organisation" VARCHAR,
"check_date" TIMESTAMP,
"expense_type" VARCHAR,
"supplier" VARCHAR,
"invoice_number" VARCHAR,
"invoice_amount" VARCHAR,
"postcode" VARCHAR
);
CREATE TABLE dfi_departmental_spend_over_25000_for_december_2024 (
"department" VARCHAR,
"organisation" VARCHAR,
"check_date" TIMESTAMP,
"expense_type" VARCHAR,
"supplier" VARCHAR,
"invoice_number" VARCHAR,
"invoice_amount" VARCHAR,
"postcode" VARCHAR,
"unnamed_8" VARCHAR
);
CREATE TABLE dfi_departmental_spend_over_25000_for_february_2025 (
"department" VARCHAR,
"organisation" VARCHAR,
"check_date" TIMESTAMP,
"expense_type" VARCHAR,
"supplier" VARCHAR,
"invoice_number" VARCHAR,
"invoice_amount" VARCHAR,
"postcode" VARCHAR
);
CREATE TABLE dfi_departmental_spend_over_25000_for_january_2025 (
"department" VARCHAR,
"organisation" VARCHAR,
"check_date" TIMESTAMP,
"expense_type" VARCHAR,
"supplier" VARCHAR,
"invoice_number" VARCHAR,
"invoice_amount" VARCHAR,
"postcode" VARCHAR
);
CREATE TABLE dfi_departmental_spend_over_25000_for_july_2024 (
"department" VARCHAR,
"organisation" VARCHAR,
"check_date" TIMESTAMP,
"expense_type" VARCHAR,
"supplier" VARCHAR,
"invoice_number" VARCHAR,
"invoice_amount" VARCHAR,
"postcode" VARCHAR
);
CREATE TABLE dfi_departmental_spend_over_25000_for_june_2024 (
"department" VARCHAR,
"organisation" VARCHAR,
"check_date" TIMESTAMP,
"expense_type" VARCHAR,
"supplier" VARCHAR,
"invoice_number" VARCHAR,
"invoice_amount" VARCHAR,
"postcode" VARCHAR
);
CREATE TABLE dfi_departmental_spend_over_25000_for_march_2025 (
"department" VARCHAR,
"organisation" VARCHAR,
"check_date" TIMESTAMP,
"expense_type" VARCHAR,
"supplier" VARCHAR,
"invoice_number" VARCHAR,
"invoice_amount" VARCHAR,
"postcode" VARCHAR
);
CREATE TABLE dfi_departmental_spend_over_25000_for_may_2024 (
"department" VARCHAR,
"organisation" VARCHAR,
"check_date" TIMESTAMP,
"expense_type" VARCHAR,
"supplier" VARCHAR,
"invoice_number" VARCHAR,
"invoice_amount" VARCHAR,
"postcode" VARCHAR
);
CREATE TABLE dfi_departmental_spend_over_25000_for_november_2024 (
"department" VARCHAR,
"organisation" VARCHAR,
"check_date" TIMESTAMP,
"expense_type" VARCHAR,
"supplier" VARCHAR,
"invoice_number" VARCHAR,
"invoice_amount" VARCHAR,
"postcode" VARCHAR
);
CREATE TABLE dfi_departmental_spend_over_25000_for_october_2024 (
"department" VARCHAR,
"organisation" VARCHAR,
"check_date" TIMESTAMP,
"expense_type" VARCHAR,
"supplier" VARCHAR,
"invoice_number" VARCHAR,
"invoice_amount" VARCHAR,
"postcode" VARCHAR,
"unnamed_8" VARCHAR
);
CREATE TABLE dfi_departmental_spend_over_25000_for_september_2024 (
"department" VARCHAR,
"organisation" VARCHAR,
"check_date" TIMESTAMP,
"expense_type" VARCHAR,
"supplier" VARCHAR,
"invoice_number" VARCHAR,
"invoice_amount" VARCHAR,
"postcode" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" DOUBLE
);
Anyone who has the link will be able to view this.