{"current_page":1,"data":[{"id":12549558,"change_date":"2026-07-25 21:35:00","inspection_id":"88516456","dot_number":"792056","report_state":"GA","report_number":"1414001184","insp_date":"2026-07-22 00:00:00","insp_start_time":"1040","insp_end_time":"1057","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"BREMEN GA","county_code_state":"GA","county_code":"045","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"EMPTY","shipping_paper_number":"EMPTY","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-25 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"116000","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":"3833969","transaction_code":"A","transaction_date":"2026-07-24 00:00:00","upload_date":"2026-07-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2026-07-25 21:35:00","snet_input_date":"2026-07-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-25 21:35:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-28T09:41:40.000000Z","updated_at":"2026-08-05T09:31:01.000000Z","inspection_violations":[{"id":21848938,"change_date":"2026-07-25 21:35:00","inspection_id":"88516456","insp_violation_id":"275733608","seq_no":"1","part_no":"392","part_no_section":"2-SLLML","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-28T10:02:30.000000Z","updated_at":"2026-08-05T09:42:09.000000Z","normalized_code":"3922SLLML"}],"inspection_per_units":[{"id":21791641,"change_date":"2026-07-25 21:35:00","inspection_id":"88516456","insp_unit_id":"214818371","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"VIN8084","insp_unit_license":"PG74072","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GR1A7622LE218084","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-28T09:19:06.000000Z","updated_at":"2026-08-05T09:01:47.000000Z"},{"id":21791640,"change_date":"2026-07-25 21:35:00","inspection_id":"88516456","insp_unit_id":"214818370","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"VIN1881","insp_unit_license":"3626762","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHTDV8RSVC1881","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-28T09:19:06.000000Z","updated_at":"2026-08-05T09:01:47.000000Z"}]},{"id":11663075,"change_date":"2026-04-23 21:39:00","inspection_id":"87593270","dot_number":"792056","report_state":"AL","report_number":"1118007952","insp_date":"2026-04-16 00:00:00","insp_start_time":"0455","insp_end_time":"0522","registration_date":"2026-04-17 00:00:00","region":"CD","ci_status_code":"C","location":null,"location_desc":"CALERA AL","county_code_state":"AL","county_code":"117","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SYSCO","shipping_paper_number":"0608986","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-04-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"74700","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":"3168338","transaction_code":"C","transaction_date":"2026-04-16 00:00:00","upload_date":"2026-04-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2026-04-16 21:40:00","snet_input_date":"2026-04-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-16 21:40:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-27T09:40:22.000000Z","updated_at":"2026-05-04T09:30:13.000000Z","inspection_violations":[{"id":20257173,"change_date":"2026-04-23 21:39:00","inspection_id":"87593270","insp_violation_id":"273803463","seq_no":"1","part_no":"392","part_no_section":"2-SLLSWZ","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"U7697320","created_at":"2026-04-27T10:02:27.000000Z","updated_at":"2026-05-04T09:43:13.000000Z","normalized_code":"3922SLLSWZ"}],"inspection_per_units":[{"id":20287691,"change_date":"2026-04-23 21:39:00","inspection_id":"87593270","insp_unit_id":"213179756","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"138326","insp_unit_license":"3626892","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4W39EG4KN206444","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:18:15.000000Z","updated_at":"2026-05-04T09:02:22.000000Z"},{"id":20287692,"change_date":"2026-04-23 21:39:00","inspection_id":"87593270","insp_unit_id":"213179757","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"256954","insp_unit_license":"PG65445","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V281K5SJ518026","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:18:15.000000Z","updated_at":"2026-05-04T09:02:22.000000Z"}]},{"id":11574828,"change_date":"2026-04-06 21:37:00","inspection_id":"87498943","dot_number":"792056","report_state":"AL","report_number":"1299004243","insp_date":"2026-04-06 00:00:00","insp_start_time":"0435","insp_end_time":"0455","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"ALABASTER AL","county_code_state":"AL","county_code":"117","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SYSCO","shipping_paper_number":"0608013","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-04-06 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"102700","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":"3119718","transaction_code":"A","transaction_date":"2026-04-06 00:00:00","upload_date":"2026-04-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2026-04-06 21:37:00","snet_input_date":"2026-04-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-06 21:37:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-09T09:49:08.000000Z","updated_at":"2026-04-17T09:36:13.000000Z","inspection_violations":[{"id":19568813,"change_date":"2026-04-06 21:37:00","inspection_id":"87498943","insp_violation_id":"272889433","seq_no":"1","part_no":"392","part_no_section":"2-SLLSWZ","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2026-04-08T10:13:23.000000Z","updated_at":"2026-04-18T10:37:51.000000Z","normalized_code":"3922SLLSWZ"}],"inspection_per_units":[{"id":19838150,"change_date":"2026-04-06 21:37:00","inspection_id":"87498943","insp_unit_id":"212560811","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"PG74348","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA8429JE701819","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-09T09:42:59.000000Z","updated_at":"2026-04-18T09:20:11.000000Z"},{"id":19838149,"change_date":"2026-04-06 21:37:00","inspection_id":"87498943","insp_unit_id":"212560810","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK TRUCK","insp_unit_company":"141270","insp_unit_license":"2962527","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN2AY6LM002113","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-09T09:42:59.000000Z","updated_at":"2026-04-18T09:20:11.000000Z"}]},{"id":11369075,"change_date":"2026-03-13 21:37:00","inspection_id":"87282630","dot_number":"792056","report_state":"AL","report_number":"2113002358","insp_date":"2026-03-13 00:00:00","insp_start_time":"1350","insp_end_time":"1413","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"HEFLIN AL","county_code_state":"AL","county_code":"029","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SYSCO OF CENTRAL ALABAMA","shipping_paper_number":"446515839","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-03-13 21:37: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":"3002867","transaction_code":"A","transaction_date":"2026-03-13 00:00:00","upload_date":"2026-03-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2026-03-13 21:37:00","snet_input_date":"2026-03-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-13 21:37:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-16T09:39:13.000000Z","updated_at":"2026-03-24T09:30:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19467110,"change_date":"2026-03-13 21:37:00","inspection_id":"87282630","insp_unit_id":"212122026","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"143544","insp_unit_license":"3216141","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN3AY9PM003266","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-16T09:16:57.000000Z","updated_at":"2026-03-24T09:04:17.000000Z"},{"id":19467111,"change_date":"2026-03-13 21:37:00","inspection_id":"87282630","insp_unit_id":"212122027","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STE HACKNE","insp_unit_company":"255432","insp_unit_license":"PF74261","insp_unit_license_state":"AL","insp_unit_vehicle_id_number":"526162816R3000119","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-16T09:16:57.000000Z","updated_at":"2026-03-24T09:04:17.000000Z"}]},{"id":11200591,"change_date":"2026-03-02 21:38:00","inspection_id":"87111430","dot_number":"792056","report_state":"AL","report_number":"1118007797","insp_date":"2026-02-23 00:00:00","insp_start_time":"0510","insp_end_time":"0550","registration_date":"2026-02-27 00:00:00","region":"CS","ci_status_code":"C","location":null,"location_desc":"ALABASTER AL","county_code_state":"AL","county_code":"117","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SYSCO","shipping_paper_number":"7812","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-02-23 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"102700","viol_total":"6","oos_total":"2","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2921175","transaction_code":"C","transaction_date":"2026-02-23 00:00:00","upload_date":"2026-03-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2026-02-23 21:38:00","snet_input_date":"2026-02-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-23 21:38:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-26T10:36:52.000000Z","updated_at":"2026-03-13T09:30:41.000000Z","inspection_violations":[{"id":18928687,"change_date":"2026-03-02 21:38:00","inspection_id":"87111430","insp_violation_id":"272135700","seq_no":"1","part_no":"392","part_no_section":"2-SLLSWZ","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-05T10:56:47.000000Z","updated_at":"2026-03-13T09:44:27.000000Z","normalized_code":"3922SLLSWZ"},{"id":18928688,"change_date":"2026-03-02 21:38:00","inspection_id":"87111430","insp_violation_id":"272135701","seq_no":"2","part_no":"393","part_no_section":"9A-LSML","insp_viol_unit":"2","insp_unit_id":"211917105","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-05T10:56:47.000000Z","updated_at":"2026-03-13T09:44:27.000000Z","normalized_code":"3939ALSML"},{"id":18928689,"change_date":"2026-03-02 21:38:00","inspection_id":"87111430","insp_violation_id":"272135702","seq_no":"3","part_no":"393","part_no_section":"9A-LTSI","insp_viol_unit":"2","insp_unit_id":"211917105","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-03-05T10:56:47.000000Z","updated_at":"2026-03-13T09:44:27.000000Z","normalized_code":"3939ALTSI"},{"id":18928690,"change_date":"2026-03-02 21:38:00","inspection_id":"87111430","insp_violation_id":"272135703","seq_no":"4","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"2","insp_unit_id":"211917105","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-05T10:56:47.000000Z","updated_at":"2026-03-13T09:44:27.000000Z","normalized_code":"3939ALLPL"},{"id":18928691,"change_date":"2026-03-02 21:38:00","inspection_id":"87111430","insp_violation_id":"272135704","seq_no":"5","part_no":"393","part_no_section":"9B-LRLIWR","insp_viol_unit":"2","insp_unit_id":"211917105","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-03-05T10:56:47.000000Z","updated_at":"2026-03-13T09:44:27.000000Z","normalized_code":"3939BLRLIWR"},{"id":18928692,"change_date":"2026-03-02 21:38:00","inspection_id":"87111430","insp_violation_id":"272135705","seq_no":"6","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"211917105","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-05T10:56:47.000000Z","updated_at":"2026-03-13T09:44:27.000000Z","normalized_code":"3939ALIL"}],"inspection_per_units":[{"id":19259756,"change_date":"2026-03-02 21:38:00","inspection_id":"87111430","insp_unit_id":"211917104","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"141182","insp_unit_license":"3786731","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN2AY0LM002026","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-05T10:14:40.000000Z","updated_at":"2026-03-13T09:05:59.000000Z"},{"id":19259757,"change_date":"2026-03-02 21:38:00","inspection_id":"87111430","insp_unit_id":"211917105","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"P281801","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA7621EB704292","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-05T10:14:40.000000Z","updated_at":"2026-03-13T09:05:59.000000Z"}]},{"id":11103047,"change_date":"2026-02-27 21:41:00","inspection_id":"87015204","dot_number":"792056","report_state":"AL","report_number":"2121000406","insp_date":"2026-02-11 00:00:00","insp_start_time":"1055","insp_end_time":"1122","registration_date":"2026-02-13 00:00:00","region":"CS","ci_status_code":"C","location":null,"location_desc":"AUBURN AL","county_code_state":"AL","county_code":"081","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-02-11 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"73700","viol_total":"5","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2873221","transaction_code":"C","transaction_date":"2026-02-11 00:00:00","upload_date":"2026-02-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2026-02-11 21:38:00","snet_input_date":"2026-02-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-11 21:38:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-14T10:37:31.000000Z","updated_at":"2026-03-10T09:31:21.000000Z","inspection_violations":[{"id":18886339,"change_date":"2026-02-27 21:41:00","inspection_id":"87015204","insp_violation_id":"272089627","seq_no":"1","part_no":"392","part_no_section":"2-SLLS3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"~W004394","created_at":"2026-03-02T10:58:22.000000Z","updated_at":"2026-03-10T09:44:21.000000Z","normalized_code":"3922SLLS3"},{"id":18886340,"change_date":"2026-02-27 21:41:00","inspection_id":"87015204","insp_violation_id":"272089628","seq_no":"2","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"211878868","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-02T10:58:22.000000Z","updated_at":"2026-03-10T09:44:21.000000Z","normalized_code":"39395A4EEUS"},{"id":18886341,"change_date":"2026-02-27 21:41:00","inspection_id":"87015204","insp_violation_id":"272089629","seq_no":"3","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"211878868","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-02T10:58:22.000000Z","updated_at":"2026-03-10T09:44:21.000000Z","normalized_code":"39378AWS"},{"id":18886342,"change_date":"2026-02-27 21:41:00","inspection_id":"87015204","insp_violation_id":"272089630","seq_no":"4","part_no":"393","part_no_section":"9A-LFTSI","insp_viol_unit":"1","insp_unit_id":"211878868","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-02T10:58:22.000000Z","updated_at":"2026-03-10T09:44:21.000000Z","normalized_code":"3939ALFTSI"},{"id":18886343,"change_date":"2026-02-27 21:41:00","inspection_id":"87015204","insp_violation_id":"272089631","seq_no":"5","part_no":"393","part_no_section":"9A-LHWS","insp_viol_unit":"1","insp_unit_id":"211878868","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-02T10:58:22.000000Z","updated_at":"2026-03-10T09:44:21.000000Z","normalized_code":"3939ALHWS"}],"inspection_per_units":[{"id":19222431,"change_date":"2026-02-27 21:41:00","inspection_id":"87015204","insp_unit_id":"211878868","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"141182","insp_unit_license":"3786731","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN2AY0LM002026","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-02T10:16:18.000000Z","updated_at":"2026-03-10T09:02:21.000000Z"},{"id":19222432,"change_date":"2026-02-27 21:41:00","inspection_id":"87015204","insp_unit_id":"211878869","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"P380367","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA561XFE702181","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-02T10:16:18.000000Z","updated_at":"2026-03-10T09:02:21.000000Z"}]},{"id":10586550,"change_date":"2026-01-22 21:39:00","inspection_id":"86725217","dot_number":"792056","report_state":"AL","report_number":"1191000559","insp_date":"2026-01-07 00:00:00","insp_start_time":"0650","insp_end_time":"0725","registration_date":"2026-01-22 00:00:00","region":"CS","ci_status_code":"C","location":null,"location_desc":"PELHAM AL","county_code_state":"AL","county_code":"117","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-01-07 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"80700","viol_total":"6","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2733866","transaction_code":"C","transaction_date":"2026-01-07 00:00:00","upload_date":"2026-01-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2026-01-07 21:38:00","snet_input_date":"2026-01-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-07 21:38:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-10T10:34:38.000000Z","updated_at":"2026-02-02T10:30:28.000000Z","inspection_violations":[{"id":18112617,"change_date":"2026-01-22 21:39:00","inspection_id":"86725217","insp_violation_id":"271356126","seq_no":"1","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"2","insp_unit_id":"211228451","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-25T10:42:29.000000Z","updated_at":"2026-02-02T10:36:32.000000Z","normalized_code":"3939ALLPL"},{"id":18112618,"change_date":"2026-01-22 21:39:00","inspection_id":"86725217","insp_violation_id":"271356127","seq_no":"2","part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"2","insp_unit_id":"211228451","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-25T10:42:29.000000Z","updated_at":"2026-02-02T10:36:32.000000Z","normalized_code":"3939ALRLI"},{"id":18112619,"change_date":"2026-01-22 21:39:00","inspection_id":"86725217","insp_violation_id":"271356128","seq_no":"3","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"211228450","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-25T10:42:29.000000Z","updated_at":"2026-02-02T10:36:32.000000Z","normalized_code":"39395A4EEUS"},{"id":18112620,"change_date":"2026-01-22 21:39:00","inspection_id":"86725217","insp_violation_id":"271356129","seq_no":"4","part_no":"393","part_no_section":"9A-LSML","insp_viol_unit":"2","insp_unit_id":"211228451","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-25T10:42:29.000000Z","updated_at":"2026-02-02T10:36:32.000000Z","normalized_code":"3939ALSML"},{"id":18112621,"change_date":"2026-01-22 21:39:00","inspection_id":"86725217","insp_violation_id":"271356130","seq_no":"5","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"211228450","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-25T10:42:29.000000Z","updated_at":"2026-02-02T10:36:32.000000Z","normalized_code":"3939ALIL"},{"id":18112622,"change_date":"2026-01-22 21:39:00","inspection_id":"86725217","insp_violation_id":"271356131","seq_no":"6","part_no":"393","part_no_section":"9A-LSML","insp_viol_unit":"1","insp_unit_id":"211228450","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-25T10:42:29.000000Z","updated_at":"2026-02-02T10:36:32.000000Z","normalized_code":"3939ALSML"}],"inspection_per_units":[{"id":18198069,"change_date":"2026-01-22 21:39:00","inspection_id":"86725217","insp_unit_id":"211228450","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"132473","insp_unit_license":"2028780","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4M39DG5EN168199","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-25T10:09:14.000000Z","updated_at":"2026-02-02T10:02:48.000000Z"},{"id":18198070,"change_date":"2026-01-22 21:39:00","inspection_id":"86725217","insp_unit_id":"211228451","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HACKNEY &","insp_unit_company":"254067","insp_unit_license":"PD71406","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"526162813P5000659","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-25T10:09:14.000000Z","updated_at":"2026-02-02T10:02:48.000000Z"}]},{"id":9778510,"change_date":"2025-09-29 21:39:00","inspection_id":"85876750","dot_number":"792056","report_state":"AL","report_number":"1299003922","insp_date":"2025-09-24 00:00:00","insp_start_time":"0830","insp_end_time":"0855","registration_date":"2025-09-26 00:00:00","region":"CD","ci_status_code":"C","location":null,"location_desc":"CLANTON AL","county_code_state":"AL","county_code":"021","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-09-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"34000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2326153","transaction_code":"C","transaction_date":"2025-09-25 00:00:00","upload_date":"2025-09-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2025-09-25 21:41:00","snet_input_date":"2025-09-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-25 21:41:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-28T10:01:08.000000Z","updated_at":"2025-10-03T10:00:35.000000Z","inspection_violations":[{"id":16126253,"change_date":"2025-09-29 21:39:00","inspection_id":"85876750","insp_violation_id":"268975350","seq_no":"1","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"209195128","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-02T10:15:24.000000Z","updated_at":"2025-10-03T10:15:58.000000Z","normalized_code":"39395A1"}],"inspection_per_units":[{"id":16249662,"change_date":"2025-09-29 21:39:00","inspection_id":"85876750","insp_unit_id":"209195128","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"#134355","insp_unit_license":"2241072","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4M39EG0GN944899","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-02T09:45:18.000000Z","updated_at":"2025-10-03T09:45:47.000000Z"}]},{"id":9559384,"change_date":"2025-09-01 21:34:00","inspection_id":"85647630","dot_number":"792056","report_state":"AL","report_number":"1299003883","insp_date":"2025-09-01 00:00:00","insp_start_time":"0445","insp_end_time":"0507","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"ALABASTER AL","county_code_state":"AL","county_code":"117","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SYSCO","shipping_paper_number":"668475","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-01 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"102000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2207020","transaction_code":"A","transaction_date":"2025-09-01 00:00:00","upload_date":"2025-09-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2025-09-01 21:34:00","snet_input_date":"2025-09-01 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-01 21:34:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-06T10:42:47.000000Z","updated_at":"2025-09-06T10:42:47.000000Z","inspection_violations":[{"id":15610130,"change_date":"2025-09-01 21:34:00","inspection_id":"85647630","insp_violation_id":"268379290","seq_no":"1","part_no":"383","part_no_section":"71H","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-06T10:46:57.000000Z","updated_at":"2025-09-06T10:46:57.000000Z","normalized_code":"38371H"}],"inspection_per_units":[{"id":15778012,"change_date":"2025-09-01 21:34:00","inspection_id":"85647630","insp_unit_id":"208683707","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"143548","insp_unit_license":"3216215","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN3AY1PM003262","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:47:06.000000Z","updated_at":"2025-09-09T09:47:06.000000Z"},{"id":15778013,"change_date":"2025-09-01 21:34:00","inspection_id":"85647630","insp_unit_id":"208683708","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"247277","insp_unit_license":"P812106","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA762XKE155590","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:47:06.000000Z","updated_at":"2025-09-09T09:47:06.000000Z"}]},{"id":9532182,"change_date":"2025-08-28 21:41:00","inspection_id":"85618576","dot_number":"792056","report_state":"AL","report_number":"1260005074","insp_date":"2025-08-28 00:00:00","insp_start_time":"0740","insp_end_time":"0800","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"CULLMAN AL","county_code_state":"AL","county_code":"043","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"THE FOUNDRY","shipping_paper_number":"446309386","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-08-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2190665","transaction_code":"A","transaction_date":"2025-08-28 00:00:00","upload_date":"2025-08-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2025-08-28 21:41:00","snet_input_date":"2025-08-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-28 21:41:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-06T10:42:13.000000Z","updated_at":"2025-09-06T10:42:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15733244,"change_date":"2025-08-28 21:41:00","inspection_id":"85618576","insp_unit_id":"208632692","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"146006","insp_unit_license":"2962652","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHTDV4PDUP2054","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:46:35.000000Z","updated_at":"2025-09-09T09:46:35.000000Z"},{"id":15733245,"change_date":"2025-08-28 21:41:00","inspection_id":"85618576","insp_unit_id":"208632693","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"254069","insp_unit_license":"PD71191","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V422K1RJ103043","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:46:35.000000Z","updated_at":"2025-09-09T09:46:35.000000Z"}]},{"id":9490294,"change_date":"2025-08-23 21:33:00","inspection_id":"85574420","dot_number":"792056","report_state":"AL","report_number":"1293004600","insp_date":"2025-08-22 00:00:00","insp_start_time":"1709","insp_end_time":"1730","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"DEMOPOLIS AL","county_code_state":"AL","county_code":"091","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-08-23 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"73000","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":"2168742","transaction_code":"A","transaction_date":"2025-08-23 00:00:00","upload_date":"2025-08-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2025-08-23 21:33:00","snet_input_date":"2025-08-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-23 21:33:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-26T10:46:12.000000Z","updated_at":"2025-08-27T10:43:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15654879,"change_date":"2025-08-23 21:33:00","inspection_id":"85574420","insp_unit_id":"208549718","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"CALB141184","insp_unit_license":"3859030","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN2AY4LM002028","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-26T09:46:33.000000Z","updated_at":"2025-08-27T09:45:22.000000Z"},{"id":15654880,"change_date":"2025-08-23 21:33:00","inspection_id":"85574420","insp_unit_id":"208549719","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KENTUCKY M","insp_unit_company":"255432","insp_unit_license":"PF74261","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"526162816R3000119","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-26T09:46:33.000000Z","updated_at":"2025-08-27T09:45:22.000000Z"}]},{"id":9479525,"change_date":"2025-08-22 21:38:00","inspection_id":"85563160","dot_number":"792056","report_state":"AL","report_number":"1750002224","insp_date":"2025-08-21 00:00:00","insp_start_time":"1538","insp_end_time":"1606","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"BAY MINETTE AL","county_code_state":"AL","county_code":"003","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-08-22 21:38: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":"2164800","transaction_code":"A","transaction_date":"2025-08-22 00:00:00","upload_date":"2025-08-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2025-08-22 21:38:00","snet_input_date":"2025-08-21 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-22 21:38:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-25T10:43:12.000000Z","updated_at":"2025-08-26T10:45:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15637048,"change_date":"2025-08-22 21:38:00","inspection_id":"85563160","insp_unit_id":"208529053","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"145275","insp_unit_license":"3431919","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKBHTDV7PDUG7835","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-25T09:46:37.000000Z","updated_at":"2025-08-26T09:45:35.000000Z"},{"id":15637049,"change_date":"2025-08-22 21:38:00","inspection_id":"85563160","insp_unit_id":"208529054","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"256953","insp_unit_license":"PG65444","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V281K3SJ518025","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-25T09:46:37.000000Z","updated_at":"2025-08-26T09:45:35.000000Z"}]},{"id":9378116,"change_date":"2025-08-11 21:38:00","inspection_id":"85456477","dot_number":"792056","report_state":"AL","report_number":"1088003693","insp_date":"2025-08-08 00:00:00","insp_start_time":"1755","insp_end_time":"1822","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"DEMOPOLIS AL","county_code_state":"AL","county_code":"091","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SYSCO","shipping_paper_number":"0589451","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-08-11 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"80700","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":"2114056","transaction_code":"A","transaction_date":"2025-08-11 00:00:00","upload_date":"2025-08-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2025-08-11 21:38:00","snet_input_date":"2025-08-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-11 21:38:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-14T10:42:25.000000Z","updated_at":"2025-08-15T10:43:03.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15451944,"change_date":"2025-08-11 21:38:00","inspection_id":"85456477","insp_unit_id":"208330888","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"148062","insp_unit_license":"2028843","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKBHTDV6SSVN1816","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-14T09:45:30.000000Z","updated_at":"2025-08-15T09:45:38.000000Z"},{"id":15451945,"change_date":"2025-08-11 21:38:00","inspection_id":"85456477","insp_unit_id":"208330889","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HACKNEY &","insp_unit_company":"254067","insp_unit_license":"PD71406","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"526162813P5000659","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-14T09:45:30.000000Z","updated_at":"2025-08-15T09:45:38.000000Z"}]},{"id":9096604,"change_date":"2025-07-09 21:42:00","inspection_id":"85160869","dot_number":"792056","report_state":"AL","report_number":"1260004919","insp_date":"2025-07-09 00:00:00","insp_start_time":"1035","insp_end_time":"1055","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"CULLMAN AL","county_code_state":"AL","county_code":"043","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"GRAVES DINNER","shipping_paper_number":"44658888","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-07-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1968942","transaction_code":"A","transaction_date":"2025-07-09 00:00:00","upload_date":"2025-07-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2025-07-09 21:42:00","snet_input_date":"2025-07-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-09 21:42:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-12T10:45:17.000000Z","updated_at":"2025-07-14T10:45:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14931584,"change_date":"2025-07-09 21:42:00","inspection_id":"85160869","insp_unit_id":"207769355","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"146005","insp_unit_license":"2962648","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHTDV2PDUP2053","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-12T09:45:48.000000Z","updated_at":"2025-07-13T09:45:46.000000Z"},{"id":14931585,"change_date":"2025-07-09 21:42:00","inspection_id":"85160869","insp_unit_id":"207769356","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"245312","insp_unit_license":"P590237","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA7625HE703133","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-12T09:45:48.000000Z","updated_at":"2025-07-13T09:45:46.000000Z"}]},{"id":8792812,"change_date":"2025-06-02 21:39:00","inspection_id":"84839104","dot_number":"792056","report_state":"AL","report_number":"1511004297","insp_date":"2025-06-02 00:00:00","insp_start_time":"0830","insp_end_time":"0916","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"VESTAVIA HILLS AL","county_code_state":"AL","county_code":"073","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-06-02 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"34700","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1812087","transaction_code":"A","transaction_date":"2025-06-02 00:00:00","upload_date":"2025-06-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2025-06-02 21:39:00","snet_input_date":"2025-06-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-06-02 21:39:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-05T10:00:25.000000Z","updated_at":"2025-06-06T10:00:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14388578,"change_date":"2025-06-02 21:39:00","inspection_id":"84839104","insp_unit_id":"207176696","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"143548","insp_unit_license":"3216215","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN3AY1PM003262","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-05T09:45:24.000000Z","updated_at":"2025-06-06T09:45:26.000000Z"}]},{"id":8624542,"change_date":"2025-05-14 21:41:00","inspection_id":"84661426","dot_number":"792056","report_state":"GA","report_number":"0117000989","insp_date":"2025-05-07 00:00:00","insp_start_time":"1107","insp_end_time":"1135","registration_date":null,"region":"ED","ci_status_code":"C","location":"271","location_desc":"TEMPLE GA","county_code_state":"GA","county_code":"045","insp_level_id":"3","service_center":"SH","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-05-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1723837","transaction_code":"A","transaction_date":"2025-05-14 00:00:00","upload_date":"2025-05-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2025-05-14 21:41:00","snet_input_date":"2025-05-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-14 21:41:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-17T10:04:45.000000Z","updated_at":"2025-05-18T10:04:02.000000Z","inspection_violations":[{"id":13714151,"change_date":"2025-05-14 21:41:00","inspection_id":"84661426","insp_violation_id":"266206158","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-18T10:25:23.000000Z","updated_at":"2025-05-18T10:29:13.000000Z","normalized_code":"3922SLLEWA1"}],"inspection_per_units":[{"id":14082890,"change_date":"2025-05-14 21:41:00","inspection_id":"84661426","insp_unit_id":"206843549","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CIMC VEHIC","insp_unit_company":null,"insp_unit_license":"PF74115","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"527SR4828SL044236","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-17T09:48:39.000000Z","updated_at":"2025-05-18T09:49:10.000000Z"},{"id":14082889,"change_date":"2025-05-14 21:41:00","inspection_id":"84661426","insp_unit_id":"206843548","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"146007","insp_unit_license":"2962651","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHTDV6PDUP2055","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-17T09:48:39.000000Z","updated_at":"2025-05-18T09:49:10.000000Z"}]},{"id":8555038,"change_date":"2025-05-06 21:39:00","inspection_id":"84588368","dot_number":"792056","report_state":"GA","report_number":"1413000699","insp_date":"2025-04-29 00:00:00","insp_start_time":"1515","insp_end_time":"1540","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"BREMEN GA","county_code_state":"GA","county_code":"045","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SYSCO CENTRAL ALABAMA INC","shipping_paper_number":"MULTIPLE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-05-06 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"77699","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":"1689071","transaction_code":"A","transaction_date":"2025-05-06 00:00:00","upload_date":"2025-05-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2025-05-06 21:39:00","snet_input_date":"2025-04-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-06 21:39:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-09T10:25:22.000000Z","updated_at":"2025-05-10T10:50:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13913884,"change_date":"2025-05-06 21:39:00","inspection_id":"84588368","insp_unit_id":"206657121","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"143544","insp_unit_license":"3216141","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN3AY9PM003266","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-09T10:07:38.000000Z","updated_at":"2025-05-10T09:53:21.000000Z"},{"id":13913885,"change_date":"2025-05-06 21:39:00","inspection_id":"84588368","insp_unit_id":"206657122","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KENTUCKY M","insp_unit_company":"255432","insp_unit_license":"PF74261","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"526162816R3000119","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-09T10:07:38.000000Z","updated_at":"2025-05-10T09:53:21.000000Z"}]},{"id":8348726,"change_date":"2025-04-11 21:40:00","inspection_id":"84370757","dot_number":"792056","report_state":"FL","report_number":"1952006205","insp_date":"2025-04-07 00:00:00","insp_start_time":"1335","insp_end_time":"1353","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"MILTON FL","county_code_state":"FL","county_code":"113","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SAME AS  CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-04-11 21:40: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":"1580808","transaction_code":"A","transaction_date":"2025-04-11 00:00:00","upload_date":"2025-04-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2025-04-11 21:40:00","snet_input_date":"2025-04-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-11 21:40:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-14T10:29:23.000000Z","updated_at":"2025-04-15T10:14:22.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13546042,"change_date":"2025-04-11 21:40:00","inspection_id":"84370757","insp_unit_id":"206259198","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"150138","insp_unit_license":"2962664","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKBHTDV0SSWC5498","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-14T10:09:55.000000Z","updated_at":"2025-04-15T09:52:41.000000Z"},{"id":13546043,"change_date":"2025-04-11 21:40:00","inspection_id":"84370757","insp_unit_id":"206259199","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"246724","insp_unit_license":"P668540","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA5612JE132993","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-14T10:09:55.000000Z","updated_at":"2025-04-15T09:52:41.000000Z"}]},{"id":8294660,"change_date":"2025-04-04 21:40:00","inspection_id":"84313883","dot_number":"792056","report_state":"AL","report_number":"1278000004","insp_date":"2025-04-04 00:00:00","insp_start_time":"0529","insp_end_time":"0555","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"VERBENA AL","county_code_state":"AL","county_code":"021","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SYCO","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-04-04 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"732000","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":"1554613","transaction_code":"A","transaction_date":"2025-04-04 00:00:00","upload_date":"2025-04-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2025-04-04 21:40:00","snet_input_date":"2025-04-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-04 21:40:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-07T10:21:57.000000Z","updated_at":"2025-04-08T10:09:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13448573,"change_date":"2025-04-04 21:40:00","inspection_id":"84313883","insp_unit_id":"206155079","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"133822","insp_unit_license":"3539752","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4MC9EG9FN927372","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-07T10:08:19.000000Z","updated_at":"2025-04-08T09:54:46.000000Z"},{"id":13448574,"change_date":"2025-04-04 21:40:00","inspection_id":"84313883","insp_unit_id":"206155080","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"229714","insp_unit_license":"P281801","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA7621EB704292","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-07T10:08:19.000000Z","updated_at":"2025-04-08T09:54:46.000000Z"}]},{"id":8144731,"change_date":"2025-03-18 21:40:00","inspection_id":"84156063","dot_number":"792056","report_state":"AL","report_number":"1440003087","insp_date":"2025-03-18 00:00:00","insp_start_time":"0620","insp_end_time":"0653","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"AL","county_code":"009","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SAME AS CARRIER","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1046150","transaction_code":"A","transaction_date":"2025-03-18 00:00:00","upload_date":"2025-03-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2025-03-18 21:40:00","snet_input_date":"2025-03-18 00:00:00","source_office":"2ALS001","mcmis_add_date":"2025-03-18 21:40:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"109972","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-21T10:32:58.000000Z","updated_at":"2025-03-22T10:34:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13155639,"change_date":"2025-03-18 21:40:00","inspection_id":"84156063","insp_unit_id":"205857974","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"146005","insp_unit_license":"2962648","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHTDV2PDUP2053","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-21T10:05:31.000000Z","updated_at":"2025-03-22T09:57:46.000000Z"},{"id":13155640,"change_date":"2025-03-18 21:40:00","inspection_id":"84156063","insp_unit_id":"205857975","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"244408","insp_unit_license":"P490515","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA762XGE702770","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-21T10:05:31.000000Z","updated_at":"2025-03-22T09:57:46.000000Z"}]},{"id":7884765,"change_date":"2025-02-19 21:40:00","inspection_id":"83882987","dot_number":"792056","report_state":"AL","report_number":"1299003535","insp_date":"2025-02-17 00:00:00","insp_start_time":"0455","insp_end_time":"0515","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"AL","county_code":"117","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SYSCO","shipping_paper_number":"0575940","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-02-17 21:35: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":"1042128","transaction_code":"C","transaction_date":"2025-02-19 00:00:00","upload_date":"2025-02-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2025-02-17 21:35:00","snet_input_date":"2025-02-17 00:00:00","source_office":"2ALS001","mcmis_add_date":"2025-02-17 21:35:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"109972","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:01:57.000000Z","updated_at":"2025-03-17T21:01:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12726818,"change_date":"2025-02-19 21:40:00","inspection_id":"83882987","insp_unit_id":"205393529","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"2342151","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4M39EG9HN983721","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:37.000000Z","updated_at":"2025-03-17T23:55:37.000000Z"},{"id":12726819,"change_date":"2025-02-19 21:40:00","inspection_id":"83882987","insp_unit_id":"205393530","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":null,"insp_unit_license":"PG26886","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V382K8SJ149061","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:37.000000Z","updated_at":"2025-03-17T23:55:37.000000Z"}]},{"id":7638505,"change_date":"2025-01-16 21:41:00","inspection_id":"83624184","dot_number":"792056","report_state":"AL","report_number":"1440002843","insp_date":"2025-01-16 00:00:00","insp_start_time":"1120","insp_end_time":"1147","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"AL","county_code":"009","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SAME AS CARRIER","shipping_paper_number":"573401","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-01-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1038598","transaction_code":"A","transaction_date":"2025-01-16 00:00:00","upload_date":"2025-01-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2025-01-16 21:41:00","snet_input_date":"2025-01-16 00:00:00","source_office":"2ALS001","mcmis_add_date":"2025-01-16 21:41:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"109972","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:56:35.000000Z","updated_at":"2025-03-17T20:56:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12325285,"change_date":"2025-01-16 21:41:00","inspection_id":"83624184","insp_unit_id":"204870802","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"147167","insp_unit_license":"3626762","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHTDV8RSVC1881","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:03.000000Z","updated_at":"2025-03-17T23:51:03.000000Z"},{"id":12325286,"change_date":"2025-01-16 21:41:00","inspection_id":"83624184","insp_unit_id":"204870803","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"250617","insp_unit_license":"P945651","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GR1A7629LE218082","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:03.000000Z","updated_at":"2025-03-17T23:51:03.000000Z"}]},{"id":7293602,"change_date":"2024-11-27 21:39:00","inspection_id":"83261751","dot_number":"792056","report_state":"AL","report_number":"CMAD003930","insp_date":"2024-11-27 00:00:00","insp_start_time":"1214","insp_end_time":"1235","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US31 NEAR CR493","county_code_state":"AL","county_code":"043","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-11-27 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":"1033666","transaction_code":"A","transaction_date":"2024-11-27 00:00:00","upload_date":"2024-11-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2024-11-27 21:39:00","snet_input_date":"2024-11-27 00:00:00","source_office":"2ALS001","mcmis_add_date":"2024-11-27 21:39:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"109972","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:48:11.000000Z","updated_at":"2025-03-17T20:48:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11764812,"change_date":"2024-11-27 21:39:00","inspection_id":"83261751","insp_unit_id":"204085659","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"148066","insp_unit_license":"2028843","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKBHTDV6SSVN1816","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:55.000000Z","updated_at":"2025-03-17T23:44:55.000000Z"},{"id":11764813,"change_date":"2024-11-27 21:39:00","inspection_id":"83261751","insp_unit_id":"204085660","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"250766","insp_unit_license":"P945654","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GR1A7624LE218085","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:55.000000Z","updated_at":"2025-03-17T23:44:55.000000Z"}]},{"id":7299333,"change_date":"2024-11-28 21:34:00","inspection_id":"83267852","dot_number":"792056","report_state":"MS","report_number":"6626401040","insp_date":"2024-11-11 00:00:00","insp_start_time":"0746","insp_end_time":"0816","registration_date":null,"region":"CT","ci_status_code":"C","location":"30","location_desc":"I-10 W   @ MM  75","county_code_state":"MS","county_code":"059","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SYSCO FOOD SERVICES","shipping_paper_number":"446012935","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-11-28 21:34:00","post_acc_ind":"Y","gross_comb_veh_wt":null,"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":"1083276","transaction_code":"A","transaction_date":"2024-11-27 00:00:00","upload_date":"2024-11-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2024-11-28 21:34:00","snet_input_date":"2024-11-28 00:00:00","source_office":"2MSS002","mcmis_add_date":"2024-11-28 21:34:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:48:13.000000Z","updated_at":"2025-03-17T20:48:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11774456,"change_date":"2024-11-28 21:34:00","inspection_id":"83267852","insp_unit_id":"204097338","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"CALB143549","insp_unit_license":"3283518","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN3AY0PM003267","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:01.000000Z","updated_at":"2025-03-17T23:45:01.000000Z"},{"id":11774457,"change_date":"2024-11-28 21:34:00","inspection_id":"83267852","insp_unit_id":"204097339","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"242669","insp_unit_license":"PA41206","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA5614FE701950","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:01.000000Z","updated_at":"2025-03-17T23:45:01.000000Z"}]},{"id":6911388,"change_date":"2024-10-18 21:42:00","inspection_id":"82856602","dot_number":"792056","report_state":"AL","report_number":"BWJW008316","insp_date":"2024-10-08 00:00:00","insp_start_time":"0610","insp_end_time":"0645","registration_date":"2024-10-18 00:00:00","region":"CT","ci_status_code":"C","location":"S271","location_desc":"ROADSIDE","county_code_state":"AL","county_code":"101","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"WALMART","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"73000","viol_total":"7","oos_total":"4","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"4","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1027008","transaction_code":"C","transaction_date":"2024-10-09 00:00:00","upload_date":"2024-10-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2024-10-08 21:41:00","snet_input_date":"2024-10-08 00:00:00","source_office":"2ALS001","mcmis_add_date":"2024-10-08 21:41:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"109972","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:40:14.000000Z","updated_at":"2025-03-17T20:40:14.000000Z","inspection_violations":[{"id":10770427,"change_date":"2024-10-18 21:42:00","inspection_id":"82856602","insp_violation_id":"262424318","seq_no":"1","part_no":"393","part_no_section":"9T","insp_viol_unit":"2","insp_unit_id":"203470805","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"U5410010","created_at":"2025-03-17T21:58:09.000000Z","updated_at":"2025-03-17T21:58:09.000000Z","normalized_code":"3939T"},{"id":10770428,"change_date":"2024-10-18 21:42:00","inspection_id":"82856602","insp_violation_id":"262424319","seq_no":"2","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"203470805","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:58:09.000000Z","updated_at":"2025-03-17T21:58:09.000000Z","normalized_code":"3939"},{"id":10770429,"change_date":"2024-10-18 21:42:00","inspection_id":"82856602","insp_violation_id":"262424320","seq_no":"3","part_no":"393","part_no_section":"9TS","insp_viol_unit":"2","insp_unit_id":"203470805","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"U5410011","created_at":"2025-03-17T21:58:09.000000Z","updated_at":"2025-03-17T21:58:09.000000Z","normalized_code":"3939TS"},{"id":10770430,"change_date":"2024-10-18 21:42:00","inspection_id":"82856602","insp_violation_id":"262424321","seq_no":"4","part_no":"393","part_no_section":"55E","insp_viol_unit":"2","insp_unit_id":"203470805","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:09.000000Z","updated_at":"2025-03-17T21:58:09.000000Z","normalized_code":"39355E"},{"id":10770431,"change_date":"2024-10-18 21:42:00","inspection_id":"82856602","insp_violation_id":"262424322","seq_no":"5","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"203470805","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:09.000000Z","updated_at":"2025-03-17T21:58:09.000000Z","normalized_code":"3939"},{"id":10770432,"change_date":"2024-10-18 21:42:00","inspection_id":"82856602","insp_violation_id":"262424323","seq_no":"6","part_no":"392","part_no_section":"7A","insp_viol_unit":"1","insp_unit_id":"203470804","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"U5410012","created_at":"2025-03-17T21:58:09.000000Z","updated_at":"2025-03-17T21:58:09.000000Z","normalized_code":"3927A"},{"id":10770433,"change_date":"2024-10-18 21:42:00","inspection_id":"82856602","insp_violation_id":"262424324","seq_no":"7","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"203470805","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:58:09.000000Z","updated_at":"2025-03-17T21:58:09.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":11146473,"change_date":"2024-10-18 21:42:00","inspection_id":"82856602","insp_unit_id":"203470804","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"143547","insp_unit_license":"3215214","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN3AY0PM003270","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:27.000000Z","updated_at":"2025-03-17T23:38:27.000000Z"},{"id":11146474,"change_date":"2024-10-18 21:42:00","inspection_id":"82856602","insp_unit_id":"203470805","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"229513","insp_unit_license":"PD71297","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA5611EB700674","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:27.000000Z","updated_at":"2025-03-17T23:38:27.000000Z"}]},{"id":6805532,"change_date":"2024-09-30 21:41:00","inspection_id":"82744245","dot_number":"792056","report_state":"AL","report_number":"DWMC007093","insp_date":"2024-09-24 00:00:00","insp_start_time":"0632","insp_end_time":"0658","registration_date":"2024-09-27 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"AL","county_code":"051","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"0565021","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1024645","transaction_code":"C","transaction_date":"2024-09-24 00:00:00","upload_date":"2024-09-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2024-09-24 21:41:00","snet_input_date":"2024-09-24 00:00:00","source_office":"2ALS001","mcmis_add_date":"2024-09-24 21:41:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"109972","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:38:11.000000Z","updated_at":"2025-03-17T20:38:11.000000Z","inspection_violations":[{"id":10598454,"change_date":"2024-09-30 21:41:00","inspection_id":"82744245","insp_violation_id":"262100062","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"203189614","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:17.000000Z","updated_at":"2025-03-17T21:57:17.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":10974346,"change_date":"2024-09-30 21:41:00","inspection_id":"82744245","insp_unit_id":"203189614","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"CALB 138175","insp_unit_license":"2561567","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4NC9EH7KN208760","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:39.000000Z","updated_at":"2025-03-17T23:36:39.000000Z"},{"id":10974347,"change_date":"2024-09-30 21:41:00","inspection_id":"82744245","insp_unit_id":"203189615","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"246069","insp_unit_license":"P668338","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA7624JE701296","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:39.000000Z","updated_at":"2025-03-17T23:36:39.000000Z"}]},{"id":6794401,"change_date":"2024-09-23 21:40:00","inspection_id":"82732470","dot_number":"792056","report_state":"AL","report_number":"1218001498","insp_date":"2024-09-23 00:00:00","insp_start_time":"1300","insp_end_time":"1330","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"AL","county_code":"041","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-23 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"74700","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":"1024520","transaction_code":"A","transaction_date":"2024-09-23 00:00:00","upload_date":"2024-09-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2024-09-23 21:40:00","snet_input_date":"2024-09-23 00:00:00","source_office":"2ALS001","mcmis_add_date":"2024-09-23 21:40:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"109972","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:37:46.000000Z","updated_at":"2025-03-17T20:37:46.000000Z","inspection_violations":[{"id":10581565,"change_date":"2024-09-23 21:40:00","inspection_id":"82732470","insp_violation_id":"261979713","seq_no":"1","part_no":"383","part_no_section":"71(h)","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:57:16.000000Z","updated_at":"2025-03-17T21:57:16.000000Z","normalized_code":"38371H"}],"inspection_per_units":[{"id":10956284,"change_date":"2024-09-23 21:40:00","inspection_id":"82732470","insp_unit_id":"203079328","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"2241340","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4M39EG3GN959316","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:30.000000Z","updated_at":"2025-03-17T23:36:30.000000Z"},{"id":10956285,"change_date":"2024-09-23 21:40:00","inspection_id":"82732470","insp_unit_id":"203079329","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":null,"insp_unit_license":"P812267","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V281C8KT532001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:30.000000Z","updated_at":"2025-03-17T23:36:30.000000Z"}]},{"id":6688835,"change_date":"2024-09-17 21:44:00","inspection_id":"82619740","dot_number":"792056","report_state":"AL","report_number":"APCV003250","insp_date":"2024-09-10 00:00:00","insp_start_time":"0500","insp_end_time":"0535","registration_date":"2024-09-16 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"AL","county_code":"101","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SYSCO","shipping_paper_number":"42116","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-10 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"91000","viol_total":"3","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1022553","transaction_code":"C","transaction_date":"2024-09-10 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2024-09-10 21:39:00","snet_input_date":"2024-09-10 00:00:00","source_office":"2ALS001","mcmis_add_date":"2024-09-10 21:39:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"109972","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:35:39.000000Z","updated_at":"2025-03-17T20:35:39.000000Z","inspection_violations":[{"id":10411226,"change_date":"2024-09-17 21:44:00","inspection_id":"82619740","insp_violation_id":"261851225","seq_no":"1","part_no":"395","part_no_section":"30(b)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:25.000000Z","updated_at":"2025-03-17T21:56:25.000000Z","normalized_code":"39530B1"},{"id":10411227,"change_date":"2024-09-17 21:44:00","inspection_id":"82619740","insp_violation_id":"261851226","seq_no":"2","part_no":"395","part_no_section":"24(c)(2)(iii)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:25.000000Z","updated_at":"2025-03-17T21:56:25.000000Z","normalized_code":"39524C2III"},{"id":10411228,"change_date":"2024-09-17 21:44:00","inspection_id":"82619740","insp_violation_id":"261851227","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"202965913","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:25.000000Z","updated_at":"2025-03-17T21:56:25.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":10784953,"change_date":"2024-09-17 21:44:00","inspection_id":"82619740","insp_unit_id":"202965912","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"143549","insp_unit_license":"3283518","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN3AY0PM003267","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:38.000000Z","updated_at":"2025-03-17T23:34:38.000000Z"},{"id":10784954,"change_date":"2024-09-17 21:44:00","inspection_id":"82619740","insp_unit_id":"202965913","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"28","insp_unit_license":"PF73947","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA5612BB707533","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:38.000000Z","updated_at":"2025-03-17T23:34:38.000000Z"}]},{"id":6655684,"change_date":"2024-09-13 21:41:00","inspection_id":"82584475","dot_number":"792056","report_state":"AL","report_number":"1299003308","insp_date":"2024-09-05 00:00:00","insp_start_time":"0430","insp_end_time":"0450","registration_date":"2024-09-11 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"AL","county_code":"117","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SYSCO","shipping_paper_number":"0563630","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-05 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1021942","transaction_code":"C","transaction_date":"2024-09-05 00:00:00","upload_date":"2024-09-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2024-09-05 21:43:00","snet_input_date":"2024-09-05 00:00:00","source_office":"2ALS001","mcmis_add_date":"2024-09-05 21:43:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"109972","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:34:53.000000Z","updated_at":"2025-03-17T20:34:53.000000Z","inspection_violations":[{"id":10357903,"change_date":"2024-09-13 21:41:00","inspection_id":"82584475","insp_violation_id":"261787830","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"202912194","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:09.000000Z","updated_at":"2025-03-17T21:56:09.000000Z","normalized_code":"39378"}],"inspection_per_units":[{"id":10730705,"change_date":"2024-09-13 21:41:00","inspection_id":"82584475","insp_unit_id":"202912194","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"2488585","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4MC9EG9FN923855","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:08.000000Z","updated_at":"2025-03-17T23:34:08.000000Z"},{"id":10730706,"change_date":"2024-09-13 21:41:00","inspection_id":"82584475","insp_unit_id":"202912195","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":null,"insp_unit_license":"P962441","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1JJV362W96L002541","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:08.000000Z","updated_at":"2025-03-17T23:34:08.000000Z"}]},{"id":6624739,"change_date":"2024-09-03 21:40:00","inspection_id":"82551576","dot_number":"792056","report_state":"GA","report_number":"1417000385","insp_date":"2024-08-27 00:00:00","insp_start_time":"1400","insp_end_time":"1500","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"KENNESAW GA","county_code_state":"GA","county_code":"055","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SYSCO CENTRAL ALABAMA INC","shipping_paper_number":"346926016","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-09-03 21:40: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":"809692","transaction_code":"A","transaction_date":"2024-09-03 00:00:00","upload_date":"2024-09-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2024-09-03 21:40:00","snet_input_date":"2024-08-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-09-03 21:40:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:34:25.000000Z","updated_at":"2025-03-17T20:34:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10680933,"change_date":"2024-09-03 21:40:00","inspection_id":"82551576","insp_unit_id":"202712147","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"148066","insp_unit_license":"2165012","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKBHTDV3RDVJ0218","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:37.000000Z","updated_at":"2025-03-17T23:33:37.000000Z"},{"id":10680934,"change_date":"2024-09-03 21:40:00","inspection_id":"82551576","insp_unit_id":"202712148","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"246916","insp_unit_license":"P744458","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA5618KE131932","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:37.000000Z","updated_at":"2025-03-17T23:33:37.000000Z"}]},{"id":6514320,"change_date":"2024-08-20 21:42:00","inspection_id":"82433884","dot_number":"792056","report_state":"AL","report_number":"DWCV002518","insp_date":"2024-08-20 00:00:00","insp_start_time":"0700","insp_end_time":"0730","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-82","county_code_state":"AL","county_code":"051","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"INTERNATIONAL PAPER","shipping_paper_number":"0562378","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-20 21:42: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":"1019768","transaction_code":"A","transaction_date":"2024-08-20 00:00:00","upload_date":"2024-08-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2024-08-20 21:42:00","snet_input_date":"2024-08-20 00:00:00","source_office":"2ALS001","mcmis_add_date":"2024-08-20 21:42:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"109972","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:32:00.000000Z","updated_at":"2025-03-17T20:32:00.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10501163,"change_date":"2024-08-20 21:42:00","inspection_id":"82433884","insp_unit_id":"202484963","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"136330","insp_unit_license":"2488535","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4M39EG4HN991175","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:47.000000Z","updated_at":"2025-03-17T23:31:47.000000Z"},{"id":10501164,"change_date":"2024-08-20 21:42:00","inspection_id":"82433884","insp_unit_id":"202484964","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"247277","insp_unit_license":"P812106","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA762XKE155590","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:47.000000Z","updated_at":"2025-03-17T23:31:47.000000Z"}]},{"id":6514357,"change_date":"2024-08-20 21:42:00","inspection_id":"82433924","dot_number":"792056","report_state":"AL","report_number":"NSXA006982","insp_date":"2024-08-20 00:00:00","insp_start_time":"0452","insp_end_time":"0511","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"AL","county_code":"117","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-20 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"35000","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":"1019743","transaction_code":"A","transaction_date":"2024-08-20 00:00:00","upload_date":"2024-08-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2024-08-20 21:42:00","snet_input_date":"2024-08-20 00:00:00","source_office":"2ALS001","mcmis_add_date":"2024-08-20 21:42:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"109972","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:32:00.000000Z","updated_at":"2025-03-17T20:32:00.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10501227,"change_date":"2024-08-20 21:42:00","inspection_id":"82433924","insp_unit_id":"202485036","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"2028228","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4M39DG2EN149531","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:47.000000Z","updated_at":"2025-03-17T23:31:47.000000Z"}]},{"id":6442348,"change_date":"2024-08-12 21:43:00","inspection_id":"82357207","dot_number":"792056","report_state":"AL","report_number":"1925000688","insp_date":"2024-08-12 00:00:00","insp_start_time":"1015","insp_end_time":"1100","registration_date":null,"region":"CT","ci_status_code":"C","location":"30","location_desc":"AL-113\/11 MM","county_code_state":"AL","county_code":"053","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-12 21:43: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":"1018351","transaction_code":"A","transaction_date":"2024-08-12 00:00:00","upload_date":"2024-08-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2024-08-12 21:43:00","snet_input_date":"2024-08-12 00:00:00","source_office":"2ALS001","mcmis_add_date":"2024-08-12 21:43:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"109972","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:30:39.000000Z","updated_at":"2025-03-17T20:30:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10383124,"change_date":"2024-08-12 21:43:00","inspection_id":"82357207","insp_unit_id":"202340643","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"147166","insp_unit_license":"2962653","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHTDV6RSVC1880","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:36.000000Z","updated_at":"2025-03-17T23:30:36.000000Z"},{"id":10383125,"change_date":"2024-08-12 21:43:00","inspection_id":"82357207","insp_unit_id":"202340644","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"245281","insp_unit_license":"P590307","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA0627HE703142","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:36.000000Z","updated_at":"2025-03-17T23:30:36.000000Z"}]},{"id":6421873,"change_date":"2024-08-08 21:42:00","inspection_id":"82335280","dot_number":"792056","report_state":"AL","report_number":"1928002151","insp_date":"2024-08-08 00:00:00","insp_start_time":"0838","insp_end_time":"0858","registration_date":null,"region":"CT","ci_status_code":"C","location":"29","location_desc":"ROADSIDE","county_code_state":"AL","county_code":"051","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-08 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"92000","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":"1017872","transaction_code":"A","transaction_date":"2024-08-08 00:00:00","upload_date":"2024-08-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2024-08-08 21:42:00","snet_input_date":"2024-08-08 00:00:00","source_office":"2ALS001","mcmis_add_date":"2024-08-08 21:42:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"109972","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:30:15.000000Z","updated_at":"2025-03-17T20:30:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10349614,"change_date":"2024-08-08 21:42:00","inspection_id":"82335280","insp_unit_id":"202298637","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"2561568","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4NC9EH9KN208761","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:13.000000Z","updated_at":"2025-03-17T23:30:13.000000Z"},{"id":10349615,"change_date":"2024-08-08 21:42:00","inspection_id":"82335280","insp_unit_id":"202298638","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"P962458","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA5617CB708578","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:13.000000Z","updated_at":"2025-03-17T23:30:13.000000Z"}]},{"id":6412567,"change_date":"2024-08-07 21:41:00","inspection_id":"82325366","dot_number":"792056","report_state":"AL","report_number":"1218001408","insp_date":"2024-08-07 00:00:00","insp_start_time":"1355","insp_end_time":"1420","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"AL","county_code":"013","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"89000","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":"1017753","transaction_code":"A","transaction_date":"2024-08-07 00:00:00","upload_date":"2024-08-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2024-08-07 21:41:00","snet_input_date":"2024-08-07 00:00:00","source_office":"2ALS001","mcmis_add_date":"2024-08-07 21:41:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"109972","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:29:54.000000Z","updated_at":"2025-03-17T20:29:54.000000Z","inspection_violations":[{"id":9956448,"change_date":"2024-08-07 21:41:00","inspection_id":"82325366","insp_violation_id":"261066050","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:08.000000Z","updated_at":"2025-03-17T21:54:08.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10334596,"change_date":"2024-08-07 21:41:00","inspection_id":"82325366","insp_unit_id":"202279749","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"2561587","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4W39EG6KN208793","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:04.000000Z","updated_at":"2025-03-17T23:30:04.000000Z"},{"id":10334597,"change_date":"2024-08-07 21:41:00","inspection_id":"82325366","insp_unit_id":"202279750","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"P380059","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA5618FE701949","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:04.000000Z","updated_at":"2025-03-17T23:30:04.000000Z"}]},{"id":6326322,"change_date":"2024-07-28 21:33:00","inspection_id":"82232967","dot_number":"792056","report_state":"GA","report_number":"0392000420","insp_date":"2024-07-22 00:00:00","insp_start_time":"1345","insp_end_time":"1415","registration_date":null,"region":"ED","ci_status_code":"C","location":"4","location_desc":"LA GRANGE GA","county_code_state":"GA","county_code":"285","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SAME AS CARRIER","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-07-28 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","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":"691060","transaction_code":"A","transaction_date":"2024-07-28 00:00:00","upload_date":"2024-07-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2024-07-28 21:33:00","snet_input_date":"2024-07-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-07-28 21:33:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:28:14.000000Z","updated_at":"2025-03-17T20:28:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10193910,"change_date":"2024-07-28 21:33:00","inspection_id":"82232967","insp_unit_id":"202105185","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"135167","insp_unit_license":"3283620","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUJGBDV7GLHB3379","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:34.000000Z","updated_at":"2025-03-17T23:28:34.000000Z"}]},{"id":6185342,"change_date":"2024-07-10 21:40:00","inspection_id":"82081918","dot_number":"792056","report_state":"AL","report_number":"RCCV001340","insp_date":"2024-07-10 00:00:00","insp_start_time":"1108","insp_end_time":"1141","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"AL","county_code":"107","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SYSCO CENTRAL ALABAMA INC","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-07-10 21:40: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":"1013068","transaction_code":"A","transaction_date":"2024-07-10 00:00:00","upload_date":"2024-07-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2024-07-10 21:40:00","snet_input_date":"2024-07-10 00:00:00","source_office":"2ALS001","mcmis_add_date":"2024-07-10 21:40:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"109972","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:25:21.000000Z","updated_at":"2025-03-17T20:25:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9964187,"change_date":"2024-07-10 21:40:00","inspection_id":"82081918","insp_unit_id":"201815594","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"#134355","insp_unit_license":"2241072","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4M39EG0GN944899","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:14.000000Z","updated_at":"2025-03-17T23:26:14.000000Z"},{"id":9964188,"change_date":"2024-07-10 21:40:00","inspection_id":"82081918","insp_unit_id":"201815595","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"#246725","insp_unit_license":"P668541","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA5614JE132994","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:14.000000Z","updated_at":"2025-03-17T23:26:14.000000Z"}]},{"id":6017023,"change_date":"2024-06-18 21:42:00","inspection_id":"81900811","dot_number":"792056","report_state":"AL","report_number":"1928001967","insp_date":"2024-06-18 00:00:00","insp_start_time":"1603","insp_end_time":"1630","registration_date":null,"region":"CT","ci_status_code":"C","location":"29","location_desc":"ROADSIDE","county_code_state":"AL","county_code":"051","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"74000","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":"1010176","transaction_code":"A","transaction_date":"2024-06-18 00:00:00","upload_date":"2024-06-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2024-06-18 21:42:00","snet_input_date":"2024-06-18 00:00:00","source_office":"2ALS001","mcmis_add_date":"2024-06-18 21:42:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"109972","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:21:54.000000Z","updated_at":"2025-03-17T20:21:54.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9691071,"change_date":"2024-06-18 21:42:00","inspection_id":"81900811","insp_unit_id":"201465066","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"2779576","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN2AY4LM002028","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:26.000000Z","updated_at":"2025-03-17T23:23:26.000000Z"},{"id":9691072,"change_date":"2024-06-18 21:42:00","inspection_id":"81900811","insp_unit_id":"201465067","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"P962437","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS128Y4M253206","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:26.000000Z","updated_at":"2025-03-17T23:23:26.000000Z"}]},{"id":5875470,"change_date":"2024-05-30 21:42:00","inspection_id":"81746907","dot_number":"792056","report_state":"AL","report_number":"1218001254","insp_date":"2024-05-29 00:00:00","insp_start_time":"1430","insp_end_time":"1450","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"AL","county_code":"013","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-30 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"116000","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":"1007335","transaction_code":"A","transaction_date":"2024-05-29 00:00:00","upload_date":"2024-05-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2024-05-30 21:42:00","snet_input_date":"2024-05-29 00:00:00","source_office":"2ALS001","mcmis_add_date":"2024-05-30 21:42:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"109972","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:19:06.000000Z","updated_at":"2025-03-17T20:19:06.000000Z","inspection_violations":[{"id":9110737,"change_date":"2024-05-30 21:42:00","inspection_id":"81746907","insp_violation_id":"259810359","seq_no":"1","part_no":"383","part_no_section":"71(h)","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:50:01.000000Z","updated_at":"2025-03-17T21:50:01.000000Z","normalized_code":"38371H"}],"inspection_per_units":[{"id":9462841,"change_date":"2024-05-30 21:42:00","inspection_id":"81746907","insp_unit_id":"201152398","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"2561273","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4W39EG6JN901362","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:09.000000Z","updated_at":"2025-03-17T23:21:09.000000Z"},{"id":9462842,"change_date":"2024-05-30 21:42:00","inspection_id":"81746907","insp_unit_id":"201152399","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"P380057","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA5614FE701947","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:09.000000Z","updated_at":"2025-03-17T23:21:09.000000Z"}]},{"id":5817732,"change_date":"2024-05-22 21:40:00","inspection_id":"81684622","dot_number":"792056","report_state":"AL","report_number":"MLCV009517","insp_date":"2024-05-22 00:00:00","insp_start_time":"0500","insp_end_time":"0530","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"I 459 N@IRONDALE","county_code_state":"AL","county_code":"073","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-22 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":"1006422","transaction_code":"A","transaction_date":"2024-05-22 00:00:00","upload_date":"2024-05-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2024-05-22 21:40:00","snet_input_date":"2024-05-22 00:00:00","source_office":"2ALS001","mcmis_add_date":"2024-05-22 21:40:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"109972","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:17:55.000000Z","updated_at":"2025-03-17T20:17:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9369580,"change_date":"2024-05-22 21:40:00","inspection_id":"81684622","insp_unit_id":"201033475","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"CALS-133695","insp_unit_license":"2488585","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4MC9EG9FN923855","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:16.000000Z","updated_at":"2025-03-17T23:20:16.000000Z"}]},{"id":5790465,"change_date":"2024-05-24 21:38:00","inspection_id":"81654782","dot_number":"792056","report_state":"AL","report_number":"NSXA006770","insp_date":"2024-05-20 00:00:00","insp_start_time":"0420","insp_end_time":"0507","registration_date":"2024-05-22 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"AL","county_code":"117","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SYSCO","shipping_paper_number":"0555800","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":"2024-05-20 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"102700","viol_total":"4","oos_total":"2","driver_viol_total":"3","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1005910","transaction_code":"C","transaction_date":"2024-05-20 00:00:00","upload_date":"2024-05-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2024-05-20 21:42:00","snet_input_date":"2024-05-20 00:00:00","source_office":"2ALS001","mcmis_add_date":"2024-05-20 21:42:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"109972","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:17:30.000000Z","updated_at":"2025-03-17T20:17:30.000000Z","inspection_violations":[{"id":8967985,"change_date":"2024-05-24 21:38:00","inspection_id":"81654782","insp_violation_id":"259711930","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:22.000000Z","updated_at":"2025-03-17T21:49:22.000000Z","normalized_code":"3922"},{"id":8967986,"change_date":"2024-05-24 21:38:00","inspection_id":"81654782","insp_violation_id":"259711931","seq_no":"2","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:49:22.000000Z","updated_at":"2025-03-17T21:49:22.000000Z","normalized_code":"38323A2"},{"id":8967987,"change_date":"2024-05-24 21:38:00","inspection_id":"81654782","insp_violation_id":"259711932","seq_no":"3","part_no":"383","part_no_section":"71(h)","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:49:22.000000Z","updated_at":"2025-03-17T21:49:22.000000Z","normalized_code":"38371H"},{"id":8967988,"change_date":"2024-05-24 21:38:00","inspection_id":"81654782","insp_violation_id":"259711933","seq_no":"4","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"201069004","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:49:22.000000Z","updated_at":"2025-03-17T21:49:22.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":9326155,"change_date":"2024-05-24 21:38:00","inspection_id":"81654782","insp_unit_id":"201069003","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"148065","insp_unit_license":"2165024","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKBHTDV1RDVJ0217","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:50.000000Z","updated_at":"2025-03-17T23:19:50.000000Z"},{"id":9326156,"change_date":"2024-05-24 21:38:00","inspection_id":"81654782","insp_unit_id":"201069004","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"203702","insp_unit_license":"P962453","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA96277S701802","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:50.000000Z","updated_at":"2025-03-17T23:19:50.000000Z"}]},{"id":5718092,"change_date":"2024-05-24 21:38:00","inspection_id":"81576422","dot_number":"792056","report_state":"AL","report_number":"1035000277","insp_date":"2024-05-10 00:00:00","insp_start_time":"1115","insp_end_time":"1137","registration_date":"2024-05-22 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"AL5","county_code_state":"AL","county_code":"131","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SYSCO","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-10 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"73700","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":"1004606","transaction_code":"C","transaction_date":"2024-05-10 00:00:00","upload_date":"2024-05-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2024-05-10 21:38:00","snet_input_date":"2024-05-10 00:00:00","source_office":"2ALS001","mcmis_add_date":"2024-05-10 21:38:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"109972","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:15:56.000000Z","updated_at":"2025-03-17T20:15:56.000000Z","inspection_violations":[{"id":8847740,"change_date":"2024-05-24 21:38:00","inspection_id":"81576422","insp_violation_id":"259711708","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"201068844","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:49.000000Z","updated_at":"2025-03-17T21:48:49.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":9209764,"change_date":"2024-05-24 21:38:00","inspection_id":"81576422","insp_unit_id":"201068843","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"2241248","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUBGBDV0GLHB3339","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:41.000000Z","updated_at":"2025-03-17T23:18:41.000000Z"},{"id":9209765,"change_date":"2024-05-24 21:38:00","inspection_id":"81576422","insp_unit_id":"201068844","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"P744457","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA5616KE131931","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:41.000000Z","updated_at":"2025-03-17T23:18:41.000000Z"}]},{"id":5424029,"change_date":"2024-04-03 21:41:00","inspection_id":"81255927","dot_number":"792056","report_state":"AL","report_number":"DBCV003091","insp_date":"2024-04-03 00:00:00","insp_start_time":"0931","insp_end_time":"0955","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"AL","county_code":"117","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-03 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"32000","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":"998896","transaction_code":"A","transaction_date":"2024-04-03 00:00:00","upload_date":"2024-04-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2024-04-03 21:41:00","snet_input_date":"2024-04-03 00:00:00","source_office":"2ALS001","mcmis_add_date":"2024-04-03 21:41:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"109972","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:10:15.000000Z","updated_at":"2025-03-17T20:10:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8736570,"change_date":"2024-04-03 21:41:00","inspection_id":"81255927","insp_unit_id":"200213025","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"CALB_132020","insp_unit_license":"2028228","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4M39DG2EN149531","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:16.000000Z","updated_at":"2025-03-17T23:14:16.000000Z"}]},{"id":5404862,"change_date":"2024-04-12 21:39:00","inspection_id":"81234744","dot_number":"792056","report_state":"AL","report_number":"1440001693","insp_date":"2024-03-30 00:00:00","insp_start_time":"0640","insp_end_time":"0710","registration_date":"2024-04-10 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"AL","county_code":"009","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SAME AS CARRIER","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-31 21:32:00","post_acc_ind":"N","gross_comb_veh_wt":"73700","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"998340","transaction_code":"C","transaction_date":"2024-04-12 00:00:00","upload_date":"2024-04-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2024-03-31 21:32:00","snet_input_date":"2024-03-30 00:00:00","source_office":"2ALS001","mcmis_add_date":"2024-03-31 21:32:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"109972","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:09:50.000000Z","updated_at":"2025-03-17T20:09:50.000000Z","inspection_violations":[{"id":8341607,"change_date":"2024-04-12 21:39:00","inspection_id":"81234744","insp_violation_id":"258898846","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200369115","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:24.000000Z","updated_at":"2025-03-17T21:46:24.000000Z","normalized_code":"3939A"},{"id":8341608,"change_date":"2024-04-12 21:39:00","inspection_id":"81234744","insp_violation_id":"258898847","seq_no":"2","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"200369116","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:24.000000Z","updated_at":"2025-03-17T21:46:24.000000Z","normalized_code":"39355E"}],"inspection_per_units":[{"id":8704957,"change_date":"2024-04-12 21:39:00","inspection_id":"81234744","insp_unit_id":"200369115","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"136327","insp_unit_license":"2488525","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4M39EG9HN991172","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:57.000000Z","updated_at":"2025-03-17T23:13:57.000000Z"},{"id":8704958,"change_date":"2024-04-12 21:39:00","inspection_id":"81234744","insp_unit_id":"200369116","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"229514","insp_unit_license":"PD71130","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA5613FB700675","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:57.000000Z","updated_at":"2025-03-17T23:13:57.000000Z"}]},{"id":5303943,"change_date":"2024-03-22 21:39:00","inspection_id":"81124934","dot_number":"792056","report_state":"AL","report_number":"1299002992","insp_date":"2024-03-18 00:00:00","insp_start_time":"0502","insp_end_time":"0529","registration_date":"2024-03-22 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"AL","county_code":"117","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SYSCO","shipping_paper_number":"S2KOBLOWNR","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-18 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"75000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"996347","transaction_code":"C","transaction_date":"2024-03-18 00:00:00","upload_date":"2024-03-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2024-03-18 21:38:00","snet_input_date":"2024-03-18 00:00:00","source_office":"2ALS001","mcmis_add_date":"2024-03-18 21:38:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"109972","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:07:52.000000Z","updated_at":"2025-03-17T20:07:52.000000Z","inspection_violations":[{"id":8180814,"change_date":"2024-03-22 21:39:00","inspection_id":"81124934","insp_violation_id":"258535147","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"200043974","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:34.000000Z","updated_at":"2025-03-17T21:45:34.000000Z","normalized_code":"39378"},{"id":8180815,"change_date":"2024-03-22 21:39:00","inspection_id":"81124934","insp_violation_id":"258535148","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"200043975","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:45:34.000000Z","updated_at":"2025-03-17T21:45:34.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":8541644,"change_date":"2024-03-22 21:39:00","inspection_id":"81124934","insp_unit_id":"200043974","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"2028228","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4M39DG2EN149531","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:25.000000Z","updated_at":"2025-03-17T23:12:25.000000Z"},{"id":8541645,"change_date":"2024-03-22 21:39:00","inspection_id":"81124934","insp_unit_id":"200043975","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HACK","insp_unit_company":null,"insp_unit_license":"PD71405","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"526162811P5000658","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:25.000000Z","updated_at":"2025-03-17T23:12:25.000000Z"}]},{"id":4996392,"change_date":"2024-02-07 21:41:00","inspection_id":"80789372","dot_number":"792056","report_state":"AL","report_number":"JWCV001102","insp_date":"2024-02-07 00:00:00","insp_start_time":"0810","insp_end_time":"0843","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"CALERA","county_code_state":"AL","county_code":"117","insp_level_id":"2","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"NA","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-07 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":"991057","transaction_code":"A","transaction_date":"2024-02-07 00:00:00","upload_date":"2024-02-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2024-02-07 21:41:00","snet_input_date":"2024-02-07 00:00:00","source_office":"2ALS001","mcmis_add_date":"2024-02-07 21:41:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:01:40.000000Z","updated_at":"2025-03-17T20:01:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8041727,"change_date":"2024-02-07 21:41:00","inspection_id":"80789372","insp_unit_id":"199308343","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"135877","insp_unit_license":"2488250","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4M39EG0HNN98371","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:53.000000Z","updated_at":"2025-03-17T23:07:53.000000Z"}]},{"id":4996393,"change_date":"2024-03-04 21:41:00","inspection_id":"80789373","dot_number":"792056","report_state":"AL","report_number":"JWCV001103","insp_date":"2024-02-07 00:00:00","insp_start_time":"0846","insp_end_time":"0903","registration_date":"2024-02-29 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"CALERA","county_code_state":"AL","county_code":"117","insp_level_id":"2","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"NA","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"95000","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":"991069","transaction_code":"C","transaction_date":"2024-03-04 00:00:00","upload_date":"2024-03-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2024-02-07 21:41:00","snet_input_date":"2024-02-07 00:00:00","source_office":"2ALS001","mcmis_add_date":"2024-02-07 21:41:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:01:40.000000Z","updated_at":"2025-03-17T20:01:40.000000Z","inspection_violations":[{"id":7696134,"change_date":"2024-03-04 21:41:00","inspection_id":"80789373","insp_violation_id":"258183259","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"199734461","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:08.000000Z","updated_at":"2025-03-17T21:43:08.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":8041728,"change_date":"2024-03-04 21:41:00","inspection_id":"80789373","insp_unit_id":"199734460","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"135877","insp_unit_license":"1191613","insp_unit_license_state":"AL","insp_unit_vehicle_id_number":"4V4WC9EH0PN612821","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:53.000000Z","updated_at":"2025-03-17T23:07:53.000000Z"},{"id":8041729,"change_date":"2024-03-04 21:41:00","inspection_id":"80789373","insp_unit_id":"199734461","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":"254065","insp_unit_license":"64A1CD9","insp_unit_license_state":"AL","insp_unit_vehicle_id_number":"52616281XP5000657","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:53.000000Z","updated_at":"2025-03-17T23:07:53.000000Z"}]},{"id":4917912,"change_date":"2024-01-29 21:39:00","inspection_id":"80703372","dot_number":"792056","report_state":"AL","report_number":"1299002891","insp_date":"2024-01-29 00:00:00","insp_start_time":"0420","insp_end_time":"0445","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"RO","county_code_state":"AL","county_code":"117","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SYSCO","shipping_paper_number":"1247","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-01-29 21:39: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":"989305","transaction_code":"A","transaction_date":"2024-01-29 00:00:00","upload_date":"2024-01-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2024-01-29 21:39:00","snet_input_date":"2024-01-29 00:00:00","source_office":"2ALS001","mcmis_add_date":"2024-01-29 21:39:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:00:05.000000Z","updated_at":"2025-03-17T20:00:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7913682,"change_date":"2024-01-29 21:39:00","inspection_id":"80703372","insp_unit_id":"199142793","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"145006","insp_unit_license":"2962652","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHTDV4PDUP2054","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:44.000000Z","updated_at":"2025-03-17T23:06:44.000000Z"},{"id":7913683,"change_date":"2024-01-29 21:39:00","inspection_id":"80703372","insp_unit_id":"199142794","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":null,"insp_unit_license":"PD71191","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V422KK1RJ10304","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:44.000000Z","updated_at":"2025-03-17T23:06:44.000000Z"}]},{"id":4742739,"change_date":"2024-01-02 21:43:00","inspection_id":"80511898","dot_number":"792056","report_state":"AL","report_number":"SCHP007943","insp_date":"2024-01-02 00:00:00","insp_start_time":"1200","insp_end_time":"1225","registration_date":null,"region":"CT","ci_status_code":"C","location":"50","location_desc":"ROADSIDE","county_code_state":"AL","county_code":"095","insp_level_id":"3","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"SYSCO","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-02 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":"986467","transaction_code":"A","transaction_date":"2024-01-02 00:00:00","upload_date":"2024-01-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2024-01-02 21:43:00","snet_input_date":"2024-01-02 00:00:00","source_office":"2ALS001","mcmis_add_date":"2024-01-02 21:43:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:56:51.000000Z","updated_at":"2025-03-17T19:56:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7628918,"change_date":"2024-01-02 21:43:00","inspection_id":"80511898","insp_unit_id":"198761187","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"2561635","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4W39EG4KN208792","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:11.000000Z","updated_at":"2025-03-17T23:04:11.000000Z"},{"id":7628919,"change_date":"2024-01-02 21:43:00","inspection_id":"80511898","insp_unit_id":"198761188","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":null,"insp_unit_license":null,"insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V281C1KT532003","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:11.000000Z","updated_at":"2025-03-17T23:04:11.000000Z"}]},{"id":4371339,"change_date":"2023-11-07 21:40:00","inspection_id":"80104217","dot_number":"792056","report_state":"AL","report_number":"RCCV001101","insp_date":"2023-11-07 00:00:00","insp_start_time":"1310","insp_end_time":"1336","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"AL","county_code":"125","insp_level_id":"3","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"NA","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-11-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"91000","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":"981887","transaction_code":"A","transaction_date":"2023-11-07 00:00:00","upload_date":"2023-11-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2023-11-07 21:40:00","snet_input_date":"2023-11-07 00:00:00","source_office":"2ALS001","mcmis_add_date":"2023-11-07 21:40:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:49:32.000000Z","updated_at":"2025-03-17T19:49:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7030121,"change_date":"2023-11-07 21:40:00","inspection_id":"80104217","insp_unit_id":"197942344","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"129556","insp_unit_license":"2962659","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUBGBDV1CSBL4882","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:01.000000Z","updated_at":"2025-03-17T22:59:01.000000Z"},{"id":7030122,"change_date":"2023-11-07 21:40:00","inspection_id":"80104217","insp_unit_id":"197942345","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"42001915","insp_unit_license":"P812596","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA5611GE702118","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:01.000000Z","updated_at":"2025-03-17T22:59:01.000000Z"}]},{"id":4330674,"change_date":"2023-11-20 21:40:00","inspection_id":"80059056","dot_number":"792056","report_state":"AL","report_number":"NSXA006446","insp_date":"2023-11-01 00:00:00","insp_start_time":"0438","insp_end_time":"0508","registration_date":"2023-11-20 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"ROAD SIDE","county_code_state":"AL","county_code":"117","insp_level_id":"2","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"SYSCO CENTRAL ALABAMA INC","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-11-01 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"103000","viol_total":"6","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"981015","transaction_code":"C","transaction_date":"2023-11-01 00:00:00","upload_date":"2023-11-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2023-11-01 21:43:00","snet_input_date":"2023-11-01 00:00:00","source_office":"2ALS001","mcmis_add_date":"2023-11-01 21:43:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:48:44.000000Z","updated_at":"2025-03-17T19:48:44.000000Z","inspection_violations":[{"id":6698714,"change_date":"2023-11-20 21:40:00","inspection_id":"80059056","insp_violation_id":"256483160","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:13.000000Z","updated_at":"2025-03-17T21:38:13.000000Z","normalized_code":"38323A2"},{"id":6698715,"change_date":"2023-11-20 21:40:00","inspection_id":"80059056","insp_violation_id":"256483161","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"198138712","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:13.000000Z","updated_at":"2025-03-17T21:38:13.000000Z","normalized_code":"39378"},{"id":6698716,"change_date":"2023-11-20 21:40:00","inspection_id":"80059056","insp_violation_id":"256483162","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"198138713","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:13.000000Z","updated_at":"2025-03-17T21:38:13.000000Z","normalized_code":"3939A"},{"id":6698717,"change_date":"2023-11-20 21:40:00","inspection_id":"80059056","insp_violation_id":"256483163","seq_no":"4","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"198138713","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:13.000000Z","updated_at":"2025-03-17T21:38:13.000000Z","normalized_code":"39355E"},{"id":6698718,"change_date":"2023-11-20 21:40:00","inspection_id":"80059056","insp_violation_id":"256483164","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"198138713","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:13.000000Z","updated_at":"2025-03-17T21:38:13.000000Z","normalized_code":"3939A"},{"id":6698719,"change_date":"2023-11-20 21:40:00","inspection_id":"80059056","insp_violation_id":"256483165","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"198138713","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:13.000000Z","updated_at":"2025-03-17T21:38:13.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":6964408,"change_date":"2023-11-20 21:40:00","inspection_id":"80059056","insp_unit_id":"198138712","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"3539813","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4M39DG9DN144972","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:27.000000Z","updated_at":"2025-03-17T22:58:27.000000Z"},{"id":6964409,"change_date":"2023-11-20 21:40:00","inspection_id":"80059056","insp_unit_id":"198138713","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"246069","insp_unit_license":"P668338","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA7624JE701296","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:27.000000Z","updated_at":"2025-03-17T22:58:27.000000Z"}]},{"id":4280855,"change_date":"2023-10-25 21:41:00","inspection_id":"80003949","dot_number":"792056","report_state":"AL","report_number":"MCMP003191","insp_date":"2023-10-25 00:00:00","insp_start_time":"1405","insp_end_time":"1425","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"AL","county_code":"051","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SYSCO CENTRAL ALABAMA INC","shipping_paper_number":"346596460","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"979738","transaction_code":"A","transaction_date":"2023-10-25 00:00:00","upload_date":"2023-10-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2023-10-25 21:41:00","snet_input_date":"2023-10-25 00:00:00","source_office":"2ALS001","mcmis_add_date":"2023-10-25 21:41:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:47:49.000000Z","updated_at":"2025-03-17T19:47:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6884547,"change_date":"2023-10-25 21:41:00","inspection_id":"80003949","insp_unit_id":"197737914","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"133695","insp_unit_license":"2488585","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4MC9EC2FN923855","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:43.000000Z","updated_at":"2025-03-17T22:57:43.000000Z"},{"id":6884548,"change_date":"2023-10-25 21:41:00","inspection_id":"80003949","insp_unit_id":"197737915","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"250618","insp_unit_license":"P945652","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GR1A7620LE218083","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:43.000000Z","updated_at":"2025-03-17T22:57:43.000000Z"}]},{"id":4244671,"change_date":"2023-10-27 21:42:00","inspection_id":"79963717","dot_number":"792056","report_state":"AL","report_number":"BCCV008699","insp_date":"2023-10-20 00:00:00","insp_start_time":"0939","insp_end_time":"1008","registration_date":"2023-10-27 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"AL","county_code":"043","insp_level_id":"3","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"SYSCO CENTRAL ALABAMA INC","shipping_paper_number":"346591025","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-10-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"101000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"978928","transaction_code":"C","transaction_date":"2023-10-20 00:00:00","upload_date":"2023-10-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2023-10-20 21:40:00","snet_input_date":"2023-10-20 00:00:00","source_office":"2ALS001","mcmis_add_date":"2023-10-20 21:40:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:47:02.000000Z","updated_at":"2025-03-17T19:47:02.000000Z","inspection_violations":[{"id":6572879,"change_date":"2023-10-27 21:42:00","inspection_id":"79963717","insp_violation_id":"256083282","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:40.000000Z","updated_at":"2025-03-17T21:37:40.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":6825933,"change_date":"2023-10-27 21:42:00","inspection_id":"79963717","insp_unit_id":"197779920","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"129909","insp_unit_license":"2962662","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUBGBDV6DLBR7052","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:13.000000Z","updated_at":"2025-03-17T22:57:13.000000Z"},{"id":6825934,"change_date":"2023-10-27 21:42:00","inspection_id":"79963717","insp_unit_id":"197779921","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"229714","insp_unit_license":"P281801","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA7621EB704292","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:13.000000Z","updated_at":"2025-03-17T22:57:13.000000Z"}]},{"id":4201112,"change_date":"2023-11-07 21:40:00","inspection_id":"79915781","dot_number":"792056","report_state":"AL","report_number":"MCMP003131","insp_date":"2023-10-16 00:00:00","insp_start_time":"1045","insp_end_time":"1135","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"AL","county_code":"101","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SYSCO CENTRAL ALABAMA INC","shipping_paper_number":"346586828","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-16 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"77700","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"977867","transaction_code":"C","transaction_date":"2023-11-07 00:00:00","upload_date":"2023-11-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2023-10-16 21:42:00","snet_input_date":"2023-10-16 00:00:00","source_office":"2ALS001","mcmis_add_date":"2023-10-16 21:42:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:46:12.000000Z","updated_at":"2025-03-17T19:46:12.000000Z","inspection_violations":[{"id":6506091,"change_date":"2023-11-07 21:40:00","inspection_id":"79915781","insp_violation_id":"256260679","seq_no":"1","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"197942387","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:23.000000Z","updated_at":"2025-03-17T21:37:23.000000Z","normalized_code":"39395F"},{"id":6506092,"change_date":"2023-11-07 21:40:00","inspection_id":"79915781","insp_violation_id":"256260680","seq_no":"2","part_no":"393","part_no_section":"205(c)","insp_viol_unit":"1","insp_unit_id":"197942387","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:23.000000Z","updated_at":"2025-03-17T21:37:23.000000Z","normalized_code":"393205C"}],"inspection_per_units":[{"id":6755994,"change_date":"2023-11-07 21:40:00","inspection_id":"79915781","insp_unit_id":"197942387","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"136330","insp_unit_license":"2488535","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4M39EG4HN991175","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:39.000000Z","updated_at":"2025-03-17T22:56:39.000000Z"},{"id":6755995,"change_date":"2023-11-07 21:40:00","inspection_id":"79915781","insp_unit_id":"197942388","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HACK","insp_unit_company":"254065","insp_unit_license":"PD71404","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"52616281XP5000657","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:39.000000Z","updated_at":"2025-03-17T22:56:39.000000Z"}]},{"id":4170931,"change_date":"2023-10-17 21:41:00","inspection_id":"79882470","dot_number":"792056","report_state":"AL","report_number":"JSBH007351","insp_date":"2023-10-11 00:00:00","insp_start_time":"0625","insp_end_time":"0655","registration_date":"2023-10-17 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"AL","county_code":"117","insp_level_id":"2","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"SYSCO INC.","shipping_paper_number":"0539632","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-10-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"977125","transaction_code":"C","transaction_date":"2023-10-11 00:00:00","upload_date":"2023-10-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2023-10-11 21:40:00","snet_input_date":"2023-10-11 00:00:00","source_office":"2ALS001","mcmis_add_date":"2023-10-11 21:40:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:45:28.000000Z","updated_at":"2025-03-17T19:45:28.000000Z","inspection_violations":[{"id":6456322,"change_date":"2023-10-17 21:41:00","inspection_id":"79882470","insp_violation_id":"255876176","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197590591","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:06.000000Z","updated_at":"2025-03-17T21:37:06.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":6706866,"change_date":"2023-10-17 21:41:00","inspection_id":"79882470","insp_unit_id":"197590591","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"129556","insp_unit_license":"2962659","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUBGBDV1CSBL4882","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:14.000000Z","updated_at":"2025-03-17T22:56:14.000000Z"},{"id":6706867,"change_date":"2023-10-17 21:41:00","inspection_id":"79882470","insp_unit_id":"197590592","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"250616","insp_unit_license":"P945650","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GR1A7627LE218081","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:14.000000Z","updated_at":"2025-03-17T22:56:14.000000Z"}]},{"id":3922054,"change_date":"2023-09-07 21:40:00","inspection_id":"79606139","dot_number":"792056","report_state":"AL","report_number":"BSCV002406","insp_date":"2023-09-07 00:00:00","insp_start_time":"0505","insp_end_time":"0530","registration_date":null,"region":"CT","ci_status_code":"C","location":"58","location_desc":"INTERSTATE","county_code_state":"AL","county_code":"117","insp_level_id":"2","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"SYSCO CENTRAL ALABAMA INC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-09-07 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":"971210","transaction_code":"A","transaction_date":"2023-09-07 00:00:00","upload_date":"2023-09-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2023-09-07 21:40:00","snet_input_date":"2023-09-07 00:00:00","source_office":"2ALS001","mcmis_add_date":"2023-09-07 21:40:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:40:25.000000Z","updated_at":"2025-03-17T19:40:25.000000Z","inspection_violations":[{"id":6062496,"change_date":"2023-09-07 21:40:00","inspection_id":"79606139","insp_violation_id":"255130754","seq_no":"1","part_no":"383","part_no_section":"71(h)","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:35:21.000000Z","updated_at":"2025-03-17T21:35:21.000000Z","normalized_code":"38371H"}],"inspection_per_units":[{"id":6306333,"change_date":"2023-09-07 21:40:00","inspection_id":"79606139","insp_unit_id":"196939514","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"145275","insp_unit_license":"3431919","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKBHTDV7PDUG7835","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:59.000000Z","updated_at":"2025-03-17T22:52:59.000000Z"},{"id":6306334,"change_date":"2023-09-07 21:40:00","inspection_id":"79606139","insp_unit_id":"196939515","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"PD71406","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"526162813P5000659","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:59.000000Z","updated_at":"2025-03-17T22:52:59.000000Z"}]},{"id":3830613,"change_date":"2023-08-25 21:41:00","inspection_id":"79504079","dot_number":"792056","report_state":"AL","report_number":"SBAB002556","insp_date":"2023-08-25 00:00:00","insp_start_time":"1322","insp_end_time":"1406","registration_date":null,"region":"CT","ci_status_code":"C","location":"11","location_desc":"ROADSIDE","county_code_state":"AL","county_code":"015","insp_level_id":"2","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"SYSCO","shipping_paper_number":"ROUTE#5367","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-08-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"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":"969196","transaction_code":"A","transaction_date":"2023-08-25 00:00:00","upload_date":"2023-08-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2023-08-25 21:41:00","snet_input_date":"2023-08-25 00:00:00","source_office":"2ALS001","mcmis_add_date":"2023-08-25 21:41:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:38:31.000000Z","updated_at":"2025-03-17T19:38:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6158634,"change_date":"2023-08-25 21:41:00","inspection_id":"79504079","insp_unit_id":"196726614","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"143542","insp_unit_license":"3283407","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN3AYXPM003275","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:44.000000Z","updated_at":"2025-03-17T22:51:44.000000Z"},{"id":6158635,"change_date":"2023-08-25 21:41:00","inspection_id":"79504079","insp_unit_id":"196726615","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"242668","insp_unit_license":"P380059","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA5618FE701949","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:44.000000Z","updated_at":"2025-03-17T22:51:44.000000Z"}]},{"id":3702614,"change_date":"2023-08-09 21:42:00","inspection_id":"79361316","dot_number":"792056","report_state":"AL","report_number":"BWJW007253","insp_date":"2023-08-09 00:00:00","insp_start_time":"0903","insp_end_time":"0927","registration_date":null,"region":"CT","ci_status_code":"C","location":"I065","location_desc":"ROADSIDE","county_code_state":"AL","county_code":"051","insp_level_id":"3","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-08-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"102000","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":"965855","transaction_code":"A","transaction_date":"2023-08-09 00:00:00","upload_date":"2023-08-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2023-08-09 21:42:00","snet_input_date":"2023-08-09 00:00:00","source_office":"2ALS001","mcmis_add_date":"2023-08-09 21:42:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:36:05.000000Z","updated_at":"2025-03-17T19:36:05.000000Z","inspection_violations":[{"id":5710267,"change_date":"2023-08-09 21:42:00","inspection_id":"79361316","insp_violation_id":"254550984","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"W004582","created_at":"2025-03-17T21:33:27.000000Z","updated_at":"2025-03-17T21:33:27.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5953079,"change_date":"2023-08-09 21:42:00","inspection_id":"79361316","insp_unit_id":"196438260","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"141184","insp_unit_license":"2779576","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN2AY4LM002028","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:02.000000Z","updated_at":"2025-03-17T22:50:02.000000Z"},{"id":5953080,"change_date":"2023-08-09 21:42:00","inspection_id":"79361316","insp_unit_id":"196438261","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"229715","insp_unit_license":"P281800","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA762XEB704291","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:02.000000Z","updated_at":"2025-03-17T22:50:02.000000Z"}]},{"id":3682817,"change_date":"2023-08-07 21:41:00","inspection_id":"79339301","dot_number":"792056","report_state":"AL","report_number":"BSCV002237","insp_date":"2023-08-07 00:00:00","insp_start_time":"0405","insp_end_time":"0435","registration_date":null,"region":"CT","ci_status_code":"C","location":"58","location_desc":"INTERSTATE","county_code_state":"AL","county_code":"117","insp_level_id":"2","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-08-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"34700","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"965320","transaction_code":"A","transaction_date":"2023-08-07 00:00:00","upload_date":"2023-08-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2023-08-07 21:41:00","snet_input_date":"2023-08-07 00:00:00","source_office":"2ALS001","mcmis_add_date":"2023-08-07 21:41:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:35:39.000000Z","updated_at":"2025-03-17T19:35:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5920905,"change_date":"2023-08-07 21:41:00","inspection_id":"79339301","insp_unit_id":"196391349","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"135877","insp_unit_license":"2488250","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4M39EG0HN983719","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:47.000000Z","updated_at":"2025-03-17T22:49:47.000000Z"}]},{"id":3606496,"change_date":"2023-07-27 21:40:00","inspection_id":"79253534","dot_number":"792056","report_state":"AL","report_number":"JWCV001061","insp_date":"2023-07-27 00:00:00","insp_start_time":"0740","insp_end_time":"0805","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"CALERA","county_code_state":"AL","county_code":"117","insp_level_id":"2","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"NA","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"53400","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":"963630","transaction_code":"A","transaction_date":"2023-07-27 00:00:00","upload_date":"2023-07-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2023-07-27 21:40:00","snet_input_date":"2023-07-27 00:00:00","source_office":"2ALS001","mcmis_add_date":"2023-07-27 21:40:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:34:12.000000Z","updated_at":"2025-03-17T19:34:12.000000Z","inspection_violations":[{"id":5561512,"change_date":"2023-07-27 21:40:00","inspection_id":"79253534","insp_violation_id":"254310090","seq_no":"1","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"196221068","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:48.000000Z","updated_at":"2025-03-17T21:32:48.000000Z","normalized_code":"39395F"}],"inspection_per_units":[{"id":5798458,"change_date":"2023-07-27 21:40:00","inspection_id":"79253534","insp_unit_id":"196221068","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"649444","insp_unit_license":"3156834","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HSDJAPR4FN685149","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:46.000000Z","updated_at":"2025-03-17T22:48:46.000000Z"}]},{"id":3606517,"change_date":"2023-08-10 21:41:00","inspection_id":"79253555","dot_number":"792056","report_state":"AL","report_number":"JWCV001060","insp_date":"2023-07-27 00:00:00","insp_start_time":"0708","insp_end_time":"0734","registration_date":"2023-08-10 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"CALERA","county_code_state":"AL","county_code":"117","insp_level_id":"2","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"SYSCO","shipping_paper_number":"053882","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-07-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"963661","transaction_code":"C","transaction_date":"2023-07-27 00:00:00","upload_date":"2023-08-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2023-07-27 21:40:00","snet_input_date":"2023-07-27 00:00:00","source_office":"2ALS001","mcmis_add_date":"2023-07-27 21:40:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:34:12.000000Z","updated_at":"2025-03-17T19:34:12.000000Z","inspection_violations":[{"id":5561537,"change_date":"2023-08-10 21:41:00","inspection_id":"79253555","insp_violation_id":"254575068","seq_no":"1","part_no":"393","part_no_section":"28","insp_viol_unit":"1","insp_unit_id":"196461474","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:48.000000Z","updated_at":"2025-03-17T21:32:48.000000Z","normalized_code":"39328"},{"id":5561538,"change_date":"2023-08-10 21:41:00","inspection_id":"79253555","insp_violation_id":"254575069","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"196461474","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:48.000000Z","updated_at":"2025-03-17T21:32:48.000000Z","normalized_code":"39378"}],"inspection_per_units":[{"id":5798492,"change_date":"2023-08-10 21:41:00","inspection_id":"79253555","insp_unit_id":"196461474","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"129910","insp_unit_license":"2962663","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUBGBDV8DLBR7053","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:46.000000Z","updated_at":"2025-03-17T22:48:46.000000Z"},{"id":5798493,"change_date":"2023-08-10 21:41:00","inspection_id":"79253555","insp_unit_id":"196461475","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"343772","insp_unit_license":"PB24798","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA7627GE702130","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:46.000000Z","updated_at":"2025-03-17T22:48:46.000000Z"}]},{"id":3340705,"change_date":"2023-07-05 21:41:00","inspection_id":"78955062","dot_number":"792056","report_state":"AL","report_number":"BWJW007095","insp_date":"2023-06-22 00:00:00","insp_start_time":"1327","insp_end_time":"1405","registration_date":"2023-07-05 00:00:00","region":"CT","ci_status_code":"C","location":"S147","location_desc":"PARKING LOT","county_code_state":"AL","county_code":"081","insp_level_id":"1","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"STAYBRIDGE SUITES","shipping_paper_number":"531478","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-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"74700","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"957850","transaction_code":"C","transaction_date":"2023-06-22 00:00:00","upload_date":"2023-07-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2023-06-22 21:41:00","snet_input_date":"2023-06-22 00:00:00","source_office":"2ALS001","mcmis_add_date":"2023-06-22 21:41:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","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":[{"id":5151319,"change_date":"2023-07-05 21:41:00","inspection_id":"78955062","insp_violation_id":"253860252","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"195818109","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:55.000000Z","updated_at":"2025-03-17T21:30:55.000000Z","normalized_code":"39395A"},{"id":5151320,"change_date":"2023-07-05 21:41:00","inspection_id":"78955062","insp_violation_id":"253860253","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"195818110","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:30:55.000000Z","updated_at":"2025-03-17T21:30:55.000000Z","normalized_code":"3939A"},{"id":5151321,"change_date":"2023-07-05 21:41:00","inspection_id":"78955062","insp_violation_id":"253860254","seq_no":"3","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"195818110","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:55.000000Z","updated_at":"2025-03-17T21:30:55.000000Z","normalized_code":"39355E"},{"id":5151322,"change_date":"2023-07-05 21:41:00","inspection_id":"78955062","insp_violation_id":"253860255","seq_no":"4","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"2","insp_unit_id":"195818110","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:55.000000Z","updated_at":"2025-03-17T21:30:55.000000Z","normalized_code":"39345D"}],"inspection_per_units":[{"id":5370520,"change_date":"2023-07-05 21:41:00","inspection_id":"78955062","insp_unit_id":"195818109","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"141270","insp_unit_license":"2962527","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN2AY6LM002113","insp_unit_decal":"Y","insp_unit_decal_number":"32750417","created_at":"2025-03-17T22:45:22.000000Z","updated_at":"2025-03-17T22:45:22.000000Z"},{"id":5370521,"change_date":"2023-07-05 21:41:00","inspection_id":"78955062","insp_unit_id":"195818110","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"203655","insp_unit_license":"P962435","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA561X8S702251","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":3189585,"change_date":"2023-06-01 21:42:00","inspection_id":"78784551","dot_number":"792056","report_state":"AL","report_number":"BSCV002002","insp_date":"2023-05-30 00:00:00","insp_start_time":"0620","insp_end_time":"0640","registration_date":null,"region":"CT","ci_status_code":"C","location":"58","location_desc":"INTERSTATE","county_code_state":"AL","county_code":"117","insp_level_id":"3","service_center":"SH","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":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-06-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"89000","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":"955288","transaction_code":"A","transaction_date":"2023-05-30 00:00:00","upload_date":"2023-06-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2023-06-01 21:42:00","snet_input_date":"2023-06-01 00:00:00","source_office":"2ALS001","mcmis_add_date":"2023-06-01 21:42:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:26:06.000000Z","updated_at":"2025-03-17T19:26:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5129981,"change_date":"2023-06-01 21:42:00","inspection_id":"78784551","insp_unit_id":"195250635","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"102917","insp_unit_license":"2962653","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4MC9GF37N479913","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:24.000000Z","updated_at":"2025-03-17T22:43:24.000000Z"},{"id":5129982,"change_date":"2023-06-01 21:42:00","inspection_id":"78784551","insp_unit_id":"195250636","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"246917","insp_unit_license":"P744500","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA561XKE131933","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:24.000000Z","updated_at":"2025-03-17T22:43:24.000000Z"}]},{"id":2557264,"change_date":"2023-03-12 21:30:00","inspection_id":"78067765","dot_number":"792056","report_state":"AL","report_number":"JWCV000986","insp_date":"2023-03-11 00:00:00","insp_start_time":"0654","insp_end_time":"0718","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"CALERA","county_code_state":"AL","county_code":"117","insp_level_id":"2","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"SYSCO","shipping_paper_number":"0524158","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-12 21:30: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":"945361","transaction_code":"A","transaction_date":"2023-03-11 00:00:00","upload_date":"2023-03-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2023-03-12 21:30:00","snet_input_date":"2023-03-11 00:00:00","source_office":"2ALS001","mcmis_add_date":"2023-03-12 21:30:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:13:44.000000Z","updated_at":"2025-03-17T19:13:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4116076,"change_date":"2023-03-12 21:30:00","inspection_id":"78067765","insp_unit_id":"193823558","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"132877","insp_unit_license":"2165012","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4M39DG2EN173375","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:31.000000Z","updated_at":"2025-03-17T22:35:31.000000Z"},{"id":4116077,"change_date":"2023-03-12 21:30:00","inspection_id":"78067765","insp_unit_id":"193823559","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"246913","insp_unit_license":"P744455","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA5618KE131929","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:31.000000Z","updated_at":"2025-03-17T22:35:31.000000Z"}]},{"id":2560701,"change_date":"2023-03-13 21:42:00","inspection_id":"78071749","dot_number":"792056","report_state":"FL","report_number":"2750004817","insp_date":"2023-03-09 00:00:00","insp_start_time":"1252","insp_end_time":"1300","registration_date":null,"region":"CT","ci_status_code":"C","location":"101W","location_desc":"I10 SNEADS WIM-WEST","county_code_state":"FL","county_code":"063","insp_level_id":"3","service_center":"SH","census_source_id":"4","insp_facility":"F","shipper_name":"SAC","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-03-13 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":"2488234","transaction_code":"A","transaction_date":"2023-03-09 00:00:00","upload_date":"2023-03-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2023-03-13 21:42:00","snet_input_date":"2023-03-13 00:00:00","source_office":"2FLS001","mcmis_add_date":"2023-03-13 21:42:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:14:02.000000Z","updated_at":"2025-03-17T19:14:02.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4121039,"change_date":"2023-03-13 21:42:00","inspection_id":"78071749","insp_unit_id":"193831040","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"143544","insp_unit_license":"3216141","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN3AY9PM003266","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:33.000000Z","updated_at":"2025-03-17T22:35:33.000000Z"},{"id":4121040,"change_date":"2023-03-13 21:42:00","inspection_id":"78071749","insp_unit_id":"193831041","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"24374","insp_unit_license":"P426720","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA5611GE702121","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:33.000000Z","updated_at":"2025-03-17T22:35:33.000000Z"}]},{"id":2420672,"change_date":"2023-03-14 21:41:00","inspection_id":"77912757","dot_number":"792056","report_state":"AL","report_number":"MCMP002481","insp_date":"2023-02-22 00:00:00","insp_start_time":"1015","insp_end_time":"1105","registration_date":"2023-03-14 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"AL","county_code":"101","insp_level_id":"1","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"SYSCO CENTRAL ALABAMA INC","shipping_paper_number":"522823","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-02-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"102700","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"943244","transaction_code":"C","transaction_date":"2023-02-22 00:00:00","upload_date":"2023-03-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2023-02-22 21:40:00","snet_input_date":"2023-02-22 00:00:00","source_office":"2ALS001","mcmis_add_date":"2023-02-22 21:40:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:11:23.000000Z","updated_at":"2025-03-17T19:11:23.000000Z","inspection_violations":[{"id":3728541,"change_date":"2023-03-14 21:41:00","inspection_id":"77912757","insp_violation_id":"251649757","seq_no":"1","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"193859508","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:35.000000Z","updated_at":"2025-03-17T21:24:35.000000Z","normalized_code":"39355E"},{"id":3728542,"change_date":"2023-03-14 21:41:00","inspection_id":"77912757","insp_violation_id":"251649758","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"193859508","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:35.000000Z","updated_at":"2025-03-17T21:24:35.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":3895821,"change_date":"2023-03-14 21:41:00","inspection_id":"77912757","insp_unit_id":"193859507","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"138206","insp_unit_license":"2561586","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4W39EG2KN208791","insp_unit_decal":"Y","insp_unit_decal_number":"32378859","created_at":"2025-03-17T22:33:55.000000Z","updated_at":"2025-03-17T22:33:55.000000Z"},{"id":3895822,"change_date":"2023-03-14 21:41:00","inspection_id":"77912757","insp_unit_id":"193859508","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"250616","insp_unit_license":"P945650","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GR1A7627LE218081","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:55.000000Z","updated_at":"2025-03-17T22:33:55.000000Z"}]},{"id":2407780,"change_date":"2023-02-21 21:41:00","inspection_id":"77897906","dot_number":"792056","report_state":"FL","report_number":"2516001375","insp_date":"2023-02-14 00:00:00","insp_start_time":"1145","insp_end_time":"1214","registration_date":null,"region":"ET","ci_status_code":"C","location":"HCCM06","location_desc":"MCSAP HCC I-10 LEON","county_code_state":"FL","county_code":"073","insp_level_id":"3","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-02-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","viol_total":"4","oos_total":"0","driver_viol_total":"4","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2479598","transaction_code":"A","transaction_date":"2023-02-14 00:00:00","upload_date":"2023-02-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2023-02-21 21:41:00","snet_input_date":"2023-02-16 00:00:00","source_office":"2FLS001","mcmis_add_date":"2023-02-21 21:41:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:11:03.000000Z","updated_at":"2025-03-17T19:11:03.000000Z","inspection_violations":[{"id":3706595,"change_date":"2023-02-21 21:41:00","inspection_id":"77897906","insp_violation_id":"251231424","seq_no":"1","part_no":"395","part_no_section":"32(b)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:29.000000Z","updated_at":"2025-03-17T21:24:29.000000Z","normalized_code":"39532B"},{"id":3706596,"change_date":"2023-02-21 21:41:00","inspection_id":"77897906","insp_violation_id":"251231425","seq_no":"2","part_no":"395","part_no_section":"32(b)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:29.000000Z","updated_at":"2025-03-17T21:24:29.000000Z","normalized_code":"39532B"},{"id":3706597,"change_date":"2023-02-21 21:41:00","inspection_id":"77897906","insp_violation_id":"251231426","seq_no":"3","part_no":"395","part_no_section":"32(b)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:29.000000Z","updated_at":"2025-03-17T21:24:29.000000Z","normalized_code":"39532B"},{"id":3706598,"change_date":"2023-02-21 21:41:00","inspection_id":"77897906","insp_violation_id":"251231427","seq_no":"4","part_no":"395","part_no_section":"32(b)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:29.000000Z","updated_at":"2025-03-17T21:24:29.000000Z","normalized_code":"39532B"}],"inspection_per_units":[{"id":3874186,"change_date":"2023-02-21 21:41:00","inspection_id":"77897906","insp_unit_id":"193484231","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"134885","insp_unit_license":"2241371","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FVACWDU3GHHG0062","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:44.000000Z","updated_at":"2025-03-17T22:33:44.000000Z"}]},{"id":2072221,"change_date":"2023-01-05 21:40:00","inspection_id":"77514269","dot_number":"792056","report_state":"AL","report_number":"1905000546","insp_date":"2023-01-02 00:00:00","insp_start_time":"1402","insp_end_time":"1438","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"AL","county_code":"051","insp_level_id":"3","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"SYSCO LEASING","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":"I","final_status_date":"2023-01-05 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":"936834","transaction_code":"A","transaction_date":"2023-01-02 00:00:00","upload_date":"2023-01-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2023-01-05 21:40:00","snet_input_date":"2023-01-05 00:00:00","source_office":"2ALS001","mcmis_add_date":"2023-01-05 21:40:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:04:46.000000Z","updated_at":"2025-03-17T19:04:46.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3333662,"change_date":"2023-01-05 21:40:00","inspection_id":"77514269","insp_unit_id":"192709536","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"135781","insp_unit_license":"2342181","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4M39EG0HN983722","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:51.000000Z","updated_at":"2025-03-17T22:29:51.000000Z"},{"id":3333663,"change_date":"2023-01-05 21:40:00","inspection_id":"77514269","insp_unit_id":"192709537","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GFTR","insp_unit_company":"242669","insp_unit_license":"PA41206","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA5614FE701950","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:51.000000Z","updated_at":"2025-03-17T22:29:51.000000Z"}]},{"id":1866498,"change_date":"2022-12-05 21:39:00","inspection_id":"77279306","dot_number":"792056","report_state":"AL","report_number":"JWCV000918","insp_date":"2022-12-02 00:00:00","insp_start_time":"1003","insp_end_time":"1025","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"CALERA","county_code_state":"AL","county_code":"117","insp_level_id":"2","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"NA","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-12-05 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"115000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"933337","transaction_code":"A","transaction_date":"2022-12-02 00:00:00","upload_date":"2022-12-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2022-12-05 21:39:00","snet_input_date":"2022-12-05 00:00:00","source_office":"2ALS001","mcmis_add_date":"2022-12-05 21:39:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:01:05.000000Z","updated_at":"2025-03-17T19:01:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3003590,"change_date":"2022-12-05 21:39:00","inspection_id":"77279306","insp_unit_id":"192247211","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"132018","insp_unit_license":"2028192","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4MC9EG8DN149529","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:33.000000Z","updated_at":"2025-03-17T22:27:33.000000Z"},{"id":3003591,"change_date":"2022-12-05 21:39:00","inspection_id":"77279306","insp_unit_id":"192247212","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KIEF","insp_unit_company":"203695","insp_unit_license":"P962449","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1K913422972054503","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:33.000000Z","updated_at":"2025-03-17T22:27:33.000000Z"}]},{"id":1830678,"change_date":"2023-01-06 21:38:00","inspection_id":"77238356","dot_number":"792056","report_state":"AL","report_number":"2034000009","insp_date":"2022-11-21 00:00:00","insp_start_time":"0953","insp_end_time":"1033","registration_date":"2023-01-06 00:00:00","region":"CT","ci_status_code":"C","location":"1020","location_desc":"WEIGH-STATION","county_code_state":"AL","county_code":"029","insp_level_id":"2","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"SYSCO","shipping_paper_number":"682214148","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-11-29 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"72000","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":"932381","transaction_code":"C","transaction_date":"2022-11-21 00:00:00","upload_date":"2023-01-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2022-11-29 21:40:00","snet_input_date":"2022-11-29 00:00:00","source_office":"2ALS001","mcmis_add_date":"2022-11-29 21:40:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:00:21.000000Z","updated_at":"2025-03-17T19:00:21.000000Z","inspection_violations":[{"id":2858688,"change_date":"2023-01-06 21:38:00","inspection_id":"77238356","insp_violation_id":"250419593","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"192730301","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:20:31.000000Z","updated_at":"2025-03-17T21:20:31.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":2945106,"change_date":"2023-01-06 21:38:00","inspection_id":"77238356","insp_unit_id":"192730301","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"135167","insp_unit_license":"2341805","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUJGBDV7GLHB3379","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:10.000000Z","updated_at":"2025-03-17T22:27:10.000000Z"},{"id":2945107,"change_date":"2023-01-06 21:38:00","inspection_id":"77238356","insp_unit_id":"192730302","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"203699","insp_unit_license":"PB84489","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1K913482162054629","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:10.000000Z","updated_at":"2025-03-17T22:27:10.000000Z"}]},{"id":1830647,"change_date":"2022-11-29 21:40:00","inspection_id":"77238324","dot_number":"792056","report_state":"AL","report_number":"CDJP002964","insp_date":"2022-11-19 00:00:00","insp_start_time":"1318","insp_end_time":"1345","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SIMTHS, AL","county_code_state":"AL","county_code":"081","insp_level_id":"3","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"NA","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-11-29 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"932334","transaction_code":"A","transaction_date":"2022-11-19 00:00:00","upload_date":"2022-11-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2022-11-29 21:40:00","snet_input_date":"2022-11-29 00:00:00","source_office":"2ALS001","mcmis_add_date":"2022-11-29 21:40:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:00:21.000000Z","updated_at":"2025-03-17T19:00:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2945055,"change_date":"2022-11-29 21:40:00","inspection_id":"77238324","insp_unit_id":"192163204","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"138208","insp_unit_license":"2561587","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4W39EG6KN208793","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:10.000000Z","updated_at":"2025-03-17T22:27:10.000000Z"},{"id":2945056,"change_date":"2022-11-29 21:40:00","inspection_id":"77238324","insp_unit_id":"192163205","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"242666","insp_unit_license":"P380057","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA5614FE701947","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:10.000000Z","updated_at":"2025-03-17T22:27:10.000000Z"}]},{"id":1724965,"change_date":"2022-11-14 21:41:00","inspection_id":"77117116","dot_number":"792056","report_state":"AL","report_number":"BSCV001617","insp_date":"2022-11-12 00:00:00","insp_start_time":"0430","insp_end_time":"0450","registration_date":null,"region":"CT","ci_status_code":"C","location":"58","location_desc":"INTERSTATE","county_code_state":"AL","county_code":"117","insp_level_id":"3","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"SYSCO CENTRAL ALABAMA INC","shipping_paper_number":"6067","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-11-14 21:41: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":"930975","transaction_code":"A","transaction_date":"2022-11-12 00:00:00","upload_date":"2022-11-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2022-11-14 21:41:00","snet_input_date":"2022-11-14 00:00:00","source_office":"2ALS001","mcmis_add_date":"2022-11-14 21:41:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:58:32.000000Z","updated_at":"2025-03-17T18:58:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2774696,"change_date":"2022-11-14 21:41:00","inspection_id":"77117116","insp_unit_id":"191921794","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"143545","insp_unit_license":"3216183","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN3AY5PM003264","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:58.000000Z","updated_at":"2025-03-17T22:25:58.000000Z"},{"id":2774697,"change_date":"2022-11-14 21:41:00","inspection_id":"77117116","insp_unit_id":"191921795","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"203681","insp_unit_license":"P962439","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1JJV362W74L884354","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:58.000000Z","updated_at":"2025-03-17T22:25:58.000000Z"}]},{"id":1665269,"change_date":"2022-11-03 21:41:00","inspection_id":"77048540","dot_number":"792056","report_state":"AL","report_number":"JWAW003831","insp_date":"2022-11-03 00:00:00","insp_start_time":"0905","insp_end_time":"0920","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"AL","county_code":"011","insp_level_id":"3","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"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":"2022-11-03 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"133200","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":"929587","transaction_code":"A","transaction_date":"2022-11-03 00:00:00","upload_date":"2022-11-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2022-11-03 21:41:00","snet_input_date":"2022-11-03 00:00:00","source_office":"2ALS001","mcmis_add_date":"2022-11-03 21:41:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:57:24.000000Z","updated_at":"2025-03-17T18:57:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2678848,"change_date":"2022-11-03 21:41:00","inspection_id":"77048540","insp_unit_id":"191788287","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"03","insp_unit_license":"1158401","insp_unit_license_state":"AL","insp_unit_vehicle_id_number":"1FUJA6CK05DU00196","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:21.000000Z","updated_at":"2025-03-17T22:25:21.000000Z"},{"id":2678849,"change_date":"2022-11-03 21:41:00","inspection_id":"77048540","insp_unit_id":"191788288","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"SEMN","insp_unit_company":null,"insp_unit_license":"A132408","insp_unit_license_state":"AL","insp_unit_vehicle_id_number":"LEW1977","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:21.000000Z","updated_at":"2025-03-17T22:25:21.000000Z"}]},{"id":1444059,"change_date":"2022-10-05 21:40:00","inspection_id":"76793506","dot_number":"792056","report_state":"AL","report_number":"APCV000623","insp_date":"2022-10-05 00:00:00","insp_start_time":"0837","insp_end_time":"0901","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"AL","county_code":"085","insp_level_id":"3","service_center":"SH","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":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-10-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"87000","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":"925267","transaction_code":"A","transaction_date":"2022-10-05 00:00:00","upload_date":"2022-10-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2022-10-05 21:40:00","snet_input_date":"2022-10-05 00:00:00","source_office":"2ALS001","mcmis_add_date":"2022-10-05 21:40:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:53:23.000000Z","updated_at":"2025-03-17T18:53:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2324574,"change_date":"2022-10-05 21:40:00","inspection_id":"76793506","insp_unit_id":"191275250","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"137371","insp_unit_license":"2561273","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4W39EG6JN901362","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:54.000000Z","updated_at":"2025-03-17T22:22:54.000000Z"},{"id":2324575,"change_date":"2022-10-05 21:40:00","inspection_id":"76793506","insp_unit_id":"191275251","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"203652","insp_unit_license":"P962432","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA561685701758","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:54.000000Z","updated_at":"2025-03-17T22:22:54.000000Z"}]},{"id":1419573,"change_date":"2022-10-03 21:40:00","inspection_id":"76765458","dot_number":"792056","report_state":"AL","report_number":"BWJW006684","insp_date":"2022-10-03 00:00:00","insp_start_time":"1145","insp_end_time":"1201","registration_date":null,"region":"CT","ci_status_code":"C","location":"I085","location_desc":"ROADSIDE","county_code_state":"AL","county_code":"087","insp_level_id":"3","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"COMMUNITY HOSPITAL","shipping_paper_number":"346173431","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-10-03 21:40: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":"924951","transaction_code":"A","transaction_date":"2022-10-03 00:00:00","upload_date":"2022-10-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2022-10-03 21:40:00","snet_input_date":"2022-10-03 00:00:00","source_office":"2ALS001","mcmis_add_date":"2022-10-03 21:40:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:52:45.000000Z","updated_at":"2025-03-17T18:52:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2285108,"change_date":"2022-10-03 21:40:00","inspection_id":"76765458","insp_unit_id":"191218177","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"137371","insp_unit_license":"2561273","insp_unit_license_state":"AL","insp_unit_vehicle_id_number":"4V4W39EG6JN901362","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:39.000000Z","updated_at":"2025-03-17T22:22:39.000000Z"},{"id":2285109,"change_date":"2022-10-03 21:40:00","inspection_id":"76765458","insp_unit_id":"191218178","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"228340","insp_unit_license":"P962460","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA5613CB709468","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:39.000000Z","updated_at":"2025-03-17T22:22:39.000000Z"}]},{"id":1314134,"change_date":"2022-09-19 21:39:00","inspection_id":"76643181","dot_number":"792056","report_state":"TN","report_number":"TCGK002535","insp_date":"2022-09-16 00:00:00","insp_start_time":"0717","insp_end_time":"0749","registration_date":null,"region":"CT","ci_status_code":"C","location":"SCALES","location_desc":"I-24 COFFEE COUNTY SCALES","county_code_state":"TN","county_code":"031","insp_level_id":"1","service_center":"SH","census_source_id":"4","insp_facility":"F","shipper_name":"KEYSTON","shipping_paper_number":"0511610","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-09-19 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"70000","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":"1597282","transaction_code":"A","transaction_date":"2022-09-16 00:00:00","upload_date":"2022-09-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2022-09-19 21:39:00","snet_input_date":"2022-09-19 00:00:00","source_office":"2TNS001","mcmis_add_date":"2022-09-19 21:39:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:50:52.000000Z","updated_at":"2025-03-17T18:50:52.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2115546,"change_date":"2022-09-19 21:39:00","inspection_id":"76643181","insp_unit_id":"190970571","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"46_143540","insp_unit_license":"328516","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN3AY2PM003268","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:30.000000Z","updated_at":"2025-03-17T22:21:30.000000Z"},{"id":2115547,"change_date":"2022-09-19 21:39:00","inspection_id":"76643181","insp_unit_id":"190970572","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"243723","insp_unit_license":"P812596","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA5611GE702118","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:30.000000Z","updated_at":"2025-03-17T22:21:30.000000Z"}]},{"id":1258808,"change_date":"2022-09-12 21:42:00","inspection_id":"76578541","dot_number":"792056","report_state":"FL","report_number":"3233013410","insp_date":"2022-09-06 00:00:00","insp_start_time":"1105","insp_end_time":"1117","registration_date":null,"region":"CT","ci_status_code":"C","location":"101W","location_desc":"I10 SNEADS WIM-WEST","county_code_state":"FL","county_code":"063","insp_level_id":"3","service_center":"SH","census_source_id":"4","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-09-12 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2436134","transaction_code":"A","transaction_date":"2022-09-06 00:00:00","upload_date":"2022-09-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2022-09-12 21:42:00","snet_input_date":"2022-09-12 00:00:00","source_office":"2FLS001","mcmis_add_date":"2022-09-12 21:42:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:49:46.000000Z","updated_at":"2025-03-17T18:49:46.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2025454,"change_date":"2022-09-12 21:42:00","inspection_id":"76578541","insp_unit_id":"190833959","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"143544","insp_unit_license":"3216141","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN3AY9PM003266","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:55.000000Z","updated_at":"2025-03-17T22:20:55.000000Z"},{"id":2025455,"change_date":"2022-09-12 21:42:00","inspection_id":"76578541","insp_unit_id":"190833960","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"246069","insp_unit_license":"P668338","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA7624JE701296","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:55.000000Z","updated_at":"2025-03-17T22:20:55.000000Z"}]},{"id":1043384,"change_date":"2022-08-16 21:38:00","inspection_id":"76327752","dot_number":"792056","report_state":"AL","report_number":"GUNB000704","insp_date":"2022-08-16 00:00:00","insp_start_time":"0434","insp_end_time":"0500","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SOUTHGATE-ROADSIDE","county_code_state":"AL","county_code":"095","insp_level_id":"2","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"SYSCO","shipping_paper_number":"346117603","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-08-16 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"73700","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":"918265","transaction_code":"A","transaction_date":"2022-08-16 00:00:00","upload_date":"2022-08-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2022-08-16 21:38:00","snet_input_date":"2022-08-16 00:00:00","source_office":"2ALS001","mcmis_add_date":"2022-08-16 21:38:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:46:09.000000Z","updated_at":"2025-03-17T18:46:09.000000Z","inspection_violations":[{"id":1643548,"change_date":"2022-08-16 21:38:00","inspection_id":"76327752","insp_violation_id":"247730886","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:14:43.000000Z","updated_at":"2025-03-17T21:14:43.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1678814,"change_date":"2022-08-16 21:38:00","inspection_id":"76327752","insp_unit_id":"190323884","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"136328","insp_unit_license":"2488526","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4M39EG0HN991173","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:34.000000Z","updated_at":"2025-03-17T22:18:34.000000Z"},{"id":1678815,"change_date":"2022-08-16 21:38:00","inspection_id":"76327752","insp_unit_id":"190323885","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"203653","insp_unit_license":"P962433","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA56188S701759","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:34.000000Z","updated_at":"2025-03-17T22:18:34.000000Z"}]},{"id":805854,"change_date":"2022-07-18 21:41:00","inspection_id":"76050144","dot_number":"792056","report_state":"AL","report_number":"EUMC001050","insp_date":"2022-07-13 00:00:00","insp_start_time":"0738","insp_end_time":"0806","registration_date":"2022-07-18 00:00:00","region":"CT","ci_status_code":"C","location":"18","location_desc":"WEIGH STATION","county_code_state":"AL","county_code":"029","insp_level_id":"2","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"BUCKHEAD MEAT","shipping_paper_number":"0101787839","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-07-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"914511","transaction_code":"C","transaction_date":"2022-07-13 00:00:00","upload_date":"2022-07-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00792056","upload_search_indicator":null,"census_search_date":"2022-07-13 21:40:00","snet_input_date":"2022-07-13 00:00:00","source_office":"2ALS001","mcmis_add_date":"2022-07-13 21:40:00","insp_carrier_name":"SYSCO CENTRAL ALABAMA INC","insp_carrier_street":"1000 SYSCO DRIVE","insp_carrier_city":"CALERA","insp_carrier_state":"AL","insp_carrier_zip_code":"35040","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:41:56.000000Z","updated_at":"2025-03-17T18:41:56.000000Z","inspection_violations":[{"id":1271415,"change_date":"2022-07-18 21:41:00","inspection_id":"76050144","insp_violation_id":"247139373","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"189815665","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:12:59.000000Z","updated_at":"2025-03-17T21:12:59.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":1296572,"change_date":"2022-07-18 21:41:00","inspection_id":"76050144","insp_unit_id":"189815664","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"133695","insp_unit_license":"2488585","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4MC9EC2FN923855","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:09.000000Z","updated_at":"2025-03-17T22:16:09.000000Z"},{"id":1296573,"change_date":"2022-07-18 21:41:00","inspection_id":"76050144","insp_unit_id":"189815665","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"203701","insp_unit_license":"P962452","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA96297S701803","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:09.000000Z","updated_at":"2025-03-17T22:16:09.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/792056\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/792056\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/792056\/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\/792056\/inspections","per_page":100,"prev_page_url":null,"to":79,"total":79}