Council Spending

body Body	bodyname BodyName	servicelabel ServiceLabel	servicedivisionlabel ServiceDivisionLabel	expenditurecategory ExpenditureCategory	detailedexpendituretype DetailedExpenditureType	detailedexpenditurecode DetailedExpenditureCode	datepaid DatePaid	transactionnumber TransactionNumber	netamount NetAmount	capitalorrevenue CapitalOrRevenue	suppliername SupplierName
http://statistics.data.gov.uk/doc/local-authority/00DA	Leeds City Council	Environment & Housing	Parks & Countryside	Supplies and Services	Operational Materials	205	29-Nov-13	1311-00001	950	R	A & G Hoare
http://statistics.data.gov.uk/doc/local-authority/00DA	Leeds City Council	Central & Corporate	Commercial Services Trading Services	Supplies and Services	Other Hired And Contracted Services	265	06-Nov-13	1311-00002	2600	R	A C Construction Ltd
http://statistics.data.gov.uk/doc/local-authority/00DA	Leeds City Council	Environment & Housing	Hra	Premises	General Maintenance	104	14-Nov-13	1311-00003	4700	R	REDACTED PERSONAL DATA
http://statistics.data.gov.uk/doc/local-authority/00DA	Leeds City Council	Adult Social Care	Services For Older People - 65 And Over	Supplies and Services	Non-Recurring Grants	227	07-Nov-13	1311-00004	1303.95	R	A E Spector
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	07-Nov-13	1311-00005	802	R	A E Speight
http://statistics.data.gov.uk/doc/local-authority/00DA	Leeds City Council	Central & Corporate	Commercial Services Trading Services	Supplies and Services	Operational Materials	205	29-Nov-13	1311-00006	450	R	A J H Pump Supply & Repair Ltd
http://statistics.data.gov.uk/doc/local-authority/00DA	Leeds City Council	Central & Corporate	Commercial Services Trading Services	Supplies and Services	Operational Materials	205	22-Nov-13	1311-00007	473	R	A J H Pump Supply & Repair Ltd
http://statistics.data.gov.uk/doc/local-authority/00DA	Leeds City Council	Central & Corporate	Commercial Services Trading Services	Supplies and Services	Operational Materials	205	27-Nov-13	1311-00008	996	R	A J H Pump Supply & Repair Ltd
http://statistics.data.gov.uk/doc/local-authority/00DA	Leeds City Council	Central & Corporate	Commercial Services Trading Services	Supplies and Services	Operational Materials	205	29-Nov-13	1311-00009	996	R	A J H Pump Supply & Repair Ltd
http://statistics.data.gov.uk/doc/local-authority/00DA	Leeds City Council	City Development	Economic Development	Supplies and Services	Resaleable Materials	204	21-Nov-13	1311-00010	544.1	R	A J Promotions


CREATE TABLE november_2013 (
  "body" VARCHAR,
  "bodyname" VARCHAR,
  "servicelabel" VARCHAR,
  "servicedivisionlabel" VARCHAR,
  "expenditurecategory" VARCHAR,
  "detailedexpendituretype" VARCHAR,
  "detailedexpenditurecode" BIGINT,
  "datepaid" VARCHAR,
  "transactionnumber" VARCHAR,
  "netamount" DOUBLE,
  "capitalorrevenue" VARCHAR,
  "suppliername" VARCHAR
);

Share link

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