Cambridgeshire County Council Government Procurement Card Transactions
Cambridgeshire Insight
@ukgov.cambridgeshire_county_council_government_procurement_c_ce7ce3f8
Cambridgeshire Insight
@ukgov.cambridgeshire_county_council_government_procurement_c_ce7ce3f8
This page shows the Government Procurement Card (GPC) Transactions made by Cambridgeshire County Council from 2014 Q1 onwards.
The datasets detail the GPC transactions made by Cambridgeshire County Council each quarter. They show where and when the transactions were made, the cost, and by which service area within the Council.
Publisher name: Cambridgeshire Insight
Last updated: 2025-04-03T04:00:14Z
CREATE TABLE cambridgeshire_county_council_government_procurement_c_0c3eaeb7 (
"body_name" VARCHAR,
"transaction_date" TIMESTAMP,
"transaction_amount" VARCHAR,
"merchant_name" VARCHAR,
"merchant_description" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);CREATE TABLE cambridgeshire_county_council_government_procurement_c_463bebd0 (
"body_name" VARCHAR,
"transaction_date" TIMESTAMP,
"transaction_amount" VARCHAR,
"merchant_name" VARCHAR,
"merchant_description" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);CREATE TABLE cambridgeshire_county_council_government_procurement_c_ab916b7b (
"body_name" VARCHAR,
"transaction_date" TIMESTAMP,
"transaction_amount" VARCHAR,
"merchant_name" VARCHAR,
"merchant_description" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);CREATE TABLE cambsgpc2014_15q1 (
"organisation_name" VARCHAR,
"organisation_code" VARCHAR,
"effective_date" TIMESTAMP,
"transaction_date" TIMESTAMP,
"service_area" VARCHAR,
"supplier_name" VARCHAR,
"companyregistrationnumber" VARCHAR,
"amount_incl_vat" DOUBLE,
"vat_amount" DOUBLE,
"nonrecoverablevat" VARCHAR,
"description" VARCHAR,
"merchantcategory" VARCHAR
);CREATE TABLE cambsgpc2014_15q2 (
"organisation_name" VARCHAR,
"organisation_code" VARCHAR,
"effective_date" TIMESTAMP,
"transaction_date" TIMESTAMP,
"service_area" VARCHAR,
"supplier_name" VARCHAR,
"companyregistrationnumber" VARCHAR,
"amount_inc_vat" DOUBLE -- Amount (inc VAT),
"vat_amount" DOUBLE,
"nonrecoverablevat" VARCHAR,
"description" VARCHAR,
"merchantcategory" VARCHAR
);CREATE TABLE cambsgpc2014_15q3 (
"organisation_name" VARCHAR,
"organisation_code" VARCHAR,
"effective_date" TIMESTAMP,
"transaction_date" TIMESTAMP,
"service_area" VARCHAR,
"supplier_name" VARCHAR,
"companyregistrationnumber" VARCHAR,
"amount_inc_vat" DOUBLE -- Amount (inc VAT),
"vat_amount" DOUBLE,
"nonrecoverablevat" VARCHAR,
"description" VARCHAR,
"merchantcategory" VARCHAR
);Anyone who has the link will be able to view this.