Spend Over £25,000 In UK Sport
UK Sport
@ukgov.transparency_data
UK Sport
@ukgov.transparency_data
CREATE TABLE spend_over_25_000_in_uk_sport (
"spend_over_25_000_publication_template" 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 transparency_april_2019 (
"unnamed_0" VARCHAR,
"unnamed_1" VARCHAR,
"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,
"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,
"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,
"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,
"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,
"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,
"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,
"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,
"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,
"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,
"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,
"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,
"vat_registration_number" VARCHAR
);
Anyone who has the link will be able to view this.