{"current_page":1,"data":[{"id":11691598,"change_date":"2026-04-20 21:37:00","inspection_id":"87617655","dot_number":"517926","report_state":"CT","report_number":"3085000238","insp_date":"2026-04-20 00:00:00","insp_start_time":"0616","insp_end_time":"0651","registration_date":null,"region":"ET","ci_status_code":"C","location":"T049","location_desc":"RIGHT SHOULDER N\/B EXIT 49","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"WINDSOR SANITATION INC","shipping_paper_number":"57765A","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-04-20 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"77600","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":"770692","transaction_code":"A","transaction_date":"2026-04-20 00:00:00","upload_date":"2026-04-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00517926","upload_search_indicator":null,"census_search_date":"2026-04-20 21:37:00","snet_input_date":"2026-04-20 00:00:00","source_office":"1CTS001","mcmis_add_date":"2026-04-20 21:37:00","insp_carrier_name":"WINDSOR SANITATION INC","insp_carrier_street":"33 MUCKO RD","insp_carrier_city":"BLOOMFIELD","insp_carrier_state":"CT","insp_carrier_zip_code":"06002","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-27T09:35:11.000000Z","updated_at":"2026-05-01T09:30:15.000000Z","inspection_violations":[{"id":20312552,"change_date":"2026-04-20 21:37:00","inspection_id":"87617655","insp_violation_id":"273706013","seq_no":"1","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"W1120-5019","created_at":"2026-04-27T09:50:14.000000Z","updated_at":"2026-05-01T09:40:50.000000Z","normalized_code":"3922SLL"}],"inspection_per_units":[{"id":20347593,"change_date":"2026-04-20 21:37:00","inspection_id":"87617655","insp_unit_id":"213102615","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"NONE","insp_unit_license":"57765A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1NKZX4EX5GJ486887","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:10:20.000000Z","updated_at":"2026-05-01T09:02:44.000000Z"}]},{"id":11143325,"change_date":"2026-02-19 21:39:00","inspection_id":"87057449","dot_number":"517926","report_state":"CT","report_number":"3010004890","insp_date":"2026-02-17 00:00:00","insp_start_time":"0559","insp_end_time":"0645","registration_date":"2026-02-19 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":"WINDSOR SANITATION INC","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":"2026-02-17 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"77600","viol_total":"5","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"765574","transaction_code":"C","transaction_date":"2026-02-17 00:00:00","upload_date":"2026-02-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00517926","upload_search_indicator":null,"census_search_date":"2026-02-17 21:38:00","snet_input_date":"2026-02-17 00:00:00","source_office":"1CTS001","mcmis_add_date":"2026-02-17 21:38:00","insp_carrier_name":"WINDSOR SANITATION INC","insp_carrier_street":"33 MUCKO RD","insp_carrier_city":"BLOOMFIELD","insp_carrier_state":"CT","insp_carrier_zip_code":"06002","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-20T10:37:38.000000Z","updated_at":"2026-03-02T10:30:05.000000Z","inspection_violations":[{"id":18719286,"change_date":"2026-02-19 21:39:00","inspection_id":"87057449","insp_violation_id":"271882572","seq_no":"1","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"211696827","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-22T10:53:03.000000Z","updated_at":"2026-03-02T10:40:10.000000Z","normalized_code":"3939ALIL"},{"id":18719287,"change_date":"2026-02-19 21:39:00","inspection_id":"87057449","insp_violation_id":"271882573","seq_no":"4","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"211696827","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-22T10:53:03.000000Z","updated_at":"2026-03-02T10:40:10.000000Z","normalized_code":"39345B2BAIR"},{"id":18719289,"change_date":"2026-02-19 21:39:00","inspection_id":"87057449","insp_violation_id":"271882575","seq_no":"2","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"211696827","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-22T10:53:03.000000Z","updated_at":"2026-03-02T10:40:10.000000Z","normalized_code":"3939ALIL"},{"id":18719290,"change_date":"2026-02-19 21:39:00","inspection_id":"87057449","insp_violation_id":"271882576","seq_no":"3","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"211696827","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-22T10:53:03.000000Z","updated_at":"2026-03-02T10:40:10.000000Z","normalized_code":"39345B2BAIR"},{"id":18719288,"change_date":"2026-02-19 21:39:00","inspection_id":"87057449","insp_violation_id":"271882574","seq_no":"5","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"211696827","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-22T10:53:03.000000Z","updated_at":"2026-03-02T10:40:10.000000Z","normalized_code":"39378AWS"}],"inspection_per_units":[{"id":19053280,"change_date":"2026-02-19 21:39:00","inspection_id":"87057449","insp_unit_id":"211696827","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"29","insp_unit_license":"57765A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1NKZX4EX5GJ486887","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-22T10:13:19.000000Z","updated_at":"2026-03-02T10:02:30.000000Z"}]},{"id":11077549,"change_date":"2026-02-10 21:37:00","inspection_id":"86988542","dot_number":"517926","report_state":"CT","report_number":"3129006520","insp_date":"2026-02-09 00:00:00","insp_start_time":"1006","insp_end_time":"1036","registration_date":"2026-02-10 00:00:00","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":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":"2026-02-09 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"13200","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":"765199","transaction_code":"C","transaction_date":"2026-02-09 00:00:00","upload_date":"2026-02-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00517926","upload_search_indicator":null,"census_search_date":"2026-02-09 21:37:00","snet_input_date":"2026-02-09 00:00:00","source_office":"1CTS001","mcmis_add_date":"2026-02-09 21:37:00","insp_carrier_name":"WINDSOR SANITATION INC","insp_carrier_street":"33 MUCKO RD","insp_carrier_city":"BLOOMFIELD","insp_carrier_state":"CT","insp_carrier_zip_code":"06002","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-12T10:36:50.000000Z","updated_at":"2026-02-21T10:30:04.000000Z","inspection_violations":[{"id":18563367,"change_date":"2026-02-10 21:37:00","inspection_id":"86988542","insp_violation_id":"271692604","seq_no":"1","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"1","insp_unit_id":"211530013","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-13T10:51:54.000000Z","updated_at":"2026-02-21T10:38:09.000000Z","normalized_code":"3922SLL"},{"id":18563368,"change_date":"2026-02-10 21:37:00","inspection_id":"86988542","insp_violation_id":"271692605","seq_no":"2","part_no":"392","part_no_section":"2-SLLUCR","insp_viol_unit":"1","insp_unit_id":"211530013","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-13T10:51:54.000000Z","updated_at":"2026-02-21T10:38:09.000000Z","normalized_code":"3922SLLUCR"}],"inspection_per_units":[{"id":18909103,"change_date":"2026-02-10 21:37:00","inspection_id":"86988542","insp_unit_id":"211530013","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"L11260","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1GB3CZCG5DF212417","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-13T10:15:32.000000Z","updated_at":"2026-02-21T10:02:36.000000Z"}]},{"id":10910095,"change_date":"2026-02-19 21:39:00","inspection_id":"86941864","dot_number":"517926","report_state":"CT","report_number":"3029003609","insp_date":"2026-02-03 00:00:00","insp_start_time":"0849","insp_end_time":"0934","registration_date":"2026-02-19 00:00:00","region":"ET","ci_status_code":"C","location":"164","location_desc":"WINDSOR","county_code_state":"CT","county_code":"003","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"WINDSOR SANITATION 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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-02-03 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"56000","viol_total":"7","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"764736","transaction_code":"C","transaction_date":"2026-02-03 00:00:00","upload_date":"2026-02-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00517926","upload_search_indicator":null,"census_search_date":"2026-02-03 21:38:00","snet_input_date":"2026-02-03 00:00:00","source_office":"1CTS001","mcmis_add_date":"2026-02-03 21:38:00","insp_carrier_name":"WINDSOR SANITATION INC","insp_carrier_street":"33 MUCKO RD","insp_carrier_city":"BLOOMFIELD","insp_carrier_state":"CT","insp_carrier_zip_code":"06002","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-06T10:35:08.000000Z","updated_at":"2026-03-02T10:30:46.000000Z","inspection_violations":[{"id":18718353,"change_date":"2026-02-19 21:39:00","inspection_id":"86941864","insp_violation_id":"271882799","seq_no":"6","part_no":"393","part_no_section":"9A-LSML","insp_viol_unit":"1","insp_unit_id":"211696921","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-22T10:53:02.000000Z","updated_at":"2026-03-02T10:40:01.000000Z","normalized_code":"3939ALSML"},{"id":18718354,"change_date":"2026-02-19 21:39:00","inspection_id":"86941864","insp_violation_id":"271882800","seq_no":"7","part_no":"392","part_no_section":"16B-DPASS","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-02-22T10:53:02.000000Z","updated_at":"2026-03-02T10:40:01.000000Z","normalized_code":"39216BDPASS"},{"id":18718348,"change_date":"2026-02-19 21:39:00","inspection_id":"86941864","insp_violation_id":"271882794","seq_no":"1","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-22T10:53:02.000000Z","updated_at":"2026-03-02T10:40:01.000000Z","normalized_code":"3922SLL"},{"id":18718349,"change_date":"2026-02-19 21:39:00","inspection_id":"86941864","insp_violation_id":"271882795","seq_no":"2","part_no":"396","part_no_section":"5B-L","insp_viol_unit":"1","insp_unit_id":"211696921","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-22T10:53:02.000000Z","updated_at":"2026-03-02T10:40:01.000000Z","normalized_code":"3965BL"},{"id":18718350,"change_date":"2026-02-19 21:39:00","inspection_id":"86941864","insp_violation_id":"271882796","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"211696921","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-22T10:53:02.000000Z","updated_at":"2026-03-02T10:40:01.000000Z","normalized_code":"39378"},{"id":18718351,"change_date":"2026-02-19 21:39:00","inspection_id":"86941864","insp_violation_id":"271882797","seq_no":"4","part_no":"393","part_no_section":"9A-LBL","insp_viol_unit":"1","insp_unit_id":"211696921","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-22T10:53:02.000000Z","updated_at":"2026-03-02T10:40:01.000000Z","normalized_code":"3939ALBL"},{"id":18718352,"change_date":"2026-02-19 21:39:00","inspection_id":"86941864","insp_violation_id":"271882798","seq_no":"5","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"1","insp_unit_id":"211696921","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-22T10:53:02.000000Z","updated_at":"2026-03-02T10:40:01.000000Z","normalized_code":"3939ALLPL"}],"inspection_per_units":[{"id":19052804,"change_date":"2026-02-19 21:39:00","inspection_id":"86941864","insp_unit_id":"211696921","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"31","insp_unit_license":"AE11628","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FVXJLBB8YHB13369","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-22T10:13:18.000000Z","updated_at":"2026-03-02T10:03:30.000000Z"}]},{"id":9723665,"change_date":"2025-09-30 21:38:00","inspection_id":"85819445","dot_number":"517926","report_state":"CT","report_number":"3011001844","insp_date":"2025-09-19 00:00:00","insp_start_time":"0652","insp_end_time":"0733","registration_date":"2025-09-30 00:00:00","region":"ET","ci_status_code":"C","location":"164","location_desc":"WINDSOR","county_code_state":"CT","county_code":"003","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"WINDSOR SANITATION","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-19 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"53800","viol_total":"3","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"752641","transaction_code":"C","transaction_date":"2025-09-19 00:00:00","upload_date":"2025-09-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00517926","upload_search_indicator":null,"census_search_date":"2025-09-19 21:38:00","snet_input_date":"2025-09-19 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-09-19 21:38:00","insp_carrier_name":"WINDSOR SANITATION INC","insp_carrier_street":"33 MUCKO RD","insp_carrier_city":"BLOOMFIELD","insp_carrier_state":"CT","insp_carrier_zip_code":"06002","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-23T10:02:35.000000Z","updated_at":"2025-10-04T10:00:05.000000Z","inspection_violations":[{"id":16142184,"change_date":"2025-09-30 21:38:00","inspection_id":"85819445","insp_violation_id":"268994810","seq_no":"3","part_no":"393","part_no_section":"11A1-LCHL","insp_viol_unit":"1","insp_unit_id":"209211062","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-03T10:17:39.000000Z","updated_at":"2025-10-04T10:15:10.000000Z","normalized_code":"39311A1LCHL"},{"id":16142185,"change_date":"2025-09-30 21:38:00","inspection_id":"85819445","insp_violation_id":"268994811","seq_no":"1","part_no":"392","part_no_section":"2-SLLTR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-03T10:17:39.000000Z","updated_at":"2025-10-04T10:15:10.000000Z","normalized_code":"3922SLLTR"},{"id":16142186,"change_date":"2025-09-30 21:38:00","inspection_id":"85819445","insp_violation_id":"268994812","seq_no":"2","part_no":"393","part_no_section":"134B-CRHLC","insp_viol_unit":"1","insp_unit_id":"209211062","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-10-03T10:17:39.000000Z","updated_at":"2025-10-04T10:15:10.000000Z","normalized_code":"393134BCRHLC"}],"inspection_per_units":[{"id":16263717,"change_date":"2025-09-30 21:38:00","inspection_id":"85819445","insp_unit_id":"209211062","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"41","insp_unit_license":"70204A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1M2GR4GC7KM001245","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-03T09:47:08.000000Z","updated_at":"2025-10-04T09:45:09.000000Z"}]},{"id":9454284,"change_date":"2025-08-20 21:39:00","inspection_id":"85525868","dot_number":"517926","report_state":"CT","report_number":"3019006578","insp_date":"2025-08-19 00:00:00","insp_start_time":"1251","insp_end_time":"1331","registration_date":"2025-08-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":"TOWN OF WINDSOR","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-08-19 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"749495","transaction_code":"C","transaction_date":"2025-08-19 00:00:00","upload_date":"2025-08-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00517926","upload_search_indicator":null,"census_search_date":"2025-08-19 21:39:00","snet_input_date":"2025-08-19 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-08-19 21:39:00","insp_carrier_name":"WINDSOR SANITATION INC","insp_carrier_street":"33 MUCKO RD","insp_carrier_city":"BLOOMFIELD","insp_carrier_state":"CT","insp_carrier_zip_code":"06002","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-23T10:46:40.000000Z","updated_at":"2025-08-25T10:41:23.000000Z","inspection_violations":[{"id":15398574,"change_date":"2025-08-20 21:39:00","inspection_id":"85525868","insp_violation_id":"268127982","seq_no":"1","part_no":"392","part_no_section":"2-SLLDL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-23T10:48:55.000000Z","updated_at":"2025-08-24T10:46:41.000000Z","normalized_code":"3922SLLDL"},{"id":15398575,"change_date":"2025-08-20 21:39:00","inspection_id":"85525868","insp_violation_id":"268127983","seq_no":"2","part_no":"393","part_no_section":"205C-WR","insp_viol_unit":"1","insp_unit_id":"208479557","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-23T10:48:55.000000Z","updated_at":"2025-08-24T10:46:41.000000Z","normalized_code":"393205CWR"},{"id":15398576,"change_date":"2025-08-20 21:39:00","inspection_id":"85525868","insp_violation_id":"268127984","seq_no":"3","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"1","insp_unit_id":"208479557","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V135548-2","created_at":"2025-08-23T10:48:55.000000Z","updated_at":"2025-08-24T10:46:41.000000Z","normalized_code":"3922SLLEWA1"},{"id":15398577,"change_date":"2025-08-20 21:39:00","inspection_id":"85525868","insp_violation_id":"268127985","seq_no":"4","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"1","insp_unit_id":"208479557","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V135548-2","created_at":"2025-08-23T10:48:55.000000Z","updated_at":"2025-08-24T10:46:41.000000Z","normalized_code":"3922SLLEWA1"},{"id":15398578,"change_date":"2025-08-20 21:39:00","inspection_id":"85525868","insp_violation_id":"268127986","seq_no":"5","part_no":"392","part_no_section":"2-SLLEWG3","insp_viol_unit":"1","insp_unit_id":"208479557","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V135548-2","created_at":"2025-08-23T10:48:55.000000Z","updated_at":"2025-08-24T10:46:41.000000Z","normalized_code":"3922SLLEWG3"}],"inspection_per_units":[{"id":15590543,"change_date":"2025-08-20 21:39:00","inspection_id":"85525868","insp_unit_id":"208479557","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"AUTO","insp_unit_company":"27","insp_unit_license":"L21750","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"5VCACRUFXFH218393","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-23T09:46:34.000000Z","updated_at":"2025-08-24T09:45:08.000000Z"}]},{"id":9384373,"change_date":"2025-08-19 21:39:00","inspection_id":"85462961","dot_number":"517926","report_state":"CT","report_number":"3025005711","insp_date":"2025-08-11 00:00:00","insp_start_time":"1609","insp_end_time":"1631","registration_date":"2025-08-19 00:00:00","region":"ET","ci_status_code":"C","location":"164","location_desc":"WINDSOR","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"WINDSOR SANITATION INC","shipping_paper_number":"ROUTE 64","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-08-12 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"79000","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":"748585","transaction_code":"C","transaction_date":"2025-08-11 00:00:00","upload_date":"2025-08-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00517926","upload_search_indicator":null,"census_search_date":"2025-08-12 21:39:00","snet_input_date":"2025-08-11 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-08-12 21:39:00","insp_carrier_name":"WINDSOR SANITATION INC","insp_carrier_street":"33 MUCKO RD","insp_carrier_city":"BLOOMFIELD","insp_carrier_state":"CT","insp_carrier_zip_code":"06002","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-15T10:43:35.000000Z","updated_at":"2025-08-23T10:46:14.000000Z","inspection_violations":[{"id":15375222,"change_date":"2025-08-19 21:39:00","inspection_id":"85462961","insp_violation_id":"268102495","seq_no":"1","part_no":"392","part_no_section":"16AD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V135366-2","created_at":"2025-08-22T10:44:36.000000Z","updated_at":"2025-08-23T10:47:10.000000Z","normalized_code":"39216AD"},{"id":15375223,"change_date":"2025-08-19 21:39:00","inspection_id":"85462961","insp_violation_id":"268102496","seq_no":"2","part_no":"392","part_no_section":"2-SLLIRP","insp_viol_unit":"1","insp_unit_id":"208459236","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-22T10:44:36.000000Z","updated_at":"2025-08-23T10:47:10.000000Z","normalized_code":"3922SLLIRP"}],"inspection_per_units":[{"id":15571123,"change_date":"2025-08-19 21:39:00","inspection_id":"85462961","insp_unit_id":"208459236","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"AUTO","insp_unit_company":"33","insp_unit_license":"62595A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"5VCACLUF3JH225532","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-22T09:46:33.000000Z","updated_at":"2025-08-23T09:45:06.000000Z"}]},{"id":8622736,"change_date":"2025-05-27 21:38:00","inspection_id":"84659523","dot_number":"517926","report_state":"CT","report_number":"3063007064","insp_date":"2025-05-14 00:00:00","insp_start_time":"1117","insp_end_time":"1215","registration_date":"2025-05-27 00:00:00","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":"167160001","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"86000","viol_total":"8","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"740202","transaction_code":"C","transaction_date":"2025-05-14 00:00:00","upload_date":"2025-05-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00517926","upload_search_indicator":null,"census_search_date":"2025-05-14 21:41:00","snet_input_date":"2025-05-14 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-05-14 21:41:00","insp_carrier_name":"WINDSOR SANITATION INC","insp_carrier_street":"33 MUCKO RD","insp_carrier_city":"BLOOMFIELD","insp_carrier_state":"CT","insp_carrier_zip_code":"06002","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-17T10:04:35.000000Z","updated_at":"2025-05-31T10:00:05.000000Z","inspection_violations":[{"id":13943957,"change_date":"2025-05-27 21:38:00","inspection_id":"84659523","insp_violation_id":"266474194","seq_no":"1","part_no":"393","part_no_section":"134B-CRHLC","insp_viol_unit":"1","insp_unit_id":"207065552","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-05-30T10:15:30.000000Z","updated_at":"2025-05-31T10:16:38.000000Z","normalized_code":"393134BCRHLC"},{"id":13943958,"change_date":"2025-05-27 21:38:00","inspection_id":"84659523","insp_violation_id":"266474195","seq_no":"2","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"207065552","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-30T10:15:30.000000Z","updated_at":"2025-05-31T10:16:38.000000Z","normalized_code":"39395F"},{"id":13943959,"change_date":"2025-05-27 21:38:00","inspection_id":"84659523","insp_violation_id":"266474196","seq_no":"3","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"207065552","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-30T10:15:30.000000Z","updated_at":"2025-05-31T10:16:38.000000Z","normalized_code":"39395A4EEUS"},{"id":13943960,"change_date":"2025-05-27 21:38:00","inspection_id":"84659523","insp_violation_id":"266474197","seq_no":"4","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"207065552","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-30T10:15:30.000000Z","updated_at":"2025-05-31T10:16:38.000000Z","normalized_code":"3939ALIL"},{"id":13943961,"change_date":"2025-05-27 21:38:00","inspection_id":"84659523","insp_violation_id":"266474198","seq_no":"5","part_no":"393","part_no_section":"9A-LSML","insp_viol_unit":"1","insp_unit_id":"207065552","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-30T10:15:30.000000Z","updated_at":"2025-05-31T10:16:38.000000Z","normalized_code":"3939ALSML"},{"id":13943962,"change_date":"2025-05-27 21:38:00","inspection_id":"84659523","insp_violation_id":"266474199","seq_no":"6","part_no":"393","part_no_section":"11A1-LRR","insp_viol_unit":"1","insp_unit_id":"207065552","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-30T10:15:30.000000Z","updated_at":"2025-05-31T10:16:38.000000Z","normalized_code":"39311A1LRR"},{"id":13943963,"change_date":"2025-05-27 21:38:00","inspection_id":"84659523","insp_violation_id":"266474200","seq_no":"7","part_no":"393","part_no_section":"11A1-LRR","insp_viol_unit":"1","insp_unit_id":"207065552","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-30T10:15:30.000000Z","updated_at":"2025-05-31T10:16:38.000000Z","normalized_code":"39311A1LRR"},{"id":13943964,"change_date":"2025-05-27 21:38:00","inspection_id":"84659523","insp_violation_id":"266474201","seq_no":"8","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"207065552","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-30T10:15:30.000000Z","updated_at":"2025-05-31T10:16:38.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":14285057,"change_date":"2025-05-27 21:38:00","inspection_id":"84659523","insp_unit_id":"207065552","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"36","insp_unit_license":"76727A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1M2AX07C1AM009196","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-30T09:45:25.000000Z","updated_at":"2025-05-31T09:46:36.000000Z"}]},{"id":8612032,"change_date":"2025-05-13 21:40:00","inspection_id":"84648133","dot_number":"517926","report_state":"CT","report_number":"3129005814","insp_date":"2025-05-13 00:00:00","insp_start_time":"1415","insp_end_time":"1433","registration_date":null,"region":"ET","ci_status_code":"C","location":"164","location_desc":"WINDSOR","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"740057","transaction_code":"A","transaction_date":"2025-05-13 00:00:00","upload_date":"2025-05-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00517926","upload_search_indicator":null,"census_search_date":"2025-05-13 21:40:00","snet_input_date":"2025-05-13 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-05-13 21:40:00","insp_carrier_name":"WINDSOR SANITATION INC","insp_carrier_street":"33 MUCKO RD","insp_carrier_city":"BLOOMFIELD","insp_carrier_state":"CT","insp_carrier_zip_code":"06002","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-17T10:03:39.000000Z","updated_at":"2025-05-17T10:07:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14061235,"change_date":"2025-05-13 21:40:00","inspection_id":"84648133","insp_unit_id":"206819007","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"77079A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1NKZX4TX5PJ217081","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-16T09:49:22.000000Z","updated_at":"2025-05-17T09:48:43.000000Z"}]},{"id":8584397,"change_date":"2025-05-12 21:39:00","inspection_id":"84619021","dot_number":"517926","report_state":"CT","report_number":"3011001605","insp_date":"2025-05-09 00:00:00","insp_start_time":"0822","insp_end_time":"0831","registration_date":"2025-05-12 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":"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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"739725","transaction_code":"C","transaction_date":"2025-05-09 00:00:00","upload_date":"2025-05-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00517926","upload_search_indicator":null,"census_search_date":"2025-05-09 21:40:00","snet_input_date":"2025-05-09 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-05-09 21:40:00","insp_carrier_name":"WINDSOR SANITATION INC","insp_carrier_street":"33 MUCKO RD","insp_carrier_city":"BLOOMFIELD","insp_carrier_state":"CT","insp_carrier_zip_code":"06002","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-12T10:02:34.000000Z","updated_at":"2025-05-17T10:03:19.000000Z","inspection_violations":[{"id":13661755,"change_date":"2025-05-12 21:39:00","inspection_id":"84619021","insp_violation_id":"266148638","seq_no":"1","part_no":"392","part_no_section":"2-SLLTR","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-15T10:16:33.000000Z","updated_at":"2025-05-16T10:18:30.000000Z","normalized_code":"3922SLLTR"}],"inspection_per_units":[{"id":14037254,"change_date":"2025-05-12 21:39:00","inspection_id":"84619021","insp_unit_id":"206795427","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"36","insp_unit_license":"76727A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1M2AX07C1AM009196","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-15T09:45:48.000000Z","updated_at":"2025-05-16T09:48:17.000000Z"}]},{"id":8584407,"change_date":"2025-05-12 21:39:00","inspection_id":"84619031","dot_number":"517926","report_state":"CT","report_number":"3078003360","insp_date":"2025-05-09 00:00:00","insp_start_time":"0606","insp_end_time":"0628","registration_date":"2025-05-12 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":"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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"0","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":"739695","transaction_code":"C","transaction_date":"2025-05-09 00:00:00","upload_date":"2025-05-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00517926","upload_search_indicator":null,"census_search_date":"2025-05-09 21:40:00","snet_input_date":"2025-05-09 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-05-09 21:40:00","insp_carrier_name":"WINDSOR SANITATION INC","insp_carrier_street":"33 MUCKO RD","insp_carrier_city":"BLOOMFIELD","insp_carrier_state":"CT","insp_carrier_zip_code":"06002","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-12T10:02:34.000000Z","updated_at":"2025-05-17T10:03:19.000000Z","inspection_violations":[{"id":13661756,"change_date":"2025-05-12 21:39:00","inspection_id":"84619031","insp_violation_id":"266148672","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":"V133717-5","created_at":"2025-05-15T10:16:33.000000Z","updated_at":"2025-05-16T10:18:30.000000Z","normalized_code":"3922SLLS3"},{"id":13661757,"change_date":"2025-05-12 21:39:00","inspection_id":"84619031","insp_violation_id":"266148673","seq_no":"2","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"206795453","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-15T10:16:33.000000Z","updated_at":"2025-05-16T10:18:30.000000Z","normalized_code":"3922SLLEQP"}],"inspection_per_units":[{"id":14037255,"change_date":"2025-05-12 21:39:00","inspection_id":"84619031","insp_unit_id":"206795453","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"1-096","insp_unit_license":"61954A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1NKZX4EX5JJ199458","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-15T09:45:48.000000Z","updated_at":"2025-05-16T09:48:17.000000Z"}]},{"id":8114202,"change_date":"2025-03-14 21:39:00","inspection_id":"84123858","dot_number":"517926","report_state":"CT","report_number":"3011001499","insp_date":"2025-03-14 00:00:00","insp_start_time":"0629","insp_end_time":"0642","registration_date":null,"region":"ET","ci_status_code":"C","location":"164","location_desc":"WINDSOR","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-14 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"734837","transaction_code":"A","transaction_date":"2025-03-14 00:00:00","upload_date":"2025-03-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00517926","upload_search_indicator":null,"census_search_date":"2025-03-14 21:39:00","snet_input_date":"2025-03-14 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-03-14 21:39:00","insp_carrier_name":"WINDSOR SANITATION INC","insp_carrier_street":"33 MUCKO RD","insp_carrier_city":"BLOOMFIELD","insp_carrier_state":"CT","insp_carrier_zip_code":"06002","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:06:53.000000Z","updated_at":"2025-03-17T21:06:53.000000Z","inspection_violations":[{"id":12687655,"change_date":"2025-03-14 21:39:00","inspection_id":"84123858","insp_violation_id":"265034229","seq_no":"1","part_no":"392","part_no_section":"2-SLLTR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:08:09.000000Z","updated_at":"2025-03-17T22:08:09.000000Z","normalized_code":"3922SLLTR"},{"id":12687656,"change_date":"2025-03-14 21:39:00","inspection_id":"84123858","insp_violation_id":"265034230","seq_no":"2","part_no":"393","part_no_section":"134B-CRHLC","insp_viol_unit":"1","insp_unit_id":"205796952","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:08:09.000000Z","updated_at":"2025-03-17T22:08:09.000000Z","normalized_code":"393134BCRHLC"}],"inspection_per_units":[{"id":13101086,"change_date":"2025-03-14 21:39:00","inspection_id":"84123858","insp_unit_id":"205796952","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"36","insp_unit_license":"76727A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1M2AX07C1AM009196","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:51.000000Z","updated_at":"2025-03-17T23:59:51.000000Z"}]},{"id":7633279,"change_date":"2025-01-16 21:40:00","inspection_id":"83618654","dot_number":"517926","report_state":"CT","report_number":"3132005289","insp_date":"2025-01-16 00:00:00","insp_start_time":"0852","insp_end_time":"0900","registration_date":null,"region":"ET","ci_status_code":"C","location":"164","location_desc":"WINDSOR","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-01-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"86000","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":"729860","transaction_code":"A","transaction_date":"2025-01-16 00:00:00","upload_date":"2025-01-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00517926","upload_search_indicator":null,"census_search_date":"2025-01-16 21:40:00","snet_input_date":"2025-01-16 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-01-16 21:40:00","insp_carrier_name":"WINDSOR SANITATION INC","insp_carrier_street":"33 MUCKO RD","insp_carrier_city":"BLOOMFIELD","insp_carrier_state":"CT","insp_carrier_zip_code":"06002","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:56:33.000000Z","updated_at":"2025-03-17T20:56:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12316777,"change_date":"2025-01-16 21:40:00","inspection_id":"83618654","insp_unit_id":"204861032","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"77079A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1NKZX4TX5PJ217081","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:56.000000Z","updated_at":"2025-03-17T23:50:56.000000Z"}]},{"id":7560067,"change_date":"2025-01-10 21:39:00","inspection_id":"83541803","dot_number":"517926","report_state":"CT","report_number":"0997000864","insp_date":"2025-01-07 00:00:00","insp_start_time":"0533","insp_end_time":"0550","registration_date":"2025-01-10 00:00:00","region":"ET","ci_status_code":"C","location":"155","location_desc":"WEST HARTFORD","county_code_state":"CT","county_code":"003","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"NONE","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-01-07 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"728637","transaction_code":"C","transaction_date":"2025-01-07 00:00:00","upload_date":"2025-01-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00517926","upload_search_indicator":null,"census_search_date":"2025-01-07 21:39:00","snet_input_date":"2025-01-07 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-01-07 21:39:00","insp_carrier_name":"WINDSOR SANITATION INC","insp_carrier_street":"33 MUCKO RD","insp_carrier_city":"BLOOMFIELD","insp_carrier_state":"CT","insp_carrier_zip_code":"06002","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:55:14.000000Z","updated_at":"2025-03-17T20:55:14.000000Z","inspection_violations":[{"id":11817730,"change_date":"2025-01-10 21:39:00","inspection_id":"83541803","insp_violation_id":"263851347","seq_no":"1","part_no":"392","part_no_section":"2-SLLS4","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:33.000000Z","updated_at":"2025-03-17T22:03:33.000000Z","normalized_code":"3922SLLS4"},{"id":11817731,"change_date":"2025-01-10 21:39:00","inspection_id":"83541803","insp_violation_id":"263851348","seq_no":"2","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"204737444","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:33.000000Z","updated_at":"2025-03-17T22:03:33.000000Z","normalized_code":"3939ALIL"}],"inspection_per_units":[{"id":12198202,"change_date":"2025-01-10 21:39:00","inspection_id":"83541803","insp_unit_id":"204737444","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"36","insp_unit_license":"76727A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1M2AX07C1AM009196","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:39.000000Z","updated_at":"2025-03-17T23:49:39.000000Z"}]},{"id":7313797,"change_date":"2024-12-18 21:40:00","inspection_id":"83282981","dot_number":"517926","report_state":"CT","report_number":"3019005899","insp_date":"2024-12-02 00:00:00","insp_start_time":"1347","insp_end_time":"1422","registration_date":"2024-12-17 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":"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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-12-02 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"725387","transaction_code":"C","transaction_date":"2024-12-02 00:00:00","upload_date":"2024-12-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00517926","upload_search_indicator":null,"census_search_date":"2024-12-02 21:39:00","snet_input_date":"2024-12-02 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-12-02 21:39:00","insp_carrier_name":"WINDSOR SANITATION INC","insp_carrier_street":"33 MUCKO RD","insp_carrier_city":"BLOOMFIELD","insp_carrier_state":"CT","insp_carrier_zip_code":"06002","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:48:36.000000Z","updated_at":"2025-03-17T20:48:36.000000Z","inspection_violations":[{"id":11432847,"change_date":"2024-12-18 21:40:00","inspection_id":"83282981","insp_violation_id":"263531486","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWG3","insp_viol_unit":"1","insp_unit_id":"204442366","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V131232-5","created_at":"2025-03-17T22:01:34.000000Z","updated_at":"2025-03-17T22:01:34.000000Z","normalized_code":"3922SLLEWG3"},{"id":11432848,"change_date":"2024-12-18 21:40:00","inspection_id":"83282981","insp_violation_id":"263531487","seq_no":"2","part_no":"392","part_no_section":"2-SLLEWA3","insp_viol_unit":"1","insp_unit_id":"204442366","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V131232-5","created_at":"2025-03-17T22:01:34.000000Z","updated_at":"2025-03-17T22:01:34.000000Z","normalized_code":"3922SLLEWA3"},{"id":11432849,"change_date":"2024-12-18 21:40:00","inspection_id":"83282981","insp_violation_id":"263531488","seq_no":"3","part_no":"392","part_no_section":"2-SLLEWA3","insp_viol_unit":"1","insp_unit_id":"204442366","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V131232-5","created_at":"2025-03-17T22:01:34.000000Z","updated_at":"2025-03-17T22:01:34.000000Z","normalized_code":"3922SLLEWA3"},{"id":11432850,"change_date":"2024-12-18 21:40:00","inspection_id":"83282981","insp_violation_id":"263531489","seq_no":"4","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"1","insp_unit_id":"204442366","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V131232-5","created_at":"2025-03-17T22:01:34.000000Z","updated_at":"2025-03-17T22:01:34.000000Z","normalized_code":"3922SLLEWA1"}],"inspection_per_units":[{"id":11798217,"change_date":"2024-12-18 21:40:00","inspection_id":"83282981","insp_unit_id":"204442366","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"AUTO","insp_unit_company":"34","insp_unit_license":"72236A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"5VCACLUF7JC225529","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:17.000000Z","updated_at":"2025-03-17T23:45:17.000000Z"}]},{"id":7288188,"change_date":"2024-11-27 21:39:00","inspection_id":"83255987","dot_number":"517926","report_state":"CT","report_number":"3129005306","insp_date":"2024-11-27 00:00:00","insp_start_time":"0630","insp_end_time":"0657","registration_date":null,"region":"ET","ci_status_code":"C","location":"164","location_desc":"WINDSOR","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-11-27 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"67400","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":"724965","transaction_code":"A","transaction_date":"2024-11-27 00:00:00","upload_date":"2024-11-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00517926","upload_search_indicator":null,"census_search_date":"2024-11-27 21:39:00","snet_input_date":"2024-11-27 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-11-27 21:39:00","insp_carrier_name":"WINDSOR SANITATION INC","insp_carrier_street":"33 MUCKO RD","insp_carrier_city":"BLOOMFIELD","insp_carrier_state":"CT","insp_carrier_zip_code":"06002","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:48:09.000000Z","updated_at":"2025-03-17T20:48:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11756190,"change_date":"2024-11-27 21:39:00","inspection_id":"83255987","insp_unit_id":"204075050","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"29","insp_unit_license":"57765A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1NKZX4EX5GJ486887","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:51.000000Z","updated_at":"2025-03-17T23:44:51.000000Z"}]},{"id":6956404,"change_date":"2024-10-30 21:40:00","inspection_id":"82904443","dot_number":"517926","report_state":"CT","report_number":"3019005763","insp_date":"2024-10-15 00:00:00","insp_start_time":"1044","insp_end_time":"1114","registration_date":"2024-10-30 00:00:00","region":"ET","ci_status_code":"C","location":"017","location_desc":"BRISTOL","county_code_state":"CT","county_code":"003","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":"2024-10-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"73000","viol_total":"5","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"720626","transaction_code":"C","transaction_date":"2024-10-16 00:00:00","upload_date":"2024-10-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00517926","upload_search_indicator":null,"census_search_date":"2024-10-15 21:41:00","snet_input_date":"2024-10-15 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-10-15 21:41:00","insp_carrier_name":"WINDSOR SANITATION INC","insp_carrier_street":"33 MUCKO RD","insp_carrier_city":"BLOOMFIELD","insp_carrier_state":"CT","insp_carrier_zip_code":"06002","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:41:03.000000Z","updated_at":"2025-03-17T20:41:03.000000Z","inspection_violations":[{"id":10845445,"change_date":"2024-10-30 21:40:00","inspection_id":"82904443","insp_violation_id":"262625262","seq_no":"1","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"1","insp_unit_id":"203646258","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:35.000000Z","updated_at":"2025-03-17T21:58:35.000000Z","normalized_code":"3922SLL"},{"id":10845446,"change_date":"2024-10-30 21:40:00","inspection_id":"82904443","insp_violation_id":"262625263","seq_no":"2","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"203646258","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:35.000000Z","updated_at":"2025-03-17T21:58:35.000000Z","normalized_code":"3939ALCL"},{"id":10845447,"change_date":"2024-10-30 21:40:00","inspection_id":"82904443","insp_violation_id":"262625264","seq_no":"3","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"203646258","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:35.000000Z","updated_at":"2025-03-17T21:58:35.000000Z","normalized_code":"3939ALIL"},{"id":10845448,"change_date":"2024-10-30 21:40:00","inspection_id":"82904443","insp_violation_id":"262625265","seq_no":"4","part_no":"392","part_no_section":"2-SLLEWG3","insp_viol_unit":"1","insp_unit_id":"203646258","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V130350-5","created_at":"2025-03-17T21:58:35.000000Z","updated_at":"2025-03-17T21:58:35.000000Z","normalized_code":"3922SLLEWG3"},{"id":10845449,"change_date":"2024-10-30 21:40:00","inspection_id":"82904443","insp_violation_id":"262625266","seq_no":"5","part_no":"393","part_no_section":"55D1-B","insp_viol_unit":"1","insp_unit_id":"203646258","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:35.000000Z","updated_at":"2025-03-17T21:58:35.000000Z","normalized_code":"39355D1B"}],"inspection_per_units":[{"id":11220030,"change_date":"2024-10-30 21:40:00","inspection_id":"82904443","insp_unit_id":"203646258","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"26","insp_unit_license":"50704A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1M2AV04CXEM011903","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:11.000000Z","updated_at":"2025-03-17T23:39:11.000000Z"}]},{"id":6170068,"change_date":"2024-07-09 21:42:00","inspection_id":"82065500","dot_number":"517926","report_state":"CT","report_number":"3010003471","insp_date":"2024-07-09 00:00:00","insp_start_time":"0600","insp_end_time":"0626","registration_date":null,"region":"ET","ci_status_code":"C","location":"049","location_desc":"ENFIELD","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":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-07-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"67400","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":"712067","transaction_code":"A","transaction_date":"2024-07-09 00:00:00","upload_date":"2024-07-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00517926","upload_search_indicator":null,"census_search_date":"2024-07-09 21:42:00","snet_input_date":"2024-07-09 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-07-09 21:42:00","insp_carrier_name":"WINDSOR SANITATION INC","insp_carrier_street":"33 MUCKO RD","insp_carrier_city":"BLOOMFIELD","insp_carrier_state":"CT","insp_carrier_zip_code":"06002","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:25:01.000000Z","updated_at":"2025-03-17T20:25:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9939562,"change_date":"2024-07-09 21:42:00","inspection_id":"82065500","insp_unit_id":"201782274","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"29","insp_unit_license":"57765A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1NKZX4EX5GJ486887","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:59.000000Z","updated_at":"2025-03-17T23:25:59.000000Z"}]},{"id":5960347,"change_date":"2024-06-11 21:42:00","inspection_id":"81839252","dot_number":"517926","report_state":"MA","report_number":"CL00003808","insp_date":"2024-06-10 00:00:00","insp_start_time":"1104","insp_end_time":"1130","registration_date":"2024-06-11 00:00:00","region":"ET","ci_status_code":"C","location":"311H","location_desc":"H-SPRINGFIELD","county_code_state":"MA","county_code":"013","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER OWNED","shipping_paper_number":"ROLL OFF","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-11 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"82000","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":"493551","transaction_code":"A","transaction_date":"2024-06-11 00:00:00","upload_date":"2024-06-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00517926","upload_search_indicator":"M","census_search_date":"2024-06-11 21:42:00","snet_input_date":"2024-06-10 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-06-11 21:42:00","insp_carrier_name":"WINDSOR SANITATION INC","insp_carrier_street":"33 MUCKO RD","insp_carrier_city":"BLOOMFIELD","insp_carrier_state":"CT","insp_carrier_zip_code":"06002","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:21:01.000000Z","updated_at":"2025-03-17T20:21:01.000000Z","inspection_violations":[{"id":9247064,"change_date":"2024-06-11 21:42:00","inspection_id":"81839252","insp_violation_id":"260015050","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"699997AC","created_at":"2025-03-17T21:50:45.000000Z","updated_at":"2025-03-17T21:50:45.000000Z","normalized_code":"3922"},{"id":9247065,"change_date":"2024-06-11 21:42:00","inspection_id":"81839252","insp_violation_id":"260015051","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2025-03-17T21:50:45.000000Z","updated_at":"2025-03-17T21:50:45.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9600597,"change_date":"2024-06-11 21:42:00","inspection_id":"81839252","insp_unit_id":"201330364","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"47","insp_unit_license":"77919A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1NKZX4TX2SJ377217","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:34.000000Z","updated_at":"2025-03-17T23:22:34.000000Z"}]},{"id":5516513,"change_date":"2024-04-16 21:40:00","inspection_id":"81356889","dot_number":"517926","report_state":"CT","report_number":"3132004491","insp_date":"2024-04-16 00:00:00","insp_start_time":"1458","insp_end_time":"1505","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-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"53800","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":"705046","transaction_code":"A","transaction_date":"2024-04-16 00:00:00","upload_date":"2024-04-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00517926","upload_search_indicator":null,"census_search_date":"2024-04-16 21:40:00","snet_input_date":"2024-04-16 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-04-16 21:40:00","insp_carrier_name":"WINDSOR SANITATION INC","insp_carrier_street":"33 MUCKO RD","insp_carrier_city":"BLOOMFIELD","insp_carrier_state":"CT","insp_carrier_zip_code":"06002","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:11:59.000000Z","updated_at":"2025-03-17T20:11:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8885962,"change_date":"2024-04-16 21:40:00","inspection_id":"81356889","insp_unit_id":"200407220","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"70204A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1M2GR4GC7KM001245","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:41.000000Z","updated_at":"2025-03-17T23:15:41.000000Z"}]},{"id":5355365,"change_date":"2024-03-25 21:40:00","inspection_id":"81180982","dot_number":"517926","report_state":"CT","report_number":"3091005312","insp_date":"2024-03-25 00:00:00","insp_start_time":"1009","insp_end_time":"1027","registration_date":null,"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":"WINDSOR SANITATION INC","shipping_paper_number":"0000112299","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-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"703148","transaction_code":"A","transaction_date":"2024-03-25 00:00:00","upload_date":"2024-03-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00517926","upload_search_indicator":null,"census_search_date":"2024-03-25 21:40:00","snet_input_date":"2024-03-25 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-03-25 21:40:00","insp_carrier_name":"WINDSOR SANITATION INC","insp_carrier_street":"33 MUCKO RD","insp_carrier_city":"BLOOMFIELD","insp_carrier_state":"CT","insp_carrier_zip_code":"06002","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:08:42.000000Z","updated_at":"2025-03-17T20:08:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8624371,"change_date":"2024-03-25 21:40:00","inspection_id":"81180982","insp_unit_id":"200058732","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"36","insp_unit_license":"76727A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1M2AX07C1AM009196","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:12.000000Z","updated_at":"2025-03-17T23:13:12.000000Z"}]},{"id":5130443,"change_date":"2024-03-05 21:40:00","inspection_id":"80935810","dot_number":"517926","report_state":"CT","report_number":"3017999749","insp_date":"2024-02-26 00:00:00","insp_start_time":"0934","insp_end_time":"0957","registration_date":"2024-03-05 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":"MULTI","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-26 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"700554","transaction_code":"C","transaction_date":"2024-02-26 00:00:00","upload_date":"2024-03-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00517926","upload_search_indicator":null,"census_search_date":"2024-02-26 21:41:00","snet_input_date":"2024-02-26 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-02-26 21:41:00","insp_carrier_name":"WINDSOR SANITATION INC","insp_carrier_street":"33 MUCKO RD","insp_carrier_city":"BLOOMFIELD","insp_carrier_state":"CT","insp_carrier_zip_code":"06002","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:04:13.000000Z","updated_at":"2025-03-17T20:04:13.000000Z","inspection_violations":[{"id":7911668,"change_date":"2024-03-05 21:40:00","inspection_id":"80935810","insp_violation_id":"258196151","seq_no":"1","part_no":"392","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199750075","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"V126396-6","created_at":"2025-03-17T21:44:13.000000Z","updated_at":"2025-03-17T21:44:13.000000Z","normalized_code":"3929A"}],"inspection_per_units":[{"id":8259938,"change_date":"2024-03-05 21:40:00","inspection_id":"80935810","insp_unit_id":"199750075","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"AUTO","insp_unit_company":null,"insp_unit_license":"72236A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"5VCACLUF7JC225529","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:50.000000Z","updated_at":"2025-03-17T23:09:50.000000Z"}]},{"id":4368519,"change_date":"2023-11-09 21:40:00","inspection_id":"80100711","dot_number":"517926","report_state":"CT","report_number":"3010003036","insp_date":"2023-11-07 00:00:00","insp_start_time":"0730","insp_end_time":"0812","registration_date":"2023-11-09 00:00:00","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":"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-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"690894","transaction_code":"C","transaction_date":"2023-11-07 00:00:00","upload_date":"2023-11-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00517926","upload_search_indicator":null,"census_search_date":"2023-11-07 21:40:00","snet_input_date":"2023-11-07 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-11-07 21:40:00","insp_carrier_name":"WINDSOR SANITATION INC","insp_carrier_street":"33 MUCKO RD","insp_carrier_city":"BLOOMFIELD","insp_carrier_state":"CT","insp_carrier_zip_code":"06002","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:49:31.000000Z","updated_at":"2025-03-17T19:49:31.000000Z","inspection_violations":[{"id":6758603,"change_date":"2023-11-09 21:40:00","inspection_id":"80100711","insp_violation_id":"256300968","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197977142","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:30.000000Z","updated_at":"2025-03-17T21:38:30.000000Z","normalized_code":"3922"},{"id":6758604,"change_date":"2023-11-09 21:40:00","inspection_id":"80100711","insp_violation_id":"256300969","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197977142","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:30.000000Z","updated_at":"2025-03-17T21:38:30.000000Z","normalized_code":"3922"},{"id":6758605,"change_date":"2023-11-09 21:40:00","inspection_id":"80100711","insp_violation_id":"256300970","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197977142","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:30.000000Z","updated_at":"2025-03-17T21:38:30.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":7025966,"change_date":"2023-11-09 21:40:00","inspection_id":"80100711","insp_unit_id":"197977142","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"36","insp_unit_license":"64794A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1M2AX07C1AM009196","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:59.000000Z","updated_at":"2025-03-17T22:58:59.000000Z"}]},{"id":3626834,"change_date":"2023-11-06 21:41:00","inspection_id":"79276398","dot_number":"517926","report_state":"CT","report_number":"3120003983","insp_date":"2023-07-31 00:00:00","insp_start_time":"1115","insp_end_time":"1203","registration_date":"2023-11-05 00:00:00","region":"ET","ci_status_code":"C","location":"011","location_desc":"BLOOMFIELD","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"ENFIELD CARPET","shipping_paper_number":"94062","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-31 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"4","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"682030","transaction_code":"C","transaction_date":"2023-07-31 00:00:00","upload_date":"2023-11-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00517926","upload_search_indicator":null,"census_search_date":"2023-07-31 21:40:00","snet_input_date":"2023-07-31 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-07-31 21:40:00","insp_carrier_name":"WINDSOR SANITATION INC","insp_carrier_street":"33 MUCKO RD","insp_carrier_city":"BLOOMFIELD","insp_carrier_state":"CT","insp_carrier_zip_code":"06002","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":5593113,"change_date":"2023-11-06 21:41:00","inspection_id":"79276398","insp_violation_id":"256224671","seq_no":"1","part_no":"391","part_no_section":"45(b)","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:32:55.000000Z","updated_at":"2025-03-17T21:32:55.000000Z","normalized_code":"39145B"},{"id":5593114,"change_date":"2023-11-06 21:41:00","inspection_id":"79276398","insp_violation_id":"256224672","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197911515","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"Y998093-3","created_at":"2025-03-17T21:32:55.000000Z","updated_at":"2025-03-17T21:32:55.000000Z","normalized_code":"3922"},{"id":5593115,"change_date":"2023-11-06 21:41:00","inspection_id":"79276398","insp_violation_id":"256224673","seq_no":"3","part_no":"393","part_no_section":"134(b)(3)","insp_viol_unit":"1","insp_unit_id":"197911515","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"Y998094-4","created_at":"2025-03-17T21:32:55.000000Z","updated_at":"2025-03-17T21:32:55.000000Z","normalized_code":"393134B3"},{"id":5593116,"change_date":"2023-11-06 21:41:00","inspection_id":"79276398","insp_violation_id":"256224674","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197911515","insp_violation_category_id":"14","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":"3922"}],"inspection_per_units":[{"id":5831385,"change_date":"2023-11-06 21:41:00","inspection_id":"79276398","insp_unit_id":"197911515","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"35","insp_unit_license":"63119A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1M2AL02C96M002135","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":3425798,"change_date":"2023-07-05 21:41:00","inspection_id":"79050550","dot_number":"517926","report_state":"CT","report_number":"3025002600","insp_date":"2023-07-03 00:00:00","insp_start_time":"1403","insp_end_time":"1417","registration_date":"2023-07-05 00:00:00","region":"ET","ci_status_code":"C","location":"164","location_desc":"WINDSOR","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"0168560001","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-04 21:32:00","post_acc_ind":"N","gross_comb_veh_wt":"67400","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":"679384","transaction_code":"C","transaction_date":"2023-07-03 00:00:00","upload_date":"2023-07-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00517926","upload_search_indicator":null,"census_search_date":"2023-07-04 21:32:00","snet_input_date":"2023-07-03 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-07-04 21:32:00","insp_carrier_name":"WINDSOR SANITATION INC","insp_carrier_street":"33 MUCKO RD","insp_carrier_city":"BLOOMFIELD","insp_carrier_state":"CT","insp_carrier_zip_code":"06002","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:30:55.000000Z","updated_at":"2025-03-17T19:30:55.000000Z","inspection_violations":[{"id":5282685,"change_date":"2023-07-05 21:41:00","inspection_id":"79050550","insp_violation_id":"253855242","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:31:33.000000Z","updated_at":"2025-03-17T21:31:33.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":5507804,"change_date":"2023-07-05 21:41:00","inspection_id":"79050550","insp_unit_id":"195814262","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"15","insp_unit_license":"49277A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"2NKDX9TX2SM648356","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:28.000000Z","updated_at":"2025-03-17T22:46:28.000000Z"}]},{"id":2472751,"change_date":"2023-03-01 21:41:00","inspection_id":"77971638","dot_number":"517926","report_state":"CT","report_number":"0779000783","insp_date":"2023-03-01 00:00:00","insp_start_time":"0715","insp_end_time":"0735","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":"WINDSOR SANITATION","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-01 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"53800","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":"667890","transaction_code":"A","transaction_date":"2023-03-01 00:00:00","upload_date":"2023-03-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00517926","upload_search_indicator":null,"census_search_date":"2023-03-01 21:41:00","snet_input_date":"2023-03-01 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-03-01 21:41:00","insp_carrier_name":"WINDSOR SANITATION INC","insp_carrier_street":"33 MUCKO RD","insp_carrier_city":"BLOOMFIELD","insp_carrier_state":"CT","insp_carrier_zip_code":"06002","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:12:09.000000Z","updated_at":"2025-03-17T19:12:09.000000Z","inspection_violations":[{"id":3806020,"change_date":"2023-03-01 21:41:00","inspection_id":"77971638","insp_violation_id":"251396690","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:24:54.000000Z","updated_at":"2025-03-17T21:24:54.000000Z","normalized_code":"3922"},{"id":3806021,"change_date":"2023-03-01 21:41:00","inspection_id":"77971638","insp_violation_id":"251396691","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:54.000000Z","updated_at":"2025-03-17T21:24:54.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3979729,"change_date":"2023-03-01 21:41:00","inspection_id":"77971638","insp_unit_id":"193632351","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"001","insp_unit_license":"70204A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1M2GR4GC7KM001245","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:29.000000Z","updated_at":"2025-03-17T22:34:29.000000Z"}]},{"id":1701570,"change_date":"2022-11-09 21:39:00","inspection_id":"77090159","dot_number":"517926","report_state":"CT","report_number":"3078001356","insp_date":"2022-11-09 00:00:00","insp_start_time":"1425","insp_end_time":"1435","registration_date":null,"region":"ET","ci_status_code":"C","location":"164","location_desc":"WINDSOR","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-09 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"0","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":"658415","transaction_code":"A","transaction_date":"2022-11-09 00:00:00","upload_date":"2022-11-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00517926","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":"WINDSOR SANITATION INC","insp_carrier_street":"33 MUCKO RD","insp_carrier_city":"BLOOMFIELD","insp_carrier_state":"CT","insp_carrier_zip_code":"06002","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":[{"id":2667388,"change_date":"2022-11-09 21:39:00","inspection_id":"77090159","insp_violation_id":"249503674","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:19:34.000000Z","updated_at":"2025-03-17T21:19:34.000000Z","normalized_code":"39216A"},{"id":2667389,"change_date":"2022-11-09 21:39:00","inspection_id":"77090159","insp_violation_id":"249503675","seq_no":"2","part_no":"392","part_no_section":"82(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"Y992020-6","created_at":"2025-03-17T21:19:34.000000Z","updated_at":"2025-03-17T21:19:34.000000Z","normalized_code":"39282A1"}],"inspection_per_units":[{"id":2737913,"change_date":"2022-11-09 21:39:00","inspection_id":"77090159","insp_unit_id":"191870190","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"1-108","insp_unit_license":"57765A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1NKZX4EX5GJ486887","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:44.000000Z","updated_at":"2025-03-17T22:25:44.000000Z"}]},{"id":785402,"change_date":"2022-07-11 21:41:00","inspection_id":"76026397","dot_number":"517926","report_state":"CT","report_number":"3120003097","insp_date":"2022-07-09 00:00:00","insp_start_time":"0527","insp_end_time":"0554","registration_date":null,"region":"ET","ci_status_code":"C","location":"119","location_desc":"ROCKY HILL","county_code_state":"CT","county_code":"003","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"WINDSOR SANITATION INC","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-07-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"77600","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"648452","transaction_code":"A","transaction_date":"2022-07-09 00:00:00","upload_date":"2022-07-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00517926","upload_search_indicator":null,"census_search_date":"2022-07-11 21:41:00","snet_input_date":"2022-07-09 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-07-11 21:41:00","insp_carrier_name":"WINDSOR SANITATION INC","insp_carrier_street":"33 MUCKO RD","insp_carrier_city":"BLOOMFIELD","insp_carrier_state":"CT","insp_carrier_zip_code":"06002","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:41:34.000000Z","updated_at":"2025-03-17T18:41:34.000000Z","inspection_violations":[{"id":1238862,"change_date":"2022-07-11 21:41:00","inspection_id":"76026397","insp_violation_id":"246990391","seq_no":"1","part_no":"393","part_no_section":"134(b)(3)","insp_viol_unit":"1","insp_unit_id":"189689847","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"Y989796-1","created_at":"2025-03-17T21:12:47.000000Z","updated_at":"2025-03-17T21:12:47.000000Z","normalized_code":"393134B3"}],"inspection_per_units":[{"id":1263699,"change_date":"2022-07-11 21:41:00","inspection_id":"76026397","insp_unit_id":"189689847","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"29","insp_unit_license":"57765A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1NKZX4EX5GJ486887","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:57.000000Z","updated_at":"2025-03-17T22:15:57.000000Z"}]},{"id":775540,"change_date":"2022-07-08 21:40:00","inspection_id":"76015008","dot_number":"517926","report_state":"CT","report_number":"3061001671","insp_date":"2022-07-01 00:00:00","insp_start_time":"1445","insp_end_time":"1501","registration_date":null,"region":"ET","ci_status_code":"C","location":"064","location_desc":"HARTFORD","county_code_state":"CT","county_code":"003","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-07-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"67400","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"648029","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":"00517926","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":"WINDSOR SANITATION INC","insp_carrier_street":"33 MUCKO RD","insp_carrier_city":"BLOOMFIELD","insp_carrier_state":"CT","insp_carrier_zip_code":"06002","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":[{"id":1225183,"change_date":"2022-07-08 21:40:00","inspection_id":"76015008","insp_violation_id":"246965700","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:12:46.000000Z","updated_at":"2025-03-17T21:12:46.000000Z","normalized_code":"39216A"},{"id":1225184,"change_date":"2022-07-08 21:40:00","inspection_id":"76015008","insp_violation_id":"246965701","seq_no":"2","part_no":"393","part_no_section":"134","insp_viol_unit":"1","insp_unit_id":"189665982","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:12:46.000000Z","updated_at":"2025-03-17T21:12:46.000000Z","normalized_code":"393134"}],"inspection_per_units":[{"id":1247972,"change_date":"2022-07-08 21:40:00","inspection_id":"76015008","insp_unit_id":"189665982","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"1","insp_unit_license":"49277A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"2NKDX9TX2SM648356","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"}]},{"id":403000,"change_date":"2022-05-17 21:42:00","inspection_id":"75573681","dot_number":"517926","report_state":"CT","report_number":"3129003151","insp_date":"2022-05-13 00:00:00","insp_start_time":"1335","insp_end_time":"1352","registration_date":null,"region":"ET","ci_status_code":"C","location":"164","location_desc":"WINDSOR","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"111","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-05-17 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"29500","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":"644501","transaction_code":"A","transaction_date":"2022-05-13 00:00:00","upload_date":"2022-05-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00517926","upload_search_indicator":null,"census_search_date":"2022-05-17 21:42:00","snet_input_date":"2022-05-13 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-05-17 21:42:00","insp_carrier_name":"WINDSOR SANITATION INC","insp_carrier_street":"33 MUCKO RD","insp_carrier_city":"BLOOMFIELD","insp_carrier_state":"CT","insp_carrier_zip_code":"06002","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:34:45.000000Z","updated_at":"2025-03-17T18:34:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":650868,"change_date":"2022-05-17 21:42:00","inspection_id":"75573681","insp_unit_id":"188714504","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"32","insp_unit_license":"61954A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1NKZX4EX5JJ199458","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:12.000000Z","updated_at":"2025-03-17T22:12:12.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/517926\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/517926\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/517926\/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\/517926\/inspections","per_page":100,"prev_page_url":null,"to":30,"total":30}