Council Spending

body Body	bodyname BodyName	servicelabel ServiceLabel	servicedivisionlabel ServiceDivisionLabel	expenditurecategory ExpenditureCategory	detailedexpendituretype DetailedExpenditureType	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	Fri Jul 04 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	1407-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	Mon Jul 14 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	1407-00002	140.99	R	A & A Electrical Distributors Ltd
http://statistics.data.gov.uk/doc/local-authority/00DA	Leeds City Council	Environment & Housing	Environmental Health	Capital	Construction	Wed Jul 30 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	1407-00003	2438.6	C	A & P Crontractors Ltd
http://statistics.data.gov.uk/doc/local-authority/00DA	Leeds City Council	Central & Corporate	Commercial Services Trading Services	Supplies and Services	Operational Materials	Fri Jul 04 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	1407-00004	24.06	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	Tue Jul 01 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	1407-00005	29.47	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	Wed Jul 02 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	1407-00006	445.3	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	Wed Jul 23 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	1407-00007	220.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	Fri Jul 04 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	1407-00008	12.8	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	Fri Jul 04 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	1407-00009	37.75	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	Wed Jul 16 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	1407-00010	558.77	R	A C Entertainment Technologies Ltd


CREATE TABLE july_2014 (
  "body" VARCHAR,
  "bodyname" VARCHAR,
  "servicelabel" VARCHAR,
  "servicedivisionlabel" VARCHAR,
  "expenditurecategory" VARCHAR,
  "detailedexpendituretype" VARCHAR,
  "detailedexpenditurecode" DOUBLE,
  "datepaid" TIMESTAMP,
  "transactionnumber" VARCHAR,
  "netamount" DOUBLE,
  "capitalorrevenue" VARCHAR,
  "suppliername" VARCHAR,
  "unnamed_12" VARCHAR,
  "unnamed_13" VARCHAR,
  "unnamed_14" VARCHAR,
  "unnamed_15" VARCHAR,
  "unnamed_16" VARCHAR,
  "unnamed_17" VARCHAR,
  "unnamed_18" VARCHAR,
  "unnamed_19" VARCHAR,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR,
  "unnamed_22" VARCHAR,
  "unnamed_23" VARCHAR,
  "unnamed_24" VARCHAR,
  "unnamed_25" VARCHAR,
  "unnamed_26" VARCHAR,
  "unnamed_27" VARCHAR,
  "unnamed_28" VARCHAR,
  "unnamed_29" VARCHAR,
  "unnamed_30" VARCHAR,
  "unnamed_31" VARCHAR,
  "unnamed_32" VARCHAR,
  "unnamed_33" VARCHAR,
  "unnamed_34" VARCHAR,
  "unnamed_35" VARCHAR,
  "unnamed_36" VARCHAR,
  "unnamed_37" VARCHAR,
  "unnamed_38" VARCHAR,
  "unnamed_39" VARCHAR,
  "unnamed_40" VARCHAR,
  "unnamed_41" VARCHAR,
  "unnamed_42" VARCHAR,
  "unnamed_43" VARCHAR,
  "unnamed_44" VARCHAR,
  "unnamed_45" VARCHAR,
  "unnamed_46" VARCHAR,
  "unnamed_47" VARCHAR,
  "unnamed_48" VARCHAR,
  "unnamed_49" VARCHAR,
  "unnamed_50" VARCHAR,
  "unnamed_51" VARCHAR,
  "unnamed_52" VARCHAR,
  "unnamed_53" VARCHAR,
  "unnamed_54" VARCHAR,
  "unnamed_55" VARCHAR,
  "unnamed_56" VARCHAR,
  "unnamed_57" VARCHAR,
  "unnamed_58" VARCHAR,
  "unnamed_59" VARCHAR,
  "unnamed_60" VARCHAR,
  "unnamed_61" VARCHAR,
  "unnamed_62" VARCHAR,
  "unnamed_63" VARCHAR,
  "unnamed_64" VARCHAR,
  "unnamed_65" VARCHAR,
  "unnamed_66" VARCHAR,
  "unnamed_67" VARCHAR,
  "unnamed_68" VARCHAR,
  "unnamed_69" VARCHAR,
  "unnamed_70" VARCHAR,
  "unnamed_71" VARCHAR,
  "unnamed_72" VARCHAR,
  "unnamed_73" VARCHAR,
  "unnamed_74" VARCHAR,
  "unnamed_75" VARCHAR,
  "unnamed_76" VARCHAR,
  "unnamed_77" VARCHAR,
  "unnamed_78" VARCHAR,
  "unnamed_79" VARCHAR,
  "unnamed_80" VARCHAR,
  "unnamed_81" VARCHAR,
  "unnamed_82" VARCHAR,
  "unnamed_83" VARCHAR,
  "unnamed_84" VARCHAR,
  "unnamed_85" VARCHAR,
  "unnamed_86" VARCHAR,
  "unnamed_87" VARCHAR,
  "unnamed_88" VARCHAR,
  "unnamed_89" VARCHAR,
  "unnamed_90" VARCHAR,
  "unnamed_91" VARCHAR,
  "unnamed_92" VARCHAR,
  "unnamed_93" VARCHAR,
  "unnamed_94" VARCHAR,
  "unnamed_95" VARCHAR,
  "unnamed_96" VARCHAR,
  "unnamed_97" VARCHAR,
  "unnamed_98" VARCHAR,
  "unnamed_99" VARCHAR
);