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

31.33 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

43.37 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  -- Unnamed: 17
);