{"dot_number":"237574","summary":{"total":4,"fatalities":1,"injuries":0},"crashes":[{"crash_id":"4682874","dot_number":"237574","report_state":"TX","report_date":"20231229","report_time":"1059","city":"DALLAS","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"3ALACWFC8PDNT0702","vehicle_license":"2363741","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"PISOS COLONIALES DE MEXICO SA DE CV","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:32:09"},{"crash_id":"4595255","dot_number":"237574","report_state":"TX","report_date":"20230717","report_time":"1931","city":"WAXAHACHIE","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"3AKJHHDR3PSNS6729","vehicle_license":"R625337","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"PISOS COLONIALES DE MEXICO SA DE CV","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:32:29"},{"crash_id":"2436040","dot_number":"237574","report_state":"MO","report_date":"20110701","report_time":"0245","city":"NON-CITY OR UNINCORPORATE","state":"MO","fatalities":0,"injuries":0,"tow_away":0,"vin":"1HTMMAAM27H503315","vehicle_license":"1047099","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"PISOS COLONIALES DE MEXICO SA DE CV","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:41:33"},{"crash_id":"199869","dot_number":"237574","report_state":"VT","report_date":"19960724","report_time":"1857","city":"SHELBURNE","state":"VT","fatalities":1,"injuries":0,"tow_away":0,"vin":"1FUWDCYASSH825060","vehicle_license":"PR4787","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"PISOS COLONIALESDE","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:51:34"}]}