{"current_page":1,"data":[{"id":8965893,"change_date":"2025-06-24 21:39:00","inspection_id":"85022946","dot_number":"2079121","report_state":"CT","report_number":"3014004527","insp_date":"2025-06-20 00:00:00","insp_start_time":"1424","insp_end_time":"1437","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":"CARRIER","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-24 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"743585","transaction_code":"A","transaction_date":"2025-06-20 00:00:00","upload_date":"2025-06-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02079121","upload_search_indicator":null,"census_search_date":"2025-06-24 21:39:00","snet_input_date":"2025-06-20 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-06-24 21:39:00","insp_carrier_name":"EXPRESS COUNTERTOP KITCHEN & FLOORING","insp_carrier_street":"231 WESTON STREET","insp_carrier_city":"HARTFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-28T10:00:40.000000Z","updated_at":"2025-06-28T10:00:40.000000Z","inspection_violations":[{"id":14403682,"change_date":"2025-06-24 21:39:00","inspection_id":"85022946","insp_violation_id":"266998797","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-27T10:17:01.000000Z","updated_at":"2025-06-28T10:16:36.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":14698157,"change_date":"2025-06-24 21:39:00","inspection_id":"85022946","insp_unit_id":"207516466","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"400147","insp_unit_license":"BJ26253","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3ALACWFC4PDUC6887","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-27T09:46:28.000000Z","updated_at":"2025-06-28T09:45:03.000000Z"}]},{"id":8496105,"change_date":"2025-05-20 21:40:00","inspection_id":"84525991","dot_number":"2079121","report_state":"CT","report_number":"3077A00393","insp_date":"2025-04-30 00:00:00","insp_start_time":"1459","insp_end_time":"1535","registration_date":"2025-05-20 00:00:00","region":"ET","ci_status_code":"C","location":"052","location_desc":"FARMINGTON","county_code_state":"CT","county_code":"003","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"EXPRESS COUNTERTOP KITCHEN & FLOORING","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":"2025-04-30 21:50: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":"738900","transaction_code":"C","transaction_date":"2025-04-30 00:00:00","upload_date":"2025-05-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02079121","upload_search_indicator":null,"census_search_date":"2025-04-30 21:50:00","snet_input_date":"2025-04-30 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-04-30 21:50:00","insp_carrier_name":"EXPRESS COUNTERTOP KITCHEN & FLOORING","insp_carrier_street":"231 WESTON STREET","insp_carrier_city":"HARTFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-02T13:49:31.000000Z","updated_at":"2025-05-24T10:03:23.000000Z","inspection_violations":[{"id":13829239,"change_date":"2025-05-20 21:40:00","inspection_id":"84525991","insp_violation_id":"266335799","seq_no":"1","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"206954472","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-23T10:28:03.000000Z","updated_at":"2025-05-24T10:18:26.000000Z","normalized_code":"39021TB2DOT"},{"id":13829240,"change_date":"2025-05-20 21:40:00","inspection_id":"84525991","insp_violation_id":"266335800","seq_no":"2","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"206954472","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-23T10:28:03.000000Z","updated_at":"2025-05-24T10:18:26.000000Z","normalized_code":"39395A4EEUS"},{"id":13829241,"change_date":"2025-05-20 21:40:00","inspection_id":"84525991","insp_violation_id":"266335801","seq_no":"3","part_no":"393","part_no_section":"9A-LFTSI","insp_viol_unit":"1","insp_unit_id":"206954472","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-23T10:28:03.000000Z","updated_at":"2025-05-24T10:18:26.000000Z","normalized_code":"3939ALFTSI"},{"id":13829242,"change_date":"2025-05-20 21:40:00","inspection_id":"84525991","insp_violation_id":"266335802","seq_no":"4","part_no":"393","part_no_section":"9A-LHWS","insp_viol_unit":"1","insp_unit_id":"206954472","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-23T10:28:03.000000Z","updated_at":"2025-05-24T10:18:26.000000Z","normalized_code":"3939ALHWS"}],"inspection_per_units":[{"id":14184957,"change_date":"2025-05-20 21:40:00","inspection_id":"84525991","insp_unit_id":"206954472","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"400147","insp_unit_license":"BJ26253","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3ALACWFC4PDUC6887","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-23T09:48:34.000000Z","updated_at":"2025-05-24T09:48:20.000000Z"}]},{"id":7569694,"change_date":"2025-01-08 21:38:00","inspection_id":"83551952","dot_number":"2079121","report_state":"CT","report_number":"3132005253","insp_date":"2025-01-08 00:00:00","insp_start_time":"1007","insp_end_time":"1035","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":"EXPRESS COUNTERTOP KITCHEN & FLOORING","shipping_paper_number":"2NW29750","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-01-08 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"728843","transaction_code":"A","transaction_date":"2025-01-08 00:00:00","upload_date":"2025-01-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02079121","upload_search_indicator":null,"census_search_date":"2025-01-08 21:38:00","snet_input_date":"2025-01-08 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-01-08 21:38:00","insp_carrier_name":"EXPRESS COUNTERTOP KITCHEN & FLOORING","insp_carrier_street":"231 WESTON STREET","insp_carrier_city":"HARTFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:55:17.000000Z","updated_at":"2025-03-17T20:55:17.000000Z","inspection_violations":[{"id":11833727,"change_date":"2025-01-08 21:38:00","inspection_id":"83551952","insp_violation_id":"263806878","seq_no":"1","part_no":"391","part_no_section":"11A-QMC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"54","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:38.000000Z","updated_at":"2025-03-17T22:03:38.000000Z","normalized_code":"39111AQMC"}],"inspection_per_units":[{"id":12213492,"change_date":"2025-01-08 21:38:00","inspection_id":"83551952","insp_unit_id":"204697827","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BJ26253","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3ALACWFC4PDUC6887","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:49.000000Z","updated_at":"2025-03-17T23:49:49.000000Z"}]},{"id":5419950,"change_date":"2024-04-03 21:40:00","inspection_id":"81251465","dot_number":"2079121","report_state":"CT","report_number":"3132004469","insp_date":"2024-04-03 00:00:00","insp_start_time":"1353","insp_end_time":"1400","registration_date":null,"region":"ET","ci_status_code":"C","location":"064","location_desc":"HARTFORD","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"704008","transaction_code":"A","transaction_date":"2024-04-03 00:00:00","upload_date":"2024-04-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02079121","upload_search_indicator":null,"census_search_date":"2024-04-03 21:40:00","snet_input_date":"2024-04-03 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-04-03 21:40:00","insp_carrier_name":"EXPRESS COUNTERTOP KITCHEN & FLOORING","insp_carrier_street":"231 WESTON STREET","insp_carrier_city":"HARTFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:09:55.000000Z","updated_at":"2025-03-17T20:09:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8729918,"change_date":"2024-04-03 21:40:00","inspection_id":"81251465","insp_unit_id":"200204140","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BJ26253","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3ALACWFC4PDUC6887","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:10.000000Z","updated_at":"2025-03-17T23:14:10.000000Z"}]},{"id":5229590,"change_date":"2024-03-18 21:37:00","inspection_id":"81043536","dot_number":"2079121","report_state":"CT","report_number":"3070005760","insp_date":"2024-03-07 00:00:00","insp_start_time":"1424","insp_end_time":"1445","registration_date":"2024-03-18 00:00:00","region":"ET","ci_status_code":"C","location":"131","location_desc":"SOUTHINGTON","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"0","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-07 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"701634","transaction_code":"C","transaction_date":"2024-03-07 00:00:00","upload_date":"2024-03-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02079121","upload_search_indicator":null,"census_search_date":"2024-03-07 21:38:00","snet_input_date":"2024-03-07 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-03-07 21:38:00","insp_carrier_name":"EXPRESS COUNTERTOP KITCHEN & FLOORING","insp_carrier_street":"231 WESTON STREET","insp_carrier_city":"HARTFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:06:13.000000Z","updated_at":"2025-03-17T20:06:13.000000Z","inspection_violations":[{"id":8063052,"change_date":"2024-03-18 21:37:00","inspection_id":"81043536","insp_violation_id":"258424514","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V126595-2","created_at":"2025-03-17T21:44:59.000000Z","updated_at":"2025-03-17T21:44:59.000000Z","normalized_code":"3922"},{"id":8063053,"change_date":"2024-03-18 21:37:00","inspection_id":"81043536","insp_violation_id":"258424515","seq_no":"2","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"199949934","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:59.000000Z","updated_at":"2025-03-17T21:44:59.000000Z","normalized_code":"39021TB"},{"id":8063054,"change_date":"2024-03-18 21:37:00","inspection_id":"81043536","insp_violation_id":"258424516","seq_no":"3","part_no":"396","part_no_section":"9(d)(2)","insp_viol_unit":"1","insp_unit_id":"199949934","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:59.000000Z","updated_at":"2025-03-17T21:44:59.000000Z","normalized_code":"3969D2"}],"inspection_per_units":[{"id":8421174,"change_date":"2024-03-18 21:37:00","inspection_id":"81043536","insp_unit_id":"199949934","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BJ26253","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3ALACWFC4PDUC6887","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:19.000000Z","updated_at":"2025-03-17T23:11:19.000000Z"}]},{"id":4401063,"change_date":"2024-01-11 21:45:00","inspection_id":"80137009","dot_number":"2079121","report_state":"CT","report_number":"1142000228","insp_date":"2023-11-10 00:00:00","insp_start_time":"0936","insp_end_time":"1019","registration_date":"2024-01-11 00:00:00","region":"ET","ci_status_code":"C","location":null,"location_desc":"RT 11 SOUTH AT RT 82","county_code_state":"CT","county_code":"011","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"4","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"691335","transaction_code":"C","transaction_date":"2023-12-26 00:00:00","upload_date":"2024-01-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02079121","upload_search_indicator":null,"census_search_date":"2023-11-13 21:40:00","snet_input_date":"2023-11-10 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-11-13 21:40:00","insp_carrier_name":"EXPRESS COUNTERTOP KITCHEN & FLOORING","insp_carrier_street":"231 WESTON STREET","insp_carrier_city":"HARTFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:50:15.000000Z","updated_at":"2025-03-17T19:50:15.000000Z","inspection_violations":[{"id":6812246,"change_date":"2024-01-11 21:45:00","inspection_id":"80137009","insp_violation_id":"257286384","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":"Z411576-3","created_at":"2025-03-17T21:38:47.000000Z","updated_at":"2025-03-17T21:38:47.000000Z","normalized_code":"39141A1"},{"id":6812247,"change_date":"2024-01-11 21:45:00","inspection_id":"80137009","insp_violation_id":"257286385","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198909764","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"Z411578-5","created_at":"2025-03-17T21:38:47.000000Z","updated_at":"2025-03-17T21:38:47.000000Z","normalized_code":"3939A"},{"id":6812248,"change_date":"2024-01-11 21:45:00","inspection_id":"80137009","insp_violation_id":"257286386","seq_no":"3","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"198909764","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"Z411578-5","created_at":"2025-03-17T21:38:47.000000Z","updated_at":"2025-03-17T21:38:47.000000Z","normalized_code":"39311"},{"id":6812249,"change_date":"2024-01-11 21:45:00","inspection_id":"80137009","insp_violation_id":"257286387","seq_no":"4","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"198909764","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:47.000000Z","updated_at":"2025-03-17T21:38:47.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":7077898,"change_date":"2024-01-11 21:45:00","inspection_id":"80137009","insp_unit_id":"198909764","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"659662","insp_unit_license":"AB16386","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FVACWDT8GHHS1317","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:25.000000Z","updated_at":"2025-03-17T22:59:25.000000Z"}]},{"id":3949910,"change_date":"2024-10-02 21:40:00","inspection_id":"79637168","dot_number":"2079121","report_state":"CT","report_number":"3134000721","insp_date":"2023-09-12 00:00:00","insp_start_time":"1504","insp_end_time":"1555","registration_date":null,"region":"ET","ci_status_code":"C","location":"077","location_desc":"MANCHESTER","county_code_state":"CT","county_code":"003","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME AS CARRIER","shipping_paper_number":"2NW26227","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-12 21:39:00","post_acc_ind":"Y","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"685864","transaction_code":"C","transaction_date":"2024-10-02 00:00:00","upload_date":"2024-10-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02079121","upload_search_indicator":null,"census_search_date":"2023-09-12 21:39:00","snet_input_date":"2023-09-12 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-09-12 21:39:00","insp_carrier_name":"EXPRESS COUNTERTOP KITCHEN & FLOORING","insp_carrier_street":"231 WESTON STREET","insp_carrier_city":"HARTFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:40:49.000000Z","updated_at":"2025-03-17T19:40:49.000000Z","inspection_violations":[{"id":6107299,"change_date":"2024-10-02 21:40:00","inspection_id":"79637168","insp_violation_id":"262138406","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:35:32.000000Z","updated_at":"2025-03-17T21:35:32.000000Z","normalized_code":"39141A1"}],"inspection_per_units":[{"id":6351458,"change_date":"2024-10-02 21:40:00","inspection_id":"79637168","insp_unit_id":"203225574","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"400146","insp_unit_license":"BJ24215","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3ALACWFC2PDUC6886","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:22.000000Z","updated_at":"2025-03-17T22:53:22.000000Z"}]},{"id":3862734,"change_date":"2023-08-30 21:43:00","inspection_id":"79540093","dot_number":"2079121","report_state":"CT","report_number":"3129004278","insp_date":"2023-08-29 00:00:00","insp_start_time":"1356","insp_end_time":"1418","registration_date":null,"region":"ET","ci_status_code":"C","location":"164","location_desc":"WINDSOR","county_code_state":"CT","county_code":"003","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"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":"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":"684841","transaction_code":"A","transaction_date":"2023-08-29 00:00:00","upload_date":"2023-08-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02079121","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":"EXPRESS COUNTERTOP KITCHEN & FLOORING","insp_carrier_street":"231 WESTON STREET","insp_carrier_city":"HARTFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06120","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":5965445,"change_date":"2023-08-30 21:43:00","inspection_id":"79540093","insp_violation_id":"254963121","seq_no":"1","part_no":"390","part_no_section":"21T(c)","insp_viol_unit":"1","insp_unit_id":"196798646","insp_violation_category_id":"30","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":"39021TC"}],"inspection_per_units":[{"id":6210363,"change_date":"2023-08-30 21:43:00","inspection_id":"79540093","insp_unit_id":"196798646","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BJ26253","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3ALACWFC4PDUC6887","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":3173978,"change_date":"2023-05-31 21:41:00","inspection_id":"78766780","dot_number":"2079121","report_state":"CT","report_number":"3070004691","insp_date":"2023-05-31 00:00:00","insp_start_time":"1526","insp_end_time":"1535","registration_date":null,"region":"ET","ci_status_code":"C","location":"151","location_desc":"WATERBURY","county_code_state":"CT","county_code":"009","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"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-05-31 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"675873","transaction_code":"A","transaction_date":"2023-05-31 00:00:00","upload_date":"2023-05-31 00:00:00","upload_first_byte":"0","upload_dot_number":"02079121","upload_search_indicator":null,"census_search_date":"2023-05-31 21:41:00","snet_input_date":"2023-05-31 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-05-31 21:41:00","insp_carrier_name":"EXPRESS COUNTERTOP KITCHEN & FLOORING","insp_carrier_street":"231 WESTON STREET","insp_carrier_city":"HARTFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:25:45.000000Z","updated_at":"2025-03-17T19:25:45.000000Z","inspection_violations":[{"id":4891041,"change_date":"2023-05-31 21:41:00","inspection_id":"78766780","insp_violation_id":"253165714","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"Y996368-0","created_at":"2025-03-17T21:29:45.000000Z","updated_at":"2025-03-17T21:29:45.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5105707,"change_date":"2023-05-31 21:41:00","inspection_id":"78766780","insp_unit_id":"195216715","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BJ26253","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3ALACWFC4PDUC6887","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:15.000000Z","updated_at":"2025-03-17T22:43:15.000000Z"}]},{"id":3039126,"change_date":"2023-05-15 21:41:00","inspection_id":"78614970","dot_number":"2079121","report_state":"CT","report_number":"3132003799","insp_date":"2023-05-12 00:00:00","insp_start_time":"1300","insp_end_time":"1316","registration_date":null,"region":"ET","ci_status_code":"C","location":"155","location_desc":"WEST HARTFORD","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"674424","transaction_code":"A","transaction_date":"2023-05-12 00:00:00","upload_date":"2023-05-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02079121","upload_search_indicator":null,"census_search_date":"2023-05-15 21:41:00","snet_input_date":"2023-05-12 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-05-15 21:41:00","insp_carrier_name":"EXPRESS COUNTERTOP KITCHEN & FLOORING","insp_carrier_street":"231 WESTON STREET","insp_carrier_city":"HARTFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:23:04.000000Z","updated_at":"2025-03-17T19:23:04.000000Z","inspection_violations":[{"id":4668176,"change_date":"2023-05-15 21:41:00","inspection_id":"78614970","insp_violation_id":"252816623","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":"Y9959001","created_at":"2025-03-17T21:28:46.000000Z","updated_at":"2025-03-17T21:28:46.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4889261,"change_date":"2023-05-15 21:41:00","inspection_id":"78614970","insp_unit_id":"194917958","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BJ24215","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3ALACWFC2PDUC6886","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:31.000000Z","updated_at":"2025-03-17T22:41:31.000000Z"}]},{"id":2671269,"change_date":"2023-03-28 21:40:00","inspection_id":"78197124","dot_number":"2079121","report_state":"CT","report_number":"3023005328","insp_date":"2023-03-27 00:00:00","insp_start_time":"1712","insp_end_time":"1734","registration_date":null,"region":"ET","ci_status_code":"C","location":"145S","location_desc":"UNION SCALE","county_code_state":"CT","county_code":"013","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"YES","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-03-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"670659","transaction_code":"A","transaction_date":"2023-03-27 00:00:00","upload_date":"2023-03-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02079121","upload_search_indicator":null,"census_search_date":"2023-03-28 21:40:00","snet_input_date":"2023-03-27 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-03-28 21:40:00","insp_carrier_name":"EXPRESS COUNTERTOP KITCHEN & FLOORING","insp_carrier_street":"231 WESTON STREET","insp_carrier_city":"HARTFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:15:53.000000Z","updated_at":"2025-03-17T19:15:53.000000Z","inspection_violations":[{"id":4105551,"change_date":"2023-03-28 21:40:00","inspection_id":"78197124","insp_violation_id":"251892159","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"Y994880-3","created_at":"2025-03-17T21:26:14.000000Z","updated_at":"2025-03-17T21:26:14.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4301122,"change_date":"2023-03-28 21:40:00","inspection_id":"78197124","insp_unit_id":"194086978","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BJ26253","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3ALACWFC4PDUC6887","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:53.000000Z","updated_at":"2025-03-17T22:36:53.000000Z"}]},{"id":1803405,"change_date":"2022-11-23 21:39:00","inspection_id":"77207150","dot_number":"2079121","report_state":"CT","report_number":"0954000218","insp_date":"2022-11-23 00:00:00","insp_start_time":"1135","insp_end_time":"1147","registration_date":null,"region":"ET","ci_status_code":"C","location":"083S","location_desc":"MIDDLETOWN SCALE","county_code_state":"CT","county_code":"007","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SAME","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"659765","transaction_code":"A","transaction_date":"2022-11-23 00:00:00","upload_date":"2022-11-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02079121","upload_search_indicator":null,"census_search_date":"2022-11-23 21:39:00","snet_input_date":"2022-11-23 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-11-23 21:39:00","insp_carrier_name":"EXPRESS COUNTERTOP KITCHEN & FLOORING","insp_carrier_street":"231 WESTON STREET","insp_carrier_city":"HARTFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:59:57.000000Z","updated_at":"2025-03-17T18:59:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2901006,"change_date":"2022-11-23 21:39:00","inspection_id":"77207150","insp_unit_id":"192102042","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"400147","insp_unit_license":"BJ26253","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3ALACWFC4PDUC6887","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:52.000000Z","updated_at":"2025-03-17T22:26:52.000000Z"}]},{"id":775678,"change_date":"2022-07-08 21:40:00","inspection_id":"76015167","dot_number":"2079121","report_state":"CT","report_number":"3129003270","insp_date":"2022-07-01 00:00:00","insp_start_time":"1529","insp_end_time":"1551","registration_date":null,"region":"ET","ci_status_code":"C","location":"064","location_desc":"HARTFORD","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-07-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"648024","transaction_code":"A","transaction_date":"2022-07-01 00:00:00","upload_date":"2022-07-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02079121","upload_search_indicator":null,"census_search_date":"2022-07-08 21:40:00","snet_input_date":"2022-07-01 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-07-08 21:40:00","insp_carrier_name":"EXPRESS COUNTERTOP KITCHEN & FLOORING","insp_carrier_street":"231 WESTON STREET","insp_carrier_city":"HARTFORD","insp_carrier_state":"CT","insp_carrier_zip_code":"06120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:41:16.000000Z","updated_at":"2025-03-17T18:41:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1248172,"change_date":"2022-07-08 21:40:00","inspection_id":"76015167","insp_unit_id":"189666326","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"681089","insp_unit_license":"AU39745","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3ALACXFC0JDJJ6764","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:51.000000Z","updated_at":"2025-03-17T22:15:51.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2079121\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2079121\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2079121\/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\/2079121\/inspections","per_page":100,"prev_page_url":null,"to":13,"total":13}