{"dot_number":"472815","summary":{"total":4,"fatalities":0,"injuries":9},"crashes":[{"crash_id":"2411446","dot_number":"472815","report_state":"TX","report_date":"20110415","report_time":"1801","city":"","state":"TX","fatalities":0,"injuries":5,"tow_away":0,"vin":"1XKDD40X39J259569","vehicle_license":"RD9R18","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"LODI DRILLING & SERVICE CO INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:41:43"},{"crash_id":"265275","dot_number":"472815","report_state":"TX","report_date":"20000219","report_time":"1640","city":"","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1M2P141Y0LM008695","vehicle_license":"R1SF41","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"LODI TRUCKING CO (LODI DRILLIN","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:49:48"},{"crash_id":"106648","dot_number":"472815","report_state":"TX","report_date":"19950723","report_time":"1000","city":"","state":"TX","fatalities":0,"injuries":3,"tow_away":0,"vin":"2HSFBAER9RC093387","vehicle_license":"R13182","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"LODI DRILLING & SERVICE CO (LODI TRUCKIN","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:52:03"},{"crash_id":"670102","dot_number":"472815","report_state":"LA","report_date":"19930205","report_time":"1737","city":"","state":"LA","fatalities":0,"injuries":1,"tow_away":0,"vin":"1M2N187Y5HA018119","vehicle_license":"R54519","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"LODI DRILLING AND SERVICE COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:52:48"}]}