{"current_page":1,"data":[{"id":12296554,"change_date":"2026-06-27 21:41:00","inspection_id":"88253374","dot_number":"596882","report_state":"CT","report_number":"3011002322","insp_date":"2026-06-26 00:00:00","insp_start_time":"0540","insp_end_time":"0627","registration_date":"2026-06-26 00:00:00","region":"ED","ci_status_code":"C","location":"083","location_desc":"CT","county_code_state":"CT","county_code":"007","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SYSCO","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-06-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"4","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3629119","transaction_code":"A","transaction_date":"2026-06-27 00:00:00","upload_date":"2026-06-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00596882","upload_search_indicator":null,"census_search_date":"2026-06-27 21:41:00","snet_input_date":"2026-06-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-27 21:41:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-30T09:40:08.000000Z","updated_at":"2026-07-08T09:30:25.000000Z","inspection_violations":[{"id":21402492,"change_date":"2026-06-27 21:41:00","inspection_id":"88253374","insp_violation_id":"275158984","seq_no":"1","part_no":"393","part_no_section":"9A-LRLIWR","insp_viol_unit":"2","insp_unit_id":"214315962","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-06-30T09:58:28.000000Z","updated_at":"2026-07-08T09:40:55.000000Z","normalized_code":"3939ALRLIWR"},{"id":21402493,"change_date":"2026-06-27 21:41:00","inspection_id":"88253374","insp_violation_id":"275158985","seq_no":"2","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"214315962","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-30T09:58:28.000000Z","updated_at":"2026-07-08T09:40:55.000000Z","normalized_code":"3939ALIL"},{"id":21402494,"change_date":"2026-06-27 21:41:00","inspection_id":"88253374","insp_violation_id":"275158986","seq_no":"3","part_no":"393","part_no_section":"9A-LSML","insp_viol_unit":"2","insp_unit_id":"214315962","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-30T09:58:28.000000Z","updated_at":"2026-07-08T09:40:55.000000Z","normalized_code":"3939ALSML"},{"id":21402495,"change_date":"2026-06-27 21:41:00","inspection_id":"88253374","insp_violation_id":"275158987","seq_no":"4","part_no":"393","part_no_section":"75A3-TAOLTIS","insp_viol_unit":"2","insp_unit_id":"214315962","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-06-30T09:58:28.000000Z","updated_at":"2026-07-08T09:40:55.000000Z","normalized_code":"39375A3TAOLTIS"}],"inspection_per_units":[{"id":21358320,"change_date":"2026-06-27 21:41:00","inspection_id":"88253374","insp_unit_id":"214315961","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"135526","insp_unit_license":"2341929","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUBGBDV3GLHE4374","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-30T09:16:21.000000Z","updated_at":"2026-07-08T09:01:31.000000Z"},{"id":21358321,"change_date":"2026-06-27 21:41:00","inspection_id":"88253374","insp_unit_id":"214315962","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"228030","insp_unit_license":"W11575","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1GRAA8420CB706802","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-30T09:16:21.000000Z","updated_at":"2026-07-08T09:01:31.000000Z"}]},{"id":12022668,"change_date":"2026-06-04 21:45:00","inspection_id":"87962317","dot_number":"596882","report_state":"CT","report_number":"3090005145","insp_date":"2026-05-27 00:00:00","insp_start_time":"1020","insp_end_time":"1116","registration_date":"2026-06-01 00:00:00","region":"ED","ci_status_code":"C","location":"034S","location_desc":"CT","county_code_state":"CT","county_code":"001","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SELF","shipping_paper_number":"0806194","cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-27 21:39: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":"3457961","transaction_code":"C","transaction_date":"2026-06-04 00:00:00","upload_date":"2026-06-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00596882","upload_search_indicator":null,"census_search_date":"2026-05-27 21:39:00","snet_input_date":"2026-05-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-27 21:39:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-30T09:39:22.000000Z","updated_at":"2026-06-16T09:30:10.000000Z","inspection_violations":[{"id":20920836,"change_date":"2026-06-04 21:45:00","inspection_id":"87962317","insp_violation_id":"274678362","seq_no":"1","part_no":"395","part_no_section":"30B1-ELDDFR","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":"2026-05-30T09:57:11.000000Z","updated_at":"2026-06-16T09:44:09.000000Z","normalized_code":"39530B1ELDDFR"}],"inspection_per_units":[{"id":20898163,"change_date":"2026-06-04 21:45:00","inspection_id":"87962317","insp_unit_id":"213899643","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"2488705","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUBC5DV9JHJM2698","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-30T09:17:21.000000Z","updated_at":"2026-06-16T09:01:18.000000Z"},{"id":20898164,"change_date":"2026-06-04 21:45:00","inspection_id":"87962317","insp_unit_id":"213899644","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":null,"insp_unit_license":"PG65363","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V422K1SJ519423","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-30T09:17:21.000000Z","updated_at":"2026-06-16T09:01:18.000000Z"}]},{"id":11811309,"change_date":"2026-05-02 21:34:00","inspection_id":"87744913","dot_number":"596882","report_state":"MA","report_number":"DQ00003266","insp_date":"2026-05-01 00:00:00","insp_start_time":"2300","insp_end_time":"2300","registration_date":null,"region":"ES","ci_status_code":"C","location":"370H","location_desc":"MA","county_code_state":"MA","county_code":"017","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SAME","shipping_paper_number":"803672","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"U","drug_intrdctn_search":"U","drug_intrdctn_arrests":"0","size_weight_enf":"U","traffic_enf":"U","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-02 21:34: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":"3249629","transaction_code":"A","transaction_date":"2026-05-02 00:00:00","upload_date":"2026-05-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00596882","upload_search_indicator":null,"census_search_date":"2026-05-02 21:34:00","snet_input_date":"2026-05-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-02 21:34:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-05T09:41:47.000000Z","updated_at":"2026-05-13T09:30:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20543966,"change_date":"2026-05-02 21:34:00","inspection_id":"87744913","insp_unit_id":"213349764","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRTV","insp_unit_company":null,"insp_unit_license":"2208911","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHTDV3SSWD0710","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-05T09:19:43.000000Z","updated_at":"2026-05-13T09:02:28.000000Z"},{"id":20543967,"change_date":"2026-05-02 21:34:00","inspection_id":"87744913","insp_unit_id":"213349765","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":null,"insp_unit_license":"PG26512","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"527SR4823SL044211","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-05T09:19:43.000000Z","updated_at":"2026-05-13T09:02:28.000000Z"}]},{"id":11725235,"change_date":"2026-05-04 21:38:00","inspection_id":"87652925","dot_number":"596882","report_state":"CT","report_number":"3011002225","insp_date":"2026-04-23 00:00:00","insp_start_time":"0546","insp_end_time":"0602","registration_date":"2026-05-04 00:00:00","region":"ET","ci_status_code":"C","location":"148","location_desc":"WALLINGFORD","county_code_state":"CT","county_code":"009","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SYSCO","shipping_paper_number":"554343738","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.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-04-23 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"771016","transaction_code":"C","transaction_date":"2026-04-23 00:00:00","upload_date":"2026-05-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00596882","upload_search_indicator":null,"census_search_date":"2026-04-23 21:38:00","snet_input_date":"2026-04-23 00:00:00","source_office":"1CTS001","mcmis_add_date":"2026-04-23 21:38:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-27T09:40:22.000000Z","updated_at":"2026-05-14T12:30:10.000000Z","inspection_violations":[{"id":20383886,"change_date":"2026-05-04 21:38:00","inspection_id":"87652925","insp_violation_id":"274015340","seq_no":"1","part_no":"392","part_no_section":"2-SLLML","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:59:58.000000Z","updated_at":"2026-05-14T12:41:29.000000Z","normalized_code":"3922SLLML"}],"inspection_per_units":[{"id":20402657,"change_date":"2026-05-04 21:38:00","inspection_id":"87652925","insp_unit_id":"213359482","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"145867","insp_unit_license":"2028312","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALACWFD5PDUC4638","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:18:23.000000Z","updated_at":"2026-05-14T11:47:31.000000Z"}]},{"id":11548816,"change_date":"2026-04-07 21:37:00","inspection_id":"87471531","dot_number":"596882","report_state":"CT","report_number":"3011002182","insp_date":"2026-04-02 00:00:00","insp_start_time":"1238","insp_end_time":"1253","registration_date":"2026-04-07 00:00:00","region":"ET","ci_status_code":"C","location":"119","location_desc":"ROCKY HILL","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SYSCO","shipping_paper_number":"554315284","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.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-04-02 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"769406","transaction_code":"C","transaction_date":"2026-04-02 00:00:00","upload_date":"2026-04-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00596882","upload_search_indicator":null,"census_search_date":"2026-04-02 21:38:00","snet_input_date":"2026-04-02 00:00:00","source_office":"1CTS001","mcmis_add_date":"2026-04-02 21:38:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-05T09:56:29.000000Z","updated_at":"2026-04-17T09:44:42.000000Z","inspection_violations":[{"id":19579649,"change_date":"2026-04-07 21:37:00","inspection_id":"87471531","insp_violation_id":"272902623","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-04-09T10:16:18.000000Z","updated_at":"2026-04-18T10:40:34.000000Z","normalized_code":"3922SLLTCD"}],"inspection_per_units":[{"id":19845823,"change_date":"2026-04-07 21:37:00","inspection_id":"87471531","insp_unit_id":"212570308","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRTV","insp_unit_company":"CON 145343","insp_unit_license":"3711022","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALACWFD3PDUC4511","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-10T09:22:16.000000Z","updated_at":"2026-04-18T09:27:07.000000Z"}]},{"id":11459416,"change_date":"2026-03-24 21:39:00","inspection_id":"87377272","dot_number":"596882","report_state":"CT","report_number":"3063007552","insp_date":"2026-03-24 00:00:00","insp_start_time":"0716","insp_end_time":"0758","registration_date":null,"region":"ET","ci_status_code":"C","location":"145S","location_desc":"UNION SCALE","county_code_state":"CT","county_code":"013","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SYSCO CONNECTICUT LLC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-24 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"102700","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"768550","transaction_code":"A","transaction_date":"2026-03-24 00:00:00","upload_date":"2026-03-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00596882","upload_search_indicator":null,"census_search_date":"2026-03-24 21:39:00","snet_input_date":"2026-03-24 00:00:00","source_office":"1CTS001","mcmis_add_date":"2026-03-24 21:39:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-27T09:45:10.000000Z","updated_at":"2026-04-04T09:30:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19627416,"change_date":"2026-03-24 21:39:00","inspection_id":"87377272","insp_unit_id":"212297316","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT","insp_unit_company":"243110","insp_unit_license":"P380278","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA8428FE702077","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-27T09:22:53.000000Z","updated_at":"2026-04-04T09:03:21.000000Z"},{"id":19627415,"change_date":"2026-03-24 21:39:00","inspection_id":"87377272","insp_unit_id":"212297315","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"147741","insp_unit_license":"2208895","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKBHTDV9RDVH0273","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-27T09:22:53.000000Z","updated_at":"2026-04-04T09:03:21.000000Z"}]},{"id":11230574,"change_date":"2026-02-26 21:40:00","inspection_id":"87142744","dot_number":"596882","report_state":"CT","report_number":"3070007747","insp_date":"2026-02-26 00:00:00","insp_start_time":"1440","insp_end_time":"1506","registration_date":null,"region":"ET","ci_status_code":"C","location":"034S","location_desc":"DANBURY SCALE","county_code_state":"CT","county_code":"001","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"554263855","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-02-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"77700","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"766316","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":"00596882","upload_search_indicator":null,"census_search_date":"2026-02-26 21:40:00","snet_input_date":"2026-02-26 00:00:00","source_office":"1CTS001","mcmis_add_date":"2026-02-26 21:40:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-01T10:38:47.000000Z","updated_at":"2026-03-09T09:30:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19197460,"change_date":"2026-02-26 21:40:00","inspection_id":"87142744","insp_unit_id":"211840388","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRTV","insp_unit_company":null,"insp_unit_license":"2208890","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKBHTDVXPDUP1849","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-01T10:15:36.000000Z","updated_at":"2026-03-09T09:05:09.000000Z"},{"id":19197461,"change_date":"2026-02-26 21:40:00","inspection_id":"87142744","insp_unit_id":"211840389","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KID","insp_unit_company":"245371","insp_unit_license":"PF55501","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"526162816H5000060","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-01T10:15:36.000000Z","updated_at":"2026-03-09T09:05:09.000000Z"}]},{"id":10871831,"change_date":"2026-02-02 21:38:00","inspection_id":"86901860","dot_number":"596882","report_state":"CT","report_number":"3120005821","insp_date":"2026-01-28 00:00:00","insp_start_time":"0557","insp_end_time":"0640","registration_date":"2026-02-02 00:00:00","region":"ET","ci_status_code":"C","location":"083","location_desc":"MIDDLETOWN","county_code_state":"CT","county_code":"007","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SYSCO CONNECTICUT LLC","shipping_paper_number":"0794584","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.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-01-28 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"71350","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"764309","transaction_code":"C","transaction_date":"2026-01-28 00:00:00","upload_date":"2026-02-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00596882","upload_search_indicator":null,"census_search_date":"2026-01-28 21:37:00","snet_input_date":"2026-01-28 00:00:00","source_office":"1CTS001","mcmis_add_date":"2026-01-28 21:37:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-31T10:36:23.000000Z","updated_at":"2026-02-13T10:30:09.000000Z","inspection_violations":[{"id":18258224,"change_date":"2026-02-02 21:38:00","inspection_id":"86901860","insp_violation_id":"271536769","seq_no":"1","part_no":"393","part_no_section":"23-LEU","insp_viol_unit":"2","insp_unit_id":"211385623","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2026-02-05T10:45:07.000000Z","updated_at":"2026-02-13T10:38:09.000000Z","normalized_code":"39323LEU"}],"inspection_per_units":[{"id":18330606,"change_date":"2026-02-02 21:38:00","inspection_id":"86901860","insp_unit_id":"211385622","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"143306","insp_unit_license":"2987460","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HSDXTZN0NN268517","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-05T10:08:34.000000Z","updated_at":"2026-02-13T10:04:28.000000Z"},{"id":18330607,"change_date":"2026-02-02 21:38:00","inspection_id":"86901860","insp_unit_id":"211385623","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"243496","insp_unit_license":"PG65598","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA5619GB711067","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-05T10:08:34.000000Z","updated_at":"2026-02-13T10:04:28.000000Z"}]},{"id":10630917,"change_date":"2026-01-13 21:38:00","inspection_id":"86771754","dot_number":"596882","report_state":"CT","report_number":"3025006172","insp_date":"2026-01-13 00:00:00","insp_start_time":"1557","insp_end_time":"1620","registration_date":null,"region":"ET","ci_status_code":"C","location":"083S","location_desc":"MIDDLETOWN SCALE","county_code_state":"CT","county_code":"007","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SYSCO CONNECTICUT LLC","shipping_paper_number":"0793271","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-01-13 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"763226","transaction_code":"A","transaction_date":"2026-01-13 00:00:00","upload_date":"2026-01-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00596882","upload_search_indicator":null,"census_search_date":"2026-01-13 21:38:00","snet_input_date":"2026-01-13 00:00:00","source_office":"1CTS001","mcmis_add_date":"2026-01-13 21:38:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-16T10:35:48.000000Z","updated_at":"2026-01-24T10:30:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17827691,"change_date":"2026-01-13 21:38:00","inspection_id":"86771754","insp_unit_id":"211040949","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRTV","insp_unit_company":"145343","insp_unit_license":"3711022","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALACWFD3PDUC4511","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-16T10:08:31.000000Z","updated_at":"2026-01-24T10:01:30.000000Z"}]},{"id":10620337,"change_date":"2026-01-12 21:38:00","inspection_id":"86760712","dot_number":"596882","report_state":"CT","report_number":"0767000483","insp_date":"2026-01-12 00:00:00","insp_start_time":"0524","insp_end_time":"0539","registration_date":null,"region":"ET","ci_status_code":"C","location":"084","location_desc":"MILFORD","county_code_state":"CT","county_code":"009","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CHEESE CAKE","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-01-12 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":"762945","transaction_code":"A","transaction_date":"2026-01-12 00:00:00","upload_date":"2026-01-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00596882","upload_search_indicator":null,"census_search_date":"2026-01-12 21:38:00","snet_input_date":"2026-01-12 00:00:00","source_office":"1CTS001","mcmis_add_date":"2026-01-12 21:38:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-15T10:36:49.000000Z","updated_at":"2026-01-23T10:30:08.000000Z","inspection_violations":[{"id":17858326,"change_date":"2026-01-12 21:38:00","inspection_id":"86760712","insp_violation_id":"271130126","seq_no":"1","part_no":"392","part_no_section":"2-SLLLR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-15T10:42:37.000000Z","updated_at":"2026-01-23T10:30:16.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":17806994,"change_date":"2026-01-12 21:38:00","inspection_id":"86760712","insp_unit_id":"211017602","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRTV","insp_unit_company":null,"insp_unit_license":"2240827","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKBGBDV4FSGN6764","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-15T10:08:19.000000Z","updated_at":"2026-01-24T10:00:26.000000Z"},{"id":17806995,"change_date":"2026-01-12 21:38:00","inspection_id":"86760712","insp_unit_id":"211017603","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"P380278","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA8428FE702077","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-15T10:08:19.000000Z","updated_at":"2026-01-24T10:00:26.000000Z"}]},{"id":10603762,"change_date":"2026-01-09 21:38:00","inspection_id":"86743208","dot_number":"596882","report_state":"CT","report_number":"3070007648","insp_date":"2026-01-09 00:00:00","insp_start_time":"0610","insp_end_time":"0620","registration_date":null,"region":"ET","ci_status_code":"C","location":"138","location_desc":"STRATFORD","county_code_state":"CT","county_code":"001","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"LITTLE PUB","shipping_paper_number":"0792983","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-01-09 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"46800","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":"762806","transaction_code":"A","transaction_date":"2026-01-09 00:00:00","upload_date":"2026-01-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00596882","upload_search_indicator":null,"census_search_date":"2026-01-09 21:38:00","snet_input_date":"2026-01-09 00:00:00","source_office":"1CTS001","mcmis_add_date":"2026-01-09 21:38:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-12T10:34:38.000000Z","updated_at":"2026-01-20T10:30:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17777940,"change_date":"2026-01-09 21:38:00","inspection_id":"86743208","insp_unit_id":"210986348","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"2962637","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HAEVTARXLL284827","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-12T10:11:39.000000Z","updated_at":"2026-01-20T10:00:06.000000Z"}]},{"id":10371977,"change_date":"2025-12-08 21:37:00","inspection_id":"86500870","dot_number":"596882","report_state":"CT","report_number":"0108000070","insp_date":"2025-12-06 00:00:00","insp_start_time":"1238","insp_end_time":"1259","registration_date":null,"region":"ET","ci_status_code":"C","location":"T084","location_desc":"I-91 NORTH, MIDDLETOWN","county_code_state":"CT","county_code":"007","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SYSCO CONNECTICUT LLC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-12-08 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"759864","transaction_code":"A","transaction_date":"2025-12-06 00:00:00","upload_date":"2025-12-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00596882","upload_search_indicator":null,"census_search_date":"2025-12-08 21:37:00","snet_input_date":"2025-12-06 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-12-08 21:37:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-11T10:30:18.000000Z","updated_at":"2025-12-12T10:30:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17336523,"change_date":"2025-12-08 21:37:00","inspection_id":"86500870","insp_unit_id":"210461318","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"149441","insp_unit_license":"3858942","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALACWFD2RDVK7488","insp_unit_decal":"Y","insp_unit_decal_number":"35803812","created_at":"2025-12-11T10:00:23.000000Z","updated_at":"2025-12-12T10:00:05.000000Z"}]},{"id":10212320,"change_date":"2025-11-17 21:38:00","inspection_id":"86333674","dot_number":"596882","report_state":"CT","report_number":"3129006363","insp_date":"2025-11-17 00:00:00","insp_start_time":"1045","insp_end_time":"1108","registration_date":null,"region":"ET","ci_status_code":"C","location":"052","location_desc":"FARMINGTON","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-11-17 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"757923","transaction_code":"A","transaction_date":"2025-11-17 00:00:00","upload_date":"2025-11-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00596882","upload_search_indicator":null,"census_search_date":"2025-11-17 21:38:00","snet_input_date":"2025-11-17 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-11-17 21:38:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-20T10:30:20.000000Z","updated_at":"2025-11-21T10:30:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17011652,"change_date":"2025-11-17 21:38:00","inspection_id":"86333674","insp_unit_id":"210053964","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRTV","insp_unit_company":"145343","insp_unit_license":"3711022","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALACWFD3PDUC4511","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-20T10:00:25.000000Z","updated_at":"2025-11-21T10:00:07.000000Z"}]},{"id":10086671,"change_date":"2026-01-20 21:39:00","inspection_id":"86201491","dot_number":"596882","report_state":"CT","report_number":"3029003424","insp_date":"2025-10-31 00:00:00","insp_start_time":"0555","insp_end_time":"0607","registration_date":"2026-01-16 00:00:00","region":"ET","ci_status_code":"C","location":"080","location_desc":"MERIDEN","county_code_state":"CT","county_code":"009","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SYSCO CONNECTICUT LLC","shipping_paper_number":"S2KOBJOWNER","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.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-10-31 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"74000","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":"756645","transaction_code":"C","transaction_date":"2025-10-31 00:00:00","upload_date":"2026-01-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00596882","upload_search_indicator":null,"census_search_date":"2025-10-31 21:39:00","snet_input_date":"2025-10-31 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-10-31 21:39:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-03T11:04:34.000000Z","updated_at":"2026-01-31T10:30:04.000000Z","inspection_violations":[{"id":18058856,"change_date":"2026-01-20 21:39:00","inspection_id":"86201491","insp_violation_id":"271292351","seq_no":"1","part_no":"392","part_no_section":"2-SLLLR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-23T10:42:07.000000Z","updated_at":"2026-01-31T10:36:38.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":18143165,"change_date":"2026-01-20 21:39:00","inspection_id":"86201491","insp_unit_id":"211166914","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"2987136","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUBGBDV0DLBX0333","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-24T10:08:12.000000Z","updated_at":"2026-01-31T10:02:18.000000Z"},{"id":18143166,"change_date":"2026-01-20 21:39:00","inspection_id":"86201491","insp_unit_id":"211166915","insp_unit_type_id":"10","insp_unit_number":"2","insp_unit_make":"KID","insp_unit_company":"246644","insp_unit_license":"P668369","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"526162818J5000261","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-24T10:08:12.000000Z","updated_at":"2026-01-31T10:02:18.000000Z"}]},{"id":9859428,"change_date":"2025-10-07 21:40:00","inspection_id":"85961762","dot_number":"596882","report_state":"CT","report_number":"3010004597","insp_date":"2025-10-04 00:00:00","insp_start_time":"0533","insp_end_time":"0559","registration_date":"2025-10-07 00:00:00","region":"ET","ci_status_code":"C","location":"033","location_desc":"CROMWELL","county_code_state":"CT","county_code":"007","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SYSCO CONNECTICUT LLC","shipping_paper_number":"TRIP SLIP","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.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-10-06 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"754148","transaction_code":"C","transaction_date":"2025-10-04 00:00:00","upload_date":"2025-10-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00596882","upload_search_indicator":null,"census_search_date":"2025-10-06 21:39:00","snet_input_date":"2025-10-04 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-10-06 21:39:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-09T10:00:24.000000Z","updated_at":"2025-10-11T10:00:16.000000Z","inspection_violations":[{"id":16271083,"change_date":"2025-10-07 21:40:00","inspection_id":"85961762","insp_violation_id":"269136051","seq_no":"1","part_no":"392","part_no_section":"2-DMOVE","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-10-10T10:18:17.000000Z","updated_at":"2025-10-11T10:15:38.000000Z","normalized_code":"3922DMOVE"}],"inspection_per_units":[{"id":16377495,"change_date":"2025-10-07 21:40:00","inspection_id":"85961762","insp_unit_id":"209331626","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"137085","insp_unit_license":"2561187","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HAMSTAR0JL715368","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-10T09:47:40.000000Z","updated_at":"2025-10-11T09:45:22.000000Z"}]},{"id":9859472,"change_date":"2025-10-16 21:39:00","inspection_id":"85961808","dot_number":"596882","report_state":"CT","report_number":"3129006247","insp_date":"2025-10-03 00:00:00","insp_start_time":"1800","insp_end_time":"1840","registration_date":"2025-10-16 00:00:00","region":"ET","ci_status_code":"C","location":"083S","location_desc":"MIDDLETOWN SCALE","county_code_state":"CT","county_code":"007","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-06 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"754132","transaction_code":"C","transaction_date":"2025-10-03 00:00:00","upload_date":"2025-10-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00596882","upload_search_indicator":null,"census_search_date":"2025-10-06 21:39:00","snet_input_date":"2025-10-03 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-10-06 21:39:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-09T10:00:24.000000Z","updated_at":"2025-10-20T10:00:05.000000Z","inspection_violations":[{"id":16436399,"change_date":"2025-10-16 21:39:00","inspection_id":"85961808","insp_violation_id":"269327766","seq_no":"1","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-19T10:17:21.000000Z","updated_at":"2025-10-20T10:15:10.000000Z","normalized_code":"3922SLL"}],"inspection_per_units":[{"id":16525147,"change_date":"2025-10-16 21:39:00","inspection_id":"85961808","insp_unit_id":"209493745","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRTV","insp_unit_company":"145343","insp_unit_license":"3711022","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALACWFD3PDUC4511","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-19T09:46:41.000000Z","updated_at":"2025-10-20T09:45:08.000000Z"}]},{"id":9678563,"change_date":"2025-09-15 21:39:00","inspection_id":"85772035","dot_number":"596882","report_state":"CT","report_number":"3129006169","insp_date":"2025-09-13 00:00:00","insp_start_time":"0644","insp_end_time":"0700","registration_date":null,"region":"ET","ci_status_code":"C","location":"119","location_desc":"ROCKY HILL","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"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-09-15 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"67000","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":"751970","transaction_code":"A","transaction_date":"2025-09-13 00:00:00","upload_date":"2025-09-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00596882","upload_search_indicator":null,"census_search_date":"2025-09-15 21:39:00","snet_input_date":"2025-09-13 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-09-15 21:39:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-18T10:00:16.000000Z","updated_at":"2025-09-18T10:00:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16017093,"change_date":"2025-09-15 21:39:00","inspection_id":"85772035","insp_unit_id":"208945038","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MCK","insp_unit_company":"137102","insp_unit_license":"2561174","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AW01Y7JM010946","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-18T09:45:23.000000Z","updated_at":"2025-09-18T09:45:23.000000Z"}]},{"id":9564512,"change_date":"2025-09-04 21:40:00","inspection_id":"85652899","dot_number":"596882","report_state":"MA","report_number":"CX00001585","insp_date":"2025-09-01 00:00:00","insp_start_time":"0633","insp_end_time":"0648","registration_date":"2025-09-04 00:00:00","region":"ET","ci_status_code":"C","location":"205H","location_desc":"H-MILLBURY","county_code_state":"MA","county_code":"027","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"0780705","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-02 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"99700","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":"527226","transaction_code":"C","transaction_date":"2025-09-02 00:00:00","upload_date":"2025-09-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00596882","upload_search_indicator":"M","census_search_date":"2025-09-02 21:39:00","snet_input_date":"2025-09-01 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-09-02 21:39:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-06T10:43:00.000000Z","updated_at":"2025-09-10T10:45:19.000000Z","inspection_violations":[{"id":15665399,"change_date":"2025-09-04 21:40:00","inspection_id":"85652899","insp_violation_id":"268460894","seq_no":"1","part_no":"392","part_no_section":"8-D","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-09T10:42:43.000000Z","updated_at":"2025-09-10T10:46:33.000000Z","normalized_code":"3928D"},{"id":15665400,"change_date":"2025-09-04 21:40:00","inspection_id":"85652899","insp_violation_id":"268460895","seq_no":"2","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-09T10:42:43.000000Z","updated_at":"2025-09-10T10:46:33.000000Z","normalized_code":"3922SLL"}],"inspection_per_units":[{"id":15828879,"change_date":"2025-09-04 21:40:00","inspection_id":"85652899","insp_unit_id":"208747992","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"136512","insp_unit_license":"2488705","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUBC5DV9JHJM2698","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:47:41.000000Z","updated_at":"2025-09-10T09:45:08.000000Z"},{"id":15828880,"change_date":"2025-09-04 21:40:00","inspection_id":"85652899","insp_unit_id":"208747993","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KID","insp_unit_company":"229622","insp_unit_license":"PB84414","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"526173820D5000819","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:47:41.000000Z","updated_at":"2025-09-10T09:45:08.000000Z"}]},{"id":9503922,"change_date":"2025-08-26 21:39:00","inspection_id":"85588841","dot_number":"596882","report_state":"CT","report_number":"3031A00627","insp_date":"2025-08-26 00:00:00","insp_start_time":"1141","insp_end_time":"1209","registration_date":null,"region":"ET","ci_status_code":"C","location":"083S","location_desc":"MIDDLETOWN SCALE","county_code_state":"CT","county_code":"007","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SYSCO","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-08-26 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"750164","transaction_code":"A","transaction_date":"2025-08-26 00:00:00","upload_date":"2025-08-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00596882","upload_search_indicator":null,"census_search_date":"2025-08-26 21:39:00","snet_input_date":"2025-08-26 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-08-26 21:39:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-29T10:42:49.000000Z","updated_at":"2025-09-05T10:45:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15681042,"change_date":"2025-08-26 21:39:00","inspection_id":"85588841","insp_unit_id":"208577510","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRTV","insp_unit_company":"145867","insp_unit_license":"2028312","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALACWFD5PDUC4638","insp_unit_decal":"Y","insp_unit_decal_number":"35535230","created_at":"2025-08-29T09:46:33.000000Z","updated_at":"2025-09-05T09:45:08.000000Z"}]},{"id":9407296,"change_date":"2025-08-20 21:39:00","inspection_id":"85487027","dot_number":"596882","report_state":"CT","report_number":"3025005725","insp_date":"2025-08-13 00:00:00","insp_start_time":"1524","insp_end_time":"1641","registration_date":"2025-08-20 00:00:00","region":"ET","ci_status_code":"C","location":"151","location_desc":"WATERBURY","county_code_state":"CT","county_code":"009","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"BRIANS FABULOUS FRY BREADS\/BRI CINS INC","shipping_paper_number":"3430","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.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-08-14 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"74700","viol_total":"3","oos_total":"1","driver_viol_total":"3","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"748933","transaction_code":"C","transaction_date":"2025-08-13 00:00:00","upload_date":"2025-08-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00596882","upload_search_indicator":null,"census_search_date":"2025-08-14 21:39:00","snet_input_date":"2025-08-13 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-08-14 21:39:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-17T10:01:06.000000Z","updated_at":"2025-08-25T10:41:23.000000Z","inspection_violations":[{"id":15398370,"change_date":"2025-08-20 21:39:00","inspection_id":"85487027","insp_violation_id":"268128128","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":"V135433-6","created_at":"2025-08-23T10:48:54.000000Z","updated_at":"2025-08-24T10:46:39.000000Z","normalized_code":"3922SLLS3"},{"id":15398371,"change_date":"2025-08-20 21:39:00","inspection_id":"85487027","insp_violation_id":"268128129","seq_no":"2","part_no":"383","part_no_section":"71H","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-23T10:48:54.000000Z","updated_at":"2025-08-24T10:46:39.000000Z","normalized_code":"38371H"},{"id":15398372,"change_date":"2025-08-20 21:39:00","inspection_id":"85487027","insp_violation_id":"268128130","seq_no":"3","part_no":"383","part_no_section":"23A2-LCDLN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-23T10:48:54.000000Z","updated_at":"2025-08-24T10:46:39.000000Z","normalized_code":"38323A2LCDLN"}],"inspection_per_units":[{"id":15590442,"change_date":"2025-08-20 21:39:00","inspection_id":"85487027","insp_unit_id":"208479620","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"140719","insp_unit_license":"2802380","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN2AY4LM001932","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-23T09:46:33.000000Z","updated_at":"2025-08-24T09:45:08.000000Z"},{"id":15590443,"change_date":"2025-08-20 21:39:00","inspection_id":"85487027","insp_unit_id":"208479621","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"257053","insp_unit_license":"PG65563","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V281K9SJ517820","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-23T09:46:33.000000Z","updated_at":"2025-08-24T09:45:08.000000Z"}]},{"id":9170031,"change_date":"2026-01-13 21:38:00","inspection_id":"85237512","dot_number":"596882","report_state":"CT","report_number":"3077A00508","insp_date":"2025-07-17 00:00:00","insp_start_time":"1558","insp_end_time":"1614","registration_date":"2026-01-13 00:00:00","region":"ET","ci_status_code":"C","location":"093","location_desc":"NEW HAVEN","county_code_state":"CT","county_code":"009","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SYSCO CONNECTICUT LLC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"746385","transaction_code":"C","transaction_date":"2025-07-17 00:00:00","upload_date":"2026-01-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00596882","upload_search_indicator":null,"census_search_date":"2025-07-17 21:41:00","snet_input_date":"2025-07-17 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-07-17 21:41:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"CT","created_at":"2025-07-21T10:43:03.000000Z","updated_at":"2026-01-24T10:30:04.000000Z","inspection_violations":[{"id":17878199,"change_date":"2026-01-13 21:38:00","inspection_id":"85237512","insp_violation_id":"271154889","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":"V134984-5","created_at":"2026-01-16T10:41:39.000000Z","updated_at":"2026-01-24T10:30:05.000000Z","normalized_code":"3922SLLS3"}],"inspection_per_units":[{"id":17827399,"change_date":"2026-01-13 21:38:00","inspection_id":"85237512","insp_unit_id":"211041081","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"145867","insp_unit_license":"2028312","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALACWFD5PDUC4638","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-16T10:08:31.000000Z","updated_at":"2026-01-24T10:01:30.000000Z"}]},{"id":9044698,"change_date":"2025-07-02 21:39:00","inspection_id":"85105584","dot_number":"596882","report_state":"CT","report_number":"3132005673","insp_date":"2025-07-02 00:00:00","insp_start_time":"1312","insp_end_time":"1322","registration_date":null,"region":"ET","ci_status_code":"C","location":"064","location_desc":"HARTFORD","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-02 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"67000","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":"744714","transaction_code":"A","transaction_date":"2025-07-02 00:00:00","upload_date":"2025-07-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00596882","upload_search_indicator":null,"census_search_date":"2025-07-02 21:39:00","snet_input_date":"2025-07-02 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-07-02 21:39:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-07T10:07:10.000000Z","updated_at":"2025-07-07T10:07:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14837425,"change_date":"2025-07-02 21:39:00","inspection_id":"85105584","insp_unit_id":"207666311","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"2561132","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AW01YXJM010875","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-05T09:46:02.000000Z","updated_at":"2025-07-06T09:45:05.000000Z"},{"id":14837426,"change_date":"2025-07-02 21:39:00","inspection_id":"85105584","insp_unit_id":"207666312","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":null,"insp_unit_license":"PG65365","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V422K5SJ519425","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-05T09:46:02.000000Z","updated_at":"2025-07-06T09:45:05.000000Z"}]},{"id":9054946,"change_date":"2025-07-03 21:33:00","inspection_id":"85105559","dot_number":"596882","report_state":"CT","report_number":"3077A00496","insp_date":"2025-07-02 00:00:00","insp_start_time":"1641","insp_end_time":"1710","registration_date":"2025-07-03 00:00:00","region":"ET","ci_status_code":"C","location":"093","location_desc":"NEW HAVEN","county_code_state":"CT","county_code":"009","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SYSCO CONNECTICUT LLC","shipping_paper_number":"454939097","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.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-07-02 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"744731","transaction_code":"C","transaction_date":"2025-07-02 00:00:00","upload_date":"2025-07-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00596882","upload_search_indicator":null,"census_search_date":"2025-07-02 21:39:00","snet_input_date":"2025-07-02 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-07-02 21:39:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-07T10:07:30.000000Z","updated_at":"2025-07-07T10:07:30.000000Z","inspection_violations":[{"id":14570415,"change_date":"2025-07-03 21:33:00","inspection_id":"85105559","insp_violation_id":"267186158","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":"V134644-1","created_at":"2025-07-06T10:16:45.000000Z","updated_at":"2025-07-07T10:15:11.000000Z","normalized_code":"3922SLLS3"}],"inspection_per_units":[{"id":14856706,"change_date":"2025-07-03 21:33:00","inspection_id":"85105559","insp_unit_id":"207686552","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRTV","insp_unit_company":"145867","insp_unit_license":"2028312","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALACWFD5PDUC4638","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-06T09:46:16.000000Z","updated_at":"2025-07-07T09:45:07.000000Z"}]},{"id":9388426,"change_date":"2025-08-12 21:39:00","inspection_id":"85467292","dot_number":"596882","report_state":"MA","report_number":"LP21000032","insp_date":"2025-06-25 00:00:00","insp_start_time":"1501","insp_end_time":"1529","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"WORCESTER MA","county_code_state":"MA","county_code":"027","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-08-12 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"102700","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2119335","transaction_code":"A","transaction_date":"2025-08-12 00:00:00","upload_date":"2025-08-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00596882","upload_search_indicator":null,"census_search_date":"2025-08-12 21:39:00","snet_input_date":"2025-06-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-12 21:39:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-15T10:43:42.000000Z","updated_at":"2025-08-16T10:00:30.000000Z","inspection_violations":[{"id":15260864,"change_date":"2025-08-12 21:39:00","inspection_id":"85467292","insp_violation_id":"267972057","seq_no":"1","part_no":"393","part_no_section":"75A2-TAOTLM","insp_viol_unit":"2","insp_unit_id":"208350389","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-08-15T10:45:40.000000Z","updated_at":"2025-08-16T10:43:32.000000Z","normalized_code":"39375A2TAOTLM"}],"inspection_per_units":[{"id":15470380,"change_date":"2025-08-12 21:39:00","inspection_id":"85467292","insp_unit_id":"208350388","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"134000","insp_unit_license":"2240827","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKBGBDV4FSGN6764","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-15T09:46:19.000000Z","updated_at":"2025-08-16T09:45:38.000000Z"},{"id":15470381,"change_date":"2025-08-12 21:39:00","inspection_id":"85467292","insp_unit_id":"208350389","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HACKNEY &","insp_unit_company":"247567","insp_unit_license":"P744773","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"526164225J5001221","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-15T09:46:19.000000Z","updated_at":"2025-08-16T09:45:38.000000Z"}]},{"id":8905802,"change_date":"2025-06-16 21:38:00","inspection_id":"84959015","dot_number":"596882","report_state":"CT","report_number":"3129005899","insp_date":"2025-06-14 00:00:00","insp_start_time":"0530","insp_end_time":"0546","registration_date":null,"region":"ET","ci_status_code":"C","location":"119","location_desc":"ROCKY HILL","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-16 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"743135","transaction_code":"A","transaction_date":"2025-06-14 00:00:00","upload_date":"2025-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00596882","upload_search_indicator":null,"census_search_date":"2025-06-16 21:38:00","snet_input_date":"2025-06-14 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-06-16 21:38:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-19T10:00:14.000000Z","updated_at":"2025-06-20T10:00:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14590519,"change_date":"2025-06-16 21:38:00","inspection_id":"84959015","insp_unit_id":"207398770","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRTV","insp_unit_company":"145867","insp_unit_license":"2028312","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALACWFD5PDUC4638","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-19T09:45:16.000000Z","updated_at":"2025-06-20T09:45:05.000000Z"}]},{"id":8865992,"change_date":"2025-06-11 21:41:00","inspection_id":"84916605","dot_number":"596882","report_state":"CT","report_number":"3097008517","insp_date":"2025-06-11 00:00:00","insp_start_time":"0711","insp_end_time":"0733","registration_date":null,"region":"ET","ci_status_code":"C","location":"152SN","location_desc":"WATERFORD SCALE N\/B","county_code_state":"CT","county_code":"011","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SYSCO","shipping_paper_number":"454911664","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"742653","transaction_code":"A","transaction_date":"2025-06-11 00:00:00","upload_date":"2025-06-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00596882","upload_search_indicator":null,"census_search_date":"2025-06-11 21:41:00","snet_input_date":"2025-06-11 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-06-11 21:41:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-14T10:00:52.000000Z","updated_at":"2025-06-15T10:00:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14520291,"change_date":"2025-06-11 21:41:00","inspection_id":"84916605","insp_unit_id":"207320038","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"149443","insp_unit_license":"2987538","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALACWFD0RDVK7490","insp_unit_decal":"Y","insp_unit_decal_number":"35261521","created_at":"2025-06-14T09:46:03.000000Z","updated_at":"2025-06-15T09:45:08.000000Z"}]},{"id":8820394,"change_date":"2025-06-13 21:39:00","inspection_id":"84868211","dot_number":"596882","report_state":"CT","report_number":"3132005617","insp_date":"2025-06-05 00:00:00","insp_start_time":"1338","insp_end_time":"1348","registration_date":"2025-06-13 00:00:00","region":"ET","ci_status_code":"C","location":"064","location_desc":"HARTFORD","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SYSCO CONNECTICUT LLC","shipping_paper_number":"454905016","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.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-06-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"67000","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":"742232","transaction_code":"C","transaction_date":"2025-06-05 00:00:00","upload_date":"2025-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00596882","upload_search_indicator":null,"census_search_date":"2025-06-05 21:40:00","snet_input_date":"2025-06-05 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-06-05 21:40:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-09T10:00:54.000000Z","updated_at":"2025-06-17T10:00:04.000000Z","inspection_violations":[{"id":14248049,"change_date":"2025-06-13 21:39:00","inspection_id":"84868211","insp_violation_id":"266822136","seq_no":"1","part_no":"392","part_no_section":"16-D","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-06-17T10:17:26.000000Z","updated_at":"2025-06-17T10:19:56.000000Z","normalized_code":"39216D"}],"inspection_per_units":[{"id":14562294,"change_date":"2025-06-13 21:39:00","inspection_id":"84868211","insp_unit_id":"207367463","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"2240827","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKBGBDV4FSGN6764","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-16T09:46:33.000000Z","updated_at":"2025-06-17T09:45:03.000000Z"},{"id":14562295,"change_date":"2025-06-13 21:39:00","inspection_id":"84868211","insp_unit_id":"207367464","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":null,"insp_unit_license":"PG65365","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V422K5SJ519425","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-16T09:46:33.000000Z","updated_at":"2025-06-17T09:45:03.000000Z"}]},{"id":8718784,"change_date":"2025-05-23 21:38:00","inspection_id":"84760608","dot_number":"596882","report_state":"CT","report_number":"3081A00056","insp_date":"2025-05-23 00:00:00","insp_start_time":"0613","insp_end_time":"0719","registration_date":null,"region":"ET","ci_status_code":"C","location":"084","location_desc":"MILFORD SERVICE PLAZA  I-95 SB","county_code_state":"CT","county_code":"009","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SYSCO FOODS","shipping_paper_number":"0771164","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.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-05-23 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"99700","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"741118","transaction_code":"A","transaction_date":"2025-05-23 00:00:00","upload_date":"2025-05-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00596882","upload_search_indicator":null,"census_search_date":"2025-05-23 21:38:00","snet_input_date":"2025-05-23 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-05-23 21:38:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-26T10:03:34.000000Z","updated_at":"2025-05-27T10:01:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14251699,"change_date":"2025-05-23 21:38:00","inspection_id":"84760608","insp_unit_id":"207029571","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRTV","insp_unit_company":"134832","insp_unit_license":"2241332","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUBGBDV4GLHB3358","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-26T09:49:25.000000Z","updated_at":"2025-05-27T09:48:29.000000Z"},{"id":14251700,"change_date":"2025-05-23 21:38:00","inspection_id":"84760608","insp_unit_id":"207029572","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HACK","insp_unit_company":"247566","insp_unit_license":"P744772","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"526164223J5001220","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-26T09:49:25.000000Z","updated_at":"2025-05-27T09:48:29.000000Z"}]},{"id":8206659,"change_date":"2025-03-26 21:40:00","inspection_id":"84221809","dot_number":"596882","report_state":"CT","report_number":"0613001401","insp_date":"2025-03-25 00:00:00","insp_start_time":"1923","insp_end_time":"1945","registration_date":"2025-03-26 00:00:00","region":"ET","ci_status_code":"C","location":"083","location_desc":"MIDDLETOWN SCALE","county_code_state":"CT","county_code":"003","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"98700","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"735860","transaction_code":"A","transaction_date":"2025-03-25 00:00:00","upload_date":"2025-03-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00596882","upload_search_indicator":null,"census_search_date":"2025-03-26 21:40:00","snet_input_date":"2025-03-25 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-03-26 21:40:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-29T10:20:49.000000Z","updated_at":"2025-03-30T10:34:11.000000Z","inspection_violations":[{"id":12871614,"change_date":"2025-03-26 21:40:00","inspection_id":"84221809","insp_violation_id":"265245708","seq_no":"1","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"205982753","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-28T10:52:13.000000Z","updated_at":"2025-03-29T10:30:37.000000Z","normalized_code":"3939ALHLI"},{"id":12871615,"change_date":"2025-03-26 21:40:00","inspection_id":"84221809","insp_violation_id":"265245709","seq_no":"2","part_no":"383","part_no_section":"23A2-LCDLN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-28T10:52:13.000000Z","updated_at":"2025-03-29T10:30:37.000000Z","normalized_code":"38323A2LCDLN"}],"inspection_per_units":[{"id":13270371,"change_date":"2025-03-26 21:40:00","inspection_id":"84221809","insp_unit_id":"205982753","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"2342048","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUBGBDV7HLHH9419","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-29T10:02:02.000000Z","updated_at":"2025-03-30T09:55:23.000000Z"},{"id":13270372,"change_date":"2025-03-26 21:40:00","inspection_id":"84221809","insp_unit_id":"205982754","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":null,"insp_unit_license":"PF55344","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V422K5SJ423004","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-29T10:02:02.000000Z","updated_at":"2025-03-30T09:55:23.000000Z"}]},{"id":7742292,"change_date":"2025-01-31 21:39:00","inspection_id":"83733005","dot_number":"596882","report_state":"CT","report_number":"3029002827","insp_date":"2025-01-30 00:00:00","insp_start_time":"0542","insp_end_time":"0549","registration_date":"2025-01-31 00:00:00","region":"ET","ci_status_code":"C","location":"138","location_desc":"STRATFORD","county_code_state":"CT","county_code":"001","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SYSCO CONNECTICUT LLC","shipping_paper_number":"0760584","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.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-01-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"67000","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":"731175","transaction_code":"C","transaction_date":"2025-01-30 00:00:00","upload_date":"2025-01-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00596882","upload_search_indicator":null,"census_search_date":"2025-01-30 21:40:00","snet_input_date":"2025-01-30 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-01-30 21:40:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:59:06.000000Z","updated_at":"2025-03-17T20:59:06.000000Z","inspection_violations":[{"id":12097182,"change_date":"2025-01-31 21:39:00","inspection_id":"83733005","insp_violation_id":"264267196","seq_no":"1","part_no":"392","part_no_section":"2-SLLLR","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:04:59.000000Z","updated_at":"2025-03-17T22:04:59.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":12494135,"change_date":"2025-01-31 21:39:00","inspection_id":"83733005","insp_unit_id":"205091423","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRTV","insp_unit_company":null,"insp_unit_license":"2987136","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUBGBDV0DLBX0333","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:51.000000Z","updated_at":"2025-03-17T23:52:51.000000Z"},{"id":12494136,"change_date":"2025-01-31 21:39:00","inspection_id":"83733005","insp_unit_id":"205091424","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KID","insp_unit_company":"252023","insp_unit_license":"P962617","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"526162812L5000663","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:51.000000Z","updated_at":"2025-03-17T23:52:51.000000Z"}]},{"id":7711656,"change_date":"2025-01-28 21:38:00","inspection_id":"83700951","dot_number":"596882","report_state":"CT","report_number":"3070006712","insp_date":"2025-01-27 00:00:00","insp_start_time":"1336","insp_end_time":"1346","registration_date":"2025-01-28 00:00:00","region":"ET","ci_status_code":"C","location":"025","location_desc":"CHESHIRE","county_code_state":"CT","county_code":"009","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"0760242","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.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-01-27 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"67000","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":"730826","transaction_code":"C","transaction_date":"2025-01-27 00:00:00","upload_date":"2025-01-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00596882","upload_search_indicator":null,"census_search_date":"2025-01-27 21:39:00","snet_input_date":"2025-01-27 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-01-27 21:39:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:58:18.000000Z","updated_at":"2025-03-17T20:58:18.000000Z","inspection_violations":[{"id":12048587,"change_date":"2025-01-28 21:38:00","inspection_id":"83700951","insp_violation_id":"264203593","seq_no":"1","part_no":"392","part_no_section":"2-SLLLR","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:04:45.000000Z","updated_at":"2025-03-17T22:04:45.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":12444524,"change_date":"2025-01-28 21:38:00","inspection_id":"83700951","insp_unit_id":"205032383","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRTV","insp_unit_company":null,"insp_unit_license":"2488442","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUBC5DV1HHJC7358","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:18.000000Z","updated_at":"2025-03-17T23:52:18.000000Z"},{"id":12444525,"change_date":"2025-01-28 21:38:00","inspection_id":"83700951","insp_unit_id":"205032384","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"PB84635","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA5614FE702063","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:18.000000Z","updated_at":"2025-03-17T23:52:18.000000Z"}]},{"id":7422148,"change_date":"2024-12-16 21:39:00","inspection_id":"83396990","dot_number":"596882","report_state":"CT","report_number":"3129005376","insp_date":"2024-12-14 00:00:00","insp_start_time":"0630","insp_end_time":"0655","registration_date":null,"region":"ET","ci_status_code":"C","location":"119","location_desc":"ROCKY HILL","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"001","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-12-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"726619","transaction_code":"A","transaction_date":"2024-12-14 00:00:00","upload_date":"2024-12-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00596882","upload_search_indicator":null,"census_search_date":"2024-12-16 21:39:00","snet_input_date":"2024-12-14 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-12-16 21:39:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:51:06.000000Z","updated_at":"2025-03-17T20:51:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11974196,"change_date":"2024-12-16 21:39:00","inspection_id":"83396990","insp_unit_id":"204395342","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRTV","insp_unit_company":"145343","insp_unit_license":"3711022","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALACWFD3PDUC4511","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:47:11.000000Z","updated_at":"2025-03-17T23:47:11.000000Z"}]},{"id":7365099,"change_date":"2024-12-12 21:40:00","inspection_id":"83337143","dot_number":"596882","report_state":"CT","report_number":"3129005343","insp_date":"2024-12-07 00:00:00","insp_start_time":"0526","insp_end_time":"0600","registration_date":"2024-12-12 00:00:00","region":"ET","ci_status_code":"C","location":"119","location_desc":"ROCKY HILL","county_code_state":"CT","county_code":"003","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"001","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-12-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"46800","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"725919","transaction_code":"C","transaction_date":"2024-12-07 00:00:00","upload_date":"2024-12-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00596882","upload_search_indicator":null,"census_search_date":"2024-12-09 21:40:00","snet_input_date":"2024-12-07 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-12-09 21:40:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:49:47.000000Z","updated_at":"2025-03-17T20:49:47.000000Z","inspection_violations":[{"id":11508983,"change_date":"2024-12-12 21:40:00","inspection_id":"83337143","insp_violation_id":"263407645","seq_no":"1","part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"1","insp_unit_id":"204334941","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T22:02:01.000000Z","updated_at":"2025-03-17T22:02:01.000000Z","normalized_code":"3939ALRLI"}],"inspection_per_units":[{"id":11881130,"change_date":"2024-12-12 21:40:00","inspection_id":"83337143","insp_unit_id":"204334941","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"2962638","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HAEVTAR1LL284828","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:13.000000Z","updated_at":"2025-03-17T23:46:13.000000Z"}]},{"id":7212908,"change_date":"2024-11-18 21:40:00","inspection_id":"83176496","dot_number":"596882","report_state":"CT","report_number":"3132005066","insp_date":"2024-11-18 00:00:00","insp_start_time":"1420","insp_end_time":"1437","registration_date":null,"region":"ET","ci_status_code":"C","location":"064","location_desc":"HARTFORD","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-11-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"119270","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":"723960","transaction_code":"A","transaction_date":"2024-11-18 00:00:00","upload_date":"2024-11-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00596882","upload_search_indicator":null,"census_search_date":"2024-11-18 21:40:00","snet_input_date":"2024-11-18 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-11-18 21:40:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:46:28.000000Z","updated_at":"2025-03-17T20:46:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11634434,"change_date":"2024-11-18 21:40:00","inspection_id":"83176496","insp_unit_id":"203919522","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"2802379","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN2AY6LM001933","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:33.000000Z","updated_at":"2025-03-17T23:43:33.000000Z"},{"id":11634435,"change_date":"2024-11-18 21:40:00","inspection_id":"83176496","insp_unit_id":"203919523","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNK","insp_unit_company":null,"insp_unit_license":"PF74013","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"527SR4229SL044156","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:33.000000Z","updated_at":"2025-03-17T23:43:33.000000Z"}]},{"id":6762596,"change_date":"2024-09-25 21:40:00","inspection_id":"82698143","dot_number":"596882","report_state":"CT","report_number":"3010003626","insp_date":"2024-09-19 00:00:00","insp_start_time":"0536","insp_end_time":"0605","registration_date":"2024-09-24 00:00:00","region":"ET","ci_status_code":"C","location":"033","location_desc":"CROMWELL","county_code_state":"CT","county_code":"007","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"64800","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":"718441","transaction_code":"C","transaction_date":"2024-09-19 00:00:00","upload_date":"2024-09-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00596882","upload_search_indicator":null,"census_search_date":"2024-09-19 21:41:00","snet_input_date":"2024-09-19 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-09-19 21:41:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:37:18.000000Z","updated_at":"2025-03-17T20:37:18.000000Z","inspection_violations":[{"id":10531187,"change_date":"2024-09-25 21:40:00","inspection_id":"82698143","insp_violation_id":"262016849","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"203115087","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:00.000000Z","updated_at":"2025-03-17T21:57:00.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10904930,"change_date":"2024-09-25 21:40:00","inspection_id":"82698143","insp_unit_id":"203115086","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"146027","insp_unit_license":"3481112","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKBHTDVXPDUP1866","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:56.000000Z","updated_at":"2025-03-17T23:35:56.000000Z"},{"id":10904931,"change_date":"2024-09-25 21:40:00","inspection_id":"82698143","insp_unit_id":"203115087","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HACK","insp_unit_company":"246646","insp_unit_license":"P668371","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"526164225J5000263","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:56.000000Z","updated_at":"2025-03-17T23:35:56.000000Z"}]},{"id":6650609,"change_date":"2024-09-11 21:40:00","inspection_id":"82579058","dot_number":"596882","report_state":"CT","report_number":"1162002480","insp_date":"2024-09-04 00:00:00","insp_start_time":"1833","insp_end_time":"1845","registration_date":"2024-09-11 00:00:00","region":"ET","ci_status_code":"C","location":"083S","location_desc":"MIDDLETOWN SCALE","county_code_state":"CT","county_code":"007","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-05 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"717131","transaction_code":"C","transaction_date":"2024-09-04 00:00:00","upload_date":"2024-09-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00596882","upload_search_indicator":null,"census_search_date":"2024-09-05 21:42:00","snet_input_date":"2024-09-04 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-09-05 21:42:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:34:51.000000Z","updated_at":"2025-03-17T20:34:51.000000Z","inspection_violations":[{"id":10348952,"change_date":"2024-09-11 21:40:00","inspection_id":"82579058","insp_violation_id":"261727641","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:08.000000Z","updated_at":"2025-03-17T21:56:08.000000Z","normalized_code":"3922"},{"id":10348953,"change_date":"2024-09-11 21:40:00","inspection_id":"82579058","insp_violation_id":"261727642","seq_no":"2","part_no":"391","part_no_section":"41(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:08.000000Z","updated_at":"2025-03-17T21:56:08.000000Z","normalized_code":"39141A1"}],"inspection_per_units":[{"id":10722602,"change_date":"2024-09-11 21:40:00","inspection_id":"82579058","insp_unit_id":"202857712","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"2962547","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HAEUMMM3LL284595","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:02.000000Z","updated_at":"2025-03-17T23:34:02.000000Z"}]},{"id":6622828,"change_date":"2024-09-17 21:43:00","inspection_id":"82549543","dot_number":"596882","report_state":"CT","report_number":"0767000233","insp_date":"2024-09-03 00:00:00","insp_start_time":"1457","insp_end_time":"1516","registration_date":"2024-09-17 00:00:00","region":"ET","ci_status_code":"C","location":"015","location_desc":"BRIDGEPORT","county_code_state":"CT","county_code":"001","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"91000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"716929","transaction_code":"C","transaction_date":"2024-09-03 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00596882","upload_search_indicator":null,"census_search_date":"2024-09-03 21:40:00","snet_input_date":"2024-09-03 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-09-03 21:40:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:34:25.000000Z","updated_at":"2025-03-17T20:34:25.000000Z","inspection_violations":[{"id":10300105,"change_date":"2024-09-17 21:43:00","inspection_id":"82549543","insp_violation_id":"261838892","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:56.000000Z","updated_at":"2025-03-17T21:55:56.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10677808,"change_date":"2024-09-17 21:43:00","inspection_id":"82549543","insp_unit_id":"202956013","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"2987458","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HSDXTZN7NN268515","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:34.000000Z","updated_at":"2025-03-17T23:33:34.000000Z"},{"id":10677809,"change_date":"2024-09-17 21:43:00","inspection_id":"82549543","insp_unit_id":"202956014","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"PB84635","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA5614FE702063","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:34.000000Z","updated_at":"2025-03-17T23:33:34.000000Z"}]},{"id":6054099,"change_date":"2024-06-26 21:42:00","inspection_id":"81940822","dot_number":"596882","report_state":"CT","report_number":"3014004215","insp_date":"2024-06-22 00:00:00","insp_start_time":"0838","insp_end_time":"0852","registration_date":"2024-06-26 00:00:00","region":"ET","ci_status_code":"C","location":"151","location_desc":"WATERBURY","county_code_state":"CT","county_code":"009","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"0740966","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"710730","transaction_code":"C","transaction_date":"2024-06-22 00:00:00","upload_date":"2024-06-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00596882","upload_search_indicator":null,"census_search_date":"2024-06-24 21:41:00","snet_input_date":"2024-06-22 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-06-24 21:41:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:22:38.000000Z","updated_at":"2025-03-17T20:22:38.000000Z","inspection_violations":[{"id":9390733,"change_date":"2024-06-26 21:42:00","inspection_id":"81940822","insp_violation_id":"260312057","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:25.000000Z","updated_at":"2025-03-17T21:51:25.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9751066,"change_date":"2024-06-26 21:42:00","inspection_id":"81940822","insp_unit_id":"201591807","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"145867","insp_unit_license":"2028312","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"JALE5W163D7302102","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:02.000000Z","updated_at":"2025-03-17T23:24:02.000000Z"}]},{"id":5761152,"change_date":"2024-05-23 21:40:00","inspection_id":"81623146","dot_number":"596882","report_state":"CT","report_number":"3087002795","insp_date":"2024-05-15 00:00:00","insp_start_time":"1830","insp_end_time":"1915","registration_date":"2024-05-22 00:00:00","region":"ET","ci_status_code":"C","location":"083S","location_desc":"MIDDLETOWN SCALE","county_code_state":"CT","county_code":"007","insp_level_id":"1","service_center":"EA","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":"N","pen_cen_match":null,"final_status_date":"2024-05-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"707695","transaction_code":"C","transaction_date":"2024-05-15 00:00:00","upload_date":"2024-05-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00596882","upload_search_indicator":null,"census_search_date":"2024-05-16 21:40:00","snet_input_date":"2024-05-15 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-05-16 21:40:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:17:03.000000Z","updated_at":"2025-03-17T20:17:03.000000Z","inspection_violations":[{"id":8917242,"change_date":"2024-05-23 21:40:00","inspection_id":"81623146","insp_violation_id":"259682868","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"201045293","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:07.000000Z","updated_at":"2025-03-17T21:49:07.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":9279268,"change_date":"2024-05-23 21:40:00","inspection_id":"81623146","insp_unit_id":"201045292","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRTV","insp_unit_company":"135526","insp_unit_license":"2341929","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUBGBDV3GLHE4374","insp_unit_decal":"Y","insp_unit_decal_number":"34062996","created_at":"2025-03-17T23:19:21.000000Z","updated_at":"2025-03-17T23:19:21.000000Z"},{"id":9279269,"change_date":"2024-05-23 21:40:00","inspection_id":"81623146","insp_unit_id":"201045293","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"229293","insp_unit_license":"PD71410","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA7626DB710362","insp_unit_decal":"Y","insp_unit_decal_number":"34063000","created_at":"2025-03-17T23:19:21.000000Z","updated_at":"2025-03-17T23:19:21.000000Z"}]},{"id":5735678,"change_date":"2024-05-14 21:40:00","inspection_id":"81595520","dot_number":"596882","report_state":"CT","report_number":"3132004561","insp_date":"2024-05-13 00:00:00","insp_start_time":"1308","insp_end_time":"1320","registration_date":null,"region":"ET","ci_status_code":"C","location":"155","location_desc":"WEST HARTFORD","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"707420","transaction_code":"A","transaction_date":"2024-05-13 00:00:00","upload_date":"2024-05-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00596882","upload_search_indicator":null,"census_search_date":"2024-05-14 21:40:00","snet_input_date":"2024-05-13 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-05-14 21:40:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:16:20.000000Z","updated_at":"2025-03-17T20:16:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9238246,"change_date":"2024-05-14 21:40:00","inspection_id":"81595520","insp_unit_id":"200866661","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"2208905","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUBGBDVXCSBL4962","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:58.000000Z","updated_at":"2025-03-17T23:18:58.000000Z"},{"id":9238247,"change_date":"2024-05-14 21:40:00","inspection_id":"81595520","insp_unit_id":"200866662","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"PE52981","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA5612GB711069","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:58.000000Z","updated_at":"2025-03-17T23:18:58.000000Z"}]},{"id":5385080,"change_date":"2024-04-02 21:41:00","inspection_id":"81213178","dot_number":"596882","report_state":"CT","report_number":"3070005835","insp_date":"2024-03-28 00:00:00","insp_start_time":"1320","insp_end_time":"1335","registration_date":"2024-04-02 00:00:00","region":"ET","ci_status_code":"C","location":"025","location_desc":"CHESHIRE","county_code_state":"CT","county_code":"009","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"0","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54270","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":"703625","transaction_code":"C","transaction_date":"2024-03-28 00:00:00","upload_date":"2024-04-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00596882","upload_search_indicator":null,"census_search_date":"2024-03-28 21:40:00","snet_input_date":"2024-03-28 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-03-28 21:40:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:09:26.000000Z","updated_at":"2025-03-17T20:09:26.000000Z","inspection_violations":[{"id":8311335,"change_date":"2024-04-02 21:41:00","inspection_id":"81213178","insp_violation_id":"258692232","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:13.000000Z","updated_at":"2025-03-17T21:46:13.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8672741,"change_date":"2024-04-02 21:41:00","inspection_id":"81213178","insp_unit_id":"200186798","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRTV","insp_unit_company":null,"insp_unit_license":"2240806","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKBGBDV6FSGN6765","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:40.000000Z","updated_at":"2025-03-17T23:13:40.000000Z"},{"id":8672742,"change_date":"2024-04-02 21:41:00","inspection_id":"81213178","insp_unit_id":"200186799","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KID","insp_unit_company":null,"insp_unit_license":"P962618","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"526162814L5000664","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:40.000000Z","updated_at":"2025-03-17T23:13:40.000000Z"}]},{"id":5309852,"change_date":"2024-03-19 21:43:00","inspection_id":"81131406","dot_number":"596882","report_state":"CT","report_number":"3016000841","insp_date":"2024-03-19 00:00:00","insp_start_time":"0855","insp_end_time":"0934","registration_date":null,"region":"ET","ci_status_code":"C","location":"034S","location_desc":"DANBURY SCALE","county_code_state":"CT","county_code":"001","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"DANBURY HIGH SCHOOL","shipping_paper_number":"454277483","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-19 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"73700","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"702635","transaction_code":"A","transaction_date":"2024-03-19 00:00:00","upload_date":"2024-03-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00596882","upload_search_indicator":null,"census_search_date":"2024-03-19 21:43:00","snet_input_date":"2024-03-19 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-03-19 21:43:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:07:53.000000Z","updated_at":"2025-03-17T20:07:53.000000Z","inspection_violations":[{"id":8191149,"change_date":"2024-03-19 21:43:00","inspection_id":"81131406","insp_violation_id":"258443384","seq_no":"1","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"199965479","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:35.000000Z","updated_at":"2025-03-17T21:45:35.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":8551544,"change_date":"2024-03-19 21:43:00","inspection_id":"81131406","insp_unit_id":"199965479","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRTV","insp_unit_company":"136176","insp_unit_license":"2488442","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUBC5DV1HHJC7358","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:31.000000Z","updated_at":"2025-03-17T23:12:31.000000Z"},{"id":8551545,"change_date":"2024-03-19 21:43:00","inspection_id":"81131406","insp_unit_id":"199965480","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"243526","insp_unit_license":"P426682","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA5610GB711068","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:31.000000Z","updated_at":"2025-03-17T23:12:31.000000Z"}]},{"id":5354505,"change_date":"2024-03-24 21:32:00","inspection_id":"81180053","dot_number":"596882","report_state":"NY","report_number":"SPT1020049","insp_date":"2024-03-18 00:00:00","insp_start_time":"0544","insp_end_time":"0616","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"YONKERS NY","county_code_state":"NY","county_code":"119","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-03-24 21:32:00","post_acc_ind":"N","gross_comb_veh_wt":"52350","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"340365","transaction_code":"A","transaction_date":"2024-03-24 00:00:00","upload_date":"2024-03-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00596882","upload_search_indicator":null,"census_search_date":"2024-03-24 21:32:00","snet_input_date":"2024-03-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-03-24 21:32:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:08:42.000000Z","updated_at":"2025-03-17T20:08:42.000000Z","inspection_violations":[{"id":8261167,"change_date":"2024-03-24 21:32:00","inspection_id":"81180053","insp_violation_id":"258547368","seq_no":"1","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"200057110","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:00.000000Z","updated_at":"2025-03-17T21:46:00.000000Z","normalized_code":"3939ALHLI"},{"id":8261168,"change_date":"2024-03-24 21:32:00","inspection_id":"81180053","insp_violation_id":"258547369","seq_no":"2","part_no":"393","part_no_section":"9A-LSLIWR","insp_viol_unit":"1","insp_unit_id":"200057110","insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:46:00.000000Z","updated_at":"2025-03-17T21:46:00.000000Z","normalized_code":"3939ALSLIWR"}],"inspection_per_units":[{"id":8622936,"change_date":"2024-03-24 21:32:00","inspection_id":"81180053","insp_unit_id":"200057110","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"143306","insp_unit_license":"2987460","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HSDXTZN0NN268517","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:12.000000Z","updated_at":"2025-03-17T23:13:12.000000Z"},{"id":8622937,"change_date":"2024-03-24 21:32:00","inspection_id":"81180053","insp_unit_id":"200057111","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"230453","insp_unit_license":"BN97386","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1GRAA5615CB701436","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:12.000000Z","updated_at":"2025-03-17T23:13:12.000000Z"}]},{"id":5309900,"change_date":"2024-03-19 21:43:00","inspection_id":"81131458","dot_number":"596882","report_state":"CT","report_number":"1162002389","insp_date":"2024-03-18 00:00:00","insp_start_time":"2109","insp_end_time":"2120","registration_date":null,"region":"ET","ci_status_code":"C","location":"151","location_desc":"RIGHT SHOULDER, EAST OF X23","county_code_state":"CT","county_code":"009","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-19 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"54270","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":"702595","transaction_code":"A","transaction_date":"2024-03-18 00:00:00","upload_date":"2024-03-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00596882","upload_search_indicator":null,"census_search_date":"2024-03-19 21:43:00","snet_input_date":"2024-03-18 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-03-19 21:43:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:07:54.000000Z","updated_at":"2025-03-17T20:07:54.000000Z","inspection_violations":[{"id":8191248,"change_date":"2024-03-19 21:43:00","inspection_id":"81131458","insp_violation_id":"258443599","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:45:35.000000Z","updated_at":"2025-03-17T21:45:35.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8551608,"change_date":"2024-03-19 21:43:00","inspection_id":"81131458","insp_unit_id":"199965603","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MCK","insp_unit_company":null,"insp_unit_license":"2802438","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN2AY0LM001930","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:31.000000Z","updated_at":"2025-03-17T23:12:31.000000Z"},{"id":8551609,"change_date":"2024-03-19 21:43:00","inspection_id":"81131458","insp_unit_id":"199965604","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"228031","insp_unit_license":"W11547","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1GRAA7624CB706812","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:31.000000Z","updated_at":"2025-03-17T23:12:31.000000Z"}]},{"id":5291652,"change_date":"2024-03-15 21:39:00","inspection_id":"81111432","dot_number":"596882","report_state":"CT","report_number":"3011000811","insp_date":"2024-03-15 00:00:00","insp_start_time":"1022","insp_end_time":"1030","registration_date":null,"region":"ET","ci_status_code":"C","location":"052","location_desc":"FARMINGTON","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-15 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"46800","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":"702305","transaction_code":"A","transaction_date":"2024-03-15 00:00:00","upload_date":"2024-03-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00596882","upload_search_indicator":null,"census_search_date":"2024-03-15 21:39:00","snet_input_date":"2024-03-15 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-03-15 21:39:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:07:30.000000Z","updated_at":"2025-03-17T20:07:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8521434,"change_date":"2024-03-15 21:39:00","inspection_id":"81111432","insp_unit_id":"199925800","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"141489","insp_unit_license":"2962637","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HAEVTARXLL284827","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:14.000000Z","updated_at":"2025-03-17T23:12:14.000000Z"}]},{"id":4871744,"change_date":"2024-01-24 21:44:00","inspection_id":"80653000","dot_number":"596882","report_state":"CT","report_number":"3129004615","insp_date":"2024-01-20 00:00:00","insp_start_time":"0545","insp_end_time":"0708","registration_date":"2024-01-24 00:00:00","region":"ET","ci_status_code":"C","location":"033","location_desc":"CROMWELL","county_code_state":"CT","county_code":"007","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"0726613","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":null,"final_status_date":"2024-01-22 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"800000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"697321","transaction_code":"C","transaction_date":"2024-01-20 00:00:00","upload_date":"2024-01-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00596882","upload_search_indicator":null,"census_search_date":"2024-01-22 21:43:00","snet_input_date":"2024-01-20 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-01-22 21:43:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:59:15.000000Z","updated_at":"2025-03-17T19:59:15.000000Z","inspection_violations":[{"id":7507572,"change_date":"2024-01-24 21:44:00","inspection_id":"80653000","insp_violation_id":"257464956","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"199081306","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:42:14.000000Z","updated_at":"2025-03-17T21:42:14.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":7838501,"change_date":"2024-01-24 21:44:00","inspection_id":"80653000","insp_unit_id":"199081305","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRTV","insp_unit_company":"147744","insp_unit_license":"2208909","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKBHTDV4RDVH0276","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:02.000000Z","updated_at":"2025-03-17T23:06:02.000000Z"},{"id":7838502,"change_date":"2024-01-24 21:44:00","inspection_id":"80653000","insp_unit_id":"199081306","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"P590101","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA8425HB708732","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:02.000000Z","updated_at":"2025-03-17T23:06:02.000000Z"}]},{"id":4798493,"change_date":"2024-01-10 21:43:00","inspection_id":"80572768","dot_number":"596882","report_state":"CT","report_number":"3078002493","insp_date":"2024-01-10 00:00:00","insp_start_time":"1434","insp_end_time":"1459","registration_date":null,"region":"ET","ci_status_code":"C","location":"083S","location_desc":"MIDDLETOWN SCALE","county_code_state":"CT","county_code":"007","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SAME","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-01-10 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"0","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":"696598","transaction_code":"A","transaction_date":"2024-01-10 00:00:00","upload_date":"2024-01-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00596882","upload_search_indicator":null,"census_search_date":"2024-01-10 21:43:00","snet_input_date":"2024-01-10 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-01-10 21:43:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:57:42.000000Z","updated_at":"2025-03-17T19:57:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7720216,"change_date":"2024-01-10 21:43:00","inspection_id":"80572768","insp_unit_id":"198888851","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRTV","insp_unit_company":null,"insp_unit_license":"2208891","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKBHTDV7RDVH0272","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:01.000000Z","updated_at":"2025-03-17T23:05:01.000000Z"},{"id":7720217,"change_date":"2024-01-10 21:43:00","inspection_id":"80572768","insp_unit_id":"198888852","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KID","insp_unit_company":null,"insp_unit_license":"P590114","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"526162816H5000060","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:01.000000Z","updated_at":"2025-03-17T23:05:01.000000Z"}]},{"id":4706028,"change_date":"2023-12-27 21:41:00","inspection_id":"80472068","dot_number":"596882","report_state":"CT","report_number":"3070005558","insp_date":"2023-12-27 00:00:00","insp_start_time":"1406","insp_end_time":"1419","registration_date":null,"region":"ET","ci_status_code":"C","location":"131","location_desc":"SOUTHINGTON","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"796006","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.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-12-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"0","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":"695447","transaction_code":"A","transaction_date":"2023-12-27 00:00:00","upload_date":"2023-12-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00596882","upload_search_indicator":null,"census_search_date":"2023-12-27 21:41:00","snet_input_date":"2023-12-27 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-12-27 21:41:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:56:09.000000Z","updated_at":"2025-03-17T19:56:09.000000Z","inspection_violations":[{"id":7267865,"change_date":"2023-12-27 21:41:00","inspection_id":"80472068","insp_violation_id":"257055400","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:07.000000Z","updated_at":"2025-03-17T21:41:07.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7569442,"change_date":"2023-12-27 21:41:00","inspection_id":"80472068","insp_unit_id":"198671906","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"2341929","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUBGBDV3GLHE4374","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:39.000000Z","updated_at":"2025-03-17T23:03:39.000000Z"},{"id":7569443,"change_date":"2023-12-27 21:41:00","inspection_id":"80472068","insp_unit_id":"198671907","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"P668546","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA8428DB707469","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:39.000000Z","updated_at":"2025-03-17T23:03:39.000000Z"}]},{"id":4668545,"change_date":"2023-12-30 21:32:00","inspection_id":"80431014","dot_number":"596882","report_state":"CT","report_number":"3070005544","insp_date":"2023-12-20 00:00:00","insp_start_time":"1346","insp_end_time":"1400","registration_date":"2023-12-29 00:00:00","region":"ET","ci_status_code":"C","location":"025","location_desc":"CHESHIRE","county_code_state":"CT","county_code":"009","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"CCN 21633","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.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-12-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"0","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":"694988","transaction_code":"C","transaction_date":"2023-12-20 00:00:00","upload_date":"2023-12-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00596882","upload_search_indicator":null,"census_search_date":"2023-12-20 21:41:00","snet_input_date":"2023-12-20 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-12-20 21:41:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:55:23.000000Z","updated_at":"2025-03-17T19:55:23.000000Z","inspection_violations":[{"id":7216557,"change_date":"2023-12-30 21:32:00","inspection_id":"80431014","insp_violation_id":"257124643","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:50.000000Z","updated_at":"2025-03-17T21:40:50.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7508792,"change_date":"2023-12-30 21:32:00","inspection_id":"80431014","insp_unit_id":"198745422","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRTV","insp_unit_company":null,"insp_unit_license":"2208901","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKBHTDV3RDVH0270","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:07.000000Z","updated_at":"2025-03-17T23:03:07.000000Z"},{"id":7508793,"change_date":"2023-12-30 21:32:00","inspection_id":"80431014","insp_unit_id":"198745423","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"P812427","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA8429DB710283","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:07.000000Z","updated_at":"2025-03-17T23:03:07.000000Z"}]},{"id":4438706,"change_date":"2023-11-21 21:39:00","inspection_id":"80178484","dot_number":"596882","report_state":"MA","report_number":"DR00000277","insp_date":"2023-11-15 00:00:00","insp_start_time":"1709","insp_end_time":"1727","registration_date":"2023-11-21 00:00:00","region":"ET","ci_status_code":"C","location":"311H","location_desc":"H-SPRINGFIELD","county_code_state":"MA","county_code":"013","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"454112121","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-16 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"99700","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"478877","transaction_code":"C","transaction_date":"2023-11-16 00:00:00","upload_date":"2023-11-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00596882","upload_search_indicator":"M","census_search_date":"2023-11-16 21:42:00","snet_input_date":"2023-11-15 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-11-16 21:42:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:50:46.000000Z","updated_at":"2025-03-17T19:50:46.000000Z","inspection_violations":[{"id":6870267,"change_date":"2023-11-21 21:39:00","inspection_id":"80178484","insp_violation_id":"256505591","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"198159011","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:39:06.000000Z","updated_at":"2025-03-17T21:39:06.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":7138187,"change_date":"2023-11-21 21:39:00","inspection_id":"80178484","insp_unit_id":"198159010","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRTV","insp_unit_company":"134832","insp_unit_license":"2241332","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUBGBDV4GLHB3358","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:56.000000Z","updated_at":"2025-03-17T22:59:56.000000Z"},{"id":7138188,"change_date":"2023-11-21 21:39:00","inspection_id":"80178484","insp_unit_id":"198159011","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KID","insp_unit_company":"247566","insp_unit_license":"P744772","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"526164223J5001220","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:56.000000Z","updated_at":"2025-03-17T22:59:56.000000Z"}]},{"id":4337913,"change_date":"2023-11-02 21:41:00","inspection_id":"80067007","dot_number":"596882","report_state":"CT","report_number":"3129004453","insp_date":"2023-11-01 00:00:00","insp_start_time":"1644","insp_end_time":"1713","registration_date":null,"region":"ET","ci_status_code":"C","location":"064","location_desc":"HARTFORD","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-02 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":"690453","transaction_code":"A","transaction_date":"2023-11-01 00:00:00","upload_date":"2023-11-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00596882","upload_search_indicator":null,"census_search_date":"2023-11-02 21:41:00","snet_input_date":"2023-11-01 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-11-02 21:41:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:48:46.000000Z","updated_at":"2025-03-17T19:48:46.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6976534,"change_date":"2023-11-02 21:41:00","inspection_id":"80067007","insp_unit_id":"197868681","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRTV","insp_unit_company":null,"insp_unit_license":"2208893","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUBGBDV8BLAX0154","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:34.000000Z","updated_at":"2025-03-17T22:58:34.000000Z"},{"id":6976535,"change_date":"2023-11-02 21:41:00","inspection_id":"80067007","insp_unit_id":"197868682","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HACK","insp_unit_company":"254072","insp_unit_license":"PD71336","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"526162814P5000654","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:34.000000Z","updated_at":"2025-03-17T22:58:34.000000Z"}]},{"id":4277785,"change_date":"2023-11-14 21:40:00","inspection_id":"80000577","dot_number":"596882","report_state":"CT","report_number":"3010002999","insp_date":"2023-10-25 00:00:00","insp_start_time":"0625","insp_end_time":"0718","registration_date":"2023-11-13 00:00:00","region":"ET","ci_status_code":"C","location":"152","location_desc":"WATERFORD N\/B SCALE","county_code_state":"CT","county_code":"011","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"TRIP SLIP","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.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-10-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"103000","viol_total":"4","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"689735","transaction_code":"C","transaction_date":"2023-10-25 00:00:00","upload_date":"2023-11-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00596882","upload_search_indicator":null,"census_search_date":"2023-10-25 21:41:00","snet_input_date":"2023-10-25 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-10-25 21:41:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:47:29.000000Z","updated_at":"2025-03-17T19:47:29.000000Z","inspection_violations":[{"id":6617051,"change_date":"2023-11-14 21:40:00","inspection_id":"80000577","insp_violation_id":"256370862","seq_no":"1","part_no":"391","part_no_section":"11(b)(4)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:51.000000Z","updated_at":"2025-03-17T21:37:51.000000Z","normalized_code":"39111B4"},{"id":6617052,"change_date":"2023-11-14 21:40:00","inspection_id":"80000577","insp_violation_id":"256370863","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:51.000000Z","updated_at":"2025-03-17T21:37:51.000000Z","normalized_code":"3922"},{"id":6617053,"change_date":"2023-11-14 21:40:00","inspection_id":"80000577","insp_violation_id":"256370864","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198040227","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:51.000000Z","updated_at":"2025-03-17T21:37:51.000000Z","normalized_code":"3939A"},{"id":6617054,"change_date":"2023-11-14 21:40:00","inspection_id":"80000577","insp_violation_id":"256370865","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"198040226","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:51.000000Z","updated_at":"2025-03-17T21:37:51.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6879936,"change_date":"2023-11-14 21:40:00","inspection_id":"80000577","insp_unit_id":"198040226","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"4738","insp_unit_license":"V98744","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1GRAA7625BB707174","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:40.000000Z","updated_at":"2025-03-17T22:57:40.000000Z"},{"id":6879937,"change_date":"2023-11-14 21:40:00","inspection_id":"80000577","insp_unit_id":"198040227","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"132052","insp_unit_license":"2028195","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUBGBDV4DLBX0335","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:40.000000Z","updated_at":"2025-03-17T22:57:40.000000Z"}]},{"id":3680628,"change_date":"2023-08-07 21:41:00","inspection_id":"79336876","dot_number":"596882","report_state":"CT","report_number":"3129004168","insp_date":"2023-08-05 00:00:00","insp_start_time":"0605","insp_end_time":"0629","registration_date":null,"region":"ET","ci_status_code":"C","location":"119","location_desc":"ROCKY HILL","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"001","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"682602","transaction_code":"A","transaction_date":"2023-08-05 00:00:00","upload_date":"2023-08-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00596882","upload_search_indicator":null,"census_search_date":"2023-08-07 21:41:00","snet_input_date":"2023-08-05 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-08-07 21:41:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:35:38.000000Z","updated_at":"2025-03-17T19:35:38.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5917855,"change_date":"2023-08-07 21:41:00","inspection_id":"79336876","insp_unit_id":"196387103","insp_unit_type_id":"3","insp_unit_number":"1","insp_unit_make":"INTC","insp_unit_company":"141505","insp_unit_license":"2962547","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HAEUMMM3LL284595","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:44.000000Z","updated_at":"2025-03-17T22:49:44.000000Z"}]},{"id":3626841,"change_date":"2023-07-31 21:40:00","inspection_id":"79276406","dot_number":"596882","report_state":"CT","report_number":"3132003987","insp_date":"2023-07-28 00:00:00","insp_start_time":"1627","insp_end_time":"1642","registration_date":null,"region":"ET","ci_status_code":"C","location":"064","location_desc":"HARTFORD","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-31 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"78500","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":"681896","transaction_code":"A","transaction_date":"2023-07-28 00:00:00","upload_date":"2023-07-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00596882","upload_search_indicator":null,"census_search_date":"2023-07-31 21:40:00","snet_input_date":"2023-07-28 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-07-31 21:40:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:34:33.000000Z","updated_at":"2025-03-17T19:34:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5831394,"change_date":"2023-07-31 21:40:00","inspection_id":"79276406","insp_unit_id":"196266421","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"2208908","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUBGBDV5DLBR7057","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:03.000000Z","updated_at":"2025-03-17T22:49:03.000000Z"},{"id":5831395,"change_date":"2023-07-31 21:40:00","inspection_id":"79276406","insp_unit_id":"196266422","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"V99602","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1GRAA5615CB701436","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:03.000000Z","updated_at":"2025-03-17T22:49:03.000000Z"}]},{"id":3551814,"change_date":"2023-07-20 21:40:00","inspection_id":"79192208","dot_number":"596882","report_state":"CT","report_number":"3129004129","insp_date":"2023-07-20 00:00:00","insp_start_time":"0645","insp_end_time":"0710","registration_date":null,"region":"ET","ci_status_code":"C","location":"119","location_desc":"ROCKY HILL","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"67000","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":"681063","transaction_code":"A","transaction_date":"2023-07-20 00:00:00","upload_date":"2023-07-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00596882","upload_search_indicator":null,"census_search_date":"2023-07-20 21:40:00","snet_input_date":"2023-07-20 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-07-20 21:40:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:33:10.000000Z","updated_at":"2025-03-17T19:33:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5711135,"change_date":"2023-07-20 21:40:00","inspection_id":"79192208","insp_unit_id":"196096376","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRTV","insp_unit_company":null,"insp_unit_license":"2341928","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUBGBDV5GLHE4375","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:05.000000Z","updated_at":"2025-03-17T22:48:05.000000Z"},{"id":5711136,"change_date":"2023-07-20 21:40:00","inspection_id":"79192208","insp_unit_id":"196096377","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"PB84791","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"0","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:05.000000Z","updated_at":"2025-03-17T22:48:05.000000Z"}]},{"id":3462462,"change_date":"2023-07-19 21:43:00","inspection_id":"79092124","dot_number":"596882","report_state":"CT","report_number":"3025002640","insp_date":"2023-07-07 00:00:00","insp_start_time":"1743","insp_end_time":"1805","registration_date":"2023-07-19 00:00:00","region":"ET","ci_status_code":"C","location":"164","location_desc":"WINDSOR","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"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-07-10 21:41: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":"679813","transaction_code":"C","transaction_date":"2023-07-07 00:00:00","upload_date":"2023-07-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00596882","upload_search_indicator":null,"census_search_date":"2023-07-10 21:41:00","snet_input_date":"2023-07-07 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-07-10 21:41:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:31:39.000000Z","updated_at":"2025-03-17T19:31:39.000000Z","inspection_violations":[{"id":5339219,"change_date":"2023-07-19 21:43:00","inspection_id":"79092124","insp_violation_id":"254141594","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:45.000000Z","updated_at":"2025-03-17T21:31:45.000000Z","normalized_code":"3922"},{"id":5339220,"change_date":"2023-07-19 21:43:00","inspection_id":"79092124","insp_violation_id":"254141595","seq_no":"2","part_no":"395","part_no_section":"34(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:45.000000Z","updated_at":"2025-03-17T21:31:45.000000Z","normalized_code":"39534A1"}],"inspection_per_units":[{"id":5567663,"change_date":"2023-07-19 21:43:00","inspection_id":"79092124","insp_unit_id":"196072688","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"134832","insp_unit_license":"2241332","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUBGBDV4GLHB3358","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:57.000000Z","updated_at":"2025-03-17T22:46:57.000000Z"},{"id":5567664,"change_date":"2023-07-19 21:43:00","inspection_id":"79092124","insp_unit_id":"196072689","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"228850","insp_unit_license":"P744592","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA7626DB706859","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:57.000000Z","updated_at":"2025-03-17T22:46:57.000000Z"}]},{"id":3338476,"change_date":"2023-07-05 21:41:00","inspection_id":"78952595","dot_number":"596882","report_state":"CT","report_number":"1147001640","insp_date":"2023-06-22 00:00:00","insp_start_time":"0958","insp_end_time":"1035","registration_date":"2023-07-05 00:00:00","region":"ET","ci_status_code":"C","location":"061","location_desc":"HADDAM","county_code_state":"CT","county_code":"007","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SYSCO","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"99700","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":"678125","transaction_code":"C","transaction_date":"2023-06-22 00:00:00","upload_date":"2023-07-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00596882","upload_search_indicator":null,"census_search_date":"2023-06-22 21:41:00","snet_input_date":"2023-06-22 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-06-22 21:41:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:28:58.000000Z","updated_at":"2025-03-17T19:28:58.000000Z","inspection_violations":[{"id":5148131,"change_date":"2023-07-05 21:41:00","inspection_id":"78952595","insp_violation_id":"253855109","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:54.000000Z","updated_at":"2025-03-17T21:30:54.000000Z","normalized_code":"3922"},{"id":5148132,"change_date":"2023-07-05 21:41:00","inspection_id":"78952595","insp_violation_id":"253855110","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:54.000000Z","updated_at":"2025-03-17T21:30:54.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5367294,"change_date":"2023-07-05 21:41:00","inspection_id":"78952595","insp_unit_id":"195814218","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"134005","insp_unit_license":"2240805","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKBGBDV1FSGN6768","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:20.000000Z","updated_at":"2025-03-17T22:45:20.000000Z"},{"id":5367295,"change_date":"2023-07-05 21:41:00","inspection_id":"78952595","insp_unit_id":"195814219","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KID","insp_unit_company":"247568","insp_unit_license":"P744774","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"526164227J5001222","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:20.000000Z","updated_at":"2025-03-17T22:45:20.000000Z"}]},{"id":2949570,"change_date":"2023-05-09 21:41:00","inspection_id":"78513481","dot_number":"596882","report_state":"CT","report_number":"1162001642","insp_date":"2023-05-02 00:00:00","insp_start_time":"0549","insp_end_time":"0604","registration_date":"2023-05-09 00:00:00","region":"ET","ci_status_code":"C","location":"151","location_desc":"RIGHT SHOULDER, EAST OF X23","county_code_state":"CT","county_code":"009","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","shipping_paper_number":"0703645","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.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-05-03 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","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":"673246","transaction_code":"C","transaction_date":"2023-05-02 00:00:00","upload_date":"2023-05-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00596882","upload_search_indicator":null,"census_search_date":"2023-05-03 21:41:00","snet_input_date":"2023-05-02 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-05-03 21:41:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:21:23.000000Z","updated_at":"2025-03-17T19:21:23.000000Z","inspection_violations":[{"id":4527442,"change_date":"2023-05-09 21:41:00","inspection_id":"78513481","insp_violation_id":"252705942","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:28:06.000000Z","updated_at":"2025-03-17T21:28:06.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4745908,"change_date":"2023-05-09 21:41:00","inspection_id":"78513481","insp_unit_id":"194821467","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"2561132","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AW01YXJM010875","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:25.000000Z","updated_at":"2025-03-17T22:40:25.000000Z"},{"id":4745909,"change_date":"2023-05-09 21:41:00","inspection_id":"78513481","insp_unit_id":"194821468","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KID","insp_unit_company":"245368","insp_unit_license":"P590111","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"526162818H5000058","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:25.000000Z","updated_at":"2025-03-17T22:40:25.000000Z"}]},{"id":2835312,"change_date":"2023-06-22 21:41:00","inspection_id":"78384178","dot_number":"596882","report_state":"CT","report_number":"0935000215","insp_date":"2023-04-19 00:00:00","insp_start_time":"1218","insp_end_time":"1338","registration_date":"2023-06-22 00:00:00","region":"ET","ci_status_code":"C","location":"080","location_desc":"E MAIN ST (LOWES LOT)","county_code_state":"CT","county_code":"009","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SYSCO CONNECTICUT LLC","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-04-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"102700","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"672267","transaction_code":"C","transaction_date":"2023-04-19 00:00:00","upload_date":"2023-06-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00596882","upload_search_indicator":null,"census_search_date":"2023-04-19 21:41:00","snet_input_date":"2023-04-19 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-04-19 21:41:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:18:56.000000Z","updated_at":"2025-03-17T19:18:56.000000Z","inspection_violations":[{"id":4349690,"change_date":"2023-06-22 21:41:00","inspection_id":"78384178","insp_violation_id":"253632674","seq_no":"1","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"195614912","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:19.000000Z","updated_at":"2025-03-17T21:27:19.000000Z","normalized_code":"39345D"},{"id":4349691,"change_date":"2023-06-22 21:41:00","inspection_id":"78384178","insp_violation_id":"253632675","seq_no":"2","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"195614912","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:19.000000Z","updated_at":"2025-03-17T21:27:19.000000Z","normalized_code":"39345B2"},{"id":4349692,"change_date":"2023-06-22 21:41:00","inspection_id":"78384178","insp_violation_id":"253632676","seq_no":"3","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"195614913","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:19.000000Z","updated_at":"2025-03-17T21:27:19.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":4563742,"change_date":"2023-06-22 21:41:00","inspection_id":"78384178","insp_unit_id":"195614912","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"134005","insp_unit_license":"2240805","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKBGBDV1FSGN6768","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:59.000000Z","updated_at":"2025-03-17T22:38:59.000000Z"},{"id":4563743,"change_date":"2023-06-22 21:41:00","inspection_id":"78384178","insp_unit_id":"195614913","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"228415","insp_unit_license":"W12901","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1GRAA8429CB710170","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:59.000000Z","updated_at":"2025-03-17T22:38:59.000000Z"}]},{"id":2538402,"change_date":"2023-03-09 21:41:00","inspection_id":"78046270","dot_number":"596882","report_state":"CT","report_number":"3016000234","insp_date":"2023-03-09 00:00:00","insp_start_time":"1053","insp_end_time":"1123","registration_date":null,"region":"ET","ci_status_code":"C","location":"093","location_desc":"SARGENT DR NEW HAVEN","county_code_state":"CT","county_code":"009","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"THE TASTE GARDEN CAFE","shipping_paper_number":"354756877","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-09 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"668931","transaction_code":"A","transaction_date":"2023-03-09 00:00:00","upload_date":"2023-03-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00596882","upload_search_indicator":null,"census_search_date":"2023-03-09 21:41:00","snet_input_date":"2023-03-09 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-03-09 21:41:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:13:23.000000Z","updated_at":"2025-03-17T19:13:23.000000Z","inspection_violations":[{"id":3904612,"change_date":"2023-03-09 21:41:00","inspection_id":"78046270","insp_violation_id":"251558727","seq_no":"1","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"193780416","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:20.000000Z","updated_at":"2025-03-17T21:25:20.000000Z","normalized_code":"39021TB"},{"id":3904613,"change_date":"2023-03-09 21:41:00","inspection_id":"78046270","insp_violation_id":"251558728","seq_no":"2","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:20.000000Z","updated_at":"2025-03-17T21:25:20.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":4085902,"change_date":"2023-03-09 21:41:00","inspection_id":"78046270","insp_unit_id":"193780416","insp_unit_type_id":"3","insp_unit_number":"1","insp_unit_make":"INTC","insp_unit_company":"141505","insp_unit_license":"2962547","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HAEUMMM3LL284595","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:18.000000Z","updated_at":"2025-03-17T22:35:18.000000Z"}]},{"id":2442687,"change_date":"2023-02-27 21:40:00","inspection_id":"77937521","dot_number":"596882","report_state":"CT","report_number":"3061001964","insp_date":"2023-02-24 00:00:00","insp_start_time":"1623","insp_end_time":"1640","registration_date":"2023-02-27 00:00:00","region":"ET","ci_status_code":"C","location":"083S","location_desc":"MIDDLETOWN SCALE","county_code_state":"CT","county_code":"007","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"2","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":"667612","transaction_code":"C","transaction_date":"2023-02-24 00:00:00","upload_date":"2023-02-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00596882","upload_search_indicator":null,"census_search_date":"2023-02-24 21:40:00","snet_input_date":"2023-02-24 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-02-24 21:40:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:11:45.000000Z","updated_at":"2025-03-17T19:11:45.000000Z","inspection_violations":[{"id":3760223,"change_date":"2023-02-27 21:40:00","inspection_id":"77937521","insp_violation_id":"251341753","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:44.000000Z","updated_at":"2025-03-17T21:24:44.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3930893,"change_date":"2023-02-27 21:40:00","inspection_id":"77937521","insp_unit_id":"193583876","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"54-135526","insp_unit_license":"2341929","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUBGBDV3GLHE4374","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:09.000000Z","updated_at":"2025-03-17T22:34:09.000000Z"},{"id":3930894,"change_date":"2023-02-27 21:40:00","inspection_id":"77937521","insp_unit_id":"193583877","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KID","insp_unit_company":"229627","insp_unit_license":"P590489","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"526174226D5000855","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:09.000000Z","updated_at":"2025-03-17T22:34:09.000000Z"}]},{"id":2404127,"change_date":"2023-02-22 21:39:00","inspection_id":"77893692","dot_number":"596882","report_state":"CT","report_number":"3079001894","insp_date":"2023-02-17 00:00:00","insp_start_time":"1755","insp_end_time":"1835","registration_date":"2023-02-22 00:00:00","region":"ET","ci_status_code":"C","location":"083S","location_desc":"MIDDLETOWN SCALE","county_code_state":"CT","county_code":"007","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"0697516","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.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-02-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"9","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"9","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"667125","transaction_code":"C","transaction_date":"2023-02-17 00:00:00","upload_date":"2023-02-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00596882","upload_search_indicator":null,"census_search_date":"2023-02-21 21:40:00","snet_input_date":"2023-02-17 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-02-21 21:40:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:11:02.000000Z","updated_at":"2025-03-17T19:11:02.000000Z","inspection_violations":[{"id":3701284,"change_date":"2023-02-22 21:39:00","inspection_id":"77893692","insp_violation_id":"251260586","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193509996","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:28.000000Z","updated_at":"2025-03-17T21:24:28.000000Z","normalized_code":"3939A"},{"id":3701285,"change_date":"2023-02-22 21:39:00","inspection_id":"77893692","insp_violation_id":"251260587","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193509996","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:28.000000Z","updated_at":"2025-03-17T21:24:28.000000Z","normalized_code":"3939A"},{"id":3701286,"change_date":"2023-02-22 21:39:00","inspection_id":"77893692","insp_violation_id":"251260588","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193509996","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:28.000000Z","updated_at":"2025-03-17T21:24:28.000000Z","normalized_code":"3939A"},{"id":3701287,"change_date":"2023-02-22 21:39:00","inspection_id":"77893692","insp_violation_id":"251260589","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193509996","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:28.000000Z","updated_at":"2025-03-17T21:24:28.000000Z","normalized_code":"3939A"},{"id":3701288,"change_date":"2023-02-22 21:39:00","inspection_id":"77893692","insp_violation_id":"251260590","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193509996","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:28.000000Z","updated_at":"2025-03-17T21:24:28.000000Z","normalized_code":"3939A"},{"id":3701289,"change_date":"2023-02-22 21:39:00","inspection_id":"77893692","insp_violation_id":"251260591","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193509996","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"Y993918-0","created_at":"2025-03-17T21:24:28.000000Z","updated_at":"2025-03-17T21:24:28.000000Z","normalized_code":"3939A"},{"id":3701290,"change_date":"2023-02-22 21:39:00","inspection_id":"77893692","insp_violation_id":"251260592","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193509996","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:28.000000Z","updated_at":"2025-03-17T21:24:28.000000Z","normalized_code":"3939A"},{"id":3701291,"change_date":"2023-02-22 21:39:00","inspection_id":"77893692","insp_violation_id":"251260593","seq_no":"8","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193509996","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:28.000000Z","updated_at":"2025-03-17T21:24:28.000000Z","normalized_code":"3939A"},{"id":3701292,"change_date":"2023-02-22 21:39:00","inspection_id":"77893692","insp_violation_id":"251260594","seq_no":"9","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193509996","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:28.000000Z","updated_at":"2025-03-17T21:24:28.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":3869107,"change_date":"2023-02-22 21:39:00","inspection_id":"77893692","insp_unit_id":"193509996","insp_unit_type_id":"3","insp_unit_number":"1","insp_unit_make":"INTC","insp_unit_company":"137085","insp_unit_license":"2561187","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HAMSTAR0JL715368","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:42.000000Z","updated_at":"2025-03-17T22:33:42.000000Z"}]},{"id":2383656,"change_date":"2023-02-22 21:39:00","inspection_id":"77870392","dot_number":"596882","report_state":"CT","report_number":"1162001507","insp_date":"2023-02-16 00:00:00","insp_start_time":"1247","insp_end_time":"1317","registration_date":"2023-02-22 00:00:00","region":"ET","ci_status_code":"C","location":"061","location_desc":"HADDAM SWING BRIDGE","county_code_state":"CT","county_code":"007","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"666863","transaction_code":"C","transaction_date":"2023-02-16 00:00:00","upload_date":"2023-02-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00596882","upload_search_indicator":null,"census_search_date":"2023-02-16 21:41:00","snet_input_date":"2023-02-16 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-02-16 21:41:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:10:41.000000Z","updated_at":"2025-03-17T19:10:41.000000Z","inspection_violations":[{"id":3670678,"change_date":"2023-02-22 21:39:00","inspection_id":"77870392","insp_violation_id":"251260737","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:18.000000Z","updated_at":"2025-03-17T21:24:18.000000Z","normalized_code":"3922"},{"id":3670679,"change_date":"2023-02-22 21:39:00","inspection_id":"77870392","insp_violation_id":"251260738","seq_no":"2","part_no":"387","part_no_section":"303(b)(4)","insp_viol_unit":"1","insp_unit_id":"193510106","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:18.000000Z","updated_at":"2025-03-17T21:24:18.000000Z","normalized_code":"387303B4"}],"inspection_per_units":[{"id":3835770,"change_date":"2023-02-22 21:39:00","inspection_id":"77870392","insp_unit_id":"193510106","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"135590","insp_unit_license":"2342048","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUBGBDV7HLHH9419","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:29.000000Z","updated_at":"2025-03-17T22:33:29.000000Z"},{"id":3835771,"change_date":"2023-02-22 21:39:00","inspection_id":"77870392","insp_unit_id":"193510107","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"229294","insp_unit_license":"P490583","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA8427DB710282","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:29.000000Z","updated_at":"2025-03-17T22:33:29.000000Z"}]},{"id":2342220,"change_date":"2023-02-10 21:39:00","inspection_id":"77822801","dot_number":"596882","report_state":"CT","report_number":"3070004299","insp_date":"2023-02-09 00:00:00","insp_start_time":"1007","insp_end_time":"1020","registration_date":null,"region":"ET","ci_status_code":"C","location":"131","location_desc":"SOUTHINGTON","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"WHEELER CLINIC INC","shipping_paper_number":"354720560","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.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-02-10 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"0","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":"666244","transaction_code":"A","transaction_date":"2023-02-09 00:00:00","upload_date":"2023-02-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00596882","upload_search_indicator":null,"census_search_date":"2023-02-10 21:39:00","snet_input_date":"2023-02-09 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-02-10 21:39:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:09:56.000000Z","updated_at":"2025-03-17T19:09:56.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3768987,"change_date":"2023-02-10 21:39:00","inspection_id":"77822801","insp_unit_id":"193330967","insp_unit_type_id":"3","insp_unit_number":"1","insp_unit_make":"FRT","insp_unit_company":null,"insp_unit_license":"2208895","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUBGBDV1BLAX0156","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:59.000000Z","updated_at":"2025-03-17T22:32:59.000000Z"},{"id":3768988,"change_date":"2023-02-10 21:39:00","inspection_id":"77822801","insp_unit_id":"193330968","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"V98744","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1GRAA7625BB707174","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:59.000000Z","updated_at":"2025-03-17T22:32:59.000000Z"}]},{"id":2342214,"change_date":"2023-02-10 21:39:00","inspection_id":"77822793","dot_number":"596882","report_state":"CT","report_number":"3129003772","insp_date":"2023-02-08 00:00:00","insp_start_time":"1430","insp_end_time":"1455","registration_date":null,"region":"ET","ci_status_code":"C","location":"064","location_desc":"HARTFORD","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"1111","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.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-02-10 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"103000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"666140","transaction_code":"A","transaction_date":"2023-02-08 00:00:00","upload_date":"2023-02-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00596882","upload_search_indicator":null,"census_search_date":"2023-02-10 21:39:00","snet_input_date":"2023-02-08 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-02-10 21:39:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:09:56.000000Z","updated_at":"2025-03-17T19:09:56.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3768978,"change_date":"2023-02-10 21:39:00","inspection_id":"77822793","insp_unit_id":"193330943","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRAI","insp_unit_company":null,"insp_unit_license":"2987136","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUBGBDV0DLBX0333","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:59.000000Z","updated_at":"2025-03-17T22:32:59.000000Z"},{"id":3768979,"change_date":"2023-02-10 21:39:00","inspection_id":"77822793","insp_unit_id":"193330944","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"V99650","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1GRAA8420CB701437","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:59.000000Z","updated_at":"2025-03-17T22:32:59.000000Z"}]},{"id":2311975,"change_date":"2023-02-10 21:39:00","inspection_id":"77788251","dot_number":"596882","report_state":"CT","report_number":"3119001570","insp_date":"2023-02-03 00:00:00","insp_start_time":"1732","insp_end_time":"1807","registration_date":"2023-02-10 00:00:00","region":"ET","ci_status_code":"C","location":"083S","location_desc":"MIDDLETOWN SCALE","county_code_state":"CT","county_code":"007","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"NONE","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"75350","viol_total":"2","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"665702","transaction_code":"C","transaction_date":"2023-02-03 00:00:00","upload_date":"2023-02-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00596882","upload_search_indicator":null,"census_search_date":"2023-02-07 21:40:00","snet_input_date":"2023-02-03 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-02-07 21:40:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:09:15.000000Z","updated_at":"2025-03-17T19:09:15.000000Z","inspection_violations":[{"id":3561816,"change_date":"2023-02-10 21:39:00","inspection_id":"77788251","insp_violation_id":"251059411","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:50.000000Z","updated_at":"2025-03-17T21:23:50.000000Z","normalized_code":"38323A2"},{"id":3561817,"change_date":"2023-02-10 21:39:00","inspection_id":"77788251","insp_violation_id":"251059412","seq_no":"2","part_no":"383","part_no_section":"71(h)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:50.000000Z","updated_at":"2025-03-17T21:23:50.000000Z","normalized_code":"38371H"}],"inspection_per_units":[{"id":3721195,"change_date":"2023-02-10 21:39:00","inspection_id":"77788251","insp_unit_id":"193330624","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INL","insp_unit_company":"143304","insp_unit_license":"2987458","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HSDXTZN7NN268515","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:40.000000Z","updated_at":"2025-03-17T22:32:40.000000Z"},{"id":3721196,"change_date":"2023-02-10 21:39:00","inspection_id":"77788251","insp_unit_id":"193330625","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HACK","insp_unit_company":"252025","insp_unit_license":"P962619","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"526162816L5000665","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:40.000000Z","updated_at":"2025-03-17T22:32:40.000000Z"}]},{"id":2269767,"change_date":"2023-02-01 21:40:00","inspection_id":"77740459","dot_number":"596882","report_state":"CT","report_number":"3016000141","insp_date":"2023-02-01 00:00:00","insp_start_time":"0641","insp_end_time":"0652","registration_date":null,"region":"ET","ci_status_code":"C","location":"148","location_desc":"I-91 S EXIT 15 WALLINGFORD","county_code_state":"CT","county_code":"009","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"0696062","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.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-02-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"665188","transaction_code":"A","transaction_date":"2023-02-01 00:00:00","upload_date":"2023-02-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00596882","upload_search_indicator":null,"census_search_date":"2023-02-01 21:40:00","snet_input_date":"2023-02-01 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-02-01 21:40:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:08:30.000000Z","updated_at":"2025-03-17T19:08:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3654033,"change_date":"2023-02-01 21:40:00","inspection_id":"77740459","insp_unit_id":"193163998","insp_unit_type_id":"3","insp_unit_number":"1","insp_unit_make":"INTC","insp_unit_company":"54 137085","insp_unit_license":"2561187","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HAMSTAR0JL715368","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:11.000000Z","updated_at":"2025-03-17T22:32:11.000000Z"}]},{"id":2209786,"change_date":"2023-01-31 21:42:00","inspection_id":"77672060","dot_number":"596882","report_state":"CT","report_number":"3087002328","insp_date":"2023-01-20 00:00:00","insp_start_time":"1910","insp_end_time":"1938","registration_date":"2023-01-31 00:00:00","region":"ET","ci_status_code":"C","location":"083S","location_desc":"MIDDLETOWN SCALE","county_code_state":"CT","county_code":"007","insp_level_id":"3","service_center":"EA","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":"N","pen_cen_match":null,"final_status_date":"2023-01-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"95000","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":"664448","transaction_code":"C","transaction_date":"2023-01-21 00:00:00","upload_date":"2023-01-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00596882","upload_search_indicator":null,"census_search_date":"2023-01-24 21:42:00","snet_input_date":"2023-01-20 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-01-24 21:42:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:07:21.000000Z","updated_at":"2025-03-17T19:07:21.000000Z","inspection_violations":[{"id":3413270,"change_date":"2023-01-31 21:42:00","inspection_id":"77672060","insp_violation_id":"250860640","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:07.000000Z","updated_at":"2025-03-17T21:23:07.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3556672,"change_date":"2023-01-31 21:42:00","inspection_id":"77672060","insp_unit_id":"193143332","insp_unit_type_id":"3","insp_unit_number":"1","insp_unit_make":"FRT","insp_unit_company":"134019","insp_unit_license":"2240828","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKBGBDVXFSGN6770","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:31.000000Z","updated_at":"2025-03-17T22:31:31.000000Z"},{"id":3556673,"change_date":"2023-01-31 21:42:00","inspection_id":"77672060","insp_unit_id":"193143333","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KID","insp_unit_company":"3228","insp_unit_license":"P590113","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"52616281XH5000059","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:31.000000Z","updated_at":"2025-03-17T22:31:31.000000Z"}]},{"id":1814329,"change_date":"2022-12-15 21:38:00","inspection_id":"77219793","dot_number":"596882","report_state":"CT","report_number":"3132003386","insp_date":"2022-11-28 00:00:00","insp_start_time":"1442","insp_end_time":"1527","registration_date":"2022-12-14 00:00:00","region":"ET","ci_status_code":"C","location":"064","location_desc":"HARTFORD","county_code_state":"CT","county_code":"003","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"659866","transaction_code":"C","transaction_date":"2022-11-28 00:00:00","upload_date":"2022-12-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00596882","upload_search_indicator":null,"census_search_date":"2022-11-28 21:40:00","snet_input_date":"2022-11-28 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-11-28 21:40:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:00:01.000000Z","updated_at":"2025-03-17T19:00:01.000000Z","inspection_violations":[{"id":2836589,"change_date":"2022-12-15 21:38:00","inspection_id":"77219793","insp_violation_id":"250110913","seq_no":"1","part_no":"393","part_no_section":"209(d)","insp_viol_unit":"1","insp_unit_id":"192437548","insp_violation_category_id":"21","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"Y9923533","created_at":"2025-03-17T21:20:25.000000Z","updated_at":"2025-03-17T21:20:25.000000Z","normalized_code":"393209D"},{"id":2836590,"change_date":"2022-12-15 21:38:00","inspection_id":"77219793","insp_violation_id":"250110914","seq_no":"2","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"192437548","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"Y9923533","created_at":"2025-03-17T21:20:25.000000Z","updated_at":"2025-03-17T21:20:25.000000Z","normalized_code":"39345D"},{"id":2836591,"change_date":"2022-12-15 21:38:00","inspection_id":"77219793","insp_violation_id":"250110915","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"192437549","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"Y9923533","created_at":"2025-03-17T21:20:25.000000Z","updated_at":"2025-03-17T21:20:25.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2918434,"change_date":"2022-12-15 21:38:00","inspection_id":"77219793","insp_unit_id":"192437548","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"2208904","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUBGBDVXCSBL4959","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:58.000000Z","updated_at":"2025-03-17T22:26:58.000000Z"},{"id":2918435,"change_date":"2022-12-15 21:38:00","inspection_id":"77219793","insp_unit_id":"192437549","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"V91112","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1GRAA84299S701672","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:58.000000Z","updated_at":"2025-03-17T22:26:58.000000Z"}]},{"id":1556986,"change_date":"2022-11-03 21:41:00","inspection_id":"76924309","dot_number":"596882","report_state":"CT","report_number":"3132003288","insp_date":"2022-10-20 00:00:00","insp_start_time":"0615","insp_end_time":"0646","registration_date":"2022-11-03 00:00:00","region":"ET","ci_status_code":"C","location":"146","location_desc":"VERNON","county_code_state":"CT","county_code":"013","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SYSCO CONNECTICUT LLC","shipping_paper_number":"354571526","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-10-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"46800","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":"656739","transaction_code":"C","transaction_date":"2022-10-20 00:00:00","upload_date":"2022-11-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00596882","upload_search_indicator":null,"census_search_date":"2022-10-20 21:40:00","snet_input_date":"2022-10-20 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-10-20 21:40:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:55:15.000000Z","updated_at":"2025-03-17T18:55:15.000000Z","inspection_violations":[{"id":2448595,"change_date":"2022-11-03 21:41:00","inspection_id":"76924309","insp_violation_id":"249409378","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191784128","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:18:27.000000Z","updated_at":"2025-03-17T21:18:27.000000Z","normalized_code":"3939A"},{"id":2448596,"change_date":"2022-11-03 21:41:00","inspection_id":"76924309","insp_violation_id":"249409379","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191784128","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:27.000000Z","updated_at":"2025-03-17T21:18:27.000000Z","normalized_code":"3939A"},{"id":2448597,"change_date":"2022-11-03 21:41:00","inspection_id":"76924309","insp_violation_id":"249409380","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"191784128","insp_violation_category_id":"18","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"Y9918040","created_at":"2025-03-17T21:18:27.000000Z","updated_at":"2025-03-17T21:18:27.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":2505418,"change_date":"2022-11-03 21:41:00","inspection_id":"76924309","insp_unit_id":"191784128","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"2962637","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HAEVTARXLL284827","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:11.000000Z","updated_at":"2025-03-17T22:24:11.000000Z"}]},{"id":1129577,"change_date":"2022-09-15 21:39:00","inspection_id":"76428765","dot_number":"596882","report_state":"CT","report_number":"3070003752","insp_date":"2022-08-24 00:00:00","insp_start_time":"1905","insp_end_time":"1955","registration_date":"2022-09-15 00:00:00","region":"ET","ci_status_code":"C","location":"034S","location_desc":"DANBURY SCALE","county_code_state":"CT","county_code":"001","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"FREDDY RESTURANT","shipping_paper_number":"0681831","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-25 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"37400","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"652591","transaction_code":"C","transaction_date":"2022-08-24 00:00:00","upload_date":"2022-09-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00596882","upload_search_indicator":null,"census_search_date":"2022-08-25 21:42:00","snet_input_date":"2022-08-24 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-08-25 21:42:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:47:34.000000Z","updated_at":"2025-03-17T18:47:34.000000Z","inspection_violations":[{"id":1784706,"change_date":"2022-09-15 21:39:00","inspection_id":"76428765","insp_violation_id":"248424453","seq_no":"1","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"190909303","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:19.000000Z","updated_at":"2025-03-17T21:15:19.000000Z","normalized_code":"39345D"},{"id":1784707,"change_date":"2022-09-15 21:39:00","inspection_id":"76428765","insp_violation_id":"248424454","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"190909303","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:15:19.000000Z","updated_at":"2025-03-17T21:15:19.000000Z","normalized_code":"3963A1"},{"id":1784708,"change_date":"2022-09-15 21:39:00","inspection_id":"76428765","insp_violation_id":"248424455","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"190909304","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:19.000000Z","updated_at":"2025-03-17T21:15:19.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1816870,"change_date":"2022-09-15 21:39:00","inspection_id":"76428765","insp_unit_id":"190909303","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"2342148","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUBC5DV7HHJB3626","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:32.000000Z","updated_at":"2025-03-17T22:19:32.000000Z"},{"id":1816871,"change_date":"2022-09-15 21:39:00","inspection_id":"76428765","insp_unit_id":"190909304","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"V99602","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1GRAA5615CB701436","insp_unit_decal":"Y","insp_unit_decal_number":"31730630","created_at":"2025-03-17T22:19:32.000000Z","updated_at":"2025-03-17T22:19:32.000000Z"}]},{"id":49077,"change_date":"2022-04-22 21:41:00","inspection_id":"75148115","dot_number":"596882","report_state":"RI","report_number":"00SP002209","insp_date":"2022-03-26 00:00:00","insp_start_time":"1231","insp_end_time":"1251","registration_date":"2022-04-19 00:00:00","region":"ET","ci_status_code":"C","location":"66","location_desc":"RT 95S @ AIRPORT CONNECTOR","county_code_state":"RI","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-04-22 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":"76153","transaction_code":"C","transaction_date":"2022-04-22 00:00:00","upload_date":"2022-04-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00596882","upload_search_indicator":"M","census_search_date":"2022-04-22 21:41:00","snet_input_date":"2022-03-28 00:00:00","source_office":"1RIS001","mcmis_add_date":"2022-03-28 21:40:00","insp_carrier_name":"SYSCO CONNECTICUT LLC","insp_carrier_street":"100 INWOOD ROAD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:28:26.000000Z","updated_at":"2025-03-17T18:28:26.000000Z","inspection_violations":[{"id":69842,"change_date":"2022-04-22 21:41:00","inspection_id":"75148115","insp_violation_id":"245315234","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:26.000000Z","updated_at":"2025-03-17T21:07:26.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":79045,"change_date":"2022-04-22 21:41:00","inspection_id":"75148115","insp_unit_id":"188288967","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"2987448","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HSDXTZN1NN375043","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:44.000000Z","updated_at":"2025-03-17T22:08:44.000000Z"},{"id":79046,"change_date":"2022-04-22 21:41:00","inspection_id":"75148115","insp_unit_id":"188288968","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"V98744","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1GRAA7625BB707174","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:44.000000Z","updated_at":"2025-03-17T22:08:44.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/596882\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/596882\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/596882\/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\/596882\/inspections","per_page":100,"prev_page_url":null,"to":72,"total":72}