{"current_page":1,"data":[{"id":12655033,"change_date":"2026-08-06 21:42:00","inspection_id":"88627471","dot_number":"1677307","report_state":"MI","report_number":"POWED06021","insp_date":"2026-08-06 00:00:00","insp_start_time":"1348","insp_end_time":"1410","registration_date":null,"region":"ED","ci_status_code":"C","location":"212","location_desc":"MI","county_code_state":"MI","county_code":"125","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"S\/C","shipping_paper_number":"170726","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-06 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"64000","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3925011","transaction_code":"A","transaction_date":"2026-08-06 00:00:00","upload_date":"2026-08-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01677307","upload_search_indicator":null,"census_search_date":"2026-08-06 21:42:00","snet_input_date":"2026-08-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-08-06 21:42:00","insp_carrier_name":"STERLING SANITATION INC","insp_carrier_street":"37625 29 MILE RD","insp_carrier_city":"LENOX","insp_carrier_state":"MI","insp_carrier_zip_code":"48050","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-08-09T09:42:23.000000Z","updated_at":"2026-08-17T09:31:11.000000Z","inspection_violations":[{"id":22032034,"change_date":"2026-08-06 21:42:00","inspection_id":"88627471","insp_violation_id":"275973932","seq_no":"1","part_no":"393","part_no_section":"134B-CRHLC","insp_viol_unit":"1","insp_unit_id":"215021433","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2026-08-09T10:03:37.000000Z","updated_at":"2026-08-17T09:42:14.000000Z","normalized_code":"393134BCRHLC"},{"id":22032035,"change_date":"2026-08-06 21:42:00","inspection_id":"88627471","insp_violation_id":"275973933","seq_no":"2","part_no":"392","part_no_section":"2-SLLUCR","insp_viol_unit":"1","insp_unit_id":"215021433","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-09T10:03:37.000000Z","updated_at":"2026-08-17T09:42:14.000000Z","normalized_code":"3922SLLUCR"},{"id":22032036,"change_date":"2026-08-06 21:42:00","inspection_id":"88627471","insp_violation_id":"275973934","seq_no":"3","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"215021433","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-09T10:03:37.000000Z","updated_at":"2026-08-17T09:42:14.000000Z","normalized_code":"3939ALHLI"}],"inspection_per_units":[{"id":21966114,"change_date":"2026-08-06 21:42:00","inspection_id":"88627471","insp_unit_id":"215021433","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"N\/A","insp_unit_license":"BE17670","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NKZX4TX6HJ120246","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-09T09:20:44.000000Z","updated_at":"2026-08-17T09:02:40.000000Z"}]},{"id":12509480,"change_date":"2026-07-21 21:40:00","inspection_id":"88473700","dot_number":"1677307","report_state":"MI","report_number":"ESCOT03267","insp_date":"2026-07-21 00:00:00","insp_start_time":"1435","insp_end_time":"1530","registration_date":null,"region":"ED","ci_status_code":"C","location":"ROAD","location_desc":"MI","county_code_state":"MI","county_code":"099","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SC","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":"Y","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":"86000","viol_total":"5","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3804248","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":"01677307","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":"STERLING SANITATION INC","insp_carrier_street":"37625 29 MILE RD","insp_carrier_city":"LENOX","insp_carrier_state":"MI","insp_carrier_zip_code":"48050","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-24T09:42:32.000000Z","updated_at":"2026-08-01T09:31:01.000000Z","inspection_violations":[{"id":21778880,"change_date":"2026-07-21 21:40:00","inspection_id":"88473700","insp_violation_id":"275642712","seq_no":"1","part_no":"392","part_no_section":"2-SLLLR","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-24T10:05:00.000000Z","updated_at":"2026-08-01T09:43:23.000000Z","normalized_code":"3922SLLLR"},{"id":21778881,"change_date":"2026-07-21 21:40:00","inspection_id":"88473700","insp_violation_id":"275642713","seq_no":"2","part_no":"392","part_no_section":"2-SLLUCR","insp_viol_unit":"1","insp_unit_id":"214737636","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4731208","created_at":"2026-07-24T10:05:00.000000Z","updated_at":"2026-08-01T09:43:23.000000Z","normalized_code":"3922SLLUCR"},{"id":21778882,"change_date":"2026-07-21 21:40:00","inspection_id":"88473700","insp_violation_id":"275642714","seq_no":"3","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"214737636","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-24T10:05:00.000000Z","updated_at":"2026-08-01T09:43:23.000000Z","normalized_code":"39395A1"},{"id":21778883,"change_date":"2026-07-21 21:40:00","inspection_id":"88473700","insp_violation_id":"275642715","seq_no":"4","part_no":"393","part_no_section":"75C-TAOTD-LT1\/32","insp_viol_unit":"1","insp_unit_id":"214737636","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-24T10:05:00.000000Z","updated_at":"2026-08-01T09:43:23.000000Z","normalized_code":"39375CTAOTDLT1\/32"},{"id":21778884,"change_date":"2026-07-21 21:40:00","inspection_id":"88473700","insp_violation_id":"275642716","seq_no":"5","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"214737636","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-24T10:05:00.000000Z","updated_at":"2026-08-01T09:43:23.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":21725150,"change_date":"2026-07-21 21:40:00","inspection_id":"88473700","insp_unit_id":"214737636","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"126","insp_unit_license":"BE17672","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NKDXUTX3BJ291523","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-24T09:20:08.000000Z","updated_at":"2026-08-01T09:02:28.000000Z"}]},{"id":11930383,"change_date":"2026-05-28 21:41:00","inspection_id":"87865000","dot_number":"1677307","report_state":"MI","report_number":"DAWDD04533","insp_date":"2026-05-15 00:00:00","insp_start_time":"1131","insp_end_time":"1201","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"163","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"STERLING SANITATION INC","shipping_paper_number":"05152026","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-15 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"3337072","transaction_code":"C","transaction_date":"2026-05-28 00:00:00","upload_date":"2026-05-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01677307","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":"STERLING SANITATION INC","insp_carrier_street":"37625 29 MILE RD","insp_carrier_city":"LENOX","insp_carrier_state":"MI","insp_carrier_zip_code":"48050","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-18T09:40:36.000000Z","updated_at":"2026-06-08T09:30:08.000000Z","inspection_violations":[{"id":20751872,"change_date":"2026-05-28 21:41:00","inspection_id":"87865000","insp_violation_id":"274543381","seq_no":"1","part_no":"392","part_no_section":"2-SLLUCR","insp_viol_unit":"1","insp_unit_id":"213785296","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-18T10:01:11.000000Z","updated_at":"2026-06-08T09:41:38.000000Z","normalized_code":"3922SLLUCR"},{"id":20751873,"change_date":"2026-05-28 21:41:00","inspection_id":"87865000","insp_violation_id":"274543382","seq_no":"2","part_no":"393","part_no_section":"75A3-TFL","insp_viol_unit":"1","insp_unit_id":"213785296","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2026-05-18T10:01:11.000000Z","updated_at":"2026-06-08T09:41:38.000000Z","normalized_code":"39375A3TFL"}],"inspection_per_units":[{"id":20747317,"change_date":"2026-05-28 21:41:00","inspection_id":"87865000","insp_unit_id":"213785296","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"NONE","insp_unit_license":"BE17663","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NKZX4TX1PJ250076","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-18T09:18:52.000000Z","updated_at":"2026-06-08T09:01:05.000000Z"}]},{"id":11759715,"change_date":"2026-04-27 21:39:00","inspection_id":"87690049","dot_number":"1677307","report_state":"MI","report_number":"COPEK03666","insp_date":"2026-04-27 00:00:00","insp_start_time":"0930","insp_end_time":"0950","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"GRATIOT @ NEW HAVEN RD","county_code_state":"MI","county_code":"099","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/A\/C","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":"N","pen_cen_match":null,"final_status_date":"2026-04-27 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"1267831","transaction_code":"A","transaction_date":"2026-04-27 00:00:00","upload_date":"2026-04-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01677307","upload_search_indicator":null,"census_search_date":"2026-04-27 21:39:00","snet_input_date":"2026-04-27 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-04-27 21:39:00","insp_carrier_name":"STERLING SANITATION INC","insp_carrier_street":"37625 29 MILE RD","insp_carrier_city":"LENOX","insp_carrier_state":"MI","insp_carrier_zip_code":"48050","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-30T09:39:38.000000Z","updated_at":"2026-05-08T09:31:01.000000Z","inspection_violations":[{"id":20445620,"change_date":"2026-04-27 21:39:00","inspection_id":"87690049","insp_violation_id":"273879614","seq_no":"1","part_no":"392","part_no_section":"2-SLLTCD","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-04-30T09:59:01.000000Z","updated_at":"2026-05-08T09:42:13.000000Z","normalized_code":"3922SLLTCD"}],"inspection_per_units":[{"id":20459688,"change_date":"2026-04-27 21:39:00","inspection_id":"87690049","insp_unit_id":"213247666","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"11","insp_unit_license":"BE17676","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NKDLB0XXVJ754167","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-30T09:18:37.000000Z","updated_at":"2026-05-08T09:03:43.000000Z"}]},{"id":11819286,"change_date":"2026-05-04 21:39:00","inspection_id":"87753689","dot_number":"1677307","report_state":"MI","report_number":"COPEK03666","insp_date":"2026-04-26 00:00:00","insp_start_time":"2300","insp_end_time":"2300","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"099","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/A\/C","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":"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-04 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3257147","transaction_code":"A","transaction_date":"2026-05-04 00:00:00","upload_date":"2026-05-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01677307","upload_search_indicator":null,"census_search_date":"2026-05-04 21:39:00","snet_input_date":"2026-05-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-04 21:39:00","insp_carrier_name":"STERLING SANITATION INC","insp_carrier_street":"37625 29 MILE RD","insp_carrier_city":"LENOX","insp_carrier_state":"MI","insp_carrier_zip_code":"48050","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-07T09:39:00.000000Z","updated_at":"2026-05-14T12:30:55.000000Z","inspection_violations":[{"id":20553807,"change_date":"2026-05-04 21:39:00","inspection_id":"87753689","insp_violation_id":"274025003","seq_no":"1","part_no":"392","part_no_section":"2-SLLTCD","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-05-07T09:57:50.000000Z","updated_at":"2026-05-14T12:42:29.000000Z","normalized_code":"3922SLLTCD"},{"id":20553808,"change_date":"2026-05-04 21:39:00","inspection_id":"87753689","insp_violation_id":"274025004","seq_no":"2","part_no":"392","part_no_section":"2-SLLUCR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-07T09:57:50.000000Z","updated_at":"2026-05-14T12:42:29.000000Z","normalized_code":"3922SLLUCR"}],"inspection_per_units":[{"id":20557352,"change_date":"2026-05-04 21:39:00","inspection_id":"87753689","insp_unit_id":"213366810","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"BE17676","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NKDLB0XXVJ754167","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-07T09:17:38.000000Z","updated_at":"2026-05-14T11:48:52.000000Z"}]},{"id":10279701,"change_date":"2025-12-04 21:38:00","inspection_id":"86404356","dot_number":"1677307","report_state":"MI","report_number":"DAWDD04248","insp_date":"2025-11-21 00:00:00","insp_start_time":"1108","insp_end_time":"1139","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WB I-96 AT FARMINGTON","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"STERLING","shipping_paper_number":"11212025","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":"2025-11-24 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1251722","transaction_code":"C","transaction_date":"2025-11-21 00:00:00","upload_date":"2025-12-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01677307","upload_search_indicator":null,"census_search_date":"2025-11-24 21:39:00","snet_input_date":"2025-11-21 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-11-24 21:39:00","insp_carrier_name":"STERLING SANITATION INC","insp_carrier_street":"37625 29 MILE RD","insp_carrier_city":"LENOX","insp_carrier_state":"MI","insp_carrier_zip_code":"48050","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-27T10:30:49.000000Z","updated_at":"2025-12-08T10:30:42.000000Z","inspection_violations":[{"id":17322841,"change_date":"2025-12-04 21:38:00","inspection_id":"86404356","insp_violation_id":"270461989","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":"X4595584","created_at":"2025-12-07T10:32:10.000000Z","updated_at":"2025-12-08T10:31:14.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":17292422,"change_date":"2025-12-04 21:38:00","inspection_id":"86404356","insp_unit_id":"210414452","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"138","insp_unit_license":"BE17663","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NKZX4TX1PJ250076","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-07T10:01:28.000000Z","updated_at":"2025-12-08T10:00:50.000000Z"}]},{"id":9654971,"change_date":"2025-09-11 21:41:00","inspection_id":"85748807","dot_number":"1677307","report_state":"MI","report_number":"BALLB05225","insp_date":"2025-09-11 00:00:00","insp_start_time":"1025","insp_end_time":"1055","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"BUNERT @ I696","county_code_state":"MI","county_code":"099","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"156604","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":"2025-09-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"62000","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1240662","transaction_code":"A","transaction_date":"2025-09-11 00:00:00","upload_date":"2025-09-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01677307","upload_search_indicator":null,"census_search_date":"2025-09-11 21:41:00","snet_input_date":"2025-09-11 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-09-11 21:41:00","insp_carrier_name":"STERLING SANITATION INC","insp_carrier_street":"37625 29 MILE RD","insp_carrier_city":"LENOX","insp_carrier_state":"MI","insp_carrier_zip_code":"48050","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-13T10:48:00.000000Z","updated_at":"2025-09-16T10:47:02.000000Z","inspection_violations":[{"id":15812117,"change_date":"2025-09-11 21:41:00","inspection_id":"85748807","insp_violation_id":"268613383","seq_no":"1","part_no":"392","part_no_section":"2-SLLLR","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":"2025-09-14T11:57:00.000000Z","updated_at":"2025-09-14T11:57:00.000000Z","normalized_code":"3922SLLLR"},{"id":15812118,"change_date":"2025-09-11 21:41:00","inspection_id":"85748807","insp_violation_id":"268613384","seq_no":"2","part_no":"393","part_no_section":"134B-CRHLC","insp_viol_unit":"1","insp_unit_id":"208876690","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-09-14T11:57:00.000000Z","updated_at":"2025-09-14T11:57:00.000000Z","normalized_code":"393134BCRHLC"}],"inspection_per_units":[{"id":15954752,"change_date":"2025-09-11 21:41:00","inspection_id":"85748807","insp_unit_id":"208876690","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"132","insp_unit_license":"BE17669","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NKZX4TX4JJ199129","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-13T10:00:39.000000Z","updated_at":"2025-09-15T09:53:27.000000Z"}]},{"id":9547188,"change_date":"2025-08-29 21:40:00","inspection_id":"85634653","dot_number":"1677307","report_state":"MI","report_number":"TPDKH00158","insp_date":"2025-08-28 00:00:00","insp_start_time":"1120","insp_end_time":"1151","registration_date":null,"region":"ET","ci_status_code":"C","location":"2","location_desc":"BIG BEAVER\/LIVERNOIS","county_code_state":"MI","county_code":"125","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-08-29 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"62740","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":"1238318","transaction_code":"A","transaction_date":"2025-08-28 00:00:00","upload_date":"2025-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01677307","upload_search_indicator":null,"census_search_date":"2025-08-29 21:40:00","snet_input_date":"2025-08-28 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-08-29 21:40:00","insp_carrier_name":"STERLING SANITATION INC","insp_carrier_street":"37625 29 MILE RD","insp_carrier_city":"LENOX","insp_carrier_state":"MI","insp_carrier_zip_code":"48050","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-06T10:42:32.000000Z","updated_at":"2025-09-06T10:42:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15757948,"change_date":"2025-08-29 21:40:00","inspection_id":"85634653","insp_unit_id":"208661567","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"136","insp_unit_license":"BE17665","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NPAL00X17N662653","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:46:53.000000Z","updated_at":"2025-09-09T09:46:53.000000Z"}]},{"id":9238189,"change_date":"2025-07-24 21:41:00","inspection_id":"85309298","dot_number":"1677307","report_state":"MI","report_number":"SAHIW02877","insp_date":"2025-07-23 00:00:00","insp_start_time":"1705","insp_end_time":"1725","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"26 MILE RD @ I-94","county_code_state":"MI","county_code":"099","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/A\/C","shipping_paper_number":"149461","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":"2025-07-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"86000","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1232193","transaction_code":"A","transaction_date":"2025-07-23 00:00:00","upload_date":"2025-07-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01677307","upload_search_indicator":null,"census_search_date":"2025-07-24 21:41:00","snet_input_date":"2025-07-23 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-07-24 21:41:00","insp_carrier_name":"STERLING SANITATION INC","insp_carrier_street":"48655 GRATIOT","insp_carrier_city":"CHESTERFIELD","insp_carrier_state":"MI","insp_carrier_zip_code":"48051","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-07-27T10:41:55.000000Z","updated_at":"2025-07-30T10:00:52.000000Z","inspection_violations":[{"id":14956414,"change_date":"2025-07-24 21:41:00","inspection_id":"85309298","insp_violation_id":"267629243","seq_no":"1","part_no":"392","part_no_section":"16AD","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":"2025-07-27T10:44:16.000000Z","updated_at":"2025-07-28T10:48:54.000000Z","normalized_code":"39216AD"},{"id":14956415,"change_date":"2025-07-24 21:41:00","inspection_id":"85309298","insp_violation_id":"267629244","seq_no":"2","part_no":"392","part_no_section":"2-SLLFC","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":"2025-07-27T10:44:16.000000Z","updated_at":"2025-07-28T10:48:54.000000Z","normalized_code":"3922SLLFC"}],"inspection_per_units":[{"id":15201609,"change_date":"2025-07-24 21:41:00","inspection_id":"85309298","insp_unit_id":"208060735","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"BE17663","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NKZX4TX1PJ250076","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-27T09:46:32.000000Z","updated_at":"2025-07-28T09:46:05.000000Z"}]},{"id":8660986,"change_date":"2025-05-16 21:43:00","inspection_id":"84699619","dot_number":"1677307","report_state":"MI","report_number":"DUBOL00018","insp_date":"2025-05-15 00:00:00","insp_start_time":"1540","insp_end_time":"1625","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"E LINCOLN DR @ LONGFELLOW AVE","county_code_state":"MI","county_code":"125","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-16 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"57000","viol_total":"4","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1221667","transaction_code":"A","transaction_date":"2025-05-15 00:00:00","upload_date":"2025-05-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01677307","upload_search_indicator":null,"census_search_date":"2025-05-16 21:43:00","snet_input_date":"2025-05-15 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-05-16 21:43:00","insp_carrier_name":"STERLING SANITATION INC","insp_carrier_street":"48655 GRATIOT","insp_carrier_city":"CHESTERFIELD","insp_carrier_state":"MI","insp_carrier_zip_code":"48051","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-05-19T10:04:27.000000Z","updated_at":"2025-05-20T10:06:23.000000Z","inspection_violations":[{"id":13783029,"change_date":"2025-05-16 21:43:00","inspection_id":"84699619","insp_violation_id":"266283421","seq_no":"1","part_no":"392","part_no_section":"16-D","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4530909","created_at":"2025-05-19T10:37:02.000000Z","updated_at":"2025-05-20T10:27:55.000000Z","normalized_code":"39216D"},{"id":13783030,"change_date":"2025-05-16 21:43:00","inspection_id":"84699619","insp_violation_id":"266283422","seq_no":"2","part_no":"393","part_no_section":"9A-LBL","insp_viol_unit":"1","insp_unit_id":"206912933","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-19T10:37:02.000000Z","updated_at":"2025-05-20T10:27:55.000000Z","normalized_code":"3939ALBL"},{"id":13783031,"change_date":"2025-05-16 21:43:00","inspection_id":"84699619","insp_violation_id":"266283423","seq_no":"3","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"206912933","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-19T10:37:02.000000Z","updated_at":"2025-05-20T10:27:55.000000Z","normalized_code":"3939ALIL"},{"id":13783032,"change_date":"2025-05-16 21:43:00","inspection_id":"84699619","insp_violation_id":"266283424","seq_no":"4","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"1","insp_unit_id":"206912933","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-19T10:37:02.000000Z","updated_at":"2025-05-20T10:27:55.000000Z","normalized_code":"3939ALLPL"}],"inspection_per_units":[{"id":14146866,"change_date":"2025-05-16 21:43:00","inspection_id":"84699619","insp_unit_id":"206912933","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"116","insp_unit_license":"BE17675","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NKDLB0X8XJ835090","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-19T09:50:35.000000Z","updated_at":"2025-05-20T09:51:52.000000Z"}]},{"id":8393704,"change_date":"2025-04-16 21:41:00","inspection_id":"84418207","dot_number":"1677307","report_state":"MI","report_number":"POWED05234","insp_date":"2025-04-15 00:00:00","insp_start_time":"1410","insp_end_time":"1455","registration_date":null,"region":"ET","ci_status_code":"C","location":"212","location_desc":"PONTIAC SCALE S\/B","county_code_state":"MI","county_code":"125","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"S\/C","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"86000","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":"1217672","transaction_code":"A","transaction_date":"2025-04-15 00:00:00","upload_date":"2025-04-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01677307","upload_search_indicator":null,"census_search_date":"2025-04-16 21:41:00","snet_input_date":"2025-04-15 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-04-16 21:41:00","insp_carrier_name":"STERLING SANITATION INC","insp_carrier_street":"48655 GRATIOT","insp_carrier_city":"CHESTERFIELD","insp_carrier_state":"MI","insp_carrier_zip_code":"48051","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-04-19T10:19:27.000000Z","updated_at":"2025-04-20T10:25:48.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13625205,"change_date":"2025-04-16 21:41:00","inspection_id":"84418207","insp_unit_id":"206346287","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"138","insp_unit_license":"BE17663","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NKZX4TX1PJ250076","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-19T10:09:32.000000Z","updated_at":"2025-04-20T10:01:15.000000Z"}]},{"id":7749356,"change_date":"2025-01-30 21:41:00","inspection_id":"83740530","dot_number":"1677307","report_state":"MI","report_number":"COPEK03062","insp_date":"2025-01-30 00:00:00","insp_start_time":"1230","insp_end_time":"1250","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"EB M59 @ ROCHESTER RD","county_code_state":"MI","county_code":"125","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/A\/C","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":"N","pen_cen_match":null,"final_status_date":"2025-01-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"64000","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":"1208366","transaction_code":"A","transaction_date":"2025-01-30 00:00:00","upload_date":"2025-01-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01677307","upload_search_indicator":null,"census_search_date":"2025-01-30 21:41:00","snet_input_date":"2025-01-30 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-01-30 21:41:00","insp_carrier_name":"STERLING SANITATION INC","insp_carrier_street":"48655 GRATIOT","insp_carrier_city":"CHESTERFIELD","insp_carrier_state":"MI","insp_carrier_zip_code":"48051","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:59:08.000000Z","updated_at":"2025-03-17T20:59:08.000000Z","inspection_violations":[{"id":12108583,"change_date":"2025-01-30 21:41:00","inspection_id":"83740530","insp_violation_id":"264259933","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"205085253","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:04.000000Z","updated_at":"2025-03-17T22:05:04.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":12505745,"change_date":"2025-01-30 21:41:00","inspection_id":"83740530","insp_unit_id":"205085253","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"SKMD","insp_unit_company":"128","insp_unit_license":"BC35390","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NKDX4TXXDJ311821","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:53:03.000000Z","updated_at":"2025-03-17T23:53:03.000000Z"}]},{"id":7545645,"change_date":"2025-01-14 21:55:00","inspection_id":"83526622","dot_number":"1677307","report_state":"MI","report_number":"TPDSA00155","insp_date":"2025-01-02 00:00:00","insp_start_time":"0919","insp_end_time":"1022","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ROCHESTER RD\/I75 N","county_code_state":"MI","county_code":"125","insp_level_id":"2","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-01-03 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"55000","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":"1205614","transaction_code":"C","transaction_date":"2025-01-02 00:00:00","upload_date":"2025-01-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01677307","upload_search_indicator":null,"census_search_date":"2025-01-03 21:39:00","snet_input_date":"2025-01-02 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-01-03 21:39:00","insp_carrier_name":"STERLING SANITATION INC","insp_carrier_street":"48655 GRATIOT","insp_carrier_city":"CHESTERFIELD","insp_carrier_state":"MI","insp_carrier_zip_code":"48051","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:54:52.000000Z","updated_at":"2025-03-17T20:54:52.000000Z","inspection_violations":[{"id":11792357,"change_date":"2025-01-14 21:55:00","inspection_id":"83526622","insp_violation_id":"263996792","seq_no":"1","part_no":"392","part_no_section":"2-SLLCP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"25TR00042","created_at":"2025-03-17T22:03:27.000000Z","updated_at":"2025-03-17T22:03:27.000000Z","normalized_code":"3922SLLCP"},{"id":11792358,"change_date":"2025-01-14 21:55:00","inspection_id":"83526622","insp_violation_id":"263996793","seq_no":"2","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"204829491","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:27.000000Z","updated_at":"2025-03-17T22:03:27.000000Z","normalized_code":"3939ALHLI"}],"inspection_per_units":[{"id":12174396,"change_date":"2025-01-14 21:55:00","inspection_id":"83526622","insp_unit_id":"204829491","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"SKMD","insp_unit_company":"120","insp_unit_license":"BC35389","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NKDLB0X75J080270","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:23.000000Z","updated_at":"2025-03-17T23:49:23.000000Z"}]},{"id":6990200,"change_date":"2024-10-18 21:42:00","inspection_id":"82940431","dot_number":"1677307","report_state":"MI","report_number":"BARTT04629","insp_date":"2024-10-16 00:00:00","insp_start_time":"0725","insp_end_time":"0744","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"E\/BI69@BOWMAN","county_code_state":"MI","county_code":"087","insp_level_id":"3","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"127000","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":"1198469","transaction_code":"A","transaction_date":"2024-10-16 00:00:00","upload_date":"2024-10-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01677307","upload_search_indicator":null,"census_search_date":"2024-10-18 21:42:00","snet_input_date":"2024-10-16 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-10-18 21:42:00","insp_carrier_name":"STERLING SANITATION INC","insp_carrier_street":"48655 GRATIOT","insp_carrier_city":"CHESTERFIELD","insp_carrier_state":"MI","insp_carrier_zip_code":"48051","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:41:48.000000Z","updated_at":"2025-03-17T20:41:48.000000Z","inspection_violations":[{"id":10904636,"change_date":"2024-10-18 21:42:00","inspection_id":"82940431","insp_violation_id":"262428133","seq_no":"1","part_no":"392","part_no_section":"82DUMT","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4445297","created_at":"2025-03-17T21:58:54.000000Z","updated_at":"2025-03-17T21:58:54.000000Z","normalized_code":"39282DUMT"}],"inspection_per_units":[{"id":11274671,"change_date":"2024-10-18 21:42:00","inspection_id":"82940431","insp_unit_id":"203475509","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"129","insp_unit_license":"BD66383","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NKZX4EX6FJ419326","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:42.000000Z","updated_at":"2025-03-17T23:39:42.000000Z"},{"id":11274672,"change_date":"2024-10-18 21:42:00","inspection_id":"82940431","insp_unit_id":"203475510","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DUNRI","insp_unit_company":"129","insp_unit_license":"E987886","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1D9R02444XC232493","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:42.000000Z","updated_at":"2025-03-17T23:39:42.000000Z"}]},{"id":6490433,"change_date":"2024-09-17 21:45:00","inspection_id":"82408572","dot_number":"1677307","report_state":"MI","report_number":"NESBA01549","insp_date":"2024-08-13 00:00:00","insp_start_time":"0805","insp_end_time":"0825","registration_date":null,"region":"ET","ci_status_code":"C","location":"212","location_desc":"BALDWIN RD@N I-75","county_code_state":"MI","county_code":"125","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","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":"N","pen_cen_match":null,"final_status_date":"2024-08-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","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":"1190432","transaction_code":"C","transaction_date":"2024-08-13 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01677307","upload_search_indicator":null,"census_search_date":"2024-08-16 21:39:00","snet_input_date":"2024-08-13 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-08-16 21:39:00","insp_carrier_name":"STERLING SANITATION INC","insp_carrier_street":"48655 GRATIOT","insp_carrier_city":"CHESTERFIELD","insp_carrier_state":"MI","insp_carrier_zip_code":"48051","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:31:35.000000Z","updated_at":"2025-03-17T20:31:35.000000Z","inspection_violations":[{"id":10077598,"change_date":"2024-09-17 21:45:00","inspection_id":"82408572","insp_violation_id":"261869133","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202983101","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:44.000000Z","updated_at":"2025-03-17T21:54:44.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10462279,"change_date":"2024-09-17 21:45:00","inspection_id":"82408572","insp_unit_id":"202983101","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"130","insp_unit_license":"BC35384","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NKZX4EX1GJ465065","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:24.000000Z","updated_at":"2025-03-17T23:31:24.000000Z"}]},{"id":6335855,"change_date":"2024-09-17 21:45:00","inspection_id":"82243212","dot_number":"1677307","report_state":"MI","report_number":"COPEK02739","insp_date":"2024-07-26 00:00:00","insp_start_time":"0950","insp_end_time":"1020","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"NB I-75 @ UNIVERSITY","county_code_state":"MI","county_code":"125","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/A\/C","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":"N","pen_cen_match":null,"final_status_date":"2024-07-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"55000","viol_total":"3","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1188049","transaction_code":"C","transaction_date":"2024-07-26 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01677307","upload_search_indicator":null,"census_search_date":"2024-07-29 21:42:00","snet_input_date":"2024-07-26 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-07-29 21:42:00","insp_carrier_name":"STERLING SANITATION INC","insp_carrier_street":"48655 GRATIOT","insp_carrier_city":"CHESTERFIELD","insp_carrier_state":"MI","insp_carrier_zip_code":"48051","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:28:17.000000Z","updated_at":"2025-03-17T20:28:17.000000Z","inspection_violations":[{"id":9836378,"change_date":"2024-09-17 21:45:00","inspection_id":"82243212","insp_violation_id":"261859257","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4408968","created_at":"2025-03-17T21:53:33.000000Z","updated_at":"2025-03-17T21:53:33.000000Z","normalized_code":"39216A"},{"id":9836379,"change_date":"2024-09-17 21:45:00","inspection_id":"82243212","insp_violation_id":"261859258","seq_no":"2","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"202975578","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4409740","created_at":"2025-03-17T21:53:33.000000Z","updated_at":"2025-03-17T21:53:33.000000Z","normalized_code":"39375C"},{"id":9836380,"change_date":"2024-09-17 21:45:00","inspection_id":"82243212","insp_violation_id":"261859259","seq_no":"3","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"202975578","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:33.000000Z","updated_at":"2025-03-17T21:53:33.000000Z","normalized_code":"39021TB"}],"inspection_per_units":[{"id":10209444,"change_date":"2024-09-17 21:45:00","inspection_id":"82243212","insp_unit_id":"202975578","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"SKMD","insp_unit_company":"120","insp_unit_license":"BC35389","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NKDLB0X75J080270","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:43.000000Z","updated_at":"2025-03-17T23:28:43.000000Z"}]},{"id":6152456,"change_date":"2024-07-05 21:36:00","inspection_id":"82046492","dot_number":"1677307","report_state":"MI","report_number":"DAWDD03608","insp_date":"2024-07-05 00:00:00","insp_start_time":"0750","insp_end_time":"0810","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WB I-96 AT MERRIMAN","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"STERLING SANITATION INC","shipping_paper_number":"07052024","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":"2024-07-05 21:36:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1184888","transaction_code":"A","transaction_date":"2024-07-05 00:00:00","upload_date":"2024-07-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01677307","upload_search_indicator":null,"census_search_date":"2024-07-05 21:36:00","snet_input_date":"2024-07-05 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-07-05 21:36:00","insp_carrier_name":"STERLING SANITATION INC","insp_carrier_street":"48655 GRATIOT","insp_carrier_city":"CHESTERFIELD","insp_carrier_state":"MI","insp_carrier_zip_code":"48051","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:24:37.000000Z","updated_at":"2025-03-17T20:24:37.000000Z","inspection_violations":[{"id":9548588,"change_date":"2024-07-05 21:36:00","inspection_id":"82046492","insp_violation_id":"260481086","seq_no":"1","part_no":"392","part_no_section":"2","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":"2025-03-17T21:52:13.000000Z","updated_at":"2025-03-17T21:52:13.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9910482,"change_date":"2024-07-05 21:36:00","inspection_id":"82046492","insp_unit_id":"201746886","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"138","insp_unit_license":"BD66382","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NKZX4TX1PJ250076","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:45.000000Z","updated_at":"2025-03-17T23:25:45.000000Z"}]},{"id":6103294,"change_date":"2024-06-28 21:39:00","inspection_id":"81993684","dot_number":"1677307","report_state":"MI","report_number":"BALLB04742","insp_date":"2024-06-27 00:00:00","insp_start_time":"0858","insp_end_time":"0920","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"CAPITAL @ COOLIDGE","county_code_state":"MI","county_code":"125","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","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":"2024-06-28 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"64740","viol_total":"3","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1184084","transaction_code":"A","transaction_date":"2024-06-27 00:00:00","upload_date":"2024-06-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01677307","upload_search_indicator":null,"census_search_date":"2024-06-28 21:39:00","snet_input_date":"2024-06-27 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-06-28 21:39:00","insp_carrier_name":"STERLING SANITATION INC","insp_carrier_street":"48655 GRATIOT","insp_carrier_city":"CHESTERFIELD","insp_carrier_state":"MI","insp_carrier_zip_code":"48051","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:23:44.000000Z","updated_at":"2025-03-17T20:23:44.000000Z","inspection_violations":[{"id":9472676,"change_date":"2024-06-28 21:39:00","inspection_id":"81993684","insp_violation_id":"260373466","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:50.000000Z","updated_at":"2025-03-17T21:51:50.000000Z","normalized_code":"3922"},{"id":9472677,"change_date":"2024-06-28 21:39:00","inspection_id":"81993684","insp_violation_id":"260373467","seq_no":"2","part_no":"393","part_no_section":"203(c)","insp_viol_unit":"1","insp_unit_id":"201645922","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:50.000000Z","updated_at":"2025-03-17T21:51:50.000000Z","normalized_code":"393203C"},{"id":9472678,"change_date":"2024-06-28 21:39:00","inspection_id":"81993684","insp_violation_id":"260373468","seq_no":"3","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"201645922","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:50.000000Z","updated_at":"2025-03-17T21:51:50.000000Z","normalized_code":"39395F"}],"inspection_per_units":[{"id":9830406,"change_date":"2024-06-28 21:39:00","inspection_id":"81993684","insp_unit_id":"201645922","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"120","insp_unit_license":"BC67250","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NKDLB0X75J080270","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:51.000000Z","updated_at":"2025-03-17T23:24:51.000000Z"}]},{"id":5645308,"change_date":"2024-05-01 21:43:00","inspection_id":"81497323","dot_number":"1677307","report_state":"MI","report_number":"POWED04721","insp_date":"2024-04-30 00:00:00","insp_start_time":"1350","insp_end_time":"1425","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"NB I-275 @ CANTON REST AREA","county_code_state":"MI","county_code":"163","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-01 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"57000","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":"1176498","transaction_code":"A","transaction_date":"2024-04-30 00:00:00","upload_date":"2024-05-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01677307","upload_search_indicator":null,"census_search_date":"2024-05-01 21:43:00","snet_input_date":"2024-04-30 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-05-01 21:43:00","insp_carrier_name":"STERLING SANITATION INC","insp_carrier_street":"48655 GRATIOT","insp_carrier_city":"CHESTERFIELD","insp_carrier_state":"MI","insp_carrier_zip_code":"48051","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:14:41.000000Z","updated_at":"2025-03-17T20:14:41.000000Z","inspection_violations":[{"id":8730382,"change_date":"2024-05-01 21:43:00","inspection_id":"81497323","insp_violation_id":"259254986","seq_no":"1","part_no":"393","part_no_section":"134","insp_viol_unit":"1","insp_unit_id":"200676055","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:48:14.000000Z","updated_at":"2025-03-17T21:48:14.000000Z","normalized_code":"393134"}],"inspection_per_units":[{"id":9093157,"change_date":"2024-05-01 21:43:00","inspection_id":"81497323","insp_unit_id":"200676055","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"116","insp_unit_license":"BC35393","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NKDLB0X8XJ835090","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:36.000000Z","updated_at":"2025-03-17T23:17:36.000000Z"}]},{"id":4977466,"change_date":"2024-02-05 21:40:00","inspection_id":"80768740","dot_number":"1677307","report_state":"MI","report_number":"DAWDD03294","insp_date":"2024-02-02 00:00:00","insp_start_time":"0752","insp_end_time":"0812","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WB I-96 AT FARMINGTON","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"STERLING SANITATION INC","shipping_paper_number":"02022024","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":"2024-02-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1162974","transaction_code":"A","transaction_date":"2024-02-02 00:00:00","upload_date":"2024-02-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01677307","upload_search_indicator":null,"census_search_date":"2024-02-05 21:40:00","snet_input_date":"2024-02-02 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-02-05 21:40:00","insp_carrier_name":"STERLING SANITATION INC","insp_carrier_street":"48655 GRATIOT","insp_carrier_city":"CHESTERFIELD","insp_carrier_state":"MI","insp_carrier_zip_code":"48051","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:01:16.000000Z","updated_at":"2025-03-17T20:01:16.000000Z","inspection_violations":[{"id":7667112,"change_date":"2024-02-05 21:40:00","inspection_id":"80768740","insp_violation_id":"257666670","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:02.000000Z","updated_at":"2025-03-17T21:43:02.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8011058,"change_date":"2024-02-05 21:40:00","inspection_id":"80768740","insp_unit_id":"199269739","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"138","insp_unit_license":"BD66382","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NKZX4TX1PJ250076","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:37.000000Z","updated_at":"2025-03-17T23:07:37.000000Z"}]},{"id":4885417,"change_date":"2024-01-23 21:45:00","inspection_id":"80667822","dot_number":"1677307","report_state":"MI","report_number":"KERSD00234","insp_date":"2024-01-22 00:00:00","insp_start_time":"1335","insp_end_time":"1350","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-75 NB @ WARREN","county_code_state":"MI","county_code":"163","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SC","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":"2024-01-23 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","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":"1161244","transaction_code":"A","transaction_date":"2024-01-22 00:00:00","upload_date":"2024-01-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01677307","upload_search_indicator":null,"census_search_date":"2024-01-23 21:45:00","snet_input_date":"2024-01-22 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-01-23 21:45:00","insp_carrier_name":"STERLING SANITATION INC","insp_carrier_street":"48655 GRATIOT","insp_carrier_city":"CHESTERFIELD","insp_carrier_state":"MI","insp_carrier_zip_code":"48051","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:59:36.000000Z","updated_at":"2025-03-17T19:59:36.000000Z","inspection_violations":[{"id":7527312,"change_date":"2024-01-23 21:45:00","inspection_id":"80667822","insp_violation_id":"257455587","seq_no":"1","part_no":"393","part_no_section":"134","insp_viol_unit":"1","insp_unit_id":"199072748","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:42:20.000000Z","updated_at":"2025-03-17T21:42:20.000000Z","normalized_code":"393134"}],"inspection_per_units":[{"id":7860625,"change_date":"2024-01-23 21:45:00","inspection_id":"80667822","insp_unit_id":"199072748","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"130","insp_unit_license":"BC35384","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NKZX4EX1GJ465065","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:16.000000Z","updated_at":"2025-03-17T23:06:16.000000Z"}]},{"id":4745871,"change_date":"2024-01-02 21:43:00","inspection_id":"80515355","dot_number":"1677307","report_state":"MI","report_number":"CTPRW00164","insp_date":"2024-01-02 00:00:00","insp_start_time":"1020","insp_end_time":"1040","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"21 MILE RD @ BRIAR TOWNE","county_code_state":"MI","county_code":"099","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":"N","pen_cen_match":null,"final_status_date":"2024-01-02 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"47000","viol_total":"7","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1159082","transaction_code":"A","transaction_date":"2024-01-02 00:00:00","upload_date":"2024-01-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01677307","upload_search_indicator":null,"census_search_date":"2024-01-02 21:43:00","snet_input_date":"2024-01-02 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-01-02 21:43:00","insp_carrier_name":"STERLING SANITATION INC","insp_carrier_street":"48655 GRATIOT","insp_carrier_city":"CHESTERFIELD","insp_carrier_state":"MI","insp_carrier_zip_code":"48051","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:56:52.000000Z","updated_at":"2025-03-17T19:56:52.000000Z","inspection_violations":[{"id":7324180,"change_date":"2024-01-02 21:43:00","inspection_id":"80515355","insp_violation_id":"257141913","seq_no":"1","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"198768205","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:23.000000Z","updated_at":"2025-03-17T21:41:23.000000Z","normalized_code":"39021TB"},{"id":7324181,"change_date":"2024-01-02 21:43:00","inspection_id":"80515355","insp_violation_id":"257141914","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"198768205","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:23.000000Z","updated_at":"2025-03-17T21:41:23.000000Z","normalized_code":"39617C"},{"id":7324182,"change_date":"2024-01-02 21:43:00","inspection_id":"80515355","insp_violation_id":"257141915","seq_no":"3","part_no":"393","part_no_section":"43","insp_viol_unit":"2","insp_unit_id":"198768206","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:41:23.000000Z","updated_at":"2025-03-17T21:41:23.000000Z","normalized_code":"39343"},{"id":7324183,"change_date":"2024-01-02 21:43:00","inspection_id":"80515355","insp_violation_id":"257141916","seq_no":"4","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"198768206","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:23.000000Z","updated_at":"2025-03-17T21:41:23.000000Z","normalized_code":"39617C"},{"id":7324184,"change_date":"2024-01-02 21:43:00","inspection_id":"80515355","insp_violation_id":"257141917","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"198768206","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:23.000000Z","updated_at":"2025-03-17T21:41:23.000000Z","normalized_code":"3939A"},{"id":7324185,"change_date":"2024-01-02 21:43:00","inspection_id":"80515355","insp_violation_id":"257141918","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"198768206","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:23.000000Z","updated_at":"2025-03-17T21:41:23.000000Z","normalized_code":"3939A"},{"id":7324186,"change_date":"2024-01-02 21:43:00","inspection_id":"80515355","insp_violation_id":"257141919","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"198768206","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:41:23.000000Z","updated_at":"2025-03-17T21:41:23.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":7634236,"change_date":"2024-01-02 21:43:00","inspection_id":"80515355","insp_unit_id":"198768205","insp_unit_type_id":"3","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1","insp_unit_license":"BD66364","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVACXDC25HN87128","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:14.000000Z","updated_at":"2025-03-17T23:04:14.000000Z"},{"id":7634237,"change_date":"2024-01-02 21:43:00","inspection_id":"80515355","insp_unit_id":"198768206","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"C+W","insp_unit_company":"T04","insp_unit_license":"E790079","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"46CCT1221MM038615","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:14.000000Z","updated_at":"2025-03-17T23:04:14.000000Z"}]},{"id":4632536,"change_date":"2023-12-14 21:43:00","inspection_id":"80391628","dot_number":"1677307","report_state":"MI","report_number":"DAWDD03193","insp_date":"2023-12-13 00:00:00","insp_start_time":"0758","insp_end_time":"0828","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"NB I-275 AT 6 MILE RD","county_code_state":"MI","county_code":"163","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"STERLING SANITATION INC","shipping_paper_number":"12132023","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":"2023-12-14 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"86000","viol_total":"3","oos_total":"1","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1157294","transaction_code":"A","transaction_date":"2023-12-13 00:00:00","upload_date":"2023-12-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01677307","upload_search_indicator":null,"census_search_date":"2023-12-14 21:43:00","snet_input_date":"2023-12-13 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-12-14 21:43:00","insp_carrier_name":"STERLING SANITATION INC","insp_carrier_street":"48655 GRATIOT","insp_carrier_city":"CHESTERFIELD","insp_carrier_state":"MI","insp_carrier_zip_code":"48051","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:54:34.000000Z","updated_at":"2025-03-17T19:54:34.000000Z","inspection_violations":[{"id":7159878,"change_date":"2023-12-14 21:43:00","inspection_id":"80391628","insp_violation_id":"256888509","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:33.000000Z","updated_at":"2025-03-17T21:40:33.000000Z","normalized_code":"3922"},{"id":7159879,"change_date":"2023-12-14 21:43:00","inspection_id":"80391628","insp_violation_id":"256888510","seq_no":"2","part_no":"392","part_no_section":"2","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":"2025-03-17T21:40:33.000000Z","updated_at":"2025-03-17T21:40:33.000000Z","normalized_code":"3922"},{"id":7159880,"change_date":"2023-12-14 21:43:00","inspection_id":"80391628","insp_violation_id":"256888511","seq_no":"3","part_no":"393","part_no_section":"134(b)(3)","insp_viol_unit":"1","insp_unit_id":"198511397","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:40:33.000000Z","updated_at":"2025-03-17T21:40:33.000000Z","normalized_code":"393134B3"}],"inspection_per_units":[{"id":7450971,"change_date":"2023-12-14 21:43:00","inspection_id":"80391628","insp_unit_id":"198511397","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"138","insp_unit_license":"BD66382","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NKZX4TX1PJ250076","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:38.000000Z","updated_at":"2025-03-17T23:02:38.000000Z"}]},{"id":4443206,"change_date":"2023-11-16 21:43:00","inspection_id":"80183517","dot_number":"1677307","report_state":"MI","report_number":"WATTR03628","insp_date":"2023-11-15 00:00:00","insp_start_time":"1419","insp_end_time":"1510","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"23 MILE RD","county_code_state":"MI","county_code":"099","insp_level_id":"2","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-16 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","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":"1153736","transaction_code":"A","transaction_date":"2023-11-15 00:00:00","upload_date":"2023-11-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01677307","upload_search_indicator":null,"census_search_date":"2023-11-16 21:43:00","snet_input_date":"2023-11-15 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-11-16 21:43:00","insp_carrier_name":"STERLING SANITATION INC","insp_carrier_street":"48655 GRATIOT","insp_carrier_city":"CHESTERFIELD","insp_carrier_state":"MI","insp_carrier_zip_code":"48051","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:51:02.000000Z","updated_at":"2025-03-17T19:51:02.000000Z","inspection_violations":[{"id":6877071,"change_date":"2023-11-16 21:43:00","inspection_id":"80183517","insp_violation_id":"256442260","seq_no":"1","part_no":"391","part_no_section":"45(b)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4291054","created_at":"2025-03-17T21:39:07.000000Z","updated_at":"2025-03-17T21:39:07.000000Z","normalized_code":"39145B"},{"id":6877072,"change_date":"2023-11-16 21:43:00","inspection_id":"80183517","insp_violation_id":"256442261","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198102962","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:07.000000Z","updated_at":"2025-03-17T21:39:07.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7145469,"change_date":"2023-11-16 21:43:00","inspection_id":"80183517","insp_unit_id":"198102962","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"129","insp_unit_license":"BC35391","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NKZX4EX6FJ419326","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:01.000000Z","updated_at":"2025-03-17T23:00:01.000000Z"}]},{"id":3632669,"change_date":"2023-08-29 21:42:00","inspection_id":"79283018","dot_number":"1677307","report_state":"MI","report_number":"LPDAS00014","insp_date":"2023-07-28 00:00:00","insp_start_time":"1221","insp_end_time":"1309","registration_date":null,"region":"ET","ci_status_code":"C","location":"48150","location_desc":"LPD SCALES - 32600 GLENDALE","county_code_state":"MI","county_code":"163","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"FOUNDRY SAND","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":"2023-07-31 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"86000","viol_total":"9","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"9","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1137587","transaction_code":"C","transaction_date":"2023-07-28 00:00:00","upload_date":"2023-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01677307","upload_search_indicator":null,"census_search_date":"2023-07-31 21:41:00","snet_input_date":"2023-07-28 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-07-31 21:41:00","insp_carrier_name":"STERLING SANITATION INC","insp_carrier_street":"48655 GRATIOT","insp_carrier_city":"CHESTERFIELD","insp_carrier_state":"MI","insp_carrier_zip_code":"48051","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:34:35.000000Z","updated_at":"2025-03-17T19:34:35.000000Z","inspection_violations":[{"id":5600847,"change_date":"2023-08-29 21:42:00","inspection_id":"79283018","insp_violation_id":"254953141","seq_no":"1","part_no":"393","part_no_section":"209(d)","insp_viol_unit":"1","insp_unit_id":"196788527","insp_violation_category_id":"21","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:33:00.000000Z","updated_at":"2025-03-17T21:33:00.000000Z","normalized_code":"393209D"},{"id":5600848,"change_date":"2023-08-29 21:42:00","inspection_id":"79283018","insp_violation_id":"254953142","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"196788527","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:00.000000Z","updated_at":"2025-03-17T21:33:00.000000Z","normalized_code":"39347E"},{"id":5600849,"change_date":"2023-08-29 21:42:00","inspection_id":"79283018","insp_violation_id":"254953143","seq_no":"3","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"196788527","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:00.000000Z","updated_at":"2025-03-17T21:33:00.000000Z","normalized_code":"39353B"},{"id":5600850,"change_date":"2023-08-29 21:42:00","inspection_id":"79283018","insp_violation_id":"254953144","seq_no":"4","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"196788527","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:00.000000Z","updated_at":"2025-03-17T21:33:00.000000Z","normalized_code":"39347E"},{"id":5600851,"change_date":"2023-08-29 21:42:00","inspection_id":"79283018","insp_violation_id":"254953145","seq_no":"5","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"196788527","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:33:00.000000Z","updated_at":"2025-03-17T21:33:00.000000Z","normalized_code":"3963A1"},{"id":5600852,"change_date":"2023-08-29 21:42:00","inspection_id":"79283018","insp_violation_id":"254953146","seq_no":"6","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"196788527","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:00.000000Z","updated_at":"2025-03-17T21:33:00.000000Z","normalized_code":"39378"},{"id":5600853,"change_date":"2023-08-29 21:42:00","inspection_id":"79283018","insp_violation_id":"254953147","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196788527","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:00.000000Z","updated_at":"2025-03-17T21:33:00.000000Z","normalized_code":"3939A"},{"id":5600854,"change_date":"2023-08-29 21:42:00","inspection_id":"79283018","insp_violation_id":"254953148","seq_no":"8","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196788527","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:00.000000Z","updated_at":"2025-03-17T21:33:00.000000Z","normalized_code":"3922"},{"id":5600855,"change_date":"2023-08-29 21:42:00","inspection_id":"79283018","insp_violation_id":"254953149","seq_no":"9","part_no":"390","part_no_section":"19(a)(2)","insp_viol_unit":"1","insp_unit_id":"196788527","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:00.000000Z","updated_at":"2025-03-17T21:33:00.000000Z","normalized_code":"39019A2"}],"inspection_per_units":[{"id":5840647,"change_date":"2023-08-29 21:42:00","inspection_id":"79283018","insp_unit_id":"196788527","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"BC35396","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NKZX4TX6HJ120246","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:08.000000Z","updated_at":"2025-03-17T22:49:08.000000Z"}]},{"id":2708645,"change_date":"2023-03-31 21:41:00","inspection_id":"78240863","dot_number":"1677307","report_state":"MI","report_number":"BARTT03764","insp_date":"2023-03-31 00:00:00","insp_start_time":"1450","insp_end_time":"1513","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"E\/BI69@BOWMAN","county_code_state":"MI","county_code":"087","insp_level_id":"2","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-31 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"37500","viol_total":"3","oos_total":"1","driver_viol_total":"3","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1119991","transaction_code":"A","transaction_date":"2023-03-31 00:00:00","upload_date":"2023-03-31 00:00:00","upload_first_byte":"0","upload_dot_number":"01677307","upload_search_indicator":null,"census_search_date":"2023-03-31 21:41:00","snet_input_date":"2023-03-31 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-03-31 21:41:00","insp_carrier_name":"STERLING SANITATION INC","insp_carrier_street":"48655 GRATIOT","insp_carrier_city":"CHESTERFIELD","insp_carrier_state":"MI","insp_carrier_zip_code":"48051","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:16:35.000000Z","updated_at":"2025-03-17T19:16:35.000000Z","inspection_violations":[{"id":4160115,"change_date":"2023-03-31 21:41:00","inspection_id":"78240863","insp_violation_id":"251986817","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4191934","created_at":"2025-03-17T21:26:31.000000Z","updated_at":"2025-03-17T21:26:31.000000Z","normalized_code":"39216A"},{"id":4160116,"change_date":"2023-03-31 21:41:00","inspection_id":"78240863","insp_violation_id":"251986818","seq_no":"2","part_no":"391","part_no_section":"45(b)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4191934","created_at":"2025-03-17T21:26:31.000000Z","updated_at":"2025-03-17T21:26:31.000000Z","normalized_code":"39145B"},{"id":4160117,"change_date":"2023-03-31 21:41:00","inspection_id":"78240863","insp_violation_id":"251986819","seq_no":"3","part_no":"391","part_no_section":"11(b)(4)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:31.000000Z","updated_at":"2025-03-17T21:26:31.000000Z","normalized_code":"39111B4"}],"inspection_per_units":[{"id":4359070,"change_date":"2023-03-31 21:41:00","inspection_id":"78240863","insp_unit_id":"194170255","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"0","insp_unit_license":"BC35378","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FV6HJAA5XHA55627","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:19.000000Z","updated_at":"2025-03-17T22:37:19.000000Z"},{"id":4359071,"change_date":"2023-03-31 21:41:00","inspection_id":"78240863","insp_unit_id":"194170256","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CW","insp_unit_company":"0","insp_unit_license":"D500812","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"46CCT16306M003800","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:19.000000Z","updated_at":"2025-03-17T22:37:19.000000Z"}]},{"id":2656416,"change_date":"2023-03-24 21:41:00","inspection_id":"78180487","dot_number":"1677307","report_state":"MI","report_number":"COPEK01985","insp_date":"2023-03-23 00:00:00","insp_start_time":"1225","insp_end_time":"1250","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"EB I-94 @ OLD SCALES","county_code_state":"MI","county_code":"099","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/A\/C","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":"2023-03-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"64000","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":"1119167","transaction_code":"A","transaction_date":"2023-03-23 00:00:00","upload_date":"2023-03-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01677307","upload_search_indicator":null,"census_search_date":"2023-03-24 21:41:00","snet_input_date":"2023-03-23 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-03-24 21:41:00","insp_carrier_name":"STERLING SANITATION INC","insp_carrier_street":"48655 GRATIOT","insp_carrier_city":"CHESTERFIELD","insp_carrier_state":"MI","insp_carrier_zip_code":"48051","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:15:34.000000Z","updated_at":"2025-03-17T19:15:34.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4276729,"change_date":"2023-03-24 21:41:00","inspection_id":"78180487","insp_unit_id":"194054672","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"114","insp_unit_license":"BC35387","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NKDLB0X6XJ817946","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:41.000000Z","updated_at":"2025-03-17T22:36:41.000000Z"}]},{"id":1807224,"change_date":"2022-11-23 21:40:00","inspection_id":"77211615","dot_number":"1677307","report_state":"MI","report_number":"COPEK01747","insp_date":"2022-11-21 00:00:00","insp_start_time":"1330","insp_end_time":"1350","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WB I-94 @ 23 MILE RD","county_code_state":"MI","county_code":"099","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/A\/C","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":"N","pen_cen_match":null,"final_status_date":"2022-11-23 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"55000","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":"1103046","transaction_code":"A","transaction_date":"2022-11-21 00:00:00","upload_date":"2022-11-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01677307","upload_search_indicator":null,"census_search_date":"2022-11-23 21:40:00","snet_input_date":"2022-11-21 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-11-23 21:40:00","insp_carrier_name":"STERLING SANITATION INC","insp_carrier_street":"48655 GRATIOT","insp_carrier_city":"CHESTERFIELD","insp_carrier_state":"MI","insp_carrier_zip_code":"48051","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:59:58.000000Z","updated_at":"2025-03-17T18:59:58.000000Z","inspection_violations":[{"id":2825947,"change_date":"2022-11-23 21:40:00","inspection_id":"77211615","insp_violation_id":"249768963","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"192111144","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:25.000000Z","updated_at":"2025-03-17T21:20:25.000000Z","normalized_code":"3922"},{"id":2825948,"change_date":"2022-11-23 21:40:00","inspection_id":"77211615","insp_violation_id":"249768964","seq_no":"2","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"192111144","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:25.000000Z","updated_at":"2025-03-17T21:20:25.000000Z","normalized_code":"39375C"}],"inspection_per_units":[{"id":2907088,"change_date":"2022-11-23 21:40:00","inspection_id":"77211615","insp_unit_id":"192111144","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"117","insp_unit_license":"BC35392","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3BKDLB0X8YF840080","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:54.000000Z","updated_at":"2025-03-17T22:26:54.000000Z"}]},{"id":697372,"change_date":"2022-06-27 21:40:00","inspection_id":"75923497","dot_number":"1677307","report_state":"MI","report_number":"MALIK01124","insp_date":"2022-06-21 00:00:00","insp_start_time":"1010","insp_end_time":"1040","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"W\/B M-59 @ SQUIRREL RD","county_code_state":"MI","county_code":"125","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","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":"2022-06-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"64000","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":"1081264","transaction_code":"A","transaction_date":"2022-06-21 00:00:00","upload_date":"2022-06-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01677307","upload_search_indicator":null,"census_search_date":"2022-06-27 21:40:00","snet_input_date":"2022-06-21 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-06-27 21:40:00","insp_carrier_name":"STERLING SANITATION INC","insp_carrier_street":"48655 GRATIOT","insp_carrier_city":"CHESTERFIELD","insp_carrier_state":"MI","insp_carrier_zip_code":"48051","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:39:52.000000Z","updated_at":"2025-03-17T18:39:52.000000Z","inspection_violations":[{"id":1094285,"change_date":"2022-06-27 21:40:00","inspection_id":"75923497","insp_violation_id":"246726798","seq_no":"1","part_no":"393","part_no_section":"134","insp_viol_unit":"1","insp_unit_id":"189471215","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:12:07.000000Z","updated_at":"2025-03-17T21:12:07.000000Z","normalized_code":"393134"}],"inspection_per_units":[{"id":1120323,"change_date":"2022-06-27 21:40:00","inspection_id":"75923497","insp_unit_id":"189471215","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"114","insp_unit_license":"BC35387","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NKDLB0X6XJ817946","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:06.000000Z","updated_at":"2025-03-17T22:15:06.000000Z"}]},{"id":482495,"change_date":"2022-06-09 21:42:00","inspection_id":"75668477","dot_number":"1677307","report_state":"MI","report_number":"COPEK01380","insp_date":"2022-05-23 00:00:00","insp_start_time":"1410","insp_end_time":"1435","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"EB I-94 @ 23 MILE RD","county_code_state":"MI","county_code":"099","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/A\/C","shipping_paper_number":"89124","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":"2022-05-25 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"64000","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":"1076985","transaction_code":"C","transaction_date":"2022-05-23 00:00:00","upload_date":"2022-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01677307","upload_search_indicator":null,"census_search_date":"2022-05-25 21:42:00","snet_input_date":"2022-05-23 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-05-25 21:42:00","insp_carrier_name":"STERLING SANITATION INC","insp_carrier_street":"48655 GRATIOT","insp_carrier_city":"CHESTERFIELD","insp_carrier_state":"MI","insp_carrier_zip_code":"48051","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:36:17.000000Z","updated_at":"2025-03-17T18:36:17.000000Z","inspection_violations":[{"id":763096,"change_date":"2022-06-09 21:42:00","inspection_id":"75668477","insp_violation_id":"246332488","seq_no":"1","part_no":"392","part_no_section":"2","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":"2025-03-17T21:10:39.000000Z","updated_at":"2025-03-17T21:10:39.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":775916,"change_date":"2022-06-09 21:42:00","inspection_id":"75668477","insp_unit_id":"189144780","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"128","insp_unit_license":"BC35390","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NKDX4TXXDJ311821","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:58.000000Z","updated_at":"2025-03-17T22:12:58.000000Z"}]},{"id":243086,"change_date":"2022-06-09 21:42:00","inspection_id":"75382934","dot_number":"1677307","report_state":"MI","report_number":"LITTJ03954","insp_date":"2022-04-21 00:00:00","insp_start_time":"1315","insp_end_time":"1330","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M-59 @ ADAMS","county_code_state":"MI","county_code":"125","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","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":"N","pen_cen_match":null,"final_status_date":"2022-04-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"64000","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":"1073091","transaction_code":"C","transaction_date":"2022-04-21 00:00:00","upload_date":"2022-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01677307","upload_search_indicator":null,"census_search_date":"2022-04-25 21:41:00","snet_input_date":"2022-04-21 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-04-25 21:41:00","insp_carrier_name":"STERLING SANITATION INC","insp_carrier_street":"48655 GRATIOT","insp_carrier_city":"CHESTERFIELD","insp_carrier_state":"MI","insp_carrier_zip_code":"48051","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:31:51.000000Z","updated_at":"2025-03-17T18:31:51.000000Z","inspection_violations":[{"id":373437,"change_date":"2022-06-09 21:42:00","inspection_id":"75382934","insp_violation_id":"246336797","seq_no":"1","part_no":"393","part_no_section":"134","insp_viol_unit":"1","insp_unit_id":"189147937","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:08:49.000000Z","updated_at":"2025-03-17T21:08:49.000000Z","normalized_code":"393134"}],"inspection_per_units":[{"id":394226,"change_date":"2022-06-09 21:42:00","inspection_id":"75382934","insp_unit_id":"189147937","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"114","insp_unit_license":"BC35387","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NKDLB0X6XJ817946","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:37.000000Z","updated_at":"2025-03-17T22:10:37.000000Z"}]},{"id":43901,"change_date":"2022-03-25 21:31:00","inspection_id":"75141420","dot_number":"1677307","report_state":"MI","report_number":"WATTR03002","insp_date":"2022-03-24 00:00:00","insp_start_time":"1244","insp_end_time":"1420","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"UNIVERSITY DR","county_code_state":"MI","county_code":"125","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-03-25 21:31:00","post_acc_ind":"N","gross_comb_veh_wt":"86000","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":"1069246","transaction_code":"A","transaction_date":"2022-03-24 00:00:00","upload_date":"2022-03-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01677307","upload_search_indicator":null,"census_search_date":"2022-03-25 21:31:00","snet_input_date":"2022-03-24 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-03-25 21:31:00","insp_carrier_name":"STERLING SANITATION INC","insp_carrier_street":"48655 GRATIOT","insp_carrier_city":"CHESTERFIELD","insp_carrier_state":"MI","insp_carrier_zip_code":"48051","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:28:24.000000Z","updated_at":"2025-03-17T18:28:24.000000Z","inspection_violations":[{"id":61806,"change_date":"2022-03-25 21:31:00","inspection_id":"75141420","insp_violation_id":"244782401","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4030138","created_at":"2025-03-17T21:07:25.000000Z","updated_at":"2025-03-17T21:07:25.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":70794,"change_date":"2022-03-25 21:31:00","inspection_id":"75141420","insp_unit_id":"187825160","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"132","insp_unit_license":"BC35382","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NKZX4TX4JJ199129","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:42.000000Z","updated_at":"2025-03-17T22:08:42.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1677307\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1677307\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1677307\/inspections?page=1","label":"1","page":1,"active":true},{"url":null,"label":"Next »","page":null,"active":false}],"next_page_url":null,"path":"https:\/\/searchcarriers.com\/company\/1677307\/inspections","per_page":100,"prev_page_url":null,"to":32,"total":32}