{"current_page":1,"data":[{"id":5249911,"change_date":"2024-03-15 21:39:00","inspection_id":"81065961","dot_number":"2338684","report_state":"CT","report_number":"3132004411","insp_date":"2024-03-08 00:00:00","insp_start_time":"1431","insp_end_time":"1441","registration_date":"2024-03-15 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":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-03-11 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"701777","transaction_code":"C","transaction_date":"2024-03-08 00:00:00","upload_date":"2024-03-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02338684","upload_search_indicator":null,"census_search_date":"2024-03-11 21:42:00","snet_input_date":"2024-03-08 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-03-11 21:42:00","insp_carrier_name":"CRAFT BEER GUILD DISTRIBUTING OF CONNECTICUT LLC","insp_carrier_street":"110 REPUBLIC DRIVE","insp_carrier_city":"NORTH HAVEN","insp_carrier_state":"CT","insp_carrier_zip_code":"06473","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:06:41.000000Z","updated_at":"2025-03-17T20:06:41.000000Z","inspection_violations":[{"id":8095785,"change_date":"2024-03-15 21:39:00","inspection_id":"81065961","insp_violation_id":"258397337","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:45:06.000000Z","updated_at":"2025-03-17T21:45:06.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":8453738,"change_date":"2024-03-15 21:39:00","inspection_id":"81065961","insp_unit_id":"199925749","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"L18036","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"5PVNJ8JT7D4S54832","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:35.000000Z","updated_at":"2025-03-17T23:11:35.000000Z"}]},{"id":5168965,"change_date":"2024-02-29 21:46:00","inspection_id":"80977356","dot_number":"2338684","report_state":"CT","report_number":"3070005736","insp_date":"2024-02-29 00:00:00","insp_start_time":"0606","insp_end_time":"0624","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":"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-02-29 21:46:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"700925","transaction_code":"A","transaction_date":"2024-02-29 00:00:00","upload_date":"2024-02-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02338684","upload_search_indicator":null,"census_search_date":"2024-02-29 21:46:00","snet_input_date":"2024-02-29 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-02-29 21:46:00","insp_carrier_name":"CRAFT BEER GUILD DISTRIBUTING OF CONNECTICUT LLC","insp_carrier_street":"110 REPUBLIC DRIVE","insp_carrier_city":"NORTH HAVEN","insp_carrier_state":"CT","insp_carrier_zip_code":"06473","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:04:58.000000Z","updated_at":"2025-03-17T20:04:58.000000Z","inspection_violations":[{"id":7965814,"change_date":"2024-02-29 21:46:00","inspection_id":"80977356","insp_violation_id":"258106861","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":"V126469-2","created_at":"2025-03-17T21:44:30.000000Z","updated_at":"2025-03-17T21:44:30.000000Z","normalized_code":"3922"},{"id":7965815,"change_date":"2024-02-29 21:46:00","inspection_id":"80977356","insp_violation_id":"258106862","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:44:30.000000Z","updated_at":"2025-03-17T21:44:30.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":8322103,"change_date":"2024-02-29 21:46:00","inspection_id":"80977356","insp_unit_id":"199667862","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"AE31436","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"5PVNJ8JV335S78880","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:25.000000Z","updated_at":"2025-03-17T23:10:25.000000Z"}]},{"id":2858025,"change_date":"2023-04-21 21:40:00","inspection_id":"78409889","dot_number":"2338684","report_state":"CT","report_number":"3016000326","insp_date":"2023-04-21 00:00:00","insp_start_time":"0858","insp_end_time":"0920","registration_date":null,"region":"ET","ci_status_code":"C","location":"080","location_desc":"I91 N\/B EXIT 17 MERIDEN","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":"ROUTE MANIFEST","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.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-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"53200","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":"672443","transaction_code":"A","transaction_date":"2023-04-21 00:00:00","upload_date":"2023-04-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02338684","upload_search_indicator":null,"census_search_date":"2023-04-21 21:40:00","snet_input_date":"2023-04-21 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-04-21 21:40:00","insp_carrier_name":"CRAFT BEER GUILD DISTRIBUTING OF CONNECTICUT LLC","insp_carrier_street":"110 REPUBLIC DRIVE","insp_carrier_city":"NORTH HAVEN","insp_carrier_state":"CT","insp_carrier_zip_code":"06473","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:19:19.000000Z","updated_at":"2025-03-17T19:19:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4598735,"change_date":"2023-04-21 21:40:00","inspection_id":"78409889","insp_unit_id":"194510123","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"8104337","insp_unit_license":"AU43203","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"2NKHLJ9X8GM485113","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:15.000000Z","updated_at":"2025-03-17T22:39:15.000000Z"}]},{"id":2548873,"change_date":"2023-03-16 21:42:00","inspection_id":"78058184","dot_number":"2338684","report_state":"CT","report_number":"3129003834","insp_date":"2023-03-10 00:00:00","insp_start_time":"0850","insp_end_time":"0908","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":"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-03-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33500","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":"669069","transaction_code":"C","transaction_date":"2023-03-10 00:00:00","upload_date":"2023-03-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02338684","upload_search_indicator":null,"census_search_date":"2023-03-10 21:40:00","snet_input_date":"2023-03-10 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-03-10 21:40:00","insp_carrier_name":"CRAFT BEER GUILD DISTRIBUTING OF CONNECTICUT LLC","insp_carrier_street":"110 REPUBLIC DRIVE","insp_carrier_city":"NORTH HAVEN","insp_carrier_state":"CT","insp_carrier_zip_code":"06473","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:13:42.000000Z","updated_at":"2025-03-17T19:13:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4102731,"change_date":"2023-03-16 21:42:00","inspection_id":"78058184","insp_unit_id":"193900633","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"BA86162","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"5PVNV8JV9D4S52571","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:24.000000Z","updated_at":"2025-03-17T22:35:24.000000Z"}]},{"id":1908442,"change_date":"2022-12-19 21:40:00","inspection_id":"77326959","dot_number":"2338684","report_state":"CT","report_number":"3090002983","insp_date":"2022-12-09 00:00:00","insp_start_time":"0820","insp_end_time":"0858","registration_date":"2022-12-19 00:00:00","region":"ET","ci_status_code":"C","location":"083","location_desc":"MIDDLETOWN SCALE","county_code_state":"CT","county_code":"009","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SELF","shipping_paper_number":"5802","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-12-09 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"660750","transaction_code":"C","transaction_date":"2022-12-09 00:00:00","upload_date":"2022-12-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02338684","upload_search_indicator":null,"census_search_date":"2022-12-09 21:39:00","snet_input_date":"2022-12-09 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-12-09 21:39:00","insp_carrier_name":"CRAFT BEER GUILD DISTRIBUTING OF CONNECTICUT LLC","insp_carrier_street":"110 REPUBLIC DRIVE","insp_carrier_city":"NORTH HAVEN","insp_carrier_state":"CT","insp_carrier_zip_code":"06473","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:01:51.000000Z","updated_at":"2025-03-17T19:01:51.000000Z","inspection_violations":[{"id":2969007,"change_date":"2022-12-19 21:40:00","inspection_id":"77326959","insp_violation_id":"250152796","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"192475655","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:07.000000Z","updated_at":"2025-03-17T21:21:07.000000Z","normalized_code":"3939A"},{"id":2969008,"change_date":"2022-12-19 21:40:00","inspection_id":"77326959","insp_violation_id":"250152797","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"192475655","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:07.000000Z","updated_at":"2025-03-17T21:21:07.000000Z","normalized_code":"3939A"},{"id":2969009,"change_date":"2022-12-19 21:40:00","inspection_id":"77326959","insp_violation_id":"250152798","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"192475655","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"Y992476 0","created_at":"2025-03-17T21:21:07.000000Z","updated_at":"2025-03-17T21:21:07.000000Z","normalized_code":"3922"},{"id":2969010,"change_date":"2022-12-19 21:40:00","inspection_id":"77326959","insp_violation_id":"250152799","seq_no":"4","part_no":"396","part_no_section":"9(d)(2)","insp_viol_unit":"1","insp_unit_id":"192475655","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"Y992476 0","created_at":"2025-03-17T21:21:07.000000Z","updated_at":"2025-03-17T21:21:07.000000Z","normalized_code":"3969D2"}],"inspection_per_units":[{"id":3071505,"change_date":"2022-12-19 21:40:00","inspection_id":"77326959","insp_unit_id":"192475655","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"AE31299","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"5PVNV8JV8L5S60587","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:02.000000Z","updated_at":"2025-03-17T22:28:02.000000Z"}]},{"id":1210749,"change_date":"2022-09-14 21:39:00","inspection_id":"76523064","dot_number":"2338684","report_state":"CT","report_number":"3067002292","insp_date":"2022-09-02 00:00:00","insp_start_time":"0848","insp_end_time":"0920","registration_date":"2022-09-14 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":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":"2022-09-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"653324","transaction_code":"C","transaction_date":"2022-09-02 00:00:00","upload_date":"2022-09-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02338684","upload_search_indicator":null,"census_search_date":"2022-09-06 21:41:00","snet_input_date":"2022-09-02 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-09-06 21:41:00","insp_carrier_name":"CRAFT BEER GUILD DISTRIBUTING OF CONNECTICUT LLC","insp_carrier_street":"110 REPUBLIC DRIVE","insp_carrier_city":"NORTH HAVEN","insp_carrier_state":"CT","insp_carrier_zip_code":"06473","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:48:59.000000Z","updated_at":"2025-03-17T18:48:59.000000Z","inspection_violations":[{"id":1919663,"change_date":"2022-09-14 21:39:00","inspection_id":"76523064","insp_violation_id":"248396615","seq_no":"1","part_no":"393","part_no_section":"55(d)(1)","insp_viol_unit":"1","insp_unit_id":"190884683","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:50.000000Z","updated_at":"2025-03-17T21:15:50.000000Z","normalized_code":"39355D1"},{"id":1919664,"change_date":"2022-09-14 21:39:00","inspection_id":"76523064","insp_violation_id":"248396616","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"190884683","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:50.000000Z","updated_at":"2025-03-17T21:15:50.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1947449,"change_date":"2022-09-14 21:39:00","inspection_id":"76523064","insp_unit_id":"190884683","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"BA86162","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"5PVNV8JV9D4S52571","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:23.000000Z","updated_at":"2025-03-17T22:20:23.000000Z"}]},{"id":939969,"change_date":"2022-08-15 21:37:00","inspection_id":"76207407","dot_number":"2338684","report_state":"CT","report_number":"3019003755","insp_date":"2022-08-02 00:00:00","insp_start_time":"0812","insp_end_time":"0831","registration_date":"2022-08-12 00:00:00","region":"ET","ci_status_code":"C","location":"107","location_desc":"ORANGE","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-02 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"5","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"650374","transaction_code":"C","transaction_date":"2022-08-02 00:00:00","upload_date":"2022-08-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02338684","upload_search_indicator":null,"census_search_date":"2022-08-02 21:39:00","snet_input_date":"2022-08-02 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-08-02 21:39:00","insp_carrier_name":"CRAFT BEER GUILD DISTRIBUTING OF CONNECTICUT LLC","insp_carrier_street":"110 REPUBLIC DRIVE","insp_carrier_city":"NORTH HAVEN","insp_carrier_state":"CT","insp_carrier_zip_code":"06473","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:44:07.000000Z","updated_at":"2025-03-17T18:44:07.000000Z","inspection_violations":[{"id":1483017,"change_date":"2022-08-15 21:37:00","inspection_id":"76207407","insp_violation_id":"247697217","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":"Y990245-2","created_at":"2025-03-17T21:14:03.000000Z","updated_at":"2025-03-17T21:14:03.000000Z","normalized_code":"39216A"},{"id":1483018,"change_date":"2022-08-15 21:37:00","inspection_id":"76207407","insp_violation_id":"247697218","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"190294894","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"Y990245-2","created_at":"2025-03-17T21:14:03.000000Z","updated_at":"2025-03-17T21:14:03.000000Z","normalized_code":"3922"},{"id":1483019,"change_date":"2022-08-15 21:37:00","inspection_id":"76207407","insp_violation_id":"247697219","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"190294894","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:03.000000Z","updated_at":"2025-03-17T21:14:03.000000Z","normalized_code":"3922"},{"id":1483020,"change_date":"2022-08-15 21:37:00","inspection_id":"76207407","insp_violation_id":"247697220","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190294894","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:03.000000Z","updated_at":"2025-03-17T21:14:03.000000Z","normalized_code":"3939A"},{"id":1483021,"change_date":"2022-08-15 21:37:00","inspection_id":"76207407","insp_violation_id":"247697221","seq_no":"5","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"190294894","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:03.000000Z","updated_at":"2025-03-17T21:14:03.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":1513129,"change_date":"2022-08-15 21:37:00","inspection_id":"76207407","insp_unit_id":"190294894","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"AE31299","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"5PVNV8JV8L5S60587","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:31.000000Z","updated_at":"2025-03-17T22:17:31.000000Z"}]},{"id":804435,"change_date":"2022-07-20 21:41:00","inspection_id":"76048497","dot_number":"2338684","report_state":"CT","report_number":"3120003107","insp_date":"2022-07-13 00:00:00","insp_start_time":"0945","insp_end_time":"1007","registration_date":"2022-07-18 00:00:00","region":"ET","ci_status_code":"C","location":"152","location_desc":"WATERFORD","county_code_state":"CT","county_code":"011","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CRAFT BEER GUILD DISTRIBUTING OF CONNECTICUT LLC","shipping_paper_number":"3804","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.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-07-13 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"648767","transaction_code":"C","transaction_date":"2022-07-13 00:00:00","upload_date":"2022-07-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02338684","upload_search_indicator":null,"census_search_date":"2022-07-13 21:39:00","snet_input_date":"2022-07-13 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-07-13 21:39:00","insp_carrier_name":"CRAFT BEER GUILD DISTRIBUTING OF CONNECTICUT LLC","insp_carrier_street":"110 REPUBLIC DRIVE","insp_carrier_city":"NORTH HAVEN","insp_carrier_state":"CT","insp_carrier_zip_code":"06473","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:41:55.000000Z","updated_at":"2025-03-17T18:41:55.000000Z","inspection_violations":[{"id":1269123,"change_date":"2022-07-20 21:41:00","inspection_id":"76048497","insp_violation_id":"247195412","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:59.000000Z","updated_at":"2025-03-17T21:12:59.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1294592,"change_date":"2022-07-20 21:41:00","inspection_id":"76048497","insp_unit_id":"189865358","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"CT-3","insp_unit_license":"L8036","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"5PVNJ8JT7D4S54832","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:07.000000Z","updated_at":"2025-03-17T22:16:07.000000Z"}]},{"id":589561,"change_date":"2022-06-20 21:35:00","inspection_id":"75795199","dot_number":"2338684","report_state":"CT","report_number":"3132002986","insp_date":"2022-06-13 00:00:00","insp_start_time":"1417","insp_end_time":"1434","registration_date":"2022-06-20 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":"CRAFT BEER GUILD DISTRIBUTING OF CONNECTICUT LLC","shipping_paper_number":"105621","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"646333","transaction_code":"C","transaction_date":"2022-06-13 00:00:00","upload_date":"2022-06-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02338684","upload_search_indicator":null,"census_search_date":"2022-06-13 21:41:00","snet_input_date":"2022-06-13 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-06-13 21:41:00","insp_carrier_name":"CRAFT BEER GUILD DISTRIBUTING OF CONNECTICUT LLC","insp_carrier_street":"110 REPUBLIC DRIVE","insp_carrier_city":"NORTH HAVEN","insp_carrier_state":"CT","insp_carrier_zip_code":"06473","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:38:05.000000Z","updated_at":"2025-03-17T18:38:05.000000Z","inspection_violations":[{"id":924747,"change_date":"2022-06-20 21:35:00","inspection_id":"75795199","insp_violation_id":"246579378","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:11:22.000000Z","updated_at":"2025-03-17T21:11:22.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":947279,"change_date":"2022-06-20 21:35:00","inspection_id":"75795199","insp_unit_id":"189343016","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"K92923","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"5PVNJ8JT3D4S54181","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:02.000000Z","updated_at":"2025-03-17T22:14:02.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2338684\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2338684\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2338684\/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\/2338684\/inspections","per_page":100,"prev_page_url":null,"to":9,"total":9}