datahub-transportation-gov/crash-file-aayw-vxb3
Icon for Socrata external plugin
Open repository in Console
 
Readme
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 https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"datahub-transportation-gov/crash-file-aayw-vxb3\".\"crash_file\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • crash_file
     
     
     
     
     
Upstream Metadata