Cambridgeshire County Council Traffic Count Data by UK Government | Transportation and Logistics

About this Dataset

Cambridgeshire County Council Traffic Count Data

"Traffic Counts" data refers to the number of vehicles counted at predetermined specific points across the county. It is collated annually by the Data Analysis and Performance team, using video surveys, and is summarised by vehicle type.
Publisher name: Cambridgeshire Insight
Last updated: 2024-09-14T15:52:38Z

Tables

Traffic Counts 2009-13

@ukgov.cambridgeshire_county_council_traffic_count_data1.traffic_counts_2009_13

30.6 KB
687 rows
10 columns


CREATE TABLE traffic_counts_2009_13 (
  "reference" BIGINT,
  "road_number" VARCHAR,
  "road_name" VARCHAR,
  "day" VARCHAR,
  "date" BIGINT,
  "all_vehicle_flow" BIGINT,
  "hgv_flow" DOUBLE,
  "bus_coach_flow" DOUBLE,
  "easting" DOUBLE,
  "northing" DOUBLE
);

Traffic Counts 2010-2014

@ukgov.cambridgeshire_county_council_traffic_count_data1.traffic_counts_2010_2014

42.35 KB
761 rows
18 columns


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