{"current_page":1,"data":[{"id":12313276,"change_date":"2026-06-29 21:42:00","inspection_id":"88270902","dot_number":"1202329","report_state":"WV","report_number":"PSC1550948","insp_date":"2026-06-24 00:00:00","insp_start_time":"1805","insp_end_time":"1829","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"NITRO WV","county_code_state":"WV","county_code":"039","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"UNKNOWN","shipping_paper_number":"UNKNOWN","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-29 21:42:00","post_acc_ind":"Y","gross_comb_veh_wt":"120000","viol_total":"3","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":"3646663","transaction_code":"A","transaction_date":"2026-06-29 00:00:00","upload_date":"2026-06-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01202329","upload_search_indicator":null,"census_search_date":"2026-06-29 21:42:00","snet_input_date":"2026-06-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-29 21:42:00","insp_carrier_name":"RIVER VALLEY TRUCKING LLC","insp_carrier_street":"606 17TH AVE","insp_carrier_city":"ELDORA","insp_carrier_state":"IA","insp_carrier_zip_code":"50627","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-02T09:40:36.000000Z","updated_at":"2026-07-10T09:31:13.000000Z","inspection_violations":[{"id":21428490,"change_date":"2026-06-29 21:42:00","inspection_id":"88270902","insp_violation_id":"275196530","seq_no":"1","part_no":"396","part_no_section":"7A-UOC","insp_viol_unit":"1","insp_unit_id":"214351364","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-07-02T10:00:50.000000Z","updated_at":"2026-07-10T09:42:39.000000Z","normalized_code":"3967AUOC"},{"id":21428491,"change_date":"2026-06-29 21:42:00","inspection_id":"88270902","insp_violation_id":"275196531","seq_no":"2","part_no":"393","part_no_section":"207A-SAPPAS","insp_viol_unit":"2","insp_unit_id":"214351365","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-07-02T10:00:50.000000Z","updated_at":"2026-07-10T09:42:39.000000Z","normalized_code":"393207ASAPPAS"},{"id":21428492,"change_date":"2026-06-29 21:42:00","inspection_id":"88270902","insp_violation_id":"275196532","seq_no":"3","part_no":"393","part_no_section":"75A3-TALS","insp_viol_unit":"2","insp_unit_id":"214351365","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-07-02T10:00:50.000000Z","updated_at":"2026-07-10T09:42:39.000000Z","normalized_code":"39375A3TALS"}],"inspection_per_units":[{"id":21386148,"change_date":"2026-06-29 21:42:00","inspection_id":"88270902","insp_unit_id":"214351364","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"FP2561","insp_unit_license":"FP2561","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3HSCXAPR7GN031435","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-02T09:17:34.000000Z","updated_at":"2026-07-10T09:02:28.000000Z"},{"id":21386149,"change_date":"2026-06-29 21:42:00","inspection_id":"88270902","insp_unit_id":"214351365","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"R109","insp_unit_license":"FB7515","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GRAA0621HW704717","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-02T09:17:34.000000Z","updated_at":"2026-07-10T09:02:28.000000Z"}]},{"id":12294705,"change_date":"2026-06-27 21:41:00","inspection_id":"88251461","dot_number":"1202329","report_state":"IN","report_number":"5982006581","insp_date":"2026-06-22 00:00:00","insp_start_time":"1151","insp_end_time":"1019","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"RICHMOND IN","county_code_state":"IN","county_code":"177","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"HIGH LINER FOODS","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-27 21:41:00","post_acc_ind":"Y","gross_comb_veh_wt":"118350","viol_total":"10","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":"3623470","transaction_code":"A","transaction_date":"2026-06-25 00:00:00","upload_date":"2026-06-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01202329","upload_search_indicator":null,"census_search_date":"2026-06-27 21:41:00","snet_input_date":"2026-06-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-27 21:41:00","insp_carrier_name":"RIVER VALLEY TRUCKING LLC","insp_carrier_street":"606 17TH AVE","insp_carrier_city":"ELDORA","insp_carrier_state":"IA","insp_carrier_zip_code":"50627","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-30T09:40:00.000000Z","updated_at":"2026-07-08T09:30:12.000000Z","inspection_violations":[{"id":21399574,"change_date":"2026-06-27 21:41:00","inspection_id":"88251461","insp_violation_id":"275155676","seq_no":"1","part_no":"393","part_no_section":"201A-FRMS","insp_viol_unit":"1","insp_unit_id":"214312658","insp_violation_category_id":"19","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-06-30T09:58:20.000000Z","updated_at":"2026-07-08T09:40:36.000000Z","normalized_code":"393201AFRMS"},{"id":21399575,"change_date":"2026-06-27 21:41:00","inspection_id":"88251461","insp_violation_id":"275155677","seq_no":"2","part_no":"396","part_no_section":"3A1-F","insp_viol_unit":"1","insp_unit_id":"214312658","insp_violation_category_id":"18","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-06-30T09:58:20.000000Z","updated_at":"2026-07-08T09:40:36.000000Z","normalized_code":"3963A1F"},{"id":21399578,"change_date":"2026-06-27 21:41:00","inspection_id":"88251461","insp_violation_id":"275155680","seq_no":"5","part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"1","insp_unit_id":"214312658","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-30T09:58:20.000000Z","updated_at":"2026-07-08T09:40:36.000000Z","normalized_code":"3939ALRLI"},{"id":21399579,"change_date":"2026-06-27 21:41:00","inspection_id":"88251461","insp_violation_id":"275155681","seq_no":"6","part_no":"393","part_no_section":"9A-LTSI","insp_viol_unit":"1","insp_unit_id":"214312658","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-06-30T09:58:20.000000Z","updated_at":"2026-07-08T09:40:36.000000Z","normalized_code":"3939ALTSI"},{"id":21399580,"change_date":"2026-06-27 21:41:00","inspection_id":"88251461","insp_violation_id":"275155682","seq_no":"7","part_no":"393","part_no_section":"207A-SAPPAS","insp_viol_unit":"1","insp_unit_id":"214312658","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-06-30T09:58:20.000000Z","updated_at":"2026-07-08T09:40:36.000000Z","normalized_code":"393207ASAPPAS"},{"id":21399581,"change_date":"2026-06-27 21:41:00","inspection_id":"88251461","insp_violation_id":"275155683","seq_no":"8","part_no":"393","part_no_section":"60B","insp_viol_unit":"1","insp_unit_id":"214312658","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-30T09:58:20.000000Z","updated_at":"2026-07-08T09:40:36.000000Z","normalized_code":"39360B"},{"id":21399582,"change_date":"2026-06-27 21:41:00","inspection_id":"88251461","insp_violation_id":"275155684","seq_no":"9","part_no":"393","part_no_section":"209C-STSCL","insp_viol_unit":"1","insp_unit_id":"214312658","insp_violation_category_id":"21","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-06-30T09:58:20.000000Z","updated_at":"2026-07-08T09:40:36.000000Z","normalized_code":"393209CSTSCL"},{"id":21399583,"change_date":"2026-06-27 21:41:00","inspection_id":"88251461","insp_violation_id":"275155685","seq_no":"10","part_no":"393","part_no_section":"75A3-TFL","insp_viol_unit":"1","insp_unit_id":"214312658","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-06-30T09:58:20.000000Z","updated_at":"2026-07-08T09:40:36.000000Z","normalized_code":"39375A3TFL"},{"id":21399576,"change_date":"2026-06-27 21:41:00","inspection_id":"88251461","insp_violation_id":"275155678","seq_no":"3","part_no":"393","part_no_section":"43D-BSB","insp_viol_unit":"1","insp_unit_id":"214312658","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-06-30T09:58:20.000000Z","updated_at":"2026-07-08T09:40:36.000000Z","normalized_code":"39343DBSB"},{"id":21399577,"change_date":"2026-06-27 21:41:00","inspection_id":"88251461","insp_violation_id":"275155679","seq_no":"4","part_no":"393","part_no_section":"9A-HLLH","insp_viol_unit":"1","insp_unit_id":"214312658","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-30T09:58:20.000000Z","updated_at":"2026-07-08T09:40:36.000000Z","normalized_code":"3939AHLLH"}],"inspection_per_units":[{"id":21355209,"change_date":"2026-06-27 21:41:00","inspection_id":"88251461","insp_unit_id":"214312658","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"73002","insp_unit_license":"LR3390","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"4V4NC9TJX5N396491","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-30T09:16:15.000000Z","updated_at":"2026-07-08T09:01:07.000000Z"},{"id":21355210,"change_date":"2026-06-27 21:41:00","inspection_id":"88251461","insp_unit_id":"214312659","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"R504","insp_unit_license":"FW4028","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GRAA0621DB705321","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-30T09:16:15.000000Z","updated_at":"2026-07-08T09:01:07.000000Z"}]},{"id":12256455,"change_date":"2026-06-23 21:39:00","inspection_id":"88215066","dot_number":"1202329","report_state":"IN","report_number":"6162004422","insp_date":"2026-06-21 00:00:00","insp_start_time":"0740","insp_end_time":"0830","registration_date":null,"region":"CD","ci_status_code":"C","location":"I-90","location_desc":"PORTAGE IN","county_code_state":"IN","county_code":"127","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"HYVEE","shipping_paper_number":"TRIP ID 1214708","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120300","viol_total":"2","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3598857","transaction_code":"A","transaction_date":"2026-06-23 00:00:00","upload_date":"2026-06-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01202329","upload_search_indicator":null,"census_search_date":"2026-06-23 21:39:00","snet_input_date":"2026-06-21 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-23 21:39:00","insp_carrier_name":"RIVER VALLEY TRUCKING LLC","insp_carrier_street":"606 17TH AVE","insp_carrier_city":"ELDORA","insp_carrier_state":"IA","insp_carrier_zip_code":"50627","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-26T09:40:46.000000Z","updated_at":"2026-07-04T09:30:32.000000Z","inspection_violations":[{"id":21334843,"change_date":"2026-06-23 21:39:00","inspection_id":"88215066","insp_violation_id":"275071800","seq_no":"1","part_no":"392","part_no_section":"2-SLLS4","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-26T10:01:07.000000Z","updated_at":"2026-07-04T09:42:48.000000Z","normalized_code":"3922SLLS4"},{"id":21334844,"change_date":"2026-06-23 21:39:00","inspection_id":"88215066","insp_violation_id":"275071801","seq_no":"2","part_no":"395","part_no_section":"8A1-HOSP","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":"2026-06-26T10:01:07.000000Z","updated_at":"2026-07-04T09:42:48.000000Z","normalized_code":"3958A1HOSP"}],"inspection_per_units":[{"id":21283646,"change_date":"2026-06-23 21:39:00","inspection_id":"88215066","insp_unit_id":"214236212","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"1010","insp_unit_license":"FP2561","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3HSCXAPR7GN031435","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-26T09:17:07.000000Z","updated_at":"2026-07-05T09:03:33.000000Z"},{"id":21283647,"change_date":"2026-06-23 21:39:00","inspection_id":"88215066","insp_unit_id":"214236213","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"R109","insp_unit_license":"FB7515","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GRAA0621HW704717","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-26T09:17:07.000000Z","updated_at":"2026-07-05T09:03:33.000000Z"}]},{"id":12057563,"change_date":"2026-05-30 21:35:00","inspection_id":"87999022","dot_number":"1202329","report_state":"TN","report_number":"I035G30081","insp_date":"2026-05-28 00:00:00","insp_start_time":"0950","insp_end_time":"1025","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"KINGSPORT TN","county_code_state":"TN","county_code":"163","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"HYVEE","shipping_paper_number":"399427","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-30 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3430681","transaction_code":"A","transaction_date":"2026-05-29 00:00:00","upload_date":"2026-05-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01202329","upload_search_indicator":null,"census_search_date":"2026-05-30 21:35:00","snet_input_date":"2026-05-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-30 21:35:00","insp_carrier_name":"RIVER VALLEY TRUCKING LLC","insp_carrier_street":"606 17TH AVE","insp_carrier_city":"ELDORA","insp_carrier_state":"IA","insp_carrier_zip_code":"50627","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-02T09:40:10.000000Z","updated_at":"2026-06-10T09:30:30.000000Z","inspection_violations":[{"id":20980696,"change_date":"2026-05-30 21:35:00","inspection_id":"87999022","insp_violation_id":"274596058","seq_no":"1","part_no":"392","part_no_section":"2-SLLILC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-02T09:58:50.000000Z","updated_at":"2026-06-10T09:40:44.000000Z","normalized_code":"3922SLLILC"},{"id":20980697,"change_date":"2026-05-30 21:35:00","inspection_id":"87999022","insp_violation_id":"274596059","seq_no":"2","part_no":"395","part_no_section":"8A1-HOSP","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":"2026-06-02T09:58:50.000000Z","updated_at":"2026-06-10T09:40:44.000000Z","normalized_code":"3958A1HOSP"}],"inspection_per_units":[{"id":20955718,"change_date":"2026-05-30 21:35:00","inspection_id":"87999022","insp_unit_id":"213832106","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"FW4027","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GRAA0623DB705319","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-02T09:17:16.000000Z","updated_at":"2026-06-10T09:01:32.000000Z"},{"id":20955719,"change_date":"2026-05-30 21:35:00","inspection_id":"87999022","insp_unit_id":"213832107","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"1010","insp_unit_license":"FP2561","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3HSCXAPR7GN031435","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-02T09:17:16.000000Z","updated_at":"2026-06-10T09:01:32.000000Z"}]},{"id":12035937,"change_date":"2026-05-28 21:41:00","inspection_id":"87976267","dot_number":"1202329","report_state":"IN","report_number":"9109002992","insp_date":"2026-05-27 00:00:00","insp_start_time":"1337","insp_end_time":"1359","registration_date":null,"region":"ED","ci_status_code":"C","location":"910975","location_desc":"LAFAYETTE IN","county_code_state":"IN","county_code":null,"insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"HYVEE","shipping_paper_number":"1205035","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117300","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":"3415614","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":"01202329","upload_search_indicator":null,"census_search_date":"2026-05-28 21:41:00","snet_input_date":"2026-05-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-28 21:41:00","insp_carrier_name":"RIVER VALLEY TRUCKING LLC","insp_carrier_street":"606 17TH AVE","insp_carrier_city":"ELDORA","insp_carrier_state":"IA","insp_carrier_zip_code":"50627","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-01T09:39:50.000000Z","updated_at":"2026-06-08T09:30:39.000000Z","inspection_violations":[{"id":20944593,"change_date":"2026-05-28 21:41:00","inspection_id":"87976267","insp_violation_id":"274547558","seq_no":"1","part_no":"392","part_no_section":"2-SLLLR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-01T09:59:03.000000Z","updated_at":"2026-06-08T09:42:13.000000Z","normalized_code":"3922SLLLR"},{"id":20944594,"change_date":"2026-05-28 21:41:00","inspection_id":"87976267","insp_violation_id":"274547559","seq_no":"2","part_no":"392","part_no_section":"2-SLLS3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-01T09:59:03.000000Z","updated_at":"2026-06-08T09:42:13.000000Z","normalized_code":"3922SLLS3"}],"inspection_per_units":[{"id":20919978,"change_date":"2026-05-28 21:41:00","inspection_id":"87976267","insp_unit_id":"213789072","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"1016","insp_unit_license":"FX8979","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3HSCXAPR2AN266932","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-01T09:17:01.000000Z","updated_at":"2026-06-08T09:02:07.000000Z"},{"id":20919979,"change_date":"2026-05-28 21:41:00","inspection_id":"87976267","insp_unit_id":"213789073","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":"24796","insp_unit_license":"FW2048","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1UYVS2534R2084504","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-01T09:17:01.000000Z","updated_at":"2026-06-08T09:02:07.000000Z"}]},{"id":11954939,"change_date":"2026-05-18 21:40:00","inspection_id":"87890788","dot_number":"1202329","report_state":"IL","report_number":"4248660178","insp_date":"2026-05-17 00:00:00","insp_start_time":"0839","insp_end_time":"0842","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"I74","county_code_state":"IL","county_code":"161","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"HYVEE","shipping_paper_number":"1201714","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-05-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","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":"2473786","transaction_code":"A","transaction_date":"2026-05-17 00:00:00","upload_date":"2026-05-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01202329","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-05-17 00:00:00","source_office":"3ILS001","mcmis_add_date":"2026-05-18 21:40:00","insp_carrier_name":"RIVER VALLEY TRUCKING LLC","insp_carrier_street":"606 17TH AVE","insp_carrier_city":"ELDORA","insp_carrier_state":"IA","insp_carrier_zip_code":"50627","insp_colonia":null,"docket_number":"479058","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-21T09:41:13.000000Z","updated_at":"2026-05-29T09:31:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20787157,"change_date":"2026-05-18 21:40:00","inspection_id":"87890788","insp_unit_id":"213628656","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"FB7518","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"4V4NC9EH3DN563962","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-21T09:20:45.000000Z","updated_at":"2026-05-29T09:03:43.000000Z"}]},{"id":11664086,"change_date":"2026-04-16 21:40:00","inspection_id":"87594356","dot_number":"1202329","report_state":"KY","report_number":"CV44105639","insp_date":"2026-04-15 00:00:00","insp_start_time":"1908","insp_end_time":"2026","registration_date":null,"region":"CT","ci_status_code":"C","location":"9814","location_desc":"KUTTAWA","county_code_state":"KY","county_code":"143","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"RISE BAKING CO LLC","shipping_paper_number":"1189649","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-04-16 21:40: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":"2340705","transaction_code":"A","transaction_date":"2026-04-16 00:00:00","upload_date":"2026-04-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01202329","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2026-04-16 00:00:00","source_office":"2KYS001","mcmis_add_date":"2026-04-16 21:40:00","insp_carrier_name":"RIVER VALLEY TRUCKING LLC","insp_carrier_street":"606 17TH AVE","insp_carrier_city":"ELDORA","insp_carrier_state":"IA","insp_carrier_zip_code":"50627","insp_colonia":null,"docket_number":"479058","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-27T09:31:22.000000Z","updated_at":"2026-04-27T09:31:22.000000Z","inspection_violations":[{"id":20259193,"change_date":"2026-04-16 21:40:00","inspection_id":"87594356","insp_violation_id":"273645775","seq_no":"1","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"FG69905","created_at":"2026-04-27T09:44:39.000000Z","updated_at":"2026-04-27T09:44:39.000000Z","normalized_code":"3922SLL"},{"id":20259194,"change_date":"2026-04-16 21:40:00","inspection_id":"87594356","insp_violation_id":"273645776","seq_no":"2","part_no":"395","part_no_section":"34A1-ELDDFN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"FG69905","created_at":"2026-04-27T09:44:39.000000Z","updated_at":"2026-04-27T09:44:39.000000Z","normalized_code":"39534A1ELDDFN"}],"inspection_per_units":[{"id":20289334,"change_date":"2026-04-16 21:40:00","inspection_id":"87594356","insp_unit_id":"213050068","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"420","insp_unit_license":"MX9992","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1M1AW07Y1GM056093","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:04:19.000000Z","updated_at":"2026-04-27T09:04:19.000000Z"},{"id":20289335,"change_date":"2026-04-16 21:40:00","inspection_id":"87594356","insp_unit_id":"213050069","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"26854","insp_unit_license":"LR5452","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GR1A0625TW728429","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:04:19.000000Z","updated_at":"2026-04-27T09:04:19.000000Z"}]},{"id":11160995,"change_date":"2026-02-18 21:38:00","inspection_id":"87076229","dot_number":"1202329","report_state":"MA","report_number":"DU00000321","insp_date":"2026-02-17 00:00:00","insp_start_time":"1534","insp_end_time":"1555","registration_date":null,"region":"ET","ci_status_code":"C","location":"366H","location_desc":"H-WESTFIELD","county_code_state":"MA","county_code":"013","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CAPE COD SHELLFISH","shipping_paper_number":"605677","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-02-18 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"540543","transaction_code":"A","transaction_date":"2026-02-18 00:00:00","upload_date":"2026-02-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01202329","upload_search_indicator":"M","census_search_date":"2026-02-18 21:38:00","snet_input_date":"2026-02-17 00:00:00","source_office":"1MAS001","mcmis_add_date":"2026-02-18 21:38:00","insp_carrier_name":"RIVER VALLEY TRUCKING LLC","insp_carrier_street":"606 17TH AVE","insp_carrier_city":"ELDORA","insp_carrier_state":"IA","insp_carrier_zip_code":"50627","insp_colonia":null,"docket_number":"4790","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-21T10:37:59.000000Z","updated_at":"2026-03-01T10:30:36.000000Z","inspection_violations":[{"id":18709258,"change_date":"2026-02-18 21:38:00","inspection_id":"87076229","insp_violation_id":"271871577","seq_no":"1","part_no":"392","part_no_section":"16AD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-21T10:53:41.000000Z","updated_at":"2026-03-01T10:40:22.000000Z","normalized_code":"39216AD"}],"inspection_per_units":[{"id":19042107,"change_date":"2026-02-18 21:38:00","inspection_id":"87076229","insp_unit_id":"211685587","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"02","insp_unit_license":"FA1268","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKWD49X74R397895","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-21T10:14:00.000000Z","updated_at":"2026-03-01T10:03:24.000000Z"},{"id":19042108,"change_date":"2026-02-18 21:38:00","inspection_id":"87076229","insp_unit_id":"211685588","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"R506","insp_unit_license":"FY4936","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GR1A062XSW726514","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-21T10:14:00.000000Z","updated_at":"2026-03-01T10:03:24.000000Z"}]},{"id":11140687,"change_date":"2026-02-16 21:35:00","inspection_id":"87054706","dot_number":"1202329","report_state":"IN","report_number":"6162004086","insp_date":"2026-02-15 00:00:00","insp_start_time":"0759","insp_end_time":"0825","registration_date":null,"region":"CS","ci_status_code":"C","location":"I-90","location_desc":"PORTAGE IN","county_code_state":"IN","county_code":"127","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"HYVEE","shipping_paper_number":"PO# 3152232","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-02-16 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"2892610","transaction_code":"A","transaction_date":"2026-02-16 00:00:00","upload_date":"2026-02-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01202329","upload_search_indicator":null,"census_search_date":"2026-02-16 21:35:00","snet_input_date":"2026-02-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-16 21:35:00","insp_carrier_name":"RIVER VALLEY TRUCKING LLC","insp_carrier_street":"606 17TH AVE","insp_carrier_city":"ELDORA","insp_carrier_state":"IA","insp_carrier_zip_code":"50627","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-19T10:37:10.000000Z","updated_at":"2026-02-27T10:30:13.000000Z","inspection_violations":[{"id":18664254,"change_date":"2026-02-16 21:35:00","inspection_id":"87054706","insp_violation_id":"271818333","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-19T10:51:10.000000Z","updated_at":"2026-02-27T10:38:33.000000Z","normalized_code":"3922SLLS2"},{"id":18664255,"change_date":"2026-02-16 21:35:00","inspection_id":"87054706","insp_violation_id":"271818334","seq_no":"2","part_no":"395","part_no_section":"8E-HOSPD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-19T10:51:10.000000Z","updated_at":"2026-02-27T10:38:33.000000Z","normalized_code":"3958EHOSPD"}],"inspection_per_units":[{"id":19004557,"change_date":"2026-02-16 21:35:00","inspection_id":"87054706","insp_unit_id":"211642216","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"T112","insp_unit_license":"FJ4950","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"2HSFHAMR7SC036532","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-19T10:12:51.000000Z","updated_at":"2026-02-27T10:02:27.000000Z"},{"id":19004558,"change_date":"2026-02-16 21:35:00","inspection_id":"87054706","insp_unit_id":"211642217","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":"25826","insp_unit_license":"RY3179","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1UYVS2533S2334014","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-19T10:12:51.000000Z","updated_at":"2026-02-27T10:02:27.000000Z"}]},{"id":11089809,"change_date":"2026-02-10 21:38:00","inspection_id":"87001305","dot_number":"1202329","report_state":"NY","report_number":"SPT3141540","insp_date":"2026-02-03 00:00:00","insp_start_time":"1637","insp_end_time":"1718","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"ALBANY NY","county_code_state":"NY","county_code":"001","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-02-10 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"7","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2866018","transaction_code":"A","transaction_date":"2026-02-09 00:00:00","upload_date":"2026-02-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01202329","upload_search_indicator":null,"census_search_date":"2026-02-10 21:38:00","snet_input_date":"2026-02-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-10 21:38:00","insp_carrier_name":"RIVER VALLEY TRUCKING LLC","insp_carrier_street":"606 17TH AVE","insp_carrier_city":"ELDORA","insp_carrier_state":"IA","insp_carrier_zip_code":"50627","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-13T10:37:48.000000Z","updated_at":"2026-02-21T10:30:15.000000Z","inspection_violations":[{"id":18566206,"change_date":"2026-02-10 21:38:00","inspection_id":"87001305","insp_violation_id":"271694249","seq_no":"1","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"211531486","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-13T10:52:00.000000Z","updated_at":"2026-02-21T10:38:34.000000Z","normalized_code":"39378AWS"},{"id":18566207,"change_date":"2026-02-10 21:38:00","inspection_id":"87001305","insp_violation_id":"271694250","seq_no":"2","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"211531486","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-13T10:52:00.000000Z","updated_at":"2026-02-21T10:38:34.000000Z","normalized_code":"3939ALHLI"},{"id":18566208,"change_date":"2026-02-10 21:38:00","inspection_id":"87001305","insp_violation_id":"271694251","seq_no":"3","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"211531486","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-13T10:52:00.000000Z","updated_at":"2026-02-21T10:38:34.000000Z","normalized_code":"3939ALCL"},{"id":18566209,"change_date":"2026-02-10 21:38:00","inspection_id":"87001305","insp_violation_id":"271694252","seq_no":"4","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"211531486","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2026-02-13T10:52:00.000000Z","updated_at":"2026-02-21T10:38:34.000000Z","normalized_code":"39375A3TAOL"},{"id":18566210,"change_date":"2026-02-10 21:38:00","inspection_id":"87001305","insp_violation_id":"271694253","seq_no":"5","part_no":"393","part_no_section":"55E-B","insp_viol_unit":"2","insp_unit_id":"211531487","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-13T10:52:00.000000Z","updated_at":"2026-02-21T10:38:34.000000Z","normalized_code":"39355EB"},{"id":18566211,"change_date":"2026-02-10 21:38:00","inspection_id":"87001305","insp_violation_id":"271694254","seq_no":"6","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"211531486","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-13T10:52:00.000000Z","updated_at":"2026-02-21T10:38:34.000000Z","normalized_code":"3922SLLIFTA"},{"id":18566212,"change_date":"2026-02-10 21:38:00","inspection_id":"87001305","insp_violation_id":"271694255","seq_no":"7","part_no":"393","part_no_section":"9A-LSLIWR","insp_viol_unit":"2","insp_unit_id":"211531487","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2026-02-13T10:52:00.000000Z","updated_at":"2026-02-21T10:38:34.000000Z","normalized_code":"3939ALSLIWR"}],"inspection_per_units":[{"id":18911397,"change_date":"2026-02-10 21:38:00","inspection_id":"87001305","insp_unit_id":"211531486","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"02","insp_unit_license":"FA1268","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKWD49X74R397895","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-13T10:15:33.000000Z","updated_at":"2026-02-21T10:02:49.000000Z"},{"id":18911398,"change_date":"2026-02-10 21:38:00","inspection_id":"87001305","insp_unit_id":"211531487","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"R506","insp_unit_license":"FY4936","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GR1A062XSW726514","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-13T10:15:33.000000Z","updated_at":"2026-02-21T10:02:49.000000Z"}]},{"id":10394775,"change_date":"2025-12-10 21:37:00","inspection_id":"86524702","dot_number":"1202329","report_state":"NY","report_number":"SPA3031052","insp_date":"2025-12-03 00:00:00","insp_start_time":"1046","insp_end_time":"1103","registration_date":null,"region":"ES","ci_status_code":"C","location":"50370M","location_desc":"IRVING NY","county_code_state":"NY","county_code":"013","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"RAW SEAFOOD","shipping_paper_number":"3835397","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":"2025-12-10 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"119200","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":"2636364","transaction_code":"A","transaction_date":"2025-12-09 00:00:00","upload_date":"2025-12-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01202329","upload_search_indicator":null,"census_search_date":"2025-12-10 21:37:00","snet_input_date":"2025-12-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-12-10 21:37:00","insp_carrier_name":"RIVER VALLEY TRUCKING LLC","insp_carrier_street":"606 17TH AVE","insp_carrier_city":"ELDORA","insp_carrier_state":"IA","insp_carrier_zip_code":"50627","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-13T10:31:23.000000Z","updated_at":"2025-12-14T10:30:13.000000Z","inspection_violations":[{"id":17411523,"change_date":"2025-12-10 21:37:00","inspection_id":"86524702","insp_violation_id":"270576811","seq_no":"1","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"210517013","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-13T10:32:15.000000Z","updated_at":"2025-12-14T10:30:16.000000Z","normalized_code":"3922SLLIFTA"}],"inspection_per_units":[{"id":17378214,"change_date":"2025-12-10 21:37:00","inspection_id":"86524702","insp_unit_id":"210517013","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":null,"insp_unit_license":"MX2648","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"4V4NC9EH4KN193814","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-13T10:01:42.000000Z","updated_at":"2025-12-14T10:00:19.000000Z"},{"id":17378215,"change_date":"2025-12-10 21:37:00","inspection_id":"86524702","insp_unit_id":"210517014","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"R506","insp_unit_license":"FY4936","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GR1A062XSW726514","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-13T10:01:42.000000Z","updated_at":"2025-12-14T10:00:19.000000Z"}]},{"id":9955992,"change_date":"2025-10-16 21:39:00","inspection_id":"86063813","dot_number":"1202329","report_state":"CO","report_number":"1705150551","insp_date":"2025-10-14 00:00:00","insp_start_time":"1054","insp_end_time":"1112","registration_date":null,"region":"MD","ci_status_code":"C","location":"36H178","location_desc":"COPE CO","county_code_state":"CO","county_code":"121","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"NONE","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-10-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"116200","viol_total":"2","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":"2418919","transaction_code":"A","transaction_date":"2025-10-15 00:00:00","upload_date":"2025-10-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01202329","upload_search_indicator":null,"census_search_date":"2025-10-16 21:39:00","snet_input_date":"2025-10-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-16 21:39:00","insp_carrier_name":"RIVER VALLEY TRUCKING LLC","insp_carrier_street":"606 17TH AVE","insp_carrier_city":"ELDORA","insp_carrier_state":"IA","insp_carrier_zip_code":"50627","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-19T10:01:29.000000Z","updated_at":"2025-10-20T10:00:17.000000Z","inspection_violations":[{"id":16439484,"change_date":"2025-10-16 21:39:00","inspection_id":"86063813","insp_violation_id":"269330949","seq_no":"1","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"209497271","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-19T10:17:26.000000Z","updated_at":"2025-10-20T10:15:29.000000Z","normalized_code":"39345B2BAIR"},{"id":16439485,"change_date":"2025-10-16 21:39:00","inspection_id":"86063813","insp_violation_id":"269330950","seq_no":"2","part_no":"393","part_no_section":"45B2-BHTD","insp_viol_unit":"1","insp_unit_id":"209497271","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-10-19T10:17:26.000000Z","updated_at":"2025-10-20T10:15:29.000000Z","normalized_code":"39345B2BHTD"}],"inspection_per_units":[{"id":16528580,"change_date":"2025-10-16 21:39:00","inspection_id":"86063813","insp_unit_id":"209497271","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"1921","insp_unit_license":"TEMP","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"4V4NC9EH4KN193814","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-19T09:46:49.000000Z","updated_at":"2025-10-20T09:45:28.000000Z"},{"id":16528581,"change_date":"2025-10-16 21:39:00","inspection_id":"86063813","insp_unit_id":"209497272","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":"24780","insp_unit_license":"FW3265","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3UTVS2534R8924904","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-19T09:46:49.000000Z","updated_at":"2025-10-20T09:45:28.000000Z"}]},{"id":9347178,"change_date":"2025-08-07 21:39:00","inspection_id":"85423994","dot_number":"1202329","report_state":"CT","report_number":"3091006015","insp_date":"2025-08-07 00:00:00","insp_start_time":"1341","insp_end_time":"1455","registration_date":null,"region":"ET","ci_status_code":"C","location":"160","location_desc":"WILLINGTON","county_code_state":"CT","county_code":"013","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"RIVER VALLEY TRUCKING LLC","shipping_paper_number":"PO144","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-08-07 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","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":"748188","transaction_code":"A","transaction_date":"2025-08-07 00:00:00","upload_date":"2025-08-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01202329","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-08-07 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-08-07 21:39:00","insp_carrier_name":"RIVER VALLEY TRUCKING LLC","insp_carrier_street":"606 17TH AVE","insp_carrier_city":"ELDORA","insp_carrier_state":"IA","insp_carrier_zip_code":"50627","insp_colonia":null,"docket_number":"479058","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-12T10:42:27.000000Z","updated_at":"2025-08-12T10:42:27.000000Z","inspection_violations":[{"id":15178394,"change_date":"2025-08-07 21:39:00","inspection_id":"85423994","insp_violation_id":"267879115","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"W1120-4466","created_at":"2025-08-10T10:44:26.000000Z","updated_at":"2025-08-11T10:43:41.000000Z","normalized_code":"3922SLLS2"},{"id":15178395,"change_date":"2025-08-07 21:39:00","inspection_id":"85423994","insp_violation_id":"267879116","seq_no":"2","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"208271871","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-08-10T10:44:26.000000Z","updated_at":"2025-08-11T10:43:41.000000Z","normalized_code":"39345B2BAIR"},{"id":15178396,"change_date":"2025-08-07 21:39:00","inspection_id":"85423994","insp_violation_id":"267879117","seq_no":"3","part_no":"393","part_no_section":"9A-LFTSI","insp_viol_unit":"1","insp_unit_id":"208271871","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-10T10:44:26.000000Z","updated_at":"2025-08-11T10:43:41.000000Z","normalized_code":"3939ALFTSI"}],"inspection_per_units":[{"id":15397943,"change_date":"2025-08-07 21:39:00","inspection_id":"85423994","insp_unit_id":"208271871","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"1201","insp_unit_license":"FJ4946","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKYD49X8HJ126129","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-10T09:46:15.000000Z","updated_at":"2025-08-11T09:45:10.000000Z"},{"id":15397944,"change_date":"2025-08-07 21:39:00","inspection_id":"85423994","insp_unit_id":"208271872","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"26835","insp_unit_license":"LR5489","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GR1A0626TW728410","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-10T09:46:15.000000Z","updated_at":"2025-08-11T09:45:10.000000Z"}]},{"id":9064618,"change_date":"2025-07-05 21:35:00","inspection_id":"85126590","dot_number":"1202329","report_state":"OH","report_number":"3220000655","insp_date":"2025-07-01 00:00:00","insp_start_time":"0932","insp_end_time":"1045","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"BUCYRUS OH","county_code_state":"OH","county_code":"033","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-07-05 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1952114","transaction_code":"A","transaction_date":"2025-07-04 00:00:00","upload_date":"2025-07-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01202329","upload_search_indicator":null,"census_search_date":"2025-07-05 21:35:00","snet_input_date":"2025-07-01 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-05 21:35:00","insp_carrier_name":"RIVER VALLEY TRUCKING LLC","insp_carrier_street":"606 17TH AVE","insp_carrier_city":"ELDORA","insp_carrier_state":"IA","insp_carrier_zip_code":"50627","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-09T10:00:18.000000Z","updated_at":"2025-07-09T10:00:18.000000Z","inspection_violations":[{"id":14589998,"change_date":"2025-07-05 21:35:00","inspection_id":"85126590","insp_violation_id":"267209145","seq_no":"1","part_no":"383","part_no_section":"23A2-LCDLN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"OHP100634070120","created_at":"2025-07-08T10:15:29.000000Z","updated_at":"2025-07-09T10:42:47.000000Z","normalized_code":"38323A2LCDLN"},{"id":14589999,"change_date":"2025-07-05 21:35:00","inspection_id":"85126590","insp_violation_id":"267209146","seq_no":"2","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":"OHP100634070120","created_at":"2025-07-08T10:15:29.000000Z","updated_at":"2025-07-09T10:42:47.000000Z","normalized_code":"3922SLLTL"}],"inspection_per_units":[{"id":14873388,"change_date":"2025-07-05 21:35:00","inspection_id":"85126590","insp_unit_id":"207705214","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"T111","insp_unit_license":"FX1679","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"2HSFHAMR6WC048449","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-08T09:45:20.000000Z","updated_at":"2025-07-09T09:45:16.000000Z"},{"id":14873389,"change_date":"2025-07-05 21:35:00","inspection_id":"85126590","insp_unit_id":"207705215","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"R115","insp_unit_license":"FW0840","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GR1A0628PE508892","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-08T09:45:20.000000Z","updated_at":"2025-07-09T09:45:16.000000Z"}]},{"id":7868001,"change_date":"2025-02-14 21:39:00","inspection_id":"83865255","dot_number":"1202329","report_state":"CT","report_number":"3019006079","insp_date":"2025-02-14 00:00:00","insp_start_time":"0658","insp_end_time":"0725","registration_date":null,"region":"ET","ci_status_code":"C","location":"003","location_desc":"ASHFORD","county_code_state":"CT","county_code":"015","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-14 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","viol_total":"4","oos_total":"0","driver_viol_total":"4","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"732456","transaction_code":"A","transaction_date":"2025-02-14 00:00:00","upload_date":"2025-02-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01202329","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-02-14 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-02-14 21:39:00","insp_carrier_name":"RIVER VALLEY TRUCKING LLC","insp_carrier_street":"606 17TH AVE","insp_carrier_city":"ELDORA","insp_carrier_state":"IA","insp_carrier_zip_code":"50627","insp_colonia":null,"docket_number":"479058","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:01:33.000000Z","updated_at":"2025-03-17T21:01:33.000000Z","inspection_violations":[{"id":12295772,"change_date":"2025-02-14 21:39:00","inspection_id":"83865255","insp_violation_id":"264514716","seq_no":"1","part_no":"392","part_no_section":"2-SLLLR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V132412-2","created_at":"2025-03-17T22:06:00.000000Z","updated_at":"2025-03-17T22:06:00.000000Z","normalized_code":"3922SLLLR"},{"id":12295773,"change_date":"2025-02-14 21:39:00","inspection_id":"83865255","insp_violation_id":"264514717","seq_no":"2","part_no":"395","part_no_section":"22H4-ELDBRODS","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-03-17T22:06:00.000000Z","updated_at":"2025-03-17T22:06:00.000000Z","normalized_code":"39522H4ELDBRODS"},{"id":12295774,"change_date":"2025-02-14 21:39:00","inspection_id":"83865255","insp_violation_id":"264514718","seq_no":"3","part_no":"395","part_no_section":"8A1-HOSP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:00.000000Z","updated_at":"2025-03-17T22:06:00.000000Z","normalized_code":"3958A1HOSP"},{"id":12295775,"change_date":"2025-02-14 21:39:00","inspection_id":"83865255","insp_violation_id":"264514719","seq_no":"4","part_no":"395","part_no_section":"24","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-03-17T22:06:00.000000Z","updated_at":"2025-03-17T22:06:00.000000Z","normalized_code":"39524"}],"inspection_per_units":[{"id":12698920,"change_date":"2025-02-14 21:39:00","inspection_id":"83865255","insp_unit_id":"205320763","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"1201","insp_unit_license":"FJ4946","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKYD49X8HJ126129","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:15.000000Z","updated_at":"2025-03-17T23:55:15.000000Z"},{"id":12698921,"change_date":"2025-02-14 21:39:00","inspection_id":"83865255","insp_unit_id":"205320764","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"19680","insp_unit_license":"FA1436","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GRAA0628KW155170","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:15.000000Z","updated_at":"2025-03-17T23:55:15.000000Z"}]},{"id":7838239,"change_date":"2025-02-11 21:39:00","inspection_id":"83834129","dot_number":"1202329","report_state":"NY","report_number":"SPT3140439","insp_date":"2025-02-04 00:00:00","insp_start_time":"1800","insp_end_time":"1817","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"ALBANY NY","county_code_state":"NY","county_code":"001","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-02-11 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1348861","transaction_code":"A","transaction_date":"2025-02-11 00:00:00","upload_date":"2025-02-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01202329","upload_search_indicator":null,"census_search_date":"2025-02-11 21:39:00","snet_input_date":"2025-02-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-11 21:39:00","insp_carrier_name":"RIVER VALLEY TRUCKING LLC","insp_carrier_street":"606 17TH AVE","insp_carrier_city":"ELDORA","insp_carrier_state":"IA","insp_carrier_zip_code":"50627","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:00:49.000000Z","updated_at":"2025-03-17T21:00:49.000000Z","inspection_violations":[{"id":12249154,"change_date":"2025-02-11 21:39:00","inspection_id":"83834129","insp_violation_id":"264451481","seq_no":"1","part_no":"395","part_no_section":"8E-HOSPDOOS","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:46.000000Z","updated_at":"2025-03-17T22:05:46.000000Z","normalized_code":"3958EHOSPDOOS"}],"inspection_per_units":[{"id":12650096,"change_date":"2025-02-11 21:39:00","inspection_id":"83834129","insp_unit_id":"205261935","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"02","insp_unit_license":"FA1268","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKWD49X74R397895","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:45.000000Z","updated_at":"2025-03-17T23:54:45.000000Z"},{"id":12650097,"change_date":"2025-02-11 21:39:00","inspection_id":"83834129","insp_unit_id":"205261936","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"R506","insp_unit_license":"FY4936","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GR1A062XSW726514","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:45.000000Z","updated_at":"2025-03-17T23:54:45.000000Z"}]},{"id":7488018,"change_date":"2024-12-23 21:39:00","inspection_id":"83466260","dot_number":"1202329","report_state":"IA","report_number":"000P165XLK","insp_date":"2024-12-18 00:00:00","insp_start_time":"0904","insp_end_time":"0945","registration_date":null,"region":"CT","ci_status_code":"C","location":"10","location_desc":"10 - I35 NB MM 30 OSCEOLA","county_code_state":"IA","county_code":"039","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"PERISHABLE DIST OF IOWA","shipping_paper_number":"85941790","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-12-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120300","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1342498","transaction_code":"A","transaction_date":"2024-12-23 00:00:00","upload_date":"2024-12-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01202329","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-12-18 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-12-23 21:39:00","insp_carrier_name":"RIVER VALLEY TRUCKING LLC","insp_carrier_street":"606 17TH AVE","insp_carrier_city":"ELDORA","insp_carrier_state":"IA","insp_carrier_zip_code":"50627","insp_colonia":null,"docket_number":"479058","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:52:19.000000Z","updated_at":"2025-03-17T20:52:19.000000Z","inspection_violations":[{"id":11705780,"change_date":"2024-12-23 21:39:00","inspection_id":"83466260","insp_violation_id":"263635349","seq_no":"4","part_no":"393","part_no_section":"9A-LSLI","insp_viol_unit":"1","insp_unit_id":"204533595","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:02.000000Z","updated_at":"2025-03-17T22:03:02.000000Z","normalized_code":"3939ALSLI"},{"id":11705781,"change_date":"2024-12-23 21:39:00","inspection_id":"83466260","insp_violation_id":"263635350","seq_no":"1","part_no":"390","part_no_section":"21TB","insp_viol_unit":"1","insp_unit_id":"204533595","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:02.000000Z","updated_at":"2025-03-17T22:03:02.000000Z","normalized_code":"39021TB"},{"id":11705782,"change_date":"2024-12-23 21:39:00","inspection_id":"83466260","insp_violation_id":"263635351","seq_no":"2","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"204533595","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:02.000000Z","updated_at":"2025-03-17T22:03:02.000000Z","normalized_code":"39360D"},{"id":11705783,"change_date":"2024-12-23 21:39:00","inspection_id":"83466260","insp_violation_id":"263635352","seq_no":"3","part_no":"392","part_no_section":"9AA1","insp_viol_unit":"1","insp_unit_id":"204533595","insp_violation_category_id":"51","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"2BRO24121809320","created_at":"2025-03-17T22:03:02.000000Z","updated_at":"2025-03-17T22:03:02.000000Z","normalized_code":"3929AA1"}],"inspection_per_units":[{"id":12080416,"change_date":"2024-12-23 21:39:00","inspection_id":"83466260","insp_unit_id":"204533595","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"312","insp_unit_license":"FJ4947","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"2HSCEAPR17C450436","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:48:25.000000Z","updated_at":"2025-03-17T23:48:25.000000Z"},{"id":12080417,"change_date":"2024-12-23 21:39:00","inspection_id":"83466260","insp_unit_id":"204533596","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"R500","insp_unit_license":"FT9290","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GRAA0623AW702733","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:48:25.000000Z","updated_at":"2025-03-17T23:48:25.000000Z"}]},{"id":7371463,"change_date":"2024-12-09 21:41:00","inspection_id":"83343842","dot_number":"1202329","report_state":"IA","report_number":"000P14DM0Z","insp_date":"2024-12-08 00:00:00","insp_start_time":"1004","insp_end_time":"1050","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"I-80\/35 WB MM 132","county_code_state":"IA","county_code":"153","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"HYVEE","shipping_paper_number":"117433","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-12-09 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"1341058","transaction_code":"A","transaction_date":"2024-12-09 00:00:00","upload_date":"2024-12-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01202329","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-12-08 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-12-09 21:41:00","insp_carrier_name":"RIVER VALLEY TRUCKING LLC","insp_carrier_street":"606 17TH AVE","insp_carrier_city":"ELDORA","insp_carrier_state":"IA","insp_carrier_zip_code":"50627","insp_colonia":null,"docket_number":"479058","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:49:49.000000Z","updated_at":"2025-03-17T20:49:49.000000Z","inspection_violations":[{"id":11518721,"change_date":"2024-12-09 21:41:00","inspection_id":"83343842","insp_violation_id":"263330002","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:02.000000Z","updated_at":"2025-03-17T22:02:02.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":11891482,"change_date":"2024-12-09 21:41:00","inspection_id":"83343842","insp_unit_id":"204269351","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"312","insp_unit_license":"FJ4947","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"2HSCEAPR17C450436","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:19.000000Z","updated_at":"2025-03-17T23:46:19.000000Z"},{"id":11891483,"change_date":"2024-12-09 21:41:00","inspection_id":"83343842","insp_unit_id":"204269352","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"R500","insp_unit_license":"FT9290","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GRAA0623AW702733","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:19.000000Z","updated_at":"2025-03-17T23:46:19.000000Z"}]},{"id":7291706,"change_date":"2024-11-27 21:39:00","inspection_id":"83259724","dot_number":"1202329","report_state":"VA","report_number":"4371000462","insp_date":"2024-11-26 00:00:00","insp_start_time":"1144","insp_end_time":"1250","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"DUMFRIES VA","county_code_state":"VA","county_code":"153","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"DUTCHLAND FOODS","shipping_paper_number":"76-0020503","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-11-27 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1099407","transaction_code":"A","transaction_date":"2024-11-27 00:00:00","upload_date":"2024-11-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01202329","upload_search_indicator":null,"census_search_date":"2024-11-27 21:39:00","snet_input_date":"2024-11-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-27 21:39:00","insp_carrier_name":"RIVER VALLEY TRUCKING LLC","insp_carrier_street":"606 17TH AVE","insp_carrier_city":"ELDORA","insp_carrier_state":"IA","insp_carrier_zip_code":"50627","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:48:10.000000Z","updated_at":"2025-03-17T20:48:10.000000Z","inspection_violations":[{"id":11401584,"change_date":"2024-11-27 21:39:00","inspection_id":"83259724","insp_violation_id":"263121903","seq_no":"1","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"204081893","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:27.000000Z","updated_at":"2025-03-17T22:01:27.000000Z","normalized_code":"39617CPI"},{"id":11401585,"change_date":"2024-11-27 21:39:00","inspection_id":"83259724","insp_violation_id":"263121904","seq_no":"2","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-03-17T22:01:27.000000Z","updated_at":"2025-03-17T22:01:27.000000Z","normalized_code":"39522GELDMFV"},{"id":11401586,"change_date":"2024-11-27 21:39:00","inspection_id":"83259724","insp_violation_id":"263121905","seq_no":"3","part_no":"395","part_no_section":"8A1-HOSP","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-17T22:01:27.000000Z","updated_at":"2025-03-17T22:01:27.000000Z","normalized_code":"3958A1HOSP"}],"inspection_per_units":[{"id":11761926,"change_date":"2024-11-27 21:39:00","inspection_id":"83259724","insp_unit_id":"204081893","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"1118","insp_unit_license":"FS7414","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3HSCXAPR8BN370097","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:54.000000Z","updated_at":"2025-03-17T23:44:54.000000Z"},{"id":11761927,"change_date":"2024-11-27 21:39:00","inspection_id":"83259724","insp_unit_id":"204081894","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"FW4028","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GRAA0621DB705321","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:54.000000Z","updated_at":"2025-03-17T23:44:54.000000Z"}]},{"id":6771269,"change_date":"2024-09-19 21:42:00","inspection_id":"82707489","dot_number":"1202329","report_state":"TX","report_number":"6YJD9DIO8P","insp_date":"2024-09-10 00:00:00","insp_start_time":"1308","insp_end_time":"1342","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0035 IN HILL CO. (357-370)","county_code_state":"TX","county_code":"217","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"EMPTY","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-09-19 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"8","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9381087","transaction_code":"A","transaction_date":"2024-09-19 00:00:00","upload_date":"2024-09-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01202329","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-09-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-09-19 21:42:00","insp_carrier_name":"RIVER VALLEY TRUCKING LLC","insp_carrier_street":"606 17TH AVE","insp_carrier_city":"ELDORA","insp_carrier_state":"IA","insp_carrier_zip_code":"50627","insp_colonia":null,"docket_number":"479058","insp_interstate":"Y","insp_carrier_state_id":"1042286","created_at":"2025-03-17T20:37:21.000000Z","updated_at":"2025-03-17T20:37:21.000000Z","inspection_violations":[{"id":10545469,"change_date":"2024-09-19 21:42:00","inspection_id":"82707489","insp_violation_id":"261928379","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"203033699","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:04.000000Z","updated_at":"2025-03-17T21:57:04.000000Z","normalized_code":"39311"},{"id":10545470,"change_date":"2024-09-19 21:42:00","inspection_id":"82707489","insp_violation_id":"261928380","seq_no":"2","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"203033698","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:04.000000Z","updated_at":"2025-03-17T21:57:04.000000Z","normalized_code":"39360D"},{"id":10545471,"change_date":"2024-09-19 21:42:00","inspection_id":"82707489","insp_violation_id":"261928381","seq_no":"3","part_no":"395","part_no_section":"22(g)","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-03-17T21:57:04.000000Z","updated_at":"2025-03-17T21:57:04.000000Z","normalized_code":"39522G"},{"id":10545472,"change_date":"2024-09-19 21:42:00","inspection_id":"82707489","insp_violation_id":"261928382","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"203033698","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:04.000000Z","updated_at":"2025-03-17T21:57:04.000000Z","normalized_code":"3939A"},{"id":10545473,"change_date":"2024-09-19 21:42:00","inspection_id":"82707489","insp_violation_id":"261928383","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"203033698","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:04.000000Z","updated_at":"2025-03-17T21:57:04.000000Z","normalized_code":"3939A"},{"id":10545474,"change_date":"2024-09-19 21:42:00","inspection_id":"82707489","insp_violation_id":"261928384","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"203033698","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:04.000000Z","updated_at":"2025-03-17T21:57:04.000000Z","normalized_code":"3939A"},{"id":10545475,"change_date":"2024-09-19 21:42:00","inspection_id":"82707489","insp_violation_id":"261928385","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"203033698","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:04.000000Z","updated_at":"2025-03-17T21:57:04.000000Z","normalized_code":"3939A"},{"id":10545476,"change_date":"2024-09-19 21:42:00","inspection_id":"82707489","insp_violation_id":"261928386","seq_no":"8","part_no":"395","part_no_section":"8(f)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:04.000000Z","updated_at":"2025-03-17T21:57:04.000000Z","normalized_code":"3958F1"}],"inspection_per_units":[{"id":10919107,"change_date":"2024-09-19 21:42:00","inspection_id":"82707489","insp_unit_id":"203033698","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"312","insp_unit_license":"FJ4947","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"2HSCEAPR17C450436","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:06.000000Z","updated_at":"2025-03-17T23:36:06.000000Z"},{"id":10919108,"change_date":"2024-09-19 21:42:00","inspection_id":"82707489","insp_unit_id":"203033699","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GRDN","insp_unit_company":"R500","insp_unit_license":"FT9290","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GRAA0623AW702733","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:06.000000Z","updated_at":"2025-03-17T23:36:06.000000Z"}]},{"id":6161193,"change_date":"2024-07-08 21:42:00","inspection_id":"82055900","dot_number":"1202329","report_state":"IN","report_number":"8632008067","insp_date":"2024-07-07 00:00:00","insp_start_time":"1702","insp_end_time":"1731","registration_date":null,"region":"CD","ci_status_code":"C","location":"2265-3","location_desc":"PORTAGE IN","county_code_state":"IN","county_code":"127","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"HY VEE","shipping_paper_number":"963129","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-07-08 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","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":"633434","transaction_code":"A","transaction_date":"2024-07-08 00:00:00","upload_date":"2024-07-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01202329","upload_search_indicator":null,"census_search_date":"2024-07-08 21:42:00","snet_input_date":"2024-07-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-07-08 21:42:00","insp_carrier_name":"RIVER VALLEY TRUCKING LLC","insp_carrier_street":"606 17TH AVE","insp_carrier_city":"ELDORA","insp_carrier_state":"IA","insp_carrier_zip_code":"50627","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:24:58.000000Z","updated_at":"2025-03-17T20:24:58.000000Z","inspection_violations":[{"id":9563341,"change_date":"2024-07-08 21:42:00","inspection_id":"82055900","insp_violation_id":"260500420","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":"000195909901","created_at":"2025-03-17T21:52:19.000000Z","updated_at":"2025-03-17T21:52:19.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9924963,"change_date":"2024-07-08 21:42:00","inspection_id":"82055900","insp_unit_id":"201764230","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"1016","insp_unit_license":"FX8979","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3HSCXAPR2AN266932","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:51.000000Z","updated_at":"2025-03-17T23:25:51.000000Z"},{"id":9924964,"change_date":"2024-07-08 21:42:00","inspection_id":"82055900","insp_unit_id":"201764231","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"R500","insp_unit_license":"FT9290","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GRAA0623AW702733","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:51.000000Z","updated_at":"2025-03-17T23:25:51.000000Z"}]},{"id":6038738,"change_date":"2024-06-20 21:43:00","inspection_id":"81924282","dot_number":"1202329","report_state":"IL","report_number":"4179110080","insp_date":"2024-06-17 00:00:00","insp_start_time":"1430","insp_end_time":"1434","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"I94","county_code_state":"IL","county_code":"031","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-20 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"55000","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":"2332196","transaction_code":"A","transaction_date":"2024-06-17 00:00:00","upload_date":"2024-06-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01202329","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-06-17 00:00:00","source_office":"3ILS001","mcmis_add_date":"2024-06-20 21:43:00","insp_carrier_name":"RIVER VALLEY TRUCKING LLC","insp_carrier_street":"606 17TH AVE","insp_carrier_city":"ELDORA","insp_carrier_state":"IA","insp_carrier_zip_code":"50627","insp_colonia":null,"docket_number":"479058","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:22:18.000000Z","updated_at":"2025-03-17T20:22:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9726148,"change_date":"2024-06-20 21:43:00","inspection_id":"81924282","insp_unit_id":"201509982","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"FB7515","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XPBD49X8FD203562","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:47.000000Z","updated_at":"2025-03-17T23:23:47.000000Z"}]},{"id":6003064,"change_date":"2024-06-17 21:42:00","inspection_id":"81885750","dot_number":"1202329","report_state":"CO","report_number":"1330010486","insp_date":"2024-06-11 00:00:00","insp_start_time":"1339","insp_end_time":"1354","registration_date":null,"region":"MD","ci_status_code":"C","location":"DUPEEB","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":"FULLER ORCHARDS","shipping_paper_number":"201","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":"2024-06-17 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":"575109","transaction_code":"A","transaction_date":"2024-06-17 00:00:00","upload_date":"2024-06-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01202329","upload_search_indicator":null,"census_search_date":"2024-06-17 21:42:00","snet_input_date":"2024-06-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-06-17 21:42:00","insp_carrier_name":"RIVER VALLEY TRUCKING LLC","insp_carrier_street":"606 17TH AVE","insp_carrier_city":"ELDORA","insp_carrier_state":"IA","insp_carrier_zip_code":"50627","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:21:50.000000Z","updated_at":"2025-03-17T20:21:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9668832,"change_date":"2024-06-17 21:42:00","inspection_id":"81885750","insp_unit_id":"201417673","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"T111","insp_unit_license":"FX167","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"2HSFHAMR6WC048449","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:12.000000Z","updated_at":"2025-03-17T23:23:12.000000Z"},{"id":9668833,"change_date":"2024-06-17 21:42:00","inspection_id":"81885750","insp_unit_id":"201417674","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"R500","insp_unit_license":"FB7516","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GRAA0623AW702733","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:12.000000Z","updated_at":"2025-03-17T23:23:12.000000Z"}]},{"id":5855188,"change_date":"2024-05-28 21:43:00","inspection_id":"81725078","dot_number":"1202329","report_state":"IA","report_number":"000TT45Q73","insp_date":"2024-05-24 00:00:00","insp_start_time":"1255","insp_end_time":"1320","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"I-35 93MM","county_code_state":"IA","county_code":"153","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-28 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"1314810","transaction_code":"A","transaction_date":"2024-05-28 00:00:00","upload_date":"2024-05-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01202329","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-05-24 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-05-28 21:43:00","insp_carrier_name":"RIVER VALLEY TRUCKING LLC","insp_carrier_street":"606 17TH AVE","insp_carrier_city":"ELDORA","insp_carrier_state":"IA","insp_carrier_zip_code":"50627","insp_colonia":null,"docket_number":"479058","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:18:42.000000Z","updated_at":"2025-03-17T20:18:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9430284,"change_date":"2024-05-28 21:43:00","inspection_id":"81725078","insp_unit_id":"201110222","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"T111","insp_unit_license":"FX1679","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"2HSFHAMR6WC048449","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:52.000000Z","updated_at":"2025-03-17T23:20:52.000000Z"}]},{"id":5686571,"change_date":"2024-05-28 21:42:00","inspection_id":"81542146","dot_number":"1202329","report_state":"ME","report_number":"8980999998","insp_date":"2024-05-07 00:00:00","insp_start_time":"0747","insp_end_time":"0844","registration_date":"2024-05-28 00:00:00","region":"ET","ci_status_code":"C","location":"000295","location_desc":"KITTERY - SCALES","county_code_state":"ME","county_code":"031","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"-","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-05-07 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"6","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"379096","transaction_code":"C","transaction_date":"2024-05-13 00:00:00","upload_date":"2024-05-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01202329","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-05-07 00:00:00","source_office":"1MES001","mcmis_add_date":"2024-05-07 21:42:00","insp_carrier_name":"RIVER VALLEY TRUCKING LLC","insp_carrier_street":"606 17TH AVE","insp_carrier_city":"ELDORA","insp_carrier_state":"IA","insp_carrier_zip_code":"50627","insp_colonia":null,"docket_number":"479058","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:15:28.000000Z","updated_at":"2025-03-17T20:15:28.000000Z","inspection_violations":[{"id":8799028,"change_date":"2024-05-28 21:42:00","inspection_id":"81542146","insp_violation_id":"259747112","seq_no":"1","part_no":"395","part_no_section":"8(f)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:31.000000Z","updated_at":"2025-03-17T21:48:31.000000Z","normalized_code":"3958F1"},{"id":8799029,"change_date":"2024-05-28 21:42:00","inspection_id":"81542146","insp_violation_id":"259747113","seq_no":"2","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"201099173","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:31.000000Z","updated_at":"2025-03-17T21:48:31.000000Z","normalized_code":"39395A"},{"id":8799030,"change_date":"2024-05-28 21:42:00","inspection_id":"81542146","insp_violation_id":"259747114","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"201099173","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:31.000000Z","updated_at":"2025-03-17T21:48:31.000000Z","normalized_code":"39617C"},{"id":8799031,"change_date":"2024-05-28 21:42:00","inspection_id":"81542146","insp_violation_id":"259747115","seq_no":"4","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"201099173","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:31.000000Z","updated_at":"2025-03-17T21:48:31.000000Z","normalized_code":"39311"},{"id":8799032,"change_date":"2024-05-28 21:42:00","inspection_id":"81542146","insp_violation_id":"259747116","seq_no":"5","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"201099174","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:31.000000Z","updated_at":"2025-03-17T21:48:31.000000Z","normalized_code":"39617C"},{"id":8799033,"change_date":"2024-05-28 21:42:00","inspection_id":"81542146","insp_violation_id":"259747117","seq_no":"6","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"201099174","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:31.000000Z","updated_at":"2025-03-17T21:48:31.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":9159183,"change_date":"2024-05-28 21:42:00","inspection_id":"81542146","insp_unit_id":"201099173","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"02","insp_unit_license":"FA1268","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKWD49X74R397895","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:13.000000Z","updated_at":"2025-03-17T23:18:13.000000Z"},{"id":9159184,"change_date":"2024-05-28 21:42:00","inspection_id":"81542146","insp_unit_id":"201099174","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"R500","insp_unit_license":"FB7516","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GRAA0623AW702733","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:13.000000Z","updated_at":"2025-03-17T23:18:13.000000Z"}]},{"id":5457421,"change_date":"2024-04-08 21:43:00","inspection_id":"81292293","dot_number":"1202329","report_state":"MO","report_number":"W032000473","insp_date":"2024-04-07 00:00:00","insp_start_time":"1650","insp_end_time":"1740","registration_date":null,"region":"CD","ci_status_code":"C","location":"A4S","location_desc":"HARRISONVILLE MO","county_code_state":"MO","county_code":"037","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-04-08 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"5","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":"380560","transaction_code":"C","transaction_date":"2024-04-08 00:00:00","upload_date":"2024-04-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01202329","upload_search_indicator":null,"census_search_date":"2024-04-08 21:43:00","snet_input_date":"2024-04-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-04-08 21:43:00","insp_carrier_name":"RIVER VALLEY TRUCKING LLC","insp_carrier_street":"606 17TH AVE","insp_carrier_city":"ELDORA","insp_carrier_state":"IA","insp_carrier_zip_code":"50627","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:10:44.000000Z","updated_at":"2025-03-17T20:10:44.000000Z","inspection_violations":[{"id":8424157,"change_date":"2024-04-08 21:43:00","inspection_id":"81292293","insp_violation_id":"258796177","seq_no":"1","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"200283015","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:48.000000Z","updated_at":"2025-03-17T21:46:48.000000Z","normalized_code":"39375C"},{"id":8424158,"change_date":"2024-04-08 21:43:00","inspection_id":"81292293","insp_violation_id":"258796178","seq_no":"2","part_no":"395","part_no_section":"8(a)","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:46:48.000000Z","updated_at":"2025-03-17T21:46:48.000000Z","normalized_code":"3958A"},{"id":8424159,"change_date":"2024-04-08 21:43:00","inspection_id":"81292293","insp_violation_id":"258796179","seq_no":"3","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"200283015","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:48.000000Z","updated_at":"2025-03-17T21:46:48.000000Z","normalized_code":"39348A"},{"id":8424160,"change_date":"2024-04-08 21:43:00","inspection_id":"81292293","insp_violation_id":"258796180","seq_no":"4","part_no":"393","part_no_section":"205(a)","insp_viol_unit":"1","insp_unit_id":"200283014","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:46:48.000000Z","updated_at":"2025-03-17T21:46:48.000000Z","normalized_code":"393205A"},{"id":8424161,"change_date":"2024-04-08 21:43:00","inspection_id":"81292293","insp_violation_id":"258796181","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200283014","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:48.000000Z","updated_at":"2025-03-17T21:46:48.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":8790923,"change_date":"2024-04-08 21:43:00","inspection_id":"81292293","insp_unit_id":"200283014","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"FJ4950","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"2HSFHAMR7SC036532","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:46.000000Z","updated_at":"2025-03-17T23:14:46.000000Z"},{"id":8790924,"change_date":"2024-04-08 21:43:00","inspection_id":"81292293","insp_unit_id":"200283015","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"FW4028","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GRAA0621DB705321","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:46.000000Z","updated_at":"2025-03-17T23:14:46.000000Z"}]},{"id":5133452,"change_date":"2024-03-22 21:39:00","inspection_id":"80939142","dot_number":"1202329","report_state":"NJ","report_number":"SPPTI00471","insp_date":"2024-02-22 00:00:00","insp_start_time":"0824","insp_end_time":"0840","registration_date":"2024-03-10 00:00:00","region":"ET","ci_status_code":"C","location":"0338","location_desc":"SOUTH","county_code_state":"NJ","county_code":"005","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-26 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1196282","transaction_code":"C","transaction_date":"2024-02-22 00:00:00","upload_date":"2024-03-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01202329","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-02-22 00:00:00","source_office":"1NJS001","mcmis_add_date":"2024-02-26 21:41:00","insp_carrier_name":"RIVER VALLEY TRUCKING LLC","insp_carrier_street":"606 17TH AVE","insp_carrier_city":"ELDORA","insp_carrier_state":"IA","insp_carrier_zip_code":"50627","insp_colonia":null,"docket_number":"479058","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:04:14.000000Z","updated_at":"2025-03-17T20:04:14.000000Z","inspection_violations":[{"id":7915911,"change_date":"2024-03-22 21:39:00","inspection_id":"80939142","insp_violation_id":"258534082","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":"VERBAL","created_at":"2025-03-17T21:44:13.000000Z","updated_at":"2025-03-17T21:44:13.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8265097,"change_date":"2024-03-22 21:39:00","inspection_id":"80939142","insp_unit_id":"200043325","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"1201","insp_unit_license":"FJ4946","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1KKYD49X8HJ126129","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:55.000000Z","updated_at":"2025-03-17T23:09:55.000000Z"},{"id":8265098,"change_date":"2024-03-22 21:39:00","inspection_id":"80939142","insp_unit_id":"200043326","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"R503","insp_unit_license":"FW4027","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GRAA623DB705319","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:55.000000Z","updated_at":"2025-03-17T23:09:55.000000Z"}]},{"id":4756106,"change_date":"2024-01-03 21:44:00","inspection_id":"80526467","dot_number":"1202329","report_state":"IA","report_number":"000P14W16Z","insp_date":"2024-01-01 00:00:00","insp_start_time":"1145","insp_end_time":"1205","registration_date":null,"region":"CT","ci_status_code":"C","location":"28","location_desc":"28 - I80 WB MM 44 AVOCA","county_code_state":"IA","county_code":"155","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"HYVEE","shipping_paper_number":"888171","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-03 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1299188","transaction_code":"A","transaction_date":"2024-01-03 00:00:00","upload_date":"2024-01-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01202329","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-01-01 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-01-03 21:44:00","insp_carrier_name":"RIVER VALLEY TRUCKING LLC","insp_carrier_street":"606 17TH AVE","insp_carrier_city":"ELDORA","insp_carrier_state":"IA","insp_carrier_zip_code":"50627","insp_colonia":null,"docket_number":"479058","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:56:56.000000Z","updated_at":"2025-03-17T19:56:56.000000Z","inspection_violations":[{"id":7339063,"change_date":"2024-01-03 21:44:00","inspection_id":"80526467","insp_violation_id":"257166051","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"7CRA24010111490","created_at":"2025-03-17T21:41:24.000000Z","updated_at":"2025-03-17T21:41:24.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7651225,"change_date":"2024-01-03 21:44:00","inspection_id":"80526467","insp_unit_id":"198794810","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"T108","insp_unit_license":"FB7518","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"4V4NC9EH3DN563962","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:24.000000Z","updated_at":"2025-03-17T23:04:24.000000Z"},{"id":7651226,"change_date":"2024-01-03 21:44:00","inspection_id":"80526467","insp_unit_id":"198794811","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"19686","insp_unit_license":"FA0728","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GRAA0629KW155176","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:24.000000Z","updated_at":"2025-03-17T23:04:24.000000Z"}]},{"id":4044408,"change_date":"2023-09-26 21:43:00","inspection_id":"79742152","dot_number":"1202329","report_state":"IA","report_number":"000P14GT03","insp_date":"2023-09-21 00:00:00","insp_start_time":"1506","insp_end_time":"1640","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 163 EB","county_code_state":"IA","county_code":"123","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"PDI","shipping_paper_number":"846890","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"168700","viol_total":"3","oos_total":"2","driver_viol_total":"3","driver_oos_total":"2","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1289832","transaction_code":"C","transaction_date":"2023-09-23 00:00:00","upload_date":"2023-09-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01202329","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-09-21 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-09-25 21:40:00","insp_carrier_name":"RIVER VALLEY TRUCKING LLC","insp_carrier_street":"606 17TH AVE","insp_carrier_city":"ELDORA","insp_carrier_state":"IA","insp_carrier_zip_code":"50627","insp_colonia":null,"docket_number":"479058","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:42:46.000000Z","updated_at":"2025-03-17T19:42:46.000000Z","inspection_violations":[{"id":6260232,"change_date":"2023-09-26 21:43:00","inspection_id":"79742152","insp_violation_id":"255495367","seq_no":"1","part_no":"395","part_no_section":"8(e)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"4VAN23092115553","created_at":"2025-03-17T21:36:14.000000Z","updated_at":"2025-03-17T21:36:14.000000Z","normalized_code":"3958E1"},{"id":6260233,"change_date":"2023-09-26 21:43:00","inspection_id":"79742152","insp_violation_id":"255495368","seq_no":"2","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":"99","citation_number":null,"created_at":"2025-03-17T21:36:14.000000Z","updated_at":"2025-03-17T21:36:14.000000Z","normalized_code":"3958A1"},{"id":6260234,"change_date":"2023-09-26 21:43:00","inspection_id":"79742152","insp_violation_id":"255495369","seq_no":"3","part_no":"392","part_no_section":"60(a)","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:36:14.000000Z","updated_at":"2025-03-17T21:36:14.000000Z","normalized_code":"39260A"}],"inspection_per_units":[{"id":6502604,"change_date":"2023-09-26 21:43:00","inspection_id":"79742152","insp_unit_id":"197249166","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"T108","insp_unit_license":"FB7518","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"4V4NC9EH3DN563962","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:34.000000Z","updated_at":"2025-03-17T22:54:34.000000Z"},{"id":6502605,"change_date":"2023-09-26 21:43:00","inspection_id":"79742152","insp_unit_id":"197249167","insp_unit_type_id":"11","insp_unit_number":"2","insp_unit_make":"VOLV","insp_unit_company":"T108","insp_unit_license":"FB7518","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"4V4NC9EH3DN563962","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:34.000000Z","updated_at":"2025-03-17T22:54:34.000000Z"},{"id":6502606,"change_date":"2023-09-26 21:43:00","inspection_id":"79742152","insp_unit_id":"197249168","insp_unit_type_id":"9","insp_unit_number":"3","insp_unit_make":"GDAN","insp_unit_company":"22764","insp_unit_license":"FR9311","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GR1A062XNW415363","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:34.000000Z","updated_at":"2025-03-17T22:54:34.000000Z"}]},{"id":3910032,"change_date":"2023-09-06 21:42:00","inspection_id":"79592743","dot_number":"1202329","report_state":"WV","report_number":"4708001589","insp_date":"2023-09-06 00:00:00","insp_start_time":"1440","insp_end_time":"1455","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"COOPERS ROCK WEIGH STATION","county_code_state":"WV","county_code":"077","insp_level_id":"3","service_center":"EA","census_source_id":"4","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":"I","final_status_date":"2023-09-06 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"536165","transaction_code":"A","transaction_date":"2023-09-06 00:00:00","upload_date":"2023-09-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01202329","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-09-06 00:00:00","source_office":"1WVS001","mcmis_add_date":"2023-09-06 21:42:00","insp_carrier_name":"RIVER VALLEY TRUCKING LLC","insp_carrier_street":"606 17TH AVE","insp_carrier_city":"ELDORA","insp_carrier_state":"IA","insp_carrier_zip_code":"50627","insp_colonia":null,"docket_number":"479058","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:40:05.000000Z","updated_at":"2025-03-17T19:40:05.000000Z","inspection_violations":[{"id":6042285,"change_date":"2023-09-06 21:42:00","inspection_id":"79592743","insp_violation_id":"255098916","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:35:16.000000Z","updated_at":"2025-03-17T21:35:16.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6286764,"change_date":"2023-09-06 21:42:00","inspection_id":"79592743","insp_unit_id":"196912383","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"T108","insp_unit_license":"FB7518","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"4V4NC9EH3DN563962","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:49.000000Z","updated_at":"2025-03-17T22:52:49.000000Z"},{"id":6286765,"change_date":"2023-09-06 21:42:00","inspection_id":"79592743","insp_unit_id":"196912384","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"R115","insp_unit_license":"FW0840","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GR1A0628PE508892","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:49.000000Z","updated_at":"2025-03-17T22:52:49.000000Z"}]},{"id":3885102,"change_date":"2023-09-01 21:38:00","inspection_id":"79564973","dot_number":"1202329","report_state":"MO","report_number":"0672000042","insp_date":"2023-08-31 00:00:00","insp_start_time":"1431","insp_end_time":"1525","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"KINGDOM CITYMO","county_code_state":"MO","county_code":"027","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2023-09-01 21:38: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":"48190","transaction_code":"A","transaction_date":"2023-09-01 00:00:00","upload_date":"2023-09-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01202329","upload_search_indicator":null,"census_search_date":"2023-09-01 21:38:00","snet_input_date":"2023-08-31 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-09-01 21:38:00","insp_carrier_name":"RIVER VALLEY TRUCKING LLC","insp_carrier_street":"606 17TH AVE","insp_carrier_city":"ELDORA","insp_carrier_state":"IA","insp_carrier_zip_code":"50627","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:39:42.000000Z","updated_at":"2025-03-17T19:39:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6246195,"change_date":"2023-09-01 21:38:00","inspection_id":"79564973","insp_unit_id":"196856816","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"FW0839","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1M1AW07Y1GM056093","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:29.000000Z","updated_at":"2025-03-17T22:52:29.000000Z"},{"id":6246196,"change_date":"2023-09-01 21:38:00","inspection_id":"79564973","insp_unit_id":"196856817","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"FR9314","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GR1A0629NW415368","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:29.000000Z","updated_at":"2025-03-17T22:52:29.000000Z"}]},{"id":3844557,"change_date":"2023-08-28 21:42:00","inspection_id":"79519870","dot_number":"1202329","report_state":"IL","report_number":"4181480025","insp_date":"2023-08-26 00:00:00","insp_start_time":"1833","insp_end_time":"1847","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"I-80","county_code_state":"IL","county_code":"073","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"NEW HOLLAND FRESH PR","shipping_paper_number":"0019271335","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-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":"2271262","transaction_code":"A","transaction_date":"2023-08-26 00:00:00","upload_date":"2023-08-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01202329","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-08-26 00:00:00","source_office":"3ILS001","mcmis_add_date":"2023-08-28 21:42:00","insp_carrier_name":"RIVER VALLEY TRUCKING LLC","insp_carrier_street":"606 17TH AVE","insp_carrier_city":"ELDORA","insp_carrier_state":"IA","insp_carrier_zip_code":"50627","insp_colonia":null,"docket_number":"479058","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:38:54.000000Z","updated_at":"2025-03-17T19:38:54.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6181176,"change_date":"2023-08-28 21:42:00","inspection_id":"79519870","insp_unit_id":"196758653","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"1201","insp_unit_license":"FJ4946","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XYD49X8HJ126129","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:56.000000Z","updated_at":"2025-03-17T22:51:56.000000Z"},{"id":6181177,"change_date":"2023-08-28 21:42:00","inspection_id":"79519870","insp_unit_id":"196758654","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"R504","insp_unit_license":"FW4028","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GRAA0621DB705321","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:56.000000Z","updated_at":"2025-03-17T22:51:56.000000Z"}]},{"id":3685907,"change_date":"2023-08-07 21:42:00","inspection_id":"79342844","dot_number":"1202329","report_state":"IA","report_number":"000TT8BT51","insp_date":"2023-08-04 00:00:00","insp_start_time":"2044","insp_end_time":"2115","registration_date":null,"region":"CT","ci_status_code":"C","location":"02","location_desc":"02 - I80 EB MM 115 VAN METER","county_code_state":"IA","county_code":"049","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"PURDUE\/PDI\/HYVEE","shipping_paper_number":"27289","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-08-07 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"1283714","transaction_code":"A","transaction_date":"2023-08-07 00:00:00","upload_date":"2023-08-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01202329","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-08-04 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-08-07 21:42:00","insp_carrier_name":"RIVER VALLEY TRUCKING LLC","insp_carrier_street":"606 17TH AVE","insp_carrier_city":"ELDORA","insp_carrier_state":"IA","insp_carrier_zip_code":"50627","insp_colonia":null,"docket_number":"479058","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:35:40.000000Z","updated_at":"2025-03-17T19:35:40.000000Z","inspection_violations":[{"id":5682969,"change_date":"2023-08-07 21:42:00","inspection_id":"79342844","insp_violation_id":"254508187","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:21.000000Z","updated_at":"2025-03-17T21:33:21.000000Z","normalized_code":"3922"},{"id":5682970,"change_date":"2023-08-07 21:42:00","inspection_id":"79342844","insp_violation_id":"254508188","seq_no":"2","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":"1TIN23080420545","created_at":"2025-03-17T21:33:21.000000Z","updated_at":"2025-03-17T21:33:21.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5926131,"change_date":"2023-08-07 21:42:00","inspection_id":"79342844","insp_unit_id":"196401184","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"T111","insp_unit_license":"DX5657","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"2HSFHAMR6WC048449","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:49.000000Z","updated_at":"2025-03-17T22:49:49.000000Z"},{"id":5926132,"change_date":"2023-08-07 21:42:00","inspection_id":"79342844","insp_unit_id":"196401185","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"17645","insp_unit_license":"DF2471","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GRAA0628HW703161","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:49.000000Z","updated_at":"2025-03-17T22:49:49.000000Z"}]},{"id":3511201,"change_date":"2023-07-14 21:41:00","inspection_id":"79146692","dot_number":"1202329","report_state":"IA","report_number":"000P136NHX","insp_date":"2023-07-14 00:00:00","insp_start_time":"0944","insp_end_time":"1015","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 60SB BY ALTON, IA","county_code_state":"IA","county_code":"167","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"730350","viol_total":"3","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1281167","transaction_code":"A","transaction_date":"2023-07-14 00:00:00","upload_date":"2023-07-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01202329","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-07-14 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-07-14 21:41:00","insp_carrier_name":"RIVER VALLEY TRUCKING LLC","insp_carrier_street":"606 17TH AVE","insp_carrier_city":"ELDORA","insp_carrier_state":"IA","insp_carrier_zip_code":"50627","insp_colonia":null,"docket_number":"479058","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:32:28.000000Z","updated_at":"2025-03-17T19:32:28.000000Z","inspection_violations":[{"id":5413485,"change_date":"2023-07-14 21:41:00","inspection_id":"79146692","insp_violation_id":"254067601","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:07.000000Z","updated_at":"2025-03-17T21:32:07.000000Z","normalized_code":"3922"},{"id":5413486,"change_date":"2023-07-14 21:41:00","inspection_id":"79146692","insp_violation_id":"254067602","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"196006419","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:07.000000Z","updated_at":"2025-03-17T21:32:07.000000Z","normalized_code":"39617C"},{"id":5413487,"change_date":"2023-07-14 21:41:00","inspection_id":"79146692","insp_violation_id":"254067603","seq_no":"3","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":"99","citation_number":"1HIL23071410053","created_at":"2025-03-17T21:32:07.000000Z","updated_at":"2025-03-17T21:32:07.000000Z","normalized_code":"3958A1"}],"inspection_per_units":[{"id":5645815,"change_date":"2023-07-14 21:41:00","inspection_id":"79146692","insp_unit_id":"196006419","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"T108","insp_unit_license":"FB7518","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"4V4NC9EH3DN563962","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:34.000000Z","updated_at":"2025-03-17T22:47:34.000000Z"},{"id":5645816,"change_date":"2023-07-14 21:41:00","inspection_id":"79146692","insp_unit_id":"196006420","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"22764","insp_unit_license":"FR9311","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GR1A062XNW415363","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:34.000000Z","updated_at":"2025-03-17T22:47:34.000000Z"}]},{"id":3293019,"change_date":"2023-06-15 21:42:00","inspection_id":"78901410","dot_number":"1202329","report_state":"OK","report_number":"PE16200158","insp_date":"2023-06-14 00:00:00","insp_start_time":"1300","insp_end_time":"1331","registration_date":null,"region":"CT","ci_status_code":"C","location":"36035","location_desc":"BRAMAN SCALES","county_code_state":"OK","county_code":"071","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"ZARDA FOODS INC","shipping_paper_number":"10632","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-15 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"118350","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":"713292","transaction_code":"A","transaction_date":"2023-06-15 00:00:00","upload_date":"2023-06-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01202329","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-06-14 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-06-15 21:42:00","insp_carrier_name":"RIVER VALLEY TRUCKING LLC","insp_carrier_street":"606 17TH AVE","insp_carrier_city":"ELDORA","insp_carrier_state":"IA","insp_carrier_zip_code":"50627","insp_colonia":null,"docket_number":"479058","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:28:10.000000Z","updated_at":"2025-03-17T19:28:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5294057,"change_date":"2023-06-15 21:42:00","inspection_id":"78901410","insp_unit_id":"195515981","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"T108","insp_unit_license":"FB7518","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"4V4NC9EH3DN563962","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:43.000000Z","updated_at":"2025-03-17T22:44:43.000000Z"},{"id":5294058,"change_date":"2023-06-15 21:42:00","inspection_id":"78901410","insp_unit_id":"195515982","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"20712","insp_unit_license":"FB2996","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GR1A0628LW173427","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:43.000000Z","updated_at":"2025-03-17T22:44:43.000000Z"}]},{"id":3259316,"change_date":"2023-06-29 21:43:00","inspection_id":"78863169","dot_number":"1202329","report_state":"IL","report_number":"4180770070","insp_date":"2023-06-11 00:00:00","insp_start_time":"1046","insp_end_time":"1101","registration_date":"2023-06-29 00:00:00","region":"CT","ci_status_code":"C","location":"999","location_desc":"I-80","county_code_state":"IL","county_code":"197","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"HYVEE","shipping_paper_number":"5594669","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-12 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":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2251835","transaction_code":"C","transaction_date":"2023-06-11 00:00:00","upload_date":"2023-06-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01202329","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-06-11 00:00:00","source_office":"3ILS001","mcmis_add_date":"2023-06-12 21:40:00","insp_carrier_name":"RIVER VALLEY TRUCKING LLC","insp_carrier_street":"606 17TH AVE","insp_carrier_city":"ELDORA","insp_carrier_state":"IA","insp_carrier_zip_code":"50627","insp_colonia":null,"docket_number":"479058","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:27:23.000000Z","updated_at":"2025-03-17T19:27:23.000000Z","inspection_violations":[{"id":5024646,"change_date":"2023-06-29 21:43:00","inspection_id":"78863169","insp_violation_id":"253795135","seq_no":"1","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:30:22.000000Z","updated_at":"2025-03-17T21:30:22.000000Z","normalized_code":"3922"},{"id":5024647,"change_date":"2023-06-29 21:43:00","inspection_id":"78863169","insp_violation_id":"253795136","seq_no":"2","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:30:22.000000Z","updated_at":"2025-03-17T21:30:22.000000Z","normalized_code":"3922"},{"id":5024648,"change_date":"2023-06-29 21:43:00","inspection_id":"78863169","insp_violation_id":"253795137","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:22.000000Z","updated_at":"2025-03-17T21:30:22.000000Z","normalized_code":"3922"},{"id":5024649,"change_date":"2023-06-29 21:43:00","inspection_id":"78863169","insp_violation_id":"253795138","seq_no":"4","part_no":"395","part_no_section":"8(f)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:22.000000Z","updated_at":"2025-03-17T21:30:22.000000Z","normalized_code":"3958F1"}],"inspection_per_units":[{"id":5241483,"change_date":"2023-06-29 21:43:00","inspection_id":"78863169","insp_unit_id":"195762528","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"T104","insp_unit_license":"FB7517","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"2HSCUAPR39C045653","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:19.000000Z","updated_at":"2025-03-17T22:44:19.000000Z"},{"id":5241484,"change_date":"2023-06-29 21:43:00","inspection_id":"78863169","insp_unit_id":"195762529","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"R112","insp_unit_license":"FH5991","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GRAA0624GW702815","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:19.000000Z","updated_at":"2025-03-17T22:44:19.000000Z"}]},{"id":3231289,"change_date":"2023-06-07 21:42:00","inspection_id":"78831690","dot_number":"1202329","report_state":"OH","report_number":"1931002693","insp_date":"2023-06-07 00:00:00","insp_start_time":"1330","insp_end_time":"1355","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"RAMP TO BICKETT","county_code_state":"OH","county_code":"057","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"GENERAL MILLS OPERATIONS LLC","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":"I","final_status_date":"2023-06-07 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1661075","transaction_code":"A","transaction_date":"2023-06-07 00:00:00","upload_date":"2023-06-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01202329","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-06-07 00:00:00","source_office":"3OHS001","mcmis_add_date":"2023-06-07 21:42:00","insp_carrier_name":"RIVER VALLEY TRUCKING LLC","insp_carrier_street":"606 17TH AVE","insp_carrier_city":"ELDORA","insp_carrier_state":"IA","insp_carrier_zip_code":"50627","insp_colonia":null,"docket_number":"479058","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:26:55.000000Z","updated_at":"2025-03-17T19:26:55.000000Z","inspection_violations":[{"id":4980407,"change_date":"2023-06-07 21:42:00","inspection_id":"78831690","insp_violation_id":"253358529","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195375092","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:12.000000Z","updated_at":"2025-03-17T21:30:12.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":5196737,"change_date":"2023-06-07 21:42:00","inspection_id":"78831690","insp_unit_id":"195375092","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"FB7517","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"2HSCUAPR39C045653","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:57.000000Z","updated_at":"2025-03-17T22:43:57.000000Z"},{"id":5196738,"change_date":"2023-06-07 21:42:00","inspection_id":"78831690","insp_unit_id":"195375093","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"FB7517","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GRAA0621HW704717","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:57.000000Z","updated_at":"2025-03-17T22:43:57.000000Z"}]},{"id":3298938,"change_date":"2023-06-19 21:36:00","inspection_id":"78908206","dot_number":"1202329","report_state":"TX","report_number":"V231041418","insp_date":"2023-06-06 00:00:00","insp_start_time":"1400","insp_end_time":"1423","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US 77 MM 714 SB","county_code_state":"TX","county_code":"261","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"RIVER VALLEY TRUCKING LLC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-06-15 21:43: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":"9006463","transaction_code":"C","transaction_date":"2023-06-19 00:00:00","upload_date":"2023-06-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01202329","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-06-06 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-06-15 21:43:00","insp_carrier_name":"RIVER VALLEY TRUCKING LLC","insp_carrier_street":"606 17TH AVE","insp_carrier_city":"ELDORA","insp_carrier_state":"IA","insp_carrier_zip_code":"50627","insp_colonia":null,"docket_number":"479058","insp_interstate":"Y","insp_carrier_state_id":"1042286","created_at":"2025-03-17T19:28:12.000000Z","updated_at":"2025-03-17T19:28:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5304164,"change_date":"2023-06-19 21:36:00","inspection_id":"78908206","insp_unit_id":"195563454","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"EAGI","insp_unit_company":"112","insp_unit_license":"FJ4950","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"2HSFHAMR7SC036532","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:50.000000Z","updated_at":"2025-03-17T22:44:50.000000Z"},{"id":5304165,"change_date":"2023-06-19 21:36:00","inspection_id":"78908206","insp_unit_id":"195563455","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"R112","insp_unit_license":"FH5991","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GRAA0624GW702815","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:50.000000Z","updated_at":"2025-03-17T22:44:50.000000Z"}]},{"id":3048433,"change_date":"2023-05-16 21:41:00","inspection_id":"78625418","dot_number":"1202329","report_state":"US","report_number":"1186000021","insp_date":"2023-05-10 00:00:00","insp_start_time":"1038","insp_end_time":"1106","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"EAST MOLINEIL","county_code_state":"IL","county_code":"001","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"GENERAL MILLS","shipping_paper_number":"0087161241","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":"2023-05-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","viol_total":"2","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":"15542","transaction_code":"A","transaction_date":"2023-05-16 00:00:00","upload_date":"2023-05-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01202329","upload_search_indicator":null,"census_search_date":"2023-05-16 21:41:00","snet_input_date":"2023-05-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-05-16 21:41:00","insp_carrier_name":"RIVER VALLEY TRUCKING LLC","insp_carrier_street":"606 17TH AVE","insp_carrier_city":"ELDORA","insp_carrier_state":"IA","insp_carrier_zip_code":"50627","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:23:23.000000Z","updated_at":"2025-03-17T19:23:23.000000Z","inspection_violations":[{"id":4685592,"change_date":"2023-05-16 21:41:00","inspection_id":"78625418","insp_violation_id":"252844703","seq_no":"1","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"194939897","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:51.000000Z","updated_at":"2025-03-17T21:28:51.000000Z","normalized_code":"39395A4EEUS"},{"id":4685593,"change_date":"2023-05-16 21:41:00","inspection_id":"78625418","insp_violation_id":"252844704","seq_no":"2","part_no":"393","part_no_section":"9A-LFTSI","insp_viol_unit":"1","insp_unit_id":"194939897","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:51.000000Z","updated_at":"2025-03-17T21:28:51.000000Z","normalized_code":"3939ALFTSI"}],"inspection_per_units":[{"id":4904487,"change_date":"2023-05-16 21:41:00","inspection_id":"78625418","insp_unit_id":"194939897","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"FJ4946","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKYD49X8HJ126129","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:39.000000Z","updated_at":"2025-03-17T22:41:39.000000Z"},{"id":4904488,"change_date":"2023-05-16 21:41:00","inspection_id":"78625418","insp_unit_id":"194939898","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"FP2562","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GRAA0625FW701624","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:39.000000Z","updated_at":"2025-03-17T22:41:39.000000Z"}]},{"id":2766037,"change_date":"2023-04-12 21:40:00","inspection_id":"78305919","dot_number":"1202329","report_state":"IA","report_number":"000TT6CCZJ","insp_date":"2023-04-07 00:00:00","insp_start_time":"1301","insp_end_time":"1330","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"I-35 NB\/72.6","county_code_state":"IA","county_code":"153","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"TYSON FOODS, INC","shipping_paper_number":"2275","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-04-11 12:04:00","post_acc_ind":"Y","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":"1270029","transaction_code":"C","transaction_date":"2023-04-11 00:00:00","upload_date":"2023-04-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01202329","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-04-07 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-04-11 12:04:00","insp_carrier_name":"RIVER VALLEY TRUCKING LLC","insp_carrier_street":"606 17TH AVE","insp_carrier_city":"ELDORA","insp_carrier_state":"IA","insp_carrier_zip_code":"50627","insp_colonia":null,"docket_number":"479058","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:17:40.000000Z","updated_at":"2025-03-17T19:17:40.000000Z","inspection_violations":[{"id":4243921,"change_date":"2023-04-12 21:40:00","inspection_id":"78305919","insp_violation_id":"252175427","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:26:52.000000Z","updated_at":"2025-03-17T21:26:52.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4451801,"change_date":"2023-04-12 21:40:00","inspection_id":"78305919","insp_unit_id":"194346454","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"T111","insp_unit_license":"DX5657","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"2HSFHAMR6WC048449","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:03.000000Z","updated_at":"2025-03-17T22:38:03.000000Z"},{"id":4451802,"change_date":"2023-04-12 21:40:00","inspection_id":"78305919","insp_unit_id":"194346455","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"10499","insp_unit_license":"DB1813","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GRAA0628AW700881","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:03.000000Z","updated_at":"2025-03-17T22:38:03.000000Z"}]},{"id":2299041,"change_date":"2023-02-04 21:31:00","inspection_id":"77773825","dot_number":"1202329","report_state":"IN","report_number":"9761000669","insp_date":"2023-01-31 00:00:00","insp_start_time":"1557","insp_end_time":"1629","registration_date":null,"region":"ET","ci_status_code":"C","location":"2269S","location_desc":"#22  I-69  SB  HUNTINGTON","county_code_state":"IN","county_code":"069","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-02-04 21:31:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"2173487","transaction_code":"A","transaction_date":"2023-02-02 00:00:00","upload_date":"2023-02-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01202329","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-02-02 00:00:00","source_office":"3INS001","mcmis_add_date":"2023-02-04 21:31:00","insp_carrier_name":"RIVER VALLEY TRUCKING LLC","insp_carrier_street":"606 17TH AVE","insp_carrier_city":"ELDORA","insp_carrier_state":"IA","insp_carrier_zip_code":"50627","insp_colonia":null,"docket_number":"479058","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:08:55.000000Z","updated_at":"2025-03-17T19:08:55.000000Z","inspection_violations":[{"id":3544526,"change_date":"2023-02-04 21:31:00","inspection_id":"77773825","insp_violation_id":"250954841","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"175944438","created_at":"2025-03-17T21:23:46.000000Z","updated_at":"2025-03-17T21:23:46.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":3700687,"change_date":"2023-02-04 21:31:00","inspection_id":"77773825","insp_unit_id":"193231971","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"1016","insp_unit_license":"FT4241","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3HSCXAPR2AN266932","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:31.000000Z","updated_at":"2025-03-17T22:32:31.000000Z"},{"id":3700688,"change_date":"2023-02-04 21:31:00","inspection_id":"77773825","insp_unit_id":"193231972","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"R103","insp_unit_license":"FB7512","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GRAA06278W700753","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:31.000000Z","updated_at":"2025-03-17T22:32:31.000000Z"}]},{"id":1836562,"change_date":"2022-11-30 21:40:00","inspection_id":"77245129","dot_number":"1202329","report_state":"TX","report_number":"6G9C0XCSRW","insp_date":"2022-11-22 00:00:00","insp_start_time":"1136","insp_end_time":"1211","registration_date":null,"region":"CT","ci_status_code":"C","location":"2A701","location_desc":"IH 45 NORTHBOUND NEW WAVERLY","county_code_state":"TX","county_code":"471","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SUNNY DELIGHT BEVERAGE","shipping_paper_number":"707976","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8838173","transaction_code":"C","transaction_date":"2022-11-30 00:00:00","upload_date":"2022-11-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01202329","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-11-22 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-11-29 21:41:00","insp_carrier_name":"RIVER VALLEY TRUCKING LLC","insp_carrier_street":"606 17TH AVE","insp_carrier_city":"ELDORA","insp_carrier_state":"IA","insp_carrier_zip_code":"50627","insp_colonia":null,"docket_number":"479058","insp_interstate":"Y","insp_carrier_state_id":"1042286","created_at":"2025-03-17T19:00:23.000000Z","updated_at":"2025-03-17T19:00:23.000000Z","inspection_violations":[{"id":2866121,"change_date":"2022-11-30 21:40:00","inspection_id":"77245129","insp_violation_id":"249856828","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"192198388","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:20:39.000000Z","updated_at":"2025-03-17T21:20:39.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":2955042,"change_date":"2022-11-30 21:40:00","inspection_id":"77245129","insp_unit_id":"192198387","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"112","insp_unit_license":"FJ4950","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"2HSFHAMR7SC036532","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:14.000000Z","updated_at":"2025-03-17T22:27:14.000000Z"},{"id":2955043,"change_date":"2022-11-30 21:40:00","inspection_id":"77245129","insp_unit_id":"192198388","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GRDN","insp_unit_company":"03","insp_unit_license":"FH5991","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GRAA0624GW702815","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:14.000000Z","updated_at":"2025-03-17T22:27:14.000000Z"}]},{"id":1720959,"change_date":"2022-11-11 21:31:00","inspection_id":"77112430","dot_number":"1202329","report_state":"AR","report_number":"758C000286","insp_date":"2022-11-09 00:00:00","insp_start_time":"0910","insp_end_time":"1020","registration_date":null,"region":"CT","ci_status_code":"C","location":"17-301","location_desc":"CRAWFORD COUNTY(ALMA EAST STN)","county_code_state":"AR","county_code":"033","insp_level_id":"1","service_center":"SH","census_source_id":"4","insp_facility":"F","shipper_name":"TYSON","shipping_paper_number":"0017695024","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-11-11 21:31:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1429003","transaction_code":"A","transaction_date":"2022-11-10 00:00:00","upload_date":"2022-11-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01202329","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-11-10 00:00:00","source_office":"2ARS001","mcmis_add_date":"2022-11-11 21:31:00","insp_carrier_name":"RIVER VALLEY TRUCKING LLC","insp_carrier_street":"606 17TH AVE","insp_carrier_city":"ELDORA","insp_carrier_state":"IA","insp_carrier_zip_code":"50627","insp_colonia":null,"docket_number":"479058","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:58:30.000000Z","updated_at":"2025-03-17T18:58:30.000000Z","inspection_violations":[{"id":2696889,"change_date":"2022-11-11 21:31:00","inspection_id":"77112430","insp_violation_id":"249554136","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"191913795","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:19:40.000000Z","updated_at":"2025-03-17T21:19:40.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":2768694,"change_date":"2022-11-11 21:31:00","inspection_id":"77112430","insp_unit_id":"191913795","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"112","insp_unit_license":"FJ4950","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"2HSFHAMR7SC036532","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:56.000000Z","updated_at":"2025-03-17T22:25:56.000000Z"},{"id":2768695,"change_date":"2022-11-11 21:31:00","inspection_id":"77112430","insp_unit_id":"191913796","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"110","insp_unit_license":"FA1522","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GRAA0625FW701607","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:56.000000Z","updated_at":"2025-03-17T22:25:56.000000Z"}]},{"id":1709722,"change_date":"2022-11-09 21:41:00","inspection_id":"77099659","dot_number":"1202329","report_state":"PA","report_number":"N636231205","insp_date":"2022-11-08 00:00:00","insp_start_time":"1634","insp_end_time":"1653","registration_date":null,"region":"ET","ci_status_code":"C","location":"999","location_desc":"I80 W AT MM 294.3","county_code_state":"PA","county_code":"089","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"PATRIOT PICKLE, INC.","shipping_paper_number":"706078","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-11-09 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"150349","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":"2298715","transaction_code":"A","transaction_date":"2022-11-08 00:00:00","upload_date":"2022-11-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01202329","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-11-08 00:00:00","source_office":"1PAS001","mcmis_add_date":"2022-11-09 21:41:00","insp_carrier_name":"RIVER VALLEY TRUCKING LLC","insp_carrier_street":"606 17TH AVE","insp_carrier_city":"ELDORA","insp_carrier_state":"IA","insp_carrier_zip_code":"50627","insp_colonia":null,"docket_number":"479058","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:58:12.000000Z","updated_at":"2025-03-17T18:58:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2750561,"change_date":"2022-11-09 21:41:00","inspection_id":"77099659","insp_unit_id":"191888253","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"T108","insp_unit_license":"FB7518","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"4V4NC9EH3DN563962","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:50.000000Z","updated_at":"2025-03-17T22:25:50.000000Z"},{"id":2750562,"change_date":"2022-11-09 21:41:00","inspection_id":"77099659","insp_unit_id":"191888254","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GRDN","insp_unit_company":"R109","insp_unit_license":"FB7515","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GRAA0621HW704717","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:50.000000Z","updated_at":"2025-03-17T22:25:50.000000Z"}]},{"id":1363978,"change_date":"2022-09-26 21:39:00","inspection_id":"76700995","dot_number":"1202329","report_state":"OK","report_number":"PE11183070","insp_date":"2022-09-18 00:00:00","insp_start_time":"1448","insp_end_time":"1520","registration_date":null,"region":"CT","ci_status_code":"C","location":"36035","location_desc":"BRAMAN SCALES","county_code_state":"OK","county_code":"071","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"PERISHABLE DISTRIBUTORS OF IOWA","shipping_paper_number":"700255","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-26 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"684594","transaction_code":"A","transaction_date":"2022-09-18 00:00:00","upload_date":"2022-09-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01202329","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-09-18 00:00:00","source_office":"2OKS001","mcmis_add_date":"2022-09-26 21:39:00","insp_carrier_name":"RIVER VALLEY TRUCKING LLC","insp_carrier_street":"606 17TH AVE","insp_carrier_city":"ELDORA","insp_carrier_state":"IA","insp_carrier_zip_code":"50627","insp_colonia":null,"docket_number":"479058","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:51:57.000000Z","updated_at":"2025-03-17T18:51:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2196147,"change_date":"2022-09-26 21:39:00","inspection_id":"76700995","insp_unit_id":"191089883","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"420","insp_unit_license":"FB8080","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1M1AW07Y1GM056093","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:02.000000Z","updated_at":"2025-03-17T22:22:02.000000Z"},{"id":2196148,"change_date":"2022-09-26 21:39:00","inspection_id":"76700995","insp_unit_id":"191089884","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"13550","insp_unit_license":"DX8188","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1UYVS2537DU709703","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:02.000000Z","updated_at":"2025-03-17T22:22:02.000000Z"}]},{"id":1225605,"change_date":"2022-09-07 21:40:00","inspection_id":"76540147","dot_number":"1202329","report_state":"MA","report_number":"DD00000092","insp_date":"2022-09-07 00:00:00","insp_start_time":"1228","insp_end_time":"1445","registration_date":null,"region":"ET","ci_status_code":"C","location":"322H","location_desc":"H-STURBRIDGE","county_code_state":"MA","county_code":"027","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"KAYEM FOODS","shipping_paper_number":"698154","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-09-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"11","oos_total":"2","driver_viol_total":"3","driver_oos_total":"1","vehicle_viol_total":"8","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"451570","transaction_code":"A","transaction_date":"2022-09-07 00:00:00","upload_date":"2022-09-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01202329","upload_search_indicator":"M","census_search_date":"2022-09-07 21:40:00","snet_input_date":"2022-09-07 00:00:00","source_office":"1MAS001","mcmis_add_date":"2022-09-07 21:40:00","insp_carrier_name":"RIVER VALLEY TRUCKING LLC","insp_carrier_street":"606 17TH AVE","insp_carrier_city":"ELDORA","insp_carrier_state":"IA","insp_carrier_zip_code":"50627","insp_colonia":null,"docket_number":"4790","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:49:19.000000Z","updated_at":"2025-03-17T18:49:19.000000Z","inspection_violations":[{"id":1941464,"change_date":"2022-09-07 21:40:00","inspection_id":"76540147","insp_violation_id":"248246656","seq_no":"1","part_no":"391","part_no_section":"45(b)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:58.000000Z","updated_at":"2025-03-17T21:15:58.000000Z","normalized_code":"39145B"},{"id":1941465,"change_date":"2022-09-07 21:40:00","inspection_id":"76540147","insp_violation_id":"248246657","seq_no":"2","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:15:58.000000Z","updated_at":"2025-03-17T21:15:58.000000Z","normalized_code":"3958A1"},{"id":1941466,"change_date":"2022-09-07 21:40:00","inspection_id":"76540147","insp_violation_id":"248246658","seq_no":"3","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"190754352","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:58.000000Z","updated_at":"2025-03-17T21:15:58.000000Z","normalized_code":"39311"},{"id":1941467,"change_date":"2022-09-07 21:40:00","inspection_id":"76540147","insp_violation_id":"248246659","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"190754353","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:15:58.000000Z","updated_at":"2025-03-17T21:15:58.000000Z","normalized_code":"3963A1"},{"id":1941468,"change_date":"2022-09-07 21:40:00","inspection_id":"76540147","insp_violation_id":"248246660","seq_no":"5","part_no":"393","part_no_section":"76","insp_viol_unit":"1","insp_unit_id":"190754352","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:58.000000Z","updated_at":"2025-03-17T21:15:58.000000Z","normalized_code":"39376"},{"id":1941469,"change_date":"2022-09-07 21:40:00","inspection_id":"76540147","insp_violation_id":"248246661","seq_no":"6","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:58.000000Z","updated_at":"2025-03-17T21:15:58.000000Z","normalized_code":"3922"},{"id":1941470,"change_date":"2022-09-07 21:40:00","inspection_id":"76540147","insp_violation_id":"248246662","seq_no":"7","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"190754352","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:58.000000Z","updated_at":"2025-03-17T21:15:58.000000Z","normalized_code":"39617C"},{"id":1941471,"change_date":"2022-09-07 21:40:00","inspection_id":"76540147","insp_violation_id":"248246663","seq_no":"9","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"190754353","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:58.000000Z","updated_at":"2025-03-17T21:15:58.000000Z","normalized_code":"39347E"},{"id":1941472,"change_date":"2022-09-07 21:40:00","inspection_id":"76540147","insp_violation_id":"248246664","seq_no":"10","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"190754352","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:58.000000Z","updated_at":"2025-03-17T21:15:58.000000Z","normalized_code":"39353B"},{"id":1941473,"change_date":"2022-09-07 21:40:00","inspection_id":"76540147","insp_violation_id":"248246665","seq_no":"11","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"190754353","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:58.000000Z","updated_at":"2025-03-17T21:15:58.000000Z","normalized_code":"39353B"},{"id":1941474,"change_date":"2022-09-07 21:40:00","inspection_id":"76540147","insp_violation_id":"248246666","seq_no":"8","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"190754352","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:58.000000Z","updated_at":"2025-03-17T21:15:58.000000Z","normalized_code":"39347E"}],"inspection_per_units":[{"id":1972224,"change_date":"2022-09-07 21:40:00","inspection_id":"76540147","insp_unit_id":"190754352","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"T-104","insp_unit_license":"FB7517","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"2HSCUAPR39C045653","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:33.000000Z","updated_at":"2025-03-17T22:20:33.000000Z"},{"id":1972225,"change_date":"2022-09-07 21:40:00","inspection_id":"76540147","insp_unit_id":"190754353","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"R500","insp_unit_license":"FB7516","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GRAA0623AW702733","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:33.000000Z","updated_at":"2025-03-17T22:20:33.000000Z"}]},{"id":1217300,"change_date":"2022-09-06 21:42:00","inspection_id":"76530759","dot_number":"1202329","report_state":"MO","report_number":"0589000396","insp_date":"2022-09-02 00:00:00","insp_start_time":"0827","insp_end_time":"0924","registration_date":null,"region":"CT","ci_status_code":"C","location":"D160","location_desc":"US 160 W\/O N RED OAK PLACE","county_code_state":"MO","county_code":"077","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"GRASSLAND BEEF LLC","shipping_paper_number":"22789","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-09-06 21:42:00","post_acc_ind":"Y","gross_comb_veh_wt":"95000","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":"2030534","transaction_code":"A","transaction_date":"2022-09-02 00:00:00","upload_date":"2022-09-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01202329","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-09-06 00:00:00","source_office":"3MOS001","mcmis_add_date":"2022-09-06 21:42:00","insp_carrier_name":"RIVER VALLEY TRUCKING LLC","insp_carrier_street":"606 17TH AVE","insp_carrier_city":"ELDORA","insp_carrier_state":"IA","insp_carrier_zip_code":"50627","insp_colonia":null,"docket_number":"479058","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:49:01.000000Z","updated_at":"2025-03-17T18:49:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1958385,"change_date":"2022-09-06 21:42:00","inspection_id":"76530759","insp_unit_id":"190736043","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"4","insp_unit_license":"FB0026","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"2HSFHAER8XC078245","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:27.000000Z","updated_at":"2025-03-17T22:20:27.000000Z"},{"id":1958386,"change_date":"2022-09-06 21:42:00","inspection_id":"76530759","insp_unit_id":"190736044","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"R501","insp_unit_license":"FB3078","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1UYVS2538EM866903","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:27.000000Z","updated_at":"2025-03-17T22:20:27.000000Z"}]},{"id":1017059,"change_date":"2022-08-11 21:38:00","inspection_id":"76297388","dot_number":"1202329","report_state":"OH","report_number":"3257051464","insp_date":"2022-08-10 00:00:00","insp_start_time":"0830","insp_end_time":"0945","registration_date":null,"region":"ET","ci_status_code":"C","location":"15580","location_desc":"GIRARD(HUBBARD)SCALES","county_code_state":"OH","county_code":"155","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"PATRIOT PICKLE INC.","shipping_paper_number":"694625","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-08-11 21:38: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":"1610804","transaction_code":"A","transaction_date":"2022-08-10 00:00:00","upload_date":"2022-08-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01202329","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-08-11 00:00:00","source_office":"3OHS001","mcmis_add_date":"2022-08-11 21:38:00","insp_carrier_name":"RIVER VALLEY TRUCKING LLC","insp_carrier_street":"606 17TH AVE","insp_carrier_city":"ELDORA","insp_carrier_state":"IA","insp_carrier_zip_code":"50627","insp_colonia":null,"docket_number":"479058","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:45:29.000000Z","updated_at":"2025-03-17T18:45:29.000000Z","inspection_violations":[{"id":1601339,"change_date":"2022-08-11 21:38:00","inspection_id":"76297388","insp_violation_id":"247657281","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190261069","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:33.000000Z","updated_at":"2025-03-17T21:14:33.000000Z","normalized_code":"3939A"},{"id":1601340,"change_date":"2022-08-11 21:38:00","inspection_id":"76297388","insp_violation_id":"247657282","seq_no":"2","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"190261069","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:33.000000Z","updated_at":"2025-03-17T21:14:33.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":1636426,"change_date":"2022-08-11 21:38:00","inspection_id":"76297388","insp_unit_id":"190261069","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"1201","insp_unit_license":"FJ4946","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKYD49X8HJ126129","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:18.000000Z","updated_at":"2025-03-17T22:18:18.000000Z"},{"id":1636427,"change_date":"2022-08-11 21:38:00","inspection_id":"76297388","insp_unit_id":"190261070","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"R109","insp_unit_license":"FB7515","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GRAA0621HW704717","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:18.000000Z","updated_at":"2025-03-17T22:18:18.000000Z"}]},{"id":762721,"change_date":"2022-07-06 21:41:00","inspection_id":"76000056","dot_number":"1202329","report_state":"OH","report_number":"1200003615","insp_date":"2022-07-04 00:00:00","insp_start_time":"1240","insp_end_time":"1305","registration_date":null,"region":"ET","ci_status_code":"C","location":"14372","location_desc":"ROADSIDE 72","county_code_state":"OH","county_code":"143","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"HYVEE","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":"I","final_status_date":"2022-07-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1605387","transaction_code":"A","transaction_date":"2022-07-04 00:00:00","upload_date":"2022-07-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01202329","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-07-06 00:00:00","source_office":"3OHS001","mcmis_add_date":"2022-07-06 21:41:00","insp_carrier_name":"RIVER VALLEY TRUCKING LLC","insp_carrier_street":"606 17TH AVE","insp_carrier_city":"ELDORA","insp_carrier_state":"IA","insp_carrier_zip_code":"50627","insp_colonia":null,"docket_number":"479058","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:41:12.000000Z","updated_at":"2025-03-17T18:41:12.000000Z","inspection_violations":[{"id":1202077,"change_date":"2022-07-06 21:41:00","inspection_id":"76000056","insp_violation_id":"246922541","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":"26BWQ","created_at":"2025-03-17T21:12:39.000000Z","updated_at":"2025-03-17T21:12:39.000000Z","normalized_code":"3922"},{"id":1202078,"change_date":"2022-07-06 21:41:00","inspection_id":"76000056","insp_violation_id":"246922542","seq_no":"2","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:12:39.000000Z","updated_at":"2025-03-17T21:12:39.000000Z","normalized_code":"3958A1"}],"inspection_per_units":[{"id":1226686,"change_date":"2022-07-06 21:41:00","inspection_id":"76000056","insp_unit_id":"189632833","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"1201","insp_unit_license":"FJ4946","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKYD49X8HJ126129","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:44.000000Z","updated_at":"2025-03-17T22:15:44.000000Z"},{"id":1226687,"change_date":"2022-07-06 21:41:00","inspection_id":"76000056","insp_unit_id":"189632834","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"R111","insp_unit_license":"FP2562","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GRAA0625FW701624","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:44.000000Z","updated_at":"2025-03-17T22:15:44.000000Z"}]},{"id":535487,"change_date":"2022-06-02 21:42:00","inspection_id":"75731609","dot_number":"1202329","report_state":"PA","report_number":"N307215211","insp_date":"2022-06-01 00:00:00","insp_start_time":"1239","insp_end_time":"1306","registration_date":null,"region":"ET","ci_status_code":"C","location":"999","location_desc":"I-80 WB OFF RAMP ATEXIT 274","county_code_state":"PA","county_code":"025","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"PATRIOT PICKEL","shipping_paper_number":"1111040","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-06-02 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"91200","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":"2261212","transaction_code":"A","transaction_date":"2022-06-01 00:00:00","upload_date":"2022-06-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01202329","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-06-01 00:00:00","source_office":"1PAS001","mcmis_add_date":"2022-06-02 21:42:00","insp_carrier_name":"RIVER VALLEY TRUCKING LLC","insp_carrier_street":"606 17TH AVE","insp_carrier_city":"ELDORA","insp_carrier_state":"IA","insp_carrier_zip_code":"50627","insp_colonia":null,"docket_number":"479058","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:37:05.000000Z","updated_at":"2025-03-17T18:37:05.000000Z","inspection_violations":[{"id":845645,"change_date":"2022-06-02 21:42:00","inspection_id":"75731609","insp_violation_id":"246225549","seq_no":"1","part_no":"395","part_no_section":"22(h)(4)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"T9714924-2","created_at":"2025-03-17T21:11:01.000000Z","updated_at":"2025-03-17T21:11:01.000000Z","normalized_code":"39522H4"}],"inspection_per_units":[{"id":861768,"change_date":"2022-06-02 21:42:00","inspection_id":"75731609","insp_unit_id":"189045848","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"1201","insp_unit_license":"FJ4946","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKYD49X8HJ126129","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:31.000000Z","updated_at":"2025-03-17T22:13:31.000000Z"},{"id":861769,"change_date":"2022-06-02 21:42:00","inspection_id":"75731609","insp_unit_id":"189045849","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"R109","insp_unit_license":"FB7515","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GRAA0621HW704717","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:31.000000Z","updated_at":"2025-03-17T22:13:31.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1202329\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1202329\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1202329\/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\/1202329\/inspections","per_page":100,"prev_page_url":null,"to":50,"total":50}