About this Dataset

Cambridgeshire County Council Government Procurement Card Transactions

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

Tables

Cambridgeshire County Council Government Procurement Card Spend: 2023-24 Quarter 1

@ukgov.cambridgeshire_county_council_government_procurement_c_ce7ce3f8.cambridgeshire_county_council_government_procurement_c_0c3eaeb7

61.53 KB
3552 rows
8 columns


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
);

Cambridgeshire County Council Government Procurement Card Spend: 2021-22

@ukgov.cambridgeshire_county_council_government_procurement_c_ce7ce3f8.cambridgeshire_county_council_government_procurement_c_463bebd0

142.16 KB
10006 rows
8 columns


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
);

Cambridgeshire County Council Government Procurement Card Spend: 2022-23

@ukgov.cambridgeshire_county_council_government_procurement_c_ce7ce3f8.cambridgeshire_county_council_government_procurement_c_ab916b7b

167.86 KB
12735 rows
8 columns


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
);

CambsGPC2014-15Q1

@ukgov.cambridgeshire_county_council_government_procurement_c_ce7ce3f8.cambsgpc2014_15q1

64.59 KB
3979 rows
12 columns


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
);

CambsGPC2014-15Q2

@ukgov.cambridgeshire_county_council_government_procurement_c_ce7ce3f8.cambsgpc2014_15q2

65.23 KB
3860 rows
12 columns


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,
  "vat_amount" DOUBLE,
  "nonrecoverablevat" VARCHAR,
  "description" VARCHAR,
  "merchantcategory" VARCHAR
);

CambsGPC2014-15Q3

@ukgov.cambridgeshire_county_council_government_procurement_c_ce7ce3f8.cambsgpc2014_15q3

65.98 KB
4110 rows
12 columns


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,
  "vat_amount" DOUBLE,
  "nonrecoverablevat" VARCHAR,
  "description" VARCHAR,
  "merchantcategory" VARCHAR
);