{"dot_number":"452875","summary":{"total":8,"fatalities":0,"injuries":4},"crashes":[{"crash_id":"4131610","dot_number":"452875","report_state":"TX","report_date":"20210324","report_time":"0900","city":"NOT LISTED","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"3HSCEAPR84N083643","vehicle_license":"2ZH151","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"JUAN CARRANCO","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:34:14"},{"crash_id":"2943727","dot_number":"452875","report_state":"TX","report_date":"20141023","report_time":"0430","city":"RURAL CAMERON COUNTY","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1FUYDSEB8SH631539","vehicle_license":"R033499","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"JUAN CARRANCO","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:39:33"},{"crash_id":"1923612","dot_number":"452875","report_state":"TX","report_date":"20080110","report_time":"1615","city":"","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XP5DB8X4SD381742","vehicle_license":"R05581","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"JUAN CARRANCO","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:44:08"},{"crash_id":"1916541","dot_number":"452875","report_state":"TX","report_date":"20071213","report_time":"1135","city":"","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"1M2P267C3TM025138","vehicle_license":"R05579","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"JUAN CARRANCO","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:44:08"},{"crash_id":"1792684","dot_number":"452875","report_state":"NE","report_date":"20070425","report_time":"1415","city":"AURORA","state":"NE","fatalities":0,"injuries":0,"tow_away":0,"vin":"1FUPCXYB6SH662103","vehicle_license":"R7MP90","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"JUAN CARRANCO","federal_recordable":"Y","state_recordable":"N","source":"mcmis","ingested_at":"2026-05-16 00:44:26"},{"crash_id":"1438744","dot_number":"452875","report_state":"MS","report_date":"20041113","report_time":"0911","city":"LYON","state":"MS","fatalities":0,"injuries":0,"tow_away":0,"vin":"UNKNOWN","vehicle_license":"R5FM22","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"JUAN CARRANCO","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:46:16"},{"crash_id":"1351447","dot_number":"452875","report_state":"TN","report_date":"20031110","report_time":"1530","city":"","state":"TN","fatalities":0,"injuries":1,"tow_away":0,"vin":"","vehicle_license":"","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"JUAN CARRANCO","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:46:51"},{"crash_id":"385595","dot_number":"452875","report_state":"AL","report_date":"20000107","report_time":"1845","city":"00","state":"AL","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XP5DR9X6TN392292","vehicle_license":"R92718","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"JUAN CARRANCO","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:49:48"}]}