Council Spending

organisation_code Organisation Code	bodyname BodyName	servicelabel ServiceLabel	servicedivisionlabel ServiceDivisionLabel	expenditurecategory ExpenditureCategory	detailedexpendituretype DetailedExpenditureType	detailedexpenditurecode DetailedExpenditureCode	datepaid DatePaid	transactionnumber TransactionNumber	netamount NetAmount	capitalorrevenue CapitalOrRevenue	suppliername SupplierName	procurement_card Procurement Card
Http://opendatacommunities.org/id/metropolitan-district-council/leeds	Leeds City Council	Central & Corporate	Commercial Services Trading Services	Supplies and Services	Operational Materials	205	Fri Oct 31 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	1410-00001	53.78	R	A & A Electrical Distributors Ltd	No
Http://opendatacommunities.org/id/metropolitan-district-council/leeds	Leeds City Council	Environment & Housing	Parks & Countryside	Supplies and Services	Operational Materials	205	Mon Sep 01 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	1410-00002	24.25	R	A & E Macgregor	Yes
Http://opendatacommunities.org/id/metropolitan-district-council/leeds	Leeds City Council	Environment & Housing	Environmental Health	Capital	Construction	3	Fri Oct 31 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	1410-00003	14400	C	A & P Crontractors Ltd	No
Http://opendatacommunities.org/id/metropolitan-district-council/leeds	Leeds City Council as Accountable Body	Social Services Pooled Budgets	Leeds Community Equip Store Pooled Budgt	Supplies and Services	Other Equipment	203	Wed Oct 29 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	1410-00004	4841.79	R	A & P Crontractors Ltd	No
Http://opendatacommunities.org/id/metropolitan-district-council/leeds	Leeds City Council	Childrens Services	Safeguarding Targeted & Specialist	Third Party Payments	Section 17	551	Thu Oct 02 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	1410-00005	550	R	A Ahmadi	No
Http://opendatacommunities.org/id/metropolitan-district-council/leeds	Leeds City Council	Central & Corporate	Commercial Services Trading Services	Supplies and Services	Operational Materials	205	Thu Oct 23 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	1410-00006	138.9	R	A Andrews & Sons (Marbles & Tiles)	No
Http://opendatacommunities.org/id/metropolitan-district-council/leeds	Leeds City Council	Central & Corporate	Commercial Services Trading Services	Supplies and Services	Operational Materials	205	Wed Oct 22 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	1410-00007	109.72	R	A Andrews & Sons (Marbles & Tiles)	No
Http://opendatacommunities.org/id/metropolitan-district-council/leeds	Leeds City Council	Central & Corporate	Commercial Services Trading Services	Supplies and Services	Operational Materials	205	Wed Oct 22 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	1410-00008	36	R	A Andrews & Sons (Marbles & Tiles)	No
Http://opendatacommunities.org/id/metropolitan-district-council/leeds	Leeds City Council	Central & Corporate	Commercial Services Trading Services	Supplies and Services	Operational Materials	205	Wed Oct 22 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	1410-00009	2636.2	R	A Andrews & Sons (Marbles & Tiles)	No
Http://opendatacommunities.org/id/metropolitan-district-council/leeds	Leeds City Council	Central & Corporate	Commercial Services Trading Services	Supplies and Services	Operational Materials	205	Wed Oct 22 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	1410-00010	27.22	R	A Andrews & Sons (Marbles & Tiles)	No


CREATE TABLE october_2014 (
  "organisation_code" VARCHAR,
  "bodyname" VARCHAR,
  "servicelabel" VARCHAR,
  "servicedivisionlabel" VARCHAR,
  "expenditurecategory" VARCHAR,
  "detailedexpendituretype" VARCHAR,
  "detailedexpenditurecode" DOUBLE,
  "datepaid" TIMESTAMP,
  "transactionnumber" VARCHAR,
  "netamount" DOUBLE,
  "capitalorrevenue" VARCHAR,
  "suppliername" VARCHAR,
  "procurement_card" VARCHAR
);