About this Dataset

Non-confidential Waste

Non-confidential council waste. Shows card and general waste by month and year. Data is listed by directorate, council building and bin type. PLEASE NOTE ----------- Weight is in tonnes
Publisher name: Leeds City Council
Last updated: 2024-09-14T09:30:54Z

Tables

April 2013 - September 2013

@ukgov.non_confidential_waste.april_2013_september_2013

17.68 kB
508 rows
10 columns

CREATE TABLE april_2013_september_2013 (
  "directorates" VARCHAR,
  "lcc_customer" VARCHAR,
  "bin_type" VARCHAR,
  "waste_type" VARCHAR,
  "apr_13" VARCHAR,
  "may_13" VARCHAR,
  "jun_13" DOUBLE,
  "jul_13" DOUBLE,
  "aug_13" VARCHAR,
  "sep_13" VARCHAR
);

2008/9

@ukgov.non_confidential_waste.n_2008_9

45.72 kB
641 rows
16 columns

CREATE TABLE n_2008_9 (
  "directorates" VARCHAR,
  "lcc_customer" VARCHAR,
  "bin_type" VARCHAR,
  "waste_type" VARCHAR,
  "apr_08" DOUBLE,
  "may_08" DOUBLE,
  "jun_08" DOUBLE,
  "jul_08" DOUBLE,
  "aug_08" DOUBLE,
  "sep_08" DOUBLE,
  "oct_08" DOUBLE,
  "nov_08" DOUBLE,
  "dec_08" DOUBLE,
  "jan_09" DOUBLE,
  "feb_09" DOUBLE,
  "mar_09" DOUBLE
);

2009/10

@ukgov.non_confidential_waste.n_2009_10

43.54 kB
758 rows
16 columns

CREATE TABLE n_2009_10 (
  "directorates" VARCHAR,
  "lcc_customer" VARCHAR,
  "bin_type" VARCHAR,
  "waste_type" VARCHAR,
  "apr_09" DOUBLE,
  "may_09" DOUBLE,
  "jun_09" DOUBLE,
  "jul_09" DOUBLE,
  "aug_09" DOUBLE,
  "sep_09" DOUBLE,
  "oct_09" DOUBLE,
  "nov_09" DOUBLE,
  "dec_09" DOUBLE,
  "jan_10" DOUBLE,
  "feb_10" DOUBLE,
  "mar_10" DOUBLE
);

2010/11

@ukgov.non_confidential_waste.n_2010_11

49.71 kB
724 rows
16 columns

CREATE TABLE n_2010_11 (
  "directorates" VARCHAR,
  "lcc_customer" VARCHAR,
  "bin_type" VARCHAR,
  "waste_type" VARCHAR,
  "apr_10" DOUBLE,
  "may_10" DOUBLE,
  "jun_10" DOUBLE,
  "jul_10" DOUBLE,
  "aug_10" DOUBLE,
  "sep_10" DOUBLE,
  "oct_10" DOUBLE,
  "nov_10" DOUBLE,
  "dec_10" DOUBLE,
  "jan_11" DOUBLE,
  "feb_11" DOUBLE,
  "mar_11" DOUBLE
);

2011/12

@ukgov.non_confidential_waste.n_2011_12

34.15 kB
800 rows
16 columns

CREATE TABLE n_2011_12 (
  "directorates" VARCHAR,
  "lcc_customer" VARCHAR,
  "bin_type" VARCHAR,
  "waste_type" VARCHAR,
  "apr_11" DOUBLE,
  "may_11" DOUBLE,
  "jun_11" DOUBLE,
  "jul_11" DOUBLE,
  "aug_11" DOUBLE,
  "sep_11" DOUBLE,
  "oct_11" DOUBLE,
  "nov_11" DOUBLE,
  "dec_11" DOUBLE,
  "jan_12" DOUBLE,
  "feb_12" DOUBLE,
  "mar_12" DOUBLE
);

2012/13

@ukgov.non_confidential_waste.n_2012_13

36.34 kB
860 rows
16 columns

CREATE TABLE n_2012_13 (
  "directorates" VARCHAR,
  "lcc_customer" VARCHAR,
  "bin_type" VARCHAR,
  "waste_type" VARCHAR,
  "apr_12" DOUBLE,
  "may_12" DOUBLE,
  "jun_12" DOUBLE,
  "jul_12" DOUBLE,
  "aug_12" DOUBLE,
  "sep_12" DOUBLE,
  "oct_12" DOUBLE,
  "nov_12" DOUBLE,
  "dec_12" DOUBLE,
  "jan_13" DOUBLE,
  "feb_13" DOUBLE,
  "mar_13" DOUBLE
);

2014/15

@ukgov.non_confidential_waste.n_2014_15

55.5 kB
787 rows
22 columns

CREATE TABLE n_2014_15 (
  "account" VARCHAR,
  "account_site_and_bin_type" VARCHAR  -- Account - Site And Bin Type,
  "bin_tpe" VARCHAR,
  "waste_type" VARCHAR,
  "n_01_04_2014" DOUBLE  -- 01/04/2014,
  "n_01_05_2014" DOUBLE  -- 01/05/2014,
  "n_01_06_2014" DOUBLE  -- 01/06/2014,
  "n_01_07_2014" DOUBLE  -- 01/07/2014,
  "n_01_08_2014" DOUBLE  -- 01/08/2014,
  "n_01_09_2014" DOUBLE  -- 01/09/2014,
  "n_01_10_2014" DOUBLE  -- 01/10/2014,
  "n_01_11_2014" DOUBLE  -- 01/11/2014,
  "n_01_12_2014" DOUBLE  -- 01/12/2014,
  "n_01_01_2015" DOUBLE  -- 01/01/2015,
  "n_01_02_2015" DOUBLE  -- 01/02/2015,
  "n_01_03_2015" DOUBLE  -- 01/03/2015,
  "xxx" DOUBLE,
  "unnamed_17" VARCHAR  -- Unnamed: 17,
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21
);

2015/16

@ukgov.non_confidential_waste.n_2015_16

230.97 kB
85,882 rows
5 columns

CREATE TABLE n_2015_16 (
  "eventtimestamp" VARCHAR,
  "productdescription" VARCHAR,
  "accountname" VARCHAR,
  "wastetype" VARCHAR,
  "netweight" DOUBLE
);

2016/17

@ukgov.non_confidential_waste.n_2016_17

364.19 kB
122,816 rows
5 columns

CREATE TABLE n_2016_17 (
  "eventtimestamp" VARCHAR,
  "productdescription" VARCHAR,
  "accountname" VARCHAR,
  "wastetype" VARCHAR,
  "netweight" DOUBLE
);

2017/18

@ukgov.non_confidential_waste.n_2017_18

289 kB
170,734 rows
7 columns

CREATE TABLE n_2017_18 (
  "n_4_1_2017_0_00" VARCHAR  -- 4/1/2017–0:00,
  "n_1100_litre_bin_active_general" VARCHAR  -- 1100 LITRE BIN (ACTIVE GENERAL ),
  "leeds_city_council_trade_waste" VARCHAR  -- LEEDS CITY COUNCIL - TRADE WASTE,
  "general_waste_inc_mixed_municipal_waste" VARCHAR,
  "n_67" DOUBLE  -- 67,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6
);