About this Dataset

Payments To Suppliers With A Value Over £500 From Bristol City Council

Bristol City Council individual payments to suppliers with a value over £500 made within the month. Publication of these lists forms part of the Council's commitment to be open and transparent with its residents. Each report shows: •supplier name •amount •description of what was bought •purchasing department •payment date •transaction number The amounts shown exclude VAT. Where payments under £500 appear in a report, this is either because once the VAT element is included the total is more than £500, or because an invoice for more than £500 has been broken down to reflect different items of purchase which could also include credits such as discounts. Payments made using purchase cards are presented as a separate report. The reports do not include: •banking investments •salaries •refunds •member allowances •employee remuneration payments •benefits and homelessness payments Individual's names are not shown and are replaced with the word "redacted".
Publisher name: Bristol City Council
Publisher URL: http://data.europa.eu/88u/.well-known/genid/a3a2f43f4c245bbc4b0483fdf15a3094
Last updated: 2025-03-13T04:00:23Z

Tables

April 2019

@ukgov.local_authority_spend_over_500_bristol_city_council.april_2019

121.67 kB
6,612 rows
9 columns

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
);

April 2020

@ukgov.local_authority_spend_over_500_bristol_city_council.april_2020

118.68 kB
6,611 rows
9 columns

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
);

August 2019

@ukgov.local_authority_spend_over_500_bristol_city_council.august_2019

111.01 kB
5,627 rows
9 columns

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
);

August 2020

@ukgov.local_authority_spend_over_500_bristol_city_council.august_2020

94.16 kB
4,865 rows
9 columns

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
);

December 2019

@ukgov.local_authority_spend_over_500_bristol_city_council.december_2019

112.75 kB
5,613 rows
9 columns

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
);

December 2020

@ukgov.local_authority_spend_over_500_bristol_city_council.december_2020

120.32 kB
6,850 rows
9 columns

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
);

February 2019

@ukgov.local_authority_spend_over_500_bristol_city_council.february_2019

103.97 kB
5,026 rows
9 columns

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
);

February 2020

@ukgov.local_authority_spend_over_500_bristol_city_council.february_2020

114.05 kB
5,544 rows
9 columns

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
);

January 2019

@ukgov.local_authority_spend_over_500_bristol_city_council.january_2019

104.64 kB
5,028 rows
9 columns

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
);

January 2020

@ukgov.local_authority_spend_over_500_bristol_city_council.january_2020

116.11 kB
6,368 rows
9 columns

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
);

July 2019

@ukgov.local_authority_spend_over_500_bristol_city_council.july_2019

107.52 kB
5,184 rows
9 columns

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
);

June 2019

@ukgov.local_authority_spend_over_500_bristol_city_council.june_2019

98.23 kB
4,583 rows
9 columns

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
);

March 2019

@ukgov.local_authority_spend_over_500_bristol_city_council.march_2019

122.81 kB
6,663 rows
9 columns

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
);

March 2020

@ukgov.local_authority_spend_over_500_bristol_city_council.march_2020

153.16 kB
8,178 rows
9 columns

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
);

May 2019

@ukgov.local_authority_spend_over_500_bristol_city_council.may_2019

106.17 kB
5,295 rows
9 columns

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
);

May 2020

@ukgov.local_authority_spend_over_500_bristol_city_council.may_2020

98.17 kB
5,105 rows
9 columns

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
);

November 2019

@ukgov.local_authority_spend_over_500_bristol_city_council.november_2019

102.79 kB
5,084 rows
9 columns

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
);

November 2020

@ukgov.local_authority_spend_over_500_bristol_city_council.november_2020

110.51 kB
6,080 rows
9 columns

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
);

October 2019

@ukgov.local_authority_spend_over_500_bristol_city_council.october_2019

115.82 kB
5,388 rows
9 columns

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
);

October 2020

@ukgov.local_authority_spend_over_500_bristol_city_council.october_2020

112.16 kB
5,600 rows
10 columns

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  -- Unnamed: 9
);

Payments To Suppliers With A Value Over £500 From Bristol City Council

@ukgov.local_authority_spend_over_500_bristol_city_council.payments_to_suppliers_with_a_value_over_500_from_brist_a7657dc4

134.22 kB
10,178 rows
6 columns

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
);

September 2019

@ukgov.local_authority_spend_over_500_bristol_city_council.september_2019

105.5 kB
5,264 rows
9 columns

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
);

September 2020

@ukgov.local_authority_spend_over_500_bristol_city_council.september_2020

87.72 kB
4,443 rows
9 columns

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
);