Cambridgeshire County Council Expenditure Over £500
Cambridgeshire Insight
@ukgov.cambridgeshire_county_council_expenditure_over_5001
Cambridgeshire Insight
@ukgov.cambridgeshire_county_council_expenditure_over_5001
CREATE TABLE cambridgeshire_county_council_expenditure_march_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_march_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_march_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_may_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_may_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_may_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_may_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_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_may_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_may_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_may_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_may_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_may_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_may_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_november_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_november_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_november_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_november_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_november_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_november_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_november_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_november_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_november_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_november_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_october_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_october_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
);
Anyone who has the link will be able to view this.