Confidential Waste

client Client	address Address	type Type	consoles_in_place Consoles In Place	wk_1 Wk 1	weight Weight	wk_2 Wk 2	weight_e1f8a6 Weight	wk3 Wk3	weight_1 Weight.1	wk_4 Wk 4	weight_1_211d1e Weight .1	wk_5 Wk 5	weight_2 Weight .2
Citizens & Communities	G Fl Compton Centre	Regular	1 console	È6.00	35.00
Welfare Rights	1st Floor Compton Centre	Regular	2 consoles	È6.00	50.00	6.00	30	6.00	35	6	36
Adult Social Care	1 Acorn Court, Killingbeck	Regular	1 console	È12.00	50.00
Facilities Management	1st Floor Tribeca House	Regular	1 console	È6.00	35.00
Facilities Management	Unit 2 Killinbeck Court	Regular	2 consoles	È18.00	35.00	18.00	70	18.00	25	18	40
Adult Social Care	Unit 1 Killingbeck	Regular	2 consoles
Integrated Services	Middleton Road	Regular	1 console	È6.00	20.00	6.00	25	6.90	30	6	26	6	25
Citizens & Communities	1st Floor Dewsbury Road	Regular	1 consoles
Highways & Transportation	Ring Road Middleton	Regular	7 consoles					49.20	236
Middleton Skills	Middleton Road	Regular	1 x console/ 1 x box


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
);