{"current_page":1,"data":[{"id":12496647,"change_date":"2026-07-20 21:39:00","inspection_id":"88460253","dot_number":"1702320","report_state":"MI","report_number":"LAUEJ02424","insp_date":"2026-07-20 00:00:00","insp_start_time":"1145","insp_end_time":"1200","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"097","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":"U","pen_cen_match":"I","final_status_date":"2026-07-20 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"3794671","transaction_code":"A","transaction_date":"2026-07-20 00:00:00","upload_date":"2026-07-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01702320","upload_search_indicator":null,"census_search_date":"2026-07-20 21:39:00","snet_input_date":"2026-07-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-20 21:39:00","insp_carrier_name":"SUN VALLEY FOODS COMPANY","insp_carrier_street":"14401 DEXTER DRIVE","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48238","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-23T09:41:14.000000Z","updated_at":"2026-07-31T09:30:45.000000Z","inspection_violations":[{"id":21754800,"change_date":"2026-07-20 21:39:00","inspection_id":"88460253","insp_violation_id":"275611968","seq_no":"1","part_no":"392","part_no_section":"2-DMOVE","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-23T10:01:28.000000Z","updated_at":"2026-07-31T09:42:50.000000Z","normalized_code":"3922DMOVE"}],"inspection_per_units":[{"id":21703717,"change_date":"2026-07-20 21:39:00","inspection_id":"88460253","insp_unit_id":"214712846","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"RB87741","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN2GY1LM019506","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-23T09:17:32.000000Z","updated_at":"2026-07-31T09:01:57.000000Z"},{"id":21703718,"change_date":"2026-07-20 21:39:00","inspection_id":"88460253","insp_unit_id":"214712847","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":null,"insp_unit_license":"E596941","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532K9NJ804006","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-23T09:17:32.000000Z","updated_at":"2026-07-31T09:01:57.000000Z"}]},{"id":12384807,"change_date":"2026-07-08 21:41:00","inspection_id":"88347931","dot_number":"1702320","report_state":"MI","report_number":"DELMT02792","insp_date":"2026-07-08 00:00:00","insp_start_time":"1440","insp_end_time":"1538","registration_date":null,"region":"ED","ci_status_code":"C","location":"131","location_desc":"MI","county_code_state":"MI","county_code":"075","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SUN VALLEY FOODS","shipping_paper_number":"340418","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"10","oos_total":"5","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"10","vehicle_oos_total":"5","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3710586","transaction_code":"A","transaction_date":"2026-07-08 00:00:00","upload_date":"2026-07-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01702320","upload_search_indicator":null,"census_search_date":"2026-07-08 21:41:00","snet_input_date":"2026-07-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-08 21:41:00","insp_carrier_name":"SUN VALLEY FOODS COMPANY","insp_carrier_street":"14401 DEXTER DRIVE","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48238","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-11T09:39:40.000000Z","updated_at":"2026-07-19T09:31:09.000000Z","inspection_violations":[{"id":21552143,"change_date":"2026-07-08 21:41:00","inspection_id":"88347931","insp_violation_id":"275359449","seq_no":"6","part_no":"393","part_no_section":"207F-SDAS","insp_viol_unit":"2","insp_unit_id":"214498540","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-07-11T09:57:02.000000Z","updated_at":"2026-07-19T09:43:11.000000Z","normalized_code":"393207FSDAS"},{"id":21552144,"change_date":"2026-07-08 21:41:00","inspection_id":"88347931","insp_violation_id":"275359450","seq_no":"7","part_no":"393","part_no_section":"207F-SDAS","insp_viol_unit":"2","insp_unit_id":"214498540","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-07-11T09:57:02.000000Z","updated_at":"2026-07-19T09:43:11.000000Z","normalized_code":"393207FSDAS"},{"id":21552136,"change_date":"2026-07-08 21:41:00","inspection_id":"88347931","insp_violation_id":"275359442","seq_no":"1","part_no":"393","part_no_section":"11B-CSLRR","insp_viol_unit":"2","insp_unit_id":"214498540","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-11T09:57:02.000000Z","updated_at":"2026-07-19T09:43:11.000000Z","normalized_code":"39311BCSLRR"},{"id":21552137,"change_date":"2026-07-08 21:41:00","inspection_id":"88347931","insp_violation_id":"275359443","seq_no":"2","part_no":"393","part_no_section":"11B-CSURR","insp_viol_unit":"2","insp_unit_id":"214498540","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-11T09:57:02.000000Z","updated_at":"2026-07-19T09:43:11.000000Z","normalized_code":"39311BCSURR"},{"id":21552138,"change_date":"2026-07-08 21:41:00","inspection_id":"88347931","insp_violation_id":"275359444","seq_no":"3","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"214498539","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-11T09:57:02.000000Z","updated_at":"2026-07-19T09:43:11.000000Z","normalized_code":"39347E"},{"id":21552139,"change_date":"2026-07-08 21:41:00","inspection_id":"88347931","insp_violation_id":"275359445","seq_no":"4","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"2","insp_unit_id":"214498540","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-11T09:57:02.000000Z","updated_at":"2026-07-19T09:43:11.000000Z","normalized_code":"39353BB"},{"id":21552140,"change_date":"2026-07-08 21:41:00","inspection_id":"88347931","insp_violation_id":"275359446","seq_no":"5","part_no":"393","part_no_section":"207F-SDAS","insp_viol_unit":"2","insp_unit_id":"214498540","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4722489","created_at":"2026-07-11T09:57:02.000000Z","updated_at":"2026-07-19T09:43:11.000000Z","normalized_code":"393207FSDAS"},{"id":21552141,"change_date":"2026-07-08 21:41:00","inspection_id":"88347931","insp_violation_id":"275359447","seq_no":"9","part_no":"393","part_no_section":"11A1-CSLRR","insp_viol_unit":"1","insp_unit_id":"214498539","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-11T09:57:02.000000Z","updated_at":"2026-07-19T09:43:11.000000Z","normalized_code":"39311A1CSLRR"},{"id":21552142,"change_date":"2026-07-08 21:41:00","inspection_id":"88347931","insp_violation_id":"275359448","seq_no":"10","part_no":"396","part_no_section":"3A1-BARS","insp_viol_unit":"2","insp_unit_id":"214498540","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-07-11T09:57:02.000000Z","updated_at":"2026-07-19T09:43:11.000000Z","normalized_code":"3963A1BARS"},{"id":21552145,"change_date":"2026-07-08 21:41:00","inspection_id":"88347931","insp_violation_id":"275359451","seq_no":"8","part_no":"393","part_no_section":"207F-SDAS","insp_viol_unit":"2","insp_unit_id":"214498540","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-07-11T09:57:02.000000Z","updated_at":"2026-07-19T09:43:11.000000Z","normalized_code":"393207FSDAS"}],"inspection_per_units":[{"id":21504853,"change_date":"2026-07-08 21:41:00","inspection_id":"88347931","insp_unit_id":"214498540","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":null,"insp_unit_license":"E123567","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532C2JT400004","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-11T09:15:48.000000Z","updated_at":"2026-07-19T09:02:34.000000Z"},{"id":21504852,"change_date":"2026-07-08 21:41:00","inspection_id":"88347931","insp_unit_id":"214498539","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"RB87747","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN2GY5LM019508","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-11T09:15:48.000000Z","updated_at":"2026-07-19T09:02:34.000000Z"}]},{"id":12159457,"change_date":"2026-06-11 21:41:00","inspection_id":"88109098","dot_number":"1702320","report_state":"MI","report_number":"DAWDD04574","insp_date":"2026-06-10 00:00:00","insp_start_time":"0941","insp_end_time":"1010","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"163","insp_level_id":"3","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":"U","pen_cen_match":"I","final_status_date":"2026-06-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"3518336","transaction_code":"A","transaction_date":"2026-06-11 00:00:00","upload_date":"2026-06-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01702320","upload_search_indicator":null,"census_search_date":"2026-06-11 21:41:00","snet_input_date":"2026-06-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-11 21:41:00","insp_carrier_name":"SUN VALLEY FOODS COMPANY","insp_carrier_street":"14401 DEXTER DRIVE","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48238","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-15T09:41:30.000000Z","updated_at":"2026-06-22T09:30:41.000000Z","inspection_violations":[{"id":21162779,"change_date":"2026-06-11 21:41:00","inspection_id":"88109098","insp_violation_id":"274841410","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","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-06-15T10:02:44.000000Z","updated_at":"2026-06-22T09:42:26.000000Z","normalized_code":"3922SLLSR"},{"id":21162780,"change_date":"2026-06-11 21:41:00","inspection_id":"88109098","insp_violation_id":"274841411","seq_no":"2","part_no":"390","part_no_section":"19B2-BIENNIAL","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-06-15T10:02:44.000000Z","updated_at":"2026-06-22T09:42:26.000000Z","normalized_code":"39019B2BIENNIAL"}],"inspection_per_units":[{"id":21121892,"change_date":"2026-06-11 21:41:00","inspection_id":"88109098","insp_unit_id":"214037057","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"60381","insp_unit_license":"RB87801","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5PVNV8JVXL5S60381","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-15T09:19:20.000000Z","updated_at":"2026-06-22T09:01:47.000000Z"}]},{"id":11665487,"change_date":"2026-04-16 21:41:00","inspection_id":"87595813","dot_number":"1702320","report_state":"MI","report_number":"LAUEJ02222","insp_date":"2026-04-14 00:00:00","insp_start_time":"0915","insp_end_time":"1017","registration_date":null,"region":"ET","ci_status_code":"C","location":"831","location_desc":"MACKINAC BRIDGE","county_code_state":"MI","county_code":"097","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-04-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1266214","transaction_code":"A","transaction_date":"2026-04-14 00:00:00","upload_date":"2026-04-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01702320","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-04-14 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-04-16 21:41:00","insp_carrier_name":"SUN VALLEY FOODS COMPANY","insp_carrier_street":"14401 DEXTER DRIVE","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48238","insp_colonia":null,"docket_number":"4541","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-27T09:31:36.000000Z","updated_at":"2026-04-27T09:31:36.000000Z","inspection_violations":[{"id":20261910,"change_date":"2026-04-16 21:41:00","inspection_id":"87595813","insp_violation_id":"273649350","seq_no":"2","part_no":"393","part_no_section":"48A-BIBD","insp_viol_unit":"2","insp_unit_id":"213053997","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:44:56.000000Z","updated_at":"2026-04-27T09:44:56.000000Z","normalized_code":"39348ABIBD"},{"id":20261911,"change_date":"2026-04-16 21:41:00","inspection_id":"87595813","insp_violation_id":"273649351","seq_no":"3","part_no":"393","part_no_section":"55E-B","insp_viol_unit":"2","insp_unit_id":"213053997","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:44:56.000000Z","updated_at":"2026-04-27T09:44:56.000000Z","normalized_code":"39355EB"},{"id":20261909,"change_date":"2026-04-16 21:41:00","inspection_id":"87595813","insp_violation_id":"273649349","seq_no":"1","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"213053996","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:44:56.000000Z","updated_at":"2026-04-27T09:44:56.000000Z","normalized_code":"3939ALIL"}],"inspection_per_units":[{"id":20292475,"change_date":"2026-04-16 21:41:00","inspection_id":"87595813","insp_unit_id":"213053996","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"RB87741","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN2GY1LM019506","insp_unit_decal":"Y","insp_unit_decal_number":"36397236","created_at":"2026-04-27T09:04:38.000000Z","updated_at":"2026-04-27T09:04:38.000000Z"},{"id":20292476,"change_date":"2026-04-16 21:41:00","inspection_id":"87595813","insp_unit_id":"213053997","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":null,"insp_unit_license":"E240865","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532C8LT436010","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:04:38.000000Z","updated_at":"2026-04-27T09:04:38.000000Z"}]},{"id":11632078,"change_date":"2026-04-13 21:38:00","inspection_id":"87560795","dot_number":"1702320","report_state":"MI","report_number":"WERNR01560","insp_date":"2026-04-07 00:00:00","insp_start_time":"1125","insp_end_time":"1138","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M117 NEAR MCKELVEY RD","county_code_state":"MI","county_code":"097","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":"2026-04-13 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1265443","transaction_code":"A","transaction_date":"2026-04-07 00:00:00","upload_date":"2026-04-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01702320","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-04-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-04-13 21:38:00","insp_carrier_name":"SUN VALLEY FOODS COMPANY","insp_carrier_street":"14401 DEXTER DRIVE","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48238","insp_colonia":null,"docket_number":"4541","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-24T09:31:02.000000Z","updated_at":"2026-04-24T09:31:02.000000Z","inspection_violations":[{"id":20189116,"change_date":"2026-04-13 21:38:00","inspection_id":"87560795","insp_violation_id":"273564322","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-24T09:43:07.000000Z","updated_at":"2026-04-24T09:43:07.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":20232385,"change_date":"2026-04-13 21:38:00","inspection_id":"87560795","insp_unit_id":"212987070","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"RB87741","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN2GY1LM019506","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-24T09:03:39.000000Z","updated_at":"2026-04-24T09:03:39.000000Z"},{"id":20232386,"change_date":"2026-04-13 21:38:00","inspection_id":"87560795","insp_unit_id":"212987071","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":null,"insp_unit_license":"D679613","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532C1MT178009","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-24T09:03:39.000000Z","updated_at":"2026-04-24T09:03:39.000000Z"}]},{"id":11501389,"change_date":"2026-03-27 21:40:00","inspection_id":"87421514","dot_number":"1702320","report_state":"MI","report_number":"HUFFR00443","insp_date":"2026-03-25 00:00:00","insp_start_time":"0755","insp_end_time":"0820","registration_date":null,"region":"ET","ci_status_code":"C","location":"141","location_desc":"MONROE SCALE N\/B","county_code_state":"MI","county_code":"115","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAC","shipping_paper_number":"332632","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"21000","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":"1264344","transaction_code":"A","transaction_date":"2026-03-25 00:00:00","upload_date":"2026-03-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01702320","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-03-25 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-03-27 21:40:00","insp_carrier_name":"SUN VALLEY FOODS COMPANY","insp_carrier_street":"14401 DEXTER DRIVE","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48238","insp_colonia":null,"docket_number":"4541","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-30T09:51:45.000000Z","updated_at":"2026-04-07T09:32:31.000000Z","inspection_violations":[{"id":19420933,"change_date":"2026-03-27 21:40:00","inspection_id":"87421514","insp_violation_id":"272692913","seq_no":"1","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"212385032","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-30T10:20:08.000000Z","updated_at":"2026-04-07T09:48:49.000000Z","normalized_code":"3939ALIL"}],"inspection_per_units":[{"id":19703368,"change_date":"2026-03-27 21:40:00","inspection_id":"87421514","insp_unit_id":"212385032","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"60381","insp_unit_license":"RB87801","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5PVNV8JVXL5S60381","insp_unit_decal":"Y","insp_unit_decal_number":"36057686","created_at":"2026-03-30T09:33:26.000000Z","updated_at":"2026-04-07T09:08:55.000000Z"}]},{"id":11227779,"change_date":"2026-03-06 21:42:00","inspection_id":"87139858","dot_number":"1702320","report_state":"MI","report_number":"NESBA02607","insp_date":"2026-02-24 00:00:00","insp_start_time":"1315","insp_end_time":"1340","registration_date":null,"region":"ET","ci_status_code":"C","location":"212","location_desc":"S I-75@RATTALEE LAKE RD","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":"Y","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-02-25 21:49:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1260337","transaction_code":"C","transaction_date":"2026-02-24 00:00:00","upload_date":"2026-02-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01702320","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-02-24 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-02-25 21:49:00","insp_carrier_name":"SUN VALLEY FOODS COMPANY","insp_carrier_street":"14401 DEXTER DRIVE","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48238","insp_colonia":null,"docket_number":"4541","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-28T10:39:27.000000Z","updated_at":"2026-03-17T09:30:36.000000Z","inspection_violations":[{"id":19022280,"change_date":"2026-03-06 21:42:00","inspection_id":"87139858","insp_violation_id":"272250859","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-03-09T10:08:27.000000Z","updated_at":"2026-03-17T09:39:31.000000Z","normalized_code":"3922SLLLR"},{"id":19022281,"change_date":"2026-03-06 21:42:00","inspection_id":"87139858","insp_violation_id":"272250860","seq_no":"2","part_no":"392","part_no_section":"2-SLLMF","insp_viol_unit":"1","insp_unit_id":"212013526","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-09T10:08:27.000000Z","updated_at":"2026-03-17T09:39:31.000000Z","normalized_code":"3922SLLMF"},{"id":19022282,"change_date":"2026-03-06 21:42:00","inspection_id":"87139858","insp_violation_id":"272250861","seq_no":"3","part_no":"393","part_no_section":"9A-LTSIR","insp_viol_unit":"1","insp_unit_id":"212013526","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-09T10:08:27.000000Z","updated_at":"2026-03-17T09:39:31.000000Z","normalized_code":"3939ALTSIR"},{"id":19022283,"change_date":"2026-03-06 21:42:00","inspection_id":"87139858","insp_violation_id":"272250862","seq_no":"4","part_no":"393","part_no_section":"9A-LSLI","insp_viol_unit":"1","insp_unit_id":"212013526","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-09T10:08:27.000000Z","updated_at":"2026-03-17T09:39:31.000000Z","normalized_code":"3939ALSLI"},{"id":19022284,"change_date":"2026-03-06 21:42:00","inspection_id":"87139858","insp_violation_id":"272250863","seq_no":"5","part_no":"393","part_no_section":"9A-LHWS","insp_viol_unit":"1","insp_unit_id":"212013526","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-09T10:08:27.000000Z","updated_at":"2026-03-17T09:39:31.000000Z","normalized_code":"3939ALHWS"}],"inspection_per_units":[{"id":19343704,"change_date":"2026-03-06 21:42:00","inspection_id":"87139858","insp_unit_id":"212013527","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"538650","insp_unit_license":"D679613","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532C1MT178009","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-09T09:28:21.000000Z","updated_at":"2026-03-17T09:02:47.000000Z"},{"id":19343703,"change_date":"2026-03-06 21:42:00","inspection_id":"87139858","insp_unit_id":"212013526","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"10625","insp_unit_license":"RB85990","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN2GYXKM010625","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-09T09:28:21.000000Z","updated_at":"2026-03-17T09:02:47.000000Z"}]},{"id":11173376,"change_date":"2026-02-19 21:40:00","inspection_id":"87089249","dot_number":"1702320","report_state":"MI","report_number":"MOREM06314","insp_date":"2026-02-18 00:00:00","insp_start_time":"1125","insp_end_time":"1250","registration_date":null,"region":"ET","ci_status_code":"C","location":"122","location_desc":"FOWLERVILLE SCALE W\/B","county_code_state":"MI","county_code":"093","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SUN VALLEY FOODS","shipping_paper_number":"329179","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-02-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1259752","transaction_code":"A","transaction_date":"2026-02-18 00:00:00","upload_date":"2026-02-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01702320","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-02-18 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-02-19 21:40:00","insp_carrier_name":"SUN VALLEY FOODS COMPANY","insp_carrier_street":"14401 DEXTER DRIVE","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48238","insp_colonia":null,"docket_number":"4541","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-22T10:38:04.000000Z","updated_at":"2026-03-02T10:31:03.000000Z","inspection_violations":[{"id":18730731,"change_date":"2026-02-19 21:40:00","inspection_id":"87089249","insp_violation_id":"271897213","seq_no":"1","part_no":"393","part_no_section":"75A3-TAOLTIS","insp_viol_unit":"2","insp_unit_id":"211713429","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-02-22T10:53:26.000000Z","updated_at":"2026-03-02T10:41:32.000000Z","normalized_code":"39375A3TAOLTIS"},{"id":18730732,"change_date":"2026-02-19 21:40:00","inspection_id":"87089249","insp_violation_id":"271897214","seq_no":"2","part_no":"393","part_no_section":"48A-BIBD","insp_viol_unit":"2","insp_unit_id":"211713429","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-22T10:53:26.000000Z","updated_at":"2026-03-02T10:41:32.000000Z","normalized_code":"39348ABIBD"},{"id":18730734,"change_date":"2026-02-19 21:40:00","inspection_id":"87089249","insp_violation_id":"271897216","seq_no":"4","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"2","insp_unit_id":"211713429","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-22T10:53:26.000000Z","updated_at":"2026-03-02T10:41:32.000000Z","normalized_code":"39353BB"},{"id":18730733,"change_date":"2026-02-19 21:40:00","inspection_id":"87089249","insp_violation_id":"271897215","seq_no":"3","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"211713429","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-22T10:53:26.000000Z","updated_at":"2026-03-02T10:41:32.000000Z","normalized_code":"39347E"},{"id":18730735,"change_date":"2026-02-19 21:40:00","inspection_id":"87089249","insp_violation_id":"271897217","seq_no":"5","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"211713428","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-22T10:53:26.000000Z","updated_at":"2026-03-02T10:41:32.000000Z","normalized_code":"39347E"},{"id":18730736,"change_date":"2026-02-19 21:40:00","inspection_id":"87089249","insp_violation_id":"271897218","seq_no":"6","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"211713428","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-22T10:53:26.000000Z","updated_at":"2026-03-02T10:41:32.000000Z","normalized_code":"39347E"},{"id":18730737,"change_date":"2026-02-19 21:40:00","inspection_id":"87089249","insp_violation_id":"271897219","seq_no":"7","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"1","insp_unit_id":"211713428","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4655720","created_at":"2026-02-22T10:53:26.000000Z","updated_at":"2026-03-02T10:41:32.000000Z","normalized_code":"3963A1BOS"}],"inspection_per_units":[{"id":19067944,"change_date":"2026-02-19 21:40:00","inspection_id":"87089249","insp_unit_id":"211713428","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"19501","insp_unit_license":"RB87740","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN2GY2LM019501","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-22T10:13:28.000000Z","updated_at":"2026-03-02T10:03:58.000000Z"},{"id":19067945,"change_date":"2026-02-19 21:40:00","inspection_id":"87089249","insp_unit_id":"211713429","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"538633","insp_unit_license":"D679612","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532C0MT178003","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-22T10:13:28.000000Z","updated_at":"2026-03-02T10:03:58.000000Z"}]},{"id":10067618,"change_date":"2025-10-29 21:40:00","inspection_id":"86181290","dot_number":"1702320","report_state":"MI","report_number":"GUTHG02825","insp_date":"2025-10-28 00:00:00","insp_start_time":"0900","insp_end_time":"0947","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"HWY SHOULDER","county_code_state":"MI","county_code":"097","insp_level_id":"3","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":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-29 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"101000","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":"1248279","transaction_code":"A","transaction_date":"2025-10-28 00:00:00","upload_date":"2025-10-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01702320","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-10-28 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-10-29 21:40:00","insp_carrier_name":"SUN VALLEY FOODS COMPANY","insp_carrier_street":"14401 DEXTER DRIVE","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48238","insp_colonia":null,"docket_number":"4541","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-01T10:02:30.000000Z","updated_at":"2025-11-02T11:01:10.000000Z","inspection_violations":[{"id":16671892,"change_date":"2025-10-29 21:40:00","inspection_id":"86181290","insp_violation_id":"269595886","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":null,"created_at":"2025-11-01T10:17:59.000000Z","updated_at":"2025-11-02T11:16:48.000000Z","normalized_code":"39216D"},{"id":16671893,"change_date":"2025-10-29 21:40:00","inspection_id":"86181290","insp_violation_id":"269595887","seq_no":"2","part_no":"395","part_no_section":"3A3-HOSPRNC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"4","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-01T10:17:59.000000Z","updated_at":"2025-11-02T11:16:48.000000Z","normalized_code":"3953A3HOSPRNC"}],"inspection_per_units":[{"id":16733948,"change_date":"2025-10-29 21:40:00","inspection_id":"86181290","insp_unit_id":"209720591","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"19508","insp_unit_license":"RB87747","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN2GY5LM019508","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-01T09:47:06.000000Z","updated_at":"2025-11-02T10:46:30.000000Z"},{"id":16733949,"change_date":"2025-10-29 21:40:00","inspection_id":"86181290","insp_unit_id":"209720592","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"537866","insp_unit_license":"E596941","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532K9NJ804006","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-01T09:47:06.000000Z","updated_at":"2025-11-02T10:46:30.000000Z"}]},{"id":9547179,"change_date":"2025-08-29 21:40:00","inspection_id":"85634644","dot_number":"1702320","report_state":"MI","report_number":"TPDSA00211","insp_date":"2025-08-28 00:00:00","insp_start_time":"0906","insp_end_time":"1007","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"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":"33000","viol_total":"5","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1238456","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":"01702320","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-08-28 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-08-29 21:40:00","insp_carrier_name":"SUN VALLEY FOODS COMPANY","insp_carrier_street":"14401 DEXTER DRIVE","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48238","insp_colonia":null,"docket_number":"4541","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":[{"id":15586127,"change_date":"2025-08-29 21:40:00","inspection_id":"85634644","insp_violation_id":"268347824","seq_no":"1","part_no":"393","part_no_section":"11B-CSLRR","insp_viol_unit":"1","insp_unit_id":"208661553","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"25TR08329","created_at":"2025-09-06T10:46:20.000000Z","updated_at":"2025-09-06T10:46:20.000000Z","normalized_code":"39311BCSLRR"},{"id":15586128,"change_date":"2025-08-29 21:40:00","inspection_id":"85634644","insp_violation_id":"268347825","seq_no":"2","part_no":"393","part_no_section":"11B-CSSRR","insp_viol_unit":"1","insp_unit_id":"208661553","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"25TR08329","created_at":"2025-09-06T10:46:20.000000Z","updated_at":"2025-09-06T10:46:20.000000Z","normalized_code":"39311BCSSRR"},{"id":15586129,"change_date":"2025-08-29 21:40:00","inspection_id":"85634644","insp_violation_id":"268347826","seq_no":"3","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"208661553","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"25TR08329","created_at":"2025-09-06T10:46:20.000000Z","updated_at":"2025-09-06T10:46:20.000000Z","normalized_code":"39347E"},{"id":15586130,"change_date":"2025-08-29 21:40:00","inspection_id":"85634644","insp_violation_id":"268347827","seq_no":"4","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"1","insp_unit_id":"208661553","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"25TR08329","created_at":"2025-09-06T10:46:20.000000Z","updated_at":"2025-09-06T10:46:20.000000Z","normalized_code":"39353BB"},{"id":15586131,"change_date":"2025-08-29 21:40:00","inspection_id":"85634644","insp_violation_id":"268347828","seq_no":"5","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"1","insp_unit_id":"208661553","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"25TR08329","created_at":"2025-09-06T10:46:20.000000Z","updated_at":"2025-09-06T10:46:20.000000Z","normalized_code":"3963A1BOS"}],"inspection_per_units":[{"id":15757934,"change_date":"2025-08-29 21:40:00","inspection_id":"85634644","insp_unit_id":"208661553","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"RB87801","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5PVNV8JVXL5S60381","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":8779895,"change_date":"2025-05-30 21:40:00","inspection_id":"84825449","dot_number":"1702320","report_state":"MI","report_number":"WERNR01394","insp_date":"2025-05-29 00:00:00","insp_start_time":"1010","insp_end_time":"1026","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"NB I75 NEAR MM 310","county_code_state":"MI","county_code":"031","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":"2025-05-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1223413","transaction_code":"A","transaction_date":"2025-05-29 00:00:00","upload_date":"2025-05-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01702320","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-05-29 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-05-30 21:40:00","insp_carrier_name":"SUN VALLEY FOODS COMPANY","insp_carrier_street":"14401 DEXTER DRIVE","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48238","insp_colonia":null,"docket_number":"4541","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-04T10:01:08.000000Z","updated_at":"2025-06-04T10:01:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14364679,"change_date":"2025-05-30 21:40:00","inspection_id":"84825449","insp_unit_id":"207152049","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"RB44001","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AW02Y6GM077657","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-02T09:46:22.000000Z","updated_at":"2025-06-03T09:45:49.000000Z"},{"id":14364680,"change_date":"2025-05-30 21:40:00","inspection_id":"84825449","insp_unit_id":"207152050","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":null,"insp_unit_license":"E123567","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532C2JT400004","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-02T09:46:22.000000Z","updated_at":"2025-06-03T09:45:49.000000Z"}]},{"id":8468484,"change_date":"2025-04-25 21:36:00","inspection_id":"84497031","dot_number":"1702320","report_state":"MI","report_number":"NEGUB02754","insp_date":"2025-04-23 00:00:00","insp_start_time":"0900","insp_end_time":"0925","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US-223 @ STAMP HWY","county_code_state":"MI","county_code":"091","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"NA","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-25 21:36:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","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":"1218906","transaction_code":"A","transaction_date":"2025-04-23 00:00:00","upload_date":"2025-04-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01702320","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-04-23 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-04-25 21:36:00","insp_carrier_name":"SUN VALLEY FOODS COMPANY","insp_carrier_street":"14401 DEXTER DRIVE","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48238","insp_colonia":null,"docket_number":"4541","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-28T10:14:20.000000Z","updated_at":"2025-04-29T10:02:33.000000Z","inspection_violations":[{"id":13386915,"change_date":"2025-04-25 21:36:00","inspection_id":"84497031","insp_violation_id":"265828786","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-28T10:35:51.000000Z","updated_at":"2025-04-29T10:23:41.000000Z","normalized_code":"3922SLLS2"},{"id":13386916,"change_date":"2025-04-25 21:36:00","inspection_id":"84497031","insp_violation_id":"265828787","seq_no":"2","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":"X4514496","created_at":"2025-04-28T10:35:51.000000Z","updated_at":"2025-04-29T10:23:41.000000Z","normalized_code":"39282DUMT"}],"inspection_per_units":[{"id":13759117,"change_date":"2025-04-25 21:36:00","inspection_id":"84497031","insp_unit_id":"206489779","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"19504","insp_unit_license":"RB87744","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN2GY8LM019504","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-28T10:04:44.000000Z","updated_at":"2025-04-29T09:56:27.000000Z"},{"id":13759118,"change_date":"2025-04-25 21:36:00","inspection_id":"84497031","insp_unit_id":"206489780","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"538643","insp_unit_license":"D679618","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532CXMT178008","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-28T10:04:44.000000Z","updated_at":"2025-04-29T09:56:27.000000Z"}]},{"id":8451116,"change_date":"2025-04-23 21:41:00","inspection_id":"84478795","dot_number":"1702320","report_state":"MI","report_number":"RAMSB02134","insp_date":"2025-04-22 00:00:00","insp_start_time":"0600","insp_end_time":"0748","registration_date":null,"region":"ET","ci_status_code":"C","location":"122","location_desc":"FOWLERVILLE SCALE W\/B","county_code_state":"MI","county_code":"093","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SUN VALLEY FOODS","shipping_paper_number":"305066","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":"2025-04-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"13","oos_total":"1","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"11","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1218688","transaction_code":"A","transaction_date":"2025-04-22 00:00:00","upload_date":"2025-04-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01702320","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-04-22 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-04-23 21:41:00","insp_carrier_name":"SUN VALLEY FOODS COMPANY","insp_carrier_street":"14401 DEXTER DRIVE","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48238","insp_colonia":null,"docket_number":"4541","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-26T10:28:33.000000Z","updated_at":"2025-04-27T10:31:44.000000Z","inspection_violations":[{"id":13352280,"change_date":"2025-04-23 21:41:00","inspection_id":"84478795","insp_violation_id":"265789813","seq_no":"1","part_no":"392","part_no_section":"2-SLLDL","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-04-25T11:08:35.000000Z","updated_at":"2025-04-26T10:50:42.000000Z","normalized_code":"3922SLLDL"},{"id":13352281,"change_date":"2025-04-23 21:41:00","inspection_id":"84478795","insp_violation_id":"265789814","seq_no":"2","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-25T11:08:35.000000Z","updated_at":"2025-04-26T10:50:42.000000Z","normalized_code":"3922SLLEWA1"},{"id":13352282,"change_date":"2025-04-23 21:41:00","inspection_id":"84478795","insp_violation_id":"265789815","seq_no":"3","part_no":"392","part_no_section":"2-SLLIRP","insp_viol_unit":"1","insp_unit_id":"206456404","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-25T11:08:35.000000Z","updated_at":"2025-04-26T10:50:42.000000Z","normalized_code":"3922SLLIRP"},{"id":13352283,"change_date":"2025-04-23 21:41:00","inspection_id":"84478795","insp_violation_id":"265789816","seq_no":"4","part_no":"392","part_no_section":"2-SLLSIV","insp_viol_unit":"1","insp_unit_id":"206456404","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-25T11:08:35.000000Z","updated_at":"2025-04-26T10:50:42.000000Z","normalized_code":"3922SLLSIV"},{"id":13352284,"change_date":"2025-04-23 21:41:00","inspection_id":"84478795","insp_violation_id":"265789817","seq_no":"5","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"206456404","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-25T11:08:35.000000Z","updated_at":"2025-04-26T10:50:42.000000Z","normalized_code":"39021TB2DOT"},{"id":13352285,"change_date":"2025-04-23 21:41:00","inspection_id":"84478795","insp_violation_id":"265789818","seq_no":"6","part_no":"393","part_no_section":"75A3-ATIS","insp_viol_unit":"1","insp_unit_id":"206456404","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-25T11:08:35.000000Z","updated_at":"2025-04-26T10:50:42.000000Z","normalized_code":"39375A3ATIS"},{"id":13352286,"change_date":"2025-04-23 21:41:00","inspection_id":"84478795","insp_violation_id":"265789819","seq_no":"7","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"2","insp_unit_id":"206456405","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-25T11:08:35.000000Z","updated_at":"2025-04-26T10:50:42.000000Z","normalized_code":"3922SLLSR"},{"id":13352287,"change_date":"2025-04-23 21:41:00","inspection_id":"84478795","insp_violation_id":"265789820","seq_no":"8","part_no":"396","part_no_section":"3A1-BARS","insp_viol_unit":"2","insp_unit_id":"206456405","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-25T11:08:35.000000Z","updated_at":"2025-04-26T10:50:42.000000Z","normalized_code":"3963A1BARS"},{"id":13352288,"change_date":"2025-04-23 21:41:00","inspection_id":"84478795","insp_violation_id":"265789821","seq_no":"9","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"206456405","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-25T11:08:35.000000Z","updated_at":"2025-04-26T10:50:42.000000Z","normalized_code":"39347E"},{"id":13352289,"change_date":"2025-04-23 21:41:00","inspection_id":"84478795","insp_violation_id":"265789822","seq_no":"10","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"206456405","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-25T11:08:35.000000Z","updated_at":"2025-04-26T10:50:42.000000Z","normalized_code":"39347E"},{"id":13352290,"change_date":"2025-04-23 21:41:00","inspection_id":"84478795","insp_violation_id":"265789823","seq_no":"11","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"2","insp_unit_id":"206456405","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-25T11:08:35.000000Z","updated_at":"2025-04-26T10:50:42.000000Z","normalized_code":"39353BB"},{"id":13352291,"change_date":"2025-04-23 21:41:00","inspection_id":"84478795","insp_violation_id":"265789824","seq_no":"12","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"2","insp_unit_id":"206456405","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4489850","created_at":"2025-04-25T11:08:35.000000Z","updated_at":"2025-04-26T10:50:42.000000Z","normalized_code":"3963A1BOS"},{"id":13352292,"change_date":"2025-04-23 21:41:00","inspection_id":"84478795","insp_violation_id":"265789825","seq_no":"13","part_no":"393","part_no_section":"11B-CSURR","insp_viol_unit":"2","insp_unit_id":"206456405","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-25T11:08:35.000000Z","updated_at":"2025-04-26T10:50:42.000000Z","normalized_code":"39311BCSURR"}],"inspection_per_units":[{"id":13726925,"change_date":"2025-04-23 21:41:00","inspection_id":"84478795","insp_unit_id":"206456404","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"77657","insp_unit_license":"RB44001","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AW02Y6GM077657","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-26T10:14:32.000000Z","updated_at":"2025-04-27T10:04:15.000000Z"},{"id":13726926,"change_date":"2025-04-23 21:41:00","inspection_id":"84478795","insp_unit_id":"206456405","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"539941","insp_unit_license":"E123567","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532C2JT400004","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-26T10:14:32.000000Z","updated_at":"2025-04-27T10:04:15.000000Z"}]},{"id":8034892,"change_date":"2025-03-05 21:40:00","inspection_id":"84040486","dot_number":"1702320","report_state":"MI","report_number":"ROLLJ02694","insp_date":"2025-03-04 00:00:00","insp_start_time":"1210","insp_end_time":"1228","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"EB M55 @ LOCUS LANE","county_code_state":"MI","county_code":"165","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","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-03-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1211970","transaction_code":"A","transaction_date":"2025-03-04 00:00:00","upload_date":"2025-03-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01702320","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-03-04 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-03-05 21:40:00","insp_carrier_name":"SUN VALLEY FOODS COMPANY","insp_carrier_street":"14401 DEXTER DRIVE","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48238","insp_colonia":null,"docket_number":"4541","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:04:58.000000Z","updated_at":"2025-03-17T21:04:58.000000Z","inspection_violations":[{"id":12556354,"change_date":"2025-03-05 21:40:00","inspection_id":"84040486","insp_violation_id":"264849407","seq_no":"1","part_no":"392","part_no_section":"2-SLLS4","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4490895","created_at":"2025-03-17T22:07:22.000000Z","updated_at":"2025-03-17T22:07:22.000000Z","normalized_code":"3922SLLS4"},{"id":12556355,"change_date":"2025-03-05 21:40:00","inspection_id":"84040486","insp_violation_id":"264849408","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"2","insp_unit_id":"205642064","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:22.000000Z","updated_at":"2025-03-17T22:07:22.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":12971776,"change_date":"2025-03-05 21:40:00","inspection_id":"84040486","insp_unit_id":"205642063","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"RB87747","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN2GY5LM019508","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:58:18.000000Z","updated_at":"2025-03-17T23:58:18.000000Z"},{"id":12971777,"change_date":"2025-03-05 21:40:00","inspection_id":"84040486","insp_unit_id":"205642064","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":null,"insp_unit_license":"D679618","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532CXMT178008","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:58:18.000000Z","updated_at":"2025-03-17T23:58:18.000000Z"}]},{"id":7970077,"change_date":"2025-02-26 21:41:00","inspection_id":"83972337","dot_number":"1702320","report_state":"MI","report_number":"ESCOT02492","insp_date":"2025-02-25 00:00:00","insp_start_time":"1140","insp_end_time":"1200","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"LIVERNOIS AVE@W I-94","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S-C","shipping_paper_number":"299775","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-02-26 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1211245","transaction_code":"A","transaction_date":"2025-02-25 00:00:00","upload_date":"2025-02-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01702320","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-02-25 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-02-26 21:41:00","insp_carrier_name":"SUN VALLEY FOODS COMPANY","insp_carrier_street":"14401 DEXTER DRIVE","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48238","insp_colonia":null,"docket_number":"4541","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:03:39.000000Z","updated_at":"2025-03-17T21:03:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12866526,"change_date":"2025-02-26 21:41:00","inspection_id":"83972337","insp_unit_id":"205517773","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"19518","insp_unit_license":"RC46917","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN2GY8LM019518","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:08.000000Z","updated_at":"2025-03-17T23:57:08.000000Z"},{"id":12866527,"change_date":"2025-02-26 21:41:00","inspection_id":"83972337","insp_unit_id":"205517774","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"537866","insp_unit_license":"E596941","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532K9NJ804006","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:08.000000Z","updated_at":"2025-03-17T23:57:08.000000Z"}]},{"id":7739375,"change_date":"2025-01-29 21:41:00","inspection_id":"83729956","dot_number":"1702320","report_state":"MI","report_number":"GENTC02956","insp_date":"2025-01-28 00:00:00","insp_start_time":"1140","insp_end_time":"1200","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M-115 @ ADAMS RD","county_code_state":"MI","county_code":"035","insp_level_id":"3","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-01-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1207854","transaction_code":"A","transaction_date":"2025-01-28 00:00:00","upload_date":"2025-01-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01702320","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-01-28 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-01-29 21:41:00","insp_carrier_name":"SUN VALLEY FOODS COMPANY","insp_carrier_street":"14401 DEXTER DRIVE","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48238","insp_colonia":null,"docket_number":"4541","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:58:46.000000Z","updated_at":"2025-03-17T20:58:46.000000Z","inspection_violations":[{"id":12091909,"change_date":"2025-01-29 21:41:00","inspection_id":"83729956","insp_violation_id":"264237510","seq_no":"1","part_no":"392","part_no_section":"2-SLLS1","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-17T22:04:58.000000Z","updated_at":"2025-03-17T22:04:58.000000Z","normalized_code":"3922SLLS1"}],"inspection_per_units":[{"id":12489402,"change_date":"2025-01-29 21:41:00","inspection_id":"83729956","insp_unit_id":"205065446","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"19505","insp_unit_license":"RB87742","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN2GYXLM019505","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:46.000000Z","updated_at":"2025-03-17T23:52:46.000000Z"},{"id":12489403,"change_date":"2025-01-29 21:41:00","inspection_id":"83729956","insp_unit_id":"205065447","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"538635","insp_unit_license":"D679614","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532C2MT178004","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:46.000000Z","updated_at":"2025-03-17T23:52:46.000000Z"}]},{"id":7739497,"change_date":"2025-01-29 21:41:00","inspection_id":"83730086","dot_number":"1702320","report_state":"MI","report_number":"LAUEJ01806","insp_date":"2025-01-27 00:00:00","insp_start_time":"1000","insp_end_time":"1025","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I75 S\/B 344MM","county_code_state":"MI","county_code":"097","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":"2025-01-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1207766","transaction_code":"A","transaction_date":"2025-01-27 00:00:00","upload_date":"2025-01-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01702320","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-01-27 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-01-29 21:41:00","insp_carrier_name":"SUN VALLEY FOODS COMPANY","insp_carrier_street":"14401 DEXTER DRIVE","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48238","insp_colonia":null,"docket_number":"4541","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:58:46.000000Z","updated_at":"2025-03-17T20:58:46.000000Z","inspection_violations":[{"id":12092203,"change_date":"2025-01-29 21:41:00","inspection_id":"83730086","insp_violation_id":"264237816","seq_no":"1","part_no":"392","part_no_section":"2-SLLUP","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-17T22:04:58.000000Z","updated_at":"2025-03-17T22:04:58.000000Z","normalized_code":"3922SLLUP"}],"inspection_per_units":[{"id":12489617,"change_date":"2025-01-29 21:41:00","inspection_id":"83730086","insp_unit_id":"205065676","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"19501","insp_unit_license":"RB87740","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN2GY2LM019501","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:46.000000Z","updated_at":"2025-03-17T23:52:46.000000Z"},{"id":12489618,"change_date":"2025-01-29 21:41:00","inspection_id":"83730086","insp_unit_id":"205065677","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"538632","insp_unit_license":"D679611","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532C9MT178002","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:46.000000Z","updated_at":"2025-03-17T23:52:46.000000Z"}]},{"id":7640064,"change_date":"2025-01-16 21:41:00","inspection_id":"83625802","dot_number":"1702320","report_state":"MI","report_number":"BESSJ00982","insp_date":"2025-01-16 00:00:00","insp_start_time":"1120","insp_end_time":"1210","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WB I-96 @ FOLWLERVILLE SCALES","county_code_state":"MI","county_code":"093","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"295879","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-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1206970","transaction_code":"A","transaction_date":"2025-01-16 00:00:00","upload_date":"2025-01-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01702320","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-01-16 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-01-16 21:41:00","insp_carrier_name":"SUN VALLEY FOODS COMPANY","insp_carrier_street":"14401 DEXTER DRIVE","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48238","insp_colonia":null,"docket_number":"4541","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:56:58.000000Z","updated_at":"2025-03-17T20:56:58.000000Z","inspection_violations":[{"id":11938726,"change_date":"2025-01-16 21:41:00","inspection_id":"83625802","insp_violation_id":"264038798","seq_no":"1","part_no":"393","part_no_section":"75A3-ATIS","insp_viol_unit":"1","insp_unit_id":"204874136","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:04:08.000000Z","updated_at":"2025-03-17T22:04:08.000000Z","normalized_code":"39375A3ATIS"},{"id":11938727,"change_date":"2025-01-16 21:41:00","inspection_id":"83625802","insp_violation_id":"264038799","seq_no":"2","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"2","insp_unit_id":"204874137","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:08.000000Z","updated_at":"2025-03-17T22:04:08.000000Z","normalized_code":"39345DB"},{"id":11938728,"change_date":"2025-01-16 21:41:00","inspection_id":"83625802","insp_violation_id":"264038800","seq_no":"3","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"204874137","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:08.000000Z","updated_at":"2025-03-17T22:04:08.000000Z","normalized_code":"39347E"}],"inspection_per_units":[{"id":12327975,"change_date":"2025-01-16 21:41:00","inspection_id":"83625802","insp_unit_id":"204874136","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"19506","insp_unit_license":"RB7741","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN2GY1LM019506","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:03.000000Z","updated_at":"2025-03-17T23:51:03.000000Z"},{"id":12327976,"change_date":"2025-01-16 21:41:00","inspection_id":"83625802","insp_unit_id":"204874137","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"538633","insp_unit_license":"D67612","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532C0MT178003","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:03.000000Z","updated_at":"2025-03-17T23:51:03.000000Z"}]},{"id":7593604,"change_date":"2025-01-14 21:55:00","inspection_id":"83577061","dot_number":"1702320","report_state":"MI","report_number":"OSHEE02420","insp_date":"2025-01-09 00:00:00","insp_start_time":"1355","insp_end_time":"1415","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I75 @ 4 MILE","county_code_state":"MI","county_code":"039","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":"2025-01-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"125000","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":"1206251","transaction_code":"C","transaction_date":"2025-01-09 00:00:00","upload_date":"2025-01-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01702320","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-01-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-01-10 21:40:00","insp_carrier_name":"SUN VALLEY FOODS COMPANY","insp_carrier_street":"14401 DEXTER DRIVE","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48238","insp_colonia":null,"docket_number":"4541","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:55:43.000000Z","updated_at":"2025-03-17T20:55:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12252453,"change_date":"2025-01-14 21:55:00","inspection_id":"83577061","insp_unit_id":"204828884","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"RB87742","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN2GYXLM019505","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:14.000000Z","updated_at":"2025-03-17T23:50:14.000000Z"},{"id":12252454,"change_date":"2025-01-14 21:55:00","inspection_id":"83577061","insp_unit_id":"204828885","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":null,"insp_unit_license":"D679611","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532C9MT178002","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:14.000000Z","updated_at":"2025-03-17T23:50:14.000000Z"}]},{"id":7535393,"change_date":"2025-01-14 21:55:00","inspection_id":"83515915","dot_number":"1702320","report_state":"MI","report_number":"BEAMW04167","insp_date":"2024-12-30 00:00:00","insp_start_time":"1050","insp_end_time":"1105","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I75 N @ BUSCH","county_code_state":"MI","county_code":"145","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","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-02 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"23500","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":"1205529","transaction_code":"C","transaction_date":"2024-12-30 00:00:00","upload_date":"2025-01-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01702320","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-12-30 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-01-02 21:39:00","insp_carrier_name":"SUN VALLEY FOODS COMPANY","insp_carrier_street":"14401 DEXTER DRIVE","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48238","insp_colonia":null,"docket_number":"4541","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:53:13.000000Z","updated_at":"2025-03-17T20:53:13.000000Z","inspection_violations":[{"id":11776531,"change_date":"2025-01-14 21:55:00","inspection_id":"83515915","insp_violation_id":"263994443","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-03-17T22:03:22.000000Z","updated_at":"2025-03-17T22:03:22.000000Z","normalized_code":"3922SLLLR"},{"id":11776532,"change_date":"2025-01-14 21:55:00","inspection_id":"83515915","insp_violation_id":"263994444","seq_no":"2","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:22.000000Z","updated_at":"2025-03-17T22:03:22.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":12157039,"change_date":"2025-01-14 21:55:00","inspection_id":"83515915","insp_unit_id":"204827373","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"BC33310","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5PVNJ8JVXL5S79234","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:13.000000Z","updated_at":"2025-03-17T23:49:13.000000Z"}]},{"id":7381982,"change_date":"2024-12-10 21:41:00","inspection_id":"83354852","dot_number":"1702320","report_state":"MI","report_number":"LULAN02467","insp_date":"2024-12-09 00:00:00","insp_start_time":"1010","insp_end_time":"1120","registration_date":null,"region":"ET","ci_status_code":"C","location":"122","location_desc":"FOWLERVILLE SCALE W\/B","county_code_state":"MI","county_code":"093","insp_level_id":"1","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":"2024-12-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1203806","transaction_code":"A","transaction_date":"2024-12-09 00:00:00","upload_date":"2024-12-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01702320","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-12-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-12-10 21:41:00","insp_carrier_name":"SUN VALLEY FOODS COMPANY","insp_carrier_street":"14401 DEXTER DRIVE","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48238","insp_colonia":null,"docket_number":"4541","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:50:15.000000Z","updated_at":"2025-03-17T20:50:15.000000Z","inspection_violations":[{"id":11531994,"change_date":"2024-12-10 21:41:00","inspection_id":"83354852","insp_violation_id":"263360102","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"204297521","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:07.000000Z","updated_at":"2025-03-17T22:02:07.000000Z","normalized_code":"3922SLLSR"},{"id":11531995,"change_date":"2024-12-10 21:41:00","inspection_id":"83354852","insp_violation_id":"263360103","seq_no":"2","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"204297522","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:07.000000Z","updated_at":"2025-03-17T22:02:07.000000Z","normalized_code":"39347E"},{"id":11531996,"change_date":"2024-12-10 21:41:00","inspection_id":"83354852","insp_violation_id":"263360104","seq_no":"3","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"204297522","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:07.000000Z","updated_at":"2025-03-17T22:02:07.000000Z","normalized_code":"39347E"},{"id":11531997,"change_date":"2024-12-10 21:41:00","inspection_id":"83354852","insp_violation_id":"263360105","seq_no":"4","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"2","insp_unit_id":"204297522","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:02:07.000000Z","updated_at":"2025-03-17T22:02:07.000000Z","normalized_code":"3963A1BOS"}],"inspection_per_units":[{"id":11908235,"change_date":"2024-12-10 21:41:00","inspection_id":"83354852","insp_unit_id":"204297521","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"RB87746","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN2GY8LM019518","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:29.000000Z","updated_at":"2025-03-17T23:46:29.000000Z"},{"id":11908236,"change_date":"2024-12-10 21:41:00","inspection_id":"83354852","insp_unit_id":"204297522","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"538635","insp_unit_license":"D679614","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532C2MT178004","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:29.000000Z","updated_at":"2025-03-17T23:46:29.000000Z"}]},{"id":6575243,"change_date":"2024-09-17 21:45:00","inspection_id":"82498746","dot_number":"1702320","report_state":"MI","report_number":"BARTC02691","insp_date":"2024-08-27 00:00:00","insp_start_time":"1030","insp_end_time":"1100","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I75 @ HARTWICK PINES","county_code_state":"MI","county_code":"039","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-27 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1191948","transaction_code":"C","transaction_date":"2024-08-27 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01702320","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-08-27 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-08-27 21:42:00","insp_carrier_name":"SUN VALLEY FOODS COMPANY","insp_carrier_street":"14401 DEXTER DRIVE","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48238","insp_colonia":null,"docket_number":"4541","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:33:13.000000Z","updated_at":"2025-03-17T20:33:13.000000Z","inspection_violations":[{"id":10219381,"change_date":"2024-09-17 21:45:00","inspection_id":"82498746","insp_violation_id":"261857925","seq_no":"1","part_no":"393","part_no_section":"75(a)","insp_viol_unit":"2","insp_unit_id":"202974274","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:55:26.000000Z","updated_at":"2025-03-17T21:55:26.000000Z","normalized_code":"39375A"}],"inspection_per_units":[{"id":10600225,"change_date":"2024-09-17 21:45:00","inspection_id":"82498746","insp_unit_id":"202974273","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"RB78040","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AW02Y4HM081983","insp_unit_decal":"Y","insp_unit_decal_number":"34302203","created_at":"2025-03-17T23:32:49.000000Z","updated_at":"2025-03-17T23:32:49.000000Z"},{"id":10600226,"change_date":"2024-09-17 21:45:00","inspection_id":"82498746","insp_unit_id":"202974274","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"538742","insp_unit_license":"E240865","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532C8LT436010","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:49.000000Z","updated_at":"2025-03-17T23:32:49.000000Z"}]},{"id":6490492,"change_date":"2024-09-17 21:45:00","inspection_id":"82408634","dot_number":"1702320","report_state":"MI","report_number":"NESBA01557","insp_date":"2024-08-14 00:00:00","insp_start_time":"1205","insp_end_time":"1230","registration_date":null,"region":"ET","ci_status_code":"C","location":"212","location_desc":"S I-75@GIDDINGS RD","county_code_state":"MI","county_code":"125","insp_level_id":"3","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":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1190019","transaction_code":"C","transaction_date":"2024-08-14 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01702320","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-08-14 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-08-16 21:39:00","insp_carrier_name":"SUN VALLEY FOODS COMPANY","insp_carrier_street":"14401 DEXTER DRIVE","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48238","insp_colonia":null,"docket_number":"4541","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:31:35.000000Z","updated_at":"2025-03-17T20:31:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10462370,"change_date":"2024-09-17 21:45:00","inspection_id":"82408634","insp_unit_id":"202983222","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"19501","insp_unit_license":"RB87740","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN2GY2LM019501","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":10462371,"change_date":"2024-09-17 21:45:00","inspection_id":"82408634","insp_unit_id":"202983223","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"538636","insp_unit_license":"D679615","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532C4MT178005","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":6423995,"change_date":"2024-09-17 21:45:00","inspection_id":"82337547","dot_number":"1702320","report_state":"MI","report_number":"BESSJ00742","insp_date":"2024-08-07 00:00:00","insp_start_time":"0500","insp_end_time":"0545","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WB I-96 @ FOLWLERVILLE SCALES","county_code_state":"MI","county_code":"093","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-08 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1189312","transaction_code":"C","transaction_date":"2024-08-07 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01702320","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-08-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-08-08 21:42:00","insp_carrier_name":"SUN VALLEY FOODS COMPANY","insp_carrier_street":"14401 DEXTER DRIVE","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48238","insp_colonia":null,"docket_number":"4541","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:30:16.000000Z","updated_at":"2025-03-17T20:30:16.000000Z","inspection_violations":[{"id":9974681,"change_date":"2024-09-17 21:45:00","inspection_id":"82337547","insp_violation_id":"261858559","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202974868","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:14.000000Z","updated_at":"2025-03-17T21:54:14.000000Z","normalized_code":"3939A"},{"id":9974682,"change_date":"2024-09-17 21:45:00","inspection_id":"82337547","insp_violation_id":"261858560","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"202974869","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:14.000000Z","updated_at":"2025-03-17T21:54:14.000000Z","normalized_code":"39347E"},{"id":9974683,"change_date":"2024-09-17 21:45:00","inspection_id":"82337547","insp_violation_id":"261858561","seq_no":"3","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"202974869","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:14.000000Z","updated_at":"2025-03-17T21:54:14.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":10353256,"change_date":"2024-09-17 21:45:00","inspection_id":"82337547","insp_unit_id":"202974868","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"N\/A","insp_unit_license":"RB87744","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN2GY8LM019504","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:18.000000Z","updated_at":"2025-03-17T23:30:18.000000Z"},{"id":10353257,"change_date":"2024-09-17 21:45:00","inspection_id":"82337547","insp_unit_id":"202974869","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"538645","insp_unit_license":"D679618","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532CXMT178008","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:18.000000Z","updated_at":"2025-03-17T23:30:18.000000Z"}]},{"id":6220488,"change_date":"2024-09-16 21:43:00","inspection_id":"82119670","dot_number":"1702320","report_state":"MI","report_number":"HAMIZ01101","insp_date":"2024-07-11 00:00:00","insp_start_time":"0859","insp_end_time":"0949","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"TOPINABEE REST AREA","county_code_state":"MI","county_code":"031","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAC","shipping_paper_number":"279375","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-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1185190","transaction_code":"C","transaction_date":"2024-07-11 00:00:00","upload_date":"2024-09-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01702320","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-07-11 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-07-15 21:41:00","insp_carrier_name":"SUN VALLEY FOODS COMPANY","insp_carrier_street":"14401 DEXTER DRIVE","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48238","insp_colonia":null,"docket_number":"4541","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:26:09.000000Z","updated_at":"2025-03-17T20:26:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10022049,"change_date":"2024-09-16 21:43:00","inspection_id":"82119670","insp_unit_id":"202945758","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"19508","insp_unit_license":"RB87747","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN2GY5LM019508","insp_unit_decal":"Y","insp_unit_decal_number":"34302297","created_at":"2025-03-17T23:26:51.000000Z","updated_at":"2025-03-17T23:26:51.000000Z"},{"id":10022050,"change_date":"2024-09-16 21:43:00","inspection_id":"82119670","insp_unit_id":"202945759","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"538632","insp_unit_license":"D679611","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532C9MT178002","insp_unit_decal":"Y","insp_unit_decal_number":"34302298","created_at":"2025-03-17T23:26:51.000000Z","updated_at":"2025-03-17T23:26:51.000000Z"}]},{"id":6586301,"change_date":"2024-08-28 21:42:00","inspection_id":"82510458","dot_number":"1702320","report_state":"MI","report_number":"LAUEJ01618","insp_date":"2024-06-25 00:00:00","insp_start_time":"1750","insp_end_time":"1840","registration_date":null,"region":"ET","ci_status_code":"C","location":"831","location_desc":"MACKINAC BRIDGE","county_code_state":"MI","county_code":"097","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"3","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1192146","transaction_code":"A","transaction_date":"2024-06-25 00:00:00","upload_date":"2024-08-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01702320","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-06-25 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-08-28 21:42:00","insp_carrier_name":"SUN VALLEY FOODS COMPANY","insp_carrier_street":"14401 DEXTER DRIVE","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48238","insp_colonia":null,"docket_number":"4541","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:33:38.000000Z","updated_at":"2025-03-17T20:33:38.000000Z","inspection_violations":[{"id":10239900,"change_date":"2024-08-28 21:42:00","inspection_id":"82510458","insp_violation_id":"261466968","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","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:55:32.000000Z","updated_at":"2025-03-17T21:55:32.000000Z","normalized_code":"38323A2"},{"id":10239901,"change_date":"2024-08-28 21:42:00","inspection_id":"82510458","insp_violation_id":"261466969","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202632567","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:32.000000Z","updated_at":"2025-03-17T21:55:32.000000Z","normalized_code":"3939A"},{"id":10239902,"change_date":"2024-08-28 21:42:00","inspection_id":"82510458","insp_violation_id":"261466970","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202632567","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:32.000000Z","updated_at":"2025-03-17T21:55:32.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":10618271,"change_date":"2024-08-28 21:42:00","inspection_id":"82510458","insp_unit_id":"202632567","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"RB87740","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN2GY2LM019501","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:58.000000Z","updated_at":"2025-03-17T23:32:58.000000Z"},{"id":10618272,"change_date":"2024-08-28 21:42:00","inspection_id":"82510458","insp_unit_id":"202632568","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":null,"insp_unit_license":"E240865","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532C8LT436010","insp_unit_decal":"Y","insp_unit_decal_number":"0","created_at":"2025-03-17T23:32:58.000000Z","updated_at":"2025-03-17T23:32:58.000000Z"}]},{"id":5700237,"change_date":"2024-05-08 21:42:00","inspection_id":"81557143","dot_number":"1702320","report_state":"MI","report_number":"DAWDD03517","insp_date":"2024-05-07 00:00:00","insp_start_time":"0749","insp_end_time":"0810","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":"SUN VALLEY","shipping_paper_number":"272035","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-05-08 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1177628","transaction_code":"A","transaction_date":"2024-05-07 00:00:00","upload_date":"2024-05-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01702320","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-05-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-05-08 21:42:00","insp_carrier_name":"SUN VALLEY FOODS COMPANY","insp_carrier_street":"14401 DEXTER DRIVE","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48238","insp_colonia":null,"docket_number":"4541","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:15:50.000000Z","updated_at":"2025-03-17T20:15:50.000000Z","inspection_violations":[{"id":8817505,"change_date":"2024-05-08 21:42:00","inspection_id":"81557143","insp_violation_id":"259385720","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:48:37.000000Z","updated_at":"2025-03-17T21:48:37.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9181111,"change_date":"2024-05-08 21:42:00","inspection_id":"81557143","insp_unit_id":"200792098","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"60378","insp_unit_license":"RB87805","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5PVNV8JVXL5S60378","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:27.000000Z","updated_at":"2025-03-17T23:18:27.000000Z"}]},{"id":5052664,"change_date":"2024-02-14 21:42:00","inspection_id":"80850958","dot_number":"1702320","report_state":"MI","report_number":"POWEL03494","insp_date":"2024-02-13 00:00:00","insp_start_time":"0605","insp_end_time":"0611","registration_date":null,"region":"ET","ci_status_code":"C","location":"122","location_desc":"FOWLERVILLE SCALE W\/B","county_code_state":"MI","county_code":"093","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAME","shipping_paper_number":"266847","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-02-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"118200","viol_total":"2","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1164812","transaction_code":"A","transaction_date":"2024-02-13 00:00:00","upload_date":"2024-02-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01702320","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-02-13 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-02-14 21:42:00","insp_carrier_name":"SUN VALLEY FOODS COMPANY","insp_carrier_street":"14401 DEXTER DRIVE","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48238","insp_colonia":null,"docket_number":"4541","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:02:46.000000Z","updated_at":"2025-03-17T20:02:46.000000Z","inspection_violations":[{"id":7786394,"change_date":"2024-02-14 21:42:00","inspection_id":"80850958","insp_violation_id":"257840016","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"199425700","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:43:40.000000Z","updated_at":"2025-03-17T21:43:40.000000Z","normalized_code":"3939A"},{"id":7786395,"change_date":"2024-02-14 21:42:00","inspection_id":"80850958","insp_violation_id":"257840017","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"199425700","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:43:40.000000Z","updated_at":"2025-03-17T21:43:40.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":8133120,"change_date":"2024-02-14 21:42:00","inspection_id":"80850958","insp_unit_id":"199425699","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"19501","insp_unit_license":"RB87740","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN2GY2LM019501","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:41.000000Z","updated_at":"2025-03-17T23:08:41.000000Z"},{"id":8133121,"change_date":"2024-02-14 21:42:00","inspection_id":"80850958","insp_unit_id":"199425700","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"636","insp_unit_license":"D679615","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532C4MT178005","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:41.000000Z","updated_at":"2025-03-17T23:08:41.000000Z"}]},{"id":4997881,"change_date":"2024-02-07 21:41:00","inspection_id":"80791023","dot_number":"1702320","report_state":"MI","report_number":"LAUEJ01564","insp_date":"2024-02-06 00:00:00","insp_start_time":"1200","insp_end_time":"1230","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US 2 HWY \/W366","county_code_state":"MI","county_code":"097","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":"2024-02-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1163447","transaction_code":"A","transaction_date":"2024-02-06 00:00:00","upload_date":"2024-02-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01702320","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-02-06 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-02-07 21:41:00","insp_carrier_name":"SUN VALLEY FOODS COMPANY","insp_carrier_street":"14401 DEXTER DRIVE","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48238","insp_colonia":null,"docket_number":"4541","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:01:40.000000Z","updated_at":"2025-03-17T20:01:40.000000Z","inspection_violations":[{"id":7698116,"change_date":"2024-02-07 21:41:00","inspection_id":"80791023","insp_violation_id":"257712039","seq_no":"1","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:43:09.000000Z","updated_at":"2025-03-17T21:43:09.000000Z","normalized_code":"3922"},{"id":7698117,"change_date":"2024-02-07 21:41:00","inspection_id":"80791023","insp_violation_id":"257712040","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199312246","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:09.000000Z","updated_at":"2025-03-17T21:43:09.000000Z","normalized_code":"3922"},{"id":7698118,"change_date":"2024-02-07 21:41:00","inspection_id":"80791023","insp_violation_id":"257712041","seq_no":"3","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"199312246","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:09.000000Z","updated_at":"2025-03-17T21:43:09.000000Z","normalized_code":"39021TB"},{"id":7698119,"change_date":"2024-02-07 21:41:00","inspection_id":"80791023","insp_violation_id":"257712042","seq_no":"4","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"199312246","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:09.000000Z","updated_at":"2025-03-17T21:43:09.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":8044305,"change_date":"2024-02-07 21:41:00","inspection_id":"80791023","insp_unit_id":"199312246","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"RB62663","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AW02Y5JM090018","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:53.000000Z","updated_at":"2025-03-17T23:07:53.000000Z"},{"id":8044306,"change_date":"2024-02-07 21:41:00","inspection_id":"80791023","insp_unit_id":"199312247","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":null,"insp_unit_license":"D679613","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532C1MT178009","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:53.000000Z","updated_at":"2025-03-17T23:07:53.000000Z"}]},{"id":4463714,"change_date":"2023-11-20 21:40:00","inspection_id":"80206041","dot_number":"1702320","report_state":"MI","report_number":"POWEL03392","insp_date":"2023-11-17 00:00:00","insp_start_time":"0825","insp_end_time":"0900","registration_date":null,"region":"ET","ci_status_code":"C","location":"122","location_desc":"FOWLERVILLE SCALE W\/B","county_code_state":"MI","county_code":"093","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAME","shipping_paper_number":"256723","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-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"36000","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":"1154130","transaction_code":"A","transaction_date":"2023-11-17 00:00:00","upload_date":"2023-11-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01702320","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-11-17 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-11-20 21:40:00","insp_carrier_name":"SUN VALLEY FOODS COMPANY","insp_carrier_street":"14401 DEXTER DRIVE","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48238","insp_colonia":null,"docket_number":"4541","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:51:23.000000Z","updated_at":"2025-03-17T19:51:23.000000Z","inspection_violations":[{"id":6908709,"change_date":"2023-11-20 21:40:00","inspection_id":"80206041","insp_violation_id":"256490080","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"198146167","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:39:20.000000Z","updated_at":"2025-03-17T21:39:20.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":7178638,"change_date":"2023-11-20 21:40:00","inspection_id":"80206041","insp_unit_id":"198146167","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"60379","insp_unit_license":"RB87804","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5PVNV8JV1L5S60379","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:16.000000Z","updated_at":"2025-03-17T23:00:16.000000Z"}]},{"id":4184843,"change_date":"2023-10-12 21:42:00","inspection_id":"79897877","dot_number":"1702320","report_state":"MI","report_number":"MCGEJ03016","insp_date":"2023-10-12 00:00:00","insp_start_time":"0715","insp_end_time":"0808","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"I75 NB @ 4 MILE REST AREA","county_code_state":"MI","county_code":"039","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"MULTIPLE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-12 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1149386","transaction_code":"A","transaction_date":"2023-10-12 00:00:00","upload_date":"2023-10-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01702320","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-10-12 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-10-12 21:42:00","insp_carrier_name":"SUN VALLEY FOODS COMPANY","insp_carrier_street":"14401 DEXTER DRIVE","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48238","insp_colonia":null,"docket_number":"4541","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:45:50.000000Z","updated_at":"2025-03-17T19:45:50.000000Z","inspection_violations":[{"id":6478754,"change_date":"2023-10-12 21:42:00","inspection_id":"79897877","insp_violation_id":"255803839","seq_no":"1","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"197528135","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:12.000000Z","updated_at":"2025-03-17T21:37:12.000000Z","normalized_code":"39021TB"},{"id":6478755,"change_date":"2023-10-12 21:42:00","inspection_id":"79897877","insp_violation_id":"255803840","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"197528136","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:12.000000Z","updated_at":"2025-03-17T21:37:12.000000Z","normalized_code":"3939A"},{"id":6478756,"change_date":"2023-10-12 21:42:00","inspection_id":"79897877","insp_violation_id":"255803841","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"197528136","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:12.000000Z","updated_at":"2025-03-17T21:37:12.000000Z","normalized_code":"3939A"},{"id":6478757,"change_date":"2023-10-12 21:42:00","inspection_id":"79897877","insp_violation_id":"255803842","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"197528136","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:37:12.000000Z","updated_at":"2025-03-17T21:37:12.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":6729838,"change_date":"2023-10-12 21:42:00","inspection_id":"79897877","insp_unit_id":"197528135","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"RB37382","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AW02Y6GM051396","insp_unit_decal":"Y","insp_unit_decal_number":"33396685","created_at":"2025-03-17T22:56:24.000000Z","updated_at":"2025-03-17T22:56:24.000000Z"},{"id":6729839,"change_date":"2023-10-12 21:42:00","inspection_id":"79897877","insp_unit_id":"197528136","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"539941","insp_unit_license":"E123567","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532C2JT400004","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:24.000000Z","updated_at":"2025-03-17T22:56:24.000000Z"}]},{"id":3934031,"change_date":"2023-09-08 21:41:00","inspection_id":"79619575","dot_number":"1702320","report_state":"MI","report_number":"JURKV02353","insp_date":"2023-09-07 00:00:00","insp_start_time":"0700","insp_end_time":"0718","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ROAD","county_code_state":"MI","county_code":"145","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1145077","transaction_code":"A","transaction_date":"2023-09-07 00:00:00","upload_date":"2023-09-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01702320","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-09-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-09-08 21:41:00","insp_carrier_name":"SUN VALLEY FOODS COMPANY","insp_carrier_street":"14401 DEXTER DRIVE","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48238","insp_colonia":null,"docket_number":"4541","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:40:29.000000Z","updated_at":"2025-03-17T19:40:29.000000Z","inspection_violations":[{"id":6080652,"change_date":"2023-09-08 21:41:00","inspection_id":"79619575","insp_violation_id":"255164339","seq_no":"1","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:35:25.000000Z","updated_at":"2025-03-17T21:35:25.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6325731,"change_date":"2023-09-08 21:41:00","inspection_id":"79619575","insp_unit_id":"196968265","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"19506","insp_unit_license":"RB87741","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN2GY1LM019506","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:09.000000Z","updated_at":"2025-03-17T22:53:09.000000Z"},{"id":6325732,"change_date":"2023-09-08 21:41:00","inspection_id":"79619575","insp_unit_id":"196968266","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"538632","insp_unit_license":"DD679611","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532C9MT178002","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:09.000000Z","updated_at":"2025-03-17T22:53:09.000000Z"}]},{"id":3888696,"change_date":"2023-09-01 21:39:00","inspection_id":"79569104","dot_number":"1702320","report_state":"MI","report_number":"JURKV02346","insp_date":"2023-09-01 00:00:00","insp_start_time":"0650","insp_end_time":"0707","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ROAD","county_code_state":"MI","county_code":"145","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1144097","transaction_code":"A","transaction_date":"2023-09-01 00:00:00","upload_date":"2023-09-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01702320","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-09-01 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-09-01 21:39:00","insp_carrier_name":"SUN VALLEY FOODS COMPANY","insp_carrier_street":"14401 DEXTER DRIVE","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48238","insp_colonia":null,"docket_number":"4541","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:39:43.000000Z","updated_at":"2025-03-17T19:39:43.000000Z","inspection_violations":[{"id":6009419,"change_date":"2023-09-01 21:39:00","inspection_id":"79569104","insp_violation_id":"255045495","seq_no":"1","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:35:06.000000Z","updated_at":"2025-03-17T21:35:06.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6252005,"change_date":"2023-09-01 21:39:00","inspection_id":"79569104","insp_unit_id":"196865296","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"19506","insp_unit_license":"RB87741","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN2GY1LM019506","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:32.000000Z","updated_at":"2025-03-17T22:52:32.000000Z"},{"id":6252006,"change_date":"2023-09-01 21:39:00","inspection_id":"79569104","insp_unit_id":"196865297","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"538632","insp_unit_license":"D679611","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532C9MT178002","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:32.000000Z","updated_at":"2025-03-17T22:52:32.000000Z"}]},{"id":3674742,"change_date":"2023-08-29 21:42:00","inspection_id":"79330398","dot_number":"1702320","report_state":"MI","report_number":"BURGM05471","insp_date":"2023-08-02 00:00:00","insp_start_time":"1035","insp_end_time":"1129","registration_date":null,"region":"ET","ci_status_code":"C","location":"122","location_desc":"FOWLERVILLE SCALE W\/B","county_code_state":"MI","county_code":"093","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SUN VALLEY","shipping_paper_number":"249388","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-08-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"101500","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":"1138401","transaction_code":"C","transaction_date":"2023-08-02 00:00:00","upload_date":"2023-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01702320","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-08-02 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-08-04 21:41:00","insp_carrier_name":"SUN VALLEY FOODS COMPANY","insp_carrier_street":"14401 DEXTER DRIVE","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48238","insp_colonia":null,"docket_number":"4541","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:35:19.000000Z","updated_at":"2025-03-17T19:35:19.000000Z","inspection_violations":[{"id":5664304,"change_date":"2023-08-29 21:42:00","inspection_id":"79330398","insp_violation_id":"254954792","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4260573","created_at":"2025-03-17T21:33:16.000000Z","updated_at":"2025-03-17T21:33:16.000000Z","normalized_code":"3922"},{"id":5664305,"change_date":"2023-08-29 21:42:00","inspection_id":"79330398","insp_violation_id":"254954793","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196789835","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:16.000000Z","updated_at":"2025-03-17T21:33:16.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":5908159,"change_date":"2023-08-29 21:42:00","inspection_id":"79330398","insp_unit_id":"196789835","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"19505","insp_unit_license":"RB87742","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN2GYXLM019505","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:40.000000Z","updated_at":"2025-03-17T22:49:40.000000Z"},{"id":5908160,"change_date":"2023-08-29 21:42:00","inspection_id":"79330398","insp_unit_id":"196789836","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"538638","insp_unit_license":"D679616","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532C6MT178006","insp_unit_decal":"Y","insp_unit_decal_number":"33029133","created_at":"2025-03-17T22:49:40.000000Z","updated_at":"2025-03-17T22:49:40.000000Z"}]},{"id":3609524,"change_date":"2023-07-27 21:40:00","inspection_id":"79257039","dot_number":"1702320","report_state":"MI","report_number":"RODRR02253","insp_date":"2023-07-27 00:00:00","insp_start_time":"1020","insp_end_time":"1040","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US-31 SB @ GREENLY ST","county_code_state":"MI","county_code":"139","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAME AS CARRIER","shipping_paper_number":"248857","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-07-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1137224","transaction_code":"A","transaction_date":"2023-07-27 00:00:00","upload_date":"2023-07-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01702320","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-07-27 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-07-27 21:40:00","insp_carrier_name":"SUN VALLEY FOODS COMPANY","insp_carrier_street":"14401 DEXTER DRIVE","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48238","insp_colonia":null,"docket_number":"4541","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:34:13.000000Z","updated_at":"2025-03-17T19:34:13.000000Z","inspection_violations":[{"id":5566485,"change_date":"2023-07-27 21:40:00","inspection_id":"79257039","insp_violation_id":"254318528","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:32:49.000000Z","updated_at":"2025-03-17T21:32:49.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5803458,"change_date":"2023-07-27 21:40:00","inspection_id":"79257039","insp_unit_id":"196228567","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"19505","insp_unit_license":"RB87742","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN2GYXLM019505","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:48.000000Z","updated_at":"2025-03-17T22:48:48.000000Z"},{"id":5803459,"change_date":"2023-07-27 21:40:00","inspection_id":"79257039","insp_unit_id":"196228568","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"538636","insp_unit_license":"D679615","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532C4MT178005","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:48.000000Z","updated_at":"2025-03-17T22:48:48.000000Z"}]},{"id":3434171,"change_date":"2023-07-05 21:42:00","inspection_id":"79059912","dot_number":"1702320","report_state":"MI","report_number":"POWEL03221","insp_date":"2023-07-03 00:00:00","insp_start_time":"0800","insp_end_time":"0835","registration_date":null,"region":"ET","ci_status_code":"C","location":"122","location_desc":"FOWLERVILLE SCALE W\/B","county_code_state":"MI","county_code":"093","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAME","shipping_paper_number":"24777813","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-07-05 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"36000","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1133482","transaction_code":"A","transaction_date":"2023-07-03 00:00:00","upload_date":"2023-07-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01702320","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-07-03 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-07-05 21:42:00","insp_carrier_name":"SUN VALLEY FOODS COMPANY","insp_carrier_street":"14401 DEXTER DRIVE","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48238","insp_colonia":null,"docket_number":"4541","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:30:58.000000Z","updated_at":"2025-03-17T19:30:58.000000Z","inspection_violations":[{"id":5292907,"change_date":"2023-07-05 21:42:00","inspection_id":"79059912","insp_violation_id":"253867499","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"X4235973","created_at":"2025-03-17T21:31:34.000000Z","updated_at":"2025-03-17T21:31:34.000000Z","normalized_code":"38323A2"},{"id":5292908,"change_date":"2023-07-05 21:42:00","inspection_id":"79059912","insp_violation_id":"253867500","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195828393","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:34.000000Z","updated_at":"2025-03-17T21:31:34.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":5521709,"change_date":"2023-07-05 21:42:00","inspection_id":"79059912","insp_unit_id":"195828393","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"60380","insp_unit_license":"RB98982","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5PVNV8JV8L5S60380","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:35.000000Z","updated_at":"2025-03-17T22:46:35.000000Z"}]},{"id":3304460,"change_date":"2023-06-16 21:40:00","inspection_id":"78914516","dot_number":"1702320","report_state":"MI","report_number":"BRACG00903","insp_date":"2023-06-15 00:00:00","insp_start_time":"1321","insp_end_time":"1339","registration_date":null,"region":"ET","ci_status_code":"C","location":"121","location_desc":"FOWLERVILLE SCALE E\/B","county_code_state":"MI","county_code":"093","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAC","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":"2023-06-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","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":"1130779","transaction_code":"A","transaction_date":"2023-06-15 00:00:00","upload_date":"2023-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01702320","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-06-15 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-06-16 21:40:00","insp_carrier_name":"SUN VALLEY FOODS COMPANY","insp_carrier_street":"14401 DEXTER DRIVE","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48238","insp_colonia":null,"docket_number":"4541","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:28:30.000000Z","updated_at":"2025-03-17T19:28:30.000000Z","inspection_violations":[{"id":5095871,"change_date":"2023-06-16 21:40:00","inspection_id":"78914516","insp_violation_id":"253553546","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195541412","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:40.000000Z","updated_at":"2025-03-17T21:30:40.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":5312605,"change_date":"2023-06-16 21:40:00","inspection_id":"78914516","insp_unit_id":"195541412","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"1905","insp_unit_license":"RB87742","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN2GYXLM019505","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:54.000000Z","updated_at":"2025-03-17T22:44:54.000000Z"},{"id":5312606,"change_date":"2023-06-16 21:40:00","inspection_id":"78914516","insp_unit_id":"195541413","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"538632","insp_unit_license":"D679611","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532C9MT178002","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:54.000000Z","updated_at":"2025-03-17T22:44:54.000000Z"}]},{"id":3274604,"change_date":"2023-06-13 21:42:00","inspection_id":"78880511","dot_number":"1702320","report_state":"MI","report_number":"KELLC01821","insp_date":"2023-06-13 00:00:00","insp_start_time":"0950","insp_end_time":"1024","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I75NB @ 4 MILE REST AREA","county_code_state":"MI","county_code":"039","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1130343","transaction_code":"A","transaction_date":"2023-06-13 00:00:00","upload_date":"2023-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01702320","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-06-13 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-06-13 21:42:00","insp_carrier_name":"SUN VALLEY FOODS COMPANY","insp_carrier_street":"14401 DEXTER DRIVE","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48238","insp_colonia":null,"docket_number":"4541","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:27:45.000000Z","updated_at":"2025-03-17T19:27:45.000000Z","inspection_violations":[{"id":5048917,"change_date":"2023-06-13 21:42:00","inspection_id":"78880511","insp_violation_id":"253476498","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":"X4233462","created_at":"2025-03-17T21:30:29.000000Z","updated_at":"2025-03-17T21:30:29.000000Z","normalized_code":"39216A"},{"id":5048918,"change_date":"2023-06-13 21:42:00","inspection_id":"78880511","insp_violation_id":"253476499","seq_no":"2","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"195474200","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:29.000000Z","updated_at":"2025-03-17T21:30:29.000000Z","normalized_code":"39360C"}],"inspection_per_units":[{"id":5265229,"change_date":"2023-06-13 21:42:00","inspection_id":"78880511","insp_unit_id":"195474200","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"19502","insp_unit_license":"RB87745","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN2GY4LM019502","insp_unit_decal":"Y","insp_unit_decal_number":"32662255","created_at":"2025-03-17T22:44:31.000000Z","updated_at":"2025-03-17T22:44:31.000000Z"},{"id":5265230,"change_date":"2023-06-13 21:42:00","inspection_id":"78880511","insp_unit_id":"195474201","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"538638","insp_unit_license":"D679616","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532C6MT178006","insp_unit_decal":"Y","insp_unit_decal_number":"32662256","created_at":"2025-03-17T22:44:31.000000Z","updated_at":"2025-03-17T22:44:31.000000Z"}]},{"id":3094050,"change_date":"2023-05-19 21:43:00","inspection_id":"78676654","dot_number":"1702320","report_state":"IN","report_number":"8843003593","insp_date":"2023-05-18 00:00:00","insp_start_time":"0815","insp_end_time":"0946","registration_date":null,"region":"CT","ci_status_code":"C","location":"1365S","location_desc":"#13  I-65 SB  LAKE","county_code_state":"IN","county_code":"089","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"CANTEEN SERVICES INC","shipping_paper_number":"243722","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":"I","final_status_date":"2023-05-19 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"2190406","transaction_code":"A","transaction_date":"2023-05-19 00:00:00","upload_date":"2023-05-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01702320","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-05-19 00:00:00","source_office":"3INS001","mcmis_add_date":"2023-05-19 21:43:00","insp_carrier_name":"SUN VALLEY FOODS COMPANY","insp_carrier_street":"14401 DEXTER DRIVE","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48238","insp_colonia":null,"docket_number":"4541","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:24:12.000000Z","updated_at":"2025-03-17T19:24:12.000000Z","inspection_violations":[{"id":4757014,"change_date":"2023-05-19 21:43:00","inspection_id":"78676654","insp_violation_id":"252955067","seq_no":"1","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"195038702","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:29:08.000000Z","updated_at":"2025-03-17T21:29:08.000000Z","normalized_code":"39345"},{"id":4757015,"change_date":"2023-05-19 21:43:00","inspection_id":"78676654","insp_violation_id":"252955068","seq_no":"2","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"195038703","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:08.000000Z","updated_at":"2025-03-17T21:29:08.000000Z","normalized_code":"39355E"},{"id":4757016,"change_date":"2023-05-19 21:43:00","inspection_id":"78676654","insp_violation_id":"252955069","seq_no":"3","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"195038702","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:08.000000Z","updated_at":"2025-03-17T21:29:08.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":4976852,"change_date":"2023-05-19 21:43:00","inspection_id":"78676654","insp_unit_id":"195038702","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"19501","insp_unit_license":"RB87740","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN2GY2LM019501","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:15.000000Z","updated_at":"2025-03-17T22:42:15.000000Z"},{"id":4976853,"change_date":"2023-05-19 21:43:00","inspection_id":"78676654","insp_unit_id":"195038703","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"538633","insp_unit_license":"D679612","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532C0MT178003","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:15.000000Z","updated_at":"2025-03-17T22:42:15.000000Z"}]},{"id":2918328,"change_date":"2023-04-28 21:39:00","inspection_id":"78478545","dot_number":"1702320","report_state":"MI","report_number":"STOCC04126","insp_date":"2023-04-28 00:00:00","insp_start_time":"0650","insp_end_time":"0740","registration_date":null,"region":"ET","ci_status_code":"C","location":"132","location_desc":"GRASS LAKE SCALE W\/B","county_code_state":"MI","county_code":"075","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SUN VALLEY FOODS","shipping_paper_number":"241179","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-04-28 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1124095","transaction_code":"A","transaction_date":"2023-04-28 00:00:00","upload_date":"2023-04-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01702320","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-04-28 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-04-28 21:39:00","insp_carrier_name":"SUN VALLEY FOODS COMPANY","insp_carrier_street":"14401 DEXTER DRIVE","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48238","insp_colonia":null,"docket_number":"4541","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:20:29.000000Z","updated_at":"2025-03-17T19:20:29.000000Z","inspection_violations":[{"id":4478778,"change_date":"2023-04-28 21:39:00","inspection_id":"78478545","insp_violation_id":"252506240","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4206728","created_at":"2025-03-17T21:27:51.000000Z","updated_at":"2025-03-17T21:27:51.000000Z","normalized_code":"3922"},{"id":4478779,"change_date":"2023-04-28 21:39:00","inspection_id":"78478545","insp_violation_id":"252506241","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"194645340","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:51.000000Z","updated_at":"2025-03-17T21:27:51.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":4695300,"change_date":"2023-04-28 21:39:00","inspection_id":"78478545","insp_unit_id":"194645340","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"60377","insp_unit_license":"RB87803","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5PVNV8JV8L5S60377","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:02.000000Z","updated_at":"2025-03-17T22:40:02.000000Z"}]},{"id":2828454,"change_date":"2023-04-18 21:42:00","inspection_id":"78376520","dot_number":"1702320","report_state":"MI","report_number":"BYARC00841","insp_date":"2023-04-17 00:00:00","insp_start_time":"1402","insp_end_time":"1422","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US41 \/ EVERGREEN STRETCH","county_code_state":"MI","county_code":"103","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-04-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1122353","transaction_code":"A","transaction_date":"2023-04-17 00:00:00","upload_date":"2023-04-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01702320","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-04-17 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-04-18 21:42:00","insp_carrier_name":"SUN VALLEY FOODS COMPANY","insp_carrier_street":"14401 DEXTER DRIVE","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48238","insp_colonia":null,"docket_number":"4541","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:18:54.000000Z","updated_at":"2025-03-17T19:18:54.000000Z","inspection_violations":[{"id":4340104,"change_date":"2023-04-18 21:42:00","inspection_id":"78376520","insp_violation_id":"252286406","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:27:18.000000Z","updated_at":"2025-03-17T21:27:18.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4552821,"change_date":"2023-04-18 21:42:00","inspection_id":"78376520","insp_unit_id":"194446800","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"19508","insp_unit_license":"RB87747","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN2GY5LM019508","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:54.000000Z","updated_at":"2025-03-17T22:38:54.000000Z"},{"id":4552822,"change_date":"2023-04-18 21:42:00","inspection_id":"78376520","insp_unit_id":"194446801","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"538650","insp_unit_license":"D679613","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532C1MT178009","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:54.000000Z","updated_at":"2025-03-17T22:38:54.000000Z"}]},{"id":2818158,"change_date":"2023-04-17 21:41:00","inspection_id":"78364963","dot_number":"1702320","report_state":"MI","report_number":"POWEL03101","insp_date":"2023-04-14 00:00:00","insp_start_time":"0700","insp_end_time":"0725","registration_date":null,"region":"ET","ci_status_code":"C","location":"121","location_desc":"FOWLERVILLE SCALE E\/B","county_code_state":"MI","county_code":"093","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAME","shipping_paper_number":"240984","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-04-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1122105","transaction_code":"A","transaction_date":"2023-04-14 00:00:00","upload_date":"2023-04-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01702320","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-04-14 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-04-17 21:41:00","insp_carrier_name":"SUN VALLEY FOODS COMPANY","insp_carrier_street":"14401 DEXTER DRIVE","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48238","insp_colonia":null,"docket_number":"4541","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:18:34.000000Z","updated_at":"2025-03-17T19:18:34.000000Z","inspection_violations":[{"id":4324215,"change_date":"2023-04-17 21:41:00","inspection_id":"78364963","insp_violation_id":"252259846","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:14.000000Z","updated_at":"2025-03-17T21:27:14.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4535750,"change_date":"2023-04-17 21:41:00","inspection_id":"78364963","insp_unit_id":"194422377","insp_unit_type_id":"6","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"309","insp_unit_license":"RB21470","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5PVNV8JV2F4S54309","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:46.000000Z","updated_at":"2025-03-17T22:38:46.000000Z"}]},{"id":2787529,"change_date":"2023-05-05 21:42:00","inspection_id":"78330126","dot_number":"1702320","report_state":"MI","report_number":"MCGEJ02769","insp_date":"2023-04-11 00:00:00","insp_start_time":"1100","insp_end_time":"1127","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"I75 NB @MM 166","county_code_state":"MI","county_code":"039","insp_level_id":"3","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-04-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1121484","transaction_code":"C","transaction_date":"2023-05-03 00:00:00","upload_date":"2023-05-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01702320","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-04-11 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-04-12 21:40:00","insp_carrier_name":"SUN VALLEY FOODS COMPANY","insp_carrier_street":"14401 DEXTER DRIVE","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48238","insp_colonia":null,"docket_number":"4541","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:18:04.000000Z","updated_at":"2025-03-17T19:18:04.000000Z","inspection_violations":[{"id":4276508,"change_date":"2023-05-05 21:42:00","inspection_id":"78330126","insp_violation_id":"252651900","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":"X4194756","created_at":"2025-03-17T21:26:58.000000Z","updated_at":"2025-03-17T21:26:58.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":4486653,"change_date":"2023-05-05 21:42:00","inspection_id":"78330126","insp_unit_id":"194775206","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"51404","insp_unit_license":"RC19563","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AW02Y1GM051404","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:23.000000Z","updated_at":"2025-03-17T22:38:23.000000Z"},{"id":4486654,"change_date":"2023-05-05 21:42:00","inspection_id":"78330126","insp_unit_id":"194775207","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"538638","insp_unit_license":"D679616","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532C6MT178006","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:23.000000Z","updated_at":"2025-03-17T22:38:23.000000Z"}]},{"id":2741349,"change_date":"2023-04-05 21:41:00","inspection_id":"78277920","dot_number":"1702320","report_state":"MI","report_number":"HADZM03648","insp_date":"2023-04-04 00:00:00","insp_start_time":"1430","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":"CARRIERE","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":"2023-04-05 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1120661","transaction_code":"A","transaction_date":"2023-04-04 00:00:00","upload_date":"2023-04-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01702320","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-04-04 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-04-05 21:41:00","insp_carrier_name":"SUN VALLEY FOODS COMPANY","insp_carrier_street":"14401 DEXTER DRIVE","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48238","insp_colonia":null,"docket_number":"4541","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:17:18.000000Z","updated_at":"2025-03-17T19:17:18.000000Z","inspection_violations":[{"id":4208058,"change_date":"2023-04-05 21:41:00","inspection_id":"78277920","insp_violation_id":"252064465","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"194244059","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:41.000000Z","updated_at":"2025-03-17T21:26:41.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":4412615,"change_date":"2023-04-05 21:41:00","inspection_id":"78277920","insp_unit_id":"194244059","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"506","insp_unit_license":"RB87741","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN2GY1LM019506","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:44.000000Z","updated_at":"2025-03-17T22:37:44.000000Z"},{"id":4412616,"change_date":"2023-04-05 21:41:00","inspection_id":"78277920","insp_unit_id":"194244060","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"538630","insp_unit_license":"D679610","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532C7MT178001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:44.000000Z","updated_at":"2025-03-17T22:37:44.000000Z"}]},{"id":2585847,"change_date":"2023-03-15 21:42:00","inspection_id":"78100627","dot_number":"1702320","report_state":"MI","report_number":"FRIZS02693","insp_date":"2023-03-14 00:00:00","insp_start_time":"0802","insp_end_time":"0824","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CADILLAC DR @ LAKE STATION","county_code_state":"MI","county_code":"035","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SUN VALLEY FOODS","shipping_paper_number":"236788","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-15 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1117663","transaction_code":"A","transaction_date":"2023-03-14 00:00:00","upload_date":"2023-03-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01702320","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-03-14 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-03-15 21:42:00","insp_carrier_name":"SUN VALLEY FOODS COMPANY","insp_carrier_street":"14401 DEXTER DRIVE","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48238","insp_colonia":null,"docket_number":"4541","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:14:27.000000Z","updated_at":"2025-03-17T19:14:27.000000Z","inspection_violations":[{"id":3976735,"change_date":"2023-03-15 21:42:00","inspection_id":"78100627","insp_violation_id":"251680928","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:25:38.000000Z","updated_at":"2025-03-17T21:25:38.000000Z","normalized_code":"3922"},{"id":3976736,"change_date":"2023-03-15 21:42:00","inspection_id":"78100627","insp_violation_id":"251680929","seq_no":"2","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"193890584","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:38.000000Z","updated_at":"2025-03-17T21:25:38.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":4162051,"change_date":"2023-03-15 21:42:00","inspection_id":"78100627","insp_unit_id":"193890584","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"19508","insp_unit_license":"RB87747","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN2GY5LM019508","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:50.000000Z","updated_at":"2025-03-17T22:35:50.000000Z"},{"id":4162052,"change_date":"2023-03-15 21:42:00","inspection_id":"78100627","insp_unit_id":"193890585","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"538633","insp_unit_license":"D679612","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532C0MT178003","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:50.000000Z","updated_at":"2025-03-17T22:35:50.000000Z"}]},{"id":2513220,"change_date":"2023-03-06 21:40:00","inspection_id":"78017853","dot_number":"1702320","report_state":"MI","report_number":"KIRKB04060","insp_date":"2023-03-06 00:00:00","insp_start_time":"0955","insp_end_time":"1125","registration_date":null,"region":"ET","ci_status_code":"C","location":"121","location_desc":"FOWLERVILLE SCALE E\/B","county_code_state":"MI","county_code":"093","insp_level_id":"1","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1116282","transaction_code":"A","transaction_date":"2023-03-06 00:00:00","upload_date":"2023-03-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01702320","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-03-06 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-03-06 21:40:00","insp_carrier_name":"SUN VALLEY FOODS COMPANY","insp_carrier_street":"14401 DEXTER DRIVE","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48238","insp_colonia":null,"docket_number":"4541","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:12:57.000000Z","updated_at":"2025-03-17T19:12:57.000000Z","inspection_violations":[{"id":3864298,"change_date":"2023-03-06 21:40:00","inspection_id":"78017853","insp_violation_id":"251494543","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"193723951","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:10.000000Z","updated_at":"2025-03-17T21:25:10.000000Z","normalized_code":"39378"},{"id":3864299,"change_date":"2023-03-06 21:40:00","inspection_id":"78017853","insp_violation_id":"251494544","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"193723951","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4182737","created_at":"2025-03-17T21:25:10.000000Z","updated_at":"2025-03-17T21:25:10.000000Z","normalized_code":"39617C"},{"id":3864300,"change_date":"2023-03-06 21:40:00","inspection_id":"78017853","insp_violation_id":"251494545","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"193723952","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4182737","created_at":"2025-03-17T21:25:10.000000Z","updated_at":"2025-03-17T21:25:10.000000Z","normalized_code":"39617C"},{"id":3864301,"change_date":"2023-03-06 21:40:00","inspection_id":"78017853","insp_violation_id":"251494546","seq_no":"4","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"193723952","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4182737","created_at":"2025-03-17T21:25:10.000000Z","updated_at":"2025-03-17T21:25:10.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":4044979,"change_date":"2023-03-06 21:40:00","inspection_id":"78017853","insp_unit_id":"193723951","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"19508","insp_unit_license":"RB87747","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN2GY5LM019508","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:59.000000Z","updated_at":"2025-03-17T22:34:59.000000Z"},{"id":4044980,"change_date":"2023-03-06 21:40:00","inspection_id":"78017853","insp_unit_id":"193723952","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"538630","insp_unit_license":"D679610","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532C7MT178001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:59.000000Z","updated_at":"2025-03-17T22:34:59.000000Z"}]},{"id":2273694,"change_date":"2023-02-01 21:41:00","inspection_id":"77744960","dot_number":"1702320","report_state":"MI","report_number":"NESBA00168","insp_date":"2023-01-31 00:00:00","insp_start_time":"1005","insp_end_time":"1030","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"N\/B I-75@ RATTALEE LAKE RD","county_code_state":"MI","county_code":"125","insp_level_id":"3","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-01 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1111678","transaction_code":"A","transaction_date":"2023-01-31 00:00:00","upload_date":"2023-02-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01702320","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-01-31 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-02-01 21:41:00","insp_carrier_name":"SUN VALLEY FOODS COMPANY","insp_carrier_street":"14401 DEXTER DRIVE","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48238","insp_colonia":null,"docket_number":"4541","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:08:31.000000Z","updated_at":"2025-03-17T19:08:31.000000Z","inspection_violations":[{"id":3507644,"change_date":"2023-02-01 21:41:00","inspection_id":"77744960","insp_violation_id":"250890298","seq_no":"1","part_no":"392","part_no_section":"82(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4155435","created_at":"2025-03-17T21:23:34.000000Z","updated_at":"2025-03-17T21:23:34.000000Z","normalized_code":"39282A1"}],"inspection_per_units":[{"id":3660277,"change_date":"2023-02-01 21:41:00","inspection_id":"77744960","insp_unit_id":"193173398","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"19506","insp_unit_license":"RB87741","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN2GY1LM019506","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:15.000000Z","updated_at":"2025-03-17T22:32:15.000000Z"},{"id":3660278,"change_date":"2023-02-01 21:41:00","inspection_id":"77744960","insp_unit_id":"193173399","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"538630","insp_unit_license":"D679610","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532C7MT178001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:15.000000Z","updated_at":"2025-03-17T22:32:15.000000Z"}]},{"id":2273733,"change_date":"2023-02-01 21:41:00","inspection_id":"77745004","dot_number":"1702320","report_state":"MI","report_number":"STOCC03989","insp_date":"2023-01-31 00:00:00","insp_start_time":"1155","insp_end_time":"1250","registration_date":null,"region":"ET","ci_status_code":"C","location":"132","location_desc":"GRASS LAKE SCALE W\/B","county_code_state":"MI","county_code":"075","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SUN VALLEY FOODS CO.","shipping_paper_number":"44","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-02-01 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","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":"1111584","transaction_code":"A","transaction_date":"2023-01-31 00:00:00","upload_date":"2023-02-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01702320","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-01-31 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-02-01 21:41:00","insp_carrier_name":"SUN VALLEY FOODS COMPANY","insp_carrier_street":"14401 DEXTER DRIVE","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48238","insp_colonia":null,"docket_number":"4541","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:08:31.000000Z","updated_at":"2025-03-17T19:08:31.000000Z","inspection_violations":[{"id":3507696,"change_date":"2023-02-01 21:41:00","inspection_id":"77745004","insp_violation_id":"250890366","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4171884","created_at":"2025-03-17T21:23:34.000000Z","updated_at":"2025-03-17T21:23:34.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3660339,"change_date":"2023-02-01 21:41:00","inspection_id":"77745004","insp_unit_id":"193173476","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"19507","insp_unit_license":"RB87743","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN2GY3LM019507","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:15.000000Z","updated_at":"2025-03-17T22:32:15.000000Z"},{"id":3660340,"change_date":"2023-02-01 21:41:00","inspection_id":"77745004","insp_unit_id":"193173477","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"538632","insp_unit_license":"D679611","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532C9MT178002","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:15.000000Z","updated_at":"2025-03-17T22:32:15.000000Z"}]},{"id":2266113,"change_date":"2023-01-31 21:43:00","inspection_id":"77736355","dot_number":"1702320","report_state":"MI","report_number":"DELMT00274","insp_date":"2023-01-30 00:00:00","insp_start_time":"1633","insp_end_time":"1655","registration_date":null,"region":"ET","ci_status_code":"C","location":"131","location_desc":"GRASS LAKE SCALE E\/B","county_code_state":"MI","county_code":"075","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","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-01-31 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1111525","transaction_code":"A","transaction_date":"2023-01-30 00:00:00","upload_date":"2023-01-31 00:00:00","upload_first_byte":"0","upload_dot_number":"01702320","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-01-30 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-01-31 21:43:00","insp_carrier_name":"SUN VALLEY FOODS COMPANY","insp_carrier_street":"14401 DEXTER DRIVE","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48238","insp_colonia":null,"docket_number":"4541","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:08:29.000000Z","updated_at":"2025-03-17T19:08:29.000000Z","inspection_violations":[{"id":3496428,"change_date":"2023-01-31 21:43:00","inspection_id":"77736355","insp_violation_id":"250871675","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193155370","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:30.000000Z","updated_at":"2025-03-17T21:23:30.000000Z","normalized_code":"3939A"},{"id":3496429,"change_date":"2023-01-31 21:43:00","inspection_id":"77736355","insp_violation_id":"250871676","seq_no":"2","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"193155371","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:23:30.000000Z","updated_at":"2025-03-17T21:23:30.000000Z","normalized_code":"39375A3"},{"id":3496430,"change_date":"2023-01-31 21:43:00","inspection_id":"77736355","insp_violation_id":"250871677","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"193155371","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:30.000000Z","updated_at":"2025-03-17T21:23:30.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":3647740,"change_date":"2023-01-31 21:43:00","inspection_id":"77736355","insp_unit_id":"193155370","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"RB87740","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN2GY2LM019501","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:08.000000Z","updated_at":"2025-03-17T22:32:08.000000Z"},{"id":3647741,"change_date":"2023-01-31 21:43:00","inspection_id":"77736355","insp_unit_id":"193155371","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"538633","insp_unit_license":"D679612","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532C0MT178003","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:08.000000Z","updated_at":"2025-03-17T22:32:08.000000Z"}]},{"id":2166756,"change_date":"2023-01-18 21:40:00","inspection_id":"77623307","dot_number":"1702320","report_state":"MI","report_number":"BACZM01776","insp_date":"2023-01-18 00:00:00","insp_start_time":"0907","insp_end_time":"0955","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I75 NB @ LAKE RD","county_code_state":"MI","county_code":"049","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"MULTIPLE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1109655","transaction_code":"A","transaction_date":"2023-01-18 00:00:00","upload_date":"2023-01-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01702320","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-01-18 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-01-18 21:40:00","insp_carrier_name":"SUN VALLEY FOODS COMPANY","insp_carrier_street":"14401 DEXTER DRIVE","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48238","insp_colonia":null,"docket_number":"4541","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:06:36.000000Z","updated_at":"2025-03-17T19:06:36.000000Z","inspection_violations":[{"id":3350772,"change_date":"2023-01-18 21:40:00","inspection_id":"77623307","insp_violation_id":"250631371","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"192925565","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4157269","created_at":"2025-03-17T21:22:50.000000Z","updated_at":"2025-03-17T21:22:50.000000Z","normalized_code":"3922"},{"id":3350773,"change_date":"2023-01-18 21:40:00","inspection_id":"77623307","insp_violation_id":"250631372","seq_no":"2","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"192925565","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:50.000000Z","updated_at":"2025-03-17T21:22:50.000000Z","normalized_code":"39395F"},{"id":3350774,"change_date":"2023-01-18 21:40:00","inspection_id":"77623307","insp_violation_id":"250631373","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"192925565","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:50.000000Z","updated_at":"2025-03-17T21:22:50.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":3487289,"change_date":"2023-01-18 21:40:00","inspection_id":"77623307","insp_unit_id":"192925565","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"RB87803","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5PVNV8JV8L5S60377","insp_unit_decal":"Y","insp_unit_decal_number":"32323257","created_at":"2025-03-17T22:31:00.000000Z","updated_at":"2025-03-17T22:31:00.000000Z"}]},{"id":2140988,"change_date":"2023-01-13 21:40:00","inspection_id":"77593247","dot_number":"1702320","report_state":"MI","report_number":"CELMS00216","insp_date":"2023-01-12 00:00:00","insp_start_time":"1650","insp_end_time":"1715","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":"2023-01-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1109216","transaction_code":"A","transaction_date":"2023-01-12 00:00:00","upload_date":"2023-01-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01702320","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-01-12 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-01-13 21:40:00","insp_carrier_name":"SUN VALLEY FOODS COMPANY","insp_carrier_street":"14401 DEXTER DRIVE","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48238","insp_colonia":null,"docket_number":"4541","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:06:12.000000Z","updated_at":"2025-03-17T19:06:12.000000Z","inspection_violations":[{"id":3312401,"change_date":"2023-01-13 21:40:00","inspection_id":"77593247","insp_violation_id":"250568271","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"192867883","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:40.000000Z","updated_at":"2025-03-17T21:22:40.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":3445482,"change_date":"2023-01-13 21:40:00","inspection_id":"77593247","insp_unit_id":"192867883","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"19504","insp_unit_license":"RB87744","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN2GY8LM019504","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:42.000000Z","updated_at":"2025-03-17T22:30:42.000000Z"},{"id":3445483,"change_date":"2023-01-13 21:40:00","inspection_id":"77593247","insp_unit_id":"192867884","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"538650","insp_unit_license":"D679613","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532C1MT178009","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:42.000000Z","updated_at":"2025-03-17T22:30:42.000000Z"}]},{"id":1821075,"change_date":"2022-11-28 21:41:00","inspection_id":"77227573","dot_number":"1702320","report_state":"MI","report_number":"BACZM01724","insp_date":"2022-11-23 00:00:00","insp_start_time":"0840","insp_end_time":"0915","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I75 NB @ LAKE RD","county_code_state":"MI","county_code":"049","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"226155","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":"2022-11-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1103205","transaction_code":"A","transaction_date":"2022-11-23 00:00:00","upload_date":"2022-11-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01702320","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-11-23 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-11-28 21:41:00","insp_carrier_name":"SUN VALLEY FOODS COMPANY","insp_carrier_street":"14401 DEXTER DRIVE","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48238","insp_colonia":null,"docket_number":"4541","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:00:18.000000Z","updated_at":"2025-03-17T19:00:18.000000Z","inspection_violations":[{"id":2844059,"change_date":"2022-11-28 21:41:00","inspection_id":"77227573","insp_violation_id":"249799944","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"192143101","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:30.000000Z","updated_at":"2025-03-17T21:20:30.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2929570,"change_date":"2022-11-28 21:41:00","inspection_id":"77227573","insp_unit_id":"192143101","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"RB87803","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5PVNV8JV8L5S60377","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:02.000000Z","updated_at":"2025-03-17T22:27:02.000000Z"}]},{"id":1754188,"change_date":"2022-11-16 21:41:00","inspection_id":"77150597","dot_number":"1702320","report_state":"MI","report_number":"BEAMW03139","insp_date":"2022-11-15 00:00:00","insp_start_time":"1535","insp_end_time":"1551","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"75 S @ RIVERVIEW","county_code_state":"MI","county_code":"145","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1102314","transaction_code":"A","transaction_date":"2022-11-15 00:00:00","upload_date":"2022-11-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01702320","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-11-15 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-11-16 21:41:00","insp_carrier_name":"SUN VALLEY FOODS COMPANY","insp_carrier_street":"14401 DEXTER DRIVE","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48238","insp_colonia":null,"docket_number":"4541","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:58:58.000000Z","updated_at":"2025-03-17T18:58:58.000000Z","inspection_violations":[{"id":2746364,"change_date":"2022-11-16 21:41:00","inspection_id":"77150597","insp_violation_id":"249635968","seq_no":"1","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:19:56.000000Z","updated_at":"2025-03-17T21:19:56.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2822390,"change_date":"2022-11-16 21:41:00","inspection_id":"77150597","insp_unit_id":"191989289","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"19518","insp_unit_license":"RB87746","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN2GY8LM019518","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:18.000000Z","updated_at":"2025-03-17T22:26:18.000000Z"},{"id":2822391,"change_date":"2022-11-16 21:41:00","inspection_id":"77150597","insp_unit_id":"191989290","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"538638","insp_unit_license":"D679616","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532C6MT178006","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:18.000000Z","updated_at":"2025-03-17T22:26:18.000000Z"}]},{"id":1754346,"change_date":"2022-11-16 21:41:00","inspection_id":"77150783","dot_number":"1702320","report_state":"MI","report_number":"PATTM04029","insp_date":"2022-11-14 00:00:00","insp_start_time":"0830","insp_end_time":"0915","registration_date":null,"region":"ET","ci_status_code":"C","location":"131","location_desc":"GRASS LAKE SCALE E\/B","county_code_state":"MI","county_code":"075","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAC","shipping_paper_number":"225646","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-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1102258","transaction_code":"A","transaction_date":"2022-11-14 00:00:00","upload_date":"2022-11-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01702320","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-11-14 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-11-16 21:41:00","insp_carrier_name":"SUN VALLEY FOODS COMPANY","insp_carrier_street":"14401 DEXTER DRIVE","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48238","insp_colonia":null,"docket_number":"4541","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:58:58.000000Z","updated_at":"2025-03-17T18:58:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2822667,"change_date":"2022-11-16 21:41:00","inspection_id":"77150783","insp_unit_id":"191989629","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"RC19563","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AW02Y1GM051404","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:18.000000Z","updated_at":"2025-03-17T22:26:18.000000Z"},{"id":2822668,"change_date":"2022-11-16 21:41:00","inspection_id":"77150783","insp_unit_id":"191989630","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":null,"insp_unit_license":"D679613","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532C1MT178009","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:18.000000Z","updated_at":"2025-03-17T22:26:18.000000Z"}]},{"id":1668665,"change_date":"2022-11-03 21:42:00","inspection_id":"77052543","dot_number":"1702320","report_state":"MI","report_number":"REBIM00217","insp_date":"2022-11-02 00:00:00","insp_start_time":"1202","insp_end_time":"1241","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CLIO REST AREA","county_code_state":"MI","county_code":"049","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-03 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1100894","transaction_code":"A","transaction_date":"2022-11-02 00:00:00","upload_date":"2022-11-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01702320","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-11-02 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-11-03 21:42:00","insp_carrier_name":"SUN VALLEY FOODS COMPANY","insp_carrier_street":"14401 DEXTER DRIVE","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48238","insp_colonia":null,"docket_number":"4541","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:57:25.000000Z","updated_at":"2025-03-17T18:57:25.000000Z","inspection_violations":[{"id":2616961,"change_date":"2022-11-03 21:42:00","inspection_id":"77052543","insp_violation_id":"249422910","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"191796083","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:18.000000Z","updated_at":"2025-03-17T21:19:18.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":2684242,"change_date":"2022-11-03 21:42:00","inspection_id":"77052543","insp_unit_id":"191796083","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"60381","insp_unit_license":"RB87801","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5PVNV8JVXL5S60381","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:23.000000Z","updated_at":"2025-03-17T22:25:23.000000Z"}]},{"id":1466873,"change_date":"2022-10-07 21:39:00","inspection_id":"76820322","dot_number":"1702320","report_state":"MI","report_number":"FELDW00264","insp_date":"2022-10-06 00:00:00","insp_start_time":"1235","insp_end_time":"1305","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":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAME AS CARRIER","shipping_paper_number":"220690","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-10-07 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1097702","transaction_code":"A","transaction_date":"2022-10-06 00:00:00","upload_date":"2022-10-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01702320","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-10-06 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-10-07 21:39:00","insp_carrier_name":"SUN VALLEY FOODS COMPANY","insp_carrier_street":"14401 DEXTER DRIVE","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48238","insp_colonia":null,"docket_number":"4541","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:53:46.000000Z","updated_at":"2025-03-17T18:53:46.000000Z","inspection_violations":[{"id":2310227,"change_date":"2022-10-07 21:39:00","inspection_id":"76820322","insp_violation_id":"248900072","seq_no":"1","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"191329659","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:36.000000Z","updated_at":"2025-03-17T21:17:36.000000Z","normalized_code":"39345D"},{"id":2310228,"change_date":"2022-10-07 21:39:00","inspection_id":"76820322","insp_violation_id":"248900073","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"191329660","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:36.000000Z","updated_at":"2025-03-17T21:17:36.000000Z","normalized_code":"39347E"},{"id":2310229,"change_date":"2022-10-07 21:39:00","inspection_id":"76820322","insp_violation_id":"248900074","seq_no":"3","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"191329660","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:36.000000Z","updated_at":"2025-03-17T21:17:36.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":2361561,"change_date":"2022-10-07 21:39:00","inspection_id":"76820322","insp_unit_id":"191329659","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"19502","insp_unit_license":"RB87745","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN2GY4LM019502","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:11.000000Z","updated_at":"2025-03-17T22:23:11.000000Z"},{"id":2361562,"change_date":"2022-10-07 21:39:00","inspection_id":"76820322","insp_unit_id":"191329660","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":null,"insp_unit_license":"D679613","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532C1MT178009","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:11.000000Z","updated_at":"2025-03-17T22:23:11.000000Z"}]},{"id":1158983,"change_date":"2022-08-29 21:42:00","inspection_id":"76463198","dot_number":"1702320","report_state":"MI","report_number":"HAMIZ00877","insp_date":"2022-08-25 00:00:00","insp_start_time":"1016","insp_end_time":"1029","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"RIDGE HWY & SUTTON RD","county_code_state":"MI","county_code":"091","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1091581","transaction_code":"A","transaction_date":"2022-08-25 00:00:00","upload_date":"2022-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01702320","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-08-25 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-08-29 21:42:00","insp_carrier_name":"SUN VALLEY FOODS COMPANY","insp_carrier_street":"14401 DEXTER DRIVE","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48238","insp_colonia":null,"docket_number":"4541","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:47:58.000000Z","updated_at":"2025-03-17T18:47:58.000000Z","inspection_violations":[{"id":1836259,"change_date":"2022-08-29 21:42:00","inspection_id":"76463198","insp_violation_id":"248064356","seq_no":"1","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:15:29.000000Z","updated_at":"2025-03-17T21:15:29.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1863418,"change_date":"2022-08-29 21:42:00","inspection_id":"76463198","insp_unit_id":"190596981","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"60378","insp_unit_license":"RB87805","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5PVNV8JVXL5S60378","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:49.000000Z","updated_at":"2025-03-17T22:19:49.000000Z"}]},{"id":1124213,"change_date":"2022-08-24 21:39:00","inspection_id":"76422597","dot_number":"1702320","report_state":"MI","report_number":"HOLLM03076","insp_date":"2022-08-23 00:00:00","insp_start_time":"1510","insp_end_time":"1620","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-94 E\/B @ CHELSEA REST AREA","county_code_state":"MI","county_code":"161","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"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-08-24 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"1091173","transaction_code":"A","transaction_date":"2022-08-23 00:00:00","upload_date":"2022-08-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01702320","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-08-23 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-08-24 21:39:00","insp_carrier_name":"SUN VALLEY FOODS COMPANY","insp_carrier_street":"14401 DEXTER DRIVE","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48238","insp_colonia":null,"docket_number":"4541","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:47:32.000000Z","updated_at":"2025-03-17T18:47:32.000000Z","inspection_violations":[{"id":1775133,"change_date":"2022-08-24 21:39:00","inspection_id":"76422597","insp_violation_id":"247960375","seq_no":"1","part_no":"393","part_no_section":"100(c)","insp_viol_unit":"2","insp_unit_id":"190515862","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:15:15.000000Z","updated_at":"2025-03-17T21:15:15.000000Z","normalized_code":"393100C"},{"id":1775134,"change_date":"2022-08-24 21:39:00","inspection_id":"76422597","insp_violation_id":"247960376","seq_no":"2","part_no":"393","part_no_section":"75(a)(2)","insp_viol_unit":"2","insp_unit_id":"190515862","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:15.000000Z","updated_at":"2025-03-17T21:15:15.000000Z","normalized_code":"39375A2"}],"inspection_per_units":[{"id":1808128,"change_date":"2022-08-24 21:39:00","inspection_id":"76422597","insp_unit_id":"190515861","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"RB87741","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN2GY1LM019506","insp_unit_decal":"Y","insp_unit_decal_number":"31655592","created_at":"2025-03-17T22:19:28.000000Z","updated_at":"2025-03-17T22:19:28.000000Z"},{"id":1808129,"change_date":"2022-08-24 21:39:00","inspection_id":"76422597","insp_unit_id":"190515862","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":null,"insp_unit_license":"D679616","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532C6MT178006","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:28.000000Z","updated_at":"2025-03-17T22:19:28.000000Z"}]},{"id":957065,"change_date":"2022-08-03 21:42:00","inspection_id":"76227530","dot_number":"1702320","report_state":"MI","report_number":"JURKV01815","insp_date":"2022-08-02 00:00:00","insp_start_time":"0730","insp_end_time":"0747","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ROAD","county_code_state":"MI","county_code":"145","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-03 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1086629","transaction_code":"A","transaction_date":"2022-08-02 00:00:00","upload_date":"2022-08-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01702320","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-08-02 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-08-03 21:42:00","insp_carrier_name":"SUN VALLEY FOODS COMPANY","insp_carrier_street":"14401 DEXTER DRIVE","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48238","insp_colonia":null,"docket_number":"4541","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:44:27.000000Z","updated_at":"2025-03-17T18:44:27.000000Z","inspection_violations":[{"id":1508044,"change_date":"2022-08-03 21:42:00","inspection_id":"76227530","insp_violation_id":"247492613","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:14:08.000000Z","updated_at":"2025-03-17T21:14:08.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1540042,"change_date":"2022-08-03 21:42:00","inspection_id":"76227530","insp_unit_id":"190117443","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"RB87805","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5PVNV8JVXL5S60378","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:42.000000Z","updated_at":"2025-03-17T22:17:42.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1702320\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1702320\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1702320\/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\/1702320\/inspections","per_page":100,"prev_page_url":null,"to":59,"total":59}