About this Dataset

Legacy Baton Rouge Traffic Incidents (2021 - 2022)

***On August 30, 2022, the Baton Rouge Police Department switched to a new crash reporting system. This dataset contains data from 1/1/2021 to 8/29/2022. To view traffic incident data prior to January 1, 2021 please use the Legacy Baton Rouge Traffic Incidents (2010-2020) dataset at https://data.brla.gov/Transportation-and-Infrastructure/Legacy-Baton-Rouge-Traffic-Incidents/2tu5-7kif

Original records for all vehicular crashes that occurred within the City of Baton Rouge which were not processed by the Center for Analytics & Research in Transportation Safety (CARTS) at LSU.
Organization: City of Baton Rouge
Last updated: 2021-09-22T19:37:12.007682
Tags: brpd, crash, traffic

Tables

Table 1

@usgov.city_of_baton_rouge_baton_rouge_traffic_incidents_3da6d.table_1

1.23 MB
20,932 rows
33 columns

CREATE TABLE table_1 (
  "incident_number" VARCHAR,
  "crash_date" VARCHAR,
  "street_address" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" DOUBLE,
  "district" DOUBLE,
  "zone" VARCHAR,
  "subzone" VARCHAR,
  "total_vehicles" BIGINT,
  "road_class" VARCHAR,
  "hit_and_run" BOOLEAN,
  "train" BOOLEAN,
  "fatality" BOOLEAN,
  "injury" BOOLEAN,
  "pedestrian" BOOLEAN,
  "intersection" BOOLEAN,
  "nearest_street" VARCHAR,
  "manner_of_collision" VARCHAR,
  "roadway_surface" VARCHAR,
  "roadway_condition" VARCHAR,
  "roadway_design" VARCHAR,
  "alignment" VARCHAR,
  "primary_factor" VARCHAR,
  "secondary_factor" VARCHAR,
  "weather" VARCHAR,
  "location_type" VARCHAR,
  "roadway_relation" VARCHAR,
  "access_control" VARCHAR,
  "lighting" VARCHAR,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "geolocation" VARCHAR
);