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	Environmental Health	Capital	Construction	3	31-Jul-13	1307-00001	4257.24	C	A & P Crontractors Ltd
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	04-Jul-13	1307-00002	577.3	R	A E Speight
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	04-Jul-13	1307-00003	1425.8	R	A Foley
http://statistics.data.gov.uk/doc/local-authority/00DA	Leeds City Council	Childrens Services	Safeguarding Targeted & Specialist	Third Party Payments	Adoptions - Allowances	560	11-Jul-13	1307-00004	500	R	REDACTED PERSONAL DATA
http://statistics.data.gov.uk/doc/local-authority/00DA	Leeds City Council	Central & Corporate	Commercial Services Trading Services	Supplies and Services	Operational Materials	205	23-Jul-13	1307-00005	860.54	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	31-Jul-13	1307-00006	1831	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	12-Jul-13	1307-00007	4019	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	Other Hired And Contracted Services	265	10-Jul-13	1307-00008	550.64	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	Other Hired And Contracted Services	265	31-Jul-13	1307-00009	883	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	Other Hired And Contracted Services	265	31-Jul-13	1307-00010	2900	R	A J H Pump Supply & Repair Ltd


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

Share link

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