{"current_page":1,"data":[{"id":12678766,"change_date":"2026-08-10 21:40:00","inspection_id":"88652259","dot_number":"292854","report_state":"MN","report_number":"1676000792","insp_date":"2026-08-04 00:00:00","insp_start_time":"0719","insp_end_time":"0729","registration_date":null,"region":"CD","ci_status_code":"C","location":"ERSKN","location_desc":"ERSKINE MN","county_code_state":"MN","county_code":"119","insp_level_id":"3","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-08-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"136000","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":"3945325","transaction_code":"A","transaction_date":"2026-08-10 00:00:00","upload_date":"2026-08-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00292854","upload_search_indicator":null,"census_search_date":"2026-08-10 21:40:00","snet_input_date":"2026-08-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-08-10 21:40:00","insp_carrier_name":"SYSCO ASIAN FOODS INC","insp_carrier_street":"1300 LORIENT STREET","insp_carrier_city":"ST PAUL","insp_carrier_state":"MN","insp_carrier_zip_code":"55117","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-08-13T09:40:17.000000Z","updated_at":"2026-08-22T09:31:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":22005995,"change_date":"2026-08-10 21:40:00","inspection_id":"88652259","insp_unit_id":"215066275","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":null,"insp_unit_license":"3283486","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4WC9EG9PN332578","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-13T09:17:55.000000Z","updated_at":"2026-08-21T09:01:34.000000Z"},{"id":22005996,"change_date":"2026-08-10 21:40:00","inspection_id":"88652259","insp_unit_id":"215066276","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"247628","insp_unit_license":"6279STT","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"3H3V482C2KT844002","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-13T09:17:55.000000Z","updated_at":"2026-08-21T09:01:34.000000Z"}]},{"id":12581430,"change_date":"2026-07-29 21:41:00","inspection_id":"88550016","dot_number":"292854","report_state":"IA","report_number":"205S000238","insp_date":"2026-07-29 00:00:00","insp_start_time":"1239","insp_end_time":"1312","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"IA","county_code_state":"IA","county_code":"021","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SYSCO ASIAN FOODS","shipping_paper_number":"R5052785","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"112000","viol_total":"3","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3863732","transaction_code":"A","transaction_date":"2026-07-29 00:00:00","upload_date":"2026-07-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00292854","upload_search_indicator":null,"census_search_date":"2026-07-29 21:41:00","snet_input_date":"2026-07-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-29 21:41:00","insp_carrier_name":"SYSCO ASIAN FOODS INC","insp_carrier_street":"1300 LORIENT STREET","insp_carrier_city":"ST PAUL","insp_carrier_state":"MN","insp_carrier_zip_code":"55117","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-08-01T09:41:38.000000Z","updated_at":"2026-08-09T09:31:25.000000Z","inspection_violations":[{"id":21904370,"change_date":"2026-07-29 21:41:00","inspection_id":"88550016","insp_violation_id":"275804183","seq_no":"1","part_no":"393","part_no_section":"75A1-TAORETA","insp_viol_unit":"1","insp_unit_id":"214879066","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-01T10:02:38.000000Z","updated_at":"2026-08-09T09:44:32.000000Z","normalized_code":"39375A1TAORETA"},{"id":21904371,"change_date":"2026-07-29 21:41:00","inspection_id":"88550016","insp_violation_id":"275804184","seq_no":"2","part_no":"393","part_no_section":"201A-VBF","insp_viol_unit":"2","insp_unit_id":"214879067","insp_violation_category_id":"19","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-08-01T10:02:38.000000Z","updated_at":"2026-08-09T09:44:32.000000Z","normalized_code":"393201AVBF"},{"id":21904372,"change_date":"2026-07-29 21:41:00","inspection_id":"88550016","insp_violation_id":"275804185","seq_no":"3","part_no":"396","part_no_section":"3A1-BARS","insp_viol_unit":"2","insp_unit_id":"214879067","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-08-01T10:02:38.000000Z","updated_at":"2026-08-09T09:44:32.000000Z","normalized_code":"3963A1BARS"}],"inspection_per_units":[{"id":21844449,"change_date":"2026-07-29 21:41:00","inspection_id":"88550016","insp_unit_id":"214879066","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"ASF_1478","insp_unit_license":"2962390","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHTDV1RSVH3577","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-01T09:18:44.000000Z","updated_at":"2026-08-09T09:02:58.000000Z"},{"id":21844450,"change_date":"2026-07-29 21:41:00","inspection_id":"88550016","insp_unit_id":"214879067","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"2","insp_unit_license":"8738STT","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1GRAA7629EB702760","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-01T09:18:44.000000Z","updated_at":"2026-08-09T09:02:58.000000Z"}]},{"id":12551520,"change_date":"2026-07-26 21:34:00","inspection_id":"88518515","dot_number":"292854","report_state":"WI","report_number":"2824000331","insp_date":"2026-07-23 00:00:00","insp_start_time":"1250","insp_end_time":"1345","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"LADYSMITH WI","county_code_state":"WI","county_code":"107","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SELF","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-26 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3838022","transaction_code":"A","transaction_date":"2026-07-25 00:00:00","upload_date":"2026-07-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00292854","upload_search_indicator":null,"census_search_date":"2026-07-26 21:34:00","snet_input_date":"2026-07-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-26 21:34:00","insp_carrier_name":"SYSCO ASIAN FOODS INC","insp_carrier_street":"1300 LORIENT STREET","insp_carrier_city":"ST PAUL","insp_carrier_state":"MN","insp_carrier_zip_code":"55117","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-29T09:39:54.000000Z","updated_at":"2026-08-06T09:30:30.000000Z","inspection_violations":[{"id":21852312,"change_date":"2026-07-26 21:34:00","inspection_id":"88518515","insp_violation_id":"275737697","seq_no":"1","part_no":"392","part_no_section":"2-SLLUP","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":"2026-07-29T09:58:33.000000Z","updated_at":"2026-08-06T09:41:47.000000Z","normalized_code":"3922SLLUP"}],"inspection_per_units":[{"id":21794944,"change_date":"2026-07-26 21:34:00","inspection_id":"88518515","insp_unit_id":"214822122","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"149676","insp_unit_license":"2962395","insp_unit_license_state":"WI","insp_unit_vehicle_id_number":"3AKJHTDV0SDWB8051","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-29T09:16:24.000000Z","updated_at":"2026-08-06T09:01:15.000000Z"},{"id":21794945,"change_date":"2026-07-26 21:34:00","inspection_id":"88518515","insp_unit_id":"214822123","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"PF73965","insp_unit_license_state":"WI","insp_unit_vehicle_id_number":"1GR1A962XSB721454","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-29T09:16:24.000000Z","updated_at":"2026-08-06T09:01:15.000000Z"}]},{"id":12505431,"change_date":"2026-07-21 21:39:00","inspection_id":"88469447","dot_number":"292854","report_state":"MN","report_number":"0605000976","insp_date":"2026-07-14 00:00:00","insp_start_time":"1513","insp_end_time":"1519","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"RED LAKE FALLS MN","county_code_state":"MN","county_code":"113","insp_level_id":"3","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":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3798691","transaction_code":"A","transaction_date":"2026-07-20 00:00:00","upload_date":"2026-07-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00292854","upload_search_indicator":null,"census_search_date":"2026-07-21 21:39:00","snet_input_date":"2026-07-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-21 21:39:00","insp_carrier_name":"SYSCO ASIAN FOODS INC","insp_carrier_street":"1300 LORIENT STREET","insp_carrier_city":"ST PAUL","insp_carrier_state":"MN","insp_carrier_zip_code":"55117","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-24T09:42:25.000000Z","updated_at":"2026-08-01T09:30:30.000000Z","inspection_violations":[{"id":21772269,"change_date":"2026-07-21 21:39:00","inspection_id":"88469447","insp_violation_id":"275633866","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARN","created_at":"2026-07-24T10:04:35.000000Z","updated_at":"2026-08-01T09:42:15.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":21718528,"change_date":"2026-07-21 21:39:00","inspection_id":"88469447","insp_unit_id":"214729806","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"147838","insp_unit_license":"2962398","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHTDV3RSVH3578","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-24T09:19:53.000000Z","updated_at":"2026-08-01T09:01:38.000000Z"},{"id":21718529,"change_date":"2026-07-21 21:39:00","inspection_id":"88469447","insp_unit_id":"214729807","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"229296","insp_unit_license":"6271STT","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1GRAA962XDB707623","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-24T09:19:53.000000Z","updated_at":"2026-08-01T09:01:38.000000Z"}]},{"id":12152749,"change_date":"2026-06-10 21:45:00","inspection_id":"88102082","dot_number":"292854","report_state":"ND","report_number":"HP02000675","insp_date":"2026-06-09 00:00:00","insp_start_time":"1241","insp_end_time":"1303","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"DEVILS LAKE ND","county_code_state":"ND","county_code":"071","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SYSCO ASIAN FOODS","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-06-10 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":"3514156","transaction_code":"A","transaction_date":"2026-06-10 00:00:00","upload_date":"2026-06-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00292854","upload_search_indicator":null,"census_search_date":"2026-06-10 21:45:00","snet_input_date":"2026-06-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-10 21:45:00","insp_carrier_name":"SYSCO ASIAN FOODS INC","insp_carrier_street":"1300 LORIENT STREET","insp_carrier_city":"ST PAUL","insp_carrier_state":"MN","insp_carrier_zip_code":"55117","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-13T09:41:35.000000Z","updated_at":"2026-06-21T09:31:48.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21110681,"change_date":"2026-06-10 21:45:00","inspection_id":"88102082","insp_unit_id":"214022782","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"STE3121","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1GRAA9627HB712204","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-13T09:18:05.000000Z","updated_at":"2026-06-21T09:03:21.000000Z"},{"id":21110680,"change_date":"2026-06-10 21:45:00","inspection_id":"88102082","insp_unit_id":"214022781","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"147838","insp_unit_license":"2962398","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHTDV3RSVH3578","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-13T09:18:05.000000Z","updated_at":"2026-06-21T09:03:21.000000Z"}]},{"id":11704546,"change_date":"2026-04-21 21:38:00","inspection_id":"87631122","dot_number":"292854","report_state":"MN","report_number":"1676000574","insp_date":"2026-04-14 00:00:00","insp_start_time":"0816","insp_end_time":"0933","registration_date":null,"region":"CD","ci_status_code":"C","location":"ERSKN","location_desc":"ERSKINE MN","county_code_state":"MN","county_code":"119","insp_level_id":"1","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-04-21 21:38: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":"3186722","transaction_code":"A","transaction_date":"2026-04-20 00:00:00","upload_date":"2026-04-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00292854","upload_search_indicator":null,"census_search_date":"2026-04-21 21:38:00","snet_input_date":"2026-04-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-21 21:38:00","insp_carrier_name":"SYSCO ASIAN FOODS INC","insp_carrier_street":"1300 LORIENT STREET","insp_carrier_city":"ST PAUL","insp_carrier_state":"MN","insp_carrier_zip_code":"55117","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-27T09:37:09.000000Z","updated_at":"2026-05-02T09:30:10.000000Z","inspection_violations":[{"id":20339726,"change_date":"2026-04-21 21:38:00","inspection_id":"87631122","insp_violation_id":"273736766","seq_no":"1","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"2","insp_unit_id":"213128338","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2026-04-27T09:53:42.000000Z","updated_at":"2026-05-02T09:41:24.000000Z","normalized_code":"39345B2BAIR"},{"id":20339727,"change_date":"2026-04-21 21:38:00","inspection_id":"87631122","insp_violation_id":"273736767","seq_no":"2","part_no":"393","part_no_section":"45B2-BHTD","insp_viol_unit":"2","insp_unit_id":"213128338","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"882616760015","created_at":"2026-04-27T09:53:42.000000Z","updated_at":"2026-05-02T09:41:24.000000Z","normalized_code":"39345B2BHTD"},{"id":20339728,"change_date":"2026-04-21 21:38:00","inspection_id":"87631122","insp_violation_id":"273736768","seq_no":"3","part_no":"393","part_no_section":"209E-STPSD","insp_viol_unit":"1","insp_unit_id":"213128337","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2026-04-27T09:53:42.000000Z","updated_at":"2026-05-02T09:41:24.000000Z","normalized_code":"393209ESTPSD"},{"id":20339729,"change_date":"2026-04-21 21:38:00","inspection_id":"87631122","insp_violation_id":"273736769","seq_no":"4","part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"1","insp_unit_id":"213128337","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2026-04-27T09:53:42.000000Z","updated_at":"2026-05-02T09:41:24.000000Z","normalized_code":"3939ALRLI"}],"inspection_per_units":[{"id":20368869,"change_date":"2026-04-21 21:38:00","inspection_id":"87631122","insp_unit_id":"213128337","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":null,"insp_unit_license":"3283486","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4WC9EG9PN332578","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:13:12.000000Z","updated_at":"2026-05-02T09:02:19.000000Z"},{"id":20368870,"change_date":"2026-04-21 21:38:00","inspection_id":"87631122","insp_unit_id":"213128338","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":null,"insp_unit_license":"6278STT","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"3H3V482C0KT844001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:13:12.000000Z","updated_at":"2026-05-02T09:02:19.000000Z"}]},{"id":11413717,"change_date":"2026-03-19 21:38:00","inspection_id":"87329272","dot_number":"292854","report_state":"MN","report_number":"0263001180","insp_date":"2026-03-12 00:00:00","insp_start_time":"1548","insp_end_time":"1602","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"SAINT PAUL MN","county_code_state":"MN","county_code":"123","insp_level_id":"3","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":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-03-19 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"102700","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3023573","transaction_code":"A","transaction_date":"2026-03-18 00:00:00","upload_date":"2026-03-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00292854","upload_search_indicator":null,"census_search_date":"2026-03-19 21:38:00","snet_input_date":"2026-03-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-19 21:38:00","insp_carrier_name":"SYSCO ASIAN FOODS INC","insp_carrier_street":"1300 LORIENT STREET","insp_carrier_city":"ST PAUL","insp_carrier_state":"MN","insp_carrier_zip_code":"55117","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-22T09:50:42.000000Z","updated_at":"2026-03-30T09:30:58.000000Z","inspection_violations":[{"id":19249819,"change_date":"2026-03-19 21:38:00","inspection_id":"87329272","insp_violation_id":"272492339","seq_no":"1","part_no":"392","part_no_section":"2-SLLTCD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-22T10:16:41.000000Z","updated_at":"2026-03-30T09:52:52.000000Z","normalized_code":"3922SLLTCD"}],"inspection_per_units":[{"id":19550930,"change_date":"2026-03-19 21:38:00","inspection_id":"87329272","insp_unit_id":"212213428","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"146091","insp_unit_license":"3539561","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKBHTDV8PDUP1980","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-22T09:32:24.000000Z","updated_at":"2026-03-30T09:05:21.000000Z"},{"id":19550931,"change_date":"2026-03-19 21:38:00","inspection_id":"87329272","insp_unit_id":"212213429","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"6294STT","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1GRAA6229EB710485","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-22T09:32:24.000000Z","updated_at":"2026-03-30T09:05:21.000000Z"}]},{"id":11370900,"change_date":"2026-03-13 21:37:00","inspection_id":"87284546","dot_number":"292854","report_state":"MI","report_number":"ZASTM02065","insp_date":"2026-03-09 00:00:00","insp_start_time":"1813","insp_end_time":"1826","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US-41 @ 34TH ROAD","county_code_state":"MI","county_code":"041","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"MULTIPLE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-13 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1261784","transaction_code":"A","transaction_date":"2026-03-09 00:00:00","upload_date":"2026-03-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00292854","upload_search_indicator":null,"census_search_date":"2026-03-13 21:37:00","snet_input_date":"2026-03-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-03-13 21:37:00","insp_carrier_name":"SYSCO ASIAN FOODS INC","insp_carrier_street":"1300 LORIENT STREET","insp_carrier_city":"ST PAUL","insp_carrier_state":"MN","insp_carrier_zip_code":"55117","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-16T09:39:17.000000Z","updated_at":"2026-03-24T09:31:08.000000Z","inspection_violations":[{"id":19161634,"change_date":"2026-03-13 21:37:00","inspection_id":"87284546","insp_violation_id":"272392870","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-16T10:01:22.000000Z","updated_at":"2026-03-24T09:44:30.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":19470145,"change_date":"2026-03-13 21:37:00","inspection_id":"87284546","insp_unit_id":"212125591","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"138347","insp_unit_license":"2240870","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4WC9EG1KN208894","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-16T09:16:59.000000Z","updated_at":"2026-03-24T09:04:43.000000Z"},{"id":19470146,"change_date":"2026-03-13 21:37:00","inspection_id":"87284546","insp_unit_id":"212125592","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"247628","insp_unit_license":"6279STT","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"3H3V482C2KT844002","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-16T09:16:59.000000Z","updated_at":"2026-03-24T09:04:43.000000Z"}]},{"id":11234483,"change_date":"2026-02-26 21:40:00","inspection_id":"87146891","dot_number":"292854","report_state":"ND","report_number":"TR20002160","insp_date":"2026-02-25 00:00:00","insp_start_time":"0829","insp_end_time":"0850","registration_date":null,"region":"CS","ci_status_code":"C","location":"FARGO","location_desc":"FARGO ND","county_code_state":"ND","county_code":"017","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SYSCO","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"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-26 21:40: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":"2936877","transaction_code":"A","transaction_date":"2026-02-26 00:00:00","upload_date":"2026-02-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00292854","upload_search_indicator":null,"census_search_date":"2026-02-26 21:40:00","snet_input_date":"2026-02-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-26 21:40:00","insp_carrier_name":"SYSCO ASIAN FOODS INC","insp_carrier_street":"1300 LORIENT STREET","insp_carrier_city":"ST PAUL","insp_carrier_state":"MN","insp_carrier_zip_code":"55117","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-01T10:38:52.000000Z","updated_at":"2026-03-09T09:31:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19203810,"change_date":"2026-02-26 21:40:00","inspection_id":"87146891","insp_unit_id":"211847670","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"3786744","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHTDV9SDWB8050","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-01T10:15:40.000000Z","updated_at":"2026-03-09T09:07:24.000000Z"},{"id":19203811,"change_date":"2026-02-26 21:40:00","inspection_id":"87146891","insp_unit_id":"211847671","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":null,"insp_unit_license":"C458418","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"3H3V482K4SJ520004","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-01T10:15:40.000000Z","updated_at":"2026-03-09T09:07:24.000000Z"}]},{"id":11247252,"change_date":"2026-02-27 21:41:00","inspection_id":"87160152","dot_number":"292854","report_state":"MN","report_number":"0191000619","insp_date":"2026-02-20 00:00:00","insp_start_time":"1551","insp_end_time":"1655","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"AVON MN","county_code_state":"MN","county_code":"145","insp_level_id":"1","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":"2026-02-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"9","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2941188","transaction_code":"A","transaction_date":"2026-02-26 00:00:00","upload_date":"2026-02-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00292854","upload_search_indicator":null,"census_search_date":"2026-02-27 21:41:00","snet_input_date":"2026-02-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-27 21:41:00","insp_carrier_name":"SYSCO ASIAN FOODS INC","insp_carrier_street":"1300 LORIENT STREET","insp_carrier_city":"ST PAUL","insp_carrier_state":"MN","insp_carrier_zip_code":"55117","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-02T10:39:32.000000Z","updated_at":"2026-03-10T09:30:36.000000Z","inspection_violations":[{"id":18892865,"change_date":"2026-02-27 21:41:00","inspection_id":"87160152","insp_violation_id":"272083728","seq_no":"1","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"211873922","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2026-03-02T10:58:36.000000Z","updated_at":"2026-03-10T09:43:02.000000Z","normalized_code":"39617CPI"},{"id":18892866,"change_date":"2026-02-27 21:41:00","inspection_id":"87160152","insp_violation_id":"272083729","seq_no":"2","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"211873923","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2026-03-02T10:58:36.000000Z","updated_at":"2026-03-10T09:43:02.000000Z","normalized_code":"39617CPI"},{"id":18892867,"change_date":"2026-02-27 21:41:00","inspection_id":"87160152","insp_violation_id":"272083730","seq_no":"3","part_no":"393","part_no_section":"75C-TAOTD-LT2\/32","insp_viol_unit":"2","insp_unit_id":"211873923","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2026-03-02T10:58:36.000000Z","updated_at":"2026-03-10T09:43:02.000000Z","normalized_code":"39375CTAOTDLT2\/32"},{"id":18892868,"change_date":"2026-02-27 21:41:00","inspection_id":"87160152","insp_violation_id":"272083731","seq_no":"4","part_no":"395","part_no_section":"8A","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2026-03-02T10:58:36.000000Z","updated_at":"2026-03-10T09:43:02.000000Z","normalized_code":"3958A"},{"id":18892869,"change_date":"2026-02-27 21:41:00","inspection_id":"87160152","insp_violation_id":"272083732","seq_no":"5","part_no":"393","part_no_section":"55C2-B","insp_viol_unit":"1","insp_unit_id":"211873922","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2026-03-02T10:58:36.000000Z","updated_at":"2026-03-10T09:43:02.000000Z","normalized_code":"39355C2B"},{"id":18892870,"change_date":"2026-02-27 21:41:00","inspection_id":"87160152","insp_violation_id":"272083733","seq_no":"6","part_no":"393","part_no_section":"55E-B","insp_viol_unit":"2","insp_unit_id":"211873923","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2026-03-02T10:58:36.000000Z","updated_at":"2026-03-10T09:43:02.000000Z","normalized_code":"39355EB"},{"id":18892871,"change_date":"2026-02-27 21:41:00","inspection_id":"87160152","insp_violation_id":"272083734","seq_no":"7","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"211873922","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2026-03-02T10:58:36.000000Z","updated_at":"2026-03-10T09:43:02.000000Z","normalized_code":"39395A4EEUS"},{"id":18892872,"change_date":"2026-02-27 21:41:00","inspection_id":"87160152","insp_violation_id":"272083735","seq_no":"8","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"211873922","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2026-03-02T10:58:36.000000Z","updated_at":"2026-03-10T09:43:02.000000Z","normalized_code":"39378AWS"},{"id":18892873,"change_date":"2026-02-27 21:41:00","inspection_id":"87160152","insp_violation_id":"272083736","seq_no":"9","part_no":"393","part_no_section":"9B-LBL","insp_viol_unit":"1","insp_unit_id":"211873922","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2026-03-02T10:58:36.000000Z","updated_at":"2026-03-10T09:43:02.000000Z","normalized_code":"3939BLBL"}],"inspection_per_units":[{"id":19227796,"change_date":"2026-02-27 21:41:00","inspection_id":"87160152","insp_unit_id":"211873923","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":"06","insp_unit_license":"P839513","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V482C0LT888002","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-02T10:16:21.000000Z","updated_at":"2026-03-10T09:05:17.000000Z"},{"id":19227795,"change_date":"2026-02-27 21:41:00","inspection_id":"87160152","insp_unit_id":"211873922","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"150875","insp_unit_license":"3859260","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHTDVXTSWK6319","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-02T10:16:21.000000Z","updated_at":"2026-03-10T09:05:17.000000Z"}]},{"id":10896072,"change_date":"2026-01-31 21:33:00","inspection_id":"86927227","dot_number":"292854","report_state":"WI","report_number":"9993000508","insp_date":"2026-01-28 00:00:00","insp_start_time":"0746","insp_end_time":"0809","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"WAUKESHA WI","county_code_state":"WI","county_code":"133","insp_level_id":"3","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":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-01-31 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2830241","transaction_code":"A","transaction_date":"2026-01-30 00:00:00","upload_date":"2026-01-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00292854","upload_search_indicator":null,"census_search_date":"2026-01-31 21:33:00","snet_input_date":"2026-01-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-31 21:33:00","insp_carrier_name":"SYSCO ASIAN FOODS INC","insp_carrier_street":"1300 LORIENT STREET","insp_carrier_city":"ST PAUL","insp_carrier_state":"MN","insp_carrier_zip_code":"55117","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-03T10:35:13.000000Z","updated_at":"2026-02-11T10:30:06.000000Z","inspection_violations":[{"id":18247104,"change_date":"2026-01-31 21:33:00","inspection_id":"86927227","insp_violation_id":"271523749","seq_no":"2","part_no":"392","part_no_section":"2-SLLTCD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-04T10:45:21.000000Z","updated_at":"2026-02-11T10:37:01.000000Z","normalized_code":"3922SLLTCD"},{"id":18247105,"change_date":"2026-01-31 21:33:00","inspection_id":"86927227","insp_violation_id":"271523750","seq_no":"1","part_no":"392","part_no_section":"2WG","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"3V80NSNQBF","created_at":"2026-02-04T10:45:21.000000Z","updated_at":"2026-02-11T10:37:01.000000Z","normalized_code":"3922WG"}],"inspection_per_units":[{"id":18319054,"change_date":"2026-01-31 21:33:00","inspection_id":"86927227","insp_unit_id":"211372912","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"146093","insp_unit_license":"2962391","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHTDV0PDUP2066","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-03T10:09:32.000000Z","updated_at":"2026-02-11T10:03:34.000000Z"},{"id":18319055,"change_date":"2026-01-31 21:33:00","inspection_id":"86927227","insp_unit_id":"211372913","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"247632","insp_unit_license":"6275STT","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"3H3V382C5KT848001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-03T10:09:32.000000Z","updated_at":"2026-02-11T10:03:34.000000Z"}]},{"id":10409388,"change_date":"2025-12-11 21:44:00","inspection_id":"86540042","dot_number":"292854","report_state":"SD","report_number":"5450003055","insp_date":"2025-12-10 00:00:00","insp_start_time":"0738","insp_end_time":"0819","registration_date":null,"region":"CS","ci_status_code":"C","location":"SUFLSW","location_desc":"VALLEY SPRINGS SD","county_code_state":"SD","county_code":"099","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SYCSO FOODS","shipping_paper_number":"ROUTE 3190","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-12-11 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2639845","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":"00292854","upload_search_indicator":null,"census_search_date":"2025-12-11 21:44:00","snet_input_date":"2025-12-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-12-11 21:44:00","insp_carrier_name":"SYSCO ASIAN FOODS INC","insp_carrier_street":"1300 LORIENT STREET","insp_carrier_city":"ST PAUL","insp_carrier_state":"MN","insp_carrier_zip_code":"55117","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-14T10:31:46.000000Z","updated_at":"2025-12-15T10:31:07.000000Z","inspection_violations":[{"id":17448487,"change_date":"2025-12-11 21:44:00","inspection_id":"86540042","insp_violation_id":"270618321","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"B1376470-HP","created_at":"2025-12-14T10:32:37.000000Z","updated_at":"2025-12-15T10:32:24.000000Z","normalized_code":"3922SLLEWA2"}],"inspection_per_units":[{"id":17408736,"change_date":"2025-12-11 21:44:00","inspection_id":"86540042","insp_unit_id":"210550142","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"147835","insp_unit_license":"2962383","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHTDV8RSVH3575","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-14T10:02:00.000000Z","updated_at":"2025-12-15T10:01:36.000000Z"},{"id":17408737,"change_date":"2025-12-11 21:44:00","inspection_id":"86540042","insp_unit_id":"210550143","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"PF73965","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GR1A962XSB721454","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-14T10:02:00.000000Z","updated_at":"2025-12-15T10:01:36.000000Z"}]},{"id":9803755,"change_date":"2025-09-29 21:38:00","inspection_id":"85903363","dot_number":"292854","report_state":"SD","report_number":"HP55000055","insp_date":"2025-09-25 00:00:00","insp_start_time":"1206","insp_end_time":"1219","registration_date":null,"region":"MD","ci_status_code":"C","location":null,"location_desc":"RAPID CITY SD","county_code_state":"SD","county_code":"103","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"EMPTY","shipping_paper_number":"EMPTY","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-09-29 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"140000","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":"2341234","transaction_code":"A","transaction_date":"2025-09-29 00:00:00","upload_date":"2025-09-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00292854","upload_search_indicator":null,"census_search_date":"2025-09-29 21:38:00","snet_input_date":"2025-09-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-29 21:38:00","insp_carrier_name":"SYSCO ASIAN FOODS INC","insp_carrier_street":"1300 LORIENT STREET","insp_carrier_city":"ST PAUL","insp_carrier_state":"MN","insp_carrier_zip_code":"55117","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-02T10:00:15.000000Z","updated_at":"2025-10-03T10:00:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16247702,"change_date":"2025-09-29 21:38:00","inspection_id":"85903363","insp_unit_id":"209193990","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":null,"insp_unit_license":"3216297","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4WC9EG0PN332579","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-02T09:45:17.000000Z","updated_at":"2025-10-03T09:45:31.000000Z"},{"id":16247703,"change_date":"2025-09-29 21:38:00","inspection_id":"85903363","insp_unit_id":"209193991","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"250538","insp_unit_license":"P839512","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V482C9LT888001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-02T09:45:17.000000Z","updated_at":"2025-10-03T09:45:31.000000Z"}]},{"id":9775298,"change_date":"2025-09-25 21:40:00","inspection_id":"85873354","dot_number":"292854","report_state":"MN","report_number":"MN06860031","insp_date":"2025-09-18 00:00:00","insp_start_time":"1026","insp_end_time":"1113","registration_date":null,"region":"CD","ci_status_code":"C","location":"CLKGVN","location_desc":"CLARKS GROVE MN","county_code_state":"MN","county_code":"047","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-09-25 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":"2322943","transaction_code":"A","transaction_date":"2025-09-24 00:00:00","upload_date":"2025-09-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00292854","upload_search_indicator":null,"census_search_date":"2025-09-25 21:40:00","snet_input_date":"2025-09-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-25 21:40:00","insp_carrier_name":"SYSCO ASIAN FOODS INC","insp_carrier_street":"1300 LORIENT STREET","insp_carrier_city":"ST PAUL","insp_carrier_state":"MN","insp_carrier_zip_code":"55117","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-28T10:00:59.000000Z","updated_at":"2025-09-30T10:00:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16194479,"change_date":"2025-09-25 21:40:00","inspection_id":"85873354","insp_unit_id":"209136248","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"138348","insp_unit_license":"3481026","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4WC9EG3KN208895","insp_unit_decal":"Y","insp_unit_decal_number":"35507283","created_at":"2025-09-29T09:46:32.000000Z","updated_at":"2025-09-29T09:46:32.000000Z"},{"id":16194480,"change_date":"2025-09-25 21:40:00","inspection_id":"85873354","insp_unit_id":"209136249","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"239940","insp_unit_license":"2780STT","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1GRAA7622FB700219","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-29T09:46:32.000000Z","updated_at":"2025-09-29T09:46:32.000000Z"}]},{"id":9762844,"change_date":"2025-09-24 21:41:00","inspection_id":"85860331","dot_number":"292854","report_state":"MN","report_number":"1658000565","insp_date":"2025-09-17 00:00:00","insp_start_time":"0852","insp_end_time":"0938","registration_date":null,"region":"CD","ci_status_code":"C","location":"SGNAW","location_desc":"SAGINAW MN","county_code_state":"MN","county_code":"137","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-09-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"2317246","transaction_code":"A","transaction_date":"2025-09-23 00:00:00","upload_date":"2025-09-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00292854","upload_search_indicator":null,"census_search_date":"2025-09-24 21:41:00","snet_input_date":"2025-09-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-24 21:41:00","insp_carrier_name":"SYSCO ASIAN FOODS INC","insp_carrier_street":"1300 LORIENT STREET","insp_carrier_city":"ST PAUL","insp_carrier_state":"MN","insp_carrier_zip_code":"55117","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-26T10:01:06.000000Z","updated_at":"2025-09-28T10:00:10.000000Z","inspection_violations":[{"id":16045321,"change_date":"2025-09-24 21:41:00","inspection_id":"85860331","insp_violation_id":"268884329","seq_no":"1","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"2","insp_unit_id":"209112504","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-27T10:16:50.000000Z","updated_at":"2025-09-28T10:15:17.000000Z","normalized_code":"39345B2BAIR"},{"id":16045322,"change_date":"2025-09-24 21:41:00","inspection_id":"85860331","insp_violation_id":"268884330","seq_no":"2","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"2","insp_unit_id":"209112504","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-27T10:16:50.000000Z","updated_at":"2025-09-28T10:15:17.000000Z","normalized_code":"39345B2BAIR"},{"id":16045323,"change_date":"2025-09-24 21:41:00","inspection_id":"85860331","insp_violation_id":"268884331","seq_no":"3","part_no":"395","part_no_section":"8A","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-27T10:16:50.000000Z","updated_at":"2025-09-28T10:15:17.000000Z","normalized_code":"3958A"}],"inspection_per_units":[{"id":16173253,"change_date":"2025-09-24 21:41:00","inspection_id":"85860331","insp_unit_id":"209112503","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"138346","insp_unit_license":"2962410","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4MC9EG2HN989442","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-27T09:46:17.000000Z","updated_at":"2025-09-29T09:45:10.000000Z"},{"id":16173254,"change_date":"2025-09-24 21:41:00","inspection_id":"85860331","insp_unit_id":"209112504","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"245489","insp_unit_license":"STE3121","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1GRAA9627HB712204","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-27T09:46:17.000000Z","updated_at":"2025-09-29T09:45:10.000000Z"}]},{"id":9173180,"change_date":"2025-07-17 21:41:00","inspection_id":"85240864","dot_number":"292854","report_state":"MN","report_number":"0531000590","insp_date":"2025-07-11 00:00:00","insp_start_time":"0626","insp_end_time":"0641","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"CHAMPLIN MN","county_code_state":"MN","county_code":"053","insp_level_id":"3","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":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-07-17 21:41: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":"2004145","transaction_code":"A","transaction_date":"2025-07-17 00:00:00","upload_date":"2025-07-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00292854","upload_search_indicator":null,"census_search_date":"2025-07-17 21:41:00","snet_input_date":"2025-07-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-17 21:41:00","insp_carrier_name":"SYSCO ASIAN FOODS INC","insp_carrier_street":"1300 LORIENT STREET","insp_carrier_city":"ST PAUL","insp_carrier_state":"MN","insp_carrier_zip_code":"55117","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-21T10:43:08.000000Z","updated_at":"2025-07-21T10:43:08.000000Z","inspection_violations":[{"id":14811680,"change_date":"2025-07-17 21:41:00","inspection_id":"85240864","insp_violation_id":"267462352","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-07-21T10:45:30.000000Z","updated_at":"2025-07-21T10:45:30.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":15072308,"change_date":"2025-07-17 21:41:00","inspection_id":"85240864","insp_unit_id":"207919170","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":null,"insp_unit_license":"2962410","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4MC9EG2HN989442","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-20T09:46:26.000000Z","updated_at":"2025-07-21T09:45:35.000000Z"},{"id":15072309,"change_date":"2025-07-17 21:41:00","inspection_id":"85240864","insp_unit_id":"207919171","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"STC1552","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1GRAA7620EB702761","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-20T09:46:26.000000Z","updated_at":"2025-07-21T09:45:35.000000Z"}]},{"id":9161644,"change_date":"2025-07-16 21:40:00","inspection_id":"85228752","dot_number":"292854","report_state":"MN","report_number":"0691000040","insp_date":"2025-07-09 00:00:00","insp_start_time":"1108","insp_end_time":"1149","registration_date":null,"region":"CD","ci_status_code":"C","location":"STCRX","location_desc":"WEST LAKELAND MN","county_code_state":"MN","county_code":"163","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-07-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"119998","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":"1997044","transaction_code":"A","transaction_date":"2025-07-15 00:00:00","upload_date":"2025-07-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00292854","upload_search_indicator":null,"census_search_date":"2025-07-16 21:40:00","snet_input_date":"2025-07-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-16 21:40:00","insp_carrier_name":"SYSCO ASIAN FOODS INC","insp_carrier_street":"1300 LORIENT STREET","insp_carrier_city":"ST PAUL","insp_carrier_state":"MN","insp_carrier_zip_code":"55117","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-19T10:42:29.000000Z","updated_at":"2025-07-21T10:42:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15048324,"change_date":"2025-07-16 21:40:00","inspection_id":"85228752","insp_unit_id":"207895521","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":null,"insp_unit_license":"2962399","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4MC9EG8FN927511","insp_unit_decal":"Y","insp_unit_decal_number":"35505687","created_at":"2025-07-19T09:46:14.000000Z","updated_at":"2025-07-20T09:45:24.000000Z"},{"id":15048325,"change_date":"2025-07-16 21:40:00","inspection_id":"85228752","insp_unit_id":"207895522","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":null,"insp_unit_license":"6276STT","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"3H3V382C7KT848002","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-19T09:46:14.000000Z","updated_at":"2025-07-20T09:45:24.000000Z"}]},{"id":9148975,"change_date":"2025-07-15 21:39:00","inspection_id":"85215537","dot_number":"292854","report_state":"MN","report_number":"0605000506","insp_date":"2025-07-08 00:00:00","insp_start_time":"1036","insp_end_time":"1046","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"ERSKINE MN","county_code_state":"MN","county_code":"119","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-07-15 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1991181","transaction_code":"A","transaction_date":"2025-07-14 00:00:00","upload_date":"2025-07-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00292854","upload_search_indicator":null,"census_search_date":"2025-07-15 21:39:00","snet_input_date":"2025-07-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-15 21:39:00","insp_carrier_name":"SYSCO ASIAN FOODS INC","insp_carrier_street":"1300 LORIENT STREET","insp_carrier_city":"ST PAUL","insp_carrier_state":"MN","insp_carrier_zip_code":"55117","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-18T10:45:54.000000Z","updated_at":"2025-07-19T10:41:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15024603,"change_date":"2025-07-15 21:39:00","inspection_id":"85215537","insp_unit_id":"207870389","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":null,"insp_unit_license":"3283486","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4WC9EG9PN332578","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-18T09:46:33.000000Z","updated_at":"2025-07-19T09:45:11.000000Z"},{"id":15024604,"change_date":"2025-07-15 21:39:00","inspection_id":"85215537","insp_unit_id":"207870390","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":null,"insp_unit_license":"6278STT","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"3H3V482C0KT844001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-18T09:46:33.000000Z","updated_at":"2025-07-19T09:45:11.000000Z"}]},{"id":8752190,"change_date":"2025-05-28 21:42:00","inspection_id":"84796023","dot_number":"292854","report_state":"MN","report_number":"1675000099","insp_date":"2025-05-22 00:00:00","insp_start_time":"0708","insp_end_time":"0730","registration_date":null,"region":"CD","ci_status_code":"C","location":"CLKGVN","location_desc":"CLARKS GROVE MN","county_code_state":"MN","county_code":"047","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SYSCO","shipping_paper_number":"SP462200","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-05-28 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":"1788984","transaction_code":"A","transaction_date":"2025-05-28 00:00:00","upload_date":"2025-05-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00292854","upload_search_indicator":null,"census_search_date":"2025-05-28 21:42:00","snet_input_date":"2025-05-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-28 21:42:00","insp_carrier_name":"SYSCO ASIAN FOODS INC","insp_carrier_street":"1300 LORIENT STREET","insp_carrier_city":"ST PAUL","insp_carrier_state":"MN","insp_carrier_zip_code":"55117","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-31T10:01:21.000000Z","updated_at":"2025-06-01T10:00:16.000000Z","inspection_violations":[{"id":13973490,"change_date":"2025-05-28 21:42:00","inspection_id":"84796023","insp_violation_id":"266507088","seq_no":"1","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"207093961","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-31T10:16:56.000000Z","updated_at":"2025-06-01T10:17:15.000000Z","normalized_code":"3922SLLIFTA"}],"inspection_per_units":[{"id":14311757,"change_date":"2025-05-28 21:42:00","inspection_id":"84796023","insp_unit_id":"207093961","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"149677","insp_unit_license":"3786745","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHTDV2SDWB8052","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-31T09:46:44.000000Z","updated_at":"2025-06-01T09:46:50.000000Z"},{"id":14311758,"change_date":"2025-05-28 21:42:00","inspection_id":"84796023","insp_unit_id":"207093962","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"244454","insp_unit_license":"8729STT","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1GRAA9626HB703428","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-31T09:46:44.000000Z","updated_at":"2025-06-01T09:46:50.000000Z"}]},{"id":8350172,"change_date":"2025-04-11 21:40:00","inspection_id":"84372328","dot_number":"292854","report_state":"WI","report_number":"2315000392","insp_date":"2025-04-08 00:00:00","insp_start_time":"1003","insp_end_time":"1033","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"ELM GROVE WI","county_code_state":"WI","county_code":"133","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SELF","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":"2025-04-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1582271","transaction_code":"A","transaction_date":"2025-04-11 00:00:00","upload_date":"2025-04-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00292854","upload_search_indicator":null,"census_search_date":"2025-04-11 21:40:00","snet_input_date":"2025-04-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-11 21:40:00","insp_carrier_name":"SYSCO ASIAN FOODS INC","insp_carrier_street":"1300 LORIENT STREET","insp_carrier_city":"ST PAUL","insp_carrier_state":"MN","insp_carrier_zip_code":"55117","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-14T10:29:30.000000Z","updated_at":"2025-04-15T10:14:37.000000Z","inspection_violations":[{"id":13151639,"change_date":"2025-04-11 21:40:00","inspection_id":"84372328","insp_violation_id":"265562161","seq_no":"1","part_no":"392","part_no_section":"2-SLLTCD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-13T10:57:56.000000Z","updated_at":"2025-04-15T10:26:54.000000Z","normalized_code":"3922SLLTCD"}],"inspection_per_units":[{"id":13548473,"change_date":"2025-04-11 21:40:00","inspection_id":"84372328","insp_unit_id":"206261879","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"133797","insp_unit_license":"2962399","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4MC9EG8FN927511","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-14T10:11:51.000000Z","updated_at":"2025-04-15T09:55:18.000000Z"},{"id":13548474,"change_date":"2025-04-11 21:40:00","inspection_id":"84372328","insp_unit_id":"206261880","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"247630","insp_unit_license":"6277STT","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"3H3V382CXKT849001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-14T10:11:51.000000Z","updated_at":"2025-04-15T09:55:18.000000Z"}]},{"id":7903028,"change_date":"2025-02-19 21:40:00","inspection_id":"83902053","dot_number":"292854","report_state":"ND","report_number":"TR88007164","insp_date":"2025-02-17 00:00:00","insp_start_time":"1320","insp_end_time":"1350","registration_date":null,"region":"CS","ci_status_code":"C","location":"APPLWB","location_desc":"BISMARCK ND","county_code_state":"ND","county_code":"015","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SYSCO ASIAN FOODS","shipping_paper_number":"ROUTE 1410","cargo_tank":null,"hazmat_placard_req":null,"snet_version_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-19 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":"1376401","transaction_code":"A","transaction_date":"2025-02-19 00:00:00","upload_date":"2025-02-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00292854","upload_search_indicator":null,"census_search_date":"2025-02-19 21:40:00","snet_input_date":"2025-02-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-19 21:40:00","insp_carrier_name":"SYSCO ASIAN FOODS INC","insp_carrier_street":"1300 LORIENT STREET","insp_carrier_city":"ST PAUL","insp_carrier_state":"MN","insp_carrier_zip_code":"55117","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:02:20.000000Z","updated_at":"2025-03-17T21:02:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12756900,"change_date":"2025-02-19 21:40:00","inspection_id":"83902053","insp_unit_id":"205387631","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"135825","insp_unit_license":"2962406","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4MC9EG8HN983760","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:57.000000Z","updated_at":"2025-03-17T23:55:57.000000Z"},{"id":12756901,"change_date":"2025-02-19 21:40:00","inspection_id":"83902053","insp_unit_id":"205387632","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"229296","insp_unit_license":"6271STT","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1GRAA962XDB707623","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:57.000000Z","updated_at":"2025-03-17T23:55:57.000000Z"}]},{"id":7925572,"change_date":"2025-02-21 21:40:00","inspection_id":"83925638","dot_number":"292854","report_state":"MN","report_number":"0460000178","insp_date":"2025-02-14 00:00:00","insp_start_time":"1226","insp_end_time":"1302","registration_date":null,"region":"CS","ci_status_code":"C","location":"CLKGVN","location_desc":"CLARKS GROVE MN","county_code_state":"MN","county_code":"047","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"SP457978","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-02-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1383305","transaction_code":"A","transaction_date":"2025-02-21 00:00:00","upload_date":"2025-02-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00292854","upload_search_indicator":null,"census_search_date":"2025-02-21 21:40:00","snet_input_date":"2025-02-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-21 21:40:00","insp_carrier_name":"SYSCO ASIAN FOODS INC","insp_carrier_street":"1300 LORIENT STREET","insp_carrier_city":"ST PAUL","insp_carrier_state":"MN","insp_carrier_zip_code":"55117","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:02:49.000000Z","updated_at":"2025-03-17T21:02:49.000000Z","inspection_violations":[{"id":12382171,"change_date":"2025-02-21 21:40:00","inspection_id":"83925638","insp_violation_id":"264625879","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T22:06:31.000000Z","updated_at":"2025-03-17T22:06:31.000000Z","normalized_code":"3922SLLEWA3"}],"inspection_per_units":[{"id":12793814,"change_date":"2025-02-21 21:40:00","inspection_id":"83925638","insp_unit_id":"205432237","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"146093","insp_unit_license":"2962391","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHTDV0PDUP2066","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:56:19.000000Z","updated_at":"2025-03-17T23:56:19.000000Z"},{"id":12793815,"change_date":"2025-02-21 21:40:00","inspection_id":"83925638","insp_unit_id":"205432238","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"4674STX","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1GRAA9625CB706863","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:56:19.000000Z","updated_at":"2025-03-17T23:56:19.000000Z"}]},{"id":7882209,"change_date":"2025-02-17 21:35:00","inspection_id":"83880256","dot_number":"292854","report_state":"MN","report_number":"0317000398","insp_date":"2025-02-10 00:00:00","insp_start_time":"1418","insp_end_time":"1437","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"SOUTH SAINT PAUL MN","county_code_state":"MN","county_code":"037","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":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-02-17 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1368390","transaction_code":"A","transaction_date":"2025-02-17 00:00:00","upload_date":"2025-02-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00292854","upload_search_indicator":null,"census_search_date":"2025-02-17 21:35:00","snet_input_date":"2025-02-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-17 21:35:00","insp_carrier_name":"SYSCO ASIAN FOODS INC","insp_carrier_street":"1300 LORIENT STREET","insp_carrier_city":"ST PAUL","insp_carrier_state":"MN","insp_carrier_zip_code":"55117","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:01:57.000000Z","updated_at":"2025-03-17T21:01:57.000000Z","inspection_violations":[{"id":12318893,"change_date":"2025-02-17 21:35:00","inspection_id":"83880256","insp_violation_id":"264543798","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:06.000000Z","updated_at":"2025-03-17T22:06:06.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":12722547,"change_date":"2025-02-17 21:35:00","inspection_id":"83880256","insp_unit_id":"205348050","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"131784","insp_unit_license":"292854","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUJGEDR1DLBV8272","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:33.000000Z","updated_at":"2025-03-17T23:55:33.000000Z"}]},{"id":7832519,"change_date":"2025-02-10 21:40:00","inspection_id":"83828166","dot_number":"292854","report_state":"IA","report_number":"000P120DHD","insp_date":"2025-02-07 00:00:00","insp_start_time":"0919","insp_end_time":"0945","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 14 NB","county_code_state":"IA","county_code":"023","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SYSCO ASIAN FOODS","shipping_paper_number":"4350","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1348791","transaction_code":"A","transaction_date":"2025-02-10 00:00:00","upload_date":"2025-02-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00292854","upload_search_indicator":"M","census_search_date":"2025-02-10 21:40:00","snet_input_date":"2025-02-07 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-02-10 21:40:00","insp_carrier_name":"SYSCO ASIAN FOODS INC","insp_carrier_street":"1300 LORIENT STREET","insp_carrier_city":"ST PAUL","insp_carrier_state":"MN","insp_carrier_zip_code":"55117","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:00:47.000000Z","updated_at":"2025-03-17T21:00:47.000000Z","inspection_violations":[{"id":12238439,"change_date":"2025-02-10 21:40:00","inspection_id":"83828166","insp_violation_id":"264437978","seq_no":"1","part_no":"392","part_no_section":"2-SLLS3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"3KOO25020709305","created_at":"2025-03-17T22:05:41.000000Z","updated_at":"2025-03-17T22:05:41.000000Z","normalized_code":"3922SLLS3"},{"id":12238440,"change_date":"2025-02-10 21:40:00","inspection_id":"83828166","insp_violation_id":"264437979","seq_no":"2","part_no":"395","part_no_section":"30B1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:41.000000Z","updated_at":"2025-03-17T22:05:41.000000Z","normalized_code":"39530B1"}],"inspection_per_units":[{"id":12640912,"change_date":"2025-02-10 21:40:00","inspection_id":"83828166","insp_unit_id":"205251327","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"ASF_1379","insp_unit_license":"2962415","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4W39EG1KN196326","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:39.000000Z","updated_at":"2025-03-17T23:54:39.000000Z"},{"id":12640913,"change_date":"2025-02-10 21:40:00","inspection_id":"83828166","insp_unit_id":"205251328","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUN","insp_unit_company":"246256","insp_unit_license":"6250STT","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"3H3V482C9JT551003","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:39.000000Z","updated_at":"2025-03-17T23:54:39.000000Z"}]},{"id":7702405,"change_date":"2025-01-24 21:40:00","inspection_id":"83691200","dot_number":"292854","report_state":"IA","report_number":"000P10ST8Z","insp_date":"2025-01-22 00:00:00","insp_start_time":"1440","insp_end_time":"1500","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 122","county_code_state":"IA","county_code":"033","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SYSCO FOODS","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-01-24 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":"1346827","transaction_code":"A","transaction_date":"2025-01-23 00:00:00","upload_date":"2025-01-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00292854","upload_search_indicator":"M","census_search_date":"2025-01-24 21:40:00","snet_input_date":"2025-01-22 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-01-24 21:40:00","insp_carrier_name":"SYSCO ASIAN FOODS INC","insp_carrier_street":"1300 LORIENT STREET","insp_carrier_city":"ST PAUL","insp_carrier_state":"MN","insp_carrier_zip_code":"55117","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:58:15.000000Z","updated_at":"2025-03-17T20:58:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12429044,"change_date":"2025-01-24 21:40:00","inspection_id":"83691200","insp_unit_id":"204993178","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VLV","insp_unit_company":"ASF_1358","insp_unit_license":"2962406","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4MC9EG8HN983760","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:08.000000Z","updated_at":"2025-03-17T23:52:08.000000Z"},{"id":12429045,"change_date":"2025-01-24 21:40:00","inspection_id":"83691200","insp_unit_id":"204993179","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUN","insp_unit_company":"246254","insp_unit_license":"7297STT","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"3H3V482C5JT551001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:08.000000Z","updated_at":"2025-03-17T23:52:08.000000Z"}]},{"id":6638860,"change_date":"2024-09-04 21:41:00","inspection_id":"82566545","dot_number":"292854","report_state":"MN","report_number":"1603000299","insp_date":"2024-08-28 00:00:00","insp_start_time":"0830","insp_end_time":"0913","registration_date":null,"region":"CD","ci_status_code":"C","location":"RDRVR","location_desc":"MOORHEAD MN","county_code_state":"MN","county_code":"027","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"REILES\/UNITED SUGARS CORP","shipping_paper_number":"121442","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-09-04 21:41: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":"812028","transaction_code":"A","transaction_date":"2024-09-04 00:00:00","upload_date":"2024-09-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00292854","upload_search_indicator":null,"census_search_date":"2024-09-04 21:41:00","snet_input_date":"2024-08-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-09-04 21:41:00","insp_carrier_name":"SYSCO ASIAN FOODS INC","insp_carrier_street":"1300 LORIENT STREET","insp_carrier_city":"ST PAUL","insp_carrier_state":"MN","insp_carrier_zip_code":"55117","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:34:30.000000Z","updated_at":"2025-03-17T20:34:30.000000Z","inspection_violations":[{"id":10328734,"change_date":"2024-09-04 21:41:00","inspection_id":"82566545","insp_violation_id":"261589260","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"882416030058","created_at":"2025-03-17T21:56:02.000000Z","updated_at":"2025-03-17T21:56:02.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10703576,"change_date":"2024-09-04 21:41:00","inspection_id":"82566545","insp_unit_id":"202739618","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"147838","insp_unit_license":"2962398","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHTDV3RSVH3578","insp_unit_decal":"Y","insp_unit_decal_number":"34364339","created_at":"2025-03-17T23:33:50.000000Z","updated_at":"2025-03-17T23:33:50.000000Z"},{"id":10703577,"change_date":"2024-09-04 21:41:00","inspection_id":"82566545","insp_unit_id":"202739619","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"246256","insp_unit_license":"6250STT","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"3H3V482C9JT551003","insp_unit_decal":"Y","insp_unit_decal_number":"34364340","created_at":"2025-03-17T23:33:50.000000Z","updated_at":"2025-03-17T23:33:50.000000Z"}]},{"id":6451553,"change_date":"2024-08-13 21:41:00","inspection_id":"82366975","dot_number":"292854","report_state":"ND","report_number":"TR36006570","insp_date":"2024-08-07 00:00:00","insp_start_time":"0829","insp_end_time":"0844","registration_date":null,"region":"CD","ci_status_code":"C","location":"FARGO","location_desc":"FARGO ND","county_code_state":"ND","county_code":"017","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-08-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"47000","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":"740425","transaction_code":"A","transaction_date":"2024-08-13 00:00:00","upload_date":"2024-08-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00292854","upload_search_indicator":null,"census_search_date":"2024-08-13 21:41:00","snet_input_date":"2024-08-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-13 21:41:00","insp_carrier_name":"SYSCO ASIAN FOODS INC","insp_carrier_street":"1300 LORIENT STREET","insp_carrier_city":"ST PAUL","insp_carrier_state":"MN","insp_carrier_zip_code":"55117","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:30:42.000000Z","updated_at":"2025-03-17T20:30:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10398639,"change_date":"2024-08-13 21:41:00","inspection_id":"82366975","insp_unit_id":"202358538","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"2962391","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHTDV0PDUP2066","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:45.000000Z","updated_at":"2025-03-17T23:30:45.000000Z"},{"id":10398640,"change_date":"2024-08-13 21:41:00","inspection_id":"82366975","insp_unit_id":"202358539","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":null,"insp_unit_license":"C146998","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"3H3V482K3NJ211001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:45.000000Z","updated_at":"2025-03-17T23:30:45.000000Z"}]},{"id":6559424,"change_date":"2024-08-26 21:41:00","inspection_id":"82481920","dot_number":"292854","report_state":"MN","report_number":"1640000197","insp_date":"2024-07-20 00:00:00","insp_start_time":"0855","insp_end_time":"1015","registration_date":null,"region":"CD","ci_status_code":"C","location":"RDRVR","location_desc":"MOORHEAD MN","county_code_state":"MN","county_code":"027","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SYSCO ASIAN FOOD","shipping_paper_number":"5320","cargo_tank":null,"hazmat_placard_req":null,"snet_version_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-26 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"784685","transaction_code":"A","transaction_date":"2024-08-26 00:00:00","upload_date":"2024-08-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00292854","upload_search_indicator":null,"census_search_date":"2024-08-26 21:41:00","snet_input_date":"2024-07-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-26 21:41:00","insp_carrier_name":"SYSCO ASIAN FOODS INC","insp_carrier_street":"1300 LORIENT STREET","insp_carrier_city":"ST PAUL","insp_carrier_state":"MN","insp_carrier_zip_code":"55117","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:32:50.000000Z","updated_at":"2025-03-17T20:32:50.000000Z","inspection_violations":[{"id":10192720,"change_date":"2024-08-26 21:41:00","inspection_id":"82481920","insp_violation_id":"261399098","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"202577180","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:55:20.000000Z","updated_at":"2025-03-17T21:55:20.000000Z","normalized_code":"39375A3"},{"id":10192721,"change_date":"2024-08-26 21:41:00","inspection_id":"82481920","insp_violation_id":"261399099","seq_no":"2","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"202577179","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:20.000000Z","updated_at":"2025-03-17T21:55:20.000000Z","normalized_code":"39345B2"},{"id":10192722,"change_date":"2024-08-26 21:41:00","inspection_id":"82481920","insp_violation_id":"261399100","seq_no":"3","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"202577180","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:20.000000Z","updated_at":"2025-03-17T21:55:20.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":10574800,"change_date":"2024-08-26 21:41:00","inspection_id":"82481920","insp_unit_id":"202577179","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"147839","insp_unit_license":"2962385","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUJGBDV1CSBF3682","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:31.000000Z","updated_at":"2025-03-17T23:32:31.000000Z"},{"id":10574801,"change_date":"2024-08-26 21:41:00","inspection_id":"82481920","insp_unit_id":"202577180","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYSTER COR","insp_unit_company":"247629","insp_unit_license":"6280STT","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"3H3V482C4KT844003","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:31.000000Z","updated_at":"2025-03-17T23:32:31.000000Z"}]},{"id":5763607,"change_date":"2024-05-16 21:40:00","inspection_id":"81625819","dot_number":"292854","report_state":"SD","report_number":"HP16000025","insp_date":"2024-05-16 00:00:00","insp_start_time":"1329","insp_end_time":"1346","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"WATERTOWN SD","county_code_state":"SD","county_code":"029","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SYSCO ASIAN FOODS","shipping_paper_number":"144057","cargo_tank":null,"hazmat_placard_req":null,"snet_version_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-05-16 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":"488393","transaction_code":"A","transaction_date":"2024-05-16 00:00:00","upload_date":"2024-05-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00292854","upload_search_indicator":null,"census_search_date":"2024-05-16 21:40:00","snet_input_date":"2024-05-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-05-16 21:40:00","insp_carrier_name":"SYSCO ASIAN FOODS INC","insp_carrier_street":"1300 LORIENT STREET","insp_carrier_city":"ST PAUL","insp_carrier_state":"MN","insp_carrier_zip_code":"55117","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:17:04.000000Z","updated_at":"2025-03-17T20:17:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9283227,"change_date":"2024-05-16 21:40:00","inspection_id":"81625819","insp_unit_id":"200922597","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":null,"insp_unit_license":"3283486","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4WC9EG9PN332578","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:24.000000Z","updated_at":"2025-03-17T23:19:24.000000Z"},{"id":9283228,"change_date":"2024-05-16 21:40:00","inspection_id":"81625819","insp_unit_id":"200922598","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":null,"insp_unit_license":"6278STT","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"3H3V482C0KT844001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:24.000000Z","updated_at":"2025-03-17T23:19:24.000000Z"}]},{"id":5540463,"change_date":"2024-04-18 21:39:00","inspection_id":"81383151","dot_number":"292854","report_state":"SD","report_number":"0750000553","insp_date":"2024-04-18 00:00:00","insp_start_time":"0842","insp_end_time":"0858","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"WEBSTER SD","county_code_state":"SD","county_code":"037","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SYSCO ASIAN FOODS","shipping_paper_number":"144057","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-04-18 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"115000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"408678","transaction_code":"A","transaction_date":"2024-04-18 00:00:00","upload_date":"2024-04-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00292854","upload_search_indicator":null,"census_search_date":"2024-04-18 21:39:00","snet_input_date":"2024-04-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-04-18 21:39:00","insp_carrier_name":"SYSCO ASIAN FOODS INC","insp_carrier_street":"1300 LORIENT STREET","insp_carrier_city":"ST PAUL","insp_carrier_state":"MN","insp_carrier_zip_code":"55117","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:12:42.000000Z","updated_at":"2025-03-17T20:12:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8924667,"change_date":"2024-04-18 21:39:00","inspection_id":"81383151","insp_unit_id":"200458854","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"ASF144057","insp_unit_license":"3283486","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4WC9EG9PN332578","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:02.000000Z","updated_at":"2025-03-17T23:16:02.000000Z"},{"id":8924668,"change_date":"2024-04-18 21:39:00","inspection_id":"81383151","insp_unit_id":"200458855","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"247627","insp_unit_license":"6278STT","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"3H3V482C0KT844001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:02.000000Z","updated_at":"2025-03-17T23:16:02.000000Z"}]},{"id":5002212,"change_date":"2024-02-08 21:42:00","inspection_id":"80795778","dot_number":"292854","report_state":"ND","report_number":"TR20000877","insp_date":"2024-01-31 00:00:00","insp_start_time":"0840","insp_end_time":"0852","registration_date":null,"region":"CS","ci_status_code":"C","location":"FARGO","location_desc":"FARGO ND","county_code_state":"ND","county_code":"017","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SYSCO","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"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-08 21:42: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":"227053","transaction_code":"A","transaction_date":"2024-02-08 00:00:00","upload_date":"2024-02-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00292854","upload_search_indicator":null,"census_search_date":"2024-02-08 21:42:00","snet_input_date":"2024-01-31 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-02-08 21:42:00","insp_carrier_name":"SYSCO ASIAN FOODS INC","insp_carrier_street":"1300 LORIENT STREET","insp_carrier_city":"ST PAUL","insp_carrier_state":"MN","insp_carrier_zip_code":"55117","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:01:59.000000Z","updated_at":"2025-03-17T20:01:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8051218,"change_date":"2024-02-08 21:42:00","inspection_id":"80795778","insp_unit_id":"199320961","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"2962391","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHTDV0PDUP2066","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:58.000000Z","updated_at":"2025-03-17T23:07:58.000000Z"},{"id":8051219,"change_date":"2024-02-08 21:42:00","inspection_id":"80795778","insp_unit_id":"199320962","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":null,"insp_unit_license":"PB12428","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V482K3NJ211001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:58.000000Z","updated_at":"2025-03-17T23:07:58.000000Z"}]},{"id":4838782,"change_date":"2024-01-16 21:45:00","inspection_id":"80617000","dot_number":"292854","report_state":"MN","report_number":"0ADS001576","insp_date":"2024-01-15 00:00:00","insp_start_time":"0625","insp_end_time":"0644","registration_date":null,"region":"CT","ci_status_code":"C","location":"MRTB","location_desc":"HECTOR-ROADSIDE","county_code_state":"MN","county_code":"129","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"ROUTE 1180 RAP","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2024-01-16 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"115000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1430408","transaction_code":"A","transaction_date":"2024-01-15 00:00:00","upload_date":"2024-01-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00292854","upload_search_indicator":null,"census_search_date":"2024-01-16 21:45:00","snet_input_date":"2024-01-16 00:00:00","source_office":"3MNS001","mcmis_add_date":"2024-01-16 21:45:00","insp_carrier_name":"SYSCO ASIAN FOODS INC","insp_carrier_street":"1300 LORIENT STREET","insp_carrier_city":"ST PAUL","insp_carrier_state":"MN","insp_carrier_zip_code":"55117","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:58:29.000000Z","updated_at":"2025-03-17T19:58:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7785075,"change_date":"2024-01-16 21:45:00","inspection_id":"80617000","insp_unit_id":"198972427","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"146092","insp_unit_license":"2962417","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHTDV9PDUP2065","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:36.000000Z","updated_at":"2025-03-17T23:05:36.000000Z"},{"id":7785076,"change_date":"2024-01-16 21:45:00","inspection_id":"80617000","insp_unit_id":"198972428","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":null,"insp_unit_license":"PB12429","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V482K3NJ211001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:36.000000Z","updated_at":"2025-03-17T23:05:36.000000Z"}]},{"id":4646906,"change_date":"2023-12-16 21:30:00","inspection_id":"80407291","dot_number":"292854","report_state":"WI","report_number":"2764003199","insp_date":"2023-12-15 00:00:00","insp_start_time":"1600","insp_end_time":"1630","registration_date":null,"region":"CS","ci_status_code":"C","location":"S72","location_desc":"SOUTH RANGE WI","county_code_state":"WI","county_code":"031","insp_level_id":"1","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":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2023-12-16 21:30:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"133928","transaction_code":"A","transaction_date":"2023-12-16 00:00:00","upload_date":"2023-12-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00292854","upload_search_indicator":null,"census_search_date":"2023-12-16 21:30:00","snet_input_date":"2023-12-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-12-16 21:30:00","insp_carrier_name":"SYSCO ASIAN FOODS INC","insp_carrier_street":"1300 LORIENT STREET","insp_carrier_city":"ST PAUL","insp_carrier_state":"MN","insp_carrier_zip_code":"55117","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:54:57.000000Z","updated_at":"2025-03-17T19:54:57.000000Z","inspection_violations":[{"id":7184115,"change_date":"2023-12-16 21:30:00","inspection_id":"80407291","insp_violation_id":"256924419","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"198540543","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:43.000000Z","updated_at":"2025-03-17T21:40:43.000000Z","normalized_code":"39347E"},{"id":7184116,"change_date":"2023-12-16 21:30:00","inspection_id":"80407291","insp_violation_id":"256924420","seq_no":"2","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"2","insp_unit_id":"198540543","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:43.000000Z","updated_at":"2025-03-17T21:40:43.000000Z","normalized_code":"39353BB"},{"id":7184117,"change_date":"2023-12-16 21:30:00","inspection_id":"80407291","insp_violation_id":"256924421","seq_no":"3","part_no":"393","part_no_section":"55(c)(2)","insp_viol_unit":"2","insp_unit_id":"198540543","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:43.000000Z","updated_at":"2025-03-17T21:40:43.000000Z","normalized_code":"39355C2"}],"inspection_per_units":[{"id":7473618,"change_date":"2023-12-16 21:30:00","inspection_id":"80407291","insp_unit_id":"198540542","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":null,"insp_unit_license":"2962410","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4MC9EG2HN989442","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:49.000000Z","updated_at":"2025-03-17T23:02:49.000000Z"},{"id":7473619,"change_date":"2023-12-16 21:30:00","inspection_id":"80407291","insp_unit_id":"198540543","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HACKNEY &","insp_unit_company":null,"insp_unit_license":"4680STY","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"52616482XG5000257","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:49.000000Z","updated_at":"2025-03-17T23:02:49.000000Z"}]},{"id":4502935,"change_date":"2023-11-28 21:41:00","inspection_id":"80249003","dot_number":"292854","report_state":"SD","report_number":"1620000064","insp_date":"2023-11-25 00:00:00","insp_start_time":"0847","insp_end_time":"0901","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"BRANDON SD","county_code_state":"SD","county_code":"137","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SELF","shipping_paper_number":"1157","cargo_tank":null,"hazmat_placard_req":null,"snet_version_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-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"104000","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":"109364","transaction_code":"A","transaction_date":"2023-11-28 00:00:00","upload_date":"2023-11-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00292854","upload_search_indicator":null,"census_search_date":"2023-11-28 21:41:00","snet_input_date":"2023-11-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-11-28 21:41:00","insp_carrier_name":"SYSCO ASIAN FOODS INC","insp_carrier_street":"1300 LORIENT STREET","insp_carrier_city":"ST PAUL","insp_carrier_state":"MN","insp_carrier_zip_code":"55117","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:52:10.000000Z","updated_at":"2025-03-17T19:52:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7242293,"change_date":"2023-11-28 21:41:00","inspection_id":"80249003","insp_unit_id":"198231731","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"UNK","insp_unit_license":"3481026","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4WC9EG3KN208895","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:50.000000Z","updated_at":"2025-03-17T23:00:50.000000Z"},{"id":7242294,"change_date":"2023-11-28 21:41:00","inspection_id":"80249003","insp_unit_id":"198231732","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"247627","insp_unit_license":"6278STT","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"3H3V482C0KT844001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:50.000000Z","updated_at":"2025-03-17T23:00:50.000000Z"}]},{"id":4152481,"change_date":"2023-10-09 21:36:00","inspection_id":"79862256","dot_number":"292854","report_state":"TN","report_number":"TFFG000110","insp_date":"2023-10-06 00:00:00","insp_start_time":"1745","insp_end_time":"1833","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"GREENE CO SCALES","county_code_state":"TN","county_code":"059","insp_level_id":"1","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"AWESOME PRODUCTS INC.","shipping_paper_number":"840577","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-10-09 21:36:00","post_acc_ind":"N","gross_comb_veh_wt":"148000","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":"1679232","transaction_code":"A","transaction_date":"2023-10-06 00:00:00","upload_date":"2023-10-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00292854","upload_search_indicator":null,"census_search_date":"2023-10-09 21:36:00","snet_input_date":"2023-10-08 00:00:00","source_office":"2TNS001","mcmis_add_date":"2023-10-09 21:36:00","insp_carrier_name":"SYSCO ASIAN FOODS INC","insp_carrier_street":"1300 LORIENT STREET","insp_carrier_city":"ST PAUL","insp_carrier_state":"MN","insp_carrier_zip_code":"55117","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:44:57.000000Z","updated_at":"2025-03-17T19:44:57.000000Z","inspection_violations":[{"id":6426959,"change_date":"2023-10-09 21:36:00","inspection_id":"79862256","insp_violation_id":"255721307","seq_no":"1","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"197455110","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:00.000000Z","updated_at":"2025-03-17T21:37:00.000000Z","normalized_code":"39360C"},{"id":6426960,"change_date":"2023-10-09 21:36:00","inspection_id":"79862256","insp_violation_id":"255721308","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"197455111","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:00.000000Z","updated_at":"2025-03-17T21:37:00.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":6676860,"change_date":"2023-10-09 21:36:00","inspection_id":"79862256","insp_unit_id":"197455110","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1999","insp_unit_license":"R608373","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJGLD50ESFK3824","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:00.000000Z","updated_at":"2025-03-17T22:56:00.000000Z"},{"id":6676861,"change_date":"2023-10-09 21:36:00","inspection_id":"79862256","insp_unit_id":"197455111","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNK","insp_unit_company":"1010","insp_unit_license":"171C828","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2MN01JAH381000628","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:00.000000Z","updated_at":"2025-03-17T22:56:00.000000Z"}]},{"id":4071860,"change_date":"2023-09-27 21:41:00","inspection_id":"79772848","dot_number":"292854","report_state":"ND","report_number":"HP59000100","insp_date":"2023-09-21 00:00:00","insp_start_time":"1443","insp_end_time":"1505","registration_date":null,"region":"CT","ci_status_code":"C","location":"1","location_desc":"SOUTH OF STANLEY TURNOUT","county_code_state":"ND","county_code":"061","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"SYSCO ASIAN FOODS","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-09-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"375944","transaction_code":"A","transaction_date":"2023-09-27 00:00:00","upload_date":"2023-09-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00292854","upload_search_indicator":"M","census_search_date":"2023-09-27 21:41:00","snet_input_date":"2023-09-26 00:00:00","source_office":"4NDS001","mcmis_add_date":"2023-09-27 21:41:00","insp_carrier_name":"SYSCO ASIAN FOODS INC","insp_carrier_street":"1300 LORIENT STREET","insp_carrier_city":"ST PAUL","insp_carrier_state":"MN","insp_carrier_zip_code":"55117","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:43:13.000000Z","updated_at":"2025-03-17T19:43:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6546952,"change_date":"2023-09-27 21:41:00","inspection_id":"79772848","insp_unit_id":"197274229","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"2","insp_unit_license":"3283487","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4WC9EG7PN332580","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:57.000000Z","updated_at":"2025-03-17T22:54:57.000000Z"},{"id":6546953,"change_date":"2023-09-27 21:41:00","inspection_id":"79772848","insp_unit_id":"197274230","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":null,"insp_unit_license":"P839513","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V482C0LT888002","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:57.000000Z","updated_at":"2025-03-17T22:54:57.000000Z"}]},{"id":3992229,"change_date":"2023-09-18 21:38:00","inspection_id":"79684212","dot_number":"292854","report_state":"MN","report_number":"0AGG000056","insp_date":"2023-09-15 00:00:00","insp_start_time":"0830","insp_end_time":"0934","registration_date":null,"region":"CT","ci_status_code":"C","location":"RDRVR","location_desc":"RED RIVER WEIGH STATION","county_code_state":"MN","county_code":"027","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"3049065","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-09-18 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1410029","transaction_code":"A","transaction_date":"2023-09-15 00:00:00","upload_date":"2023-09-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00292854","upload_search_indicator":null,"census_search_date":"2023-09-18 21:38:00","snet_input_date":"2023-09-18 00:00:00","source_office":"3MNS001","mcmis_add_date":"2023-09-18 21:38:00","insp_carrier_name":"SYSCO ASIAN FOODS INC","insp_carrier_street":"1300 LORIENT STREET","insp_carrier_city":"ST PAUL","insp_carrier_state":"MN","insp_carrier_zip_code":"55117","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:41:39.000000Z","updated_at":"2025-03-17T19:41:39.000000Z","inspection_violations":[{"id":6175137,"change_date":"2023-09-18 21:38:00","inspection_id":"79684212","insp_violation_id":"255320013","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"882316730003","created_at":"2025-03-17T21:35:49.000000Z","updated_at":"2025-03-17T21:35:49.000000Z","normalized_code":"3922"},{"id":6175138,"change_date":"2023-09-18 21:38:00","inspection_id":"79684212","insp_violation_id":"255320014","seq_no":"1","part_no":"395","part_no_section":"24(d)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:49.000000Z","updated_at":"2025-03-17T21:35:49.000000Z","normalized_code":"39524D"}],"inspection_per_units":[{"id":6419353,"change_date":"2023-09-18 21:38:00","inspection_id":"79684212","insp_unit_id":"197099043","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"137970","insp_unit_license":"2962415","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHTDV0PDUP2066","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:53.000000Z","updated_at":"2025-03-17T22:53:53.000000Z"},{"id":6419354,"change_date":"2023-09-18 21:38:00","inspection_id":"79684212","insp_unit_id":"197099044","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"246254","insp_unit_license":"7297STT","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"3H3V482C5JT551001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:53.000000Z","updated_at":"2025-03-17T22:53:53.000000Z"}]},{"id":3834403,"change_date":"2023-08-25 21:41:00","inspection_id":"79508530","dot_number":"292854","report_state":"WI","report_number":"2342007901","insp_date":"2023-08-24 00:00:00","insp_start_time":"0716","insp_end_time":"0737","registration_date":null,"region":"CT","ci_status_code":"C","location":"04(57)","location_desc":"EDGEWATER (TOWN)","county_code_state":"WI","county_code":"113","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-08-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"904281","transaction_code":"A","transaction_date":"2023-08-24 00:00:00","upload_date":"2023-08-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00292854","upload_search_indicator":null,"census_search_date":"2023-08-25 21:41:00","snet_input_date":"2023-08-25 00:00:00","source_office":"3WIS001","mcmis_add_date":"2023-08-25 21:41:00","insp_carrier_name":"SYSCO ASIAN FOODS INC","insp_carrier_street":"1300 LORIENT STREET","insp_carrier_city":"ST PAUL","insp_carrier_state":"MN","insp_carrier_zip_code":"55117","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:38:33.000000Z","updated_at":"2025-03-17T19:38:33.000000Z","inspection_violations":[{"id":5921629,"change_date":"2023-08-25 21:41:00","inspection_id":"79508530","insp_violation_id":"254893875","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":"BH004947-5","created_at":"2025-03-17T21:34:39.000000Z","updated_at":"2025-03-17T21:34:39.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6165019,"change_date":"2023-08-25 21:41:00","inspection_id":"79508530","insp_unit_id":"196736751","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"2962399","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4MC9EG8FN927511","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:49.000000Z","updated_at":"2025-03-17T22:51:49.000000Z"},{"id":6165020,"change_date":"2023-08-25 21:41:00","inspection_id":"79508530","insp_unit_id":"196736752","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"7296STT","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1GRAA9626JB705718","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:49.000000Z","updated_at":"2025-03-17T22:51:49.000000Z"}]},{"id":3776359,"change_date":"2023-08-18 21:41:00","inspection_id":"79443416","dot_number":"292854","report_state":"IA","report_number":"000TT12XVS","insp_date":"2023-08-17 00:00:00","insp_start_time":"1000","insp_end_time":"1030","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"3100 BL HWY 169 NB OGDEN","county_code_state":"IA","county_code":"015","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SYSCO ASIAN FOODS","shipping_paper_number":"3490","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"118350","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1285405","transaction_code":"A","transaction_date":"2023-08-18 00:00:00","upload_date":"2023-08-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00292854","upload_search_indicator":"M","census_search_date":"2023-08-18 21:41:00","snet_input_date":"2023-08-17 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-08-18 21:41:00","insp_carrier_name":"SYSCO ASIAN FOODS INC","insp_carrier_street":"1300 LORIENT STREET","insp_carrier_city":"ST PAUL","insp_carrier_state":"MN","insp_carrier_zip_code":"55117","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:37:19.000000Z","updated_at":"2025-03-17T19:37:19.000000Z","inspection_violations":[{"id":5824686,"change_date":"2023-08-18 21:41:00","inspection_id":"79443416","insp_violation_id":"254739010","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:34:03.000000Z","updated_at":"2025-03-17T21:34:03.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6071534,"change_date":"2023-08-18 21:41:00","inspection_id":"79443416","insp_unit_id":"196606745","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"ASF_1338","insp_unit_license":"2962400","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4MC9EG6FN927510","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:02.000000Z","updated_at":"2025-03-17T22:51:02.000000Z"},{"id":6071535,"change_date":"2023-08-18 21:41:00","inspection_id":"79443416","insp_unit_id":"196606746","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"133819","insp_unit_license":"6284STT","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1GRAA9623DB700982","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:02.000000Z","updated_at":"2025-03-17T22:51:02.000000Z"}]},{"id":2868247,"change_date":"2023-04-24 21:40:00","inspection_id":"78421434","dot_number":"292854","report_state":"SD","report_number":"0970000030","insp_date":"2023-04-17 00:00:00","insp_start_time":"0906","insp_end_time":"0923","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"BRUCESD","county_code_state":"SD","county_code":"001","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SYSCO","shipping_paper_number":"1180","cargo_tank":null,"hazmat_placard_req":null,"snet_version_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-04-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9726","transaction_code":"A","transaction_date":"2023-04-24 00:00:00","upload_date":"2023-04-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00292854","upload_search_indicator":null,"census_search_date":"2023-04-24 21:40:00","snet_input_date":"2023-04-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-04-24 21:40:00","insp_carrier_name":"SYSCO ASIAN FOODS INC","insp_carrier_street":"1300 LORIENT STREET","insp_carrier_city":"ST PAUL","insp_carrier_state":"MN","insp_carrier_zip_code":"55117","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:19:41.000000Z","updated_at":"2025-03-17T19:19:41.000000Z","inspection_violations":[{"id":4402033,"change_date":"2023-04-24 21:40:00","inspection_id":"78421434","insp_violation_id":"252383336","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":"WARNING","created_at":"2025-03-17T21:27:35.000000Z","updated_at":"2025-03-17T21:27:35.000000Z","normalized_code":"3922"},{"id":4402034,"change_date":"2023-04-24 21:40:00","inspection_id":"78421434","insp_violation_id":"252383337","seq_no":"2","part_no":"392","part_no_section":"16-D","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"B1053493-HP","created_at":"2025-03-17T21:27:35.000000Z","updated_at":"2025-03-17T21:27:35.000000Z","normalized_code":"39216D"}],"inspection_per_units":[{"id":4615081,"change_date":"2023-04-24 21:40:00","inspection_id":"78421434","insp_unit_id":"194534188","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":null,"insp_unit_license":"3481026","insp_unit_license_state":"SD","insp_unit_vehicle_id_number":"4V4WC9EG3KN208895","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:25.000000Z","updated_at":"2025-03-17T22:39:25.000000Z"},{"id":4615082,"change_date":"2023-04-24 21:40:00","inspection_id":"78421434","insp_unit_id":"194534189","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":null,"insp_unit_license":"PB12429","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V482K3NJ211001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:25.000000Z","updated_at":"2025-03-17T22:39:25.000000Z"}]},{"id":2192890,"change_date":"2023-01-20 21:41:00","inspection_id":"77652972","dot_number":"292854","report_state":"IA","report_number":"000TTDB20Z","insp_date":"2023-01-18 00:00:00","insp_start_time":"1443","insp_end_time":"1459","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 71 SB","county_code_state":"IA","county_code":"161","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"ASIAN FOODS (SYSCO)","shipping_paper_number":"SELF","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"115300","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1259328","transaction_code":"A","transaction_date":"2023-01-20 00:00:00","upload_date":"2023-01-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00292854","upload_search_indicator":"M","census_search_date":"2023-01-20 21:41:00","snet_input_date":"2023-01-18 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-01-20 21:41:00","insp_carrier_name":"SYSCO ASIAN FOODS INC","insp_carrier_street":"1300 LORIENT STREET","insp_carrier_city":"ST PAUL","insp_carrier_state":"MN","insp_carrier_zip_code":"55117","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:06:58.000000Z","updated_at":"2025-03-17T19:06:58.000000Z","inspection_violations":[{"id":3387064,"change_date":"2023-01-20 21:41:00","inspection_id":"77652972","insp_violation_id":"250690859","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:01.000000Z","updated_at":"2025-03-17T21:23:01.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3529374,"change_date":"2023-01-20 21:41:00","inspection_id":"77652972","insp_unit_id":"192984133","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"103133823","insp_unit_license":"2962401","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4MC9EGXFN927509","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:18.000000Z","updated_at":"2025-03-17T22:31:18.000000Z"},{"id":3529375,"change_date":"2023-01-20 21:41:00","inspection_id":"77652972","insp_unit_id":"192984134","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUN","insp_unit_company":"247631","insp_unit_license":"6276STT","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"3H3V382C7KT848002","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:18.000000Z","updated_at":"2025-03-17T22:31:18.000000Z"}]},{"id":1170317,"change_date":"2022-08-30 21:40:00","inspection_id":"76476232","dot_number":"292854","report_state":"MN","report_number":"00ZV005727","insp_date":"2022-08-30 00:00:00","insp_start_time":"1050","insp_end_time":"1131","registration_date":null,"region":"CT","ci_status_code":"C","location":"ERSKN","location_desc":"ERSKINE WEIGH SCALE","county_code_state":"MN","county_code":"119","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-08-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"118350","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1347886","transaction_code":"A","transaction_date":"2022-08-30 00:00:00","upload_date":"2022-08-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00292854","upload_search_indicator":null,"census_search_date":"2022-08-30 21:40:00","snet_input_date":"2022-08-30 00:00:00","source_office":"3MNS001","mcmis_add_date":"2022-08-30 21:40:00","insp_carrier_name":"SYSCO ASIAN FOODS INC","insp_carrier_street":"1300 LORIENT STREET","insp_carrier_city":"ST PAUL","insp_carrier_state":"MN","insp_carrier_zip_code":"55117","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:48:18.000000Z","updated_at":"2025-03-17T18:48:18.000000Z","inspection_violations":[{"id":1855050,"change_date":"2022-08-30 21:40:00","inspection_id":"76476232","insp_violation_id":"248094912","seq_no":"1","part_no":"393","part_no_section":"207(b)","insp_viol_unit":"2","insp_unit_id":"190623015","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:34.000000Z","updated_at":"2025-03-17T21:15:34.000000Z","normalized_code":"393207B"}],"inspection_per_units":[{"id":1882019,"change_date":"2022-08-30 21:40:00","inspection_id":"76476232","insp_unit_id":"190623014","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"135825","insp_unit_license":"2962406","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4MC9EG8HN983760","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:57.000000Z","updated_at":"2025-03-17T22:19:57.000000Z"},{"id":1882020,"change_date":"2022-08-30 21:40:00","inspection_id":"76476232","insp_unit_id":"190623015","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYST","insp_unit_company":null,"insp_unit_license":"6280STT","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"3H3V482C4KT844003","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:57.000000Z","updated_at":"2025-03-17T22:19:57.000000Z"}]},{"id":1146807,"change_date":"2022-08-26 21:40:00","inspection_id":"76449023","dot_number":"292854","report_state":"MN","report_number":"00WI006612","insp_date":"2022-08-26 00:00:00","insp_start_time":"1105","insp_end_time":"1155","registration_date":null,"region":"CT","ci_status_code":"C","location":"RDRVR","location_desc":"RED RIVER WEIGH STATION","county_code_state":"MN","county_code":"027","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-08-26 21:40: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":"1347416","transaction_code":"A","transaction_date":"2022-08-26 00:00:00","upload_date":"2022-08-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00292854","upload_search_indicator":null,"census_search_date":"2022-08-26 21:40:00","snet_input_date":"2022-08-26 00:00:00","source_office":"3MNS001","mcmis_add_date":"2022-08-26 21:40:00","insp_carrier_name":"SYSCO ASIAN FOODS INC","insp_carrier_street":"1300 LORIENT STREET","insp_carrier_city":"ST PAUL","insp_carrier_state":"MN","insp_carrier_zip_code":"55117","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:47:54.000000Z","updated_at":"2025-03-17T18:47:54.000000Z","inspection_violations":[{"id":1815508,"change_date":"2022-08-26 21:40:00","inspection_id":"76449023","insp_violation_id":"248029741","seq_no":"1","part_no":"393","part_no_section":"45","insp_viol_unit":"2","insp_unit_id":"190568237","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:25.000000Z","updated_at":"2025-03-17T21:15:25.000000Z","normalized_code":"39345"},{"id":1815509,"change_date":"2022-08-26 21:40:00","inspection_id":"76449023","insp_violation_id":"248029742","seq_no":"2","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"190568237","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:25.000000Z","updated_at":"2025-03-17T21:15:25.000000Z","normalized_code":"39345B2"},{"id":1815510,"change_date":"2022-08-26 21:40:00","inspection_id":"76449023","insp_violation_id":"248029743","seq_no":"3","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"190568237","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:25.000000Z","updated_at":"2025-03-17T21:15:25.000000Z","normalized_code":"39345B2"},{"id":1815511,"change_date":"2022-08-26 21:40:00","inspection_id":"76449023","insp_violation_id":"248029744","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"190568237","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:15:25.000000Z","updated_at":"2025-03-17T21:15:25.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":1843481,"change_date":"2022-08-26 21:40:00","inspection_id":"76449023","insp_unit_id":"190568236","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"103 144059","insp_unit_license":"3283487","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4WC9EG7PN332580","insp_unit_decal":"Y","insp_unit_decal_number":"31703703","created_at":"2025-03-17T22:19:42.000000Z","updated_at":"2025-03-17T22:19:42.000000Z"},{"id":1843482,"change_date":"2022-08-26 21:40:00","inspection_id":"76449023","insp_unit_id":"190568237","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"6284STT","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1GRAA9623DB700982","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:42.000000Z","updated_at":"2025-03-17T22:19:42.000000Z"}]},{"id":1064320,"change_date":"2022-08-17 21:40:00","inspection_id":"76352782","dot_number":"292854","report_state":"WI","report_number":"2342007549","insp_date":"2022-08-12 00:00:00","insp_start_time":"0928","insp_end_time":"0945","registration_date":null,"region":"CT","ci_status_code":"C","location":"12(57)","location_desc":"RADISSON (TOWN)","county_code_state":"WI","county_code":"113","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-08-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"869132","transaction_code":"A","transaction_date":"2022-08-16 00:00:00","upload_date":"2022-08-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00292854","upload_search_indicator":"M","census_search_date":"2022-08-17 21:40:00","snet_input_date":"2022-08-16 00:00:00","source_office":"3WIS001","mcmis_add_date":"2022-08-17 21:40:00","insp_carrier_name":"SYSCO ASIAN FOODS INC","insp_carrier_street":"1300 LORIENT STREET","insp_carrier_city":"ST PAUL","insp_carrier_state":"MN","insp_carrier_zip_code":"55117","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:46:30.000000Z","updated_at":"2025-03-17T18:46:30.000000Z","inspection_violations":[{"id":1679503,"change_date":"2022-08-17 21:40:00","inspection_id":"76352782","insp_violation_id":"247794026","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:49.000000Z","updated_at":"2025-03-17T21:14:49.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1712667,"change_date":"2022-08-17 21:40:00","inspection_id":"76352782","insp_unit_id":"190375123","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"2962399","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4MC9EG8FN927511","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:48.000000Z","updated_at":"2025-03-17T22:18:48.000000Z"},{"id":1712668,"change_date":"2022-08-17 21:40:00","inspection_id":"76352782","insp_unit_id":"190375124","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"6289STP","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1GRAA9627HB712204","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:48.000000Z","updated_at":"2025-03-17T22:18:48.000000Z"}]},{"id":884857,"change_date":"2022-07-28 21:40:00","inspection_id":"76142655","dot_number":"292854","report_state":"SD","report_number":"0020085421","insp_date":"2022-07-22 00:00:00","insp_start_time":"0858","insp_end_time":"0920","registration_date":null,"region":"CT","ci_status_code":"C","location":"MC20","location_desc":"SIOUX FALLS PORT OF ENTRY","county_code_state":"SD","county_code":"099","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"SYSCO ASIAN FOODS","shipping_paper_number":"5190","cargo_tank":null,"hazmat_placard_req":null,"snet_version_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-25 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":null,"viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"623073","transaction_code":"C","transaction_date":"2022-07-28 00:00:00","upload_date":"2022-07-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00292854","upload_search_indicator":"M","census_search_date":"2022-07-25 21:39:00","snet_input_date":"2022-07-25 00:00:00","source_office":"4SDS001","mcmis_add_date":"2022-07-25 21:39:00","insp_carrier_name":"SYSCO ASIAN FOODS INC","insp_carrier_street":"1300 LORIENT STREET","insp_carrier_city":"ST PAUL","insp_carrier_state":"MN","insp_carrier_zip_code":"55117","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:43:21.000000Z","updated_at":"2025-03-17T18:43:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1424582,"change_date":"2022-07-28 21:40:00","inspection_id":"76142655","insp_unit_id":"190019675","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"103136223","insp_unit_license":"2962408","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4MC9EG2HN990588","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:56.000000Z","updated_at":"2025-03-17T22:16:56.000000Z"},{"id":1424583,"change_date":"2022-07-28 21:40:00","inspection_id":"76142655","insp_unit_id":"190019676","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"250539","insp_unit_license":"P839513","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V482C0LT888002","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:56.000000Z","updated_at":"2025-03-17T22:16:56.000000Z"}]},{"id":28606,"change_date":"2022-03-23 21:32:00","inspection_id":"75121288","dot_number":"292854","report_state":"MN","report_number":"00ZM005540","insp_date":"2022-03-23 00:00:00","insp_start_time":"1105","insp_end_time":"1118","registration_date":null,"region":"CT","ci_status_code":"C","location":"RDRVR","location_desc":"RED RIVER WEIGH STATION","county_code_state":"MN","county_code":"027","insp_level_id":"3","service_center":"MW","census_source_id":"4","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":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-03-23 21:32:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1319725","transaction_code":"A","transaction_date":"2022-03-23 00:00:00","upload_date":"2022-03-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00292854","upload_search_indicator":null,"census_search_date":"2022-03-23 21:32:00","snet_input_date":"2022-03-23 00:00:00","source_office":"3MNS001","mcmis_add_date":"2022-03-23 21:32:00","insp_carrier_name":"SYSCO ASIAN FOODS INC","insp_carrier_street":"1300 LORIENT STREET","insp_carrier_city":"ST PAUL","insp_carrier_state":"MN","insp_carrier_zip_code":"55117","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:28:05.000000Z","updated_at":"2025-03-17T18:28:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":46063,"change_date":"2022-03-23 21:32:00","inspection_id":"75121288","insp_unit_id":"187783782","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"137970","insp_unit_license":"2962415","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4W39EG1KN196326","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:33.000000Z","updated_at":"2025-03-17T22:08:33.000000Z"},{"id":46064,"change_date":"2022-03-23 21:32:00","inspection_id":"75121288","insp_unit_id":"187783783","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"228950","insp_unit_license":"6284STT","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1GRAA9623DB700982","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:33.000000Z","updated_at":"2025-03-17T22:08:33.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/292854\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/292854\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/292854\/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\/292854\/inspections","per_page":100,"prev_page_url":null,"to":46,"total":46}