{"current_page":1,"data":[{"id":12374881,"change_date":"2026-07-07 21:40:00","inspection_id":"88337489","dot_number":"314371","report_state":"OK","report_number":"C200000957","insp_date":"2026-07-07 00:00:00","insp_start_time":"1235","insp_end_time":"1250","registration_date":null,"region":"CD","ci_status_code":"C","location":"63400","location_desc":"OK","county_code_state":"OK","county_code":"125","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"53000516","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-07 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":"3700145","transaction_code":"A","transaction_date":"2026-07-07 00:00:00","upload_date":"2026-07-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00314371","upload_search_indicator":null,"census_search_date":"2026-07-07 21:40:00","snet_input_date":"2026-07-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-07 21:40:00","insp_carrier_name":"ADA COCA COLA BOTTLING COMPANY","insp_carrier_street":"15978 STATE HWY 1W","insp_carrier_city":"ADA","insp_carrier_state":"OK","insp_carrier_zip_code":"74820","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-10T09:40:24.000000Z","updated_at":"2026-07-18T09:30:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21488508,"change_date":"2026-07-07 21:40:00","inspection_id":"88337489","insp_unit_id":"214479396","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"25","insp_unit_license":"726078","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1FUJGEDR5CSBR5555","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-10T09:16:42.000000Z","updated_at":"2026-07-18T09:02:20.000000Z"},{"id":21488509,"change_date":"2026-07-07 21:40:00","inspection_id":"88337489","insp_unit_id":"214479397","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRIM","insp_unit_company":"304","insp_unit_license":"4673FX","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"2MN01JAH481003358","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-10T09:16:42.000000Z","updated_at":"2026-07-18T09:02:20.000000Z"}]},{"id":12297862,"change_date":"2026-06-27 21:41:00","inspection_id":"88254750","dot_number":"314371","report_state":"OK","report_number":"N600001430","insp_date":"2026-06-26 00:00:00","insp_start_time":"1215","insp_end_time":"1240","registration_date":null,"region":"CD","ci_status_code":"C","location":"62377","location_desc":"OK","county_code_state":"OK","county_code":"123","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"06262026","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"100000","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":"3632095","transaction_code":"A","transaction_date":"2026-06-27 00:00:00","upload_date":"2026-06-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00314371","upload_search_indicator":null,"census_search_date":"2026-06-27 21:41:00","snet_input_date":"2026-06-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-27 21:41:00","insp_carrier_name":"ADA COCA COLA BOTTLING COMPANY","insp_carrier_street":"15978 STATE HWY 1W","insp_carrier_city":"ADA","insp_carrier_state":"OK","insp_carrier_zip_code":"74820","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-30T09:40:10.000000Z","updated_at":"2026-07-08T09:30:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21360519,"change_date":"2026-06-27 21:41:00","inspection_id":"88254750","insp_unit_id":"214318360","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"94","insp_unit_license":"714936","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1HSHWCVN4EJ482536","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-30T09:16:27.000000Z","updated_at":"2026-07-08T09:01:46.000000Z"},{"id":21360520,"change_date":"2026-06-27 21:41:00","inspection_id":"88254750","insp_unit_id":"214318361","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"311","insp_unit_license":"AD5390","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1GRAA7028JB126520","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-30T09:16:27.000000Z","updated_at":"2026-07-08T09:01:46.000000Z"}]},{"id":11334212,"change_date":"2026-03-27 21:40:00","inspection_id":"87251480","dot_number":"314371","report_state":"OK","report_number":"H600154588","insp_date":"2026-03-10 00:00:00","insp_start_time":"1202","insp_end_time":"1232","registration_date":"2026-03-26 00:00:00","region":"CT","ci_status_code":"C","location":"63177","location_desc":"US-177 \/ S BENSON PARK RD","county_code_state":"OK","county_code":"125","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"M\/C","shipping_paper_number":"11103","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-03-10 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"5","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"814509","transaction_code":"C","transaction_date":"2026-03-10 00:00:00","upload_date":"2026-03-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00314371","upload_search_indicator":null,"census_search_date":"2026-03-10 21:38:00","snet_input_date":"2026-03-10 00:00:00","source_office":"2OKS001","mcmis_add_date":"2026-03-10 21:38:00","insp_carrier_name":"ADA COCA COLA BOTTLING COMPANY","insp_carrier_street":"15978 STATE HWY 1W","insp_carrier_city":"ADA","insp_carrier_state":"OK","insp_carrier_zip_code":"74820","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-13T09:43:47.000000Z","updated_at":"2026-04-07T09:33:19.000000Z","inspection_violations":[{"id":19418056,"change_date":"2026-03-27 21:40:00","inspection_id":"87251480","insp_violation_id":"272689346","seq_no":"1","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"212381687","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-30T10:20:01.000000Z","updated_at":"2026-04-07T09:48:21.000000Z","normalized_code":"39395A4EEUS"},{"id":19418057,"change_date":"2026-03-27 21:40:00","inspection_id":"87251480","insp_violation_id":"272689347","seq_no":"2","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"212381687","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-30T10:20:01.000000Z","updated_at":"2026-04-07T09:48:21.000000Z","normalized_code":"3939ALIL"},{"id":19418058,"change_date":"2026-03-27 21:40:00","inspection_id":"87251480","insp_violation_id":"272689348","seq_no":"3","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"212381687","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-30T10:20:01.000000Z","updated_at":"2026-04-07T09:48:21.000000Z","normalized_code":"3922SLLSR"},{"id":19418059,"change_date":"2026-03-27 21:40:00","inspection_id":"87251480","insp_violation_id":"272689349","seq_no":"4","part_no":"393","part_no_section":"55C1-B","insp_viol_unit":"1","insp_unit_id":"212381687","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-30T10:20:01.000000Z","updated_at":"2026-04-07T09:48:21.000000Z","normalized_code":"39355C1B"},{"id":19418060,"change_date":"2026-03-27 21:40:00","inspection_id":"87251480","insp_violation_id":"272689350","seq_no":"5","part_no":"393","part_no_section":"106B-C","insp_viol_unit":"2","insp_unit_id":"212381688","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-30T10:20:01.000000Z","updated_at":"2026-04-07T09:48:21.000000Z","normalized_code":"393106BC"}],"inspection_per_units":[{"id":19698958,"change_date":"2026-03-27 21:40:00","inspection_id":"87251480","insp_unit_id":"212381687","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"22","insp_unit_license":"731200","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1FUJC5DX5DHFA7460","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-30T09:33:21.000000Z","updated_at":"2026-04-07T09:08:02.000000Z"},{"id":19698959,"change_date":"2026-03-27 21:40:00","inspection_id":"87251480","insp_unit_id":"212381688","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"313","insp_unit_license":"BN7742","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1GR1A7024LB208974","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-30T09:33:21.000000Z","updated_at":"2026-04-07T09:08:02.000000Z"}]},{"id":10914832,"change_date":"2026-02-03 21:38:00","inspection_id":"86946867","dot_number":"314371","report_state":"OK","report_number":"N600001248","insp_date":"2026-02-03 00:00:00","insp_start_time":"1300","insp_end_time":"1325","registration_date":null,"region":"CT","ci_status_code":"C","location":"62001","location_desc":"STATE HIGHWAY 1 LATTA","county_code_state":"OK","county_code":"123","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"02032026","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-02-03 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"103000","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":"811173","transaction_code":"A","transaction_date":"2026-02-03 00:00:00","upload_date":"2026-02-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00314371","upload_search_indicator":null,"census_search_date":"2026-02-03 21:38:00","snet_input_date":"2026-02-03 00:00:00","source_office":"2OKS001","mcmis_add_date":"2026-02-03 21:38:00","insp_carrier_name":"ADA COCA COLA BOTTLING COMPANY","insp_carrier_street":"15978 STATE HWY 1W","insp_carrier_city":"ADA","insp_carrier_state":"OK","insp_carrier_zip_code":"74820","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-06T10:35:15.000000Z","updated_at":"2026-02-14T10:30:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18355389,"change_date":"2026-02-03 21:38:00","inspection_id":"86946867","insp_unit_id":"211416481","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"12","insp_unit_license":"726073","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1NPCA28X6PD871343","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-06T10:09:23.000000Z","updated_at":"2026-02-14T10:05:24.000000Z"},{"id":18355390,"change_date":"2026-02-03 21:38:00","inspection_id":"86946867","insp_unit_id":"211416482","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"316","insp_unit_license":"BR6002","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1GR1A702XPB503146","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-06T10:09:23.000000Z","updated_at":"2026-02-14T10:05:24.000000Z"}]},{"id":10363485,"change_date":"2025-12-18 21:41:00","inspection_id":"86492006","dot_number":"314371","report_state":"OK","report_number":"H600154400","insp_date":"2025-12-04 00:00:00","insp_start_time":"1009","insp_end_time":"1055","registration_date":"2025-12-17 00:00:00","region":"CT","ci_status_code":"C","location":"63177","location_desc":"US-177 \/ GORDON COOPER","county_code_state":"OK","county_code":"125","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"M\/C","shipping_paper_number":"14240413","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-05 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"117500","viol_total":"6","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"805733","transaction_code":"C","transaction_date":"2025-12-04 00:00:00","upload_date":"2025-12-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00314371","upload_search_indicator":"M","census_search_date":"2025-12-05 21:43:00","snet_input_date":"2025-12-04 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-12-05 21:43:00","insp_carrier_name":"ADA COCA COLA BOTTLING COMPANY","insp_carrier_street":"15978 STATE HWY 1W","insp_carrier_city":"ADA","insp_carrier_state":"OK","insp_carrier_zip_code":"74820","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-08T10:32:04.000000Z","updated_at":"2025-12-29T10:30:55.000000Z","inspection_violations":[{"id":17566398,"change_date":"2025-12-18 21:41:00","inspection_id":"86492006","insp_violation_id":"270775767","seq_no":"1","part_no":"390","part_no_section":"21TE2IV-D","insp_viol_unit":"1","insp_unit_id":"210695047","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-21T10:32:27.000000Z","updated_at":"2025-12-29T10:31:31.000000Z","normalized_code":"39021TE2IVD"},{"id":17566399,"change_date":"2025-12-18 21:41:00","inspection_id":"86492006","insp_violation_id":"270775768","seq_no":"2","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"210695047","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-21T10:32:27.000000Z","updated_at":"2025-12-29T10:31:31.000000Z","normalized_code":"39021TB1MC"},{"id":17566400,"change_date":"2025-12-18 21:41:00","inspection_id":"86492006","insp_violation_id":"270775769","seq_no":"3","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"210695047","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-21T10:32:27.000000Z","updated_at":"2025-12-29T10:31:31.000000Z","normalized_code":"39021TB2DOT"},{"id":17566401,"change_date":"2025-12-18 21:41:00","inspection_id":"86492006","insp_violation_id":"270775770","seq_no":"4","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"2","insp_unit_id":"210695048","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-21T10:32:27.000000Z","updated_at":"2025-12-29T10:31:31.000000Z","normalized_code":"39345DB"},{"id":17566402,"change_date":"2025-12-18 21:41:00","inspection_id":"86492006","insp_violation_id":"270775771","seq_no":"5","part_no":"393","part_no_section":"106B-C","insp_viol_unit":"2","insp_unit_id":"210695048","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-21T10:32:27.000000Z","updated_at":"2025-12-29T10:31:31.000000Z","normalized_code":"393106BC"},{"id":17566403,"change_date":"2025-12-18 21:41:00","inspection_id":"86492006","insp_violation_id":"270775772","seq_no":"6","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"2","insp_unit_id":"210695048","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-21T10:32:27.000000Z","updated_at":"2025-12-29T10:31:31.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":17525415,"change_date":"2025-12-18 21:41:00","inspection_id":"86492006","insp_unit_id":"210695047","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"813628","insp_unit_license":"R674184","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPCD49X6RD659861","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-21T10:01:46.000000Z","updated_at":"2025-12-29T10:01:08.000000Z"},{"id":17525416,"change_date":"2025-12-18 21:41:00","inspection_id":"86492006","insp_unit_id":"210695048","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRIM","insp_unit_company":"304","insp_unit_license":"46673FX","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"2MN01JAH481003358","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-21T10:01:46.000000Z","updated_at":"2025-12-29T10:01:08.000000Z"}]},{"id":9123028,"change_date":"2025-07-11 21:39:00","inspection_id":"85188345","dot_number":"314371","report_state":"OK","report_number":"N600000973","insp_date":"2025-07-11 00:00:00","insp_start_time":"1235","insp_end_time":"1300","registration_date":null,"region":"CT","ci_status_code":"C","location":"67377","location_desc":"U.S. HWY  377 5 S OF SEMINOLE","county_code_state":"OK","county_code":"133","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"07112025","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-07-11 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"100000","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":"790570","transaction_code":"A","transaction_date":"2025-07-11 00:00:00","upload_date":"2025-07-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00314371","upload_search_indicator":null,"census_search_date":"2025-07-11 21:39:00","snet_input_date":"2025-07-11 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-07-11 21:39:00","insp_carrier_name":"ADA COCA COLA BOTTLING COMPANY","insp_carrier_street":"15978 STATE HWY 1W","insp_carrier_city":"ADA","insp_carrier_state":"OK","insp_carrier_zip_code":"74820","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-14T10:47:04.000000Z","updated_at":"2025-07-16T10:44:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14978631,"change_date":"2025-07-11 21:39:00","inspection_id":"85188345","insp_unit_id":"207820433","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"96","insp_unit_license":"726081","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1HSHWCVN8EJ482538","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-14T09:46:06.000000Z","updated_at":"2025-07-15T09:45:44.000000Z"},{"id":14978632,"change_date":"2025-07-11 21:39:00","inspection_id":"85188345","insp_unit_id":"207820434","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"310","insp_unit_license":"AD5389","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1GRAA7021JB126519","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-14T09:46:06.000000Z","updated_at":"2025-07-15T09:45:44.000000Z"}]},{"id":8827070,"change_date":"2025-06-16 21:39:00","inspection_id":"84875388","dot_number":"314371","report_state":"OK","report_number":"H600154030","insp_date":"2025-06-05 00:00:00","insp_start_time":"0717","insp_end_time":"0753","registration_date":"2025-06-16 00:00:00","region":"CT","ci_status_code":"C","location":"63177","location_desc":"US-177 \/ ACME RD","county_code_state":"OK","county_code":"125","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"M\/C","shipping_paper_number":"11103","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-05 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"787461","transaction_code":"C","transaction_date":"2025-06-05 00:00:00","upload_date":"2025-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00314371","upload_search_indicator":"M","census_search_date":"2025-06-05 21:41:00","snet_input_date":"2025-06-05 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-06-05 21:41:00","insp_carrier_name":"ADA COCA COLA BOTTLING COMPANY","insp_carrier_street":"15978 STATE HWY 1W","insp_carrier_city":"ADA","insp_carrier_state":"OK","insp_carrier_zip_code":"74820","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-09T10:01:06.000000Z","updated_at":"2025-06-20T10:00:06.000000Z","inspection_violations":[{"id":14279739,"change_date":"2025-06-16 21:39:00","inspection_id":"84875388","insp_violation_id":"266865707","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"207406835","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-19T10:15:22.000000Z","updated_at":"2025-06-20T10:15:11.000000Z","normalized_code":"39378"},{"id":14279740,"change_date":"2025-06-16 21:39:00","inspection_id":"84875388","insp_violation_id":"266865708","seq_no":"2","part_no":"393","part_no_section":"95A3","insp_viol_unit":"1","insp_unit_id":"207406835","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-19T10:15:22.000000Z","updated_at":"2025-06-20T10:15:11.000000Z","normalized_code":"39395A3"},{"id":14279741,"change_date":"2025-06-16 21:39:00","inspection_id":"84875388","insp_violation_id":"266865709","seq_no":"3","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"207406835","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-19T10:15:22.000000Z","updated_at":"2025-06-20T10:15:11.000000Z","normalized_code":"3939ALIL"},{"id":14279742,"change_date":"2025-06-16 21:39:00","inspection_id":"84875388","insp_violation_id":"266865710","seq_no":"4","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"207406835","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-19T10:15:22.000000Z","updated_at":"2025-06-20T10:15:11.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":14591314,"change_date":"2025-06-16 21:39:00","inspection_id":"84875388","insp_unit_id":"207406835","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"22","insp_unit_license":"731200","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1FUJC5DX5DHFA7460","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-19T09:45:17.000000Z","updated_at":"2025-06-20T09:45:08.000000Z"},{"id":14591315,"change_date":"2025-06-16 21:39:00","inspection_id":"84875388","insp_unit_id":"207406836","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"314","insp_unit_license":"BN7743","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1GR1A7026LB208975","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-19T09:45:17.000000Z","updated_at":"2025-06-20T09:45:08.000000Z"}]},{"id":8342970,"change_date":"2025-04-28 21:35:00","inspection_id":"84364701","dot_number":"314371","report_state":"OK","report_number":"H600153880","insp_date":"2025-04-10 00:00:00","insp_start_time":"1014","insp_end_time":"1045","registration_date":null,"region":"CT","ci_status_code":"C","location":"63177","location_desc":"US-177 \/ GORDON COOPER","county_code_state":"OK","county_code":"125","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"M\/C","shipping_paper_number":"13136011","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-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"781329","transaction_code":"C","transaction_date":"2025-04-28 00:00:00","upload_date":"2025-04-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00314371","upload_search_indicator":"M","census_search_date":"2025-04-10 21:41:00","snet_input_date":"2025-04-10 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-04-10 21:41:00","insp_carrier_name":"ADA COCA COLA BOTTLING COMPANY","insp_carrier_street":"15978 STATE HWY 1W","insp_carrier_city":"ADA","insp_carrier_state":"OK","insp_carrier_zip_code":"74820","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-14T10:28:21.000000Z","updated_at":"2025-05-02T10:21:55.000000Z","inspection_violations":[{"id":13393681,"change_date":"2025-04-28 21:35:00","inspection_id":"84364701","insp_violation_id":"265840312","seq_no":"1","part_no":"396","part_no_section":"5B-L","insp_viol_unit":"1","insp_unit_id":"206500940","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-01T10:15:41.000000Z","updated_at":"2025-05-02T10:39:27.000000Z","normalized_code":"3965BL"},{"id":13393682,"change_date":"2025-04-28 21:35:00","inspection_id":"84364701","insp_violation_id":"265840313","seq_no":"2","part_no":"383","part_no_section":"95A-LCDL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-01T10:15:41.000000Z","updated_at":"2025-05-02T10:39:27.000000Z","normalized_code":"38395ALCDL"}],"inspection_per_units":[{"id":13765013,"change_date":"2025-04-28 21:35:00","inspection_id":"84364701","insp_unit_id":"206500940","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"60","insp_unit_license":"719481","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1NPBDH9X8FD295581","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-01T09:45:36.000000Z","updated_at":"2025-05-02T09:48:58.000000Z"},{"id":13765014,"change_date":"2025-04-28 21:35:00","inspection_id":"84364701","insp_unit_id":"206500941","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"315","insp_unit_license":"BN7741","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1GR1A9624LB208976","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-01T09:45:36.000000Z","updated_at":"2025-05-02T09:48:58.000000Z"}]},{"id":7530187,"change_date":"2025-01-01 21:32:00","inspection_id":"83510415","dot_number":"314371","report_state":"OK","report_number":"B300000135","insp_date":"2024-12-31 00:00:00","insp_start_time":"1034","insp_end_time":"1054","registration_date":null,"region":"CT","ci_status_code":"C","location":"0177","location_desc":"US-177 \/ ACME ROAD","county_code_state":"OK","county_code":"125","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"M\/C","shipping_paper_number":"M\/C","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-01-01 21:32: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":"772244","transaction_code":"A","transaction_date":"2024-12-31 00:00:00","upload_date":"2024-12-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00314371","upload_search_indicator":"M","census_search_date":"2025-01-01 21:32:00","snet_input_date":"2024-12-31 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-01-01 21:32:00","insp_carrier_name":"ADA COCA COLA BOTTLING COMPANY","insp_carrier_street":"15978 STATE HWY 1W","insp_carrier_city":"ADA","insp_carrier_state":"OK","insp_carrier_zip_code":"74820","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:53:11.000000Z","updated_at":"2025-03-17T20:53:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12148487,"change_date":"2025-01-01 21:32:00","inspection_id":"83510415","insp_unit_id":"204614028","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"726078","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1FUJGEDR5CSBR5555","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:07.000000Z","updated_at":"2025-03-17T23:49:07.000000Z"},{"id":12148488,"change_date":"2025-01-01 21:32:00","inspection_id":"83510415","insp_unit_id":"204614029","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLM","insp_unit_company":null,"insp_unit_license":"4673FX","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"2MN01JAH481003358","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:07.000000Z","updated_at":"2025-03-17T23:49:07.000000Z"}]},{"id":7391271,"change_date":"2024-12-11 21:41:00","inspection_id":"83364544","dot_number":"314371","report_state":"OK","report_number":"H600153704","insp_date":"2024-12-10 00:00:00","insp_start_time":"1334","insp_end_time":"1350","registration_date":null,"region":"CT","ci_status_code":"C","location":"63177","location_desc":"US-177 \/ FARRELL ST","county_code_state":"OK","county_code":"125","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"M\/C","shipping_paper_number":"12630984","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-12-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","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":"770284","transaction_code":"A","transaction_date":"2024-12-10 00:00:00","upload_date":"2024-12-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00314371","upload_search_indicator":"M","census_search_date":"2024-12-11 21:41:00","snet_input_date":"2024-12-10 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-12-11 21:41:00","insp_carrier_name":"ADA COCA COLA BOTTLING COMPANY","insp_carrier_street":"15978 STATE HWY 1W","insp_carrier_city":"ADA","insp_carrier_state":"OK","insp_carrier_zip_code":"74820","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:50:19.000000Z","updated_at":"2025-03-17T20:50:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11923367,"change_date":"2024-12-11 21:41:00","inspection_id":"83364544","insp_unit_id":"204321187","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"60","insp_unit_license":"719481","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1NPBDH9X8FD295581","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:38.000000Z","updated_at":"2025-03-17T23:46:38.000000Z"},{"id":11923368,"change_date":"2024-12-11 21:41:00","inspection_id":"83364544","insp_unit_id":"204321188","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"315","insp_unit_license":"BN7741","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1GR1A9624LB208976","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:38.000000Z","updated_at":"2025-03-17T23:46:38.000000Z"}]},{"id":7002370,"change_date":"2024-11-04 21:40:00","inspection_id":"82953401","dot_number":"314371","report_state":"OK","report_number":"H600153583","insp_date":"2024-10-17 00:00:00","insp_start_time":"0703","insp_end_time":"0733","registration_date":"2024-11-04 00:00:00","region":"CT","ci_status_code":"C","location":"63177","location_desc":"US-177 \/ HARDESTY RD","county_code_state":"OK","county_code":"125","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"M\/C","shipping_paper_number":"NO #","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-10-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"101000","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":"765060","transaction_code":"C","transaction_date":"2024-10-21 00:00:00","upload_date":"2024-11-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00314371","upload_search_indicator":"M","census_search_date":"2024-10-21 21:41:00","snet_input_date":"2024-10-17 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-10-21 21:41:00","insp_carrier_name":"ADA COCA COLA BOTTLING COMPANY","insp_carrier_street":"1205 CRADDUCK ROAD","insp_carrier_city":"ADA","insp_carrier_state":"OK","insp_carrier_zip_code":"74820","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:42:13.000000Z","updated_at":"2025-03-17T20:42:13.000000Z","inspection_violations":[{"id":10926477,"change_date":"2024-11-04 21:40:00","inspection_id":"82953401","insp_violation_id":"262710319","seq_no":"1","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"203722248","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:01.000000Z","updated_at":"2025-03-17T21:59:01.000000Z","normalized_code":"3922RG"},{"id":10926478,"change_date":"2024-11-04 21:40:00","inspection_id":"82953401","insp_violation_id":"262710320","seq_no":"2","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"1","insp_unit_id":"203722248","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:01.000000Z","updated_at":"2025-03-17T21:59:01.000000Z","normalized_code":"3922SLL"},{"id":10926479,"change_date":"2024-11-04 21:40:00","inspection_id":"82953401","insp_violation_id":"262710321","seq_no":"3","part_no":"396","part_no_section":"17C","insp_viol_unit":"2","insp_unit_id":"203722249","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:01.000000Z","updated_at":"2025-03-17T21:59:01.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":11294502,"change_date":"2024-11-04 21:40:00","inspection_id":"82953401","insp_unit_id":"203722248","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"24","insp_unit_license":"731201","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1FUJC5DX7DHFA7458","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:55.000000Z","updated_at":"2025-03-17T23:39:55.000000Z"},{"id":11294503,"change_date":"2024-11-04 21:40:00","inspection_id":"82953401","insp_unit_id":"203722249","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"314","insp_unit_license":"BN7743","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1GR1A7026LB208975","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:55.000000Z","updated_at":"2025-03-17T23:39:55.000000Z"}]},{"id":6735158,"change_date":"2024-09-30 21:41:00","inspection_id":"82668962","dot_number":"314371","report_state":"OK","report_number":"H600153506","insp_date":"2024-09-16 00:00:00","insp_start_time":"0939","insp_end_time":"0959","registration_date":"2024-09-30 00:00:00","region":"CT","ci_status_code":"C","location":"63177","location_desc":"US-177 \/ HARDESTY RD","county_code_state":"OK","county_code":"125","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"M\/C","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":null,"final_status_date":"2024-09-16 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"98200","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":"761367","transaction_code":"C","transaction_date":"2024-09-16 00:00:00","upload_date":"2024-09-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00314371","upload_search_indicator":"M","census_search_date":"2024-09-16 21:42:00","snet_input_date":"2024-09-16 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-09-16 21:42:00","insp_carrier_name":"ADA COCA COLA BOTTLING COMPANY","insp_carrier_street":"1205 CRADDUCK ROAD","insp_carrier_city":"ADA","insp_carrier_state":"OK","insp_carrier_zip_code":"74820","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:36:33.000000Z","updated_at":"2025-03-17T20:36:33.000000Z","inspection_violations":[{"id":10487155,"change_date":"2024-09-30 21:41:00","inspection_id":"82668962","insp_violation_id":"262102422","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"203192344","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:47.000000Z","updated_at":"2025-03-17T21:56:47.000000Z","normalized_code":"39617C"},{"id":10487156,"change_date":"2024-09-30 21:41:00","inspection_id":"82668962","insp_violation_id":"262102423","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"203192344","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:47.000000Z","updated_at":"2025-03-17T21:56:47.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10860374,"change_date":"2024-09-30 21:41:00","inspection_id":"82668962","insp_unit_id":"203192343","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"9","insp_unit_license":"722232","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3HCDGAPR9HL751087","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:31.000000Z","updated_at":"2025-03-17T23:35:31.000000Z"},{"id":10860375,"change_date":"2024-09-30 21:41:00","inspection_id":"82668962","insp_unit_id":"203192344","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LUFK","insp_unit_company":"02","insp_unit_license":"73623V","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1L01A372961161445","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:31.000000Z","updated_at":"2025-03-17T23:35:31.000000Z"}]},{"id":6377199,"change_date":"2024-08-02 21:40:00","inspection_id":"82287379","dot_number":"314371","report_state":"OK","report_number":"N600000487","insp_date":"2024-08-02 00:00:00","insp_start_time":"1205","insp_end_time":"1240","registration_date":null,"region":"CT","ci_status_code":"C","location":"67377","location_desc":"U.S. HWY 377 AT HWY 39  KONAWA","county_code_state":"OK","county_code":"133","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"08022024","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-02 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"100000","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":"756782","transaction_code":"A","transaction_date":"2024-08-02 00:00:00","upload_date":"2024-08-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00314371","upload_search_indicator":null,"census_search_date":"2024-08-02 21:40:00","snet_input_date":"2024-08-02 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-08-02 21:40:00","insp_carrier_name":"ADA COCA COLA BOTTLING COMPANY","insp_carrier_street":"1205 CRADDUCK ROAD","insp_carrier_city":"ADA","insp_carrier_state":"OK","insp_carrier_zip_code":"74820","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:29:08.000000Z","updated_at":"2025-03-17T20:29:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10276754,"change_date":"2024-08-02 21:40:00","inspection_id":"82287379","insp_unit_id":"202208646","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"96","insp_unit_license":"726081","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1HSHWCVN8EJ482538","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:27.000000Z","updated_at":"2025-03-17T23:29:27.000000Z"},{"id":10276755,"change_date":"2024-08-02 21:40:00","inspection_id":"82287379","insp_unit_id":"202208647","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GRDN","insp_unit_company":"310","insp_unit_license":"AD5389","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1GRAA7021JB126519","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:27.000000Z","updated_at":"2025-03-17T23:29:27.000000Z"}]},{"id":6310169,"change_date":"2024-08-08 21:42:00","inspection_id":"82215778","dot_number":"314371","report_state":"OK","report_number":"H600153393","insp_date":"2024-07-25 00:00:00","insp_start_time":"0553","insp_end_time":"0623","registration_date":"2024-08-08 00:00:00","region":"CT","ci_status_code":"C","location":"63177","location_desc":"US-177 \/ BENSON PARK","county_code_state":"OK","county_code":"125","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"M\/C","shipping_paper_number":"1103","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-07-25 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"97000","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":"755624","transaction_code":"C","transaction_date":"2024-07-25 00:00:00","upload_date":"2024-08-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00314371","upload_search_indicator":"M","census_search_date":"2024-07-25 21:44:00","snet_input_date":"2024-07-25 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-07-25 21:44:00","insp_carrier_name":"ADA COCA COLA BOTTLING COMPANY","insp_carrier_street":"1205 CRADDUCK ROAD","insp_carrier_city":"ADA","insp_carrier_state":"OK","insp_carrier_zip_code":"74820","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:27:51.000000Z","updated_at":"2025-03-17T20:27:51.000000Z","inspection_violations":[{"id":9797017,"change_date":"2024-08-08 21:42:00","inspection_id":"82215778","insp_violation_id":"261089777","seq_no":"1","part_no":"393","part_no_section":"30","insp_viol_unit":"1","insp_unit_id":"202300589","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:21.000000Z","updated_at":"2025-03-17T21:53:21.000000Z","normalized_code":"39330"},{"id":9797018,"change_date":"2024-08-08 21:42:00","inspection_id":"82215778","insp_violation_id":"261089778","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"202300590","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:21.000000Z","updated_at":"2025-03-17T21:53:21.000000Z","normalized_code":"39617C"},{"id":9797019,"change_date":"2024-08-08 21:42:00","inspection_id":"82215778","insp_violation_id":"261089779","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"202300590","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:21.000000Z","updated_at":"2025-03-17T21:53:21.000000Z","normalized_code":"3939A"},{"id":9797020,"change_date":"2024-08-08 21:42:00","inspection_id":"82215778","insp_violation_id":"261089780","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"202300590","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:21.000000Z","updated_at":"2025-03-17T21:53:21.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10167317,"change_date":"2024-08-08 21:42:00","inspection_id":"82215778","insp_unit_id":"202300589","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"94","insp_unit_license":"714936","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1HSHWCVN4EJ482536","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:19.000000Z","updated_at":"2025-03-17T23:28:19.000000Z"},{"id":10167318,"change_date":"2024-08-08 21:42:00","inspection_id":"82215778","insp_unit_id":"202300590","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"310","insp_unit_license":"8685LL","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1UYVS2368CP307201","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:19.000000Z","updated_at":"2025-03-17T23:28:19.000000Z"}]},{"id":5409969,"change_date":"2024-04-01 21:40:00","inspection_id":"81240405","dot_number":"314371","report_state":"OK","report_number":"C200000317","insp_date":"2024-03-30 00:00:00","insp_start_time":"1205","insp_end_time":"1230","registration_date":null,"region":"CT","ci_status_code":"C","location":"63177","location_desc":"US-177 AND MACARTHUR ST","county_code_state":"OK","county_code":"125","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"COCA-COLA","shipping_paper_number":"-","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"101000","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":"742142","transaction_code":"A","transaction_date":"2024-04-01 00:00:00","upload_date":"2024-04-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00314371","upload_search_indicator":"M","census_search_date":"2024-04-01 21:40:00","snet_input_date":"2024-03-30 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-04-01 21:40:00","insp_carrier_name":"ADA COCA COLA BOTTLING COMPANY","insp_carrier_street":"1205 CRADDUCK ROAD","insp_carrier_city":"ADA","insp_carrier_state":"OK","insp_carrier_zip_code":"74820","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:09:52.000000Z","updated_at":"2025-03-17T20:09:52.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8713247,"change_date":"2024-04-01 21:40:00","inspection_id":"81240405","insp_unit_id":"200178242","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"6","insp_unit_license":"719480","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"2XP2A27X5MM767127","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:02.000000Z","updated_at":"2025-03-17T23:14:02.000000Z"},{"id":8713248,"change_date":"2024-04-01 21:40:00","inspection_id":"81240405","insp_unit_id":"200178243","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"317","insp_unit_license":"BR6001","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1GR1A7021PB503147","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:02.000000Z","updated_at":"2025-03-17T23:14:02.000000Z"}]},{"id":5296432,"change_date":"2024-03-15 21:40:00","inspection_id":"81116751","dot_number":"314371","report_state":"OK","report_number":"H600153107","insp_date":"2024-03-14 00:00:00","insp_start_time":"0552","insp_end_time":"0615","registration_date":null,"region":"CT","ci_status_code":"C","location":"63177","location_desc":"US-177 \/ SH-59","county_code_state":"OK","county_code":"125","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"M\/C","shipping_paper_number":"1650","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-03-15 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":"740514","transaction_code":"A","transaction_date":"2024-03-14 00:00:00","upload_date":"2024-03-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00314371","upload_search_indicator":null,"census_search_date":"2024-03-15 21:40:00","snet_input_date":"2024-03-14 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-03-15 21:40:00","insp_carrier_name":"ADA COCA COLA BOTTLING COMPANY","insp_carrier_street":"1205 CRADDUCK ROAD","insp_carrier_city":"ADA","insp_carrier_state":"OK","insp_carrier_zip_code":"74820","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:07:31.000000Z","updated_at":"2025-03-17T20:07:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8529322,"change_date":"2024-03-15 21:40:00","inspection_id":"81116751","insp_unit_id":"199936150","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"22","insp_unit_license":"731200","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1FUJC5DX5DHFA7460","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:17.000000Z","updated_at":"2025-03-17T23:12:17.000000Z"},{"id":8529323,"change_date":"2024-03-15 21:40:00","inspection_id":"81116751","insp_unit_id":"199936151","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"314","insp_unit_license":"BN7743","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1GR1A7026LB208975","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:17.000000Z","updated_at":"2025-03-17T23:12:17.000000Z"}]},{"id":4894153,"change_date":"2024-02-05 21:40:00","inspection_id":"80677447","dot_number":"314371","report_state":"OK","report_number":"H600153019","insp_date":"2024-01-24 00:00:00","insp_start_time":"1405","insp_end_time":"1435","registration_date":"2024-02-05 00:00:00","region":"CT","ci_status_code":"C","location":"63177","location_desc":"US-177 S\/B \/ GORDON COOPER DR","county_code_state":"OK","county_code":"125","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"ARCA CONTINENTAL","shipping_paper_number":"2264187972","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-01-24 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","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":"735345","transaction_code":"C","transaction_date":"2024-01-24 00:00:00","upload_date":"2024-02-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00314371","upload_search_indicator":"M","census_search_date":"2024-01-24 21:45:00","snet_input_date":"2024-01-24 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-01-24 21:45:00","insp_carrier_name":"ADA COCA COLA BOTTLING COMPANY","insp_carrier_street":"1205 CRADDUCK ROAD","insp_carrier_city":"ADA","insp_carrier_state":"OK","insp_carrier_zip_code":"74820","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:59:39.000000Z","updated_at":"2025-03-17T19:59:39.000000Z","inspection_violations":[{"id":7540553,"change_date":"2024-02-05 21:40:00","inspection_id":"80677447","insp_violation_id":"257664154","seq_no":"1","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"199267330","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:24.000000Z","updated_at":"2025-03-17T21:42:24.000000Z","normalized_code":"3965B"},{"id":7540554,"change_date":"2024-02-05 21:40:00","inspection_id":"80677447","insp_violation_id":"257664155","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199267330","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:24.000000Z","updated_at":"2025-03-17T21:42:24.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7874843,"change_date":"2024-02-05 21:40:00","inspection_id":"80677447","insp_unit_id":"199267330","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"60","insp_unit_license":"719481","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1NPBDH9X8FD295581","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:22.000000Z","updated_at":"2025-03-17T23:06:22.000000Z"},{"id":7874844,"change_date":"2024-02-05 21:40:00","inspection_id":"80677447","insp_unit_id":"199267331","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"315","insp_unit_license":"BN7741","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1GR1A9624LB208976","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:22.000000Z","updated_at":"2025-03-17T23:06:22.000000Z"}]},{"id":4724960,"change_date":"2024-01-05 21:46:00","inspection_id":"80492532","dot_number":"314371","report_state":"OK","report_number":"H513154289","insp_date":"2023-12-26 00:00:00","insp_start_time":"0559","insp_end_time":"0640","registration_date":"2024-01-05 00:00:00","region":"CT","ci_status_code":"C","location":"67377","location_desc":"US 377 \/ SH 9","county_code_state":"OK","county_code":"133","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"STRAIGHT","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-12-28 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"103000","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":"733210","transaction_code":"C","transaction_date":"2023-12-28 00:00:00","upload_date":"2024-01-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00314371","upload_search_indicator":"M","census_search_date":"2023-12-28 21:45:00","snet_input_date":"2023-12-26 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-12-28 21:45:00","insp_carrier_name":"ADA COCA COLA BOTTLING COMPANY","insp_carrier_street":"1205 CRADDUCK ROAD","insp_carrier_city":"ADA","insp_carrier_state":"OK","insp_carrier_zip_code":"74820","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:56:31.000000Z","updated_at":"2025-03-17T19:56:31.000000Z","inspection_violations":[{"id":7295163,"change_date":"2024-01-05 21:46:00","inspection_id":"80492532","insp_violation_id":"257208984","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198835503","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:13.000000Z","updated_at":"2025-03-17T21:41:13.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7600284,"change_date":"2024-01-05 21:46:00","inspection_id":"80492532","insp_unit_id":"198835503","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"12","insp_unit_license":"726073","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1NPCA28X6PD871343","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:58.000000Z","updated_at":"2025-03-17T23:03:58.000000Z"},{"id":7600285,"change_date":"2024-01-05 21:46:00","inspection_id":"80492532","insp_unit_id":"198835504","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"316","insp_unit_license":"BR6002","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1GR1A702XPB503146","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:58.000000Z","updated_at":"2025-03-17T23:03:58.000000Z"}]},{"id":4491876,"change_date":"2023-12-01 21:42:00","inspection_id":"80236928","dot_number":"314371","report_state":"OK","report_number":"H600152883","insp_date":"2023-11-21 00:00:00","insp_start_time":"1030","insp_end_time":"1051","registration_date":"2023-11-28 00:00:00","region":"CT","ci_status_code":"C","location":"63040","location_desc":"I-40 W\/B \/ MCLOUD","county_code_state":"OK","county_code":"125","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"M\/C","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":null,"final_status_date":"2023-11-27 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":"729512","transaction_code":"C","transaction_date":"2023-11-27 00:00:00","upload_date":"2023-12-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00314371","upload_search_indicator":"M","census_search_date":"2023-11-27 21:41:00","snet_input_date":"2023-11-21 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-11-27 21:41:00","insp_carrier_name":"ADA COCA COLA BOTTLING COMPANY","insp_carrier_street":"1205 CRADDUCK ROAD","insp_carrier_city":"ADA","insp_carrier_state":"OK","insp_carrier_zip_code":"74820","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:51:49.000000Z","updated_at":"2025-03-17T19:51:49.000000Z","inspection_violations":[{"id":6951251,"change_date":"2023-12-01 21:42:00","inspection_id":"80236928","insp_violation_id":"256663160","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"198304204","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:32.000000Z","updated_at":"2025-03-17T21:39:32.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7223914,"change_date":"2023-12-01 21:42:00","inspection_id":"80236928","insp_unit_id":"198304203","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"25","insp_unit_license":"726078","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1FUJGEDR5CSBR5555","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:40.000000Z","updated_at":"2025-03-17T23:00:40.000000Z"},{"id":7223915,"change_date":"2023-12-01 21:42:00","inspection_id":"80236928","insp_unit_id":"198304204","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLM","insp_unit_company":"304","insp_unit_license":"4673FX","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"2MN01JAH481003358","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:40.000000Z","updated_at":"2025-03-17T23:00:40.000000Z"}]},{"id":4491981,"change_date":"2023-12-01 21:42:00","inspection_id":"80237049","dot_number":"314371","report_state":"OK","report_number":"N600000167","insp_date":"2023-11-20 00:00:00","insp_start_time":"1456","insp_end_time":"1531","registration_date":"2023-11-28 00:00:00","region":"CT","ci_status_code":"C","location":"62377","location_desc":"U.S HWY 377 AT CRADDUCK RD","county_code_state":"OK","county_code":"123","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","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":"N","pen_cen_match":null,"final_status_date":"2023-11-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","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":"729270","transaction_code":"C","transaction_date":"2023-11-27 00:00:00","upload_date":"2023-12-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00314371","upload_search_indicator":"M","census_search_date":"2023-11-27 21:41:00","snet_input_date":"2023-11-20 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-11-27 21:41:00","insp_carrier_name":"ADA COCA COLA BOTTLING COMPANY","insp_carrier_street":"1205 CRADDUCK ROAD","insp_carrier_city":"ADA","insp_carrier_state":"OK","insp_carrier_zip_code":"74820","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:51:49.000000Z","updated_at":"2025-03-17T19:51:49.000000Z","inspection_violations":[{"id":6951357,"change_date":"2023-12-01 21:42:00","inspection_id":"80237049","insp_violation_id":"256662078","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"198303189","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:32.000000Z","updated_at":"2025-03-17T21:39:32.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":7224085,"change_date":"2023-12-01 21:42:00","inspection_id":"80237049","insp_unit_id":"198303188","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"3","insp_unit_license":"726079","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1NPBDH9X4LD649494","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:40.000000Z","updated_at":"2025-03-17T23:00:40.000000Z"},{"id":7224086,"change_date":"2023-12-01 21:42:00","inspection_id":"80237049","insp_unit_id":"198303189","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VANR","insp_unit_company":"305","insp_unit_license":"7407GS","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5V5VA4823AM000131","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:40.000000Z","updated_at":"2025-03-17T23:00:40.000000Z"}]},{"id":4311426,"change_date":"2023-11-14 21:41:00","inspection_id":"80037869","dot_number":"314371","report_state":"OK","report_number":"H600152801","insp_date":"2023-10-21 00:00:00","insp_start_time":"0805","insp_end_time":"0830","registration_date":"2023-11-13 00:00:00","region":"CT","ci_status_code":"C","location":"63040","location_desc":"I-40 E\/B \/ SH-102","county_code_state":"OK","county_code":"125","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"M\/C","shipping_paper_number":"1040","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-30 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","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":"726237","transaction_code":"C","transaction_date":"2023-10-23 00:00:00","upload_date":"2023-11-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00314371","upload_search_indicator":"M","census_search_date":"2023-10-30 21:42:00","snet_input_date":"2023-10-21 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-10-30 21:42:00","insp_carrier_name":"ADA COCA COLA BOTTLING COMPANY","insp_carrier_street":"1205 CRADDUCK ROAD","insp_carrier_city":"ADA","insp_carrier_state":"OK","insp_carrier_zip_code":"74820","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:48:22.000000Z","updated_at":"2025-03-17T19:48:22.000000Z","inspection_violations":[{"id":6669185,"change_date":"2023-11-14 21:41:00","inspection_id":"80037869","insp_violation_id":"256383158","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"198051999","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:06.000000Z","updated_at":"2025-03-17T21:38:06.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6934007,"change_date":"2023-11-14 21:41:00","inspection_id":"80037869","insp_unit_id":"198051998","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"60","insp_unit_license":"719481","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1NPBDH9X8FD295581","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:11.000000Z","updated_at":"2025-03-17T22:58:11.000000Z"},{"id":6934008,"change_date":"2023-11-14 21:41:00","inspection_id":"80037869","insp_unit_id":"198051999","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"315","insp_unit_license":"BN7741","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1GR1A9624LB208976","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:11.000000Z","updated_at":"2025-03-17T22:58:11.000000Z"}]},{"id":4311423,"change_date":"2023-11-14 21:41:00","inspection_id":"80037866","dot_number":"314371","report_state":"OK","report_number":"H600152798","insp_date":"2023-10-20 00:00:00","insp_start_time":"1326","insp_end_time":"1402","registration_date":"2023-11-13 00:00:00","region":"CT","ci_status_code":"C","location":"63177","location_desc":"US-177 \/ BENSON PARK","county_code_state":"OK","county_code":"125","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"M\/C","shipping_paper_number":"NO #","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-30 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"101000","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":"726340","transaction_code":"C","transaction_date":"2023-10-23 00:00:00","upload_date":"2023-11-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00314371","upload_search_indicator":"M","census_search_date":"2023-10-30 21:42:00","snet_input_date":"2023-10-20 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-10-30 21:42:00","insp_carrier_name":"ADA COCA COLA BOTTLING COMPANY","insp_carrier_street":"1205 CRADDUCK ROAD","insp_carrier_city":"ADA","insp_carrier_state":"OK","insp_carrier_zip_code":"74820","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:48:22.000000Z","updated_at":"2025-03-17T19:48:22.000000Z","inspection_violations":[{"id":6669179,"change_date":"2023-11-14 21:41:00","inspection_id":"80037866","insp_violation_id":"256383157","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"198051997","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:06.000000Z","updated_at":"2025-03-17T21:38:06.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6934001,"change_date":"2023-11-14 21:41:00","inspection_id":"80037866","insp_unit_id":"198051996","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"40","insp_unit_license":"726083","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"2NP2A27X9GM368154","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:11.000000Z","updated_at":"2025-03-17T22:58:11.000000Z"},{"id":6934002,"change_date":"2023-11-14 21:41:00","inspection_id":"80037866","insp_unit_id":"198051997","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"308","insp_unit_license":"4605JK","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1GRAA7027DB702070","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:11.000000Z","updated_at":"2025-03-17T22:58:11.000000Z"}]},{"id":3932765,"change_date":"2023-11-14 21:41:00","inspection_id":"79618136","dot_number":"314371","report_state":"OK","report_number":"H600152702","insp_date":"2023-09-08 00:00:00","insp_start_time":"0700","insp_end_time":"0720","registration_date":"2023-11-14 00:00:00","region":"CT","ci_status_code":"C","location":"32270","location_desc":"US-270-B \/ BERTON AVE","county_code_state":"OK","county_code":"063","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"M\/C","shipping_paper_number":"1600","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","viol_total":"3","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"721975","transaction_code":"C","transaction_date":"2023-09-08 00:00:00","upload_date":"2023-11-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00314371","upload_search_indicator":"M","census_search_date":"2023-09-08 21:41:00","snet_input_date":"2023-09-08 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-09-08 21:41:00","insp_carrier_name":"ADA COCA COLA BOTTLING COMPANY","insp_carrier_street":"1205 CRADDUCK ROAD","insp_carrier_city":"ADA","insp_carrier_state":"OK","insp_carrier_zip_code":"74820","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:40:28.000000Z","updated_at":"2025-03-17T19:40:28.000000Z","inspection_violations":[{"id":6078609,"change_date":"2023-11-14 21:41:00","inspection_id":"79618136","insp_violation_id":"256382987","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:22.000000Z","updated_at":"2025-03-17T21:35:22.000000Z","normalized_code":"39216A"},{"id":6078610,"change_date":"2023-11-14 21:41:00","inspection_id":"79618136","insp_violation_id":"256382988","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"198051906","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:22.000000Z","updated_at":"2025-03-17T21:35:22.000000Z","normalized_code":"39617C"},{"id":6078611,"change_date":"2023-11-14 21:41:00","inspection_id":"79618136","insp_violation_id":"256382989","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"198051906","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:22.000000Z","updated_at":"2025-03-17T21:35:22.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6323536,"change_date":"2023-11-14 21:41:00","inspection_id":"79618136","insp_unit_id":"198051905","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"3","insp_unit_license":"726079","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1NPBDH9X4LD649494","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:07.000000Z","updated_at":"2025-03-17T22:53:07.000000Z"},{"id":6323537,"change_date":"2023-11-14 21:41:00","inspection_id":"79618136","insp_unit_id":"198051906","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VANR","insp_unit_company":"305","insp_unit_license":"7407GS","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5V5VA4823AM000131","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:07.000000Z","updated_at":"2025-03-17T22:53:07.000000Z"}]},{"id":3684815,"change_date":"2023-08-08 21:41:00","inspection_id":"79341602","dot_number":"314371","report_state":"OK","report_number":"H600152603","insp_date":"2023-08-02 00:00:00","insp_start_time":"1153","insp_end_time":"1220","registration_date":"2023-08-08 00:00:00","region":"CT","ci_status_code":"C","location":"63040","location_desc":"I-40 E\/B \/ SH-102","county_code_state":"OK","county_code":"125","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"M\/C","shipping_paper_number":"2244582116","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-07 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","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":"718250","transaction_code":"C","transaction_date":"2023-08-02 00:00:00","upload_date":"2023-08-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00314371","upload_search_indicator":null,"census_search_date":"2023-08-07 21:42:00","snet_input_date":"2023-08-02 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-08-07 21:42:00","insp_carrier_name":"ADA COCA COLA BOTTLING COMPANY","insp_carrier_street":"1205 CRADDUCK ROAD","insp_carrier_city":"ADA","insp_carrier_state":"OK","insp_carrier_zip_code":"74820","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:35:39.000000Z","updated_at":"2025-03-17T19:35:39.000000Z","inspection_violations":[{"id":5681405,"change_date":"2023-08-08 21:41:00","inspection_id":"79341602","insp_violation_id":"254530557","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"196422048","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:21.000000Z","updated_at":"2025-03-17T21:33:21.000000Z","normalized_code":"3922"},{"id":5681406,"change_date":"2023-08-08 21:41:00","inspection_id":"79341602","insp_violation_id":"254530558","seq_no":"2","part_no":"393","part_no_section":"106(b)","insp_viol_unit":"2","insp_unit_id":"196422048","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:21.000000Z","updated_at":"2025-03-17T21:33:21.000000Z","normalized_code":"393106B"}],"inspection_per_units":[{"id":5924231,"change_date":"2023-08-08 21:41:00","inspection_id":"79341602","insp_unit_id":"196422047","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"60","insp_unit_license":"719481","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1NPBDH9X8FD295581","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:47.000000Z","updated_at":"2025-03-17T22:49:47.000000Z"},{"id":5924232,"change_date":"2023-08-08 21:41:00","inspection_id":"79341602","insp_unit_id":"196422048","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"315","insp_unit_license":"BN7741","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1GR1A9624LB208976","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:47.000000Z","updated_at":"2025-03-17T22:49:47.000000Z"}]},{"id":2930582,"change_date":"2023-05-08 21:42:00","inspection_id":"78492154","dot_number":"314371","report_state":"OK","report_number":"H600152421","insp_date":"2023-04-25 00:00:00","insp_start_time":"0743","insp_end_time":"0810","registration_date":"2023-05-08 00:00:00","region":"CT","ci_status_code":"C","location":"63177","location_desc":"US-177 \/ LEO ST","county_code_state":"OK","county_code":"125","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"ARCA CONTENTAL","shipping_paper_number":"2233608201","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"115000","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":"707258","transaction_code":"C","transaction_date":"2023-05-01 00:00:00","upload_date":"2023-05-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00314371","upload_search_indicator":"M","census_search_date":"2023-05-01 21:39:00","snet_input_date":"2023-04-25 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-05-01 21:39:00","insp_carrier_name":"ADA COCA COLA BOTTLING COMPANY","insp_carrier_street":"1205 CRADDUCK ROAD","insp_carrier_city":"ADA","insp_carrier_state":"OK","insp_carrier_zip_code":"74820","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:20:55.000000Z","updated_at":"2025-03-17T19:20:55.000000Z","inspection_violations":[{"id":4498884,"change_date":"2023-05-08 21:42:00","inspection_id":"78492154","insp_violation_id":"252682063","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"194799792","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:56.000000Z","updated_at":"2025-03-17T21:27:56.000000Z","normalized_code":"39617C"},{"id":4498885,"change_date":"2023-05-08 21:42:00","inspection_id":"78492154","insp_violation_id":"252682064","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"194799793","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:56.000000Z","updated_at":"2025-03-17T21:27:56.000000Z","normalized_code":"39617C"},{"id":4498886,"change_date":"2023-05-08 21:42:00","inspection_id":"78492154","insp_violation_id":"252682065","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"194799793","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:56.000000Z","updated_at":"2025-03-17T21:27:56.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4715013,"change_date":"2023-05-08 21:42:00","inspection_id":"78492154","insp_unit_id":"194799792","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"3","insp_unit_license":"726079","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1NPBDH9X4LD649494","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:11.000000Z","updated_at":"2025-03-17T22:40:11.000000Z"},{"id":4715014,"change_date":"2023-05-08 21:42:00","inspection_id":"78492154","insp_unit_id":"194799793","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLM","insp_unit_company":"304","insp_unit_license":"4673FX","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"2MN01JAH481003358","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:11.000000Z","updated_at":"2025-03-17T22:40:11.000000Z"}]},{"id":2601122,"change_date":"2023-03-22 21:42:00","inspection_id":"78118105","dot_number":"314371","report_state":"OK","report_number":"H600152337","insp_date":"2023-03-14 00:00:00","insp_start_time":"0559","insp_end_time":"0620","registration_date":"2023-03-21 00:00:00","region":"CT","ci_status_code":"C","location":"63177","location_desc":"US-177 \/ TROUSDALE RD","county_code_state":"OK","county_code":"125","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"M\/C","shipping_paper_number":"11103","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-17 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"100000","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":"702936","transaction_code":"C","transaction_date":"2023-03-17 00:00:00","upload_date":"2023-03-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00314371","upload_search_indicator":"M","census_search_date":"2023-03-17 21:42:00","snet_input_date":"2023-03-14 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-03-17 21:42:00","insp_carrier_name":"ADA COCA COLA BOTTLING COMPANY","insp_carrier_street":"1205 CRADDUCK ROAD","insp_carrier_city":"ADA","insp_carrier_state":"OK","insp_carrier_zip_code":"74820","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:14:48.000000Z","updated_at":"2025-03-17T19:14:48.000000Z","inspection_violations":[{"id":4000907,"change_date":"2023-03-22 21:42:00","inspection_id":"78118105","insp_violation_id":"251800556","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"194000970","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:47.000000Z","updated_at":"2025-03-17T21:25:47.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4186716,"change_date":"2023-03-22 21:42:00","inspection_id":"78118105","insp_unit_id":"194000969","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"94","insp_unit_license":"714936","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1HSHWCVN4EJ482536","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:01.000000Z","updated_at":"2025-03-17T22:36:01.000000Z"},{"id":4186717,"change_date":"2023-03-22 21:42:00","inspection_id":"78118105","insp_unit_id":"194000970","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"313","insp_unit_license":"BN7742","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1GR1A7024CB208974","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:01.000000Z","updated_at":"2025-03-17T22:36:01.000000Z"}]},{"id":2265095,"change_date":"2023-02-06 21:41:00","inspection_id":"77735168","dot_number":"314371","report_state":"OK","report_number":"H600152241","insp_date":"2023-01-27 00:00:00","insp_start_time":"0541","insp_end_time":"0605","registration_date":"2023-02-06 00:00:00","region":"CT","ci_status_code":"C","location":"63177","location_desc":"US-177 \/ SING RD","county_code_state":"OK","county_code":"125","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"M\/C","shipping_paper_number":"11102","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-31 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"98000","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":"697976","transaction_code":"C","transaction_date":"2023-01-27 00:00:00","upload_date":"2023-02-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00314371","upload_search_indicator":null,"census_search_date":"2023-01-31 21:43:00","snet_input_date":"2023-01-27 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-01-31 21:43:00","insp_carrier_name":"ADA COCA COLA BOTTLING COMPANY","insp_carrier_street":"1205 CRADDUCK ROAD","insp_carrier_city":"ADA","insp_carrier_state":"OK","insp_carrier_zip_code":"74820","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:08:28.000000Z","updated_at":"2025-03-17T19:08:28.000000Z","inspection_violations":[{"id":3494960,"change_date":"2023-02-06 21:41:00","inspection_id":"77735168","insp_violation_id":"250965020","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"193242530","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:30.000000Z","updated_at":"2025-03-17T21:23:30.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3645957,"change_date":"2023-02-06 21:41:00","inspection_id":"77735168","insp_unit_id":"193242529","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"40","insp_unit_license":"726083","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"2NP2A27X9GM368154","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:08.000000Z","updated_at":"2025-03-17T22:32:08.000000Z"},{"id":3645958,"change_date":"2023-02-06 21:41:00","inspection_id":"77735168","insp_unit_id":"193242530","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"310","insp_unit_license":"8685LL","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1UYVS2368CP307201","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:08.000000Z","updated_at":"2025-03-17T22:32:08.000000Z"}]},{"id":1784228,"change_date":"2022-12-06 21:40:00","inspection_id":"77185198","dot_number":"314371","report_state":"OK","report_number":"H600152121","insp_date":"2022-11-21 00:00:00","insp_start_time":"1028","insp_end_time":"1105","registration_date":"2022-12-05 00:00:00","region":"CT","ci_status_code":"C","location":"63177","location_desc":"US-177 \/ ACME RD","county_code_state":"OK","county_code":"125","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"M\/C","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":null,"final_status_date":"2022-11-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"5","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"691749","transaction_code":"C","transaction_date":"2022-11-21 00:00:00","upload_date":"2022-12-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00314371","upload_search_indicator":"M","census_search_date":"2022-11-21 21:41:00","snet_input_date":"2022-11-21 00:00:00","source_office":"2OKS001","mcmis_add_date":"2022-11-21 21:41:00","insp_carrier_name":"ADA COCA COLA BOTTLING COMPANY","insp_carrier_street":"1205 CRADDUCK ROAD","insp_carrier_city":"ADA","insp_carrier_state":"OK","insp_carrier_zip_code":"74820","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:59:37.000000Z","updated_at":"2025-03-17T18:59:37.000000Z","inspection_violations":[{"id":2791099,"change_date":"2022-12-06 21:40:00","inspection_id":"77185198","insp_violation_id":"249937217","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"192277517","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:06.000000Z","updated_at":"2025-03-17T21:20:06.000000Z","normalized_code":"39395A"},{"id":2791100,"change_date":"2022-12-06 21:40:00","inspection_id":"77185198","insp_violation_id":"249937218","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"192277517","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:06.000000Z","updated_at":"2025-03-17T21:20:06.000000Z","normalized_code":"3922"},{"id":2791101,"change_date":"2022-12-06 21:40:00","inspection_id":"77185198","insp_violation_id":"249937219","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"192277518","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:06.000000Z","updated_at":"2025-03-17T21:20:06.000000Z","normalized_code":"3963A1"},{"id":2791102,"change_date":"2022-12-06 21:40:00","inspection_id":"77185198","insp_violation_id":"249937220","seq_no":"4","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"192277518","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:06.000000Z","updated_at":"2025-03-17T21:20:06.000000Z","normalized_code":"39311"},{"id":2791103,"change_date":"2022-12-06 21:40:00","inspection_id":"77185198","insp_violation_id":"249937221","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"192277518","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:06.000000Z","updated_at":"2025-03-17T21:20:06.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2869969,"change_date":"2022-12-06 21:40:00","inspection_id":"77185198","insp_unit_id":"192277517","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"25","insp_unit_license":"714945","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1FUJGEDR5CSBR5555","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:37.000000Z","updated_at":"2025-03-17T22:26:37.000000Z"},{"id":2869970,"change_date":"2022-12-06 21:40:00","inspection_id":"77185198","insp_unit_id":"192277518","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLM","insp_unit_company":"304","insp_unit_license":"4673FX","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"2MN01JAH481003358","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:37.000000Z","updated_at":"2025-03-17T22:26:37.000000Z"}]},{"id":1727274,"change_date":"2022-11-22 21:41:00","inspection_id":"77119853","dot_number":"314371","report_state":"OK","report_number":"C200000076","insp_date":"2022-11-12 00:00:00","insp_start_time":"1140","insp_end_time":"1201","registration_date":null,"region":"CT","ci_status_code":"C","location":"63177","location_desc":"US-177 AND SH-9","county_code_state":"OK","county_code":"125","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"-","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"145000","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":"690571","transaction_code":"C","transaction_date":"2022-11-22 00:00:00","upload_date":"2022-11-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00314371","upload_search_indicator":"M","census_search_date":"2022-11-14 21:42:00","snet_input_date":"2022-11-12 00:00:00","source_office":"2OKS001","mcmis_add_date":"2022-11-14 21:42:00","insp_carrier_name":"ADA COCA COLA BOTTLING COMPANY","insp_carrier_street":"1205 CRADDUCK ROAD","insp_carrier_city":"ADA","insp_carrier_state":"OK","insp_carrier_zip_code":"74820","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:58:33.000000Z","updated_at":"2025-03-17T18:58:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2778600,"change_date":"2022-11-22 21:41:00","inspection_id":"77119853","insp_unit_id":"192086623","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"60","insp_unit_license":"719481","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1NPBDH9X8FD295581","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:00.000000Z","updated_at":"2025-03-17T22:26:00.000000Z"},{"id":2778601,"change_date":"2022-11-22 21:41:00","inspection_id":"77119853","insp_unit_id":"192086624","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"315","insp_unit_license":"BN7741","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1GR1A9624LB208976","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:00.000000Z","updated_at":"2025-03-17T22:26:00.000000Z"}]},{"id":1727416,"change_date":"2022-11-17 21:40:00","inspection_id":"77120020","dot_number":"314371","report_state":"OK","report_number":"H600152104","insp_date":"2022-11-11 00:00:00","insp_start_time":"0558","insp_end_time":"0630","registration_date":"2022-11-17 00:00:00","region":"CT","ci_status_code":"C","location":"63177","location_desc":"US-177 \/ BROOKSVILLE RD","county_code_state":"OK","county_code":"125","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"M\/C","shipping_paper_number":"NO #","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"690519","transaction_code":"C","transaction_date":"2022-11-14 00:00:00","upload_date":"2022-11-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00314371","upload_search_indicator":"M","census_search_date":"2022-11-14 21:42:00","snet_input_date":"2022-11-11 00:00:00","source_office":"2OKS001","mcmis_add_date":"2022-11-14 21:42:00","insp_carrier_name":"ADA COCA COLA BOTTLING COMPANY","insp_carrier_street":"1205 CRADDUCK ROAD","insp_carrier_city":"ADA","insp_carrier_state":"OK","insp_carrier_zip_code":"74820","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:58:33.000000Z","updated_at":"2025-03-17T18:58:33.000000Z","inspection_violations":[{"id":2704624,"change_date":"2022-11-17 21:40:00","inspection_id":"77120020","insp_violation_id":"249659963","seq_no":"1","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:45.000000Z","updated_at":"2025-03-17T21:19:45.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":2778852,"change_date":"2022-11-17 21:40:00","inspection_id":"77120020","insp_unit_id":"192009913","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"22","insp_unit_license":"714942","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1FUJC5DX5DHFA7460","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:00.000000Z","updated_at":"2025-03-17T22:26:00.000000Z"},{"id":2778853,"change_date":"2022-11-17 21:40:00","inspection_id":"77120020","insp_unit_id":"192009914","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"310","insp_unit_license":"8685LL","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1UYVS2368CP307201","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:00.000000Z","updated_at":"2025-03-17T22:26:00.000000Z"}]},{"id":1195039,"change_date":"2022-09-26 21:39:00","inspection_id":"76504805","dot_number":"314371","report_state":"OK","report_number":"H600151926","insp_date":"2022-09-01 00:00:00","insp_start_time":"1540","insp_end_time":"1610","registration_date":"2022-09-20 00:00:00","region":"CT","ci_status_code":"C","location":"63177","location_desc":"US-177 \/ HIGHLAND ST","county_code_state":"OK","county_code":"125","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"M\/C","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":null,"final_status_date":"2022-09-01 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"100000","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":"682666","transaction_code":"C","transaction_date":"2022-09-01 00:00:00","upload_date":"2022-09-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00314371","upload_search_indicator":"M","census_search_date":"2022-09-01 21:41:00","snet_input_date":"2022-09-01 00:00:00","source_office":"2OKS001","mcmis_add_date":"2022-09-01 21:41:00","insp_carrier_name":"ADA COCA COLA BOTTLING COMPANY","insp_carrier_street":"1205 CRADDUCK ROAD","insp_carrier_city":"ADA","insp_carrier_state":"OK","insp_carrier_zip_code":"74820","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:48:39.000000Z","updated_at":"2025-03-17T18:48:39.000000Z","inspection_violations":[{"id":1894459,"change_date":"2022-09-26 21:39:00","inspection_id":"76504805","insp_violation_id":"248633200","seq_no":"1","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"191087591","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:44.000000Z","updated_at":"2025-03-17T21:15:44.000000Z","normalized_code":"39345D"}],"inspection_per_units":[{"id":1921457,"change_date":"2022-09-26 21:39:00","inspection_id":"76504805","insp_unit_id":"191087591","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"94","insp_unit_license":"714936","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1HSHWCVN4EJ482536","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:13.000000Z","updated_at":"2025-03-17T22:20:13.000000Z"},{"id":1921458,"change_date":"2022-09-26 21:39:00","inspection_id":"76504805","insp_unit_id":"191087592","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"313","insp_unit_license":"BN7742","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1GR1A7024CB208974","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:13.000000Z","updated_at":"2025-03-17T22:20:13.000000Z"}]},{"id":1111917,"change_date":"2022-09-09 21:38:00","inspection_id":"76408226","dot_number":"314371","report_state":"OK","report_number":"H600151904","insp_date":"2022-08-23 00:00:00","insp_start_time":"0700","insp_end_time":"0805","registration_date":"2022-09-08 00:00:00","region":"CT","ci_status_code":"C","location":"63177","location_desc":"US-177 \/ US-270 B (KICK SPUR)","county_code_state":"OK","county_code":"125","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"M\/C","shipping_paper_number":"1650","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-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"101000","viol_total":"8","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"681505","transaction_code":"C","transaction_date":"2022-08-23 00:00:00","upload_date":"2022-09-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00314371","upload_search_indicator":"M","census_search_date":"2022-08-23 21:41:00","snet_input_date":"2022-08-23 00:00:00","source_office":"2OKS001","mcmis_add_date":"2022-08-23 21:41:00","insp_carrier_name":"ADA COCA COLA BOTTLING COMPANY","insp_carrier_street":"1205 CRADDUCK ROAD","insp_carrier_city":"ADA","insp_carrier_state":"OK","insp_carrier_zip_code":"74820","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:47:15.000000Z","updated_at":"2025-03-17T18:47:15.000000Z","inspection_violations":[{"id":1752144,"change_date":"2022-09-09 21:38:00","inspection_id":"76408226","insp_violation_id":"248305138","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"190806814","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:09.000000Z","updated_at":"2025-03-17T21:15:09.000000Z","normalized_code":"39617C"},{"id":1752145,"change_date":"2022-09-09 21:38:00","inspection_id":"76408226","insp_violation_id":"248305139","seq_no":"2","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"190806814","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:09.000000Z","updated_at":"2025-03-17T21:15:09.000000Z","normalized_code":"39345D"},{"id":1752146,"change_date":"2022-09-09 21:38:00","inspection_id":"76408226","insp_violation_id":"248305140","seq_no":"3","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"190806814","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:09.000000Z","updated_at":"2025-03-17T21:15:09.000000Z","normalized_code":"39345D"},{"id":1752147,"change_date":"2022-09-09 21:38:00","inspection_id":"76408226","insp_violation_id":"248305141","seq_no":"4","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"190806814","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:09.000000Z","updated_at":"2025-03-17T21:15:09.000000Z","normalized_code":"39347E"},{"id":1752148,"change_date":"2022-09-09 21:38:00","inspection_id":"76408226","insp_violation_id":"248305142","seq_no":"5","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"190806814","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:09.000000Z","updated_at":"2025-03-17T21:15:09.000000Z","normalized_code":"39353B"},{"id":1752149,"change_date":"2022-09-09 21:38:00","inspection_id":"76408226","insp_violation_id":"248305143","seq_no":"6","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"190806815","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:09.000000Z","updated_at":"2025-03-17T21:15:09.000000Z","normalized_code":"3922"},{"id":1752150,"change_date":"2022-09-09 21:38:00","inspection_id":"76408226","insp_violation_id":"248305144","seq_no":"7","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"190806815","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:09.000000Z","updated_at":"2025-03-17T21:15:09.000000Z","normalized_code":"39617C"},{"id":1752151,"change_date":"2022-09-09 21:38:00","inspection_id":"76408226","insp_violation_id":"248305145","seq_no":"8","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"190806815","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:09.000000Z","updated_at":"2025-03-17T21:15:09.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":1787999,"change_date":"2022-09-09 21:38:00","inspection_id":"76408226","insp_unit_id":"190806814","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"23","insp_unit_license":"714943","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1FUJC5DX7DHFA7458","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:17.000000Z","updated_at":"2025-03-17T22:19:17.000000Z"},{"id":1788000,"change_date":"2022-09-09 21:38:00","inspection_id":"76408226","insp_unit_id":"190806815","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"314","insp_unit_license":"N7743","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1GR1A7026LB208975","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:17.000000Z","updated_at":"2025-03-17T22:19:17.000000Z"}]},{"id":276656,"change_date":"2022-04-28 21:39:00","inspection_id":"75423070","dot_number":"314371","report_state":"OK","report_number":"H600151708","insp_date":"2022-04-27 00:00:00","insp_start_time":"0644","insp_end_time":"0714","registration_date":null,"region":"CT","ci_status_code":"C","location":"63177","location_desc":"US-177 \/ HARDESTY RD","county_code_state":"OK","county_code":"125","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"M\/C","shipping_paper_number":"NO #","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-28 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"101000","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":"668407","transaction_code":"A","transaction_date":"2022-04-27 00:00:00","upload_date":"2022-04-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00314371","upload_search_indicator":null,"census_search_date":"2022-04-28 21:39:00","snet_input_date":"2022-04-27 00:00:00","source_office":"2OKS001","mcmis_add_date":"2022-04-28 21:39:00","insp_carrier_name":"ADA COCA COLA BOTTLING COMPANY","insp_carrier_street":"1205 CRADDUCK ROAD","insp_carrier_city":"ADA","insp_carrier_state":"OK","insp_carrier_zip_code":"74820","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:32:16.000000Z","updated_at":"2025-03-17T18:32:16.000000Z","inspection_violations":[{"id":428382,"change_date":"2022-04-28 21:39:00","inspection_id":"75423070","insp_violation_id":"245440828","seq_no":"1","part_no":"391","part_no_section":"41(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:04.000000Z","updated_at":"2025-03-17T21:09:04.000000Z","normalized_code":"39141A1"}],"inspection_per_units":[{"id":447821,"change_date":"2022-04-28 21:39:00","inspection_id":"75423070","insp_unit_id":"188395774","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"40","insp_unit_license":"714940","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"2NP2A27X9GM368154","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:57.000000Z","updated_at":"2025-03-17T22:10:57.000000Z"},{"id":447822,"change_date":"2022-04-28 21:39:00","inspection_id":"75423070","insp_unit_id":"188395775","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"308","insp_unit_license":"4605JK","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1GRAA7027DB702070","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:57.000000Z","updated_at":"2025-03-17T22:10:57.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/314371\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/314371\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/314371\/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\/314371\/inspections","per_page":100,"prev_page_url":null,"to":33,"total":33}