About this Dataset

Legacy Baton Rouge Traffic Incidents (2010 - 2020)

***On January 1, 2021, the Baton Rouge Police Department switched to a new reporting system. This dataset contains data from 1/1/2010 to 12/31/2020. For data from 1/1/2021 to 8/29/22 please visit: https://data.brla.gov/Transportation-and-Infrastructure/Baton-Rouge-Traffic-Incidents/sfeg-d9ip

Traffic incident reports handled by the Baton Rouge Police Department from 2010 to 2020.
Organization: City of Baton Rouge
Last updated: 2020-11-12T14:59:46.133229
Tags: accident, brpd, crash, police, traffic

Tables

Table 1

@usgov.city_of_baton_rouge_baton_rouge_traffic_incidents.table_1

7.49 MB
177,119 rows
34 columns

CREATE TABLE table_1 (
  "file" VARCHAR  -- FILE#,
  "crash_date" TIMESTAMP,
  "crash_time" VARCHAR,
  "tot_veh" BIGINT,
  "district" VARCHAR,
  "zone" VARCHAR,
  "subzone" VARCHAR,
  "street" DOUBLE  -- STREET#,
  "street_direction" VARCHAR,
  "street_name" VARCHAR,
  "street_type" VARCHAR,
  "formatted_street" VARCHAR,
  "occured_on" VARCHAR,
  "hit_run" VARCHAR,
  "train_involved" VARCHAR,
  "fatality" VARCHAR,
  "injury" VARCHAR,
  "pedestrian" VARCHAR,
  "at_intersection" VARCHAR,
  "closest_street" VARCHAR,
  "manner_of_collision" VARCHAR,
  "surface_condition" VARCHAR,
  "surface_type" VARCHAR,
  "road_condition" VARCHAR,
  "road_type" VARCHAR,
  "alignment" VARCHAR,
  "primary_factor" VARCHAR,
  "second_factor" VARCHAR,
  "weather" VARCHAR,
  "location_kind" VARCHAR,
  "relation_roadway" VARCHAR,
  "access_control" VARCHAR,
  "lighting" VARCHAR,
  "geolocation" VARCHAR
);