Council Spending

body Body	body_name Body Name	service_label Service Label	service_divison_label Service Divison Label	expenditure_category Expenditure Category	detailed_expenditure_type Detailed Expenditure Type	detailed_expenditure_code Detailed Expenditure 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	Wed Apr 06 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	1104-00001	5340	R	A & A Electrical Distributors Ltd
http://statistics.data.gov.uk/doc/local-authority/00DA	Leeds City Council	City Development	Libraries Arts & Heritage	Supplies and Services	Other Hired And Contracted Services	265	Wed Apr 13 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	1104-00002	760	R	A A Crouch
http://statistics.data.gov.uk/doc/local-authority/00DA	Leeds City Council	Environment & Neighbourhoods	Streetscene Environmental Services	Supplies and Services	Operational Furniture And Equipment	203	Thu Apr 07 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	1104-00003	3536	R	A Appleyard
http://statistics.data.gov.uk/doc/local-authority/00DA	Leeds City Council	Environment & Neighbourhoods	Streetscene Environmental Services	Supplies and Services	Operational Furniture And Equipment	203	Thu Apr 07 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	1104-00004	1664	R	A Appleyard
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	Tue Apr 12 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	1104-00005	760	R	A Bush (Engineering Services) 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	Tue Apr 12 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	1104-00006	880	R	A Bush (Engineering Services) 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	Wed Apr 27 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	1104-00007	3270	R	A Bush (Engineering Services) 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	Thu Apr 28 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	1104-00008	630	R	A Bush (Engineering Services) Ltd
http://statistics.data.gov.uk/doc/local-authority/00DA	Leeds City Council	Adult Social Care	Roseville Enterprises	Employees	Training Costs	71	Thu Apr 28 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	1104-00009	450	R	A D G Engineering 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	Thu Apr 28 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	1104-00010	9090	R	A D G Engineering Ltd


CREATE TABLE april_2011 (
  "body" VARCHAR,
  "body_name" VARCHAR,
  "service_label" VARCHAR,
  "service_divison_label" VARCHAR,
  "expenditure_category" VARCHAR,
  "detailed_expenditure_type" VARCHAR,
  "detailed_expenditure_code" BIGINT,
  "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
);