{"dot_number":"54336","summary":{"total":331,"fatalities":18,"injuries":153},"crashes":[{"crash_id":"5136827","dot_number":"54336","report_state":"AZ","report_date":"20260412","report_time":"2106","city":"PAYSON","state":"AZ","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XPBAP8X0TD806853","vehicle_license":"GWA2J0","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK FOODS COMPANY","federal_recordable":"Y","state_recordable":"","source":"mcmis","ingested_at":"2026-05-16 00:30:32"},{"crash_id":"5097404","dot_number":"54336","report_state":"CA","report_date":"20260102","report_time":"2309","city":"SAN DIMAS","state":"CA","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XPBDP9X4PD829385","vehicle_license":"AL22564","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK FOODS COMPANY","federal_recordable":"Y","state_recordable":"","source":"mcmis","ingested_at":"2026-05-16 00:30:33"},{"crash_id":"5087219","dot_number":"54336","report_state":"OR","report_date":"20260101","report_time":"0810","city":"4.41 E RUFUS","state":"OR","fatalities":0,"injuries":6,"tow_away":0,"vin":"1XPBDP9XXMD744210","vehicle_license":"AL11713","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK FOODS COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:30:33"},{"crash_id":"5091209","dot_number":"54336","report_state":"CA","report_date":"20251223","report_time":"1156","city":"BEAUMONT","state":"CA","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XPBAP8XXRD656050","vehicle_license":"AM21026","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK FOODS COMPANY","federal_recordable":"Y","state_recordable":"","source":"mcmis","ingested_at":"2026-05-16 00:30:49"},{"crash_id":"5083079","dot_number":"54336","report_state":"AZ","report_date":"20251223","report_time":"0217","city":"PHOENIX","state":"AZ","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XPBDP9X9PD829396","vehicle_license":"ZLA59J","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK FOODS COMPANY","federal_recordable":"Y","state_recordable":"","source":"mcmis","ingested_at":"2026-05-16 00:30:49"},{"crash_id":"5088636","dot_number":"54336","report_state":"NM","report_date":"20251204","report_time":"0405","city":"NOT IN CITY","state":"NM","fatalities":1,"injuries":1,"tow_away":0,"vin":"3AKJHHDR1RSVJ0323","vehicle_license":"AM550004","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK FOODS COMPANY","federal_recordable":"Y","state_recordable":"","source":"mcmis","ingested_at":"2026-05-16 00:30:49"},{"crash_id":"5065992","dot_number":"54336","report_state":"AZ","report_date":"20251117","report_time":"2145","city":"BUCKEYE","state":"AZ","fatalities":1,"injuries":0,"tow_away":0,"vin":"1XPBDP9X1PD829330","vehicle_license":"FCA32H","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK FOODS COMPANY","federal_recordable":"Y","state_recordable":"","source":"mcmis","ingested_at":"2026-05-16 00:30:49"},{"crash_id":"5048468","dot_number":"54336","report_state":"AZ","report_date":"20250926","report_time":"1605","city":"Unknown","state":"AZ","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XPBAP8X8RD689032","vehicle_license":"16004WA","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK FOODS COMPANY","federal_recordable":"Y","state_recordable":"","source":"mcmis","ingested_at":"2026-05-16 00:30:49"},{"crash_id":"5029621","dot_number":"54336","report_state":"AZ","report_date":"20250904","report_time":"1236","city":"CHANDLER","state":"AZ","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XPBP49X7MD742405","vehicle_license":"JRA7A1A","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK FOODS COMPANY","federal_recordable":"Y","state_recordable":"","source":"mcmis","ingested_at":"2026-05-16 00:30:58"},{"crash_id":"4989514","dot_number":"54336","report_state":"AZ","report_date":"20250804","report_time":"1248","city":"BAGDAD","state":"AZ","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XPBDP9X9SD751744","vehicle_license":"AM57086","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK FOODS COMPANY","federal_recordable":"Y","state_recordable":"","source":"mcmis","ingested_at":"2026-05-16 00:30:59"},{"crash_id":"4988831","dot_number":"54336","report_state":"AZ","report_date":"20250625","report_time":"2134","city":"FLAGSTAFF","state":"AZ","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XPBDP9X3SD751769","vehicle_license":"AM59994","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK FOODS COMPANY","federal_recordable":"Y","state_recordable":"","source":"mcmis","ingested_at":"2026-05-16 00:30:59"},{"crash_id":"4956905","dot_number":"54336","report_state":"CA","report_date":"20250531","report_time":"0550","city":"DIAMOND BAR","state":"CA","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XPBAP8XXRD656050","vehicle_license":"AM21026","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK FOODS COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:31:15"},{"crash_id":"4950757","dot_number":"54336","report_state":"ID","report_date":"20250515","report_time":"0449","city":"WILDER","state":"ID","fatalities":0,"injuries":0,"tow_away":0,"vin":"3AKJHHDR7RSVG7685","vehicle_license":"AM57014","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK FOODS COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:31:15"},{"crash_id":"4942832","dot_number":"54336","report_state":"NM","report_date":"20250426","report_time":"1319","city":"ALBUQUERQUE","state":"NM","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XPBDP9X9PD829365","vehicle_license":"AL22330","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK FOODS COMPANY","federal_recordable":"Y","state_recordable":"N","source":"mcmis","ingested_at":"2026-05-16 00:31:15"},{"crash_id":"4935943","dot_number":"54336","report_state":"AZ","report_date":"20250419","report_time":"0658","city":"","state":"AZ","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XPBAP8X4JD485316","vehicle_license":"AH87787","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK FOODS COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:31:15"},{"crash_id":"4921548","dot_number":"54336","report_state":"UT","report_date":"20250325","report_time":"0530","city":"SPRINGVILLE","state":"UT","fatalities":0,"injuries":0,"tow_away":0,"vin":"3AKJHHDR8SSWC7446","vehicle_license":"AM56953","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK FOODS COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:31:15"},{"crash_id":"4925492","dot_number":"54336","report_state":"AZ","report_date":"20250210","report_time":"1621","city":"Camp Verde","state":"AZ","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XPBDP9X6RD688998","vehicle_license":"AM24835","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK FOODS COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:31:21"},{"crash_id":"4904669","dot_number":"54336","report_state":"AZ","report_date":"20250208","report_time":"1833","city":"Phoenix","state":"AZ","fatalities":0,"injuries":0,"tow_away":0,"vin":"2NPKHM6X5PM829553","vehicle_license":"17A7NM","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK FOODS COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:31:21"},{"crash_id":"4889524","dot_number":"54336","report_state":"OR","report_date":"20250205","report_time":"1517","city":"CENTRAL POINT","state":"OR","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XPBDP9X9RD688963","vehicle_license":"AM23659","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK FOODS COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:31:21"},{"crash_id":"4887632","dot_number":"54336","report_state":"CA","report_date":"20250113","report_time":"1733","city":"LAKE FOREST","state":"CA","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XPBDP9X3RD688974","vehicle_license":"AM23721","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK FOODS COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:31:21"},{"crash_id":"4885122","dot_number":"54336","report_state":"CA","report_date":"20241231","report_time":"1155","city":"UNINCORPORATED","state":"CA","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XPBDP9X7RD655993","vehicle_license":"AM23599","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK FOODS COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:31:21"},{"crash_id":"4853586","dot_number":"54336","report_state":"AZ","report_date":"20241126","report_time":"0411","city":"","state":"AZ","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XPBDP9XXMD744224","vehicle_license":"AL11704","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK FOODS COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:31:21"},{"crash_id":"4848449","dot_number":"54336","report_state":"AZ","report_date":"20241121","report_time":"0256","city":"","state":"AZ","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XPBAP8X5JD485308","vehicle_license":"AH87779","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK FOODS COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:31:21"},{"crash_id":"4852980","dot_number":"54336","report_state":"OR","report_date":"20241113","report_time":"2010","city":"4.70 E ROOSTER ROCK","state":"OR","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XPBDP9X3MD744226","vehicle_license":"AL11706","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK FOODS COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:31:21"},{"crash_id":"4835805","dot_number":"54336","report_state":"AZ","report_date":"20241022","report_time":"2022","city":"Unknown","state":"AZ","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XPBDP9X1ND829325","vehicle_license":"AL19434","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK FOODS COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:31:34"},{"crash_id":"4820170","dot_number":"54336","report_state":"CA","report_date":"20240828","report_time":"1120","city":"Industry","state":"CA","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XPBDP9XXPD829388","vehicle_license":"AL22568","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK FOODS COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:31:35"},{"crash_id":"4798711","dot_number":"54336","report_state":"AZ","report_date":"20240814","report_time":"0342","city":"","state":"AZ","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XPBDP9X8RD689019","vehicle_license":"AM23833","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK FOODS COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:31:35"},{"crash_id":"4792076","dot_number":"54336","report_state":"NM","report_date":"20240725","report_time":"1119","city":"LAS CRUCES","state":"NM","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XPBDP9X0PD829366","vehicle_license":"AL22388","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK FOODS COMPANY","federal_recordable":"Y","state_recordable":"N","source":"mcmis","ingested_at":"2026-05-16 00:31:40"},{"crash_id":"4786939","dot_number":"54336","report_state":"MI","report_date":"20240724","report_time":"0830","city":"DETROIT","state":"MI","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XPBD49X8PD829436","vehicle_license":"AL22521","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK FOODS COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:31:40"},{"crash_id":"4751359","dot_number":"54336","report_state":"AZ","report_date":"20240522","report_time":"0543","city":"PHOENIX","state":"AZ","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XPBDP9X8RD688999","vehicle_license":"AM24836","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK FOODS COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:31:40"},{"crash_id":"4749860","dot_number":"54336","report_state":"AZ","report_date":"20240520","report_time":"1018","city":"PHOENIX","state":"AZ","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XPBD49X9RD655945","vehicle_license":"AM24980","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK FOODS COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:31:40"},{"crash_id":"4754198","dot_number":"54336","report_state":"CA","report_date":"20240511","report_time":"0327","city":"TURLOCK","state":"CA","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XPBDP9X8RD688968","vehicle_license":"AM23664","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK FOODS COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:31:40"},{"crash_id":"4836493","dot_number":"54336","report_state":"OR","report_date":"20240507","report_time":"2105","city":"4.31 W QUINTON","state":"OR","fatalities":0,"injuries":0,"tow_away":0,"vin":"3AKJHHDR5MSMA5627","vehicle_license":"AK14845","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK FOODS COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:31:40"},{"crash_id":"4743642","dot_number":"54336","report_state":"AZ","report_date":"20240430","report_time":"0948","city":"UNKNOWN","state":"AZ","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XPBDP9X4JD485242","vehicle_license":"AH87661","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK FOODS COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:31:40"},{"crash_id":"4741773","dot_number":"54336","report_state":"AZ","report_date":"20240421","report_time":"1827","city":"UNKNOWN","state":"AZ","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XPBD49X4RD655934","vehicle_license":"AM21004","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK FOODS COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:32:02"},{"crash_id":"4738793","dot_number":"54336","report_state":"AZ","report_date":"20240406","report_time":"0253","city":"UNKNOWN","state":"AZ","fatalities":0,"injuries":1,"tow_away":0,"vin":"3AKJHHDR2LSLR1592","vehicle_license":"AJ93352","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK FOODS COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:32:02"},{"crash_id":"4736019","dot_number":"54336","report_state":"CA","report_date":"20240330","report_time":"0034","city":"Glendale","state":"CA","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XPBDP9X1RD656010","vehicle_license":"AM23643","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK FOODS COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:32:02"},{"crash_id":"4731419","dot_number":"54336","report_state":"CA","report_date":"20240327","report_time":"1345","city":"SACRAMENTO","state":"CA","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XPBDP9X3RD688960","vehicle_license":"AM23656","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK FOODS COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:32:02"},{"crash_id":"4733977","dot_number":"54336","report_state":"CA","report_date":"20240321","report_time":"0205","city":"UNINCORPORATED","state":"CA","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XPBDP9X5RD655961","vehicle_license":"AL29147","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK FOODS COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:32:02"},{"crash_id":"4718053","dot_number":"54336","report_state":"CA","report_date":"20240312","report_time":"0045","city":"VALLEJO","state":"CA","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XPBDP9X4RD655952","vehicle_license":"AL27715","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK FOODS COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:32:02"},{"crash_id":"4712617","dot_number":"54336","report_state":"ID","report_date":"20240227","report_time":"0013","city":"BLISS","state":"ID","fatalities":0,"injuries":2,"tow_away":0,"vin":"1XPBDP9X2JD461330","vehicle_license":"AJ60451","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK FOODS COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:32:02"},{"crash_id":"4721578","dot_number":"54336","report_state":"NV","report_date":"20240226","report_time":"1252","city":"","state":"NV","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XPBD49X0RD655929","vehicle_license":"AL27678","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK FOODS COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:32:02"},{"crash_id":"4695730","dot_number":"54336","report_state":"WI","report_date":"20240201","report_time":"0713","city":"HARTFORD","state":"WI","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XPBD49X1RD667538","vehicle_license":"AL28974","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK FOODS COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:32:02"},{"crash_id":"4809806","dot_number":"54336","report_state":"CO","report_date":"20240125","report_time":"0657","city":"","state":"CO","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XPBD49XXRD655937","vehicle_license":"AM20920","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK FOODS COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:32:02"},{"crash_id":"4687034","dot_number":"54336","report_state":"NV","report_date":"20240113","report_time":"1620","city":"","state":"NV","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XPBDP9X4RD688966","vehicle_license":"AM23662","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK FOODS COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:32:09"},{"crash_id":"4696659","dot_number":"54336","report_state":"CA","report_date":"20240112","report_time":"2305","city":"VACAVILLE","state":"CA","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XPBDP9X4RD656017","vehicle_license":"AM23715","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK FOODS COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:32:09"},{"crash_id":"4682835","dot_number":"54336","report_state":"WA","report_date":"20240110","report_time":"0755","city":"BENTON CITY","state":"WA","fatalities":0,"injuries":0,"tow_away":0,"vin":"3AKJHHDR7RSVG7685","vehicle_license":"AM23796","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK FOODS COMPANY","federal_recordable":"Y","state_recordable":"N","source":"mcmis","ingested_at":"2026-05-16 00:32:09"},{"crash_id":"4674108","dot_number":"54336","report_state":"AZ","report_date":"20231227","report_time":"1516","city":"PHOENIX","state":"AZ","fatalities":0,"injuries":0,"tow_away":0,"vin":"2XP2AJ7X7LM710856","vehicle_license":"9TD604","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK FOODS COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:32:09"},{"crash_id":"4673037","dot_number":"54336","report_state":"AZ","report_date":"20231216","report_time":"1908","city":"PHOENIX","state":"AZ","fatalities":0,"injuries":0,"tow_away":0,"vin":"JHHYDM1H3LK009025","vehicle_license":"ASA4DZA","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK FOODS COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:32:09"},{"crash_id":"4671719","dot_number":"54336","report_state":"AZ","report_date":"20231213","report_time":"1603","city":"TEMPE","state":"AZ","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XPBP49X3MD742403","vehicle_license":"9TE124","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK FOODS COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:32:09"}]}