Payments To Suppliers With A Value Over £500 From Bristol City Council
Bristol City Council
@ukgov.local_authority_spend_over_500_bristol_city_council
Bristol City Council
@ukgov.local_authority_spend_over_500_bristol_city_council
CREATE TABLE april_2019 (
"body" VARCHAR,
"body_name" VARCHAR,
"name" VARCHAR,
"amount" DOUBLE,
"pay_date" TIMESTAMP,
"transaction_number" BIGINT,
"description_1" VARCHAR,
"description_2" VARCHAR,
"description_3" VARCHAR
);
CREATE TABLE april_2020 (
"body" VARCHAR,
"body_name" VARCHAR,
"name" VARCHAR,
"amount" DOUBLE,
"pay_date" TIMESTAMP,
"transaction_number" DOUBLE,
"description_1" VARCHAR,
"description_2" VARCHAR,
"description_3" VARCHAR
);
CREATE TABLE august_2019 (
"body" VARCHAR,
"body_name" VARCHAR,
"name" VARCHAR,
"amount" DOUBLE,
"pay_date" TIMESTAMP,
"transaction_number" BIGINT,
"description_1" VARCHAR,
"description_2" VARCHAR,
"description_3" VARCHAR
);
CREATE TABLE august_2020 (
"body" VARCHAR,
"body_name" VARCHAR,
"name" VARCHAR,
"amount" DOUBLE,
"pay_date" TIMESTAMP,
"transaction_number" BIGINT,
"description_1" VARCHAR,
"description_2" VARCHAR,
"description_3" VARCHAR
);
CREATE TABLE december_2019 (
"body" VARCHAR,
"body_name" VARCHAR,
"name" VARCHAR,
"amount" DOUBLE,
"pay_date" TIMESTAMP,
"transaction_number" BIGINT,
"description_1" VARCHAR,
"description_2" VARCHAR,
"description_3" VARCHAR
);
CREATE TABLE december_2020 (
"body" VARCHAR,
"body_name" VARCHAR,
"name" VARCHAR,
"amount" DOUBLE,
"pay_date" TIMESTAMP,
"transaction_number" BIGINT,
"description_1" VARCHAR,
"description_2" VARCHAR,
"description_3" VARCHAR
);
CREATE TABLE february_2019 (
"body" VARCHAR,
"body_name" VARCHAR,
"name" VARCHAR,
"amount" DOUBLE,
"pay_date" TIMESTAMP,
"transaction_number" DOUBLE,
"description_1" VARCHAR,
"description_2" VARCHAR,
"description_3" VARCHAR
);
CREATE TABLE february_2020 (
"body" VARCHAR,
"body_name" VARCHAR,
"name" VARCHAR,
"amount" DOUBLE,
"pay_date" TIMESTAMP,
"transaction_number" BIGINT,
"description_1" VARCHAR,
"description_2" VARCHAR,
"description_3" VARCHAR
);
CREATE TABLE january_2019 (
"body" VARCHAR,
"body_name" VARCHAR,
"name" VARCHAR,
"amount" DOUBLE,
"pay_date" TIMESTAMP,
"transaction_number" BIGINT,
"description_1" VARCHAR,
"description_2" VARCHAR,
"description_3" VARCHAR
);
CREATE TABLE january_2020 (
"body" VARCHAR,
"body_name" VARCHAR,
"name" VARCHAR,
"amount" DOUBLE,
"pay_date" TIMESTAMP,
"transaction_number" BIGINT,
"description_1" VARCHAR,
"description_2" VARCHAR,
"description_3" VARCHAR
);
CREATE TABLE july_2019 (
"body" VARCHAR,
"body_name" VARCHAR,
"name" VARCHAR,
"amount" DOUBLE,
"pay_date" TIMESTAMP,
"transaction_number" BIGINT,
"description_1" VARCHAR,
"description_2" VARCHAR,
"description_3" VARCHAR
);
CREATE TABLE june_2019 (
"body" VARCHAR,
"body_name" VARCHAR,
"name" VARCHAR,
"amount" DOUBLE,
"pay_date" TIMESTAMP,
"transaction_number" DOUBLE,
"description_1" VARCHAR,
"description_2" VARCHAR,
"description_3" VARCHAR
);
CREATE TABLE march_2019 (
"body" VARCHAR,
"body_name" VARCHAR,
"name" VARCHAR,
"amount" DOUBLE,
"pay_date" TIMESTAMP,
"transaction_number" BIGINT,
"description_1" VARCHAR,
"description_2" VARCHAR,
"description_3" VARCHAR
);
CREATE TABLE march_2020 (
"body" VARCHAR,
"body_name" VARCHAR,
"name" VARCHAR,
"amount" DOUBLE,
"pay_date" TIMESTAMP,
"transaction_number" BIGINT,
"description_1" VARCHAR,
"description_2" VARCHAR,
"description_3" VARCHAR
);
CREATE TABLE may_2019 (
"body" VARCHAR,
"body_name" VARCHAR,
"name" VARCHAR,
"amount" DOUBLE,
"pay_date" TIMESTAMP,
"transaction_number" BIGINT,
"description_1" VARCHAR,
"description_2" VARCHAR,
"description_3" VARCHAR
);
CREATE TABLE may_2020 (
"body" VARCHAR,
"body_name" VARCHAR,
"name" VARCHAR,
"amount" DOUBLE,
"pay_date" TIMESTAMP,
"transaction_number" BIGINT,
"description_1" VARCHAR,
"description_2" VARCHAR,
"description_3" VARCHAR
);
CREATE TABLE november_2019 (
"body" VARCHAR,
"body_name" VARCHAR,
"name" VARCHAR,
"amount" DOUBLE,
"pay_date" TIMESTAMP,
"transaction_number" BIGINT,
"description_1" VARCHAR,
"description_2" VARCHAR,
"description_3" VARCHAR
);
CREATE TABLE november_2020 (
"body" VARCHAR,
"body_name" VARCHAR,
"name" VARCHAR,
"amount" DOUBLE,
"pay_date" TIMESTAMP,
"transaction_number" BIGINT,
"description_1" VARCHAR,
"description_2" VARCHAR,
"description_3" VARCHAR
);
CREATE TABLE october_2019 (
"body" VARCHAR,
"body_name" VARCHAR,
"name" VARCHAR,
"amount" DOUBLE,
"pay_date" TIMESTAMP,
"transaction_number" BIGINT,
"description_1" VARCHAR,
"description_2" VARCHAR,
"description_3" VARCHAR
);
CREATE TABLE october_2020 (
"body" VARCHAR,
"body_name" VARCHAR,
"name" VARCHAR,
"amount" DOUBLE,
"pay_date" TIMESTAMP,
"transaction_number" BIGINT,
"description_1" VARCHAR,
"description_2" VARCHAR,
"description_3" VARCHAR,
"unnamed_9" VARCHAR
);
CREATE TABLE payments_to_suppliers_with_a_value_over_500_from_brist_a7657dc4 (
"supplier" VARCHAR,
"amount" DOUBLE,
"pay_date" VARCHAR,
"description_1" VARCHAR,
"description_2" VARCHAR,
"description_3" VARCHAR
);
CREATE TABLE september_2019 (
"body" VARCHAR,
"body_name" VARCHAR,
"name" VARCHAR,
"amount" DOUBLE,
"pay_date" TIMESTAMP,
"transaction_number" BIGINT,
"description_1" VARCHAR,
"description_2" VARCHAR,
"description_3" VARCHAR
);
CREATE TABLE september_2020 (
"body" VARCHAR,
"body_name" VARCHAR,
"name" VARCHAR,
"amount" DOUBLE,
"pay_date" TIMESTAMP,
"transaction_number" BIGINT,
"description_1" VARCHAR,
"description_2" VARCHAR,
"description_3" VARCHAR
);
Anyone who has the link will be able to view this.