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	East - North East	East - North East	Construction Services	Supplies and Services	Other Materials	205	30-May-12	1205-00001	670.4	R	A Andrews & Sons (Marbles & Tiles)
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	01-May-12	1205-00002	1000	R	A Bush (Engineering Services) 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	16-May-12	1205-00003	866.5	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	16-May-12	1205-00004	1539.84	R	A D G Engineering 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	08-May-12	1205-00005	429.9	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	08-May-12	1205-00006	533.6	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	24-May-12	1205-00007	688.45	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	24-May-12	1205-00008	2579.16	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	18-May-12	1205-00009	2995	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	11-May-12	1205-00010	5328.37	R	A D Simpson Construction Ltd


CREATE TABLE may_2012 (
  "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" 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.