{"current_page":1,"data":[{"id":11509370,"change_date":"2026-03-29 21:33:00","inspection_id":"87429878","dot_number":"235869","report_state":"WA","report_number":"2111001310","insp_date":"2026-03-24 00:00:00","insp_start_time":"1415","insp_end_time":"1435","registration_date":null,"region":"PD","ci_status_code":"C","location":"SC40","location_desc":"GRANDVIEW WA","county_code_state":"WA","county_code":"005","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-03-29 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3082771","transaction_code":"A","transaction_date":"2026-03-28 00:00:00","upload_date":"2026-03-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00235869","upload_search_indicator":null,"census_search_date":"2026-03-29 21:33:00","snet_input_date":"2026-03-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-29 21:33:00","insp_carrier_name":"COCA COLA BOTTLING COMPANY OF YAKIMA & TRICITIES","insp_carrier_street":"607 E R STREET","insp_carrier_city":"YAKIMA","insp_carrier_state":"WA","insp_carrier_zip_code":"98901","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-04-01T09:51:43.000000Z","updated_at":"2026-04-09T09:30:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19717196,"change_date":"2026-03-29 21:33:00","inspection_id":"87429878","insp_unit_id":"212408312","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAILMOBIL","insp_unit_company":"3232P","insp_unit_license":"6742ZH","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"2MN01JAH651009514","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-01T09:37:03.000000Z","updated_at":"2026-04-09T09:08:20.000000Z"},{"id":19717197,"change_date":"2026-03-29 21:33:00","inspection_id":"87429878","insp_unit_id":"212408313","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"490","insp_unit_license":"B424115","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"4V4NC9TG35N383022","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-01T09:37:03.000000Z","updated_at":"2026-04-09T09:08:20.000000Z"}]},{"id":11339577,"change_date":"2026-03-11 21:38:00","inspection_id":"87257079","dot_number":"235869","report_state":"WA","report_number":"1158004544","insp_date":"2026-03-06 00:00:00","insp_start_time":"1229","insp_end_time":"1300","registration_date":null,"region":"PS","ci_status_code":"C","location":null,"location_desc":"SELAH WA","county_code_state":"WA","county_code":"077","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-03-11 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"90000","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":"2989104","transaction_code":"A","transaction_date":"2026-03-10 00:00:00","upload_date":"2026-03-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00235869","upload_search_indicator":null,"census_search_date":"2026-03-11 21:38:00","snet_input_date":"2026-03-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-11 21:38:00","insp_carrier_name":"COCA COLA BOTTLING COMPANY OF YAKIMA & TRICITIES","insp_carrier_street":"607 E R STREET","insp_carrier_city":"YAKIMA","insp_carrier_state":"WA","insp_carrier_zip_code":"98901","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-03-14T09:38:13.000000Z","updated_at":"2026-03-22T09:30:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19405859,"change_date":"2026-03-11 21:38:00","inspection_id":"87257079","insp_unit_id":"212074559","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"045","insp_unit_license":"C40339A","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"4V4MC9GH37N478908","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-14T09:14:50.000000Z","updated_at":"2026-03-22T09:09:45.000000Z"},{"id":19405860,"change_date":"2026-03-11 21:38:00","inspection_id":"87257079","insp_unit_id":"212074560","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"81162AC","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1C91ARG19TC002024","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-14T09:14:50.000000Z","updated_at":"2026-03-22T09:09:45.000000Z"}]},{"id":11321836,"change_date":"2026-05-18 21:39:00","inspection_id":"87238530","dot_number":"235869","report_state":"WA","report_number":"0813001767","insp_date":"2026-03-04 00:00:00","insp_start_time":"0945","insp_end_time":"1010","registration_date":null,"region":"PS","ci_status_code":"C","location":null,"location_desc":"KENNEWICK WA","county_code_state":"WA","county_code":"005","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-03-09 21:36:00","post_acc_ind":"N","gross_comb_veh_wt":"63000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2980403","transaction_code":"C","transaction_date":"2026-03-08 00:00:00","upload_date":"2026-05-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00235869","upload_search_indicator":null,"census_search_date":"2026-03-09 21:36:00","snet_input_date":"2026-03-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-09 21:36:00","insp_carrier_name":"COCA COLA BOTTLING COMPANY OF YAKIMA & TRICITIES","insp_carrier_street":"607 E R STREET","insp_carrier_city":"YAKIMA","insp_carrier_state":"WA","insp_carrier_zip_code":"98901","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-03-12T09:40:19.000000Z","updated_at":"2026-05-29T09:30:04.000000Z","inspection_violations":[{"id":19056612,"change_date":"2026-03-09 21:36:00","inspection_id":"87238530","insp_violation_id":"272283135","seq_no":"4","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"212038360","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-12T10:01:38.000000Z","updated_at":"2026-03-20T09:43:11.000000Z","normalized_code":"39617CPI"},{"id":19056609,"change_date":"2026-05-18 21:39:00","inspection_id":"87238530","insp_violation_id":"274327707","seq_no":"1","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"2","insp_unit_id":"213613557","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-12T10:01:38.000000Z","updated_at":"2026-05-29T09:40:18.000000Z","normalized_code":"3939ALLPL"},{"id":19056610,"change_date":"2026-05-18 21:39:00","inspection_id":"87238530","insp_violation_id":"274327708","seq_no":"2","part_no":"393","part_no_section":"9A-LSLI","insp_viol_unit":"2","insp_unit_id":"213613557","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-12T10:01:38.000000Z","updated_at":"2026-05-29T09:40:18.000000Z","normalized_code":"3939ALSLI"},{"id":19056611,"change_date":"2026-05-18 21:39:00","inspection_id":"87238530","insp_violation_id":"274327709","seq_no":"3","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"213613557","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-12T10:01:38.000000Z","updated_at":"2026-05-29T09:40:18.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":19371134,"change_date":"2026-05-18 21:39:00","inspection_id":"87238530","insp_unit_id":"213613556","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"D61437H","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"3HCEUTAN5RL745948","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-12T09:21:03.000000Z","updated_at":"2026-05-29T09:01:54.000000Z"},{"id":19371135,"change_date":"2026-05-18 21:39:00","inspection_id":"87238530","insp_unit_id":"213613557","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HESSE CORP","insp_unit_company":null,"insp_unit_license":"7044SN","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1H9RA1213EH008307","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-12T09:21:03.000000Z","updated_at":"2026-05-29T09:01:54.000000Z"}]},{"id":8519441,"change_date":"2025-05-01 21:40:00","inspection_id":"84550737","dot_number":"235869","report_state":"WA","report_number":"1158004227","insp_date":"2025-04-29 00:00:00","insp_start_time":"1500","insp_end_time":"1520","registration_date":null,"region":"PD","ci_status_code":"C","location":"30399","location_desc":"GRANDVIEW WA","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":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-05-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"114960","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":"1669302","transaction_code":"A","transaction_date":"2025-05-01 00:00:00","upload_date":"2025-05-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00235869","upload_search_indicator":null,"census_search_date":"2025-05-01 21:40:00","snet_input_date":"2025-04-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-01 21:40:00","insp_carrier_name":"COCA COLA BOTTLING COMPANY OF YAKIMA & TRICITIES","insp_carrier_street":"607 E R STREET","insp_carrier_city":"YAKIMA","insp_carrier_state":"WA","insp_carrier_zip_code":"98901","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-05-04T10:34:30.000000Z","updated_at":"2025-05-05T10:11:26.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13850008,"change_date":"2025-05-01 21:40:00","inspection_id":"84550737","insp_unit_id":"206588211","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"490","insp_unit_license":"B42411S","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"4V4NC9TG35N383022","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-04T10:18:04.000000Z","updated_at":"2025-05-05T09:51:47.000000Z"},{"id":13850009,"change_date":"2025-05-01 21:40:00","inspection_id":"84550737","insp_unit_id":"206588212","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAILMOBIL","insp_unit_company":"3232P","insp_unit_license":"6742ZH","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"2MN01JAH651009514","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-04T10:18:04.000000Z","updated_at":"2025-05-05T09:51:47.000000Z"}]},{"id":7301832,"change_date":"2024-11-29 21:34:00","inspection_id":"83270531","dot_number":"235869","report_state":"WA","report_number":"0813000809","insp_date":"2024-11-27 00:00:00","insp_start_time":"1115","insp_end_time":"1150","registration_date":null,"region":"PS","ci_status_code":"C","location":null,"location_desc":"KENNEWICK WA","county_code_state":"WA","county_code":"005","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"MULTIPLE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-11-29 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"77100","viol_total":"4","oos_total":"2","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1106064","transaction_code":"A","transaction_date":"2024-11-29 00:00:00","upload_date":"2024-11-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00235869","upload_search_indicator":null,"census_search_date":"2024-11-29 21:34:00","snet_input_date":"2024-11-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-29 21:34:00","insp_carrier_name":"COCA COLA BOTTLING COMPANY OF YAKIMA & TRICITIES","insp_carrier_street":"607 E R STREET","insp_carrier_city":"YAKIMA","insp_carrier_state":"WA","insp_carrier_zip_code":"98901","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:48:32.000000Z","updated_at":"2025-03-17T20:48:32.000000Z","inspection_violations":[{"id":11418285,"change_date":"2024-11-29 21:34:00","inspection_id":"83270531","insp_violation_id":"263144248","seq_no":"1","part_no":"392","part_no_section":"9AA1","insp_viol_unit":"1","insp_unit_id":"204101934","insp_violation_category_id":"51","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:01:28.000000Z","updated_at":"2025-03-17T22:01:28.000000Z","normalized_code":"3929AA1"},{"id":11418286,"change_date":"2024-11-29 21:34:00","inspection_id":"83270531","insp_violation_id":"263144249","seq_no":"2","part_no":"392","part_no_section":"16-D","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:28.000000Z","updated_at":"2025-03-17T22:01:28.000000Z","normalized_code":"39216D"},{"id":11418287,"change_date":"2024-11-29 21:34:00","inspection_id":"83270531","insp_violation_id":"263144250","seq_no":"3","part_no":"391","part_no_section":"41A-MCPC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:28.000000Z","updated_at":"2025-03-17T22:01:28.000000Z","normalized_code":"39141AMCPC"},{"id":11418288,"change_date":"2024-11-29 21:34:00","inspection_id":"83270531","insp_violation_id":"263144251","seq_no":"4","part_no":"383","part_no_section":"23A2-LCDLN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:28.000000Z","updated_at":"2025-03-17T22:01:28.000000Z","normalized_code":"38323A2LCDLN"}],"inspection_per_units":[{"id":11778605,"change_date":"2024-11-29 21:34:00","inspection_id":"83270531","insp_unit_id":"204101934","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"D88153C","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1HSHBAHR4TH253440","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:04.000000Z","updated_at":"2025-03-17T23:45:04.000000Z"},{"id":11778606,"change_date":"2024-11-29 21:34:00","inspection_id":"83270531","insp_unit_id":"204101935","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HESSE CORP","insp_unit_company":null,"insp_unit_license":"7044SN","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1H9RA1213EH008307","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:04.000000Z","updated_at":"2025-03-17T23:45:04.000000Z"}]},{"id":7158800,"change_date":"2024-11-09 21:33:00","inspection_id":"83119140","dot_number":"235869","report_state":"WA","report_number":"2110006270","insp_date":"2024-11-07 00:00:00","insp_start_time":"0625","insp_end_time":"0715","registration_date":null,"region":"PS","ci_status_code":"C","location":null,"location_desc":"BENTON CITY WA","county_code_state":"WA","county_code":"005","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"110724 RT 10","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-11-09 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"117961","viol_total":"7","oos_total":"1","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1036166","transaction_code":"A","transaction_date":"2024-11-09 00:00:00","upload_date":"2024-11-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00235869","upload_search_indicator":null,"census_search_date":"2024-11-09 21:33:00","snet_input_date":"2024-11-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-09 21:33:00","insp_carrier_name":"COCA COLA BOTTLING COMPANY OF YAKIMA & TRICITIES","insp_carrier_street":"607 E R STREET","insp_carrier_city":"YAKIMA","insp_carrier_state":"WA","insp_carrier_zip_code":"98901","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:45:10.000000Z","updated_at":"2025-03-17T20:45:10.000000Z","inspection_violations":[{"id":11184026,"change_date":"2024-11-09 21:33:00","inspection_id":"83119140","insp_violation_id":"262816666","seq_no":"1","part_no":"392","part_no_section":"2-SLLIRP","insp_viol_unit":"1","insp_unit_id":"203811366","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:17.000000Z","updated_at":"2025-03-17T22:00:17.000000Z","normalized_code":"3922SLLIRP"},{"id":11184027,"change_date":"2024-11-09 21:33:00","inspection_id":"83119140","insp_violation_id":"262816667","seq_no":"2","part_no":"393","part_no_section":"9A-LSML","insp_viol_unit":"2","insp_unit_id":"203811367","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:17.000000Z","updated_at":"2025-03-17T22:00:17.000000Z","normalized_code":"3939ALSML"},{"id":11184028,"change_date":"2024-11-09 21:33:00","inspection_id":"83119140","insp_violation_id":"262816668","seq_no":"3","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"2","insp_unit_id":"203811367","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:17.000000Z","updated_at":"2025-03-17T22:00:17.000000Z","normalized_code":"3939ALLPL"},{"id":11184029,"change_date":"2024-11-09 21:33:00","inspection_id":"83119140","insp_violation_id":"262816669","seq_no":"4","part_no":"393","part_no_section":"11A1-CSLRR","insp_viol_unit":"1","insp_unit_id":"203811366","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:17.000000Z","updated_at":"2025-03-17T22:00:17.000000Z","normalized_code":"39311A1CSLRR"},{"id":11184030,"change_date":"2024-11-09 21:33:00","inspection_id":"83119140","insp_violation_id":"262816670","seq_no":"5","part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"2","insp_unit_id":"203811367","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:17.000000Z","updated_at":"2025-03-17T22:00:17.000000Z","normalized_code":"3939ALRLI"},{"id":11184031,"change_date":"2024-11-09 21:33:00","inspection_id":"83119140","insp_violation_id":"262816671","seq_no":"6","part_no":"383","part_no_section":"71C-LCDL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:17.000000Z","updated_at":"2025-03-17T22:00:17.000000Z","normalized_code":"38371CLCDL"},{"id":11184032,"change_date":"2024-11-09 21:33:00","inspection_id":"83119140","insp_violation_id":"262816672","seq_no":"7","part_no":"383","part_no_section":"23A2-LCDLN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:17.000000Z","updated_at":"2025-03-17T22:00:17.000000Z","normalized_code":"38323A2LCDLN"}],"inspection_per_units":[{"id":11546332,"change_date":"2024-11-09 21:33:00","inspection_id":"83119140","insp_unit_id":"203811366","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"490","insp_unit_license":"B424115","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"4V4NC9TG35N383022","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:42:40.000000Z","updated_at":"2025-03-17T23:42:40.000000Z"},{"id":11546333,"change_date":"2024-11-09 21:33:00","inspection_id":"83119140","insp_unit_id":"203811367","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"399","insp_unit_license":"9008SV","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1GRAA96295T517839","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:42:40.000000Z","updated_at":"2025-03-17T23:42:40.000000Z"}]},{"id":7043378,"change_date":"2024-10-25 21:40:00","inspection_id":"82996840","dot_number":"235869","report_state":"WA","report_number":"C046000046","insp_date":"2024-10-23 00:00:00","insp_start_time":"1317","insp_end_time":"1350","registration_date":null,"region":"PD","ci_status_code":"C","location":null,"location_desc":"WAPATO WA","county_code_state":"WA","county_code":"077","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":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-10-25 21:40:00","post_acc_ind":"Y","gross_comb_veh_wt":"117350","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":"983201","transaction_code":"A","transaction_date":"2024-10-25 00:00:00","upload_date":"2024-10-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00235869","upload_search_indicator":null,"census_search_date":"2024-10-25 21:40:00","snet_input_date":"2024-10-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-25 21:40:00","insp_carrier_name":"COCA COLA BOTTLING COMPANY OF YAKIMA & TRICITIES","insp_carrier_street":"607 E R STREET","insp_carrier_city":"YAKIMA","insp_carrier_state":"WA","insp_carrier_zip_code":"98901","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:42:59.000000Z","updated_at":"2025-03-17T20:42:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11359357,"change_date":"2024-10-25 21:40:00","inspection_id":"82996840","insp_unit_id":"203582332","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"C29437Z","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1HSDJAPR4FH716751","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:36.000000Z","updated_at":"2025-03-17T23:40:36.000000Z"},{"id":11359358,"change_date":"2024-10-25 21:40:00","inspection_id":"82996840","insp_unit_id":"203582333","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":null,"insp_unit_license":"79570AJ","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1UYVS2481DG717307","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:36.000000Z","updated_at":"2025-03-17T23:40:36.000000Z"}]},{"id":6317514,"change_date":"2024-07-26 21:38:00","inspection_id":"82223545","dot_number":"235869","report_state":"WA","report_number":"1158003867","insp_date":"2024-07-23 00:00:00","insp_start_time":"0834","insp_end_time":"0951","registration_date":null,"region":"PD","ci_status_code":"C","location":"SC40","location_desc":"GRANDVIEW WA","county_code_state":"WA","county_code":"005","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"157829","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-07-26 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"114961","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":"688602","transaction_code":"A","transaction_date":"2024-07-26 00:00:00","upload_date":"2024-07-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00235869","upload_search_indicator":null,"census_search_date":"2024-07-26 21:38:00","snet_input_date":"2024-07-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-07-26 21:38:00","insp_carrier_name":"COCA COLA BOTTLING COMPANY OF YAKIMA & TRICITIES","insp_carrier_street":"607 E R STREET","insp_carrier_city":"YAKIMA","insp_carrier_state":"WA","insp_carrier_zip_code":"98901","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:27:53.000000Z","updated_at":"2025-03-17T20:27:53.000000Z","inspection_violations":[{"id":9810250,"change_date":"2024-07-26 21:38:00","inspection_id":"82223545","insp_violation_id":"260859056","seq_no":"1","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"202086158","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:27.000000Z","updated_at":"2025-03-17T21:53:27.000000Z","normalized_code":"39345D"},{"id":9810251,"change_date":"2024-07-26 21:38:00","inspection_id":"82223545","insp_violation_id":"260859057","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202086158","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:27.000000Z","updated_at":"2025-03-17T21:53:27.000000Z","normalized_code":"3922"},{"id":9810252,"change_date":"2024-07-26 21:38:00","inspection_id":"82223545","insp_violation_id":"260859058","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"202086159","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:27.000000Z","updated_at":"2025-03-17T21:53:27.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":10179453,"change_date":"2024-07-26 21:38:00","inspection_id":"82223545","insp_unit_id":"202086158","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"490","insp_unit_license":"B42411S","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"4V4NC9TG35N383022","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:25.000000Z","updated_at":"2025-03-17T23:28:25.000000Z"},{"id":10179454,"change_date":"2024-07-26 21:38:00","inspection_id":"82223545","insp_unit_id":"202086159","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAILMOBIL","insp_unit_company":"3232P","insp_unit_license":"6742ZH","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"2MN01JAH651009514","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:25.000000Z","updated_at":"2025-03-17T23:28:25.000000Z"}]},{"id":6257911,"change_date":"2024-07-19 21:37:00","inspection_id":"82159703","dot_number":"235869","report_state":"WA","report_number":"C046000021","insp_date":"2024-07-17 00:00:00","insp_start_time":"1505","insp_end_time":"1600","registration_date":null,"region":"PD","ci_status_code":"C","location":null,"location_desc":"TIETON WA","county_code_state":"WA","county_code":"077","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-07-19 21:37:00","post_acc_ind":"Y","gross_comb_veh_wt":"115000","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":"666899","transaction_code":"A","transaction_date":"2024-07-18 00:00:00","upload_date":"2024-07-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00235869","upload_search_indicator":null,"census_search_date":"2024-07-19 21:37:00","snet_input_date":"2024-07-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-07-19 21:37:00","insp_carrier_name":"COCA COLA BOTTLING COMPANY OF YAKIMA & TRICITIES","insp_carrier_street":"607 E R STREET","insp_carrier_city":"YAKIMA","insp_carrier_state":"WA","insp_carrier_zip_code":"98901","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:26:40.000000Z","updated_at":"2025-03-17T20:26:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10082645,"change_date":"2024-07-19 21:37:00","inspection_id":"82159703","insp_unit_id":"201964403","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"491","insp_unit_license":"C70759S","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"4V4NC9TJ25N377594","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:29.000000Z","updated_at":"2025-03-17T23:27:29.000000Z"},{"id":10082646,"change_date":"2024-07-19 21:37:00","inspection_id":"82159703","insp_unit_id":"201964404","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNKNOWN","insp_unit_company":"3460","insp_unit_license":"5558ZH","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"2MN01JAH051009492","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:29.000000Z","updated_at":"2025-03-17T23:27:29.000000Z"}]},{"id":5615086,"change_date":"2024-04-29 21:42:00","inspection_id":"81464472","dot_number":"235869","report_state":"WA","report_number":"1158003754","insp_date":"2024-04-25 00:00:00","insp_start_time":"0853","insp_end_time":"0912","registration_date":null,"region":"PD","ci_status_code":"C","location":"SC40","location_desc":"GRANDVIEW WA","county_code_state":"WA","county_code":"005","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-04-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"435728","transaction_code":"A","transaction_date":"2024-04-29 00:00:00","upload_date":"2024-04-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00235869","upload_search_indicator":null,"census_search_date":"2024-04-29 21:42:00","snet_input_date":"2024-04-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-04-29 21:42:00","insp_carrier_name":"COCA COLA BOTTLING COMPANY OF YAKIMA & TRICITIES","insp_carrier_street":"607 E R STREET","insp_carrier_city":"YAKIMA","insp_carrier_state":"WA","insp_carrier_zip_code":"98901","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:13:55.000000Z","updated_at":"2025-03-17T20:13:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9045213,"change_date":"2024-04-29 21:42:00","inspection_id":"81464472","insp_unit_id":"200613485","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"490","insp_unit_license":"B42411S","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"4V4NC9TG35N383022","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:11.000000Z","updated_at":"2025-03-17T23:17:11.000000Z"},{"id":9045214,"change_date":"2024-04-29 21:42:00","inspection_id":"81464472","insp_unit_id":"200613486","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUEHAUF","insp_unit_company":"494","insp_unit_license":"6060YP","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1JJV532FXXF633842","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:11.000000Z","updated_at":"2025-03-17T23:17:11.000000Z"}]},{"id":5541304,"change_date":"2024-04-18 21:39:00","inspection_id":"81384074","dot_number":"235869","report_state":"WA","report_number":"0853000066","insp_date":"2024-04-16 00:00:00","insp_start_time":"1155","insp_end_time":"1240","registration_date":null,"region":"PD","ci_status_code":"C","location":"SC40","location_desc":"GRANDVIEW WA","county_code_state":"WA","county_code":"005","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-04-18 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"409460","transaction_code":"A","transaction_date":"2024-04-18 00:00:00","upload_date":"2024-04-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00235869","upload_search_indicator":null,"census_search_date":"2024-04-18 21:39:00","snet_input_date":"2024-04-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-04-18 21:39:00","insp_carrier_name":"COCA COLA BOTTLING COMPANY OF YAKIMA & TRICITIES","insp_carrier_street":"607 E R STREET","insp_carrier_city":"YAKIMA","insp_carrier_state":"WA","insp_carrier_zip_code":"98901","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:12:43.000000Z","updated_at":"2025-03-17T20:12:43.000000Z","inspection_violations":[{"id":8562252,"change_date":"2024-04-18 21:39:00","inspection_id":"81384074","insp_violation_id":"259002226","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":"4A0394042","created_at":"2025-03-17T21:47:31.000000Z","updated_at":"2025-03-17T21:47:31.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8926052,"change_date":"2024-04-18 21:39:00","inspection_id":"81384074","insp_unit_id":"200460481","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"8893","insp_unit_license":"D39603A","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"3HAMMMMLXGL128868","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:04.000000Z","updated_at":"2025-03-17T23:16:04.000000Z"}]},{"id":5282816,"change_date":"2024-03-14 21:41:00","inspection_id":"81101803","dot_number":"235869","report_state":"WA","report_number":"2020000050","insp_date":"2024-03-11 00:00:00","insp_start_time":"1140","insp_end_time":"1215","registration_date":null,"region":"PD","ci_status_code":"C","location":null,"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":"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":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-03-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"17040","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"315959","transaction_code":"A","transaction_date":"2024-03-13 00:00:00","upload_date":"2024-03-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00235869","upload_search_indicator":null,"census_search_date":"2024-03-14 21:41:00","snet_input_date":"2024-03-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-03-14 21:41:00","insp_carrier_name":"COCA COLA BOTTLING COMPANY OF YAKIMA & TRICITIES","insp_carrier_street":"607 E R STREET","insp_carrier_city":"YAKIMA","insp_carrier_state":"WA","insp_carrier_zip_code":"98901","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:07:27.000000Z","updated_at":"2025-03-17T20:07:27.000000Z","inspection_violations":[{"id":8145981,"change_date":"2024-03-14 21:41:00","inspection_id":"81101803","insp_violation_id":"258373387","seq_no":"1","part_no":"392","part_no_section":"2-SLLTCD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:23.000000Z","updated_at":"2025-03-17T21:45:23.000000Z","normalized_code":"3922SLLTCD"}],"inspection_per_units":[{"id":8506970,"change_date":"2024-03-14 21:41:00","inspection_id":"81101803","insp_unit_id":"199904814","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"F160010","insp_unit_license":"D39503A","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"3HAMMMMLXGL128868","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:06.000000Z","updated_at":"2025-03-17T23:12:06.000000Z"}]},{"id":4834181,"change_date":"2024-01-16 21:44:00","inspection_id":"80611963","dot_number":"235869","report_state":"WA","report_number":"2022000158","insp_date":"2024-01-16 00:00:00","insp_start_time":"1210","insp_end_time":"1225","registration_date":null,"region":"PS","ci_status_code":"C","location":"SC40","location_desc":"GRANDVIEW WA","county_code_state":"WA","county_code":"005","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-01-16 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"178483","transaction_code":"A","transaction_date":"2024-01-16 00:00:00","upload_date":"2024-01-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00235869","upload_search_indicator":null,"census_search_date":"2024-01-16 21:44:00","snet_input_date":"2024-01-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-01-16 21:44:00","insp_carrier_name":"COCA COLA BOTTLING COMPANY OF YAKIMA & TRICITIES","insp_carrier_street":"607 E R STREET","insp_carrier_city":"YAKIMA","insp_carrier_state":"WA","insp_carrier_zip_code":"98901","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:58:28.000000Z","updated_at":"2025-03-17T19:58:28.000000Z","inspection_violations":[{"id":7454034,"change_date":"2024-01-16 21:44:00","inspection_id":"80611963","insp_violation_id":"257342152","seq_no":"1","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"198962721","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:57.000000Z","updated_at":"2025-03-17T21:41:57.000000Z","normalized_code":"39021TB2DOT"}],"inspection_per_units":[{"id":7777747,"change_date":"2024-01-16 21:44:00","inspection_id":"80611963","insp_unit_id":"198962721","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"D70063B","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1HTMMMML0HH462642","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:30.000000Z","updated_at":"2025-03-17T23:05:30.000000Z"}]},{"id":3071127,"change_date":"2023-05-17 21:43:00","inspection_id":"78650926","dot_number":"235869","report_state":"WA","report_number":"W314003277","insp_date":"2023-05-16 00:00:00","insp_start_time":"1240","insp_end_time":"1340","registration_date":null,"region":"PT","ci_status_code":"C","location":null,"location_desc":"EB","county_code_state":"WA","county_code":"005","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-05-17 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2572172","transaction_code":"A","transaction_date":"2023-05-16 00:00:00","upload_date":"2023-05-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00235869","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-05-17 00:00:00","source_office":"4WAS001","mcmis_add_date":"2023-05-17 21:43:00","insp_carrier_name":"COCA COLA BOTTLING YAKIMA & TRI-CITIES","insp_carrier_street":"P O BOX 1726","insp_carrier_city":"YAKIMA","insp_carrier_state":"WA","insp_carrier_zip_code":"98907","insp_colonia":null,"docket_number":"449480","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":4719401,"change_date":"2023-05-17 21:43:00","inspection_id":"78650926","insp_violation_id":"252897479","seq_no":"1","part_no":"393","part_no_section":"83(h)","insp_viol_unit":"1","insp_unit_id":"194989604","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:57.000000Z","updated_at":"2025-03-17T21:28:57.000000Z","normalized_code":"39383H"},{"id":4719402,"change_date":"2023-05-17 21:43:00","inspection_id":"78650926","insp_violation_id":"252897480","seq_no":"2","part_no":"393","part_no_section":"201(a)","insp_viol_unit":"1","insp_unit_id":"194989604","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:57.000000Z","updated_at":"2025-03-17T21:28:57.000000Z","normalized_code":"393201A"},{"id":4719403,"change_date":"2023-05-17 21:43:00","inspection_id":"78650926","insp_violation_id":"252897481","seq_no":"3","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"194989604","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:57.000000Z","updated_at":"2025-03-17T21:28:57.000000Z","normalized_code":"39311"},{"id":4719404,"change_date":"2023-05-17 21:43:00","inspection_id":"78650926","insp_violation_id":"252897482","seq_no":"4","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"194989604","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:57.000000Z","updated_at":"2025-03-17T21:28:57.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":4940738,"change_date":"2023-05-17 21:43:00","inspection_id":"78650926","insp_unit_id":"194989604","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"8795","insp_unit_license":"C74566Y","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"3HAMMMML9FL598968","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":3046066,"change_date":"2023-05-15 21:42:00","inspection_id":"78622837","dot_number":"235869","report_state":"WA","report_number":"W328001734","insp_date":"2023-05-12 00:00:00","insp_start_time":"0910","insp_end_time":"0920","registration_date":null,"region":"PT","ci_status_code":"C","location":null,"location_desc":"EB","county_code_state":"WA","county_code":"077","insp_level_id":"3","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-05-15 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2571445","transaction_code":"A","transaction_date":"2023-05-12 00:00:00","upload_date":"2023-05-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00235869","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-05-15 00:00:00","source_office":"4WAS001","mcmis_add_date":"2023-05-15 21:42:00","insp_carrier_name":"COCA COLA BOTTLING YAKIMA & TRI-CITIES","insp_carrier_street":"P O BOX 1726","insp_carrier_city":"YAKIMA","insp_carrier_state":"WA","insp_carrier_zip_code":"98907","insp_colonia":null,"docket_number":"449480","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:23:22.000000Z","updated_at":"2025-03-17T19:23:22.000000Z","inspection_violations":[{"id":4679127,"change_date":"2023-05-15 21:42:00","inspection_id":"78622837","insp_violation_id":"252835461","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":"3A0376758","created_at":"2025-03-17T21:28:46.000000Z","updated_at":"2025-03-17T21:28:46.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":4900561,"change_date":"2023-05-15 21:42:00","inspection_id":"78622837","insp_unit_id":"194934638","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"462","insp_unit_license":"B67330F","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1FV3GJAC9YHF03327","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:39.000000Z","updated_at":"2025-03-17T22:41:39.000000Z"}]},{"id":2447932,"change_date":"2023-02-24 21:40:00","inspection_id":"77943549","dot_number":"235869","report_state":"WA","report_number":"W311001355","insp_date":"2023-02-23 00:00:00","insp_start_time":"1232","insp_end_time":"1240","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":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-02-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"2554994","transaction_code":"A","transaction_date":"2023-02-23 00:00:00","upload_date":"2023-02-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00235869","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-02-24 00:00:00","source_office":"4WAS001","mcmis_add_date":"2023-02-24 21:40:00","insp_carrier_name":"COCA COLA BOTTLING YAKIMA & TRI-CITIES","insp_carrier_street":"P O BOX 1726","insp_carrier_city":"YAKIMA","insp_carrier_state":"WA","insp_carrier_zip_code":"98907","insp_colonia":null,"docket_number":"449480","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:11:46.000000Z","updated_at":"2025-03-17T19:11:46.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3939498,"change_date":"2023-02-24 21:40:00","inspection_id":"77943549","insp_unit_id":"193574987","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"D39503A","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"3HAMMMMLXGL128868","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:12.000000Z","updated_at":"2025-03-17T22:34:12.000000Z"}]},{"id":2228246,"change_date":"2023-01-25 21:43:00","inspection_id":"77693309","dot_number":"235869","report_state":"WA","report_number":"W329003254","insp_date":"2023-01-24 00:00:00","insp_start_time":"0535","insp_end_time":"0620","registration_date":null,"region":"PT","ci_status_code":"C","location":null,"location_desc":"W\/B 182","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-01-25 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"2547845","transaction_code":"A","transaction_date":"2023-01-24 00:00:00","upload_date":"2023-01-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00235869","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-01-25 00:00:00","source_office":"4WAS001","mcmis_add_date":"2023-01-25 21:43:00","insp_carrier_name":"COCA COLA BOTTLING YAKIMA & TRI-CITIES","insp_carrier_street":"P O BOX 1726","insp_carrier_city":"YAKIMA","insp_carrier_state":"WA","insp_carrier_zip_code":"98907","insp_colonia":null,"docket_number":"449480","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:07:44.000000Z","updated_at":"2025-03-17T19:07:44.000000Z","inspection_violations":[{"id":3441999,"change_date":"2023-01-25 21:43:00","inspection_id":"77693309","insp_violation_id":"250781285","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193068583","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:18.000000Z","updated_at":"2025-03-17T21:23:18.000000Z","normalized_code":"3922"},{"id":3442000,"change_date":"2023-01-25 21:43:00","inspection_id":"77693309","insp_violation_id":"250781286","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193068583","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:18.000000Z","updated_at":"2025-03-17T21:23:18.000000Z","normalized_code":"3922"},{"id":3442001,"change_date":"2023-01-25 21:43:00","inspection_id":"77693309","insp_violation_id":"250781287","seq_no":"3","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"193068583","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:18.000000Z","updated_at":"2025-03-17T21:23:18.000000Z","normalized_code":"39311"},{"id":3442002,"change_date":"2023-01-25 21:43:00","inspection_id":"77693309","insp_violation_id":"250781288","seq_no":"4","part_no":"392","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193068583","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:23:18.000000Z","updated_at":"2025-03-17T21:23:18.000000Z","normalized_code":"3929A"},{"id":3442003,"change_date":"2023-01-25 21:43:00","inspection_id":"77693309","insp_violation_id":"250781289","seq_no":"5","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"193068583","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:18.000000Z","updated_at":"2025-03-17T21:23:18.000000Z","normalized_code":"39021TB"}],"inspection_per_units":[{"id":3586595,"change_date":"2023-01-25 21:43:00","inspection_id":"77693309","insp_unit_id":"193068583","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"C90629T","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"3HAMMMMM0EL066984","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:43.000000Z","updated_at":"2025-03-17T22:31:43.000000Z"}]},{"id":2142523,"change_date":"2023-01-13 21:40:00","inspection_id":"77595016","dot_number":"235869","report_state":"WA","report_number":"W318005793","insp_date":"2023-01-06 00:00:00","insp_start_time":"1140","insp_end_time":"1200","registration_date":null,"region":"PT","ci_status_code":"C","location":null,"location_desc":"EB I82","county_code_state":"WA","county_code":"037","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-01-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"2545595","transaction_code":"A","transaction_date":"2023-01-06 00:00:00","upload_date":"2023-01-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00235869","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-01-13 00:00:00","source_office":"4WAS001","mcmis_add_date":"2023-01-13 21:40:00","insp_carrier_name":"COCA COLA BOTTLING YAKIMA & TRI-CITIES","insp_carrier_street":"P O BOX 1726","insp_carrier_city":"YAKIMA","insp_carrier_state":"WA","insp_carrier_zip_code":"98907","insp_colonia":null,"docket_number":"449480","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:06:13.000000Z","updated_at":"2025-03-17T19:06:13.000000Z","inspection_violations":[{"id":3315126,"change_date":"2023-01-13 21:40:00","inspection_id":"77595016","insp_violation_id":"250572490","seq_no":"1","part_no":"392","part_no_section":"82(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"3A0101207","created_at":"2025-03-17T21:22:40.000000Z","updated_at":"2025-03-17T21:22:40.000000Z","normalized_code":"39282A1"}],"inspection_per_units":[{"id":3448189,"change_date":"2023-01-13 21:40:00","inspection_id":"77595016","insp_unit_id":"192871491","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"C34319F","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1HSHBAZN7RH587305","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:42.000000Z","updated_at":"2025-03-17T22:30:42.000000Z"},{"id":3448190,"change_date":"2023-01-13 21:40:00","inspection_id":"77595016","insp_unit_id":"192871492","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNK","insp_unit_company":null,"insp_unit_license":"1591VI","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1NNVA2812JM114461","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:42.000000Z","updated_at":"2025-03-17T22:30:42.000000Z"}]},{"id":1962640,"change_date":"2022-12-16 21:40:00","inspection_id":"77389579","dot_number":"235869","report_state":"WA","report_number":"W311001195","insp_date":"2022-12-15 00:00:00","insp_start_time":"1054","insp_end_time":"1115","registration_date":null,"region":"PT","ci_status_code":"C","location":"SC47","location_desc":"SC47   RIMROCK","county_code_state":"WA","county_code":"077","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":"2022-12-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"3","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2540924","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":"00235869","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-12-16 00:00:00","source_office":"4WAS001","mcmis_add_date":"2022-12-16 21:40:00","insp_carrier_name":"COCA COLA BOTTLING YAKIMA & TRI-CITIES","insp_carrier_street":"P O BOX 1726","insp_carrier_city":"YAKIMA","insp_carrier_state":"WA","insp_carrier_zip_code":"98907","insp_colonia":null,"docket_number":"449480","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:02:54.000000Z","updated_at":"2025-03-17T19:02:54.000000Z","inspection_violations":[{"id":3047781,"change_date":"2022-12-16 21:40:00","inspection_id":"77389579","insp_violation_id":"250138988","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"192463618","insp_violation_category_id":"20","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":"3939A"},{"id":3047782,"change_date":"2022-12-16 21:40:00","inspection_id":"77389579","insp_violation_id":"250138989","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"29","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":"39617C"},{"id":3047783,"change_date":"2022-12-16 21:40:00","inspection_id":"77389579","insp_violation_id":"250138990","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:30.000000Z","updated_at":"2025-03-17T21:21:30.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3158207,"change_date":"2022-12-16 21:40:00","inspection_id":"77389579","insp_unit_id":"192463618","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"F160010","insp_unit_license":"B67330F","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1FV3GJAC9YHF03327","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":1648943,"change_date":"2022-11-01 21:40:00","inspection_id":"77030045","dot_number":"235869","report_state":"WA","report_number":"W329003087","insp_date":"2022-10-31 00:00:00","insp_start_time":"1005","insp_end_time":"1030","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":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":"2022-11-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"16000","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2531482","transaction_code":"A","transaction_date":"2022-10-31 00:00:00","upload_date":"2022-11-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00235869","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-11-01 00:00:00","source_office":"4WAS001","mcmis_add_date":"2022-11-01 21:40:00","insp_carrier_name":"COCA COLA BOTTLING YAKIMA & TRI-CITIES","insp_carrier_street":"P O BOX 1726","insp_carrier_city":"YAKIMA","insp_carrier_state":"WA","insp_carrier_zip_code":"98907","insp_colonia":null,"docket_number":"449480","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:57:03.000000Z","updated_at":"2025-03-17T18:57:03.000000Z","inspection_violations":[{"id":2587653,"change_date":"2022-11-01 21:40:00","inspection_id":"77030045","insp_violation_id":"249374062","seq_no":"1","part_no":"392","part_no_section":"82(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"2A0661185","created_at":"2025-03-17T21:19:11.000000Z","updated_at":"2025-03-17T21:19:11.000000Z","normalized_code":"39282A1"},{"id":2587654,"change_date":"2022-11-01 21:40:00","inspection_id":"77030045","insp_violation_id":"249374063","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191753323","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:11.000000Z","updated_at":"2025-03-17T21:19:11.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2653490,"change_date":"2022-11-01 21:40:00","inspection_id":"77030045","insp_unit_id":"191753323","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"C93238G","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1GBE4C1257F400479","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:11.000000Z","updated_at":"2025-03-17T22:25:11.000000Z"}]},{"id":1518898,"change_date":"2022-10-14 21:39:00","inspection_id":"76880498","dot_number":"235869","report_state":"WA","report_number":"W303009123","insp_date":"2022-10-13 00:00:00","insp_start_time":"1255","insp_end_time":"1325","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":"1","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":"2022-10-14 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"2527639","transaction_code":"A","transaction_date":"2022-10-13 00:00:00","upload_date":"2022-10-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00235869","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-10-14 00:00:00","source_office":"4WAS001","mcmis_add_date":"2022-10-14 21:39:00","insp_carrier_name":"COCA COLA BOTTLING YAKIMA & TRI-CITIES","insp_carrier_street":"P O BOX 1726","insp_carrier_city":"YAKIMA","insp_carrier_state":"WA","insp_carrier_zip_code":"98907","insp_colonia":null,"docket_number":"449480","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:54:32.000000Z","updated_at":"2025-03-17T18:54:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2444483,"change_date":"2022-10-14 21:39:00","inspection_id":"76880498","insp_unit_id":"191450821","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"C74566Y","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"3HAMMMML9FL598968","insp_unit_decal":"Y","insp_unit_decal_number":"31961896","created_at":"2025-03-17T22:23:44.000000Z","updated_at":"2025-03-17T22:23:44.000000Z"}]},{"id":281167,"change_date":"2022-04-28 21:40:00","inspection_id":"75428748","dot_number":"235869","report_state":"WA","report_number":"W312000484","insp_date":"2022-04-27 00:00:00","insp_start_time":"1318","insp_end_time":"1340","registration_date":null,"region":"PT","ci_status_code":"C","location":null,"location_desc":"SELAH","county_code_state":"WA","county_code":"077","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":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-04-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"2491012","transaction_code":"A","transaction_date":"2022-04-27 00:00:00","upload_date":"2022-04-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00235869","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-04-28 00:00:00","source_office":"4WAS001","mcmis_add_date":"2022-04-28 21:40:00","insp_carrier_name":"COCA COLA BOTTLING YAKIMA & TRI-CITIES","insp_carrier_street":"P O BOX 1726","insp_carrier_city":"YAKIMA","insp_carrier_state":"WA","insp_carrier_zip_code":"98907","insp_colonia":null,"docket_number":"449480","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:32:32.000000Z","updated_at":"2025-03-17T18:32:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":455351,"change_date":"2022-04-28 21:40:00","inspection_id":"75428748","insp_unit_id":"188407485","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"8517","insp_unit_license":"C70744S","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"3ALACWCY2HDJE4300","insp_unit_decal":"Y","insp_unit_decal_number":"31278568","created_at":"2025-03-17T22:11:00.000000Z","updated_at":"2025-03-17T22:11:00.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/235869\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/235869\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/235869\/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\/235869\/inspections","per_page":100,"prev_page_url":null,"to":22,"total":22}