{"current_page":1,"data":[{"id":12075415,"change_date":"2026-06-02 21:41:00","inspection_id":"88017847","dot_number":"1451726","report_state":"NY","report_number":"D507501777","insp_date":"2026-06-01 00:00:00","insp_start_time":"1317","insp_end_time":"1342","registration_date":null,"region":"ED","ci_status_code":"C","location":"40714E","location_desc":"CHURCHVILLE NY","county_code_state":"NY","county_code":"055","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","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":"3448342","transaction_code":"A","transaction_date":"2026-06-02 00:00:00","upload_date":"2026-06-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01451726","upload_search_indicator":null,"census_search_date":"2026-06-02 21:41:00","snet_input_date":"2026-06-01 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-02 21:41:00","insp_carrier_name":"H2OLEK PLUMBING INC","insp_carrier_street":"1200 BUFFALO ROAD","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14624","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-06-06T09:40:24.000000Z","updated_at":"2026-06-13T09:31:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20984794,"change_date":"2026-06-02 21:41:00","inspection_id":"88017847","insp_unit_id":"213867735","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"R18","insp_unit_license":"67158NG","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDUF4HT5JEB80727","insp_unit_decal":"Y","insp_unit_decal_number":"36369656","created_at":"2026-06-06T09:17:16.000000Z","updated_at":"2026-06-13T09:02:11.000000Z"}]},{"id":10226033,"change_date":"2025-11-18 21:38:00","inspection_id":"86347974","dot_number":"1451726","report_state":"NY","report_number":"M606700596","insp_date":"2025-11-17 00:00:00","insp_start_time":"1149","insp_end_time":"1224","registration_date":null,"region":"ES","ci_status_code":"C","location":"40714W","location_desc":"CHURCHVILLE NY","county_code_state":"NY","county_code":"055","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-11-18 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"14200","viol_total":"6","oos_total":"2","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2554936","transaction_code":"A","transaction_date":"2025-11-18 00:00:00","upload_date":"2025-11-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01451726","upload_search_indicator":null,"census_search_date":"2025-11-18 21:38:00","snet_input_date":"2025-11-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-11-18 21:38:00","insp_carrier_name":"H2OLEK PLUMBING INC","insp_carrier_street":"1200 BUFFALO ROAD","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14624","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-11-21T10:31:42.000000Z","updated_at":"2025-11-23T10:30:28.000000Z","inspection_violations":[{"id":17000619,"change_date":"2025-11-18 21:38:00","inspection_id":"86347974","insp_violation_id":"270025405","seq_no":"1","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"210087223","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-21T10:32:48.000000Z","updated_at":"2025-11-23T10:30:42.000000Z","normalized_code":"39395A1"},{"id":17000620,"change_date":"2025-11-18 21:38:00","inspection_id":"86347974","insp_violation_id":"270025406","seq_no":"2","part_no":"393","part_no_section":"55B-B","insp_viol_unit":"1","insp_unit_id":"210087223","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-21T10:32:48.000000Z","updated_at":"2025-11-23T10:30:42.000000Z","normalized_code":"39355BB"},{"id":17000622,"change_date":"2025-11-18 21:38:00","inspection_id":"86347974","insp_violation_id":"270025408","seq_no":"4","part_no":"390","part_no_section":"21TC-MC","insp_viol_unit":"1","insp_unit_id":"210087223","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-21T10:32:48.000000Z","updated_at":"2025-11-23T10:30:42.000000Z","normalized_code":"39021TCMC"},{"id":17000623,"change_date":"2025-11-18 21:38:00","inspection_id":"86347974","insp_violation_id":"270025409","seq_no":"5","part_no":"391","part_no_section":"41APC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-21T10:32:48.000000Z","updated_at":"2025-11-23T10:30:42.000000Z","normalized_code":"39141APC"},{"id":17000624,"change_date":"2025-11-18 21:38:00","inspection_id":"86347974","insp_violation_id":"270025410","seq_no":"6","part_no":"393","part_no_section":"41-BNPB","insp_viol_unit":"1","insp_unit_id":"210087223","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-11-21T10:32:48.000000Z","updated_at":"2025-11-23T10:30:42.000000Z","normalized_code":"39341BNPB"},{"id":17000621,"change_date":"2025-11-18 21:38:00","inspection_id":"86347974","insp_violation_id":"270025407","seq_no":"3","part_no":"393","part_no_section":"80A","insp_viol_unit":"1","insp_unit_id":"210087223","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-21T10:32:48.000000Z","updated_at":"2025-11-23T10:30:42.000000Z","normalized_code":"39380A"}],"inspection_per_units":[{"id":17039834,"change_date":"2025-11-18 21:38:00","inspection_id":"86347974","insp_unit_id":"210087223","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":"W2","insp_unit_license":"52673NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GB6GUCG7G1224168","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-21T10:01:51.000000Z","updated_at":"2025-11-23T10:00:35.000000Z"}]},{"id":8858219,"change_date":"2025-06-10 21:40:00","inspection_id":"84908351","dot_number":"1451726","report_state":"NY","report_number":"SPE3020614","insp_date":"2025-06-03 00:00:00","insp_start_time":"1202","insp_end_time":"1234","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"ROCHESTER NY","county_code_state":"NY","county_code":"055","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-06-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"30500","viol_total":"8","oos_total":"4","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1844064","transaction_code":"A","transaction_date":"2025-06-09 00:00:00","upload_date":"2025-06-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01451726","upload_search_indicator":null,"census_search_date":"2025-06-10 21:40:00","snet_input_date":"2025-06-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-06-10 21:40:00","insp_carrier_name":"H2OLEK PLUMBING INC","insp_carrier_street":"1200 BUFFALO ROAD","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14624","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-06-14T10:00:41.000000Z","updated_at":"2025-06-14T10:00:41.000000Z","inspection_violations":[{"id":14188667,"change_date":"2025-06-10 21:40:00","inspection_id":"84908351","insp_violation_id":"266752304","seq_no":"1","part_no":"393","part_no_section":"9A-LSLI","insp_viol_unit":"2","insp_unit_id":"207304677","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-13T10:16:40.000000Z","updated_at":"2025-06-14T10:15:20.000000Z","normalized_code":"3939ALSLI"},{"id":14188668,"change_date":"2025-06-10 21:40:00","inspection_id":"84908351","insp_violation_id":"266752305","seq_no":"2","part_no":"393","part_no_section":"9A-LHWS","insp_viol_unit":"2","insp_unit_id":"207304677","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-13T10:16:40.000000Z","updated_at":"2025-06-14T10:15:20.000000Z","normalized_code":"3939ALHWS"},{"id":14188669,"change_date":"2025-06-10 21:40:00","inspection_id":"84908351","insp_violation_id":"266752306","seq_no":"3","part_no":"393","part_no_section":"130B-CHVE","insp_viol_unit":"2","insp_unit_id":"207304677","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-06-13T10:16:40.000000Z","updated_at":"2025-06-14T10:15:20.000000Z","normalized_code":"393130BCHVE"},{"id":14188670,"change_date":"2025-06-10 21:40:00","inspection_id":"84908351","insp_violation_id":"266752307","seq_no":"4","part_no":"393","part_no_section":"43DBMA","insp_viol_unit":"2","insp_unit_id":"207304677","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-06-13T10:16:40.000000Z","updated_at":"2025-06-14T10:15:20.000000Z","normalized_code":"39343DBMA"},{"id":14188671,"change_date":"2025-06-10 21:40:00","inspection_id":"84908351","insp_violation_id":"266752308","seq_no":"5","part_no":"393","part_no_section":"9A-LTSI","insp_viol_unit":"2","insp_unit_id":"207304677","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"8E24KDX1VL","created_at":"2025-06-13T10:16:40.000000Z","updated_at":"2025-06-14T10:15:20.000000Z","normalized_code":"3939ALTSI"},{"id":14188672,"change_date":"2025-06-10 21:40:00","inspection_id":"84908351","insp_violation_id":"266752309","seq_no":"6","part_no":"383","part_no_section":"23A2-LCDLN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-13T10:16:40.000000Z","updated_at":"2025-06-14T10:15:20.000000Z","normalized_code":"38323A2LCDLN"},{"id":14188673,"change_date":"2025-06-10 21:40:00","inspection_id":"84908351","insp_violation_id":"266752310","seq_no":"7","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"207304676","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-13T10:16:40.000000Z","updated_at":"2025-06-14T10:15:20.000000Z","normalized_code":"3922SLLIFTA"},{"id":14188674,"change_date":"2025-06-10 21:40:00","inspection_id":"84908351","insp_violation_id":"266752311","seq_no":"8","part_no":"392","part_no_section":"7A-D","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-06-13T10:16:40.000000Z","updated_at":"2025-06-14T10:15:20.000000Z","normalized_code":"3927AD"}],"inspection_per_units":[{"id":14506178,"change_date":"2025-06-10 21:40:00","inspection_id":"84908351","insp_unit_id":"207304676","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"R18","insp_unit_license":"10177ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDUF4HT5JEB80727","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-13T09:45:40.000000Z","updated_at":"2025-06-14T09:45:14.000000Z"},{"id":14506179,"change_date":"2025-06-10 21:40:00","inspection_id":"84908351","insp_unit_id":"207304677","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"CB83552","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4P5F82020H1267442","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-13T09:45:40.000000Z","updated_at":"2025-06-14T09:45:14.000000Z"}]},{"id":8672891,"change_date":"2025-05-19 21:39:00","inspection_id":"84712246","dot_number":"1451726","report_state":"NY","report_number":"SPE3000129","insp_date":"2025-05-12 00:00:00","insp_start_time":"1255","insp_end_time":"1322","registration_date":null,"region":"ED","ci_status_code":"C","location":"40658","location_desc":"PHELPS NY","county_code_state":"NY","county_code":"069","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-05-19 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1748752","transaction_code":"A","transaction_date":"2025-05-19 00:00:00","upload_date":"2025-05-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01451726","upload_search_indicator":null,"census_search_date":"2025-05-19 21:39:00","snet_input_date":"2025-05-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-19 21:39:00","insp_carrier_name":"H2OLEK PLUMBING INC","insp_carrier_street":"1200 BUFFALO ROAD","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14624","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-05-22T10:01:15.000000Z","updated_at":"2025-05-23T10:03:54.000000Z","inspection_violations":[{"id":13805620,"change_date":"2025-05-19 21:39:00","inspection_id":"84712246","insp_violation_id":"266309730","seq_no":"1","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"206934988","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-22T10:17:37.000000Z","updated_at":"2025-05-23T10:20:22.000000Z","normalized_code":"39378AWS"},{"id":13805621,"change_date":"2025-05-19 21:39:00","inspection_id":"84712246","insp_violation_id":"266309731","seq_no":"2","part_no":"391","part_no_section":"41APC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-22T10:17:37.000000Z","updated_at":"2025-05-23T10:20:22.000000Z","normalized_code":"39141APC"},{"id":13805622,"change_date":"2025-05-19 21:39:00","inspection_id":"84712246","insp_violation_id":"266309732","seq_no":"3","part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"1","insp_unit_id":"206934988","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-22T10:17:37.000000Z","updated_at":"2025-05-23T10:20:22.000000Z","normalized_code":"3939ALRLI"},{"id":13805623,"change_date":"2025-05-19 21:39:00","inspection_id":"84712246","insp_violation_id":"266309733","seq_no":"4","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"206934988","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-22T10:17:37.000000Z","updated_at":"2025-05-23T10:20:22.000000Z","normalized_code":"39395A1"}],"inspection_per_units":[{"id":14166692,"change_date":"2025-05-19 21:39:00","inspection_id":"84712246","insp_unit_id":"206934988","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":null,"insp_unit_license":"60897NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DCDW1D8MS205030","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-22T09:45:56.000000Z","updated_at":"2025-05-23T09:48:49.000000Z"}]},{"id":7857098,"change_date":"2025-02-13 21:39:00","inspection_id":"83853905","dot_number":"1451726","report_state":"NY","report_number":"SPE3010378","insp_date":"2025-02-06 00:00:00","insp_start_time":"1325","insp_end_time":"1355","registration_date":null,"region":"ES","ci_status_code":"C","location":"40504M","location_desc":"MANCHESTER NY","county_code_state":"NY","county_code":"069","insp_level_id":"2","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":"U","pen_cen_match":"I","final_status_date":"2025-02-13 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"14200","viol_total":"6","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1356520","transaction_code":"A","transaction_date":"2025-02-13 00:00:00","upload_date":"2025-02-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01451726","upload_search_indicator":null,"census_search_date":"2025-02-13 21:39:00","snet_input_date":"2025-02-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-13 21:39:00","insp_carrier_name":"H2OLEK PLUMBING INC","insp_carrier_street":"1200 BUFFALO ROAD","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14624","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T21:01:14.000000Z","updated_at":"2025-03-17T21:01:14.000000Z","inspection_violations":[{"id":12280374,"change_date":"2025-02-13 21:39:00","inspection_id":"83853905","insp_violation_id":"264493956","seq_no":"1","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"205299245","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:58.000000Z","updated_at":"2025-03-17T22:05:58.000000Z","normalized_code":"3939ALIL"},{"id":12280375,"change_date":"2025-02-13 21:39:00","inspection_id":"83853905","insp_violation_id":"264493957","seq_no":"2","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"205299245","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:58.000000Z","updated_at":"2025-03-17T22:05:58.000000Z","normalized_code":"3939ALCL"},{"id":12280376,"change_date":"2025-02-13 21:39:00","inspection_id":"83853905","insp_violation_id":"264493958","seq_no":"3","part_no":"396","part_no_section":"9D2-FTF","insp_viol_unit":"1","insp_unit_id":"205299245","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:58.000000Z","updated_at":"2025-03-17T22:05:58.000000Z","normalized_code":"3969D2FTF"},{"id":12280377,"change_date":"2025-02-13 21:39:00","inspection_id":"83853905","insp_violation_id":"264493959","seq_no":"4","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"205299245","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:58.000000Z","updated_at":"2025-03-17T22:05:58.000000Z","normalized_code":"39360C"},{"id":12280378,"change_date":"2025-02-13 21:39:00","inspection_id":"83853905","insp_violation_id":"264493960","seq_no":"5","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"1","insp_unit_id":"205299245","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:58.000000Z","updated_at":"2025-03-17T22:05:58.000000Z","normalized_code":"3939ALLPL"},{"id":12280379,"change_date":"2025-02-13 21:39:00","inspection_id":"83853905","insp_violation_id":"264493961","seq_no":"6","part_no":"393","part_no_section":"41-BNPB","insp_viol_unit":"1","insp_unit_id":"205299245","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:05:58.000000Z","updated_at":"2025-03-17T22:05:58.000000Z","normalized_code":"39341BNPB"}],"inspection_per_units":[{"id":12681153,"change_date":"2025-02-13 21:39:00","inspection_id":"83853905","insp_unit_id":"205299245","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":"W2","insp_unit_license":"52673NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GB6GUCG7G1224168","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:05.000000Z","updated_at":"2025-03-17T23:55:05.000000Z"}]},{"id":7664574,"change_date":"2025-01-20 21:34:00","inspection_id":"83651607","dot_number":"1451726","report_state":"NY","report_number":"SPT3080359","insp_date":"2025-01-13 00:00:00","insp_start_time":"1446","insp_end_time":"1526","registration_date":null,"region":"ES","ci_status_code":"C","location":"40504M","location_desc":"MANCHESTER NY","county_code_state":"NY","county_code":"069","insp_level_id":"2","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":"U","pen_cen_match":"I","final_status_date":"2025-01-20 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","viol_total":"9","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":"1269104","transaction_code":"A","transaction_date":"2025-01-20 00:00:00","upload_date":"2025-01-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01451726","upload_search_indicator":null,"census_search_date":"2025-01-20 21:34:00","snet_input_date":"2025-01-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-20 21:34:00","insp_carrier_name":"H2OLEK PLUMBING INC","insp_carrier_street":"1200 BUFFALO ROAD","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14624","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:57:25.000000Z","updated_at":"2025-03-17T20:57:25.000000Z","inspection_violations":[{"id":11974888,"change_date":"2025-01-20 21:34:00","inspection_id":"83651607","insp_violation_id":"264084807","seq_no":"1","part_no":"390","part_no_section":"19B2-BIENNIAL","insp_viol_unit":"1","insp_unit_id":"204920396","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:19.000000Z","updated_at":"2025-03-17T22:04:19.000000Z","normalized_code":"39019B2BIENNIAL"},{"id":11974889,"change_date":"2025-01-20 21:34:00","inspection_id":"83651607","insp_violation_id":"264084808","seq_no":"2","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-03-17T22:04:19.000000Z","updated_at":"2025-03-17T22:04:19.000000Z","normalized_code":"3922SLLDL"},{"id":11974890,"change_date":"2025-01-20 21:34:00","inspection_id":"83651607","insp_violation_id":"264084809","seq_no":"3","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"204920396","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"3T80JWW6XD","created_at":"2025-03-17T22:04:19.000000Z","updated_at":"2025-03-17T22:04:19.000000Z","normalized_code":"39378AWS"},{"id":11974891,"change_date":"2025-01-20 21:34:00","inspection_id":"83651607","insp_violation_id":"264084810","seq_no":"4","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"204920396","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:19.000000Z","updated_at":"2025-03-17T22:04:19.000000Z","normalized_code":"3939ALIL"},{"id":11974892,"change_date":"2025-01-20 21:34:00","inspection_id":"83651607","insp_violation_id":"264084811","seq_no":"5","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"204920396","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:19.000000Z","updated_at":"2025-03-17T22:04:19.000000Z","normalized_code":"3939ALCL"},{"id":11974893,"change_date":"2025-01-20 21:34:00","inspection_id":"83651607","insp_violation_id":"264084812","seq_no":"6","part_no":"393","part_no_section":"80A","insp_viol_unit":"1","insp_unit_id":"204920396","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:19.000000Z","updated_at":"2025-03-17T22:04:19.000000Z","normalized_code":"39380A"},{"id":11974894,"change_date":"2025-01-20 21:34:00","inspection_id":"83651607","insp_violation_id":"264084813","seq_no":"7","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"204920396","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:19.000000Z","updated_at":"2025-03-17T22:04:19.000000Z","normalized_code":"39360C"},{"id":11974895,"change_date":"2025-01-20 21:34:00","inspection_id":"83651607","insp_violation_id":"264084814","seq_no":"8","part_no":"393","part_no_section":"75C-TAOTD-LT2\/32","insp_viol_unit":"1","insp_unit_id":"204920396","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:19.000000Z","updated_at":"2025-03-17T22:04:19.000000Z","normalized_code":"39375CTAOTDLT2\/32"},{"id":11974896,"change_date":"2025-01-20 21:34:00","inspection_id":"83651607","insp_violation_id":"264084815","seq_no":"9","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"204920396","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:19.000000Z","updated_at":"2025-03-17T22:04:19.000000Z","normalized_code":"3922SLLEQP"}],"inspection_per_units":[{"id":12367689,"change_date":"2025-01-20 21:34:00","inspection_id":"83651607","insp_unit_id":"204920396","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":"W2","insp_unit_license":"52673NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GB6GUCG7G1224168","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:29.000000Z","updated_at":"2025-03-17T23:51:29.000000Z"}]},{"id":7496294,"change_date":"2024-12-25 21:32:00","inspection_id":"83474917","dot_number":"1451726","report_state":"NY","report_number":"SPE3080175","insp_date":"2024-12-18 00:00:00","insp_start_time":"1359","insp_end_time":"1415","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"ROCHESTER NY","county_code_state":"NY","county_code":"055","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":"U","pen_cen_match":"I","final_status_date":"2024-12-25 21:32:00","post_acc_ind":"N","gross_comb_veh_wt":"14200","viol_total":"1","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":"1192536","transaction_code":"A","transaction_date":"2024-12-25 00:00:00","upload_date":"2024-12-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01451726","upload_search_indicator":null,"census_search_date":"2024-12-25 21:32:00","snet_input_date":"2024-12-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-12-25 21:32:00","insp_carrier_name":"H2OLEK PLUMBING INC","insp_carrier_street":"1200 BUFFALO ROAD","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14624","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:52:21.000000Z","updated_at":"2025-03-17T20:52:21.000000Z","inspection_violations":[{"id":11717208,"change_date":"2024-12-25 21:32:00","inspection_id":"83474917","insp_violation_id":"263649076","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-03-17T22:03:03.000000Z","updated_at":"2025-03-17T22:03:03.000000Z","normalized_code":"3922SLLDL"}],"inspection_per_units":[{"id":12093246,"change_date":"2024-12-25 21:32:00","inspection_id":"83474917","insp_unit_id":"204548023","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":"W2","insp_unit_license":"52673NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GB6GUCG7G1224168","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:48:31.000000Z","updated_at":"2025-03-17T23:48:31.000000Z"}]},{"id":3158798,"change_date":"2023-05-30 21:41:00","inspection_id":"78749515","dot_number":"1451726","report_state":"NY","report_number":"SPE0320638","insp_date":"2023-05-26 00:00:00","insp_start_time":"1206","insp_end_time":"1244","registration_date":null,"region":"ET","ci_status_code":"C","location":"40857","location_desc":"VICTOR","county_code_state":"NY","county_code":"069","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"30500","viol_total":"4","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2829988","transaction_code":"A","transaction_date":"2023-05-30 00:00:00","upload_date":"2023-05-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01451726","upload_search_indicator":"M","census_search_date":"2023-05-30 21:41:00","snet_input_date":"2023-05-30 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-05-30 21:41:00","insp_carrier_name":"H2OLEK PLUMBING INC","insp_carrier_street":"1200 BUFFALO ROAD","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14624","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:25:24.000000Z","updated_at":"2025-03-17T19:25:24.000000Z","inspection_violations":[{"id":4865817,"change_date":"2023-05-30 21:41:00","inspection_id":"78749515","insp_violation_id":"253125756","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:29:39.000000Z","updated_at":"2025-03-17T21:29:39.000000Z","normalized_code":"38323A2"},{"id":4865818,"change_date":"2023-05-30 21:41:00","inspection_id":"78749515","insp_violation_id":"253125757","seq_no":"2","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:39.000000Z","updated_at":"2025-03-17T21:29:39.000000Z","normalized_code":"39141A"},{"id":4865819,"change_date":"2023-05-30 21:41:00","inspection_id":"78749515","insp_violation_id":"253125758","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195180651","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:39.000000Z","updated_at":"2025-03-17T21:29:39.000000Z","normalized_code":"3922"},{"id":4865820,"change_date":"2023-05-30 21:41:00","inspection_id":"78749515","insp_violation_id":"253125759","seq_no":"4","part_no":"393","part_no_section":"81","insp_viol_unit":"1","insp_unit_id":"195180651","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:39.000000Z","updated_at":"2025-03-17T21:29:39.000000Z","normalized_code":"39381"}],"inspection_per_units":[{"id":5079985,"change_date":"2023-05-30 21:41:00","inspection_id":"78749515","insp_unit_id":"195180651","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"10177ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDUF4HT5JEB80727","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:01.000000Z","updated_at":"2025-03-17T22:43:01.000000Z"},{"id":5079986,"change_date":"2023-05-30 21:41:00","inspection_id":"78749515","insp_unit_id":"195180652","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"CB83552","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4P5F82020H1267442","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:01.000000Z","updated_at":"2025-03-17T22:43:01.000000Z"}]},{"id":3175405,"change_date":"2023-05-31 21:41:00","inspection_id":"78768370","dot_number":"1451726","report_state":"NY","report_number":"SPE0273695","insp_date":"2023-05-25 00:00:00","insp_start_time":"1135","insp_end_time":"1200","registration_date":null,"region":"ET","ci_status_code":"C","location":"40658","location_desc":"PHELPS","county_code_state":"NY","county_code":"069","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"PRIVATE RESIDENCE","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-05-31 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"2","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2830650","transaction_code":"A","transaction_date":"2023-05-25 00:00:00","upload_date":"2023-05-31 00:00:00","upload_first_byte":"0","upload_dot_number":"01451726","upload_search_indicator":null,"census_search_date":"2023-05-31 21:41:00","snet_input_date":"2023-05-31 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-05-31 21:41:00","insp_carrier_name":"ROTO ROOTER","insp_carrier_street":"1200 BUFFALO RD","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14624","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:25:46.000000Z","updated_at":"2025-03-17T19:25:46.000000Z","inspection_violations":[{"id":4893724,"change_date":"2023-05-31 21:41:00","inspection_id":"78768370","insp_violation_id":"253170709","seq_no":"1","part_no":"391","part_no_section":"15(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"8","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:29:45.000000Z","updated_at":"2025-03-17T21:29:45.000000Z","normalized_code":"39115A"},{"id":4893725,"change_date":"2023-05-31 21:41:00","inspection_id":"78768370","insp_violation_id":"253170710","seq_no":"2","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:45.000000Z","updated_at":"2025-03-17T21:29:45.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":5107657,"change_date":"2023-05-31 21:41:00","inspection_id":"78768370","insp_unit_id":"195219759","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"60897NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DCDW1D8MS205030","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:15.000000Z","updated_at":"2025-03-17T22:43:15.000000Z"}]},{"id":2793664,"change_date":"2023-04-13 21:42:00","inspection_id":"78336970","dot_number":"1451726","report_state":"NY","report_number":"SPWE130638","insp_date":"2023-04-12 00:00:00","insp_start_time":"1502","insp_end_time":"1519","registration_date":null,"region":"ET","ci_status_code":"C","location":"40316R","location_desc":"GATES","county_code_state":"NY","county_code":"055","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":"2023-04-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"10090","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":"2815125","transaction_code":"A","transaction_date":"2023-04-12 00:00:00","upload_date":"2023-04-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01451726","upload_search_indicator":null,"census_search_date":"2023-04-13 21:42:00","snet_input_date":"2023-04-13 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-04-13 21:42:00","insp_carrier_name":"ROTO ROOTER SERIVICE","insp_carrier_street":"1200 BUFFALO ROAD","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14624","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:18:06.000000Z","updated_at":"2025-03-17T19:18:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4496081,"change_date":"2023-04-13 21:42:00","inspection_id":"78336970","insp_unit_id":"194360660","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"52673NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GB6GUCG7G1224168","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:27.000000Z","updated_at":"2025-03-17T22:38:27.000000Z"}]},{"id":2188992,"change_date":"2023-01-20 21:40:00","inspection_id":"77648250","dot_number":"1451726","report_state":"NY","report_number":"SPE0243019","insp_date":"2022-12-08 00:00:00","insp_start_time":"0800","insp_end_time":"0900","registration_date":null,"region":"ET","ci_status_code":"C","location":"40065","location_desc":"RIGA (WB)","county_code_state":"NY","county_code":"037","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":"2023-01-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"9","oos_total":"2","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2790773","transaction_code":"A","transaction_date":"2023-01-20 00:00:00","upload_date":"2023-01-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01451726","upload_search_indicator":"M","census_search_date":"2023-01-20 21:40:00","snet_input_date":"2023-01-20 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-01-20 21:40:00","insp_carrier_name":"H2OLEK PLUMBING INC","insp_carrier_street":"1200 BUFFALO ROAD","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14624","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:06:57.000000Z","updated_at":"2025-03-17T19:06:57.000000Z","inspection_violations":[{"id":3381784,"change_date":"2023-01-20 21:40:00","inspection_id":"77648250","insp_violation_id":"250680073","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:01.000000Z","updated_at":"2025-03-17T21:23:01.000000Z","normalized_code":"3922"},{"id":3381785,"change_date":"2023-01-20 21:40:00","inspection_id":"77648250","insp_violation_id":"250680074","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"192974346","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:01.000000Z","updated_at":"2025-03-17T21:23:01.000000Z","normalized_code":"3922"},{"id":3381786,"change_date":"2023-01-20 21:40:00","inspection_id":"77648250","insp_violation_id":"250680075","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"192974346","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:01.000000Z","updated_at":"2025-03-17T21:23:01.000000Z","normalized_code":"39617C"},{"id":3381787,"change_date":"2023-01-20 21:40:00","inspection_id":"77648250","insp_violation_id":"250680076","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"192974346","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:01.000000Z","updated_at":"2025-03-17T21:23:01.000000Z","normalized_code":"3922"},{"id":3381788,"change_date":"2023-01-20 21:40:00","inspection_id":"77648250","insp_violation_id":"250680077","seq_no":"5","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"192974347","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:01.000000Z","updated_at":"2025-03-17T21:23:01.000000Z","normalized_code":"39617C"},{"id":3381789,"change_date":"2023-01-20 21:40:00","inspection_id":"77648250","insp_violation_id":"250680078","seq_no":"6","part_no":"393","part_no_section":"104(f)(3)","insp_viol_unit":"2","insp_unit_id":"192974347","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:01.000000Z","updated_at":"2025-03-17T21:23:01.000000Z","normalized_code":"393104F3"},{"id":3381790,"change_date":"2023-01-20 21:40:00","inspection_id":"77648250","insp_violation_id":"250680079","seq_no":"7","part_no":"393","part_no_section":"110","insp_viol_unit":"2","insp_unit_id":"192974347","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:23:01.000000Z","updated_at":"2025-03-17T21:23:01.000000Z","normalized_code":"393110"},{"id":3381791,"change_date":"2023-01-20 21:40:00","inspection_id":"77648250","insp_violation_id":"250680080","seq_no":"8","part_no":"393","part_no_section":"42","insp_viol_unit":"2","insp_unit_id":"192974347","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:01.000000Z","updated_at":"2025-03-17T21:23:01.000000Z","normalized_code":"39342"},{"id":3381792,"change_date":"2023-01-20 21:40:00","inspection_id":"77648250","insp_violation_id":"250680081","seq_no":"9","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"192974347","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:23:01.000000Z","updated_at":"2025-03-17T21:23:01.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":3523271,"change_date":"2023-01-20 21:40:00","inspection_id":"77648250","insp_unit_id":"192974346","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"R18","insp_unit_license":"10177ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDUF4HT5JEB80727","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:16.000000Z","updated_at":"2025-03-17T22:31:16.000000Z"},{"id":3523272,"change_date":"2023-01-20 21:40:00","inspection_id":"77648250","insp_unit_id":"192974347","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"CB83552","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4P5F82020H1267442","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:16.000000Z","updated_at":"2025-03-17T22:31:16.000000Z"}]},{"id":1643113,"change_date":"2022-11-01 21:40:00","inspection_id":"77023243","dot_number":"1451726","report_state":"NY","report_number":"SPE0273293","insp_date":"2022-10-31 00:00:00","insp_start_time":"1015","insp_end_time":"1030","registration_date":null,"region":"ET","ci_status_code":"C","location":"40857","location_desc":"VICTOR EB","county_code_state":"NY","county_code":"069","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"ARIA ENERGY","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"44000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2764628","transaction_code":"A","transaction_date":"2022-11-01 00:00:00","upload_date":"2022-11-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01451726","upload_search_indicator":"M","census_search_date":"2022-11-01 21:40:00","snet_input_date":"2022-11-01 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-11-01 21:40:00","insp_carrier_name":"ROTO ROOTER","insp_carrier_street":"1200 BUFFALO ROAD","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14624","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:57:01.000000Z","updated_at":"2025-03-17T18:57:01.000000Z","inspection_violations":[{"id":2579459,"change_date":"2022-11-01 21:40:00","inspection_id":"77023243","insp_violation_id":"249359861","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191738452","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:08.000000Z","updated_at":"2025-03-17T21:19:08.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2643501,"change_date":"2022-11-01 21:40:00","inspection_id":"77023243","insp_unit_id":"191738452","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"STER","insp_unit_company":"R21","insp_unit_license":"55416NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"2FZMAZCV45AU86949","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:07.000000Z","updated_at":"2025-03-17T22:25:07.000000Z"}]},{"id":1154213,"change_date":"2022-08-29 21:41:00","inspection_id":"76457504","dot_number":"1451726","report_state":"NY","report_number":"0325001191","insp_date":"2022-08-26 00:00:00","insp_start_time":"1022","insp_end_time":"1110","registration_date":null,"region":"ET","ci_status_code":"C","location":"40504M","location_desc":"MANCHESTER EXIT 43 TANDEM LOT","county_code_state":"NY","county_code":"069","insp_level_id":"1","service_center":"EA","census_source_id":"4","insp_facility":"F","shipper_name":"H2OLEK PLUMBING INC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-08-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"145000","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":"2744248","transaction_code":"A","transaction_date":"2022-08-29 00:00:00","upload_date":"2022-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01451726","upload_search_indicator":"M","census_search_date":"2022-08-29 21:41:00","snet_input_date":"2022-08-29 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-08-29 21:41:00","insp_carrier_name":"H2OLEK PLUMBING INC","insp_carrier_street":"P O BOX 24770","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14624","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:47:57.000000Z","updated_at":"2025-03-17T18:47:57.000000Z","inspection_violations":[{"id":1830129,"change_date":"2022-08-29 21:41:00","inspection_id":"76457504","insp_violation_id":"248052411","seq_no":"1","part_no":"391","part_no_section":"41(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:29.000000Z","updated_at":"2025-03-17T21:15:29.000000Z","normalized_code":"39141A1"}],"inspection_per_units":[{"id":1855441,"change_date":"2022-08-29 21:41:00","inspection_id":"76457504","insp_unit_id":"190584631","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"W5","insp_unit_license":"60897NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DCDW1D8MS205030","insp_unit_decal":"Y","insp_unit_decal_number":"31688890","created_at":"2025-03-17T22:19:47.000000Z","updated_at":"2025-03-17T22:19:47.000000Z"}]},{"id":1130281,"change_date":"2022-08-25 21:42:00","inspection_id":"76429590","dot_number":"1451726","report_state":"NY","report_number":"SPWE080849","insp_date":"2022-08-24 00:00:00","insp_start_time":"1325","insp_end_time":"1341","registration_date":null,"region":"ET","ci_status_code":"C","location":"40714A","location_desc":"RIGA (EB)","county_code_state":"NY","county_code":"055","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-25 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"10980","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":"2743434","transaction_code":"A","transaction_date":"2022-08-25 00:00:00","upload_date":"2022-08-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01451726","upload_search_indicator":"M","census_search_date":"2022-08-25 21:42:00","snet_input_date":"2022-08-25 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-08-25 21:42:00","insp_carrier_name":"ROTO ROOTER","insp_carrier_street":"1200 BUFFALO ROAD","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14624","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:47:34.000000Z","updated_at":"2025-03-17T18:47:34.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1817776,"change_date":"2022-08-25 21:42:00","inspection_id":"76429590","insp_unit_id":"190530336","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"52673NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GB6GUCG7G1224168","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:32.000000Z","updated_at":"2025-03-17T22:19:32.000000Z"}]},{"id":68639,"change_date":"2022-03-30 21:39:00","inspection_id":"75172028","dot_number":"1451726","report_state":"NY","report_number":"0518000242","insp_date":"2022-03-29 00:00:00","insp_start_time":"0856","insp_end_time":"0915","registration_date":null,"region":"ET","ci_status_code":"C","location":"40857M","location_desc":"VICTOR PARKING AREA (EB)","county_code_state":"NY","county_code":"069","insp_level_id":"2","service_center":"EA","census_source_id":"4","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":"I","final_status_date":"2022-03-30 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"3","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2690347","transaction_code":"A","transaction_date":"2022-03-30 00:00:00","upload_date":"2022-03-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01451726","upload_search_indicator":"M","census_search_date":"2022-03-30 21:39:00","snet_input_date":"2022-03-30 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-03-30 21:39:00","insp_carrier_name":"H2OLEK PLUMBING INC","insp_carrier_street":"P O BOX 24770","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14624","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:28:47.000000Z","updated_at":"2025-03-17T18:28:47.000000Z","inspection_violations":[{"id":100430,"change_date":"2022-03-30 21:39:00","inspection_id":"75172028","insp_violation_id":"244852659","seq_no":"1","part_no":"391","part_no_section":"41(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:35.000000Z","updated_at":"2025-03-17T21:07:35.000000Z","normalized_code":"39141A1"},{"id":100431,"change_date":"2022-03-30 21:39:00","inspection_id":"75172028","insp_violation_id":"244852660","seq_no":"2","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"187888390","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:35.000000Z","updated_at":"2025-03-17T21:07:35.000000Z","normalized_code":"39021TB"},{"id":100432,"change_date":"2022-03-30 21:39:00","inspection_id":"75172028","insp_violation_id":"244852661","seq_no":"3","part_no":"390","part_no_section":"19(b)(2)","insp_viol_unit":"1","insp_unit_id":"187888390","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:35.000000Z","updated_at":"2025-03-17T21:07:35.000000Z","normalized_code":"39019B2"}],"inspection_per_units":[{"id":111347,"change_date":"2022-03-30 21:39:00","inspection_id":"75172028","insp_unit_id":"187888390","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"W-5","insp_unit_license":"60897NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DCDW1D8MS205030","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:54.000000Z","updated_at":"2025-03-17T22:08:54.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1451726\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1451726\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1451726\/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\/1451726\/inspections","per_page":100,"prev_page_url":null,"to":15,"total":15}