{"current_page":1,"data":[{"id":6754326,"change_date":"2024-09-18 21:42:00","inspection_id":"82689252","dot_number":"3901739","report_state":"WA","report_number":"2127000664","insp_date":"2024-09-16 00:00:00","insp_start_time":"0956","insp_end_time":"1034","registration_date":null,"region":"PD","ci_status_code":"C","location":"SC53","location_desc":"CLE ELUM WA","county_code_state":"WA","county_code":"037","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SUNRAY FARMS","shipping_paper_number":"062260","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-09-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"136000","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":"858663","transaction_code":"A","transaction_date":"2024-09-18 00:00:00","upload_date":"2024-09-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03901739","upload_search_indicator":null,"census_search_date":"2024-09-18 21:42:00","snet_input_date":"2024-09-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-09-18 21:42:00","insp_carrier_name":"J MEDELEZ LLC","insp_carrier_street":"1300 E PUNKIN CENTER RD","insp_carrier_city":"HERMISTON","insp_carrier_state":"OR","insp_carrier_zip_code":"97838","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:36:57.000000Z","updated_at":"2025-03-17T20:36:57.000000Z","inspection_violations":[{"id":10518305,"change_date":"2024-09-18 21:42:00","inspection_id":"82689252","insp_violation_id":"261887713","seq_no":"1","part_no":"391","part_no_section":"11(b)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"54","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:54.000000Z","updated_at":"2025-03-17T21:56:54.000000Z","normalized_code":"39111B2"},{"id":10518306,"change_date":"2024-09-18 21:42:00","inspection_id":"82689252","insp_violation_id":"261887714","seq_no":"2","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"202998253","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:54.000000Z","updated_at":"2025-03-17T21:56:54.000000Z","normalized_code":"39360C"},{"id":10518307,"change_date":"2024-09-18 21:42:00","inspection_id":"82689252","insp_violation_id":"261887715","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"3","insp_unit_id":"202998255","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:54.000000Z","updated_at":"2025-03-17T21:56:54.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":10891517,"change_date":"2024-09-18 21:42:00","inspection_id":"82689252","insp_unit_id":"202998253","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"109","insp_unit_license":"YAKG277","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XP5DB9X3SD360637","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:48.000000Z","updated_at":"2025-03-17T23:35:48.000000Z"},{"id":10891518,"change_date":"2024-09-18 21:42:00","inspection_id":"82689252","insp_unit_id":"202998254","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"PINES TRAI","insp_unit_company":"306","insp_unit_license":"67606AK","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1PND281S7EK015169","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:48.000000Z","updated_at":"2025-03-17T23:35:48.000000Z"},{"id":10891519,"change_date":"2024-09-18 21:42:00","inspection_id":"82689252","insp_unit_id":"202998255","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"PINES TRAI","insp_unit_company":"307","insp_unit_license":"67305AK","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1PND281S3FK016563","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:48.000000Z","updated_at":"2025-03-17T23:35:48.000000Z"}]},{"id":5230092,"change_date":"2024-03-07 21:38:00","inspection_id":"81044062","dot_number":"3901739","report_state":"WA","report_number":"2110005993","insp_date":"2024-03-06 00:00:00","insp_start_time":"0630","insp_end_time":"0735","registration_date":null,"region":"PS","ci_status_code":"C","location":"SC55","location_desc":"PASCO WA","county_code_state":"WA","county_code":"021","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CAMPBELL SNACKS","shipping_paper_number":"4506333497","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-03-07 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","viol_total":"8","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":"299057","transaction_code":"A","transaction_date":"2024-03-06 00:00:00","upload_date":"2024-03-06 00:00:00","upload_first_byte":"0","upload_dot_number":"03901739","upload_search_indicator":null,"census_search_date":"2024-03-07 21:38:00","snet_input_date":"2024-03-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-03-07 21:38:00","insp_carrier_name":"J MEDELEZ LLC","insp_carrier_street":"1300 E PUNKIN CENTER RD","insp_carrier_city":"HERMISTON","insp_carrier_state":"OR","insp_carrier_zip_code":"97838","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:06:13.000000Z","updated_at":"2025-03-17T20:06:13.000000Z","inspection_violations":[{"id":8064352,"change_date":"2024-03-07 21:38:00","inspection_id":"81044062","insp_violation_id":"258251617","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":"4A0262743","created_at":"2025-03-17T21:44:59.000000Z","updated_at":"2025-03-17T21:44:59.000000Z","normalized_code":"3922"},{"id":8064353,"change_date":"2024-03-07 21:38:00","inspection_id":"81044062","insp_violation_id":"258251618","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"199795196","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:59.000000Z","updated_at":"2025-03-17T21:44:59.000000Z","normalized_code":"3922SLLSR"},{"id":8064354,"change_date":"2024-03-07 21:38:00","inspection_id":"81044062","insp_violation_id":"258251619","seq_no":"3","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"199795196","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:59.000000Z","updated_at":"2025-03-17T21:44:59.000000Z","normalized_code":"39360C"},{"id":8064355,"change_date":"2024-03-07 21:38:00","inspection_id":"81044062","insp_violation_id":"258251620","seq_no":"4","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"2","insp_unit_id":"199795197","insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:44:59.000000Z","updated_at":"2025-03-17T21:44:59.000000Z","normalized_code":"39375A3TAOL"},{"id":8064356,"change_date":"2024-03-07 21:38:00","inspection_id":"81044062","insp_violation_id":"258251621","seq_no":"5","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"199795196","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:59.000000Z","updated_at":"2025-03-17T21:44:59.000000Z","normalized_code":"39395A4EEUS"},{"id":8064357,"change_date":"2024-03-07 21:38:00","inspection_id":"81044062","insp_violation_id":"258251622","seq_no":"6","part_no":"393","part_no_section":"9A-LHWS","insp_viol_unit":"1","insp_unit_id":"199795196","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:59.000000Z","updated_at":"2025-03-17T21:44:59.000000Z","normalized_code":"3939ALHWS"},{"id":8064358,"change_date":"2024-03-07 21:38:00","inspection_id":"81044062","insp_violation_id":"258251623","seq_no":"7","part_no":"393","part_no_section":"9A-LSLI","insp_viol_unit":"1","insp_unit_id":"199795196","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:59.000000Z","updated_at":"2025-03-17T21:44:59.000000Z","normalized_code":"3939ALSLI"},{"id":8064359,"change_date":"2024-03-07 21:38:00","inspection_id":"81044062","insp_violation_id":"258251624","seq_no":"8","part_no":"393","part_no_section":"9A-LTSIR","insp_viol_unit":"1","insp_unit_id":"199795196","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:59.000000Z","updated_at":"2025-03-17T21:44:59.000000Z","normalized_code":"3939ALTSIR"}],"inspection_per_units":[{"id":8421957,"change_date":"2024-03-07 21:38:00","inspection_id":"81044062","insp_unit_id":"199795196","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"104","insp_unit_license":"YAKG272","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XKYD49X3KJ220278","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:19.000000Z","updated_at":"2025-03-17T23:11:19.000000Z"},{"id":8421958,"change_date":"2024-03-07 21:38:00","inspection_id":"81044062","insp_unit_id":"199795197","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRINITY PR","insp_unit_company":"204","insp_unit_license":"HV67185","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1T9SC5341MB656188","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:19.000000Z","updated_at":"2025-03-17T23:11:19.000000Z"}]},{"id":4804270,"change_date":"2024-01-10 21:44:00","inspection_id":"80579238","dot_number":"3901739","report_state":"OR","report_number":"AADG010298","insp_date":"2024-01-09 00:00:00","insp_start_time":"0716","insp_end_time":"0735","registration_date":null,"region":"PT","ci_status_code":"C","location":"3006","location_desc":"UMATILLA POE","county_code_state":"OR","county_code":"059","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"LAMBWESTON","shipping_paper_number":"640-210698","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":"2024-01-10 21:44: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":"1240494","transaction_code":"A","transaction_date":"2024-01-09 00:00:00","upload_date":"2024-01-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03901739","upload_search_indicator":null,"census_search_date":"2024-01-10 21:44:00","snet_input_date":"2024-01-10 00:00:00","source_office":"4ORS001","mcmis_add_date":"2024-01-10 21:44:00","insp_carrier_name":"J MEDELEZ LLC","insp_carrier_street":"1300 E PUNKIN CENTER RD","insp_carrier_city":"HERMISTON","insp_carrier_state":"OR","insp_carrier_zip_code":"97838-7700","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"007063","created_at":"2025-03-17T19:58:00.000000Z","updated_at":"2025-03-17T19:58:00.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7729831,"change_date":"2024-01-10 21:44:00","inspection_id":"80579238","insp_unit_id":"198901539","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"10","insp_unit_license":"YAJZ824","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XPHD49X5ED217430","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:04.000000Z","updated_at":"2025-03-17T23:05:04.000000Z"},{"id":7729832,"change_date":"2024-01-10 21:44:00","inspection_id":"80579238","insp_unit_id":"198901540","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRIN","insp_unit_company":"45","insp_unit_license":"HU93046","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":null,"insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:04.000000Z","updated_at":"2025-03-17T23:05:04.000000Z"}]},{"id":4804278,"change_date":"2024-01-10 21:44:00","inspection_id":"80579246","dot_number":"3901739","report_state":"OR","report_number":"AADH004686","insp_date":"2024-01-09 00:00:00","insp_start_time":"0745","insp_end_time":"0844","registration_date":null,"region":"PT","ci_status_code":"C","location":"3006","location_desc":"UMATILLA POE","county_code_state":"OR","county_code":"059","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"LAMBWESTON","shipping_paper_number":"640210699","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":"2024-01-10 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"55200","viol_total":"6","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1240614","transaction_code":"A","transaction_date":"2024-01-09 00:00:00","upload_date":"2024-01-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03901739","upload_search_indicator":null,"census_search_date":"2024-01-10 21:44:00","snet_input_date":"2024-01-10 00:00:00","source_office":"4ORS001","mcmis_add_date":"2024-01-10 21:44:00","insp_carrier_name":"MEDELEZ, J LLC","insp_carrier_street":"1300 E PUNKIN CENTER RD","insp_carrier_city":"HERMISTON","insp_carrier_state":"OR","insp_carrier_zip_code":"97838","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"007063","created_at":"2025-03-17T19:58:00.000000Z","updated_at":"2025-03-17T19:58:00.000000Z","inspection_violations":[{"id":7410319,"change_date":"2024-01-10 21:44:00","inspection_id":"80579246","insp_violation_id":"257276663","seq_no":"6","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"198901556","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:46.000000Z","updated_at":"2025-03-17T21:41:46.000000Z","normalized_code":"39353B"},{"id":7410320,"change_date":"2024-01-10 21:44:00","inspection_id":"80579246","insp_violation_id":"257276664","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"198901556","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:41:46.000000Z","updated_at":"2025-03-17T21:41:46.000000Z","normalized_code":"39375A3"},{"id":7410321,"change_date":"2024-01-10 21:44:00","inspection_id":"80579246","insp_violation_id":"257276665","seq_no":"2","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"198901556","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:46.000000Z","updated_at":"2025-03-17T21:41:46.000000Z","normalized_code":"39355E"},{"id":7410322,"change_date":"2024-01-10 21:44:00","inspection_id":"80579246","insp_violation_id":"257276666","seq_no":"3","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"2","insp_unit_id":"198901556","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:41:46.000000Z","updated_at":"2025-03-17T21:41:46.000000Z","normalized_code":"393207A"},{"id":7410323,"change_date":"2024-01-10 21:44:00","inspection_id":"80579246","insp_violation_id":"257276667","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"198901556","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:46.000000Z","updated_at":"2025-03-17T21:41:46.000000Z","normalized_code":"3963A1"},{"id":7410324,"change_date":"2024-01-10 21:44:00","inspection_id":"80579246","insp_violation_id":"257276668","seq_no":"5","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"198901556","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:46.000000Z","updated_at":"2025-03-17T21:41:46.000000Z","normalized_code":"39347E"}],"inspection_per_units":[{"id":7729847,"change_date":"2024-01-10 21:44:00","inspection_id":"80579246","insp_unit_id":"198901555","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"46","insp_unit_license":"YAKC519","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XKYP49X9JJ198762","insp_unit_decal":"Y","insp_unit_decal_number":"33703451","created_at":"2025-03-17T23:05:04.000000Z","updated_at":"2025-03-17T23:05:04.000000Z"},{"id":7729848,"change_date":"2024-01-10 21:44:00","inspection_id":"80579246","insp_unit_id":"198901556","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRIN","insp_unit_company":"55","insp_unit_license":"HV36082","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":null,"insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:04.000000Z","updated_at":"2025-03-17T23:05:04.000000Z"}]},{"id":4706364,"change_date":"2023-12-27 21:41:00","inspection_id":"80472437","dot_number":"3901739","report_state":"WA","report_number":"X843000072","insp_date":"2023-12-26 00:00:00","insp_start_time":"1225","insp_end_time":"1340","registration_date":null,"region":"PS","ci_status_code":"C","location":null,"location_desc":"WALLULA WA","county_code_state":"WA","county_code":"077","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CORIA AND SONS LLC","shipping_paper_number":"31439","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":"2023-12-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52500","viol_total":"7","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":"145787","transaction_code":"A","transaction_date":"2023-12-27 00:00:00","upload_date":"2023-12-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03901739","upload_search_indicator":null,"census_search_date":"2023-12-27 21:41:00","snet_input_date":"2023-12-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-12-27 21:41:00","insp_carrier_name":"J MEDELEZ LLC","insp_carrier_street":"1300 E PUNKIN CENTER RD","insp_carrier_city":"HERMISTON","insp_carrier_state":"OR","insp_carrier_zip_code":"97838","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:56:09.000000Z","updated_at":"2025-03-17T19:56:09.000000Z","inspection_violations":[{"id":7268305,"change_date":"2023-12-27 21:41:00","inspection_id":"80472437","insp_violation_id":"257056012","seq_no":"2","part_no":"393","part_no_section":"11A1-CSURR","insp_viol_unit":"1","insp_unit_id":"198672545","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:07.000000Z","updated_at":"2025-03-17T21:41:07.000000Z","normalized_code":"39311A1CSURR"},{"id":7268306,"change_date":"2023-12-27 21:41:00","inspection_id":"80472437","insp_violation_id":"257056013","seq_no":"3","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"198672545","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:07.000000Z","updated_at":"2025-03-17T21:41:07.000000Z","normalized_code":"39617CPI"},{"id":7268307,"change_date":"2023-12-27 21:41:00","inspection_id":"80472437","insp_violation_id":"257056014","seq_no":"4","part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"1","insp_unit_id":"198672545","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:07.000000Z","updated_at":"2025-03-17T21:41:07.000000Z","normalized_code":"3939ALRLI"},{"id":7268308,"change_date":"2023-12-27 21:41:00","inspection_id":"80472437","insp_violation_id":"257056015","seq_no":"5","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"198672546","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:07.000000Z","updated_at":"2025-03-17T21:41:07.000000Z","normalized_code":"39617CPI"},{"id":7268309,"change_date":"2023-12-27 21:41:00","inspection_id":"80472437","insp_violation_id":"257056016","seq_no":"6","part_no":"392","part_no_section":"2-SLLIRP","insp_viol_unit":"1","insp_unit_id":"198672545","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:07.000000Z","updated_at":"2025-03-17T21:41:07.000000Z","normalized_code":"3922SLLIRP"},{"id":7268310,"change_date":"2023-12-27 21:41:00","inspection_id":"80472437","insp_violation_id":"257056017","seq_no":"7","part_no":"392","part_no_section":"16-D","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"3A0554094","created_at":"2025-03-17T21:41:07.000000Z","updated_at":"2025-03-17T21:41:07.000000Z","normalized_code":"39216D"},{"id":7268311,"change_date":"2023-12-27 21:41:00","inspection_id":"80472437","insp_violation_id":"257056018","seq_no":"1","part_no":"393","part_no_section":"9B-LIL","insp_viol_unit":"2","insp_unit_id":"198672546","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:07.000000Z","updated_at":"2025-03-17T21:41:07.000000Z","normalized_code":"3939BLIL"}],"inspection_per_units":[{"id":7569974,"change_date":"2023-12-27 21:41:00","inspection_id":"80472437","insp_unit_id":"198672545","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WESTERN ST","insp_unit_company":null,"insp_unit_license":"YAIZ029","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"5KJNALD1XGPHP6733","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:39.000000Z","updated_at":"2025-03-17T23:03:39.000000Z"},{"id":7569975,"change_date":"2023-12-27 21:41:00","inspection_id":"80472437","insp_unit_id":"198672546","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRINITY PR","insp_unit_company":null,"insp_unit_license":"HU82077","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1T9SC5346EB656253","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:39.000000Z","updated_at":"2025-03-17T23:03:39.000000Z"}]},{"id":4691146,"change_date":"2023-12-22 21:40:00","inspection_id":"80455818","dot_number":"3901739","report_state":"WA","report_number":"0813000095","insp_date":"2023-12-20 00:00:00","insp_start_time":"1200","insp_end_time":"1230","registration_date":null,"region":"PS","ci_status_code":"C","location":null,"location_desc":"PASCO WA","county_code_state":"WA","county_code":"021","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"122023","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":"2023-12-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"23996","viol_total":"4","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"141632","transaction_code":"A","transaction_date":"2023-12-22 00:00:00","upload_date":"2023-12-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03901739","upload_search_indicator":null,"census_search_date":"2023-12-22 21:40:00","snet_input_date":"2023-12-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-12-22 21:40:00","insp_carrier_name":"J MEDELEZ LLC","insp_carrier_street":"1300 E PUNKIN CENTER RD","insp_carrier_city":"HERMISTON","insp_carrier_state":"OR","insp_carrier_zip_code":"97838","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:55:47.000000Z","updated_at":"2025-03-17T19:55:47.000000Z","inspection_violations":[{"id":7249748,"change_date":"2023-12-22 21:40:00","inspection_id":"80455818","insp_violation_id":"257027047","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"198636235","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:01.000000Z","updated_at":"2025-03-17T21:41:01.000000Z","normalized_code":"3922SLLSR"},{"id":7249749,"change_date":"2023-12-22 21:40:00","inspection_id":"80455818","insp_violation_id":"257027048","seq_no":"2","part_no":"393","part_no_section":"43DBMA","insp_viol_unit":"2","insp_unit_id":"198636236","insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:41:01.000000Z","updated_at":"2025-03-17T21:41:01.000000Z","normalized_code":"39343DBMA"},{"id":7249750,"change_date":"2023-12-22 21:40:00","inspection_id":"80455818","insp_violation_id":"257027049","seq_no":"3","part_no":"393","part_no_section":"23-LEU","insp_viol_unit":"2","insp_unit_id":"198636236","insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:41:01.000000Z","updated_at":"2025-03-17T21:41:01.000000Z","normalized_code":"39323LEU"},{"id":7249751,"change_date":"2023-12-22 21:40:00","inspection_id":"80455818","insp_violation_id":"257027050","seq_no":"4","part_no":"392","part_no_section":"2-SLL","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:41:01.000000Z","updated_at":"2025-03-17T21:41:01.000000Z","normalized_code":"3922SLL"}],"inspection_per_units":[{"id":7545496,"change_date":"2023-12-22 21:40:00","inspection_id":"80455818","insp_unit_id":"198636235","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"967KMJ","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1FT7W2BT5JEB42736","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:28.000000Z","updated_at":"2025-03-17T23:03:28.000000Z"},{"id":7545497,"change_date":"2023-12-22 21:40:00","inspection_id":"80455818","insp_unit_id":"198636236","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"82835AB","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"50HDT1622J1020297","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:28.000000Z","updated_at":"2025-03-17T23:03:28.000000Z"}]},{"id":4602643,"change_date":"2023-12-11 21:41:00","inspection_id":"80358842","dot_number":"3901739","report_state":"OR","report_number":"AADG010277","insp_date":"2023-12-11 00:00:00","insp_start_time":"1138","insp_end_time":"1152","registration_date":null,"region":"PT","ci_status_code":"C","location":"3006","location_desc":"UMATILLA POE","county_code_state":"OR","county_code":"059","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"AMALGAMATED SUGAR CO","shipping_paper_number":"1929","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-12-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"1238988","transaction_code":"A","transaction_date":"2023-12-11 00:00:00","upload_date":"2023-12-11 00:00:00","upload_first_byte":"0","upload_dot_number":"03901739","upload_search_indicator":null,"census_search_date":"2023-12-11 21:41:00","snet_input_date":"2023-12-11 00:00:00","source_office":"4ORS001","mcmis_add_date":"2023-12-11 21:41:00","insp_carrier_name":"J MEDELEZ LLC","insp_carrier_street":"1300 E PUNKIN CENTER RD","insp_carrier_city":"HERMISTON","insp_carrier_state":"OR","insp_carrier_zip_code":"97838-7700","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"007063","created_at":"2025-03-17T19:54:09.000000Z","updated_at":"2025-03-17T19:54:09.000000Z","inspection_violations":[{"id":7116313,"change_date":"2023-12-11 21:41:00","inspection_id":"80358842","insp_violation_id":"256819164","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"198447036","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:40:21.000000Z","updated_at":"2025-03-17T21:40:21.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":7402964,"change_date":"2023-12-11 21:41:00","inspection_id":"80358842","insp_unit_id":"198447035","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRIN","insp_unit_company":"53","insp_unit_license":"HV46989","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":null,"insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:13.000000Z","updated_at":"2025-03-17T23:02:13.000000Z"},{"id":7402965,"change_date":"2023-12-11 21:41:00","inspection_id":"80358842","insp_unit_id":"198447036","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"10","insp_unit_license":"YAJZ824","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XPHD49X5ED217430","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:13.000000Z","updated_at":"2025-03-17T23:02:13.000000Z"}]},{"id":4500114,"change_date":"2023-11-27 21:42:00","inspection_id":"80246011","dot_number":"3901739","report_state":"CA","report_number":"ND4O004005","insp_date":"2023-11-21 00:00:00","insp_start_time":"1851","insp_end_time":"1932","registration_date":null,"region":"PT","ci_status_code":"C","location":"656","location_desc":"DESERT HILLS IF","county_code_state":"CA","county_code":"065","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"TANIMURA & ANTLE\/PETER RABBIT","shipping_paper_number":"174788\/SO218418","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-27 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","viol_total":"3","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15145053","transaction_code":"A","transaction_date":"2023-11-23 00:00:00","upload_date":"2023-11-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03901739","upload_search_indicator":null,"census_search_date":"2023-11-27 21:42:00","snet_input_date":"2023-11-21 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-11-27 21:42:00","insp_carrier_name":"J MEDELEZ LLC","insp_carrier_street":"1300 E PUNKIN CENTER RD","insp_carrier_city":"HERMISTON","insp_carrier_state":"OR","insp_carrier_zip_code":"97838","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:52:09.000000Z","updated_at":"2025-03-17T19:52:09.000000Z","inspection_violations":[{"id":6966435,"change_date":"2023-11-27 21:42:00","inspection_id":"80246011","insp_violation_id":"256580089","seq_no":"1","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"KK97472","created_at":"2025-03-17T21:39:38.000000Z","updated_at":"2025-03-17T21:39:38.000000Z","normalized_code":"39141A"},{"id":6966436,"change_date":"2023-11-27 21:42:00","inspection_id":"80246011","insp_violation_id":"256580090","seq_no":"2","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"198226637","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:38.000000Z","updated_at":"2025-03-17T21:39:38.000000Z","normalized_code":"39360C"},{"id":6966437,"change_date":"2023-11-27 21:42:00","inspection_id":"80246011","insp_violation_id":"256580091","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"198226638","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:38.000000Z","updated_at":"2025-03-17T21:39:38.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":7237721,"change_date":"2023-11-27 21:42:00","inspection_id":"80246011","insp_unit_id":"198226637","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"27\/BROWN","insp_unit_license":"YAJH182","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XPXD49X4MD710591","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:47.000000Z","updated_at":"2025-03-17T23:00:47.000000Z"},{"id":7237722,"change_date":"2023-11-27 21:42:00","inspection_id":"80246011","insp_unit_id":"198226638","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"326\/WHITE","insp_unit_license":"HV65906","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"3H3V532C7KT295042","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:47.000000Z","updated_at":"2025-03-17T23:00:47.000000Z"}]},{"id":4324415,"change_date":"2023-12-08 21:41:00","inspection_id":"80052240","dot_number":"3901739","report_state":"OR","report_number":"AAYK003819","insp_date":"2023-10-30 00:00:00","insp_start_time":"1946","insp_end_time":"2021","registration_date":"2023-12-08 00:00:00","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":"2","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"RIGBY PRODUCE, INC","shipping_paper_number":"129897","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-10-31 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"55200","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":"1236684","transaction_code":"C","transaction_date":"2023-10-30 00:00:00","upload_date":"2023-12-08 00:00:00","upload_first_byte":"0","upload_dot_number":"03901739","upload_search_indicator":null,"census_search_date":"2023-10-31 21:40:00","snet_input_date":"2023-10-31 00:00:00","source_office":"4ORS001","mcmis_add_date":"2023-10-31 21:40:00","insp_carrier_name":"J MEDELEZ LLC","insp_carrier_street":"1300 E PUNKIN CENTER RD","insp_carrier_city":"HERMISTON","insp_carrier_state":"OR","insp_carrier_zip_code":"97838-7700","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"007063","created_at":"2025-03-17T19:48:42.000000Z","updated_at":"2025-03-17T19:48:42.000000Z","inspection_violations":[{"id":6688084,"change_date":"2023-12-08 21:41:00","inspection_id":"80052240","insp_violation_id":"256795733","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"198424055","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:38:12.000000Z","updated_at":"2025-03-17T21:38:12.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":6954851,"change_date":"2023-12-08 21:41:00","inspection_id":"80052240","insp_unit_id":"198424055","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"05","insp_unit_license":"YAJX908","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XKYP49X1JJ198769","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:21.000000Z","updated_at":"2025-03-17T22:58:21.000000Z"},{"id":6954852,"change_date":"2023-12-08 21:41:00","inspection_id":"80052240","insp_unit_id":"198424056","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRIN","insp_unit_company":"28","insp_unit_license":"HV84762","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":null,"insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:21.000000Z","updated_at":"2025-03-17T22:58:21.000000Z"}]},{"id":4263406,"change_date":"2023-10-23 21:42:00","inspection_id":"79984751","dot_number":"3901739","report_state":"WA","report_number":"W303009335","insp_date":"2023-10-22 00:00:00","insp_start_time":"0900","insp_end_time":"0925","registration_date":null,"region":"PT","ci_status_code":"C","location":"SC40","location_desc":"SC40  GRANDVIEW","county_code_state":"WA","county_code":"005","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-10-23 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"119000","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":"2599112","transaction_code":"A","transaction_date":"2023-10-22 00:00:00","upload_date":"2023-10-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03901739","upload_search_indicator":null,"census_search_date":"2023-10-23 21:42:00","snet_input_date":"2023-10-23 00:00:00","source_office":"4WAS001","mcmis_add_date":"2023-10-23 21:42:00","insp_carrier_name":"J MEDELEZ LLC","insp_carrier_street":"1300 E PUNKIN CENTER RD","insp_carrier_city":"HERMISTON","insp_carrier_state":"OR","insp_carrier_zip_code":"97838-7700","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:47:25.000000Z","updated_at":"2025-03-17T19:47:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6856737,"change_date":"2023-10-23 21:42:00","inspection_id":"79984751","insp_unit_id":"197701385","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WAGN","insp_unit_company":null,"insp_unit_license":"YAIZ012","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"5KJNALD14EPFT7126","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:29.000000Z","updated_at":"2025-03-17T22:57:29.000000Z"},{"id":6856738,"change_date":"2023-10-23 21:42:00","inspection_id":"79984751","insp_unit_id":"197701386","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WESE","insp_unit_company":null,"insp_unit_license":"HU63086","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"5DN155346CB00068","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:29.000000Z","updated_at":"2025-03-17T22:57:29.000000Z"}]},{"id":4238466,"change_date":"2023-10-19 21:41:00","inspection_id":"79957032","dot_number":"3901739","report_state":"WA","report_number":"W341001622","insp_date":"2023-10-18 00:00:00","insp_start_time":"1200","insp_end_time":"1420","registration_date":null,"region":"PT","ci_status_code":"C","location":"33999","location_desc":"EAST BOUND","county_code_state":"WA","county_code":"077","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"VANDYKE & CEDERGREEN FOODS","shipping_paper_number":"060500","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-10-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","viol_total":"8","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"6","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2598515","transaction_code":"A","transaction_date":"2023-10-18 00:00:00","upload_date":"2023-10-19 00:00:00","upload_first_byte":"0","upload_dot_number":"03901739","upload_search_indicator":null,"census_search_date":"2023-10-19 21:41:00","snet_input_date":"2023-10-19 00:00:00","source_office":"4WAS001","mcmis_add_date":"2023-10-19 21:41:00","insp_carrier_name":"J MEDELEZ LLC","insp_carrier_street":"1300 E PUNKIN CENTER RD","insp_carrier_city":"HERMISTON","insp_carrier_state":"OR","insp_carrier_zip_code":"97838-7700","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:46:40.000000Z","updated_at":"2025-03-17T19:46:40.000000Z","inspection_violations":[{"id":6563448,"change_date":"2023-10-19 21:41:00","inspection_id":"79957032","insp_violation_id":"255941358","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":"3A0736536","created_at":"2025-03-17T21:37:39.000000Z","updated_at":"2025-03-17T21:37:39.000000Z","normalized_code":"3922"},{"id":6563449,"change_date":"2023-10-19 21:41:00","inspection_id":"79957032","insp_violation_id":"255941359","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"197648565","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:39.000000Z","updated_at":"2025-03-17T21:37:39.000000Z","normalized_code":"3939A"},{"id":6563450,"change_date":"2023-10-19 21:41:00","inspection_id":"79957032","insp_violation_id":"255941360","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"197648565","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:39.000000Z","updated_at":"2025-03-17T21:37:39.000000Z","normalized_code":"3939A"},{"id":6563451,"change_date":"2023-10-19 21:41:00","inspection_id":"79957032","insp_violation_id":"255941361","seq_no":"4","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"197648564","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:39.000000Z","updated_at":"2025-03-17T21:37:39.000000Z","normalized_code":"39311"},{"id":6563452,"change_date":"2023-10-19 21:41:00","inspection_id":"79957032","insp_violation_id":"255941362","seq_no":"5","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"197648564","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:39.000000Z","updated_at":"2025-03-17T21:37:39.000000Z","normalized_code":"39395A"},{"id":6563453,"change_date":"2023-10-19 21:41:00","inspection_id":"79957032","insp_violation_id":"255941363","seq_no":"6","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197648564","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:39.000000Z","updated_at":"2025-03-17T21:37:39.000000Z","normalized_code":"3922"},{"id":6563454,"change_date":"2023-10-19 21:41:00","inspection_id":"79957032","insp_violation_id":"255941364","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197648564","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:39.000000Z","updated_at":"2025-03-17T21:37:39.000000Z","normalized_code":"3939A"},{"id":6563455,"change_date":"2023-10-19 21:41:00","inspection_id":"79957032","insp_violation_id":"255941365","seq_no":"8","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"3A0736536","created_at":"2025-03-17T21:37:39.000000Z","updated_at":"2025-03-17T21:37:39.000000Z","normalized_code":"38323A2"}],"inspection_per_units":[{"id":6816640,"change_date":"2023-10-19 21:41:00","inspection_id":"79957032","insp_unit_id":"197648564","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"15","insp_unit_license":"YAIY795","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XP5DB9X06D875259","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:09.000000Z","updated_at":"2025-03-17T22:57:09.000000Z"},{"id":6816641,"change_date":"2023-10-19 21:41:00","inspection_id":"79957032","insp_unit_id":"197648565","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNK","insp_unit_company":"62","insp_unit_license":"5311MK","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1PND281S3EK014651","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:09.000000Z","updated_at":"2025-03-17T22:57:09.000000Z"},{"id":6816642,"change_date":"2023-10-19 21:41:00","inspection_id":"79957032","insp_unit_id":"197648566","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"UNK","insp_unit_company":"61","insp_unit_license":"5312MK","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1PND281SXEK014341","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:09.000000Z","updated_at":"2025-03-17T22:57:09.000000Z"}]},{"id":4174826,"change_date":"2023-10-11 21:41:00","inspection_id":"79886810","dot_number":"3901739","report_state":"WA","report_number":"W541000900","insp_date":"2023-10-06 00:00:00","insp_start_time":"1421","insp_end_time":"1510","registration_date":null,"region":"PT","ci_status_code":"C","location":"SC72","location_desc":"SC72   RIDGEFIELD (POE)","county_code_state":"WA","county_code":"011","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"KROGER","shipping_paper_number":"201556","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-10-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117500","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":"2596719","transaction_code":"A","transaction_date":"2023-10-06 00:00:00","upload_date":"2023-10-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03901739","upload_search_indicator":null,"census_search_date":"2023-10-11 21:41:00","snet_input_date":"2023-10-10 00:00:00","source_office":"4WAS001","mcmis_add_date":"2023-10-11 21:41:00","insp_carrier_name":"J MEDELEZ LLC","insp_carrier_street":"1300 E PUNKIN CENTER RD","insp_carrier_city":"HERMISTON","insp_carrier_state":"OR","insp_carrier_zip_code":"97838-7700","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:45:30.000000Z","updated_at":"2025-03-17T19:45:30.000000Z","inspection_violations":[{"id":6462719,"change_date":"2023-10-11 21:41:00","inspection_id":"79886810","insp_violation_id":"255776689","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"197504536","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:11.000000Z","updated_at":"2025-03-17T21:37:11.000000Z","normalized_code":"39378"},{"id":6462720,"change_date":"2023-10-11 21:41:00","inspection_id":"79886810","insp_violation_id":"255776690","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:37:11.000000Z","updated_at":"2025-03-17T21:37:11.000000Z","normalized_code":"3958A1"},{"id":6462721,"change_date":"2023-10-11 21:41:00","inspection_id":"79886810","insp_violation_id":"255776691","seq_no":"3","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":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:11.000000Z","updated_at":"2025-03-17T21:37:11.000000Z","normalized_code":"3958E1"}],"inspection_per_units":[{"id":6713555,"change_date":"2023-10-11 21:41:00","inspection_id":"79886810","insp_unit_id":"197504536","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"42","insp_unit_license":"YAKA867","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XKYD49X7PJ235650","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:17.000000Z","updated_at":"2025-03-17T22:56:17.000000Z"},{"id":6713556,"change_date":"2023-10-11 21:41:00","inspection_id":"79886810","insp_unit_id":"197504537","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"320","insp_unit_license":"HV70938","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1UYVS2530GU485808","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:17.000000Z","updated_at":"2025-03-17T22:56:17.000000Z"}]},{"id":4084514,"change_date":"2023-09-28 21:41:00","inspection_id":"79786902","dot_number":"3901739","report_state":"WA","report_number":"W326004368","insp_date":"2023-09-27 00:00:00","insp_start_time":"0510","insp_end_time":"0615","registration_date":null,"region":"PT","ci_status_code":"C","location":null,"location_desc":"N\/B 395","county_code_state":"WA","county_code":"021","insp_level_id":"2","service_center":"WE","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":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-09-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"56000","viol_total":"17","oos_total":"5","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"15","vehicle_oos_total":"4","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2594596","transaction_code":"A","transaction_date":"2023-09-27 00:00:00","upload_date":"2023-09-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03901739","upload_search_indicator":null,"census_search_date":"2023-09-28 21:41:00","snet_input_date":"2023-09-28 00:00:00","source_office":"4WAS001","mcmis_add_date":"2023-09-28 21:41:00","insp_carrier_name":"J MEDELEZ LLC","insp_carrier_street":"1300 E PUNKIN CENTER RD","insp_carrier_city":"HERMISTON","insp_carrier_state":"OR","insp_carrier_zip_code":"97838-7700","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:43:36.000000Z","updated_at":"2025-03-17T19:43:36.000000Z","inspection_violations":[{"id":6322228,"change_date":"2023-09-28 21:41:00","inspection_id":"79786902","insp_violation_id":"255555077","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:32.000000Z","updated_at":"2025-03-17T21:36:32.000000Z","normalized_code":"38323A2"},{"id":6322229,"change_date":"2023-09-28 21:41:00","inspection_id":"79786902","insp_violation_id":"255555078","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197302985","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:32.000000Z","updated_at":"2025-03-17T21:36:32.000000Z","normalized_code":"3922"},{"id":6322230,"change_date":"2023-09-28 21:41:00","inspection_id":"79786902","insp_violation_id":"255555079","seq_no":"3","part_no":"387","part_no_section":"301(a)","insp_viol_unit":"1","insp_unit_id":"197302985","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:32.000000Z","updated_at":"2025-03-17T21:36:32.000000Z","normalized_code":"387301A"},{"id":6322231,"change_date":"2023-09-28 21:41:00","inspection_id":"79786902","insp_violation_id":"255555080","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197302985","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:32.000000Z","updated_at":"2025-03-17T21:36:32.000000Z","normalized_code":"3922"},{"id":6322232,"change_date":"2023-09-28 21:41:00","inspection_id":"79786902","insp_violation_id":"255555081","seq_no":"5","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"197302985","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:32.000000Z","updated_at":"2025-03-17T21:36:32.000000Z","normalized_code":"39395A"},{"id":6322233,"change_date":"2023-09-28 21:41:00","inspection_id":"79786902","insp_violation_id":"255555082","seq_no":"6","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"197302985","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:32.000000Z","updated_at":"2025-03-17T21:36:32.000000Z","normalized_code":"39395F"},{"id":6322234,"change_date":"2023-09-28 21:41:00","inspection_id":"79786902","insp_violation_id":"255555083","seq_no":"7","part_no":"393","part_no_section":"209(d)","insp_viol_unit":"1","insp_unit_id":"197302985","insp_violation_category_id":"21","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:36:32.000000Z","updated_at":"2025-03-17T21:36:32.000000Z","normalized_code":"393209D"},{"id":6322235,"change_date":"2023-09-28 21:41:00","inspection_id":"79786902","insp_violation_id":"255555084","seq_no":"8","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197302985","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:32.000000Z","updated_at":"2025-03-17T21:36:32.000000Z","normalized_code":"3939A"},{"id":6322236,"change_date":"2023-09-28 21:41:00","inspection_id":"79786902","insp_violation_id":"255555085","seq_no":"9","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"197302986","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:32.000000Z","updated_at":"2025-03-17T21:36:32.000000Z","normalized_code":"3939A"},{"id":6322237,"change_date":"2023-09-28 21:41:00","inspection_id":"79786902","insp_violation_id":"255555086","seq_no":"10","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"197302986","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:32.000000Z","updated_at":"2025-03-17T21:36:32.000000Z","normalized_code":"39311"},{"id":6322238,"change_date":"2023-09-28 21:41:00","inspection_id":"79786902","insp_violation_id":"255555087","seq_no":"11","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"197302986","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:32.000000Z","updated_at":"2025-03-17T21:36:32.000000Z","normalized_code":"3939A"},{"id":6322239,"change_date":"2023-09-28 21:41:00","inspection_id":"79786902","insp_violation_id":"255555088","seq_no":"12","part_no":"393","part_no_section":"70(d)","insp_viol_unit":"3","insp_unit_id":"197302987","insp_violation_category_id":"17","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:32.000000Z","updated_at":"2025-03-17T21:36:32.000000Z","normalized_code":"39370D"},{"id":6322240,"change_date":"2023-09-28 21:41:00","inspection_id":"79786902","insp_violation_id":"255555089","seq_no":"13","part_no":"393","part_no_section":"45","insp_viol_unit":"3","insp_unit_id":"197302987","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:36:32.000000Z","updated_at":"2025-03-17T21:36:32.000000Z","normalized_code":"39345"},{"id":6322241,"change_date":"2023-09-28 21:41:00","inspection_id":"79786902","insp_violation_id":"255555090","seq_no":"14","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"3","insp_unit_id":"197302987","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:36:32.000000Z","updated_at":"2025-03-17T21:36:32.000000Z","normalized_code":"39375A3"},{"id":6322242,"change_date":"2023-09-28 21:41:00","inspection_id":"79786902","insp_violation_id":"255555091","seq_no":"15","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"3","insp_unit_id":"197302987","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:36:32.000000Z","updated_at":"2025-03-17T21:36:32.000000Z","normalized_code":"3939A"},{"id":6322243,"change_date":"2023-09-28 21:41:00","inspection_id":"79786902","insp_violation_id":"255555092","seq_no":"16","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"3","insp_unit_id":"197302987","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:32.000000Z","updated_at":"2025-03-17T21:36:32.000000Z","normalized_code":"3939A"},{"id":6322244,"change_date":"2023-09-28 21:41:00","inspection_id":"79786902","insp_violation_id":"255555093","seq_no":"17","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":"3A0554072","created_at":"2025-03-17T21:36:32.000000Z","updated_at":"2025-03-17T21:36:32.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6567141,"change_date":"2023-09-28 21:41:00","inspection_id":"79786902","insp_unit_id":"197302985","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"74","insp_unit_license":"YAIV303","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"5KJJAED17FPGF2858","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:07.000000Z","updated_at":"2025-03-17T22:55:07.000000Z"},{"id":6567142,"change_date":"2023-09-28 21:41:00","inspection_id":"79786902","insp_unit_id":"197302986","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"00114AD","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1H5Y0281XEM030631","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:07.000000Z","updated_at":"2025-03-17T22:55:07.000000Z"},{"id":6567143,"change_date":"2023-09-28 21:41:00","inspection_id":"79786902","insp_unit_id":"197302987","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"00114AD","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"159J5340625023798","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:07.000000Z","updated_at":"2025-03-17T22:55:07.000000Z"}]},{"id":4035471,"change_date":"2023-09-22 21:39:00","inspection_id":"79732243","dot_number":"3901739","report_state":"WA","report_number":"W339001334","insp_date":"2023-09-21 00:00:00","insp_start_time":"1435","insp_end_time":"1620","registration_date":null,"region":"PT","ci_status_code":"C","location":"30399","location_desc":"SELLARDS RD","county_code_state":"WA","county_code":"005","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"WYCKOFF","shipping_paper_number":"20003311","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-09-22 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"124000","viol_total":"21","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"21","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2593473","transaction_code":"A","transaction_date":"2023-09-21 00:00:00","upload_date":"2023-09-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03901739","upload_search_indicator":null,"census_search_date":"2023-09-22 21:39:00","snet_input_date":"2023-09-22 00:00:00","source_office":"4WAS001","mcmis_add_date":"2023-09-22 21:39:00","insp_carrier_name":"J MEDELEZ LLC","insp_carrier_street":"1300 E PUNKIN CENTER RD","insp_carrier_city":"HERMISTON","insp_carrier_state":"OR","insp_carrier_zip_code":"97838-7700","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:42:26.000000Z","updated_at":"2025-03-17T19:42:26.000000Z","inspection_violations":[{"id":6246471,"change_date":"2023-09-22 21:39:00","inspection_id":"79732243","insp_violation_id":"255430548","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197192092","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:09.000000Z","updated_at":"2025-03-17T21:36:09.000000Z","normalized_code":"3922"},{"id":6246472,"change_date":"2023-09-22 21:39:00","inspection_id":"79732243","insp_violation_id":"255430549","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197192092","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:09.000000Z","updated_at":"2025-03-17T21:36:09.000000Z","normalized_code":"3922"},{"id":6246473,"change_date":"2023-09-22 21:39:00","inspection_id":"79732243","insp_violation_id":"255430550","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197192092","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:09.000000Z","updated_at":"2025-03-17T21:36:09.000000Z","normalized_code":"3922"},{"id":6246474,"change_date":"2023-09-22 21:39:00","inspection_id":"79732243","insp_violation_id":"255430551","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197192092","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:09.000000Z","updated_at":"2025-03-17T21:36:09.000000Z","normalized_code":"3922"},{"id":6246475,"change_date":"2023-09-22 21:39:00","inspection_id":"79732243","insp_violation_id":"255430552","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197192092","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"3A0603721A","created_at":"2025-03-17T21:36:09.000000Z","updated_at":"2025-03-17T21:36:09.000000Z","normalized_code":"3922"},{"id":6246476,"change_date":"2023-09-22 21:39:00","inspection_id":"79732243","insp_violation_id":"255430553","seq_no":"6","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197192092","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:09.000000Z","updated_at":"2025-03-17T21:36:09.000000Z","normalized_code":"3922"},{"id":6246477,"change_date":"2023-09-22 21:39:00","inspection_id":"79732243","insp_violation_id":"255430554","seq_no":"7","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197192092","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"3A0603721C","created_at":"2025-03-17T21:36:09.000000Z","updated_at":"2025-03-17T21:36:09.000000Z","normalized_code":"3922"},{"id":6246478,"change_date":"2023-09-22 21:39:00","inspection_id":"79732243","insp_violation_id":"255430555","seq_no":"8","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"197192092","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:09.000000Z","updated_at":"2025-03-17T21:36:09.000000Z","normalized_code":"39378"},{"id":6246479,"change_date":"2023-09-22 21:39:00","inspection_id":"79732243","insp_violation_id":"255430556","seq_no":"9","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"197192092","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:09.000000Z","updated_at":"2025-03-17T21:36:09.000000Z","normalized_code":"39395A"},{"id":6246480,"change_date":"2023-09-22 21:39:00","inspection_id":"79732243","insp_violation_id":"255430557","seq_no":"10","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"197192092","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:09.000000Z","updated_at":"2025-03-17T21:36:09.000000Z","normalized_code":"39311"},{"id":6246481,"change_date":"2023-09-22 21:39:00","inspection_id":"79732243","insp_violation_id":"255430558","seq_no":"11","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"197192092","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:09.000000Z","updated_at":"2025-03-17T21:36:09.000000Z","normalized_code":"39345D"},{"id":6246482,"change_date":"2023-09-22 21:39:00","inspection_id":"79732243","insp_violation_id":"255430559","seq_no":"12","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"197192092","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:09.000000Z","updated_at":"2025-03-17T21:36:09.000000Z","normalized_code":"39345D"},{"id":6246483,"change_date":"2023-09-22 21:39:00","inspection_id":"79732243","insp_violation_id":"255430560","seq_no":"13","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"197192092","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:09.000000Z","updated_at":"2025-03-17T21:36:09.000000Z","normalized_code":"39311"},{"id":6246484,"change_date":"2023-09-22 21:39:00","inspection_id":"79732243","insp_violation_id":"255430561","seq_no":"14","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"197192092","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:36:09.000000Z","updated_at":"2025-03-17T21:36:09.000000Z","normalized_code":"39375A3"},{"id":6246485,"change_date":"2023-09-22 21:39:00","inspection_id":"79732243","insp_violation_id":"255430562","seq_no":"15","part_no":"393","part_no_section":"207(f)","insp_viol_unit":"1","insp_unit_id":"197192092","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:09.000000Z","updated_at":"2025-03-17T21:36:09.000000Z","normalized_code":"393207F"},{"id":6246486,"change_date":"2023-09-22 21:39:00","inspection_id":"79732243","insp_violation_id":"255430563","seq_no":"16","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"197192093","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"3A0603721B","created_at":"2025-03-17T21:36:09.000000Z","updated_at":"2025-03-17T21:36:09.000000Z","normalized_code":"39375A3"},{"id":6246487,"change_date":"2023-09-22 21:39:00","inspection_id":"79732243","insp_violation_id":"255430564","seq_no":"17","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"197192093","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:09.000000Z","updated_at":"2025-03-17T21:36:09.000000Z","normalized_code":"3922"},{"id":6246488,"change_date":"2023-09-22 21:39:00","inspection_id":"79732243","insp_violation_id":"255430565","seq_no":"18","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"197192093","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:09.000000Z","updated_at":"2025-03-17T21:36:09.000000Z","normalized_code":"3939A"},{"id":6246489,"change_date":"2023-09-22 21:39:00","inspection_id":"79732243","insp_violation_id":"255430566","seq_no":"19","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"197192093","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:09.000000Z","updated_at":"2025-03-17T21:36:09.000000Z","normalized_code":"39311"},{"id":6246490,"change_date":"2023-09-22 21:39:00","inspection_id":"79732243","insp_violation_id":"255430567","seq_no":"20","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"197192093","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:09.000000Z","updated_at":"2025-03-17T21:36:09.000000Z","normalized_code":"3922"},{"id":6246491,"change_date":"2023-09-22 21:39:00","inspection_id":"79732243","insp_violation_id":"255430568","seq_no":"21","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"197192093","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:09.000000Z","updated_at":"2025-03-17T21:36:09.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6488242,"change_date":"2023-09-22 21:39:00","inspection_id":"79732243","insp_unit_id":"197192092","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"200","insp_unit_license":"YAIG862","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XP5DB9X3SD360637","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:27.000000Z","updated_at":"2025-03-17T22:54:27.000000Z"},{"id":6488243,"change_date":"2023-09-22 21:39:00","inspection_id":"79732243","insp_unit_id":"197192093","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRIN","insp_unit_company":"42","insp_unit_license":"HU69381","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1T9SC5036CB656262","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:27.000000Z","updated_at":"2025-03-17T22:54:27.000000Z"}]},{"id":3903457,"change_date":"2023-09-05 21:41:00","inspection_id":"79585589","dot_number":"3901739","report_state":"WA","report_number":"W739001242","insp_date":"2023-09-04 00:00:00","insp_start_time":"0745","insp_end_time":"0850","registration_date":null,"region":"PT","ci_status_code":"C","location":"SC54","location_desc":"SC54   PLYMOUTH (POE)","county_code_state":"WA","county_code":"005","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"NORTHWEST FARMS","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-09-05 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"125000","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":"2589793","transaction_code":"A","transaction_date":"2023-09-04 00:00:00","upload_date":"2023-09-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03901739","upload_search_indicator":null,"census_search_date":"2023-09-05 21:41:00","snet_input_date":"2023-09-05 00:00:00","source_office":"4WAS001","mcmis_add_date":"2023-09-05 21:41:00","insp_carrier_name":"J MEDELEZ LLC","insp_carrier_street":"1300 E PUNKIN CENTER RD","insp_carrier_city":"HERMISTON","insp_carrier_state":"OR","insp_carrier_zip_code":"97838-7700","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:40:03.000000Z","updated_at":"2025-03-17T19:40:03.000000Z","inspection_violations":[{"id":6031510,"change_date":"2023-09-05 21:41:00","inspection_id":"79585589","insp_violation_id":"255082168","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":"3A0646537","created_at":"2025-03-17T21:35:12.000000Z","updated_at":"2025-03-17T21:35:12.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6276380,"change_date":"2023-09-05 21:41:00","inspection_id":"79585589","insp_unit_id":"196898720","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"03","insp_unit_license":"YAJW871","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XPXD49X8PD813047","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:44.000000Z","updated_at":"2025-03-17T22:52:44.000000Z"},{"id":6276381,"change_date":"2023-09-05 21:41:00","inspection_id":"79585589","insp_unit_id":"196898721","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRIN","insp_unit_company":"81","insp_unit_license":"HV67170","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1T9SC5346MB656185","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:44.000000Z","updated_at":"2025-03-17T22:52:44.000000Z"}]},{"id":3882231,"change_date":"2023-08-31 21:43:00","inspection_id":"79561840","dot_number":"3901739","report_state":"WA","report_number":"0001357405","insp_date":"2023-08-25 00:00:00","insp_start_time":"1215","insp_end_time":"1245","registration_date":null,"region":"PD","ci_status_code":"C","location":null,"location_desc":"SR-14 MP 180","county_code_state":"WA","county_code":"005","insp_level_id":"3","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-31 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"128000","viol_total":"3","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2589477","transaction_code":"A","transaction_date":"2023-08-31 00:00:00","upload_date":"2023-08-31 00:00:00","upload_first_byte":"0","upload_dot_number":"03901739","upload_search_indicator":"M","census_search_date":"2023-08-31 21:43:00","snet_input_date":"2023-08-31 00:00:00","source_office":"4WAS001","mcmis_add_date":"2023-08-31 21:43:00","insp_carrier_name":"J MEDELEZ LLC","insp_carrier_street":"1300 E PUNKIN CENTER RD","insp_carrier_city":"HERMISTON","insp_carrier_state":"OR","insp_carrier_zip_code":"97838","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:39:41.000000Z","updated_at":"2025-03-17T19:39:41.000000Z","inspection_violations":[{"id":5999419,"change_date":"2023-08-31 21:43:00","inspection_id":"79561840","insp_violation_id":"255029777","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":"I7012476","created_at":"2025-03-17T21:35:01.000000Z","updated_at":"2025-03-17T21:35:01.000000Z","normalized_code":"39216A"},{"id":5999420,"change_date":"2023-08-31 21:43:00","inspection_id":"79561840","insp_violation_id":"255029778","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196851413","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:01.000000Z","updated_at":"2025-03-17T21:35:01.000000Z","normalized_code":"3922"},{"id":5999421,"change_date":"2023-08-31 21:43:00","inspection_id":"79561840","insp_violation_id":"255029779","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"196851414","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:01.000000Z","updated_at":"2025-03-17T21:35:01.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6241763,"change_date":"2023-08-31 21:43:00","inspection_id":"79561840","insp_unit_id":"196851413","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"04","insp_unit_license":"YAJX907","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1FUNGEDR1DSFB9213","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:27.000000Z","updated_at":"2025-03-17T22:52:27.000000Z"},{"id":6241764,"change_date":"2023-08-31 21:43:00","inspection_id":"79561840","insp_unit_id":"196851414","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRIN","insp_unit_company":"194","insp_unit_license":"HV46922","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1T9SC5340KB656194","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:27.000000Z","updated_at":"2025-03-17T22:52:27.000000Z"}]},{"id":3835470,"change_date":"2023-12-08 21:41:00","inspection_id":"79509715","dot_number":"3901739","report_state":"OR","report_number":"AADH004514","insp_date":"2023-08-24 00:00:00","insp_start_time":"1352","insp_end_time":"1431","registration_date":"2023-12-08 00:00:00","region":"PT","ci_status_code":"C","location":"3006","location_desc":"UMATILLA POE","county_code_state":"OR","county_code":"059","insp_level_id":"1","service_center":"WE","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-08-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"65650","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":"1231968","transaction_code":"C","transaction_date":"2023-08-24 00:00:00","upload_date":"2023-12-08 00:00:00","upload_first_byte":"0","upload_dot_number":"03901739","upload_search_indicator":null,"census_search_date":"2023-08-25 21:41:00","snet_input_date":"2023-08-25 00:00:00","source_office":"4ORS001","mcmis_add_date":"2023-08-25 21:41:00","insp_carrier_name":"J MEDELEZ LLC","insp_carrier_street":"1300 E PUNKIN CENTER RD","insp_carrier_city":"HERMISTON","insp_carrier_state":"OR","insp_carrier_zip_code":"97838-7700","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"219794","created_at":"2025-03-17T19:38:33.000000Z","updated_at":"2025-03-17T19:38:33.000000Z","inspection_violations":[{"id":5923947,"change_date":"2023-12-08 21:41:00","inspection_id":"79509715","insp_violation_id":"256795701","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"198424017","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:39.000000Z","updated_at":"2025-03-17T21:34:39.000000Z","normalized_code":"39347E"},{"id":5923948,"change_date":"2023-12-08 21:41:00","inspection_id":"79509715","insp_violation_id":"256795702","seq_no":"2","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"198424017","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:39.000000Z","updated_at":"2025-03-17T21:34:39.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":6166747,"change_date":"2023-12-08 21:41:00","inspection_id":"79509715","insp_unit_id":"198424016","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"60","insp_unit_license":"YAJF964","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"5KJNBHDR1LLLX9586","insp_unit_decal":"Y","insp_unit_decal_number":"33071244","created_at":"2025-03-17T22:51:49.000000Z","updated_at":"2025-03-17T22:51:49.000000Z"},{"id":6166748,"change_date":"2023-12-08 21:41:00","inspection_id":"79509715","insp_unit_id":"198424017","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRIN","insp_unit_company":"15","insp_unit_license":"HV65321","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":null,"insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:49.000000Z","updated_at":"2025-03-17T22:51:49.000000Z"}]},{"id":3835570,"change_date":"2023-08-25 21:42:00","inspection_id":"79509829","dot_number":"3901739","report_state":"WA","report_number":"W326004360","insp_date":"2023-08-23 00:00:00","insp_start_time":"0950","insp_end_time":"1045","registration_date":null,"region":"PT","ci_status_code":"C","location":null,"location_desc":"E\/B 12","county_code_state":"WA","county_code":"021","insp_level_id":"2","service_center":"WE","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":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-08-25 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"121000","viol_total":"9","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2588308","transaction_code":"A","transaction_date":"2023-08-23 00:00:00","upload_date":"2023-08-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03901739","upload_search_indicator":null,"census_search_date":"2023-08-25 21:42:00","snet_input_date":"2023-08-24 00:00:00","source_office":"4WAS001","mcmis_add_date":"2023-08-25 21:42:00","insp_carrier_name":"J MEDELEZ LLC","insp_carrier_street":"1300 E PUNKIN CENTER RD","insp_carrier_city":"HERMISTON","insp_carrier_state":"OR","insp_carrier_zip_code":"97838-7700","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:38:33.000000Z","updated_at":"2025-03-17T19:38:33.000000Z","inspection_violations":[{"id":5924124,"change_date":"2023-08-25 21:42:00","inspection_id":"79509829","insp_violation_id":"254897559","seq_no":"1","part_no":"391","part_no_section":"11(b)(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:34:39.000000Z","updated_at":"2025-03-17T21:34:39.000000Z","normalized_code":"39111B2"},{"id":5924125,"change_date":"2023-08-25 21:42:00","inspection_id":"79509829","insp_violation_id":"254897560","seq_no":"2","part_no":"387","part_no_section":"301(a)","insp_viol_unit":"1","insp_unit_id":"196739446","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:39.000000Z","updated_at":"2025-03-17T21:34:39.000000Z","normalized_code":"387301A"},{"id":5924126,"change_date":"2023-08-25 21:42:00","inspection_id":"79509829","insp_violation_id":"254897561","seq_no":"3","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"196739446","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:39.000000Z","updated_at":"2025-03-17T21:34:39.000000Z","normalized_code":"39395A"},{"id":5924127,"change_date":"2023-08-25 21:42:00","inspection_id":"79509829","insp_violation_id":"254897562","seq_no":"4","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"196739446","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:39.000000Z","updated_at":"2025-03-17T21:34:39.000000Z","normalized_code":"39378"},{"id":5924128,"change_date":"2023-08-25 21:42:00","inspection_id":"79509829","insp_violation_id":"254897563","seq_no":"5","part_no":"393","part_no_section":"81","insp_viol_unit":"1","insp_unit_id":"196739446","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:39.000000Z","updated_at":"2025-03-17T21:34:39.000000Z","normalized_code":"39381"},{"id":5924129,"change_date":"2023-08-25 21:42:00","inspection_id":"79509829","insp_violation_id":"254897564","seq_no":"6","part_no":"393","part_no_section":"100(b)","insp_viol_unit":"2","insp_unit_id":"196739447","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"3A0554070","created_at":"2025-03-17T21:34:39.000000Z","updated_at":"2025-03-17T21:34:39.000000Z","normalized_code":"393100B"},{"id":5924130,"change_date":"2023-08-25 21:42:00","inspection_id":"79509829","insp_violation_id":"254897565","seq_no":"7","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"196739447","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:39.000000Z","updated_at":"2025-03-17T21:34:39.000000Z","normalized_code":"3922"},{"id":5924131,"change_date":"2023-08-25 21:42:00","inspection_id":"79509829","insp_violation_id":"254897566","seq_no":"8","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"196739447","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:39.000000Z","updated_at":"2025-03-17T21:34:39.000000Z","normalized_code":"39617C"},{"id":5924132,"change_date":"2023-08-25 21:42:00","inspection_id":"79509829","insp_violation_id":"254897567","seq_no":"9","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"196739446","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:39.000000Z","updated_at":"2025-03-17T21:34:39.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":6166928,"change_date":"2023-08-25 21:42:00","inspection_id":"79509829","insp_unit_id":"196739446","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"15","insp_unit_license":"YAJI762","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XKWDB9X46R112111","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:49.000000Z","updated_at":"2025-03-17T22:51:49.000000Z"},{"id":6166929,"change_date":"2023-08-25 21:42:00","inspection_id":"79509829","insp_unit_id":"196739447","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"4","insp_unit_license":"9964YM","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"WA98230980","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:49.000000Z","updated_at":"2025-03-17T22:51:49.000000Z"}]},{"id":3687891,"change_date":"2023-12-08 21:41:00","inspection_id":"79345093","dot_number":"3901739","report_state":"OR","report_number":"AAXD006634","insp_date":"2023-08-06 00:00:00","insp_start_time":"0555","insp_end_time":"0709","registration_date":"2023-12-08 00:00:00","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":"2","service_center":"WE","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-08-07 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"143500","viol_total":"6","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1230476","transaction_code":"C","transaction_date":"2023-08-06 00:00:00","upload_date":"2023-12-08 00:00:00","upload_first_byte":"0","upload_dot_number":"03901739","upload_search_indicator":null,"census_search_date":"2023-08-07 21:42:00","snet_input_date":"2023-08-07 00:00:00","source_office":"4ORS001","mcmis_add_date":"2023-08-07 21:42:00","insp_carrier_name":"J MEDELEZ LLC","insp_carrier_street":"1300 E PUNKIN CENTER RD","insp_carrier_city":"HERMISTON","insp_carrier_state":"OR","insp_carrier_zip_code":"97838-7700","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"219794","created_at":"2025-03-17T19:35:40.000000Z","updated_at":"2025-03-17T19:35:40.000000Z","inspection_violations":[{"id":5686202,"change_date":"2023-12-08 21:41:00","inspection_id":"79345093","insp_violation_id":"256795683","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"198424008","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:22.000000Z","updated_at":"2025-03-17T21:33:22.000000Z","normalized_code":"39311"},{"id":5686203,"change_date":"2023-12-08 21:41:00","inspection_id":"79345093","insp_violation_id":"256795684","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"198424008","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:22.000000Z","updated_at":"2025-03-17T21:33:22.000000Z","normalized_code":"39378"},{"id":5686204,"change_date":"2023-12-08 21:41:00","inspection_id":"79345093","insp_violation_id":"256795685","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"198424009","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:22.000000Z","updated_at":"2025-03-17T21:33:22.000000Z","normalized_code":"39617C"},{"id":5686205,"change_date":"2023-12-08 21:41:00","inspection_id":"79345093","insp_violation_id":"256795686","seq_no":"4","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"198424009","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:22.000000Z","updated_at":"2025-03-17T21:33:22.000000Z","normalized_code":"39355E"},{"id":5686206,"change_date":"2023-12-08 21:41:00","inspection_id":"79345093","insp_violation_id":"256795687","seq_no":"5","part_no":"395","part_no_section":"32(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:33:22.000000Z","updated_at":"2025-03-17T21:33:22.000000Z","normalized_code":"39532B"},{"id":5686207,"change_date":"2023-12-08 21:41:00","inspection_id":"79345093","insp_violation_id":"256795688","seq_no":"6","part_no":"395","part_no_section":"32(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:33:22.000000Z","updated_at":"2025-03-17T21:33:22.000000Z","normalized_code":"39532B"}],"inspection_per_units":[{"id":5929597,"change_date":"2023-12-08 21:41:00","inspection_id":"79345093","insp_unit_id":"198424008","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"16","insp_unit_license":"YAJF964","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"5KJNBHDR1LLLX9586","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":5929598,"change_date":"2023-12-08 21:41:00","inspection_id":"79345093","insp_unit_id":"198424009","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRIN","insp_unit_company":"15","insp_unit_license":"HV65321","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1T9SC5346JB656098","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":3570708,"change_date":"2023-07-21 21:41:00","inspection_id":"79213464","dot_number":"3901739","report_state":"CA","report_number":"NE8S001711","insp_date":"2023-07-20 00:00:00","insp_start_time":"1914","insp_end_time":"1936","registration_date":null,"region":"PT","ci_status_code":"C","location":"601","location_desc":"SIDEWINDER PLATFORM SCALE","county_code_state":"CA","county_code":"073","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117500","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":"14991831","transaction_code":"A","transaction_date":"2023-07-20 00:00:00","upload_date":"2023-07-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03901739","upload_search_indicator":null,"census_search_date":"2023-07-21 21:41:00","snet_input_date":"2023-07-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-07-21 21:41:00","insp_carrier_name":"J MEDELEZ LLC","insp_carrier_street":"1300 E PUNKIN CENTER RD","insp_carrier_city":"HERMISTON","insp_carrier_state":"OR","insp_carrier_zip_code":"97838","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:33:33.000000Z","updated_at":"2025-03-17T19:33:33.000000Z","inspection_violations":[{"id":5505740,"change_date":"2023-07-21 21:41:00","inspection_id":"79213464","insp_violation_id":"254216441","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"196138933","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"CW927535","created_at":"2025-03-17T21:32:33.000000Z","updated_at":"2025-03-17T21:32:33.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":5741270,"change_date":"2023-07-21 21:41:00","inspection_id":"79213464","insp_unit_id":"196138932","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"42 \/ SILVER","insp_unit_license":"YAKA867","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XKYD49X7PJ235650","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:19.000000Z","updated_at":"2025-03-17T22:48:19.000000Z"},{"id":5741271,"change_date":"2023-07-21 21:41:00","inspection_id":"79213464","insp_unit_id":"196138933","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"SN83 \/BLACK","insp_unit_license":"HV70938","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1UYVS2530GU485808","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:19.000000Z","updated_at":"2025-03-17T22:48:19.000000Z"}]},{"id":3558891,"change_date":"2023-07-20 21:41:00","inspection_id":"79200188","dot_number":"3901739","report_state":"WA","report_number":"W605013104","insp_date":"2023-07-18 00:00:00","insp_start_time":"0800","insp_end_time":"0823","registration_date":null,"region":"PT","ci_status_code":"C","location":"SC94","location_desc":"SC94   ROCK ISLAND","county_code_state":"WA","county_code":"017","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-07-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"132350","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":"2582566","transaction_code":"A","transaction_date":"2023-07-18 00:00:00","upload_date":"2023-07-20 00:00:00","upload_first_byte":"0","upload_dot_number":"03901739","upload_search_indicator":null,"census_search_date":"2023-07-20 21:41:00","snet_input_date":"2023-07-20 00:00:00","source_office":"4WAS001","mcmis_add_date":"2023-07-20 21:41:00","insp_carrier_name":"J MEDELEZ LLC","insp_carrier_street":"1300 E PUNKIN CENTER RD","insp_carrier_city":"HERMISTON","insp_carrier_state":"OR","insp_carrier_zip_code":"97838-7700","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:33:12.000000Z","updated_at":"2025-03-17T19:33:12.000000Z","inspection_violations":[{"id":5486887,"change_date":"2023-07-20 21:41:00","inspection_id":"79200188","insp_violation_id":"254185127","seq_no":"1","part_no":"391","part_no_section":"11(b)(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:32:28.000000Z","updated_at":"2025-03-17T21:32:28.000000Z","normalized_code":"39111B2"}],"inspection_per_units":[{"id":5723010,"change_date":"2023-07-20 21:41:00","inspection_id":"79200188","insp_unit_id":"196112799","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"08","insp_unit_license":"YAJY839","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XPBD49X1GD359282","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:10.000000Z","updated_at":"2025-03-17T22:48:10.000000Z"},{"id":5723011,"change_date":"2023-07-20 21:41:00","inspection_id":"79200188","insp_unit_id":"196112800","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"HV46930","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1UYVS3538FU082907","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:10.000000Z","updated_at":"2025-03-17T22:48:10.000000Z"}]},{"id":3459216,"change_date":"2023-07-07 21:42:00","inspection_id":"79088557","dot_number":"3901739","report_state":"WA","report_number":"W605013060","insp_date":"2023-07-06 00:00:00","insp_start_time":"0840","insp_end_time":"0915","registration_date":null,"region":"PT","ci_status_code":"C","location":"SC94","location_desc":"SC94   ROCK ISLAND","county_code_state":"WA","county_code":"017","insp_level_id":"2","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-07-07 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"116000","viol_total":"5","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2580415","transaction_code":"A","transaction_date":"2023-07-06 00:00:00","upload_date":"2023-07-07 00:00:00","upload_first_byte":"0","upload_dot_number":"03901739","upload_search_indicator":null,"census_search_date":"2023-07-07 21:42:00","snet_input_date":"2023-07-07 00:00:00","source_office":"4WAS001","mcmis_add_date":"2023-07-07 21:42:00","insp_carrier_name":"J MEDELEZ LLC","insp_carrier_street":"1300 E PUNKIN CENTER RD","insp_carrier_city":"HERMISTON","insp_carrier_state":"OR","insp_carrier_zip_code":"97838-7700","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:31:23.000000Z","updated_at":"2025-03-17T19:31:23.000000Z","inspection_violations":[{"id":5333589,"change_date":"2023-07-07 21:42:00","inspection_id":"79088557","insp_violation_id":"253937139","seq_no":"1","part_no":"396","part_no_section":"9(d)(2)","insp_viol_unit":"1","insp_unit_id":"195888747","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:44.000000Z","updated_at":"2025-03-17T21:31:44.000000Z","normalized_code":"3969D2"},{"id":5333590,"change_date":"2023-07-07 21:42:00","inspection_id":"79088557","insp_violation_id":"253937140","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195888747","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:44.000000Z","updated_at":"2025-03-17T21:31:44.000000Z","normalized_code":"3922"},{"id":5333591,"change_date":"2023-07-07 21:42:00","inspection_id":"79088557","insp_violation_id":"253937141","seq_no":"3","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:31:44.000000Z","updated_at":"2025-03-17T21:31:44.000000Z","normalized_code":"3922"},{"id":5333592,"change_date":"2023-07-07 21:42:00","inspection_id":"79088557","insp_violation_id":"253937142","seq_no":"4","part_no":"393","part_no_section":"55(d)(3)","insp_viol_unit":"2","insp_unit_id":"195888748","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:44.000000Z","updated_at":"2025-03-17T21:31:44.000000Z","normalized_code":"39355D3"},{"id":5333593,"change_date":"2023-07-07 21:42:00","inspection_id":"79088557","insp_violation_id":"253937143","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195888747","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:44.000000Z","updated_at":"2025-03-17T21:31:44.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":5562492,"change_date":"2023-07-07 21:42:00","inspection_id":"79088557","insp_unit_id":"195888747","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"24","insp_unit_license":"YAJE347","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XKYD49X3KJ220278","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:55.000000Z","updated_at":"2025-03-17T22:46:55.000000Z"},{"id":5562493,"change_date":"2023-07-07 21:42:00","inspection_id":"79088557","insp_unit_id":"195888748","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"HV12022","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1UYVS35368U322328","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:55.000000Z","updated_at":"2025-03-17T22:46:55.000000Z"}]},{"id":3261370,"change_date":"2023-06-12 21:40:00","inspection_id":"78865509","dot_number":"3901739","report_state":"WA","report_number":"W625001293","insp_date":"2023-06-09 00:00:00","insp_start_time":"0900","insp_end_time":"1000","registration_date":null,"region":"PT","ci_status_code":"C","location":"SC54","location_desc":"SC54   PLYMOUTH (POE)","county_code_state":"WA","county_code":"005","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"LINEAGE INTERMODAL","shipping_paper_number":"T565173","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":"Y","pen_cen_match":"I","final_status_date":"2023-06-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"148000","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":"2576263","transaction_code":"A","transaction_date":"2023-06-09 00:00:00","upload_date":"2023-06-12 00:00:00","upload_first_byte":"0","upload_dot_number":"03901739","upload_search_indicator":null,"census_search_date":"2023-06-12 21:40:00","snet_input_date":"2023-06-12 00:00:00","source_office":"4WAS001","mcmis_add_date":"2023-06-12 21:40:00","insp_carrier_name":"J MEDELEZ LLC","insp_carrier_street":"1300 E PUNKIN CENTER RD","insp_carrier_city":"HERMISTON","insp_carrier_state":"OR","insp_carrier_zip_code":"97838-7700","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:27:40.000000Z","updated_at":"2025-03-17T19:27:40.000000Z","inspection_violations":[{"id":5027919,"change_date":"2023-06-12 21:40:00","inspection_id":"78865509","insp_violation_id":"253441368","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:30:23.000000Z","updated_at":"2025-03-17T21:30:23.000000Z","normalized_code":"3922"},{"id":5027920,"change_date":"2023-06-12 21:40:00","inspection_id":"78865509","insp_violation_id":"253441369","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:23.000000Z","updated_at":"2025-03-17T21:30:23.000000Z","normalized_code":"3922"},{"id":5027921,"change_date":"2023-06-12 21:40:00","inspection_id":"78865509","insp_violation_id":"253441370","seq_no":"3","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"195446233","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:23.000000Z","updated_at":"2025-03-17T21:30:23.000000Z","normalized_code":"39360D"},{"id":5027922,"change_date":"2023-06-12 21:40:00","inspection_id":"78865509","insp_violation_id":"253441371","seq_no":"4","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"195446233","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:23.000000Z","updated_at":"2025-03-17T21:30:23.000000Z","normalized_code":"39617C"},{"id":5027923,"change_date":"2023-06-12 21:40:00","inspection_id":"78865509","insp_violation_id":"253441372","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195446233","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:23.000000Z","updated_at":"2025-03-17T21:30:23.000000Z","normalized_code":"3939A"},{"id":5027924,"change_date":"2023-06-12 21:40:00","inspection_id":"78865509","insp_violation_id":"253441373","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195446233","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:23.000000Z","updated_at":"2025-03-17T21:30:23.000000Z","normalized_code":"3939A"},{"id":5027925,"change_date":"2023-06-12 21:40:00","inspection_id":"78865509","insp_violation_id":"253441374","seq_no":"7","part_no":"396","part_no_section":"9(d)(2)","insp_viol_unit":"1","insp_unit_id":"195446233","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:23.000000Z","updated_at":"2025-03-17T21:30:23.000000Z","normalized_code":"3969D2"},{"id":5027926,"change_date":"2023-06-12 21:40:00","inspection_id":"78865509","insp_violation_id":"253441375","seq_no":"8","part_no":"376","part_no_section":"11(d)(1)","insp_viol_unit":"1","insp_unit_id":"195446233","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:23.000000Z","updated_at":"2025-03-17T21:30:23.000000Z","normalized_code":"37611D1"}],"inspection_per_units":[{"id":5245146,"change_date":"2023-06-12 21:40:00","inspection_id":"78865509","insp_unit_id":"195446233","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"85","insp_unit_license":"YAJE347","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XKYD49X3KJ220278","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:22.000000Z","updated_at":"2025-03-17T22:44:22.000000Z"},{"id":5245147,"change_date":"2023-06-12 21:40:00","inspection_id":"78865509","insp_unit_id":"195446234","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"502","insp_unit_license":"HU93033","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1UYVS35318U436009","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:22.000000Z","updated_at":"2025-03-17T22:44:22.000000Z"}]},{"id":3241692,"change_date":"2023-06-12 21:40:00","inspection_id":"78843398","dot_number":"3901739","report_state":"OR","report_number":"AAYL003563","insp_date":"2023-06-07 00:00:00","insp_start_time":"1020","insp_end_time":"1044","registration_date":"2023-06-12 00:00:00","region":"PT","ci_status_code":"C","location":"3004","location_desc":"COLD SPRINGS - JCT US730\/OR37","county_code_state":"OR","county_code":"059","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"LAMB WESTON","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-06-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"31860","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":"1226623","transaction_code":"C","transaction_date":"2023-06-07 00:00:00","upload_date":"2023-06-12 00:00:00","upload_first_byte":"0","upload_dot_number":"03901739","upload_search_indicator":null,"census_search_date":"2023-06-08 21:41:00","snet_input_date":"2023-06-08 00:00:00","source_office":"4ORS001","mcmis_add_date":"2023-06-08 21:41:00","insp_carrier_name":"J MEDELEZ LLC","insp_carrier_street":"1300 E PUNKIN CENTER RD","insp_carrier_city":"HERMISTON","insp_carrier_state":"OR","insp_carrier_zip_code":"97838-7700","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"007063","created_at":"2025-03-17T19:27:18.000000Z","updated_at":"2025-03-17T19:27:18.000000Z","inspection_violations":[{"id":4997292,"change_date":"2023-06-12 21:40:00","inspection_id":"78843398","insp_violation_id":"253440371","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"195445298","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:30:13.000000Z","updated_at":"2025-03-17T21:30:13.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":5213913,"change_date":"2023-06-12 21:40:00","inspection_id":"78843398","insp_unit_id":"195445297","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"04","insp_unit_license":"YAJX907","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1FUNGEDR1DSFB9213","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:05.000000Z","updated_at":"2025-03-17T22:44:05.000000Z"},{"id":5213914,"change_date":"2023-06-12 21:40:00","inspection_id":"78843398","insp_unit_id":"195445298","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRIN","insp_unit_company":"129","insp_unit_license":"HU93015","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":null,"insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:05.000000Z","updated_at":"2025-03-17T22:44:05.000000Z"}]},{"id":3109041,"change_date":"2023-06-20 21:41:00","inspection_id":"78693605","dot_number":"3901739","report_state":"WA","report_number":"W625001245","insp_date":"2023-05-21 00:00:00","insp_start_time":"1050","insp_end_time":"1145","registration_date":null,"region":"PT","ci_status_code":"C","location":"SC54","location_desc":"SC54   PLYMOUTH (POE)","county_code_state":"WA","county_code":"005","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":"I","final_status_date":"2023-05-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120300","viol_total":"5","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2572835","transaction_code":"C","transaction_date":"2023-06-20 00:00:00","upload_date":"2023-06-20 00:00:00","upload_first_byte":"0","upload_dot_number":"03901739","upload_search_indicator":null,"census_search_date":"2023-05-22 21:41:00","snet_input_date":"2023-05-22 00:00:00","source_office":"4WAS001","mcmis_add_date":"2023-05-22 21:41:00","insp_carrier_name":"J MEDELEZ LLC","insp_carrier_street":"1300 E PUNKIN CENTER RD","insp_carrier_city":"HERMISTON","insp_carrier_state":"OR","insp_carrier_zip_code":"97838-7700","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:24:35.000000Z","updated_at":"2025-03-17T19:24:35.000000Z","inspection_violations":[{"id":4783123,"change_date":"2023-06-20 21:41:00","inspection_id":"78693605","insp_violation_id":"253606968","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:29:17.000000Z","updated_at":"2025-03-17T21:29:17.000000Z","normalized_code":"3922"},{"id":4783124,"change_date":"2023-06-20 21:41:00","inspection_id":"78693605","insp_violation_id":"253606969","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:17.000000Z","updated_at":"2025-03-17T21:29:17.000000Z","normalized_code":"3922"},{"id":4783125,"change_date":"2023-06-20 21:41:00","inspection_id":"78693605","insp_violation_id":"253606970","seq_no":"3","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"195590365","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:17.000000Z","updated_at":"2025-03-17T21:29:17.000000Z","normalized_code":"39360D"},{"id":4783126,"change_date":"2023-06-20 21:41:00","inspection_id":"78693605","insp_violation_id":"253606971","seq_no":"4","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"195590365","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:17.000000Z","updated_at":"2025-03-17T21:29:17.000000Z","normalized_code":"39311"},{"id":4783127,"change_date":"2023-06-20 21:41:00","inspection_id":"78693605","insp_violation_id":"253606972","seq_no":"5","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"195590366","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:17.000000Z","updated_at":"2025-03-17T21:29:17.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":5000937,"change_date":"2023-06-20 21:41:00","inspection_id":"78693605","insp_unit_id":"195590365","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"07","insp_unit_license":"YAJY490","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XPBP40X2HD354548","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:26.000000Z","updated_at":"2025-03-17T22:42:26.000000Z"},{"id":5000938,"change_date":"2023-06-20 21:41:00","inspection_id":"78693605","insp_unit_id":"195590366","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRIN","insp_unit_company":null,"insp_unit_license":"HU76183","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1T9SC5347DB656244","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:26.000000Z","updated_at":"2025-03-17T22:42:26.000000Z"}]},{"id":3071470,"change_date":"2023-05-17 21:43:00","inspection_id":"78651315","dot_number":"3901739","report_state":"WY","report_number":"PCAJ999999","insp_date":"2023-05-16 00:00:00","insp_start_time":"1654","insp_end_time":"1726","registration_date":null,"region":"MT","ci_status_code":"C","location":"ML25","location_desc":"CHEYENNE I-25 POE","county_code_state":"WY","county_code":"021","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ANHEUSER-BUSCH LLC","shipping_paper_number":"746323136673","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-17 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","viol_total":"2","oos_total":"2","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"431503","transaction_code":"A","transaction_date":"2023-05-17 00:00:00","upload_date":"2023-05-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03901739","upload_search_indicator":"M","census_search_date":"2023-05-17 21:43:00","snet_input_date":"2023-05-16 00:00:00","source_office":"4WYS001","mcmis_add_date":"2023-05-17 21:43:00","insp_carrier_name":"J MEDELEZ LLC","insp_carrier_street":"1300 E PUNKIN CENTER RD","insp_carrier_city":"HERMISTON","insp_carrier_state":"OR","insp_carrier_zip_code":"97838","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:23:47.000000Z","updated_at":"2025-03-17T19:23:47.000000Z","inspection_violations":[{"id":4720068,"change_date":"2023-05-17 21:43:00","inspection_id":"78651315","insp_violation_id":"252898339","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:29:01.000000Z","updated_at":"2025-03-17T21:29:01.000000Z","normalized_code":"3958A1"},{"id":4720069,"change_date":"2023-05-17 21:43:00","inspection_id":"78651315","insp_violation_id":"252898340","seq_no":"2","part_no":"392","part_no_section":"9a(a)(1)","insp_viol_unit":"2","insp_unit_id":"194990324","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:29:01.000000Z","updated_at":"2025-03-17T21:29:01.000000Z","normalized_code":"3929AA1"}],"inspection_per_units":[{"id":4941314,"change_date":"2023-05-17 21:43:00","inspection_id":"78651315","insp_unit_id":"194990323","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"42","insp_unit_license":"YAKA867","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XKYD49X7PJ235650","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:58.000000Z","updated_at":"2025-03-17T22:41:58.000000Z"},{"id":4941315,"change_date":"2023-05-17 21:43:00","inspection_id":"78651315","insp_unit_id":"194990324","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"329","insp_unit_license":"HU77891","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1UYVS253XEU070105","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:58.000000Z","updated_at":"2025-03-17T22:41:58.000000Z"}]},{"id":2750509,"change_date":"2023-04-06 21:40:00","inspection_id":"78288483","dot_number":"3901739","report_state":"MT","report_number":"L230002874","insp_date":"2023-04-05 00:00:00","insp_start_time":"1421","insp_end_time":"1444","registration_date":null,"region":"MT","ci_status_code":"C","location":"SHERID","location_desc":"SHERIDAN IN TOWN","county_code_state":"MT","county_code":"057","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"BUYAN RANCH","shipping_paper_number":"7141","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-04-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117300","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":"990535","transaction_code":"A","transaction_date":"2023-04-05 00:00:00","upload_date":"2023-04-06 00:00:00","upload_first_byte":"0","upload_dot_number":"03901739","upload_search_indicator":null,"census_search_date":"2023-04-06 21:40:00","snet_input_date":"2023-04-06 00:00:00","source_office":"4MTS001","mcmis_add_date":"2023-04-06 21:40:00","insp_carrier_name":"J MEDELEZ LLC","insp_carrier_street":"1300 E PUNKIN CENTER RD","insp_carrier_city":"HERMISTON","insp_carrier_state":"OR","insp_carrier_zip_code":"97838-7700","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:17:21.000000Z","updated_at":"2025-03-17T19:17:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4427069,"change_date":"2023-04-06 21:40:00","inspection_id":"78288483","insp_unit_id":"194265387","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"YAJY490","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XPBP40X8HD354548","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:51.000000Z","updated_at":"2025-03-17T22:37:51.000000Z"},{"id":4427070,"change_date":"2023-04-06 21:40:00","inspection_id":"78288483","insp_unit_id":"194265388","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRIN","insp_unit_company":null,"insp_unit_license":"HU76183","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1T9SC5347DB656244","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:51.000000Z","updated_at":"2025-03-17T22:37:51.000000Z"}]},{"id":2743299,"change_date":"2023-04-05 21:41:00","inspection_id":"78280217","dot_number":"3901739","report_state":"WA","report_number":"W419005094","insp_date":"2023-04-04 00:00:00","insp_start_time":"2048","insp_end_time":"2146","registration_date":null,"region":"PT","ci_status_code":"C","location":"SC64","location_desc":"SC64   EAST SPOKANE (POE)","county_code_state":"WA","county_code":"063","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"TRB DYKEMA LLC","shipping_paper_number":"1355","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-04-05 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"53500","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":"2562860","transaction_code":"A","transaction_date":"2023-04-04 00:00:00","upload_date":"2023-04-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03901739","upload_search_indicator":null,"census_search_date":"2023-04-05 21:41:00","snet_input_date":"2023-04-05 00:00:00","source_office":"4WAS001","mcmis_add_date":"2023-04-05 21:41:00","insp_carrier_name":"J MEDELEZ LLC","insp_carrier_street":"1300 E PUNKIN CENTER RD","insp_carrier_city":"HERMISTON","insp_carrier_state":"OR","insp_carrier_zip_code":"97838-7700","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:17:19.000000Z","updated_at":"2025-03-17T19:17:19.000000Z","inspection_violations":[{"id":4211447,"change_date":"2023-04-05 21:41:00","inspection_id":"78280217","insp_violation_id":"252069619","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:26:41.000000Z","updated_at":"2025-03-17T21:26:41.000000Z","normalized_code":"39524D"},{"id":4211448,"change_date":"2023-04-05 21:41:00","inspection_id":"78280217","insp_violation_id":"252069620","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194248632","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:41.000000Z","updated_at":"2025-03-17T21:26:41.000000Z","normalized_code":"3922"},{"id":4211449,"change_date":"2023-04-05 21:41:00","inspection_id":"78280217","insp_violation_id":"252069621","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194248632","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:41.000000Z","updated_at":"2025-03-17T21:26:41.000000Z","normalized_code":"3922"},{"id":4211450,"change_date":"2023-04-05 21:41:00","inspection_id":"78280217","insp_violation_id":"252069622","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"194248633","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"3A0331281","created_at":"2025-03-17T21:26:41.000000Z","updated_at":"2025-03-17T21:26:41.000000Z","normalized_code":"3922"},{"id":4211451,"change_date":"2023-04-05 21:41:00","inspection_id":"78280217","insp_violation_id":"252069623","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"194248633","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:41.000000Z","updated_at":"2025-03-17T21:26:41.000000Z","normalized_code":"3922"},{"id":4211452,"change_date":"2023-04-05 21:41:00","inspection_id":"78280217","insp_violation_id":"252069624","seq_no":"6","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194248632","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:41.000000Z","updated_at":"2025-03-17T21:26:41.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4416029,"change_date":"2023-04-05 21:41:00","inspection_id":"78280217","insp_unit_id":"194248632","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"003","insp_unit_license":"YAJW871","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XPXD49X8PD813047","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:46.000000Z","updated_at":"2025-03-17T22:37:46.000000Z"},{"id":4416030,"change_date":"2023-04-05 21:41:00","inspection_id":"78280217","insp_unit_id":"194248633","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"081","insp_unit_license":"HV67170","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1T9SC5346MB656185","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:46.000000Z","updated_at":"2025-03-17T22:37:46.000000Z"}]},{"id":2777626,"change_date":"2023-04-11 21:40:00","inspection_id":"78319214","dot_number":"3901739","report_state":"WA","report_number":"W405009658","insp_date":"2023-04-04 00:00:00","insp_start_time":"2054","insp_end_time":"2124","registration_date":null,"region":"PT","ci_status_code":"C","location":null,"location_desc":"LIBERTY LAKE.","county_code_state":"WA","county_code":"063","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"TRB DYKEMA LLC","shipping_paper_number":"1354","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-04-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"2563882","transaction_code":"A","transaction_date":"2023-04-04 00:00:00","upload_date":"2023-04-11 00:00:00","upload_first_byte":"0","upload_dot_number":"03901739","upload_search_indicator":null,"census_search_date":"2023-04-11 21:40:00","snet_input_date":"2023-04-11 00:00:00","source_office":"4WAS001","mcmis_add_date":"2023-04-11 21:40:00","insp_carrier_name":"J MEDELEZ LLC","insp_carrier_street":"1300 E PUNKIN CENTER RD","insp_carrier_city":"HERMISTON","insp_carrier_state":"OR","insp_carrier_zip_code":"97838-7700","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:17:44.000000Z","updated_at":"2025-03-17T19:17:44.000000Z","inspection_violations":[{"id":4263321,"change_date":"2023-04-11 21:40:00","inspection_id":"78319214","insp_violation_id":"252156477","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:26:57.000000Z","updated_at":"2025-03-17T21:26:57.000000Z","normalized_code":"3922"},{"id":4263322,"change_date":"2023-04-11 21:40:00","inspection_id":"78319214","insp_violation_id":"252156478","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:26:57.000000Z","updated_at":"2025-03-17T21:26:57.000000Z","normalized_code":"3958A1"}],"inspection_per_units":[{"id":4471295,"change_date":"2023-04-11 21:40:00","inspection_id":"78319214","insp_unit_id":"194327627","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"YAJH553","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1NPXP49X4MD710592","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:14.000000Z","updated_at":"2025-03-17T22:38:14.000000Z"},{"id":4471296,"change_date":"2023-04-11 21:40:00","inspection_id":"78319214","insp_unit_id":"194327628","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRIN","insp_unit_company":null,"insp_unit_license":"HU87994","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1T9SC5342FB656090","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:14.000000Z","updated_at":"2025-03-17T22:38:14.000000Z"}]},{"id":2501902,"change_date":"2023-03-03 21:40:00","inspection_id":"78005044","dot_number":"3901739","report_state":"AZ","report_number":"0321001476","insp_date":"2023-03-02 00:00:00","insp_start_time":"1731","insp_end_time":"1846","registration_date":null,"region":"MT","ci_status_code":"C","location":"611504","location_desc":"I10 MP 128 EB","county_code_state":"AZ","county_code":"013","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"E.W. BRANT & SONS INC","shipping_paper_number":"00170800","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-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"113000","viol_total":"9","oos_total":"0","driver_viol_total":"4","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1800975","transaction_code":"A","transaction_date":"2023-03-02 00:00:00","upload_date":"2023-03-03 00:00:00","upload_first_byte":"0","upload_dot_number":"03901739","upload_search_indicator":null,"census_search_date":"2023-03-03 21:40:00","snet_input_date":"2023-03-03 00:00:00","source_office":"4AZS001","mcmis_add_date":"2023-03-03 21:40:00","insp_carrier_name":"J MEDELEZ LLC","insp_carrier_street":"1300 E PUNKIN CENTER RD","insp_carrier_city":"HERMISTON","insp_carrier_state":"OR","insp_carrier_zip_code":"97838-7700","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:12:53.000000Z","updated_at":"2025-03-17T19:12:53.000000Z","inspection_violations":[{"id":3847501,"change_date":"2023-03-03 21:40:00","inspection_id":"78005044","insp_violation_id":"251468204","seq_no":"2","part_no":"395","part_no_section":"8","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:25:04.000000Z","updated_at":"2025-03-17T21:25:04.000000Z","normalized_code":"3958"},{"id":3847500,"change_date":"2023-03-03 21:40:00","inspection_id":"78005044","insp_violation_id":"251468203","seq_no":"1","part_no":"395","part_no_section":"24(c)(2)(ii)","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:25:04.000000Z","updated_at":"2025-03-17T21:25:04.000000Z","normalized_code":"39524C2II"},{"id":3847502,"change_date":"2023-03-03 21:40:00","inspection_id":"78005044","insp_violation_id":"251468205","seq_no":"3","part_no":"395","part_no_section":"22(h)(1)","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:25:04.000000Z","updated_at":"2025-03-17T21:25:04.000000Z","normalized_code":"39522H1"},{"id":3847503,"change_date":"2023-03-03 21:40:00","inspection_id":"78005044","insp_violation_id":"251468206","seq_no":"4","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":null,"created_at":"2025-03-17T21:25:04.000000Z","updated_at":"2025-03-17T21:25:04.000000Z","normalized_code":"39522H4"},{"id":3847504,"change_date":"2023-03-03 21:40:00","inspection_id":"78005044","insp_violation_id":"251468207","seq_no":"5","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"193698817","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:04.000000Z","updated_at":"2025-03-17T21:25:04.000000Z","normalized_code":"39360D"},{"id":3847505,"change_date":"2023-03-03 21:40:00","inspection_id":"78005044","insp_violation_id":"251468208","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193698817","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:04.000000Z","updated_at":"2025-03-17T21:25:04.000000Z","normalized_code":"3939A"},{"id":3847506,"change_date":"2023-03-03 21:40:00","inspection_id":"78005044","insp_violation_id":"251468209","seq_no":"7","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"193698817","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:04.000000Z","updated_at":"2025-03-17T21:25:04.000000Z","normalized_code":"39617C"},{"id":3847507,"change_date":"2023-03-03 21:40:00","inspection_id":"78005044","insp_violation_id":"251468210","seq_no":"8","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"193698818","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:04.000000Z","updated_at":"2025-03-17T21:25:04.000000Z","normalized_code":"39617C"},{"id":3847508,"change_date":"2023-03-03 21:40:00","inspection_id":"78005044","insp_violation_id":"251468211","seq_no":"9","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"193698818","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:04.000000Z","updated_at":"2025-03-17T21:25:04.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":4026027,"change_date":"2023-03-03 21:40:00","inspection_id":"78005044","insp_unit_id":"193698817","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"24","insp_unit_license":"YAJE347","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XKYD49X3KJ220278","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:52.000000Z","updated_at":"2025-03-17T22:34:52.000000Z"},{"id":4026028,"change_date":"2023-03-03 21:40:00","inspection_id":"78005044","insp_unit_id":"193698818","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"319","insp_unit_license":"HV16237","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1UYVS2537J2254648","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:52.000000Z","updated_at":"2025-03-17T22:34:52.000000Z"}]},{"id":2424702,"change_date":"2023-02-22 21:40:00","inspection_id":"77917411","dot_number":"3901739","report_state":"WA","report_number":"W331002908","insp_date":"2023-02-21 00:00:00","insp_start_time":"1030","insp_end_time":"1115","registration_date":null,"region":"PT","ci_status_code":"C","location":"SC54","location_desc":"SC54   PLYMOUTH (POE)","county_code_state":"WA","county_code":"005","insp_level_id":"2","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-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"129600","viol_total":"5","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2554279","transaction_code":"A","transaction_date":"2023-02-21 00:00:00","upload_date":"2023-02-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03901739","upload_search_indicator":null,"census_search_date":"2023-02-22 21:40:00","snet_input_date":"2023-02-22 00:00:00","source_office":"4WAS001","mcmis_add_date":"2023-02-22 21:40:00","insp_carrier_name":"J MEDELEZ LLC","insp_carrier_street":"1300 E PUNKIN CENTER RD","insp_carrier_city":"HERMISTON","insp_carrier_state":"OR","insp_carrier_zip_code":"97838-7700","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:11:24.000000Z","updated_at":"2025-03-17T19:11:24.000000Z","inspection_violations":[{"id":3733761,"change_date":"2023-02-22 21:40:00","inspection_id":"77917411","insp_violation_id":"251275069","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:24:35.000000Z","updated_at":"2025-03-17T21:24:35.000000Z","normalized_code":"3922"},{"id":3733762,"change_date":"2023-02-22 21:40:00","inspection_id":"77917411","insp_violation_id":"251275070","seq_no":"2","part_no":"376","part_no_section":"11(d)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:35.000000Z","updated_at":"2025-03-17T21:24:35.000000Z","normalized_code":"37611D1"},{"id":3733763,"change_date":"2023-02-22 21:40:00","inspection_id":"77917411","insp_violation_id":"251275071","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"193524113","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:35.000000Z","updated_at":"2025-03-17T21:24:35.000000Z","normalized_code":"39378"},{"id":3733764,"change_date":"2023-02-22 21:40:00","inspection_id":"77917411","insp_violation_id":"251275072","seq_no":"4","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"193524113","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:35.000000Z","updated_at":"2025-03-17T21:24:35.000000Z","normalized_code":"39395F"},{"id":3733765,"change_date":"2023-02-22 21:40:00","inspection_id":"77917411","insp_violation_id":"251275073","seq_no":"5","part_no":"396","part_no_section":"9(d)(2)","insp_viol_unit":"1","insp_unit_id":"193524113","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:35.000000Z","updated_at":"2025-03-17T21:24:35.000000Z","normalized_code":"3969D2"}],"inspection_per_units":[{"id":3902681,"change_date":"2023-02-22 21:40:00","inspection_id":"77917411","insp_unit_id":"193524113","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"64","insp_unit_license":"YAJH918","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XPBPP9X4KD627825","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:57.000000Z","updated_at":"2025-03-17T22:33:57.000000Z"},{"id":3902682,"change_date":"2023-02-22 21:40:00","inspection_id":"77917411","insp_unit_id":"193524114","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRIN","insp_unit_company":"15","insp_unit_license":"HV65321","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1T9SC5346JB656098","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:57.000000Z","updated_at":"2025-03-17T22:33:57.000000Z"}]},{"id":2359628,"change_date":"2023-02-13 21:43:00","inspection_id":"77842814","dot_number":"3901739","report_state":"WA","report_number":"W339000845","insp_date":"2023-02-10 00:00:00","insp_start_time":"1215","insp_end_time":"1320","registration_date":null,"region":"PT","ci_status_code":"C","location":"31199","location_desc":"SR 395 ROADSIDE FRANKLIN","county_code_state":"WA","county_code":"021","insp_level_id":"1","service_center":"WE","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":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-02-13 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"123000","viol_total":"15","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"15","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2551915","transaction_code":"A","transaction_date":"2023-02-10 00:00:00","upload_date":"2023-02-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03901739","upload_search_indicator":null,"census_search_date":"2023-02-13 21:43:00","snet_input_date":"2023-02-13 00:00:00","source_office":"4WAS001","mcmis_add_date":"2023-02-13 21:43:00","insp_carrier_name":"J MEDELEZ LLC","insp_carrier_street":"1300 E PUNKIN CENTER RD","insp_carrier_city":"HERMISTON","insp_carrier_state":"OR","insp_carrier_zip_code":"97838-7700","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:10:01.000000Z","updated_at":"2025-03-17T19:10:01.000000Z","inspection_violations":[{"id":3634334,"change_date":"2023-02-13 21:43:00","inspection_id":"77842814","insp_violation_id":"251105691","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193373018","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:07.000000Z","updated_at":"2025-03-17T21:24:07.000000Z","normalized_code":"3922"},{"id":3634335,"change_date":"2023-02-13 21:43:00","inspection_id":"77842814","insp_violation_id":"251105692","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"193373019","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:07.000000Z","updated_at":"2025-03-17T21:24:07.000000Z","normalized_code":"39617C"},{"id":3634336,"change_date":"2023-02-13 21:43:00","inspection_id":"77842814","insp_violation_id":"251105693","seq_no":"3","part_no":"393","part_no_section":"100(b)","insp_viol_unit":"2","insp_unit_id":"193373019","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:24:07.000000Z","updated_at":"2025-03-17T21:24:07.000000Z","normalized_code":"393100B"},{"id":3634337,"change_date":"2023-02-13 21:43:00","inspection_id":"77842814","insp_violation_id":"251105694","seq_no":"4","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"193373019","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:07.000000Z","updated_at":"2025-03-17T21:24:07.000000Z","normalized_code":"39311"},{"id":3634338,"change_date":"2023-02-13 21:43:00","inspection_id":"77842814","insp_violation_id":"251105695","seq_no":"5","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"193373019","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:07.000000Z","updated_at":"2025-03-17T21:24:07.000000Z","normalized_code":"3963A1"},{"id":3634339,"change_date":"2023-02-13 21:43:00","inspection_id":"77842814","insp_violation_id":"251105696","seq_no":"6","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"193373019","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:07.000000Z","updated_at":"2025-03-17T21:24:07.000000Z","normalized_code":"39347E"},{"id":3634340,"change_date":"2023-02-13 21:43:00","inspection_id":"77842814","insp_violation_id":"251105697","seq_no":"7","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"193373019","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:07.000000Z","updated_at":"2025-03-17T21:24:07.000000Z","normalized_code":"39353B"},{"id":3634341,"change_date":"2023-02-13 21:43:00","inspection_id":"77842814","insp_violation_id":"251105698","seq_no":"8","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"193373019","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:07.000000Z","updated_at":"2025-03-17T21:24:07.000000Z","normalized_code":"39347E"},{"id":3634342,"change_date":"2023-02-13 21:43:00","inspection_id":"77842814","insp_violation_id":"251105699","seq_no":"9","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"193373019","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:07.000000Z","updated_at":"2025-03-17T21:24:07.000000Z","normalized_code":"39348A"},{"id":3634343,"change_date":"2023-02-13 21:43:00","inspection_id":"77842814","insp_violation_id":"251105700","seq_no":"10","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"193373019","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:07.000000Z","updated_at":"2025-03-17T21:24:07.000000Z","normalized_code":"39348A"},{"id":3634344,"change_date":"2023-02-13 21:43:00","inspection_id":"77842814","insp_violation_id":"251105701","seq_no":"11","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"193373019","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:07.000000Z","updated_at":"2025-03-17T21:24:07.000000Z","normalized_code":"39348A"},{"id":3634345,"change_date":"2023-02-13 21:43:00","inspection_id":"77842814","insp_violation_id":"251105702","seq_no":"12","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"193373019","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:07.000000Z","updated_at":"2025-03-17T21:24:07.000000Z","normalized_code":"39348A"},{"id":3634346,"change_date":"2023-02-13 21:43:00","inspection_id":"77842814","insp_violation_id":"251105703","seq_no":"13","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"193373019","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:07.000000Z","updated_at":"2025-03-17T21:24:07.000000Z","normalized_code":"39347E"},{"id":3634347,"change_date":"2023-02-13 21:43:00","inspection_id":"77842814","insp_violation_id":"251105704","seq_no":"14","part_no":"393","part_no_section":"30","insp_viol_unit":"2","insp_unit_id":"193373019","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:07.000000Z","updated_at":"2025-03-17T21:24:07.000000Z","normalized_code":"39330"},{"id":3634348,"change_date":"2023-02-13 21:43:00","inspection_id":"77842814","insp_violation_id":"251105705","seq_no":"15","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"2","insp_unit_id":"193373019","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:07.000000Z","updated_at":"2025-03-17T21:24:07.000000Z","normalized_code":"39345D"}],"inspection_per_units":[{"id":3797797,"change_date":"2023-02-13 21:43:00","inspection_id":"77842814","insp_unit_id":"193373018","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"5","insp_unit_license":"YAJX908","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XKYP49X1JJ198769","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:12.000000Z","updated_at":"2025-03-17T22:33:12.000000Z"},{"id":3797798,"change_date":"2023-02-13 21:43:00","inspection_id":"77842814","insp_unit_id":"193373019","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRIN","insp_unit_company":"12","insp_unit_license":"HU31236","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1T9SC53407B656204","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:12.000000Z","updated_at":"2025-03-17T22:33:12.000000Z"}]},{"id":2116953,"change_date":"2023-01-11 21:43:00","inspection_id":"77565832","dot_number":"3901739","report_state":"WA","report_number":"W326003963","insp_date":"2023-01-09 00:00:00","insp_start_time":"1345","insp_end_time":"1440","registration_date":null,"region":"PT","ci_status_code":"C","location":null,"location_desc":"S\/B 395","county_code_state":"WA","county_code":"021","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"SIMPLOT","shipping_paper_number":"22016146","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-01-11 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"124000","viol_total":"7","oos_total":"4","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"4","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2544959","transaction_code":"A","transaction_date":"2023-01-09 00:00:00","upload_date":"2023-01-11 00:00:00","upload_first_byte":"0","upload_dot_number":"03901739","upload_search_indicator":null,"census_search_date":"2023-01-11 21:43:00","snet_input_date":"2023-01-11 00:00:00","source_office":"4WAS001","mcmis_add_date":"2023-01-11 21:43:00","insp_carrier_name":"J MEDELEZ LLC","insp_carrier_street":"1300 E PUNKIN CENTER RD","insp_carrier_city":"HERMISTON","insp_carrier_state":"OR","insp_carrier_zip_code":"97838-7700","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:05:33.000000Z","updated_at":"2025-03-17T19:05:33.000000Z","inspection_violations":[{"id":3277869,"change_date":"2023-01-11 21:43:00","inspection_id":"77565832","insp_violation_id":"250512818","seq_no":"1","part_no":"392","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"192815141","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:22:29.000000Z","updated_at":"2025-03-17T21:22:29.000000Z","normalized_code":"3929A"},{"id":3277870,"change_date":"2023-01-11 21:43:00","inspection_id":"77565832","insp_violation_id":"250512819","seq_no":"2","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"192815141","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:22:29.000000Z","updated_at":"2025-03-17T21:22:29.000000Z","normalized_code":"39375A3"},{"id":3277871,"change_date":"2023-01-11 21:43:00","inspection_id":"77565832","insp_violation_id":"250512820","seq_no":"3","part_no":"393","part_no_section":"201(a)","insp_viol_unit":"2","insp_unit_id":"192815141","insp_violation_category_id":"19","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:22:29.000000Z","updated_at":"2025-03-17T21:22:29.000000Z","normalized_code":"393201A"},{"id":3277872,"change_date":"2023-01-11 21:43:00","inspection_id":"77565832","insp_violation_id":"250512821","seq_no":"4","part_no":"393","part_no_section":"201(a)","insp_viol_unit":"2","insp_unit_id":"192815141","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:29.000000Z","updated_at":"2025-03-17T21:22:29.000000Z","normalized_code":"393201A"},{"id":3277873,"change_date":"2023-01-11 21:43:00","inspection_id":"77565832","insp_violation_id":"250512822","seq_no":"5","part_no":"393","part_no_section":"201(a)","insp_viol_unit":"2","insp_unit_id":"192815141","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:29.000000Z","updated_at":"2025-03-17T21:22:29.000000Z","normalized_code":"393201A"},{"id":3277874,"change_date":"2023-01-11 21:43:00","inspection_id":"77565832","insp_violation_id":"250512823","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"192815141","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:22:29.000000Z","updated_at":"2025-03-17T21:22:29.000000Z","normalized_code":"3939A"},{"id":3277875,"change_date":"2023-01-11 21:43:00","inspection_id":"77565832","insp_violation_id":"250512824","seq_no":"7","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":"3A0009507","created_at":"2025-03-17T21:22:29.000000Z","updated_at":"2025-03-17T21:22:29.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3407345,"change_date":"2023-01-11 21:43:00","inspection_id":"77565832","insp_unit_id":"192815140","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"YAJX908","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XKYP49X1JJ198769","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:25.000000Z","updated_at":"2025-03-17T22:30:25.000000Z"},{"id":3407346,"change_date":"2023-01-11 21:43:00","inspection_id":"77565832","insp_unit_id":"192815141","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRIN","insp_unit_company":"06","insp_unit_license":"HU23227","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1T9SC53497B656105","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:25.000000Z","updated_at":"2025-03-17T22:30:25.000000Z"}]},{"id":2006110,"change_date":"2022-12-22 21:40:00","inspection_id":"77439126","dot_number":"3901739","report_state":"WA","report_number":"W326003926","insp_date":"2022-12-21 00:00:00","insp_start_time":"0935","insp_end_time":"1020","registration_date":null,"region":"PT","ci_status_code":"C","location":null,"location_desc":"N\/B 395","county_code_state":"WA","county_code":"021","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"SIMPLOT","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":"2022-12-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"138500","viol_total":"6","oos_total":"2","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2541875","transaction_code":"A","transaction_date":"2022-12-21 00:00:00","upload_date":"2022-12-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03901739","upload_search_indicator":null,"census_search_date":"2022-12-22 21:40:00","snet_input_date":"2022-12-22 00:00:00","source_office":"4WAS001","mcmis_add_date":"2022-12-22 21:40:00","insp_carrier_name":"J MEDELEZ LLC","insp_carrier_street":"1300 E PUNKIN CENTER RD","insp_carrier_city":"HERMISTON","insp_carrier_state":"OR","insp_carrier_zip_code":"97838-7700","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:03:39.000000Z","updated_at":"2025-03-17T19:03:39.000000Z","inspection_violations":[{"id":3114124,"change_date":"2022-12-22 21:40:00","inspection_id":"77439126","insp_violation_id":"250246685","seq_no":"1","part_no":"383","part_no_section":"21","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:21:45.000000Z","updated_at":"2025-03-17T21:21:45.000000Z","normalized_code":"38321"},{"id":3114125,"change_date":"2022-12-22 21:40:00","inspection_id":"77439126","insp_violation_id":"250246686","seq_no":"2","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:45.000000Z","updated_at":"2025-03-17T21:21:45.000000Z","normalized_code":"38323A2"},{"id":3114126,"change_date":"2022-12-22 21:40:00","inspection_id":"77439126","insp_violation_id":"250246687","seq_no":"3","part_no":"393","part_no_section":"100(b)","insp_viol_unit":"2","insp_unit_id":"192561640","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"2A0729869","created_at":"2025-03-17T21:21:45.000000Z","updated_at":"2025-03-17T21:21:45.000000Z","normalized_code":"393100B"},{"id":3114127,"change_date":"2022-12-22 21:40:00","inspection_id":"77439126","insp_violation_id":"250246688","seq_no":"4","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"192561640","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:45.000000Z","updated_at":"2025-03-17T21:21:45.000000Z","normalized_code":"39375C"},{"id":3114128,"change_date":"2022-12-22 21:40:00","inspection_id":"77439126","insp_violation_id":"250246689","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"192561640","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:45.000000Z","updated_at":"2025-03-17T21:21:45.000000Z","normalized_code":"3939A"},{"id":3114129,"change_date":"2022-12-22 21:40:00","inspection_id":"77439126","insp_violation_id":"250246690","seq_no":"6","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"192561640","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:45.000000Z","updated_at":"2025-03-17T21:21:45.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3227531,"change_date":"2022-12-22 21:40:00","inspection_id":"77439126","insp_unit_id":"192561639","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"06","insp_unit_license":"YAJY489","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XPBP40X6HD364547","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:06.000000Z","updated_at":"2025-03-17T22:29:06.000000Z"},{"id":3227532,"change_date":"2022-12-22 21:40:00","inspection_id":"77439126","insp_unit_id":"192561640","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRIN","insp_unit_company":"37","insp_unit_license":"HS94970","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1T9SC53405B656121","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:06.000000Z","updated_at":"2025-03-17T22:29:06.000000Z"}]},{"id":1962680,"change_date":"2022-12-16 21:40:00","inspection_id":"77389630","dot_number":"3901739","report_state":"WA","report_number":"W339000728","insp_date":"2022-12-15 00:00:00","insp_start_time":"1645","insp_end_time":"1800","registration_date":null,"region":"PT","ci_status_code":"C","location":"31199","location_desc":"SR 395 ROADSIDE FRANKLIN","county_code_state":"WA","county_code":"021","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"SIMPLOT","shipping_paper_number":"19028932","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-12-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"123000","viol_total":"5","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2540762","transaction_code":"A","transaction_date":"2022-12-15 00:00:00","upload_date":"2022-12-16 00:00:00","upload_first_byte":"0","upload_dot_number":"03901739","upload_search_indicator":null,"census_search_date":"2022-12-16 21:40:00","snet_input_date":"2022-12-16 00:00:00","source_office":"4WAS001","mcmis_add_date":"2022-12-16 21:40:00","insp_carrier_name":"J MEDELEZ LLC","insp_carrier_street":"1300 E PUNKIN CENTER RD","insp_carrier_city":"HERMISTON","insp_carrier_state":"OR","insp_carrier_zip_code":"97838-7700","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:02:54.000000Z","updated_at":"2025-03-17T19:02:54.000000Z","inspection_violations":[{"id":3047814,"change_date":"2022-12-16 21:40:00","inspection_id":"77389630","insp_violation_id":"250139056","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"192463704","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:30.000000Z","updated_at":"2025-03-17T21:21:30.000000Z","normalized_code":"3922"},{"id":3047815,"change_date":"2022-12-16 21:40:00","inspection_id":"77389630","insp_violation_id":"250139057","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"192463704","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"2A0722299","created_at":"2025-03-17T21:21:30.000000Z","updated_at":"2025-03-17T21:21:30.000000Z","normalized_code":"3922"},{"id":3047816,"change_date":"2022-12-16 21:40:00","inspection_id":"77389630","insp_violation_id":"250139058","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"192463704","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:30.000000Z","updated_at":"2025-03-17T21:21:30.000000Z","normalized_code":"3922"},{"id":3047817,"change_date":"2022-12-16 21:40:00","inspection_id":"77389630","insp_violation_id":"250139059","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"192463705","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:30.000000Z","updated_at":"2025-03-17T21:21:30.000000Z","normalized_code":"3922"},{"id":3047818,"change_date":"2022-12-16 21:40:00","inspection_id":"77389630","insp_violation_id":"250139060","seq_no":"5","part_no":"393","part_no_section":"100(b)","insp_viol_unit":"2","insp_unit_id":"192463705","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:21:30.000000Z","updated_at":"2025-03-17T21:21:30.000000Z","normalized_code":"393100B"}],"inspection_per_units":[{"id":3158274,"change_date":"2022-12-16 21:40:00","inspection_id":"77389630","insp_unit_id":"192463704","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"02","insp_unit_license":"YAJW689","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XKYP49X5JJ198774","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:37.000000Z","updated_at":"2025-03-17T22:28:37.000000Z"},{"id":3158275,"change_date":"2022-12-16 21:40:00","inspection_id":"77389630","insp_unit_id":"192463705","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRIN","insp_unit_company":"105","insp_unit_license":"HU82091","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1T9SC5032EB656259","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:37.000000Z","updated_at":"2025-03-17T22:28:37.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3901739\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3901739\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3901739\/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\/3901739\/inspections","per_page":100,"prev_page_url":null,"to":35,"total":35}