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	£7.00	50							7	40
Welfare Rights	1st Floor Compton Centre	Regular	2 consoles	£7.00	40	7	35	27	170	7	40	7	20
Adult Social Care	1 Acorn Court, Killingbeck	Regular	1 console	£14.00	55							14	60
Facilities Management	1st Floor Tribeca House	Regular	1 console									7	36
Facilities Management	Unit 2 Killinbeck Court	Regular	2 consoles	£21.00	28	21	30	21	25	21	25	21	30
Adult Social Care	Unit 1 Killingbeck	Regular	2 consoles
Integrated Services	Middleton Road	Regular	1 console	£7.00	25	7	20	7	15	7	18	7	25
Citizens & Communities	1st Floor Dewsbury Road	Regular	1 consoles
Housing l eeds	1st Floor Dewsbury One stp	Regular	3 consoles					21	62
Contracts	Knowsthorpe Gate	Regular	1 console			7	20


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