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-15Q1

@ukgov.cambridgeshire_county_council_government_procurement_c_ce7ce3f8.cambsgpc2014_15q1

64.59 KB
3979 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_incl_vat Amount Incl VAT	vat_amount VAT Amount	description Description	merchantcategory MerchantCategory
Cambridgeshire County Council	http://statistics.data.gov.uk/id/local-authority/12	Thu Jul 31 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Jun 30 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Economy, Transport & Environment	TESCO STORES-2889	2		Provisions - General	GROCERY STORES, SUPERMARKETS
Cambridgeshire County Council	http://statistics.data.gov.uk/id/local-authority/12	Thu Jul 31 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Jun 30 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Children, Families & Adults	TESCO STORE 2694	331.48		Gen. Office Expenses & Stationery	GROCERY STORES, SUPERMARKETS
Cambridgeshire County Council	http://statistics.data.gov.uk/id/local-authority/12	Thu Jul 31 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Jun 30 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Economy, Transport & Environment	GREATER ANGLIA	40.8		Staff subsistence	PASSENGER RAILWAYS
Cambridgeshire County Council	http://statistics.data.gov.uk/id/local-authority/12	Thu Jul 31 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Jun 30 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Children, Families & Adults	EAT N BOWL	91		Staff Training & Development	BOWLING ALLEYS
Cambridgeshire County Council	http://statistics.data.gov.uk/id/local-authority/12	Thu Jul 31 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Jun 30 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Children, Families & Adults	MACHINE MART LTD	143.98		Cleaning equipment and tools	HOUSEHOLD APPLIANCE STORES
Cambridgeshire County Council	http://statistics.data.gov.uk/id/local-authority/12	Thu Jul 31 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Jun 30 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Children, Families & Adults	MOLE COUNTRY STORES	27.27		Grounds Maintenance	AGRICULTURAL COOPERATIVES
Cambridgeshire County Council	http://statistics.data.gov.uk/id/local-authority/12	Thu Jul 31 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Jun 30 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Corporate Services	SAINSBURYS 2007	220		Provisions - General	GROCERY STORES, SUPERMARKETS
Cambridgeshire County Council	http://statistics.data.gov.uk/id/local-authority/12	Thu Jul 31 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Jun 30 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Corporate Services	WAITROSE 163	6.49		Provisions - General	GROCERY STORES, SUPERMARKETS
Cambridgeshire County Council	http://statistics.data.gov.uk/id/local-authority/12	Thu Jul 31 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Jun 30 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Corporate Services	GREATER ANGLIA	29.45		Staff subsistence	PASSENGER RAILWAYS
Cambridgeshire County Council	http://statistics.data.gov.uk/id/local-authority/12	Thu Jul 31 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Jun 30 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Children, Families & Adults	STANWICK LAKES	50	8.33	Gen. Office Expenses & Stationery	EATING PLACES, RESTAURANTS


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