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	07-Feb-14	1402-00001	97.56	R	A & A Electrical Distributors 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	14-Feb-14	1402-00002	130	R	A & A Electrical Distributors Ltd
http://statistics.data.gov.uk/doc/local-authority/00DA	Leeds City Council	Civic Enterprise Leeds	Commercial Services	Supplies and Services	Teaching Materials	203	20-Jan-14	1402-00003	80.49	R	A & L Sunter 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	28-Feb-14	1402-00004	67.14	R	A Andrews & Sons (Marbles & Tiles)
http://statistics.data.gov.uk/doc/local-authority/00DA	Leeds City Council	Central & Corporate	Commercial Services Trading Services	Supplies and Services	Operational Materials	205	28-Feb-14	1402-00005	395.36	R	A Andrews & Sons (Marbles & Tiles)
http://statistics.data.gov.uk/doc/local-authority/00DA	Leeds City Council	Central & Corporate	Commercial Services Trading Services	Supplies and Services	Operational Materials	205	26-Feb-14	1402-00006	5.5	R	A Andrews & Sons (Marbles & Tiles)
http://statistics.data.gov.uk/doc/local-authority/00DA	Leeds City Council	Central & Corporate	Commercial Services Trading Services	Supplies and Services	Operational Materials	205	26-Feb-14	1402-00007	35.09	R	A Andrews & Sons (Marbles & Tiles)
http://statistics.data.gov.uk/doc/local-authority/00DA	Leeds City Council	Central & Corporate	Commercial Services Trading Services	Supplies and Services	Operational Materials	205	26-Feb-14	1402-00008	12.4	R	A Andrews & Sons (Marbles & Tiles)
http://statistics.data.gov.uk/doc/local-authority/00DA	Leeds City Council	Central & Corporate	Commercial Services Trading Services	Supplies and Services	Operational Materials	205	24-Feb-14	1402-00009	32.2	R	A Andrews & Sons (Marbles & Tiles)
http://statistics.data.gov.uk/doc/local-authority/00DA	Leeds City Council	City Development	Libraries Arts & Heritage	Supplies and Services	Operational Furniture And Equipment	203	07-Feb-14	1402-00010	50	R	A C Entertainment Technologies Ltd


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