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	14-Mar-14	1203-00001	351.81	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	21-Mar-14	1203-00002	35.05	R	A & A Electrical Distributors Ltd
http://statistics.data.gov.uk/doc/local-authority/00DA	Leeds City Council	Childrens Services	Learning Skills & Universal	Supplies and Services	Bought In Professional Services	277	14-Mar-14	1203-00003	125	R	A Ajmal
http://statistics.data.gov.uk/doc/local-authority/00DA	Leeds City Council	City Development	Planning & Sustainable Development	Income	Planning Fees	939	13-Mar-14	1203-00004	178	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	07-Mar-14	1203-00005	347.44	R	A Andrews & Sons (Marbles & Tiles)
http://statistics.data.gov.uk/doc/local-authority/00DA	Leeds City Council	Environment & Housing	Streetscene Environmental Services	Income	Penalties Fines & Car Parking Charges	934	06-Mar-14	1203-00006	2	R	REDACTED PERSONAL DATA
http://statistics.data.gov.uk/doc/local-authority/00DA	Leeds City Council	City Development	Highways	Supplies and Services	Other Hired And Contracted Services	265	25-Mar-14	1203-00007	1811.6	R	A D D Loop Cutting Services Ltd
http://statistics.data.gov.uk/doc/local-authority/00DA	Leeds City Council	City Development	Highways	Capital	Other Costs	7	25-Mar-14	1203-00008	1324.2	C	A D D Loop Cutting Services Ltd
http://statistics.data.gov.uk/doc/local-authority/00DA	Leeds City Council	City Development	Highways	Capital	Construction	3	25-Mar-14	1203-00009	725.95	C	A D D Loop Cutting Services Ltd
http://statistics.data.gov.uk/doc/local-authority/00DA	Leeds City Council	Adult Social Care	Roseville Enterprises	Supplies and Services	Operational Furniture And Equipment	203	07-Mar-14	1203-00010	2601.7	R	A D G Engineering Ltd


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