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	Leeds City Council	Central & Corporate Functions	Commercial Services Trading Services	Supplies and Services	Operational Materials	205	02-Mar-12	1203-00001	646.29	R	A & A Electrical Distributors Ltd
http://statistics.data.gov.uk/doc/local-authority/00DA	East - North East	East - North East	Construction Services	Supplies and Services	Other Materials	205	02-Mar-12	1203-00002	570.4	R	A Andrews & Sons (Marbles & Tiles)
http://statistics.data.gov.uk/doc/local-authority/00DA	East - North East	East - North East	Construction Services	Supplies and Services	Other Materials	205	23-Mar-12	1203-00003	670.4	R	A Andrews & Sons (Marbles & Tiles)
http://statistics.data.gov.uk/doc/local-authority/00DA	Leeds City Council	Childrens Services	Learning Skills & Universal	Supplies and Services	Teaching Furniture & Equipment	207	15-Mar-12	1203-00004	675	R	A Ash
http://statistics.data.gov.uk/doc/local-authority/00DA	Leeds City Council	Childrens Services	Learning Skills & Universal	Third Party Payments	Services Rendered By Voluntary Sector	505	20-Mar-12	1203-00005	2823.84	R	REDACTED PERSONAL DATA
http://statistics.data.gov.uk/doc/local-authority/00DA	Leeds City Council	City Development	Highways	Capital	Construction	3	22-Mar-12	1203-00006	22982.4	C	A E Yates 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	02-Mar-12	1203-00007	1427	R	A J H Pump Supply & Repair 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	16-Mar-12	1203-00008	732	R	A J H Pump Supply & Repair 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	28-Mar-12	1203-00009	579	R	A J H Pump Supply & Repair 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	02-Mar-12	1203-00010	6300	R	A J Promotions


CREATE TABLE march_2012 (
  "body" VARCHAR,
  "body_name" VARCHAR,
  "service_label" VARCHAR,
  "service_divison_label" VARCHAR,
  "expenditure_category" VARCHAR,
  "detailed_expenses_type" VARCHAR,
  "detailed_expense_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.