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
CREATE TABLE june_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,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR
);
CREATE TABLE march_2016 (
"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
);
CREATE TABLE vale_of_york_ccg_spend_over_25k (
"run_at_9_10_2014_9_13_53_am" 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,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR
);
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
);
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
);
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,
"vat_registration_number" VARCHAR,
"purchase_invoice_number" VARCHAR,
"supplier_post_code" VARCHAR,
"supplier_type" VARCHAR,
"expenditure_type" VARCHAR
);
CREATE TABLE april_2016 (
"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
);
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,
"vat_registration_number" VARCHAR,
"purchase_invoice_number" VARCHAR,
"supplier_post_code" VARCHAR,
"supplier_type" VARCHAR,
"expenditure_type" VARCHAR
);
CREATE TABLE november_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
);
CREATE TABLE february_2017 (
"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
);
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,
"vat_registration_number" VARCHAR,
"purchase_invoice_number" VARCHAR,
"supplier_post_code" VARCHAR,
"supplier_type" VARCHAR,
"expenditure_type" VARCHAR,
"unnamed_13" VARCHAR
);
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,
"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_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
);
CREATE TABLE february_2016 (
"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
);
CREATE TABLE january_2016 (
"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
);
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,
"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_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
);
CREATE TABLE june_2016 (
"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
);
CREATE TABLE may_2016 (
"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
);
CREATE TABLE july_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,
"expenditure_over_threshold" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR
);
Anyone who has the link will be able to view this.