Council Spending

body Body	body_name Body Name	service_label Service Label	service_divison_label Service Divison Label	expenditure_category Expenditure Category	detailed_expenses_type Detailed Expenses Type	detailed_expense_code Detailed Expense Code	date_paid Date Paid	transaction_number Transaction Number	net_amount Net Amount	capital_or_revenue Capital Or Revenue	supplier_name Supplier Name
http://statistics.data.gov.uk/doc/local-authority/00DA	Leeds City Council	Central & Corporate Functions	Commercial Services Trading Services	Supplies and Services	Operational Materials	205	Thu Dec 29 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	1112-00001	488.34	R	A & A Electrical Distributors Ltd
http://statistics.data.gov.uk/doc/local-authority/00DA	Leeds City Council	Childrens Services	Learning Skills & Universal	Supplies and Services	Other Hired And Contracted Services	265	Mon Dec 19 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	1112-00002	4000	R	A + C Mealing
http://statistics.data.gov.uk/doc/local-authority/00DA	East - North East	East - North East	Construction Services	Supplies and Services	Other Materials	205	Fri Dec 16 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	1112-00003	570.4	R	A Andrews & Sons (Marbles & Tiles)
http://statistics.data.gov.uk/doc/local-authority/00DA	Leeds City Council	Central & Corporate Functions	Leeds Shared Services	Precepts	Office Consumables	210	Mon Dec 05 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	1112-00004	1750	R	A C Labels (2010) Ltd
http://statistics.data.gov.uk/doc/local-authority/00DA	Leeds City Council	Adult Social Care	Roseville Enterprises	Supplies and Services	Operational Furniture And Equipment	203	Fri Dec 30 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	1112-00005	800	R	A D G Engineering Ltd
http://statistics.data.gov.uk/doc/local-authority/00DA	Leeds City Council	Central & Corporate Functions	Commercial Services Trading Services	Supplies and Services	Operational Materials	205	Fri Dec 09 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	1112-00006	994	R	A J H Pump Supply & Repair Ltd
http://statistics.data.gov.uk/doc/local-authority/00DA	Leeds City Council	Central & Corporate Functions	Commercial Services Trading Services	Supplies and Services	Operational Materials	205	Fri Dec 16 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	1112-00007	900	R	A J H Pump Supply & Repair Ltd
http://statistics.data.gov.uk/doc/local-authority/00DA	Leeds City Council	Central & Corporate Functions	Commercial Services Trading Services	Supplies and Services	Operational Materials	205	Wed Dec 21 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	1112-00008	702	R	A J H Pump Supply & Repair Ltd
http://statistics.data.gov.uk/doc/local-authority/00DA	Leeds City Council	Central & Corporate Functions	Commercial Services Trading Services	Supplies and Services	Other Hired And Contracted Services	265	Fri Dec 30 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	1112-00009	540	R	A J H Pump Supply & Repair Ltd
http://statistics.data.gov.uk/doc/local-authority/00DA	Leeds City Council	City Development	Economic Development	Supplies and Services	Resaleable Materials	204	Mon Dec 05 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	1112-00010	713	R	A J Promotions


CREATE TABLE december_2011 (
  "body" VARCHAR,
  "body_name" VARCHAR,
  "service_label" VARCHAR,
  "service_divison_label" VARCHAR,
  "expenditure_category" VARCHAR,
  "detailed_expenses_type" VARCHAR,
  "detailed_expense_code" DOUBLE,
  "date_paid" TIMESTAMP,
  "transaction_number" VARCHAR,
  "net_amount" DOUBLE,
  "capital_or_revenue" VARCHAR,
  "supplier_name" VARCHAR,
  "unnamed_12" VARCHAR,
  "unnamed_13" VARCHAR,
  "unnamed_14" VARCHAR,
  "unnamed_15" VARCHAR,
  "unnamed_16" VARCHAR,
  "unnamed_17" VARCHAR,
  "unnamed_18" VARCHAR,
  "unnamed_19" VARCHAR,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR,
  "unnamed_22" VARCHAR,
  "unnamed_23" VARCHAR,
  "unnamed_24" VARCHAR,
  "unnamed_25" VARCHAR,
  "unnamed_26" VARCHAR,
  "unnamed_27" VARCHAR,
  "unnamed_28" VARCHAR,
  "unnamed_29" VARCHAR,
  "unnamed_30" VARCHAR,
  "unnamed_31" VARCHAR,
  "unnamed_32" VARCHAR,
  "unnamed_33" VARCHAR,
  "unnamed_34" VARCHAR,
  "unnamed_35" VARCHAR,
  "unnamed_36" VARCHAR
);