{"current_page":1,"data":[{"id":12570639,"change_date":"2026-07-28 21:41:00","inspection_id":"88538614","dot_number":"510829","report_state":"IN","report_number":"5982006617","insp_date":"2026-07-24 00:00:00","insp_start_time":"1500","insp_end_time":"1645","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"CONNERSVILLE IN","county_code_state":"IN","county_code":"041","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SYSCO","shipping_paper_number":"0718783","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-28 21:41:00","post_acc_ind":"Y","gross_comb_veh_wt":"118000","viol_total":"7","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3853142","transaction_code":"A","transaction_date":"2026-07-28 00:00:00","upload_date":"2026-07-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00510829","upload_search_indicator":null,"census_search_date":"2026-07-28 21:41:00","snet_input_date":"2026-07-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-28 21:41:00","insp_carrier_name":"SYSCO CINCINNATI LLC","insp_carrier_street":"10510 EVENDALE DRIVE","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45241","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-31T09:41:30.000000Z","updated_at":"2026-08-05T09:34:19.000000Z","inspection_violations":[{"id":21886592,"change_date":"2026-07-28 21:41:00","inspection_id":"88538614","insp_violation_id":"275782201","seq_no":"5","part_no":"396","part_no_section":"5B-L","insp_viol_unit":"1","insp_unit_id":"214858979","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-31T10:02:52.000000Z","updated_at":"2026-08-05T09:48:15.000000Z","normalized_code":"3965BL"},{"id":21886594,"change_date":"2026-07-28 21:41:00","inspection_id":"88538614","insp_violation_id":"275782203","seq_no":"7","part_no":"393","part_no_section":"203E-CBP","insp_viol_unit":"1","insp_unit_id":"214858979","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-31T10:02:52.000000Z","updated_at":"2026-08-05T09:48:15.000000Z","normalized_code":"393203ECBP"},{"id":21886595,"change_date":"2026-07-28 21:41:00","inspection_id":"88538614","insp_violation_id":"275782204","seq_no":"1","part_no":"393","part_no_section":"9A-HLLH","insp_viol_unit":"1","insp_unit_id":"214858979","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-31T10:02:52.000000Z","updated_at":"2026-08-05T09:48:15.000000Z","normalized_code":"3939AHLLH"},{"id":21886596,"change_date":"2026-07-28 21:41:00","inspection_id":"88538614","insp_violation_id":"275782205","seq_no":"2","part_no":"393","part_no_section":"9A-LFTSI","insp_viol_unit":"1","insp_unit_id":"214858979","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-31T10:02:52.000000Z","updated_at":"2026-08-05T09:48:15.000000Z","normalized_code":"3939ALFTSI"},{"id":21886597,"change_date":"2026-07-28 21:41:00","inspection_id":"88538614","insp_violation_id":"275782206","seq_no":"3","part_no":"393","part_no_section":"209C-STSCL","insp_viol_unit":"1","insp_unit_id":"214858979","insp_violation_category_id":"21","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-07-31T10:02:52.000000Z","updated_at":"2026-08-05T09:48:15.000000Z","normalized_code":"393209CSTSCL"},{"id":21886598,"change_date":"2026-07-28 21:41:00","inspection_id":"88538614","insp_violation_id":"275782207","seq_no":"4","part_no":"393","part_no_section":"65C-FNS","insp_viol_unit":"1","insp_unit_id":"214858979","insp_violation_category_id":"18","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-07-31T10:02:52.000000Z","updated_at":"2026-08-05T09:48:15.000000Z","normalized_code":"39365CFNS"},{"id":21886593,"change_date":"2026-07-28 21:41:00","inspection_id":"88538614","insp_violation_id":"275782202","seq_no":"6","part_no":"393","part_no_section":"203C-CBP","insp_viol_unit":"1","insp_unit_id":"214858979","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-31T10:02:52.000000Z","updated_at":"2026-08-05T09:48:15.000000Z","normalized_code":"393203CCBP"}],"inspection_per_units":[{"id":21826728,"change_date":"2026-07-28 21:41:00","inspection_id":"88538614","insp_unit_id":"214858980","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":"246787","insp_unit_license":"P668528","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"526163820J5000592","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-31T09:18:14.000000Z","updated_at":"2026-08-05T09:07:04.000000Z"},{"id":21826727,"change_date":"2026-07-28 21:41:00","inspection_id":"88538614","insp_unit_id":"214858979","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"CIN 132107","insp_unit_license":"2028291","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUBGBDV6ELFA8489","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-31T09:18:14.000000Z","updated_at":"2026-08-05T09:07:04.000000Z"}]},{"id":11145426,"change_date":"2026-02-17 21:38:00","inspection_id":"87059753","dot_number":"510829","report_state":"OH","report_number":"3289001167","insp_date":"2026-02-16 00:00:00","insp_start_time":"0716","insp_end_time":"0751","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"ROCKBRIDGE OH","county_code_state":"OH","county_code":"073","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER\/SAME","shipping_paper_number":"RTE !009","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-02-17 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"92000","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":"2896249","transaction_code":"A","transaction_date":"2026-02-17 00:00:00","upload_date":"2026-02-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00510829","upload_search_indicator":null,"census_search_date":"2026-02-17 21:38:00","snet_input_date":"2026-02-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-17 21:38:00","insp_carrier_name":"SYSCO CINCINNATI LLC","insp_carrier_street":"10510 EVENDALE DRIVE","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45241","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-20T10:37:41.000000Z","updated_at":"2026-02-28T10:30:18.000000Z","inspection_violations":[{"id":18675320,"change_date":"2026-02-17 21:38:00","inspection_id":"87059753","insp_violation_id":"271833810","seq_no":"1","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"211653649","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-20T10:52:28.000000Z","updated_at":"2026-02-28T10:40:19.000000Z","normalized_code":"39395A4EEUS"}],"inspection_per_units":[{"id":19013553,"change_date":"2026-02-17 21:38:00","inspection_id":"87059753","insp_unit_id":"211653649","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"135313","insp_unit_license":"2341890","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUJGBDV8GLHE4317","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-20T10:14:25.000000Z","updated_at":"2026-02-28T10:02:56.000000Z"},{"id":19013554,"change_date":"2026-02-17 21:38:00","inspection_id":"87059753","insp_unit_id":"211653650","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"255317","insp_unit_license":"PF55595","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V281K0SJ402412","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-20T10:14:25.000000Z","updated_at":"2026-02-28T10:02:56.000000Z"}]},{"id":11101421,"change_date":"2026-02-11 21:38:00","inspection_id":"87013477","dot_number":"510829","report_state":"OH","report_number":"3289001153","insp_date":"2026-02-09 00:00:00","insp_start_time":"0903","insp_end_time":"0929","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"ROCKBRIDGE OH","county_code_state":"OH","county_code":"073","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER\/SAME","shipping_paper_number":"RTE 1039","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-02-11 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"117300","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2869432","transaction_code":"A","transaction_date":"2026-02-10 00:00:00","upload_date":"2026-02-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00510829","upload_search_indicator":null,"census_search_date":"2026-02-11 21:38:00","snet_input_date":"2026-02-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-11 21:38:00","insp_carrier_name":"SYSCO CINCINNATI LLC","insp_carrier_street":"10510 EVENDALE DRIVE","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45241","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-14T10:37:30.000000Z","updated_at":"2026-02-22T10:30:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18932338,"change_date":"2026-02-11 21:38:00","inspection_id":"87013477","insp_unit_id":"211555340","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"149855","insp_unit_license":"2962353","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHTDV5SSWC5508","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-14T10:15:29.000000Z","updated_at":"2026-02-22T10:02:33.000000Z"},{"id":18932339,"change_date":"2026-02-11 21:38:00","inspection_id":"87013477","insp_unit_id":"211555341","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HACKNEY &","insp_unit_company":"247503","insp_unit_license":"PD71134","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"52616382XJ5001166","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-14T10:15:29.000000Z","updated_at":"2026-02-22T10:02:33.000000Z"}]},{"id":11090515,"change_date":"2026-02-10 21:38:00","inspection_id":"87002047","dot_number":"510829","report_state":"WV","report_number":"PSC1481222","insp_date":"2026-02-05 00:00:00","insp_start_time":"1345","insp_end_time":"1406","registration_date":null,"region":"ES","ci_status_code":"C","location":"I064WB","location_desc":"HURRICANE WV","county_code_state":"WV","county_code":"079","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","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-02-10 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"71504","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":"2866718","transaction_code":"A","transaction_date":"2026-02-09 00:00:00","upload_date":"2026-02-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00510829","upload_search_indicator":null,"census_search_date":"2026-02-10 21:38:00","snet_input_date":"2026-02-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-10 21:38:00","insp_carrier_name":"SYSCO CINCINNATI LLC","insp_carrier_street":"10510 EVENDALE DRIVE","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45241","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-13T10:37:49.000000Z","updated_at":"2026-02-21T10:30:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18912573,"change_date":"2026-02-10 21:38:00","inspection_id":"87002047","insp_unit_id":"211532785","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"3481119","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKBHTDV3PDUP1885","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-13T10:15:34.000000Z","updated_at":"2026-02-21T10:02:56.000000Z"},{"id":18912574,"change_date":"2026-02-10 21:38:00","inspection_id":"87002047","insp_unit_id":"211532786","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"3786534","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"526162819H5000151","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-13T10:15:34.000000Z","updated_at":"2026-02-21T10:02:56.000000Z"}]},{"id":10546493,"change_date":"2025-12-31 21:37:00","inspection_id":"86683155","dot_number":"510829","report_state":"OH","report_number":"3270001543","insp_date":"2025-12-30 00:00:00","insp_start_time":"0703","insp_end_time":"0800","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"CLEVES OH","county_code_state":"OH","county_code":"061","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SYSCO","shipping_paper_number":"2063","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-12-31 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"99700","viol_total":"8","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2712261","transaction_code":"A","transaction_date":"2025-12-31 00:00:00","upload_date":"2025-12-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00510829","upload_search_indicator":null,"census_search_date":"2025-12-31 21:37:00","snet_input_date":"2025-12-30 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-12-31 21:37:00","insp_carrier_name":"SYSCO CINCINNATI LLC","insp_carrier_street":"10510 EVENDALE DRIVE","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45241","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-03T10:35:07.000000Z","updated_at":"2026-01-11T10:30:21.000000Z","inspection_violations":[{"id":17716106,"change_date":"2025-12-31 21:37:00","inspection_id":"86683155","insp_violation_id":"270967346","seq_no":"1","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"2","insp_unit_id":"210864882","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-03T10:39:03.000000Z","updated_at":"2026-01-11T10:30:43.000000Z","normalized_code":"3939ALCL"},{"id":17716107,"change_date":"2025-12-31 21:37:00","inspection_id":"86683155","insp_violation_id":"270967347","seq_no":"2","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"2","insp_unit_id":"210864882","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-03T10:39:03.000000Z","updated_at":"2026-01-11T10:30:43.000000Z","normalized_code":"3939ALCL"},{"id":17716108,"change_date":"2025-12-31 21:37:00","inspection_id":"86683155","insp_violation_id":"270967348","seq_no":"3","part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"2","insp_unit_id":"210864882","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-03T10:39:03.000000Z","updated_at":"2026-01-11T10:30:43.000000Z","normalized_code":"3939ALRLI"},{"id":17716109,"change_date":"2025-12-31 21:37:00","inspection_id":"86683155","insp_violation_id":"270967349","seq_no":"4","part_no":"393","part_no_section":"9A-LSLIWR","insp_viol_unit":"2","insp_unit_id":"210864882","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-01-03T10:39:03.000000Z","updated_at":"2026-01-11T10:30:43.000000Z","normalized_code":"3939ALSLIWR"},{"id":17716110,"change_date":"2025-12-31 21:37:00","inspection_id":"86683155","insp_violation_id":"270967350","seq_no":"5","part_no":"393","part_no_section":"9A-LSML","insp_viol_unit":"2","insp_unit_id":"210864882","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-03T10:39:03.000000Z","updated_at":"2026-01-11T10:30:43.000000Z","normalized_code":"3939ALSML"},{"id":17716111,"change_date":"2025-12-31 21:37:00","inspection_id":"86683155","insp_violation_id":"270967351","seq_no":"6","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"210864882","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-03T10:39:03.000000Z","updated_at":"2026-01-11T10:30:43.000000Z","normalized_code":"3939ALIL"},{"id":17716112,"change_date":"2025-12-31 21:37:00","inspection_id":"86683155","insp_violation_id":"270967352","seq_no":"7","part_no":"393","part_no_section":"9A-LTSI","insp_viol_unit":"2","insp_unit_id":"210864882","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-01-03T10:39:03.000000Z","updated_at":"2026-01-11T10:30:43.000000Z","normalized_code":"3939ALTSI"},{"id":17716113,"change_date":"2025-12-31 21:37:00","inspection_id":"86683155","insp_violation_id":"270967353","seq_no":"8","part_no":"393","part_no_section":"9A-LTSI","insp_viol_unit":"2","insp_unit_id":"210864882","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-01-03T10:39:03.000000Z","updated_at":"2026-01-11T10:30:43.000000Z","normalized_code":"3939ALTSI"}],"inspection_per_units":[{"id":17667830,"change_date":"2025-12-31 21:37:00","inspection_id":"86683155","insp_unit_id":"210864881","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"CIN149851","insp_unit_license":"3786532","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKBHTDV3SSWC8914","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-03T10:05:55.000000Z","updated_at":"2026-01-11T10:00:23.000000Z"},{"id":17667831,"change_date":"2025-12-31 21:37:00","inspection_id":"86683155","insp_unit_id":"210864882","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HACKNEY &","insp_unit_company":"250486","insp_unit_license":"PG74469","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"526163829L5000013","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-03T10:05:55.000000Z","updated_at":"2026-01-11T10:00:23.000000Z"}]},{"id":10191009,"change_date":"2025-11-13 21:39:00","inspection_id":"86311321","dot_number":"510829","report_state":"KY","report_number":"CV44880818","insp_date":"2025-11-13 00:00:00","insp_start_time":"1236","insp_end_time":"1332","registration_date":null,"region":"ET","ci_status_code":"C","location":"9804","location_desc":"MOREHEAD","county_code_state":"KY","county_code":"205","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"SYSCO","shipping_paper_number":"4011","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-11-13 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"102700","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":"2316556","transaction_code":"A","transaction_date":"2025-11-13 00:00:00","upload_date":"2025-11-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00510829","upload_search_indicator":"M","census_search_date":"2025-11-13 21:39:00","snet_input_date":"2025-11-13 00:00:00","source_office":"2KYS001","mcmis_add_date":"2025-11-13 21:39:00","insp_carrier_name":"SYSCO CINCINNATI LLC","insp_carrier_street":"10510 EVENDALE DRIVE","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45241","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-16T10:31:55.000000Z","updated_at":"2025-11-17T10:30:46.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16974661,"change_date":"2025-11-13 21:39:00","inspection_id":"86311321","insp_unit_id":"210008718","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"CIN141131","insp_unit_license":"3711248","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN2AY7LM002041","insp_unit_decal":"Y","insp_unit_decal_number":"35799354","created_at":"2025-11-16T10:02:26.000000Z","updated_at":"2025-11-17T10:00:51.000000Z"},{"id":16974662,"change_date":"2025-11-13 21:39:00","inspection_id":"86311321","insp_unit_id":"210008719","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"256514","insp_unit_license":"C482002","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"3H3V382K7SJ518802","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-16T10:02:26.000000Z","updated_at":"2025-11-17T10:00:51.000000Z"}]},{"id":10104343,"change_date":"2025-11-03 21:39:00","inspection_id":"86220091","dot_number":"510829","report_state":"WV","report_number":"PSC1600471","insp_date":"2025-10-30 00:00:00","insp_start_time":"1400","insp_end_time":"1428","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"HURRICANE WV","county_code_state":"WV","county_code":"079","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-11-03 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"77700","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2495666","transaction_code":"A","transaction_date":"2025-11-03 00:00:00","upload_date":"2025-11-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00510829","upload_search_indicator":null,"census_search_date":"2025-11-03 21:39:00","snet_input_date":"2025-10-30 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-11-03 21:39:00","insp_carrier_name":"SYSCO CINCINNATI LLC","insp_carrier_street":"10510 EVENDALE DRIVE","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45241","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-06T10:30:39.000000Z","updated_at":"2025-11-07T10:30:33.000000Z","inspection_violations":[{"id":16745232,"change_date":"2025-11-03 21:39:00","inspection_id":"86220091","insp_violation_id":"269685103","seq_no":"1","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"209799232","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-07T10:30:51.000000Z","updated_at":"2025-11-07T10:30:51.000000Z","normalized_code":"39021TB2DOT"},{"id":16745233,"change_date":"2025-11-03 21:39:00","inspection_id":"86220091","insp_violation_id":"269685104","seq_no":"2","part_no":"393","part_no_section":"45B2-BHTD","insp_viol_unit":"2","insp_unit_id":"209799233","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-11-07T10:30:51.000000Z","updated_at":"2025-11-07T10:30:51.000000Z","normalized_code":"39345B2BHTD"},{"id":16745234,"change_date":"2025-11-03 21:39:00","inspection_id":"86220091","insp_violation_id":"269685105","seq_no":"3","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"209799233","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-07T10:30:51.000000Z","updated_at":"2025-11-07T10:30:51.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":16803822,"change_date":"2025-11-03 21:39:00","inspection_id":"86220091","insp_unit_id":"209799232","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"143515","insp_unit_license":"3431995","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN3AY0PM003978","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-06T10:00:35.000000Z","updated_at":"2025-11-07T10:00:44.000000Z"},{"id":16803823,"change_date":"2025-11-03 21:39:00","inspection_id":"86220091","insp_unit_id":"209799233","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"PD71427","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"526162813P5000662","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-06T10:00:35.000000Z","updated_at":"2025-11-07T10:00:44.000000Z"}]},{"id":10054080,"change_date":"2025-10-28 21:39:00","inspection_id":"86167048","dot_number":"510829","report_state":"US","report_number":"2069000020","insp_date":"2025-10-20 00:00:00","insp_start_time":"1408","insp_end_time":"1443","registration_date":null,"region":"ED","ci_status_code":"C","location":"I064WB","location_desc":"HURRICANE WV","county_code_state":"WV","county_code":"079","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SYSCO","shipping_paper_number":"0686452","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-10-28 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"74700","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":"2469934","transaction_code":"A","transaction_date":"2025-10-28 00:00:00","upload_date":"2025-10-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00510829","upload_search_indicator":null,"census_search_date":"2025-10-28 21:39:00","snet_input_date":"2025-10-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-28 21:39:00","insp_carrier_name":"SYSCO CINCINNATI LLC","insp_carrier_street":"10510 EVENDALE DRIVE","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45241","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-01T10:01:55.000000Z","updated_at":"2025-11-01T10:01:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16708308,"change_date":"2025-10-28 21:39:00","inspection_id":"86167048","insp_unit_id":"209692700","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"146586","insp_unit_license":"3481120","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKBHTDV9PDUP1888","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-31T09:47:07.000000Z","updated_at":"2025-11-01T09:45:52.000000Z"},{"id":16708309,"change_date":"2025-10-28 21:39:00","inspection_id":"86167048","insp_unit_id":"209692701","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"253317","insp_unit_license":"PF55595","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V281K0SJ402412","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-31T09:47:07.000000Z","updated_at":"2025-11-01T09:45:52.000000Z"}]},{"id":9909573,"change_date":"2025-10-10 21:40:00","inspection_id":"86014395","dot_number":"510829","report_state":"WV","report_number":"PSC1481043","insp_date":"2025-10-01 00:00:00","insp_start_time":"1246","insp_end_time":"1304","registration_date":null,"region":"ED","ci_status_code":"C","location":"I064WB","location_desc":"HURRICANE WV","county_code_state":"WV","county_code":"079","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-10-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"90000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2394389","transaction_code":"A","transaction_date":"2025-10-10 00:00:00","upload_date":"2025-10-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00510829","upload_search_indicator":null,"census_search_date":"2025-10-10 21:40:00","snet_input_date":"2025-10-01 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-10 21:40:00","insp_carrier_name":"SYSCO CINCINNATI LLC","insp_carrier_street":"10510 EVENDALE DRIVE","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45241","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-13T10:02:07.000000Z","updated_at":"2025-10-14T10:00:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16445777,"change_date":"2025-10-10 21:40:00","inspection_id":"86014395","insp_unit_id":"209406661","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"3481120","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKBHTDV9PDUP1888","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-13T09:47:29.000000Z","updated_at":"2025-10-14T09:46:08.000000Z"},{"id":16445778,"change_date":"2025-10-10 21:40:00","inspection_id":"86014395","insp_unit_id":"209406662","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"208564","insp_unit_license":"TPR7785","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1GRAA5614BB705444","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-13T09:47:29.000000Z","updated_at":"2025-10-14T09:46:08.000000Z"}]},{"id":9729116,"change_date":"2025-09-29 21:39:00","inspection_id":"85825311","dot_number":"510829","report_state":"KY","report_number":"CV43734043","insp_date":"2025-09-19 00:00:00","insp_start_time":"1156","insp_end_time":"1240","registration_date":"2025-09-26 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"HENDERSON","county_code_state":"KY","county_code":"101","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SYSCO CINCINNATI LLC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-19 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"17950","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":"2304527","transaction_code":"C","transaction_date":"2025-09-19 00:00:00","upload_date":"2025-09-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00510829","upload_search_indicator":"M","census_search_date":"2025-09-19 21:38:00","snet_input_date":"2025-09-19 00:00:00","source_office":"2KYS001","mcmis_add_date":"2025-09-19 21:38:00","insp_carrier_name":"SYSCO CINCINNATI LLC","insp_carrier_street":"10510 EVENDALE DRIVE","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45241","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-23T10:02:43.000000Z","updated_at":"2025-10-03T10:00:34.000000Z","inspection_violations":[{"id":16125853,"change_date":"2025-09-29 21:39:00","inspection_id":"85825311","insp_violation_id":"268981740","seq_no":"1","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"FC22944","created_at":"2025-10-02T10:15:23.000000Z","updated_at":"2025-10-03T10:15:56.000000Z","normalized_code":"3922SLL"}],"inspection_per_units":[{"id":16249376,"change_date":"2025-09-29 21:39:00","inspection_id":"85825311","insp_unit_id":"209200330","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"305437","insp_unit_license":"PLQ1584","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"JALE5W166G7900074","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-02T09:45:18.000000Z","updated_at":"2025-10-03T09:45:44.000000Z"}]},{"id":9714725,"change_date":"2025-09-18 21:42:00","inspection_id":"85810230","dot_number":"510829","report_state":"OH","report_number":"3282001067","insp_date":"2025-09-17 00:00:00","insp_start_time":"0810","insp_end_time":"0850","registration_date":null,"region":"ED","ci_status_code":"C","location":"10","location_desc":"WILMINGTON OH","county_code_state":"OH","county_code":"027","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"ADJ","shipping_paper_number":"2305949","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-09-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"74700","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2293501","transaction_code":"A","transaction_date":"2025-09-18 00:00:00","upload_date":"2025-09-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00510829","upload_search_indicator":null,"census_search_date":"2025-09-18 21:42:00","snet_input_date":"2025-09-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-18 21:42:00","insp_carrier_name":"SYSCO CINCINNATI LLC","insp_carrier_street":"10510 EVENDALE DRIVE","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45241","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-23T10:02:18.000000Z","updated_at":"2025-09-23T10:02:18.000000Z","inspection_violations":[{"id":15949210,"change_date":"2025-09-18 21:42:00","inspection_id":"85810230","insp_violation_id":"268774062","seq_no":"1","part_no":"393","part_no_section":"67C7V-F","insp_viol_unit":"1","insp_unit_id":"209016973","insp_violation_category_id":"18","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-22T10:17:36.000000Z","updated_at":"2025-09-22T10:17:36.000000Z","normalized_code":"39367C7VF"},{"id":15949211,"change_date":"2025-09-18 21:42:00","inspection_id":"85810230","insp_violation_id":"268774063","seq_no":"2","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"209016973","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-22T10:17:36.000000Z","updated_at":"2025-09-22T10:17:36.000000Z","normalized_code":"39395A4EEUS"}],"inspection_per_units":[{"id":16086265,"change_date":"2025-09-18 21:42:00","inspection_id":"85810230","insp_unit_id":"209016973","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"136456","insp_unit_license":"2488634","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUBGBDV4JLJK8661","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-21T09:45:53.000000Z","updated_at":"2025-09-22T09:45:50.000000Z"},{"id":16086266,"change_date":"2025-09-18 21:42:00","inspection_id":"85810230","insp_unit_id":"209016974","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"255320","insp_unit_license":"PF55338","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V281K6SJ402415","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-21T09:45:53.000000Z","updated_at":"2025-09-22T09:45:50.000000Z"}]},{"id":9576753,"change_date":"2025-09-03 21:39:00","inspection_id":"85665460","dot_number":"510829","report_state":"OH","report_number":"3237000788","insp_date":"2025-09-01 00:00:00","insp_start_time":"1158","insp_end_time":"1257","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"KIRKERSVILLE OH","county_code_state":"OH","county_code":"089","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SYSCO CINCINNATI LLC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-09-03 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"77700","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":"2212607","transaction_code":"A","transaction_date":"2025-09-02 00:00:00","upload_date":"2025-09-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00510829","upload_search_indicator":null,"census_search_date":"2025-09-03 21:39:00","snet_input_date":"2025-09-01 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-03 21:39:00","insp_carrier_name":"SYSCO CINCINNATI LLC","insp_carrier_street":"10510 EVENDALE DRIVE","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45241","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-06T10:43:17.000000Z","updated_at":"2025-09-10T10:44:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15808966,"change_date":"2025-09-03 21:39:00","inspection_id":"85665460","insp_unit_id":"208716182","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"149853","insp_unit_license":"3786534","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3AKBHTDV7SSWC8916","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:47:27.000000Z","updated_at":"2025-09-09T09:47:27.000000Z"},{"id":15808967,"change_date":"2025-09-03 21:39:00","inspection_id":"85665460","insp_unit_id":"208716183","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KIDRON","insp_unit_company":"245562","insp_unit_license":"PF74043","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"526162819H5000151","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:47:27.000000Z","updated_at":"2025-09-09T09:47:27.000000Z"}]},{"id":9245298,"change_date":"2025-07-25 21:39:00","inspection_id":"85316737","dot_number":"510829","report_state":"WV","report_number":"PSC1600198","insp_date":"2025-07-15 00:00:00","insp_start_time":"1347","insp_end_time":"1410","registration_date":null,"region":"ED","ci_status_code":"C","location":"I064WB","location_desc":"HURRICANE WV","county_code_state":"WV","county_code":"079","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SYSCO","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-07-25 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"64700","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":"2040950","transaction_code":"A","transaction_date":"2025-07-25 00:00:00","upload_date":"2025-07-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00510829","upload_search_indicator":null,"census_search_date":"2025-07-25 21:39:00","snet_input_date":"2025-07-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-25 21:39:00","insp_carrier_name":"SYSCO CINCINNATI LLC","insp_carrier_street":"10510 EVENDALE DRIVE","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45241","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-30T10:01:15.000000Z","updated_at":"2025-07-30T10:01:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15214448,"change_date":"2025-07-25 21:39:00","inspection_id":"85316737","insp_unit_id":"208074471","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"3711248","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN2AY7LM002041","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-28T09:46:31.000000Z","updated_at":"2025-07-29T09:45:27.000000Z"},{"id":15214449,"change_date":"2025-07-25 21:39:00","inspection_id":"85316737","insp_unit_id":"208074472","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"TTM1109","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1GRAA5614DB706760","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-28T09:46:31.000000Z","updated_at":"2025-07-29T09:45:27.000000Z"}]},{"id":8729155,"change_date":"2025-05-24 21:33:00","inspection_id":"84771649","dot_number":"510829","report_state":"OH","report_number":"3237000512","insp_date":"2025-05-22 00:00:00","insp_start_time":"0915","insp_end_time":"0952","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"HEBRON OH","county_code_state":"OH","county_code":"089","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CISCO CINCINNATI LLC","shipping_paper_number":"0669537","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-05-24 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"74700","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":"1774724","transaction_code":"A","transaction_date":"2025-05-24 00:00:00","upload_date":"2025-05-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00510829","upload_search_indicator":null,"census_search_date":"2025-05-24 21:33:00","snet_input_date":"2025-05-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-24 21:33:00","insp_carrier_name":"SYSCO CINCINNATI LLC","insp_carrier_street":"10510 EVENDALE DRIVE","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45241","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-27T10:03:00.000000Z","updated_at":"2025-05-28T10:00:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14270263,"change_date":"2025-05-24 21:33:00","inspection_id":"84771649","insp_unit_id":"207049896","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"256507","insp_unit_license":"PG65434","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V281K8SJ518201","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-27T09:49:25.000000Z","updated_at":"2025-05-28T09:45:10.000000Z"},{"id":14270262,"change_date":"2025-05-24 21:33:00","inspection_id":"84771649","insp_unit_id":"207049895","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"148922","insp_unit_license":"3711275","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKBHTDV7SSVV1582","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-27T09:49:25.000000Z","updated_at":"2025-05-28T09:45:10.000000Z"}]},{"id":7989831,"change_date":"2025-02-28 21:41:00","inspection_id":"83993055","dot_number":"510829","report_state":"WV","report_number":"PSC1480700","insp_date":"2025-02-27 00:00:00","insp_start_time":"1345","insp_end_time":"1403","registration_date":null,"region":"ES","ci_status_code":"C","location":"I064WB","location_desc":"HURRICANE WV","county_code_state":"WV","county_code":"079","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-02-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"72000","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":"1413585","transaction_code":"A","transaction_date":"2025-02-28 00:00:00","upload_date":"2025-02-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00510829","upload_search_indicator":null,"census_search_date":"2025-02-28 21:41:00","snet_input_date":"2025-02-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-28 21:41:00","insp_carrier_name":"SYSCO CINCINNATI LLC","insp_carrier_street":"10510 EVENDALE DRIVE","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45241","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:04:05.000000Z","updated_at":"2025-03-17T21:04:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12898791,"change_date":"2025-02-28 21:41:00","inspection_id":"83993055","insp_unit_id":"205556379","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"2987106","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHTDV5SSVT2363","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:28.000000Z","updated_at":"2025-03-17T23:57:28.000000Z"},{"id":12898792,"change_date":"2025-02-28 21:41:00","inspection_id":"83993055","insp_unit_id":"205556380","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"TPR7788","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1GRAA561XBB705447","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:28.000000Z","updated_at":"2025-03-17T23:57:28.000000Z"}]},{"id":7975770,"change_date":"2025-02-27 21:41:00","inspection_id":"83978289","dot_number":"510829","report_state":"OH","report_number":"3289000369","insp_date":"2025-02-24 00:00:00","insp_start_time":"1255","insp_end_time":"1318","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"ALBANY OH","county_code_state":"OH","county_code":"105","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER\/SAME","shipping_paper_number":"RTE 1010","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-02-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"74700","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":"1406439","transaction_code":"A","transaction_date":"2025-02-27 00:00:00","upload_date":"2025-02-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00510829","upload_search_indicator":null,"census_search_date":"2025-02-27 21:41:00","snet_input_date":"2025-02-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-27 21:41:00","insp_carrier_name":"SYSCO CINCINNATI LLC","insp_carrier_street":"10510 EVENDALE DRIVE","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45241","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:03:41.000000Z","updated_at":"2025-03-17T21:03:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12875783,"change_date":"2025-02-27 21:41:00","inspection_id":"83978289","insp_unit_id":"205528610","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"143516","insp_unit_license":"3431936","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN3AY2PM003979","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:14.000000Z","updated_at":"2025-03-17T23:57:14.000000Z"},{"id":12875784,"change_date":"2025-02-27 21:41:00","inspection_id":"83978289","insp_unit_id":"205528611","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"256507","insp_unit_license":"C480381","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"3H3V281K8SJ518201","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:14.000000Z","updated_at":"2025-03-17T23:57:14.000000Z"}]},{"id":7812857,"change_date":"2025-02-07 21:40:00","inspection_id":"83807446","dot_number":"510829","report_state":"IN","report_number":"8952005620","insp_date":"2025-02-07 00:00:00","insp_start_time":"0456","insp_end_time":"0527","registration_date":null,"region":"ES","ci_status_code":"C","location":"4274W","location_desc":"WEST HARRISON IN","county_code_state":"IN","county_code":"029","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SYSCO","shipping_paper_number":"5027","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-02-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":"1337650","transaction_code":"A","transaction_date":"2025-02-07 00:00:00","upload_date":"2025-02-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00510829","upload_search_indicator":null,"census_search_date":"2025-02-07 21:40:00","snet_input_date":"2025-02-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-07 21:40:00","insp_carrier_name":"SYSCO CINCINNATI LLC","insp_carrier_street":"10510 EVENDALE DRIVE","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45241","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:00:21.000000Z","updated_at":"2025-03-17T21:00:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12608743,"change_date":"2025-02-07 21:40:00","inspection_id":"83807446","insp_unit_id":"205210545","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"149854","insp_unit_license":"2987114","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHTDV3SSWC5507","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:16.000000Z","updated_at":"2025-03-17T23:54:16.000000Z"},{"id":12608744,"change_date":"2025-02-07 21:40:00","inspection_id":"83807446","insp_unit_id":"205210546","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"255319","insp_unit_license":"PF55337","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V281K4SJ402414","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:16.000000Z","updated_at":"2025-03-17T23:54:16.000000Z"}]},{"id":7744517,"change_date":"2025-01-30 21:40:00","inspection_id":"83735414","dot_number":"510829","report_state":"OH","report_number":"3289000311","insp_date":"2025-01-27 00:00:00","insp_start_time":"1209","insp_end_time":"1233","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"ALBANY OH","county_code_state":"OH","county_code":"009","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER\/SAME","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-01-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54700","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":"1302861","transaction_code":"A","transaction_date":"2025-01-30 00:00:00","upload_date":"2025-01-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00510829","upload_search_indicator":null,"census_search_date":"2025-01-30 21:40:00","snet_input_date":"2025-01-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-30 21:40:00","insp_carrier_name":"SYSCO CINCINNATI LLC","insp_carrier_street":"10510 EVENDALE DRIVE","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45241","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:59:07.000000Z","updated_at":"2025-03-17T20:59:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12497804,"change_date":"2025-01-30 21:40:00","inspection_id":"83735414","insp_unit_id":"205075529","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"137440","insp_unit_license":"2561272","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AW01Y1KM011107","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:55.000000Z","updated_at":"2025-03-17T23:52:55.000000Z"},{"id":12497805,"change_date":"2025-01-30 21:40:00","inspection_id":"83735414","insp_unit_id":"205075530","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"229632","insp_unit_license":"P812479","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA5618EB701756","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:55.000000Z","updated_at":"2025-03-17T23:52:55.000000Z"}]},{"id":7531963,"change_date":"2025-01-02 21:38:00","inspection_id":"83512286","dot_number":"510829","report_state":"OH","report_number":"3268000040","insp_date":"2024-12-30 00:00:00","insp_start_time":"1154","insp_end_time":"1221","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"JACKSON OH","county_code_state":"OH","county_code":"079","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER\/SAME","shipping_paper_number":"RTE 1017","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-01-02 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"73700","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":"1209826","transaction_code":"A","transaction_date":"2025-01-02 00:00:00","upload_date":"2025-01-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00510829","upload_search_indicator":null,"census_search_date":"2025-01-02 21:38:00","snet_input_date":"2024-12-30 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-02 21:38:00","insp_carrier_name":"SYSCO CINCINNATI LLC","insp_carrier_street":"10510 EVENDALE DRIVE","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45241","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:53:12.000000Z","updated_at":"2025-03-17T20:53:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12151405,"change_date":"2025-01-02 21:38:00","inspection_id":"83512286","insp_unit_id":"204617560","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"143516","insp_unit_license":"3431936","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN3AY2PM003979","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:10.000000Z","updated_at":"2025-03-17T23:49:10.000000Z"},{"id":12151406,"change_date":"2025-01-02 21:38:00","inspection_id":"83512286","insp_unit_id":"204617561","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"228864","insp_unit_license":"TPX2487","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1GRAA561XDB706763","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:10.000000Z","updated_at":"2025-03-17T23:49:10.000000Z"}]},{"id":7359747,"change_date":"2024-12-07 21:33:00","inspection_id":"83331443","dot_number":"510829","report_state":"OH","report_number":"3270000191","insp_date":"2024-12-04 00:00:00","insp_start_time":"1619","insp_end_time":"1644","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"PRINCETON OH","county_code_state":"OH","county_code":"017","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-12-07 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"49690","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":"1128152","transaction_code":"A","transaction_date":"2024-12-07 00:00:00","upload_date":"2024-12-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00510829","upload_search_indicator":null,"census_search_date":"2024-12-07 21:33:00","snet_input_date":"2024-12-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-12-07 21:33:00","insp_carrier_name":"SYSCO CINCINNATI LLC","insp_carrier_street":"10510 EVENDALE DRIVE","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45241","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:49:27.000000Z","updated_at":"2025-03-17T20:49:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11871978,"change_date":"2024-12-07 21:33:00","inspection_id":"83331443","insp_unit_id":"204246333","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"CIN135244","insp_unit_license":"2341930","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUBGBDV0GLHE4381","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:06.000000Z","updated_at":"2025-03-17T23:46:06.000000Z"},{"id":11871979,"change_date":"2024-12-07 21:33:00","inspection_id":"83331443","insp_unit_id":"204246334","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"208567","insp_unit_license":"TPR7788","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1GRAA561XBB705447","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:06.000000Z","updated_at":"2025-03-17T23:46:06.000000Z"}]},{"id":7209587,"change_date":"2024-11-16 21:33:00","inspection_id":"83172942","dot_number":"510829","report_state":"OH","report_number":"1367000062","insp_date":"2024-11-14 00:00:00","insp_start_time":"0815","insp_end_time":"0831","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"PATASKALA OH","county_code_state":"OH","county_code":"089","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SYSCO","shipping_paper_number":"0648788","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-11-16 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1059318","transaction_code":"A","transaction_date":"2024-11-16 00:00:00","upload_date":"2024-11-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00510829","upload_search_indicator":null,"census_search_date":"2024-11-16 21:33:00","snet_input_date":"2024-11-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-16 21:33:00","insp_carrier_name":"SYSCO CINCINNATI LLC","insp_carrier_street":"10510 EVENDALE DRIVE","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45241","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:46:27.000000Z","updated_at":"2025-03-17T20:46:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11628939,"change_date":"2024-11-16 21:33:00","inspection_id":"83172942","insp_unit_id":"203913333","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"143514","insp_unit_license":"3480935","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN3AY6PM003984","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:30.000000Z","updated_at":"2025-03-17T23:43:30.000000Z"},{"id":11628940,"change_date":"2024-11-16 21:33:00","inspection_id":"83172942","insp_unit_id":"203913334","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":"229646","insp_unit_license":"PB24839","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"526172814D5001036","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:30.000000Z","updated_at":"2025-03-17T23:43:30.000000Z"}]},{"id":6961370,"change_date":"2024-10-15 21:42:00","inspection_id":"82909733","dot_number":"510829","report_state":"KY","report_number":"CV44585293","insp_date":"2024-10-14 00:00:00","insp_start_time":"1235","insp_end_time":"1325","registration_date":null,"region":"ET","ci_status_code":"C","location":"9804","location_desc":"MOREHEAD","county_code_state":"KY","county_code":"205","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"SYSCO CINCINNATI LLC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-15 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2250154","transaction_code":"A","transaction_date":"2024-10-15 00:00:00","upload_date":"2024-10-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00510829","upload_search_indicator":"M","census_search_date":"2024-10-15 21:42:00","snet_input_date":"2024-10-15 00:00:00","source_office":"2KYS001","mcmis_add_date":"2024-10-15 21:42:00","insp_carrier_name":"SYSCO CINCINNATI LLC","insp_carrier_street":"10510 EVENDALE DRIVE","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45241","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:41:22.000000Z","updated_at":"2025-03-17T20:41:22.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11227608,"change_date":"2024-10-15 21:42:00","inspection_id":"82909733","insp_unit_id":"203414809","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"CIN 148925","insp_unit_license":"2987105","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHTDV3SSVT2362","insp_unit_decal":"Y","insp_unit_decal_number":"34672295","created_at":"2025-03-17T23:39:14.000000Z","updated_at":"2025-03-17T23:39:14.000000Z"},{"id":11227609,"change_date":"2024-10-15 21:42:00","inspection_id":"82909733","insp_unit_id":"203414810","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"254898","insp_unit_license":"C404028","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"3H3V382K3RJ265004","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:14.000000Z","updated_at":"2025-03-17T23:39:14.000000Z"}]},{"id":6797209,"change_date":"2024-09-23 21:41:00","inspection_id":"82735489","dot_number":"510829","report_state":"OH","report_number":"3270014823","insp_date":"2024-09-20 00:00:00","insp_start_time":"1713","insp_end_time":"1738","registration_date":null,"region":"ET","ci_status_code":"C","location":"61275","location_desc":"275 EAST","county_code_state":"OH","county_code":"061","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2024-09-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1758034","transaction_code":"A","transaction_date":"2024-09-20 00:00:00","upload_date":"2024-09-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00510829","upload_search_indicator":null,"census_search_date":"2024-09-23 21:41:00","snet_input_date":"2024-09-23 00:00:00","source_office":"3OHS001","mcmis_add_date":"2024-09-23 21:41:00","insp_carrier_name":"SYSCO CINCINNATI LLC","insp_carrier_street":"10510 EVENDALE DRIVE","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45241","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:37:47.000000Z","updated_at":"2025-03-17T20:37:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10961185,"change_date":"2024-09-23 21:41:00","inspection_id":"82735489","insp_unit_id":"203085080","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VANR","insp_unit_company":"255652","insp_unit_license":"PF74109","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"527SR4820SL044229","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:33.000000Z","updated_at":"2025-03-17T23:36:33.000000Z"},{"id":10961186,"change_date":"2024-09-23 21:41:00","inspection_id":"82735489","insp_unit_id":"203085081","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"CIN 143512","insp_unit_license":"3216181","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN3GY8PM033589","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:33.000000Z","updated_at":"2025-03-17T23:36:33.000000Z"}]},{"id":6311750,"change_date":"2024-07-25 21:44:00","inspection_id":"82217515","dot_number":"510829","report_state":"OH","report_number":"3247020564","insp_date":"2024-07-25 00:00:00","insp_start_time":"1110","insp_end_time":"1210","registration_date":null,"region":"ET","ci_status_code":"C","location":"153","location_desc":"ROADSIDE","county_code_state":"OH","county_code":"153","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"SYSCO","shipping_paper_number":"0636151","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2024-07-25 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"77700","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":"1742749","transaction_code":"A","transaction_date":"2024-07-25 00:00:00","upload_date":"2024-07-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00510829","upload_search_indicator":null,"census_search_date":"2024-07-25 21:44:00","snet_input_date":"2024-07-25 00:00:00","source_office":"3OHS001","mcmis_add_date":"2024-07-25 21:44:00","insp_carrier_name":"SYSCO CINCINNATI LLC","insp_carrier_street":"10510 EVENDALE DRIVE","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45241","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":9799712,"change_date":"2024-07-25 21:44:00","inspection_id":"82217515","insp_violation_id":"260844634","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202074706","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:22.000000Z","updated_at":"2025-03-17T21:53:22.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":10170081,"change_date":"2024-07-25 21:44:00","inspection_id":"82217515","insp_unit_id":"202074706","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"143514","insp_unit_license":"3480935","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN3AY6PM003984","insp_unit_decal":"Y","insp_unit_decal_number":"34260949","created_at":"2025-03-17T23:28:22.000000Z","updated_at":"2025-03-17T23:28:22.000000Z"},{"id":10170082,"change_date":"2024-07-25 21:44:00","inspection_id":"82217515","insp_unit_id":"202074707","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HACK","insp_unit_company":"254060","insp_unit_license":"PD71380","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"526162815P5000663","insp_unit_decal":"Y","insp_unit_decal_number":"34260950","created_at":"2025-03-17T23:28:22.000000Z","updated_at":"2025-03-17T23:28:22.000000Z"}]},{"id":6187360,"change_date":"2024-07-10 21:40:00","inspection_id":"82084098","dot_number":"510829","report_state":"OH","report_number":"3284019905","insp_date":"2024-07-08 00:00:00","insp_start_time":"1605","insp_end_time":"1625","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"OH","county_code":"145","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2024-07-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54700","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":"1738707","transaction_code":"A","transaction_date":"2024-07-08 00:00:00","upload_date":"2024-07-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00510829","upload_search_indicator":null,"census_search_date":"2024-07-10 21:40:00","snet_input_date":"2024-07-10 00:00:00","source_office":"3OHS001","mcmis_add_date":"2024-07-10 21:40:00","insp_carrier_name":"SYSCO CINCINNATI LLC","insp_carrier_street":"10510 EVENDALE DRIVE","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45241","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:25:22.000000Z","updated_at":"2025-03-17T20:25:22.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9967648,"change_date":"2024-07-10 21:40:00","inspection_id":"82084098","insp_unit_id":"201820354","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"CIN 148924","insp_unit_license":"3711246","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKBHTDV0SSVV1584","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:16.000000Z","updated_at":"2025-03-17T23:26:16.000000Z"},{"id":9967649,"change_date":"2024-07-10 21:40:00","inspection_id":"82084098","insp_unit_id":"201820355","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HACK","insp_unit_company":"254060","insp_unit_license":"PD71380","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"526162815P000663","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:16.000000Z","updated_at":"2025-03-17T23:26:16.000000Z"}]},{"id":5951757,"change_date":"2024-06-10 21:43:00","inspection_id":"81830073","dot_number":"510829","report_state":"OH","report_number":"3299015923","insp_date":"2024-06-10 00:00:00","insp_start_time":"0605","insp_end_time":"0645","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"OH","county_code":"145","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"SHIPPER","shipping_paper_number":"0631388","cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2024-06-10 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"99700","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":"1732435","transaction_code":"A","transaction_date":"2024-06-10 00:00:00","upload_date":"2024-06-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00510829","upload_search_indicator":null,"census_search_date":"2024-06-10 21:43:00","snet_input_date":"2024-06-10 00:00:00","source_office":"3OHS001","mcmis_add_date":"2024-06-10 21:43:00","insp_carrier_name":"SYSCO CINCINNATI LLC","insp_carrier_street":"10510 EVENDALE DRIVE","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45241","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:20:41.000000Z","updated_at":"2025-03-17T20:20:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9586741,"change_date":"2024-06-10 21:43:00","inspection_id":"81830073","insp_unit_id":"201314138","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"141133","insp_unit_license":"2802491","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN2AY6LM002029","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:24.000000Z","updated_at":"2025-03-17T23:22:24.000000Z"},{"id":9586742,"change_date":"2024-06-10 21:43:00","inspection_id":"81830073","insp_unit_id":"201314139","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HACK","insp_unit_company":"252011","insp_unit_license":"P962612","insp_unit_license_state":"ID","insp_unit_vehicle_id_number":"526163822L5000645","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:24.000000Z","updated_at":"2025-03-17T23:22:24.000000Z"}]},{"id":5930621,"change_date":"2024-06-06 21:41:00","inspection_id":"81807182","dot_number":"510829","report_state":"OH","report_number":"1317000806","insp_date":"2024-06-06 00:00:00","insp_start_time":"1121","insp_end_time":"1200","registration_date":null,"region":"ET","ci_status_code":"C","location":"13570","location_desc":"PREBLE SCALES","county_code_state":"OH","county_code":"135","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"SYSCO CINCINNATI","shipping_paper_number":"0631064","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2024-06-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"103000","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":"1731800","transaction_code":"A","transaction_date":"2024-06-06 00:00:00","upload_date":"2024-06-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00510829","upload_search_indicator":null,"census_search_date":"2024-06-06 21:41:00","snet_input_date":"2024-06-06 00:00:00","source_office":"3OHS001","mcmis_add_date":"2024-06-06 21:41:00","insp_carrier_name":"SYSCO CINCINNATI LLC","insp_carrier_street":"10510 EVENDALE DRIVE","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45241","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:20:16.000000Z","updated_at":"2025-03-17T20:20:16.000000Z","inspection_violations":[{"id":9196908,"change_date":"2024-06-06 21:41:00","inspection_id":"81807182","insp_violation_id":"259944969","seq_no":"1","part_no":"395","part_no_section":"22(h)(4)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:26.000000Z","updated_at":"2025-03-17T21:50:26.000000Z","normalized_code":"39522H4"}],"inspection_per_units":[{"id":9552406,"change_date":"2024-06-06 21:41:00","inspection_id":"81807182","insp_unit_id":"201270340","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"254898","insp_unit_license":"PF55335","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V382K3RJ265004","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:04.000000Z","updated_at":"2025-03-17T23:22:04.000000Z"},{"id":9552407,"change_date":"2024-06-06 21:41:00","inspection_id":"81807182","insp_unit_id":"201270341","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"132106","insp_unit_license":"2028290","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUBGBDV4ELFA8488","insp_unit_decal":"Y","insp_unit_decal_number":"33941619","created_at":"2025-03-17T23:22:04.000000Z","updated_at":"2025-03-17T23:22:04.000000Z"}]},{"id":5700578,"change_date":"2024-05-08 21:42:00","inspection_id":"81557548","dot_number":"510829","report_state":"OH","report_number":"3289012434","insp_date":"2024-05-08 00:00:00","insp_start_time":"1048","insp_end_time":"1112","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"OH","county_code":"079","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER\/SAME","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2024-05-08 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"77700","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":"1724899","transaction_code":"A","transaction_date":"2024-05-08 00:00:00","upload_date":"2024-05-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00510829","upload_search_indicator":null,"census_search_date":"2024-05-08 21:42:00","snet_input_date":"2024-05-08 00:00:00","source_office":"3OHS001","mcmis_add_date":"2024-05-08 21:42:00","insp_carrier_name":"SYSCO CINCINNATI LLC","insp_carrier_street":"10510 EVENDALE DRIVE","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45241","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:15:51.000000Z","updated_at":"2025-03-17T20:15:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9181695,"change_date":"2024-05-08 21:42:00","inspection_id":"81557548","insp_unit_id":"200792811","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"143516","insp_unit_license":"3431936","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN3AY2PM003979","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:27.000000Z","updated_at":"2025-03-17T23:18:27.000000Z"},{"id":9181696,"change_date":"2024-05-08 21:42:00","inspection_id":"81557548","insp_unit_id":"200792812","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNK","insp_unit_company":"254060","insp_unit_license":"PD71380","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"526162815P5000663","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:27.000000Z","updated_at":"2025-03-17T23:18:27.000000Z"}]},{"id":5456033,"change_date":"2024-04-08 21:43:00","inspection_id":"81290793","dot_number":"510829","report_state":"WV","report_number":"PSC1470147","insp_date":"2024-04-01 00:00:00","insp_start_time":"1125","insp_end_time":"1150","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"HURRICANE WV","county_code_state":"WV","county_code":"079","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SYSCO","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-04-08 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","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":"379407","transaction_code":"A","transaction_date":"2024-04-08 00:00:00","upload_date":"2024-04-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00510829","upload_search_indicator":null,"census_search_date":"2024-04-08 21:43:00","snet_input_date":"2024-04-01 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-04-08 21:43:00","insp_carrier_name":"SYSCO CINCINNATI LLC","insp_carrier_street":"10510 EVENDALE DRIVE","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45241","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:10:43.000000Z","updated_at":"2025-03-17T20:10:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8788650,"change_date":"2024-04-08 21:43:00","inspection_id":"81290793","insp_unit_id":"200279327","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"2802476","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN2AYXLM002034","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:44.000000Z","updated_at":"2025-03-17T23:14:44.000000Z"},{"id":8788651,"change_date":"2024-04-08 21:43:00","inspection_id":"81290793","insp_unit_id":"200279328","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"P945538","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA5615DB709716","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:44.000000Z","updated_at":"2025-03-17T23:14:44.000000Z"}]},{"id":5451720,"change_date":"2024-04-06 21:31:00","inspection_id":"81285995","dot_number":"510829","report_state":"IN","report_number":"7177002336","insp_date":"2024-03-29 00:00:00","insp_start_time":"1310","insp_end_time":"1346","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"JEFFERSONVILLE IN","county_code_state":"IN","county_code":"019","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SYSCO","shipping_paper_number":"623856","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-04-06 21:31: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":"374201","transaction_code":"A","transaction_date":"2024-04-05 00:00:00","upload_date":"2024-04-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00510829","upload_search_indicator":null,"census_search_date":"2024-04-06 21:31:00","snet_input_date":"2024-03-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-04-06 21:31:00","insp_carrier_name":"SYSCO CINCINNATI LLC","insp_carrier_street":"10510 EVENDALE DRIVE","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45241","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:10:42.000000Z","updated_at":"2025-03-17T20:10:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8781310,"change_date":"2024-04-06 21:31:00","inspection_id":"81285995","insp_unit_id":"200270725","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"132107","insp_unit_license":"2028291","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUBGBDV6ELFA8489","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:41.000000Z","updated_at":"2025-03-17T23:14:41.000000Z"},{"id":8781311,"change_date":"2024-04-06 21:31:00","inspection_id":"81285995","insp_unit_id":"200270726","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HACKNEY &","insp_unit_company":"246785","insp_unit_license":"P668526","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"526163827J5000590","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:41.000000Z","updated_at":"2025-03-17T23:14:41.000000Z"}]},{"id":5171910,"change_date":"2024-02-29 21:46:00","inspection_id":"80980606","dot_number":"510829","report_state":"WV","report_number":"PSC1460101","insp_date":"2024-02-27 00:00:00","insp_start_time":"0818","insp_end_time":"0838","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"HURRICANE WV","county_code_state":"WV","county_code":"079","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CARRRIER","shipping_paper_number":"60076957","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-02-29 21:46:00","post_acc_ind":"N","gross_comb_veh_wt":"77700","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":"280420","transaction_code":"A","transaction_date":"2024-02-28 00:00:00","upload_date":"2024-02-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00510829","upload_search_indicator":null,"census_search_date":"2024-02-29 21:46:00","snet_input_date":"2024-02-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-02-29 21:46:00","insp_carrier_name":"SYSCO CINCINNATI LLC","insp_carrier_street":"10510 EVENDALE DRIVE","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45241","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:04:59.000000Z","updated_at":"2025-03-17T20:04:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8327005,"change_date":"2024-02-29 21:46:00","inspection_id":"80980606","insp_unit_id":"199673615","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"137437","insp_unit_license":"2561270","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AW01Y6KM011104","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:27.000000Z","updated_at":"2025-03-17T23:10:27.000000Z"},{"id":8327006,"change_date":"2024-02-29 21:46:00","inspection_id":"80980606","insp_unit_id":"199673616","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HACKNEY &","insp_unit_company":null,"insp_unit_license":"PB24840","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"526162811J5000599","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:27.000000Z","updated_at":"2025-03-17T23:10:27.000000Z"}]},{"id":4921387,"change_date":"2024-01-29 21:39:00","inspection_id":"80707194","dot_number":"510829","report_state":"OH","report_number":"3284019377","insp_date":"2024-01-25 00:00:00","insp_start_time":"1520","insp_end_time":"1558","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"OH","county_code":"141","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2024-01-29 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"43100","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":"1701140","transaction_code":"A","transaction_date":"2024-01-25 00:00:00","upload_date":"2024-01-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00510829","upload_search_indicator":null,"census_search_date":"2024-01-29 21:39:00","snet_input_date":"2024-01-29 00:00:00","source_office":"3OHS001","mcmis_add_date":"2024-01-29 21:39:00","insp_carrier_name":"SYSCO CINCINNATI LLC","insp_carrier_street":"10510 EVENDALE DRIVE","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45241","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:00:25.000000Z","updated_at":"2025-03-17T20:00:25.000000Z","inspection_violations":[{"id":7580494,"change_date":"2024-01-29 21:39:00","inspection_id":"80707194","insp_violation_id":"257538872","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"199151052","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:37.000000Z","updated_at":"2025-03-17T21:42:37.000000Z","normalized_code":"39395A"},{"id":7580495,"change_date":"2024-01-29 21:39:00","inspection_id":"80707194","insp_violation_id":"257538873","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199151052","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:37.000000Z","updated_at":"2025-03-17T21:42:37.000000Z","normalized_code":"3939A"},{"id":7580496,"change_date":"2024-01-29 21:39:00","inspection_id":"80707194","insp_violation_id":"257538874","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199151052","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:37.000000Z","updated_at":"2025-03-17T21:42:37.000000Z","normalized_code":"3939A"},{"id":7580497,"change_date":"2024-01-29 21:39:00","inspection_id":"80707194","insp_violation_id":"257538875","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"199151053","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:37.000000Z","updated_at":"2025-03-17T21:42:37.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":7919732,"change_date":"2024-01-29 21:39:00","inspection_id":"80707194","insp_unit_id":"199151052","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"134347","insp_unit_license":"2779282","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUBGBDV8GLHA4078","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:47.000000Z","updated_at":"2025-03-17T23:06:47.000000Z"},{"id":7919733,"change_date":"2024-01-29 21:39:00","inspection_id":"80707194","insp_unit_id":"199151053","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"204927","insp_unit_license":"TTK2370","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1K913281374054486","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:47.000000Z","updated_at":"2025-03-17T23:06:47.000000Z"}]},{"id":4886018,"change_date":"2024-01-23 21:45:00","inspection_id":"80668509","dot_number":"510829","report_state":"OH","report_number":"3289012187","insp_date":"2024-01-23 00:00:00","insp_start_time":"0947","insp_end_time":"1031","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"REST AREA","county_code_state":"OH","county_code":"073","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER\/SAME","shipping_paper_number":"0616899","cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2024-01-23 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"73700","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":"1700076","transaction_code":"A","transaction_date":"2024-01-23 00:00:00","upload_date":"2024-01-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00510829","upload_search_indicator":null,"census_search_date":"2024-01-23 21:45:00","snet_input_date":"2024-01-23 00:00:00","source_office":"3OHS001","mcmis_add_date":"2024-01-23 21:45:00","insp_carrier_name":"SYSCO CINCINNATI LLC","insp_carrier_street":"10510 EVENDALE DRIVE","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45241","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:59:36.000000Z","updated_at":"2025-03-17T19:59:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7861656,"change_date":"2024-01-23 21:45:00","inspection_id":"80668509","insp_unit_id":"199074185","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"137439","insp_unit_license":"2561332","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AW01YXKM011106","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:16.000000Z","updated_at":"2025-03-17T23:06:16.000000Z"},{"id":7861657,"change_date":"2024-01-23 21:45:00","inspection_id":"80668509","insp_unit_id":"199074186","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"229632","insp_unit_license":"P812479","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA5618FB701756","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:16.000000Z","updated_at":"2025-03-17T23:06:16.000000Z"}]},{"id":4876572,"change_date":"2024-01-22 21:44:00","inspection_id":"80658288","dot_number":"510829","report_state":"OH","report_number":"3260000365","insp_date":"2024-01-17 00:00:00","insp_start_time":"1144","insp_end_time":"1202","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"REAST AREA","county_code_state":"OH","county_code":"105","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"616347","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2024-01-22 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"78700","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":"1699717","transaction_code":"A","transaction_date":"2024-01-18 00:00:00","upload_date":"2024-01-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00510829","upload_search_indicator":null,"census_search_date":"2024-01-22 21:44:00","snet_input_date":"2024-01-22 00:00:00","source_office":"3OHS001","mcmis_add_date":"2024-01-22 21:44:00","insp_carrier_name":"SYSCO CINCINNATI LLC","insp_carrier_street":"10510 EVENDALE DRIVE","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45241","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:59:16.000000Z","updated_at":"2025-03-17T19:59:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7846266,"change_date":"2024-01-22 21:44:00","inspection_id":"80658288","insp_unit_id":"199053279","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"141130","insp_unit_license":"2962596","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN2AY5LN002040","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:08.000000Z","updated_at":"2025-03-17T23:06:08.000000Z"},{"id":7846267,"change_date":"2024-01-22 21:44:00","inspection_id":"80658288","insp_unit_id":"199053280","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"229632","insp_unit_license":"P812479","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA5618EB701756","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:08.000000Z","updated_at":"2025-03-17T23:06:08.000000Z"}]},{"id":4570864,"change_date":"2023-12-06 21:42:00","inspection_id":"80323892","dot_number":"510829","report_state":"OH","report_number":"3282006529","insp_date":"2023-12-06 00:00:00","insp_start_time":"1210","insp_end_time":"1255","registration_date":null,"region":"ET","ci_status_code":"C","location":"06174","location_desc":"ROAD PATROL","county_code_state":"OH","county_code":"061","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-12-06 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"121000","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":"1692741","transaction_code":"A","transaction_date":"2023-12-06 00:00:00","upload_date":"2023-12-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00510829","upload_search_indicator":null,"census_search_date":"2023-12-06 21:42:00","snet_input_date":"2023-12-06 00:00:00","source_office":"3OHS001","mcmis_add_date":"2023-12-06 21:42:00","insp_carrier_name":"SYSCO CINCINNATI LLC","insp_carrier_street":"10510 EVENDALE DRIVE","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45241","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:53:24.000000Z","updated_at":"2025-03-17T19:53:24.000000Z","inspection_violations":[{"id":7070105,"change_date":"2023-12-06 21:42:00","inspection_id":"80323892","insp_violation_id":"256745664","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"198378139","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:09.000000Z","updated_at":"2025-03-17T21:40:09.000000Z","normalized_code":"39378"}],"inspection_per_units":[{"id":7351664,"change_date":"2023-12-06 21:42:00","inspection_id":"80323892","insp_unit_id":"198378139","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"141135","insp_unit_license":"2802492","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN2AY4LM002031","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:47.000000Z","updated_at":"2025-03-17T23:01:47.000000Z"},{"id":7351665,"change_date":"2023-12-06 21:42:00","inspection_id":"80323892","insp_unit_id":"198378140","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"253489","insp_unit_license":"PC93668","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V382K7PJ133022","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:47.000000Z","updated_at":"2025-03-17T23:01:47.000000Z"}]},{"id":4546153,"change_date":"2023-12-04 21:40:00","inspection_id":"80296695","dot_number":"510829","report_state":"WV","report_number":"0322000060","insp_date":"2023-12-04 00:00:00","insp_start_time":"1235","insp_end_time":"1257","registration_date":null,"region":"ET","ci_status_code":"C","location":"I64-WB","location_desc":"I-64 WEST BOUND WINFIELD WS","county_code_state":"WV","county_code":"079","insp_level_id":"2","service_center":"EA","census_source_id":"4","insp_facility":"F","shipper_name":"SYSCO","shipping_paper_number":"0612180","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-12-04 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"541492","transaction_code":"A","transaction_date":"2023-12-04 00:00:00","upload_date":"2023-12-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00510829","upload_search_indicator":null,"census_search_date":"2023-12-04 21:40:00","snet_input_date":"2023-12-04 00:00:00","source_office":"1WVS001","mcmis_add_date":"2023-12-04 21:40:00","insp_carrier_name":"SYSCO CINCINNATI LLC","insp_carrier_street":"10510 EVENDALE DRIVE","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45241","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:52:58.000000Z","updated_at":"2025-03-17T19:52:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7311410,"change_date":"2023-12-04 21:40:00","inspection_id":"80296695","insp_unit_id":"198323608","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"141137","insp_unit_license":"2802371","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN3GY4LM018727","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:26.000000Z","updated_at":"2025-03-17T23:01:26.000000Z"},{"id":7311411,"change_date":"2023-12-04 21:40:00","inspection_id":"80296695","insp_unit_id":"198323609","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"P590249","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA5612HB711719","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:26.000000Z","updated_at":"2025-03-17T23:01:26.000000Z"}]},{"id":4443830,"change_date":"2023-11-16 21:43:00","inspection_id":"80184208","dot_number":"510829","report_state":"OH","report_number":"3209303029","insp_date":"2023-11-16 00:00:00","insp_start_time":"0906","insp_end_time":"0924","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ROAD PATROL","county_code_state":"OH","county_code":"017","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-11-16 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"1689706","transaction_code":"A","transaction_date":"2023-11-16 00:00:00","upload_date":"2023-11-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00510829","upload_search_indicator":null,"census_search_date":"2023-11-16 21:43:00","snet_input_date":"2023-11-16 00:00:00","source_office":"3OHS001","mcmis_add_date":"2023-11-16 21:43:00","insp_carrier_name":"SYSCO CINCINNATI LLC","insp_carrier_street":"10510 EVENDALE DRIVE","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45241","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:51:02.000000Z","updated_at":"2025-03-17T19:51:02.000000Z","inspection_violations":[{"id":6878154,"change_date":"2023-11-16 21:43:00","inspection_id":"80184208","insp_violation_id":"256443630","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198104192","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:07.000000Z","updated_at":"2025-03-17T21:39:07.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7146524,"change_date":"2023-11-16 21:43:00","inspection_id":"80184208","insp_unit_id":"198104192","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"130892","insp_unit_license":"3216083","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUJGBDV0DLBT6436","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:01.000000Z","updated_at":"2025-03-17T23:00:01.000000Z"}]},{"id":3546778,"change_date":"2023-07-19 21:43:00","inspection_id":"79186590","dot_number":"510829","report_state":"OH","report_number":"0315002505","insp_date":"2023-07-18 00:00:00","insp_start_time":"1251","insp_end_time":"1319","registration_date":null,"region":"ET","ci_status_code":"C","location":"165075","location_desc":"IR 75 SB MP 31","county_code_state":"OH","county_code":"165","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"SYSCO","shipping_paper_number":"2071 L MIAMI","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-07-19 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"34000","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":"1668215","transaction_code":"A","transaction_date":"2023-07-18 00:00:00","upload_date":"2023-07-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00510829","upload_search_indicator":null,"census_search_date":"2023-07-19 21:43:00","snet_input_date":"2023-07-19 00:00:00","source_office":"3OHS001","mcmis_add_date":"2023-07-19 21:43:00","insp_carrier_name":"SYSCO CINCINNATI LLC","insp_carrier_street":"10510 EVENDALE DRIVE","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45241","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:33:08.000000Z","updated_at":"2025-03-17T19:33:08.000000Z","inspection_violations":[{"id":5467304,"change_date":"2023-07-19 21:43:00","inspection_id":"79186590","insp_violation_id":"254154872","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:23.000000Z","updated_at":"2025-03-17T21:32:23.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5702961,"change_date":"2023-07-19 21:43:00","inspection_id":"79186590","insp_unit_id":"196085593","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"132033","insp_unit_license":"2987199","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FVACXDT6EHFA8719","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:00.000000Z","updated_at":"2025-03-17T22:48:00.000000Z"}]},{"id":3535649,"change_date":"2023-07-18 21:42:00","inspection_id":"79174032","dot_number":"510829","report_state":"OH","report_number":"3237015509","insp_date":"2023-07-14 00:00:00","insp_start_time":"0650","insp_end_time":"0745","registration_date":null,"region":"ET","ci_status_code":"C","location":"089","location_desc":"ROADSIDE","county_code_state":"OH","county_code":"089","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"SYSCO LLC","shipping_paper_number":"0597922","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-07-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"73700","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":"1667744","transaction_code":"A","transaction_date":"2023-07-14 00:00:00","upload_date":"2023-07-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00510829","upload_search_indicator":null,"census_search_date":"2023-07-18 21:42:00","snet_input_date":"2023-07-17 00:00:00","source_office":"3OHS001","mcmis_add_date":"2023-07-18 21:42:00","insp_carrier_name":"SYSCO CINCINNATI LLC","insp_carrier_street":"10510 EVENDALE DRIVE","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45241","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:32:50.000000Z","updated_at":"2025-03-17T19:32:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5684990,"change_date":"2023-07-18 21:42:00","inspection_id":"79174032","insp_unit_id":"196060344","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"143514","insp_unit_license":"3480935","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN3AY6PM003984","insp_unit_decal":"Y","insp_unit_decal_number":"32992817","created_at":"2025-03-17T22:47:50.000000Z","updated_at":"2025-03-17T22:47:50.000000Z"},{"id":5684991,"change_date":"2023-07-18 21:42:00","inspection_id":"79174032","insp_unit_id":"196060345","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"229633","insp_unit_license":"P668394","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA561XEB701757","insp_unit_decal":"Y","insp_unit_decal_number":"32992818","created_at":"2025-03-17T22:47:50.000000Z","updated_at":"2025-03-17T22:47:50.000000Z"}]},{"id":3340983,"change_date":"2023-06-22 21:41:00","inspection_id":"78955383","dot_number":"510829","report_state":"KY","report_number":"CV44034804","insp_date":"2023-06-22 00:00:00","insp_start_time":"0608","insp_end_time":"0653","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ASHLAND","county_code_state":"KY","county_code":"019","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"BACKYARD PIZZA","shipping_paper_number":"1365975","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-06-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2171201","transaction_code":"A","transaction_date":"2023-06-22 00:00:00","upload_date":"2023-06-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00510829","upload_search_indicator":"M","census_search_date":"2023-06-22 21:41:00","snet_input_date":"2023-06-22 00:00:00","source_office":"2KYS001","mcmis_add_date":"2023-06-22 21:41:00","insp_carrier_name":"SYSCO CINCINNATI LLC","insp_carrier_street":"10510 EVENDALE DRIVE","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45241","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:29:18.000000Z","updated_at":"2025-03-17T19:29:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5371041,"change_date":"2023-06-22 21:41:00","inspection_id":"78955383","insp_unit_id":"195620166","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"141137","insp_unit_license":"2802371","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN3GY4LM018727","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:22.000000Z","updated_at":"2025-03-17T22:45:22.000000Z"},{"id":5371042,"change_date":"2023-06-22 21:41:00","inspection_id":"78955383","insp_unit_id":"195620167","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"208564","insp_unit_license":"TPR7785","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1GRAA5614BB705444","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:22.000000Z","updated_at":"2025-03-17T22:45:22.000000Z"}]},{"id":3269445,"change_date":"2023-06-13 21:41:00","inspection_id":"78874491","dot_number":"510829","report_state":"WV","report_number":"4730000982","insp_date":"2023-06-12 00:00:00","insp_start_time":"1136","insp_end_time":"1155","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"SOUTH BOUND WEIGH STATION","county_code_state":"WV","county_code":"107","insp_level_id":"2","service_center":"EA","census_source_id":"4","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"NOT NUMBERED","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-06-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"77700","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":"530468","transaction_code":"A","transaction_date":"2023-06-12 00:00:00","upload_date":"2023-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00510829","upload_search_indicator":null,"census_search_date":"2023-06-13 21:41:00","snet_input_date":"2023-06-13 00:00:00","source_office":"1WVS001","mcmis_add_date":"2023-06-13 21:41:00","insp_carrier_name":"SYSCO CINCINNATI LLC","insp_carrier_street":"10510 EVENDALE DRIVE","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45241","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:27:43.000000Z","updated_at":"2025-03-17T19:27:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5257184,"change_date":"2023-06-13 21:41:00","inspection_id":"78874491","insp_unit_id":"195462681","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"3481036","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKBHTDV7PDUP1887","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:27.000000Z","updated_at":"2025-03-17T22:44:27.000000Z"},{"id":5257185,"change_date":"2023-06-13 21:41:00","inspection_id":"78874491","insp_unit_id":"195462682","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KIEF","insp_unit_company":null,"insp_unit_license":"PB24956","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"526162818J5001152","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:27.000000Z","updated_at":"2025-03-17T22:44:27.000000Z"}]},{"id":2763160,"change_date":"2023-04-12 21:40:00","inspection_id":"78302599","dot_number":"510829","report_state":"WV","report_number":"4737001076","insp_date":"2023-04-10 00:00:00","insp_start_time":"1030","insp_end_time":"1105","registration_date":"2023-04-12 00:00:00","region":"ET","ci_status_code":"C","location":"I64EBW","location_desc":"I-64 EB WEIGH STATION WINFIELD","county_code_state":"WV","county_code":"079","insp_level_id":"1","service_center":"EA","census_source_id":"4","insp_facility":"F","shipper_name":"SYSCO","shipping_paper_number":"10039849","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-04-11 12:03:00","post_acc_ind":"N","gross_comb_veh_wt":"96000","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":"526203","transaction_code":"C","transaction_date":"2023-04-10 00:00:00","upload_date":"2023-04-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00510829","upload_search_indicator":null,"census_search_date":"2023-04-11 12:03:00","snet_input_date":"2023-04-10 00:00:00","source_office":"1WVS001","mcmis_add_date":"2023-04-11 12:03:00","insp_carrier_name":"SYSCO CINCINNATI LLC","insp_carrier_street":"10510 EVENDALE DRIVE","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45241","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:17:39.000000Z","updated_at":"2025-03-17T19:17:39.000000Z","inspection_violations":[{"id":4240264,"change_date":"2023-04-12 21:40:00","inspection_id":"78302599","insp_violation_id":"252170709","seq_no":"2","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"194341276","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:52.000000Z","updated_at":"2025-03-17T21:26:52.000000Z","normalized_code":"39355E"}],"inspection_per_units":[{"id":4446913,"change_date":"2023-04-12 21:40:00","inspection_id":"78302599","insp_unit_id":"194341275","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"143515","insp_unit_license":"3431995","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN3AY0PM003978","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:01.000000Z","updated_at":"2025-03-17T22:38:01.000000Z"},{"id":4446914,"change_date":"2023-04-12 21:40:00","inspection_id":"78302599","insp_unit_id":"194341276","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KIEF","insp_unit_company":"202082","insp_unit_license":"TQN4541","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1K913281274054771","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:01.000000Z","updated_at":"2025-03-17T22:38:01.000000Z"}]},{"id":2225508,"change_date":"2023-02-04 21:31:00","inspection_id":"77690168","dot_number":"510829","report_state":"IN","report_number":"5982004661","insp_date":"2023-01-24 00:00:00","insp_start_time":"1020","insp_end_time":"1047","registration_date":"2023-02-02 00:00:00","region":"ET","ci_status_code":"C","location":null,"location_desc":"SR44 @ TREAT LINE RD","county_code_state":"IN","county_code":"161","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"SYSCO","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-01-25 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"96000","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":"2172582","transaction_code":"C","transaction_date":"2023-01-25 00:00:00","upload_date":"2023-02-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00510829","upload_search_indicator":"M","census_search_date":"2023-01-25 21:42:00","snet_input_date":"2023-01-25 00:00:00","source_office":"3INS001","mcmis_add_date":"2023-01-25 21:42:00","insp_carrier_name":"SYSCO CINCINNATI LLC","insp_carrier_street":"10510 EVENDALE DRIVE","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45241","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:07:43.000000Z","updated_at":"2025-03-17T19:07:43.000000Z","inspection_violations":[{"id":3436851,"change_date":"2023-02-04 21:31:00","inspection_id":"77690168","insp_violation_id":"250954978","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:14.000000Z","updated_at":"2025-03-17T21:23:14.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3581844,"change_date":"2023-02-04 21:31:00","inspection_id":"77690168","insp_unit_id":"193232132","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"143515","insp_unit_license":"3431995","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN3AY0PM003978","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:41.000000Z","updated_at":"2025-03-17T22:31:41.000000Z"},{"id":3581845,"change_date":"2023-02-04 21:31:00","inspection_id":"77690168","insp_unit_id":"193232133","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HACK","insp_unit_company":"247489","insp_unit_license":"PB84435","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"526162816J5001151","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:41.000000Z","updated_at":"2025-03-17T22:31:41.000000Z"}]},{"id":2211106,"change_date":"2023-01-26 21:41:00","inspection_id":"77673510","dot_number":"510829","report_state":"WV","report_number":"4737000875","insp_date":"2023-01-13 00:00:00","insp_start_time":"0736","insp_end_time":"0758","registration_date":"2023-01-25 00:00:00","region":"ET","ci_status_code":"C","location":"I64EBW","location_desc":"I-64 EB WEIGH STATION WINFIELD","county_code_state":"WV","county_code":"079","insp_level_id":"2","service_center":"EA","census_source_id":"4","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"580355","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-01-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"34700","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"521637","transaction_code":"C","transaction_date":"2023-01-13 00:00:00","upload_date":"2023-01-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00510829","upload_search_indicator":null,"census_search_date":"2023-01-24 21:42:00","snet_input_date":"2023-01-24 00:00:00","source_office":"1WVS001","mcmis_add_date":"2023-01-24 21:42:00","insp_carrier_name":"SYSCO CINCINNATI LLC","insp_carrier_street":"10510 EVENDALE DRIVE","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45241","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:07:22.000000Z","updated_at":"2025-03-17T19:07:22.000000Z","inspection_violations":[{"id":3414818,"change_date":"2023-01-26 21:41:00","inspection_id":"77673510","insp_violation_id":"250793012","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"193078126","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:23:07.000000Z","updated_at":"2025-03-17T21:23:07.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":3558499,"change_date":"2023-01-26 21:41:00","inspection_id":"77673510","insp_unit_id":"193078126","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"141131","insp_unit_license":"2962597","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN2AY7LM002041","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:31.000000Z","updated_at":"2025-03-17T22:31:31.000000Z"},{"id":3558500,"change_date":"2023-01-26 21:41:00","inspection_id":"77673510","insp_unit_id":"193078127","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"229633","insp_unit_license":"P668394","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA561XEB701757","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:31.000000Z","updated_at":"2025-03-17T22:31:31.000000Z"}]},{"id":1916454,"change_date":"2023-03-01 21:42:00","inspection_id":"77336598","dot_number":"510829","report_state":"OH","report_number":"3205401868","insp_date":"2022-12-09 00:00:00","insp_start_time":"0850","insp_end_time":"0925","registration_date":"2023-03-01 00:00:00","region":"ET","ci_status_code":"C","location":"06","location_desc":"ROADSIDE","county_code_state":"OH","county_code":"011","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"SYSCO CINCINNATI LLC","shipping_paper_number":"319547163","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-12-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"99700","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":"1629955","transaction_code":"C","transaction_date":"2022-12-09 00:00:00","upload_date":"2023-03-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00510829","upload_search_indicator":null,"census_search_date":"2022-12-09 21:40:00","snet_input_date":"2022-12-09 00:00:00","source_office":"3OHS001","mcmis_add_date":"2022-12-09 21:40:00","insp_carrier_name":"SYSCO CINCINNATI LLC","insp_carrier_street":"10510 EVENDALE DRIVE","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45241","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:01:54.000000Z","updated_at":"2025-03-17T19:01:54.000000Z","inspection_violations":[{"id":2979889,"change_date":"2023-03-01 21:42:00","inspection_id":"77336598","insp_violation_id":"251419962","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"193653525","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:08.000000Z","updated_at":"2025-03-17T21:21:08.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":3083678,"change_date":"2023-03-01 21:42:00","inspection_id":"77336598","insp_unit_id":"193653524","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"138039","insp_unit_license":"2779102","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN2AY8KM001298","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:06.000000Z","updated_at":"2025-03-17T22:28:06.000000Z"},{"id":3083679,"change_date":"2023-03-01 21:42:00","inspection_id":"77336598","insp_unit_id":"193653525","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"202082","insp_unit_license":"TQN4541","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1K913281274054771","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:06.000000Z","updated_at":"2025-03-17T22:28:06.000000Z"}]},{"id":1762175,"change_date":"2022-11-17 21:40:00","inspection_id":"77159704","dot_number":"510829","report_state":"KY","report_number":"CV44602116","insp_date":"2022-11-16 00:00:00","insp_start_time":"0630","insp_end_time":"0715","registration_date":null,"region":"ET","ci_status_code":"C","location":"9810","location_desc":"PINER","county_code_state":"KY","county_code":"117","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"SYSCO","shipping_paper_number":"691216","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-17 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":"2133962","transaction_code":"A","transaction_date":"2022-11-17 00:00:00","upload_date":"2022-11-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00510829","upload_search_indicator":"M","census_search_date":"2022-11-17 21:40:00","snet_input_date":"2022-11-17 00:00:00","source_office":"2KYS001","mcmis_add_date":"2022-11-17 21:40:00","insp_carrier_name":"SYSCO CINCINNATI LLC","insp_carrier_street":"10510 EVENDALE DRIVE","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45241","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:59:16.000000Z","updated_at":"2025-03-17T18:59:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2834742,"change_date":"2022-11-17 21:40:00","inspection_id":"77159704","insp_unit_id":"192006708","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"19_143513","insp_unit_license":"3283402","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN3GY4PM033590","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:23.000000Z","updated_at":"2025-03-17T22:26:23.000000Z"},{"id":2834743,"change_date":"2022-11-17 21:40:00","inspection_id":"77159704","insp_unit_id":"192006709","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"250484","insp_unit_license":"P839376","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"526163824L5000016","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:23.000000Z","updated_at":"2025-03-17T22:26:23.000000Z"}]},{"id":1741253,"change_date":"2022-11-18 21:39:00","inspection_id":"77135770","dot_number":"510829","report_state":"IN","report_number":"5982004592","insp_date":"2022-11-09 00:00:00","insp_start_time":"0944","insp_end_time":"1011","registration_date":"2022-11-16 00:00:00","region":"ET","ci_status_code":"C","location":null,"location_desc":"SR44 @ TREATY LINE RD","county_code_state":"IN","county_code":"161","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"SYSCO","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-11-15 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2159053","transaction_code":"C","transaction_date":"2022-11-10 00:00:00","upload_date":"2022-11-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00510829","upload_search_indicator":"M","census_search_date":"2022-11-15 21:40:00","snet_input_date":"2022-11-10 00:00:00","source_office":"3INS001","mcmis_add_date":"2022-11-15 21:40:00","insp_carrier_name":"SYSCO CINCINNATI LLC","insp_carrier_street":"10510 EVENDALE DRIVE","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45241","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:58:53.000000Z","updated_at":"2025-03-17T18:58:53.000000Z","inspection_violations":[{"id":2726102,"change_date":"2022-11-18 21:39:00","inspection_id":"77135770","insp_violation_id":"249680426","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:51.000000Z","updated_at":"2025-03-17T21:19:51.000000Z","normalized_code":"3922"},{"id":2726103,"change_date":"2022-11-18 21:39:00","inspection_id":"77135770","insp_violation_id":"249680427","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"192029241","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:51.000000Z","updated_at":"2025-03-17T21:19:51.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2801526,"change_date":"2022-11-18 21:39:00","inspection_id":"77135770","insp_unit_id":"192029240","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"141135","insp_unit_license":"2802492","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN2AY4LM002031","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:10.000000Z","updated_at":"2025-03-17T22:26:10.000000Z"},{"id":2801527,"change_date":"2022-11-18 21:39:00","inspection_id":"77135770","insp_unit_id":"192029241","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"204691","insp_unit_license":"4JS3940","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1K913281394054460","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:10.000000Z","updated_at":"2025-03-17T22:26:10.000000Z"}]},{"id":1456347,"change_date":"2022-10-06 21:39:00","inspection_id":"76808026","dot_number":"510829","report_state":"KY","report_number":"CV44601958","insp_date":"2022-10-05 00:00:00","insp_start_time":"0630","insp_end_time":"0715","registration_date":null,"region":"ET","ci_status_code":"C","location":"9808","location_desc":"WALTON","county_code_state":"KY","county_code":"015","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"SYSCO","shipping_paper_number":"3026 \/ 0570731","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-10-06 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2126146","transaction_code":"A","transaction_date":"2022-10-06 00:00:00","upload_date":"2022-10-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00510829","upload_search_indicator":"M","census_search_date":"2022-10-06 21:39:00","snet_input_date":"2022-10-06 00:00:00","source_office":"2KYS001","mcmis_add_date":"2022-10-06 21:39:00","insp_carrier_name":"SYSCO CINCINNATI LLC","insp_carrier_street":"10510 EVENDALE DRIVE","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45241","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:53:27.000000Z","updated_at":"2025-03-17T18:53:27.000000Z","inspection_violations":[{"id":2294032,"change_date":"2022-10-06 21:39:00","inspection_id":"76808026","insp_violation_id":"248873903","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:17:29.000000Z","updated_at":"2025-03-17T21:17:29.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2344313,"change_date":"2022-10-06 21:39:00","inspection_id":"76808026","insp_unit_id":"191305146","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"130897","insp_unit_license":"2987112","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUJGBDV4DLBT6441","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:03.000000Z","updated_at":"2025-03-17T22:23:03.000000Z"},{"id":2344314,"change_date":"2022-10-06 21:39:00","inspection_id":"76808026","insp_unit_id":"191305147","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"244365","insp_unit_license":"P962587","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA9623HB703404","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:03.000000Z","updated_at":"2025-03-17T22:23:03.000000Z"}]},{"id":737629,"change_date":"2022-07-01 21:38:00","inspection_id":"75970734","dot_number":"510829","report_state":"WV","report_number":"4719001188","insp_date":"2022-07-01 00:00:00","insp_start_time":"0920","insp_end_time":"0944","registration_date":null,"region":"ET","ci_status_code":"C","location":"TEAYS","location_desc":"TEAYS VALLEY","county_code_state":"WV","county_code":"079","insp_level_id":"3","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-07-01 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"91000","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":"510754","transaction_code":"A","transaction_date":"2022-07-01 00:00:00","upload_date":"2022-07-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00510829","upload_search_indicator":null,"census_search_date":"2022-07-01 21:38:00","snet_input_date":"2022-07-01 00:00:00","source_office":"1WVS001","mcmis_add_date":"2022-07-01 21:38:00","insp_carrier_name":"SYSCO CINCINNATI LLC","insp_carrier_street":"10510 EVENDALE DRIVE","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45241","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:40:34.000000Z","updated_at":"2025-03-17T18:40:34.000000Z","inspection_violations":[{"id":1162112,"change_date":"2022-07-01 21:38:00","inspection_id":"75970734","insp_violation_id":"246853774","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":"202802022002061","created_at":"2025-03-17T21:12:27.000000Z","updated_at":"2025-03-17T21:12:27.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":1185164,"change_date":"2022-07-01 21:38:00","inspection_id":"75970734","insp_unit_id":"189571234","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"135258","insp_unit_license":"3216274","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUJGBDV8GLHE4379","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:28.000000Z","updated_at":"2025-03-17T22:15:28.000000Z"},{"id":1185165,"change_date":"2022-07-01 21:38:00","inspection_id":"75970734","insp_unit_id":"189571235","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"229632","insp_unit_license":"P812479","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA5618EB701756","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:28.000000Z","updated_at":"2025-03-17T22:15:28.000000Z"}]},{"id":408200,"change_date":"2022-05-17 21:43:00","inspection_id":"75580030","dot_number":"510829","report_state":"OH","report_number":"3237014654","insp_date":"2022-05-17 00:00:00","insp_start_time":"1127","insp_end_time":"1235","registration_date":null,"region":"ET","ci_status_code":"C","location":"089","location_desc":"ROADSIDE","county_code_state":"OH","county_code":"089","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"SYSCO CINCINNATI LLC","shipping_paper_number":"60122564","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-05-17 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"74700","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":"1597091","transaction_code":"A","transaction_date":"2022-05-17 00:00:00","upload_date":"2022-05-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00510829","upload_search_indicator":null,"census_search_date":"2022-05-17 21:43:00","snet_input_date":"2022-05-17 00:00:00","source_office":"3OHS001","mcmis_add_date":"2022-05-17 21:43:00","insp_carrier_name":"SYSCO CINCINNATI LLC","insp_carrier_street":"10510 EVENDALE DRIVE","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45241","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:34:47.000000Z","updated_at":"2025-03-17T18:34:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":659059,"change_date":"2022-05-17 21:43:00","inspection_id":"75580030","insp_unit_id":"188727585","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"133994","insp_unit_license":"2240816","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKBGBDV5FSGN6840","insp_unit_decal":"Y","insp_unit_decal_number":"31261513","created_at":"2025-03-17T22:12:14.000000Z","updated_at":"2025-03-17T22:12:14.000000Z"},{"id":659060,"change_date":"2022-05-17 21:43:00","inspection_id":"75580030","insp_unit_id":"188727586","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"202828","insp_unit_license":"TRK2469","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1GRAA561X9B700582","insp_unit_decal":"Y","insp_unit_decal_number":"31261514","created_at":"2025-03-17T22:12:14.000000Z","updated_at":"2025-03-17T22:12:14.000000Z"}]},{"id":112283,"change_date":"2022-04-05 21:40:00","inspection_id":"75225128","dot_number":"510829","report_state":"OH","report_number":"0370000433","insp_date":"2022-04-04 00:00:00","insp_start_time":"0847","insp_end_time":"0915","registration_date":null,"region":"ET","ci_status_code":"C","location":"16760","location_desc":"ROADSIDE","county_code_state":"OH","county_code":"167","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"SYSCO","shipping_paper_number":"319195883","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-04-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"77700","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":"1589453","transaction_code":"A","transaction_date":"2022-04-04 00:00:00","upload_date":"2022-04-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00510829","upload_search_indicator":null,"census_search_date":"2022-04-05 21:40:00","snet_input_date":"2022-04-05 00:00:00","source_office":"3OHS001","mcmis_add_date":"2022-04-05 21:40:00","insp_carrier_name":"SYSCO CINCINNATI LLC","insp_carrier_street":"10510 EVENDALE DRIVE","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45241","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:29:29.000000Z","updated_at":"2025-03-17T18:29:29.000000Z","inspection_violations":[{"id":164531,"change_date":"2022-04-05 21:40:00","inspection_id":"75225128","insp_violation_id":"244971994","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:51.000000Z","updated_at":"2025-03-17T21:07:51.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":181888,"change_date":"2022-04-05 21:40:00","inspection_id":"75225128","insp_unit_id":"187996034","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"141136","insp_unit_license":"2802476","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN2AYXLM002034","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:19.000000Z","updated_at":"2025-03-17T22:09:19.000000Z"},{"id":181889,"change_date":"2022-04-05 21:40:00","inspection_id":"75225128","insp_unit_id":"187996035","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"229678","insp_unit_license":"P962231","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"526172816D5001037","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:19.000000Z","updated_at":"2025-03-17T22:09:19.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/510829\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/510829\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/510829\/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\/510829\/inspections","per_page":100,"prev_page_url":null,"to":51,"total":51}