About this Dataset

Traffic Signal Change And Clearance Interval Pooled Fund Study Intersection Summary And Crash Data

This is the master spreadsheet that includes intersection summary data and crash data that was used for the crash data modeling related to yellow change and red clearance intervals.
Organization: Department of Transportation
Last updated: 2025-09-18T00:59:23.531956
Tags: change-and-clearance-interval, crash-data, crash-prediction-model, crash-prevention-and-safety, intelligent-transportation-systems-its, its-joint-program-office-jpo, safety-data

Tables

Table 1

@usgov.dot_gov_traffic_signal_change_and_clearance_interval_p_3319189b.table_1

52.49 kB
240 rows
56 columns

CREATE TABLE table_1 (
  "intid" BIGINT,
  "legid" BIGINT,
  "state" VARCHAR,
  "county" VARCHAR,
  "major_name" VARCHAR,
  "minor_name" VARCHAR,
  "lat" DOUBLE,
  "lon" DOUBLE,
  "analysisleg" VARCHAR,
  "approachdir" VARCHAR,
  "firstyear" BIGINT,
  "lastyear" BIGINT,
  "y_th" DOUBLE,
  "r_th" DOUBLE,
  "y_lt" DOUBLE,
  "r_lt" DOUBLE,
  "pathlen_lt" BIGINT,
  "pathlen_th" BIGINT,
  "postedspeed" BIGINT,
  "speed85" DOUBLE,
  "lanes_th" BIGINT,
  "traveldir" BIGINT,
  "type_lt" BIGINT,
  "lanes_lt" BIGINT,
  "type_rt" BIGINT,
  "lanes_rt" BIGINT,
  "mode_lt" BIGINT,
  "adt15" DOUBLE,
  "adt16" DOUBLE,
  "adt17" DOUBLE,
  "adt18" DOUBLE,
  "adt19" DOUBLE,
  "adt20" DOUBLE,
  "adt21" DOUBLE,
  "adt22" DOUBLE,
  "adt23" DOUBLE,
  "ay15" BIGINT,
  "ay16" BIGINT,
  "ay17" BIGINT,
  "ay18" BIGINT,
  "ay19" BIGINT,
  "ay20" BIGINT,
  "ay21" BIGINT,
  "ay22" BIGINT,
  "ay23" BIGINT,
  "valid" BIGINT,
  "notes" VARCHAR,
  "crash_count_15" BIGINT,
  "crash_count_16" BIGINT,
  "crash_count_17" BIGINT,
  "crash_count_18" BIGINT,
  "crash_count_19" BIGINT,
  "crash_count_20" BIGINT,
  "crash_count_21" BIGINT,
  "crash_count_22" BIGINT,
  "crash_count_23" BIGINT
);