About this Dataset

Confidential Waste

Confidential waste by council building, date and amount. The council is undergoing a programme of reviewing its records therefore the data may show spikes in disposal. The contract with who disposes of this data was changed in June 2013 which is why there is a difference in what data is supplied post this date. Please note ----------- * Information here is that which has been supplied by the contractor * Due to changes data between Jan 14 to Sept 14 is unavailable * Weight is in kilograms * As at April 2015 the information provided contains rebate data
Publisher name: Leeds City Council
Last updated: 2024-09-14T09:34:42Z

Tables

April 2017

@ukgov.confidential_waste.april_2017

15.5 kB
170 rows
14 columns

CREATE TABLE april_2017 (
  "client" VARCHAR,
  "address" VARCHAR,
  "type" VARCHAR,
  "consoles_in_place" VARCHAR,
  "wk_1" VARCHAR,
  "weight" VARCHAR,
  "wk_2" VARCHAR,
  "weight_e1f8a6" DOUBLE  -- Weight,
  "wk3" DOUBLE,
  "weight_1" DOUBLE,
  "wk_4" DOUBLE,
  "weight_1_211d1e" DOUBLE  -- Weight .1,
  "wk_5" VARCHAR,
  "weight_2" VARCHAR  -- Weight .2
);

August 2013

@ukgov.confidential_waste.august_2013

8.03 kB
102 rows
5 columns

CREATE TABLE august_2013 (
  "date" VARCHAR,
  "site_visited" VARCHAR,
  "address" VARCHAR,
  "total_weight_kg" DOUBLE,
  "unnamed_4" VARCHAR  -- Unnamed: 4
);

August 2015

@ukgov.confidential_waste.august_2015

14.81 kB
130 rows
14 columns

CREATE TABLE august_2015 (
  "client" VARCHAR,
  "address" VARCHAR,
  "type" VARCHAR,
  "consoles_in_place" VARCHAR,
  "week_1_recyled" VARCHAR  -- Week 1 Recyled (Ł),
  "weight_kg" VARCHAR  -- Weight (KG),
  "week_2_recycled" VARCHAR  -- Week 2 Recycled (Ł),
  "weight_kg_1" DOUBLE  -- Weight (KG).1,
  "week_3_recycled" VARCHAR  -- Week 3 Recycled (Ł),
  "weight_kg_2" DOUBLE  -- Weight (KG).2,
  "week_4_recycled" VARCHAR  -- Week 4 Recycled (Ł),
  "weight_kg_3" DOUBLE  -- Weight (KG).3,
  "week_5_recycled" VARCHAR  -- Week 5 Recycled (Ł),
  "weight_kg_4" VARCHAR  -- Weight (KG).4
);

August 2016

@ukgov.confidential_waste.august_2016

17.55 kB
152 rows
17 columns

CREATE TABLE august_2016 (
  "client" VARCHAR,
  "address" VARCHAR,
  "type" VARCHAR,
  "consoles_in_place" VARCHAR,
  "wk_1" VARCHAR,
  "weight" DOUBLE,
  "wk_2" VARCHAR,
  "weight_e1f8a6" DOUBLE  -- Weight,
  "wk3" VARCHAR,
  "weight_1" DOUBLE,
  "wk_4" VARCHAR,
  "weight_1_211d1e" DOUBLE  -- Weight .1,
  "wk_5" VARCHAR,
  "weight_2" DOUBLE  -- Weight .2,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16
);

August 2017

@ukgov.confidential_waste.august_2017

16.61 kB
185 rows
14 columns

CREATE TABLE august_2017 (
  "client" VARCHAR,
  "address" VARCHAR,
  "type" VARCHAR,
  "consoles_in_place" VARCHAR,
  "wk_1" VARCHAR,
  "weight" DOUBLE,
  "wk_2" VARCHAR,
  "weight_e1f8a6" DOUBLE  -- Weight,
  "wk3" DOUBLE,
  "weight_1" DOUBLE,
  "wk_4" DOUBLE,
  "weight_1_211d1e" DOUBLE  -- Weight .1,
  "wk_5" DOUBLE,
  "weight_2" DOUBLE  -- Weight .2
);

December 2013

@ukgov.confidential_waste.december_2013

6.83 kB
93 rows
4 columns

CREATE TABLE december_2013 (
  "date" VARCHAR,
  "site_visited" VARCHAR,
  "address" VARCHAR,
  "total_weight_kg" DOUBLE
);

December 2015

@ukgov.confidential_waste.december_2015

14.54 kB
125 rows
14 columns

CREATE TABLE december_2015 (
  "client" VARCHAR,
  "address" VARCHAR,
  "type" VARCHAR,
  "consoles_in_place" VARCHAR,
  "week_1_recyled" VARCHAR  -- Week 1 Recyled (Ł),
  "weight_kg" DOUBLE  -- Weight (KG),
  "week_2_recycled" VARCHAR  -- Week 2 Recycled (Ł),
  "weight_kg_1" DOUBLE  -- Weight (KG).1,
  "week_3_recycled" VARCHAR  -- Week 3 Recycled (Ł),
  "weight_kg_2" DOUBLE  -- Weight (KG).2,
  "week_4_recycled" VARCHAR  -- Week 4 Recycled (Ł),
  "weight_kg_3" VARCHAR  -- Weight (KG).3,
  "week_5_recycled" VARCHAR  -- Week 5 Recycled (Ł),
  "weight_kg_4" VARCHAR  -- Weight (KG).4
);

December 2016

@ukgov.confidential_waste.december_2016

16.77 kB
170 rows
16 columns

CREATE TABLE december_2016 (
  "client" VARCHAR,
  "address" VARCHAR,
  "type" VARCHAR,
  "consoles_in_place" VARCHAR,
  "wk_1" VARCHAR,
  "weight" VARCHAR,
  "wk_2" VARCHAR,
  "weight_e1f8a6" DOUBLE  -- Weight,
  "wk3" DOUBLE,
  "weight_1" DOUBLE,
  "wk_4" DOUBLE,
  "weight_1_211d1e" DOUBLE  -- Weight .1,
  "wk_5" VARCHAR,
  "weight_2" VARCHAR  -- Weight .2,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15
);

February 2016

@ukgov.confidential_waste.february_2016

15.93 kB
135 rows
14 columns

CREATE TABLE february_2016 (
  "client" VARCHAR,
  "address" VARCHAR,
  "type" VARCHAR,
  "consoles_in_place" VARCHAR,
  "week_1_recyled" VARCHAR  -- Week 1 Recyled (Ł),
  "weight_kg" DOUBLE  -- Weight (KG),
  "week_2_recycled" DOUBLE  -- Week 2 Recycled (Ł),
  "weight_kg_1" DOUBLE  -- Weight (KG).1,
  "week_3_recycled" DOUBLE  -- Week 3 Recycled (Ł),
  "weight_kg_2" DOUBLE  -- Weight (KG).2,
  "week_4_recycled" DOUBLE  -- Week 4 Recycled (Ł),
  "weight_kg_3" DOUBLE  -- Weight (KG).3,
  "week_5_recycled" DOUBLE  -- Week 5 Recycled (Ł),
  "weight_kg_4" DOUBLE  -- Weight (KG).4
);

January 2015

@ukgov.confidential_waste.january_2015

11.62 kB
129 rows
9 columns

CREATE TABLE january_2015 (
  "client" VARCHAR,
  "address" VARCHAR,
  "consoles_in_place" VARCHAR,
  "week_1" DOUBLE,
  "week_2" DOUBLE,
  "week_3" DOUBLE,
  "week_4" DOUBLE,
  "week_5" DOUBLE,
  "total_weight_kg" DOUBLE
);

January 2016

@ukgov.confidential_waste.january_2016

15.68 kB
132 rows
14 columns

CREATE TABLE january_2016 (
  "client" VARCHAR,
  "address" VARCHAR,
  "type" VARCHAR,
  "consoles_in_place" VARCHAR,
  "week_1_recyled" VARCHAR  -- Week 1 Recyled (Ł),
  "weight_kg" VARCHAR  -- Weight (KG),
  "week_2_recycled" VARCHAR  -- Week 2 Recycled (Ł),
  "weight_kg_1" DOUBLE  -- Weight (KG).1,
  "week_3_recycled" DOUBLE  -- Week 3 Recycled (Ł),
  "weight_kg_2" DOUBLE  -- Weight (KG).2,
  "week_4_recycled" DOUBLE  -- Week 4 Recycled (Ł),
  "weight_kg_3" DOUBLE  -- Weight (KG).3,
  "week_5_recycled" VARCHAR  -- Week 5 Recycled (Ł),
  "weight_kg_4" VARCHAR  -- Weight (KG).4
);

July 2013

@ukgov.confidential_waste.july_2013

6.42 kB
60 rows
4 columns

CREATE TABLE july_2013 (
  "date" VARCHAR,
  "site_visited" VARCHAR,
  "address" VARCHAR,
  "total_weight_kg" DOUBLE
);

July 2015

@ukgov.confidential_waste.july_2015

15.17 kB
131 rows
14 columns

CREATE TABLE july_2015 (
  "client" VARCHAR,
  "address" VARCHAR,
  "type" VARCHAR,
  "consoles_in_place" VARCHAR,
  "week_1_recyled" VARCHAR  -- Week 1 Recyled (£),
  "weight_kg" VARCHAR  -- Weight (KG),
  "week_2_recycled" VARCHAR  -- Week 2 Recycled (£),
  "weight_kg_1" DOUBLE  -- Weight (KG).1,
  "week_3_recycled" VARCHAR  -- Week 3 Recycled (£),
  "weight_kg_2" DOUBLE  -- Weight (KG).2,
  "week_4_recycled" VARCHAR  -- Week 4 Recycled (£),
  "weight_kg_3" DOUBLE  -- Weight (KG).3,
  "week_5_recycled" VARCHAR  -- Week 5 Recycled (£),
  "weight_kg_4" DOUBLE  -- Weight (KG).4
);

July 2016

@ukgov.confidential_waste.july_2016

16.99 kB
148 rows
16 columns

CREATE TABLE july_2016 (
  "client" VARCHAR,
  "address" VARCHAR,
  "type" VARCHAR,
  "consoles_in_place" VARCHAR,
  "wk_1" VARCHAR,
  "weight" DOUBLE,
  "wk_2" VARCHAR,
  "weight_e1f8a6" DOUBLE  -- Weight,
  "wk3" VARCHAR,
  "weight_1" DOUBLE,
  "wk_4" VARCHAR,
  "weight_1_211d1e" DOUBLE  -- Weight .1,
  "wk_5" VARCHAR,
  "weight_2" DOUBLE  -- Weight .2,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15
);

June 2008 - June 2013

@ukgov.confidential_waste.june_2008_june_2013

6.1 kB
14 rows
7 columns

CREATE TABLE june_2008_june_2013 (
  "unnamed_0" VARCHAR  -- Unnamed: 0,
  "n_2008_09" VARCHAR  -- 2008/09,
  "n_2009_10" DOUBLE  -- 2009/10,
  "n_2010_11" DOUBLE  -- 2010/11,
  "n_2011_12" DOUBLE  -- 2011/12,
  "n_2012_13" DOUBLE  -- 2012/13,
  "n_2013_14" DOUBLE  -- 2013/14
);

June 2015

@ukgov.confidential_waste.june_2015

15.07 kB
129 rows
14 columns

CREATE TABLE june_2015 (
  "client" VARCHAR,
  "address" VARCHAR,
  "type" VARCHAR,
  "consoles_in_place" VARCHAR,
  "week_1_recyled" VARCHAR  -- Week 1 Recyled (£),
  "weight_kg" DOUBLE  -- Weight (KG),
  "week_2_recycled" VARCHAR  -- Week 2 Recycled (£),
  "weight_kg_1" VARCHAR  -- Weight (KG).1,
  "week_3_recycled" VARCHAR  -- Week 3 Recycled (£),
  "weight_kg_2" DOUBLE  -- Weight (KG).2,
  "week_4_recycled" VARCHAR  -- Week 4 Recycled (£),
  "weight_kg_3" DOUBLE  -- Weight (KG).3,
  "week_5_recycled" VARCHAR  -- Week 5 Recycled (£),
  "weight_kg_4" DOUBLE  -- Weight (KG).4
);

June 2016

@ukgov.confidential_waste.june_2016

17.56 kB
149 rows
16 columns

CREATE TABLE june_2016 (
  "client" VARCHAR,
  "address" VARCHAR,
  "type" VARCHAR,
  "consoles_in_place" VARCHAR,
  "week_1_recyled" VARCHAR  -- Week 1 Recyled (£),
  "weight_kg" VARCHAR  -- Weight (KG),
  "week_2_recycled" DOUBLE  -- Week 2 Recycled (£),
  "weight_kg_1" DOUBLE  -- Weight (KG).1,
  "week_3_recycled" VARCHAR  -- Week 3 Recycled (£),
  "weight_kg_2" DOUBLE  -- Weight (KG).2,
  "week_4_recycled" DOUBLE  -- Week 4 Recycled (£),
  "weight_kg_3" DOUBLE  -- Weight (KG).3,
  "week_5_recycled" DOUBLE  -- Week 5 Recycled (£),
  "weight_kg_4" DOUBLE  -- Weight (KG).4,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15
);

June 2017

@ukgov.confidential_waste.june_2017

17.3 kB
180 rows
16 columns

CREATE TABLE june_2017 (
  "client" VARCHAR,
  "address" VARCHAR,
  "type" VARCHAR,
  "consoles_in_place" VARCHAR,
  "wk_1" VARCHAR,
  "weight" VARCHAR,
  "wk_2" VARCHAR,
  "weight_e1f8a6" DOUBLE  -- Weight,
  "wk3" VARCHAR,
  "weight_1" DOUBLE,
  "wk_4" DOUBLE,
  "weight_1_211d1e" DOUBLE  -- Weight .1,
  "wk_5" DOUBLE,
  "weight_2" DOUBLE  -- Weight .2,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15
);

March 2018

@ukgov.confidential_waste.march_2018

18.56 kB
196 rows
17 columns

CREATE TABLE march_2018 (
  "client" VARCHAR,
  "address" VARCHAR,
  "type" VARCHAR,
  "consoles_in_place" VARCHAR,
  "wk_1" DOUBLE,
  "weight" DOUBLE,
  "wk_2" DOUBLE,
  "weight_e1f8a6" DOUBLE  -- Weight,
  "wk3" DOUBLE,
  "weight_1" DOUBLE,
  "wk_4" DOUBLE,
  "weight_1_211d1e" DOUBLE  -- Weight .1,
  "wk_5" DOUBLE,
  "weight_2" DOUBLE  -- Weight .2,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16
);

May 2016

@ukgov.confidential_waste.may_2016

16.2 kB
130 rows
16 columns

CREATE TABLE may_2016 (
  "client" VARCHAR,
  "address" VARCHAR,
  "type" VARCHAR,
  "consoles_in_place" VARCHAR,
  "week_1_recyled" VARCHAR  -- Week 1 Recyled (Ł),
  "weight_kg" DOUBLE  -- Weight (KG),
  "week_2_recycled" VARCHAR  -- Week 2 Recycled (Ł),
  "weight_kg_1" DOUBLE  -- Weight (KG).1,
  "week_3_recycled" DOUBLE  -- Week 3 Recycled (Ł),
  "weight_kg_2" DOUBLE  -- Weight (KG).2,
  "week_4_recycled" DOUBLE  -- Week 4 Recycled (Ł),
  "weight_kg_3" DOUBLE  -- Weight (KG).3,
  "week_5_recycled" VARCHAR  -- Week 5 Recycled (Ł),
  "weight_kg_4" VARCHAR  -- Weight (KG).4,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15
);

November 2013

@ukgov.confidential_waste.november_2013

7.23 kB
111 rows
4 columns

CREATE TABLE november_2013 (
  "date" VARCHAR,
  "site_visited" VARCHAR,
  "address" VARCHAR,
  "total_weight_kg" DOUBLE
);

November 2014

@ukgov.confidential_waste.november_2014

11.44 kB
122 rows
9 columns

CREATE TABLE november_2014 (
  "client" VARCHAR,
  "address" VARCHAR,
  "consoles_in_place" VARCHAR,
  "week_1" DOUBLE,
  "week_2" DOUBLE,
  "week_3" DOUBLE,
  "week_4" DOUBLE,
  "week_5" VARCHAR,
  "total_weight_kg" DOUBLE
);

November 2017

@ukgov.confidential_waste.november_2017

16.55 kB
187 rows
14 columns

CREATE TABLE november_2017 (
  "client" VARCHAR,
  "address" VARCHAR,
  "type" VARCHAR,
  "consoles_in_place" VARCHAR,
  "wk_1" VARCHAR,
  "weight" VARCHAR,
  "wk_2" VARCHAR,
  "weight_e1f8a6" DOUBLE  -- Weight,
  "wk3" DOUBLE,
  "weight_1" DOUBLE,
  "wk_4" DOUBLE,
  "weight_1_211d1e" DOUBLE  -- Weight .1,
  "wk_5" DOUBLE,
  "weight_2" DOUBLE  -- Weight .2
);

October 2015

@ukgov.confidential_waste.october_2015

15.33 kB
123 rows
14 columns

CREATE TABLE october_2015 (
  "client" VARCHAR,
  "address" VARCHAR,
  "type" VARCHAR,
  "consoles_in_place" VARCHAR,
  "week_1_recyled" VARCHAR  -- Week 1 Recyled (£),
  "weight_kg" DOUBLE  -- Weight (KG),
  "week_2_recycled" VARCHAR  -- Week 2 Recycled (£),
  "weight_kg_1" DOUBLE  -- Weight (KG).1,
  "week_3_recycled" VARCHAR  -- Week 3 Recycled (£),
  "weight_kg_2" DOUBLE  -- Weight (KG).2,
  "week_4_recycled" VARCHAR  -- Week 4 Recycled (£),
  "weight_kg_3" DOUBLE  -- Weight (KG).3,
  "week_5_recycled" VARCHAR  -- Week 5 Recycled (£),
  "weight_kg_4" DOUBLE  -- Weight (KG).4
);

Rebate Summary Information

@ukgov.confidential_waste.rebate_summary_information

4.49 kB
33 rows
4 columns

CREATE TABLE rebate_summary_information (
  "month" VARCHAR,
  "kgs_collected" DOUBLE,
  "recycled" VARCHAR,
  "n_30_rebate" VARCHAR  -- 30% Rebate
);