{"current_page":1,"data":[{"id":11469527,"change_date":"2026-03-27 21:39:00","inspection_id":"87388013","dot_number":"630371","report_state":"CT","report_number":"3025006307","insp_date":"2026-03-25 00:00:00","insp_start_time":"1006","insp_end_time":"1026","registration_date":"2026-03-27 00:00:00","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":"G & G BEVERAGE DISTRIBUTORS INC","shipping_paper_number":"80608","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-25 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"768695","transaction_code":"C","transaction_date":"2026-03-25 00:00:00","upload_date":"2026-03-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00630371","upload_search_indicator":null,"census_search_date":"2026-03-25 21:39:00","snet_input_date":"2026-03-25 00:00:00","source_office":"1CTS001","mcmis_add_date":"2026-03-25 21:39:00","insp_carrier_name":"G & G BEVERAGE DISTRIBUTORS INC","insp_carrier_street":"207 CHURCH STREET","insp_carrier_city":"WALLINGFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06492","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-28T09:44:32.000000Z","updated_at":"2026-04-07T09:30:04.000000Z","inspection_violations":[{"id":19406445,"change_date":"2026-03-27 21:39:00","inspection_id":"87388013","insp_violation_id":"272674423","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":null,"created_at":"2026-03-30T10:19:35.000000Z","updated_at":"2026-04-07T09:46:16.000000Z","normalized_code":"3922SLLS3"},{"id":19406446,"change_date":"2026-03-27 21:39:00","inspection_id":"87388013","insp_violation_id":"272674424","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"212367191","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-30T10:19:35.000000Z","updated_at":"2026-04-07T09:46:16.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":19688712,"change_date":"2026-03-27 21:39:00","inspection_id":"87388013","insp_unit_id":"212367191","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"156","insp_unit_license":"AE04716","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FVACWDT7BDAW7667","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-30T09:33:11.000000Z","updated_at":"2026-04-07T09:06:05.000000Z"}]},{"id":11261681,"change_date":"2026-03-08 21:33:00","inspection_id":"87175495","dot_number":"630371","report_state":"CT","report_number":"3120005866","insp_date":"2026-03-02 00:00:00","insp_start_time":"0851","insp_end_time":"0932","registration_date":"2026-03-06 00:00:00","region":"ET","ci_status_code":"C","location":"014","location_desc":"BRANFORD","county_code_state":"CT","county_code":"009","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"G & G BEVERAGE DISTRIBUTORS INC","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-02 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"766663","transaction_code":"C","transaction_date":"2026-03-02 00:00:00","upload_date":"2026-03-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00630371","upload_search_indicator":null,"census_search_date":"2026-03-02 21:37:00","snet_input_date":"2026-03-02 00:00:00","source_office":"1CTS001","mcmis_add_date":"2026-03-02 21:37:00","insp_carrier_name":"G & G BEVERAGE DISTRIBUTORS INC","insp_carrier_street":"207 CHURCH STREET","insp_carrier_city":"WALLINGFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06492","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-05T10:38:49.000000Z","updated_at":"2026-03-19T09:30:05.000000Z","inspection_violations":[{"id":19049557,"change_date":"2026-03-08 21:33:00","inspection_id":"87175495","insp_violation_id":"272275818","seq_no":"1","part_no":"391","part_no_section":"41A-MCPC","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":"2026-03-11T09:54:15.000000Z","updated_at":"2026-03-19T09:38:04.000000Z","normalized_code":"39141AMCPC"},{"id":19049558,"change_date":"2026-03-08 21:33:00","inspection_id":"87175495","insp_violation_id":"272275819","seq_no":"2","part_no":"392","part_no_section":"2-SLLSIV","insp_viol_unit":"1","insp_unit_id":"212031712","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-11T09:54:15.000000Z","updated_at":"2026-03-19T09:38:04.000000Z","normalized_code":"3922SLLSIV"}],"inspection_per_units":[{"id":19364759,"change_date":"2026-03-08 21:33:00","inspection_id":"87175495","insp_unit_id":"212031712","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"178","insp_unit_license":"AE53464","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FVACWDT19HAD3223","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-11T09:13:26.000000Z","updated_at":"2026-03-19T09:02:03.000000Z"}]},{"id":8527718,"change_date":"2025-05-13 21:40:00","inspection_id":"84559430","dot_number":"630371","report_state":"CT","report_number":"3070006945","insp_date":"2025-05-02 00:00:00","insp_start_time":"1535","insp_end_time":"1555","registration_date":"2025-05-13 00:00:00","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":"CARRIER","shipping_paper_number":"731554","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.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-05-02 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"739202","transaction_code":"C","transaction_date":"2025-05-02 00:00:00","upload_date":"2025-05-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00630371","upload_search_indicator":null,"census_search_date":"2025-05-02 21:40:00","snet_input_date":"2025-05-02 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-05-02 21:40:00","insp_carrier_name":"G & G BEVERAGE DISTRIBUTORS INC","insp_carrier_street":"207 CHURCH STREET","insp_carrier_city":"WALLINGFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06492","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-05T10:15:08.000000Z","updated_at":"2025-05-17T10:07:15.000000Z","inspection_violations":[{"id":13689197,"change_date":"2025-05-13 21:40:00","inspection_id":"84559430","insp_violation_id":"266177323","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-05-16T10:30:39.000000Z","updated_at":"2025-05-18T10:19:21.000000Z","normalized_code":"39216D"},{"id":13689198,"change_date":"2025-05-13 21:40:00","inspection_id":"84559430","insp_violation_id":"266177324","seq_no":"2","part_no":"391","part_no_section":"41A-MCPC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-16T10:30:39.000000Z","updated_at":"2025-05-18T10:19:21.000000Z","normalized_code":"39141AMCPC"}],"inspection_per_units":[{"id":14060429,"change_date":"2025-05-13 21:40:00","inspection_id":"84559430","insp_unit_id":"206818866","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BA81657","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FVACWDT9BDAW7668","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-16T09:49:20.000000Z","updated_at":"2025-05-17T09:48:33.000000Z"}]},{"id":5364272,"change_date":"2024-04-02 21:41:00","inspection_id":"81190649","dot_number":"630371","report_state":"CT","report_number":"3016000852","insp_date":"2024-03-26 00:00:00","insp_start_time":"0538","insp_end_time":"0634","registration_date":"2024-04-02 00:00:00","region":"ET","ci_status_code":"C","location":"101","location_desc":"RT 40 COM LOT NORTH HAVEN","county_code_state":"CT","county_code":"009","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"BUFFALO WILD","shipping_paper_number":"49854","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.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-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"9","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"9","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"703265","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":"00630371","upload_search_indicator":null,"census_search_date":"2024-03-26 21:42:00","snet_input_date":"2024-03-26 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-03-26 21:42:00","insp_carrier_name":"G & G BEVERAGE DISTRIBUTORS INC","insp_carrier_street":"207 CHURCH STREET","insp_carrier_city":"WALLINGFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06492","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:09:02.000000Z","updated_at":"2025-03-17T20:09:02.000000Z","inspection_violations":[{"id":8278224,"change_date":"2024-04-02 21:41:00","inspection_id":"81190649","insp_violation_id":"258692187","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"200186787","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:01.000000Z","updated_at":"2025-03-17T21:46:01.000000Z","normalized_code":"39378"},{"id":8278225,"change_date":"2024-04-02 21:41:00","inspection_id":"81190649","insp_violation_id":"258692188","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200186787","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:01.000000Z","updated_at":"2025-03-17T21:46:01.000000Z","normalized_code":"3939A"},{"id":8278226,"change_date":"2024-04-02 21:41:00","inspection_id":"81190649","insp_violation_id":"258692189","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200186787","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:01.000000Z","updated_at":"2025-03-17T21:46:01.000000Z","normalized_code":"3939A"},{"id":8278227,"change_date":"2024-04-02 21:41:00","inspection_id":"81190649","insp_violation_id":"258692190","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200186787","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:01.000000Z","updated_at":"2025-03-17T21:46:01.000000Z","normalized_code":"3939A"},{"id":8278228,"change_date":"2024-04-02 21:41:00","inspection_id":"81190649","insp_violation_id":"258692191","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200186787","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:01.000000Z","updated_at":"2025-03-17T21:46:01.000000Z","normalized_code":"3939A"},{"id":8278229,"change_date":"2024-04-02 21:41:00","inspection_id":"81190649","insp_violation_id":"258692192","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200186787","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:46:01.000000Z","updated_at":"2025-03-17T21:46:01.000000Z","normalized_code":"3939A"},{"id":8278230,"change_date":"2024-04-02 21:41:00","inspection_id":"81190649","insp_violation_id":"258692193","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200186787","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:01.000000Z","updated_at":"2025-03-17T21:46:01.000000Z","normalized_code":"3939A"},{"id":8278231,"change_date":"2024-04-02 21:41:00","inspection_id":"81190649","insp_violation_id":"258692194","seq_no":"8","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"200186787","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:46:01.000000Z","updated_at":"2025-03-17T21:46:01.000000Z","normalized_code":"3963A1"},{"id":8278232,"change_date":"2024-04-02 21:41:00","inspection_id":"81190649","insp_violation_id":"258692195","seq_no":"9","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"200186787","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:46:01.000000Z","updated_at":"2025-03-17T21:46:01.000000Z","normalized_code":"39345"}],"inspection_per_units":[{"id":8639009,"change_date":"2024-04-02 21:41:00","inspection_id":"81190649","insp_unit_id":"200186787","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"155","insp_unit_license":"BA81657","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FVACWDT9BDAW7668","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:20.000000Z","updated_at":"2025-03-17T23:13:20.000000Z"}]},{"id":5013358,"change_date":"2024-02-27 21:38:00","inspection_id":"80807989","dot_number":"630371","report_state":"CT","report_number":"3076002704","insp_date":"2024-02-09 00:00:00","insp_start_time":"0717","insp_end_time":"0831","registration_date":"2024-02-27 00:00:00","region":"ET","ci_status_code":"C","location":"148","location_desc":"WALLINGFORD","county_code_state":"CT","county_code":"009","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"47976","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"9","oos_total":"2","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"8","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"699238","transaction_code":"C","transaction_date":"2024-02-09 00:00:00","upload_date":"2024-02-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00630371","upload_search_indicator":null,"census_search_date":"2024-02-09 21:40:00","snet_input_date":"2024-02-09 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-02-09 21:40:00","insp_carrier_name":"G & G BEVERAGE DISTRIBUTORS INC","insp_carrier_street":"207 CHURCH STREET","insp_carrier_city":"WALLINGFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06492","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:02:03.000000Z","updated_at":"2025-03-17T20:02:03.000000Z","inspection_violations":[{"id":7722827,"change_date":"2024-02-27 21:38:00","inspection_id":"80807989","insp_violation_id":"258047927","seq_no":"1","part_no":"393","part_no_section":"81","insp_viol_unit":"1","insp_unit_id":"199609041","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:22.000000Z","updated_at":"2025-03-17T21:43:22.000000Z","normalized_code":"39381"},{"id":7722828,"change_date":"2024-02-27 21:38:00","inspection_id":"80807989","insp_violation_id":"258047928","seq_no":"2","part_no":"393","part_no_section":"55(d)(1)","insp_viol_unit":"1","insp_unit_id":"199609041","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:22.000000Z","updated_at":"2025-03-17T21:43:22.000000Z","normalized_code":"39355D1"},{"id":7722829,"change_date":"2024-02-27 21:38:00","inspection_id":"80807989","insp_violation_id":"258047929","seq_no":"3","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"199609041","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:22.000000Z","updated_at":"2025-03-17T21:43:22.000000Z","normalized_code":"39347E"},{"id":7722830,"change_date":"2024-02-27 21:38:00","inspection_id":"80807989","insp_violation_id":"258047930","seq_no":"4","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"199609041","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:22.000000Z","updated_at":"2025-03-17T21:43:22.000000Z","normalized_code":"39353B"},{"id":7722831,"change_date":"2024-02-27 21:38:00","inspection_id":"80807989","insp_violation_id":"258047931","seq_no":"5","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"199609041","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"V126219 4","created_at":"2025-03-17T21:43:22.000000Z","updated_at":"2025-03-17T21:43:22.000000Z","normalized_code":"3963A1"},{"id":7722832,"change_date":"2024-02-27 21:38:00","inspection_id":"80807989","insp_violation_id":"258047932","seq_no":"6","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199609041","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V126219 4","created_at":"2025-03-17T21:43:22.000000Z","updated_at":"2025-03-17T21:43:22.000000Z","normalized_code":"3922"},{"id":7722833,"change_date":"2024-02-27 21:38:00","inspection_id":"80807989","insp_violation_id":"258047933","seq_no":"7","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199609041","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V126219 4","created_at":"2025-03-17T21:43:22.000000Z","updated_at":"2025-03-17T21:43:22.000000Z","normalized_code":"3922"},{"id":7722834,"change_date":"2024-02-27 21:38:00","inspection_id":"80807989","insp_violation_id":"258047934","seq_no":"9","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:43:22.000000Z","updated_at":"2025-03-17T21:43:22.000000Z","normalized_code":"38323A2"},{"id":7722835,"change_date":"2024-02-27 21:38:00","inspection_id":"80807989","insp_violation_id":"258047935","seq_no":"8","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199609041","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V126219 4","created_at":"2025-03-17T21:43:22.000000Z","updated_at":"2025-03-17T21:43:22.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8069052,"change_date":"2024-02-27 21:38:00","inspection_id":"80807989","insp_unit_id":"199609041","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"145","insp_unit_license":"K88377","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1GBK7C1364F508401","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:07.000000Z","updated_at":"2025-03-17T23:08:07.000000Z"}]},{"id":4947803,"change_date":"2024-02-13 21:41:00","inspection_id":"80736115","dot_number":"630371","report_state":"CT","report_number":"3090003739","insp_date":"2024-01-31 00:00:00","insp_start_time":"0647","insp_end_time":"0735","registration_date":"2024-02-09 00:00:00","region":"ET","ci_status_code":"C","location":"148","location_desc":"WALLINGFORD","county_code_state":"CT","county_code":"009","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SELF","shipping_paper_number":"GENERIC","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"5","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"698360","transaction_code":"C","transaction_date":"2024-01-31 00:00:00","upload_date":"2024-02-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00630371","upload_search_indicator":null,"census_search_date":"2024-02-01 21:42:00","snet_input_date":"2024-01-31 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-02-01 21:42:00","insp_carrier_name":"G & G BEVERAGE DISTRIBUTORS INC","insp_carrier_street":"207 CHURCH STREET","insp_carrier_city":"WALLINGFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06492","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:00:49.000000Z","updated_at":"2025-03-17T20:00:49.000000Z","inspection_violations":[{"id":7620851,"change_date":"2024-02-13 21:41:00","inspection_id":"80736115","insp_violation_id":"257800373","seq_no":"1","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":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:50.000000Z","updated_at":"2025-03-17T21:42:50.000000Z","normalized_code":"39141A1"},{"id":7620852,"change_date":"2024-02-13 21:41:00","inspection_id":"80736115","insp_violation_id":"257800374","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199390244","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:50.000000Z","updated_at":"2025-03-17T21:42:50.000000Z","normalized_code":"3939A"},{"id":7620853,"change_date":"2024-02-13 21:41:00","inspection_id":"80736115","insp_violation_id":"257800375","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199390244","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:50.000000Z","updated_at":"2025-03-17T21:42:50.000000Z","normalized_code":"3939A"},{"id":7620854,"change_date":"2024-02-13 21:41:00","inspection_id":"80736115","insp_violation_id":"257800376","seq_no":"4","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"199390244","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:50.000000Z","updated_at":"2025-03-17T21:42:50.000000Z","normalized_code":"39345D"},{"id":7620855,"change_date":"2024-02-13 21:41:00","inspection_id":"80736115","insp_violation_id":"257800377","seq_no":"5","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"199390244","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:50.000000Z","updated_at":"2025-03-17T21:42:50.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":7962586,"change_date":"2024-02-13 21:41:00","inspection_id":"80736115","insp_unit_id":"199390244","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"177","insp_unit_license":"AE53463","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FVACXBS5DHBZ7782","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:10.000000Z","updated_at":"2025-03-17T23:07:10.000000Z"}]},{"id":4659685,"change_date":"2024-01-05 21:45:00","inspection_id":"80421292","dot_number":"630371","report_state":"CT","report_number":"3019005038","insp_date":"2023-12-19 00:00:00","insp_start_time":"0705","insp_end_time":"0759","registration_date":"2024-01-05 00:00:00","region":"ET","ci_status_code":"C","location":"148","location_desc":"WALLINGFORD","county_code_state":"CT","county_code":"009","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-12-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"8","oos_total":"2","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"7","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"694772","transaction_code":"C","transaction_date":"2023-12-19 00:00:00","upload_date":"2024-01-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00630371","upload_search_indicator":null,"census_search_date":"2023-12-19 21:40:00","snet_input_date":"2023-12-19 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-12-19 21:40:00","insp_carrier_name":"G & G BEVERAGE DISTRIBUTORS INC","insp_carrier_street":"207 CHURCH STREET","insp_carrier_city":"WALLINGFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06492","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:55:01.000000Z","updated_at":"2025-03-17T19:55:01.000000Z","inspection_violations":[{"id":7204530,"change_date":"2024-01-05 21:45:00","inspection_id":"80421292","insp_violation_id":"257198407","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:40:49.000000Z","updated_at":"2025-03-17T21:40:49.000000Z","normalized_code":"38323A2"},{"id":7204531,"change_date":"2024-01-05 21:45:00","inspection_id":"80421292","insp_violation_id":"257198408","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198825569","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:49.000000Z","updated_at":"2025-03-17T21:40:49.000000Z","normalized_code":"3922"},{"id":7204532,"change_date":"2024-01-05 21:45:00","inspection_id":"80421292","insp_violation_id":"257198409","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"198825569","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"V125550-0","created_at":"2025-03-17T21:40:49.000000Z","updated_at":"2025-03-17T21:40:49.000000Z","normalized_code":"3963A1"},{"id":7204533,"change_date":"2024-01-05 21:45:00","inspection_id":"80421292","insp_violation_id":"257198410","seq_no":"4","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"198825569","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:49.000000Z","updated_at":"2025-03-17T21:40:49.000000Z","normalized_code":"39347E"},{"id":7204534,"change_date":"2024-01-05 21:45:00","inspection_id":"80421292","insp_violation_id":"257198411","seq_no":"5","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"198825569","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:49.000000Z","updated_at":"2025-03-17T21:40:49.000000Z","normalized_code":"39353B"},{"id":7204535,"change_date":"2024-01-05 21:45:00","inspection_id":"80421292","insp_violation_id":"257198412","seq_no":"6","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198825569","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V125550-0","created_at":"2025-03-17T21:40:49.000000Z","updated_at":"2025-03-17T21:40:49.000000Z","normalized_code":"3922"},{"id":7204536,"change_date":"2024-01-05 21:45:00","inspection_id":"80421292","insp_violation_id":"257198413","seq_no":"7","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198825569","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V125550-0","created_at":"2025-03-17T21:40:49.000000Z","updated_at":"2025-03-17T21:40:49.000000Z","normalized_code":"3922"},{"id":7204537,"change_date":"2024-01-05 21:45:00","inspection_id":"80421292","insp_violation_id":"257198414","seq_no":"8","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198825569","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V125550-0","created_at":"2025-03-17T21:40:49.000000Z","updated_at":"2025-03-17T21:40:49.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7494744,"change_date":"2024-01-05 21:45:00","inspection_id":"80421292","insp_unit_id":"198825569","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"130","insp_unit_license":"K88378","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FVACXCS86HW83582","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:59.000000Z","updated_at":"2025-03-17T23:02:59.000000Z"}]},{"id":4436959,"change_date":"2023-12-05 21:42:00","inspection_id":"80176587","dot_number":"630371","report_state":"CT","report_number":"3011000624","insp_date":"2023-11-16 00:00:00","insp_start_time":"0703","insp_end_time":"0806","registration_date":"2023-12-05 00:00:00","region":"ET","ci_status_code":"C","location":"148","location_desc":"WALLINGFORD","county_code_state":"CT","county_code":"009","insp_level_id":"2","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":"2023-11-16 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"6","oos_total":"2","driver_viol_total":"2","driver_oos_total":"2","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"691985","transaction_code":"C","transaction_date":"2023-11-16 00:00:00","upload_date":"2023-12-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00630371","upload_search_indicator":null,"census_search_date":"2023-11-16 21:42:00","snet_input_date":"2023-11-16 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-11-16 21:42:00","insp_carrier_name":"G & G BEVERAGE DISTRIBUTORS INC","insp_carrier_street":"207 CHURCH STREET","insp_carrier_city":"WALLINGFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06492","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:50:45.000000Z","updated_at":"2025-03-17T19:50:45.000000Z","inspection_violations":[{"id":6867351,"change_date":"2023-12-05 21:42:00","inspection_id":"80176587","insp_violation_id":"256705579","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:39:06.000000Z","updated_at":"2025-03-17T21:39:06.000000Z","normalized_code":"39111B4"},{"id":6867352,"change_date":"2023-12-05 21:42:00","inspection_id":"80176587","insp_violation_id":"256705580","seq_no":"2","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:06.000000Z","updated_at":"2025-03-17T21:39:06.000000Z","normalized_code":"38323A2"},{"id":6867353,"change_date":"2023-12-05 21:42:00","inspection_id":"80176587","insp_violation_id":"256705581","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198343146","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V125011-0","created_at":"2025-03-17T21:39:06.000000Z","updated_at":"2025-03-17T21:39:06.000000Z","normalized_code":"3922"},{"id":6867354,"change_date":"2023-12-05 21:42:00","inspection_id":"80176587","insp_violation_id":"256705582","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198343146","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V125011-0","created_at":"2025-03-17T21:39:06.000000Z","updated_at":"2025-03-17T21:39:06.000000Z","normalized_code":"3922"},{"id":6867355,"change_date":"2023-12-05 21:42:00","inspection_id":"80176587","insp_violation_id":"256705583","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198343146","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V125011-0","created_at":"2025-03-17T21:39:06.000000Z","updated_at":"2025-03-17T21:39:06.000000Z","normalized_code":"3922"},{"id":6867356,"change_date":"2023-12-05 21:42:00","inspection_id":"80176587","insp_violation_id":"256705584","seq_no":"6","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"198343146","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:06.000000Z","updated_at":"2025-03-17T21:39:06.000000Z","normalized_code":"39345D"}],"inspection_per_units":[{"id":7135335,"change_date":"2023-12-05 21:42:00","inspection_id":"80176587","insp_unit_id":"198343146","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"156","insp_unit_license":"AE04716","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FVACWDT7BDAW7667","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":4436971,"change_date":"2024-01-23 21:44:00","inspection_id":"80176603","dot_number":"630371","report_state":"CT","report_number":"3019004938","insp_date":"2023-11-16 00:00:00","insp_start_time":"0706","insp_end_time":"0726","registration_date":"2024-01-23 00:00:00","region":"ET","ci_status_code":"C","location":"148","location_desc":"WALLINGFORD","county_code_state":"CT","county_code":"009","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-16 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"3","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"691983","transaction_code":"C","transaction_date":"2023-12-14 00:00:00","upload_date":"2024-01-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00630371","upload_search_indicator":null,"census_search_date":"2023-11-16 21:42:00","snet_input_date":"2023-11-16 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-11-16 21:42:00","insp_carrier_name":"G & G BEVERAGE DISTRIBUTORS INC","insp_carrier_street":"207 CHURCH STREET","insp_carrier_city":"WALLINGFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06492","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:50:45.000000Z","updated_at":"2025-03-17T19:50:45.000000Z","inspection_violations":[{"id":6867374,"change_date":"2024-01-23 21:44:00","inspection_id":"80176603","insp_violation_id":"257444629","seq_no":"1","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:39:06.000000Z","updated_at":"2025-03-17T21:39:06.000000Z","normalized_code":"39141A1"},{"id":6867375,"change_date":"2024-01-23 21:44:00","inspection_id":"80176603","insp_violation_id":"257444630","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"199061321","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:06.000000Z","updated_at":"2025-03-17T21:39:06.000000Z","normalized_code":"39617C"},{"id":6867376,"change_date":"2024-01-23 21:44:00","inspection_id":"80176603","insp_violation_id":"257444631","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199061321","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V125008-4","created_at":"2025-03-17T21:39:06.000000Z","updated_at":"2025-03-17T21:39:06.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7135353,"change_date":"2024-01-23 21:44:00","inspection_id":"80176603","insp_unit_id":"199061321","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"151","insp_unit_license":"L26032","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1GBK7C1307F412140","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":3884951,"change_date":"2023-09-11 21:39:00","inspection_id":"79564808","dot_number":"630371","report_state":"CT","report_number":"3019004729","insp_date":"2023-09-01 00:00:00","insp_start_time":"0702","insp_end_time":"0804","registration_date":"2023-09-11 00:00:00","region":"ET","ci_status_code":"C","location":"148","location_desc":"WALLINGFORD","county_code_state":"CT","county_code":"009","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-01 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"12","oos_total":"4","driver_viol_total":"3","driver_oos_total":"3","vehicle_viol_total":"9","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"685038","transaction_code":"C","transaction_date":"2023-09-01 00:00:00","upload_date":"2023-09-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00630371","upload_search_indicator":null,"census_search_date":"2023-09-01 21:38:00","snet_input_date":"2023-09-01 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-09-01 21:38:00","insp_carrier_name":"G & G BEVERAGE DISTRIBUTORS INC","insp_carrier_street":"207 CHURCH STREET","insp_carrier_city":"WALLINGFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06492","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:39:41.000000Z","updated_at":"2025-03-17T19:39:41.000000Z","inspection_violations":[{"id":6003988,"change_date":"2023-09-11 21:39:00","inspection_id":"79564808","insp_violation_id":"255179543","seq_no":"1","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":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:05.000000Z","updated_at":"2025-03-17T21:35:05.000000Z","normalized_code":"39141A1"},{"id":6003989,"change_date":"2023-09-11 21:39:00","inspection_id":"79564808","insp_violation_id":"255179544","seq_no":"2","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:35:05.000000Z","updated_at":"2025-03-17T21:35:05.000000Z","normalized_code":"39111B4"},{"id":6003990,"change_date":"2023-09-11 21:39:00","inspection_id":"79564808","insp_violation_id":"255179545","seq_no":"3","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:35:05.000000Z","updated_at":"2025-03-17T21:35:05.000000Z","normalized_code":"38323A2"},{"id":6003991,"change_date":"2023-09-11 21:39:00","inspection_id":"79564808","insp_violation_id":"255179546","seq_no":"4","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"196979389","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:05.000000Z","updated_at":"2025-03-17T21:35:05.000000Z","normalized_code":"39347E"},{"id":6003992,"change_date":"2023-09-11 21:39:00","inspection_id":"79564808","insp_violation_id":"255179547","seq_no":"5","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"196979389","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:05.000000Z","updated_at":"2025-03-17T21:35:05.000000Z","normalized_code":"39353B"},{"id":6003993,"change_date":"2023-09-11 21:39:00","inspection_id":"79564808","insp_violation_id":"255179548","seq_no":"6","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"196979389","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:05.000000Z","updated_at":"2025-03-17T21:35:05.000000Z","normalized_code":"39347E"},{"id":6003994,"change_date":"2023-09-11 21:39:00","inspection_id":"79564808","insp_violation_id":"255179549","seq_no":"7","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"196979389","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"Y998791-1","created_at":"2025-03-17T21:35:05.000000Z","updated_at":"2025-03-17T21:35:05.000000Z","normalized_code":"3963A1"},{"id":6003995,"change_date":"2023-09-11 21:39:00","inspection_id":"79564808","insp_violation_id":"255179550","seq_no":"8","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"196979389","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:05.000000Z","updated_at":"2025-03-17T21:35:05.000000Z","normalized_code":"39345D"},{"id":6003996,"change_date":"2023-09-11 21:39:00","inspection_id":"79564808","insp_violation_id":"255179551","seq_no":"9","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196979389","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"Y998791-1","created_at":"2025-03-17T21:35:05.000000Z","updated_at":"2025-03-17T21:35:05.000000Z","normalized_code":"3922"},{"id":6003997,"change_date":"2023-09-11 21:39:00","inspection_id":"79564808","insp_violation_id":"255179552","seq_no":"10","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196979389","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"Y998791-1","created_at":"2025-03-17T21:35:05.000000Z","updated_at":"2025-03-17T21:35:05.000000Z","normalized_code":"3922"},{"id":6003998,"change_date":"2023-09-11 21:39:00","inspection_id":"79564808","insp_violation_id":"255179553","seq_no":"11","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196979389","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"Y998791-1","created_at":"2025-03-17T21:35:05.000000Z","updated_at":"2025-03-17T21:35:05.000000Z","normalized_code":"3922"},{"id":6003999,"change_date":"2023-09-11 21:39:00","inspection_id":"79564808","insp_violation_id":"255179554","seq_no":"12","part_no":"396","part_no_section":"9(d)(2)","insp_viol_unit":"1","insp_unit_id":"196979389","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:05.000000Z","updated_at":"2025-03-17T21:35:05.000000Z","normalized_code":"3969D2"}],"inspection_per_units":[{"id":6245992,"change_date":"2023-09-11 21:39:00","inspection_id":"79564808","insp_unit_id":"196979389","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"156","insp_unit_license":"AE04716","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FVACWDT7BDAW7667","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:29.000000Z","updated_at":"2025-03-17T22:52:29.000000Z"}]},{"id":3862752,"change_date":"2023-09-11 21:39:00","inspection_id":"79540113","dot_number":"630371","report_state":"CT","report_number":"3011000512","insp_date":"2023-08-29 00:00:00","insp_start_time":"0652","insp_end_time":"0734","registration_date":"2023-09-11 00:00:00","region":"ET","ci_status_code":"C","location":"148","location_desc":"WALLINGFORD","county_code_state":"CT","county_code":"009","insp_level_id":"2","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":"2023-08-30 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"684826","transaction_code":"C","transaction_date":"2023-08-29 00:00:00","upload_date":"2023-09-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00630371","upload_search_indicator":null,"census_search_date":"2023-08-30 21:43:00","snet_input_date":"2023-08-29 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-08-30 21:43:00","insp_carrier_name":"G & G BEVERAGE DISTRIBUTORS INC","insp_carrier_street":"207 CHURCH STREET","insp_carrier_city":"WALLINGFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06492","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:39:20.000000Z","updated_at":"2025-03-17T19:39:20.000000Z","inspection_violations":[{"id":5965472,"change_date":"2023-09-11 21:39:00","inspection_id":"79540113","insp_violation_id":"255179862","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196979522","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:53.000000Z","updated_at":"2025-03-17T21:34:53.000000Z","normalized_code":"3939A"},{"id":5965473,"change_date":"2023-09-11 21:39:00","inspection_id":"79540113","insp_violation_id":"255179863","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196979522","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"Y998725-5","created_at":"2025-03-17T21:34:53.000000Z","updated_at":"2025-03-17T21:34:53.000000Z","normalized_code":"3922"},{"id":5965474,"change_date":"2023-09-11 21:39:00","inspection_id":"79540113","insp_violation_id":"255179864","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196979522","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"Y998725-5","created_at":"2025-03-17T21:34:53.000000Z","updated_at":"2025-03-17T21:34:53.000000Z","normalized_code":"3922"},{"id":5965475,"change_date":"2023-09-11 21:39:00","inspection_id":"79540113","insp_violation_id":"255179865","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196979522","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"Y998725-5","created_at":"2025-03-17T21:34:53.000000Z","updated_at":"2025-03-17T21:34:53.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6210387,"change_date":"2023-09-11 21:39:00","inspection_id":"79540113","insp_unit_id":"196979522","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"177","insp_unit_license":"AE53463","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FVACXBS5DHBZ7782","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:11.000000Z","updated_at":"2025-03-17T22:52:11.000000Z"}]},{"id":3626880,"change_date":"2023-07-31 21:40:00","inspection_id":"79276447","dot_number":"630371","report_state":"CT","report_number":"3070004986","insp_date":"2023-07-28 00:00:00","insp_start_time":"1719","insp_end_time":"1743","registration_date":null,"region":"ET","ci_status_code":"C","location":"008","location_desc":"BETHANY","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":"2023-07-31 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"681960","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":"00630371","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":"G & G BEVERAGE DISTRIBUTORS INC","insp_carrier_street":"207 CHURCH STREET","insp_carrier_city":"WALLINGFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06492","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":[{"id":5593229,"change_date":"2023-07-31 21:40:00","inspection_id":"79276447","insp_violation_id":"254360807","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:55.000000Z","updated_at":"2025-03-17T21:32:55.000000Z","normalized_code":"39216A"},{"id":5593230,"change_date":"2023-07-31 21:40:00","inspection_id":"79276447","insp_violation_id":"254360808","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":"Y","defect_verification_id":"3","citation_number":"Y998047-6","created_at":"2025-03-17T21:32:55.000000Z","updated_at":"2025-03-17T21:32:55.000000Z","normalized_code":"39141A1"}],"inspection_per_units":[{"id":5831450,"change_date":"2023-07-31 21:40:00","inspection_id":"79276447","insp_unit_id":"196266530","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"AU39537","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FVACWDT6CHBL8111","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":2712417,"change_date":"2023-04-20 21:41:00","inspection_id":"78245193","dot_number":"630371","report_state":"CT","report_number":"3129003884","insp_date":"2023-04-03 00:00:00","insp_start_time":"1020","insp_end_time":"1039","registration_date":"2023-04-20 00:00:00","region":"ET","ci_status_code":"C","location":"040","location_desc":"EAST GRANBY","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":"11110","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.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-03 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"671217","transaction_code":"C","transaction_date":"2023-04-03 00:00:00","upload_date":"2023-04-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00630371","upload_search_indicator":null,"census_search_date":"2023-04-03 21:39:00","snet_input_date":"2023-04-03 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-04-03 21:39:00","insp_carrier_name":"G & G BEVERAGE DISTRIBUTORS INC","insp_carrier_street":"207 CHURCH STREET","insp_carrier_city":"WALLINGFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06492","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:16:37.000000Z","updated_at":"2025-03-17T19:16:37.000000Z","inspection_violations":[{"id":4167155,"change_date":"2023-04-20 21:41:00","inspection_id":"78245193","insp_violation_id":"252330673","seq_no":"1","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:26:31.000000Z","updated_at":"2025-03-17T21:26:31.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":4365387,"change_date":"2023-04-20 21:41:00","inspection_id":"78245193","insp_unit_id":"194486755","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"AE11116","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3ALACWDT5DDFJ0254","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:23.000000Z","updated_at":"2025-03-17T22:37:23.000000Z"}]},{"id":1876116,"change_date":"2022-12-16 21:39:00","inspection_id":"77290278","dot_number":"630371","report_state":"CT","report_number":"0613000738","insp_date":"2022-12-06 00:00:00","insp_start_time":"1506","insp_end_time":"1519","registration_date":"2022-12-15 00:00:00","region":"ET","ci_status_code":"C","location":"151","location_desc":"I-84 EB EXIT 23","county_code_state":"CT","county_code":"009","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":"2022-12-06 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"660429","transaction_code":"C","transaction_date":"2022-12-06 00:00:00","upload_date":"2022-12-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00630371","upload_search_indicator":null,"census_search_date":"2022-12-06 21:39:00","snet_input_date":"2022-12-06 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-12-06 21:39:00","insp_carrier_name":"G & G BEVERAGE DISTRIBUTORS INC","insp_carrier_street":"207 CHURCH STREET","insp_carrier_city":"WALLINGFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06492","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:01:09.000000Z","updated_at":"2025-03-17T19:01:09.000000Z","inspection_violations":[{"id":2920663,"change_date":"2022-12-16 21:39:00","inspection_id":"77290278","insp_violation_id":"250126164","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:20:57.000000Z","updated_at":"2025-03-17T21:20:57.000000Z","normalized_code":"3922"},{"id":2920664,"change_date":"2022-12-16 21:39:00","inspection_id":"77290278","insp_violation_id":"250126165","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:20:57.000000Z","updated_at":"2025-03-17T21:20:57.000000Z","normalized_code":"39141A1"}],"inspection_per_units":[{"id":3019736,"change_date":"2022-12-16 21:39:00","inspection_id":"77290278","insp_unit_id":"192451147","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"AU39537","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FVACWDT6CHBL8111","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:40.000000Z","updated_at":"2025-03-17T22:27:40.000000Z"}]},{"id":274277,"change_date":"2022-04-28 21:39:00","inspection_id":"75420177","dot_number":"630371","report_state":"NY","report_number":"SPG0173905","insp_date":"2022-04-25 00:00:00","insp_start_time":"1321","insp_end_time":"1348","registration_date":null,"region":"ET","ci_status_code":"C","location":"10753A","location_desc":"SCHODACK (WB)","county_code_state":"NY","county_code":"083","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"G AND G BEVERAGE DISTRIBUTORS INC","shipping_paper_number":"853221","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.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-04-28 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"6","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2700053","transaction_code":"A","transaction_date":"2022-04-28 00:00:00","upload_date":"2022-04-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00630371","upload_search_indicator":"M","census_search_date":"2022-04-28 21:39:00","snet_input_date":"2022-04-28 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-04-28 21:39:00","insp_carrier_name":"G & G BEVERAGE DISTRIBUTORS INC","insp_carrier_street":"207 CHURCH ST","insp_carrier_city":"WALLINGFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06492-2203","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:32:15.000000Z","updated_at":"2025-03-17T18:32:15.000000Z","inspection_violations":[{"id":425197,"change_date":"2022-04-28 21:39:00","inspection_id":"75420177","insp_violation_id":"245434894","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:04.000000Z","updated_at":"2025-03-17T21:09:04.000000Z","normalized_code":"3922"},{"id":425198,"change_date":"2022-04-28 21:39:00","inspection_id":"75420177","insp_violation_id":"245434895","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:09:04.000000Z","updated_at":"2025-03-17T21:09:04.000000Z","normalized_code":"39141A"},{"id":425199,"change_date":"2022-04-28 21:39:00","inspection_id":"75420177","insp_violation_id":"245434896","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"188390089","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:04.000000Z","updated_at":"2025-03-17T21:09:04.000000Z","normalized_code":"3922"},{"id":425200,"change_date":"2022-04-28 21:39:00","inspection_id":"75420177","insp_violation_id":"245434897","seq_no":"4","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"188390089","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:04.000000Z","updated_at":"2025-03-17T21:09:04.000000Z","normalized_code":"39617C"},{"id":425201,"change_date":"2022-04-28 21:39:00","inspection_id":"75420177","insp_violation_id":"245434898","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"188390089","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:04.000000Z","updated_at":"2025-03-17T21:09:04.000000Z","normalized_code":"3922"},{"id":425202,"change_date":"2022-04-28 21:39:00","inspection_id":"75420177","insp_violation_id":"245434899","seq_no":"6","part_no":"999","part_no_section":null,"insp_viol_unit":"1","insp_unit_id":"188390089","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:04.000000Z","updated_at":"2025-03-17T21:09:04.000000Z","normalized_code":"999"}],"inspection_per_units":[{"id":444105,"change_date":"2022-04-28 21:39:00","inspection_id":"75420177","insp_unit_id":"188390089","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"AE11116","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3ALACWDT5DDFJ0254","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:55.000000Z","updated_at":"2025-03-17T22:10:55.000000Z"}]},{"id":199278,"change_date":"2022-05-02 21:40:00","inspection_id":"75330515","dot_number":"630371","report_state":"CT","report_number":"3070003248","insp_date":"2022-04-18 00:00:00","insp_start_time":"1435","insp_end_time":"1459","registration_date":"2022-04-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":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"--","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.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-04-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"4","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"642372","transaction_code":"C","transaction_date":"2022-04-18 00:00:00","upload_date":"2022-05-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00630371","upload_search_indicator":null,"census_search_date":"2022-04-19 21:41:00","snet_input_date":"2022-04-18 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-04-19 21:41:00","insp_carrier_name":"G & G BEVERAGE DISTRIBUTORS INC","insp_carrier_street":"207 CHURCH ST","insp_carrier_city":"WALLINGFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06492","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:30:55.000000Z","updated_at":"2025-03-17T18:30:55.000000Z","inspection_violations":[{"id":304886,"change_date":"2022-05-02 21:40:00","inspection_id":"75330515","insp_violation_id":"245499121","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:28.000000Z","updated_at":"2025-03-17T21:08:28.000000Z","normalized_code":"39216A"},{"id":304887,"change_date":"2022-05-02 21:40:00","inspection_id":"75330515","insp_violation_id":"245499122","seq_no":"2","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"188443379","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:28.000000Z","updated_at":"2025-03-17T21:08:28.000000Z","normalized_code":"39021TB"},{"id":304888,"change_date":"2022-05-02 21:40:00","inspection_id":"75330515","insp_violation_id":"245499123","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"188443379","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:28.000000Z","updated_at":"2025-03-17T21:08:28.000000Z","normalized_code":"39617C"},{"id":304889,"change_date":"2022-05-02 21:40:00","inspection_id":"75330515","insp_violation_id":"245499124","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"188443379","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:28.000000Z","updated_at":"2025-03-17T21:08:28.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":322862,"change_date":"2022-05-02 21:40:00","inspection_id":"75330515","insp_unit_id":"188443379","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"151","insp_unit_license":"L26032","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1GBK7C1307F412140","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:08.000000Z","updated_at":"2025-03-17T22:10:08.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/630371\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/630371\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/630371\/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\/630371\/inspections","per_page":100,"prev_page_url":null,"to":16,"total":16}