Cambridgeshire County Council Government Procurement Card Transactions

Cambridgeshire Insight

@ukgov.cambridgeshire_county_council_government_procurement_c_ce7ce3f8

Table List

6 tables(567.35 KB)

Cambridgeshire County Council Government Procurement Card Spend: 2021-22

Cambridgeshire County Council Government Procurement Card Spend: 2022-23

CambsGPC2014-15Q3

CambsGPC2014-15Q2

CambsGPC2014-15Q1

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

CambsGPC2014-15Q3

@ukgov.cambridgeshire_county_council_government_procurement_c_ce7ce3f8.cambsgpc2014_15q3

65.98 KB
4110 rows
12 columns

organisation_name Organisation Name	organisation_code Organisation Code	effective_date Effective Date	transaction_date Transaction Date	service_area Service Area	supplier_name Supplier Name	amount_inc_vat Amount (inc VAT)	vat_amount VAT Amount	description Description	merchantcategory MerchantCategory
Cambridgeshire County Council	http://statistics.data.gov.uk/id/local-authority/12	Sat Jan 31 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Dec 31 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Children, Families & Adults	East Midlands	58		Staff subsistence	PASSENGER RAILWAYS
Cambridgeshire County Council	http://statistics.data.gov.uk/id/local-authority/12	Sat Jan 31 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Dec 31 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Children, Families & Adults	M6 TOLL	5.5		Staff subsistence	BRIDGE AND ROAD FEES, TOLLS
Cambridgeshire County Council	http://statistics.data.gov.uk/id/local-authority/12	Sat Jan 31 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Dec 31 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Children, Families & Adults	CFU PBOROUGH	15		Non-Premises - costs of residential unit	FINES
Cambridgeshire County Council	http://statistics.data.gov.uk/id/local-authority/12	Sat Jan 31 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Dec 31 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Children, Families & Adults	GTR WEB RAIL SALES	-88.6		Staff subsistence	PASSENGER RAILWAYS
Cambridgeshire County Council	http://statistics.data.gov.uk/id/local-authority/12	Sat Jan 31 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Dec 31 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Children, Families & Adults	STAPLES UK	41.47	6.91	Gen. Office Expenses & Stationery	OFFICE, SCHOOL SUPPLY, AND STATIONERY STORES
Cambridgeshire County Council	http://statistics.data.gov.uk/id/local-authority/12	Sat Jan 31 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Dec 31 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Children, Families & Adults	ROADCHEF CHESTER	8.67		Staff subsistence	EATING PLACES, RESTAURANTS
Cambridgeshire County Council	http://statistics.data.gov.uk/id/local-authority/12	Sat Jan 31 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Dec 31 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Children, Families & Adults	TESCO STORES 2228	88.92		Provisions - General	GROCERY STORES, SUPERMARKETS
Cambridgeshire County Council	http://statistics.data.gov.uk/id/local-authority/12	Sat Jan 31 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Dec 31 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Children, Families & Adults	TESCO STORES 2470	2.95		Gen. Office Expenses & Stationery	GROCERY STORES, SUPERMARKETS
Cambridgeshire County Council	http://statistics.data.gov.uk/id/local-authority/12	Sat Jan 31 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Dec 31 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Children, Families & Adults	WWW.DVLA.GOV.UK	167.5		Repairs & Servicing	GOVERNMENT SERVICES-NOT ELSEWHERE CLASSIFIED
Cambridgeshire County Council	http://statistics.data.gov.uk/id/local-authority/12	Sat Jan 31 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Dec 31 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Children, Families & Adults	SPORTSDIRECT.COM	19.98	3.33	Clothing / Uniform	SPORTING GOODS STORES


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