{"current_page":1,"data":[{"id":10371961,"change_date":"2025-12-11 21:43:00","inspection_id":"86500852","dot_number":"545907","report_state":"CT","report_number":"3075004196","insp_date":"2025-12-08 00:00:00","insp_start_time":"0917","insp_end_time":"0949","registration_date":"2025-12-11 00:00:00","region":"ET","ci_status_code":"C","location":"049","location_desc":"ENFIELD","county_code_state":"CT","county_code":"003","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SODA SERVICE & ALPINE REF","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-12-08 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"759942","transaction_code":"C","transaction_date":"2025-12-08 00:00:00","upload_date":"2025-12-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00545907","upload_search_indicator":null,"census_search_date":"2025-12-08 21:37:00","snet_input_date":"2025-12-08 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-12-08 21:37:00","insp_carrier_name":"SODA SERVICE OF HARTFORD INC","insp_carrier_street":"261 PASCONE PLACE","insp_carrier_city":"NEWINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06111","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-11T10:30:18.000000Z","updated_at":"2025-12-15T10:30:14.000000Z","inspection_violations":[{"id":18489532,"change_date":null,"inspection_id":"86500852","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3939ALCL"}],"inspection_per_units":[{"id":18673702,"change_date":null,"inspection_id":"86500852","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"BG63970","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"JALE5W162K7302587","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":3409636,"change_date":"2023-06-30 21:39:00","inspection_id":"79032566","dot_number":"545907","report_state":"CT","report_number":"3132003936","insp_date":"2023-06-30 00:00:00","insp_start_time":"1451","insp_end_time":"1504","registration_date":null,"region":"ET","ci_status_code":"C","location":"064","location_desc":"HARTFORD","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SODA SERVICE OF HARTFORD INC","shipping_paper_number":"24","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-30 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"679253","transaction_code":"A","transaction_date":"2023-06-30 00:00:00","upload_date":"2023-06-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00545907","upload_search_indicator":null,"census_search_date":"2023-06-30 21:39:00","snet_input_date":"2023-06-30 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-06-30 21:39:00","insp_carrier_name":"SODA SERVICE OF HARTFORD INC","insp_carrier_street":"261 PASCONE PLACE","insp_carrier_city":"NEWINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06111","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:30:34.000000Z","updated_at":"2025-03-17T19:30:34.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":1701477,"change_date":"2022-11-14 21:41:00","inspection_id":"77090058","dot_number":"545907","report_state":"CT","report_number":"1162001319","insp_date":"2022-11-09 00:00:00","insp_start_time":"1208","insp_end_time":"1243","registration_date":"2022-11-14 00:00:00","region":"ET","ci_status_code":"C","location":"130","location_desc":"SOUTHBURY","county_code_state":"CT","county_code":"009","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"OWN PRODUCT","shipping_paper_number":"PAPER","cargo_tank":null,"hazmat_placard_req":"Y","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-11-09 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"1","hazmat_oos_total":"0","snet_sequence_id":"658386","transaction_code":"C","transaction_date":"2022-11-09 00:00:00","upload_date":"2022-11-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00545907","upload_search_indicator":null,"census_search_date":"2022-11-09 21:39:00","snet_input_date":"2022-11-09 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-11-09 21:39:00","insp_carrier_name":"SODA SERVICE INC","insp_carrier_street":"261 PASCONE PLACE","insp_carrier_city":"NEWINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06111","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:58:09.000000Z","updated_at":"2025-03-17T18:58:09.000000Z","inspection_violations":[],"inspection_per_units":[]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/545907\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/545907\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/545907\/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\/545907\/inspections","per_page":100,"prev_page_url":null,"to":3,"total":3}