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.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"brla-gov/legacy-baton-rouge-traffic-incidents-2021-2022-sfeg-d9ip\".\"legacy_baton_rouge_traffic_incidents_2021_2022\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.