{"current_page":1,"data":[{"id":12633014,"change_date":"2026-08-04 21:40:00","inspection_id":"88604222","dot_number":"30254","report_state":"CA","report_number":"UCOD000303","insp_date":"2026-08-04 00:00:00","insp_start_time":"0820","insp_end_time":"0900","registration_date":null,"region":"PD","ci_status_code":"C","location":"881","location_desc":"CA","county_code_state":"CA","county_code":"067","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SHERWINWILLIAMS","shipping_paper_number":"INVOICE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-08-04 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3904811","transaction_code":"A","transaction_date":"2026-08-04 00:00:00","upload_date":"2026-08-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-08-04 21:40:00","snet_input_date":"2026-08-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-08-04 21:40:00","insp_carrier_name":"THE SHERWIN WILLIAMS COMPANY","insp_carrier_street":"101 PROSPECT AVE 1000 MIDLAND BLDG","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44115","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"524","created_at":"2026-08-07T09:39:52.000000Z","updated_at":"2026-08-08T09:40:29.000000Z","inspection_violations":[{"id":21993276,"change_date":"2026-08-04 21:40:00","inspection_id":"88604222","insp_violation_id":"275921702","seq_no":"1","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"214978764","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-07T09:57:43.000000Z","updated_at":"2026-08-08T09:59:14.000000Z","normalized_code":"3939ALIL"},{"id":21993277,"change_date":"2026-08-04 21:40:00","inspection_id":"88604222","insp_violation_id":"275921703","seq_no":"2","part_no":"390","part_no_section":"21TE-LCMVINFO","insp_viol_unit":"1","insp_unit_id":"214978764","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-07T09:57:43.000000Z","updated_at":"2026-08-08T09:59:14.000000Z","normalized_code":"39021TELCMVINFO"}],"inspection_per_units":[{"id":21929816,"change_date":"2026-08-04 21:40:00","inspection_id":"88604222","insp_unit_id":"214978764","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"78441S2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5PVNJ8JV2L4S76821","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-07T09:18:46.000000Z","updated_at":"2026-08-08T09:17:47.000000Z"}]},{"id":12639022,"change_date":"2026-08-05 21:42:00","inspection_id":"88610537","dot_number":"30254","report_state":"CA","report_number":"NBH6008190","insp_date":"2026-08-03 00:00:00","insp_start_time":"0738","insp_end_time":"0816","registration_date":null,"region":"PD","ci_status_code":"C","location":"366","location_desc":"CA","county_code_state":"CA","county_code":"095","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-08-05 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"16000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3910341","transaction_code":"A","transaction_date":"2026-08-05 00:00:00","upload_date":"2026-08-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-08-05 21:42:00","snet_input_date":"2026-08-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-08-05 21:42:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"1 SHERWIN WAY","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44113","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"524","created_at":"2026-08-08T09:41:10.000000Z","updated_at":"2026-08-08T09:41:10.000000Z","inspection_violations":[{"id":22005651,"change_date":"2026-08-05 21:42:00","inspection_id":"88610537","insp_violation_id":"275938444","seq_no":"1","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"214990904","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-08-08T10:00:37.000000Z","updated_at":"2026-08-08T10:00:37.000000Z","normalized_code":"39375A3TAOL"}],"inspection_per_units":[{"id":21940013,"change_date":"2026-08-05 21:42:00","inspection_id":"88610537","insp_unit_id":"214990904","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"01289L3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDUF4GN6MED23062","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-08T09:18:45.000000Z","updated_at":"2026-08-08T09:18:45.000000Z"}]},{"id":12558972,"change_date":"2026-07-27 21:39:00","inspection_id":"88526434","dot_number":"30254","report_state":"NJ","report_number":"SPPPI02335","insp_date":"2026-07-27 00:00:00","insp_start_time":"0934","insp_end_time":"0958","registration_date":null,"region":"ED","ci_status_code":"C","location":"1217","location_desc":"NJ","county_code_state":"NJ","county_code":"023","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SHERWIN WILLIAMS","shipping_paper_number":"2028","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-27 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3843401","transaction_code":"A","transaction_date":"2026-07-27 00:00:00","upload_date":"2026-07-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-07-27 21:39:00","snet_input_date":"2026-07-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-27 21:39:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"1 SHERWIN WAY","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44113","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-30T09:40:03.000000Z","updated_at":"2026-08-07T09:30:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21807264,"change_date":"2026-07-27 21:39:00","inspection_id":"88526434","insp_unit_id":"214836504","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WAB","insp_unit_company":null,"insp_unit_license":"XSHV69","insp_unit_license_state":"NJ","insp_unit_vehicle_id_number":"1FDNF6AN8TDF00966","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-30T09:17:31.000000Z","updated_at":"2026-08-07T09:02:12.000000Z"}]},{"id":12559074,"change_date":"2026-07-27 21:39:00","inspection_id":"88526543","dot_number":"30254","report_state":"ME","report_number":"9217000116","insp_date":"2026-07-27 00:00:00","insp_start_time":"1048","insp_end_time":"1059","registration_date":null,"region":"ED","ci_status_code":"C","location":"000507","location_desc":"ME","county_code_state":"ME","county_code":"023","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"THE SHERWIN WILLIAMS COMPANY","shipping_paper_number":"70577957869938","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-27 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3843532","transaction_code":"A","transaction_date":"2026-07-27 00:00:00","upload_date":"2026-07-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-07-27 21:39:00","snet_input_date":"2026-07-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-27 21:39:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"1 SHERWIN WAY","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44113","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-30T09:40:03.000000Z","updated_at":"2026-08-07T09:30:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21807433,"change_date":"2026-07-27 21:39:00","inspection_id":"88526543","insp_unit_id":"214836693","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"-","insp_unit_license":"772CSE","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1FDUF4GN9REF82832","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-30T09:17:31.000000Z","updated_at":"2026-08-07T09:02:16.000000Z"}]},{"id":12574428,"change_date":"2026-07-29 21:41:00","inspection_id":"88542613","dot_number":"30254","report_state":"CO","report_number":"0571770049","insp_date":"2026-07-27 00:00:00","insp_start_time":"1234","insp_end_time":"1250","registration_date":null,"region":"MD","ci_status_code":"C","location":"FCPESB","location_desc":"FORT COLLINS CO","county_code_state":"CO","county_code":"069","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3856242","transaction_code":"A","transaction_date":"2026-07-28 00:00:00","upload_date":"2026-07-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-07-29 21:41:00","snet_input_date":"2026-07-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-29 21:41:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"1 SHERWIN WAY","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44113-2206","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-08-01T09:41:20.000000Z","updated_at":"2026-08-08T09:32:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21833064,"change_date":"2026-07-29 21:41:00","inspection_id":"88542613","insp_unit_id":"214866548","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"N\/A","insp_unit_license":"AUXA13","insp_unit_license_state":"CO","insp_unit_vehicle_id_number":"1FDUF4GN2MED22846","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-01T09:18:04.000000Z","updated_at":"2026-08-08T09:04:09.000000Z"}]},{"id":12559784,"change_date":"2026-07-27 21:39:00","inspection_id":"88527294","dot_number":"30254","report_state":"ID","report_number":"2757002510","insp_date":"2026-07-22 00:00:00","insp_start_time":"0820","insp_end_time":"0841","registration_date":null,"region":"PD","ci_status_code":"C","location":null,"location_desc":"POST FALLS ID","county_code_state":"ID","county_code":"055","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-27 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"3","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3845260","transaction_code":"A","transaction_date":"2026-07-27 00:00:00","upload_date":"2026-07-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-07-27 21:39:00","snet_input_date":"2026-07-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-27 21:39:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"1 SHERWIN WAY","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44113-2206","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-30T09:40:05.000000Z","updated_at":"2026-08-07T09:30:54.000000Z","inspection_violations":[{"id":21865669,"change_date":"2026-07-27 21:39:00","inspection_id":"88527294","insp_violation_id":"275755494","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-30T09:58:49.000000Z","updated_at":"2026-08-07T09:41:29.000000Z","normalized_code":"3922SLLS2"},{"id":21865670,"change_date":"2026-07-27 21:39:00","inspection_id":"88527294","insp_violation_id":"275755495","seq_no":"2","part_no":"392","part_no_section":"2-SLLSIV","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-30T09:58:49.000000Z","updated_at":"2026-08-07T09:41:29.000000Z","normalized_code":"3922SLLSIV"},{"id":21865671,"change_date":"2026-07-27 21:39:00","inspection_id":"88527294","insp_violation_id":"275755496","seq_no":"3","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"214837972","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-30T09:58:49.000000Z","updated_at":"2026-08-07T09:41:29.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":21808599,"change_date":"2026-07-27 21:39:00","inspection_id":"88527294","insp_unit_id":"214837972","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"KAW949","insp_unit_license_state":"ID","insp_unit_vehicle_id_number":"1FDUF4GN6NEE43879","insp_unit_decal":"Y","insp_unit_decal_number":"36722403","created_at":"2026-07-30T09:17:33.000000Z","updated_at":"2026-08-07T09:02:24.000000Z"}]},{"id":12510322,"change_date":"2026-07-21 21:40:00","inspection_id":"88474575","dot_number":"30254","report_state":"NM","report_number":"1397Q5M82P","insp_date":"2026-07-21 00:00:00","insp_start_time":"0115","insp_end_time":"0135","registration_date":null,"region":"MD","ci_status_code":"C","location":null,"location_desc":"NM","county_code_state":"NM","county_code":"013","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SHERWIN WILLIAMS","shipping_paper_number":"70435257810068","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3805173","transaction_code":"A","transaction_date":"2026-07-21 00:00:00","upload_date":"2026-07-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-07-21 21:40:00","snet_input_date":"2026-07-21 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-21 21:40:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"1 SHERWIN WAY","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44113","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-24T09:42:33.000000Z","updated_at":"2026-08-01T09:31:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21726545,"change_date":"2026-07-21 21:40:00","inspection_id":"88474575","insp_unit_id":"214739105","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"UNIT001","insp_unit_license":"TXY9650","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FDUF4GN9PED59347","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-24T09:20:11.000000Z","updated_at":"2026-08-01T09:02:40.000000Z"}]},{"id":12506561,"change_date":"2026-07-21 21:39:00","inspection_id":"88470627","dot_number":"30254","report_state":"NY","report_number":"D507102536","insp_date":"2026-07-20 00:00:00","insp_start_time":"1029","insp_end_time":"1054","registration_date":null,"region":"ED","ci_status_code":"C","location":"40714W","location_desc":"CHURCHVILLE NY","county_code_state":"NY","county_code":"055","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3800180","transaction_code":"A","transaction_date":"2026-07-21 00:00:00","upload_date":"2026-07-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-07-21 21:39:00","snet_input_date":"2026-07-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-21 21:39:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"1 SHERWIN WAY","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44113-2206","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-24T09:42:27.000000Z","updated_at":"2026-08-01T09:30:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21720405,"change_date":"2026-07-21 21:39:00","inspection_id":"88470627","insp_unit_id":"214731892","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"14536MP","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDUF4GN6LED62443","insp_unit_decal":"Y","insp_unit_decal_number":"REPORT","created_at":"2026-07-24T09:19:57.000000Z","updated_at":"2026-08-01T09:01:53.000000Z"}]},{"id":12487358,"change_date":"2026-07-18 21:35:00","inspection_id":"88450448","dot_number":"30254","report_state":"WI","report_number":"2653007023","insp_date":"2026-07-16 00:00:00","insp_start_time":"0720","insp_end_time":"0739","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"LAKE HALLIE WI","county_code_state":"WI","county_code":"017","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SELF","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-18 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3786042","transaction_code":"A","transaction_date":"2026-07-18 00:00:00","upload_date":"2026-07-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-07-18 21:35:00","snet_input_date":"2026-07-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-18 21:35:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"1 SHERWIN WAY","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44113-2206","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-21T09:42:48.000000Z","updated_at":"2026-07-29T09:30:16.000000Z","inspection_violations":[{"id":21739073,"change_date":"2026-07-18 21:35:00","inspection_id":"88450448","insp_violation_id":"275592088","seq_no":"1","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-21T10:05:42.000000Z","updated_at":"2026-07-29T09:40:38.000000Z","normalized_code":"3922SLL"},{"id":21739074,"change_date":"2026-07-18 21:35:00","inspection_id":"88450448","insp_violation_id":"275592089","seq_no":"2","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"1","insp_unit_id":"214695357","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-21T10:05:42.000000Z","updated_at":"2026-07-29T09:40:38.000000Z","normalized_code":"3939ALLPL"}],"inspection_per_units":[{"id":21688179,"change_date":"2026-07-18 21:35:00","inspection_id":"88450448","insp_unit_id":"214695357","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"FB46151","insp_unit_license_state":"WI","insp_unit_vehicle_id_number":"1FDUF4GY0KEE76513","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-21T09:20:21.000000Z","updated_at":"2026-07-29T09:01:16.000000Z"}]},{"id":12464845,"change_date":"2026-07-16 21:41:00","inspection_id":"88425646","dot_number":"30254","report_state":"NY","report_number":"5L48000141","insp_date":"2026-07-15 00:00:00","insp_start_time":"0937","insp_end_time":"0945","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"NIAGARA FALLS NY","county_code_state":"NY","county_code":"063","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3766293","transaction_code":"A","transaction_date":"2026-07-16 00:00:00","upload_date":"2026-07-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-07-16 21:41:00","snet_input_date":"2026-07-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-16 21:41:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"1 SHERWIN WAY","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44113-2206","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-19T09:41:02.000000Z","updated_at":"2026-07-27T09:30:35.000000Z","inspection_violations":[{"id":21701645,"change_date":"2026-07-16 21:41:00","inspection_id":"88425646","insp_violation_id":"275542619","seq_no":"1","part_no":"393","part_no_section":"9A-LSML","insp_viol_unit":"1","insp_unit_id":"214644988","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-19T10:03:48.000000Z","updated_at":"2026-07-27T09:42:42.000000Z","normalized_code":"3939ALSML"}],"inspection_per_units":[{"id":21650486,"change_date":"2026-07-16 21:41:00","inspection_id":"88425646","insp_unit_id":"214644988","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"BLUE","insp_unit_license":"58334NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDUF4GN1PEC82179","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-19T09:20:14.000000Z","updated_at":"2026-07-27T09:02:00.000000Z"}]},{"id":12505424,"change_date":"2026-07-21 21:39:00","inspection_id":"88469437","dot_number":"30254","report_state":"PR","report_number":"8100000763","insp_date":"2026-07-14 00:00:00","insp_start_time":"0856","insp_end_time":"0900","registration_date":null,"region":"AS","ci_status_code":"C","location":"PM-SAL","location_desc":"SALINAS PR","county_code_state":"PR","county_code":"123","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3798719","transaction_code":"A","transaction_date":"2026-07-20 00:00:00","upload_date":"2026-07-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-07-21 21:39:00","snet_input_date":"2026-07-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-21 21:39:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"1 SHERWIN WAY","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44113","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-24T09:42:25.000000Z","updated_at":"2026-08-01T09:30:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21718517,"change_date":"2026-07-21 21:39:00","inspection_id":"88469437","insp_unit_id":"214729789","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"H104590","insp_unit_license_state":"PR","insp_unit_vehicle_id_number":"1FDUF4GN6REE86169","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-24T09:19:53.000000Z","updated_at":"2026-08-01T09:01:38.000000Z"}]},{"id":12458926,"change_date":"2026-07-15 21:42:00","inspection_id":"88419404","dot_number":"30254","report_state":"AK","report_number":"KAL0000092","insp_date":"2026-07-14 00:00:00","insp_start_time":"0853","insp_end_time":"0909","registration_date":null,"region":"AK","ci_status_code":"C","location":"UEBA1","location_desc":"ANCHORAGE AK","county_code_state":"AK","county_code":"020","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"THE SHERWIN WILLIAMS COMPANY","shipping_paper_number":"70817657726238","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-15 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3757924","transaction_code":"A","transaction_date":"2026-07-15 00:00:00","upload_date":"2026-07-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-07-15 21:42:00","snet_input_date":"2026-07-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-15 21:42:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"1 SHERWIN WAY","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44113","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-18T09:40:58.000000Z","updated_at":"2026-07-26T09:31:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21640375,"change_date":"2026-07-15 21:42:00","inspection_id":"88419404","insp_unit_id":"214633122","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"JVL758","insp_unit_license_state":"AK","insp_unit_vehicle_id_number":"1FDUF4GN4LED62439","insp_unit_decal":"Y","insp_unit_decal_number":"36768546","created_at":"2026-07-18T09:20:31.000000Z","updated_at":"2026-07-26T09:03:32.000000Z"}]},{"id":12479759,"change_date":"2026-07-30 21:42:00","inspection_id":"88441171","dot_number":"30254","report_state":"NY","report_number":"SPE3071678","insp_date":"2026-07-10 00:00:00","insp_start_time":"1311","insp_end_time":"1342","registration_date":"2026-07-29 00:00:00","region":"ED","ci_status_code":"C","location":"30876M","location_desc":"WATERLOO NY","county_code_state":"NY","county_code":"099","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SHERWIN WILLIAMS COMPANY","shipping_paper_number":"70437957682293","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-17 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3773884","transaction_code":"C","transaction_date":"2026-07-16 00:00:00","upload_date":"2026-07-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-07-17 21:42:00","snet_input_date":"2026-07-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-17 21:42:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"1 SHERWIN WAY","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44113","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-20T09:42:45.000000Z","updated_at":"2026-08-08T09:34:00.000000Z","inspection_violations":[{"id":21726580,"change_date":"2026-07-30 21:42:00","inspection_id":"88441171","insp_violation_id":"275828881","seq_no":"1","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"214899008","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-20T10:08:23.000000Z","updated_at":"2026-08-08T09:48:37.000000Z","normalized_code":"3939ALCL"}],"inspection_per_units":[{"id":21675226,"change_date":"2026-07-30 21:42:00","inspection_id":"88441171","insp_unit_id":"214899008","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"NONE","insp_unit_license":"49809NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDUF4GNXPED59325","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-20T09:21:14.000000Z","updated_at":"2026-08-08T09:07:58.000000Z"}]},{"id":12382562,"change_date":"2026-07-08 21:41:00","inspection_id":"88345564","dot_number":"30254","report_state":"AL","report_number":"1836004355","insp_date":"2026-07-07 00:00:00","insp_start_time":"1108","insp_end_time":"1148","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"GURLEY AL","county_code_state":"AL","county_code":"089","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"THE SHERWINWILLIAMS COMPANY","shipping_paper_number":"72103157647835","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3704807","transaction_code":"A","transaction_date":"2026-07-07 00:00:00","upload_date":"2026-07-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-07-08 21:41:00","snet_input_date":"2026-07-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-08 21:41:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"1 SHERWIN WAY","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44113","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-11T09:39:35.000000Z","updated_at":"2026-07-19T09:30:48.000000Z","inspection_violations":[{"id":21676649,"change_date":"2026-07-08 21:41:00","inspection_id":"88345564","insp_violation_id":"275354058","seq_no":"1","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"214493893","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-18T09:44:22.000000Z","updated_at":"2026-07-19T09:42:36.000000Z","normalized_code":"39395A4EEUS"}],"inspection_per_units":[{"id":21626195,"change_date":"2026-07-08 21:41:00","inspection_id":"88345564","insp_unit_id":"214493893","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"VIN 9300","insp_unit_license":"47C20UM","insp_unit_license_state":"AL","insp_unit_vehicle_id_number":"1FDUF4GN5PED59300","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-18T09:04:13.000000Z","updated_at":"2026-07-19T09:02:07.000000Z"}]},{"id":12382214,"change_date":"2026-07-08 21:41:00","inspection_id":"88345197","dot_number":"30254","report_state":"MD","report_number":"2512C00407","insp_date":"2026-07-06 00:00:00","insp_start_time":"1110","insp_end_time":"1128","registration_date":null,"region":"ED","ci_status_code":"C","location":"073510","location_desc":"BALTIMORE MD","county_code_state":"MD","county_code":"510","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SAME AS CARRIER","shipping_paper_number":"70335457622861","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3704392","transaction_code":"A","transaction_date":"2026-07-07 00:00:00","upload_date":"2026-07-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-07-08 21:41:00","snet_input_date":"2026-07-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-08 21:41:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"1 SHERWIN WAY","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44113","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-11T09:39:33.000000Z","updated_at":"2026-07-19T09:30:48.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21626194,"change_date":"2026-07-08 21:41:00","inspection_id":"88345197","insp_unit_id":"214493284","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"COURIER","insp_unit_company":null,"insp_unit_license":"7EW3236","insp_unit_license_state":"MD","insp_unit_vehicle_id_number":"1FDNF6AN5MDF03910","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-18T09:04:08.000000Z","updated_at":"2026-07-19T09:02:03.000000Z"}]},{"id":12324119,"change_date":"2026-06-30 21:40:00","inspection_id":"88282216","dot_number":"30254","report_state":"LA","report_number":"LANIS00778","insp_date":"2026-06-30 00:00:00","insp_start_time":"0850","insp_end_time":"0907","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"GRAY LA","county_code_state":"LA","county_code":null,"insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SHERMAN WILLIAMS COMPANY","shipping_paper_number":"72517457567497","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3654097","transaction_code":"A","transaction_date":"2026-06-30 00:00:00","upload_date":"2026-06-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-06-30 21:40:00","snet_input_date":"2026-06-30 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-30 21:40:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"1 SHERWIN WAY","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44113","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-03T09:41:25.000000Z","updated_at":"2026-07-11T09:30:51.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":12294784,"change_date":"2026-06-27 21:41:00","inspection_id":"88251543","dot_number":"30254","report_state":"CA","report_number":"UDXH001791","insp_date":"2026-06-25 00:00:00","insp_start_time":"1135","insp_end_time":"1200","registration_date":null,"region":"PD","ci_status_code":"C","location":"347","location_desc":"CA","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3623513","transaction_code":"A","transaction_date":"2026-06-27 00:00:00","upload_date":"2026-06-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-06-27 21:41:00","snet_input_date":"2026-06-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-27 21:41:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"1 SHERWIN WAY","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44113","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"524","created_at":"2026-06-30T09:40:00.000000Z","updated_at":"2026-07-08T09:30:12.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":12277813,"change_date":"2026-06-25 21:51:00","inspection_id":"88237467","dot_number":"30254","report_state":"NY","report_number":"SPA3100555","insp_date":"2026-06-19 00:00:00","insp_start_time":"0729","insp_end_time":"0751","registration_date":null,"region":"ED","ci_status_code":"C","location":"50263M","location_desc":"BEMUS POINT NY","county_code_state":"NY","county_code":"013","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-25 21:51:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3619471","transaction_code":"A","transaction_date":"2026-06-25 00:00:00","upload_date":"2026-06-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-06-25 21:51:00","snet_input_date":"2026-06-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-25 21:51:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"1 SHERWIN WAY","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44113","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-28T09:39:43.000000Z","updated_at":"2026-07-06T09:32:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21528757,"change_date":null,"inspection_id":"88237467","insp_unit_id":"sms-backfill-794137203-1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"58334NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDUF4GN1PEC82179","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-07-13T03:28:54.000000Z","updated_at":"2026-07-13T03:28:54.000000Z"}]},{"id":12134859,"change_date":"2026-06-09 21:41:00","inspection_id":"88081179","dot_number":"30254","report_state":"MA","report_number":"DT00000944","insp_date":"2026-06-09 00:00:00","insp_start_time":"0803","insp_end_time":"0829","registration_date":null,"region":"ES","ci_status_code":"C","location":"086H","location_desc":"MA","county_code_state":"MA","county_code":"011","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"OE0064597A70541","cargo_tank":"OTH","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-09 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3498636","transaction_code":"A","transaction_date":"2026-06-09 00:00:00","upload_date":"2026-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-06-09 21:41:00","snet_input_date":"2026-06-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-09 21:41:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"1 SHERWIN WAY","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44113","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-12T09:39:59.000000Z","updated_at":"2026-06-20T09:32:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21527850,"change_date":null,"inspection_id":"88081179","insp_unit_id":"sms-backfill-792730611-1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"W97734","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FDNF6AN2PDF06316","insp_unit_decal":null,"insp_unit_decal_number":"36445875","created_at":"2026-07-13T03:28:54.000000Z","updated_at":"2026-07-13T03:28:54.000000Z"}]},{"id":12157585,"change_date":"2026-06-11 21:41:00","inspection_id":"88107096","dot_number":"30254","report_state":"WI","report_number":"9943000018","insp_date":"2026-06-08 00:00:00","insp_start_time":"1035","insp_end_time":"1115","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"MILWAUKEE WI","county_code_state":"WI","county_code":"079","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3517046","transaction_code":"A","transaction_date":"2026-06-10 00:00:00","upload_date":"2026-06-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-06-11 21:41:00","snet_input_date":"2026-06-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-11 21:41:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"1 SHERWIN WAY","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44113","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-15T09:41:27.000000Z","updated_at":"2026-06-22T09:30:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21527716,"change_date":null,"inspection_id":"88107096","insp_unit_id":"sms-backfill-792963864-1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"EC70442","insp_unit_license_state":"WI","insp_unit_vehicle_id_number":"1FDUF4GN2NEC78199","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-07-13T03:28:54.000000Z","updated_at":"2026-07-13T03:28:54.000000Z"}]},{"id":12144489,"change_date":"2026-06-10 21:44:00","inspection_id":"88093048","dot_number":"30254","report_state":"OH","report_number":"3255001517","insp_date":"2026-06-08 00:00:00","insp_start_time":"1225","insp_end_time":"1310","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"ELYRIA OH","county_code_state":"OH","county_code":"093","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"70431457286681","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-10 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"1","hazmat_oos_total":"0","snet_sequence_id":"3504875","transaction_code":"A","transaction_date":"2026-06-09 00:00:00","upload_date":"2026-06-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-06-10 21:44:00","snet_input_date":"2026-06-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-10 21:44:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"1 SHERWIN WAY","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44113","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-13T09:41:20.000000Z","updated_at":"2026-06-21T09:30:28.000000Z","inspection_violations":[{"id":21563873,"change_date":null,"inspection_id":"88093048","insp_violation_id":null,"seq_no":null,"part_no":"172","part_no_section":"200A-HMSPS","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-07-13T03:31:35.000000Z","updated_at":"2026-07-13T03:31:35.000000Z","normalized_code":"172200AHMSPS"},{"id":21563874,"change_date":null,"inspection_id":"88093048","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"16-D","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-07-13T03:31:35.000000Z","updated_at":"2026-07-13T03:31:35.000000Z","normalized_code":"39216D"}],"inspection_per_units":[{"id":21527703,"change_date":null,"inspection_id":"88093048","insp_unit_id":"sms-backfill-792837432-1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"POC7781","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1FDUF4GN8PED59274","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-07-13T03:28:54.000000Z","updated_at":"2026-07-13T03:28:54.000000Z"}]},{"id":12158172,"change_date":"2026-06-11 21:41:00","inspection_id":"88107715","dot_number":"30254","report_state":"MN","report_number":"0025000857","insp_date":"2026-06-04 00:00:00","insp_start_time":"1020","insp_end_time":"1034","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"EDEN PRAIRIE MN","county_code_state":"MN","county_code":"053","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"56611","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3517077","transaction_code":"A","transaction_date":"2026-06-10 00:00:00","upload_date":"2026-06-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-06-11 21:41:00","snet_input_date":"2026-06-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-11 21:41:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"1 SHERWIN WAY","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44113","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-15T09:41:29.000000Z","updated_at":"2026-06-22T09:30:28.000000Z","inspection_violations":[{"id":21563253,"change_date":null,"inspection_id":"88107715","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-07-13T03:31:35.000000Z","updated_at":"2026-07-13T03:31:35.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":21523536,"change_date":null,"inspection_id":"88107715","insp_unit_id":"sms-backfill-792969435-1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"YCH2590","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1FDUF4GN5REE46391","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-07-13T03:28:54.000000Z","updated_at":"2026-07-13T03:28:54.000000Z"}]},{"id":12076387,"change_date":"2026-06-02 21:41:00","inspection_id":"88018886","dot_number":"30254","report_state":"IN","report_number":"7250002038","insp_date":"2026-05-28 00:00:00","insp_start_time":"1041","insp_end_time":"1120","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"BROOKVILLE IN","county_code_state":"IN","county_code":"029","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SHERWINWILLIAMS","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"2","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3449685","transaction_code":"A","transaction_date":"2026-06-02 00:00:00","upload_date":"2026-06-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-06-02 21:41:00","snet_input_date":"2026-05-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-02 21:41:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"1 SHERWIN WAY","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44113","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-06T09:40:25.000000Z","updated_at":"2026-06-13T09:31:20.000000Z","inspection_violations":[{"id":21562991,"change_date":null,"inspection_id":"88018886","insp_violation_id":null,"seq_no":null,"part_no":"391","part_no_section":"41APC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-07-13T03:31:35.000000Z","updated_at":"2026-07-13T03:31:35.000000Z","normalized_code":"39141APC"},{"id":21562992,"change_date":null,"inspection_id":"88018886","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"2-SLLTCD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-07-13T03:31:35.000000Z","updated_at":"2026-07-13T03:31:35.000000Z","normalized_code":"3922SLLTCD"}],"inspection_per_units":[{"id":21523386,"change_date":null,"inspection_id":"88018886","insp_unit_id":"sms-backfill-792169974-1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"PLV5108","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1FDUF4GN6PED59290","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-07-13T03:28:54.000000Z","updated_at":"2026-07-13T03:28:54.000000Z"}]},{"id":12028303,"change_date":"2026-05-28 21:41:00","inspection_id":"87968305","dot_number":"30254","report_state":"OR","report_number":"BG41320072","insp_date":"2026-05-27 00:00:00","insp_start_time":"1028","insp_end_time":"1036","registration_date":null,"region":"PD","ci_status_code":"C","location":null,"location_desc":"MOLALLA OR","county_code_state":"OR","county_code":"005","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SHERMAN WILLIAMS","shipping_paper_number":"OE0168472A70863","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"16001","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3412792","transaction_code":"C","transaction_date":"2026-05-27 00:00:00","upload_date":"2026-05-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-05-27 21:40:00","snet_input_date":"2026-05-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-27 21:40:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"1 SHERWIN WAY","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44113","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-30T09:39:32.000000Z","updated_at":"2026-06-08T09:30:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21521972,"change_date":null,"inspection_id":"87968305","insp_unit_id":"sms-backfill-791714745-1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"T641109","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1FDUF4GN3LEE34750","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-07-13T03:28:54.000000Z","updated_at":"2026-07-13T03:28:54.000000Z"}]},{"id":12048028,"change_date":"2026-05-29 21:39:00","inspection_id":"87988963","dot_number":"30254","report_state":"FL","report_number":"3043001303","insp_date":"2026-05-27 00:00:00","insp_start_time":"1430","insp_end_time":"1504","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"TALLAHASSEE FL","county_code_state":"FL","county_code":"073","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SAMC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-29 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3422849","transaction_code":"A","transaction_date":"2026-05-28 00:00:00","upload_date":"2026-05-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-05-29 21:39:00","snet_input_date":"2026-05-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-29 21:39:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"1 SHERWIN WAY","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44113","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-02T09:39:51.000000Z","updated_at":"2026-06-09T09:30:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21526697,"change_date":null,"inspection_id":"87988963","insp_unit_id":"sms-backfill-791900667-1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"RYXT14","insp_unit_license_state":"FL","insp_unit_vehicle_id_number":"1FDUF5GN5REF82817","insp_unit_decal":null,"insp_unit_decal_number":"36322314","created_at":"2026-07-13T03:28:54.000000Z","updated_at":"2026-07-13T03:28:54.000000Z"}]},{"id":12049239,"change_date":"2026-05-29 21:39:00","inspection_id":"87990245","dot_number":"30254","report_state":"FL","report_number":"2177007504","insp_date":"2026-05-27 00:00:00","insp_start_time":"1150","insp_end_time":"1218","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"GREEN COVE SPRINGS FL","county_code_state":"FL","county_code":"019","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"MULTIPLE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-29 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3423971","transaction_code":"A","transaction_date":"2026-05-28 00:00:00","upload_date":"2026-05-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-05-29 21:39:00","snet_input_date":"2026-05-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-29 21:39:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"1 SHERWIN WAY","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44113","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-02T09:39:53.000000Z","updated_at":"2026-06-09T09:30:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21523056,"change_date":null,"inspection_id":"87990245","insp_unit_id":"sms-backfill-791912205-1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"RYYA28","insp_unit_license_state":"FL","insp_unit_vehicle_id_number":"1FDNF6AN8SDF04353","insp_unit_decal":null,"insp_unit_decal_number":"36318180","created_at":"2026-07-13T03:28:54.000000Z","updated_at":"2026-07-13T03:28:54.000000Z"}]},{"id":12049284,"change_date":"2026-05-29 21:39:00","inspection_id":"87990295","dot_number":"30254","report_state":"FL","report_number":"3043001302","insp_date":"2026-05-27 00:00:00","insp_start_time":"1110","insp_end_time":"1258","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"TALLAHASSEE FL","county_code_state":"FL","county_code":"073","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SAMC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-29 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3424119","transaction_code":"A","transaction_date":"2026-05-28 00:00:00","upload_date":"2026-05-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-05-29 21:39:00","snet_input_date":"2026-05-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-29 21:39:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"1 SHERWIN WAY","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44113","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-02T09:39:53.000000Z","updated_at":"2026-06-09T09:30:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21526867,"change_date":null,"inspection_id":"87990295","insp_unit_id":"sms-backfill-791912655-1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"RRUH69","insp_unit_license_state":"FL","insp_unit_vehicle_id_number":"1FDNF6AN5SDF01281","insp_unit_decal":null,"insp_unit_decal_number":"36322313","created_at":"2026-07-13T03:28:54.000000Z","updated_at":"2026-07-13T03:28:54.000000Z"}]},{"id":12087793,"change_date":"2026-06-03 21:36:00","inspection_id":"88031490","dot_number":"30254","report_state":"TX","report_number":"7FUC9DLC5Q","insp_date":"2026-05-26 00:00:00","insp_start_time":"1245","insp_end_time":"1256","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"WILMETH RD","county_code_state":"TX","county_code":"085","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"THE SHERWIN WILLIAMS CO","shipping_paper_number":"72814457141186","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-06-03 21:36:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9978550","transaction_code":"A","transaction_date":"2026-06-03 00:00:00","upload_date":"2026-06-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":"M","census_search_date":"2026-06-03 21:36:00","snet_input_date":"2026-05-26 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-06-03 21:36:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"1 SHERWIN WAY","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44113","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0028305","created_at":"2026-06-06T09:40:46.000000Z","updated_at":"2026-06-15T09:30:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21527301,"change_date":null,"inspection_id":"88031490","insp_unit_id":"sms-backfill-792283410-1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"PRC7110","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FDUF4GN3LEE34814","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-07-13T03:28:54.000000Z","updated_at":"2026-07-13T03:28:54.000000Z"}]},{"id":11998508,"change_date":"2026-05-22 21:38:00","inspection_id":"87936851","dot_number":"30254","report_state":"NM","report_number":"7068Q3XBGQ","insp_date":"2026-05-21 00:00:00","insp_start_time":"0935","insp_end_time":"0955","registration_date":null,"region":"MT","ci_status_code":"C","location":null,"location_desc":"OROGRANDE PORT OF ENTRY","county_code_state":"NM","county_code":"035","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SHERWIN-WILLIAMS","shipping_paper_number":"70717357103662","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-05-22 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"12000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2305704","transaction_code":"A","transaction_date":"2026-05-21 00:00:00","upload_date":"2026-05-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-05-22 21:38:00","snet_input_date":"2026-05-22 00:00:00","source_office":"2NMS001","mcmis_add_date":"2026-05-22 21:38:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"1 SHERWIN WAY","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44113","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-25T09:41:19.000000Z","updated_at":"2026-06-02T09:32:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21525360,"change_date":null,"inspection_id":"87936851","insp_unit_id":"sms-backfill-791431659-1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"RST2873","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FDUF4GN1LED62463","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-07-13T03:28:54.000000Z","updated_at":"2026-07-13T03:28:54.000000Z"}]},{"id":11959897,"change_date":"2026-05-19 21:40:00","inspection_id":"87895978","dot_number":"30254","report_state":"NJ","report_number":"SPOUI00635","insp_date":"2026-05-19 00:00:00","insp_start_time":"0608","insp_end_time":"0625","registration_date":null,"region":"ES","ci_status_code":"C","location":"0316","location_desc":"NJ","county_code_state":"NJ","county_code":"005","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"U","drug_intrdctn_search":"U","drug_intrdctn_arrests":"0","size_weight_enf":"U","traffic_enf":"U","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3359240","transaction_code":"A","transaction_date":"2026-05-19 00:00:00","upload_date":"2026-05-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-05-19 21:40:00","snet_input_date":"2026-05-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-19 21:40:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"1 SHERWIN WAY","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44113","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-22T09:41:08.000000Z","updated_at":"2026-05-30T09:30:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21525397,"change_date":null,"inspection_id":"87895978","insp_unit_id":"sms-backfill-791063802-1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"XFZS56","insp_unit_license_state":"NJ","insp_unit_vehicle_id_number":"1FDNF6AY8KDF07070","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-07-13T03:28:54.000000Z","updated_at":"2026-07-13T03:28:54.000000Z"}]},{"id":11896713,"change_date":"2026-05-13 21:42:00","inspection_id":"87835228","dot_number":"30254","report_state":"AL","report_number":"1183000755","insp_date":"2026-05-13 00:00:00","insp_start_time":"1110","insp_end_time":"1140","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"GRAND BAY AL","county_code_state":"AL","county_code":"097","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"OE0073822A70235","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3315229","transaction_code":"A","transaction_date":"2026-05-13 00:00:00","upload_date":"2026-05-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-05-13 21:42:00","snet_input_date":"2026-05-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-13 21:42:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"1 SHERWIN WAY","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44113","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-15T12:26:54.000000Z","updated_at":"2026-05-24T09:31:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21340157,"change_date":null,"inspection_id":"87835228","insp_unit_id":"sms-backfill-790517052-1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"2C06682","insp_unit_license_state":"AL","insp_unit_vehicle_id_number":"1FDPF7AN5TDF05220","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-06-29T03:28:42.000000Z","updated_at":"2026-06-29T03:28:42.000000Z"}]},{"id":11908131,"change_date":"2026-05-14 21:42:00","inspection_id":"87847271","dot_number":"30254","report_state":"US","report_number":"1811000110","insp_date":"2026-05-12 00:00:00","insp_start_time":"1055","insp_end_time":"1145","registration_date":null,"region":"MD","ci_status_code":"C","location":"TILFRD","location_desc":"TILFORD SD","county_code_state":"SD","county_code":"093","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SHERWIN WILLIAMS COMPANY","shipping_paper_number":"70321456991421","cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3322931","transaction_code":"A","transaction_date":"2026-05-14 00:00:00","upload_date":"2026-05-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-05-14 21:42:00","snet_input_date":"2026-05-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-14 21:42:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"1 SHERWIN WAY","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44113","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-16T13:32:53.000000Z","updated_at":"2026-05-25T09:31:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21340702,"change_date":null,"inspection_id":"87847271","insp_unit_id":"sms-backfill-790625439-1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"81818C","insp_unit_license_state":"SD","insp_unit_vehicle_id_number":"1FDUF4GN0REE46394","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-06-29T03:28:42.000000Z","updated_at":"2026-06-29T03:28:42.000000Z"}]},{"id":11895161,"change_date":"2026-05-13 21:42:00","inspection_id":"87833558","dot_number":"30254","report_state":"US","report_number":"1634000267","insp_date":"2026-05-12 00:00:00","insp_start_time":"0833","insp_end_time":"0846","registration_date":null,"region":"ED","ci_status_code":"C","location":"108N","location_desc":"YULEE FL","county_code_state":"FL","county_code":"089","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"THE SHERWIN WILLIAMS COMPANY","shipping_paper_number":"70439956981381","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3312815","transaction_code":"A","transaction_date":"2026-05-13 00:00:00","upload_date":"2026-05-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-05-13 21:42:00","snet_input_date":"2026-05-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-13 21:42:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"1 SHERWIN WAY","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44113","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-15T12:26:52.000000Z","updated_at":"2026-05-24T09:31:03.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21338628,"change_date":null,"inspection_id":"87833558","insp_unit_id":"sms-backfill-790502022-1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"RYYA24","insp_unit_license_state":"FL","insp_unit_vehicle_id_number":"1FDNF6AN6SDF04352","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-06-29T03:28:42.000000Z","updated_at":"2026-06-29T03:28:42.000000Z"}]},{"id":11913058,"change_date":"2026-05-14 21:43:00","inspection_id":"87852440","dot_number":"30254","report_state":"TX","report_number":"V262328935","insp_date":"2026-05-12 00:00:00","insp_start_time":"0707","insp_end_time":"0740","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"VICTORY CIR AT GORDO","county_code_state":"TX","county_code":"121","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"PICK UP","shipping_paper_number":"72103356977119","cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-05-14 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9954896","transaction_code":"A","transaction_date":"2026-05-14 00:00:00","upload_date":"2026-05-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":"M","census_search_date":"2026-05-14 21:43:00","snet_input_date":"2026-05-12 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-05-14 21:43:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"1 SHERWIN WAY","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44113","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0028305","created_at":"2026-05-16T13:33:00.000000Z","updated_at":"2026-05-25T09:31:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21338766,"change_date":null,"inspection_id":"87852440","insp_unit_id":"sms-backfill-790671960-1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"VSB6019","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FDNF6AN9SDF04359","insp_unit_decal":null,"insp_unit_decal_number":"36260784","created_at":"2026-06-29T03:28:42.000000Z","updated_at":"2026-06-29T03:28:42.000000Z"}]},{"id":11927369,"change_date":"2026-05-15 21:44:00","inspection_id":"87861851","dot_number":"30254","report_state":"CA","report_number":"NF50002445","insp_date":"2026-05-11 00:00:00","insp_start_time":"0906","insp_end_time":"0926","registration_date":null,"region":"PS","ci_status_code":"C","location":"366","location_desc":"CA","county_code_state":"CA","county_code":"095","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"U","drug_intrdctn_search":"U","drug_intrdctn_arrests":"0","size_weight_enf":"U","traffic_enf":"U","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-15 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3334285","transaction_code":"A","transaction_date":"2026-05-15 00:00:00","upload_date":"2026-05-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-05-15 21:44:00","snet_input_date":"2026-05-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-15 21:44:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"1 SHERWIN WAY","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44113","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"524","created_at":"2026-05-18T09:40:32.000000Z","updated_at":"2026-05-26T09:31:22.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21526713,"change_date":null,"inspection_id":"87861851","insp_unit_id":"sms-backfill-790756659-1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"76401L3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDUF4GN2NEC78395","insp_unit_decal":null,"insp_unit_decal_number":"36183880","created_at":"2026-07-13T03:28:54.000000Z","updated_at":"2026-07-13T03:28:54.000000Z"}]},{"id":11869731,"change_date":"2026-05-11 21:38:00","inspection_id":"87806722","dot_number":"30254","report_state":"GA","report_number":"1267000106","insp_date":"2026-05-08 00:00:00","insp_start_time":"1110","insp_end_time":"1130","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"GRIFFIN GA","county_code_state":"GA","county_code":"255","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MARTIN & CO","shipping_paper_number":"70221056952047","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-11 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3295847","transaction_code":"A","transaction_date":"2026-05-10 00:00:00","upload_date":"2026-05-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-05-11 21:38:00","snet_input_date":"2026-05-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-11 21:38:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"1 SHERWIN WAY","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44113","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-13T13:15:17.000000Z","updated_at":"2026-05-22T09:30:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21340513,"change_date":null,"inspection_id":"87806722","insp_unit_id":"sms-backfill-790260498-1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"ZMP922","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"1FDUF4GN6REE46402","insp_unit_decal":null,"insp_unit_decal_number":"36332843","created_at":"2026-06-29T03:28:42.000000Z","updated_at":"2026-06-29T03:28:42.000000Z"}]},{"id":11849738,"change_date":"2026-05-07 21:40:00","inspection_id":"87785755","dot_number":"30254","report_state":"NV","report_number":"7165029856","insp_date":"2026-05-07 00:00:00","insp_start_time":"1120","insp_end_time":"1150","registration_date":null,"region":"PS","ci_status_code":"C","location":"2","location_desc":"NV","county_code_state":"NV","county_code":"031","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"U","drug_intrdctn_search":"U","drug_intrdctn_arrests":"0","size_weight_enf":"U","traffic_enf":"U","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3280176","transaction_code":"A","transaction_date":"2026-05-07 00:00:00","upload_date":"2026-05-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-05-07 21:40:00","snet_input_date":"2026-05-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-07 21:40:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"1 SHERWIN WAY","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44113","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-10T09:39:34.000000Z","updated_at":"2026-05-18T09:31:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21340339,"change_date":null,"inspection_id":"87785755","insp_unit_id":"sms-backfill-790071795-1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"3116702","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4NC9EH8NN289269","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-06-29T03:28:42.000000Z","updated_at":"2026-06-29T03:28:42.000000Z"},{"id":21342640,"change_date":null,"inspection_id":"87785755","insp_unit_id":"sms-backfill-790071795-2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":null,"insp_unit_license":"791020ST","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"3H3V482CXMT395011","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-06-29T03:28:42.000000Z","updated_at":"2026-06-29T03:28:42.000000Z"}]},{"id":11867789,"change_date":"2026-05-10 21:34:00","inspection_id":"87804670","dot_number":"30254","report_state":"CA","report_number":"UF4O000610","insp_date":"2026-05-07 00:00:00","insp_start_time":"0813","insp_end_time":"0841","registration_date":null,"region":"PS","ci_status_code":"C","location":"347","location_desc":"CA","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"U","drug_intrdctn_search":"U","drug_intrdctn_arrests":"0","size_weight_enf":"U","traffic_enf":"U","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-10 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3294652","transaction_code":"A","transaction_date":"2026-05-10 00:00:00","upload_date":"2026-05-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-05-10 21:34:00","snet_input_date":"2026-05-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-10 21:34:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"1 SHERWIN WAY","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44113","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-13T09:38:38.000000Z","updated_at":"2026-05-21T09:30:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21336663,"change_date":null,"inspection_id":"87804670","insp_unit_id":"sms-backfill-790242030-1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"55930H4","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDUF4GN9REE46412","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-06-29T03:28:42.000000Z","updated_at":"2026-06-29T03:28:42.000000Z"}]},{"id":11834435,"change_date":"2026-05-06 21:40:00","inspection_id":"87769681","dot_number":"30254","report_state":"WV","report_number":"PSC0991174","insp_date":"2026-05-04 00:00:00","insp_start_time":"0836","insp_end_time":"0852","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"GHENT WV","county_code_state":"WV","county_code":"081","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME AS CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3268826","transaction_code":"A","transaction_date":"2026-05-06 00:00:00","upload_date":"2026-05-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-05-06 21:40:00","snet_input_date":"2026-05-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-06 21:40:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"1 SHERWIN WAY","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44113","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-09T09:40:10.000000Z","updated_at":"2026-05-16T13:23:46.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21340054,"change_date":null,"inspection_id":"87769681","insp_unit_id":"sms-backfill-789927129-1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"COURIER","insp_unit_company":null,"insp_unit_license":"B308570","insp_unit_license_state":"WV","insp_unit_vehicle_id_number":"1FDUF4GN7NEE43888","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-06-29T03:28:42.000000Z","updated_at":"2026-06-29T03:28:42.000000Z"}]},{"id":11829170,"change_date":"2026-05-05 21:39:00","inspection_id":"87764111","dot_number":"30254","report_state":"IL","report_number":"5005010527","insp_date":"2026-05-04 00:00:00","insp_start_time":"1020","insp_end_time":"1031","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"I72","county_code_state":"IL","county_code":"167","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SHERWIN WILLIAMS","shipping_paper_number":"UNK","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-05-05 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2470298","transaction_code":"A","transaction_date":"2026-05-04 00:00:00","upload_date":"2026-05-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-05-05 21:39:00","snet_input_date":"2026-05-04 00:00:00","source_office":"3ILS001","mcmis_add_date":"2026-05-05 21:39:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"1 SHERWIN WAY","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44113","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-08T09:40:32.000000Z","updated_at":"2026-05-15T12:18:52.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21340111,"change_date":null,"inspection_id":"87764111","insp_unit_id":"sms-backfill-789876999-1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"197623H","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"1FDUF4GNXNEE43867","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-06-29T03:28:42.000000Z","updated_at":"2026-06-29T03:28:42.000000Z"}]},{"id":11833567,"change_date":"2026-05-06 21:40:00","inspection_id":"87768770","dot_number":"30254","report_state":"CO","report_number":"0669873195","insp_date":"2026-05-04 00:00:00","insp_start_time":"0945","insp_end_time":"1025","registration_date":null,"region":"MD","ci_status_code":"C","location":null,"location_desc":"COLORADO SPRINGS CO","county_code_state":"CO","county_code":"041","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3266801","transaction_code":"A","transaction_date":"2026-05-05 00:00:00","upload_date":"2026-05-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-05-06 21:40:00","snet_input_date":"2026-05-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-06 21:40:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"1 SHERWIN WAY","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44113","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-09T09:40:08.000000Z","updated_at":"2026-05-16T13:23:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21340236,"change_date":null,"inspection_id":"87768770","insp_unit_id":"sms-backfill-789918930-1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"CUHV50","insp_unit_license_state":"CO","insp_unit_vehicle_id_number":"1FDUF4GN9PED59350","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-06-29T03:28:42.000000Z","updated_at":"2026-06-29T03:28:42.000000Z"}]},{"id":11813470,"change_date":"2026-05-03 21:33:00","inspection_id":"87747219","dot_number":"30254","report_state":"PR","report_number":"8110000568","insp_date":"2026-04-27 00:00:00","insp_start_time":"1145","insp_end_time":"1150","registration_date":null,"region":"-0","ci_status_code":"C","location":null,"location_desc":"SANTA ISABEL PR","county_code_state":"PR","county_code":null,"insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-03 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3252144","transaction_code":"A","transaction_date":"2026-05-03 00:00:00","upload_date":"2026-05-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-05-03 21:33:00","snet_input_date":"2026-04-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-03 21:33:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"1 SHERWIN WAY","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44113","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-06T09:39:41.000000Z","updated_at":"2026-05-13T13:07:24.000000Z","inspection_violations":[{"id":21386822,"change_date":null,"inspection_id":"87747219","insp_violation_id":null,"seq_no":null,"part_no":"391","part_no_section":"41A-MCPC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-06-29T03:31:08.000000Z","updated_at":"2026-06-29T03:31:08.000000Z","normalized_code":"39141AMCPC"}],"inspection_per_units":[{"id":21339824,"change_date":null,"inspection_id":"87747219","insp_unit_id":"sms-backfill-789724971-1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"H71115","insp_unit_license_state":"PR","insp_unit_vehicle_id_number":"1FDUF4GY2GEB57671","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-06-29T03:28:42.000000Z","updated_at":"2026-06-29T03:28:42.000000Z"}]},{"id":11727303,"change_date":"2026-04-23 21:38:00","inspection_id":"87655130","dot_number":"30254","report_state":"FL","report_number":"2566001686","insp_date":"2026-04-21 00:00:00","insp_start_time":"0940","insp_end_time":"1010","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"WESTON FL","county_code_state":"FL","county_code":"011","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"ROUTE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-04-23 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3199223","transaction_code":"A","transaction_date":"2026-04-22 00:00:00","upload_date":"2026-04-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-04-23 21:38:00","snet_input_date":"2026-04-21 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-23 21:38:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"1 SHERWIN WAY","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44113","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-27T09:40:41.000000Z","updated_at":"2026-05-04T09:30:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20724644,"change_date":null,"inspection_id":"87655130","insp_unit_id":"sms-backfill-788896170-1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"36BKXB","insp_unit_license_state":"FL","insp_unit_vehicle_id_number":"1FDUF4GN1NED63809","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-05-18T03:15:48.000000Z","updated_at":"2026-05-18T03:15:48.000000Z"}]},{"id":11711796,"change_date":"2026-04-21 21:39:00","inspection_id":"87638844","dot_number":"30254","report_state":"TX","report_number":"7ERC9DCKK3","insp_date":"2026-04-17 00:00:00","insp_start_time":"1244","insp_end_time":"1255","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0288 IN HARRIS CO. (472-484","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SHERWIN WILLIAMS","shipping_paper_number":"70741756713969","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-04-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9926072","transaction_code":"A","transaction_date":"2026-04-21 00:00:00","upload_date":"2026-04-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":"M","census_search_date":"2026-04-21 21:39:00","snet_input_date":"2026-04-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-04-21 21:39:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"1 SHERWIN WAY","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44113","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0028305","created_at":"2026-04-27T09:38:12.000000Z","updated_at":"2026-05-02T09:31:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20727287,"change_date":null,"inspection_id":"87638844","insp_unit_id":"sms-backfill-788749596-1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"XDK3817","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FDUF4GN1SDA10035","insp_unit_decal":null,"insp_unit_decal_number":"36286099","created_at":"2026-05-18T03:15:48.000000Z","updated_at":"2026-05-18T03:15:48.000000Z"}]},{"id":11686560,"change_date":"2026-05-05 21:38:00","inspection_id":"87612298","dot_number":"30254","report_state":"FL","report_number":"3245000378","insp_date":"2026-04-16 00:00:00","insp_start_time":"0845","insp_end_time":"0900","registration_date":"2026-04-23 00:00:00","region":"ED","ci_status_code":"C","location":null,"location_desc":"PUNTA GORDA FL","county_code_state":"FL","county_code":"015","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-04-18 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3177985","transaction_code":"C","transaction_date":"2026-04-17 00:00:00","upload_date":"2026-05-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-04-18 21:34:00","snet_input_date":"2026-04-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-18 21:34:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"1 SHERWIN WAY","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44113","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-27T09:34:12.000000Z","updated_at":"2026-05-15T12:17:49.000000Z","inspection_violations":[{"id":20733487,"change_date":null,"inspection_id":"87612298","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-05-18T03:19:25.000000Z","updated_at":"2026-05-18T03:19:25.000000Z","normalized_code":"39375A3TAOL"}],"inspection_per_units":[{"id":20724298,"change_date":null,"inspection_id":"87612298","insp_unit_id":"sms-backfill-788510682-1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"30FXEH","insp_unit_license_state":"FL","insp_unit_vehicle_id_number":"1FDUF4GN5MED23067","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-05-18T03:15:48.000000Z","updated_at":"2026-05-18T03:15:48.000000Z"}]},{"id":11660082,"change_date":"2026-04-16 21:40:00","inspection_id":"87590053","dot_number":"30254","report_state":"MD","report_number":"0240C00400","insp_date":"2026-04-15 00:00:00","insp_start_time":"0754","insp_end_time":"0818","registration_date":null,"region":"ED","ci_status_code":"C","location":"068031","location_desc":"CLARKSBURG MD","county_code_state":"MD","county_code":"031","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-04-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3166490","transaction_code":"A","transaction_date":"2026-04-16 00:00:00","upload_date":"2026-04-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-04-16 21:40:00","snet_input_date":"2026-04-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-16 21:40:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"1 SHERWIN WAY","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44113","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-27T09:30:44.000000Z","updated_at":"2026-04-27T09:30:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20726956,"change_date":null,"inspection_id":"87590053","insp_unit_id":"sms-backfill-788310477-1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"9GJ5258","insp_unit_license_state":"MD","insp_unit_vehicle_id_number":"1FDNF6AN3SDF01313","insp_unit_decal":null,"insp_unit_decal_number":"36325895","created_at":"2026-05-18T03:15:48.000000Z","updated_at":"2026-05-18T03:15:48.000000Z"}]},{"id":11654891,"change_date":"2026-04-29 21:40:00","inspection_id":"87584589","dot_number":"30254","report_state":"MA","report_number":"EA00000648","insp_date":"2026-04-15 00:00:00","insp_start_time":"1420","insp_end_time":"1439","registration_date":"2026-04-29 00:00:00","region":"ET","ci_status_code":"C","location":"H","location_desc":"WILMINGTON","county_code_state":"MA","county_code":"017","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-04-15 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"544334","transaction_code":"C","transaction_date":"2026-04-15 00:00:00","upload_date":"2026-04-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":"M","census_search_date":"2026-04-15 21:39:00","snet_input_date":"2026-04-15 00:00:00","source_office":"1MAS001","mcmis_add_date":"2026-04-15 21:39:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"1 SHERWIN WAY","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44113","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-26T09:30:54.000000Z","updated_at":"2026-05-10T09:30:09.000000Z","inspection_violations":[{"id":20734116,"change_date":null,"inspection_id":"87584589","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"2-SLLLR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-05-18T03:19:25.000000Z","updated_at":"2026-05-18T03:19:25.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":20727517,"change_date":null,"inspection_id":"87584589","insp_unit_id":"sms-backfill-788261301-1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"5553207","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1FDUF5GN3REC34580","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-05-18T03:15:48.000000Z","updated_at":"2026-05-18T03:15:48.000000Z"}]},{"id":11624663,"change_date":"2026-04-12 21:33:00","inspection_id":"87552962","dot_number":"30254","report_state":"GA","report_number":"1403001622","insp_date":"2026-04-09 00:00:00","insp_start_time":"0905","insp_end_time":"0935","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"CUMMING GA","county_code_state":"GA","county_code":"117","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"THE SHERWINWILLIAMS COMPANY","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-04-12 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3147383","transaction_code":"A","transaction_date":"2026-04-11 00:00:00","upload_date":"2026-04-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-04-12 21:33:00","snet_input_date":"2026-04-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-12 21:33:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"1 SHERWIN WAY","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44113","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-23T09:30:14.000000Z","updated_at":"2026-04-23T09:30:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20723553,"change_date":null,"inspection_id":"87552962","insp_unit_id":"sms-backfill-787976658-1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"YSR725","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"1FDNF6AN1RDF06651","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-05-18T03:15:48.000000Z","updated_at":"2026-05-18T03:15:48.000000Z"}]},{"id":11605614,"change_date":"2026-04-09 21:55:00","inspection_id":"87532775","dot_number":"30254","report_state":"NJ","report_number":"SPRTI02337","insp_date":"2026-04-08 00:00:00","insp_start_time":"0717","insp_end_time":"0744","registration_date":null,"region":"ED","ci_status_code":"C","location":"0324","location_desc":"NJ","county_code_state":"NJ","county_code":"005","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"OE0315751Q70507","cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-04-09 21:55:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3135356","transaction_code":"A","transaction_date":"2026-04-09 00:00:00","upload_date":"2026-04-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-04-09 21:55:00","snet_input_date":"2026-04-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-09 21:55:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"1 SHERWIN WAY","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44113","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-12T09:45:26.000000Z","updated_at":"2026-04-20T09:31:02.000000Z","inspection_violations":[{"id":20732675,"change_date":null,"inspection_id":"87532775","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-05-18T03:19:25.000000Z","updated_at":"2026-05-18T03:19:25.000000Z","normalized_code":"39395A4EEUS"}],"inspection_per_units":[{"id":20726521,"change_date":null,"inspection_id":"87532775","insp_unit_id":"sms-backfill-787794975-1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"COURIER","insp_unit_company":null,"insp_unit_license":"XMRA19","insp_unit_license_state":"NJ","insp_unit_vehicle_id_number":"1FDNF6AN4RDF06692","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-05-18T03:15:48.000000Z","updated_at":"2026-05-18T03:15:48.000000Z"}]},{"id":11637610,"change_date":"2026-04-14 21:38:00","inspection_id":"87566479","dot_number":"30254","report_state":"NY","report_number":"SPF3051283","insp_date":"2026-04-07 00:00:00","insp_start_time":"1307","insp_end_time":"1324","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"KINGSTON NY","county_code_state":"NY","county_code":"111","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-04-14 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3152878","transaction_code":"A","transaction_date":"2026-04-13 00:00:00","upload_date":"2026-04-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-04-14 21:38:00","snet_input_date":"2026-04-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-14 21:38:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"1 SHERWIN WAY","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44113","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-25T09:30:05.000000Z","updated_at":"2026-04-25T09:30:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20723592,"change_date":null,"inspection_id":"87566479","insp_unit_id":"sms-backfill-788098311-1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"31889NF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDUF4GNXREC34554","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-05-18T03:15:48.000000Z","updated_at":"2026-05-18T03:15:48.000000Z"}]},{"id":11590651,"change_date":"2026-04-07 21:39:00","inspection_id":"87516524","dot_number":"30254","report_state":"CA","report_number":"UERV006314","insp_date":"2026-04-06 00:00:00","insp_start_time":"1415","insp_end_time":"1444","registration_date":null,"region":"PT","ci_status_code":"C","location":"9530","location_desc":"SOUTH LA","county_code_state":"CA","county_code":"037","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-04-07 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16236914","transaction_code":"A","transaction_date":"2026-04-06 00:00:00","upload_date":"2026-04-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-04-07 21:39:00","snet_input_date":"2026-04-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-04-07 21:39:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"1 SHERWIN WAY","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44113","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-10T09:43:26.000000Z","updated_at":"2026-04-17T09:56:46.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20725772,"change_date":null,"inspection_id":"87516524","insp_unit_id":"sms-backfill-787648716-1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"68169D3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDUF4GN6LEE34760","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-05-18T03:15:48.000000Z","updated_at":"2026-05-18T03:15:48.000000Z"}]},{"id":11572111,"change_date":"2026-04-05 21:33:00","inspection_id":"87496039","dot_number":"30254","report_state":"IL","report_number":"4181780158","insp_date":"2026-04-03 00:00:00","insp_start_time":"0557","insp_end_time":"0618","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"IL-53","county_code_state":"IL","county_code":"031","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SHERWIN WILLIAMS","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-04-05 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"16000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2465034","transaction_code":"A","transaction_date":"2026-04-03 00:00:00","upload_date":"2026-04-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-04-05 21:33:00","snet_input_date":"2026-04-03 00:00:00","source_office":"3ILS001","mcmis_add_date":"2026-04-05 21:33:00","insp_carrier_name":"SHERWIN WILLIAMS OLD QUAKER PAINT P","insp_carrier_street":"1 SHERWIN WAY","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44113","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-08T09:50:28.000000Z","updated_at":"2026-04-16T09:31:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20726026,"change_date":null,"inspection_id":"87496039","insp_unit_id":"sms-backfill-787464351-1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"209425H","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"1FDUF4GNXPEC82147","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-05-18T03:15:48.000000Z","updated_at":"2026-05-18T03:15:48.000000Z"}]},{"id":11565756,"change_date":"2026-04-03 21:38:00","inspection_id":"87489299","dot_number":"30254","report_state":"CA","report_number":"UC2Q003022","insp_date":"2026-04-02 00:00:00","insp_start_time":"0720","insp_end_time":"0747","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"EASTBOUND","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-04-03 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"20000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16233744","transaction_code":"A","transaction_date":"2026-04-02 00:00:00","upload_date":"2026-04-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-04-03 21:38:00","snet_input_date":"2026-04-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-04-03 21:38:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"1 SHERWIN WAY","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44113","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-06T09:50:39.000000Z","updated_at":"2026-04-14T09:31:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20725854,"change_date":null,"inspection_id":"87489299","insp_unit_id":"sms-backfill-787403691-1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"64213E3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDUF4GN5LEE34765","insp_unit_decal":null,"insp_unit_decal_number":"36187920","created_at":"2026-05-18T03:15:48.000000Z","updated_at":"2026-05-18T03:15:48.000000Z"}]},{"id":11550290,"change_date":"2026-04-02 21:38:00","inspection_id":"87473076","dot_number":"30254","report_state":"MD","report_number":"3233C00229","insp_date":"2026-03-31 00:00:00","insp_start_time":"1552","insp_end_time":"1610","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"BALTIMORE MD","county_code_state":"MD","county_code":"510","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-04-02 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3103373","transaction_code":"A","transaction_date":"2026-04-01 00:00:00","upload_date":"2026-04-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-04-02 21:38:00","snet_input_date":"2026-03-31 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-02 21:38:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"1 SHERWIN WAY","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44113","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-05T09:56:33.000000Z","updated_at":"2026-04-13T09:30:22.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20722476,"change_date":null,"inspection_id":"87473076","insp_unit_id":"sms-backfill-787257684-1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"1DY9033","insp_unit_license_state":"MD","insp_unit_vehicle_id_number":"1FDUF4GY4KEE76689","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-05-18T03:15:48.000000Z","updated_at":"2026-05-18T03:15:48.000000Z"}]},{"id":11549302,"change_date":"2026-04-02 21:38:00","inspection_id":"87472037","dot_number":"30254","report_state":"CO","report_number":"0876980107","insp_date":"2026-03-31 00:00:00","insp_start_time":"0945","insp_end_time":"1012","registration_date":null,"region":"MD","ci_status_code":"C","location":"LOPEWB","location_desc":"LOMA CO","county_code_state":"CO","county_code":"077","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"PAINT MOAB LLC","shipping_paper_number":"70719456502617","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-04-02 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3102306","transaction_code":"A","transaction_date":"2026-04-01 00:00:00","upload_date":"2026-04-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-04-02 21:38:00","snet_input_date":"2026-03-31 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-02 21:38:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"1 SHERWIN WAY","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44113","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-05T09:56:32.000000Z","updated_at":"2026-04-13T09:30:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20725704,"change_date":null,"inspection_id":"87472037","insp_unit_id":"sms-backfill-787248333-1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"AHVN36","insp_unit_license_state":"CO","insp_unit_vehicle_id_number":"1FDUF4GN5NEE43890","insp_unit_decal":null,"insp_unit_decal_number":"36054687","created_at":"2026-05-18T03:15:48.000000Z","updated_at":"2026-05-18T03:15:48.000000Z"}]},{"id":11548494,"change_date":"2026-04-01 21:40:00","inspection_id":"87471225","dot_number":"30254","report_state":"CA","report_number":"UEBM000294","insp_date":"2026-03-27 00:00:00","insp_start_time":"1011","insp_end_time":"1035","registration_date":null,"region":"PT","ci_status_code":"C","location":"726","location_desc":"GILROY IF","county_code_state":"CA","county_code":"085","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"NONE","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-04-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16231230","transaction_code":"A","transaction_date":"2026-03-27 00:00:00","upload_date":"2026-04-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-04-01 21:40:00","snet_input_date":"2026-03-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-04-01 21:40:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"101 PROSPECT AVE 1000 MIDLAND BLDG","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44115","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-04T09:43:39.000000Z","updated_at":"2026-04-12T09:33:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20722758,"change_date":null,"inspection_id":"87471225","insp_unit_id":"sms-backfill-787241025-1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"06646H4","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDUF4GN5NEC78245","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-05-18T03:15:48.000000Z","updated_at":"2026-05-18T03:15:48.000000Z"}]},{"id":11494220,"change_date":"2026-04-02 21:38:00","inspection_id":"87413916","dot_number":"30254","report_state":"NY","report_number":"M607800338","insp_date":"2026-03-25 00:00:00","insp_start_time":"1207","insp_end_time":"1236","registration_date":"2026-04-01 00:00:00","region":"ED","ci_status_code":"C","location":"10753M","location_desc":"SCHODACK LANDING NY","county_code_state":"NY","county_code":"083","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-03-27 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"1","hazmat_oos_total":"0","snet_sequence_id":"3076920","transaction_code":"C","transaction_date":"2026-03-27 00:00:00","upload_date":"2026-04-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-03-27 21:39:00","snet_input_date":"2026-03-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-27 21:39:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"101 PROSPECT AVE 1000 MIDLAND BLDG","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44115","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-30T09:51:31.000000Z","updated_at":"2026-04-13T09:30:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20722061,"change_date":null,"inspection_id":"87413916","insp_unit_id":"sms-backfill-786725244-1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"78152NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDUF4GN2PED59352","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-05-18T03:15:48.000000Z","updated_at":"2026-05-18T03:15:48.000000Z"}]},{"id":11474136,"change_date":"2026-03-25 21:39:00","inspection_id":"87392978","dot_number":"30254","report_state":"AK","report_number":"RMN1001019","insp_date":"2026-03-24 00:00:00","insp_start_time":"0900","insp_end_time":"0915","registration_date":null,"region":"AK","ci_status_code":"C","location":"UEBA2","location_desc":"ANCHORAGE AK","county_code_state":"AK","county_code":"020","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-03-25 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3065634","transaction_code":"A","transaction_date":"2026-03-25 00:00:00","upload_date":"2026-03-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-03-25 21:39:00","snet_input_date":"2026-03-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-25 21:39:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"101 PROSPECT AVE 1000 MIDLAND BLDG","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44115","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-28T09:44:39.000000Z","updated_at":"2026-04-05T09:31:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20330639,"change_date":null,"inspection_id":"87392978","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"JVL758","insp_unit_license_state":"AK","insp_unit_vehicle_id_number":"1FDUF4GN4LED62439","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-04-20T03:15:53.000000Z","updated_at":"2026-04-20T03:15:53.000000Z"}]},{"id":11357623,"change_date":"2026-03-12 21:40:00","inspection_id":"87276138","dot_number":"30254","report_state":"TX","report_number":"V262264875","insp_date":"2026-03-10 00:00:00","insp_start_time":"1420","insp_end_time":"1433","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH820 WB","county_code_state":"TX","county_code":"439","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SHERWIN WILLIAMS","shipping_paper_number":"70434456269764","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-03-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9882439","transaction_code":"A","transaction_date":"2026-03-12 00:00:00","upload_date":"2026-03-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":"M","census_search_date":"2026-03-12 21:40:00","snet_input_date":"2026-03-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-03-12 21:40:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"101 PROSPECT AVE 1000 MIDLAND BLDG","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44115","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0028305","created_at":"2026-03-15T09:40:01.000000Z","updated_at":"2026-03-23T09:32:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20329331,"change_date":null,"inspection_id":"87276138","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"VVY3628","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FDNF6AN1SDF01326","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-04-20T03:15:53.000000Z","updated_at":"2026-04-20T03:15:53.000000Z"}]},{"id":11320598,"change_date":"2026-03-08 21:33:00","inspection_id":"87237234","dot_number":"30254","report_state":"FL","report_number":"2980000785","insp_date":"2026-03-06 00:00:00","insp_start_time":"1001","insp_end_time":"1015","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"BARTOW FL","county_code_state":"FL","county_code":"105","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-03-08 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2978330","transaction_code":"A","transaction_date":"2026-03-07 00:00:00","upload_date":"2026-03-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-03-08 21:33:00","snet_input_date":"2026-03-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-08 21:33:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"101 PROSPECT AVE 1000 MIDLAND BLDG","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44115","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-11T09:38:23.000000Z","updated_at":"2026-03-19T09:30:22.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20328917,"change_date":null,"inspection_id":"87237234","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"10DZGJ","insp_unit_license_state":"FL","insp_unit_vehicle_id_number":"1FDUF4GN9PED59283","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-04-20T03:15:53.000000Z","updated_at":"2026-04-20T03:15:53.000000Z"}]},{"id":11295783,"change_date":"2026-03-05 21:39:00","inspection_id":"87211269","dot_number":"30254","report_state":"FL","report_number":"3108006490","insp_date":"2026-03-04 00:00:00","insp_start_time":"0728","insp_end_time":"0803","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"MULBERRY FL","county_code_state":"FL","county_code":"105","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"70234856199507","cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-03-05 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"1","hazmat_oos_total":"0","snet_sequence_id":"2966743","transaction_code":"A","transaction_date":"2026-03-05 00:00:00","upload_date":"2026-03-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-03-05 21:39:00","snet_input_date":"2026-03-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-05 21:39:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"101 PROSPECT AVE 1000 MIDLAND BLDG","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44115","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-08T09:44:04.000000Z","updated_at":"2026-03-16T09:30:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20328120,"change_date":null,"inspection_id":"87211269","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"FEPR15","insp_unit_license_state":"FL","insp_unit_vehicle_id_number":"1FDUF4GN1REF82808","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-04-20T03:15:53.000000Z","updated_at":"2026-04-20T03:15:53.000000Z"}]},{"id":11292186,"change_date":"2026-03-04 21:41:00","inspection_id":"87207472","dot_number":"30254","report_state":"CA","report_number":"UE7D003879","insp_date":"2026-03-04 00:00:00","insp_start_time":"1025","insp_end_time":"1037","registration_date":null,"region":"PT","ci_status_code":"C","location":"201","location_desc":"ANTELOPE E\/B","county_code_state":"CA","county_code":"067","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16194016","transaction_code":"A","transaction_date":"2026-03-04 00:00:00","upload_date":"2026-03-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-03-04 21:41:00","snet_input_date":"2026-03-04 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-04 21:41:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"101 PROSPECT AVE 1000 MIDLAND BLDG","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44115","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-07T10:39:17.000000Z","updated_at":"2026-03-15T09:31:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20331001,"change_date":null,"inspection_id":"87207472","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"75707A4","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDUF4GN8REC34567","insp_unit_decal":null,"insp_unit_decal_number":"35873833","created_at":"2026-04-20T03:15:53.000000Z","updated_at":"2026-04-20T03:15:53.000000Z"}]},{"id":11284988,"change_date":"2026-03-04 21:40:00","inspection_id":"87199906","dot_number":"30254","report_state":"VA","report_number":"9424001110","insp_date":"2026-03-03 00:00:00","insp_start_time":"0924","insp_end_time":"0945","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"SUFFOLK VA","county_code_state":"VA","county_code":"840","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"70526256187055","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-03-04 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2961596","transaction_code":"A","transaction_date":"2026-03-04 00:00:00","upload_date":"2026-03-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-03-04 21:40:00","snet_input_date":"2026-03-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-04 21:40:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"101 PROSPECT AVE 1000 MIDLAND BLDG","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44115","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-07T10:39:03.000000Z","updated_at":"2026-03-15T09:30:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20328450,"change_date":null,"inspection_id":"87199906","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"UA93016","insp_unit_license_state":"VA","insp_unit_vehicle_id_number":"1FDNF6AN3MDF07972","insp_unit_decal":null,"insp_unit_decal_number":"36018464","created_at":"2026-04-20T03:15:53.000000Z","updated_at":"2026-04-20T03:15:53.000000Z"}]},{"id":11293533,"change_date":"2026-03-09 21:37:00","inspection_id":"87208890","dot_number":"30254","report_state":"NY","report_number":"SPL3010842","insp_date":"2026-02-26 00:00:00","insp_start_time":"1312","insp_end_time":"1330","registration_date":"2026-03-06 00:00:00","region":"ES","ci_status_code":"C","location":null,"location_desc":"WOODBURY NY","county_code_state":"NY","county_code":"059","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-03-05 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2963768","transaction_code":"C","transaction_date":"2026-03-04 00:00:00","upload_date":"2026-03-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-03-05 21:39:00","snet_input_date":"2026-02-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-05 21:39:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"101 PROSPECT AVE 1000 MIDLAND BLDG","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44115","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-08T09:44:03.000000Z","updated_at":"2026-03-20T09:30:38.000000Z","inspection_violations":[{"id":20297791,"change_date":null,"inspection_id":"87208890","insp_violation_id":null,"seq_no":null,"part_no":"391","part_no_section":"41APC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-04-20T03:18:53.000000Z","updated_at":"2026-04-20T03:18:53.000000Z","normalized_code":"39141APC"}],"inspection_per_units":[{"id":20331062,"change_date":null,"inspection_id":"87208890","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"49763MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDUF4GYXKEC92454","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-04-20T03:15:53.000000Z","updated_at":"2026-04-20T03:15:53.000000Z"}]},{"id":11247952,"change_date":"2026-02-27 21:41:00","inspection_id":"87160887","dot_number":"30254","report_state":"FL","report_number":"2018004829","insp_date":"2026-02-26 00:00:00","insp_start_time":"0759","insp_end_time":"0820","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"GREEN COVE SPRINGS FL","county_code_state":"FL","county_code":"019","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-02-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2942256","transaction_code":"A","transaction_date":"2026-02-27 00:00:00","upload_date":"2026-02-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-02-27 21:41:00","snet_input_date":"2026-02-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-27 21:41:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"101 PROSPECT AVE 1000 MIDLAND BLDG","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44115","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-02T10:39:33.000000Z","updated_at":"2026-03-10T09:30:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20328199,"change_date":null,"inspection_id":"87160887","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"RYYA24","insp_unit_license_state":"FL","insp_unit_vehicle_id_number":"1FDNF6AN6SDF04352","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-04-20T03:15:53.000000Z","updated_at":"2026-04-20T03:15:53.000000Z"}]},{"id":11226106,"change_date":"2026-02-25 21:48:00","inspection_id":"87138089","dot_number":"30254","report_state":"KY","report_number":"4286010070","insp_date":"2026-02-25 00:00:00","insp_start_time":"1020","insp_end_time":"1053","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ASHLAND","county_code_state":"KY","county_code":"019","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SHERWIN-WILLIAMS","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-02-25 21:48:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2332064","transaction_code":"A","transaction_date":"2026-02-25 00:00:00","upload_date":"2026-02-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":"M","census_search_date":"2026-02-25 21:48:00","snet_input_date":"2026-02-25 00:00:00","source_office":"2KYS001","mcmis_add_date":"2026-02-25 21:48:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"101 PROSPECT AVE 1000 MIDLAND BLDG","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44115","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-28T10:39:08.000000Z","updated_at":"2026-03-08T09:31:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19453227,"change_date":null,"inspection_id":"87138089","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"B308570","insp_unit_license_state":"WV","insp_unit_vehicle_id_number":"1FDUF4GN7NEE43888","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-03-16T03:15:23.000000Z","updated_at":"2026-03-16T03:15:23.000000Z"}]},{"id":11450615,"change_date":"2026-03-23 21:51:00","inspection_id":"87368067","dot_number":"30254","report_state":"NJ","report_number":"SPQEI04911","insp_date":"2026-02-24 00:00:00","insp_start_time":"1205","insp_end_time":"1225","registration_date":null,"region":"ES","ci_status_code":"C","location":"0246","location_desc":"NJ","county_code_state":"NJ","county_code":"003","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-03-23 21:51:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3042460","transaction_code":"A","transaction_date":"2026-03-23 00:00:00","upload_date":"2026-03-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-03-23 21:51:00","snet_input_date":"2026-02-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-23 21:51:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"101 PROSPECT AVE 1000 MIDLAND BLDG","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44115","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-26T09:41:36.000000Z","updated_at":"2026-04-03T09:32:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20327541,"change_date":null,"inspection_id":"87368067","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"COURIER","insp_unit_company":null,"insp_unit_license":"XMRA27","insp_unit_license_state":"NJ","insp_unit_vehicle_id_number":"1FDUF4GN5PED59331","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-04-20T03:15:53.000000Z","updated_at":"2026-04-20T03:15:53.000000Z"}]},{"id":11221004,"change_date":"2026-02-24 21:41:00","inspection_id":"87132722","dot_number":"30254","report_state":"CA","report_number":"UF44007135","insp_date":"2026-02-24 00:00:00","insp_start_time":"1120","insp_end_time":"1126","registration_date":null,"region":"PT","ci_status_code":"C","location":"9390","location_desc":"I-680 NB @ ANDRADE RD","county_code_state":"CA","county_code":"001","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-02-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16182812","transaction_code":"A","transaction_date":"2026-02-24 00:00:00","upload_date":"2026-02-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-02-24 21:41:00","snet_input_date":"2026-02-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-02-24 21:41:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"101 PROSPECT AVE 1000 MIDLAND BLDG","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44115","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"524","created_at":"2026-02-27T10:38:11.000000Z","updated_at":"2026-03-07T10:31:19.000000Z","inspection_violations":[{"id":19148148,"change_date":null,"inspection_id":"87132722","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"2-SLLTCD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-03-16T03:19:05.000000Z","updated_at":"2026-03-16T03:19:05.000000Z","normalized_code":"3922SLLTCD"}],"inspection_per_units":[{"id":19456052,"change_date":null,"inspection_id":"87132722","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"55930H4","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDUF4GN9REE46412","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-03-16T03:15:23.000000Z","updated_at":"2026-03-16T03:15:23.000000Z"}]},{"id":11194598,"change_date":"2026-02-21 21:33:00","inspection_id":"87105042","dot_number":"30254","report_state":"FL","report_number":"2297002836","insp_date":"2026-02-19 00:00:00","insp_start_time":"0840","insp_end_time":"0905","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"KISSIMMEE FL","county_code_state":"FL","county_code":"097","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"00006592","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-02-21 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2915348","transaction_code":"A","transaction_date":"2026-02-20 00:00:00","upload_date":"2026-02-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-02-21 21:33:00","snet_input_date":"2026-02-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-21 21:33:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"101 PROSPECT AVE 1000 MIDLAND BLDG","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44115","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-24T10:37:47.000000Z","updated_at":"2026-03-04T10:30:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19452970,"change_date":null,"inspection_id":"87105042","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BR99MD","insp_unit_license_state":"FL","insp_unit_vehicle_id_number":"1FDUF4GN6LED62426","insp_unit_decal":null,"insp_unit_decal_number":"35989818","created_at":"2026-03-16T03:15:23.000000Z","updated_at":"2026-03-16T03:15:23.000000Z"}]},{"id":11185783,"change_date":"2026-02-20 21:38:00","inspection_id":"87095784","dot_number":"30254","report_state":"PA","report_number":"C111002315","insp_date":"2026-02-18 00:00:00","insp_start_time":"1331","insp_end_time":"1359","registration_date":null,"region":"ES","ci_status_code":"C","location":"I84EB","location_desc":"GREENTOWN PA","county_code_state":"PA","county_code":"103","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SHERWINWILLIAMS PAINT","shipping_paper_number":"70564556062290","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-02-20 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2909895","transaction_code":"A","transaction_date":"2026-02-19 00:00:00","upload_date":"2026-02-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-02-20 21:38:00","snet_input_date":"2026-02-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-20 21:38:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"101 PROSPECT AVE 1000 MIDLAND BLDG","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44115","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-23T10:37:48.000000Z","updated_at":"2026-03-03T10:30:26.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19455784,"change_date":null,"inspection_id":"87095784","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"ZPD0332","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"1FDUF4GN5NED63831","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-03-16T03:15:23.000000Z","updated_at":"2026-03-16T03:15:23.000000Z"}]},{"id":11162910,"change_date":"2026-02-18 21:38:00","inspection_id":"87078214","dot_number":"30254","report_state":"OK","report_number":"N114153393","insp_date":"2026-02-18 00:00:00","insp_start_time":"0923","insp_end_time":"0952","registration_date":null,"region":"CT","ci_status_code":"C","location":"066066","location_desc":"SH66 @ VERDIGRIS","county_code_state":"OK","county_code":"131","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"S\/A CARRIER","shipping_paper_number":"0E0221545A70433","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-02-18 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"812631","transaction_code":"A","transaction_date":"2026-02-18 00:00:00","upload_date":"2026-02-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":"M","census_search_date":"2026-02-18 21:38:00","snet_input_date":"2026-02-18 00:00:00","source_office":"2OKS001","mcmis_add_date":"2026-02-18 21:38:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"101 PROSPECT AVE 1000 MIDLAND BLDG","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44115","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-21T10:38:01.000000Z","updated_at":"2026-03-01T10:30:38.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19452304,"change_date":null,"inspection_id":"87078214","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"V93671","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1FDUF4GN5NEE43906","insp_unit_decal":null,"insp_unit_decal_number":"36077805","created_at":"2026-03-16T03:15:23.000000Z","updated_at":"2026-03-16T03:15:23.000000Z"}]},{"id":11159703,"change_date":"2026-02-18 21:38:00","inspection_id":"87074855","dot_number":"30254","report_state":"MO","report_number":"W172004741","insp_date":"2026-02-17 00:00:00","insp_start_time":"0925","insp_end_time":"0950","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"PARKVILLE MO","county_code_state":"MO","county_code":"165","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"70724156041771","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-02-18 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2901647","transaction_code":"A","transaction_date":"2026-02-18 00:00:00","upload_date":"2026-02-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-02-18 21:38:00","snet_input_date":"2026-02-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-18 21:38:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"101 PROSPECT AVE 1000 MIDLAND BLDG","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44115","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-21T10:37:58.000000Z","updated_at":"2026-03-01T10:30:28.000000Z","inspection_violations":[{"id":19147306,"change_date":null,"inspection_id":"87074855","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-03-16T03:19:05.000000Z","updated_at":"2026-03-16T03:19:05.000000Z","normalized_code":"39375A3TAOL"}],"inspection_per_units":[{"id":19455395,"change_date":null,"inspection_id":"87074855","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"COURIER","insp_unit_company":null,"insp_unit_license":"62H5GY","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1FDUF4GN3LEE34778","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-03-16T03:15:23.000000Z","updated_at":"2026-03-16T03:15:23.000000Z"}]},{"id":11167649,"change_date":"2026-02-19 21:39:00","inspection_id":"87083199","dot_number":"30254","report_state":"FL","report_number":"3226009395","insp_date":"2026-02-17 00:00:00","insp_start_time":"1004","insp_end_time":"1036","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"PANAMA CITY FL","county_code_state":"FL","county_code":"005","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-02-19 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2905225","transaction_code":"A","transaction_date":"2026-02-18 00:00:00","upload_date":"2026-02-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-02-19 21:39:00","snet_input_date":"2026-02-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-19 21:39:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"101 PROSPECT AVE 1000 MIDLAND BLDG","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44115","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-22T10:37:44.000000Z","updated_at":"2026-03-02T10:30:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19452396,"change_date":null,"inspection_id":"87083199","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"RRUH71","insp_unit_license_state":"FL","insp_unit_vehicle_id_number":"1FDUF4GN7REC34527","insp_unit_decal":null,"insp_unit_decal_number":"35987877","created_at":"2026-03-16T03:15:23.000000Z","updated_at":"2026-03-16T03:15:23.000000Z"}]},{"id":11447449,"change_date":"2026-03-23 21:50:00","inspection_id":"87364722","dot_number":"30254","report_state":"NJ","report_number":"SPSBI01145","insp_date":"2026-02-16 00:00:00","insp_start_time":"0808","insp_end_time":"0823","registration_date":null,"region":"ES","ci_status_code":"C","location":"1217","location_desc":"NJ","county_code_state":"NJ","county_code":"023","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SHERWIN WILLIAMS","shipping_paper_number":"5000","cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-03-23 21:50:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3051635","transaction_code":"A","transaction_date":"2026-03-23 00:00:00","upload_date":"2026-03-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-03-23 21:50:00","snet_input_date":"2026-02-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-23 21:50:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"101 PROSPECT AVE 1000 MIDLAND BLDG","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44115","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-26T09:41:25.000000Z","updated_at":"2026-04-03T09:31:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20327509,"change_date":null,"inspection_id":"87364722","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"COURIER","insp_unit_company":null,"insp_unit_license":"XMPU69","insp_unit_license_state":"NJ","insp_unit_vehicle_id_number":"1FDPF7AN8PDF06464","insp_unit_decal":null,"insp_unit_decal_number":"36072024","created_at":"2026-04-20T03:15:53.000000Z","updated_at":"2026-04-20T03:15:53.000000Z"}]},{"id":11163827,"change_date":"2026-02-18 21:38:00","inspection_id":"87079192","dot_number":"30254","report_state":"TX","report_number":"7CZA9DGXEY","insp_date":"2026-02-12 00:00:00","insp_start_time":"1032","insp_end_time":"1051","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0225 IN HARRIS CO. (686-700","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SHERWIN-WILLIAMS","shipping_paper_number":"148371","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-02-18 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9854331","transaction_code":"A","transaction_date":"2026-02-18 00:00:00","upload_date":"2026-02-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":"M","census_search_date":"2026-02-18 21:38:00","snet_input_date":"2026-02-12 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-02-18 21:38:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"101 PROSPECT AVE 1000 MIDLAND BLDG","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44115","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0028305","created_at":"2026-02-21T10:38:02.000000Z","updated_at":"2026-03-01T10:30:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19452835,"change_date":null,"inspection_id":"87079192","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"VVM8757","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FDNF6AN2SDF01285","insp_unit_decal":null,"insp_unit_decal_number":"35977061","created_at":"2026-03-16T03:15:23.000000Z","updated_at":"2026-03-16T03:15:23.000000Z"}]},{"id":11176743,"change_date":"2026-02-19 21:40:00","inspection_id":"87092752","dot_number":"30254","report_state":"CA","report_number":"NE1M007745","insp_date":"2026-02-12 00:00:00","insp_start_time":"0849","insp_end_time":"0913","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-02-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16175813","transaction_code":"A","transaction_date":"2026-02-12 00:00:00","upload_date":"2026-02-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-02-19 21:40:00","snet_input_date":"2026-02-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-02-19 21:40:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"101 PROSPECT AVE 1000 MIDLAND BLDG","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44115","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"524","created_at":"2026-02-22T10:38:08.000000Z","updated_at":"2026-03-02T10:31:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19455956,"change_date":null,"inspection_id":"87092752","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"01289L3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDUF4GN6MED23062","insp_unit_decal":null,"insp_unit_decal_number":"35880084","created_at":"2026-03-16T03:15:23.000000Z","updated_at":"2026-03-16T03:15:23.000000Z"}]},{"id":11114591,"change_date":"2026-02-12 21:40:00","inspection_id":"87027303","dot_number":"30254","report_state":"AL","report_number":"1785005470","insp_date":"2026-02-12 00:00:00","insp_start_time":"1115","insp_end_time":"1145","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"HAYDEN AL","county_code_state":"AL","county_code":"009","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"THE SHERWINWILLIAMS COMPANY","shipping_paper_number":"70254756005841","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-02-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2878552","transaction_code":"A","transaction_date":"2026-02-12 00:00:00","upload_date":"2026-02-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-02-12 21:40:00","snet_input_date":"2026-02-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-12 21:40:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"101 PROSPECT AVE 1000 MIDLAND BLDG","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44115","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-15T10:38:44.000000Z","updated_at":"2026-02-23T10:30:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19452429,"change_date":null,"inspection_id":"87027303","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"1C07BBE","insp_unit_license_state":"AL","insp_unit_vehicle_id_number":"1FDNF6AN3RDF06649","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-03-16T03:15:23.000000Z","updated_at":"2026-03-16T03:15:23.000000Z"}]},{"id":11120418,"change_date":"2026-02-12 21:41:00","inspection_id":"87033464","dot_number":"30254","report_state":"TX","report_number":"V262210522","insp_date":"2026-02-10 00:00:00","insp_start_time":"1300","insp_end_time":"1327","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"17M IH69E SB","county_code_state":"TX","county_code":"061","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"NONE","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-02-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"1","hazmat_oos_total":"0","snet_sequence_id":"9849456","transaction_code":"A","transaction_date":"2026-02-12 00:00:00","upload_date":"2026-02-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":"M","census_search_date":"2026-02-12 21:41:00","snet_input_date":"2026-02-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-02-12 21:41:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"101 PROSPECT AVE 1000 MIDLAND BLDG","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44115","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0028305","created_at":"2026-02-15T10:38:50.000000Z","updated_at":"2026-02-23T10:31:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19452334,"change_date":null,"inspection_id":"87033464","insp_unit_id":"1","insp_unit_type_id":"6","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"SBS6236","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FDUF4GY5KEE76720","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-03-16T03:15:23.000000Z","updated_at":"2026-03-16T03:15:23.000000Z"}]},{"id":11092399,"change_date":"2026-02-10 21:38:00","inspection_id":"87004083","dot_number":"30254","report_state":"AL","report_number":"1750002460","insp_date":"2026-02-10 00:00:00","insp_start_time":"1410","insp_end_time":"1455","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"AXIS AL","county_code_state":"AL","county_code":"097","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"THE SHERWINWILLIAMS","shipping_paper_number":"70235755975860","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-02-10 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2868911","transaction_code":"A","transaction_date":"2026-02-10 00:00:00","upload_date":"2026-02-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-02-10 21:38:00","snet_input_date":"2026-02-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-10 21:38:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"101 PROSPECT AVE 1000 MIDLAND BLDG","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44115","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-13T10:37:50.000000Z","updated_at":"2026-02-21T10:30:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19454198,"change_date":null,"inspection_id":"87004083","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"2A0HPPC","insp_unit_license_state":"AL","insp_unit_vehicle_id_number":"1FDUF5GN7NEE43878","insp_unit_decal":null,"insp_unit_decal_number":"36116147","created_at":"2026-03-16T03:15:23.000000Z","updated_at":"2026-03-16T03:15:23.000000Z"}]},{"id":11099714,"change_date":"2026-02-11 21:38:00","inspection_id":"87011671","dot_number":"30254","report_state":"AL","report_number":"1750002459","insp_date":"2026-02-10 00:00:00","insp_start_time":"1130","insp_end_time":"1217","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"AXIS AL","county_code_state":"AL","county_code":"097","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"THE SHERWINWILLIAMS","shipping_paper_number":"70235755976715","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-02-11 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2869277","transaction_code":"A","transaction_date":"2026-02-10 00:00:00","upload_date":"2026-02-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-02-11 21:38:00","snet_input_date":"2026-02-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-11 21:38:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"101 PROSPECT AVE 1000 MIDLAND BLDG","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44115","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-14T10:37:27.000000Z","updated_at":"2026-02-22T10:30:08.000000Z","inspection_violations":[{"id":19146532,"change_date":null,"inspection_id":"87011671","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9A-LSLI","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-03-16T03:19:05.000000Z","updated_at":"2026-03-16T03:19:05.000000Z","normalized_code":"3939ALSLI"},{"id":19146533,"change_date":null,"inspection_id":"87011671","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9A-LTSI","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-03-16T03:19:05.000000Z","updated_at":"2026-03-16T03:19:05.000000Z","normalized_code":"3939ALTSI"}],"inspection_per_units":[{"id":19451907,"change_date":null,"inspection_id":"87011671","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"2A0HPPD","insp_unit_license_state":"AL","insp_unit_vehicle_id_number":"1FDNF6AN4PDF06463","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-03-16T03:15:23.000000Z","updated_at":"2026-03-16T03:15:23.000000Z"}]},{"id":11054937,"change_date":"2026-02-05 21:38:00","inspection_id":"86965189","dot_number":"30254","report_state":"ME","report_number":"4456003579","insp_date":"2026-02-04 00:00:00","insp_start_time":"1250","insp_end_time":"1311","registration_date":null,"region":"ET","ci_status_code":"C","location":"000440","location_desc":"SIDNEY - SCALES","county_code_state":"ME","county_code":"011","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-02-05 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"407645","transaction_code":"A","transaction_date":"2026-02-04 00:00:00","upload_date":"2026-02-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-02-05 21:38:00","snet_input_date":"2026-02-04 00:00:00","source_office":"1MES001","mcmis_add_date":"2026-02-05 21:38:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"101 PROSPECT AVE 1000 MIDLAND BLDG","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44115","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-08T10:37:18.000000Z","updated_at":"2026-02-16T10:30:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19454511,"change_date":null,"inspection_id":"86965189","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"6C4610","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1FDUF4GN3NED63827","insp_unit_decal":null,"insp_unit_decal_number":"36117693","created_at":"2026-03-16T03:15:23.000000Z","updated_at":"2026-03-16T03:15:23.000000Z"}]},{"id":11064830,"change_date":"2026-02-06 21:38:00","inspection_id":"86975181","dot_number":"30254","report_state":"IN","report_number":"9449001829","insp_date":"2026-02-04 00:00:00","insp_start_time":"1327","insp_end_time":"1419","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"BRISTOL IN","county_code_state":"IN","county_code":"039","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SHERWIN WILLIAMS OLD QUAKER PAINT PRO LINE PAINT","shipping_paper_number":"79143155905871","cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-02-06 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"4","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"1","hazmat_oos_total":"1","snet_sequence_id":"2853589","transaction_code":"A","transaction_date":"2026-02-06 00:00:00","upload_date":"2026-02-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-02-06 21:38:00","snet_input_date":"2026-02-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-06 21:38:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"101 PROSPECT AVE 1000 MIDLAND BLDG","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44115","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-10T10:37:18.000000Z","updated_at":"2026-02-17T10:30:29.000000Z","inspection_violations":[{"id":19149259,"change_date":null,"inspection_id":"86975181","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-03-16T03:19:05.000000Z","updated_at":"2026-03-16T03:19:05.000000Z","normalized_code":"3939ALIL"},{"id":19149260,"change_date":null,"inspection_id":"86975181","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-03-16T03:19:05.000000Z","updated_at":"2026-03-16T03:19:05.000000Z","normalized_code":"3939ALLPL"},{"id":19149261,"change_date":null,"inspection_id":"86975181","insp_violation_id":null,"seq_no":null,"part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-03-16T03:19:05.000000Z","updated_at":"2026-03-16T03:19:05.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":19456815,"change_date":null,"inspection_id":"86975181","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"TK122NPG","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FDUF5GY2KEC92440","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-03-16T03:15:23.000000Z","updated_at":"2026-03-16T03:15:23.000000Z"}]},{"id":11439404,"change_date":"2026-03-23 21:50:00","inspection_id":"87356188","dot_number":"30254","report_state":"NJ","report_number":"SPPZI05882","insp_date":"2026-02-03 00:00:00","insp_start_time":"1114","insp_end_time":"1134","registration_date":null,"region":"ES","ci_status_code":"C","location":"1713","location_desc":"NJ","county_code_state":"NJ","county_code":"033","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-03-23 21:50:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3042919","transaction_code":"A","transaction_date":"2026-03-23 00:00:00","upload_date":"2026-03-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-03-23 21:50:00","snet_input_date":"2026-02-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-23 21:50:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"101 PROSPECT AVE 1000 MIDLAND BLDG","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44115","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-26T09:41:15.000000Z","updated_at":"2026-04-03T09:30:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20332646,"change_date":null,"inspection_id":"87356188","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"COURIER","insp_unit_company":null,"insp_unit_license":"C72132","insp_unit_license_state":"DE","insp_unit_vehicle_id_number":"1FDNF6AN6TDF00965","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-04-20T03:15:53.000000Z","updated_at":"2026-04-20T03:15:53.000000Z"}]},{"id":11056835,"change_date":"2026-02-05 21:39:00","inspection_id":"86966887","dot_number":"30254","report_state":"KS","report_number":"HP93426442","insp_date":"2026-02-03 00:00:00","insp_start_time":"0835","insp_end_time":"0910","registration_date":null,"region":"CT","ci_status_code":"C","location":"#24W","location_desc":"OLATHE SOUTH M.C.I.S. #24W","county_code_state":"KS","county_code":"091","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"72766355890957","cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-02-05 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1387867","transaction_code":"A","transaction_date":"2026-02-03 00:00:00","upload_date":"2026-02-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-02-05 21:39:00","snet_input_date":"2026-02-03 00:00:00","source_office":"3KSS001","mcmis_add_date":"2026-02-05 21:39:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"101 PROSPECT AVE 1000 MIDLAND BLDG","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44115","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-08T10:37:22.000000Z","updated_at":"2026-02-16T10:30:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19454147,"change_date":null,"inspection_id":"86966887","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"5KFY20","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1FDUF4GNXNEE43870","insp_unit_decal":null,"insp_unit_decal_number":"36103114","created_at":"2026-03-16T03:15:23.000000Z","updated_at":"2026-03-16T03:15:23.000000Z"}]},{"id":10911382,"change_date":"2026-02-03 21:38:00","inspection_id":"86943220","dot_number":"30254","report_state":"UT","report_number":"25EB002495","insp_date":"2026-02-02 00:00:00","insp_start_time":"1000","insp_end_time":"1055","registration_date":null,"region":"MS","ci_status_code":"C","location":"UT51","location_desc":"ST. GEORGE UT","county_code_state":"UT","county_code":"053","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CONSUMER GROUP","shipping_paper_number":"701617","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-02-03 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2839669","transaction_code":"A","transaction_date":"2026-02-03 00:00:00","upload_date":"2026-02-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-02-03 21:38:00","snet_input_date":"2026-02-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-03 21:38:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"101 PROSPECT AVE 1000 MIDLAND BLDG","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44115","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-06T10:35:11.000000Z","updated_at":"2026-02-14T10:30:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19453803,"change_date":null,"inspection_id":"86943220","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":null,"insp_unit_license":"3132970","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4NC9EH0NN289315","insp_unit_decal":null,"insp_unit_decal_number":"36032236","created_at":"2026-03-16T03:15:23.000000Z","updated_at":"2026-03-16T03:15:23.000000Z"},{"id":19459885,"change_date":null,"inspection_id":"86943220","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":null,"insp_unit_license":"502864","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"3H3V482C1FT217006","insp_unit_decal":null,"insp_unit_decal_number":"36032229","created_at":"2026-03-16T03:15:23.000000Z","updated_at":"2026-03-16T03:15:23.000000Z"}]},{"id":10915851,"change_date":"2026-06-15 21:42:00","inspection_id":"86947949","dot_number":"30254","report_state":"TX","report_number":"V261563931","insp_date":"2026-01-29 00:00:00","insp_start_time":"1025","insp_end_time":"1052","registration_date":null,"region":"CT","ci_status_code":"C","location":"2A701","location_desc":"IH45 NB NEW WAVERLY SCALE","county_code_state":"TX","county_code":"471","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SHERWIN WILLIAMS","shipping_paper_number":"70430055861145","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-06-15 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9837419","transaction_code":"C","transaction_date":"2026-06-15 00:00:00","upload_date":"2026-06-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":"M","census_search_date":"2026-06-15 21:42:00","snet_input_date":"2026-01-29 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-02-03 21:39:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"1 SHERWIN WAY","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44113","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0028305","created_at":"2026-02-06T10:35:19.000000Z","updated_at":"2026-06-26T09:30:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19454136,"change_date":null,"inspection_id":"86947949","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"WGH6039","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FDNF6ANXSDF04354","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-03-16T03:15:23.000000Z","updated_at":"2026-03-16T03:15:23.000000Z"}]},{"id":11044646,"change_date":"2026-02-04 21:39:00","inspection_id":"86954151","dot_number":"30254","report_state":"PR","report_number":"0030000771","insp_date":"2026-01-29 00:00:00","insp_start_time":"1155","insp_end_time":"1211","registration_date":null,"region":"-0","ci_status_code":"C","location":null,"location_desc":"CAROLINA PR","county_code_state":"PR","county_code":null,"insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-02-04 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2843744","transaction_code":"A","transaction_date":"2026-02-04 00:00:00","upload_date":"2026-02-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-02-04 21:39:00","snet_input_date":"2026-01-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-04 21:39:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"101 PROSPECT AVE 1000 MIDLAND BLDG","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44115","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-08T10:36:58.000000Z","updated_at":"2026-02-15T10:30:29.000000Z","inspection_violations":[{"id":19149014,"change_date":null,"inspection_id":"86954151","insp_violation_id":null,"seq_no":null,"part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-03-16T03:19:05.000000Z","updated_at":"2026-03-16T03:19:05.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":19456630,"change_date":null,"inspection_id":"86954151","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"H63751","insp_unit_license_state":"PR","insp_unit_vehicle_id_number":"1FDUF4GY5CEB35884","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-03-16T03:15:23.000000Z","updated_at":"2026-03-16T03:15:23.000000Z"}]},{"id":10871417,"change_date":"2026-01-27 21:38:00","inspection_id":"86901434","dot_number":"30254","report_state":"CA","report_number":"UE7D003775","insp_date":"2026-01-27 00:00:00","insp_start_time":"0858","insp_end_time":"0905","registration_date":null,"region":"PT","ci_status_code":"C","location":"850","location_desc":"GREENBACK AT KENNETH AVE","county_code_state":"CA","county_code":"067","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-01-27 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16146916","transaction_code":"A","transaction_date":"2026-01-27 00:00:00","upload_date":"2026-01-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-01-27 21:38:00","snet_input_date":"2026-01-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-01-27 21:38:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"101 PROSPECT AVE 1000 MIDLAND BLDG","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44115","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-30T10:36:32.000000Z","updated_at":"2026-02-08T10:30:48.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19084994,"change_date":null,"inspection_id":"86901434","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"73986A4","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDUF4GN1REC34538","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-23T04:15:17.000000Z","updated_at":"2026-02-23T04:15:17.000000Z"}]},{"id":10855479,"change_date":"2026-01-25 21:33:00","inspection_id":"86884753","dot_number":"30254","report_state":"WA","report_number":"0813001638","insp_date":"2026-01-20 00:00:00","insp_start_time":"0900","insp_end_time":"0920","registration_date":null,"region":"PS","ci_status_code":"C","location":null,"location_desc":"KENNEWICK WA","county_code_state":"WA","county_code":"005","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"772134","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-01-25 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2810686","transaction_code":"A","transaction_date":"2026-01-24 00:00:00","upload_date":"2026-01-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-01-25 21:33:00","snet_input_date":"2026-01-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-25 21:33:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"101 PROSPECT AVE 1000 MIDLAND BLDG","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44115","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-28T10:36:20.000000Z","updated_at":"2026-02-05T10:30:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19088611,"change_date":null,"inspection_id":"86884753","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"C23725V","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1FDUF4GN9LED62436","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-23T04:15:17.000000Z","updated_at":"2026-02-23T04:15:17.000000Z"}]},{"id":10798810,"change_date":"2026-01-17 21:34:00","inspection_id":"86825313","dot_number":"30254","report_state":"VA","report_number":"6989000864","insp_date":"2026-01-15 00:00:00","insp_start_time":"0925","insp_end_time":"0929","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"MIDDLETOWN VA","county_code_state":"VA","county_code":"630","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-01-17 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2782076","transaction_code":"A","transaction_date":"2026-01-17 00:00:00","upload_date":"2026-01-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-01-17 21:34:00","snet_input_date":"2026-01-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-17 21:34:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"101 PROSPECT AVE 1000 MIDLAND BLDG","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44115","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-20T10:36:50.000000Z","updated_at":"2026-01-28T10:30:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19090892,"change_date":null,"inspection_id":"86825313","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"UB91722","insp_unit_license_state":"VA","insp_unit_vehicle_id_number":"1FDUF4GN1PED59326","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-23T04:15:17.000000Z","updated_at":"2026-02-23T04:15:17.000000Z"}]},{"id":10800533,"change_date":"2026-01-18 21:33:00","inspection_id":"86827142","dot_number":"30254","report_state":"GA","report_number":"1220001268","insp_date":"2026-01-15 00:00:00","insp_start_time":"1122","insp_end_time":"1135","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"POOLER GA","county_code_state":"GA","county_code":"051","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"NA","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-01-18 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"18000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2783662","transaction_code":"A","transaction_date":"2026-01-17 00:00:00","upload_date":"2026-01-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-01-18 21:33:00","snet_input_date":"2026-01-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-18 21:33:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"101 PROSPECT AVE 1000 MIDLAND BLDG","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44115","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-21T10:36:13.000000Z","updated_at":"2026-01-29T10:30:09.000000Z","inspection_violations":[{"id":18745333,"change_date":null,"inspection_id":"86827142","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"2-SLLS3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-23T04:17:42.000000Z","updated_at":"2026-02-23T04:17:42.000000Z","normalized_code":"3922SLLS3"}],"inspection_per_units":[{"id":19090521,"change_date":null,"inspection_id":"86827142","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"YXH047","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"1FDUF4GNXREC34523","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-23T04:15:17.000000Z","updated_at":"2026-02-23T04:15:17.000000Z"}]},{"id":10783505,"change_date":"2026-01-15 21:41:00","inspection_id":"86809298","dot_number":"30254","report_state":"CA","report_number":"UEGX002432","insp_date":"2026-01-15 00:00:00","insp_start_time":"0840","insp_end_time":"0900","registration_date":null,"region":"PT","ci_status_code":"C","location":"365","location_desc":"LAKE HERMAN RD. EO COLUMBUS","county_code_state":"CA","county_code":"095","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-01-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16132530","transaction_code":"A","transaction_date":"2026-01-15 00:00:00","upload_date":"2026-01-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-01-15 21:41:00","snet_input_date":"2026-01-15 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-01-15 21:41:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"101 PROSPECT AVE 1000 MIDLAND BLDG","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44115","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"524","created_at":"2026-01-18T10:45:31.000000Z","updated_at":"2026-01-26T10:31:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19087463,"change_date":null,"inspection_id":"86809298","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"55930H4","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDUF4GN9REE46412","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-23T04:15:17.000000Z","updated_at":"2026-02-23T04:15:17.000000Z"}]},{"id":10775720,"change_date":"2026-01-15 21:40:00","inspection_id":"86801188","dot_number":"30254","report_state":"FL","report_number":"3574004001","insp_date":"2026-01-14 00:00:00","insp_start_time":"0803","insp_end_time":"0824","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"WINTER GARDEN FL","county_code_state":"FL","county_code":"095","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-01-15 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2769826","transaction_code":"A","transaction_date":"2026-01-15 00:00:00","upload_date":"2026-01-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-01-15 21:40:00","snet_input_date":"2026-01-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-15 21:40:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"101 PROSPECT AVE 1000 MIDLAND BLDG","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44115","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-18T10:44:39.000000Z","updated_at":"2026-01-26T10:30:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19090087,"change_date":null,"inspection_id":"86801188","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BR61NL","insp_unit_license_state":"FL","insp_unit_vehicle_id_number":"1FDUF4GN0PED59298","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-23T04:15:17.000000Z","updated_at":"2026-02-23T04:15:17.000000Z"}]},{"id":10784724,"change_date":"2026-01-16 21:39:00","inspection_id":"86810552","dot_number":"30254","report_state":"FL","report_number":"2460004216","insp_date":"2026-01-14 00:00:00","insp_start_time":"1053","insp_end_time":"1113","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"WINTER GARDEN FL","county_code_state":"FL","county_code":"095","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-01-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2773453","transaction_code":"A","transaction_date":"2026-01-15 00:00:00","upload_date":"2026-01-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-01-16 21:39:00","snet_input_date":"2026-01-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-16 21:39:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"101 PROSPECT AVE 1000 MIDLAND BLDG","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44115","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-19T10:36:50.000000Z","updated_at":"2026-01-27T10:30:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19087565,"change_date":null,"inspection_id":"86810552","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"24DZHX","insp_unit_license_state":"FL","insp_unit_vehicle_id_number":"1FDUF4GN2LED73262","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-23T04:15:17.000000Z","updated_at":"2026-02-23T04:15:17.000000Z"}]},{"id":10807121,"change_date":"2026-01-20 21:39:00","inspection_id":"86834059","dot_number":"30254","report_state":"NY","report_number":"SPC3031624","insp_date":"2026-01-13 00:00:00","insp_start_time":"1342","insp_end_time":"1358","registration_date":null,"region":"ES","ci_status_code":"C","location":"30690M","location_desc":"PREBLE NY","county_code_state":"NY","county_code":"023","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SHERWIN WILLIAMS","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-01-20 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2789811","transaction_code":"A","transaction_date":"2026-01-19 00:00:00","upload_date":"2026-01-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-01-20 21:39:00","snet_input_date":"2026-01-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-20 21:39:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"101 PROSPECT AVE 1000 MIDLAND BLDG","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44115","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-23T10:36:10.000000Z","updated_at":"2026-01-31T10:30:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19084698,"change_date":null,"inspection_id":"86834059","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":null,"insp_unit_license":"3573930","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"54DC4W1D7MS202068","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-23T04:15:17.000000Z","updated_at":"2026-02-23T04:15:17.000000Z"}]},{"id":10786269,"change_date":"2026-01-16 21:39:00","inspection_id":"86812183","dot_number":"30254","report_state":"GA","report_number":"1381000559","insp_date":"2026-01-13 00:00:00","insp_start_time":"1009","insp_end_time":"1117","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"LITHIA SPRINGS GA","county_code_state":"GA","county_code":"097","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SHERWIN WILLIAMS","shipping_paper_number":"OE0017660A72105","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-01-16 21:39:00","post_acc_ind":"Y","gross_comb_veh_wt":"16500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2775276","transaction_code":"A","transaction_date":"2026-01-15 00:00:00","upload_date":"2026-01-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-01-16 21:39:00","snet_input_date":"2026-01-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-16 21:39:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"101 PROSPECT AVE 1000 MIDLAND BLDG","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44115","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-19T10:36:52.000000Z","updated_at":"2026-01-27T10:30:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19090506,"change_date":null,"inspection_id":"86812183","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":null,"insp_unit_license":"YMR876","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"54DC4W1D9RS201530","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-23T04:15:17.000000Z","updated_at":"2026-02-23T04:15:17.000000Z"}]},{"id":10653697,"change_date":"2026-01-14 21:41:00","inspection_id":"86795643","dot_number":"30254","report_state":"CA","report_number":"NEC6001454","insp_date":"2026-01-13 00:00:00","insp_start_time":"1321","insp_end_time":"1336","registration_date":null,"region":"PT","ci_status_code":"C","location":"726","location_desc":"GILROY IF","county_code_state":"CA","county_code":"085","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-01-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16128808","transaction_code":"A","transaction_date":"2026-01-13 00:00:00","upload_date":"2026-01-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-01-14 21:41:00","snet_input_date":"2026-01-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-01-14 21:41:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"101 PROSPECT AVE 1000 MIDLAND BLDG","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44115","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"524","created_at":"2026-01-17T10:36:37.000000Z","updated_at":"2026-01-25T10:31:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19090174,"change_date":null,"inspection_id":"86795643","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"16019X3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDNF6AN3RDF06103","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-23T04:15:17.000000Z","updated_at":"2026-02-23T04:15:17.000000Z"}]},{"id":10774096,"change_date":"2026-01-15 21:40:00","inspection_id":"86799471","dot_number":"30254","report_state":"WI","report_number":"2350006084","insp_date":"2026-01-12 00:00:00","insp_start_time":"1517","insp_end_time":"1543","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"HOLMEN WI","county_code_state":"WI","county_code":"063","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SHERWIN WILLIAMS OLD QUAKER PAINT PRO LINE PAINT","shipping_paper_number":"EMPTY","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-01-15 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2768145","transaction_code":"A","transaction_date":"2026-01-14 00:00:00","upload_date":"2026-01-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-01-15 21:40:00","snet_input_date":"2026-01-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-15 21:40:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"101 PROSPECT AVE 1000 MIDLAND BLDG","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44115","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-18T10:44:09.000000Z","updated_at":"2026-01-26T10:30:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19090479,"change_date":null,"inspection_id":"86799471","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"FB55310","insp_unit_license_state":"WI","insp_unit_vehicle_id_number":"1FDUF4GN7PEC82154","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-23T04:15:17.000000Z","updated_at":"2026-02-23T04:15:17.000000Z"}]},{"id":10643979,"change_date":"2026-01-14 21:39:00","inspection_id":"86785492","dot_number":"30254","report_state":"FL","report_number":"2545005754","insp_date":"2026-01-12 00:00:00","insp_start_time":"1554","insp_end_time":"1613","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"DAVENPORT FL","county_code_state":"FL","county_code":"105","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-01-14 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2760712","transaction_code":"A","transaction_date":"2026-01-13 00:00:00","upload_date":"2026-01-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-01-14 21:39:00","snet_input_date":"2026-01-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-14 21:39:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"101 PROSPECT AVE 1000 MIDLAND BLDG","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44115","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-17T10:36:17.000000Z","updated_at":"2026-01-25T10:30:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19090557,"change_date":null,"inspection_id":"86785492","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"PKPT35","insp_unit_license_state":"FL","insp_unit_vehicle_id_number":"1FDUF4GY8KEE76694","insp_unit_decal":null,"insp_unit_decal_number":"35989725","created_at":"2026-02-23T04:15:17.000000Z","updated_at":"2026-02-23T04:15:17.000000Z"}]},{"id":11444688,"change_date":"2026-03-23 21:50:00","inspection_id":"87361777","dot_number":"30254","report_state":"NJ","report_number":"SPQSI03125","insp_date":"2026-01-08 00:00:00","insp_start_time":"0915","insp_end_time":"1000","registration_date":null,"region":"ES","ci_status_code":"C","location":"1304","location_desc":"NJ","county_code_state":"NJ","county_code":"025","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-03-23 21:50:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3048648","transaction_code":"A","transaction_date":"2026-03-23 00:00:00","upload_date":"2026-03-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00030254","upload_search_indicator":null,"census_search_date":"2026-03-23 21:50:00","snet_input_date":"2026-01-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-23 21:50:00","insp_carrier_name":"THE SHERWIN-WILLIAMS COMPANY","insp_carrier_street":"101 PROSPECT AVE 1000 MIDLAND BLDG","insp_carrier_city":"CLEVELAND","insp_carrier_state":"OH","insp_carrier_zip_code":"44115","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-26T09:41:21.000000Z","updated_at":"2026-04-03T09:31:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20327457,"change_date":null,"inspection_id":"87361777","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"COURIER","insp_unit_company":null,"insp_unit_license":"XMRA25","insp_unit_license_state":"NJ","insp_unit_vehicle_id_number":"1FDUF4GNXPEC82181","insp_unit_decal":null,"insp_unit_decal_number":"36071534","created_at":"2026-04-20T03:15:53.000000Z","updated_at":"2026-04-20T03:15:53.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/30254\/inspections?page=1","from":1,"last_page":8,"last_page_url":"https:\/\/searchcarriers.com\/company\/30254\/inspections?page=8","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/30254\/inspections?page=1","label":"1","page":1,"active":true},{"url":"https:\/\/searchcarriers.com\/company\/30254\/inspections?page=2","label":"2","page":2,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/30254\/inspections?page=3","label":"3","page":3,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/30254\/inspections?page=4","label":"4","page":4,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/30254\/inspections?page=5","label":"5","page":5,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/30254\/inspections?page=6","label":"6","page":6,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/30254\/inspections?page=7","label":"7","page":7,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/30254\/inspections?page=8","label":"8","page":8,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/30254\/inspections?page=2","label":"Next »","page":2,"active":false}],"next_page_url":"https:\/\/searchcarriers.com\/company\/30254\/inspections?page=2","path":"https:\/\/searchcarriers.com\/company\/30254\/inspections","per_page":100,"prev_page_url":null,"to":100,"total":731}