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

@ukgov.cambridgeshire_county_council_government_procurement_c_ce7ce3f8.cambsgpc2014_15q2

65.23 KB
3860 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	Thu Oct 30 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Sep 29 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Children, Families & Adults	Amazon Mktplce EU-UK	17.57	1.31	Educational Materials	BOOK STORES
Cambridgeshire County Council	http://statistics.data.gov.uk/id/local-authority/12	Thu Oct 30 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Sep 29 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Children, Families & Adults	ASDA STORES	22.48		Gen. Office Expenses & Stationery	GROCERY STORES, SUPERMARKETS
Cambridgeshire County Council	http://statistics.data.gov.uk/id/local-authority/12	Thu Oct 30 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Sep 29 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Children, Families & Adults	B & Q	29.9	5.98	Curriculum expenses	BUILDING MATERIALS, LUMBER STORES
Cambridgeshire County Council	http://statistics.data.gov.uk/id/local-authority/12	Thu Oct 30 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Sep 29 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Children, Families & Adults	THE SALVATION ARMY	10		Offending Project	ORGANIZATIONS, CHARITABLE AND SOCIAL SERVICES
Cambridgeshire County Council	http://statistics.data.gov.uk/id/local-authority/12	Thu Oct 30 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Sep 29 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Children, Families & Adults	PAYPAL SPHILLIPS19	7.99		Gen. Office Expenses & Stationery	MISCELLANEOUS AND SPECIALTY RETAIL STORES
Cambridgeshire County Council	http://statistics.data.gov.uk/id/local-authority/12	Thu Oct 30 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Sep 29 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Children, Families & Adults	WAITROSE 484	4.19		Gen. Office Expenses & Stationery	GROCERY STORES, SUPERMARKETS
Cambridgeshire County Council	http://statistics.data.gov.uk/id/local-authority/12	Thu Oct 30 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Sep 29 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Children, Families & Adults	ASDA STORES 7134	28.52		Gen. Office Expenses & Stationery	GROCERY STORES, SUPERMARKETS
Cambridgeshire County Council	http://statistics.data.gov.uk/id/local-authority/12	Thu Oct 30 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Sep 29 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Children, Families & Adults	TRAVIS PERKINS	192.55	32.09	Curriculum expenses	BUILDING MATERIALS, LUMBER STORES
Cambridgeshire County Council	http://statistics.data.gov.uk/id/local-authority/12	Thu Oct 30 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Sep 29 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	LGSS Cambridge Office	LAND REGISTRY	3		Oth Prof. Fees & Hired Services	GOVERNMENT SERVICES-NOT ELSEWHERE CLASSIFIED
Cambridgeshire County Council	http://statistics.data.gov.uk/id/local-authority/12	Thu Oct 30 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Sep 29 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Children, Families & Adults	ASDA STORES 7134	95.56		Gen. Office Expenses & Stationery	GROCERY STORES, SUPERMARKETS


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