{"current_page":1,"data":[{"id":11717471,"change_date":"2026-04-22 21:39:00","inspection_id":"87644793","dot_number":"527487","report_state":"MO","report_number":"1645004235","insp_date":"2026-04-21 00:00:00","insp_start_time":"1155","insp_end_time":"1216","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"ST. LOUIS MO","county_code_state":"MO","county_code":"510","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"842328","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-04-22 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"54700","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3194102","transaction_code":"A","transaction_date":"2026-04-21 00:00:00","upload_date":"2026-04-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00527487","upload_search_indicator":null,"census_search_date":"2026-04-22 21:39:00","snet_input_date":"2026-04-21 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-22 21:39:00","insp_carrier_name":"SYSCO ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-27T09:39:10.000000Z","updated_at":"2026-05-03T09:30:28.000000Z","inspection_violations":[{"id":20370304,"change_date":"2026-04-22 21:39:00","inspection_id":"87644793","insp_violation_id":"273770942","seq_no":"2","part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"1","insp_unit_id":"213153829","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:57:34.000000Z","updated_at":"2026-05-03T09:41:46.000000Z","normalized_code":"3939ALRLI"},{"id":20370305,"change_date":"2026-04-22 21:39:00","inspection_id":"87644793","insp_violation_id":"273770943","seq_no":"3","part_no":"393","part_no_section":"9A-LSLI","insp_viol_unit":"1","insp_unit_id":"213153829","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:57:34.000000Z","updated_at":"2026-05-03T09:41:46.000000Z","normalized_code":"3939ALSLI"},{"id":20370306,"change_date":"2026-04-22 21:39:00","inspection_id":"87644793","insp_violation_id":"273770944","seq_no":"4","part_no":"393","part_no_section":"9A-LTSIR","insp_viol_unit":"1","insp_unit_id":"213153829","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:57:34.000000Z","updated_at":"2026-05-03T09:41:46.000000Z","normalized_code":"3939ALTSIR"},{"id":20370303,"change_date":"2026-04-22 21:39:00","inspection_id":"87644793","insp_violation_id":"273770941","seq_no":"1","part_no":"393","part_no_section":"55C2-B","insp_viol_unit":"2","insp_unit_id":"213153830","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:57:34.000000Z","updated_at":"2026-05-03T09:41:46.000000Z","normalized_code":"39355C2B"}],"inspection_per_units":[{"id":20390142,"change_date":"2026-04-22 21:39:00","inspection_id":"87644793","insp_unit_id":"213153829","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"STL_143565","insp_unit_license":"3216114","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN3AY9PM003333","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:16:11.000000Z","updated_at":"2026-05-03T09:03:09.000000Z"},{"id":20390143,"change_date":"2026-04-22 21:39:00","inspection_id":"87644793","insp_unit_id":"213153830","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":"255500","insp_unit_license":"PG26508","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"526162817R5000439","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:16:11.000000Z","updated_at":"2026-05-03T09:03:09.000000Z"}]},{"id":11368908,"change_date":"2026-03-13 21:37:00","inspection_id":"87282449","dot_number":"527487","report_state":"MO","report_number":"1645004070","insp_date":"2026-03-13 00:00:00","insp_start_time":"0850","insp_end_time":"0916","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"ST. LOUIS MO","county_code_state":"MO","county_code":"510","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"0838385","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":"74700","viol_total":"3","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3002716","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":"00527487","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 ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","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:49.000000Z","inspection_violations":[{"id":19157990,"change_date":"2026-03-13 21:37:00","inspection_id":"87282449","insp_violation_id":"272388289","seq_no":"1","part_no":"383","part_no_section":"95A-LCDL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-16T10:01:14.000000Z","updated_at":"2026-03-24T09:43:56.000000Z","normalized_code":"38395ALCDL"},{"id":19157991,"change_date":"2026-03-13 21:37:00","inspection_id":"87282449","insp_violation_id":"272388290","seq_no":"2","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"212121697","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-16T10:01:14.000000Z","updated_at":"2026-03-24T09:43:56.000000Z","normalized_code":"39617CPI"},{"id":19157992,"change_date":"2026-03-13 21:37:00","inspection_id":"87282449","insp_violation_id":"272388291","seq_no":"3","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":"2026-03-16T10:01:14.000000Z","updated_at":"2026-03-24T09:43:56.000000Z","normalized_code":"38371H"}],"inspection_per_units":[{"id":19466850,"change_date":"2026-03-13 21:37:00","inspection_id":"87282449","insp_unit_id":"212121697","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"133806","insp_unit_license":"2240762","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4M39EG1FN926720","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-16T09:16:56.000000Z","updated_at":"2026-03-24T09:04:15.000000Z"},{"id":19466851,"change_date":"2026-03-13 21:37:00","inspection_id":"87282449","insp_unit_id":"212121698","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"257273","insp_unit_license":"PG74153","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V281K2TJ417818","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-16T09:16:56.000000Z","updated_at":"2026-03-24T09:04:15.000000Z"}]},{"id":11319359,"change_date":"2026-03-08 21:33:00","inspection_id":"87235928","dot_number":"527487","report_state":"MO","report_number":"3214000780","insp_date":"2026-03-06 00:00:00","insp_start_time":"0737","insp_end_time":"0807","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"ST LOUIS MO","county_code_state":"MO","county_code":null,"insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SYSCO","shipping_paper_number":"0837549","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-08 21:33: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":"2977267","transaction_code":"A","transaction_date":"2026-03-07 00:00:00","upload_date":"2026-03-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00527487","upload_search_indicator":null,"census_search_date":"2026-03-08 21:33:00","snet_input_date":"2026-03-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-08 21:33:00","insp_carrier_name":"SYSCO ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-11T09:38:22.000000Z","updated_at":"2026-03-19T09:30:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19366778,"change_date":"2026-03-08 21:33:00","inspection_id":"87235928","insp_unit_id":"212033801","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"135185","insp_unit_license":"3859283","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4M39EG1GN969150","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-11T09:13:27.000000Z","updated_at":"2026-03-19T09:02:12.000000Z"},{"id":19366779,"change_date":"2026-03-08 21:33:00","inspection_id":"87235928","insp_unit_id":"212033802","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"246583","insp_unit_license":"PG74312","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA5613JB130428","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-11T09:13:27.000000Z","updated_at":"2026-03-19T09:02:12.000000Z"}]},{"id":11135226,"change_date":"2026-02-14 21:34:00","inspection_id":"87048929","dot_number":"527487","report_state":"MO","report_number":"3214000762","insp_date":"2026-02-13 00:00:00","insp_start_time":"0725","insp_end_time":"0800","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"ST LOUIS MO","county_code_state":"MO","county_code":null,"insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SYSCO","shipping_paper_number":"0835340","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-02-14 21:34: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":"2887162","transaction_code":"A","transaction_date":"2026-02-13 00:00:00","upload_date":"2026-02-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00527487","upload_search_indicator":null,"census_search_date":"2026-02-14 21:34:00","snet_input_date":"2026-02-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-14 21:34:00","insp_carrier_name":"SYSCO ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-17T10:37:51.000000Z","updated_at":"2026-02-25T10:30:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18995011,"change_date":"2026-02-14 21:34:00","inspection_id":"87048929","insp_unit_id":"211629628","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK TRUCK","insp_unit_company":"STL-140784","insp_unit_license":"3786769","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN2AY5LM001941","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-17T10:14:26.000000Z","updated_at":"2026-02-25T10:02:04.000000Z"},{"id":18995012,"change_date":"2026-02-14 21:34:00","inspection_id":"87048929","insp_unit_id":"211629629","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"229388","insp_unit_license":"PG26794","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA5618DB711928","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-17T10:14:26.000000Z","updated_at":"2026-02-25T10:02:04.000000Z"}]},{"id":11167047,"change_date":"2026-02-19 21:39:00","inspection_id":"87082549","dot_number":"527487","report_state":"MO","report_number":"3958001290","insp_date":"2026-02-13 00:00:00","insp_start_time":"1141","insp_end_time":"1208","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"ST. LOUIS MO","county_code_state":"MO","county_code":null,"insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"0835302","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-02-19 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"2904076","transaction_code":"A","transaction_date":"2026-02-18 00:00:00","upload_date":"2026-02-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00527487","upload_search_indicator":null,"census_search_date":"2026-02-19 21:39:00","snet_input_date":"2026-02-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-19 21:39:00","insp_carrier_name":"SYSCO ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-22T10:37:44.000000Z","updated_at":"2026-03-02T10:30:10.000000Z","inspection_violations":[{"id":18720657,"change_date":"2026-02-19 21:39:00","inspection_id":"87082549","insp_violation_id":"271884274","seq_no":"1","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"211697976","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-02-22T10:53:06.000000Z","updated_at":"2026-03-02T10:40:20.000000Z","normalized_code":"39375A3TAOL"},{"id":18720658,"change_date":"2026-02-19 21:39:00","inspection_id":"87082549","insp_violation_id":"271884275","seq_no":"2","part_no":"393","part_no_section":"75C-TAOTD-LT2\/32","insp_viol_unit":"2","insp_unit_id":"211697977","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-22T10:53:06.000000Z","updated_at":"2026-03-02T10:40:20.000000Z","normalized_code":"39375CTAOTDLT2\/32"},{"id":18720659,"change_date":"2026-02-19 21:39:00","inspection_id":"87082549","insp_violation_id":"271884276","seq_no":"3","part_no":"393","part_no_section":"75C-TAOTD-LT2\/32","insp_viol_unit":"2","insp_unit_id":"211697977","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-22T10:53:06.000000Z","updated_at":"2026-03-02T10:40:20.000000Z","normalized_code":"39375CTAOTDLT2\/32"},{"id":18720660,"change_date":"2026-02-19 21:39:00","inspection_id":"87082549","insp_violation_id":"271884277","seq_no":"4","part_no":"393","part_no_section":"207B-AALPME","insp_viol_unit":"2","insp_unit_id":"211697977","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-22T10:53:06.000000Z","updated_at":"2026-03-02T10:40:20.000000Z","normalized_code":"393207BAALPME"}],"inspection_per_units":[{"id":19054333,"change_date":"2026-02-19 21:39:00","inspection_id":"87082549","insp_unit_id":"211697976","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"137024","insp_unit_license":"2488859","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4MC9EG6JN890306","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-22T10:13:19.000000Z","updated_at":"2026-03-02T10:02:36.000000Z"},{"id":19054334,"change_date":"2026-02-19 21:39:00","inspection_id":"87082549","insp_unit_id":"211697977","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"239687","insp_unit_license":"PB24953","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA9627EB708732","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-22T10:13:19.000000Z","updated_at":"2026-03-02T10:02:36.000000Z"}]},{"id":10822337,"change_date":"2026-01-21 21:37:00","inspection_id":"86849928","dot_number":"527487","report_state":"MO","report_number":"3214000728","insp_date":"2026-01-20 00:00:00","insp_start_time":"1505","insp_end_time":"1530","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"ST LOUIS MO","county_code_state":"MO","county_code":null,"insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SYSCO","shipping_paper_number":"464452031","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-21 21:37: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":"2794249","transaction_code":"A","transaction_date":"2026-01-20 00:00:00","upload_date":"2026-01-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00527487","upload_search_indicator":null,"census_search_date":"2026-01-21 21:37:00","snet_input_date":"2026-01-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-21 21:37:00","insp_carrier_name":"SYSCO ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-24T10:36:44.000000Z","updated_at":"2026-02-01T10:30:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18175089,"change_date":"2026-01-21 21:37:00","inspection_id":"86849928","insp_unit_id":"211203094","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"132152","insp_unit_license":"2028247","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUBGBDV2ELFA8408","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-24T10:08:33.000000Z","updated_at":"2026-02-01T10:02:32.000000Z"},{"id":18175090,"change_date":"2026-01-21 21:37:00","inspection_id":"86849928","insp_unit_id":"211203095","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"257273","insp_unit_license":"PG74153","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V281K2TJ417818","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-24T10:08:33.000000Z","updated_at":"2026-02-01T10:02:32.000000Z"}]},{"id":10631667,"change_date":"2026-01-13 21:39:00","inspection_id":"86772553","dot_number":"527487","report_state":"MO","report_number":"7560000565","insp_date":"2026-01-09 00:00:00","insp_start_time":"0819","insp_end_time":"0844","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"ST. LOUIS MO","county_code_state":"MO","county_code":"510","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SYSCO","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"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-13 21:39: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":"2755660","transaction_code":"A","transaction_date":"2026-01-12 00:00:00","upload_date":"2026-01-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00527487","upload_search_indicator":null,"census_search_date":"2026-01-13 21:39:00","snet_input_date":"2026-01-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-13 21:39:00","insp_carrier_name":"SYSCO ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-16T10:35:58.000000Z","updated_at":"2026-01-24T10:30:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17831768,"change_date":"2026-01-13 21:39:00","inspection_id":"86772553","insp_unit_id":"211042596","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"257273","insp_unit_license":"PG74153","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V281K2TJ417818","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-16T10:08:34.000000Z","updated_at":"2026-01-24T10:01:44.000000Z"},{"id":17831769,"change_date":"2026-01-13 21:39:00","inspection_id":"86772553","insp_unit_id":"211042597","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"132152","insp_unit_license":"2028247","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUBGBDV2ELFA8408","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-16T10:08:34.000000Z","updated_at":"2026-01-24T10:01:44.000000Z"}]},{"id":10597423,"change_date":"2026-01-08 21:39:00","inspection_id":"86736583","dot_number":"527487","report_state":"MO","report_number":"3725001739","insp_date":"2026-01-06 00:00:00","insp_start_time":"0739","insp_end_time":"0827","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"EUREKA MO","county_code_state":"MO","county_code":"510","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"464435619","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-01-08 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"74700","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":"2739567","transaction_code":"A","transaction_date":"2026-01-08 00:00:00","upload_date":"2026-01-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00527487","upload_search_indicator":null,"census_search_date":"2026-01-08 21:39:00","snet_input_date":"2026-01-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-08 21:39:00","insp_carrier_name":"SYSCO ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-11T10:34:41.000000Z","updated_at":"2026-01-19T10:30:32.000000Z","inspection_violations":[{"id":17815017,"change_date":"2026-01-08 21:39:00","inspection_id":"86736583","insp_violation_id":"271082036","seq_no":"1","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"1","insp_unit_id":"210972977","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-11T10:39:12.000000Z","updated_at":"2026-01-19T10:31:05.000000Z","normalized_code":"39345DB"},{"id":17815018,"change_date":"2026-01-08 21:39:00","inspection_id":"86736583","insp_violation_id":"271082037","seq_no":"2","part_no":"392","part_no_section":"2-SLLIRP","insp_viol_unit":"1","insp_unit_id":"210972977","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-11T10:39:12.000000Z","updated_at":"2026-01-19T10:31:05.000000Z","normalized_code":"3922SLLIRP"},{"id":17815019,"change_date":"2026-01-08 21:39:00","inspection_id":"86736583","insp_violation_id":"271082038","seq_no":"3","part_no":"392","part_no_section":"2-SLLIT","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-01-11T10:39:12.000000Z","updated_at":"2026-01-19T10:31:05.000000Z","normalized_code":"3922SLLIT"},{"id":17815020,"change_date":"2026-01-08 21:39:00","inspection_id":"86736583","insp_violation_id":"271082039","seq_no":"4","part_no":"393","part_no_section":"55C1","insp_viol_unit":"1","insp_unit_id":"210972977","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-11T10:39:12.000000Z","updated_at":"2026-01-19T10:31:05.000000Z","normalized_code":"39355C1"},{"id":17815021,"change_date":"2026-01-08 21:39:00","inspection_id":"86736583","insp_violation_id":"271082040","seq_no":"5","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"210972977","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-11T10:39:12.000000Z","updated_at":"2026-01-19T10:31:05.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":17765899,"change_date":"2026-01-08 21:39:00","inspection_id":"86736583","insp_unit_id":"210972977","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"130677","insp_unit_license":"35AR7D","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1FUBGBDV3CSBF8208","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-11T10:06:11.000000Z","updated_at":"2026-01-19T10:00:40.000000Z"},{"id":17765900,"change_date":"2026-01-08 21:39:00","inspection_id":"86736583","insp_unit_id":"210972978","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"257271","insp_unit_license":"PG74151","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V281K7TJ418205","insp_unit_decal":"Y","insp_unit_decal_number":"36128045","created_at":"2026-01-11T10:06:11.000000Z","updated_at":"2026-01-19T10:00:40.000000Z"}]},{"id":10404129,"change_date":"2025-12-11 21:44:00","inspection_id":"86534501","dot_number":"527487","report_state":"MO","report_number":"4427001854","insp_date":"2025-12-09 00:00:00","insp_start_time":"0600","insp_end_time":"0629","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"FENTON MO","county_code_state":"MO","county_code":null,"insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"0828773","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-12-11 21:44: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":"2640394","transaction_code":"A","transaction_date":"2025-12-10 00:00:00","upload_date":"2025-12-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00527487","upload_search_indicator":null,"census_search_date":"2025-12-11 21:44:00","snet_input_date":"2025-12-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-12-11 21:44:00","insp_carrier_name":"SYSCO ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-14T10:31:37.000000Z","updated_at":"2025-12-15T10:30:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17400071,"change_date":"2025-12-11 21:44:00","inspection_id":"86534501","insp_unit_id":"210540279","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"147006","insp_unit_license":"3539737","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKBHTDVXRDUV4634","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-14T10:01:52.000000Z","updated_at":"2025-12-15T10:00:36.000000Z"},{"id":17400072,"change_date":"2025-12-11 21:44:00","inspection_id":"86534501","insp_unit_id":"210540280","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"247381","insp_unit_license":"P812053","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA7628KB155654","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-14T10:01:52.000000Z","updated_at":"2025-12-15T10:00:36.000000Z"}]},{"id":10286006,"change_date":"2025-11-25 21:38:00","inspection_id":"86411000","dot_number":"527487","report_state":"MO","report_number":"1645003602","insp_date":"2025-11-25 00:00:00","insp_start_time":"0911","insp_end_time":"0935","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"ST. LOUIS MO","county_code_state":"MO","county_code":"510","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-11-25 21:38: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":"2586519","transaction_code":"A","transaction_date":"2025-11-25 00:00:00","upload_date":"2025-11-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00527487","upload_search_indicator":null,"census_search_date":"2025-11-25 21:38:00","snet_input_date":"2025-11-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-11-25 21:38:00","insp_carrier_name":"SYSCO ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-28T10:31:50.000000Z","updated_at":"2025-11-29T10:30:46.000000Z","inspection_violations":[{"id":17199473,"change_date":"2025-11-25 21:38:00","inspection_id":"86411000","insp_violation_id":"270285401","seq_no":"1","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"210254403","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-28T10:32:46.000000Z","updated_at":"2025-11-29T10:31:08.000000Z","normalized_code":"39617CPI"},{"id":17199474,"change_date":"2025-11-25 21:38:00","inspection_id":"86411000","insp_violation_id":"270285402","seq_no":"2","part_no":"392","part_no_section":"2-SLLIRP","insp_viol_unit":"1","insp_unit_id":"210254402","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-28T10:32:46.000000Z","updated_at":"2025-11-29T10:31:08.000000Z","normalized_code":"3922SLLIRP"}],"inspection_per_units":[{"id":17173844,"change_date":"2025-11-25 21:38:00","inspection_id":"86411000","insp_unit_id":"210254402","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"STL_140785","insp_unit_license":"3786976","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN2AY6LM001947","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-28T10:01:39.000000Z","updated_at":"2025-11-29T10:00:52.000000Z"},{"id":17173845,"change_date":"2025-11-25 21:38:00","inspection_id":"86411000","insp_unit_id":"210254403","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"255168","insp_unit_license":"PF14953","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V382K1RJ286062","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-28T10:01:39.000000Z","updated_at":"2025-11-29T10:00:52.000000Z"}]},{"id":10307408,"change_date":"2025-11-30 21:32:00","inspection_id":"86433523","dot_number":"527487","report_state":"MO","report_number":"3854000973","insp_date":"2025-11-24 00:00:00","insp_start_time":"0852","insp_end_time":"0920","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"WILDWOOD MO","county_code_state":"MO","county_code":null,"insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-11-30 21:32: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":"2599422","transaction_code":"A","transaction_date":"2025-11-29 00:00:00","upload_date":"2025-11-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00527487","upload_search_indicator":null,"census_search_date":"2025-11-30 21:32:00","snet_input_date":"2025-11-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-11-30 21:32:00","insp_carrier_name":"SYSCO ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-03T10:30:20.000000Z","updated_at":"2025-12-04T10:30:03.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17211881,"change_date":"2025-11-30 21:32:00","inspection_id":"86433523","insp_unit_id":"210305345","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"150030","insp_unit_license":"3786765","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKBHTDV4SSWC5455","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-03T10:00:23.000000Z","updated_at":"2025-12-04T10:00:05.000000Z"},{"id":17211882,"change_date":"2025-11-30 21:32:00","inspection_id":"86433523","insp_unit_id":"210305346","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"253473","insp_unit_license":"PC93792","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V382K9PJ133006","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-03T10:00:23.000000Z","updated_at":"2025-12-04T10:00:05.000000Z"}]},{"id":9993574,"change_date":"2025-10-21 21:38:00","inspection_id":"86103366","dot_number":"527487","report_state":"MO","report_number":"1645003375","insp_date":"2025-10-20 00:00:00","insp_start_time":"1357","insp_end_time":"1421","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"ST. LOUIS MO","county_code_state":"MO","county_code":"510","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"1138","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-10-21 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"102700","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2438015","transaction_code":"A","transaction_date":"2025-10-20 00:00:00","upload_date":"2025-10-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00527487","upload_search_indicator":null,"census_search_date":"2025-10-21 21:38:00","snet_input_date":"2025-10-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-21 21:38:00","insp_carrier_name":"SYSCO ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-24T10:01:42.000000Z","updated_at":"2025-10-25T10:00:13.000000Z","inspection_violations":[{"id":16513569,"change_date":"2025-10-21 21:38:00","inspection_id":"86103366","insp_violation_id":"269417146","seq_no":"1","part_no":"393","part_no_section":"55D2-B","insp_viol_unit":"1","insp_unit_id":"209570667","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-24T10:17:42.000000Z","updated_at":"2025-10-25T10:15:20.000000Z","normalized_code":"39355D2B"},{"id":16513570,"change_date":"2025-10-21 21:38:00","inspection_id":"86103366","insp_violation_id":"269417147","seq_no":"2","part_no":"393","part_no_section":"55C1-B","insp_viol_unit":"1","insp_unit_id":"209570667","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-24T10:17:42.000000Z","updated_at":"2025-10-25T10:15:20.000000Z","normalized_code":"39355C1B"},{"id":16513571,"change_date":"2025-10-21 21:38:00","inspection_id":"86103366","insp_violation_id":"269417148","seq_no":"3","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"209570667","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-24T10:17:42.000000Z","updated_at":"2025-10-25T10:15:20.000000Z","normalized_code":"3939ALHLI"}],"inspection_per_units":[{"id":16595302,"change_date":"2025-10-21 21:38:00","inspection_id":"86103366","insp_unit_id":"209570667","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"STL_132218","insp_unit_license":"2028350","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUBGBDV3ELFA8529","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-24T09:47:00.000000Z","updated_at":"2025-10-25T09:45:15.000000Z"},{"id":16595303,"change_date":"2025-10-21 21:38:00","inspection_id":"86103366","insp_unit_id":"209570668","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"253553","insp_unit_license":"PC93737","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V382K5PJ133083","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-24T09:47:00.000000Z","updated_at":"2025-10-25T09:45:15.000000Z"}]},{"id":9850464,"change_date":"2025-10-03 21:40:00","inspection_id":"85952241","dot_number":"527487","report_state":"IL","report_number":"4165720183","insp_date":"2025-09-29 00:00:00","insp_start_time":"1420","insp_end_time":"1441","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"US HWY 50","county_code_state":"IL","county_code":"025","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SYSCO FOODS","shipping_paper_number":"0821459","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-10-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"76700","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":"2435908","transaction_code":"A","transaction_date":"2025-09-29 00:00:00","upload_date":"2025-10-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00527487","upload_search_indicator":null,"census_search_date":"2025-10-03 21:40:00","snet_input_date":"2025-09-29 00:00:00","source_office":"3ILS001","mcmis_add_date":"2025-10-03 21:40:00","insp_carrier_name":"SYSCO ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-05T10:02:24.000000Z","updated_at":"2025-10-08T10:01:02.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16336387,"change_date":"2025-10-03 21:40:00","inspection_id":"85952241","insp_unit_id":"209288983","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRT","insp_unit_company":"STL_150029","insp_unit_license":"2987140","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKBHTDV2SSWC5454","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-05T09:47:16.000000Z","updated_at":"2025-10-08T09:46:15.000000Z"},{"id":16336388,"change_date":"2025-10-03 21:40:00","inspection_id":"85952241","insp_unit_id":"209288984","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDN","insp_unit_company":"246582","insp_unit_license":"P668477","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA5611JB130430","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-05T09:47:16.000000Z","updated_at":"2025-10-08T09:46:15.000000Z"}]},{"id":9716630,"change_date":"2025-09-18 21:42:00","inspection_id":"85812257","dot_number":"527487","report_state":"MO","report_number":"1645003249","insp_date":"2025-09-18 00:00:00","insp_start_time":"1318","insp_end_time":"1350","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"ST. LOUIS MO","county_code_state":"MO","county_code":"510","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"4414","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-09-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2295439","transaction_code":"A","transaction_date":"2025-09-18 00:00:00","upload_date":"2025-09-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00527487","upload_search_indicator":null,"census_search_date":"2025-09-18 21:42:00","snet_input_date":"2025-09-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-18 21:42:00","insp_carrier_name":"SYSCO ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-23T10:02:20.000000Z","updated_at":"2025-09-23T10:02:20.000000Z","inspection_violations":[{"id":15952429,"change_date":"2025-09-18 21:42:00","inspection_id":"85812257","insp_violation_id":"268780209","seq_no":"1","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"209022242","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-22T10:17:41.000000Z","updated_at":"2025-09-22T10:17:41.000000Z","normalized_code":"39617CPI"},{"id":15952430,"change_date":"2025-09-18 21:42:00","inspection_id":"85812257","insp_violation_id":"268780210","seq_no":"2","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"209022242","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-22T10:17:41.000000Z","updated_at":"2025-09-22T10:17:41.000000Z","normalized_code":"39395A4EEUS"},{"id":15952431,"change_date":"2025-09-18 21:42:00","inspection_id":"85812257","insp_violation_id":"268780211","seq_no":"3","part_no":"392","part_no_section":"2-MCSR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-22T10:17:41.000000Z","updated_at":"2025-09-22T10:17:41.000000Z","normalized_code":"3922MCSR"},{"id":15952432,"change_date":"2025-09-18 21:42:00","inspection_id":"85812257","insp_violation_id":"268780212","seq_no":"4","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"209022242","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-22T10:17:41.000000Z","updated_at":"2025-09-22T10:17:41.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":16089435,"change_date":"2025-09-18 21:42:00","inspection_id":"85812257","insp_unit_id":"209022242","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"STL_138369","insp_unit_license":"3786859","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4WC9EG3KN208914","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-21T09:45:54.000000Z","updated_at":"2025-09-22T09:46:04.000000Z"},{"id":16089436,"change_date":"2025-09-18 21:42:00","inspection_id":"85812257","insp_unit_id":"209022243","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"247380","insp_unit_license":"P812052","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA7626KB155653","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-21T09:45:54.000000Z","updated_at":"2025-09-22T09:46:04.000000Z"}]},{"id":9508612,"change_date":"2025-08-26 21:40:00","inspection_id":"85593744","dot_number":"527487","report_state":"MO","report_number":"3698002152","insp_date":"2025-08-26 00:00:00","insp_start_time":"1002","insp_end_time":"1027","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"ST. LOUIS MO","county_code_state":"MO","county_code":"510","insp_level_id":"2","service_center":"MW","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":"U","pen_cen_match":"I","final_status_date":"2025-08-26 21:40: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":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2180317","transaction_code":"A","transaction_date":"2025-08-26 00:00:00","upload_date":"2025-08-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00527487","upload_search_indicator":null,"census_search_date":"2025-08-26 21:40:00","snet_input_date":"2025-08-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-26 21:40:00","insp_carrier_name":"SYSCO ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-29T10:43:03.000000Z","updated_at":"2025-09-05T10:46:30.000000Z","inspection_violations":[{"id":15511926,"change_date":"2025-08-26 21:40:00","inspection_id":"85593744","insp_violation_id":"268253933","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"208586182","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-05T10:49:45.000000Z","updated_at":"2025-09-05T10:49:45.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":15690779,"change_date":"2025-08-26 21:40:00","inspection_id":"85593744","insp_unit_id":"208586182","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"137021","insp_unit_license":"2488856","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4M39EG2JN890349","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-29T09:46:39.000000Z","updated_at":"2025-09-05T09:45:48.000000Z"},{"id":15690780,"change_date":"2025-08-26 21:40:00","inspection_id":"85593744","insp_unit_id":"208586183","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"247378","insp_unit_license":"P812012","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA5618KB155648","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-29T09:46:39.000000Z","updated_at":"2025-09-05T09:45:48.000000Z"}]},{"id":9400648,"change_date":"2025-08-13 21:39:00","inspection_id":"85480119","dot_number":"527487","report_state":"MO","report_number":"1645003040","insp_date":"2025-08-13 00:00:00","insp_start_time":"1007","insp_end_time":"1028","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"ST. LOUIS MO","county_code_state":"MO","county_code":"510","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-08-13 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"91000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2124292","transaction_code":"A","transaction_date":"2025-08-13 00:00:00","upload_date":"2025-08-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00527487","upload_search_indicator":null,"census_search_date":"2025-08-13 21:39:00","snet_input_date":"2025-08-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-13 21:39:00","insp_carrier_name":"SYSCO ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-16T10:01:22.000000Z","updated_at":"2025-08-17T10:00:34.000000Z","inspection_violations":[{"id":15288159,"change_date":"2025-08-13 21:39:00","inspection_id":"85480119","insp_violation_id":"268002799","seq_no":"1","part_no":"393","part_no_section":"23-LEU","insp_viol_unit":"2","insp_unit_id":"208374906","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-08-16T10:45:04.000000Z","updated_at":"2025-08-17T10:44:15.000000Z","normalized_code":"39323LEU"}],"inspection_per_units":[{"id":15493454,"change_date":"2025-08-13 21:39:00","inspection_id":"85480119","insp_unit_id":"208374905","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"135821","insp_unit_license":"2488209","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4NC9EH5HN984409","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-16T09:46:36.000000Z","updated_at":"2025-08-17T09:45:40.000000Z"},{"id":15493455,"change_date":"2025-08-13 21:39:00","inspection_id":"85480119","insp_unit_id":"208374906","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"246582","insp_unit_license":"P668477","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA5611JB130430","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-16T09:46:36.000000Z","updated_at":"2025-08-17T09:45:40.000000Z"}]},{"id":8421937,"change_date":"2025-04-19 21:33:00","inspection_id":"84447958","dot_number":"527487","report_state":"IL","report_number":"4243930069","insp_date":"2025-04-18 00:00:00","insp_start_time":"0316","insp_end_time":"0332","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"I-270","county_code_state":"IL","county_code":"119","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CHEMTREC","shipping_paper_number":"S2K0BJOWNR","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":null,"final_status_date":"2025-04-19 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"80740","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":"2399212","transaction_code":"A","transaction_date":"2025-04-18 00:00:00","upload_date":"2025-04-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00527487","upload_search_indicator":null,"census_search_date":"2025-04-19 21:33:00","snet_input_date":"2025-04-18 00:00:00","source_office":"3ILS001","mcmis_add_date":"2025-04-19 21:33:00","insp_carrier_name":"SYSCO ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-23T10:02:54.000000Z","updated_at":"2025-04-23T10:04:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13674349,"change_date":"2025-04-19 21:33:00","inspection_id":"84447958","insp_unit_id":"206399909","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KID","insp_unit_company":"244083","insp_unit_license":"PE52911","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN2AY7LM001942","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-22T10:08:02.000000Z","updated_at":"2025-04-23T09:53:01.000000Z"},{"id":13674348,"change_date":"2025-04-19 21:33:00","inspection_id":"84447958","insp_unit_id":"206399908","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MCK","insp_unit_company":"140783","insp_unit_license":"2802470","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN2AY7LM001942","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-22T10:08:02.000000Z","updated_at":"2025-04-23T09:53:01.000000Z"}]},{"id":8360093,"change_date":"2025-04-12 21:33:00","inspection_id":"84382754","dot_number":"527487","report_state":"MO","report_number":"4427001257","insp_date":"2025-04-08 00:00:00","insp_start_time":"1118","insp_end_time":"1144","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"ST. LOUIS MO","county_code_state":"MO","county_code":null,"insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"464104669","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-12 21:33: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":"1586750","transaction_code":"A","transaction_date":"2025-04-12 00:00:00","upload_date":"2025-04-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00527487","upload_search_indicator":null,"census_search_date":"2025-04-12 21:33:00","snet_input_date":"2025-04-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-12 21:33:00","insp_carrier_name":"SYSCO ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-15T10:14:26.000000Z","updated_at":"2025-04-16T10:01:02.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13565060,"change_date":"2025-04-12 21:33:00","inspection_id":"84382754","insp_unit_id":"206281499","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"137022","insp_unit_license":"2488857","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4M39EG9JN890350","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-15T10:08:07.000000Z","updated_at":"2025-04-16T09:53:50.000000Z"},{"id":13565061,"change_date":"2025-04-12 21:33:00","inspection_id":"84382754","insp_unit_id":"206281500","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"247379","insp_unit_license":"P812051","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA7624KB155652","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-15T10:08:07.000000Z","updated_at":"2025-04-16T09:53:50.000000Z"}]},{"id":8177052,"change_date":"2025-03-21 21:40:00","inspection_id":"84190070","dot_number":"527487","report_state":"MO","report_number":"3214000499","insp_date":"2025-03-21 00:00:00","insp_start_time":"1401","insp_end_time":"1435","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"ST. LOUIS MO","county_code_state":"MO","county_code":"510","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SYSCO","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-03-21 21:40: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":"1499235","transaction_code":"A","transaction_date":"2025-03-21 00:00:00","upload_date":"2025-03-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00527487","upload_search_indicator":null,"census_search_date":"2025-03-21 21:40:00","snet_input_date":"2025-03-21 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-21 21:40:00","insp_carrier_name":"SYSCO ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-24T10:27:55.000000Z","updated_at":"2025-03-25T10:10:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13217768,"change_date":"2025-03-21 21:40:00","inspection_id":"84190070","insp_unit_id":"205924751","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"STL-140785","insp_unit_license":"2802455","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN2AY6LM001947","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-24T10:14:24.000000Z","updated_at":"2025-03-25T09:55:41.000000Z"},{"id":13217769,"change_date":"2025-03-21 21:40:00","inspection_id":"84190070","insp_unit_id":"205924752","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"255168","insp_unit_license":"PF14953","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V382K1RJ286062","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-24T10:14:24.000000Z","updated_at":"2025-03-25T09:55:41.000000Z"}]},{"id":8133274,"change_date":"2025-03-17 21:40:00","inspection_id":"84144080","dot_number":"527487","report_state":"MO","report_number":"T043600022","insp_date":"2025-03-13 00:00:00","insp_start_time":"1143","insp_end_time":"1219","registration_date":null,"region":"CD","ci_status_code":"C","location":"SYSCO1","location_desc":"ST CHARLES MO","county_code_state":"MO","county_code":"183","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-03-17 21:40: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":"1481815","transaction_code":"A","transaction_date":"2025-03-17 00:00:00","upload_date":"2025-03-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00527487","upload_search_indicator":null,"census_search_date":"2025-03-17 21:40:00","snet_input_date":"2025-03-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-17 21:40:00","insp_carrier_name":"SYSCO ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-21T10:19:50.000000Z","updated_at":"2025-03-21T10:19:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13134391,"change_date":"2025-03-17 21:40:00","inspection_id":"84144080","insp_unit_id":"205834183","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"137021","insp_unit_license":"2488856","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4M39EG2JN890349","insp_unit_decal":"Y","insp_unit_decal_number":"35012963","created_at":"2025-03-21T09:53:57.000000Z","updated_at":"2025-03-21T10:02:58.000000Z"}]},{"id":8133286,"change_date":"2025-03-17 21:40:00","inspection_id":"84144094","dot_number":"527487","report_state":"MO","report_number":"T043400127","insp_date":"2025-03-13 00:00:00","insp_start_time":"1150","insp_end_time":"1225","registration_date":null,"region":"CD","ci_status_code":"C","location":"SYS SC","location_desc":"ST CHARLES MO","county_code_state":"MO","county_code":"183","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-03-17 21:40: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":"1481811","transaction_code":"A","transaction_date":"2025-03-17 00:00:00","upload_date":"2025-03-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00527487","upload_search_indicator":null,"census_search_date":"2025-03-17 21:40:00","snet_input_date":"2025-03-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-17 21:40:00","insp_carrier_name":"SYSCO ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-21T10:19:50.000000Z","updated_at":"2025-03-21T10:19:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13134412,"change_date":"2025-03-17 21:40:00","inspection_id":"84144094","insp_unit_id":"205834208","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"145797","insp_unit_license":"3481062","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKBHTDV8PDUP1803","insp_unit_decal":"Y","insp_unit_decal_number":"35012959","created_at":"2025-03-21T09:53:57.000000Z","updated_at":"2025-03-21T10:02:58.000000Z"}]},{"id":7960742,"change_date":"2025-02-26 21:40:00","inspection_id":"83962476","dot_number":"527487","report_state":"MO","report_number":"1645002384","insp_date":"2025-02-25 00:00:00","insp_start_time":"1812","insp_end_time":"1834","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"ST. LOUIS MO","county_code_state":"MO","county_code":"510","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"464049582","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-02-26 21:40: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":"1399289","transaction_code":"A","transaction_date":"2025-02-25 00:00:00","upload_date":"2025-02-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00527487","upload_search_indicator":null,"census_search_date":"2025-02-26 21:40:00","snet_input_date":"2025-02-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-26 21:40:00","insp_carrier_name":"SYSCO ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:03:36.000000Z","updated_at":"2025-03-17T21:03:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12850909,"change_date":"2025-02-26 21:40:00","inspection_id":"83962476","insp_unit_id":"205498965","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"STL_143566","insp_unit_license":"3283533","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN3AY5PM003314","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:56:58.000000Z","updated_at":"2025-03-17T23:56:58.000000Z"},{"id":12850910,"change_date":"2025-02-26 21:40:00","inspection_id":"83962476","insp_unit_id":"205498966","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"246019","insp_unit_license":"P668196","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA7627JB705716","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:56:58.000000Z","updated_at":"2025-03-17T23:56:58.000000Z"}]},{"id":7681677,"change_date":"2025-01-22 21:39:00","inspection_id":"83669562","dot_number":"527487","report_state":"MO","report_number":"0838000270","insp_date":"2025-01-22 00:00:00","insp_start_time":"1009","insp_end_time":"1057","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"CUBA MO","county_code_state":"MO","county_code":"055","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-01-22 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"72000","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1276119","transaction_code":"A","transaction_date":"2025-01-22 00:00:00","upload_date":"2025-01-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00527487","upload_search_indicator":null,"census_search_date":"2025-01-22 21:39:00","snet_input_date":"2025-01-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-22 21:39:00","insp_carrier_name":"SYSCO ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:57:51.000000Z","updated_at":"2025-03-17T20:57:51.000000Z","inspection_violations":[{"id":12003101,"change_date":"2025-01-22 21:39:00","inspection_id":"83669562","insp_violation_id":"264119824","seq_no":"1","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"204952728","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:31.000000Z","updated_at":"2025-03-17T22:04:31.000000Z","normalized_code":"39617CPI"},{"id":12003102,"change_date":"2025-01-22 21:39:00","inspection_id":"83669562","insp_violation_id":"264119825","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"204952727","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:31.000000Z","updated_at":"2025-03-17T22:04:31.000000Z","normalized_code":"3922SLLSR"},{"id":12003103,"change_date":"2025-01-22 21:39:00","inspection_id":"83669562","insp_violation_id":"264119826","seq_no":"3","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"204952727","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:31.000000Z","updated_at":"2025-03-17T22:04:31.000000Z","normalized_code":"39617CPI"},{"id":12003104,"change_date":"2025-01-22 21:39:00","inspection_id":"83669562","insp_violation_id":"264119827","seq_no":"4","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"2","insp_unit_id":"204952728","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:31.000000Z","updated_at":"2025-03-17T22:04:31.000000Z","normalized_code":"39345DB"}],"inspection_per_units":[{"id":12395442,"change_date":"2025-01-22 21:39:00","inspection_id":"83669562","insp_unit_id":"204952727","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"STL_143563","insp_unit_license":"3216144","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN3AY5PM003331","insp_unit_decal":"Y","insp_unit_decal_number":"34991690","created_at":"2025-03-17T23:51:49.000000Z","updated_at":"2025-03-17T23:51:49.000000Z"},{"id":12395443,"change_date":"2025-01-22 21:39:00","inspection_id":"83669562","insp_unit_id":"204952728","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"P668479","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"1GRAA5615JB130429","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:49.000000Z","updated_at":"2025-03-17T23:51:49.000000Z"}]},{"id":7413733,"change_date":"2024-12-13 21:40:00","inspection_id":"83388121","dot_number":"527487","report_state":"IL","report_number":"4069050896","insp_date":"2024-12-12 00:00:00","insp_start_time":"0945","insp_end_time":"0953","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"I64","county_code_state":"IL","county_code":"191","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SYSCO","shipping_paper_number":"364959416","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-12-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"96000","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":"2377412","transaction_code":"A","transaction_date":"2024-12-12 00:00:00","upload_date":"2024-12-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00527487","upload_search_indicator":null,"census_search_date":"2024-12-13 21:40:00","snet_input_date":"2024-12-12 00:00:00","source_office":"3ILS001","mcmis_add_date":"2024-12-13 21:40:00","insp_carrier_name":"SYSCO ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:50:47.000000Z","updated_at":"2025-03-17T20:50:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11960046,"change_date":"2024-12-13 21:40:00","inspection_id":"83388121","insp_unit_id":"204373402","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"140786","insp_unit_license":"2802386","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN2AY3LM001940","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:47:03.000000Z","updated_at":"2025-03-17T23:47:03.000000Z"},{"id":11960047,"change_date":"2024-12-13 21:40:00","inspection_id":"83388121","insp_unit_id":"204373403","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"246582","insp_unit_license":"P668477","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA5611JB130430","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:47:03.000000Z","updated_at":"2025-03-17T23:47:03.000000Z"}]},{"id":7343437,"change_date":"2024-12-05 21:37:00","inspection_id":"83314212","dot_number":"527487","report_state":"MO","report_number":"8753000451","insp_date":"2024-12-04 00:00:00","insp_start_time":"1532","insp_end_time":"1550","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"ST. LOUIS MO","county_code_state":"MO","county_code":"510","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-12-05 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1119762","transaction_code":"A","transaction_date":"2024-12-05 00:00:00","upload_date":"2024-12-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00527487","upload_search_indicator":null,"census_search_date":"2024-12-05 21:37:00","snet_input_date":"2024-12-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-12-05 21:37:00","insp_carrier_name":"SYSCO ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:49:22.000000Z","updated_at":"2025-03-17T20:49:22.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11845811,"change_date":"2024-12-05 21:37:00","inspection_id":"83314212","insp_unit_id":"204196339","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":null,"insp_unit_license":"2488856","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4M39EG2JN890349","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:49.000000Z","updated_at":"2025-03-17T23:45:49.000000Z"},{"id":11845812,"change_date":"2024-12-05 21:37:00","inspection_id":"83314212","insp_unit_id":"204196340","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"208169","insp_unit_license":"31A025","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1GRAA76257B702998","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:49.000000Z","updated_at":"2025-03-17T23:45:49.000000Z"}]},{"id":7128408,"change_date":"2024-11-06 21:39:00","inspection_id":"83086974","dot_number":"527487","report_state":"MO","report_number":"8753000380","insp_date":"2024-11-05 00:00:00","insp_start_time":"1604","insp_end_time":"1625","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"ST. LOUIS MO","county_code_state":"MO","county_code":"510","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-11-06 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1022949","transaction_code":"A","transaction_date":"2024-11-05 00:00:00","upload_date":"2024-11-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00527487","upload_search_indicator":null,"census_search_date":"2024-11-06 21:39:00","snet_input_date":"2024-11-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-06 21:39:00","insp_carrier_name":"SYSCO ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:44:40.000000Z","updated_at":"2025-03-17T20:44:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11497268,"change_date":"2024-11-06 21:39:00","inspection_id":"83086974","insp_unit_id":"203750519","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"138369","insp_unit_license":"2778983","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4WC9EG3KN208914","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:42:07.000000Z","updated_at":"2025-03-17T23:42:07.000000Z"},{"id":11497269,"change_date":"2024-11-06 21:39:00","inspection_id":"83086974","insp_unit_id":"203750520","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"230720","insp_unit_license":"14B820","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1GRAA7624CB703442","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:42:07.000000Z","updated_at":"2025-03-17T23:42:07.000000Z"}]},{"id":7087180,"change_date":"2024-10-31 21:41:00","inspection_id":"83043250","dot_number":"527487","report_state":"MO","report_number":"4427000973","insp_date":"2024-10-30 00:00:00","insp_start_time":"0629","insp_end_time":"0653","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"AFFTON MO","county_code_state":"MO","county_code":null,"insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"DAY SHEET","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-10-31 21:41: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":"1002828","transaction_code":"A","transaction_date":"2024-10-31 00:00:00","upload_date":"2024-10-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00527487","upload_search_indicator":null,"census_search_date":"2024-10-31 21:41:00","snet_input_date":"2024-10-30 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-31 21:41:00","insp_carrier_name":"SYSCO ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:43:51.000000Z","updated_at":"2025-03-17T20:43:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11430083,"change_date":"2024-10-31 21:41:00","inspection_id":"83043250","insp_unit_id":"203668569","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"143567","insp_unit_license":"3216260","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN3AY0PM003334","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:23.000000Z","updated_at":"2025-03-17T23:41:23.000000Z"},{"id":11430084,"change_date":"2024-10-31 21:41:00","inspection_id":"83043250","insp_unit_id":"203668570","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":null,"insp_unit_license":"PF14952","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V382KXRJ286061","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:23.000000Z","updated_at":"2025-03-17T23:41:23.000000Z"}]},{"id":7045688,"change_date":"2024-10-25 21:40:00","inspection_id":"82999328","dot_number":"527487","report_state":"MO","report_number":"1645001962","insp_date":"2024-10-25 00:00:00","insp_start_time":"1101","insp_end_time":"1131","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"ST. LOUIS MO","county_code_state":"MO","county_code":"510","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"0787438","cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-10-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"99700","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"985492","transaction_code":"A","transaction_date":"2024-10-25 00:00:00","upload_date":"2024-10-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00527487","upload_search_indicator":null,"census_search_date":"2024-10-25 21:40:00","snet_input_date":"2024-10-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-25 21:40:00","insp_carrier_name":"SYSCO ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:43:00.000000Z","updated_at":"2025-03-17T20:43:00.000000Z","inspection_violations":[{"id":10996587,"change_date":"2024-10-25 21:40:00","inspection_id":"82999328","insp_violation_id":"262557050","seq_no":"1","part_no":"392","part_no_section":"2-SLLIRP","insp_viol_unit":"1","insp_unit_id":"203586784","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:18.000000Z","updated_at":"2025-03-17T21:59:18.000000Z","normalized_code":"3922SLLIRP"},{"id":10996588,"change_date":"2024-10-25 21:40:00","inspection_id":"82999328","insp_violation_id":"262557051","seq_no":"2","part_no":"392","part_no_section":"2-SLLSIV","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:59:18.000000Z","updated_at":"2025-03-17T21:59:18.000000Z","normalized_code":"3922SLLSIV"}],"inspection_per_units":[{"id":11363196,"change_date":"2024-10-25 21:40:00","inspection_id":"82999328","insp_unit_id":"203586784","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"131693","insp_unit_license":"2987140","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUBGBDV5DLFA8322","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:39.000000Z","updated_at":"2025-03-17T23:40:39.000000Z"},{"id":11363197,"change_date":"2024-10-25 21:40:00","inspection_id":"82999328","insp_unit_id":"203586785","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":"208175","insp_unit_license":"08B309","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1K913382974054491","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:39.000000Z","updated_at":"2025-03-17T23:40:39.000000Z"}]},{"id":6975158,"change_date":"2024-10-17 21:41:00","inspection_id":"82924330","dot_number":"527487","report_state":"MO","report_number":"3698001306","insp_date":"2024-10-16 00:00:00","insp_start_time":"1526","insp_end_time":"1548","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"ST. LOUIS MO","county_code_state":"MO","county_code":"510","insp_level_id":"2","service_center":"MW","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":"U","pen_cen_match":"I","final_status_date":"2024-10-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"100000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"951990","transaction_code":"A","transaction_date":"2024-10-16 00:00:00","upload_date":"2024-10-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00527487","upload_search_indicator":null,"census_search_date":"2024-10-17 21:41:00","snet_input_date":"2024-10-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-17 21:41:00","insp_carrier_name":"SYSCO ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:41:26.000000Z","updated_at":"2025-03-17T20:41:26.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11250237,"change_date":"2024-10-17 21:41:00","inspection_id":"82924330","insp_unit_id":"203444312","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"STL_136483","insp_unit_license":"2488655","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4M39EG9JN991176","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:28.000000Z","updated_at":"2025-03-17T23:39:28.000000Z"},{"id":11250238,"change_date":"2024-10-17 21:41:00","inspection_id":"82924330","insp_unit_id":"203444313","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"243113","insp_unit_license":"PB84693","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA7620GB701659","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:28.000000Z","updated_at":"2025-03-17T23:39:28.000000Z"}]},{"id":6808097,"change_date":"2024-09-24 21:41:00","inspection_id":"82746946","dot_number":"527487","report_state":"IL","report_number":"4165720133","insp_date":"2024-09-23 00:00:00","insp_start_time":"1403","insp_end_time":"1409","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"US-50","county_code_state":"IL","county_code":"025","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SYSCO ST. LOUIS LLC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-24 21:41: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":"2360186","transaction_code":"A","transaction_date":"2024-09-23 00:00:00","upload_date":"2024-09-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00527487","upload_search_indicator":null,"census_search_date":"2024-09-24 21:41:00","snet_input_date":"2024-09-23 00:00:00","source_office":"3ILS001","mcmis_add_date":"2024-09-24 21:41:00","insp_carrier_name":"SYSCO ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:38:12.000000Z","updated_at":"2025-03-17T20:38:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10978626,"change_date":"2024-09-24 21:41:00","inspection_id":"82746946","insp_unit_id":"203107501","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MCK","insp_unit_company":"STL_140784","insp_unit_license":"2779596","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN2AY5LM001941","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:42.000000Z","updated_at":"2025-03-17T23:36:42.000000Z"},{"id":10978627,"change_date":"2024-09-24 21:41:00","inspection_id":"82746946","insp_unit_id":"203107502","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDN","insp_unit_company":"250903","insp_unit_license":"PA41211","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GR1A5618MB313456","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:42.000000Z","updated_at":"2025-03-17T23:36:42.000000Z"}]},{"id":6769334,"change_date":"2024-09-19 21:42:00","inspection_id":"82705419","dot_number":"527487","report_state":"IL","report_number":"4292830324","insp_date":"2024-09-18 00:00:00","insp_start_time":"0946","insp_end_time":"1010","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"I-57","county_code_state":"IL","county_code":"199","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SYSCO","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"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-19 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"386000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2358054","transaction_code":"A","transaction_date":"2024-09-18 00:00:00","upload_date":"2024-09-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00527487","upload_search_indicator":null,"census_search_date":"2024-09-19 21:42:00","snet_input_date":"2024-09-18 00:00:00","source_office":"3ILS001","mcmis_add_date":"2024-09-19 21:42:00","insp_carrier_name":"SYSCO ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:37:20.000000Z","updated_at":"2025-03-17T20:37:20.000000Z","inspection_violations":[{"id":10541672,"change_date":"2024-09-19 21:42:00","inspection_id":"82705419","insp_violation_id":"261922140","seq_no":"1","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"203029122","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:04.000000Z","updated_at":"2025-03-17T21:57:04.000000Z","normalized_code":"39345B2"},{"id":10541673,"change_date":"2024-09-19 21:42:00","inspection_id":"82705419","insp_violation_id":"261922141","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"203029122","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:04.000000Z","updated_at":"2025-03-17T21:57:04.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10915868,"change_date":"2024-09-19 21:42:00","inspection_id":"82705419","insp_unit_id":"203029122","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"140782","insp_unit_license":"2779595","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN2AY9LM001943","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:05.000000Z","updated_at":"2025-03-17T23:36:05.000000Z"},{"id":10915869,"change_date":"2024-09-19 21:42:00","inspection_id":"82705419","insp_unit_id":"203029123","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"229388","insp_unit_license":"PB84537","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA5618DB711928","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:05.000000Z","updated_at":"2025-03-17T23:36:05.000000Z"}]},{"id":6625218,"change_date":"2024-09-04 21:41:00","inspection_id":"82552102","dot_number":"527487","report_state":"MO","report_number":"3214000313","insp_date":"2024-08-29 00:00:00","insp_start_time":"1358","insp_end_time":"1445","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"ST. LOUIS MO","county_code_state":"MO","county_code":null,"insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SYSCO","shipping_paper_number":"0780930","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:41:00","post_acc_ind":"N","gross_comb_veh_wt":"99700","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"797569","transaction_code":"C","transaction_date":"2024-08-29 00:00:00","upload_date":"2024-09-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00527487","upload_search_indicator":null,"census_search_date":"2024-09-03 21:41:00","snet_input_date":"2024-08-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-09-03 21:41:00","insp_carrier_name":"SYSCO ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:34:26.000000Z","updated_at":"2025-03-17T20:34:26.000000Z","inspection_violations":[{"id":10304611,"change_date":"2024-09-04 21:41:00","inspection_id":"82552102","insp_violation_id":"261592419","seq_no":"1","part_no":"393","part_no_section":"11(a)(1)","insp_viol_unit":"1","insp_unit_id":"202741849","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:56.000000Z","updated_at":"2025-03-17T21:55:56.000000Z","normalized_code":"39311A1"},{"id":10304612,"change_date":"2024-09-04 21:41:00","inspection_id":"82552102","insp_violation_id":"261592420","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202741849","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:56.000000Z","updated_at":"2025-03-17T21:55:56.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10681750,"change_date":"2024-09-04 21:41:00","inspection_id":"82552102","insp_unit_id":"202741849","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"STL_132068","insp_unit_license":"2028246","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUBGBDV0ELFA8407","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":10681751,"change_date":"2024-09-04 21:41:00","inspection_id":"82552102","insp_unit_id":"202741850","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":"208170","insp_unit_license":"02A812","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1K913382174054159","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":6593345,"change_date":"2024-08-29 21:42:00","inspection_id":"82517939","dot_number":"527487","report_state":"MO","report_number":"0838000209","insp_date":"2024-08-28 00:00:00","insp_start_time":"0908","insp_end_time":"0920","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"VIENNA MO","county_code_state":"MO","county_code":"125","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"780753","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-08-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"72000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"797109","transaction_code":"A","transaction_date":"2024-08-29 00:00:00","upload_date":"2024-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00527487","upload_search_indicator":null,"census_search_date":"2024-08-29 21:42:00","snet_input_date":"2024-08-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-29 21:42:00","insp_carrier_name":"SYSCO ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:33:41.000000Z","updated_at":"2025-03-17T20:33:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10629920,"change_date":"2024-08-29 21:42:00","inspection_id":"82517939","insp_unit_id":"202647134","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"143564","insp_unit_license":"3216185","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN3AY7PM003332","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:04.000000Z","updated_at":"2025-03-17T23:33:04.000000Z"},{"id":10629921,"change_date":"2024-08-29 21:42:00","inspection_id":"82517939","insp_unit_id":"202647135","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"PA41212","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GR1A561XMB313457","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:04.000000Z","updated_at":"2025-03-17T23:33:04.000000Z"}]},{"id":6489857,"change_date":"2024-08-16 21:39:00","inspection_id":"82407952","dot_number":"527487","report_state":"IL","report_number":"4127010232","insp_date":"2024-08-16 00:00:00","insp_start_time":"0646","insp_end_time":"0655","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"148","county_code_state":"IL","county_code":"055","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"20000","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":"2349722","transaction_code":"A","transaction_date":"2024-08-16 00:00:00","upload_date":"2024-08-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00527487","upload_search_indicator":null,"census_search_date":"2024-08-16 21:39:00","snet_input_date":"2024-08-16 00:00:00","source_office":"3ILS001","mcmis_add_date":"2024-08-16 21:39:00","insp_carrier_name":"SYSCO ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:31:34.000000Z","updated_at":"2025-03-17T20:31:34.000000Z","inspection_violations":[{"id":10076462,"change_date":"2024-08-16 21:39:00","inspection_id":"82407952","insp_violation_id":"261237352","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":"4","citation_number":null,"created_at":"2025-03-17T21:54:44.000000Z","updated_at":"2025-03-17T21:54:44.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10461293,"change_date":"2024-08-16 21:39:00","inspection_id":"82407952","insp_unit_id":"202437477","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"140783","insp_unit_license":"2802470","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN2AY7LM001942","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:23.000000Z","updated_at":"2025-03-17T23:31:23.000000Z"}]},{"id":6305750,"change_date":"2024-07-25 21:43:00","inspection_id":"82211009","dot_number":"527487","report_state":"MO","report_number":"3214000285","insp_date":"2024-07-25 00:00:00","insp_start_time":"1039","insp_end_time":"1105","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"ST LOUIS MO","county_code_state":"MO","county_code":null,"insp_level_id":"2","service_center":"MW","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":"U","pen_cen_match":"I","final_status_date":"2024-07-25 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":"686689","transaction_code":"A","transaction_date":"2024-07-25 00:00:00","upload_date":"2024-07-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00527487","upload_search_indicator":null,"census_search_date":"2024-07-25 21:43:00","snet_input_date":"2024-07-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-07-25 21:43:00","insp_carrier_name":"SYSCO ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:27:49.000000Z","updated_at":"2025-03-17T20:27:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10160432,"change_date":"2024-07-25 21:43:00","inspection_id":"82211009","insp_unit_id":"202062132","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"STL138371","insp_unit_license":"3711178","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4WC9EG7KN208916","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:16.000000Z","updated_at":"2025-03-17T23:28:16.000000Z"},{"id":10160433,"change_date":"2024-07-25 21:43:00","inspection_id":"82211009","insp_unit_id":"202062133","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TODCO","insp_unit_company":"23967","insp_unit_license":"PB24953","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA9627EB708732","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:16.000000Z","updated_at":"2025-03-17T23:28:16.000000Z"}]},{"id":6249663,"change_date":"2024-07-18 21:40:00","inspection_id":"82151095","dot_number":"527487","report_state":"IL","report_number":"4127610711","insp_date":"2024-07-17 00:00:00","insp_start_time":"1042","insp_end_time":"1054","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"57","county_code_state":"IL","county_code":"199","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-07-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":"2340349","transaction_code":"A","transaction_date":"2024-07-17 00:00:00","upload_date":"2024-07-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00527487","upload_search_indicator":null,"census_search_date":"2024-07-18 21:40:00","snet_input_date":"2024-07-17 00:00:00","source_office":"3ILS001","mcmis_add_date":"2024-07-18 21:40:00","insp_carrier_name":"SYSCO ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:26:37.000000Z","updated_at":"2025-03-17T20:26:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10069759,"change_date":"2024-07-18 21:40:00","inspection_id":"82151095","insp_unit_id":"201949441","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"143564","insp_unit_license":"3216185","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN3AY7PM003332","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:18.000000Z","updated_at":"2025-03-17T23:27:18.000000Z"},{"id":10069760,"change_date":"2024-07-18 21:40:00","inspection_id":"82151095","insp_unit_id":"201949442","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"245859","insp_unit_license":"P668017","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA5615JB703443","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:18.000000Z","updated_at":"2025-03-17T23:27:18.000000Z"}]},{"id":6203032,"change_date":"2024-07-12 21:38:00","inspection_id":"82100895","dot_number":"527487","report_state":"MO","report_number":"1645001529","insp_date":"2024-07-12 00:00:00","insp_start_time":"1052","insp_end_time":"1122","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"ST. LOUIS MO","county_code_state":"MO","county_code":"510","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"775806","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-12 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"647164","transaction_code":"A","transaction_date":"2024-07-12 00:00:00","upload_date":"2024-07-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00527487","upload_search_indicator":null,"census_search_date":"2024-07-12 21:38:00","snet_input_date":"2024-07-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-07-12 21:38:00","insp_carrier_name":"SYSCO ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:25:44.000000Z","updated_at":"2025-03-17T20:25:44.000000Z","inspection_violations":[{"id":9634511,"change_date":"2024-07-12 21:38:00","inspection_id":"82100895","insp_violation_id":"260605892","seq_no":"1","part_no":"393","part_no_section":"95(a)(1)","insp_viol_unit":"1","insp_unit_id":"201852640","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:37.000000Z","updated_at":"2025-03-17T21:52:37.000000Z","normalized_code":"39395A1"},{"id":9634512,"change_date":"2024-07-12 21:38:00","inspection_id":"82100895","insp_violation_id":"260605893","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"201852641","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:52:37.000000Z","updated_at":"2025-03-17T21:52:37.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":9993267,"change_date":"2024-07-12 21:38:00","inspection_id":"82100895","insp_unit_id":"201852640","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"137023","insp_unit_license":"2488858","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4MC9EG4JN890305","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:34.000000Z","updated_at":"2025-03-17T23:26:34.000000Z"},{"id":9993268,"change_date":"2024-07-12 21:38:00","inspection_id":"82100895","insp_unit_id":"201852641","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":"244020","insp_unit_license":"PA41306","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"526163826G5000167","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:34.000000Z","updated_at":"2025-03-17T23:26:34.000000Z"}]},{"id":6172027,"change_date":"2024-07-09 21:42:00","inspection_id":"82067655","dot_number":"527487","report_state":"MO","report_number":"5745001079","insp_date":"2024-07-08 00:00:00","insp_start_time":"1245","insp_end_time":"1301","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"ST. LOUIS MO","county_code_state":"MO","county_code":"510","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"364750640","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-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"102000","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":"635252","transaction_code":"A","transaction_date":"2024-07-08 00:00:00","upload_date":"2024-07-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00527487","upload_search_indicator":null,"census_search_date":"2024-07-09 21:42:00","snet_input_date":"2024-07-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-07-09 21:42:00","insp_carrier_name":"SYSCO ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:25:01.000000Z","updated_at":"2025-03-17T20:25:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9942794,"change_date":"2024-07-09 21:42:00","inspection_id":"82067655","insp_unit_id":"201785995","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"STL 138378","insp_unit_license":"2779023","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4W39DF3KN209019","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:02.000000Z","updated_at":"2025-03-17T23:26:02.000000Z"},{"id":9942795,"change_date":"2024-07-09 21:42:00","inspection_id":"82067655","insp_unit_id":"201785996","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"250943","insp_unit_license":"P839669","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GR1A762XLB216259","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:02.000000Z","updated_at":"2025-03-17T23:26:02.000000Z"}]},{"id":6033553,"change_date":"2024-06-20 21:43:00","inspection_id":"81918643","dot_number":"527487","report_state":"MO","report_number":"3214000257","insp_date":"2024-06-20 00:00:00","insp_start_time":"0913","insp_end_time":"0935","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"ST. LOUIS MO","county_code_state":"MO","county_code":null,"insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SYSCO","shipping_paper_number":"364726595","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-06-20 21:43: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":"586653","transaction_code":"A","transaction_date":"2024-06-20 00:00:00","upload_date":"2024-06-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00527487","upload_search_indicator":null,"census_search_date":"2024-06-20 21:43:00","snet_input_date":"2024-06-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-06-20 21:43:00","insp_carrier_name":"SYSCO ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:22:16.000000Z","updated_at":"2025-03-17T20:22:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9718009,"change_date":"2024-06-20 21:43:00","inspection_id":"81918643","insp_unit_id":"201499745","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"STL 138378","insp_unit_license":"2779023","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4W39DF3KN209019","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:41.000000Z","updated_at":"2025-03-17T23:23:41.000000Z"},{"id":9718010,"change_date":"2024-06-20 21:43:00","inspection_id":"81918643","insp_unit_id":"201499746","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"250943","insp_unit_license":"P839669","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GR1A762XLB216259","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:41.000000Z","updated_at":"2025-03-17T23:23:41.000000Z"}]},{"id":6130084,"change_date":"2024-07-02 21:41:00","inspection_id":"82022426","dot_number":"527487","report_state":"IL","report_number":"4068050241","insp_date":"2024-06-13 00:00:00","insp_start_time":"0820","insp_end_time":"0825","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"I64","county_code_state":"IL","county_code":"191","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-07-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"24000","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":"2332072","transaction_code":"A","transaction_date":"2024-06-13 00:00:00","upload_date":"2024-06-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00527487","upload_search_indicator":null,"census_search_date":"2024-07-02 21:41:00","snet_input_date":"2024-06-13 00:00:00","source_office":"3ILS001","mcmis_add_date":"2024-07-02 21:41:00","insp_carrier_name":"SYSCO ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:24:12.000000Z","updated_at":"2025-03-17T20:24:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9874080,"change_date":"2024-07-02 21:41:00","inspection_id":"82022426","insp_unit_id":"201701967","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MCKT","insp_unit_company":"143563","insp_unit_license":"3216144","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN3AY5PM003331","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:17.000000Z","updated_at":"2025-03-17T23:25:17.000000Z"}]},{"id":5748256,"change_date":"2024-05-15 21:42:00","inspection_id":"81609170","dot_number":"527487","report_state":"MO","report_number":"W011006460","insp_date":"2024-05-11 00:00:00","insp_start_time":"0839","insp_end_time":"0915","registration_date":null,"region":"CD","ci_status_code":"C","location":"C5S","location_desc":"BLOOMSDALE MO","county_code_state":"MO","county_code":null,"insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"0769500","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-05-15 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"54700","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":"481258","transaction_code":"A","transaction_date":"2024-05-15 00:00:00","upload_date":"2024-05-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00527487","upload_search_indicator":null,"census_search_date":"2024-05-15 21:42:00","snet_input_date":"2024-05-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-05-15 21:42:00","insp_carrier_name":"SYSCO ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:16:41.000000Z","updated_at":"2025-03-17T20:16:41.000000Z","inspection_violations":[{"id":8895427,"change_date":"2024-05-15 21:42:00","inspection_id":"81609170","insp_violation_id":"259501505","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:02.000000Z","updated_at":"2025-03-17T21:49:02.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9258463,"change_date":"2024-05-15 21:42:00","inspection_id":"81609170","insp_unit_id":"200891795","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"143563","insp_unit_license":"3216144","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN3AY5PM003331","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:10.000000Z","updated_at":"2025-03-17T23:19:10.000000Z"},{"id":9258464,"change_date":"2024-05-15 21:42:00","inspection_id":"81609170","insp_unit_id":"200891796","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"PB84537","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA5618DB711928","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:10.000000Z","updated_at":"2025-03-17T23:19:10.000000Z"}]},{"id":5426597,"change_date":"2024-04-03 21:41:00","inspection_id":"81258766","dot_number":"527487","report_state":"IL","report_number":"4243670142","insp_date":"2024-03-27 00:00:00","insp_start_time":"0700","insp_end_time":"0715","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"I57","county_code_state":"IL","county_code":"181","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SYSCO","shipping_paper_number":"0764604","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":"121000","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":"2314517","transaction_code":"A","transaction_date":"2024-03-27 00:00:00","upload_date":"2024-04-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00527487","upload_search_indicator":null,"census_search_date":"2024-04-03 21:41:00","snet_input_date":"2024-03-27 00:00:00","source_office":"3ILS001","mcmis_add_date":"2024-04-03 21:41:00","insp_carrier_name":"SYSCO ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:10:16.000000Z","updated_at":"2025-03-17T20:10:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8741007,"change_date":"2024-04-03 21:41:00","inspection_id":"81258766","insp_unit_id":"200218697","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MCK","insp_unit_company":"143564","insp_unit_license":"3216185","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN3AY7PM003332","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:19.000000Z","updated_at":"2025-03-17T23:14:19.000000Z"},{"id":8741008,"change_date":"2024-04-03 21:41:00","inspection_id":"81258766","insp_unit_id":"200218698","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDN","insp_unit_company":"250902","insp_unit_license":"PA41210","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GR1A5616MB313455","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:19.000000Z","updated_at":"2025-03-17T23:14:19.000000Z"}]},{"id":5375812,"change_date":"2024-03-27 21:41:00","inspection_id":"81203134","dot_number":"527487","report_state":"MO","report_number":"3698000706","insp_date":"2024-03-26 00:00:00","insp_start_time":"1723","insp_end_time":"1745","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"ST. LOUIS MO","county_code_state":"MO","county_code":null,"insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"364613711","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-03-27 21:41: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":"348318","transaction_code":"A","transaction_date":"2024-03-26 00:00:00","upload_date":"2024-03-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00527487","upload_search_indicator":null,"census_search_date":"2024-03-27 21:41:00","snet_input_date":"2024-03-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-03-27 21:41:00","insp_carrier_name":"SYSCO ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:09:05.000000Z","updated_at":"2025-03-17T20:09:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8657753,"change_date":"2024-03-27 21:41:00","inspection_id":"81203134","insp_unit_id":"200103032","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"STL140782","insp_unit_license":"2779595","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN2AY9LM001943","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:31.000000Z","updated_at":"2025-03-17T23:13:31.000000Z"},{"id":8657754,"change_date":"2024-03-27 21:41:00","inspection_id":"81203134","insp_unit_id":"200103033","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"246639","insp_unit_license":"P668538","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA7623JB131082","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:31.000000Z","updated_at":"2025-03-17T23:13:31.000000Z"}]},{"id":5220969,"change_date":"2024-03-06 21:39:00","inspection_id":"81034131","dot_number":"527487","report_state":"MO","report_number":"3698000616","insp_date":"2024-03-05 00:00:00","insp_start_time":"1556","insp_end_time":"1622","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"ST. LOUIS MO","county_code_state":"MO","county_code":null,"insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"364588290","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-03-06 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"295409","transaction_code":"A","transaction_date":"2024-03-05 00:00:00","upload_date":"2024-03-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00527487","upload_search_indicator":null,"census_search_date":"2024-03-06 21:39:00","snet_input_date":"2024-03-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-03-06 21:39:00","insp_carrier_name":"SYSCO ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:06:10.000000Z","updated_at":"2025-03-17T20:06:10.000000Z","inspection_violations":[{"id":8047636,"change_date":"2024-03-06 21:39:00","inspection_id":"81034131","insp_violation_id":"258224260","seq_no":"1","part_no":"393","part_no_section":"9A-LBL","insp_viol_unit":"1","insp_unit_id":"199774581","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:53.000000Z","updated_at":"2025-03-17T21:44:53.000000Z","normalized_code":"3939ALBL"}],"inspection_per_units":[{"id":8407297,"change_date":"2024-03-06 21:39:00","inspection_id":"81034131","insp_unit_id":"199774581","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"STL137024","insp_unit_license":"2488859","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4MC9EG6JN890306","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:10.000000Z","updated_at":"2025-03-17T23:11:10.000000Z"},{"id":8407298,"change_date":"2024-03-06 21:39:00","inspection_id":"81034131","insp_unit_id":"199774582","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"229720","insp_unit_license":"P962230","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA7626EB704420","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:10.000000Z","updated_at":"2025-03-17T23:11:10.000000Z"}]},{"id":5175086,"change_date":"2024-02-29 21:47:00","inspection_id":"80984151","dot_number":"527487","report_state":"MO","report_number":"1645000785","insp_date":"2024-02-28 00:00:00","insp_start_time":"1046","insp_end_time":"1102","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"ST. LOUIS MO","county_code_state":"MO","county_code":null,"insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"761656","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-02-29 21:47: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":"280968","transaction_code":"A","transaction_date":"2024-02-28 00:00:00","upload_date":"2024-02-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00527487","upload_search_indicator":null,"census_search_date":"2024-02-29 21:47:00","snet_input_date":"2024-02-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-02-29 21:47:00","insp_carrier_name":"SYSCO ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:05:00.000000Z","updated_at":"2025-03-17T20:05:00.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8332291,"change_date":"2024-02-29 21:47:00","inspection_id":"80984151","insp_unit_id":"199680037","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"STL_140782","insp_unit_license":"2779595","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN2AY9LM001943","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:30.000000Z","updated_at":"2025-03-17T23:10:30.000000Z"},{"id":8332292,"change_date":"2024-02-29 21:47:00","inspection_id":"80984151","insp_unit_id":"199680038","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"243113","insp_unit_license":"PB84693","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA7620GB701659","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:30.000000Z","updated_at":"2025-03-17T23:10:30.000000Z"}]},{"id":5013518,"change_date":"2024-02-09 21:40:00","inspection_id":"80808163","dot_number":"527487","report_state":"MO","report_number":"3214000145","insp_date":"2024-02-07 00:00:00","insp_start_time":"1306","insp_end_time":"1340","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"ST LOUIS MO","county_code_state":"MO","county_code":null,"insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SYSCO","shipping_paper_number":"S2K0BJOWNR","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-02-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"102708","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":"226265","transaction_code":"A","transaction_date":"2024-02-07 00:00:00","upload_date":"2024-02-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00527487","upload_search_indicator":null,"census_search_date":"2024-02-09 21:40:00","snet_input_date":"2024-02-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-02-09 21:40:00","insp_carrier_name":"SYSCO ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:02:03.000000Z","updated_at":"2025-03-17T20:02:03.000000Z","inspection_violations":[{"id":7723138,"change_date":"2024-02-09 21:40:00","inspection_id":"80808163","insp_violation_id":"257749188","seq_no":"1","part_no":"393","part_no_section":"67C7V-F","insp_viol_unit":"1","insp_unit_id":"199344576","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:22.000000Z","updated_at":"2025-03-17T21:43:22.000000Z","normalized_code":"39367C7VF"}],"inspection_per_units":[{"id":8069313,"change_date":"2024-02-09 21:40:00","inspection_id":"80808163","insp_unit_id":"199344576","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"STL 140782","insp_unit_license":"2779595","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN2AY9LM001943","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:07.000000Z","updated_at":"2025-03-17T23:08:07.000000Z"},{"id":8069314,"change_date":"2024-02-09 21:40:00","inspection_id":"80808163","insp_unit_id":"199344577","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"243113","insp_unit_license":"PB4693","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA7620GB701659","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:07.000000Z","updated_at":"2025-03-17T23:08:07.000000Z"}]},{"id":4691028,"change_date":"2023-12-22 21:40:00","inspection_id":"80455684","dot_number":"527487","report_state":"MO","report_number":"3512000165","insp_date":"2023-12-21 00:00:00","insp_start_time":"1241","insp_end_time":"1300","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"TWIN OAKS MO","county_code_state":"MO","county_code":null,"insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"0755020","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":"2023-12-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":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"141283","transaction_code":"A","transaction_date":"2023-12-21 00:00:00","upload_date":"2023-12-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00527487","upload_search_indicator":null,"census_search_date":"2023-12-22 21:40:00","snet_input_date":"2023-12-21 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-12-22 21:40:00","insp_carrier_name":"SYSCO ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:55:47.000000Z","updated_at":"2025-03-17T19:55:47.000000Z","inspection_violations":[{"id":7249543,"change_date":"2023-12-22 21:40:00","inspection_id":"80455684","insp_violation_id":"257026801","seq_no":"1","part_no":"392","part_no_section":"2-SLLIRP","insp_viol_unit":"1","insp_unit_id":"198635994","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:01.000000Z","updated_at":"2025-03-17T21:41:01.000000Z","normalized_code":"3922SLLIRP"},{"id":7249544,"change_date":"2023-12-22 21:40:00","inspection_id":"80455684","insp_violation_id":"257026802","seq_no":"2","part_no":"392","part_no_section":"2-SLLLR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:01.000000Z","updated_at":"2025-03-17T21:41:01.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":7545297,"change_date":"2023-12-22 21:40:00","inspection_id":"80455684","insp_unit_id":"198635994","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"145796","insp_unit_license":"3481061","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKBHTDV6PDUP1802","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:28.000000Z","updated_at":"2025-03-17T23:03:28.000000Z"},{"id":7545298,"change_date":"2023-12-22 21:40:00","inspection_id":"80455684","insp_unit_id":"198635995","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"253554","insp_unit_license":"PC93738","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V382K7PJ133084","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:28.000000Z","updated_at":"2025-03-17T23:03:28.000000Z"}]},{"id":4808754,"change_date":"2024-01-11 21:45:00","inspection_id":"80584080","dot_number":"527487","report_state":"MO","report_number":"3698000293","insp_date":"2023-11-29 00:00:00","insp_start_time":"1503","insp_end_time":"1524","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"ST. LOUIS MO","county_code_state":"MO","county_code":null,"insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","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":"U","pen_cen_match":"I","final_status_date":"2024-01-11 21:45: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":"111603","transaction_code":"A","transaction_date":"2023-11-29 00:00:00","upload_date":"2024-01-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00527487","upload_search_indicator":null,"census_search_date":"2024-01-11 21:45:00","snet_input_date":"2023-11-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-01-11 21:45:00","insp_carrier_name":"SYSCO ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:58:01.000000Z","updated_at":"2025-03-17T19:58:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7736793,"change_date":"2024-01-11 21:45:00","inspection_id":"80584080","insp_unit_id":"198910646","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"STL145793","insp_unit_license":"3481058","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKBHTDVXPDUP1799","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:09.000000Z","updated_at":"2025-03-17T23:05:09.000000Z"},{"id":7736794,"change_date":"2024-01-11 21:45:00","inspection_id":"80584080","insp_unit_id":"198910647","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"228573","insp_unit_license":"21B542","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1GRAA7621DB701276","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:09.000000Z","updated_at":"2025-03-17T23:05:09.000000Z"}]},{"id":4437857,"change_date":"2023-11-16 21:42:00","inspection_id":"80177547","dot_number":"527487","report_state":"MO","report_number":"3214000067","insp_date":"2023-11-15 00:00:00","insp_start_time":"1235","insp_end_time":"1310","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"ST. LOUIS MO","county_code_state":"MO","county_code":null,"insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"FOOD SERVICE CENTER","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":"2023-11-16 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"98053","transaction_code":"A","transaction_date":"2023-11-15 00:00:00","upload_date":"2023-11-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00527487","upload_search_indicator":null,"census_search_date":"2023-11-16 21:42:00","snet_input_date":"2023-11-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-11-16 21:42:00","insp_carrier_name":"SYSCO ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:50:45.000000Z","updated_at":"2025-03-17T19:50:45.000000Z","inspection_violations":[{"id":6868702,"change_date":"2023-11-16 21:42:00","inspection_id":"80177547","insp_violation_id":"256425473","seq_no":"1","part_no":"393","part_no_section":"9A-LSML","insp_viol_unit":"2","insp_unit_id":"198086842","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:06.000000Z","updated_at":"2025-03-17T21:39:06.000000Z","normalized_code":"3939ALSML"}],"inspection_per_units":[{"id":7136778,"change_date":"2023-11-16 21:42:00","inspection_id":"80177547","insp_unit_id":"198086841","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"138371","insp_unit_license":"2778985","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4WC9EG7KN208916","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:56.000000Z","updated_at":"2025-03-17T22:59:56.000000Z"},{"id":7136779,"change_date":"2023-11-16 21:42:00","inspection_id":"80177547","insp_unit_id":"198086842","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"242245","insp_unit_license":"PA41382","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA9624FB700735","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:56.000000Z","updated_at":"2025-03-17T22:59:56.000000Z"}]},{"id":4328343,"change_date":"2023-11-01 21:43:00","inspection_id":"80056521","dot_number":"527487","report_state":"MO","report_number":"3698000221","insp_date":"2023-10-31 00:00:00","insp_start_time":"1456","insp_end_time":"1516","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"ST. LOUIS MO","county_code_state":"MO","county_code":null,"insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","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":"U","pen_cen_match":"I","final_status_date":"2023-11-01 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":"82811","transaction_code":"A","transaction_date":"2023-10-31 00:00:00","upload_date":"2023-11-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00527487","upload_search_indicator":null,"census_search_date":"2023-11-01 21:43:00","snet_input_date":"2023-10-31 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-11-01 21:43:00","insp_carrier_name":"SYSCO ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:48:43.000000Z","updated_at":"2025-03-17T19:48:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6961006,"change_date":"2023-11-01 21:43:00","inspection_id":"80056521","insp_unit_id":"197846181","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"2028741","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUBGBDVXELFS9950","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:26.000000Z","updated_at":"2025-03-17T22:58:26.000000Z"},{"id":6961007,"change_date":"2023-11-01 21:43:00","inspection_id":"80056521","insp_unit_id":"197846182","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"31A025","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1GRAA76257B702998","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:26.000000Z","updated_at":"2025-03-17T22:58:26.000000Z"}]},{"id":4288757,"change_date":"2023-10-26 21:41:00","inspection_id":"80012735","dot_number":"527487","report_state":"MO","report_number":"1645000190","insp_date":"2023-10-25 00:00:00","insp_start_time":"1315","insp_end_time":"1335","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"ST. LOUIS MO","county_code_state":"MO","county_code":null,"insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2023-10-26 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"102700","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":"77150","transaction_code":"A","transaction_date":"2023-10-25 00:00:00","upload_date":"2023-10-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00527487","upload_search_indicator":null,"census_search_date":"2023-10-26 21:41:00","snet_input_date":"2023-10-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-10-26 21:41:00","insp_carrier_name":"SYSCO ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:47:51.000000Z","updated_at":"2025-03-17T19:47:51.000000Z","inspection_violations":[{"id":6634581,"change_date":"2023-10-26 21:41:00","inspection_id":"80012735","insp_violation_id":"256053894","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"197755046","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:57.000000Z","updated_at":"2025-03-17T21:37:57.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":6897520,"change_date":"2023-10-26 21:41:00","inspection_id":"80012735","insp_unit_id":"197755046","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":null,"insp_unit_license":"2241301","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4M39DF5GN959083","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:50.000000Z","updated_at":"2025-03-17T22:57:50.000000Z"},{"id":6897521,"change_date":"2023-10-26 21:41:00","inspection_id":"80012735","insp_unit_id":"197755047","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":null,"insp_unit_license":"24K3UJ","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1JJV281W65L913859","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:50.000000Z","updated_at":"2025-03-17T22:57:50.000000Z"}]},{"id":4258281,"change_date":"2023-10-23 21:41:00","inspection_id":"79978981","dot_number":"527487","report_state":"IL","report_number":"4039410311","insp_date":"2023-10-12 00:00:00","insp_start_time":"1344","insp_end_time":"1404","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"I-64","county_code_state":"IL","county_code":"193","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"130000","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":"2286783","transaction_code":"A","transaction_date":"2023-10-12 00:00:00","upload_date":"2023-10-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00527487","upload_search_indicator":null,"census_search_date":"2023-10-23 21:41:00","snet_input_date":"2023-10-12 00:00:00","source_office":"3ILS001","mcmis_add_date":"2023-10-23 21:41:00","insp_carrier_name":"SYSCO ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:47:06.000000Z","updated_at":"2025-03-17T19:47:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6848096,"change_date":"2023-10-23 21:41:00","inspection_id":"79978981","insp_unit_id":"197690818","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MCK","insp_unit_company":"1A","insp_unit_license":"2802470","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN2AY7LM001942","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:24.000000Z","updated_at":"2025-03-17T22:57:24.000000Z"},{"id":6848097,"change_date":"2023-10-23 21:41:00","inspection_id":"79978981","insp_unit_id":"197690819","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GTD","insp_unit_company":null,"insp_unit_license":"PB84537","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA5618DB711928","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:24.000000Z","updated_at":"2025-03-17T22:57:24.000000Z"}]},{"id":3761495,"change_date":"2023-08-17 21:42:00","inspection_id":"79426696","dot_number":"527487","report_state":"MO","report_number":"3698000014","insp_date":"2023-08-14 00:00:00","insp_start_time":"0825","insp_end_time":"0847","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"ST LOUISMO","county_code_state":"MO","county_code":null,"insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"364330886","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":"2023-08-17 21:42: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":"42104","transaction_code":"A","transaction_date":"2023-08-17 00:00:00","upload_date":"2023-08-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00527487","upload_search_indicator":null,"census_search_date":"2023-08-17 21:42:00","snet_input_date":"2023-08-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-08-17 21:42:00","insp_carrier_name":"SYSCO ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:37:14.000000Z","updated_at":"2025-03-17T19:37:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6048206,"change_date":"2023-08-17 21:42:00","inspection_id":"79426696","insp_unit_id":"196571852","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":null,"insp_unit_license":"2488655","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4M39EG9JN991176","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:50.000000Z","updated_at":"2025-03-17T22:50:50.000000Z"},{"id":6048207,"change_date":"2023-08-17 21:42:00","inspection_id":"79426696","insp_unit_id":"196571853","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"14B820","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1GRAA7624CB703442","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:50.000000Z","updated_at":"2025-03-17T22:50:50.000000Z"}]},{"id":3654407,"change_date":"2023-08-02 21:41:00","inspection_id":"79307268","dot_number":"527487","report_state":"MO","report_number":"SLC7001188","insp_date":"2023-08-01 00:00:00","insp_start_time":"0631","insp_end_time":"0652","registration_date":null,"region":"CT","ci_status_code":"C","location":"C21","location_desc":"10010 KENNERLY RD","county_code_state":"MO","county_code":"189","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"MERCY SOUTH HOSPITAL","shipping_paper_number":"364317650","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-08-02 21:41: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":"2086433","transaction_code":"A","transaction_date":"2023-08-01 00:00:00","upload_date":"2023-08-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00527487","upload_search_indicator":null,"census_search_date":"2023-08-02 21:41:00","snet_input_date":"2023-08-02 00:00:00","source_office":"3MOS001","mcmis_add_date":"2023-08-02 21:41:00","insp_carrier_name":"SYSCO ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:34:57.000000Z","updated_at":"2025-03-17T19:34:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5876060,"change_date":"2023-08-02 21:41:00","inspection_id":"79307268","insp_unit_id":"196327036","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"140786","insp_unit_license":"2802386","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN2AY3LM001940","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:25.000000Z","updated_at":"2025-03-17T22:49:25.000000Z"},{"id":5876061,"change_date":"2023-08-02 21:41:00","inspection_id":"79307268","insp_unit_id":"196327037","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"253526","insp_unit_license":"PC93730","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V382K2PJ133056","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:25.000000Z","updated_at":"2025-03-17T22:49:25.000000Z"}]},{"id":3567407,"change_date":"2023-07-21 21:41:00","inspection_id":"79209810","dot_number":"527487","report_state":"MO","report_number":"00SH007511","insp_date":"2023-07-20 00:00:00","insp_start_time":"1639","insp_end_time":"1655","registration_date":null,"region":"CT","ci_status_code":"C","location":"C70","location_desc":"900 N MARKET","county_code_state":"MO","county_code":"510","insp_level_id":"3","service_center":"MW","census_source_id":"4","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":"Y","pen_cen_match":"I","final_status_date":"2023-07-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"118250","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":"2084882","transaction_code":"A","transaction_date":"2023-07-21 00:00:00","upload_date":"2023-07-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00527487","upload_search_indicator":"M","census_search_date":"2023-07-21 21:41:00","snet_input_date":"2023-07-21 00:00:00","source_office":"3MOS001","mcmis_add_date":"2023-07-21 21:41:00","insp_carrier_name":"SYSCO ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:33:32.000000Z","updated_at":"2025-03-17T19:33:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5735948,"change_date":"2023-07-21 21:41:00","inspection_id":"79209810","insp_unit_id":"196131282","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"STL138370","insp_unit_license":"2778984","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4WC9EG5KN208915","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:17.000000Z","updated_at":"2025-03-17T22:48:17.000000Z"},{"id":5735949,"change_date":"2023-07-21 21:41:00","inspection_id":"79209810","insp_unit_id":"196131283","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"229147","insp_unit_license":"P744582","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA7626DB709244","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:17.000000Z","updated_at":"2025-03-17T22:48:17.000000Z"}]},{"id":3479382,"change_date":"2023-07-11 21:42:00","inspection_id":"79111126","dot_number":"527487","report_state":"MO","report_number":"00SB009532","insp_date":"2023-07-10 00:00:00","insp_start_time":"1210","insp_end_time":"1240","registration_date":null,"region":"CT","ci_status_code":"C","location":"C55","location_desc":"600 S 4TH ST","county_code_state":"MO","county_code":"510","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"FOOD SERVICE CENTER","shipping_paper_number":"440570","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-07-11 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"118531","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":"2083080","transaction_code":"A","transaction_date":"2023-07-10 00:00:00","upload_date":"2023-07-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00527487","upload_search_indicator":null,"census_search_date":"2023-07-11 21:42:00","snet_input_date":"2023-07-11 00:00:00","source_office":"3MOS001","mcmis_add_date":"2023-07-11 21:42:00","insp_carrier_name":"SYSCO ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:31:45.000000Z","updated_at":"2025-03-17T19:31:45.000000Z","inspection_violations":[{"id":5364245,"change_date":"2023-07-11 21:42:00","inspection_id":"79111126","insp_violation_id":"253988039","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"195935039","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:31:55.000000Z","updated_at":"2025-03-17T21:31:55.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":5594874,"change_date":"2023-07-11 21:42:00","inspection_id":"79111126","insp_unit_id":"195935038","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"138371","insp_unit_license":"2778985","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4WC9EG7KN208916","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:09.000000Z","updated_at":"2025-03-17T22:47:09.000000Z"},{"id":5594875,"change_date":"2023-07-11 21:42:00","inspection_id":"79111126","insp_unit_id":"195935039","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"239617","insp_unit_license":"PB24953","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA9627EB708732","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:09.000000Z","updated_at":"2025-03-17T22:47:09.000000Z"}]},{"id":3295551,"change_date":"2023-06-15 21:42:00","inspection_id":"78904329","dot_number":"527487","report_state":"MO","report_number":"00SE004462","insp_date":"2023-06-13 00:00:00","insp_start_time":"2003","insp_end_time":"2022","registration_date":null,"region":"CT","ci_status_code":"C","location":"C55","location_desc":"3415 GRAVOIS","county_code_state":"MO","county_code":"510","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":"I","final_status_date":"2023-06-15 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"148000","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":"2079202","transaction_code":"A","transaction_date":"2023-06-13 00:00:00","upload_date":"2023-06-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00527487","upload_search_indicator":null,"census_search_date":"2023-06-15 21:42:00","snet_input_date":"2023-06-15 00:00:00","source_office":"3MOS001","mcmis_add_date":"2023-06-15 21:42:00","insp_carrier_name":"SYSCO ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:28:11.000000Z","updated_at":"2025-03-17T19:28:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5298411,"change_date":"2023-06-15 21:42:00","inspection_id":"78904329","insp_unit_id":"195522256","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"2028246","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUBGBDV0ELFA8407","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:47.000000Z","updated_at":"2025-03-17T22:44:47.000000Z"},{"id":5298412,"change_date":"2023-06-15 21:42:00","inspection_id":"78904329","insp_unit_id":"195522257","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"02A812","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1K913382174054159","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:47.000000Z","updated_at":"2025-03-17T22:44:47.000000Z"}]},{"id":3231078,"change_date":"2023-06-07 21:42:00","inspection_id":"78831416","dot_number":"527487","report_state":"MO","report_number":"SLC5001898","insp_date":"2023-06-05 00:00:00","insp_start_time":"0618","insp_end_time":"0645","registration_date":null,"region":"CT","ci_status_code":"C","location":"C50","location_desc":"S LINDBERGH\/BAPTIST CHURCH RD","county_code_state":"MO","county_code":"189","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"364356063","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-06-07 21:42: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":"2077833","transaction_code":"A","transaction_date":"2023-06-07 00:00:00","upload_date":"2023-06-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00527487","upload_search_indicator":"M","census_search_date":"2023-06-07 21:42:00","snet_input_date":"2023-06-07 00:00:00","source_office":"3MOS001","mcmis_add_date":"2023-06-07 21:42:00","insp_carrier_name":"SYSCO ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:26:55.000000Z","updated_at":"2025-03-17T19:26:55.000000Z","inspection_violations":[{"id":4980105,"change_date":"2023-06-07 21:42:00","inspection_id":"78831416","insp_violation_id":"253357904","seq_no":"1","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"195374549","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:12.000000Z","updated_at":"2025-03-17T21:30:12.000000Z","normalized_code":"39345B2"},{"id":4980106,"change_date":"2023-06-07 21:42:00","inspection_id":"78831416","insp_violation_id":"253357905","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"195374550","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:12.000000Z","updated_at":"2025-03-17T21:30:12.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":5196380,"change_date":"2023-06-07 21:42:00","inspection_id":"78831416","insp_unit_id":"195374549","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"135185","insp_unit_license":"2341906","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4M39EG1GN969150","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:57.000000Z","updated_at":"2025-03-17T22:43:57.000000Z"},{"id":5196381,"change_date":"2023-06-07 21:42:00","inspection_id":"78831416","insp_unit_id":"195374550","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"247379","insp_unit_license":"P812051","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA7624KB155652","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:57.000000Z","updated_at":"2025-03-17T22:43:57.000000Z"}]},{"id":3068510,"change_date":"2023-05-17 21:43:00","inspection_id":"78647953","dot_number":"527487","report_state":"MO","report_number":"00SB009336","insp_date":"2023-05-16 00:00:00","insp_start_time":"1530","insp_end_time":"1600","registration_date":null,"region":"CT","ci_status_code":"C","location":"C55","location_desc":"800 MARION ST","county_code_state":"MO","county_code":"510","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":"I","final_status_date":"2023-05-17 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"115531","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":"2074364","transaction_code":"A","transaction_date":"2023-05-17 00:00:00","upload_date":"2023-05-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00527487","upload_search_indicator":"M","census_search_date":"2023-05-17 21:43:00","snet_input_date":"2023-05-17 00:00:00","source_office":"3MOS001","mcmis_add_date":"2023-05-17 21:43:00","insp_carrier_name":"SYSCO ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:23:46.000000Z","updated_at":"2025-03-17T19:23:46.000000Z","inspection_violations":[{"id":4714223,"change_date":"2023-05-17 21:43:00","inspection_id":"78647953","insp_violation_id":"252890342","seq_no":"1","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"194983845","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:57.000000Z","updated_at":"2025-03-17T21:28:57.000000Z","normalized_code":"39375C"},{"id":4714224,"change_date":"2023-05-17 21:43:00","inspection_id":"78647953","insp_violation_id":"252890343","seq_no":"2","part_no":"393","part_no_section":"207(f)","insp_viol_unit":"2","insp_unit_id":"194983845","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:28:57.000000Z","updated_at":"2025-03-17T21:28:57.000000Z","normalized_code":"393207F"}],"inspection_per_units":[{"id":4936300,"change_date":"2023-05-17 21:43:00","inspection_id":"78647953","insp_unit_id":"194983844","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"135821","insp_unit_license":"2488209","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4NC9EH5HN984409","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:55.000000Z","updated_at":"2025-03-17T22:41:55.000000Z"},{"id":4936301,"change_date":"2023-05-17 21:43:00","inspection_id":"78647953","insp_unit_id":"194983845","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"M4811005","insp_unit_license":"234166G","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1UYVS2483BM190403","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:55.000000Z","updated_at":"2025-03-17T22:41:55.000000Z"}]},{"id":2696090,"change_date":"2023-03-30 21:41:00","inspection_id":"78226365","dot_number":"527487","report_state":"MO","report_number":"00SB009132","insp_date":"2023-03-29 00:00:00","insp_start_time":"1530","insp_end_time":"1600","registration_date":null,"region":"CT","ci_status_code":"C","location":"C55","location_desc":"800 MARION ST","county_code_state":"MO","county_code":"510","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":"I","final_status_date":"2023-03-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"73000","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2065864","transaction_code":"A","transaction_date":"2023-03-30 00:00:00","upload_date":"2023-03-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00527487","upload_search_indicator":"M","census_search_date":"2023-03-30 21:41:00","snet_input_date":"2023-03-30 00:00:00","source_office":"3MOS001","mcmis_add_date":"2023-03-30 21:41:00","insp_carrier_name":"SYSCO ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:16:16.000000Z","updated_at":"2025-03-17T19:16:16.000000Z","inspection_violations":[{"id":4140466,"change_date":"2023-03-30 21:41:00","inspection_id":"78226365","insp_violation_id":"251954522","seq_no":"1","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"194144224","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:25.000000Z","updated_at":"2025-03-17T21:26:25.000000Z","normalized_code":"39375C"},{"id":4140467,"change_date":"2023-03-30 21:41:00","inspection_id":"78226365","insp_violation_id":"251954523","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":"3","citation_number":null,"created_at":"2025-03-17T21:26:25.000000Z","updated_at":"2025-03-17T21:26:25.000000Z","normalized_code":"38323A2"}],"inspection_per_units":[{"id":4340268,"change_date":"2023-03-30 21:41:00","inspection_id":"78226365","insp_unit_id":"194144223","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"130677","insp_unit_license":"35AR7D","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1FUBGBDV3CSBF8208","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:12.000000Z","updated_at":"2025-03-17T22:37:12.000000Z"},{"id":4340269,"change_date":"2023-03-30 21:41:00","inspection_id":"78226365","insp_unit_id":"194144224","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"208149","insp_unit_license":"114B770","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1GRAA56165S702078","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:12.000000Z","updated_at":"2025-03-17T22:37:12.000000Z"}]},{"id":2635429,"change_date":"2023-03-22 21:42:00","inspection_id":"78156734","dot_number":"527487","report_state":"MO","report_number":"00SH006960","insp_date":"2023-03-21 00:00:00","insp_start_time":"0752","insp_end_time":"0810","registration_date":null,"region":"CT","ci_status_code":"C","location":"C64","location_desc":"2800 MARKET","county_code_state":"MO","county_code":"510","insp_level_id":"2","service_center":"MW","census_source_id":"4","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":"Y","pen_cen_match":"I","final_status_date":"2023-03-22 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"97000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2064557","transaction_code":"A","transaction_date":"2023-03-22 00:00:00","upload_date":"2023-03-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00527487","upload_search_indicator":"M","census_search_date":"2023-03-22 21:42:00","snet_input_date":"2023-03-22 00:00:00","source_office":"3MOS001","mcmis_add_date":"2023-03-22 21:42:00","insp_carrier_name":"SYSCO ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:15:13.000000Z","updated_at":"2025-03-17T19:15:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4242579,"change_date":"2023-03-22 21:42:00","inspection_id":"78156734","insp_unit_id":"194005929","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"64133525","insp_unit_license":"2240568","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4M39EG1FN923803","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:26.000000Z","updated_at":"2025-03-17T22:36:26.000000Z"},{"id":4242580,"change_date":"2023-03-22 21:42:00","inspection_id":"78156734","insp_unit_id":"194005930","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"228573","insp_unit_license":"20A190","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1GRAA7621DB701276","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:26.000000Z","updated_at":"2025-03-17T22:36:26.000000Z"}]},{"id":2254971,"change_date":"2023-02-09 21:40:00","inspection_id":"77723847","dot_number":"527487","report_state":"MO","report_number":"SLC8000012","insp_date":"2023-01-28 00:00:00","insp_start_time":"0724","insp_end_time":"0842","registration_date":null,"region":"CT","ci_status_code":"C","location":"C64","location_desc":"17308 CHESTERFIELD AIRPORT RD","county_code_state":"MO","county_code":"189","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"0724447","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-30 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"2055957","transaction_code":"C","transaction_date":"2023-02-08 00:00:00","upload_date":"2023-02-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00527487","upload_search_indicator":null,"census_search_date":"2023-01-30 21:43:00","snet_input_date":"2023-01-30 00:00:00","source_office":"3MOS001","mcmis_add_date":"2023-01-30 21:43:00","insp_carrier_name":"SYSCO ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:08:09.000000Z","updated_at":"2025-03-17T19:08:09.000000Z","inspection_violations":[{"id":3480615,"change_date":"2023-02-09 21:40:00","inspection_id":"77723847","insp_violation_id":"251050755","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"193321544","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:28.000000Z","updated_at":"2025-03-17T21:23:28.000000Z","normalized_code":"39311"},{"id":3480616,"change_date":"2023-02-09 21:40:00","inspection_id":"77723847","insp_violation_id":"251050756","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"193321544","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:28.000000Z","updated_at":"2025-03-17T21:23:28.000000Z","normalized_code":"39311"},{"id":3480617,"change_date":"2023-02-09 21:40:00","inspection_id":"77723847","insp_violation_id":"251050757","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193321544","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:28.000000Z","updated_at":"2025-03-17T21:23:28.000000Z","normalized_code":"3922"},{"id":3480618,"change_date":"2023-02-09 21:40:00","inspection_id":"77723847","insp_violation_id":"251050758","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"193321545","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:28.000000Z","updated_at":"2025-03-17T21:23:28.000000Z","normalized_code":"3922"},{"id":3480619,"change_date":"2023-02-09 21:40:00","inspection_id":"77723847","insp_violation_id":"251050759","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"193321545","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:28.000000Z","updated_at":"2025-03-17T21:23:28.000000Z","normalized_code":"3939A"},{"id":3480620,"change_date":"2023-02-09 21:40:00","inspection_id":"77723847","insp_violation_id":"251050760","seq_no":"7","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"193321545","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:28.000000Z","updated_at":"2025-03-17T21:23:28.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":3629579,"change_date":"2023-02-09 21:40:00","inspection_id":"77723847","insp_unit_id":"193321544","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"137023","insp_unit_license":"2488858","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4MC9EG4JN890305","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:00.000000Z","updated_at":"2025-03-17T22:32:00.000000Z"},{"id":3629580,"change_date":"2023-02-09 21:40:00","inspection_id":"77723847","insp_unit_id":"193321545","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"243113","insp_unit_license":"P668078","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA7620GB701659","insp_unit_decal":"Y","insp_unit_decal_number":"32402288","created_at":"2025-03-17T22:32:00.000000Z","updated_at":"2025-03-17T22:32:00.000000Z"}]},{"id":1708048,"change_date":"2022-11-09 21:40:00","inspection_id":"77097739","dot_number":"527487","report_state":"MO","report_number":"00SE004021","insp_date":"2022-11-02 00:00:00","insp_start_time":"1550","insp_end_time":"1608","registration_date":null,"region":"CT","ci_status_code":"C","location":"C55","location_desc":"4340 S BROADWAY","county_code_state":"MO","county_code":"510","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":"I","final_status_date":"2022-11-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"123000","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":"2042455","transaction_code":"A","transaction_date":"2022-11-02 00:00:00","upload_date":"2022-11-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00527487","upload_search_indicator":null,"census_search_date":"2022-11-09 21:40:00","snet_input_date":"2022-11-09 00:00:00","source_office":"3MOS001","mcmis_add_date":"2022-11-09 21:40:00","insp_carrier_name":"SYSCO ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:58:11.000000Z","updated_at":"2025-03-17T18:58:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2747797,"change_date":"2022-11-09 21:40:00","inspection_id":"77097739","insp_unit_id":"191884217","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"129070","insp_unit_license":"35AR6D","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1FUJGBDV3CSBF8205","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:48.000000Z","updated_at":"2025-03-17T22:25:48.000000Z"},{"id":2747798,"change_date":"2022-11-09 21:40:00","inspection_id":"77097739","insp_unit_id":"191884218","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"201726","insp_unit_license":"PB24658","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1K911281751054303","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:48.000000Z","updated_at":"2025-03-17T22:25:48.000000Z"}]},{"id":1239713,"change_date":"2022-09-08 21:39:00","inspection_id":"76556533","dot_number":"527487","report_state":"MO","report_number":"00SH006314","insp_date":"2022-09-07 00:00:00","insp_start_time":"1359","insp_end_time":"1420","registration_date":null,"region":"CT","ci_status_code":"C","location":"C55","location_desc":"3600 GRAVOIS","county_code_state":"MO","county_code":"510","insp_level_id":"3","service_center":"MW","census_source_id":"4","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":"Y","pen_cen_match":"I","final_status_date":"2022-09-08 21:39: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":"2031026","transaction_code":"A","transaction_date":"2022-09-07 00:00:00","upload_date":"2022-09-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00527487","upload_search_indicator":null,"census_search_date":"2022-09-08 21:39:00","snet_input_date":"2022-09-08 00:00:00","source_office":"3MOS001","mcmis_add_date":"2022-09-08 21:39:00","insp_carrier_name":"SYSCO ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:49:23.000000Z","updated_at":"2025-03-17T18:49:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1995029,"change_date":"2022-09-08 21:39:00","inspection_id":"76556533","insp_unit_id":"190788910","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"129833","insp_unit_license":"63AR9J","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1FUBGBDV2CSBP7532","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:44.000000Z","updated_at":"2025-03-17T22:20:44.000000Z"},{"id":1995030,"change_date":"2022-09-08 21:39:00","inspection_id":"76556533","insp_unit_id":"190788911","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"245007","insp_unit_license":"P490773","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V281C9HT566005","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:44.000000Z","updated_at":"2025-03-17T22:20:44.000000Z"}]},{"id":965398,"change_date":"2022-08-04 21:42:00","inspection_id":"76237330","dot_number":"527487","report_state":"MO","report_number":"SLC5001290","insp_date":"2022-08-03 00:00:00","insp_start_time":"0600","insp_end_time":"0622","registration_date":null,"region":"CT","ci_status_code":"C","location":"C21","location_desc":"KORHS LN\/ GREEN PARK RD","county_code_state":"MO","county_code":"189","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":"I","final_status_date":"2022-08-04 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":"2024742","transaction_code":"A","transaction_date":"2022-08-03 00:00:00","upload_date":"2022-08-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00527487","upload_search_indicator":null,"census_search_date":"2022-08-04 21:42:00","snet_input_date":"2022-08-04 00:00:00","source_office":"3MOS001","mcmis_add_date":"2022-08-04 21:42:00","insp_carrier_name":"SYSCO ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:44:45.000000Z","updated_at":"2025-03-17T18:44:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1553428,"change_date":"2022-08-04 21:42:00","inspection_id":"76237330","insp_unit_id":"190139475","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"137022","insp_unit_license":"2488857","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4M39EG9JN890350","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:46.000000Z","updated_at":"2025-03-17T22:17:46.000000Z"},{"id":1553429,"change_date":"2022-08-04 21:42:00","inspection_id":"76237330","insp_unit_id":"190139476","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"247379","insp_unit_license":"P812051","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA7624KB155652","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:46.000000Z","updated_at":"2025-03-17T22:17:46.000000Z"}]},{"id":873553,"change_date":"2022-07-22 21:40:00","inspection_id":"76129590","dot_number":"527487","report_state":"MO","report_number":"00SH006084","insp_date":"2022-07-21 00:00:00","insp_start_time":"1500","insp_end_time":"1522","registration_date":null,"region":"CT","ci_status_code":"C","location":"C55","location_desc":"6200 GRAVOIS","county_code_state":"MO","county_code":"510","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"264902179","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":"2022-07-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"71000","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":"2022826","transaction_code":"A","transaction_date":"2022-07-22 00:00:00","upload_date":"2022-07-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00527487","upload_search_indicator":"M","census_search_date":"2022-07-22 21:40:00","snet_input_date":"2022-07-22 00:00:00","source_office":"3MOS001","mcmis_add_date":"2022-07-22 21:40:00","insp_carrier_name":"SYSCO ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:43:03.000000Z","updated_at":"2025-03-17T18:43:03.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1406349,"change_date":"2022-07-22 21:40:00","inspection_id":"76129590","insp_unit_id":"189917978","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"64 132152","insp_unit_license":"2028247","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUBGBDV2ELFA8408","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:50.000000Z","updated_at":"2025-03-17T22:16:50.000000Z"},{"id":1406350,"change_date":"2022-07-22 21:40:00","inspection_id":"76129590","insp_unit_id":"189917979","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"245959","insp_unit_license":"P668017","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA5615JB703443","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:50.000000Z","updated_at":"2025-03-17T22:16:50.000000Z"}]},{"id":777742,"change_date":"2022-09-29 21:41:00","inspection_id":"76017624","dot_number":"527487","report_state":"IL","report_number":"0110000469","insp_date":"2022-07-07 00:00:00","insp_start_time":"1400","insp_end_time":"1447","registration_date":null,"region":"CT","ci_status_code":"C","location":"SC35","location_desc":"O'FALLON - I-64 E\/B","county_code_state":"IL","county_code":"163","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"SYSCO ST LOUIS","shipping_paper_number":"706955","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-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"0","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":"2181119","transaction_code":"C","transaction_date":"2022-09-27 00:00:00","upload_date":"2022-09-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00527487","upload_search_indicator":null,"census_search_date":"2022-07-08 21:40:00","snet_input_date":"2022-07-08 00:00:00","source_office":"3ILS001","mcmis_add_date":"2022-07-08 21:40:00","insp_carrier_name":"SYSCO ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:41:17.000000Z","updated_at":"2025-03-17T18:41:17.000000Z","inspection_violations":[{"id":1228706,"change_date":"2022-09-29 21:41:00","inspection_id":"76017624","insp_violation_id":"248731955","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"191175990","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:12:46.000000Z","updated_at":"2025-03-17T21:12:46.000000Z","normalized_code":"3939A"},{"id":1228707,"change_date":"2022-09-29 21:41:00","inspection_id":"76017624","insp_violation_id":"248731956","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191175989","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:46.000000Z","updated_at":"2025-03-17T21:12:46.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1251375,"change_date":"2022-09-29 21:41:00","inspection_id":"76017624","insp_unit_id":"191175989","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLK","insp_unit_company":"138369","insp_unit_license":"2778983","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4WC9EG3KN208914","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:53.000000Z","updated_at":"2025-03-17T22:15:53.000000Z"},{"id":1251376,"change_date":"2022-09-29 21:41:00","inspection_id":"76017624","insp_unit_id":"191175990","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"230718","insp_unit_license":"11B159","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1GRAA7622CB703441","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:53.000000Z","updated_at":"2025-03-17T22:15:53.000000Z"}]},{"id":771003,"change_date":"2022-07-07 21:41:00","inspection_id":"76009645","dot_number":"527487","report_state":"MO","report_number":"00SP005164","insp_date":"2022-07-06 00:00:00","insp_start_time":"0828","insp_end_time":"0846","registration_date":null,"region":"CT","ci_status_code":"C","location":"C55","location_desc":"2400 S 7TH ST","county_code_state":"MO","county_code":"510","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"0706886","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":"2022-07-07 21:41: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":"2020155","transaction_code":"A","transaction_date":"2022-07-07 00:00:00","upload_date":"2022-07-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00527487","upload_search_indicator":"M","census_search_date":"2022-07-07 21:41:00","snet_input_date":"2022-07-07 00:00:00","source_office":"3MOS001","mcmis_add_date":"2022-07-07 21:41:00","insp_carrier_name":"SYSCO ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:41:14.000000Z","updated_at":"2025-03-17T18:41:14.000000Z","inspection_violations":[{"id":1215515,"change_date":"2022-07-07 21:41:00","inspection_id":"76009645","insp_violation_id":"246947580","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"189653774","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:40.000000Z","updated_at":"2025-03-17T21:12:40.000000Z","normalized_code":"39378"},{"id":1215516,"change_date":"2022-07-07 21:41:00","inspection_id":"76009645","insp_violation_id":"246947581","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"189653775","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:40.000000Z","updated_at":"2025-03-17T21:12:40.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":1240305,"change_date":"2022-07-07 21:41:00","inspection_id":"76009645","insp_unit_id":"189653774","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"131693","insp_unit_license":"2987140","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUBGBDV5DLFA8322","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:49.000000Z","updated_at":"2025-03-17T22:15:49.000000Z"},{"id":1240306,"change_date":"2022-07-07 21:41:00","inspection_id":"76009645","insp_unit_id":"189653775","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"208169","insp_unit_license":"31A025","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1GRAA76257B702998","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:49.000000Z","updated_at":"2025-03-17T22:15:49.000000Z"}]},{"id":739632,"change_date":"2022-07-01 21:38:00","inspection_id":"75973193","dot_number":"527487","report_state":"MO","report_number":"00SE003792","insp_date":"2022-06-28 00:00:00","insp_start_time":"1704","insp_end_time":"1724","registration_date":null,"region":"CT","ci_status_code":"C","location":"C55","location_desc":"1900 S 7TH","county_code_state":"MO","county_code":"510","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":"I","final_status_date":"2022-07-01 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"148000","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":"2019197","transaction_code":"A","transaction_date":"2022-07-01 00:00:00","upload_date":"2022-07-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00527487","upload_search_indicator":"M","census_search_date":"2022-07-01 21:38:00","snet_input_date":"2022-07-01 00:00:00","source_office":"3MOS001","mcmis_add_date":"2022-07-01 21:38:00","insp_carrier_name":"SYSCO ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:40:35.000000Z","updated_at":"2025-03-17T18:40:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1188533,"change_date":"2022-07-01 21:38:00","inspection_id":"75973193","insp_unit_id":"189576404","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"133806","insp_unit_license":"2240762","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4M39EG1FN926720","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:29.000000Z","updated_at":"2025-03-17T22:15:29.000000Z"},{"id":1188534,"change_date":"2022-07-01 21:38:00","inspection_id":"75973193","insp_unit_id":"189576405","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"246019","insp_unit_license":"P668196","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA7627JB705716","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:29.000000Z","updated_at":"2025-03-17T22:15:29.000000Z"}]},{"id":708591,"change_date":"2022-06-28 21:42:00","inspection_id":"75936854","dot_number":"527487","report_state":"IL","report_number":"4038440101","insp_date":"2022-06-27 00:00:00","insp_start_time":"1308","insp_end_time":"1327","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"IL 1","county_code_state":"IL","county_code":"193","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"92000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2179646","transaction_code":"A","transaction_date":"2022-06-27 00:00:00","upload_date":"2022-06-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00527487","upload_search_indicator":null,"census_search_date":"2022-06-28 21:42:00","snet_input_date":"2022-06-27 00:00:00","source_office":"3ILS001","mcmis_add_date":"2022-06-28 21:42:00","insp_carrier_name":"SYSCO ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:40:11.000000Z","updated_at":"2025-03-17T18:40:11.000000Z","inspection_violations":[{"id":1113320,"change_date":"2022-06-28 21:42:00","inspection_id":"75936854","insp_violation_id":"246761592","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:12:12.000000Z","updated_at":"2025-03-17T21:12:12.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1139004,"change_date":"2022-06-28 21:42:00","inspection_id":"75936854","insp_unit_id":"189499312","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"16483","insp_unit_license":"2488655","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4M39EG9JN991176","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:11.000000Z","updated_at":"2025-03-17T22:15:11.000000Z"},{"id":1139005,"change_date":"2022-06-28 21:42:00","inspection_id":"75936854","insp_unit_id":"189499313","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"250903","insp_unit_license":"PA41211","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":null,"insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:11.000000Z","updated_at":"2025-03-17T22:15:11.000000Z"}]},{"id":320619,"change_date":"2022-05-04 21:41:00","inspection_id":"75475501","dot_number":"527487","report_state":"MO","report_number":"IT03003373","insp_date":"2022-05-02 00:00:00","insp_start_time":"0930","insp_end_time":"0944","registration_date":null,"region":"CT","ci_status_code":"C","location":"IE","location_desc":"ROLLA","county_code_state":"MO","county_code":"161","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"701471","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-05-04 21:41: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":"2009610","transaction_code":"A","transaction_date":"2022-05-04 00:00:00","upload_date":"2022-05-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00527487","upload_search_indicator":"M","census_search_date":"2022-05-04 21:41:00","snet_input_date":"2022-05-04 00:00:00","source_office":"3MOS001","mcmis_add_date":"2022-05-04 21:41:00","insp_carrier_name":"SYSCO ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:33:17.000000Z","updated_at":"2025-03-17T18:33:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":518672,"change_date":"2022-05-04 21:41:00","inspection_id":"75475501","insp_unit_id":"188505222","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"143563","insp_unit_license":"3216144","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN3AY5PM003331","insp_unit_decal":"Y","insp_unit_decal_number":"31315645","created_at":"2025-03-17T22:11:22.000000Z","updated_at":"2025-03-17T22:11:22.000000Z"},{"id":518673,"change_date":"2022-05-04 21:41:00","inspection_id":"75475501","insp_unit_id":"188505223","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"250903","insp_unit_license":"PA41211","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GR1A5618MB313456","insp_unit_decal":"Y","insp_unit_decal_number":"31315646","created_at":"2025-03-17T22:11:22.000000Z","updated_at":"2025-03-17T22:11:22.000000Z"}]},{"id":300856,"change_date":"2022-05-02 21:41:00","inspection_id":"75452113","dot_number":"527487","report_state":"MO","report_number":"00SX000947","insp_date":"2022-04-28 00:00:00","insp_start_time":"1300","insp_end_time":"1333","registration_date":null,"region":"CT","ci_status_code":"C","location":"C64","location_desc":"700 N SPRING AVE","county_code_state":"MO","county_code":"510","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"SYSCO ST LOUIS LLC","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":"Y","pen_cen_match":"I","final_status_date":"2022-05-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"103000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2008915","transaction_code":"A","transaction_date":"2022-05-02 00:00:00","upload_date":"2022-05-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00527487","upload_search_indicator":"M","census_search_date":"2022-05-02 21:41:00","snet_input_date":"2022-05-02 00:00:00","source_office":"3MOS001","mcmis_add_date":"2022-05-02 21:41:00","insp_carrier_name":"SYSCO ST LOUIS LLC","insp_carrier_street":"3850 MUELLERS ROAD","insp_carrier_city":"SAINT CHARLES","insp_carrier_state":"MO","insp_carrier_zip_code":"63301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:32:54.000000Z","updated_at":"2025-03-17T18:32:54.000000Z","inspection_violations":[{"id":467804,"change_date":"2022-05-02 21:41:00","inspection_id":"75452113","insp_violation_id":"245511429","seq_no":"3","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"188454621","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:15.000000Z","updated_at":"2025-03-17T21:09:15.000000Z","normalized_code":"39311"},{"id":467805,"change_date":"2022-05-02 21:41:00","inspection_id":"75452113","insp_violation_id":"245511430","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"188454621","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:15.000000Z","updated_at":"2025-03-17T21:09:15.000000Z","normalized_code":"3939A"},{"id":467806,"change_date":"2022-05-02 21:41:00","inspection_id":"75452113","insp_violation_id":"245511431","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"188454621","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:15.000000Z","updated_at":"2025-03-17T21:09:15.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":486748,"change_date":"2022-05-02 21:41:00","inspection_id":"75452113","insp_unit_id":"188454621","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"132434","insp_unit_license":"2028740","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUBGBDV3ELFS9949","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:11.000000Z","updated_at":"2025-03-17T22:11:11.000000Z"},{"id":486749,"change_date":"2022-05-02 21:41:00","inspection_id":"75452113","insp_unit_id":"188454622","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"247381","insp_unit_license":"P812053","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA7628KB155654","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:11.000000Z","updated_at":"2025-03-17T22:11:11.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/527487\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/527487\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/527487\/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\/527487\/inspections","per_page":100,"prev_page_url":null,"to":72,"total":72}