Dataset: Baton Rouge Traffic Crash Incidents

About this Dataset

Baton Rouge Traffic Crash Incidents

Traffic incident (crash) reports beginning on September 1, 2022. This dataset includes records for all vehicular crashes which occurred within the City of Baton Rouge and has been processed by the Center for Analytics & Research in Transportation Safety (CARTS) at LSU.

To view traffic incident data prior to September 1, 2022 use the two (2) Legacy Baton Rouge Traffic Incident datasets.
Organization: City of Baton Rouge
Last updated: 2023-11-03T13:52:51.122674
Tags: brpd, crash, traffic

Tables

Table 1

@usgov.city_of_baton_rouge_baton_rouge_traffic_crash_incidents_c1a90.table_1

1.64 MB
24482 rows
33 columns


CREATE TABLE table_1 (
  "incident_number" VARCHAR,
  "crash_date" VARCHAR,
  "street_address" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" BIGINT,
  "intersecting_street" VARCHAR,
  "district" DOUBLE,
  "zone" VARCHAR,
  "subzone" VARCHAR,
  "crash_occurred_on" VARCHAR,
  "kind_of_location" VARCHAR,
  "access_control" VARCHAR,
  "type_of_roadway" VARCHAR,
  "road_surface" VARCHAR,
  "roadway_condition" VARCHAR,
  "weather_condition" VARCHAR,
  "lighting_condition" VARCHAR,
  "injury" BIGINT,
  "fatality" BIGINT,
  "hit_and_run" BIGINT,
  "pedestrian_involved" BIGINT,
  "train_involved" BIGINT,
  "intersection" BIGINT,
  "total_vehicles" BIGINT,
  "vehicle_alignment" VARCHAR,
  "relation_to_roadway" VARCHAR,
  "manner_of_collision" VARCHAR,
  "primary_factor" VARCHAR,
  "secondary_factor" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "geometry" VARCHAR
);