Payments To Suppliers With A Value Over £500 From Cheltenham Borough Council
Cheltenham Borough Council
@ukgov.local_authority_spend_over_500_cheltenham
Cheltenham Borough Council
@ukgov.local_authority_spend_over_500_cheltenham
CREATE TABLE april_2019_payments (
"organisationuri" VARCHAR,
"organisationlabel" VARCHAR,
"organisation_unit" VARCHAR,
"transactionnumber" DOUBLE,
"invoice_ref" VARCHAR,
"beneficiary_name" VARCHAR,
"expense_type" VARCHAR,
"purpose" VARCHAR,
"payment_date" TIMESTAMP,
"amount" DOUBLE
);
CREATE TABLE april_2020_payments (
"organisationuri" VARCHAR,
"organisationlabel" VARCHAR,
"organisation_unit" VARCHAR,
"transactionnumber" DOUBLE,
"invoice_ref" VARCHAR,
"beneficiary_name" VARCHAR,
"expense_type" VARCHAR,
"purpose" VARCHAR,
"payment_date" TIMESTAMP,
"amount" DOUBLE
);
CREATE TABLE august_2019_payments (
"organisationuri" VARCHAR,
"organisationlabel" VARCHAR,
"organisation_unit" VARCHAR,
"transactionnumber" DOUBLE,
"invoice_ref" VARCHAR,
"beneficiary_name" VARCHAR,
"expense_type" VARCHAR,
"purpose" VARCHAR,
"payment_date" TIMESTAMP,
"amount" DOUBLE
);
CREATE TABLE august_2020_payments (
"organisationuri" VARCHAR,
"organisationlabel" VARCHAR,
"organisation_unit" VARCHAR,
"transactionnumber" DOUBLE,
"invoice_ref" VARCHAR,
"beneficiary_name" VARCHAR,
"expense_type" VARCHAR,
"purpose" VARCHAR,
"payment_date" TIMESTAMP,
"amount" DOUBLE,
"unnamed_10" DOUBLE
);
CREATE TABLE december_2018_payments (
"organisationuri" VARCHAR,
"organisationlabel" VARCHAR,
"organisation_unit" VARCHAR,
"transactionnumber" DOUBLE,
"invoice_ref" VARCHAR,
"beneficiary_name" VARCHAR,
"expense_type" VARCHAR,
"purpose" VARCHAR,
"payment_date" TIMESTAMP,
"amount" DOUBLE
);
CREATE TABLE december_2019_payments (
"organisationuri" VARCHAR,
"organisationlabel" VARCHAR,
"organisation_unit" VARCHAR,
"transactionnumber" DOUBLE,
"invoice_ref" VARCHAR,
"beneficiary_name" VARCHAR,
"expense_type" VARCHAR,
"purpose" VARCHAR,
"payment_date" TIMESTAMP,
"amount" DOUBLE
);
CREATE TABLE december_2020_payments (
"organisationuri" VARCHAR,
"organisationlabel" VARCHAR,
"organisation_unit" VARCHAR,
"transactionnumber" DOUBLE,
"invoice_ref" VARCHAR,
"beneficiary_name" VARCHAR,
"expense_type" VARCHAR,
"purpose" VARCHAR,
"payment_date" TIMESTAMP,
"amount" DOUBLE
);
CREATE TABLE february_2019_payments (
"organisationuri" VARCHAR,
"organisationlabel" VARCHAR,
"organisation_unit" VARCHAR,
"transactionnumber" DOUBLE,
"invoice_ref" VARCHAR,
"beneficiary_name" VARCHAR,
"expense_type" VARCHAR,
"purpose" VARCHAR,
"payment_date" TIMESTAMP,
"amount" DOUBLE
);
CREATE TABLE february_2020_payments (
"organisationuri" VARCHAR,
"organisationlabel" VARCHAR,
"organisation_unit" VARCHAR,
"transactionnumber" DOUBLE,
"invoice_ref" VARCHAR,
"beneficiary_name" VARCHAR,
"expense_type" VARCHAR,
"purpose" VARCHAR,
"payment_date" TIMESTAMP,
"amount" DOUBLE
);
CREATE TABLE january_2019_payments (
"organisationuri" VARCHAR,
"organisationlabel" VARCHAR,
"organisation_unit" VARCHAR,
"transactionnumber" DOUBLE,
"invoice_ref" VARCHAR,
"beneficiary_name" VARCHAR,
"expense_type" VARCHAR,
"purpose" VARCHAR,
"payment_date" TIMESTAMP,
"amount" DOUBLE
);
CREATE TABLE january_2020_payments (
"organisationuri" VARCHAR,
"organisationlabel" VARCHAR,
"organisation_unit" VARCHAR,
"transactionnumber" DOUBLE,
"invoice_ref" VARCHAR,
"beneficiary_name" VARCHAR,
"expense_type" VARCHAR,
"purpose" VARCHAR,
"payment_date" TIMESTAMP,
"amount" DOUBLE
);
CREATE TABLE july_2019_payments (
"organisationuri" VARCHAR,
"organisationlabel" VARCHAR,
"organisation_unit" VARCHAR,
"transactionnumber" DOUBLE,
"invoice_ref" VARCHAR,
"beneficiary_name" VARCHAR,
"expense_type" VARCHAR,
"purpose" VARCHAR,
"payment_date" TIMESTAMP,
"amount" DOUBLE
);
CREATE TABLE july_2020_payments (
"organisationuri" VARCHAR,
"organisationlabel" VARCHAR,
"organisation_unit" VARCHAR,
"transactionnumber" DOUBLE,
"invoice_ref" VARCHAR,
"beneficiary_name" VARCHAR,
"expense_type" VARCHAR,
"purpose" VARCHAR,
"payment_date" TIMESTAMP,
"amount" DOUBLE
);
CREATE TABLE june_2019_payments (
"organisationuri" VARCHAR,
"organisationlabel" VARCHAR,
"organisation_unit" VARCHAR,
"transactionnumber" DOUBLE,
"invoice_ref" VARCHAR,
"beneficiary_name" VARCHAR,
"expense_type" VARCHAR,
"purpose" VARCHAR,
"payment_date" TIMESTAMP,
"amount" DOUBLE
);
CREATE TABLE june_2020_payments (
"organisationuri" VARCHAR,
"organisationlabel" VARCHAR,
"organisation_unit" VARCHAR,
"transactionnumber" DOUBLE,
"invoice_ref" VARCHAR,
"beneficiary_name" VARCHAR,
"expense_type" VARCHAR,
"purpose" VARCHAR,
"payment_date" TIMESTAMP,
"amount" DOUBLE
);
CREATE TABLE march_2019_payments (
"organisationuri" VARCHAR,
"organisationlabel" VARCHAR,
"organisation_unit" VARCHAR,
"transactionnumber" DOUBLE,
"invoice_ref" VARCHAR,
"beneficiary_name" VARCHAR,
"expense_type" VARCHAR,
"purpose" VARCHAR,
"payment_date" TIMESTAMP,
"amount" DOUBLE
);
CREATE TABLE march_2020_payments (
"organisationuri" VARCHAR,
"organisationlabel" VARCHAR,
"organisation_unit" VARCHAR,
"transactionnumber" DOUBLE,
"invoice_ref" VARCHAR,
"beneficiary_name" VARCHAR,
"expense_type" VARCHAR,
"purpose" VARCHAR,
"payment_date" TIMESTAMP,
"amount" DOUBLE
);
CREATE TABLE may_2019_payments (
"organisationuri" VARCHAR,
"organisationlabel" VARCHAR,
"organisation_unit" VARCHAR,
"transactionnumber" DOUBLE,
"invoice_ref" VARCHAR,
"beneficiary_name" VARCHAR,
"expense_type" VARCHAR,
"purpose" VARCHAR,
"payment_date" TIMESTAMP,
"amount" DOUBLE
);
CREATE TABLE may_2020_payments (
"organisationuri" VARCHAR,
"organisationlabel" VARCHAR,
"unnamed_2" VARCHAR,
"transaction_no" DOUBLE,
"invoice_ref" VARCHAR,
"vendor_name" VARCHAR,
"unnamed_6" VARCHAR,
"expense_type" VARCHAR,
"payment_date" TIMESTAMP,
"amount" DOUBLE
);
CREATE TABLE november_2019_payments (
"organisationuri" VARCHAR,
"organisationlabel" VARCHAR,
"organisation_unit" VARCHAR,
"transactionnumber" DOUBLE,
"invoice_ref" VARCHAR,
"beneficiary_name" VARCHAR,
"expense_type" VARCHAR,
"purpose" VARCHAR,
"payment_date" TIMESTAMP,
"amount" DOUBLE
);
CREATE TABLE november_2020_payments (
"organisationuri" VARCHAR,
"organisationlabel" VARCHAR,
"organisation_unit" VARCHAR,
"transactionnumber" DOUBLE,
"invoice_ref" VARCHAR,
"beneficiary_name" VARCHAR,
"expense_type" VARCHAR,
"purpose" VARCHAR,
"payment_date" TIMESTAMP,
"amount" DOUBLE
);
CREATE TABLE october_2019_payments (
"organisationuri" VARCHAR,
"organisationlabel" VARCHAR,
"organisation_unit" VARCHAR,
"transactionnumber" DOUBLE,
"invoice_ref" VARCHAR,
"beneficiary_name" VARCHAR,
"expense_type" VARCHAR,
"purpose" VARCHAR,
"payment_date" TIMESTAMP,
"amount" DOUBLE
);
CREATE TABLE october_2020_payments (
"organisationuri" VARCHAR,
"organisationlabel" VARCHAR,
"organisation_unit" VARCHAR,
"transactionnumber" DOUBLE,
"invoice_ref" VARCHAR,
"beneficiary_name" VARCHAR,
"expense_type" VARCHAR,
"purpose" VARCHAR,
"payment_date" TIMESTAMP,
"amount" DOUBLE
);
CREATE TABLE payments_to_suppliers_with_a_value_over_500_from_chelt_64703775 (
"organisationuri" VARCHAR,
"organisationlabel" VARCHAR,
"organisationalunit" VARCHAR,
"transactionnumber" BIGINT,
"invoice_ref" VARCHAR,
"beneficiaryname" VARCHAR,
"expense_type" VARCHAR,
"purpose" VARCHAR,
"paymentdate" TIMESTAMP,
"amount" DOUBLE
);
CREATE TABLE september_2019_payments (
"organisationuri" VARCHAR,
"organisationlabel" VARCHAR,
"organisation_unit" VARCHAR,
"transactionnumber" DOUBLE,
"invoice_ref" VARCHAR,
"beneficiary_name" VARCHAR,
"expense_type" VARCHAR,
"purpose" VARCHAR,
"payment_date" TIMESTAMP,
"amount" DOUBLE
);
Anyone who has the link will be able to view this.