{"current_page":1,"data":[{"id":8292520,"change_date":"2025-04-04 21:40:00","inspection_id":"84311590","dot_number":"1827560","report_state":"CO","report_number":"1290330478","insp_date":"2025-04-02 00:00:00","insp_start_time":"1626","insp_end_time":"1808","registration_date":null,"region":"MD","ci_status_code":"C","location":"CRTPOE","location_desc":"CORTEZ CO","county_code_state":"CO","county_code":"083","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"FRESH HOUSE","shipping_paper_number":"20182404","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-04-04 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","viol_total":"8","oos_total":"2","driver_viol_total":"0","driver_oos_total":"2","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1552094","transaction_code":"A","transaction_date":"2025-04-04 00:00:00","upload_date":"2025-04-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01827560","upload_search_indicator":null,"census_search_date":"2025-04-04 21:40:00","snet_input_date":"2025-04-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-04 21:40:00","insp_carrier_name":"MID COLUMBIA CARRIERS LLC","insp_carrier_street":"3107 E MAIN ST","insp_carrier_city":"OTHELLO","insp_carrier_state":"WA","insp_carrier_zip_code":"99344","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-07T10:21:49.000000Z","updated_at":"2025-04-08T10:08:38.000000Z","inspection_violations":[{"id":13038366,"change_date":"2025-04-04 21:40:00","inspection_id":"84311590","insp_violation_id":"265435488","seq_no":"1","part_no":"395","part_no_section":"8E1PC","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-04-07T10:44:22.000000Z","updated_at":"2025-04-07T10:49:41.000000Z","normalized_code":"3958E1PC"},{"id":13038367,"change_date":"2025-04-04 21:40:00","inspection_id":"84311590","insp_violation_id":"265435489","seq_no":"2","part_no":"395","part_no_section":"8E1PC","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-04-07T10:44:22.000000Z","updated_at":"2025-04-07T10:49:41.000000Z","normalized_code":"3958E1PC"},{"id":13038368,"change_date":"2025-04-04 21:40:00","inspection_id":"84311590","insp_violation_id":"265435490","seq_no":"3","part_no":"395","part_no_section":"8E1PC","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-04-07T10:44:22.000000Z","updated_at":"2025-04-07T10:49:41.000000Z","normalized_code":"3958E1PC"},{"id":13038369,"change_date":"2025-04-04 21:40:00","inspection_id":"84311590","insp_violation_id":"265435491","seq_no":"4","part_no":"395","part_no_section":"8E1PC","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-04-07T10:44:22.000000Z","updated_at":"2025-04-07T10:49:41.000000Z","normalized_code":"3958E1PC"},{"id":13038370,"change_date":"2025-04-04 21:40:00","inspection_id":"84311590","insp_violation_id":"265435492","seq_no":"5","part_no":"395","part_no_section":"8E1PC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"082507810","created_at":"2025-04-07T10:44:22.000000Z","updated_at":"2025-04-07T10:49:41.000000Z","normalized_code":"3958E1PC"},{"id":13038371,"change_date":"2025-04-04 21:40:00","inspection_id":"84311590","insp_violation_id":"265435493","seq_no":"6","part_no":"395","part_no_section":"3B2-HOSPD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"6","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-07T10:44:22.000000Z","updated_at":"2025-04-07T10:49:41.000000Z","normalized_code":"3953B2HOSPD"},{"id":13038372,"change_date":"2025-04-04 21:40:00","inspection_id":"84311590","insp_violation_id":"265435494","seq_no":"7","part_no":"395","part_no_section":"8E1PC","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-04-07T10:44:22.000000Z","updated_at":"2025-04-07T10:49:42.000000Z","normalized_code":"3958E1PC"},{"id":13038373,"change_date":"2025-04-04 21:40:00","inspection_id":"84311590","insp_violation_id":"265435495","seq_no":"8","part_no":"395","part_no_section":"8E1PC","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-04-07T10:44:22.000000Z","updated_at":"2025-04-07T10:49:42.000000Z","normalized_code":"3958E1PC"}],"inspection_per_units":[{"id":13445068,"change_date":"2025-04-04 21:40:00","inspection_id":"84311590","insp_unit_id":"206151156","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"780","insp_unit_license":"RP15871","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1XKYD49X1KJ282617","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-07T10:05:58.000000Z","updated_at":"2025-04-08T09:51:34.000000Z"},{"id":13445069,"change_date":"2025-04-04 21:40:00","inspection_id":"84311590","insp_unit_id":"206151157","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":null,"insp_unit_license":"68076AH","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1UYVS2534HM762543","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-07T10:05:58.000000Z","updated_at":"2025-04-08T09:51:34.000000Z"}]},{"id":7386826,"change_date":"2024-12-11 21:40:00","inspection_id":"83359879","dot_number":"1827560","report_state":"UT","report_number":"25TW001251","insp_date":"2024-12-10 00:00:00","insp_start_time":"1143","insp_end_time":"1229","registration_date":null,"region":"MS","ci_status_code":"C","location":"UT91","location_desc":"HELPER UT","county_code_state":"UT","county_code":"007","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"PRODUCE CONNECTION","shipping_paper_number":"0023597","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-12-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"118200","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":"1144418","transaction_code":"A","transaction_date":"2024-12-11 00:00:00","upload_date":"2024-12-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01827560","upload_search_indicator":null,"census_search_date":"2024-12-11 21:40:00","snet_input_date":"2024-12-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-12-11 21:40:00","insp_carrier_name":"MID COLUMBIA CARRIERS LLC","insp_carrier_street":"3107 E MAIN ST","insp_carrier_city":"OTHELLO","insp_carrier_state":"WA","insp_carrier_zip_code":"99344","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:50:17.000000Z","updated_at":"2025-03-17T20:50:17.000000Z","inspection_violations":[{"id":11540963,"change_date":"2024-12-11 21:40:00","inspection_id":"83359879","insp_violation_id":"263381669","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"N249100153","created_at":"2025-03-17T22:02:12.000000Z","updated_at":"2025-03-17T22:02:12.000000Z","normalized_code":"3922SLLEWA1"}],"inspection_per_units":[{"id":11916169,"change_date":"2024-12-11 21:40:00","inspection_id":"83359879","insp_unit_id":"204312618","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"776","insp_unit_license":"99592RP","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1XKYD49XXGJ114627","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:35.000000Z","updated_at":"2025-03-17T23:46:35.000000Z"},{"id":11916170,"change_date":"2024-12-11 21:40:00","inspection_id":"83359879","insp_unit_id":"204312619","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":"R24","insp_unit_license":"87315AB","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1UYVS2533FU252021","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:35.000000Z","updated_at":"2025-03-17T23:46:35.000000Z"}]},{"id":7125640,"change_date":"2024-11-06 21:40:00","inspection_id":"83084084","dot_number":"1827560","report_state":"NV","report_number":"7086028066","insp_date":"2024-11-05 00:00:00","insp_start_time":"1135","insp_end_time":"1150","registration_date":null,"region":"PT","ci_status_code":"C","location":"1","location_desc":"SR318","county_code_state":"NV","county_code":"017","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"FARMERS BEST","shipping_paper_number":"11061840","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-11-05 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":"779148","transaction_code":"C","transaction_date":"2024-11-06 00:00:00","upload_date":"2024-11-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01827560","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-11-05 00:00:00","source_office":"4NVS001","mcmis_add_date":"2024-11-05 21:39:00","insp_carrier_name":"MID COLUMBIA CARRIERS LLC","insp_carrier_street":"3107 E MAIN ST","insp_carrier_city":"OTHELLO","insp_carrier_state":"WA","insp_carrier_zip_code":"99344","insp_colonia":null,"docket_number":"829551","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:44:39.000000Z","updated_at":"2025-03-17T20:44:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11492837,"change_date":"2024-11-06 21:40:00","inspection_id":"83084084","insp_unit_id":"203766191","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"776","insp_unit_license":"99592RP","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1XKYD49XXGJ114627","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:42:04.000000Z","updated_at":"2025-03-17T23:42:04.000000Z"},{"id":11492838,"change_date":"2024-11-06 21:40:00","inspection_id":"83084084","insp_unit_id":"203766192","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"87315AB","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1UYVS2533FU252021","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:42:04.000000Z","updated_at":"2025-03-17T23:42:04.000000Z"}]},{"id":6766454,"change_date":"2024-09-26 21:40:00","inspection_id":"82702292","dot_number":"1827560","report_state":"OR","report_number":"AW43850054","insp_date":"2024-09-18 00:00:00","insp_start_time":"0923","insp_end_time":"1023","registration_date":null,"region":"PD","ci_status_code":"C","location":"30-05","location_desc":"EMIGRANT HILL OR","county_code_state":"OR","county_code":"059","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"GLENDALE AZ BREWERY","shipping_paper_number":"S742137","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-09-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"82000","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":"864183","transaction_code":"C","transaction_date":"2024-09-19 00:00:00","upload_date":"2024-09-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01827560","upload_search_indicator":null,"census_search_date":"2024-09-19 21:41:00","snet_input_date":"2024-09-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-09-19 21:41:00","insp_carrier_name":"MID COLUMBIA CARRIERS LLC","insp_carrier_street":"3107 E MAIN ST","insp_carrier_city":"OTHELLO","insp_carrier_state":"WA","insp_carrier_zip_code":"99344","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:37:19.000000Z","updated_at":"2025-03-17T20:37:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10911322,"change_date":"2024-09-26 21:40:00","inspection_id":"82702292","insp_unit_id":"203141066","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"780","insp_unit_license":"RP10001","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1XKYD49X1KJ282617","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:03.000000Z","updated_at":"2025-03-17T23:36:03.000000Z"},{"id":10911323,"change_date":"2024-09-26 21:40:00","inspection_id":"82702292","insp_unit_id":"203141067","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":"R77","insp_unit_license":"68983AH","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1UYVS2532H2951414","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:03.000000Z","updated_at":"2025-03-17T23:36:03.000000Z"}]},{"id":6221596,"change_date":"2024-07-16 21:44:00","inspection_id":"82120875","dot_number":"1827560","report_state":"NV","report_number":"7233028021","insp_date":"2024-07-14 00:00:00","insp_start_time":"1226","insp_end_time":"1245","registration_date":null,"region":"PT","ci_status_code":"C","location":"1","location_desc":"ROADSIDE","county_code_state":"NV","county_code":"003","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"EVANS FRUIT","shipping_paper_number":"18151-30","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-07-15 21:42: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":"769334","transaction_code":"C","transaction_date":"2024-07-16 00:00:00","upload_date":"2024-07-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01827560","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-07-14 00:00:00","source_office":"4NVS001","mcmis_add_date":"2024-07-15 21:42:00","insp_carrier_name":"MID COLUMBIA CARRIERS LLC","insp_carrier_street":"3107 E MAIN ST","insp_carrier_city":"OTHELLO","insp_carrier_state":"WA","insp_carrier_zip_code":"99344","insp_colonia":null,"docket_number":"829551","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:26:10.000000Z","updated_at":"2025-03-17T20:26:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10023948,"change_date":"2024-07-16 21:44:00","inspection_id":"82120875","insp_unit_id":"201911767","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"RP10000","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1XKYD49X8KJ282629","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:51.000000Z","updated_at":"2025-03-17T23:26:51.000000Z"},{"id":10023949,"change_date":"2024-07-16 21:44:00","inspection_id":"82120875","insp_unit_id":"201911768","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"68076AH","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1UYVS2534HM762543","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:51.000000Z","updated_at":"2025-03-17T23:26:51.000000Z"}]},{"id":5959700,"change_date":"2024-06-11 21:41:00","inspection_id":"81838539","dot_number":"1827560","report_state":"WA","report_number":"S780000071","insp_date":"2024-06-11 00:00:00","insp_start_time":"1145","insp_end_time":"1303","registration_date":null,"region":"PD","ci_status_code":"C","location":null,"location_desc":"OTHELLO WA","county_code_state":"WA","county_code":"001","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-06-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117500","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":"560899","transaction_code":"A","transaction_date":"2024-06-11 00:00:00","upload_date":"2024-06-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01827560","upload_search_indicator":null,"census_search_date":"2024-06-11 21:41:00","snet_input_date":"2024-06-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-06-11 21:41:00","insp_carrier_name":"MID COLUMBIA CARRIERS LLC","insp_carrier_street":"3107 E MAIN ST","insp_carrier_city":"OTHELLO","insp_carrier_state":"WA","insp_carrier_zip_code":"99344","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:20:43.000000Z","updated_at":"2025-03-17T20:20:43.000000Z","inspection_violations":[{"id":9245946,"change_date":"2024-06-11 21:41:00","inspection_id":"81838539","insp_violation_id":"260013424","seq_no":"1","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"201329013","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:44.000000Z","updated_at":"2025-03-17T21:50:44.000000Z","normalized_code":"39348A"},{"id":9245947,"change_date":"2024-06-11 21:41:00","inspection_id":"81838539","insp_violation_id":"260013425","seq_no":"2","part_no":"393","part_no_section":"201(b)","insp_viol_unit":"2","insp_unit_id":"201329013","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:44.000000Z","updated_at":"2025-03-17T21:50:44.000000Z","normalized_code":"393201B"},{"id":9245948,"change_date":"2024-06-11 21:41:00","inspection_id":"81838539","insp_violation_id":"260013426","seq_no":"3","part_no":"393","part_no_section":"78(a)","insp_viol_unit":"1","insp_unit_id":"201329012","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:44.000000Z","updated_at":"2025-03-17T21:50:44.000000Z","normalized_code":"39378A"},{"id":9245949,"change_date":"2024-06-11 21:41:00","inspection_id":"81838539","insp_violation_id":"260013427","seq_no":"4","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"201329013","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:44.000000Z","updated_at":"2025-03-17T21:50:44.000000Z","normalized_code":"39348A"}],"inspection_per_units":[{"id":9599539,"change_date":"2024-06-11 21:41:00","inspection_id":"81838539","insp_unit_id":"201329012","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"777","insp_unit_license":"RP03086","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1XPBDP9X2KD613088","insp_unit_decal":"Y","insp_unit_decal_number":"34029213","created_at":"2025-03-17T23:22:32.000000Z","updated_at":"2025-03-17T23:22:32.000000Z"},{"id":9599540,"change_date":"2024-06-11 21:41:00","inspection_id":"81838539","insp_unit_id":"201329013","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":"R24","insp_unit_license":"87315AB","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1UYVS2533FU252021","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:32.000000Z","updated_at":"2025-03-17T23:22:32.000000Z"}]},{"id":5959701,"change_date":"2024-06-11 21:41:00","inspection_id":"81838541","dot_number":"1827560","report_state":"WA","report_number":"S780000070","insp_date":"2024-06-11 00:00:00","insp_start_time":"1036","insp_end_time":"1144","registration_date":null,"region":"PD","ci_status_code":"C","location":null,"location_desc":"OTHELLO WA","county_code_state":"WA","county_code":"001","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-06-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117500","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":"560901","transaction_code":"A","transaction_date":"2024-06-11 00:00:00","upload_date":"2024-06-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01827560","upload_search_indicator":null,"census_search_date":"2024-06-11 21:41:00","snet_input_date":"2024-06-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-06-11 21:41:00","insp_carrier_name":"MID COLUMBIA CARRIERS LLC","insp_carrier_street":"3107 E MAIN ST","insp_carrier_city":"OTHELLO","insp_carrier_state":"WA","insp_carrier_zip_code":"99344","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:20:43.000000Z","updated_at":"2025-03-17T20:20:43.000000Z","inspection_violations":[{"id":9245950,"change_date":"2024-06-11 21:41:00","inspection_id":"81838541","insp_violation_id":"260013434","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"201329017","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:44.000000Z","updated_at":"2025-03-17T21:50:44.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":9599541,"change_date":"2024-06-11 21:41:00","inspection_id":"81838541","insp_unit_id":"201329016","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"779","insp_unit_license":"RP1000","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1XKYD49X8KJ282629","insp_unit_decal":"Y","insp_unit_decal_number":"34028903","created_at":"2025-03-17T23:22:32.000000Z","updated_at":"2025-03-17T23:22:32.000000Z"},{"id":9599542,"change_date":"2024-06-11 21:41:00","inspection_id":"81838541","insp_unit_id":"201329017","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":"R77","insp_unit_license":"68983AH","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1UYVS2532H2951414","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:32.000000Z","updated_at":"2025-03-17T23:22:32.000000Z"}]},{"id":5327399,"change_date":"2024-03-20 21:42:00","inspection_id":"81150553","dot_number":"1827560","report_state":"UT","report_number":"24SQ001205","insp_date":"2024-03-17 00:00:00","insp_start_time":"1608","insp_end_time":"1703","registration_date":null,"region":"MD","ci_status_code":"C","location":"UT90","location_desc":"HELPER UT","county_code_state":"UT","county_code":"007","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"LINEAGE","shipping_paper_number":"423099","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-03-20 21:42: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":"333825","transaction_code":"A","transaction_date":"2024-03-20 00:00:00","upload_date":"2024-03-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01827560","upload_search_indicator":null,"census_search_date":"2024-03-20 21:42:00","snet_input_date":"2024-03-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-03-20 21:42:00","insp_carrier_name":"MID COLUMBIA CARRIERS LLC","insp_carrier_street":"3107 E MAIN ST","insp_carrier_city":"OTHELLO","insp_carrier_state":"WA","insp_carrier_zip_code":"99344","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:08:16.000000Z","updated_at":"2025-03-17T20:08:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8579696,"change_date":"2024-03-20 21:42:00","inspection_id":"81150553","insp_unit_id":"200000146","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"779","insp_unit_license":"RP10000","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1XKYD49X8KJ282629","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:47.000000Z","updated_at":"2025-03-17T23:12:47.000000Z"},{"id":8579697,"change_date":"2024-03-20 21:42:00","inspection_id":"81150553","insp_unit_id":"200000147","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":"R26","insp_unit_license":"68076AH","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1UYVS2534HM762543","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:47.000000Z","updated_at":"2025-03-17T23:12:47.000000Z"}]},{"id":5239109,"change_date":"2024-03-08 21:38:00","inspection_id":"81054273","dot_number":"1827560","report_state":"UT","report_number":"24GD001156","insp_date":"2024-03-02 00:00:00","insp_start_time":"1028","insp_end_time":"1158","registration_date":null,"region":"MS","ci_status_code":"C","location":"UT91","location_desc":"HELPER UT","county_code_state":"UT","county_code":"007","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"WEST PAK AVACADO","shipping_paper_number":"429555","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-03-08 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"118200","viol_total":"14","oos_total":"6","driver_viol_total":"0","driver_oos_total":"5","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"302260","transaction_code":"A","transaction_date":"2024-03-08 00:00:00","upload_date":"2024-03-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01827560","upload_search_indicator":null,"census_search_date":"2024-03-08 21:38:00","snet_input_date":"2024-03-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-03-08 21:38:00","insp_carrier_name":"MID COLUMBIA CARRIERS LLC","insp_carrier_street":"3107 E MAIN ST","insp_carrier_city":"OTHELLO","insp_carrier_state":"WA","insp_carrier_zip_code":"99344","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:06:16.000000Z","updated_at":"2025-03-17T20:06:16.000000Z","inspection_violations":[{"id":8077125,"change_date":"2024-03-08 21:38:00","inspection_id":"81054273","insp_violation_id":"258271248","seq_no":"1","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"199813977","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:00.000000Z","updated_at":"2025-03-17T21:45:00.000000Z","normalized_code":"3939ALIL"},{"id":8077126,"change_date":"2024-03-08 21:38:00","inspection_id":"81054273","insp_violation_id":"258271249","seq_no":"2","part_no":"393","part_no_section":"9A-LSLIWR","insp_viol_unit":"2","insp_unit_id":"199813978","insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:45:00.000000Z","updated_at":"2025-03-17T21:45:00.000000Z","normalized_code":"3939ALSLIWR"},{"id":8077127,"change_date":"2024-03-08 21:38:00","inspection_id":"81054273","insp_violation_id":"258271250","seq_no":"3","part_no":"393","part_no_section":"207A-SAPPCBLM","insp_viol_unit":"1","insp_unit_id":"199813977","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:00.000000Z","updated_at":"2025-03-17T21:45:00.000000Z","normalized_code":"393207ASAPPCBLM"},{"id":8077128,"change_date":"2024-03-08 21:38:00","inspection_id":"81054273","insp_violation_id":"258271251","seq_no":"4","part_no":"395","part_no_section":"8(a)","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:45:00.000000Z","updated_at":"2025-03-17T21:45:00.000000Z","normalized_code":"3958A"},{"id":8077129,"change_date":"2024-03-08 21:38:00","inspection_id":"81054273","insp_violation_id":"258271252","seq_no":"5","part_no":"395","part_no_section":"8K2-HOSP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:00.000000Z","updated_at":"2025-03-17T21:45:00.000000Z","normalized_code":"3958K2HOSP"},{"id":8077130,"change_date":"2024-03-08 21:38:00","inspection_id":"81054273","insp_violation_id":"258271253","seq_no":"6","part_no":"395","part_no_section":"8K2-HOSP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:00.000000Z","updated_at":"2025-03-17T21:45:00.000000Z","normalized_code":"3958K2HOSP"},{"id":8077131,"change_date":"2024-03-08 21:38:00","inspection_id":"81054273","insp_violation_id":"258271254","seq_no":"7","part_no":"393","part_no_section":"9A-LSLI","insp_viol_unit":"1","insp_unit_id":"199813977","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:00.000000Z","updated_at":"2025-03-17T21:45:00.000000Z","normalized_code":"3939ALSLI"},{"id":8077132,"change_date":"2024-03-08 21:38:00","inspection_id":"81054273","insp_violation_id":"258271255","seq_no":"8","part_no":"393","part_no_section":"207A-SAPPCBLM","insp_viol_unit":"1","insp_unit_id":"199813977","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:00.000000Z","updated_at":"2025-03-17T21:45:00.000000Z","normalized_code":"393207ASAPPCBLM"},{"id":8077133,"change_date":"2024-03-08 21:38:00","inspection_id":"81054273","insp_violation_id":"258271256","seq_no":"9","part_no":"396","part_no_section":"3A1-BALAC","insp_viol_unit":"1","insp_unit_id":"199813977","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:00.000000Z","updated_at":"2025-03-17T21:45:00.000000Z","normalized_code":"3963A1BALAC"},{"id":8077134,"change_date":"2024-03-08 21:38:00","inspection_id":"81054273","insp_violation_id":"258271257","seq_no":"10","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"1","insp_unit_id":"199813977","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:00.000000Z","updated_at":"2025-03-17T21:45:00.000000Z","normalized_code":"39345DB"},{"id":8077135,"change_date":"2024-03-08 21:38:00","inspection_id":"81054273","insp_violation_id":"258271258","seq_no":"11","part_no":"395","part_no_section":"8E-HOSPD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:00.000000Z","updated_at":"2025-03-17T21:45:00.000000Z","normalized_code":"3958EHOSPD"},{"id":8077136,"change_date":"2024-03-08 21:38:00","inspection_id":"81054273","insp_violation_id":"258271259","seq_no":"12","part_no":"395","part_no_section":"8K2-HOSP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:00.000000Z","updated_at":"2025-03-17T21:45:00.000000Z","normalized_code":"3958K2HOSP"},{"id":8077137,"change_date":"2024-03-08 21:38:00","inspection_id":"81054273","insp_violation_id":"258271260","seq_no":"13","part_no":"395","part_no_section":"8K2-HOSP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:00.000000Z","updated_at":"2025-03-17T21:45:00.000000Z","normalized_code":"3958K2HOSP"},{"id":8077138,"change_date":"2024-03-08 21:38:00","inspection_id":"81054273","insp_violation_id":"258271261","seq_no":"14","part_no":"395","part_no_section":"8K2-HOSP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:00.000000Z","updated_at":"2025-03-17T21:45:00.000000Z","normalized_code":"3958K2HOSP"}],"inspection_per_units":[{"id":8436294,"change_date":"2024-03-08 21:38:00","inspection_id":"81054273","insp_unit_id":"199813977","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"776","insp_unit_license":"99592RP","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1XKYD49XXGJ114627","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:27.000000Z","updated_at":"2025-03-17T23:11:27.000000Z"},{"id":8436295,"change_date":"2024-03-08 21:38:00","inspection_id":"81054273","insp_unit_id":"199813978","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":"R26","insp_unit_license":"68076AH","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1UYVS2534HM762543","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:27.000000Z","updated_at":"2025-03-17T23:11:27.000000Z"}]},{"id":5174882,"change_date":"2024-02-29 21:47:00","inspection_id":"80983920","dot_number":"1827560","report_state":"UT","report_number":"24TW001157","insp_date":"2024-02-23 00:00:00","insp_start_time":"0933","insp_end_time":"1048","registration_date":null,"region":"MS","ci_status_code":"C","location":"UT91","location_desc":"HELPER UT","county_code_state":"UT","county_code":"007","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"WWEET SEASONS","shipping_paper_number":"228417","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-02-29 21:47:00","post_acc_ind":"N","gross_comb_veh_wt":"117500","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":"281488","transaction_code":"A","transaction_date":"2024-02-29 00:00:00","upload_date":"2024-02-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01827560","upload_search_indicator":null,"census_search_date":"2024-02-29 21:47:00","snet_input_date":"2024-02-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-02-29 21:47:00","insp_carrier_name":"MID COLUMBIA CARRIERS LLC","insp_carrier_street":"3107 E MAIN ST","insp_carrier_city":"OTHELLO","insp_carrier_state":"WA","insp_carrier_zip_code":"99344","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:04:59.000000Z","updated_at":"2025-03-17T20:04:59.000000Z","inspection_violations":[{"id":7975890,"change_date":"2024-02-29 21:47:00","inspection_id":"80983920","insp_violation_id":"258120616","seq_no":"1","part_no":"391","part_no_section":"11B5-LNCDLNVE","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:31.000000Z","updated_at":"2025-03-17T21:44:31.000000Z","normalized_code":"39111B5LNCDLNVE"},{"id":7975891,"change_date":"2024-02-29 21:47:00","inspection_id":"80983920","insp_violation_id":"258120617","seq_no":"2","part_no":"395","part_no_section":"8E-HOSPD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:31.000000Z","updated_at":"2025-03-17T21:44:31.000000Z","normalized_code":"3958EHOSPD"}],"inspection_per_units":[{"id":8331948,"change_date":"2024-02-29 21:47:00","inspection_id":"80983920","insp_unit_id":"199679625","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"779","insp_unit_license":"RP1000","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1XKYD49X8KJ282629","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:30.000000Z","updated_at":"2025-03-17T23:10:30.000000Z"},{"id":8331949,"change_date":"2024-02-29 21:47:00","inspection_id":"80983920","insp_unit_id":"199679626","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":"R77","insp_unit_license":"68983AH","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1UYVS2532H2951414","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:30.000000Z","updated_at":"2025-03-17T23:10:30.000000Z"}]},{"id":3275894,"change_date":"2023-06-13 21:42:00","inspection_id":"78882080","dot_number":"1827560","report_state":"OR","report_number":"AAF3000521","insp_date":"2023-06-12 00:00:00","insp_start_time":"0800","insp_end_time":"0858","registration_date":null,"region":"MT","ci_status_code":"C","location":"2305","location_desc":"OLDS FERRY - 20 MI NW ONTARIO","county_code_state":"OR","county_code":"045","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"OLYMPIC FRUIT","shipping_paper_number":"393078","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-06-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"111000","viol_total":"5","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1226855","transaction_code":"A","transaction_date":"2023-06-12 00:00:00","upload_date":"2023-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01827560","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-06-13 00:00:00","source_office":"4ORS001","mcmis_add_date":"2023-06-13 21:42:00","insp_carrier_name":"MID COLUMBIA CARRIERS LLC","insp_carrier_street":"3107 E MAIN ST","insp_carrier_city":"OTHELLO","insp_carrier_state":"WA","insp_carrier_zip_code":"99344","insp_colonia":null,"docket_number":"829551","insp_interstate":"Y","insp_carrier_state_id":"171658","created_at":"2025-03-17T19:27:45.000000Z","updated_at":"2025-03-17T19:27:45.000000Z","inspection_violations":[{"id":5051265,"change_date":"2023-06-13 21:42:00","inspection_id":"78882080","insp_violation_id":"253480243","seq_no":"1","part_no":"393","part_no_section":"205(a)","insp_viol_unit":"2","insp_unit_id":"195477449","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"WARNING","created_at":"2025-03-17T21:30:29.000000Z","updated_at":"2025-03-17T21:30:29.000000Z","normalized_code":"393205A"},{"id":5051266,"change_date":"2023-06-13 21:42:00","inspection_id":"78882080","insp_violation_id":"253480244","seq_no":"2","part_no":"393","part_no_section":"205(a)","insp_viol_unit":"2","insp_unit_id":"195477449","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:30:29.000000Z","updated_at":"2025-03-17T21:30:29.000000Z","normalized_code":"393205A"},{"id":5051267,"change_date":"2023-06-13 21:42:00","inspection_id":"78882080","insp_violation_id":"253480245","seq_no":"3","part_no":"393","part_no_section":"205(a)","insp_viol_unit":"2","insp_unit_id":"195477449","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:30:29.000000Z","updated_at":"2025-03-17T21:30:29.000000Z","normalized_code":"393205A"},{"id":5051268,"change_date":"2023-06-13 21:42:00","inspection_id":"78882080","insp_violation_id":"253480246","seq_no":"4","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"195477448","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:29.000000Z","updated_at":"2025-03-17T21:30:29.000000Z","normalized_code":"39395A"},{"id":5051269,"change_date":"2023-06-13 21:42:00","inspection_id":"78882080","insp_violation_id":"253480247","seq_no":"5","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"195477448","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:29.000000Z","updated_at":"2025-03-17T21:30:29.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":5267386,"change_date":"2023-06-13 21:42:00","inspection_id":"78882080","insp_unit_id":"195477448","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"24","insp_unit_license":"90886RP","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1XPBD48X7FD247313","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:31.000000Z","updated_at":"2025-03-17T22:44:31.000000Z"},{"id":5267387,"change_date":"2023-06-13 21:42:00","inspection_id":"78882080","insp_unit_id":"195477449","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"R26","insp_unit_license":"68076AH","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":null,"insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:31.000000Z","updated_at":"2025-03-17T22:44:31.000000Z"}]},{"id":2567384,"change_date":"2023-03-15 21:42:00","inspection_id":"78079708","dot_number":"1827560","report_state":"ID","report_number":"3200007790","insp_date":"2023-03-11 00:00:00","insp_start_time":"0458","insp_end_time":"0602","registration_date":null,"region":"MT","ci_status_code":"C","location":"8454","location_desc":"I84MP54","county_code_state":"ID","county_code":"001","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"COAST PRODUCE CO","shipping_paper_number":"687682","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-03-13 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"98000","viol_total":"8","oos_total":"4","driver_viol_total":"4","driver_oos_total":"4","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"264680","transaction_code":"C","transaction_date":"2023-03-14 00:00:00","upload_date":"2023-03-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01827560","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-03-13 00:00:00","source_office":"4IDS001","mcmis_add_date":"2023-03-13 21:43:00","insp_carrier_name":"MID COLUMBIA CARRIERS LLC","insp_carrier_street":"3107 E MAIN ST","insp_carrier_city":"OTHELLO","insp_carrier_state":"WA","insp_carrier_zip_code":"99344","insp_colonia":null,"docket_number":"829551","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:14:04.000000Z","updated_at":"2025-03-17T19:14:04.000000Z","inspection_violations":[{"id":3949069,"change_date":"2023-03-15 21:42:00","inspection_id":"78079708","insp_violation_id":"251685327","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193893985","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:31.000000Z","updated_at":"2025-03-17T21:25:31.000000Z","normalized_code":"3939A"},{"id":3949070,"change_date":"2023-03-15 21:42:00","inspection_id":"78079708","insp_violation_id":"251685328","seq_no":"2","part_no":"393","part_no_section":"55(c)(1)","insp_viol_unit":"1","insp_unit_id":"193893985","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:31.000000Z","updated_at":"2025-03-17T21:25:31.000000Z","normalized_code":"39355C1"},{"id":3949071,"change_date":"2023-03-15 21:42:00","inspection_id":"78079708","insp_violation_id":"251685329","seq_no":"3","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"193893985","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:31.000000Z","updated_at":"2025-03-17T21:25:31.000000Z","normalized_code":"39311"},{"id":3949072,"change_date":"2023-03-15 21:42:00","inspection_id":"78079708","insp_violation_id":"251685330","seq_no":"4","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"193893985","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:31.000000Z","updated_at":"2025-03-17T21:25:31.000000Z","normalized_code":"39378"},{"id":3949073,"change_date":"2023-03-15 21:42:00","inspection_id":"78079708","insp_violation_id":"251685331","seq_no":"5","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":"3","citation_number":null,"created_at":"2025-03-17T21:25:31.000000Z","updated_at":"2025-03-17T21:25:31.000000Z","normalized_code":"3958E1"},{"id":3949074,"change_date":"2023-03-15 21:42:00","inspection_id":"78079708","insp_violation_id":"251685332","seq_no":"6","part_no":"395","part_no_section":"3(a)(3)(i)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"4","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"ISP2866000237","created_at":"2025-03-17T21:25:31.000000Z","updated_at":"2025-03-17T21:25:31.000000Z","normalized_code":"3953A3I"},{"id":3949075,"change_date":"2023-03-15 21:42:00","inspection_id":"78079708","insp_violation_id":"251685333","seq_no":"7","part_no":"395","part_no_section":"3(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"4","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"ISP2866000237","created_at":"2025-03-17T21:25:31.000000Z","updated_at":"2025-03-17T21:25:31.000000Z","normalized_code":"3953A2"},{"id":3949076,"change_date":"2023-03-15 21:42:00","inspection_id":"78079708","insp_violation_id":"251685334","seq_no":"8","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:25:31.000000Z","updated_at":"2025-03-17T21:25:31.000000Z","normalized_code":"3958A1"}],"inspection_per_units":[{"id":4132030,"change_date":"2023-03-15 21:42:00","inspection_id":"78079708","insp_unit_id":"193893985","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"776","insp_unit_license":"99592RP","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1XKYD49XXGJ114627","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:37.000000Z","updated_at":"2025-03-17T22:35:37.000000Z"},{"id":4132031,"change_date":"2023-03-15 21:42:00","inspection_id":"78079708","insp_unit_id":"193893986","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"2062","insp_unit_license":"68983AH","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1UYVS2532H2951414","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:37.000000Z","updated_at":"2025-03-17T22:35:37.000000Z"}]},{"id":2415839,"change_date":"2023-02-21 21:42:00","inspection_id":"77907275","dot_number":"1827560","report_state":"OR","report_number":"AAAL000388","insp_date":"2023-02-16 00:00:00","insp_start_time":"0907","insp_end_time":"0934","registration_date":null,"region":"PT","ci_status_code":"C","location":"2408","location_desc":"WOODBURN NB - 2 MI N WOODBURN","county_code_state":"OR","county_code":"047","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-02-21 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1218937","transaction_code":"A","transaction_date":"2023-02-16 00:00:00","upload_date":"2023-02-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01827560","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-02-21 00:00:00","source_office":"4ORS001","mcmis_add_date":"2023-02-21 21:42:00","insp_carrier_name":"MID COLUMBIA CARRIERS LLC","insp_carrier_street":"3107 E MAIN ST","insp_carrier_city":"OTHELLO","insp_carrier_state":"WA","insp_carrier_zip_code":"99344","insp_colonia":null,"docket_number":"829551","insp_interstate":"Y","insp_carrier_state_id":"171658","created_at":"2025-03-17T19:11:06.000000Z","updated_at":"2025-03-17T19:11:06.000000Z","inspection_violations":[{"id":3718820,"change_date":"2023-02-21 21:42:00","inspection_id":"77907275","insp_violation_id":"251250165","seq_no":"1","part_no":"395","part_no_section":"8(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:30.000000Z","updated_at":"2025-03-17T21:24:30.000000Z","normalized_code":"3958A1"}],"inspection_per_units":[{"id":3887911,"change_date":"2023-02-21 21:42:00","inspection_id":"77907275","insp_unit_id":"193502526","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"24","insp_unit_license":"90886RP","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1XPBD48X7FD247313","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:50.000000Z","updated_at":"2025-03-17T22:33:50.000000Z"},{"id":3887912,"change_date":"2023-02-21 21:42:00","inspection_id":"77907275","insp_unit_id":"193502527","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"R78","insp_unit_license":"68982AH","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1UYVS2534H2997519","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:50.000000Z","updated_at":"2025-03-17T22:33:50.000000Z"}]},{"id":1415356,"change_date":"2022-10-05 21:40:00","inspection_id":"76760636","dot_number":"1827560","report_state":"ID","report_number":"3300003562","insp_date":"2022-09-29 00:00:00","insp_start_time":"0626","insp_end_time":"0812","registration_date":null,"region":"MT","ci_status_code":"C","location":"8420","location_desc":"I84MP20","county_code_state":"ID","county_code":"027","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"GATORADE-TOLLESON PLANT","shipping_paper_number":"10173593836","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-09-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"261313","transaction_code":"C","transaction_date":"2022-10-04 00:00:00","upload_date":"2022-10-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01827560","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-09-30 00:00:00","source_office":"4IDS001","mcmis_add_date":"2022-09-30 21:40:00","insp_carrier_name":"MID COLUMBIA CARRIERS LLC","insp_carrier_street":"3107 E MAIN ST","insp_carrier_city":"OTHELLO","insp_carrier_state":"WA","insp_carrier_zip_code":"99344","insp_colonia":null,"docket_number":"829551","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:52:43.000000Z","updated_at":"2025-03-17T18:52:43.000000Z","inspection_violations":[{"id":2230442,"change_date":"2022-10-05 21:40:00","inspection_id":"76760636","insp_violation_id":"248853966","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:17:14.000000Z","updated_at":"2025-03-17T21:17:14.000000Z","normalized_code":"3922"},{"id":2230443,"change_date":"2022-10-05 21:40:00","inspection_id":"76760636","insp_violation_id":"248853967","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:17:14.000000Z","updated_at":"2025-03-17T21:17:14.000000Z","normalized_code":"3958A1"}],"inspection_per_units":[{"id":2278473,"change_date":"2022-10-05 21:40:00","inspection_id":"76760636","insp_unit_id":"191288953","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"24A","insp_unit_license":"90886RP","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1XPBD48X7FD247313","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:35.000000Z","updated_at":"2025-03-17T22:22:35.000000Z"},{"id":2278474,"change_date":"2022-10-05 21:40:00","inspection_id":"76760636","insp_unit_id":"191288954","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"R24","insp_unit_license":"87315AB","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1UYVS2533FU252021","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:35.000000Z","updated_at":"2025-03-17T22:22:35.000000Z"}]},{"id":1218288,"change_date":"2022-09-06 21:42:00","inspection_id":"76531929","dot_number":"1827560","report_state":"AZ","report_number":"0203007876","insp_date":"2022-09-02 00:00:00","insp_start_time":"1115","insp_end_time":"1150","registration_date":null,"region":"MT","ci_status_code":"C","location":"I8","location_desc":"INTERSTATE 8","county_code_state":"AZ","county_code":"021","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"CWS","shipping_paper_number":"408119543","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":"N","gross_comb_veh_wt":"90001","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":"1768570","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":"01827560","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-09-06 00:00:00","source_office":"4AZS001","mcmis_add_date":"2022-09-06 21:42:00","insp_carrier_name":"MID COLUMBIA CARRIERS LLC","insp_carrier_street":"3107 E MAIN ST","insp_carrier_city":"OTHELLO","insp_carrier_state":"WA","insp_carrier_zip_code":"99344","insp_colonia":null,"docket_number":"829551","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:49:02.000000Z","updated_at":"2025-03-17T18:49:02.000000Z","inspection_violations":[{"id":1929813,"change_date":"2022-09-06 21:42:00","inspection_id":"76531929","insp_violation_id":"248228168","seq_no":"1","part_no":"395","part_no_section":"24(d)","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:15:54.000000Z","updated_at":"2025-03-17T21:15:54.000000Z","normalized_code":"39524D"},{"id":1929814,"change_date":"2022-09-06 21:42:00","inspection_id":"76531929","insp_violation_id":"248228169","seq_no":"2","part_no":"395","part_no_section":"26(b)","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:15:54.000000Z","updated_at":"2025-03-17T21:15:54.000000Z","normalized_code":"39526B"}],"inspection_per_units":[{"id":1960082,"change_date":"2022-09-06 21:42:00","inspection_id":"76531929","insp_unit_id":"190738183","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"0401","insp_unit_license":"90886RP","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1XPBD48X7FD247313","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:29.000000Z","updated_at":"2025-03-17T22:20:29.000000Z"},{"id":1960083,"change_date":"2022-09-06 21:42:00","inspection_id":"76531929","insp_unit_id":"190738184","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"87315AB","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1UYVS2533FU252021","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:29.000000Z","updated_at":"2025-03-17T22:20:29.000000Z"}]},{"id":753279,"change_date":"2022-07-06 21:41:00","inspection_id":"75989224","dot_number":"1827560","report_state":"TX","report_number":"6C5I9DJRJ8","insp_date":"2022-06-27 00:00:00","insp_start_time":"1757","insp_end_time":"1856","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0010 IN BEXAR CO. (545-596)","county_code_state":"TX","county_code":"029","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"GLACIER SALES","shipping_paper_number":"20282","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":"2022-07-05 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"118200","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8702415","transaction_code":"C","transaction_date":"2022-07-06 00:00:00","upload_date":"2022-07-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01827560","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-06-27 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-07-05 21:42:00","insp_carrier_name":"MID COLUMBIA CARRIERS LLC","insp_carrier_street":"3107 E MAIN ST","insp_carrier_city":"OTHELLO","insp_carrier_state":"WA","insp_carrier_zip_code":"99344","insp_colonia":null,"docket_number":"829551","insp_interstate":"Y","insp_carrier_state_id":"1016237","created_at":"2025-03-17T18:40:55.000000Z","updated_at":"2025-03-17T18:40:55.000000Z","inspection_violations":[{"id":1188339,"change_date":"2022-07-06 21:41:00","inspection_id":"75989224","insp_violation_id":"246927815","seq_no":"1","part_no":"393","part_no_section":"95(b)","insp_viol_unit":"1","insp_unit_id":"189636889","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:33.000000Z","updated_at":"2025-03-17T21:12:33.000000Z","normalized_code":"39395B"},{"id":1188340,"change_date":"2022-07-06 21:41:00","inspection_id":"75989224","insp_violation_id":"246927816","seq_no":"2","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:12:33.000000Z","updated_at":"2025-03-17T21:12:33.000000Z","normalized_code":"39260A"}],"inspection_per_units":[{"id":1211685,"change_date":"2022-07-06 21:41:00","inspection_id":"75989224","insp_unit_id":"189636889","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"776","insp_unit_license":"99592RP","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1XKYD49XXGJ114627","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:38.000000Z","updated_at":"2025-03-17T22:15:38.000000Z"},{"id":1211686,"change_date":"2022-07-06 21:41:00","inspection_id":"75989224","insp_unit_id":"189636890","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIM","insp_unit_company":null,"insp_unit_license":"A5244681","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1UYVS2534HM762543","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:38.000000Z","updated_at":"2025-03-17T22:15:38.000000Z"}]},{"id":606226,"change_date":"2022-06-14 21:42:00","inspection_id":"75815837","dot_number":"1827560","report_state":"OR","report_number":"AASP002661","insp_date":"2022-06-13 00:00:00","insp_start_time":"1724","insp_end_time":"1756","registration_date":null,"region":"PT","ci_status_code":"C","location":"3005","location_desc":"EMIGRANT HILL - 18 MI E PENDLE","county_code_state":"OR","county_code":"059","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"BIG CHUY DISTRIBUTORS & SONS","shipping_paper_number":"2002608547","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-06-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"46000","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":"1204725","transaction_code":"A","transaction_date":"2022-06-13 00:00:00","upload_date":"2022-06-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01827560","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-06-14 00:00:00","source_office":"4ORS001","mcmis_add_date":"2022-06-14 21:42:00","insp_carrier_name":"MID COLUMBIA CARRIERS LLC","insp_carrier_street":"3107 E MAIN ST","insp_carrier_city":"OTHELLO","insp_carrier_state":"WA","insp_carrier_zip_code":"99344","insp_colonia":null,"docket_number":"829551","insp_interstate":"Y","insp_carrier_state_id":"171658","created_at":"2025-03-17T18:38:25.000000Z","updated_at":"2025-03-17T18:38:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":974685,"change_date":"2022-06-14 21:42:00","inspection_id":"75815837","insp_unit_id":"189239489","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"24","insp_unit_license":"90886RP","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1XPBD48X7FD247313","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:11.000000Z","updated_at":"2025-03-17T22:14:11.000000Z"},{"id":974686,"change_date":"2022-06-14 21:42:00","inspection_id":"75815837","insp_unit_id":"189239490","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"R24","insp_unit_license":"87315AB","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":null,"insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:11.000000Z","updated_at":"2025-03-17T22:14:11.000000Z"}]},{"id":244871,"change_date":"2022-06-10 21:40:00","inspection_id":"75385062","dot_number":"1827560","report_state":"NV","report_number":"7221019123","insp_date":"2022-04-24 00:00:00","insp_start_time":"0835","insp_end_time":"0905","registration_date":"2022-06-10 00:00:00","region":"PT","ci_status_code":"C","location":"1","location_desc":"SR318","county_code_state":"NV","county_code":"017","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"THE PRODUCE EXCHANGE","shipping_paper_number":"338297","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"4","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"710099","transaction_code":"C","transaction_date":"2022-04-25 00:00:00","upload_date":"2022-06-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01827560","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-04-24 00:00:00","source_office":"4NVS001","mcmis_add_date":"2022-04-25 21:41:00","insp_carrier_name":"MID COLUMBIA CARRIERS LLC","insp_carrier_street":"3107 E MAIN ST","insp_carrier_city":"OTHELLO","insp_carrier_state":"WA","insp_carrier_zip_code":"99344","insp_colonia":null,"docket_number":"829551","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:31:52.000000Z","updated_at":"2025-03-17T18:31:52.000000Z","inspection_violations":[{"id":376720,"change_date":"2022-06-10 21:40:00","inspection_id":"75385062","insp_violation_id":"246376124","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"189179079","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:50.000000Z","updated_at":"2025-03-17T21:08:50.000000Z","normalized_code":"3963A1"},{"id":376721,"change_date":"2022-06-10 21:40:00","inspection_id":"75385062","insp_violation_id":"246376125","seq_no":"2","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"189179079","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:50.000000Z","updated_at":"2025-03-17T21:08:50.000000Z","normalized_code":"39395A"},{"id":376722,"change_date":"2022-06-10 21:40:00","inspection_id":"75385062","insp_violation_id":"246376126","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"189179080","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:08:50.000000Z","updated_at":"2025-03-17T21:08:50.000000Z","normalized_code":"3939A"},{"id":376723,"change_date":"2022-06-10 21:40:00","inspection_id":"75385062","insp_violation_id":"246376127","seq_no":"4","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"2","insp_unit_id":"189179080","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:08:50.000000Z","updated_at":"2025-03-17T21:08:50.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":397346,"change_date":"2022-06-10 21:40:00","inspection_id":"75385062","insp_unit_id":"189179079","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"26","insp_unit_license":"77209RP","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1XPBDP9X7GD336445","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:39.000000Z","updated_at":"2025-03-17T22:10:39.000000Z"},{"id":397347,"change_date":"2022-06-10 21:40:00","inspection_id":"75385062","insp_unit_id":"189179080","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"0974ZI","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1UYVS2537AU878504","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:39.000000Z","updated_at":"2025-03-17T22:10:39.000000Z"}]},{"id":122348,"change_date":"2022-04-06 21:41:00","inspection_id":"75237119","dot_number":"1827560","report_state":"WA","report_number":"W337000760","insp_date":"2022-04-05 00:00:00","insp_start_time":"1609","insp_end_time":"1745","registration_date":null,"region":"PT","ci_status_code":"C","location":null,"location_desc":"NORTH BOUND STATE ROUTE","county_code_state":"WA","county_code":"025","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"SUPERMERCADOS","shipping_paper_number":"1003777","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-04-06 21:41:00","post_acc_ind":"Y","gross_comb_veh_wt":"120350","viol_total":"13","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":"2485020","transaction_code":"A","transaction_date":"2022-04-05 00:00:00","upload_date":"2022-04-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01827560","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-04-06 00:00:00","source_office":"4WAS001","mcmis_add_date":"2022-04-06 21:41:00","insp_carrier_name":"MID COLUMBIA CARRIERS LLC","insp_carrier_street":"3107 E MAIN ST","insp_carrier_city":"OTHELLO","insp_carrier_state":"WA","insp_carrier_zip_code":"99344","insp_colonia":null,"docket_number":"829551","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:29:47.000000Z","updated_at":"2025-03-17T18:29:47.000000Z","inspection_violations":[{"id":181165,"change_date":"2022-04-06 21:41:00","inspection_id":"75237119","insp_violation_id":"245002260","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":"2A0261862","created_at":"2025-03-17T21:07:55.000000Z","updated_at":"2025-03-17T21:07:55.000000Z","normalized_code":"3922"},{"id":181166,"change_date":"2022-04-06 21:41:00","inspection_id":"75237119","insp_violation_id":"245002261","seq_no":"2","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":"3","citation_number":null,"created_at":"2025-03-17T21:07:55.000000Z","updated_at":"2025-03-17T21:07:55.000000Z","normalized_code":"3958E1"},{"id":181167,"change_date":"2022-04-06 21:41:00","inspection_id":"75237119","insp_violation_id":"245002262","seq_no":"3","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"188021443","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:55.000000Z","updated_at":"2025-03-17T21:07:55.000000Z","normalized_code":"39360C"},{"id":181168,"change_date":"2022-04-06 21:41:00","inspection_id":"75237119","insp_violation_id":"245002263","seq_no":"4","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"188021443","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:55.000000Z","updated_at":"2025-03-17T21:07:55.000000Z","normalized_code":"3965B"},{"id":181169,"change_date":"2022-04-06 21:41:00","inspection_id":"75237119","insp_violation_id":"245002264","seq_no":"5","part_no":"393","part_no_section":"201(a)","insp_viol_unit":"1","insp_unit_id":"188021443","insp_violation_category_id":"19","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:07:55.000000Z","updated_at":"2025-03-17T21:07:55.000000Z","normalized_code":"393201A"},{"id":181170,"change_date":"2022-04-06 21:41:00","inspection_id":"75237119","insp_violation_id":"245002265","seq_no":"6","part_no":"393","part_no_section":"203(e)","insp_viol_unit":"1","insp_unit_id":"188021443","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:55.000000Z","updated_at":"2025-03-17T21:07:55.000000Z","normalized_code":"393203E"},{"id":181171,"change_date":"2022-04-06 21:41:00","inspection_id":"75237119","insp_violation_id":"245002266","seq_no":"7","part_no":"393","part_no_section":"80","insp_viol_unit":"1","insp_unit_id":"188021443","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:55.000000Z","updated_at":"2025-03-17T21:07:55.000000Z","normalized_code":"39380"},{"id":181172,"change_date":"2022-04-06 21:41:00","inspection_id":"75237119","insp_violation_id":"245002267","seq_no":"8","part_no":"393","part_no_section":"83(h)","insp_viol_unit":"1","insp_unit_id":"188021443","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:55.000000Z","updated_at":"2025-03-17T21:07:55.000000Z","normalized_code":"39383H"},{"id":181173,"change_date":"2022-04-06 21:41:00","inspection_id":"75237119","insp_violation_id":"245002268","seq_no":"9","part_no":"393","part_no_section":"76","insp_viol_unit":"1","insp_unit_id":"188021443","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:55.000000Z","updated_at":"2025-03-17T21:07:55.000000Z","normalized_code":"39376"},{"id":181174,"change_date":"2022-04-06 21:41:00","inspection_id":"75237119","insp_violation_id":"245002269","seq_no":"10","part_no":"393","part_no_section":"203(a)","insp_viol_unit":"1","insp_unit_id":"188021443","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:55.000000Z","updated_at":"2025-03-17T21:07:55.000000Z","normalized_code":"393203A"},{"id":181175,"change_date":"2022-04-06 21:41:00","inspection_id":"75237119","insp_violation_id":"245002270","seq_no":"11","part_no":"393","part_no_section":"203(c)","insp_viol_unit":"1","insp_unit_id":"188021443","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:55.000000Z","updated_at":"2025-03-17T21:07:55.000000Z","normalized_code":"393203C"},{"id":181176,"change_date":"2022-04-06 21:41:00","inspection_id":"75237119","insp_violation_id":"245002271","seq_no":"12","part_no":"393","part_no_section":"201(c)","insp_viol_unit":"2","insp_unit_id":"188021444","insp_violation_category_id":"19","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:07:55.000000Z","updated_at":"2025-03-17T21:07:55.000000Z","normalized_code":"393201C"},{"id":181177,"change_date":"2022-04-06 21:41:00","inspection_id":"75237119","insp_violation_id":"245002272","seq_no":"13","part_no":"393","part_no_section":"104(a)","insp_viol_unit":"2","insp_unit_id":"188021444","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:55.000000Z","updated_at":"2025-03-17T21:07:55.000000Z","normalized_code":"393104A"}],"inspection_per_units":[{"id":198221,"change_date":"2022-04-06 21:41:00","inspection_id":"75237119","insp_unit_id":"188021443","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"744","insp_unit_license":"98891RP","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1XPBDP9X5GD336444","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:24.000000Z","updated_at":"2025-03-17T22:09:24.000000Z"},{"id":198222,"change_date":"2022-04-06 21:41:00","inspection_id":"75237119","insp_unit_id":"188021444","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"R16","insp_unit_license":"01660AC","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1UYVS2537CU302351","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:24.000000Z","updated_at":"2025-03-17T22:09:24.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1827560\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1827560\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1827560\/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\/1827560\/inspections","per_page":100,"prev_page_url":null,"to":19,"total":19}