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	Central & Corporate	Commercial Services Trading Services	Supplies and Services	Operational Materials	205	20-Jun-13	1306-00001	1240	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	20-Jun-13	1306-00002	2100	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	18-Jun-13	1306-00003	1752	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	Publication And Promotion	267	28-Jun-13	1306-00004	1100	R	A J Promotions
http://statistics.data.gov.uk/doc/local-authority/00DA	Leeds City Council	Environment & Housing	Parks & Countryside	Supplies and Services	Resaleable Materials	204	06-Jun-13	1306-00005	786.84	R	A J Promotions
http://statistics.data.gov.uk/doc/local-authority/00DA	Leeds City Council	Childrens Services	Safeguarding Targeted & Specialist	Third Party Payments	General External Residential Placements	507	07-Jun-13	1306-00006	13000	R	A Lowrie Care Service Limited
http://statistics.data.gov.uk/doc/local-authority/00DA	Leeds City Council	Childrens Services	Safeguarding Targeted & Specialist	Third Party Payments	General External Residential Placements	507	07-Jun-13	1306-00007	13000	R	A Lowrie Care Service Limited
http://statistics.data.gov.uk/doc/local-authority/00DA	Leeds City Council	Childrens Services	Safeguarding Targeted & Specialist	Third Party Payments	General External Residential Placements	507	17-Jun-13	1306-00008	13000	R	A Lowrie Care Service Limited
http://statistics.data.gov.uk/doc/local-authority/00DA	Leeds City Council	Childrens Services	Safeguarding Targeted & Specialist	Third Party Payments	General External Residential Placements	507	07-Jun-13	1306-00009	14000	R	A Lowrie Care Service Limited
http://statistics.data.gov.uk/doc/local-authority/00DA	Leeds City Council	Childrens Services	Safeguarding Targeted & Specialist	Third Party Payments	General External Residential Placements	507	07-Jun-13	1306-00010	14000	R	A Lowrie Care Service Limited


CREATE TABLE june_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.