{"current_page":1,"data":[{"id":12459332,"change_date":"2026-07-15 21:43:00","inspection_id":"88419847","dot_number":"74616","report_state":"CA","report_number":"UGGH001910","insp_date":"2026-07-15 00:00:00","insp_start_time":"1020","insp_end_time":"1050","registration_date":null,"region":"PD","ci_status_code":"C","location":"120","location_desc":"CA","county_code_state":"CA","county_code":"015","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":"2026-07-15 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3759200","transaction_code":"A","transaction_date":"2026-07-15 00:00:00","upload_date":"2026-07-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00074616","upload_search_indicator":null,"census_search_date":"2026-07-15 21:43:00","snet_input_date":"2026-07-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-15 21:43:00","insp_carrier_name":"DOUGLAS COUNTY BOTTLING CO INC","insp_carrier_street":"165 BOURBON ST","insp_carrier_city":"ROSEBURG","insp_carrier_state":"OR","insp_carrier_zip_code":"97471","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-18T09:40:59.000000Z","updated_at":"2026-07-26T09:31:35.000000Z","inspection_violations":[{"id":21691110,"change_date":"2026-07-15 21:43:00","inspection_id":"88419847","insp_violation_id":"275528472","seq_no":"1","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"2","insp_unit_id":"214633842","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-18T10:03:21.000000Z","updated_at":"2026-07-26T09:45:15.000000Z","normalized_code":"39345B2BAIR"}],"inspection_per_units":[{"id":21641023,"change_date":"2026-07-15 21:43:00","inspection_id":"88419847","insp_unit_id":"214633841","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"P30","insp_unit_license":"YAJY818","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XPBDP9X9PD884429","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-18T09:20:32.000000Z","updated_at":"2026-07-26T09:03:54.000000Z"},{"id":21641024,"change_date":"2026-07-15 21:43:00","inspection_id":"88419847","insp_unit_id":"214633842","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLWD","insp_unit_company":null,"insp_unit_license":"HV16918","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"2MN01JALX41001726","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-18T09:20:32.000000Z","updated_at":"2026-07-26T09:03:54.000000Z"}]},{"id":12136940,"change_date":"2026-06-09 21:42:00","inspection_id":"88083420","dot_number":"74616","report_state":"OR","report_number":"AP42931027","insp_date":"2026-06-09 00:00:00","insp_start_time":"1000","insp_end_time":"1036","registration_date":null,"region":"PD","ci_status_code":"C","location":"17-03","location_desc":"WILDERVILLE OR","county_code_state":"OR","county_code":"033","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MULTIPLE","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3500714","transaction_code":"A","transaction_date":"2026-06-09 00:00:00","upload_date":"2026-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00074616","upload_search_indicator":null,"census_search_date":"2026-06-09 21:42:00","snet_input_date":"2026-06-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-09 21:42:00","insp_carrier_name":"DOUGLAS COUNTY BOTTLING CO INC","insp_carrier_street":"612  NW CECIL","insp_carrier_city":"ROSEBURG","insp_carrier_state":"OR","insp_carrier_zip_code":"97470","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-12T09:40:03.000000Z","updated_at":"2026-06-20T09:32:46.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21085794,"change_date":"2026-06-09 21:42:00","inspection_id":"88083420","insp_unit_id":"213989552","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"P42","insp_unit_license":"YAKP728","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XPBDP9X8TD806475","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-12T09:15:52.000000Z","updated_at":"2026-06-20T09:04:41.000000Z"},{"id":21085795,"change_date":"2026-06-09 21:42:00","inspection_id":"88083420","insp_unit_id":"213989553","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNKNOWN","insp_unit_company":"T32","insp_unit_license":"HV87464","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"2MN01JAL871007982","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-12T09:15:52.000000Z","updated_at":"2026-06-20T09:04:41.000000Z"}]},{"id":12037006,"change_date":"2026-05-28 21:41:00","inspection_id":"87977375","dot_number":"74616","report_state":"OR","report_number":"AW42800281","insp_date":"2026-05-28 00:00:00","insp_start_time":"0524","insp_end_time":"0538","registration_date":null,"region":"PD","ci_status_code":"C","location":"15-06","location_desc":"ASHLAND  OR","county_code_state":"OR","county_code":"029","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"COCCA COLA","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"3416555","transaction_code":"A","transaction_date":"2026-05-28 00:00:00","upload_date":"2026-05-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00074616","upload_search_indicator":null,"census_search_date":"2026-05-28 21:41:00","snet_input_date":"2026-05-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-28 21:41:00","insp_carrier_name":"DOUGLAS COUNTY BOTTLING CO INC","insp_carrier_street":"165 BOURBON ST","insp_carrier_city":"ROSEBURG","insp_carrier_state":"OR","insp_carrier_zip_code":"97471","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-01T09:39:52.000000Z","updated_at":"2026-06-08T09:30:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20921748,"change_date":"2026-05-28 21:41:00","inspection_id":"87977375","insp_unit_id":"213790942","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"P14","insp_unit_license":"YAIV380","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1HSDJSJR4CH673572","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-01T09:17:03.000000Z","updated_at":"2026-06-08T09:02:37.000000Z"},{"id":20921749,"change_date":"2026-05-28 21:41:00","inspection_id":"87977375","insp_unit_id":"213790943","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"T-06","insp_unit_license":"HU48079","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1GRAA7024AT554692","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-01T09:17:03.000000Z","updated_at":"2026-06-08T09:02:37.000000Z"}]},{"id":11894480,"change_date":"2026-05-13 21:42:00","inspection_id":"87832825","dot_number":"74616","report_state":"OR","report_number":"AW43550295","insp_date":"2026-05-13 00:00:00","insp_start_time":"0643","insp_end_time":"0745","registration_date":null,"region":"PD","ci_status_code":"C","location":"18-07","location_desc":"KLAMATH FALLS OR","county_code_state":"OR","county_code":"035","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"COCA COLA","shipping_paper_number":"000000","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-05-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","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":"3312532","transaction_code":"A","transaction_date":"2026-05-13 00:00:00","upload_date":"2026-05-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00074616","upload_search_indicator":null,"census_search_date":"2026-05-13 21:42:00","snet_input_date":"2026-05-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-13 21:42:00","insp_carrier_name":"DOUGLAS COUNTY BOTTLING CO INC","insp_carrier_street":"165 BOURBON ST","insp_carrier_city":"ROSEBURG","insp_carrier_state":"OR","insp_carrier_zip_code":"97471","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-15T12:26:51.000000Z","updated_at":"2026-05-24T09:30:57.000000Z","inspection_violations":[{"id":20689413,"change_date":"2026-05-13 21:42:00","inspection_id":"87832825","insp_violation_id":"274222242","seq_no":"1","part_no":"393","part_no_section":"11A1-CSLRR","insp_viol_unit":"1","insp_unit_id":"213522954","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-15T12:59:04.000000Z","updated_at":"2026-05-24T09:44:22.000000Z","normalized_code":"39311A1CSLRR"},{"id":20689414,"change_date":"2026-05-13 21:42:00","inspection_id":"87832825","insp_violation_id":"274222243","seq_no":"2","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"2","insp_unit_id":"213522955","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-15T12:59:04.000000Z","updated_at":"2026-05-24T09:44:22.000000Z","normalized_code":"39345DB"},{"id":20689415,"change_date":"2026-05-13 21:42:00","inspection_id":"87832825","insp_violation_id":"274222244","seq_no":"3","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"213522955","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-15T12:59:04.000000Z","updated_at":"2026-05-24T09:44:22.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":20679987,"change_date":"2026-05-13 21:42:00","inspection_id":"87832825","insp_unit_id":"213522955","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"T10","insp_unit_license":"HV16917","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"2MN01JAL821002855","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-15T12:13:29.000000Z","updated_at":"2026-05-24T09:03:59.000000Z"},{"id":20679986,"change_date":"2026-05-13 21:42:00","inspection_id":"87832825","insp_unit_id":"213522954","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"CUSTOM SCO","insp_unit_company":"P11\/WHT","insp_unit_license":"YAIS094","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1HSDJSJR2CH673652","insp_unit_decal":"Y","insp_unit_decal_number":"36388278","created_at":"2026-05-15T12:13:29.000000Z","updated_at":"2026-05-24T09:03:59.000000Z"}]},{"id":11838841,"change_date":"2026-05-13 21:42:00","inspection_id":"87774313","dot_number":"74616","report_state":"CA","report_number":"NBTJ008743","insp_date":"2026-04-22 00:00:00","insp_start_time":"0804","insp_end_time":"0814","registration_date":null,"region":"PS","ci_status_code":"C","location":"147","location_desc":"CA","county_code_state":"CA","county_code":"093","insp_level_id":"1","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":"U","drug_intrdctn_search":"U","drug_intrdctn_arrests":"0","size_weight_enf":"U","traffic_enf":"U","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-06 21:41: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":"3272669","transaction_code":"C","transaction_date":"2026-05-13 00:00:00","upload_date":"2026-05-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00074616","upload_search_indicator":null,"census_search_date":"2026-05-06 21:41:00","snet_input_date":"2026-05-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-06 21:41:00","insp_carrier_name":"DOUGLAS COUNTY BOTTLING CO INC","insp_carrier_street":"165 BOURBON ST","insp_carrier_city":"ROSEBURG","insp_carrier_state":"OR","insp_carrier_zip_code":"97471","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-09T09:40:15.000000Z","updated_at":"2026-05-24T09:30:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20588772,"change_date":"2026-05-13 21:42:00","inspection_id":"87774313","insp_unit_id":"213529599","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRIM","insp_unit_company":null,"insp_unit_license":"HV16920","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"2MN01JAH551009536","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-09T09:18:23.000000Z","updated_at":"2026-05-24T09:02:25.000000Z"},{"id":20588771,"change_date":"2026-05-13 21:42:00","inspection_id":"87774313","insp_unit_id":"213529598","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"YAKK575","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XPBDP9X4SD758214","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-09T09:18:23.000000Z","updated_at":"2026-05-24T09:02:25.000000Z"}]},{"id":11669352,"change_date":"2026-04-16 21:41:00","inspection_id":"87599766","dot_number":"74616","report_state":"CA","report_number":"UDFU004865","insp_date":"2026-04-16 00:00:00","insp_start_time":"0730","insp_end_time":"0740","registration_date":null,"region":"PT","ci_status_code":"C","location":"850","location_desc":"S\/B I-5 S\/OF EASY ST","county_code_state":"CA","county_code":"093","insp_level_id":"2","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":"N","pen_cen_match":null,"final_status_date":"2026-04-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16250971","transaction_code":"A","transaction_date":"2026-04-16 00:00:00","upload_date":"2026-04-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00074616","upload_search_indicator":null,"census_search_date":"2026-04-16 21:41:00","snet_input_date":"2026-04-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-04-16 21:41:00","insp_carrier_name":"DOUGLAS COUNTY BOTTLING CO INC","insp_carrier_street":"165 BOURBON ST","insp_carrier_city":"ROSEBURG","insp_carrier_state":"OR","insp_carrier_zip_code":"97471","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-27T09:32:07.000000Z","updated_at":"2026-04-27T09:32:07.000000Z","inspection_violations":[{"id":20268053,"change_date":"2026-04-16 21:41:00","inspection_id":"87599766","insp_violation_id":"273656451","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:45:47.000000Z","updated_at":"2026-04-27T09:45:47.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":20298780,"change_date":"2026-04-16 21:41:00","inspection_id":"87599766","insp_unit_id":"213060819","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"YAKK575","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XPBDP9X4SD758214","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:05:36.000000Z","updated_at":"2026-04-27T09:05:36.000000Z"},{"id":20298781,"change_date":"2026-04-16 21:41:00","inspection_id":"87599766","insp_unit_id":"213060820","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TMO","insp_unit_company":null,"insp_unit_license":"HV16920","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"2MN01JAH551009536","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:05:36.000000Z","updated_at":"2026-04-27T09:05:36.000000Z"}]},{"id":10640991,"change_date":"2026-01-13 21:40:00","inspection_id":"86782415","dot_number":"74616","report_state":"CA","report_number":"NC0J007952","insp_date":"2026-01-07 00:00:00","insp_start_time":"1014","insp_end_time":"1025","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"COCA COLA","shipping_paper_number":"0","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":"2026-01-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"16126867","transaction_code":"A","transaction_date":"2026-01-07 00:00:00","upload_date":"2026-01-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00074616","upload_search_indicator":null,"census_search_date":"2026-01-13 21:40:00","snet_input_date":"2026-01-07 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-01-13 21:40:00","insp_carrier_name":"DOUGLAS COUNTY BOTTLING CO INC","insp_carrier_street":"165 BOURBON ST","insp_carrier_city":"ROSEBURG","insp_carrier_state":"OR","insp_carrier_zip_code":"97471","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-16T10:36:07.000000Z","updated_at":"2026-01-24T10:31:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17847585,"change_date":"2026-01-13 21:40:00","inspection_id":"86782415","insp_unit_id":"211064490","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"26\/RED","insp_unit_license":"YAJT063","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XKYD49X4LJ430115","insp_unit_decal":"Y","insp_unit_decal_number":"35869976","created_at":"2026-01-16T10:08:44.000000Z","updated_at":"2026-01-24T10:02:40.000000Z"},{"id":17847586,"change_date":"2026-01-13 21:40:00","inspection_id":"86782415","insp_unit_id":"211064491","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRIM","insp_unit_company":"T11\/RED","insp_unit_license":"HV16920","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"2MN01JAH551009536","insp_unit_decal":"Y","insp_unit_decal_number":"35869977","created_at":"2026-01-16T10:08:44.000000Z","updated_at":"2026-01-24T10:02:40.000000Z"}]},{"id":10582087,"change_date":"2026-01-06 21:39:00","inspection_id":"86720491","dot_number":"74616","report_state":"CA","report_number":"UGGH001530","insp_date":"2026-01-06 00:00:00","insp_start_time":"0920","insp_end_time":"0950","registration_date":null,"region":"PT","ci_status_code":"C","location":"120","location_desc":"CRESCENT CITY AREA","county_code_state":"CA","county_code":"015","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":"N","pen_cen_match":null,"final_status_date":"2026-01-06 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16118174","transaction_code":"A","transaction_date":"2026-01-06 00:00:00","upload_date":"2026-01-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00074616","upload_search_indicator":null,"census_search_date":"2026-01-06 21:39:00","snet_input_date":"2026-01-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-01-06 21:39:00","insp_carrier_name":"DOUGLAS COUNTY BOTTLING CO INC","insp_carrier_street":"165 BOURBON ST","insp_carrier_city":"ROSEBURG","insp_carrier_state":"OR","insp_carrier_zip_code":"97471","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-09T10:34:34.000000Z","updated_at":"2026-01-17T10:30:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17734941,"change_date":"2026-01-06 21:39:00","inspection_id":"86720491","insp_unit_id":"210939843","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"P40","insp_unit_license":"YAKK575","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XPBDP9X4SD758214","insp_unit_decal":"Y","insp_unit_decal_number":"35863426","created_at":"2026-01-09T10:05:59.000000Z","updated_at":"2026-01-17T10:01:23.000000Z"},{"id":17734942,"change_date":"2026-01-06 21:39:00","inspection_id":"86720491","insp_unit_id":"210939844","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRIM","insp_unit_company":null,"insp_unit_license":"HV87464","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"2MN01JAL871007982","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-09T10:05:59.000000Z","updated_at":"2026-01-17T10:01:23.000000Z"}]},{"id":10393430,"change_date":"2025-12-09 21:40:00","inspection_id":"86523282","dot_number":"74616","report_state":"CA","report_number":"UGGH001501","insp_date":"2025-12-09 00:00:00","insp_start_time":"0955","insp_end_time":"1035","registration_date":null,"region":"PT","ci_status_code":"C","location":"120","location_desc":"US-199 N\/OF MIDDLE FORK ROAD","county_code_state":"CA","county_code":"015","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":"N","pen_cen_match":null,"final_status_date":"2025-12-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"16088015","transaction_code":"A","transaction_date":"2025-12-09 00:00:00","upload_date":"2025-12-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00074616","upload_search_indicator":null,"census_search_date":"2025-12-09 21:40:00","snet_input_date":"2025-12-09 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-12-09 21:40:00","insp_carrier_name":"DOUGLAS COUNTY BOTTLING CO INC","insp_carrier_street":"165 BOURBON ST","insp_carrier_city":"ROSEBURG","insp_carrier_state":"OR","insp_carrier_zip_code":"97471","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-12T10:31:45.000000Z","updated_at":"2025-12-13T10:31:19.000000Z","inspection_violations":[{"id":17409458,"change_date":"2025-12-09 21:40:00","inspection_id":"86523282","insp_violation_id":"270574568","seq_no":"1","part_no":"393","part_no_section":"45D-BAAL","insp_viol_unit":"2","insp_unit_id":"210514287","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"SM56036","created_at":"2025-12-12T10:32:56.000000Z","updated_at":"2025-12-13T10:32:11.000000Z","normalized_code":"39345DBAAL"}],"inspection_per_units":[{"id":17375690,"change_date":"2025-12-09 21:40:00","inspection_id":"86523282","insp_unit_id":"210514286","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"P40","insp_unit_license":"YAKK575","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XPBDP9X4SD758214","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-12T10:01:37.000000Z","updated_at":"2025-12-13T10:01:40.000000Z"},{"id":17375691,"change_date":"2025-12-09 21:40:00","inspection_id":"86523282","insp_unit_id":"210514287","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRIM","insp_unit_company":null,"insp_unit_license":"HV87464","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"2MN01JAL871007982","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-12T10:01:37.000000Z","updated_at":"2025-12-13T10:01:40.000000Z"}]},{"id":10346428,"change_date":"2025-12-04 21:38:00","inspection_id":"86474103","dot_number":"74616","report_state":"CA","report_number":"NEZF003201","insp_date":"2025-11-26 00:00:00","insp_start_time":"1013","insp_end_time":"1025","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","insp_level_id":"2","service_center":"WE","census_source_id":"5","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-12-03 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16079409","transaction_code":"C","transaction_date":"2025-11-26 00:00:00","upload_date":"2025-12-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00074616","upload_search_indicator":null,"census_search_date":"2025-12-03 21:39:00","snet_input_date":"2025-11-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-12-03 21:39:00","insp_carrier_name":"DOUGLAS COUNTY BOTTLING CO INC","insp_carrier_street":"165 BOURBON ST","insp_carrier_city":"ROSEBURG","insp_carrier_state":"OR","insp_carrier_zip_code":"97471","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-06T10:31:40.000000Z","updated_at":"2025-12-08T10:30:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17296108,"change_date":"2025-12-04 21:38:00","inspection_id":"86474103","insp_unit_id":"210421182","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"P26\/RED","insp_unit_license":"YAJT063","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XKYD49X4LJ430115","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-07T10:01:30.000000Z","updated_at":"2025-12-08T10:01:07.000000Z"},{"id":17296109,"change_date":"2025-12-04 21:38:00","inspection_id":"86474103","insp_unit_id":"210421183","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRIM","insp_unit_company":"111\/WHT","insp_unit_license":"HV16920","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"2MN01JAH551009536","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-07T10:01:30.000000Z","updated_at":"2025-12-08T10:01:07.000000Z"}]},{"id":10185697,"change_date":"2025-11-12 21:42:00","inspection_id":"86305701","dot_number":"74616","report_state":"CA","report_number":"UGGH001443","insp_date":"2025-11-12 00:00:00","insp_start_time":"1045","insp_end_time":"1115","registration_date":null,"region":"PT","ci_status_code":"C","location":"120","location_desc":"US-101 AT AG STATION","county_code_state":"CA","county_code":"015","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":"N","pen_cen_match":null,"final_status_date":"2025-11-12 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16056167","transaction_code":"A","transaction_date":"2025-11-12 00:00:00","upload_date":"2025-11-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00074616","upload_search_indicator":null,"census_search_date":"2025-11-12 21:42:00","snet_input_date":"2025-11-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-11-12 21:42:00","insp_carrier_name":"DOUGLAS COUNTY BOTTLING CO INC","insp_carrier_street":"165 BOURBON ST","insp_carrier_city":"ROSEBURG","insp_carrier_state":"OR","insp_carrier_zip_code":"97471","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-15T10:30:56.000000Z","updated_at":"2025-11-16T10:31:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16964443,"change_date":"2025-11-12 21:42:00","inspection_id":"86305701","insp_unit_id":"209993820","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"P40","insp_unit_license":"YAKK575","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XPBDP9X4SD758214","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-15T10:00:48.000000Z","updated_at":"2025-11-16T10:02:17.000000Z"},{"id":16964444,"change_date":"2025-11-12 21:42:00","inspection_id":"86305701","insp_unit_id":"209993821","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRIM","insp_unit_company":null,"insp_unit_license":"HV87464","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"2MN01JAL871007982","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-15T10:00:48.000000Z","updated_at":"2025-11-16T10:02:17.000000Z"}]},{"id":10231935,"change_date":"2025-11-18 21:39:00","inspection_id":"86354182","dot_number":"74616","report_state":"CA","report_number":"N92M007988","insp_date":"2025-11-12 00:00:00","insp_start_time":"0939","insp_end_time":"0949","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SAME","shipping_paper_number":"ROUTE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-11-18 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16062425","transaction_code":"A","transaction_date":"2025-11-17 00:00:00","upload_date":"2025-11-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00074616","upload_search_indicator":null,"census_search_date":"2025-11-18 21:39:00","snet_input_date":"2025-11-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-11-18 21:39:00","insp_carrier_name":"DOUGLAS COUNTY BOTTLING CO INC","insp_carrier_street":"165 BOURBON ST","insp_carrier_city":"ROSEBURG","insp_carrier_state":"OR","insp_carrier_zip_code":"97471","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-21T10:31:55.000000Z","updated_at":"2025-11-23T10:31:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17051218,"change_date":"2025-11-18 21:39:00","inspection_id":"86354182","insp_unit_id":"210107450","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"P26\/RED","insp_unit_license":"YAJT063","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XKYD49X4LJ430115","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-21T10:02:01.000000Z","updated_at":"2025-11-23T10:01:24.000000Z"},{"id":17051219,"change_date":"2025-11-18 21:39:00","inspection_id":"86354182","insp_unit_id":"210107451","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRIM","insp_unit_company":"T11\/RED","insp_unit_license":"HV16920","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"2MN01JAH551009536","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-21T10:02:01.000000Z","updated_at":"2025-11-23T10:01:24.000000Z"}]},{"id":10094740,"change_date":"2025-10-31 21:41:00","inspection_id":"86209956","dot_number":"74616","report_state":"CA","report_number":"NCU6005345","insp_date":"2025-10-29 00:00:00","insp_start_time":"1005","insp_end_time":"1015","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"COKE","shipping_paper_number":"MULTI","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-31 21:41: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":"16042498","transaction_code":"A","transaction_date":"2025-10-29 00:00:00","upload_date":"2025-10-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00074616","upload_search_indicator":null,"census_search_date":"2025-10-31 21:41:00","snet_input_date":"2025-10-29 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-10-31 21:41:00","insp_carrier_name":"DOUGLAS COUNTY BOTTLING CO INC","insp_carrier_street":"165 BOURBON ST","insp_carrier_city":"ROSEBURG","insp_carrier_state":"OR","insp_carrier_zip_code":"97471","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-03T11:04:57.000000Z","updated_at":"2025-11-04T11:01:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16784339,"change_date":"2025-10-31 21:41:00","inspection_id":"86209956","insp_unit_id":"209780803","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"RED","insp_unit_license":"YAJT063","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XKYD49X4LJ430115","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-03T10:47:23.000000Z","updated_at":"2025-11-04T10:46:35.000000Z"},{"id":16784340,"change_date":"2025-10-31 21:41:00","inspection_id":"86209956","insp_unit_id":"209780804","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRIM","insp_unit_company":"RED","insp_unit_license":"HV16920","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"2MN01JAH551009536","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-03T10:47:23.000000Z","updated_at":"2025-11-04T10:46:35.000000Z"}]},{"id":9427660,"change_date":"2025-08-15 21:39:00","inspection_id":"85508531","dot_number":"74616","report_state":"CA","report_number":"UGGH001249","insp_date":"2025-08-15 00:00:00","insp_start_time":"1020","insp_end_time":"1100","registration_date":null,"region":"PT","ci_status_code":"C","location":"120","location_desc":"US-199 N\/OF MIDDLE FORK ROAD","county_code_state":"CA","county_code":"015","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":"N","pen_cen_match":null,"final_status_date":"2025-08-15 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15940089","transaction_code":"A","transaction_date":"2025-08-15 00:00:00","upload_date":"2025-08-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00074616","upload_search_indicator":null,"census_search_date":"2025-08-15 21:39:00","snet_input_date":"2025-08-15 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-08-15 21:39:00","insp_carrier_name":"DOUGLAS COUNTY BOTTLING CO INC","insp_carrier_street":"165 BOURBON ST","insp_carrier_city":"ROSEBURG","insp_carrier_state":"OR","insp_carrier_zip_code":"97471","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-20T10:44:43.000000Z","updated_at":"2025-08-20T10:44:43.000000Z","inspection_violations":[{"id":15340950,"change_date":"2025-08-15 21:39:00","inspection_id":"85508531","insp_violation_id":"268064480","seq_no":"1","part_no":"391","part_no_section":"41APC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"RC16699","created_at":"2025-08-18T10:45:09.000000Z","updated_at":"2025-08-19T10:45:11.000000Z","normalized_code":"39141APC"}],"inspection_per_units":[{"id":15541317,"change_date":"2025-08-15 21:39:00","inspection_id":"85508531","insp_unit_id":"208427444","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"P30","insp_unit_license":"YAJY818","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XPBDP9X9PD884429","insp_unit_decal":"Y","insp_unit_decal_number":"35328033","created_at":"2025-08-18T09:46:34.000000Z","updated_at":"2025-08-19T09:46:11.000000Z"},{"id":15541318,"change_date":"2025-08-15 21:39:00","inspection_id":"85508531","insp_unit_id":"208427445","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLWD","insp_unit_company":null,"insp_unit_license":"HV16918","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"2MN01JALX41001726","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-18T09:46:34.000000Z","updated_at":"2025-08-19T09:46:11.000000Z"}]},{"id":9377428,"change_date":"2025-08-13 21:38:00","inspection_id":"85455752","dot_number":"74616","report_state":"OR","report_number":"BR42990057","insp_date":"2025-08-11 00:00:00","insp_start_time":"1325","insp_end_time":"1411","registration_date":null,"region":"PD","ci_status_code":"C","location":"15-04","location_desc":"ASHLAND  OR","county_code_state":"OR","county_code":"029","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"COCA COLA","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-08-11 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2114767","transaction_code":"C","transaction_date":"2025-08-11 00:00:00","upload_date":"2025-08-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00074616","upload_search_indicator":null,"census_search_date":"2025-08-11 21:38:00","snet_input_date":"2025-08-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-11 21:38:00","insp_carrier_name":"DOUGLAS COUNTY BOTTLING CO INC","insp_carrier_street":"165 BOURBON ST","insp_carrier_city":"ROSEBURG","insp_carrier_state":"OR","insp_carrier_zip_code":"97471","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-14T10:42:25.000000Z","updated_at":"2025-08-17T10:00:08.000000Z","inspection_violations":[{"id":15278494,"change_date":"2025-08-13 21:38:00","inspection_id":"85455752","insp_violation_id":"267997475","seq_no":"1","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"1","insp_unit_id":"208370249","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-16T10:44:47.000000Z","updated_at":"2025-08-17T10:43:31.000000Z","normalized_code":"39345DB"}],"inspection_per_units":[{"id":15484901,"change_date":"2025-08-13 21:38:00","inspection_id":"85455752","insp_unit_id":"208370249","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"P41","insp_unit_license":"YAKM590","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XPBDP9X6SD758215","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-16T09:46:31.000000Z","updated_at":"2025-08-17T09:45:10.000000Z"},{"id":15484902,"change_date":"2025-08-13 21:38:00","inspection_id":"85455752","insp_unit_id":"208370250","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"HV87506","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1GR1A7022RB621436","insp_unit_decal":"Y","insp_unit_decal_number":"35492142","created_at":"2025-08-16T09:46:31.000000Z","updated_at":"2025-08-17T09:45:10.000000Z"}]},{"id":9144992,"change_date":"2025-07-14 21:41:00","inspection_id":"85211505","dot_number":"74616","report_state":"CA","report_number":"NETE002446","insp_date":"2025-07-09 00:00:00","insp_start_time":"1120","insp_end_time":"1138","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"DOUGLAS COUNTY BOTTLING CO","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15897265","transaction_code":"A","transaction_date":"2025-07-09 00:00:00","upload_date":"2025-07-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00074616","upload_search_indicator":null,"census_search_date":"2025-07-14 21:41:00","snet_input_date":"2025-07-09 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-07-14 21:41:00","insp_carrier_name":"DOUGLAS COUNTY BOTTLING CO INC","insp_carrier_street":"165 BOURBON ST","insp_carrier_city":"ROSEBURG","insp_carrier_state":"OR","insp_carrier_zip_code":"97471","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-18T10:45:50.000000Z","updated_at":"2025-07-18T10:45:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15017709,"change_date":"2025-07-14 21:41:00","inspection_id":"85211505","insp_unit_id":"207863200","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"RED\/P26","insp_unit_license":"YAJT063","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XKYD49X4LJ430115","insp_unit_decal":"Y","insp_unit_decal_number":"35332477","created_at":"2025-07-17T09:45:34.000000Z","updated_at":"2025-07-18T09:46:12.000000Z"},{"id":15017710,"change_date":"2025-07-14 21:41:00","inspection_id":"85211505","insp_unit_id":"207863201","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"RED\/T07","insp_unit_license":"HV16919","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1DW1A482XYS376133","insp_unit_decal":"Y","insp_unit_decal_number":"35332478","created_at":"2025-07-17T09:45:34.000000Z","updated_at":"2025-07-18T09:46:12.000000Z"}]},{"id":9145730,"change_date":"2025-07-14 21:41:00","inspection_id":"85212251","dot_number":"74616","report_state":"CA","report_number":"NCU6004774","insp_date":"2025-06-25 00:00:00","insp_start_time":"1107","insp_end_time":"1117","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","insp_level_id":"2","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":"N","pen_cen_match":null,"final_status_date":"2025-07-14 21:41: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":"15897858","transaction_code":"A","transaction_date":"2025-06-25 00:00:00","upload_date":"2025-07-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00074616","upload_search_indicator":null,"census_search_date":"2025-07-14 21:41:00","snet_input_date":"2025-06-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-07-14 21:41:00","insp_carrier_name":"DOUGLAS COUNTY BOTTLING CO INC","insp_carrier_street":"165 BOURBON ST","insp_carrier_city":"ROSEBURG","insp_carrier_state":"OR","insp_carrier_zip_code":"97471","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-18T10:45:50.000000Z","updated_at":"2025-07-18T10:45:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15019020,"change_date":"2025-07-14 21:41:00","inspection_id":"85212251","insp_unit_id":"207864556","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"RED","insp_unit_license":"YAJT063","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XKYD49X4LJ430115","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-17T09:45:35.000000Z","updated_at":"2025-07-18T09:46:16.000000Z"},{"id":15019021,"change_date":"2025-07-14 21:41:00","inspection_id":"85212251","insp_unit_id":"207864557","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRIM","insp_unit_company":"RED","insp_unit_license":"HV16920","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"2MN01JAH551009536","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-17T09:45:35.000000Z","updated_at":"2025-07-18T09:46:16.000000Z"}]},{"id":9006306,"change_date":"2025-06-26 21:42:00","inspection_id":"85065305","dot_number":"74616","report_state":"CA","report_number":"UGGH001097","insp_date":"2025-06-24 00:00:00","insp_start_time":"1420","insp_end_time":"1445","registration_date":null,"region":"PT","ci_status_code":"C","location":"120","location_desc":"US-199 N\/OF MIDDLE FORK ROAD","county_code_state":"CA","county_code":"015","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":"N","pen_cen_match":null,"final_status_date":"2025-06-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","viol_total":"4","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15871100","transaction_code":"A","transaction_date":"2025-06-24 00:00:00","upload_date":"2025-06-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00074616","upload_search_indicator":null,"census_search_date":"2025-06-26 21:42:00","snet_input_date":"2025-06-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-06-26 21:42:00","insp_carrier_name":"DOUGLAS COUNTY BOTTLING CO INC","insp_carrier_street":"165 BOURBON ST","insp_carrier_city":"ROSEBURG","insp_carrier_state":"OR","insp_carrier_zip_code":"97471","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-30T10:01:14.000000Z","updated_at":"2025-06-30T10:01:14.000000Z","inspection_violations":[{"id":14476042,"change_date":"2025-06-26 21:42:00","inspection_id":"85065305","insp_violation_id":"267080768","seq_no":"1","part_no":"392","part_no_section":"2-SLLTCD","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-06-29T10:17:06.000000Z","updated_at":"2025-06-30T10:18:56.000000Z","normalized_code":"3922SLLTCD"},{"id":14476043,"change_date":"2025-06-26 21:42:00","inspection_id":"85065305","insp_violation_id":"267080769","seq_no":"2","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"207593797","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-29T10:17:06.000000Z","updated_at":"2025-06-30T10:18:56.000000Z","normalized_code":"39395A1"},{"id":14476044,"change_date":"2025-06-26 21:42:00","inspection_id":"85065305","insp_violation_id":"267080770","seq_no":"3","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"207593797","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-29T10:17:06.000000Z","updated_at":"2025-06-30T10:18:56.000000Z","normalized_code":"39021TB2DOT"},{"id":14476045,"change_date":"2025-06-26 21:42:00","inspection_id":"85065305","insp_violation_id":"267080771","seq_no":"4","part_no":"393","part_no_section":"11A1-LRR","insp_viol_unit":"1","insp_unit_id":"207593797","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-29T10:17:06.000000Z","updated_at":"2025-06-30T10:18:56.000000Z","normalized_code":"39311A1LRR"}],"inspection_per_units":[{"id":14769986,"change_date":"2025-06-26 21:42:00","inspection_id":"85065305","insp_unit_id":"207593797","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"614QMX","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1GC5KSEY4SF191061","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-29T09:46:29.000000Z","updated_at":"2025-07-01T09:48:55.000000Z"}]},{"id":8809006,"change_date":"2025-06-03 21:41:00","inspection_id":"84856191","dot_number":"74616","report_state":"CA","report_number":"UGGH001050","insp_date":"2025-06-03 00:00:00","insp_start_time":"0945","insp_end_time":"1020","registration_date":null,"region":"PT","ci_status_code":"C","location":"120","location_desc":"US-101 N\/OF SANDMINE ROAD","county_code_state":"CA","county_code":"015","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":"N","pen_cen_match":null,"final_status_date":"2025-06-03 21:41: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":"15845748","transaction_code":"A","transaction_date":"2025-06-03 00:00:00","upload_date":"2025-06-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00074616","upload_search_indicator":null,"census_search_date":"2025-06-03 21:41:00","snet_input_date":"2025-06-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-06-03 21:41:00","insp_carrier_name":"DOUGLAS COUNTY BOTTLING CO INC","insp_carrier_street":"165 BOURBON ST","insp_carrier_city":"ROSEBURG","insp_carrier_state":"OR","insp_carrier_zip_code":"97471","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-06T10:01:09.000000Z","updated_at":"2025-06-07T10:00:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14418450,"change_date":"2025-06-03 21:41:00","inspection_id":"84856191","insp_unit_id":"207210334","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"P40","insp_unit_license":"YAKK575","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XPBDP9X4SD758214","insp_unit_decal":"Y","insp_unit_decal_number":"35048170","created_at":"2025-06-06T09:46:53.000000Z","updated_at":"2025-06-07T09:46:06.000000Z"},{"id":14418451,"change_date":"2025-06-03 21:41:00","inspection_id":"84856191","insp_unit_id":"207210335","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRIM","insp_unit_company":null,"insp_unit_license":"HV87464","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"2MN01JAL871007982","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-06T09:46:53.000000Z","updated_at":"2025-06-07T09:46:06.000000Z"}]},{"id":8418994,"change_date":"2025-04-18 21:41:00","inspection_id":"84444792","dot_number":"74616","report_state":"CA","report_number":"UGGH000995","insp_date":"2025-04-18 00:00:00","insp_start_time":"1045","insp_end_time":"1125","registration_date":null,"region":"PT","ci_status_code":"C","location":"120","location_desc":"US-199 N\/OF MIDDLE FORK ROAD","county_code_state":"CA","county_code":"015","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":"N","pen_cen_match":null,"final_status_date":"2025-04-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"15787713","transaction_code":"A","transaction_date":"2025-04-18 00:00:00","upload_date":"2025-04-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00074616","upload_search_indicator":null,"census_search_date":"2025-04-18 21:41:00","snet_input_date":"2025-04-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-04-18 21:41:00","insp_carrier_name":"DOUGLAS COUNTY BOTTLING CO INC","insp_carrier_street":"165 BOURBON ST","insp_carrier_city":"ROSEBURG","insp_carrier_state":"OR","insp_carrier_zip_code":"97471","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-21T10:26:24.000000Z","updated_at":"2025-04-23T10:03:49.000000Z","inspection_violations":[{"id":13284155,"change_date":"2025-04-18 21:41:00","inspection_id":"84444792","insp_violation_id":"265714462","seq_no":"1","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"206394336","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-20T11:18:58.000000Z","updated_at":"2025-04-22T10:36:27.000000Z","normalized_code":"39021TB2DOT"},{"id":13284156,"change_date":"2025-04-18 21:41:00","inspection_id":"84444792","insp_violation_id":"265714463","seq_no":"2","part_no":"393","part_no_section":"45D-BHTC","insp_viol_unit":"1","insp_unit_id":"206394336","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-20T11:18:58.000000Z","updated_at":"2025-04-22T10:36:27.000000Z","normalized_code":"39345DBHTC"}],"inspection_per_units":[{"id":13669254,"change_date":"2025-04-18 21:41:00","inspection_id":"84444792","insp_unit_id":"206394336","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"P40","insp_unit_license":"YAKK575","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XPBDP9X4SD758214","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-21T10:19:44.000000Z","updated_at":"2025-04-22T10:09:01.000000Z"},{"id":13669255,"change_date":"2025-04-18 21:41:00","inspection_id":"84444792","insp_unit_id":"206394337","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRIM","insp_unit_company":null,"insp_unit_license":"HV87464","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"2MN01JAL871007982","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-21T10:19:44.000000Z","updated_at":"2025-04-22T10:09:01.000000Z"}]},{"id":8057223,"change_date":"2025-03-07 21:39:00","inspection_id":"84063821","dot_number":"74616","report_state":"CA","report_number":"N92M007018","insp_date":"2025-03-05 00:00:00","insp_start_time":"0941","insp_end_time":"1000","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SAME","shipping_paper_number":"ROUTE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-07 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15730966","transaction_code":"A","transaction_date":"2025-03-07 00:00:00","upload_date":"2025-03-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00074616","upload_search_indicator":null,"census_search_date":"2025-03-07 21:39:00","snet_input_date":"2025-03-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-03-07 21:39:00","insp_carrier_name":"DOUGLAS COUNTY BOTTLING CO INC","insp_carrier_street":"165 BOURBON ST","insp_carrier_city":"ROSEBURG","insp_carrier_state":"OR","insp_carrier_zip_code":"97471","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:05:27.000000Z","updated_at":"2025-03-17T21:05:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13008418,"change_date":"2025-03-07 21:39:00","inspection_id":"84063821","insp_unit_id":"205685364","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"P26\/RED","insp_unit_license":"YAJT063","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XKYD49X4LJ430115","insp_unit_decal":"Y","insp_unit_decal_number":"34758168","created_at":"2025-03-17T23:58:42.000000Z","updated_at":"2025-03-17T23:58:42.000000Z"},{"id":13008419,"change_date":"2025-03-07 21:39:00","inspection_id":"84063821","insp_unit_id":"205685365","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRIM","insp_unit_company":"T11\/RED","insp_unit_license":"HV16920","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"2MN01JAH551009536","insp_unit_decal":"Y","insp_unit_decal_number":"34758169","created_at":"2025-03-17T23:58:42.000000Z","updated_at":"2025-03-17T23:58:42.000000Z"}]},{"id":7705929,"change_date":"2025-01-24 21:40:00","inspection_id":"83694920","dot_number":"74616","report_state":"CA","report_number":"NCU6004146","insp_date":"2025-01-15 00:00:00","insp_start_time":"0828","insp_end_time":"0838","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","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":"N","pen_cen_match":null,"final_status_date":"2025-01-24 21:40: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":"15677714","transaction_code":"A","transaction_date":"2025-01-15 00:00:00","upload_date":"2025-01-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00074616","upload_search_indicator":null,"census_search_date":"2025-01-24 21:40:00","snet_input_date":"2025-01-15 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-01-24 21:40:00","insp_carrier_name":"DOUGLAS COUNTY BOTTLING CO INC","insp_carrier_street":"165 BOURBON ST","insp_carrier_city":"ROSEBURG","insp_carrier_state":"OR","insp_carrier_zip_code":"97471","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:58:17.000000Z","updated_at":"2025-03-17T20:58:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12434834,"change_date":"2025-01-24 21:40:00","inspection_id":"83694920","insp_unit_id":"205000683","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"YAJT063","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XKYD49X4LJ430115","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:12.000000Z","updated_at":"2025-03-17T23:52:12.000000Z"},{"id":12434835,"change_date":"2025-01-24 21:40:00","inspection_id":"83694920","insp_unit_id":"205000684","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRIM","insp_unit_company":null,"insp_unit_license":"HV16920","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"2MN01JAH551009536","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:12.000000Z","updated_at":"2025-03-17T23:52:12.000000Z"}]},{"id":7604256,"change_date":"2025-01-14 21:54:00","inspection_id":"83588347","dot_number":"74616","report_state":"OR","report_number":"AP43050336","insp_date":"2025-01-13 00:00:00","insp_start_time":"1305","insp_end_time":"1324","registration_date":null,"region":"PS","ci_status_code":"C","location":"17-03","location_desc":"WILDERVILLE OR","county_code_state":"OR","county_code":"033","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":"2025-01-13 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"97000","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":"1243659","transaction_code":"C","transaction_date":"2025-01-13 00:00:00","upload_date":"2025-01-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00074616","upload_search_indicator":null,"census_search_date":"2025-01-13 21:45:00","snet_input_date":"2025-01-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-13 21:45:00","insp_carrier_name":"DOUGLAS COUNTY BOTTLING CO INC","insp_carrier_street":"165 BOURBON ST","insp_carrier_city":"ROSEBURG","insp_carrier_state":"OR","insp_carrier_zip_code":"97471","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:56:06.000000Z","updated_at":"2025-03-17T20:56:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12270016,"change_date":"2025-01-14 21:54:00","inspection_id":"83588347","insp_unit_id":"204809038","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"M403","insp_unit_license":"YAIM940","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1HSHUADN63J060308","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:26.000000Z","updated_at":"2025-03-17T23:50:26.000000Z"},{"id":12270017,"change_date":"2025-01-14 21:54:00","inspection_id":"83588347","insp_unit_id":"204809039","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TAIL","insp_unit_company":"T03","insp_unit_license":"HS88998","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"2MN01AAL531006444","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:26.000000Z","updated_at":"2025-03-17T23:50:26.000000Z"}]},{"id":6973855,"change_date":"2024-10-16 21:41:00","inspection_id":"82922974","dot_number":"74616","report_state":"CA","report_number":"N92M006508","insp_date":"2024-10-09 00:00:00","insp_start_time":"0808","insp_end_time":"0824","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SAME","shipping_paper_number":"511","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":"2024-10-16 21:41: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":"15558453","transaction_code":"A","transaction_date":"2024-10-16 00:00:00","upload_date":"2024-10-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00074616","upload_search_indicator":null,"census_search_date":"2024-10-16 21:41:00","snet_input_date":"2024-10-09 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-10-16 21:41:00","insp_carrier_name":"DOUGLAS COUNTY BOTTLING CO INC","insp_carrier_street":"165 BOURBON ST","insp_carrier_city":"ROSEBURG","insp_carrier_state":"OR","insp_carrier_zip_code":"97471","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:41:26.000000Z","updated_at":"2025-03-17T20:41:26.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11248142,"change_date":"2024-10-16 21:41:00","inspection_id":"82922974","insp_unit_id":"203441983","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"P26\/RED","insp_unit_license":"YAJT063","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XKYD49X4LJ430115","insp_unit_decal":"Y","insp_unit_decal_number":"34460447","created_at":"2025-03-17T23:39:25.000000Z","updated_at":"2025-03-17T23:39:25.000000Z"},{"id":11248143,"change_date":"2024-10-16 21:41:00","inspection_id":"82922974","insp_unit_id":"203441984","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRIM","insp_unit_company":"T11\/RED","insp_unit_license":"HV16920","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"2MN01JAH551009536","insp_unit_decal":"Y","insp_unit_decal_number":"34460448","created_at":"2025-03-17T23:39:25.000000Z","updated_at":"2025-03-17T23:39:25.000000Z"}]},{"id":6825066,"change_date":"2024-09-26 21:40:00","inspection_id":"82764942","dot_number":"74616","report_state":"OR","report_number":"BR42990029","insp_date":"2024-09-26 00:00:00","insp_start_time":"1418","insp_end_time":"1508","registration_date":null,"region":"PD","ci_status_code":"C","location":"15-09","location_desc":"LAKE CREEK OR","county_code_state":"OR","county_code":"029","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"COCA COLA","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-09-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"888201","transaction_code":"A","transaction_date":"2024-09-26 00:00:00","upload_date":"2024-09-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00074616","upload_search_indicator":null,"census_search_date":"2024-09-26 21:40:00","snet_input_date":"2024-09-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-09-26 21:40:00","insp_carrier_name":"DOUGLAS COUNTY BOTTLING CO INC","insp_carrier_street":"165 BOURBON ST","insp_carrier_city":"ROSEBURG","insp_carrier_state":"OR","insp_carrier_zip_code":"97471","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:38:35.000000Z","updated_at":"2025-03-17T20:38:35.000000Z","inspection_violations":[{"id":10630304,"change_date":"2024-09-26 21:40:00","inspection_id":"82764942","insp_violation_id":"262046901","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"203141027","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:29.000000Z","updated_at":"2025-03-17T21:57:29.000000Z","normalized_code":"39347E"},{"id":10630305,"change_date":"2024-09-26 21:40:00","inspection_id":"82764942","insp_violation_id":"262046902","seq_no":"2","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"203141027","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:29.000000Z","updated_at":"2025-03-17T21:57:29.000000Z","normalized_code":"39353B"},{"id":10630306,"change_date":"2024-09-26 21:40:00","inspection_id":"82764942","insp_violation_id":"262046903","seq_no":"3","part_no":"393","part_no_section":"11(b)","insp_viol_unit":"2","insp_unit_id":"203141027","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:29.000000Z","updated_at":"2025-03-17T21:57:29.000000Z","normalized_code":"39311B"},{"id":10630307,"change_date":"2024-09-26 21:40:00","inspection_id":"82764942","insp_violation_id":"262046904","seq_no":"4","part_no":"393","part_no_section":"205(c)","insp_viol_unit":"2","insp_unit_id":"203141027","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:29.000000Z","updated_at":"2025-03-17T21:57:29.000000Z","normalized_code":"393205C"}],"inspection_per_units":[{"id":11006247,"change_date":"2024-09-26 21:40:00","inspection_id":"82764942","insp_unit_id":"203141026","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"P14","insp_unit_license":"YAIV380","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1HSDJSJR4CH673572","insp_unit_decal":"Y","insp_unit_decal_number":"34339027","created_at":"2025-03-17T23:37:00.000000Z","updated_at":"2025-03-17T23:37:00.000000Z"},{"id":11006248,"change_date":"2024-09-26 21:40:00","inspection_id":"82764942","insp_unit_id":"203141027","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"T10","insp_unit_license":"HV16917","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"2MN01JAL821002855","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:00.000000Z","updated_at":"2025-03-17T23:37:00.000000Z"}]},{"id":6825074,"change_date":"2024-09-26 21:40:00","inspection_id":"82764950","dot_number":"74616","report_state":"OR","report_number":"BR42990028","insp_date":"2024-09-26 00:00:00","insp_start_time":"1251","insp_end_time":"1320","registration_date":null,"region":"PD","ci_status_code":"C","location":"15-09","location_desc":"LAKE CREEK OR","county_code_state":"OR","county_code":"029","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"COCA COLA","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-09-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"888200","transaction_code":"A","transaction_date":"2024-09-26 00:00:00","upload_date":"2024-09-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00074616","upload_search_indicator":null,"census_search_date":"2024-09-26 21:40:00","snet_input_date":"2024-09-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-09-26 21:40:00","insp_carrier_name":"DOUGLAS COUNTY BOTTLING CO INC","insp_carrier_street":"165 BOURBON ST","insp_carrier_city":"ROSEBURG","insp_carrier_state":"OR","insp_carrier_zip_code":"97471","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:38:35.000000Z","updated_at":"2025-03-17T20:38:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11006261,"change_date":"2024-09-26 21:40:00","inspection_id":"82764950","insp_unit_id":"203141042","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"P29","insp_unit_license":"YAJY817","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XPBDP9X5PD884430","insp_unit_decal":"Y","insp_unit_decal_number":"34339025","created_at":"2025-03-17T23:37:00.000000Z","updated_at":"2025-03-17T23:37:00.000000Z"},{"id":11006262,"change_date":"2024-09-26 21:40:00","inspection_id":"82764950","insp_unit_id":"203141043","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"T34","insp_unit_license":"HV87506","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1GR1A7022RB621436","insp_unit_decal":"Y","insp_unit_decal_number":"34339026","created_at":"2025-03-17T23:37:00.000000Z","updated_at":"2025-03-17T23:37:00.000000Z"}]},{"id":6416955,"change_date":"2024-08-07 21:41:00","inspection_id":"82330003","dot_number":"74616","report_state":"CA","report_number":"UGGH000548","insp_date":"2024-08-07 00:00:00","insp_start_time":"1100","insp_end_time":"1130","registration_date":null,"region":"PT","ci_status_code":"C","location":"120","location_desc":"SR-197 AT MPM 6.50","county_code_state":"CA","county_code":"015","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":"N","pen_cen_match":null,"final_status_date":"2024-08-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15474885","transaction_code":"A","transaction_date":"2024-08-07 00:00:00","upload_date":"2024-08-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00074616","upload_search_indicator":null,"census_search_date":"2024-08-07 21:41:00","snet_input_date":"2024-08-07 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-08-07 21:41:00","insp_carrier_name":"DOUGLAS COUNTY BOTTLING CO INC","insp_carrier_street":"165 BOURBON ST","insp_carrier_city":"ROSEBURG","insp_carrier_state":"OR","insp_carrier_zip_code":"97471","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:29:55.000000Z","updated_at":"2025-03-17T20:29:55.000000Z","inspection_violations":[{"id":9963897,"change_date":"2024-08-07 21:41:00","inspection_id":"82330003","insp_violation_id":"261076940","seq_no":"1","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"202289008","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:13.000000Z","updated_at":"2025-03-17T21:54:13.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":10341889,"change_date":"2024-08-07 21:41:00","inspection_id":"82330003","insp_unit_id":"202289007","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"P30","insp_unit_license":"YAJY818","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XPBDP9X9PD884429","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:10.000000Z","updated_at":"2025-03-17T23:30:10.000000Z"},{"id":10341890,"change_date":"2024-08-07 21:41:00","inspection_id":"82330003","insp_unit_id":"202289008","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRWD","insp_unit_company":null,"insp_unit_license":"HV16918","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"2MN01JALX41001726","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:10.000000Z","updated_at":"2025-03-17T23:30:10.000000Z"}]},{"id":6031142,"change_date":"2025-07-23 21:41:00","inspection_id":"81915990","dot_number":"74616","report_state":"OR","report_number":"AP43050062","insp_date":"2024-06-14 00:00:00","insp_start_time":"1441","insp_end_time":"1449","registration_date":null,"region":"PD","ci_status_code":"C","location":"15-07","location_desc":"ASHLAND  OR","county_code_state":"OR","county_code":"029","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"00000000","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-06-20 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"571034","transaction_code":"C","transaction_date":"2024-06-14 00:00:00","upload_date":"2025-07-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00074616","upload_search_indicator":null,"census_search_date":"2024-06-20 21:42:00","snet_input_date":"2024-06-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-06-20 21:42:00","insp_carrier_name":"DOUGLAS COUNTY BOTTLING CO INC","insp_carrier_street":"165 BOURBON ST","insp_carrier_city":"ROSEBURG","insp_carrier_state":"OR","insp_carrier_zip_code":"97471","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:22:16.000000Z","updated_at":"2025-07-27T10:41:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15162247,"change_date":"2025-07-23 21:41:00","inspection_id":"81915990","insp_unit_id":"208024896","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"P26","insp_unit_license":"YAJT063","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XKYD49X4LJ430115","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-26T09:46:20.000000Z","updated_at":"2025-07-27T09:45:07.000000Z"},{"id":15162248,"change_date":"2025-07-23 21:41:00","inspection_id":"81915990","insp_unit_id":"208024897","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"PULLMAN TR","insp_unit_company":"T11\/RED","insp_unit_license":"HV16920","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"2MN01JAH551009536","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-26T09:46:20.000000Z","updated_at":"2025-07-27T09:45:07.000000Z"}]},{"id":5916404,"change_date":"2024-06-05 21:41:00","inspection_id":"81791661","dot_number":"74616","report_state":"OR","report_number":"AP43050019","insp_date":"2024-06-05 00:00:00","insp_start_time":"0800","insp_end_time":"0859","registration_date":null,"region":"PD","ci_status_code":"C","location":"08-04","location_desc":"BROOKINGS OR","county_code_state":"OR","county_code":"015","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"00000","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-06-05 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52350","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"543960","transaction_code":"A","transaction_date":"2024-06-05 00:00:00","upload_date":"2024-06-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00074616","upload_search_indicator":null,"census_search_date":"2024-06-05 21:41:00","snet_input_date":"2024-06-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-06-05 21:41:00","insp_carrier_name":"DOUGLAS COUNTY BOTTLING CO INC","insp_carrier_street":"165 BOURBON ST","insp_carrier_city":"ROSEBURG","insp_carrier_state":"OR","insp_carrier_zip_code":"97471","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:19:52.000000Z","updated_at":"2025-03-17T20:19:52.000000Z","inspection_violations":[{"id":9174434,"change_date":"2024-06-05 21:41:00","inspection_id":"81791661","insp_violation_id":"259912698","seq_no":"1","part_no":"396","part_no_section":"9(d)(2)","insp_viol_unit":"1","insp_unit_id":"201241076","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:20.000000Z","updated_at":"2025-03-17T21:50:20.000000Z","normalized_code":"3969D2"},{"id":9174435,"change_date":"2024-06-05 21:41:00","inspection_id":"81791661","insp_violation_id":"259912699","seq_no":"2","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"201241077","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:20.000000Z","updated_at":"2025-03-17T21:50:20.000000Z","normalized_code":"39355E"}],"inspection_per_units":[{"id":9529397,"change_date":"2024-06-05 21:41:00","inspection_id":"81791661","insp_unit_id":"201241076","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"P09","insp_unit_license":"YAJT059","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1HSDJSJR9CH672918","insp_unit_decal":"Y","insp_unit_decal_number":"34025657","created_at":"2025-03-17T23:21:49.000000Z","updated_at":"2025-03-17T23:21:49.000000Z"},{"id":9529398,"change_date":"2024-06-05 21:41:00","inspection_id":"81791661","insp_unit_id":"201241077","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHER","insp_unit_company":"T10","insp_unit_license":"HV16917","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1HSDJSJR9CH673521","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:49.000000Z","updated_at":"2025-03-17T23:21:49.000000Z"}]},{"id":5879997,"change_date":"2024-05-30 21:43:00","inspection_id":"81751795","dot_number":"74616","report_state":"CA","report_number":"NCV6006896","insp_date":"2024-05-29 00:00:00","insp_start_time":"1126","insp_end_time":"1145","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"COCA-COLA","shipping_paper_number":"ROUGH # 511","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":"2024-05-30 21:43: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":"15384005","transaction_code":"A","transaction_date":"2024-05-30 00:00:00","upload_date":"2024-05-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00074616","upload_search_indicator":null,"census_search_date":"2024-05-30 21:43:00","snet_input_date":"2024-05-29 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-05-30 21:43:00","insp_carrier_name":"DOUGLAS COUNTY BOTTLING CO INC","insp_carrier_street":"165 BOURBON ST","insp_carrier_city":"ROSEBURG","insp_carrier_state":"OR","insp_carrier_zip_code":"97471","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:19:08.000000Z","updated_at":"2025-03-17T20:19:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9470386,"change_date":"2024-05-30 21:43:00","inspection_id":"81751795","insp_unit_id":"201163038","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"P26\/RED","insp_unit_license":"YAJT063","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XKYD49X4LJ430115","insp_unit_decal":"Y","insp_unit_decal_number":"33797389","created_at":"2025-03-17T23:21:16.000000Z","updated_at":"2025-03-17T23:21:16.000000Z"},{"id":9470387,"change_date":"2024-05-30 21:43:00","inspection_id":"81751795","insp_unit_id":"201163039","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRIM","insp_unit_company":"T11\/RED","insp_unit_license":"HV16920","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"2MN01JAH551009536","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:16.000000Z","updated_at":"2025-03-17T23:21:16.000000Z"}]},{"id":5536840,"change_date":"2024-04-17 21:42:00","inspection_id":"81379269","dot_number":"74616","report_state":"CA","report_number":"UGGH000348","insp_date":"2024-04-17 00:00:00","insp_start_time":"1025","insp_end_time":"1100","registration_date":null,"region":"PT","ci_status_code":"C","location":"120","location_desc":"SR-197 AT MPM 6.50","county_code_state":"CA","county_code":"015","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":"N","pen_cen_match":null,"final_status_date":"2024-04-17 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","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":"15323287","transaction_code":"A","transaction_date":"2024-04-17 00:00:00","upload_date":"2024-04-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00074616","upload_search_indicator":null,"census_search_date":"2024-04-17 21:42:00","snet_input_date":"2024-04-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-04-17 21:42:00","insp_carrier_name":"DOUGLAS COUNTY BOTTLING CO INC","insp_carrier_street":"165 BOURBON ST","insp_carrier_city":"ROSEBURG","insp_carrier_state":"OR","insp_carrier_zip_code":"97471","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:12:23.000000Z","updated_at":"2025-03-17T20:12:23.000000Z","inspection_violations":[{"id":8555896,"change_date":"2024-04-17 21:42:00","inspection_id":"81379269","insp_violation_id":"258994284","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"200452320","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:26.000000Z","updated_at":"2025-03-17T21:47:26.000000Z","normalized_code":"39347E"},{"id":8555897,"change_date":"2024-04-17 21:42:00","inspection_id":"81379269","insp_violation_id":"258994285","seq_no":"2","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"200452320","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:26.000000Z","updated_at":"2025-03-17T21:47:26.000000Z","normalized_code":"39353B"},{"id":8555898,"change_date":"2024-04-17 21:42:00","inspection_id":"81379269","insp_violation_id":"258994286","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"200452320","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:26.000000Z","updated_at":"2025-03-17T21:47:26.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":8918824,"change_date":"2024-04-17 21:42:00","inspection_id":"81379269","insp_unit_id":"200452319","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"P12","insp_unit_license":"YAIS590","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1HSDJSJR7CH673453","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:59.000000Z","updated_at":"2025-03-17T23:15:59.000000Z"},{"id":8918825,"change_date":"2024-04-17 21:42:00","inspection_id":"81379269","insp_unit_id":"200452320","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRIM","insp_unit_company":"T14","insp_unit_license":"HV30296","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"2MN01JAH371005021","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:59.000000Z","updated_at":"2025-03-17T23:15:59.000000Z"}]},{"id":5237985,"change_date":"2024-03-07 21:39:00","inspection_id":"81053062","dot_number":"74616","report_state":"CA","report_number":"NCV6006516","insp_date":"2024-03-06 00:00:00","insp_start_time":"1005","insp_end_time":"1016","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"COCA-COLA","shipping_paper_number":"511 ROUGHT #","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":"2024-03-07 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"15273217","transaction_code":"A","transaction_date":"2024-03-07 00:00:00","upload_date":"2024-03-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00074616","upload_search_indicator":null,"census_search_date":"2024-03-07 21:39:00","snet_input_date":"2024-03-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-03-07 21:39:00","insp_carrier_name":"DOUGLAS COUNTY BOTTLING CO INC","insp_carrier_street":"165 BOURBON ST","insp_carrier_city":"ROSEBURG","insp_carrier_state":"OR","insp_carrier_zip_code":"97471","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:06:16.000000Z","updated_at":"2025-03-17T20:06:16.000000Z","inspection_violations":[{"id":8075805,"change_date":"2024-03-07 21:39:00","inspection_id":"81053062","insp_violation_id":"258269596","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"199811986","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:45:00.000000Z","updated_at":"2025-03-17T21:45:00.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":8434543,"change_date":"2024-03-07 21:39:00","inspection_id":"81053062","insp_unit_id":"199811985","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"P26\/RED","insp_unit_license":"YAJT063","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XKYD49X4LJ430115","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:25.000000Z","updated_at":"2025-03-17T23:11:25.000000Z"},{"id":8434544,"change_date":"2024-03-07 21:39:00","inspection_id":"81053062","insp_unit_id":"199811986","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRIM","insp_unit_company":"T11\/RED","insp_unit_license":"HV16920","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"2MN01JAH551009536","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:25.000000Z","updated_at":"2025-03-17T23:11:25.000000Z"}]},{"id":5115247,"change_date":"2024-02-22 21:43:00","inspection_id":"80919257","dot_number":"74616","report_state":"OR","report_number":"AAKG007280","insp_date":"2024-02-21 00:00:00","insp_start_time":"1051","insp_end_time":"1104","registration_date":null,"region":"PT","ci_status_code":"C","location":"1514","location_desc":"EAGLE POINT NB MES","county_code_state":"OR","county_code":"029","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"COCA-COLA BOTTLING CO OF ROSEBURG","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":"2024-02-22 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"34700","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":"1242916","transaction_code":"A","transaction_date":"2024-02-21 00:00:00","upload_date":"2024-02-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00074616","upload_search_indicator":null,"census_search_date":"2024-02-22 21:43:00","snet_input_date":"2024-02-22 00:00:00","source_office":"4ORS001","mcmis_add_date":"2024-02-22 21:43:00","insp_carrier_name":"DOUGLAS COUNTY BOTTLING CO INC","insp_carrier_street":"165 BOURBON ST","insp_carrier_city":"ROSEBURG","insp_carrier_state":"OR","insp_carrier_zip_code":"97471","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"093696","created_at":"2025-03-17T20:03:51.000000Z","updated_at":"2025-03-17T20:03:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8235467,"change_date":"2024-02-22 21:43:00","inspection_id":"80919257","insp_unit_id":"199556477","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"P05","insp_unit_license":"YARZ560","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1FUBCYDJ75HN74520","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:39.000000Z","updated_at":"2025-03-17T23:09:39.000000Z"},{"id":8235468,"change_date":"2024-02-22 21:43:00","inspection_id":"80919257","insp_unit_id":"199556478","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HACK","insp_unit_company":"T05","insp_unit_license":"HV16916","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1HHRTX218VM000726","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:39.000000Z","updated_at":"2025-03-17T23:09:39.000000Z"}]},{"id":4530615,"change_date":"2023-11-30 21:39:00","inspection_id":"80279568","dot_number":"74616","report_state":"CA","report_number":"N92M005261","insp_date":"2023-11-15 00:00:00","insp_start_time":"0942","insp_end_time":"0950","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SAME","shipping_paper_number":"ROUTE","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-30 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15150016","transaction_code":"A","transaction_date":"2023-11-29 00:00:00","upload_date":"2023-11-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00074616","upload_search_indicator":null,"census_search_date":"2023-11-30 21:39:00","snet_input_date":"2023-11-15 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-11-30 21:39:00","insp_carrier_name":"DOUGLAS COUNTY BOTTLING CO INC","insp_carrier_street":"165 BOURBON ST","insp_carrier_city":"ROSEBURG","insp_carrier_state":"OR","insp_carrier_zip_code":"97471","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:52:35.000000Z","updated_at":"2025-03-17T19:52:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7286712,"change_date":"2023-11-30 21:39:00","inspection_id":"80279568","insp_unit_id":"198290713","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"26\/RED","insp_unit_license":"YAJT063","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XKYD49X4LJ430115","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:13.000000Z","updated_at":"2025-03-17T23:01:13.000000Z"},{"id":7286713,"change_date":"2023-11-30 21:39:00","inspection_id":"80279568","insp_unit_id":"198290714","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRIM","insp_unit_company":"11\/RED","insp_unit_license":"HV16920","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"2MN01JAH551009536","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:13.000000Z","updated_at":"2025-03-17T23:01:13.000000Z"}]},{"id":4434234,"change_date":"2023-11-15 21:42:00","inspection_id":"80173641","dot_number":"74616","report_state":"OR","report_number":"AADN002507","insp_date":"2023-11-14 00:00:00","insp_start_time":"1338","insp_end_time":"1352","registration_date":null,"region":"PT","ci_status_code":"C","location":"1509","location_desc":"LAKE CREEK - 20 MI E MEDFORD","county_code_state":"OR","county_code":"029","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":null,"shipping_paper_number":"00000","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-11-15 21:42: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":"1237489","transaction_code":"A","transaction_date":"2023-11-14 00:00:00","upload_date":"2023-11-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00074616","upload_search_indicator":null,"census_search_date":"2023-11-15 21:42:00","snet_input_date":"2023-11-15 00:00:00","source_office":"4ORS001","mcmis_add_date":"2023-11-15 21:42:00","insp_carrier_name":"DOUGLAS COUNTY BOTTLING CO INC","insp_carrier_street":"165 BOURBON ST","insp_carrier_city":"ROSEBURG","insp_carrier_state":"OR","insp_carrier_zip_code":"97471","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"093696","created_at":"2025-03-17T19:50:44.000000Z","updated_at":"2025-03-17T19:50:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7131113,"change_date":"2023-11-15 21:42:00","inspection_id":"80173641","insp_unit_id":"198079947","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"P30","insp_unit_license":"YAJY818","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XPBDP9X9PD884429","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:53.000000Z","updated_at":"2025-03-17T22:59:53.000000Z"},{"id":7131114,"change_date":"2023-11-15 21:42:00","inspection_id":"80173641","insp_unit_id":"198079948","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRIM","insp_unit_company":"T09","insp_unit_license":"HV16918","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:59:53.000000Z","updated_at":"2025-03-17T22:59:53.000000Z"}]},{"id":3835475,"change_date":"2023-08-29 21:42:00","inspection_id":"79509720","dot_number":"74616","report_state":"OR","report_number":"AADK000448","insp_date":"2023-08-24 00:00:00","insp_start_time":"1253","insp_end_time":"1329","registration_date":"2023-08-29 00:00:00","region":"PT","ci_status_code":"C","location":"1504","location_desc":"ASHLAND NB - 2 MI N ASHLAND","county_code_state":"OR","county_code":"029","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"COCA-COLA BOTTLING CO OF ROSEBURG","shipping_paper_number":"510","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":"52350","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":"1232021","transaction_code":"C","transaction_date":"2023-08-24 00:00:00","upload_date":"2023-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00074616","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":"DOUGLAS COUNTY BOTTLING CO INC","insp_carrier_street":"165 BOURBON ST","insp_carrier_city":"ROSEBURG","insp_carrier_state":"OR","insp_carrier_zip_code":"97471","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"093696","created_at":"2025-03-17T19:38:33.000000Z","updated_at":"2025-03-17T19:38:33.000000Z","inspection_violations":[{"id":5923955,"change_date":"2023-08-29 21:42:00","inspection_id":"79509720","insp_violation_id":"254958860","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"196794199","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":"3963A1"},{"id":5923956,"change_date":"2023-08-29 21:42:00","inspection_id":"79509720","insp_violation_id":"254958861","seq_no":"2","part_no":"393","part_no_section":"205(c)","insp_viol_unit":"1","insp_unit_id":"196794199","insp_violation_category_id":"24","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":"393205C"},{"id":5923957,"change_date":"2023-08-29 21:42:00","inspection_id":"79509720","insp_violation_id":"254958862","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"196794200","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":5923958,"change_date":"2023-08-29 21:42:00","inspection_id":"79509720","insp_violation_id":"254958863","seq_no":"4","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"196794200","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":"39355E"}],"inspection_per_units":[{"id":6166756,"change_date":"2023-08-29 21:42:00","inspection_id":"79509720","insp_unit_id":"196794199","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"M412","insp_unit_license":"YAIM945","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1HSDJSJR9CH673521","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":6166757,"change_date":"2023-08-29 21:42:00","inspection_id":"79509720","insp_unit_id":"196794200","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"T10","insp_unit_license":"HV16917","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1HSDJSJR9CH673521","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":4026833,"change_date":"2023-09-21 21:41:00","inspection_id":"79722520","dot_number":"74616","report_state":"CA","report_number":"NCV6005776","insp_date":"2023-08-23 00:00:00","insp_start_time":"1110","insp_end_time":"1125","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","insp_level_id":"1","service_center":"WE","census_source_id":"5","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-21 21:41: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":"15070158","transaction_code":"A","transaction_date":"2023-09-21 00:00:00","upload_date":"2023-09-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00074616","upload_search_indicator":null,"census_search_date":"2023-09-21 21:41:00","snet_input_date":"2023-08-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-09-21 21:41:00","insp_carrier_name":"DOUGLAS COUNTY BOTTLING CO INC","insp_carrier_street":"165 BOURBON ST","insp_carrier_city":"ROSEBURG","insp_carrier_state":"OR","insp_carrier_zip_code":"97471","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:42:24.000000Z","updated_at":"2025-03-17T19:42:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6474928,"change_date":"2023-09-21 21:41:00","inspection_id":"79722520","insp_unit_id":"197174404","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"P30\/RED","insp_unit_license":"YAJY818","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XPBDP9X9PD884429","insp_unit_decal":"Y","insp_unit_decal_number":"32837347","created_at":"2025-03-17T22:54:19.000000Z","updated_at":"2025-03-17T22:54:19.000000Z"},{"id":6474929,"change_date":"2023-09-21 21:41:00","inspection_id":"79722520","insp_unit_id":"197174405","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRIM","insp_unit_company":"T09\/RED","insp_unit_license":"HV16918","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"2MN01JALX41001726","insp_unit_decal":"Y","insp_unit_decal_number":"32837348","created_at":"2025-03-17T22:54:19.000000Z","updated_at":"2025-03-17T22:54:19.000000Z"}]},{"id":3717659,"change_date":"2023-08-16 21:39:00","inspection_id":"79378177","dot_number":"74616","report_state":"OR","report_number":"AAAZ007217","insp_date":"2023-08-09 00:00:00","insp_start_time":"1300","insp_end_time":"1326","registration_date":"2023-08-16 00:00:00","region":"PT","ci_status_code":"C","location":"1507","location_desc":"ASHLAND POE - 3.5 MI N ASHLAND","county_code_state":"OR","county_code":"029","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"COCA-COLA BOTTLING CO OF ROSEBURG","shipping_paper_number":"508","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-10 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1230712","transaction_code":"C","transaction_date":"2023-08-09 00:00:00","upload_date":"2023-08-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00074616","upload_search_indicator":null,"census_search_date":"2023-08-10 21:42:00","snet_input_date":"2023-08-10 00:00:00","source_office":"4ORS001","mcmis_add_date":"2023-08-10 21:42:00","insp_carrier_name":"DOUGLAS COUNTY BOTTLING CO INC","insp_carrier_street":"165 BOURBON ST","insp_carrier_city":"ROSEBURG","insp_carrier_state":"OR","insp_carrier_zip_code":"97471","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"093696","created_at":"2025-03-17T19:36:09.000000Z","updated_at":"2025-03-17T19:36:09.000000Z","inspection_violations":[{"id":5732649,"change_date":"2023-08-16 21:39:00","inspection_id":"79378177","insp_violation_id":"254690768","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"196564703","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:32.000000Z","updated_at":"2025-03-17T21:33:32.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":5977492,"change_date":"2023-08-16 21:39:00","inspection_id":"79378177","insp_unit_id":"196564703","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"P13","insp_unit_license":"YAIV379","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1HSDJSJR7CH673498","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:14.000000Z","updated_at":"2025-03-17T22:50:14.000000Z"},{"id":5977493,"change_date":"2023-08-16 21:39:00","inspection_id":"79378177","insp_unit_id":"196564704","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"T08","insp_unit_license":"HU24490","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:50:14.000000Z","updated_at":"2025-03-17T22:50:14.000000Z"}]},{"id":3780870,"change_date":"2023-08-18 21:42:00","inspection_id":"79448552","dot_number":"74616","report_state":"CA","report_number":"N92M004798","insp_date":"2023-07-26 00:00:00","insp_start_time":"1203","insp_end_time":"1218","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"COCA COLA","shipping_paper_number":"ROUTE","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-08-18 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":"15027660","transaction_code":"A","transaction_date":"2023-07-26 00:00:00","upload_date":"2023-08-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00074616","upload_search_indicator":null,"census_search_date":"2023-08-18 21:42:00","snet_input_date":"2023-07-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-08-18 21:42:00","insp_carrier_name":"DOUGLAS COUNTY BOTTLING CO INC","insp_carrier_street":"165 BOURBON ST","insp_carrier_city":"ROSEBURG","insp_carrier_state":"OR","insp_carrier_zip_code":"97471","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:37:38.000000Z","updated_at":"2025-03-17T19:37:38.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6079264,"change_date":"2023-08-18 21:42:00","inspection_id":"79448552","insp_unit_id":"196617670","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRGH","insp_unit_company":"P06\/RED","insp_unit_license":"YAIM941","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1FUJA6CV65LN82809","insp_unit_decal":"Y","insp_unit_decal_number":"32833819","created_at":"2025-03-17T22:51:04.000000Z","updated_at":"2025-03-17T22:51:04.000000Z"},{"id":6079265,"change_date":"2023-08-18 21:42:00","inspection_id":"79448552","insp_unit_id":"196617671","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"T07\/RED","insp_unit_license":"HV16919","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1DW1A482XYS376133","insp_unit_decal":"Y","insp_unit_decal_number":"32833820","created_at":"2025-03-17T22:51:04.000000Z","updated_at":"2025-03-17T22:51:04.000000Z"}]},{"id":2948182,"change_date":"2023-05-02 21:41:00","inspection_id":"78511957","dot_number":"74616","report_state":"CA","report_number":"NBTJ004115","insp_date":"2023-04-05 00:00:00","insp_start_time":"1113","insp_end_time":"1124","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"COCA COLA","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-05-02 21:41: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":"14884377","transaction_code":"A","transaction_date":"2023-04-05 00:00:00","upload_date":"2023-05-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00074616","upload_search_indicator":null,"census_search_date":"2023-05-02 21:41:00","snet_input_date":"2023-04-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-05-02 21:41:00","insp_carrier_name":"DOUGLAS COUNTY BOTTLING CO INC","insp_carrier_street":"165 BOURBON ST","insp_carrier_city":"ROSEBURG","insp_carrier_state":"OR","insp_carrier_zip_code":"97471","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:21:22.000000Z","updated_at":"2025-03-17T19:21:22.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4743756,"change_date":"2023-05-02 21:41:00","inspection_id":"78511957","insp_unit_id":"194712217","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"RED","insp_unit_license":"YAJT063","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XKYD49X4LJ430115","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:23.000000Z","updated_at":"2025-03-17T22:40:23.000000Z"},{"id":4743757,"change_date":"2023-05-02 21:41:00","inspection_id":"78511957","insp_unit_id":"194712218","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRIM","insp_unit_company":"RED","insp_unit_license":"HV16920","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"2MN01JAH551009536","insp_unit_decal":"Y","insp_unit_decal_number":"32446763","created_at":"2025-03-17T22:40:23.000000Z","updated_at":"2025-03-17T22:40:23.000000Z"}]},{"id":2949020,"change_date":"2023-05-02 21:41:00","inspection_id":"78512863","dot_number":"74616","report_state":"CA","report_number":"NCV6005253","insp_date":"2023-04-05 00:00:00","insp_start_time":"0925","insp_end_time":"0941","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"COCA-COLA","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"2","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14884599","transaction_code":"A","transaction_date":"2023-04-05 00:00:00","upload_date":"2023-05-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00074616","upload_search_indicator":null,"census_search_date":"2023-05-02 21:41:00","snet_input_date":"2023-04-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-05-02 21:41:00","insp_carrier_name":"DOUGLAS COUNTY BOTTLING CO INC","insp_carrier_street":"165 BOURBON ST","insp_carrier_city":"ROSEBURG","insp_carrier_state":"OR","insp_carrier_zip_code":"97471","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:21:23.000000Z","updated_at":"2025-03-17T19:21:23.000000Z","inspection_violations":[{"id":4526930,"change_date":"2023-05-02 21:41:00","inspection_id":"78512863","insp_violation_id":"252581169","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"194713746","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"DA305748","created_at":"2025-03-17T21:28:06.000000Z","updated_at":"2025-03-17T21:28:06.000000Z","normalized_code":"39375A3"},{"id":4526931,"change_date":"2023-05-02 21:41:00","inspection_id":"78512863","insp_violation_id":"252581170","seq_no":"2","part_no":"393","part_no_section":"45","insp_viol_unit":"2","insp_unit_id":"194713746","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:28:06.000000Z","updated_at":"2025-03-17T21:28:06.000000Z","normalized_code":"39345"}],"inspection_per_units":[{"id":4745133,"change_date":"2023-05-02 21:41:00","inspection_id":"78512863","insp_unit_id":"194713745","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"P26\/RED","insp_unit_license":"YAJT063","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XKYD49X4LJ430115","insp_unit_decal":"Y","insp_unit_decal_number":"32445680","created_at":"2025-03-17T22:40:25.000000Z","updated_at":"2025-03-17T22:40:25.000000Z"},{"id":4745134,"change_date":"2023-05-02 21:41:00","inspection_id":"78512863","insp_unit_id":"194713746","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRIM","insp_unit_company":"T11\/RED","insp_unit_license":"HV16920","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"2MN01JAH551009536","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:25.000000Z","updated_at":"2025-03-17T22:40:25.000000Z"}]},{"id":2648097,"change_date":"2023-03-23 21:43:00","inspection_id":"78171124","dot_number":"74616","report_state":"OR","report_number":"AADN002109","insp_date":"2023-03-23 00:00:00","insp_start_time":"1343","insp_end_time":"1404","registration_date":null,"region":"PT","ci_status_code":"C","location":"1507","location_desc":"ASHLAND POE - 3.5 MI N ASHLAND","county_code_state":"OR","county_code":"029","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"COCA COLA BOTTLING COMPANY","shipping_paper_number":"00000","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-23 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"34700","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":"1221300","transaction_code":"A","transaction_date":"2023-03-23 00:00:00","upload_date":"2023-03-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00074616","upload_search_indicator":null,"census_search_date":"2023-03-23 21:43:00","snet_input_date":"2023-03-23 00:00:00","source_office":"4ORS001","mcmis_add_date":"2023-03-23 21:43:00","insp_carrier_name":"DOUGLAS COUNTY BOTTLING CO INC","insp_carrier_street":"165 BOURBON ST","insp_carrier_city":"ROSEBURG","insp_carrier_state":"OR","insp_carrier_zip_code":"97471","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"093696","created_at":"2025-03-17T19:15:32.000000Z","updated_at":"2025-03-17T19:15:32.000000Z","inspection_violations":[{"id":4070988,"change_date":"2023-03-23 21:43:00","inspection_id":"78171124","insp_violation_id":"251839809","seq_no":"1","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"194036410","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:04.000000Z","updated_at":"2025-03-17T21:26:04.000000Z","normalized_code":"39355E"},{"id":4070989,"change_date":"2023-03-23 21:43:00","inspection_id":"78171124","insp_violation_id":"251839810","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"194036410","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:04.000000Z","updated_at":"2025-03-17T21:26:04.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":4263291,"change_date":"2023-03-23 21:43:00","inspection_id":"78171124","insp_unit_id":"194036409","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"P27","insp_unit_license":"YAJT064","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"2XKHAJ8X2MM463617","insp_unit_decal":"Y","insp_unit_decal_number":"32341386","created_at":"2025-03-17T22:36:35.000000Z","updated_at":"2025-03-17T22:36:35.000000Z"},{"id":4263292,"change_date":"2023-03-23 21:43:00","inspection_id":"78171124","insp_unit_id":"194036410","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"T02","insp_unit_license":"HS92196","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:36:35.000000Z","updated_at":"2025-03-17T22:36:35.000000Z"}]},{"id":2626210,"change_date":"2023-03-28 21:41:00","inspection_id":"78146421","dot_number":"74616","report_state":"OR","report_number":"AADJ001276","insp_date":"2023-03-20 00:00:00","insp_start_time":"1150","insp_end_time":"1218","registration_date":"2023-03-28 00:00:00","region":"PT","ci_status_code":"C","location":"1507","location_desc":"ASHLAND POE - 3.5 MI N ASHLAND","county_code_state":"OR","county_code":"029","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"CARRIER","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-03-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","viol_total":"8","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1220986","transaction_code":"C","transaction_date":"2023-03-22 00:00:00","upload_date":"2023-03-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00074616","upload_search_indicator":null,"census_search_date":"2023-03-21 21:41:00","snet_input_date":"2023-03-21 00:00:00","source_office":"4ORS001","mcmis_add_date":"2023-03-21 21:41:00","insp_carrier_name":"DOUGLAS COUNTY BOTTLING CO INC","insp_carrier_street":"165 BOURBON ST","insp_carrier_city":"ROSEBURG","insp_carrier_state":"OR","insp_carrier_zip_code":"97471","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"093696","created_at":"2025-03-17T19:15:10.000000Z","updated_at":"2025-03-17T19:15:10.000000Z","inspection_violations":[{"id":4037387,"change_date":"2023-03-28 21:41:00","inspection_id":"78146421","insp_violation_id":"251906742","seq_no":"6","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"194101411","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:25:54.000000Z","updated_at":"2025-03-17T21:25:54.000000Z","normalized_code":"3963A1"},{"id":4037388,"change_date":"2023-03-28 21:41:00","inspection_id":"78146421","insp_violation_id":"251906743","seq_no":"7","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"194101412","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:25:54.000000Z","updated_at":"2025-03-17T21:25:54.000000Z","normalized_code":"39375A3"},{"id":4037389,"change_date":"2023-03-28 21:41:00","inspection_id":"78146421","insp_violation_id":"251906744","seq_no":"8","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"194101411","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:54.000000Z","updated_at":"2025-03-17T21:25:54.000000Z","normalized_code":"3965B"},{"id":4037390,"change_date":"2023-03-28 21:41:00","inspection_id":"78146421","insp_violation_id":"251906745","seq_no":"5","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"194101412","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:54.000000Z","updated_at":"2025-03-17T21:25:54.000000Z","normalized_code":"39347E"},{"id":4037391,"change_date":"2023-03-28 21:41:00","inspection_id":"78146421","insp_violation_id":"251906746","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"194101411","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:54.000000Z","updated_at":"2025-03-17T21:25:54.000000Z","normalized_code":"39347E"},{"id":4037392,"change_date":"2023-03-28 21:41:00","inspection_id":"78146421","insp_violation_id":"251906747","seq_no":"2","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"194101411","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:54.000000Z","updated_at":"2025-03-17T21:25:54.000000Z","normalized_code":"39353B"},{"id":4037393,"change_date":"2023-03-28 21:41:00","inspection_id":"78146421","insp_violation_id":"251906748","seq_no":"3","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"194101412","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:54.000000Z","updated_at":"2025-03-17T21:25:54.000000Z","normalized_code":"39347E"},{"id":4037394,"change_date":"2023-03-28 21:41:00","inspection_id":"78146421","insp_violation_id":"251906749","seq_no":"4","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"194101412","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:54.000000Z","updated_at":"2025-03-17T21:25:54.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":4227657,"change_date":"2023-03-28 21:41:00","inspection_id":"78146421","insp_unit_id":"194101411","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"P06","insp_unit_license":"YAIM941","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1FUJA6CV65LN82809","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:19.000000Z","updated_at":"2025-03-17T22:36:19.000000Z"},{"id":4227658,"change_date":"2023-03-28 21:41:00","inspection_id":"78146421","insp_unit_id":"194101412","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"T04","insp_unit_license":"HS83913","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:36:19.000000Z","updated_at":"2025-03-17T22:36:19.000000Z"}]},{"id":2157424,"change_date":"2023-01-19 21:44:00","inspection_id":"77612678","dot_number":"74616","report_state":"OR","report_number":"AAAP007688","insp_date":"2023-01-11 00:00:00","insp_start_time":"1303","insp_end_time":"1332","registration_date":null,"region":"PT","ci_status_code":"C","location":"1507","location_desc":"ASHLAND POE - 3.5 MI N ASHLAND","county_code_state":"OR","county_code":"029","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-01-17 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52350","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":"1216794","transaction_code":"C","transaction_date":"2023-01-19 00:00:00","upload_date":"2023-01-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00074616","upload_search_indicator":null,"census_search_date":"2023-01-17 21:42:00","snet_input_date":"2023-01-12 00:00:00","source_office":"4ORS001","mcmis_add_date":"2023-01-17 21:42:00","insp_carrier_name":"DOUGLAS COUNTY BOTTLING CO INC","insp_carrier_street":"165 BOURBON ST","insp_carrier_city":"ROSEBURG","insp_carrier_state":"OR","insp_carrier_zip_code":"97471","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"093696","created_at":"2025-03-17T19:06:18.000000Z","updated_at":"2025-03-17T19:06:18.000000Z","inspection_violations":[{"id":3334409,"change_date":"2023-01-19 21:44:00","inspection_id":"77612678","insp_violation_id":"250666989","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"192963380","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:45.000000Z","updated_at":"2025-03-17T21:22:45.000000Z","normalized_code":"3963A1"},{"id":3334410,"change_date":"2023-01-19 21:44:00","inspection_id":"77612678","insp_violation_id":"250666990","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"192963381","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:45.000000Z","updated_at":"2025-03-17T21:22:45.000000Z","normalized_code":"39347E"},{"id":3334411,"change_date":"2023-01-19 21:44:00","inspection_id":"77612678","insp_violation_id":"250666991","seq_no":"3","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"192963381","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:45.000000Z","updated_at":"2025-03-17T21:22:45.000000Z","normalized_code":"39353B"},{"id":3334412,"change_date":"2023-01-19 21:44:00","inspection_id":"77612678","insp_violation_id":"250666992","seq_no":"4","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"2","insp_unit_id":"192963381","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:22:45.000000Z","updated_at":"2025-03-17T21:22:45.000000Z","normalized_code":"3965B"},{"id":3334413,"change_date":"2023-01-19 21:44:00","inspection_id":"77612678","insp_violation_id":"250666993","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"192963381","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:45.000000Z","updated_at":"2025-03-17T21:22:45.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":3472013,"change_date":"2023-01-19 21:44:00","inspection_id":"77612678","insp_unit_id":"192963380","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"P14","insp_unit_license":"YAIV380","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1HSDJSJR4CH673572","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:54.000000Z","updated_at":"2025-03-17T22:30:54.000000Z"},{"id":3472014,"change_date":"2023-01-19 21:44:00","inspection_id":"77612678","insp_unit_id":"192963381","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"T03","insp_unit_license":"HS88998","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"2MN01AAL531006444","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:54.000000Z","updated_at":"2025-03-17T22:30:54.000000Z"}]},{"id":2071051,"change_date":"2023-01-04 21:40:00","inspection_id":"77512944","dot_number":"74616","report_state":"CA","report_number":"NELC000218","insp_date":"2022-12-21 00:00:00","insp_start_time":"0756","insp_end_time":"0826","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"COCA COLA","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-04 21:40: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":"14729420","transaction_code":"A","transaction_date":"2022-12-21 00:00:00","upload_date":"2023-01-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00074616","upload_search_indicator":null,"census_search_date":"2023-01-04 21:40:00","snet_input_date":"2022-12-21 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-01-04 21:40:00","insp_carrier_name":"DOUGLAS COUNTY BOTTLING CO INC","insp_carrier_street":"165 BOURBON ST","insp_carrier_city":"ROSEBURG","insp_carrier_state":"OR","insp_carrier_zip_code":"97471","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:04:45.000000Z","updated_at":"2025-03-17T19:04:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3332058,"change_date":"2023-01-04 21:40:00","inspection_id":"77512944","insp_unit_id":"192707056","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"P26\/RED","insp_unit_license":"YAJT063","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XKYD49X4LJ430115","insp_unit_decal":"Y","insp_unit_decal_number":"31810339","created_at":"2025-03-17T22:29:51.000000Z","updated_at":"2025-03-17T22:29:51.000000Z"},{"id":3332059,"change_date":"2023-01-04 21:40:00","inspection_id":"77512944","insp_unit_id":"192707057","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRIM","insp_unit_company":"T11\/RED","insp_unit_license":"HV16920","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"2MN01JAH551009536","insp_unit_decal":"Y","insp_unit_decal_number":"31810340","created_at":"2025-03-17T22:29:51.000000Z","updated_at":"2025-03-17T22:29:51.000000Z"}]},{"id":1188876,"change_date":"2022-08-31 21:43:00","inspection_id":"76497527","dot_number":"74616","report_state":"CA","report_number":"UDFU001799","insp_date":"2022-08-31 00:00:00","insp_start_time":"1101","insp_end_time":"1141","registration_date":null,"region":"PT","ci_status_code":"C","location":"120","location_desc":"SMITH RIVER AG STATION","county_code_state":"CA","county_code":"015","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":"N","pen_cen_match":null,"final_status_date":"2022-08-31 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"6","oos_total":"2","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14577544","transaction_code":"A","transaction_date":"2022-08-31 00:00:00","upload_date":"2022-08-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00074616","upload_search_indicator":null,"census_search_date":"2022-08-31 21:43:00","snet_input_date":"2022-08-31 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-08-31 21:43:00","insp_carrier_name":"DOUGLAS COUNTY BOTTLING CO INC","insp_carrier_street":"165 BOURBON ST","insp_carrier_city":"ROSEBURG","insp_carrier_state":"OR","insp_carrier_zip_code":"97471","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:48:37.000000Z","updated_at":"2025-03-17T18:48:37.000000Z","inspection_violations":[{"id":1885104,"change_date":"2022-08-31 21:43:00","inspection_id":"76497527","insp_violation_id":"248146908","seq_no":"1","part_no":"390","part_no_section":"21T(a)","insp_viol_unit":"1","insp_unit_id":"190667160","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:43.000000Z","updated_at":"2025-03-17T21:15:43.000000Z","normalized_code":"39021TA"},{"id":1885105,"change_date":"2022-08-31 21:43:00","inspection_id":"76497527","insp_violation_id":"248146909","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"190667161","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:43.000000Z","updated_at":"2025-03-17T21:15:43.000000Z","normalized_code":"3922"},{"id":1885106,"change_date":"2022-08-31 21:43:00","inspection_id":"76497527","insp_violation_id":"248146910","seq_no":"3","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":"KD 48433","created_at":"2025-03-17T21:15:43.000000Z","updated_at":"2025-03-17T21:15:43.000000Z","normalized_code":"39141A"},{"id":1885107,"change_date":"2022-08-31 21:43:00","inspection_id":"76497527","insp_violation_id":"248146911","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"190667160","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:43.000000Z","updated_at":"2025-03-17T21:15:43.000000Z","normalized_code":"3963A1"},{"id":1885108,"change_date":"2022-08-31 21:43:00","inspection_id":"76497527","insp_violation_id":"248146912","seq_no":"5","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"190667160","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:43.000000Z","updated_at":"2025-03-17T21:15:43.000000Z","normalized_code":"3963A1"},{"id":1885109,"change_date":"2022-08-31 21:43:00","inspection_id":"76497527","insp_violation_id":"248146913","seq_no":"6","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"190667160","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:15:43.000000Z","updated_at":"2025-03-17T21:15:43.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":1912266,"change_date":"2022-08-31 21:43:00","inspection_id":"76497527","insp_unit_id":"190667160","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"2352042","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJGEDV2GSGW5865","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:09.000000Z","updated_at":"2025-03-17T22:20:09.000000Z"},{"id":1912267,"change_date":"2022-08-31 21:43:00","inspection_id":"76497527","insp_unit_id":"190667161","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TTRAI","insp_unit_company":null,"insp_unit_license":"HV16917","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"2MN01JAL821002855","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:09.000000Z","updated_at":"2025-03-17T22:20:09.000000Z"}]},{"id":1190156,"change_date":"2022-08-31 21:43:00","inspection_id":"76498981","dot_number":"74616","report_state":"CA","report_number":"UDO4001983","insp_date":"2022-08-31 00:00:00","insp_start_time":"1100","insp_end_time":"1115","registration_date":null,"region":"PT","ci_status_code":"C","location":"120","location_desc":"199 AG STATION","county_code_state":"CA","county_code":"015","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":"2022-08-31 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14577768","transaction_code":"A","transaction_date":"2022-08-31 00:00:00","upload_date":"2022-08-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00074616","upload_search_indicator":null,"census_search_date":"2022-08-31 21:43:00","snet_input_date":"2022-08-31 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-08-31 21:43:00","insp_carrier_name":"DOUGLAS COUNTY BOTTLING CO INC","insp_carrier_street":"165 BOURBON ST","insp_carrier_city":"ROSEBURG","insp_carrier_state":"OR","insp_carrier_zip_code":"97471","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:48:38.000000Z","updated_at":"2025-03-17T18:48:38.000000Z","inspection_violations":[{"id":1886382,"change_date":"2022-08-31 21:43:00","inspection_id":"76498981","insp_violation_id":"248148549","seq_no":"1","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"190669575","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:43.000000Z","updated_at":"2025-03-17T21:15:43.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":1914313,"change_date":"2022-08-31 21:43:00","inspection_id":"76498981","insp_unit_id":"190669575","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"YAIV379","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1HSDJSJR7CH673498","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:09.000000Z","updated_at":"2025-03-17T22:20:09.000000Z"},{"id":1914314,"change_date":"2022-08-31 21:43:00","inspection_id":"76498981","insp_unit_id":"190669576","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRIM","insp_unit_company":null,"insp_unit_license":"HV16918","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"2MN01JALX41001726","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:09.000000Z","updated_at":"2025-03-17T22:20:09.000000Z"}]},{"id":195428,"change_date":"2022-04-18 21:42:00","inspection_id":"75326113","dot_number":"74616","report_state":"OR","report_number":"AANZ001214","insp_date":"2022-04-15 00:00:00","insp_start_time":"0749","insp_end_time":"0752","registration_date":null,"region":"PT","ci_status_code":"C","location":"0366","location_desc":"CLACKAMAS COUNTY ROADSIDE","county_code_state":"OR","county_code":"005","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-04-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"17500","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":"1201050","transaction_code":"A","transaction_date":"2022-04-18 00:00:00","upload_date":"2022-04-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00074616","upload_search_indicator":null,"census_search_date":"2022-04-18 21:42:00","snet_input_date":"2022-04-18 00:00:00","source_office":"4ORS001","mcmis_add_date":"2022-04-18 21:42:00","insp_carrier_name":"DOUGLAS COUNTY BOTTLING CO INC","insp_carrier_street":"165 BOURBON ST","insp_carrier_city":"ROSEBURG","insp_carrier_state":"OR","insp_carrier_zip_code":"97471","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"093696","created_at":"2025-03-17T18:30:53.000000Z","updated_at":"2025-03-17T18:30:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":316731,"change_date":"2022-04-18 21:42:00","inspection_id":"75326113","insp_unit_id":"188201372","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"8505512","insp_unit_license":"T561126","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1GDE4C1286F419419","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:06.000000Z","updated_at":"2025-03-17T22:10:06.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/74616\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/74616\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/74616\/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\/74616\/inspections","per_page":100,"prev_page_url":null,"to":48,"total":48}