Cambridgeshire County Council Traffic Count Data

Cambridgeshire Insight

@ukgov.cambridgeshire_county_council_traffic_count_data1

Table List

2 tables(72.95 KB)

Traffic Counts 2009-13

Traffic Counts 2010-2014

Traffic Counts 2010-2014

@ukgov.cambridgeshire_county_council_traffic_count_data1.traffic_counts_2010_2014

42.35 KB
761 rows
18 columns

reference Reference	type Type	road Road	road_name Road Name	year Year	date Date	pedestrians Pedestrians	pedal_cycles Pedal Cycles	motorcycles Motorcycles	car Car	lgv LGV	hgv HGV	bus Bus	total_motor_vehicles Total Motor Vehicles	easting Easting	northing Northing
2010-1	Cambridge Screenline	C290	Bridge Street	2010	Mon Mar 15 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	6606	3522	39	1062	192	32	691	2016	544729	258941
2010-2	Cambridge Screenline	Footbridge	Garrett Hostel Lane	2010	Mon Mar 15 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	1806	2110							544553	258508
2010-3	Cambridge Screenline	Footbridge	Jesus Lock	2010	Tue Mar 16 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	2990	1944							544986	259296
2010-4	Cambridge Screenline	Footbridge	Mill Lane Weir	2010	Tue Mar 16 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	1394	723							544679	258011
2010-5	Cambridge Screenline	Footbridge	Coe Fen	2010	Tue Mar 16 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	687	1191							544736	257332
2010-6	Cambridge Screenline	A1134	Elizabeth Way	2010	Wed Mar 17 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	612	1608	391	19478	2736	474	274	23353	546064	259249
2010-7	Cambridge Screenline	Footbridge	Green Dragon	2010	Thu Mar 18 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	743	2256							546700	259854
2010-8	Cambridge Screenline	Footbridge	Fort St George	2010	Thu Mar 18 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	1068	1725							545513	259265
2010-9	Cambridge Screenline	Footbridge	Riverside	2010	Thu Mar 18 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	806	1278							546454	259475
2010-10	Cambridge Screenline	C294	Silver Street	2010	Fri Mar 19 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	3637	2382	127	3188	296	32	181	3824	544551	257956


CREATE TABLE traffic_counts_2010_2014 (
  "reference" VARCHAR,
  "type" VARCHAR,
  "road" VARCHAR,
  "road_name" VARCHAR,
  "year" BIGINT,
  "date" TIMESTAMP,
  "pedestrians" DOUBLE,
  "pedal_cycles" BIGINT,
  "motorcycles" DOUBLE,
  "car" DOUBLE,
  "lgv" DOUBLE,
  "hgv" DOUBLE,
  "bus" DOUBLE,
  "total_motor_vehicles" BIGINT,
  "notes" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT,
  "unnamed_17" VARCHAR
);