{"current_page":1,"data":[{"id":12033099,"change_date":"2026-05-28 21:41:00","inspection_id":"87973271","dot_number":"2392198","report_state":"CO","report_number":"1330012176","insp_date":"2026-05-26 00:00:00","insp_start_time":"1538","insp_end_time":"1618","registration_date":null,"region":"MD","ci_status_code":"C","location":"DUPEWB","location_desc":"DUMONT CO","county_code_state":"CO","county_code":"019","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"THROUGH THE VALLEY","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","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":"3413268","transaction_code":"A","transaction_date":"2026-05-27 00:00:00","upload_date":"2026-05-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02392198","upload_search_indicator":null,"census_search_date":"2026-05-28 21:41:00","snet_input_date":"2026-05-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-28 21:41:00","insp_carrier_name":"THROUGH THE VALLEY TRANSPORTATION INC","insp_carrier_street":"33006 7 MILE RD #412","insp_carrier_city":"LIVONIA","insp_carrier_state":"MI","insp_carrier_zip_code":"48152-1358","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-01T09:39:46.000000Z","updated_at":"2026-06-08T09:30:18.000000Z","inspection_violations":[{"id":20939500,"change_date":"2026-05-28 21:41:00","inspection_id":"87973271","insp_violation_id":"274541560","seq_no":"1","part_no":"392","part_no_section":"2SLSNC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"102605746","created_at":"2026-06-01T09:58:51.000000Z","updated_at":"2026-06-08T09:41:25.000000Z","normalized_code":"3922SLSNC"}],"inspection_per_units":[{"id":20915322,"change_date":"2026-05-28 21:41:00","inspection_id":"87973271","insp_unit_id":"213783944","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"17482","insp_unit_license":"BE53244","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M2MDBAA1SS017482","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-01T09:16:53.000000Z","updated_at":"2026-06-08T09:01:19.000000Z"}]},{"id":10333491,"change_date":"2025-12-02 21:39:00","inspection_id":"86460671","dot_number":"2392198","report_state":"MI","report_number":"LOPEL01880","insp_date":"2025-12-01 00:00:00","insp_start_time":"1200","insp_end_time":"1300","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"NB US-24 @ BREST RD","county_code_state":"MI","county_code":"163","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"THE ART FIRM","shipping_paper_number":"BARCODE","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-12-02 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"98000","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":"1252510","transaction_code":"A","transaction_date":"2025-12-01 00:00:00","upload_date":"2025-12-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02392198","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-12-01 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-12-02 21:39:00","insp_carrier_name":"THROUGH THE VALLEY TRANSPORTATION INC","insp_carrier_street":"33006 7 MILE ROAD #412","insp_carrier_city":"LIVONIA","insp_carrier_state":"MI","insp_carrier_zip_code":"48152","insp_colonia":null,"docket_number":"847177","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-05T10:32:33.000000Z","updated_at":"2025-12-06T10:30:51.000000Z","inspection_violations":[{"id":17286087,"change_date":"2025-12-02 21:39:00","inspection_id":"86460671","insp_violation_id":"270405094","seq_no":"1","part_no":"393","part_no_section":"48A-BIBD","insp_viol_unit":"2","insp_unit_id":"210365052","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-05T10:33:23.000000Z","updated_at":"2025-12-06T10:31:22.000000Z","normalized_code":"39348ABIBD"}],"inspection_per_units":[{"id":17258525,"change_date":"2025-12-02 21:39:00","inspection_id":"86460671","insp_unit_id":"210365051","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"43406","insp_unit_license":"RC50932","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN4GY5RM043506","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-05T10:02:54.000000Z","updated_at":"2025-12-06T10:00:53.000000Z"},{"id":17258526,"change_date":"2025-12-02 21:39:00","inspection_id":"86460671","insp_unit_id":"210365052","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"8902","insp_unit_license":"E443739","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GRAA06236B705260","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-05T10:02:54.000000Z","updated_at":"2025-12-06T10:00:53.000000Z"}]},{"id":10089189,"change_date":"2025-10-31 21:40:00","inspection_id":"86204154","dot_number":"2392198","report_state":"AZ","report_number":"BE44140229","insp_date":"2025-10-29 00:00:00","insp_start_time":"1017","insp_end_time":"1155","registration_date":null,"region":"MS","ci_status_code":"C","location":null,"location_desc":"BUCKEYE AZ","county_code_state":"AZ","county_code":"013","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-10-31 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","viol_total":"9","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":"2483689","transaction_code":"A","transaction_date":"2025-10-30 00:00:00","upload_date":"2025-10-31 00:00:00","upload_first_byte":"0","upload_dot_number":"02392198","upload_search_indicator":null,"census_search_date":"2025-10-31 21:40:00","snet_input_date":"2025-10-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-31 21:40:00","insp_carrier_name":"THROUGH THE VALLEY TRANSPORTATION INC","insp_carrier_street":"33006 7 MILE ROAD #412","insp_carrier_city":"LIVONIA","insp_carrier_state":"MI","insp_carrier_zip_code":"48152-1358","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-03T11:04:48.000000Z","updated_at":"2025-11-04T11:00:37.000000Z","inspection_violations":[{"id":16713211,"change_date":"2025-10-31 21:40:00","inspection_id":"86204154","insp_violation_id":"269642421","seq_no":"1","part_no":"395","part_no_section":"3A3II","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-03T11:17:38.000000Z","updated_at":"2025-11-04T11:15:55.000000Z","normalized_code":"3953A3II"},{"id":16713212,"change_date":"2025-10-31 21:40:00","inspection_id":"86204154","insp_violation_id":"269642422","seq_no":"2","part_no":"395","part_no_section":"22H1-ELDNUM","insp_viol_unit":"1","insp_unit_id":"209762953","insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-03T11:17:38.000000Z","updated_at":"2025-11-04T11:15:55.000000Z","normalized_code":"39522H1ELDNUM"},{"id":16713213,"change_date":"2025-10-31 21:40:00","inspection_id":"86204154","insp_violation_id":"269642423","seq_no":"3","part_no":"395","part_no_section":"22G-ELDMFV","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-03T11:17:38.000000Z","updated_at":"2025-11-04T11:15:55.000000Z","normalized_code":"39522GELDMFV"},{"id":16713214,"change_date":"2025-10-31 21:40:00","inspection_id":"86204154","insp_violation_id":"269642424","seq_no":"4","part_no":"395","part_no_section":"22H3-ELDMF","insp_viol_unit":"1","insp_unit_id":"209762953","insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-03T11:17:38.000000Z","updated_at":"2025-11-04T11:15:55.000000Z","normalized_code":"39522H3ELDMF"},{"id":16713215,"change_date":"2025-10-31 21:40:00","inspection_id":"86204154","insp_violation_id":"269642425","seq_no":"5","part_no":"390","part_no_section":"21TC-MC","insp_viol_unit":"1","insp_unit_id":"209762953","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-03T11:17:38.000000Z","updated_at":"2025-11-04T11:15:55.000000Z","normalized_code":"39021TCMC"},{"id":16713216,"change_date":"2025-10-31 21:40:00","inspection_id":"86204154","insp_violation_id":"269642426","seq_no":"6","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"209762953","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-03T11:17:38.000000Z","updated_at":"2025-11-04T11:15:55.000000Z","normalized_code":"3922SLLSR"},{"id":16713217,"change_date":"2025-10-31 21:40:00","inspection_id":"86204154","insp_violation_id":"269642427","seq_no":"7","part_no":"395","part_no_section":"22H2-ELDNISDT","insp_viol_unit":"1","insp_unit_id":"209762953","insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-03T11:17:38.000000Z","updated_at":"2025-11-04T11:15:55.000000Z","normalized_code":"39522H2ELDNISDT"},{"id":16713218,"change_date":"2025-10-31 21:40:00","inspection_id":"86204154","insp_violation_id":"269642428","seq_no":"8","part_no":"392","part_no_section":"2WG","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-11-03T11:17:38.000000Z","updated_at":"2025-11-04T11:15:55.000000Z","normalized_code":"3922WG"},{"id":16713219,"change_date":"2025-10-31 21:40:00","inspection_id":"86204154","insp_violation_id":"269642429","seq_no":"9","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"209762953","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-03T11:17:38.000000Z","updated_at":"2025-11-04T11:15:55.000000Z","normalized_code":"39395A4EEUS"}],"inspection_per_units":[{"id":16774831,"change_date":"2025-10-31 21:40:00","inspection_id":"86204154","insp_unit_id":"209762953","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"7640","insp_unit_license":"BD49198","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M2MDBAAXPS007640","insp_unit_decal":"Y","insp_unit_decal_number":"35757693","created_at":"2025-11-03T10:47:12.000000Z","updated_at":"2025-11-04T10:45:45.000000Z"}]},{"id":9288123,"change_date":"2025-07-30 21:40:00","inspection_id":"85361959","dot_number":"2392198","report_state":"MI","report_number":"NEGUB02835","insp_date":"2025-07-29 00:00:00","insp_start_time":"1025","insp_end_time":"1035","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US-12 @ BROOKLYN HWY","county_code_state":"MI","county_code":"091","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CLARKS","shipping_paper_number":"2100070007","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-07-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"1233226","transaction_code":"A","transaction_date":"2025-07-29 00:00:00","upload_date":"2025-07-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02392198","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-07-29 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-07-30 21:40:00","insp_carrier_name":"THROUGH THE VALLEY TRANSPORTATION INC","insp_carrier_street":"33006 7 MILE ROAD #412","insp_carrier_city":"LIVONIA","insp_carrier_state":"MI","insp_carrier_zip_code":"48152","insp_colonia":null,"docket_number":"847177","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-04T10:01:14.000000Z","updated_at":"2025-08-04T10:01:14.000000Z","inspection_violations":[{"id":15058108,"change_date":"2025-07-30 21:40:00","inspection_id":"85361959","insp_violation_id":"267745760","seq_no":"1","part_no":"392","part_no_section":"2-SLLTL","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-08-02T10:43:41.000000Z","updated_at":"2025-08-03T10:44:10.000000Z","normalized_code":"3922SLLTL"}],"inspection_per_units":[{"id":15292032,"change_date":"2025-07-30 21:40:00","inspection_id":"85361959","insp_unit_id":"208158966","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"05","insp_unit_license":"BC42276","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5PVNE8JVXE4S53388","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-02T09:46:27.000000Z","updated_at":"2025-08-03T09:45:56.000000Z"}]},{"id":8534571,"change_date":"2025-05-05 21:40:00","inspection_id":"84566735","dot_number":"2392198","report_state":"NV","report_number":"9400023630","insp_date":"2025-05-02 00:00:00","insp_start_time":"0745","insp_end_time":"0845","registration_date":null,"region":"PT","ci_status_code":"C","location":"1","location_desc":"SLOAN CHECKSITE","county_code_state":"NV","county_code":"003","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ATKINS TOUR TRANSPORTATION LLC","shipping_paper_number":"AHOL0061","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":"2025-05-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"4","oos_total":"1","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"792822","transaction_code":"C","transaction_date":"2025-05-05 00:00:00","upload_date":"2025-05-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02392198","upload_search_indicator":"M","census_search_date":"2025-05-05 21:40:00","snet_input_date":"2025-05-02 00:00:00","source_office":"4NVS001","mcmis_add_date":"2025-05-02 21:41:00","insp_carrier_name":"THROUGH THE VALLEY TRANSPORTATION INC","insp_carrier_street":"33006 7 MILE ROAD #412","insp_carrier_city":"LIVONIA","insp_carrier_state":"MI","insp_carrier_zip_code":"48152-1358","insp_colonia":null,"docket_number":"847177","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-05T10:16:07.000000Z","updated_at":"2025-05-09T10:21:48.000000Z","inspection_violations":[{"id":13541807,"change_date":"2025-05-05 21:40:00","inspection_id":"84566735","insp_violation_id":"266012179","seq_no":"1","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"206647678","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-08T10:23:55.000000Z","updated_at":"2025-05-09T10:41:03.000000Z","normalized_code":"39021TB2DOT"},{"id":13541808,"change_date":"2025-05-05 21:40:00","inspection_id":"84566735","insp_violation_id":"266012180","seq_no":"2","part_no":"395","part_no_section":"8D5-HOSF","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-08T10:23:55.000000Z","updated_at":"2025-05-09T10:41:03.000000Z","normalized_code":"3958D5HOSF"},{"id":13541809,"change_date":"2025-05-05 21:40:00","inspection_id":"84566735","insp_violation_id":"266012181","seq_no":"3","part_no":"395","part_no_section":"24C2III-ELDSDN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-08T10:23:55.000000Z","updated_at":"2025-05-09T10:41:03.000000Z","normalized_code":"39524C2IIIELDSDN"},{"id":13541810,"change_date":"2025-05-05 21:40:00","inspection_id":"84566735","insp_violation_id":"266012182","seq_no":"4","part_no":"393","part_no_section":"75A3-TAOLTIS","insp_viol_unit":"1","insp_unit_id":"206647678","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-05-08T10:23:55.000000Z","updated_at":"2025-05-09T10:41:03.000000Z","normalized_code":"39375A3TAOLTIS"}],"inspection_per_units":[{"id":13898190,"change_date":"2025-05-05 21:40:00","inspection_id":"84566735","insp_unit_id":"206647678","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"43506","insp_unit_license":"RC50932","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN4GY5RM043506","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-08T09:52:48.000000Z","updated_at":"2025-05-09T09:55:55.000000Z"},{"id":13898191,"change_date":"2025-05-05 21:40:00","inspection_id":"84566735","insp_unit_id":"206647679","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"8902","insp_unit_license":"E443739","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GRAA06236B705260","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-08T09:52:48.000000Z","updated_at":"2025-05-09T09:55:55.000000Z"}]},{"id":8451259,"change_date":"2025-04-23 21:41:00","inspection_id":"84478947","dot_number":"2392198","report_state":"MI","report_number":"DELMT01897","insp_date":"2025-04-22 00:00:00","insp_start_time":"1130","insp_end_time":"1315","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"E\/B I94 NEAR PARMA RD","county_code_state":"MI","county_code":"075","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"HAMTRAMCK RECYCLING","shipping_paper_number":"404300","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-04-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1218774","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":"02392198","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":"THROUGH THE VALLEY TRANSPORTATION INC","insp_carrier_street":"33006 7 MILE ROAD #412","insp_carrier_city":"LIVONIA","insp_carrier_state":"MI","insp_carrier_zip_code":"48152","insp_colonia":null,"docket_number":"847177","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-26T10:28:35.000000Z","updated_at":"2025-04-27T10:31:48.000000Z","inspection_violations":[{"id":13352648,"change_date":"2025-04-23 21:41:00","inspection_id":"84478947","insp_violation_id":"265790221","seq_no":"4","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"2","insp_unit_id":"206456672","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-25T11:08:57.000000Z","updated_at":"2025-04-26T10:51:08.000000Z","normalized_code":"39345B2BAIR"},{"id":13352645,"change_date":"2025-04-23 21:41:00","inspection_id":"84478947","insp_violation_id":"265790218","seq_no":"1","part_no":"393","part_no_section":"47A-BCLMAD-SA","insp_viol_unit":"1","insp_unit_id":"206456671","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-25T11:08:57.000000Z","updated_at":"2025-04-26T10:51:07.000000Z","normalized_code":"39347ABCLMADSA"},{"id":13352646,"change_date":"2025-04-23 21:41:00","inspection_id":"84478947","insp_violation_id":"265790219","seq_no":"2","part_no":"393","part_no_section":"47A-BCLMAD","insp_viol_unit":"1","insp_unit_id":"206456671","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-25T11:08:57.000000Z","updated_at":"2025-04-26T10:51:08.000000Z","normalized_code":"39347ABCLMAD"},{"id":13352647,"change_date":"2025-04-23 21:41:00","inspection_id":"84478947","insp_violation_id":"265790220","seq_no":"3","part_no":"393","part_no_section":"45B2-BHTD","insp_viol_unit":"2","insp_unit_id":"206456672","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-04-25T11:08:57.000000Z","updated_at":"2025-04-26T10:51:08.000000Z","normalized_code":"39345B2BHTD"},{"id":13352649,"change_date":"2025-04-23 21:41:00","inspection_id":"84478947","insp_violation_id":"265790222","seq_no":"5","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"2","insp_unit_id":"206456672","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-25T11:08:57.000000Z","updated_at":"2025-04-26T10:51:08.000000Z","normalized_code":"39345B2BAIR"}],"inspection_per_units":[{"id":13727163,"change_date":"2025-04-23 21:41:00","inspection_id":"84478947","insp_unit_id":"206456671","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"10","insp_unit_license":"RC01652","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJGLDR7HSHW0690","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-26T10:14:52.000000Z","updated_at":"2025-04-27T10:04:44.000000Z"},{"id":13727164,"change_date":"2025-04-23 21:41:00","inspection_id":"84478947","insp_unit_id":"206456672","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"5318","insp_unit_license":"C581030","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GRAP0626DT580597","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-26T10:14:52.000000Z","updated_at":"2025-04-27T10:04:44.000000Z"}]},{"id":8034929,"change_date":"2025-03-05 21:40:00","inspection_id":"84040528","dot_number":"2392198","report_state":"MI","report_number":"HOLLM04252","insp_date":"2025-03-03 00:00:00","insp_start_time":"1140","insp_end_time":"1155","registration_date":null,"region":"ET","ci_status_code":"C","location":"132","location_desc":"I-94 W\/B GRASS LAKE SCALE","county_code_state":"MI","county_code":"075","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"396471","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-03-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"4","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1211988","transaction_code":"A","transaction_date":"2025-03-03 00:00:00","upload_date":"2025-03-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02392198","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-03-03 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-03-05 21:40:00","insp_carrier_name":"THROUGH THE VALLEY TRANSPORTATION INC","insp_carrier_street":"33006 7 MILE ROAD #412","insp_carrier_city":"LIVONIA","insp_carrier_state":"MI","insp_carrier_zip_code":"48152","insp_colonia":null,"docket_number":"847177","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":12556439,"change_date":"2025-03-05 21:40:00","inspection_id":"84040528","insp_violation_id":"264849513","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA3","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-17T22:07:22.000000Z","updated_at":"2025-03-17T22:07:22.000000Z","normalized_code":"3922SLLEWA3"},{"id":12556440,"change_date":"2025-03-05 21:40:00","inspection_id":"84040528","insp_violation_id":"264849514","seq_no":"2","part_no":"396","part_no_section":"5B-L","insp_viol_unit":"1","insp_unit_id":"205642145","insp_violation_category_id":"30","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":"3965BL"},{"id":12556441,"change_date":"2025-03-05 21:40:00","inspection_id":"84040528","insp_violation_id":"264849515","seq_no":"3","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"205642145","insp_violation_category_id":"28","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":"39395A4EEUS"},{"id":12556442,"change_date":"2025-03-05 21:40:00","inspection_id":"84040528","insp_violation_id":"264849516","seq_no":"4","part_no":"393","part_no_section":"75G-TAOW","insp_viol_unit":"2","insp_unit_id":"205642146","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4490091","created_at":"2025-03-17T22:07:22.000000Z","updated_at":"2025-03-17T22:07:22.000000Z","normalized_code":"39375GTAOW"}],"inspection_per_units":[{"id":12971845,"change_date":"2025-03-05 21:40:00","inspection_id":"84040528","insp_unit_id":"205642145","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"RC01652","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJGLDR7HSHW0690","insp_unit_decal":"Y","insp_unit_decal_number":"34932041","created_at":"2025-03-17T23:58:18.000000Z","updated_at":"2025-03-17T23:58:18.000000Z"},{"id":12971846,"change_date":"2025-03-05 21:40:00","inspection_id":"84040528","insp_unit_id":"205642146","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"E270693","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GR1P0621LT169400","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":7921168,"change_date":"2025-02-20 21:40:00","inspection_id":"83921076","dot_number":"2392198","report_state":"MI","report_number":"ESCOT02479","insp_date":"2025-02-19 00:00:00","insp_start_time":"0830","insp_end_time":"0905","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"E I-96@8 MILE RD","county_code_state":"MI","county_code":"125","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S-C","shipping_paper_number":"31700108532","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-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"6","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1210614","transaction_code":"A","transaction_date":"2025-02-19 00:00:00","upload_date":"2025-02-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02392198","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-02-19 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-02-20 21:40:00","insp_carrier_name":"THROUGH THE VALLEY TRANSPORTATION INC","insp_carrier_street":"33006 7 MILE ROAD #412","insp_carrier_city":"LIVONIA","insp_carrier_state":"MI","insp_carrier_zip_code":"48152","insp_colonia":null,"docket_number":"847177","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:02:47.000000Z","updated_at":"2025-03-17T21:02:47.000000Z","inspection_violations":[{"id":12374832,"change_date":"2025-02-20 21:40:00","inspection_id":"83921076","insp_violation_id":"264615725","seq_no":"1","part_no":"391","part_no_section":"45A-MCEM","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:25.000000Z","updated_at":"2025-03-17T22:06:25.000000Z","normalized_code":"39145AMCEM"},{"id":12374833,"change_date":"2025-02-20 21:40:00","inspection_id":"83921076","insp_violation_id":"264615726","seq_no":"2","part_no":"392","part_no_section":"2-SLLSIV","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:25.000000Z","updated_at":"2025-03-17T22:06:25.000000Z","normalized_code":"3922SLLSIV"},{"id":12374834,"change_date":"2025-02-20 21:40:00","inspection_id":"83921076","insp_violation_id":"264615727","seq_no":"3","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"205423533","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:25.000000Z","updated_at":"2025-03-17T22:06:25.000000Z","normalized_code":"39617CPI"},{"id":12374835,"change_date":"2025-02-20 21:40:00","inspection_id":"83921076","insp_violation_id":"264615728","seq_no":"4","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"205423533","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:25.000000Z","updated_at":"2025-03-17T22:06:25.000000Z","normalized_code":"39395F"},{"id":12374836,"change_date":"2025-02-20 21:40:00","inspection_id":"83921076","insp_violation_id":"264615729","seq_no":"5","part_no":"393","part_no_section":"67C7V-F","insp_viol_unit":"1","insp_unit_id":"205423533","insp_violation_category_id":"18","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:25.000000Z","updated_at":"2025-03-17T22:06:25.000000Z","normalized_code":"39367C7VF"},{"id":12374837,"change_date":"2025-02-20 21:40:00","inspection_id":"83921076","insp_violation_id":"264615730","seq_no":"6","part_no":"390","part_no_section":"21TC-MC","insp_viol_unit":"1","insp_unit_id":"205423533","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:25.000000Z","updated_at":"2025-03-17T22:06:25.000000Z","normalized_code":"39021TCMC"}],"inspection_per_units":[{"id":12786661,"change_date":"2025-02-20 21:40:00","inspection_id":"83921076","insp_unit_id":"205423533","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"021","insp_unit_license":"BD72337","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5PVNE8JV862S50082","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:56:16.000000Z","updated_at":"2025-03-17T23:56:16.000000Z"}]},{"id":7739340,"change_date":"2025-01-29 21:41:00","inspection_id":"83729921","dot_number":"2392198","report_state":"MI","report_number":"MOREM05661","insp_date":"2025-01-27 00:00:00","insp_start_time":"1701","insp_end_time":"1730","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"MERRIDIAN RD","county_code_state":"MI","county_code":"065","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"COCA COLA","shipping_paper_number":"4505970954","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":"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":"1207739","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":"02392198","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":"THROUGH THE VALLEY TRANSPORTATION INC","insp_carrier_street":"33006 7 MILE ROAD #412","insp_carrier_city":"LIVONIA","insp_carrier_state":"MI","insp_carrier_zip_code":"48152","insp_colonia":null,"docket_number":"847177","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":12091855,"change_date":"2025-01-29 21:41:00","inspection_id":"83729921","insp_violation_id":"264237455","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":"X4481854","created_at":"2025-03-17T22:04:58.000000Z","updated_at":"2025-03-17T22:04:58.000000Z","normalized_code":"3922SLLS1"},{"id":12091856,"change_date":"2025-01-29 21:41:00","inspection_id":"83729921","insp_violation_id":"264237456","seq_no":"2","part_no":"392","part_no_section":"2-SLLSIV","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:58.000000Z","updated_at":"2025-03-17T22:04:58.000000Z","normalized_code":"3922SLLSIV"}],"inspection_per_units":[{"id":12489345,"change_date":"2025-01-29 21:41:00","inspection_id":"83729921","insp_unit_id":"205065387","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"10","insp_unit_license":"RC01652","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJGLDR7HSHW0690","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":12489346,"change_date":"2025-01-29 21:41:00","inspection_id":"83729921","insp_unit_id":"205065388","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"53912","insp_unit_license":"885361ST","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"1GRAP0629EK234003","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":6844445,"change_date":"2024-09-29 21:32:00","inspection_id":"82785442","dot_number":"2392198","report_state":"IN","report_number":"9667000043","insp_date":"2024-09-26 00:00:00","insp_start_time":"1505","insp_end_time":"1656","registration_date":null,"region":"ED","ci_status_code":"C","location":"1394E","location_desc":"CHESTERTON IN","county_code_state":"IN","county_code":"127","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"MADISONKIPP CORPORATION","shipping_paper_number":"30015102","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":"2024-09-29 21:32: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":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"894992","transaction_code":"A","transaction_date":"2024-09-28 00:00:00","upload_date":"2024-09-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02392198","upload_search_indicator":null,"census_search_date":"2024-09-29 21:32:00","snet_input_date":"2024-09-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-09-29 21:32:00","insp_carrier_name":"THROUGH THE VALLEY TRANSPORTATION INC","insp_carrier_street":"33006 7 MILE ROAD #412","insp_carrier_city":"LIVONIA","insp_carrier_state":"MI","insp_carrier_zip_code":"48152-1358","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:38:58.000000Z","updated_at":"2025-03-17T20:38:58.000000Z","inspection_violations":[{"id":10660815,"change_date":"2024-09-29 21:32:00","inspection_id":"82785442","insp_violation_id":"262087103","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"203178622","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:57:39.000000Z","updated_at":"2025-03-17T21:57:39.000000Z","normalized_code":"3963A1"},{"id":10660816,"change_date":"2024-09-29 21:32:00","inspection_id":"82785442","insp_violation_id":"262087104","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"203178622","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:39.000000Z","updated_at":"2025-03-17T21:57:39.000000Z","normalized_code":"3963A1"},{"id":10660817,"change_date":"2024-09-29 21:32:00","inspection_id":"82785442","insp_violation_id":"262087105","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"203178622","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:39.000000Z","updated_at":"2025-03-17T21:57:39.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":11037773,"change_date":"2024-09-29 21:32:00","inspection_id":"82785442","insp_unit_id":"203178622","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"10623","insp_unit_license":"RB86646","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN2GY6KM010623","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:18.000000Z","updated_at":"2025-03-17T23:37:18.000000Z"},{"id":11037774,"change_date":"2024-09-29 21:32:00","inspection_id":"82785442","insp_unit_id":"203178623","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"532209","insp_unit_license":"E986119","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GR1P0629NT403799","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:18.000000Z","updated_at":"2025-03-17T23:37:18.000000Z"}]},{"id":6818358,"change_date":"2024-09-25 21:41:00","inspection_id":"82757869","dot_number":"2392198","report_state":"MI","report_number":"WILLD03461","insp_date":"2024-09-25 00:00:00","insp_start_time":"0825","insp_end_time":"0855","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-96 & NEWBURGH","county_code_state":"MI","county_code":"163","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-09-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1195951","transaction_code":"A","transaction_date":"2024-09-25 00:00:00","upload_date":"2024-09-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02392198","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-09-25 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-09-25 21:41:00","insp_carrier_name":"THROUGH THE VALLEY TRANSPORTATION INC","insp_carrier_street":"33006 7 MILE ROAD #412","insp_carrier_city":"LIVONIA","insp_carrier_state":"MI","insp_carrier_zip_code":"48152","insp_colonia":null,"docket_number":"847177","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:38:15.000000Z","updated_at":"2025-03-17T20:38:15.000000Z","inspection_violations":[{"id":10617655,"change_date":"2024-09-25 21:41:00","inspection_id":"82757869","insp_violation_id":"262030746","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"203128134","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:23.000000Z","updated_at":"2025-03-17T21:57:23.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10995258,"change_date":"2024-09-25 21:41:00","inspection_id":"82757869","insp_unit_id":"203128134","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"BC10552","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5PVNJ8JV3H4S63552","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:54.000000Z","updated_at":"2025-03-17T23:36:54.000000Z"}]},{"id":6645200,"change_date":"2024-09-17 21:45:00","inspection_id":"82573374","dot_number":"2392198","report_state":"MI","report_number":"DAWDD03705","insp_date":"2024-09-04 00:00:00","insp_start_time":"0905","insp_end_time":"0926","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WB I-96 AT MERRIMAN","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"ROCKTECH","shipping_paper_number":"09042024-1","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-09-04 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1193353","transaction_code":"C","transaction_date":"2024-09-04 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02392198","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-09-04 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-09-04 21:42:00","insp_carrier_name":"THROUGH THE VALLEY TRANSPORTATION INC","insp_carrier_street":"33006 7 MILE ROAD #412","insp_carrier_city":"LIVONIA","insp_carrier_state":"MI","insp_carrier_zip_code":"48152","insp_colonia":null,"docket_number":"847177","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:34:49.000000Z","updated_at":"2025-03-17T20:34:49.000000Z","inspection_violations":[{"id":10338497,"change_date":"2024-09-17 21:45:00","inspection_id":"82573374","insp_violation_id":"261860546","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:56:03.000000Z","updated_at":"2025-03-17T21:56:03.000000Z","normalized_code":"3922"},{"id":10338498,"change_date":"2024-09-17 21:45:00","inspection_id":"82573374","insp_violation_id":"261860547","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:03.000000Z","updated_at":"2025-03-17T21:56:03.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10713715,"change_date":"2024-09-17 21:45:00","inspection_id":"82573374","insp_unit_id":"202976720","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"20","insp_unit_license":"RC02199","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AW07Y4HM079997","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:56.000000Z","updated_at":"2025-03-17T23:33:56.000000Z"},{"id":10713716,"change_date":"2024-09-17 21:45:00","inspection_id":"82573374","insp_unit_id":"202976721","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"532209","insp_unit_license":"E986119","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GR1P0629NT403799","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:56.000000Z","updated_at":"2025-03-17T23:33:56.000000Z"}]},{"id":6581734,"change_date":"2024-08-28 21:42:00","inspection_id":"82505569","dot_number":"2392198","report_state":"IN","report_number":"5417008523","insp_date":"2024-08-23 00:00:00","insp_start_time":"1315","insp_end_time":"1415","registration_date":null,"region":"CD","ci_status_code":"C","location":"1394E","location_desc":"CHESTERTON IN","county_code_state":"IN","county_code":"127","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"MADISON KIPP","shipping_paper_number":"30014518","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":"2024-08-28 21:42: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":"791271","transaction_code":"A","transaction_date":"2024-08-28 00:00:00","upload_date":"2024-08-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02392198","upload_search_indicator":null,"census_search_date":"2024-08-28 21:42:00","snet_input_date":"2024-08-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-28 21:42:00","insp_carrier_name":"THROUGH THE VALLEY TRANSPORTATION INC","insp_carrier_street":"33006 7 MILE ROAD #412","insp_carrier_city":"LIVONIA","insp_carrier_state":"MI","insp_carrier_zip_code":"48152-1358","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:33:37.000000Z","updated_at":"2025-03-17T20:33:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10610838,"change_date":"2024-08-28 21:42:00","inspection_id":"82505569","insp_unit_id":"202622060","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"30","insp_unit_license":"RC22640","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AW07Y4HM079983","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:55.000000Z","updated_at":"2025-03-17T23:32:55.000000Z"},{"id":10610839,"change_date":"2024-08-28 21:42:00","inspection_id":"82505569","insp_unit_id":"202622061","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VAN GUARD","insp_unit_company":"536027","insp_unit_license":"640124ST","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"5V8VC5320KM902115","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:55.000000Z","updated_at":"2025-03-17T23:32:55.000000Z"}]},{"id":6431993,"change_date":"2024-09-17 21:45:00","inspection_id":"82346084","dot_number":"2392198","report_state":"MI","report_number":"BACZM02452","insp_date":"2024-08-09 00:00:00","insp_start_time":"1034","insp_end_time":"1100","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":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","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":"2024-08-09 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"1189714","transaction_code":"C","transaction_date":"2024-08-09 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02392198","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-08-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-08-09 21:38:00","insp_carrier_name":"THROUGH THE VALLEY TRANSPORTATION INC","insp_carrier_street":"33006 7 MILE ROAD #412","insp_carrier_city":"LIVONIA","insp_carrier_state":"MI","insp_carrier_zip_code":"48152","insp_colonia":null,"docket_number":"847177","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:30:19.000000Z","updated_at":"2025-03-17T20:30:19.000000Z","inspection_violations":[{"id":9987764,"change_date":"2024-09-17 21:45:00","inspection_id":"82346084","insp_violation_id":"261857816","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:54:19.000000Z","updated_at":"2025-03-17T21:54:19.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10366266,"change_date":"2024-09-17 21:45:00","inspection_id":"82346084","insp_unit_id":"202974199","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"BD72337","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5PVNE8JV862S50082","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:27.000000Z","updated_at":"2025-03-17T23:30:27.000000Z"}]},{"id":5435075,"change_date":"2024-04-04 21:42:00","inspection_id":"81268046","dot_number":"2392198","report_state":"MI","report_number":"ANDER06250","insp_date":"2024-04-04 00:00:00","insp_start_time":"0540","insp_end_time":"0610","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I 75 SB 21","county_code_state":"MI","county_code":"115","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"-","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-04-04 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":"1172010","transaction_code":"A","transaction_date":"2024-04-04 00:00:00","upload_date":"2024-04-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02392198","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-04-04 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-04-04 21:42:00","insp_carrier_name":"THROUGH THE VALLEY TRANSPORTATION INC","insp_carrier_street":"33006 7 MILE ROAD #412","insp_carrier_city":"LIVONIA","insp_carrier_state":"MI","insp_carrier_zip_code":"48152","insp_colonia":null,"docket_number":"847177","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:10:19.000000Z","updated_at":"2025-03-17T20:10:19.000000Z","inspection_violations":[{"id":8389961,"change_date":"2024-04-04 21:42:00","inspection_id":"81268046","insp_violation_id":"258747686","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"200237739","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:37.000000Z","updated_at":"2025-03-17T21:46:37.000000Z","normalized_code":"3922"},{"id":8389962,"change_date":"2024-04-04 21:42:00","inspection_id":"81268046","insp_violation_id":"258747687","seq_no":"2","part_no":"393","part_no_section":"75(b)","insp_viol_unit":"1","insp_unit_id":"200237738","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:37.000000Z","updated_at":"2025-03-17T21:46:37.000000Z","normalized_code":"39375B"},{"id":8389963,"change_date":"2024-04-04 21:42:00","inspection_id":"81268046","insp_violation_id":"258747688","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200237738","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:37.000000Z","updated_at":"2025-03-17T21:46:37.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":8754743,"change_date":"2024-04-04 21:42:00","inspection_id":"81268046","insp_unit_id":"200237738","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"10","insp_unit_license":"RC01652","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJGLDR7HSHW0690","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:24.000000Z","updated_at":"2025-03-17T23:14:24.000000Z"},{"id":8754744,"change_date":"2024-04-04 21:42:00","inspection_id":"81268046","insp_unit_id":"200237739","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"531530","insp_unit_license":"D410786","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532C9GT322121","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:24.000000Z","updated_at":"2025-03-17T23:14:24.000000Z"}]},{"id":5226622,"change_date":"2024-03-06 21:40:00","inspection_id":"81040344","dot_number":"2392198","report_state":"MI","report_number":"PEIFM06084","insp_date":"2024-03-06 00:00:00","insp_start_time":"0600","insp_end_time":"0615","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-75 SB AT 1 MM","county_code_state":"MI","county_code":"115","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"GENERAL ALUMINUM","shipping_paper_number":"1508561","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-03-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1167794","transaction_code":"A","transaction_date":"2024-03-06 00:00:00","upload_date":"2024-03-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02392198","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-03-06 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-03-06 21:40:00","insp_carrier_name":"THROUGH THE VALLEY TRANSPORTATION INC","insp_carrier_street":"33006 7 MILE ROAD #412","insp_carrier_city":"LIVONIA","insp_carrier_state":"MI","insp_carrier_zip_code":"48152","insp_colonia":null,"docket_number":"847177","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:06:12.000000Z","updated_at":"2025-03-17T20:06:12.000000Z","inspection_violations":[{"id":8057314,"change_date":"2024-03-06 21:40:00","inspection_id":"81040344","insp_violation_id":"258237677","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"199786314","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:54.000000Z","updated_at":"2025-03-17T21:44:54.000000Z","normalized_code":"3939A"},{"id":8057315,"change_date":"2024-03-06 21:40:00","inspection_id":"81040344","insp_violation_id":"258237678","seq_no":"3","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"199786314","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:54.000000Z","updated_at":"2025-03-17T21:44:54.000000Z","normalized_code":"39375C"},{"id":8057316,"change_date":"2024-03-06 21:40:00","inspection_id":"81040344","insp_violation_id":"258237679","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"199786314","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:54.000000Z","updated_at":"2025-03-17T21:44:54.000000Z","normalized_code":"3922"},{"id":8057317,"change_date":"2024-03-06 21:40:00","inspection_id":"81040344","insp_violation_id":"258237680","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"199786314","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:54.000000Z","updated_at":"2025-03-17T21:44:54.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":8416627,"change_date":"2024-03-06 21:40:00","inspection_id":"81040344","insp_unit_id":"199786313","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"RC01652","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJGLDR7HSHW0690","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:16.000000Z","updated_at":"2025-03-17T23:11:16.000000Z"},{"id":8416628,"change_date":"2024-03-06 21:40:00","inspection_id":"81040344","insp_unit_id":"199786314","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"C581029","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GRAP0624DT580596","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:16.000000Z","updated_at":"2025-03-17T23:11:16.000000Z"}]},{"id":5089591,"change_date":"2024-02-20 21:42:00","inspection_id":"80891330","dot_number":"2392198","report_state":"MI","report_number":"KIRKB04487","insp_date":"2024-02-15 00:00:00","insp_start_time":"1530","insp_end_time":"1600","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"E\/B I-96 & FOWLERVILLE","county_code_state":"MI","county_code":"093","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"LACKS TRIM SYSTEMS","shipping_paper_number":"10215620","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-20 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":"1165146","transaction_code":"A","transaction_date":"2024-02-15 00:00:00","upload_date":"2024-02-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02392198","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-02-15 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-02-20 21:42:00","insp_carrier_name":"THROUGH THE VALLEY TRANSPORTATION INC","insp_carrier_street":"33006 7 MILE ROAD #412","insp_carrier_city":"LIVONIA","insp_carrier_state":"MI","insp_carrier_zip_code":"48152","insp_colonia":null,"docket_number":"847177","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:03:28.000000Z","updated_at":"2025-03-17T20:03:28.000000Z","inspection_violations":[{"id":7845541,"change_date":"2024-02-20 21:42:00","inspection_id":"80891330","insp_violation_id":"257925535","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:56.000000Z","updated_at":"2025-03-17T21:43:56.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8193838,"change_date":"2024-02-20 21:42:00","inspection_id":"80891330","insp_unit_id":"199502493","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"20","insp_unit_license":"RC02199","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AW07Y4HM079997","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:15.000000Z","updated_at":"2025-03-17T23:09:15.000000Z"},{"id":8193839,"change_date":"2024-02-20 21:42:00","inspection_id":"80891330","insp_unit_id":"199502494","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"PTLZ190322","insp_unit_license":"CB9646","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3H3V532CXKR112522","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:15.000000Z","updated_at":"2025-03-17T23:09:15.000000Z"}]},{"id":4895023,"change_date":"2024-01-24 21:45:00","inspection_id":"80678422","dot_number":"2392198","report_state":"MI","report_number":"WALKB02795","insp_date":"2024-01-23 00:00:00","insp_start_time":"1810","insp_end_time":"1838","registration_date":null,"region":"ET","ci_status_code":"C","location":"131","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":"MUGELE OF MICHIGAN","shipping_paper_number":"307830105","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-01-24 21:45: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":"1161485","transaction_code":"A","transaction_date":"2024-01-23 00:00:00","upload_date":"2024-01-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02392198","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-01-23 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-01-24 21:45:00","insp_carrier_name":"THROUGH THE VALLEY TRANSPORTATION INC","insp_carrier_street":"33006 7 MILE ROAD #412","insp_carrier_city":"LIVONIA","insp_carrier_state":"MI","insp_carrier_zip_code":"48152","insp_colonia":null,"docket_number":"847177","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:59:39.000000Z","updated_at":"2025-03-17T19:59:39.000000Z","inspection_violations":[{"id":7542023,"change_date":"2024-01-24 21:45:00","inspection_id":"80678422","insp_violation_id":"257476952","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:24.000000Z","updated_at":"2025-03-17T21:42:24.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7876358,"change_date":"2024-01-24 21:45:00","inspection_id":"80678422","insp_unit_id":"199093400","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"RC22640","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AW07Y4HM079983","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:24.000000Z","updated_at":"2025-03-17T23:06:24.000000Z"},{"id":7876359,"change_date":"2024-01-24 21:45:00","inspection_id":"80678422","insp_unit_id":"199093401","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"E310088","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GRAP0622GT610392","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:24.000000Z","updated_at":"2025-03-17T23:06:24.000000Z"}]},{"id":4686053,"change_date":"2023-12-21 21:39:00","inspection_id":"80450346","dot_number":"2392198","report_state":"MI","report_number":"DAWDD03200","insp_date":"2023-12-20 00:00:00","insp_start_time":"1020","insp_end_time":"1041","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WB I-96 AT MERRIMAN","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"ROCKTECH","shipping_paper_number":"12202023-1","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-12-21 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":"1158286","transaction_code":"A","transaction_date":"2023-12-20 00:00:00","upload_date":"2023-12-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02392198","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-12-20 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-12-21 21:39:00","insp_carrier_name":"THROUGH THE VALLEY TRANSPORTATION INC","insp_carrier_street":"33006 7 MILE ROAD #412","insp_carrier_city":"LIVONIA","insp_carrier_state":"MI","insp_carrier_zip_code":"48152","insp_colonia":null,"docket_number":"847177","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:55:45.000000Z","updated_at":"2025-03-17T19:55:45.000000Z","inspection_violations":[{"id":7241162,"change_date":"2023-12-21 21:39:00","inspection_id":"80450346","insp_violation_id":"257014514","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:41:00.000000Z","updated_at":"2025-03-17T21:41:00.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7537287,"change_date":"2023-12-21 21:39:00","inspection_id":"80450346","insp_unit_id":"198625701","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"20","insp_unit_license":"RC02199","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AW07Y4HM079997","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:23.000000Z","updated_at":"2025-03-17T23:03:23.000000Z"},{"id":7537288,"change_date":"2023-12-21 21:39:00","inspection_id":"80450346","insp_unit_id":"198625702","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"5316","insp_unit_license":"C581029","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GRAP0624DT580596","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:23.000000Z","updated_at":"2025-03-17T23:03:23.000000Z"}]},{"id":4218089,"change_date":"2023-10-17 21:41:00","inspection_id":"79934564","dot_number":"2392198","report_state":"OH","report_number":"3276013249","insp_date":"2023-10-16 00:00:00","insp_start_time":"1040","insp_end_time":"1110","registration_date":null,"region":"ET","ci_status_code":"C","location":"035080","location_desc":"ROADSIDE,.....","county_code_state":"OH","county_code":"035","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"ZF NORTH AMERICA","shipping_paper_number":"1507822","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-10-17 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":"1684234","transaction_code":"A","transaction_date":"2023-10-16 00:00:00","upload_date":"2023-10-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02392198","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-10-17 00:00:00","source_office":"3OHS001","mcmis_add_date":"2023-10-17 21:41:00","insp_carrier_name":"THROUGH THE VALLEY TRANSPORTATION INC","insp_carrier_street":"33006 7 MILE ROAD #412","insp_carrier_city":"LIVONIA","insp_carrier_state":"MI","insp_carrier_zip_code":"48152-1358","insp_colonia":null,"docket_number":"847177","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:46:17.000000Z","updated_at":"2025-03-17T19:46:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6783577,"change_date":"2023-10-17 21:41:00","inspection_id":"79934564","insp_unit_id":"197601551","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"10","insp_unit_license":"RC01652","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJGLDR7HSHW0690","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:51.000000Z","updated_at":"2025-03-17T22:56:51.000000Z"},{"id":6783578,"change_date":"2023-10-17 21:41:00","inspection_id":"79934564","insp_unit_id":"197601552","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"531608","insp_unit_license":"E310094","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GRAP062XGT610401","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:51.000000Z","updated_at":"2025-03-17T22:56:51.000000Z"}]},{"id":4184534,"change_date":"2023-10-12 21:41:00","inspection_id":"79897541","dot_number":"2392198","report_state":"MI","report_number":"ANDER05820","insp_date":"2023-10-11 00:00:00","insp_start_time":"0545","insp_end_time":"0610","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I 75 SB 21 MM","county_code_state":"MI","county_code":"115","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"-","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: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":"1149138","transaction_code":"A","transaction_date":"2023-10-11 00:00:00","upload_date":"2023-10-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02392198","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-10-11 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-10-12 21:41:00","insp_carrier_name":"THROUGH THE VALLEY TRANSPORTATION INC","insp_carrier_street":"33006 7 MILE ROAD #412","insp_carrier_city":"LIVONIA","insp_carrier_state":"MI","insp_carrier_zip_code":"48152","insp_colonia":null,"docket_number":"847177","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":6478076,"change_date":"2023-10-12 21:41:00","inspection_id":"79897541","insp_violation_id":"255803047","seq_no":"1","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"197527533","insp_violation_category_id":"16","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":"39345B2"},{"id":6478077,"change_date":"2023-10-12 21:41:00","inspection_id":"79897541","insp_violation_id":"255803048","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"197527534","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":6478078,"change_date":"2023-10-12 21:41:00","inspection_id":"79897541","insp_violation_id":"255803049","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"197527534","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"}],"inspection_per_units":[{"id":6729327,"change_date":"2023-10-12 21:41:00","inspection_id":"79897541","insp_unit_id":"197527533","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"10","insp_unit_license":"RC01652","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJGLDR7HSHW0690","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":6729328,"change_date":"2023-10-12 21:41:00","inspection_id":"79897541","insp_unit_id":"197527534","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"531903","insp_unit_license":"E792379","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GRAP0629KT120511","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":3053496,"change_date":"2023-05-16 21:42:00","inspection_id":"78631152","dot_number":"2392198","report_state":"MI","report_number":"LULAN01806","insp_date":"2023-05-15 00:00:00","insp_start_time":"1620","insp_end_time":"1643","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"N SERVICE DRIVE @ RAWSONVILLE","county_code_state":"MI","county_code":"161","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"HAMTRAMICK RECYCLING","shipping_paper_number":"303652","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-05-16 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1126234","transaction_code":"A","transaction_date":"2023-05-15 00:00:00","upload_date":"2023-05-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02392198","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-05-15 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-05-16 21:42:00","insp_carrier_name":"THROUGH THE VALLEY TRANSPORTATION INC","insp_carrier_street":"33006 7 MILE ROAD #412","insp_carrier_city":"LIVONIA","insp_carrier_state":"MI","insp_carrier_zip_code":"48152","insp_colonia":null,"docket_number":"847177","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:23:24.000000Z","updated_at":"2025-03-17T19:23:24.000000Z","inspection_violations":[{"id":4692529,"change_date":"2023-05-16 21:42:00","inspection_id":"78631152","insp_violation_id":"252857580","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:28:52.000000Z","updated_at":"2025-03-17T21:28:52.000000Z","normalized_code":"3922"},{"id":4692530,"change_date":"2023-05-16 21:42:00","inspection_id":"78631152","insp_violation_id":"252857581","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"41","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:52.000000Z","updated_at":"2025-03-17T21:28:52.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4912519,"change_date":"2023-05-16 21:42:00","inspection_id":"78631152","insp_unit_id":"194952383","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"RC18861","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AW21Y7GM055597","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:44.000000Z","updated_at":"2025-03-17T22:41:44.000000Z"},{"id":4912520,"change_date":"2023-05-16 21:42:00","inspection_id":"78631152","insp_unit_id":"194952384","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":null,"insp_unit_license":"184416T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3H3V532K6NS283255","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:44.000000Z","updated_at":"2025-03-17T22:41:44.000000Z"}]},{"id":2624583,"change_date":"2023-03-21 21:41:00","inspection_id":"78144552","dot_number":"2392198","report_state":"IN","report_number":"9288004678","insp_date":"2023-03-20 00:00:00","insp_start_time":"1245","insp_end_time":"1315","registration_date":null,"region":"CT","ci_status_code":"C","location":"1394E","location_desc":"#13  I-94 EB  PORTER","county_code_state":"IN","county_code":"127","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"MADISON-KIPP CORPORATION","shipping_paper_number":"30004144","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-03-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"116000","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":"2181815","transaction_code":"A","transaction_date":"2023-03-21 00:00:00","upload_date":"2023-03-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02392198","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-03-21 00:00:00","source_office":"3INS001","mcmis_add_date":"2023-03-21 21:41:00","insp_carrier_name":"THROUGH THE VALLEY TRANSPORTATION INC","insp_carrier_street":"33006 7 MILE ROAD #412","insp_carrier_city":"LIVONIA","insp_carrier_state":"MI","insp_carrier_zip_code":"48152-1358","insp_colonia":null,"docket_number":"847177","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:15:09.000000Z","updated_at":"2025-03-17T19:15:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4224835,"change_date":"2023-03-21 21:41:00","inspection_id":"78144552","insp_unit_id":"193980153","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"30","insp_unit_license":"RC22640","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AW07Y4HM079983","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:17.000000Z","updated_at":"2025-03-17T22:36:17.000000Z"},{"id":4224836,"change_date":"2023-03-21 21:41:00","inspection_id":"78144552","insp_unit_id":"193980154","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"531608","insp_unit_license":"E310094","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GRAP062XGT610401","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:17.000000Z","updated_at":"2025-03-17T22:36:17.000000Z"}]},{"id":2141071,"change_date":"2023-01-13 21:40:00","inspection_id":"77593341","dot_number":"2392198","report_state":"MI","report_number":"DEJOS00234","insp_date":"2023-01-12 00:00:00","insp_start_time":"1645","insp_end_time":"1705","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":"MUGELE OF MICHIGAN INC","shipping_paper_number":"M900079985","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":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1109052","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":"02392198","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":"THROUGH THE VALLEY TRANSPORTATION INC","insp_carrier_street":"33006 7 MILE ROAD #412","insp_carrier_city":"LIVONIA","insp_carrier_state":"MI","insp_carrier_zip_code":"48152","insp_colonia":null,"docket_number":"847177","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:06:13.000000Z","updated_at":"2025-03-17T19:06:13.000000Z","inspection_violations":[{"id":3312573,"change_date":"2023-01-13 21:40:00","inspection_id":"77593341","insp_violation_id":"250568504","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"192868053","insp_violation_category_id":"30","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":"3922"},{"id":3312574,"change_date":"2023-01-13 21:40:00","inspection_id":"77593341","insp_violation_id":"250568505","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"192868054","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":"3939A"}],"inspection_per_units":[{"id":3445624,"change_date":"2023-01-13 21:40:00","inspection_id":"77593341","insp_unit_id":"192868053","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"30","insp_unit_license":"RC04057","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AW07Y4HM079983","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":3445625,"change_date":"2023-01-13 21:40:00","inspection_id":"77593341","insp_unit_id":"192868054","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"532030","insp_unit_license":"E270688","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GR1P0621LT169395","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":1916380,"change_date":"2022-12-09 21:40:00","inspection_id":"77336507","dot_number":"2392198","report_state":"OH","report_number":"3233014422","insp_date":"2022-12-09 00:00:00","insp_start_time":"1005","insp_end_time":"1040","registration_date":null,"region":"ET","ci_status_code":"C","location":"03580","location_desc":"ROADSIDE (IR80)","county_code_state":"OH","county_code":"035","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"ZF NORTH AMERICA, INC","shipping_paper_number":"1507648","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":"2022-12-09 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":"1629909","transaction_code":"A","transaction_date":"2022-12-09 00:00:00","upload_date":"2022-12-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02392198","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-12-09 00:00:00","source_office":"3OHS001","mcmis_add_date":"2022-12-09 21:40:00","insp_carrier_name":"THROUGH THE VALLEY TRANSPORTATION INC","insp_carrier_street":"33006 7 MILE ROAD #412","insp_carrier_city":"LIVONIA","insp_carrier_state":"MI","insp_carrier_zip_code":"48152-1358","insp_colonia":null,"docket_number":"847177","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:01:53.000000Z","updated_at":"2025-03-17T19:01:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3083549,"change_date":"2022-12-09 21:40:00","inspection_id":"77336507","insp_unit_id":"192358472","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"20","insp_unit_license":"RC02199","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AW07Y4HM079997","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:06.000000Z","updated_at":"2025-03-17T22:28:06.000000Z"},{"id":3083550,"change_date":"2022-12-09 21:40:00","inspection_id":"77336507","insp_unit_id":"192358473","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VANR","insp_unit_company":"533554","insp_unit_license":"463268ST","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"5V8VC5322EM400193","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:06.000000Z","updated_at":"2025-03-17T22:28:06.000000Z"}]},{"id":1248662,"change_date":"2022-09-09 21:38:00","inspection_id":"76566773","dot_number":"2392198","report_state":"MI","report_number":"LITTJ04181","insp_date":"2022-09-08 00:00:00","insp_start_time":"1545","insp_end_time":"1600","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":"801","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-09-09 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"1093921","transaction_code":"A","transaction_date":"2022-09-08 00:00:00","upload_date":"2022-09-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02392198","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-09-08 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-09-09 21:38:00","insp_carrier_name":"THROUGH THE VALLEY TRANSPORTATION INC","insp_carrier_street":"33006 7 MILE ROAD #412","insp_carrier_city":"LIVONIA","insp_carrier_state":"MI","insp_carrier_zip_code":"48152","insp_colonia":null,"docket_number":"847177","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:49:43.000000Z","updated_at":"2025-03-17T18:49:43.000000Z","inspection_violations":[{"id":1976358,"change_date":"2022-09-09 21:38:00","inspection_id":"76566773","insp_violation_id":"248308793","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"190810330","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:04.000000Z","updated_at":"2025-03-17T21:16:04.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":2009494,"change_date":"2022-09-09 21:38:00","inspection_id":"76566773","insp_unit_id":"190810330","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"10","insp_unit_license":"RC01652","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJGLDR7HSHW0690","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:48.000000Z","updated_at":"2025-03-17T22:20:48.000000Z"},{"id":2009495,"change_date":"2022-09-09 21:38:00","inspection_id":"76566773","insp_unit_id":"190810331","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"48Z53M0002","insp_unit_license":"U777114","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1GRAP0625JT118088","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:48.000000Z","updated_at":"2025-03-17T22:20:48.000000Z"}]},{"id":1158834,"change_date":"2022-08-29 21:42:00","inspection_id":"76463031","dot_number":"2392198","report_state":"MI","report_number":"DAWDD02121","insp_date":"2022-08-25 00:00:00","insp_start_time":"0806","insp_end_time":"0845","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WB I-94 AT REST AREA","county_code_state":"MI","county_code":"163","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"LAZIBOY","shipping_paper_number":"08417990082","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-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"1091755","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":"02392198","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":"THROUGH THE VALLEY TRANSPORTATION INC","insp_carrier_street":"33006 7 MILE ROAD #412","insp_carrier_city":"LIVONIA","insp_carrier_state":"MI","insp_carrier_zip_code":"48152","insp_colonia":null,"docket_number":"847177","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":1835886,"change_date":"2022-08-29 21:42:00","inspection_id":"76463031","insp_violation_id":"248063882","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"190596687","insp_violation_category_id":"28","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":"39395A"}],"inspection_per_units":[{"id":1863183,"change_date":"2022-08-29 21:42:00","inspection_id":"76463031","insp_unit_id":"190596687","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"03","insp_unit_license":"BB29095","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5PVNE8JV7D4S52732","insp_unit_decal":"Y","insp_unit_decal_number":"00000001","created_at":"2025-03-17T22:19:49.000000Z","updated_at":"2025-03-17T22:19:49.000000Z"}]},{"id":309379,"change_date":"2022-06-09 21:42:00","inspection_id":"75462327","dot_number":"2392198","report_state":"MI","report_number":"WALKB01810","insp_date":"2022-05-02 00:00:00","insp_start_time":"1720","insp_end_time":"1803","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":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"ROCKTECH","shipping_paper_number":"4292022-1","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-03 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1074228","transaction_code":"C","transaction_date":"2022-05-02 00:00:00","upload_date":"2022-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02392198","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-05-02 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-05-03 21:39:00","insp_carrier_name":"THROUGH THE VALLEY TRANSPORTATION LLC","insp_carrier_street":"33006 7 MILE ROAD #412","insp_carrier_city":"LIVONIA","insp_carrier_state":"MI","insp_carrier_zip_code":"48152","insp_colonia":null,"docket_number":"847177","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:32:57.000000Z","updated_at":"2025-03-17T18:32:57.000000Z","inspection_violations":[{"id":480536,"change_date":"2022-06-09 21:42:00","inspection_id":"75462327","insp_violation_id":"246343273","seq_no":"1","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"189153736","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:21.000000Z","updated_at":"2025-03-17T21:09:21.000000Z","normalized_code":"39375C"},{"id":480537,"change_date":"2022-06-09 21:42:00","inspection_id":"75462327","insp_violation_id":"246343274","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189153736","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:21.000000Z","updated_at":"2025-03-17T21:09:21.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":500523,"change_date":"2022-06-09 21:42:00","inspection_id":"75462327","insp_unit_id":"189153736","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"RC01652","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJGLDR7HSHW0690","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:17.000000Z","updated_at":"2025-03-17T22:11:17.000000Z"},{"id":500524,"change_date":"2022-06-09 21:42:00","inspection_id":"75462327","insp_unit_id":"189153737","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"D450599","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GRAP0628HT100694","insp_unit_decal":"Y","insp_unit_decal_number":"31291985","created_at":"2025-03-17T22:11:17.000000Z","updated_at":"2025-03-17T22:11:17.000000Z"}]},{"id":129279,"change_date":"2022-04-07 21:39:00","inspection_id":"75247026","dot_number":"2392198","report_state":"WI","report_number":"2674001066","insp_date":"2022-04-06 00:00:00","insp_start_time":"0927","insp_end_time":"1020","registration_date":null,"region":"CT","ci_status_code":"C","location":"S16","location_desc":"MADISON SWEF","county_code_state":"WI","county_code":"025","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"MADISON KIPP CORP","shipping_paper_number":"304005261","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":"2022-04-07 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"5","oos_total":"2","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"857018","transaction_code":"A","transaction_date":"2022-04-07 00:00:00","upload_date":"2022-04-07 00:00:00","upload_first_byte":"0","upload_dot_number":"02392198","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-04-07 00:00:00","source_office":"3WIS001","mcmis_add_date":"2022-04-07 21:39:00","insp_carrier_name":"THROUGH THE VALLEY TRANSPORTATION LLC","insp_carrier_street":"33006 7 MILE ROAD #412","insp_carrier_city":"LIVONIA","insp_carrier_state":"MI","insp_carrier_zip_code":"48152-1358","insp_colonia":null,"docket_number":"847177","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:29:49.000000Z","updated_at":"2025-03-17T18:29:49.000000Z","inspection_violations":[{"id":191319,"change_date":"2022-04-07 21:39:00","inspection_id":"75247026","insp_violation_id":"245027263","seq_no":"1","part_no":"395","part_no_section":"8(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:56.000000Z","updated_at":"2025-03-17T21:07:56.000000Z","normalized_code":"3958A1"},{"id":191320,"change_date":"2022-04-07 21:39:00","inspection_id":"75247026","insp_violation_id":"245027264","seq_no":"2","part_no":"395","part_no_section":"30(b)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:56.000000Z","updated_at":"2025-03-17T21:07:56.000000Z","normalized_code":"39530B1"},{"id":191321,"change_date":"2022-04-07 21:39:00","inspection_id":"75247026","insp_violation_id":"245027265","seq_no":"3","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"188041605","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:07:56.000000Z","updated_at":"2025-03-17T21:07:56.000000Z","normalized_code":"39375A3"},{"id":191322,"change_date":"2022-04-07 21:39:00","inspection_id":"75247026","insp_violation_id":"245027266","seq_no":"4","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"188041605","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:56.000000Z","updated_at":"2025-03-17T21:07:56.000000Z","normalized_code":"39311"},{"id":191323,"change_date":"2022-04-07 21:39:00","inspection_id":"75247026","insp_violation_id":"245027267","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"188041605","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:56.000000Z","updated_at":"2025-03-17T21:07:56.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":209468,"change_date":"2022-04-07 21:39:00","inspection_id":"75247026","insp_unit_id":"188041605","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"10","insp_unit_license":"RC01652","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJGLDR7HSHW0690","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:28.000000Z","updated_at":"2025-03-17T22:09:28.000000Z"},{"id":209469,"change_date":"2022-04-07 21:39:00","inspection_id":"75247026","insp_unit_id":"188041606","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"532029","insp_unit_license":"E157238","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GR1P062XLT178578","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:28.000000Z","updated_at":"2025-03-17T22:09:28.000000Z"}]},{"id":52690,"change_date":"2022-03-28 21:41:00","inspection_id":"75152682","dot_number":"2392198","report_state":"MI","report_number":"STRAL01024","insp_date":"2022-03-26 00:00:00","insp_start_time":"2040","insp_end_time":"2130","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"E\/B SCALE","county_code_state":"MI","county_code":"021","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CLOROX UNIVERSITY PARK","shipping_paper_number":"11561219","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-03-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"3","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1069254","transaction_code":"A","transaction_date":"2022-03-26 00:00:00","upload_date":"2022-03-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02392198","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-03-26 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-03-28 21:41:00","insp_carrier_name":"THROUGH THE VALLEY TRANSPORTATION LLC","insp_carrier_street":"33006 7 MILE ROAD #412","insp_carrier_city":"LIVONIA","insp_carrier_state":"MI","insp_carrier_zip_code":"48152","insp_colonia":null,"docket_number":"847177","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:28:27.000000Z","updated_at":"2025-03-17T18:28:27.000000Z","inspection_violations":[{"id":74577,"change_date":"2022-03-28 21:41:00","inspection_id":"75152682","insp_violation_id":"244808347","seq_no":"1","part_no":"393","part_no_section":"23","insp_viol_unit":"2","insp_unit_id":"187848349","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:07:26.000000Z","updated_at":"2025-03-17T21:07:26.000000Z","normalized_code":"39323"},{"id":74578,"change_date":"2022-03-28 21:41:00","inspection_id":"75152682","insp_violation_id":"244808348","seq_no":"2","part_no":"393","part_no_section":"207(f)","insp_viol_unit":"2","insp_unit_id":"187848349","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"WARNING","created_at":"2025-03-17T21:07:26.000000Z","updated_at":"2025-03-17T21:07:26.000000Z","normalized_code":"393207F"},{"id":74579,"change_date":"2022-03-28 21:41:00","inspection_id":"75152682","insp_violation_id":"244808349","seq_no":"3","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":"WARNING","created_at":"2025-03-17T21:07:26.000000Z","updated_at":"2025-03-17T21:07:26.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":85204,"change_date":"2022-03-28 21:41:00","inspection_id":"75152682","insp_unit_id":"187848349","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"U91488","insp_unit_license":"E380038","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532CXCT132094","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:46.000000Z","updated_at":"2025-03-17T22:08:46.000000Z"},{"id":85205,"change_date":"2022-03-28 21:41:00","inspection_id":"75152682","insp_unit_id":"187848350","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"20","insp_unit_license":"RC02199","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AW07Y4HM079997","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:46.000000Z","updated_at":"2025-03-17T22:08:46.000000Z"}]},{"id":4087,"change_date":"2022-03-18 21:31:00","inspection_id":"75082693","dot_number":"2392198","report_state":"MI","report_number":"HARRK00688","insp_date":"2022-03-17 00:00:00","insp_start_time":"0905","insp_end_time":"0925","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WB I-94 @ ECORSE","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"DESCARTES","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-03-18 21:31:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"1068210","transaction_code":"A","transaction_date":"2022-03-17 00:00:00","upload_date":"2022-03-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02392198","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-03-17 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-03-18 21:31:00","insp_carrier_name":"THROUGH THE VALLEY TRANSPORTATION LLC","insp_carrier_street":"33006 7 MILE ROAD #412","insp_carrier_city":"LIVONIA","insp_carrier_state":"MI","insp_carrier_zip_code":"48152","insp_colonia":null,"docket_number":"847177","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:27:43.000000Z","updated_at":"2025-03-17T18:27:43.000000Z","inspection_violations":[{"id":5314,"change_date":"2022-03-18 21:31:00","inspection_id":"75082693","insp_violation_id":"244648688","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:07:09.000000Z","updated_at":"2025-03-17T21:07:09.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6611,"change_date":"2022-03-18 21:31:00","inspection_id":"75082693","insp_unit_id":"187703913","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"62335","insp_unit_license":"BA76646","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5PVNJ8JV3G4S62335","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:18.000000Z","updated_at":"2025-03-17T22:08:18.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2392198\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2392198\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2392198\/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\/2392198\/inspections","per_page":100,"prev_page_url":null,"to":31,"total":31}