Confidential Waste
Leeds City Council
@ukgov.confidential_waste
Leeds City Council
@ukgov.confidential_waste
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,
"wk3" DOUBLE,
"weight_1" DOUBLE,
"wk_4" DOUBLE,
"weight_1_211d1e" DOUBLE,
"wk_5" VARCHAR,
"weight_2" VARCHAR
);
CREATE TABLE august_2013 (
"date" VARCHAR,
"site_visited" VARCHAR,
"address" VARCHAR,
"total_weight_kg" DOUBLE,
"unnamed_4" VARCHAR
);
CREATE TABLE august_2015 (
"client" VARCHAR,
"address" VARCHAR,
"type" VARCHAR,
"consoles_in_place" VARCHAR,
"week_1_recyled" VARCHAR,
"weight_kg" VARCHAR,
"week_2_recycled" VARCHAR,
"weight_kg_1" DOUBLE,
"week_3_recycled" VARCHAR,
"weight_kg_2" DOUBLE,
"week_4_recycled" VARCHAR,
"weight_kg_3" DOUBLE,
"week_5_recycled" VARCHAR,
"weight_kg_4" VARCHAR
);
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,
"wk3" VARCHAR,
"weight_1" DOUBLE,
"wk_4" VARCHAR,
"weight_1_211d1e" DOUBLE,
"wk_5" VARCHAR,
"weight_2" DOUBLE,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR
);
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,
"wk3" DOUBLE,
"weight_1" DOUBLE,
"wk_4" DOUBLE,
"weight_1_211d1e" DOUBLE,
"wk_5" DOUBLE,
"weight_2" DOUBLE
);
CREATE TABLE december_2013 (
"date" VARCHAR,
"site_visited" VARCHAR,
"address" VARCHAR,
"total_weight_kg" DOUBLE
);
CREATE TABLE december_2015 (
"client" VARCHAR,
"address" VARCHAR,
"type" VARCHAR,
"consoles_in_place" VARCHAR,
"week_1_recyled" VARCHAR,
"weight_kg" DOUBLE,
"week_2_recycled" VARCHAR,
"weight_kg_1" DOUBLE,
"week_3_recycled" VARCHAR,
"weight_kg_2" DOUBLE,
"week_4_recycled" VARCHAR,
"weight_kg_3" VARCHAR,
"week_5_recycled" VARCHAR,
"weight_kg_4" VARCHAR
);
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,
"wk3" DOUBLE,
"weight_1" DOUBLE,
"wk_4" DOUBLE,
"weight_1_211d1e" DOUBLE,
"wk_5" VARCHAR,
"weight_2" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR
);
CREATE TABLE february_2016 (
"client" VARCHAR,
"address" VARCHAR,
"type" VARCHAR,
"consoles_in_place" VARCHAR,
"week_1_recyled" VARCHAR,
"weight_kg" DOUBLE,
"week_2_recycled" DOUBLE,
"weight_kg_1" DOUBLE,
"week_3_recycled" DOUBLE,
"weight_kg_2" DOUBLE,
"week_4_recycled" DOUBLE,
"weight_kg_3" DOUBLE,
"week_5_recycled" DOUBLE,
"weight_kg_4" DOUBLE
);
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
);
CREATE TABLE january_2016 (
"client" VARCHAR,
"address" VARCHAR,
"type" VARCHAR,
"consoles_in_place" VARCHAR,
"week_1_recyled" VARCHAR,
"weight_kg" VARCHAR,
"week_2_recycled" VARCHAR,
"weight_kg_1" DOUBLE,
"week_3_recycled" DOUBLE,
"weight_kg_2" DOUBLE,
"week_4_recycled" DOUBLE,
"weight_kg_3" DOUBLE,
"week_5_recycled" VARCHAR,
"weight_kg_4" VARCHAR
);
CREATE TABLE july_2013 (
"date" VARCHAR,
"site_visited" VARCHAR,
"address" VARCHAR,
"total_weight_kg" DOUBLE
);
CREATE TABLE july_2015 (
"client" VARCHAR,
"address" VARCHAR,
"type" VARCHAR,
"consoles_in_place" VARCHAR,
"week_1_recyled" VARCHAR,
"weight_kg" VARCHAR,
"week_2_recycled" VARCHAR,
"weight_kg_1" DOUBLE,
"week_3_recycled" VARCHAR,
"weight_kg_2" DOUBLE,
"week_4_recycled" VARCHAR,
"weight_kg_3" DOUBLE,
"week_5_recycled" VARCHAR,
"weight_kg_4" DOUBLE
);
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,
"wk3" VARCHAR,
"weight_1" DOUBLE,
"wk_4" VARCHAR,
"weight_1_211d1e" DOUBLE,
"wk_5" VARCHAR,
"weight_2" DOUBLE,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR
);
CREATE TABLE june_2008_june_2013 (
"unnamed_0" VARCHAR,
"n_2008_09" VARCHAR,
"n_2009_10" DOUBLE,
"n_2010_11" DOUBLE,
"n_2011_12" DOUBLE,
"n_2012_13" DOUBLE,
"n_2013_14" DOUBLE
);
CREATE TABLE june_2015 (
"client" VARCHAR,
"address" VARCHAR,
"type" VARCHAR,
"consoles_in_place" VARCHAR,
"week_1_recyled" VARCHAR,
"weight_kg" DOUBLE,
"week_2_recycled" VARCHAR,
"weight_kg_1" VARCHAR,
"week_3_recycled" VARCHAR,
"weight_kg_2" DOUBLE,
"week_4_recycled" VARCHAR,
"weight_kg_3" DOUBLE,
"week_5_recycled" VARCHAR,
"weight_kg_4" DOUBLE
);
CREATE TABLE june_2016 (
"client" VARCHAR,
"address" VARCHAR,
"type" VARCHAR,
"consoles_in_place" VARCHAR,
"week_1_recyled" VARCHAR,
"weight_kg" VARCHAR,
"week_2_recycled" DOUBLE,
"weight_kg_1" DOUBLE,
"week_3_recycled" VARCHAR,
"weight_kg_2" DOUBLE,
"week_4_recycled" DOUBLE,
"weight_kg_3" DOUBLE,
"week_5_recycled" DOUBLE,
"weight_kg_4" DOUBLE,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR
);
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,
"wk3" VARCHAR,
"weight_1" DOUBLE,
"wk_4" DOUBLE,
"weight_1_211d1e" DOUBLE,
"wk_5" DOUBLE,
"weight_2" DOUBLE,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR
);
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,
"wk3" DOUBLE,
"weight_1" DOUBLE,
"wk_4" DOUBLE,
"weight_1_211d1e" DOUBLE,
"wk_5" DOUBLE,
"weight_2" DOUBLE,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR
);
CREATE TABLE may_2016 (
"client" VARCHAR,
"address" VARCHAR,
"type" VARCHAR,
"consoles_in_place" VARCHAR,
"week_1_recyled" VARCHAR,
"weight_kg" DOUBLE,
"week_2_recycled" VARCHAR,
"weight_kg_1" DOUBLE,
"week_3_recycled" DOUBLE,
"weight_kg_2" DOUBLE,
"week_4_recycled" DOUBLE,
"weight_kg_3" DOUBLE,
"week_5_recycled" VARCHAR,
"weight_kg_4" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR
);
CREATE TABLE november_2013 (
"date" VARCHAR,
"site_visited" VARCHAR,
"address" VARCHAR,
"total_weight_kg" DOUBLE
);
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
);
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,
"wk3" DOUBLE,
"weight_1" DOUBLE,
"wk_4" DOUBLE,
"weight_1_211d1e" DOUBLE,
"wk_5" DOUBLE,
"weight_2" DOUBLE
);
CREATE TABLE october_2015 (
"client" VARCHAR,
"address" VARCHAR,
"type" VARCHAR,
"consoles_in_place" VARCHAR,
"week_1_recyled" VARCHAR,
"weight_kg" DOUBLE,
"week_2_recycled" VARCHAR,
"weight_kg_1" DOUBLE,
"week_3_recycled" VARCHAR,
"weight_kg_2" DOUBLE,
"week_4_recycled" VARCHAR,
"weight_kg_3" DOUBLE,
"week_5_recycled" VARCHAR,
"weight_kg_4" DOUBLE
);
CREATE TABLE rebate_summary_information (
"month" VARCHAR,
"kgs_collected" DOUBLE,
"recycled" VARCHAR,
"n_30_rebate" VARCHAR
);
Anyone who has the link will be able to view this.