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	Food & Drink	231	26-May-11	1105-00001	528	R	3663 Booker Food Services
http://statistics.data.gov.uk/doc/local-authority/00DA	Leeds City Council	Central & Corporate Functions	Commercial Services Trading Services	Supplies and Services	Food & Drink	231	26-May-11	1105-00002	1336.2	R	3663 Booker Food Services
http://statistics.data.gov.uk/doc/local-authority/00DA	Leeds City Council	Childrens Services	Early Years Service	Third Party Payments	Services Rendered By Voluntary Sector	505	26-May-11	1105-00003	63809	R	4 Children (Trading Ltd)
http://statistics.data.gov.uk/doc/local-authority/00DA	Leeds City Council	Childrens Services	Youth Justice	Employees	Agency Staff	8	06-May-11	1105-00004	2000.7	R	4 Site Security 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	11-May-11	1105-00005	4503.4	R	4 Site Security 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	11-May-11	1105-00006	1366.9	R	4 Site Security 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	11-May-11	1105-00007	1500.06	R	4 Site Security 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	11-May-11	1105-00008	2657.72	R	4 Site Security 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	11-May-11	1105-00009	1016.35	R	4 Site Security 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	11-May-11	1105-00010	3418.03	R	4 Site Security Services Ltd


CREATE TABLE may_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" VARCHAR,
  "transaction_number" VARCHAR,
  "net_amount" DOUBLE,
  "capital_or_revenue" VARCHAR,
  "supplier_name" VARCHAR
);

Share link

Anyone who has the link will be able to view this.