Payments To Suppliers
Blaby District Council
@ukgov.bdc_payments_to_suppliers
Blaby District Council
@ukgov.bdc_payments_to_suppliers
These datasets contain details of individual payments to suppliers, with a value over £250 (inc. VAT), with new information being added on a monthly basis.
Publisher name: Blaby District Council
Last updated: 2024-09-14T19:31:43Z
CREATE TABLE january_2014 (
"supplier_name" VARCHAR,
"portfolio" VARCHAR,
"cost_centre" VARCHAR,
"expenditure_class" VARCHAR,
"post_date" VARCHAR -- POST. DATE,
"amount" DOUBLE,
"ref" DOUBLE -- REF.
);CREATE TABLE january_2015 (
"supplier_name" VARCHAR,
"portfolio" VARCHAR,
"cost_centre" VARCHAR,
"expenditure_class" VARCHAR,
"post_date" VARCHAR -- POST. DATE,
"amount" DOUBLE,
"irrecoverable_vat" DOUBLE,
"ref" DOUBLE -- REF.
);CREATE TABLE january_2016 (
"unnamed_0" VARCHAR -- Unnamed: 0,
"supplier_payments_where_charge_to_specific_cost_centre_f06178f5" VARCHAR -- SUPPLIER PAYMENTS WHERE CHARGE TO SPECIFIC COST CENTRES IS OVER +/- Ł250 (inc. VAT),
"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
);CREATE TABLE january_2017 (
"unnamed_0" VARCHAR -- Unnamed: 0,
"supplier_payments_where_charge_to_specific_cost_centre_f06178f5" VARCHAR -- SUPPLIER PAYMENTS WHERE CHARGE TO SPECIFIC COST CENTRES IS OVER +/- Œ250 (inc. VAT),
"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
);CREATE TABLE january_2018 (
"unnamed_0" VARCHAR -- Unnamed: 0,
"supplier_payments_where_charge_to_specific_cost_centre_f06178f5" VARCHAR -- SUPPLIER PAYMENTS WHERE CHARGE TO SPECIFIC COST CENTRES IS OVER +/- Ł250 (inc. VAT),
"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
);CREATE TABLE july_2013 (
"supplier_name" VARCHAR,
"portfolio" VARCHAR,
"cost_centre" VARCHAR,
"expenditure_class" VARCHAR,
"post_date" VARCHAR -- POST. DATE,
"amount" DOUBLE,
"ref" DOUBLE -- REF.
);CREATE TABLE july_2014 (
"supplier_name" VARCHAR,
"portfolio" VARCHAR,
"cost_centre" VARCHAR,
"expenditure_class" VARCHAR,
"post_date" VARCHAR -- POST. DATE,
"amount" DOUBLE,
"ref" DOUBLE -- REF.
);CREATE TABLE july_2015 (
"unnamed_0" VARCHAR -- Unnamed: 0,
"blaby_district_council" VARCHAR,
"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
);CREATE TABLE july_2016 (
"unnamed_0" VARCHAR -- Unnamed: 0,
"supplier_payments_where_charge_to_specific_cost_centre_f06178f5" VARCHAR -- SUPPLIER PAYMENTS WHERE CHARGE TO SPECIFIC COST CENTRES IS OVER +/- Ł250 (inc. VAT),
"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
);CREATE TABLE july_2017 (
"unnamed_0" VARCHAR -- Unnamed: 0,
"supplier_payments_where_charge_to_specific_cost_centre_f06178f5" VARCHAR -- SUPPLIER PAYMENTS WHERE CHARGE TO SPECIFIC COST CENTRES IS OVER +/- Ł250 (inc. VAT),
"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
);CREATE TABLE july_2018 (
"unnamed_0" VARCHAR -- Unnamed: 0,
"supplier_payments_where_charge_to_specific_cost_centre_f06178f5" VARCHAR -- SUPPLIER PAYMENTS WHERE CHARGE TO SPECIFIC COST CENTRES IS OVER +/- Ł250 (inc. VAT),
"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
);CREATE TABLE june_2014 (
"supplier_name" VARCHAR,
"portfolio" VARCHAR,
"cost_centre" VARCHAR,
"expenditure_class" VARCHAR,
"post_date" VARCHAR -- POST. DATE,
"amount" DOUBLE,
"ref" DOUBLE -- REF.
);CREATE TABLE june_2015 (
"unnamed_0" VARCHAR -- Unnamed: 0,
"supplier_payments_where_charge_to_specific_cost_centre_f06178f5" VARCHAR -- SUPPLIER PAYMENTS WHERE CHARGE TO SPECIFIC COST CENTRES IS OVER +/- Ł250 (inc. VAT),
"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
);CREATE TABLE june_2016 (
"unnamed_0" VARCHAR -- Unnamed: 0,
"supplier_payments_where_charge_to_specific_cost_centre_f06178f5" VARCHAR -- SUPPLIER PAYMENTS WHERE CHARGE TO SPECIFIC COST CENTRES IS OVER +/- Ł250 (inc. VAT),
"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
);CREATE TABLE june_2017 (
"unnamed_0" VARCHAR -- Unnamed: 0,
"supplier_payments_where_charge_to_specific_cost_centre_f06178f5" VARCHAR -- SUPPLIER PAYMENTS WHERE CHARGE TO SPECIFIC COST CENTRES IS OVER +/- Ł250 (inc. VAT),
"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
);CREATE TABLE june_2018 (
"unnamed_0" VARCHAR -- Unnamed: 0,
"supplier_payments_where_charge_to_specific_cost_centre_f06178f5" VARCHAR -- SUPPLIER PAYMENTS WHERE CHARGE TO SPECIFIC COST CENTRES IS OVER +/- Ł250 (inc. VAT),
"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
);CREATE TABLE march_2013 (
"supplier_name" VARCHAR,
"unnamed_1" DOUBLE -- Unnamed: 1,
"portfolio" VARCHAR,
"cost_centre" VARCHAR,
"expenditure_class" VARCHAR,
"post_date" VARCHAR -- POST. DATE,
"amount" DOUBLE,
"ref" DOUBLE -- REF.,
"unnamed_8" VARCHAR -- Unnamed: 8
);CREATE TABLE march_2014 (
"supplier_name" VARCHAR,
"portfolio" VARCHAR,
"cost_centre" VARCHAR,
"expenditure_class" VARCHAR,
"post_date" VARCHAR -- POST. DATE,
"amount" DOUBLE,
"ref" DOUBLE -- REF.
);CREATE TABLE march_2015 (
"supplier_name" VARCHAR,
"portfolio" VARCHAR,
"cost_centre" VARCHAR,
"expenditure_class" VARCHAR,
"post_date" VARCHAR -- POST. DATE,
"amount" DOUBLE,
"irrecoverable_vat" DOUBLE,
"ref" DOUBLE -- REF.
);CREATE TABLE march_2016 (
"unnamed_0" VARCHAR -- Unnamed: 0,
"supplier_payments_where_charge_to_specific_cost_centre_f06178f5" VARCHAR -- SUPPLIER PAYMENTS WHERE CHARGE TO SPECIFIC COST CENTRES IS OVER +/- £250 (inc. VAT),
"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
);CREATE TABLE march_2017 (
"unnamed_0" VARCHAR -- Unnamed: 0,
"supplier_payments_where_charge_to_specific_cost_centre_f06178f5" VARCHAR -- SUPPLIER PAYMENTS WHERE CHARGE TO SPECIFIC COST CENTRES IS OVER +/- Ł250 (inc. VAT),
"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
);CREATE TABLE march_2018 (
"unnamed_0" VARCHAR -- Unnamed: 0,
"supplier_payments_where_charge_to_specific_cost_centre_f06178f5" VARCHAR -- SUPPLIER PAYMENTS WHERE CHARGE TO SPECIFIC COST CENTRES IS OVER +/- Ł250 (inc. VAT),
"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
);CREATE TABLE may_2013 (
"supplier_name" VARCHAR,
"unnamed_1" DOUBLE -- Unnamed: 1,
"portfolio" VARCHAR,
"cost_centre" VARCHAR,
"expenditure_class" VARCHAR,
"post_date" VARCHAR -- POST. DATE,
"amount" DOUBLE,
"ref" DOUBLE -- REF.,
"unnamed_8" VARCHAR -- Unnamed: 8
);CREATE TABLE may_2014 (
"supplier_name" VARCHAR,
"portfolio" VARCHAR,
"cost_centre" VARCHAR,
"expenditure_class" VARCHAR,
"post_date" VARCHAR -- POST. DATE,
"amount" DOUBLE,
"ref" DOUBLE -- REF.
);CREATE TABLE may_2015 (
"unnamed_0" VARCHAR -- Unnamed: 0,
"supplier_payments_where_charge_to_specific_cost_centre_f06178f5" VARCHAR -- SUPPLIER PAYMENTS WHERE CHARGE TO SPECIFIC COST CENTRES IS OVER +/- Ł250 (inc. VAT),
"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
);Anyone who has the link will be able to view this.