Baselight
Sign In

Payments To Suppliers With A Value Over £500 From Cheltenham Borough Council

Cheltenham Borough Council

@ukgov.local_authority_spend_over_500_cheltenham

Loading...
Loading...

About this Dataset

Payments To Suppliers With A Value Over £500 From Cheltenham Borough Council

The reports list the payments to suppliers where the charge to a specific cost centre is greater than or equal to £500. Publication of these lists forms part of the council’s commitment to be open and transparent with its residents.
Publisher name: Cheltenham Borough Council
Last updated: 2022-07-01T04:01:51Z

Tables

April 2019 Payments

@ukgov.local_authority_spend_over_500_cheltenham.april_2019_payments
  • 24.28 kB
  • 318 rows
  • 10 columns
Loading... 
CREATE TABLE april_2019_payments (
  "organisationuri" VARCHAR,
  "organisationlabel" VARCHAR,
  "organisation_unit" VARCHAR,
  "transactionnumber" DOUBLE,
  "invoice_ref" VARCHAR  -- Invoice Ref.,
  "beneficiary_name" VARCHAR,
  "expense_type" VARCHAR,
  "purpose" VARCHAR,
  "payment_date" TIMESTAMP,
  "amount" DOUBLE
);

April 2020 Payments

@ukgov.local_authority_spend_over_500_cheltenham.april_2020_payments
  • 24.8 kB
  • 310 rows
  • 10 columns
Loading... 
CREATE TABLE april_2020_payments (
  "organisationuri" VARCHAR,
  "organisationlabel" VARCHAR,
  "organisation_unit" VARCHAR,
  "transactionnumber" DOUBLE,
  "invoice_ref" VARCHAR  -- Invoice Ref.,
  "beneficiary_name" VARCHAR,
  "expense_type" VARCHAR,
  "purpose" VARCHAR,
  "payment_date" TIMESTAMP,
  "amount" DOUBLE
);

August 2019 Payments

@ukgov.local_authority_spend_over_500_cheltenham.august_2019_payments
  • 23.79 kB
  • 299 rows
  • 10 columns
Loading... 
CREATE TABLE august_2019_payments (
  "organisationuri" VARCHAR,
  "organisationlabel" VARCHAR,
  "organisation_unit" VARCHAR,
  "transactionnumber" DOUBLE,
  "invoice_ref" VARCHAR  -- Invoice Ref.,
  "beneficiary_name" VARCHAR,
  "expense_type" VARCHAR,
  "purpose" VARCHAR,
  "payment_date" TIMESTAMP,
  "amount" DOUBLE
);

August 2020 Payments

@ukgov.local_authority_spend_over_500_cheltenham.august_2020_payments
  • 20.43 kB
  • 187 rows
  • 11 columns
Loading... 
CREATE TABLE august_2020_payments (
  "organisationuri" VARCHAR,
  "organisationlabel" VARCHAR,
  "organisation_unit" VARCHAR,
  "transactionnumber" DOUBLE,
  "invoice_ref" VARCHAR  -- Invoice Ref.,
  "beneficiary_name" VARCHAR,
  "expense_type" VARCHAR,
  "purpose" VARCHAR,
  "payment_date" TIMESTAMP,
  "amount" DOUBLE,
  "unnamed_10" DOUBLE  -- Unnamed: 10
);

December 2018 Payments

@ukgov.local_authority_spend_over_500_cheltenham.december_2018_payments
  • 22.41 kB
  • 252 rows
  • 10 columns
Loading... 
CREATE TABLE december_2018_payments (
  "organisationuri" VARCHAR,
  "organisationlabel" VARCHAR,
  "organisation_unit" VARCHAR,
  "transactionnumber" DOUBLE,
  "invoice_ref" VARCHAR  -- Invoice Ref.,
  "beneficiary_name" VARCHAR,
  "expense_type" VARCHAR,
  "purpose" VARCHAR,
  "payment_date" TIMESTAMP,
  "amount" DOUBLE
);

December 2019 Payments

@ukgov.local_authority_spend_over_500_cheltenham.december_2019_payments
  • 24.34 kB
  • 311 rows
  • 10 columns
Loading... 
CREATE TABLE december_2019_payments (
  "organisationuri" VARCHAR,
  "organisationlabel" VARCHAR,
  "organisation_unit" VARCHAR,
  "transactionnumber" DOUBLE,
  "invoice_ref" VARCHAR  -- Invoice Ref.,
  "beneficiary_name" VARCHAR,
  "expense_type" VARCHAR,
  "purpose" VARCHAR,
  "payment_date" TIMESTAMP,
  "amount" DOUBLE
);

December 2020 Payments

@ukgov.local_authority_spend_over_500_cheltenham.december_2020_payments
  • 25.8 kB
  • 408 rows
  • 10 columns
Loading... 
CREATE TABLE december_2020_payments (
  "organisationuri" VARCHAR,
  "organisationlabel" VARCHAR,
  "organisation_unit" VARCHAR,
  "transactionnumber" DOUBLE,
  "invoice_ref" VARCHAR  -- Invoice Ref.,
  "beneficiary_name" VARCHAR,
  "expense_type" VARCHAR,
  "purpose" VARCHAR,
  "payment_date" TIMESTAMP,
  "amount" DOUBLE
);

February 2019 Payments

@ukgov.local_authority_spend_over_500_cheltenham.february_2019_payments
  • 23.02 kB
  • 302 rows
  • 10 columns
Loading... 
CREATE TABLE february_2019_payments (
  "organisationuri" VARCHAR,
  "organisationlabel" VARCHAR,
  "organisation_unit" VARCHAR,
  "transactionnumber" DOUBLE,
  "invoice_ref" VARCHAR  -- Invoice Ref.,
  "beneficiary_name" VARCHAR,
  "expense_type" VARCHAR,
  "purpose" VARCHAR,
  "payment_date" TIMESTAMP,
  "amount" DOUBLE
);

February 2020 Payments

@ukgov.local_authority_spend_over_500_cheltenham.february_2020_payments
  • 20.58 kB
  • 242 rows
  • 10 columns
Loading... 
CREATE TABLE february_2020_payments (
  "organisationuri" VARCHAR,
  "organisationlabel" VARCHAR,
  "organisation_unit" VARCHAR,
  "transactionnumber" DOUBLE,
  "invoice_ref" VARCHAR  -- Invoice Ref.,
  "beneficiary_name" VARCHAR,
  "expense_type" VARCHAR,
  "purpose" VARCHAR,
  "payment_date" TIMESTAMP,
  "amount" DOUBLE
);

January 2019 Payments

@ukgov.local_authority_spend_over_500_cheltenham.january_2019_payments
  • 24.76 kB
  • 317 rows
  • 10 columns
Loading... 
CREATE TABLE january_2019_payments (
  "organisationuri" VARCHAR,
  "organisationlabel" VARCHAR,
  "organisation_unit" VARCHAR,
  "transactionnumber" DOUBLE,
  "invoice_ref" VARCHAR  -- Invoice Ref.,
  "beneficiary_name" VARCHAR,
  "expense_type" VARCHAR,
  "purpose" VARCHAR,
  "payment_date" TIMESTAMP,
  "amount" DOUBLE
);

January 2020 Payments

@ukgov.local_authority_spend_over_500_cheltenham.january_2020_payments
  • 24.79 kB
  • 312 rows
  • 10 columns
Loading... 
CREATE TABLE january_2020_payments (
  "organisationuri" VARCHAR,
  "organisationlabel" VARCHAR,
  "organisation_unit" VARCHAR,
  "transactionnumber" DOUBLE,
  "invoice_ref" VARCHAR  -- Invoice Ref.,
  "beneficiary_name" VARCHAR,
  "expense_type" VARCHAR,
  "purpose" VARCHAR,
  "payment_date" TIMESTAMP,
  "amount" DOUBLE
);

July 2019 Payments

@ukgov.local_authority_spend_over_500_cheltenham.july_2019_payments
  • 24.52 kB
  • 370 rows
  • 10 columns
Loading... 
CREATE TABLE july_2019_payments (
  "organisationuri" VARCHAR,
  "organisationlabel" VARCHAR,
  "organisation_unit" VARCHAR,
  "transactionnumber" DOUBLE,
  "invoice_ref" VARCHAR  -- Invoice Ref.,
  "beneficiary_name" VARCHAR,
  "expense_type" VARCHAR,
  "purpose" VARCHAR,
  "payment_date" TIMESTAMP,
  "amount" DOUBLE
);

July 2020 Payments

@ukgov.local_authority_spend_over_500_cheltenham.july_2020_payments
  • 23.63 kB
  • 283 rows
  • 10 columns
Loading... 
CREATE TABLE july_2020_payments (
  "organisationuri" VARCHAR,
  "organisationlabel" VARCHAR,
  "organisation_unit" VARCHAR,
  "transactionnumber" DOUBLE,
  "invoice_ref" VARCHAR  -- Invoice Ref.,
  "beneficiary_name" VARCHAR,
  "expense_type" VARCHAR,
  "purpose" VARCHAR,
  "payment_date" TIMESTAMP,
  "amount" DOUBLE
);

June 2019 Payments

@ukgov.local_authority_spend_over_500_cheltenham.june_2019_payments
  • 23.64 kB
  • 291 rows
  • 10 columns
Loading... 
CREATE TABLE june_2019_payments (
  "organisationuri" VARCHAR,
  "organisationlabel" VARCHAR,
  "organisation_unit" VARCHAR,
  "transactionnumber" DOUBLE,
  "invoice_ref" VARCHAR  -- Invoice Ref.,
  "beneficiary_name" VARCHAR,
  "expense_type" VARCHAR,
  "purpose" VARCHAR,
  "payment_date" TIMESTAMP,
  "amount" DOUBLE
);

June 2020 Payments

@ukgov.local_authority_spend_over_500_cheltenham.june_2020_payments
  • 21.2 kB
  • 225 rows
  • 10 columns
Loading... 
CREATE TABLE june_2020_payments (
  "organisationuri" VARCHAR,
  "organisationlabel" VARCHAR,
  "organisation_unit" VARCHAR,
  "transactionnumber" DOUBLE,
  "invoice_ref" VARCHAR  -- Invoice Ref.,
  "beneficiary_name" VARCHAR,
  "expense_type" VARCHAR,
  "purpose" VARCHAR,
  "payment_date" TIMESTAMP,
  "amount" DOUBLE
);

March 2019 Payments

@ukgov.local_authority_spend_over_500_cheltenham.march_2019_payments
  • 27.05 kB
  • 387 rows
  • 10 columns
Loading... 
CREATE TABLE march_2019_payments (
  "organisationuri" VARCHAR,
  "organisationlabel" VARCHAR,
  "organisation_unit" VARCHAR,
  "transactionnumber" DOUBLE,
  "invoice_ref" VARCHAR  -- Invoice Ref.,
  "beneficiary_name" VARCHAR,
  "expense_type" VARCHAR,
  "purpose" VARCHAR,
  "payment_date" TIMESTAMP,
  "amount" DOUBLE
);

March 2020 Payments

@ukgov.local_authority_spend_over_500_cheltenham.march_2020_payments
  • 28.21 kB
  • 406 rows
  • 10 columns
Loading... 
CREATE TABLE march_2020_payments (
  "organisationuri" VARCHAR,
  "organisationlabel" VARCHAR,
  "organisation_unit" VARCHAR,
  "transactionnumber" DOUBLE,
  "invoice_ref" VARCHAR  -- Invoice Ref.,
  "beneficiary_name" VARCHAR,
  "expense_type" VARCHAR,
  "purpose" VARCHAR,
  "payment_date" TIMESTAMP,
  "amount" DOUBLE
);

May 2019 Payments

@ukgov.local_authority_spend_over_500_cheltenham.may_2019_payments
  • 24.19 kB
  • 301 rows
  • 10 columns
Loading... 
CREATE TABLE may_2019_payments (
  "organisationuri" VARCHAR,
  "organisationlabel" VARCHAR,
  "organisation_unit" VARCHAR,
  "transactionnumber" DOUBLE,
  "invoice_ref" VARCHAR  -- Invoice Ref.,
  "beneficiary_name" VARCHAR,
  "expense_type" VARCHAR,
  "purpose" VARCHAR,
  "payment_date" TIMESTAMP,
  "amount" DOUBLE
);

May 2020 Payments

@ukgov.local_authority_spend_over_500_cheltenham.may_2020_payments
  • 22.51 kB
  • 268 rows
  • 10 columns
Loading... 
CREATE TABLE may_2020_payments (
  "organisationuri" VARCHAR,
  "organisationlabel" VARCHAR,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "transaction_no" DOUBLE,
  "invoice_ref" VARCHAR  -- Invoice Ref.,
  "vendor_name" VARCHAR,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "expense_type" VARCHAR,
  "payment_date" TIMESTAMP,
  "amount" DOUBLE
);

November 2019 Payments

@ukgov.local_authority_spend_over_500_cheltenham.november_2019_payments
  • 26.29 kB
  • 361 rows
  • 10 columns
Loading... 
CREATE TABLE november_2019_payments (
  "organisationuri" VARCHAR,
  "organisationlabel" VARCHAR,
  "organisation_unit" VARCHAR,
  "transactionnumber" DOUBLE,
  "invoice_ref" VARCHAR  -- Invoice Ref.,
  "beneficiary_name" VARCHAR,
  "expense_type" VARCHAR,
  "purpose" VARCHAR,
  "payment_date" TIMESTAMP,
  "amount" DOUBLE
);

November 2020 Payments

@ukgov.local_authority_spend_over_500_cheltenham.november_2020_payments
  • 20.24 kB
  • 215 rows
  • 10 columns
Loading... 
CREATE TABLE november_2020_payments (
  "organisationuri" VARCHAR,
  "organisationlabel" VARCHAR,
  "organisation_unit" VARCHAR,
  "transactionnumber" DOUBLE,
  "invoice_ref" VARCHAR  -- Invoice Ref.,
  "beneficiary_name" VARCHAR,
  "expense_type" VARCHAR,
  "purpose" VARCHAR,
  "payment_date" TIMESTAMP,
  "amount" DOUBLE
);

October 2019 Payments

@ukgov.local_authority_spend_over_500_cheltenham.october_2019_payments
  • 24.68 kB
  • 307 rows
  • 10 columns
Loading... 
CREATE TABLE october_2019_payments (
  "organisationuri" VARCHAR,
  "organisationlabel" VARCHAR,
  "organisation_unit" VARCHAR,
  "transactionnumber" DOUBLE,
  "invoice_ref" VARCHAR  -- Invoice Ref.,
  "beneficiary_name" VARCHAR,
  "expense_type" VARCHAR,
  "purpose" VARCHAR,
  "payment_date" TIMESTAMP,
  "amount" DOUBLE
);

October 2020 Payments

@ukgov.local_authority_spend_over_500_cheltenham.october_2020_payments
  • 25.54 kB
  • 365 rows
  • 10 columns
Loading... 
CREATE TABLE october_2020_payments (
  "organisationuri" VARCHAR,
  "organisationlabel" VARCHAR,
  "organisation_unit" VARCHAR,
  "transactionnumber" DOUBLE,
  "invoice_ref" VARCHAR  -- Invoice Ref.,
  "beneficiary_name" VARCHAR,
  "expense_type" VARCHAR,
  "purpose" VARCHAR,
  "payment_date" TIMESTAMP,
  "amount" DOUBLE
);

Payments To Suppliers With A Value Over £500 From Cheltenham Borough Council

@ukgov.local_authority_spend_over_500_cheltenham.payments_to_suppliers_with_a_value_over_500_from_chelt_64703775
  • 23.29 kB
  • 294 rows
  • 10 columns
Loading... 
CREATE TABLE payments_to_suppliers_with_a_value_over_500_from_chelt_64703775 (
  "organisationuri" VARCHAR,
  "organisationlabel" VARCHAR,
  "organisationalunit" VARCHAR,
  "transactionnumber" BIGINT,
  "invoice_ref" VARCHAR  -- Invoice Ref.,
  "beneficiaryname" VARCHAR,
  "expense_type" VARCHAR,
  "purpose" VARCHAR,
  "paymentdate" TIMESTAMP,
  "amount" DOUBLE
);

September 2019 Payments

@ukgov.local_authority_spend_over_500_cheltenham.september_2019_payments
  • 24.62 kB
  • 326 rows
  • 10 columns
Loading... 
CREATE TABLE september_2019_payments (
  "organisationuri" VARCHAR,
  "organisationlabel" VARCHAR,
  "organisation_unit" VARCHAR,
  "transactionnumber" DOUBLE,
  "invoice_ref" VARCHAR  -- Invoice Ref.,
  "beneficiary_name" VARCHAR,
  "expense_type" VARCHAR,
  "purpose" VARCHAR,
  "payment_date" TIMESTAMP,
  "amount" DOUBLE
);

Share link

Anyone who has the link will be able to view this.