Vale Of York CCG Spend Over £25k.

department_family Department Family	entity Entity	date Date	expense_type Expense Type	expense_area Expense Area	supplier Supplier	transaction_number Transaction Number	ap_amount AP Amount (Ł)	vat_registration_number VAT Registration Number	purchase_invoice_number Purchase Invoice Number	supplier_post_code Supplier Post Code	supplier_type Supplier Type	expenditure_type Expenditure Type
Department of Health	NHS Vale Of York CCG	Sat Dec 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	C&M-GMS Cost of Drugs -Dispensing & C&M-GMS GP Co-Commissioning Payment	LOCAL ENHANCED SERVICES & PRC DELEGATED CO-COMMISSIONING	BEECH TREE SURGERY	15473903	218453.37		YN000020502 & YN000020501	YO8 9AJ	SME	Programme
Department of Health	NHS Vale Of York CCG	Sat Dec 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Clinical&Medical-Voluntary Sector	COMMISSIONING - NON ACUTE	BPAS	15321819	27495	855924881	32905	CV37 9BF	SME	Programme
Department of Health	NHS Vale Of York CCG	Sat Dec 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Clinical&Medical-Independent Sector	ACUTE COMMISSIONING	CLIFTON PARK TREATMENT CENTRE	15321953	748162	GB426505170	SAC101267	YO30 5RA	SME	Programme
Department of Health	NHS Vale Of York CCG	Sat Dec 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	C&M-GMS Cost of Drugs -Dispensing & C&M-GMS GP Co-Commissioning Payment	LOCAL ENHANCED SERVICES & PRC DELEGATED CO-COMMISSIONING	DALTON TERRACE SURGERY	15473906	66631.98		YN000020504 & YN000020503	YO24 4DB	SME	Programme
Department of Health	NHS Vale Of York CCG	Sat Dec 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	C&M-GMS Cost of Drugs -Dispensing & C&M-GMS GP Co-Commissioning Payment	LOCAL ENHANCED SERVICES & PRC DELEGATED CO-COMMISSIONING	DR BROOKE J P & PARTNERS	15476454	233784.67		KHU000021889 & KHU000021888	YO42 2BS	SME	Programme
Department of Health	NHS Vale Of York CCG	Sat Dec 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	C&M-GMS Cost of Drugs -Dispensing & C&M-GMS GP Co-Commissioning Payment	LOCAL ENHANCED SERVICES & PRC DELEGATED CO-COMMISSIONING	DR E M BRADLEY	15473909	28810.39		YN000020508 & YN000020507	YO60 6PS	SME	Programme
Department of Health	NHS Vale Of York CCG	Sat Dec 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	C&M-GMS Cost of Drugs -Dispensing & C&M-GMS GP Co-Commissioning Payment	LOCAL ENHANCED SERVICES & PRC DELEGATED CO-COMMISSIONING	DR NJ WILSON & DR JF MATTHEWS	15473911	35268.72	936772877	YN000020509 & YN000020510	YO62 5HD	SME	Programme
Department of Health	NHS Vale Of York CCG	Sat Dec 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	C&M-GMS Cost of Drugs -Dispensing & C&M-GMS GP Co-Commissioning Payment	LOCAL ENHANCED SERVICES & PRC DELEGATED CO-COMMISSIONING	DR R WESTERMAN & PARTNERS	15473912	88927.33	GB654454623	YN000020512 & YN000020511	YO61 3JR	SME	Programme
Department of Health	NHS Vale Of York CCG	Sat Dec 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	C&M-GMS Cost of Drugs -Dispensing & C&M-GMS GP Co-Commissioning Payment	LOCAL ENHANCED SERVICES & PRC DELEGATED CO-COMMISSIONING	DRS POTRYKUS & UTTING	15473914	72453.32		YN000020514 & YN000020513	YO61 1QW	SME	Programme
Department of Health	NHS Vale Of York CCG	Sat Dec 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	C&M-GMS Cost of Drugs -Dispensing & C&M-GMS GP Co-Commissioning Payment	LOCAL ENHANCED SERVICES & PRC DELEGATED CO-COMMISSIONING	DRS PR JONES & B MCPHERSON	15473916	71457.84	879121501	YN000020516 & YN000020515	YO61 1LL	SME	Programme


CREATE TABLE december_2016 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" BIGINT,
  "ap_amount" DOUBLE,
  "vat_registration_number" VARCHAR,
  "purchase_invoice_number" VARCHAR,
  "supplier_post_code" VARCHAR,
  "supplier_type" VARCHAR,
  "expenditure_type" VARCHAR
);