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 Mar 09 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	1103-00001	1010.19	R	A & A Electrical Distributors 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 Mar 09 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	1103-00002	1156.4	R	A & A Electrical Distributors 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	Mon Mar 21 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	1103-00003	482.24	R	A & A Electrical Distributors Ltd
http://statistics.data.gov.uk/doc/local-authority/00DA	East - North East Homes Leeds	East - North East	Technical Services	Supplies and Services	Other Materials	205	Fri Mar 18 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	1103-00004	780.8	R	A Andrews & Sons (Marbles & Tiles)
http://statistics.data.gov.uk/doc/local-authority/00DA	Leeds City Council	Environment & Neighbourhoods	Streetscene Environmental Services	Supplies and Services	Other Hired And Contracted Services	265	Fri Mar 11 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	1103-00005	3744	R	A Appleyard
http://statistics.data.gov.uk/doc/local-authority/00DA	Leeds City Council	City Development	Highways	Premises	Maintenance Of Traffic Signals	108	Wed Mar 09 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	1103-00006	5507.27	R	A D D Loop Cutting Services Ltd
http://statistics.data.gov.uk/doc/local-authority/00DA	Leeds City Council	City Development	Highways	Supplies and Services	Other Hired And Contracted Services	265	Tue Mar 15 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	1103-00007	482	R	A D D Loop Cutting Services Ltd
http://statistics.data.gov.uk/doc/local-authority/00DA	East - North East Homes Leeds	East - North East	Technical Services	Employees	Temporary Staff-Basic	9	Fri Mar 04 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	1103-00008	552	R	A D Simpson Ltd
http://statistics.data.gov.uk/doc/local-authority/00DA	East - North East Homes Leeds	East - North East	Technical Services	Employees	Temporary Staff-Basic	9	Fri Mar 04 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	1103-00009	920	R	A D Simpson Ltd
http://statistics.data.gov.uk/doc/local-authority/00DA	East - North East Homes Leeds	East - North East	Technical Services	Supplies and Services	Other Hired And Contracted Services	265	Fri Mar 04 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	1103-00010	621	R	A D Simpson Ltd


CREATE TABLE march_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
);