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 april_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 april_2014 (
"supplier_name" VARCHAR,
"portfolio" VARCHAR,
"cost_centre" VARCHAR,
"expenditure_class" VARCHAR,
"post_date" VARCHAR -- POST. DATE,
"amount" DOUBLE,
"ref" DOUBLE -- REF.
);CREATE TABLE april_2015 (
"supplier_name" VARCHAR,
"portfolio" VARCHAR,
"cost_centre" VARCHAR,
"expenditure_class" VARCHAR,
"post_date" TIMESTAMP -- POST. DATE,
"amount" DOUBLE,
"irrecoverable_vat" BIGINT,
"proclass_ref" BIGINT -- PROCLASS REF.
);CREATE TABLE april_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 april_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 april_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 august_2013 (
"supplier_name" VARCHAR,
"portfolio" VARCHAR,
"cost_centre" VARCHAR,
"expenditure_class" VARCHAR,
"post_date" VARCHAR -- POST. DATE,
"amount" DOUBLE,
"ref" DOUBLE -- REF.
);CREATE TABLE august_2014 (
"supplier_name" VARCHAR,
"portfolio" VARCHAR,
"cost_centre" VARCHAR,
"expenditure_class" VARCHAR,
"post_date" VARCHAR -- POST. DATE,
"amount" DOUBLE,
"ref" DOUBLE -- REF.
);CREATE TABLE august_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 august_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 august_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 august_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 december_2013 (
"supplier_name" VARCHAR,
"portfolio" VARCHAR,
"cost_centre" VARCHAR,
"expenditure_class" VARCHAR,
"post_date" VARCHAR -- POST. DATE,
"amount" DOUBLE,
"ref" DOUBLE -- REF.
);CREATE TABLE december_2014 (
"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 december_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 december_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 december_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 december_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 february_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 february_2014 (
"supplier_name" VARCHAR,
"portfolio" VARCHAR,
"cost_centre" VARCHAR,
"expenditure_class" VARCHAR,
"post_date" VARCHAR -- POST. DATE,
"amount" DOUBLE,
"ref" DOUBLE -- REF.
);CREATE TABLE february_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 february_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 february_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 february_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 january_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
);Anyone who has the link will be able to view this.