Cambridgeshire County Council Expenditure Over £500
Cambridgeshire Insight
@ukgov.cambridgeshire_county_council_expenditure_over_5001
Cambridgeshire Insight
@ukgov.cambridgeshire_county_council_expenditure_over_5001
Payments to suppliers with a value of £500 or over (inclusive of VAT) made by Cambridgeshire County Council. These are published in monthly datasheets and in line with the Local Government Transparency Code.
Publisher name: Cambridgeshire Insight
Last updated: 2025-05-03T04:00:21Z
CREATE TABLE cambridgeshire_county_council_expenditure_april_2015 (
"body" VARCHAR,
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);CREATE TABLE cambridgeshire_county_council_expenditure_april_2016 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);CREATE TABLE cambridgeshire_county_council_expenditure_april_2017 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);CREATE TABLE cambridgeshire_county_council_expenditure_april_2018 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" DOUBLE,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR,
"unnamed_9" VARCHAR -- Unnamed: 9,
"unnamed_10" VARCHAR -- Unnamed: 10,
"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
);CREATE TABLE cambridgeshire_county_council_expenditure_april_2019 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);CREATE TABLE cambridgeshire_county_council_expenditure_april_2020 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);CREATE TABLE cambridgeshire_county_council_expenditure_april_2021 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);CREATE TABLE cambridgeshire_county_council_expenditure_april_2022 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);CREATE TABLE cambridgeshire_county_council_expenditure_april_2023 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);CREATE TABLE cambridgeshire_county_council_expenditure_april_2024 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);CREATE TABLE cambridgeshire_county_council_expenditure_august_2015 (
"body" VARCHAR,
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);CREATE TABLE cambridgeshire_county_council_expenditure_august_2016 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);CREATE TABLE cambridgeshire_county_council_expenditure_august_2017 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);CREATE TABLE cambridgeshire_county_council_expenditure_august_2018 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);CREATE TABLE cambridgeshire_county_council_expenditure_august_2019 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);CREATE TABLE cambridgeshire_county_council_expenditure_august_2020 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);CREATE TABLE cambridgeshire_county_council_expenditure_august_2021 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);CREATE TABLE cambridgeshire_county_council_expenditure_august_2022 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);CREATE TABLE cambridgeshire_county_council_expenditure_august_2023 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);CREATE TABLE cambridgeshire_county_council_expenditure_august_2024 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);CREATE TABLE cambridgeshire_county_council_expenditure_december_2015 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);CREATE TABLE cambridgeshire_county_council_expenditure_december_2016 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);CREATE TABLE cambridgeshire_county_council_expenditure_december_2017 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);CREATE TABLE cambridgeshire_county_council_expenditure_december_2018 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" DOUBLE,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);CREATE TABLE cambridgeshire_county_council_expenditure_december_2019 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);Anyone who has the link will be able to view this.