Spend Over £25,000 In UK Sport
UK Sport
@ukgov.transparency_data
UK Sport
@ukgov.transparency_data
A list of all UK Sport financial transactions over £25,000
Publisher name: UK Sport
Last updated: 2022-07-01T04:01:28Z
CREATE TABLE spend_over_25_000_in_uk_sport (
"spend_over_25_000_publication_template" VARCHAR -- Spend Over Ś25,000 - Publication Template,
"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 transparency_april_2019 (
"unnamed_0" VARCHAR -- Unnamed: 0,
"unnamed_1" VARCHAR -- Unnamed: 1,
"document_date" TIMESTAMP,
"name" VARCHAR,
"name_1" VARCHAR,
"name_2" VARCHAR,
"document_number" BIGINT,
"value_base" DOUBLE
);CREATE TABLE transparency_august_2019 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"n__amount" DOUBLE -- Amount,
"vat_registration_number" VARCHAR
);CREATE TABLE transparency_december_2018 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" BIGINT,
"n__amount" DOUBLE -- Amount,
"vat_registration_number" VARCHAR
);CREATE TABLE transparency_february_2019 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"n__amount" DOUBLE -- Amount,
"vat_registration_number" VARCHAR
);CREATE TABLE transparency_january_2019 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"n__amount" DOUBLE -- Amount,
"vat_registration_number" VARCHAR
);CREATE TABLE transparency_july_2019 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"n__amount" DOUBLE -- Amount,
"vat_registration_number" VARCHAR
);CREATE TABLE transparency_june_2019 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"n__amount" DOUBLE -- Amount,
"vat_registration_number" VARCHAR
);CREATE TABLE transparency_may_2019 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"n__amount" DOUBLE -- Amount,
"vat_registration_number" VARCHAR
);CREATE TABLE transparency_november_2018 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" BIGINT,
"n__amount" DOUBLE -- Amount,
"vat_registration_number" VARCHAR
);CREATE TABLE transparency_october_2018 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"n__amount" DOUBLE -- Amount,
"vat_registration_number" VARCHAR
);CREATE TABLE transparency_october_2019 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"n__amount" DOUBLE -- Amount,
"vat_registration_number" VARCHAR
);CREATE TABLE transparency_september_2018 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" BIGINT,
"n__amount" DOUBLE -- Amount,
"vat_registration_number" VARCHAR
);CREATE TABLE transparency_september_2019 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"n__amount" DOUBLE -- Amount,
"vat_registration_number" VARCHAR
);Anyone who has the link will be able to view this.