Icon for Socrata external plugin
Open repository in Console
Updated 4 hours ago
Indexed 2 hours ago

Crash File

The FMCSA Crash File contains data from state police crash reports involving drivers and vehicles of motor carriers operating in the U.S. Each report contains about 80 data elements pertaining to the motor carrier, driver, vehicles, and circumstances of a crash. Due to sensitive and/or privacy restrictions, driver, and hazardous materials data are not included in any crash files released to the public.

The Crash File may contain multiple records for a crash. Separate reports are entered for each commercial motor vehicle involved in a crash. These multiple reports can be distinguished by the Crash Report Number field.

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 \
    -H "Content-Type: application/json" \
{"sql": "
    SELECT *
    FROM \"datahub-transportation-gov/crash-file-aayw-vxb3\".\"crash_file\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • crash_file
Upstream Metadata