Council Spending

organisation_name Organisation Name	invoice_id Invoice ID	invoice_date Invoice Date	supplier_name Supplier Name	proclass_category Proclass Category	service_area Service Area	cost_centre_name Cost Centre Name	invoiced Invoiced (Ł)
Rochdale	V000845887	Tue Oct 28 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	4COURT PHARMACY	Healthcare	PUBLIC HEALTH	STOP SMOKING	665.71
Rochdale	V000837649	Thu Oct 02 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	A & S BUILDING & ROOFING	Building Construction Materials	PHYSICAL DIS & OLDER PEOPLE	DISABLED FACILITIES GRANT	1441.97
Rochdale	V000838934	Tue Oct 07 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	A & S BUILDING & ROOFING	Building Construction Materials	PHYSICAL DIS & OLDER PEOPLE	DISABLED FACILITIES GRANT	2537
Rochdale	V000845910	Wed Oct 29 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	A & S BUILDING & ROOFING	Building Construction Materials	PHYSICAL DIS & OLDER PEOPLE	DISABLED FACILITIES GRANT	1291.03
Rochdale	V000846290	Thu Oct 30 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	A A ARNOLD LIMITED	Education	EARLY HELP AND SCHOOLS	RETENTIONS (MODERNISATION 2008-09)	1237.04
Rochdale	V000840287	Tue Oct 14 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	A J ASSOCIATES	Unclassifiable	EARLY HELP AND SCHOOLS	CLC RUNNING COSTS 2011/12	500
Rochdale	V000840854	Thu Oct 16 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	ABC INDUSTRIAL DOORS LTD	Building Construction Materials	ECONOMY AND ENVIRONMENT	1 RIVERSIDE	1500
Rochdale	V000839224	Wed Oct 08 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	ABC INDUSTRIAL DOORS LTD	Building Construction Materials	PROPERTY AND HIGHWAYS	ALKRINGTON/ST PETERS CHILDREN CENTRE	1440
Rochdale	V000841339	Mon Oct 20 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	ABC INDUSTRIAL DOORS LTD	Building Construction Materials	PROPERTY AND HIGHWAYS	CORPORATE LANDLORD GENERAL	951
Rochdale	V000840257	Tue Oct 14 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	ABM LANCASHIRE LIMITED	Building Construction Materials	PHYSICAL DIS & OLDER PEOPLE	DISABLED FACILITIES GRANT	3447


CREATE TABLE table_24 (
  "organisation_name" VARCHAR,
  "invoice_id" VARCHAR,
  "invoice_date" TIMESTAMP,
  "supplier_name" VARCHAR,
  "proclass_category" VARCHAR,
  "service_area" VARCHAR,
  "cost_centre_name" VARCHAR,
  "invoiced" DOUBLE
);

Share link

Anyone who has the link will be able to view this.