Vehicle Inspection File
Federal and State field enforcement staff performs Inspections on Interstate and Intrastate Motor Carriers and Hazardous Materials carriers. Violations of the Federal Motor Carrier Safety Regulations (FMCSRs) severe enough may result in a vehicle and/or driver being placed "out-of-service." The data collected from inspection activity is collected and stored in the FMCSA Motor Carrier Management Information System (MCMIS) Inspection Data Files.
Due to privacy restrictions, driver information is not included in any inspection files released to the public.
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/vehicle-inspection-file-fx4q-ay7w\".\"vehicle_inspection_file\"
LIMIT 100
"}
EOFSee the Splitgraph documentation
for more information.
