Waste Rates
Leicester City Council
@ukgov.waste_rates
Table 1
@ukgov.waste_rates.table_1
Waste Rates (csv)
- 8.07 KB
- 21 rows
- 8 columns
financial_year_fromFinancial Year From | financial_year_toFinancial Year To | periodPeriod | recycling_reuseRecycling Reuse | compostingComposting | recyling_reuse_compostingRecyling Reuse Composting | refuse_derived_fuelRefuse Derived Fuel | total_divertedTotal Diverted |
|---|---|---|---|---|---|---|---|
| Mon Apr 01 2002 00:00:00 GMT+0000 (Coordinated Universal Time) | Mon Mar 31 2003 00:00:00 GMT+0000 (Coordinated Universal Time) | 2002/2003 | 10.14 | 1.42 | 11.56 | 11.56 | |
| Tue Apr 01 2003 00:00:00 GMT+0000 (Coordinated Universal Time) | Wed Mar 31 2004 00:00:00 GMT+0000 (Coordinated Universal Time) | 2003/2004 | 12.24 | 2.47 | 14.71 | 14.71 | |
| Sat Apr 01 2006 00:00:00 GMT+0000 (Coordinated Universal Time) | Sat Mar 31 2007 00:00:00 GMT+0000 (Coordinated Universal Time) | 2006/2007 | 16.33 | 10.88 | 27.18 | 7.23 | 34.41 |
| Tue Apr 01 2008 00:00:00 GMT+0000 (Coordinated Universal Time) | Tue Mar 31 2009 00:00:00 GMT+0000 (Coordinated Universal Time) | 2008/2009 | 17.05 | 13.62 | 30.37 | 12.38 | 42.75 |
| Wed Apr 01 2009 00:00:00 GMT+0000 (Coordinated Universal Time) | Wed Mar 31 2010 00:00:00 GMT+0000 (Coordinated Universal Time) | 2009/2010 | 17.26 | 22.58 | 39.84 | 0.03 | 39.87 |
| Fri Apr 01 2011 00:00:00 GMT+0000 (Coordinated Universal Time) | Sat Mar 31 2012 00:00:00 GMT+0000 (Coordinated Universal Time) | 2011/2012 | 22.4 | 19.45 | 41.85 | 27.64 | 69.49 |
| Sun Apr 01 2012 00:00:00 GMT+0000 (Coordinated Universal Time) | Sun Mar 31 2013 00:00:00 GMT+0000 (Coordinated Universal Time) | 2012/2013 | 23.92 | 17.55 | 41.47 | 27.36 | 68.83 |
| Tue Apr 01 2014 00:00:00 GMT+0000 (Coordinated Universal Time) | Tue Mar 31 2015 00:00:00 GMT+0000 (Coordinated Universal Time) | 2014/2015 | 22.52 | 12.09 | 34.61 | 40.82 | 75.43 |
| Sun Apr 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time) | Sun Mar 31 2019 00:00:00 GMT+0000 (Coordinated Universal Time) | 2018/2019 | 20.63 | 18.57 | 39.2 | 31.69 | 70.89 |
| Mon Apr 01 2019 00:00:00 GMT+0000 (Coordinated Universal Time) | Tue Mar 31 2020 00:00:00 GMT+0000 (Coordinated Universal Time) | 2019/2020 | 20.86 | 22.04 | 42.9 | 25.23 | 68.13 |
CREATE TABLE table_1 (
"financial_year_from" TIMESTAMP,
"financial_year_to" TIMESTAMP,
"period" VARCHAR,
"recycling_reuse" DOUBLE,
"composting" DOUBLE,
"recyling_reuse_composting" DOUBLE,
"refuse_derived_fuel" DOUBLE,
"total_diverted" DOUBLE
);