Vale Of York CCG Spend Over £25k.
NHS Vale of York CCG
@ukgov.vale_of_york_ccg_spend_over_25k
NHS Vale of York CCG
@ukgov.vale_of_york_ccg_spend_over_25k
Vale of York CCG spend over £25k Open Government
Publisher name: NHS Vale of York CCG
Last updated: 2022-11-04T02:44:12Z
CREATE TABLE april_2016 (
"a3131" VARCHAR,
"unnamed_1" VARCHAR -- Unnamed: 1,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7,
"unnamed_8" VARCHAR -- Unnamed: 8,
"unnamed_9" VARCHAR -- Unnamed: 9,
"expenditure_over_threshold" VARCHAR,
"unnamed_11" VARCHAR -- Unnamed: 11,
"unnamed_12" VARCHAR -- Unnamed: 12
);CREATE TABLE august_2016 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" BIGINT,
"ap_amount" DOUBLE -- AP Amount (Ł),
"vat_registration_number" VARCHAR,
"purchase_invoice_number" VARCHAR,
"supplier_post_code" VARCHAR,
"supplier_type" VARCHAR,
"expenditure_type" VARCHAR
);CREATE TABLE december_2015 (
"a3131" VARCHAR,
"unnamed_1" VARCHAR -- Unnamed: 1,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7,
"unnamed_8" VARCHAR -- Unnamed: 8,
"unnamed_9" VARCHAR -- Unnamed: 9,
"expenditure_over_threshold" VARCHAR,
"unnamed_11" VARCHAR -- Unnamed: 11,
"unnamed_12" VARCHAR -- Unnamed: 12
);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 -- AP Amount (Ł),
"vat_registration_number" VARCHAR,
"purchase_invoice_number" VARCHAR,
"supplier_post_code" VARCHAR,
"supplier_type" VARCHAR,
"expenditure_type" VARCHAR
);CREATE TABLE february_2016 (
"a3131" VARCHAR,
"unnamed_1" VARCHAR -- Unnamed: 1,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7,
"unnamed_8" VARCHAR -- Unnamed: 8,
"unnamed_9" VARCHAR -- Unnamed: 9,
"expenditure_over_threshold" VARCHAR,
"unnamed_11" VARCHAR -- Unnamed: 11,
"unnamed_12" VARCHAR -- Unnamed: 12,
"unnamed_13" VARCHAR -- Unnamed: 13
);CREATE TABLE february_2017 (
"a3131" VARCHAR,
"unnamed_1" VARCHAR -- Unnamed: 1,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7,
"unnamed_8" VARCHAR -- Unnamed: 8,
"unnamed_9" VARCHAR -- Unnamed: 9,
"expenditure_over_threshold" VARCHAR,
"unnamed_11" VARCHAR -- Unnamed: 11,
"unnamed_12" VARCHAR -- Unnamed: 12,
"unnamed_13" VARCHAR -- Unnamed: 13
);CREATE TABLE january_2016 (
"a3131" VARCHAR,
"unnamed_1" VARCHAR -- Unnamed: 1,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7,
"unnamed_8" VARCHAR -- Unnamed: 8,
"unnamed_9" VARCHAR -- Unnamed: 9,
"expenditure_over_threshold" VARCHAR,
"unnamed_11" VARCHAR -- Unnamed: 11,
"unnamed_12" VARCHAR -- Unnamed: 12
);CREATE TABLE july_2015 (
"a3131" VARCHAR,
"unnamed_1" VARCHAR -- Unnamed: 1,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7,
"unnamed_8" VARCHAR -- Unnamed: 8,
"expenditure_over_threshold" VARCHAR,
"unnamed_10" VARCHAR -- Unnamed: 10,
"unnamed_11" VARCHAR -- Unnamed: 11
);CREATE TABLE july_2016 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" BIGINT,
"ap_amount" DOUBLE -- AP Amount (Ł),
"vat_registration_number" VARCHAR,
"purchase_invoice_number" VARCHAR,
"supplier_post_code" VARCHAR,
"supplier_type" VARCHAR,
"expenditure_type" VARCHAR,
"unnamed_13" VARCHAR -- Unnamed: 13
);CREATE TABLE june_2015 (
"a3131" VARCHAR,
"unnamed_1" VARCHAR -- Unnamed: 1,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7,
"unnamed_8" VARCHAR -- Unnamed: 8,
"unnamed_9" VARCHAR -- Unnamed: 9,
"unnamed_10" VARCHAR -- Unnamed: 10,
"unnamed_11" VARCHAR -- Unnamed: 11,
"unnamed_12" VARCHAR -- Unnamed: 12
);CREATE TABLE june_2016 (
"a3131" VARCHAR,
"unnamed_1" VARCHAR -- Unnamed: 1,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7,
"unnamed_8" VARCHAR -- Unnamed: 8,
"unnamed_9" VARCHAR -- Unnamed: 9,
"expenditure_over_threshold" VARCHAR,
"unnamed_11" VARCHAR -- Unnamed: 11,
"unnamed_12" VARCHAR -- Unnamed: 12
);CREATE TABLE march_2016 (
"a3131" VARCHAR,
"unnamed_1" VARCHAR -- Unnamed: 1,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7,
"unnamed_8" VARCHAR -- Unnamed: 8,
"unnamed_9" VARCHAR -- Unnamed: 9,
"expenditure_over_threshold" VARCHAR,
"unnamed_11" VARCHAR -- Unnamed: 11,
"unnamed_12" VARCHAR -- Unnamed: 12
);CREATE TABLE may_2016 (
"a3131" VARCHAR,
"unnamed_1" VARCHAR -- Unnamed: 1,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7,
"unnamed_8" VARCHAR -- Unnamed: 8,
"unnamed_9" VARCHAR -- Unnamed: 9,
"expenditure_over_threshold" VARCHAR,
"unnamed_11" VARCHAR -- Unnamed: 11,
"unnamed_12" VARCHAR -- Unnamed: 12
);CREATE TABLE november_2015 (
"a3131" VARCHAR,
"unnamed_1" VARCHAR -- Unnamed: 1,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7,
"unnamed_8" VARCHAR -- Unnamed: 8,
"unnamed_9" VARCHAR -- Unnamed: 9,
"expenditure_over_threshold" VARCHAR,
"unnamed_11" VARCHAR -- Unnamed: 11,
"unnamed_12" VARCHAR -- Unnamed: 12
);CREATE TABLE november_2016 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" BIGINT,
"ap_amount" DOUBLE -- AP Amount (œ),
"vat_registration_number" VARCHAR,
"purchase_invoice_number" VARCHAR,
"supplier_post_code" VARCHAR,
"supplier_type" VARCHAR,
"expenditure_type" VARCHAR
);CREATE TABLE october_2015 (
"a3131" VARCHAR,
"unnamed_1" VARCHAR -- Unnamed: 1,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7,
"unnamed_8" VARCHAR -- Unnamed: 8,
"unnamed_9" VARCHAR -- Unnamed: 9,
"expenditure_over_threshold" VARCHAR,
"unnamed_11" VARCHAR -- Unnamed: 11,
"unnamed_12" VARCHAR -- Unnamed: 12,
"unnamed_13" VARCHAR -- Unnamed: 13,
"unnamed_14" VARCHAR -- Unnamed: 14,
"unnamed_15" VARCHAR -- Unnamed: 15,
"unnamed_16" VARCHAR -- Unnamed: 16,
"unnamed_17" VARCHAR -- Unnamed: 17,
"unnamed_18" VARCHAR -- Unnamed: 18,
"unnamed_19" VARCHAR -- Unnamed: 19,
"unnamed_20" VARCHAR -- Unnamed: 20,
"unnamed_21" VARCHAR -- Unnamed: 21,
"unnamed_22" VARCHAR -- Unnamed: 22,
"unnamed_23" VARCHAR -- Unnamed: 23,
"unnamed_24" VARCHAR -- Unnamed: 24,
"unnamed_25" VARCHAR -- Unnamed: 25,
"unnamed_26" VARCHAR -- Unnamed: 26,
"unnamed_27" VARCHAR -- Unnamed: 27,
"unnamed_28" VARCHAR -- Unnamed: 28,
"unnamed_29" VARCHAR -- Unnamed: 29,
"unnamed_30" VARCHAR -- Unnamed: 30,
"unnamed_31" VARCHAR -- Unnamed: 31,
"unnamed_32" VARCHAR -- Unnamed: 32,
"unnamed_33" VARCHAR -- Unnamed: 33,
"unnamed_34" VARCHAR -- Unnamed: 34,
"unnamed_35" VARCHAR -- Unnamed: 35,
"unnamed_36" VARCHAR -- Unnamed: 36,
"unnamed_37" VARCHAR -- Unnamed: 37,
"unnamed_38" VARCHAR -- Unnamed: 38,
"unnamed_39" VARCHAR -- Unnamed: 39,
"unnamed_40" VARCHAR -- Unnamed: 40,
"unnamed_41" VARCHAR -- Unnamed: 41,
"unnamed_42" VARCHAR -- Unnamed: 42,
"unnamed_43" VARCHAR -- Unnamed: 43,
"unnamed_44" VARCHAR -- Unnamed: 44,
"unnamed_45" VARCHAR -- Unnamed: 45,
"unnamed_46" VARCHAR -- Unnamed: 46,
"unnamed_47" VARCHAR -- Unnamed: 47,
"unnamed_48" VARCHAR -- Unnamed: 48,
"unnamed_49" VARCHAR -- Unnamed: 49,
"unnamed_50" VARCHAR -- Unnamed: 50,
"unnamed_51" VARCHAR -- Unnamed: 51,
"unnamed_52" VARCHAR -- Unnamed: 52,
"unnamed_53" VARCHAR -- Unnamed: 53,
"unnamed_54" VARCHAR -- Unnamed: 54,
"unnamed_55" VARCHAR -- Unnamed: 55,
"unnamed_56" VARCHAR -- Unnamed: 56,
"unnamed_57" VARCHAR -- Unnamed: 57,
"unnamed_58" VARCHAR -- Unnamed: 58
);CREATE TABLE october_2016 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" BIGINT,
"ap_amount" DOUBLE -- AP Amount (Ł),
"vat_registration_number" VARCHAR,
"purchase_invoice_number" VARCHAR,
"supplier_post_code" VARCHAR,
"supplier_type" VARCHAR,
"expenditure_type" VARCHAR
);CREATE TABLE september_2015 (
"a3131" VARCHAR,
"unnamed_1" VARCHAR -- Unnamed: 1,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7,
"unnamed_8" VARCHAR -- Unnamed: 8,
"unnamed_9" VARCHAR -- Unnamed: 9,
"expenditure_over_threshold" VARCHAR,
"unnamed_11" VARCHAR -- Unnamed: 11,
"unnamed_12" VARCHAR -- Unnamed: 12
);CREATE TABLE september_2016 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" BIGINT,
"ap_amount" DOUBLE -- AP Amount (Ł),
"vat_registration_number" VARCHAR,
"purchase_invoice_number" VARCHAR,
"supplier_post_code" VARCHAR,
"supplier_type" VARCHAR,
"expenditure_type" VARCHAR
);CREATE TABLE vale_of_york_ccg_spend_over_25k (
"run_at_9_10_2014_9_13_53_am" VARCHAR,
"unnamed_1" VARCHAR -- Unnamed: 1,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7,
"unnamed_8" VARCHAR -- Unnamed: 8,
"unnamed_9" VARCHAR -- Unnamed: 9,
"unnamed_10" VARCHAR -- Unnamed: 10,
"unnamed_11" VARCHAR -- Unnamed: 11,
"unnamed_12" VARCHAR -- Unnamed: 12
);Anyone who has the link will be able to view this.