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.26 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

44.65 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

42.52 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

48.54 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

33.35 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

35.49 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

54.2 KB
787 rows
22 columns


CREATE TABLE n_2014_15 (
  "account" VARCHAR,
  "account_site_and_bin_type" VARCHAR,
  "bin_tpe" VARCHAR,
  "waste_type" VARCHAR,
  "n_01_04_2014" DOUBLE,
  "n_01_05_2014" DOUBLE,
  "n_01_06_2014" DOUBLE,
  "n_01_07_2014" DOUBLE,
  "n_01_08_2014" DOUBLE,
  "n_01_09_2014" DOUBLE,
  "n_01_10_2014" DOUBLE,
  "n_01_11_2014" DOUBLE,
  "n_01_12_2014" DOUBLE,
  "n_01_01_2015" DOUBLE,
  "n_01_02_2015" DOUBLE,
  "n_01_03_2015" DOUBLE,
  "xxx" DOUBLE,
  "unnamed_17" VARCHAR,
  "unnamed_18" VARCHAR,
  "unnamed_19" VARCHAR,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR
);

2015/16

@ukgov.non_confidential_waste.n_2015_16

225.56 KB
85882 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

355.66 KB
122816 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

282.23 KB
170734 rows
7 columns


CREATE TABLE n_2017_18 (
  "n_4_1_2017_0_00" VARCHAR,
  "n_1100_litre_bin_active_general" VARCHAR,
  "leeds_city_council_trade_waste" VARCHAR,
  "general_waste_inc_mixed_municipal_waste" VARCHAR,
  "n_67" DOUBLE,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR
);