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	East - North East	East - North East	Construction Services	Supplies and Services	Other Materials	205	Fri Jun 17 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	1106-00001	607.2	R	A Andrews & Sons (Marbles & Tiles)
http://statistics.data.gov.uk/doc/local-authority/00DA	East - North East	East - North East	Construction Services	Employees	Temporary Staff-Basic	9	Fri Jun 03 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	1106-00002	920	R	A D Simpson Construction Ltd
http://statistics.data.gov.uk/doc/local-authority/00DA	East - North East	East - North East	Construction Services	Supplies and Services	Other Hired And Contracted Services	265	Fri Jun 03 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	1106-00003	1060.5	R	A D Simpson Construction Ltd
http://statistics.data.gov.uk/doc/local-authority/00DA	East - North East	East - North East	Construction Services	Supplies and Services	Other Hired And Contracted Services	265	Thu Jun 09 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	1106-00004	513	R	A D Simpson Construction Ltd
http://statistics.data.gov.uk/doc/local-authority/00DA	East - North East	East - North East	Construction Services	Supplies and Services	Other Hired And Contracted Services	265	Fri Jun 10 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	1106-00005	2465.24	R	A D Simpson Construction Ltd
http://statistics.data.gov.uk/doc/local-authority/00DA	East - North East	East - North East	Construction Services	Supplies and Services	Other Hired And Contracted Services	265	Mon Jun 13 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	1106-00006	1965.15	R	A D Simpson Construction Ltd
http://statistics.data.gov.uk/doc/local-authority/00DA	East - North East	East - North East	Construction Services	Supplies and Services	Other Hired And Contracted Services	265	Mon Jun 13 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	1106-00007	417.25	R	A D Simpson Construction Ltd
http://statistics.data.gov.uk/doc/local-authority/00DA	East - North East	East - North East	Construction Services	Supplies and Services	Other Hired And Contracted Services	265	Mon Jun 13 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	1106-00008	1997.5	R	A D Simpson Construction Ltd
http://statistics.data.gov.uk/doc/local-authority/00DA	East - North East	East - North East	Construction Services	Supplies and Services	Other Hired And Contracted Services	265	Mon Jun 13 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	1106-00009	15174.4	R	A D Simpson Construction Ltd
http://statistics.data.gov.uk/doc/local-authority/00DA	East - North East	East - North East	Construction Services	Supplies and Services	Other Hired And Contracted Services	265	Mon Jun 13 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	1106-00010	2349.5	R	A D Simpson Construction Ltd


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