Council Spending

organisation_name ORGANISATION NAME	efefctive_date EFEFCTIVE DATE	directorate DIRECTORATE	supplier_name SUPPLIER NAME	date_paid DATE PAID	amount AMOUNT (Ł)	purpose PURPOSE	transaction_no TRANSACTION No.
ROCHDALE BOROUGH COUNCIL	Wed Jan 27 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	ECONOMY DIRECTORATE	EVERYTHING EVERYWHERE	Wed Jan 27 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	185	MOBILE PHONE	V001529074
ROCHDALE BOROUGH COUNCIL	Wed Jan 27 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	EVERYTHING EVERYWHERE	Wed Jan 27 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	185	MOBILE PHONE	V001529075
ROCHDALE BOROUGH COUNCIL	Wed Jan 27 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	CHILDREN’S SOCIAL CARE	EVERYTHING EVERYWHERE	Wed Jan 27 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	185	MOBILE PHONE	V001529076
ROCHDALE BOROUGH COUNCIL	Wed Jan 27 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	CHILDREN’S SOCIAL CARE	EVERYTHING EVERYWHERE	Wed Jan 27 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	49	MOBILE PHONE	V001529077
ROCHDALE BOROUGH COUNCIL	Wed Jan 27 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	ECONOMY DIRECTORATE	EVERYTHING EVERYWHERE	Wed Jan 27 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	185	MOBILE PHONE	V001529078
ROCHDALE BOROUGH COUNCIL	Wed Jan 27 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	EVERYTHING EVERYWHERE	Wed Jan 27 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	-50	MOBILE PHONE	V001529458
ROCHDALE BOROUGH COUNCIL	Wed Jan 27 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	EVERYTHING EVERYWHERE	Wed Jan 27 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	-50	MOBILE PHONE	V001529459
ROCHDALE BOROUGH COUNCIL	Wed Jan 27 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	CHILDREN’S SOCIAL CARE	EVERYTHING EVERYWHERE	Wed Jan 27 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	49	MOBILE PHONE	V001529460
ROCHDALE BOROUGH COUNCIL	Wed Jan 27 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	CHILDREN’S SOCIAL CARE	EVERYTHING EVERYWHERE	Wed Jan 27 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	-150	MOBILE PHONE	V001529461
ROCHDALE BOROUGH COUNCIL	Wed Jan 27 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	CHILDREN’S SOCIAL CARE	EVERYTHING EVERYWHERE	Wed Jan 27 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	-50	MOBILE PHONE	V001529461


CREATE TABLE table_19 (
  "organisation_name" VARCHAR,
  "efefctive_date" TIMESTAMP,
  "directorate" VARCHAR,
  "supplier_name" VARCHAR,
  "date_paid" TIMESTAMP,
  "amount" DOUBLE,
  "purpose" VARCHAR,
  "transaction_no" VARCHAR
);