Vale Of York CCG Spend Over £25k.

a3131 A3131	unnamed_1 Unnamed: 1	unnamed_2 Unnamed: 2	unnamed_3 Unnamed: 3	unnamed_4 Unnamed: 4	unnamed_5 Unnamed: 5	unnamed_6 Unnamed: 6	unnamed_7 Unnamed: 7	unnamed_8 Unnamed: 8	unnamed_9 Unnamed: 9	expenditure_over_threshold Expenditure Over Threshold	unnamed_11 Unnamed: 11	unnamed_12 Unnamed: 12





Department family	Entity	Date	Expense Type	Expense area	Supplier	Transaction number	AP Amount (ś)	VAT registration number	Purchase invoice number	Supplier Post Code	Supplier Type	Expenditure Type
Department of Health	NHS Vale Of York CCG	31/10/2015	Computer Software/License	ADMIN PROJECTS	ACCENDA LTD	9450960	42,134.40		1024	WC2E 9RZ	SME	Admin
Department of Health	NHS Vale Of York CCG	31/10/2015	C&M-GMS Cost of Drugs -Dispensing	LOCAL ENHANCED SERVICES	BEECH TREE SURGERY	9578368	35,583.94		YN000014563	YO8 9AJ	SME	Programme
Department of Health	NHS Vale Of York CCG	31/10/2015	Clinical&Medical-Independent Sector	ACUTE COMMISSIONING	CLIFTON PARK TREATMENT CENTRE	9462154	688,688.00	GB 426505170	SAC101189	YO30 5RA	SME	Programme
Department of Health	NHS Vale Of York CCG	31/10/2015	Clinical&Medical-Independent Sector	ACUTE COMMISSIONING	CLIFTON PARK TREATMENT CENTRE	9681556	27,066.00	GB 426505170	SAC101191	YO30 5RA	SME	Programme


CREATE TABLE october_2015 (
  "a3131" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR,
  "expenditure_over_threshold" VARCHAR,
  "unnamed_11" 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
);