{"dot_number":"1285243","summary":{"total":28,"fatalities":0,"injuries":19},"crashes":[{"crash_id":"5045757","dot_number":"1285243","report_state":"TX","report_date":"20251013","report_time":"0830","city":"NOT LISTED","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XPWD49X69D771556","vehicle_license":"1L55770","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK VACUUM SERVICE INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:30:49"},{"crash_id":"5011461","dot_number":"1285243","report_state":"TX","report_date":"20250701","report_time":"0659","city":"BAYTOWN","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"1M1PN4GY8LM004393","vehicle_license":"1M29265","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK VACUUM SERVICE INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:30:59"},{"crash_id":"5011447","dot_number":"1285243","report_state":"TX","report_date":"20250628","report_time":"0456","city":"MONT BELVIEU","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"1M1AN07Y0JM027923","vehicle_license":"1L55898","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK VACUUM SERVICE INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:30:59"},{"crash_id":"4655240","dot_number":"1285243","report_state":"TX","report_date":"20231110","report_time":"0536","city":"NOT LISTED","state":"TX","fatalities":0,"injuries":3,"tow_away":0,"vin":"1M1AN07Y5EM015661","vehicle_license":"1L55764","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK VACUUM SERVICE INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:32:09"},{"crash_id":"4655201","dot_number":"1285243","report_state":"TX","report_date":"20231109","report_time":"1840","city":"HOUSTON","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XPWD49X69D771556","vehicle_license":"1L55770","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK VACUUM SERVICE INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:32:09"},{"crash_id":"4529591","dot_number":"1285243","report_state":"TX","report_date":"20230306","report_time":"1548","city":"LIBERTY (LIBERTY)","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"1M1PN4GY1KM001382","vehicle_license":"1M29243","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK VACUUM SERVICE INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:32:53"},{"crash_id":"4313244","dot_number":"1285243","report_state":"TX","report_date":"20220222","report_time":"1030","city":"NOT LISTED","state":"TX","fatalities":0,"injuries":2,"tow_away":0,"vin":"1XPWD49X39D779601","vehicle_license":"1L55772","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK VACUUM SERVICE INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:33:38"},{"crash_id":"4318964","dot_number":"1285243","report_state":"TX","report_date":"20220104","report_time":"0545","city":"MONT BELVIEU","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1M1AN07Y5EM015661","vehicle_license":"1L55764","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK VACUUM SERVICE INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:33:39"},{"crash_id":"4234180","dot_number":"1285243","report_state":"TX","report_date":"20211003","report_time":"0805","city":"NOT LISTED","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"1M1AN07Y9JM027922","vehicle_license":"1L55899","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK VACUUM SERVICE INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:33:46"},{"crash_id":"4197785","dot_number":"1285243","report_state":"TX","report_date":"20210730","report_time":"1144","city":"BAYTOWN","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1M1PN4GY2LM005300","vehicle_license":"1M29275","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK VACUUM SERVICE INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:34:00"},{"crash_id":"3807272","dot_number":"1285243","report_state":"TX","report_date":"20190613","report_time":"1800","city":"RURAL LIBERTY COUNTY","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1M1PN4GY8KM001380","vehicle_license":"1M29242","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK VACUUM SERVICE INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:35:34"},{"crash_id":"3548450","dot_number":"1285243","report_state":"TX","report_date":"20180131","report_time":"0645","city":"HUNTSVILLE","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"1M1AN07Y5EM015661","vehicle_license":"1L55764","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK VACUUM SERVICE INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:36:58"},{"crash_id":"3272060","dot_number":"1285243","report_state":"TX","report_date":"20160830","report_time":"1649","city":"RURAL JEFFERSON COUNTY","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"1M1AJ06Y06N006228","vehicle_license":"1J55890","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK VACUUM SERVICE INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:38:02"},{"crash_id":"3247569","dot_number":"1285243","report_state":"TX","report_date":"20160712","report_time":"1345","city":"HOUSTON","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XKWD49X58R231901","vehicle_license":"1J55859","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK VACUUM SERVICE INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:38:12"},{"crash_id":"3233224","dot_number":"1285243","report_state":"TX","report_date":"20160606","report_time":"0940","city":"HOUSTON","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XPWD49X59D779602","vehicle_license":"1J55852","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK VACUUM SERVICE INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:38:12"},{"crash_id":"3225531","dot_number":"1285243","report_state":"TX","report_date":"20150611","report_time":"1334","city":"LIBERTY (LIBERTY)","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1M2AA18YXWW085304","vehicle_license":"1G53773","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK VACUUM SERVICE INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:39:05"},{"crash_id":"3015914","dot_number":"1285243","report_state":"TX","report_date":"20130701","report_time":"1720","city":"RURAL JEFFERSON COUNTY","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XP5DB9X47D660386","vehicle_license":"1C73010","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK VACUUM SERVICE INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:40:24"},{"crash_id":"2575584","dot_number":"1285243","report_state":"TX","report_date":"20120615","report_time":"1310","city":"","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"1M2AY04Y6HM002851","vehicle_license":"IA72977","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK VACUUM SERVICE INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:40:55"},{"crash_id":"2570668","dot_number":"1285243","report_state":"TX","report_date":"20120531","report_time":"0711","city":"","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XPWD49X29D771554","vehicle_license":"1A72984","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK VACUUM SERVICE INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:40:55"},{"crash_id":"2454766","dot_number":"1285243","report_state":"TX","report_date":"20110811","report_time":"1650","city":"","state":"TX","fatalities":0,"injuries":2,"tow_away":0,"vin":"1M1AJ07Y37N009902","vehicle_license":"2DE022","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK VACUUM SERVICE INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:41:33"},{"crash_id":"2305079","dot_number":"1285243","report_state":"TX","report_date":"20100817","report_time":"0833","city":"","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"1M1AA18Y92W148164","vehicle_license":"2RV060","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK VACUUM SERVICE INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:42:17"},{"crash_id":"2305724","dot_number":"1285243","report_state":"TX","report_date":"20100811","report_time":"1100","city":"","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XP5DB9X27D660385","vehicle_license":"2RV064","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK VACUUM SERVICE INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:42:17"},{"crash_id":"2259629","dot_number":"1285243","report_state":"TX","report_date":"20100418","report_time":"1601","city":"","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XPWD49X39D779601","vehicle_license":"2RV074","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK VACUUM SERVICE INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:42:43"},{"crash_id":"2167357","dot_number":"1285243","report_state":"LA","report_date":"20090913","report_time":"1930","city":"800","state":"LA","fatalities":0,"injuries":1,"tow_away":0,"vin":"1M1AA18Y32W144580","vehicle_license":"2BS235","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK VACUUM SERVICE INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:42:56"},{"crash_id":"1977946","dot_number":"1285243","report_state":"TX","report_date":"20080419","report_time":"1920","city":"","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XP5DB9X27D660385","vehicle_license":"2DE135","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK VACUUM SERVICE INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:43:42"},{"crash_id":"2091047","dot_number":"1285243","report_state":"TX","report_date":"20080119","report_time":"1340","city":"","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"1M1AA18Y92W148164","vehicle_license":"2BR965","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK VACUUM SERVICE INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:44:08"},{"crash_id":"1902008","dot_number":"1285243","report_state":"TX","report_date":"20071127","report_time":"1055","city":"","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XP5DB9X47D660386","vehicle_license":"2CG757","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK VACUUM SERVICE INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:44:08"},{"crash_id":"1663267","dot_number":"1285243","report_state":"TX","report_date":"20060622","report_time":"0638","city":"","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"1M1AA14Y62W14780","vehicle_license":"R7RG99","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SHAMROCK VACUUM SERVICE INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:44:49"}]}