{"dot_number":"1847475","summary":{"total":6,"fatalities":1,"injuries":3},"crashes":[{"crash_id":"4887520","dot_number":"1847475","report_state":"TX","report_date":"20250124","report_time":"2126","city":"NOT LISTED","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XPXD49X5MD768449","vehicle_license":"IRL5001","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"JOSEPH RANDALL","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:31:21"},{"crash_id":"4671236","dot_number":"1847475","report_state":"NM","report_date":"20231213","report_time":"0705","city":"97","state":"NM","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XPXD49X7ND788297","vehicle_license":"IRL9590","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"RANDALL TRUCKING","federal_recordable":"Y","state_recordable":"N","source":"mcmis","ingested_at":"2026-05-16 00:32:09"},{"crash_id":"4618923","dot_number":"1847475","report_state":"CO","report_date":"20230812","report_time":"1100","city":"","state":"CO","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XPBDP9X3HD297712","vehicle_license":"M3127IR","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"RANDALL TRUCKING","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:32:29"},{"crash_id":"3830213","dot_number":"1847475","report_state":"TX","report_date":"20190725","report_time":"1420","city":"RURAL PARMER COUNTY","state":"TX","fatalities":1,"injuries":0,"tow_away":0,"vin":"3ALXFB006EDFW4167","vehicle_license":"IRK3804","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"JOE RANDALL","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:35:22"},{"crash_id":"3373827","dot_number":"1847475","report_state":"NM","report_date":"20170307","report_time":"2153","city":"CLOVIS","state":"NM","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XPD49X68D354193","vehicle_license":"1RH8552","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"RANDALL TRUCKING","federal_recordable":"Y","state_recordable":"N","source":"mcmis","ingested_at":"2026-05-16 00:37:54"},{"crash_id":"2803859","dot_number":"1847475","report_state":"NM","report_date":"20131217","report_time":"0750","city":"","state":"NM","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XP5DB9X54D813739","vehicle_license":"IRJ0771","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"RANDALL TRUCKING","federal_recordable":"Y","state_recordable":"N","source":"mcmis","ingested_at":"2026-05-16 00:40:11"}]}