{"current_page":1,"data":[{"id":10803733,"change_date":"2026-01-19 21:34:00","inspection_id":"86830515","dot_number":"633956","report_state":"RI","report_number":"0232000030","insp_date":"2026-01-13 00:00:00","insp_start_time":"1545","insp_end_time":"1614","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"CRANSTON RI","county_code_state":"RI","county_code":"007","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":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-01-19 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"79500","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":"2785229","transaction_code":"A","transaction_date":"2026-01-18 00:00:00","upload_date":"2026-01-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00633956","upload_search_indicator":null,"census_search_date":"2026-01-19 21:34:00","snet_input_date":"2026-01-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-19 21:34:00","insp_carrier_name":"MIKES PROFESSIONAL TREE SERVICE INC","insp_carrier_street":"75 AIRPORT ROAD BUILDING 1B","insp_carrier_city":"COVENTRY","insp_carrier_state":"RI","insp_carrier_zip_code":"02816","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-01-22T10:36:01.000000Z","updated_at":"2026-01-30T10:30:10.000000Z","inspection_violations":[{"id":18053883,"change_date":"2026-01-19 21:34:00","inspection_id":"86830515","insp_violation_id":"271284805","seq_no":"1","part_no":"392","part_no_section":"2-SLLILC","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-01-22T10:42:00.000000Z","updated_at":"2026-01-30T10:30:21.000000Z","normalized_code":"3922SLLILC"},{"id":18053884,"change_date":"2026-01-19 21:34:00","inspection_id":"86830515","insp_violation_id":"271284806","seq_no":"2","part_no":"392","part_no_section":"9AA2-OA","insp_viol_unit":"1","insp_unit_id":"211161133","insp_violation_category_id":"51","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-01-22T10:42:00.000000Z","updated_at":"2026-01-30T10:30:21.000000Z","normalized_code":"3929AA2OA"},{"id":18053885,"change_date":"2026-01-19 21:34:00","inspection_id":"86830515","insp_violation_id":"271284807","seq_no":"3","part_no":"392","part_no_section":"2-SLLIRP","insp_viol_unit":"1","insp_unit_id":"211161133","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-22T10:42:00.000000Z","updated_at":"2026-01-30T10:30:21.000000Z","normalized_code":"3922SLLIRP"},{"id":18053886,"change_date":"2026-01-19 21:34:00","inspection_id":"86830515","insp_violation_id":"271284808","seq_no":"4","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"211161133","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-22T10:42:00.000000Z","updated_at":"2026-01-30T10:30:21.000000Z","normalized_code":"3922SLLIFTA"}],"inspection_per_units":[{"id":18139165,"change_date":"2026-01-19 21:34:00","inspection_id":"86830515","insp_unit_id":"211161133","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":null,"insp_unit_license":"93194","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"1NPCX4EX7MD760942","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-24T10:08:09.000000Z","updated_at":"2026-01-30T10:00:13.000000Z"}]},{"id":10243090,"change_date":"2025-11-20 21:39:00","inspection_id":"86366053","dot_number":"633956","report_state":"RI","report_number":"0203000660","insp_date":"2025-11-14 00:00:00","insp_start_time":"0910","insp_end_time":"0945","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"CRANSTON RI","county_code_state":"RI","county_code":"007","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":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-11-20 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"2","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":"2561992","transaction_code":"A","transaction_date":"2025-11-19 00:00:00","upload_date":"2025-11-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00633956","upload_search_indicator":null,"census_search_date":"2025-11-20 21:39:00","snet_input_date":"2025-11-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-11-20 21:39:00","insp_carrier_name":"MIKES PROFESSIONAL TREE SERVICE INC","insp_carrier_street":"75 AIRPORT ROAD BUILDING 1B","insp_carrier_city":"COVENTRY","insp_carrier_state":"RI","insp_carrier_zip_code":"02816","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-11-23T10:31:53.000000Z","updated_at":"2025-11-24T10:30:07.000000Z","inspection_violations":[{"id":17035864,"change_date":"2025-11-20 21:39:00","inspection_id":"86366053","insp_violation_id":"270076202","seq_no":"1","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-23T10:32:33.000000Z","updated_at":"2025-11-24T10:30:12.000000Z","normalized_code":"39141APC"},{"id":17035865,"change_date":"2025-11-20 21:39:00","inspection_id":"86366053","insp_violation_id":"270076203","seq_no":"2","part_no":"392","part_no_section":"2-SLLLR","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-11-23T10:32:33.000000Z","updated_at":"2025-11-24T10:30:12.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":17072600,"change_date":"2025-11-20 21:39:00","inspection_id":"86366053","insp_unit_id":"210131216","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"79346","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"1FD0X5HT9GED03262","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-23T10:01:53.000000Z","updated_at":"2025-11-24T10:00:15.000000Z"}]},{"id":9979729,"change_date":"2025-10-20 21:38:00","inspection_id":"86088831","dot_number":"633956","report_state":"RI","report_number":"0239000654","insp_date":"2025-10-14 00:00:00","insp_start_time":"1829","insp_end_time":"1900","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"WARWICK RI","county_code_state":"RI","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-10-20 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"79500","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":"2432113","transaction_code":"A","transaction_date":"2025-10-19 00:00:00","upload_date":"2025-10-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00633956","upload_search_indicator":null,"census_search_date":"2025-10-20 21:38:00","snet_input_date":"2025-10-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-20 21:38:00","insp_carrier_name":"MIKES PROFESSIONAL TREE SERVICE INC","insp_carrier_street":"75 AIRPORT ROAD BUILDING 1B","insp_carrier_city":"COVENTRY","insp_carrier_state":"RI","insp_carrier_zip_code":"02816","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-10-23T10:00:23.000000Z","updated_at":"2025-10-24T10:00:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16570347,"change_date":"2025-10-20 21:38:00","inspection_id":"86088831","insp_unit_id":"209543182","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":null,"insp_unit_license":"93194","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"1NPCX4EX7MD760942","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-23T09:45:31.000000Z","updated_at":"2025-10-24T09:45:10.000000Z"}]},{"id":9921673,"change_date":"2025-10-13 21:36:00","inspection_id":"86027164","dot_number":"633956","report_state":"RI","report_number":"M034000144","insp_date":"2025-10-07 00:00:00","insp_start_time":"1046","insp_end_time":"1122","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"NORTH KINGSTOWN RI","county_code_state":"RI","county_code":"009","insp_level_id":"1","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":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-10-13 21:36:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2401168","transaction_code":"A","transaction_date":"2025-10-12 00:00:00","upload_date":"2025-10-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00633956","upload_search_indicator":null,"census_search_date":"2025-10-13 21:36:00","snet_input_date":"2025-10-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-13 21:36:00","insp_carrier_name":"MIKES PROFESSIONAL TREE SERVICE INC","insp_carrier_street":"75 AIRPORT ROAD BUILDING 1B","insp_carrier_city":"COVENTRY","insp_carrier_state":"RI","insp_carrier_zip_code":"02816","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-10-16T10:00:29.000000Z","updated_at":"2025-10-17T10:00:13.000000Z","inspection_violations":[{"id":16372248,"change_date":"2025-10-13 21:36:00","inspection_id":"86027164","insp_violation_id":"269254921","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWG1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"25502502764","created_at":"2025-10-16T10:15:43.000000Z","updated_at":"2025-10-17T10:15:18.000000Z","normalized_code":"3922SLLEWG1"}],"inspection_per_units":[{"id":16466641,"change_date":"2025-10-13 21:36:00","inspection_id":"86027164","insp_unit_id":"209429995","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"95322","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"1FDUF5HT3LED12523","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-16T09:45:39.000000Z","updated_at":"2025-10-17T09:45:15.000000Z"}]},{"id":8211684,"change_date":"2025-04-02 21:41:00","inspection_id":"84227165","dot_number":"633956","report_state":"RI","report_number":"00DP004645","insp_date":"2025-03-25 00:00:00","insp_start_time":"1430","insp_end_time":"1451","registration_date":null,"region":"ET","ci_status_code":"C","location":"60","location_desc":"RT 95S @ EXIT 28B (RT 295)","county_code_state":"RI","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":"Y","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":"2025-03-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"86641","transaction_code":"C","transaction_date":"2025-04-02 00:00:00","upload_date":"2025-04-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00633956","upload_search_indicator":"M","census_search_date":"2025-03-26 21:40:00","snet_input_date":"2025-03-25 00:00:00","source_office":"1RIS001","mcmis_add_date":"2025-03-26 21:40:00","insp_carrier_name":"MIKES PROFESSIONAL TREE SERVICE INC","insp_carrier_street":"75 AIRPORT ROAD BUILDING 1B","insp_carrier_city":"COVENTRY","insp_carrier_state":"RI","insp_carrier_zip_code":"02816","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-29T10:21:14.000000Z","updated_at":"2025-04-06T10:23:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13387979,"change_date":"2025-04-02 21:41:00","inspection_id":"84227165","insp_unit_id":"206117338","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"50575","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"1FDUF5HT3KDA11156","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-05T10:05:47.000000Z","updated_at":"2025-04-06T09:51:50.000000Z"}]},{"id":7561527,"change_date":"2025-01-07 21:39:00","inspection_id":"83543364","dot_number":"633956","report_state":"RI","report_number":"0203000141","insp_date":"2024-12-31 00:00:00","insp_start_time":"1137","insp_end_time":"1229","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"WARWICK RI","county_code_state":"RI","county_code":"003","insp_level_id":"2","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-01-07 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"2","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":"1222217","transaction_code":"A","transaction_date":"2025-01-07 00:00:00","upload_date":"2025-01-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00633956","upload_search_indicator":null,"census_search_date":"2025-01-07 21:39:00","snet_input_date":"2024-12-31 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-07 21:39:00","insp_carrier_name":"MIKES PROFESSIONAL TREE SERVICE INC","insp_carrier_street":"75 AIRPORT ROAD BUILDING 1B","insp_carrier_city":"COVENTRY","insp_carrier_state":"RI","insp_carrier_zip_code":"02816","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:55:14.000000Z","updated_at":"2025-03-17T20:55:14.000000Z","inspection_violations":[{"id":11820231,"change_date":"2025-01-07 21:39:00","inspection_id":"83543364","insp_violation_id":"263785707","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWG1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:37.000000Z","updated_at":"2025-03-17T22:03:37.000000Z","normalized_code":"3922SLLEWG1"},{"id":11820232,"change_date":"2025-01-07 21:39:00","inspection_id":"83543364","insp_violation_id":"263785708","seq_no":"2","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"204678685","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:37.000000Z","updated_at":"2025-03-17T22:03:37.000000Z","normalized_code":"3939ALIL"}],"inspection_per_units":[{"id":12200608,"change_date":"2025-01-07 21:39:00","inspection_id":"83543364","insp_unit_id":"204678685","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"95322","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"1FDUF5HT3LED12523","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:42.000000Z","updated_at":"2025-03-17T23:49:42.000000Z"}]},{"id":6383867,"change_date":"2024-08-05 21:41:00","inspection_id":"82294572","dot_number":"633956","report_state":"RI","report_number":"0070000420","insp_date":"2024-07-30 00:00:00","insp_start_time":"1858","insp_end_time":"1940","registration_date":null,"region":"ED","ci_status_code":"C","location":"95 SB","location_desc":"WARWICK RI","county_code_state":"RI","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-08-05 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"716396","transaction_code":"A","transaction_date":"2024-08-05 00:00:00","upload_date":"2024-08-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00633956","upload_search_indicator":null,"census_search_date":"2024-08-05 21:41:00","snet_input_date":"2024-07-30 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-05 21:41:00","insp_carrier_name":"MIKES PROFESSIONAL TREE SERVICE INC","insp_carrier_street":"17A RESERVOIR ROAD","insp_carrier_city":"COVENTRY","insp_carrier_state":"RI","insp_carrier_zip_code":"02816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:29:28.000000Z","updated_at":"2025-03-17T20:29:28.000000Z","inspection_violations":[{"id":9908406,"change_date":"2024-08-05 21:41:00","inspection_id":"82294572","insp_violation_id":"260996949","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"24001526725","created_at":"2025-03-17T21:53:55.000000Z","updated_at":"2025-03-17T21:53:55.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10287800,"change_date":"2024-08-05 21:41:00","inspection_id":"82294572","insp_unit_id":"202221515","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"76410","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"1NKDL40X7DJ369532","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:33.000000Z","updated_at":"2025-03-17T23:29:33.000000Z"}]},{"id":6077585,"change_date":"2024-06-26 21:42:00","inspection_id":"81966053","dot_number":"633956","report_state":"RI","report_number":"0070000297","insp_date":"2024-06-20 00:00:00","insp_start_time":"0650","insp_end_time":"0750","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"WARWICK RI","county_code_state":"RI","county_code":"003","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-06-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"79500","viol_total":"5","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":"600678","transaction_code":"A","transaction_date":"2024-06-26 00:00:00","upload_date":"2024-06-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00633956","upload_search_indicator":null,"census_search_date":"2024-06-26 21:42:00","snet_input_date":"2024-06-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-06-26 21:42:00","insp_carrier_name":"MIKES PROFESSIONAL TREE SERVICE INC","insp_carrier_street":"17A RESERVOIR ROAD","insp_carrier_city":"COVENTRY","insp_carrier_state":"RI","insp_carrier_zip_code":"02816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:23:02.000000Z","updated_at":"2025-03-17T20:23:02.000000Z","inspection_violations":[{"id":9431581,"change_date":"2024-06-26 21:42:00","inspection_id":"81966053","insp_violation_id":"260313436","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"201593019","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:37.000000Z","updated_at":"2025-03-17T21:51:37.000000Z","normalized_code":"39617C"},{"id":9431582,"change_date":"2024-06-26 21:42:00","inspection_id":"81966053","insp_violation_id":"260313437","seq_no":"2","part_no":"393","part_no_section":"78(a)","insp_viol_unit":"1","insp_unit_id":"201593019","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:37.000000Z","updated_at":"2025-03-17T21:51:37.000000Z","normalized_code":"39378A"},{"id":9431583,"change_date":"2024-06-26 21:42:00","inspection_id":"81966053","insp_violation_id":"260313438","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201593019","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:37.000000Z","updated_at":"2025-03-17T21:51:37.000000Z","normalized_code":"3939A"},{"id":9431584,"change_date":"2024-06-26 21:42:00","inspection_id":"81966053","insp_violation_id":"260313439","seq_no":"4","part_no":"393","part_no_section":"75(a)(4)","insp_viol_unit":"1","insp_unit_id":"201593019","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:37.000000Z","updated_at":"2025-03-17T21:51:37.000000Z","normalized_code":"39375A4"},{"id":9431585,"change_date":"2024-06-26 21:42:00","inspection_id":"81966053","insp_violation_id":"260313440","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"24001521617","created_at":"2025-03-17T21:51:37.000000Z","updated_at":"2025-03-17T21:51:37.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9788969,"change_date":"2024-06-26 21:42:00","inspection_id":"81966053","insp_unit_id":"201593019","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":null,"insp_unit_license":"93194","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"1NPCX4EX7MD760942","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:22.000000Z","updated_at":"2025-03-17T23:24:22.000000Z"}]},{"id":5845668,"change_date":"2024-05-28 21:42:00","inspection_id":"81714792","dot_number":"633956","report_state":"RI","report_number":"0058000213","insp_date":"2024-05-22 00:00:00","insp_start_time":"1125","insp_end_time":"1158","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"WARWICK RI","county_code_state":"RI","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","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":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-05-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"3","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":"517732","transaction_code":"A","transaction_date":"2024-05-28 00:00:00","upload_date":"2024-05-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00633956","upload_search_indicator":null,"census_search_date":"2024-05-28 21:42:00","snet_input_date":"2024-05-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-05-28 21:42:00","insp_carrier_name":"MIKES PROFESSIONAL TREE SERVICE INC","insp_carrier_street":"17A RESERVOIR ROAD","insp_carrier_city":"COVENTRY","insp_carrier_state":"RI","insp_carrier_zip_code":"02816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:18:39.000000Z","updated_at":"2025-03-17T20:18:39.000000Z","inspection_violations":[{"id":9060721,"change_date":"2024-05-28 21:42:00","inspection_id":"81714792","insp_violation_id":"259737019","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":null,"created_at":"2025-03-17T21:49:49.000000Z","updated_at":"2025-03-17T21:49:49.000000Z","normalized_code":"3922"},{"id":9060722,"change_date":"2024-05-28 21:42:00","inspection_id":"81714792","insp_violation_id":"259737020","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:49:49.000000Z","updated_at":"2025-03-17T21:49:49.000000Z","normalized_code":"39141A"},{"id":9060723,"change_date":"2024-05-28 21:42:00","inspection_id":"81714792","insp_violation_id":"259737021","seq_no":"3","part_no":"390","part_no_section":"21T(b)(1)","insp_viol_unit":"1","insp_unit_id":"201091097","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:49.000000Z","updated_at":"2025-03-17T21:49:49.000000Z","normalized_code":"39021TB1"}],"inspection_per_units":[{"id":9414883,"change_date":"2024-05-28 21:42:00","inspection_id":"81714792","insp_unit_id":"201091097","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"50575","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"1FDUF5HT3KDA11156","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:41.000000Z","updated_at":"2025-03-17T23:20:41.000000Z"}]},{"id":5198837,"change_date":"2024-03-04 21:41:00","inspection_id":"81010092","dot_number":"633956","report_state":"RI","report_number":"M035000039","insp_date":"2024-02-27 00:00:00","insp_start_time":"0848","insp_end_time":"0930","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"NORTH KINGSTOWN RI","county_code_state":"RI","county_code":"009","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-03-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"2","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":"290082","transaction_code":"A","transaction_date":"2024-03-04 00:00:00","upload_date":"2024-03-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00633956","upload_search_indicator":null,"census_search_date":"2024-03-04 21:41:00","snet_input_date":"2024-02-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-03-04 21:41:00","insp_carrier_name":"MIKES PROFESSIONAL TREE SERVICE INC","insp_carrier_street":"17A RESERVOIR ROAD","insp_carrier_city":"COVENTRY","insp_carrier_state":"RI","insp_carrier_zip_code":"02816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:05:24.000000Z","updated_at":"2025-03-17T20:05:24.000000Z","inspection_violations":[{"id":8015165,"change_date":"2024-03-04 21:41:00","inspection_id":"81010092","insp_violation_id":"258177277","seq_no":"1","part_no":"383","part_no_section":"71C-LCDL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:43.000000Z","updated_at":"2025-03-17T21:44:43.000000Z","normalized_code":"38371CLCDL"},{"id":8015166,"change_date":"2024-03-04 21:41:00","inspection_id":"81010092","insp_violation_id":"258177278","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"24502500465","created_at":"2025-03-17T21:44:43.000000Z","updated_at":"2025-03-17T21:44:43.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8371310,"change_date":"2024-03-04 21:41:00","inspection_id":"81010092","insp_unit_id":"199729590","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"95322","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"1FDUF5HT3LED12523","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:51.000000Z","updated_at":"2025-03-17T23:10:51.000000Z"}]},{"id":4680135,"change_date":"2023-12-21 21:38:00","inspection_id":"80443710","dot_number":"633956","report_state":"RI","report_number":"0084000055","insp_date":"2023-12-20 00:00:00","insp_start_time":"1105","insp_end_time":"1136","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"NEWPORT RI","county_code_state":"RI","county_code":null,"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":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2023-12-21 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"76650","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":"140047","transaction_code":"A","transaction_date":"2023-12-21 00:00:00","upload_date":"2023-12-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00633956","upload_search_indicator":null,"census_search_date":"2023-12-21 21:38:00","snet_input_date":"2023-12-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-12-21 21:38:00","insp_carrier_name":"MIKES PROFESSIONAL TREE SERVICE INC","insp_carrier_street":"17A RESERVOIR ROAD","insp_carrier_city":"COVENTRY","insp_carrier_state":"RI","insp_carrier_zip_code":"02816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:55:43.000000Z","updated_at":"2025-03-17T19:55:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7527411,"change_date":"2023-12-21 21:38:00","inspection_id":"80443710","insp_unit_id":"198611557","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"89355","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"1M2AL02C07M005779","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:18.000000Z","updated_at":"2025-03-17T23:03:18.000000Z"}]},{"id":4647995,"change_date":"2023-12-18 21:41:00","inspection_id":"80408492","dot_number":"633956","report_state":"RI","report_number":"0084000050","insp_date":"2023-12-15 00:00:00","insp_start_time":"1140","insp_end_time":"1228","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"CUMEBRLAND RI","county_code_state":"RI","county_code":"007","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":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2023-12-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"79500","viol_total":"2","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":"134864","transaction_code":"A","transaction_date":"2023-12-18 00:00:00","upload_date":"2023-12-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00633956","upload_search_indicator":null,"census_search_date":"2023-12-18 21:41:00","snet_input_date":"2023-12-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-12-18 21:41:00","insp_carrier_name":"MIKES PROFESSIONAL TREE SERVICE INC","insp_carrier_street":"17A RESERVOIR ROAD","insp_carrier_city":"COVENTRY","insp_carrier_state":"RI","insp_carrier_zip_code":"02816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:54:57.000000Z","updated_at":"2025-03-17T19:54:57.000000Z","inspection_violations":[{"id":7185654,"change_date":"2023-12-18 21:41:00","inspection_id":"80408492","insp_violation_id":"256926410","seq_no":"1","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:43.000000Z","updated_at":"2025-03-17T21:40:43.000000Z","normalized_code":"3922SLL"},{"id":7185655,"change_date":"2023-12-18 21:41:00","inspection_id":"80408492","insp_violation_id":"256926411","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"23001545624","created_at":"2025-03-17T21:40:43.000000Z","updated_at":"2025-03-17T21:40:43.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7475446,"change_date":"2023-12-18 21:41:00","inspection_id":"80408492","insp_unit_id":"198542867","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":null,"insp_unit_license":"93194","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"1NPCX4EX7MD760942","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:51.000000Z","updated_at":"2025-03-17T23:02:51.000000Z"}]},{"id":4111471,"change_date":"2023-12-12 21:41:00","inspection_id":"79816745","dot_number":"633956","report_state":"RI","report_number":"00DP003004","insp_date":"2023-09-30 00:00:00","insp_start_time":"1147","insp_end_time":"1227","registration_date":null,"region":"ET","ci_status_code":"C","location":"28","location_desc":"RT 95S @ EXIT 31C (JEFFERSON)","county_code_state":"RI","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":"Y","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":"2023-10-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"3","oos_total":"1","driver_viol_total":"3","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"84419","transaction_code":"C","transaction_date":"2023-12-12 00:00:00","upload_date":"2023-12-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00633956","upload_search_indicator":"M","census_search_date":"2023-10-03 21:40:00","snet_input_date":"2023-09-30 00:00:00","source_office":"1RIS001","mcmis_add_date":"2023-10-03 21:40:00","insp_carrier_name":"MIKES PROFESSIONAL TREE SERVICE INC","insp_carrier_street":"17A RESERVOIR ROAD","insp_carrier_city":"COVENTRY","insp_carrier_state":"RI","insp_carrier_zip_code":"02816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:44:03.000000Z","updated_at":"2025-03-17T19:44:03.000000Z","inspection_violations":[{"id":6362523,"change_date":"2023-12-12 21:41:00","inspection_id":"79816745","insp_violation_id":"256838921","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:42.000000Z","updated_at":"2025-03-17T21:36:42.000000Z","normalized_code":"3922"},{"id":6362524,"change_date":"2023-12-12 21:41:00","inspection_id":"79816745","insp_violation_id":"256838922","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:36:42.000000Z","updated_at":"2025-03-17T21:36:42.000000Z","normalized_code":"39141A"},{"id":6362525,"change_date":"2023-12-12 21:41:00","inspection_id":"79816745","insp_violation_id":"256838923","seq_no":"3","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":"3","citation_number":null,"created_at":"2025-03-17T21:36:42.000000Z","updated_at":"2025-03-17T21:36:42.000000Z","normalized_code":"39115A"}],"inspection_per_units":[{"id":6610395,"change_date":"2023-12-12 21:41:00","inspection_id":"79816745","insp_unit_id":"198463182","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"95322","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"1FDUF5HT3LED12523","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:28.000000Z","updated_at":"2025-03-17T22:55:28.000000Z"}]},{"id":3394241,"change_date":"2023-11-01 21:43:00","inspection_id":"79015194","dot_number":"633956","report_state":"RI","report_number":"00DM000475","insp_date":"2023-06-29 00:00:00","insp_start_time":"1313","insp_end_time":"1334","registration_date":null,"region":"ET","ci_status_code":"C","location":"145","location_desc":"RT 4 NORTH","county_code_state":"RI","county_code":"003","insp_level_id":"2","service_center":"EA","census_source_id":"4","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":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"U","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-06-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"82967","transaction_code":"C","transaction_date":"2023-11-01 00:00:00","upload_date":"2023-11-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00633956","upload_search_indicator":"M","census_search_date":"2023-06-29 21:41:00","snet_input_date":"2023-06-29 00:00:00","source_office":"1RIS001","mcmis_add_date":"2023-06-29 21:41:00","insp_carrier_name":"MIKES PROFESSIONAL TREE SERVICE INC","insp_carrier_street":"17A RESERVOIR ROAD","insp_carrier_city":"COVENTRY","insp_carrier_state":"RI","insp_carrier_zip_code":"02816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:30:12.000000Z","updated_at":"2025-03-17T19:30:12.000000Z","inspection_violations":[{"id":5233807,"change_date":"2023-11-01 21:43:00","inspection_id":"79015194","insp_violation_id":"256157334","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:17.000000Z","updated_at":"2025-03-17T21:31:17.000000Z","normalized_code":"39216A"},{"id":5233808,"change_date":"2023-11-01 21:43:00","inspection_id":"79015194","insp_violation_id":"256157335","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"197849719","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:17.000000Z","updated_at":"2025-03-17T21:31:17.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":5456767,"change_date":"2023-11-01 21:43:00","inspection_id":"79015194","insp_unit_id":"197849719","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"94864","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"1FVACWFC6KHKS6634","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:03.000000Z","updated_at":"2025-03-17T22:46:03.000000Z"}]},{"id":3077672,"change_date":"2023-08-22 21:42:00","inspection_id":"78658160","dot_number":"633956","report_state":"RI","report_number":"00SH001929","insp_date":"2023-05-18 00:00:00","insp_start_time":"1027","insp_end_time":"1048","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ROUTE 3 AT 95","county_code_state":"RI","county_code":"009","insp_level_id":"1","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":null,"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":"Y","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":"2023-05-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"82314","transaction_code":"C","transaction_date":"2023-08-22 00:00:00","upload_date":"2023-08-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00633956","upload_search_indicator":"M","census_search_date":"2023-05-18 21:42:00","snet_input_date":"2023-05-18 00:00:00","source_office":"1RIS001","mcmis_add_date":"2023-05-18 21:42:00","insp_carrier_name":"MIKES PROFESSIONAL TREE SERVICE INC","insp_carrier_street":"17A RESERVOIR ROAD","insp_carrier_city":"COVENTRY","insp_carrier_state":"RI","insp_carrier_zip_code":"02816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:23:49.000000Z","updated_at":"2025-03-17T19:23:49.000000Z","inspection_violations":[{"id":4730354,"change_date":"2023-08-22 21:42:00","inspection_id":"78658160","insp_violation_id":"254792591","seq_no":"1","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:02.000000Z","updated_at":"2025-03-17T21:29:02.000000Z","normalized_code":"39141A"},{"id":4730355,"change_date":"2023-08-22 21:42:00","inspection_id":"78658160","insp_violation_id":"254792592","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"196654121","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:02.000000Z","updated_at":"2025-03-17T21:29:02.000000Z","normalized_code":"39617C"},{"id":4730356,"change_date":"2023-08-22 21:42:00","inspection_id":"78658160","insp_violation_id":"254792593","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"196654121","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:02.000000Z","updated_at":"2025-03-17T21:29:02.000000Z","normalized_code":"39378"},{"id":4730357,"change_date":"2023-08-22 21:42:00","inspection_id":"78658160","insp_violation_id":"254792594","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196654121","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:02.000000Z","updated_at":"2025-03-17T21:29:02.000000Z","normalized_code":"3922"},{"id":4730358,"change_date":"2023-08-22 21:42:00","inspection_id":"78658160","insp_violation_id":"254792595","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196654121","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:02.000000Z","updated_at":"2025-03-17T21:29:02.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":4950452,"change_date":"2023-08-22 21:42:00","inspection_id":"78658160","insp_unit_id":"196654121","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"95322","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"1FDUF5HT3LED12523","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:03.000000Z","updated_at":"2025-03-17T22:42:03.000000Z"}]},{"id":2928200,"change_date":"2023-07-28 21:40:00","inspection_id":"78489441","dot_number":"633956","report_state":"RI","report_number":"00DM000400","insp_date":"2023-04-27 00:00:00","insp_start_time":"1748","insp_end_time":"1914","registration_date":null,"region":"ET","ci_status_code":"C","location":"15","location_desc":"RT 95S @ EXIT 7","county_code_state":"RI","county_code":"003","insp_level_id":"1","service_center":"EA","census_source_id":"4","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":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-05-01 21:39:00","post_acc_ind":"Y","gross_comb_veh_wt":"19500","viol_total":"16","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":"81813","transaction_code":"C","transaction_date":"2023-07-28 00:00:00","upload_date":"2023-07-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00633956","upload_search_indicator":"M","census_search_date":"2023-05-01 21:39:00","snet_input_date":"2023-05-01 00:00:00","source_office":"1RIS001","mcmis_add_date":"2023-05-01 21:39:00","insp_carrier_name":"MIKES PROFESSIONAL TREE SERVICE INC","insp_carrier_street":"17A RESERVOIR ROAD","insp_carrier_city":"COVENTRY","insp_carrier_state":"RI","insp_carrier_zip_code":"02816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:20:54.000000Z","updated_at":"2025-03-17T19:20:54.000000Z","inspection_violations":[{"id":4496310,"change_date":"2023-07-28 21:40:00","inspection_id":"78489441","insp_violation_id":"254334543","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196241896","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:56.000000Z","updated_at":"2025-03-17T21:27:56.000000Z","normalized_code":"3922"},{"id":4496311,"change_date":"2023-07-28 21:40:00","inspection_id":"78489441","insp_violation_id":"254334544","seq_no":"2","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"196241896","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:56.000000Z","updated_at":"2025-03-17T21:27:56.000000Z","normalized_code":"39021TB"},{"id":4496312,"change_date":"2023-07-28 21:40:00","inspection_id":"78489441","insp_violation_id":"254334545","seq_no":"3","part_no":"393","part_no_section":"201(a)","insp_viol_unit":"1","insp_unit_id":"196241896","insp_violation_category_id":"19","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:27:56.000000Z","updated_at":"2025-03-17T21:27:56.000000Z","normalized_code":"393201A"},{"id":4496313,"change_date":"2023-07-28 21:40:00","inspection_id":"78489441","insp_violation_id":"254334546","seq_no":"4","part_no":"393","part_no_section":"86(b)(1)","insp_viol_unit":"1","insp_unit_id":"196241896","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:56.000000Z","updated_at":"2025-03-17T21:27:56.000000Z","normalized_code":"39386B1"},{"id":4496314,"change_date":"2023-07-28 21:40:00","inspection_id":"78489441","insp_violation_id":"254334547","seq_no":"5","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"1","insp_unit_id":"196241896","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:27:56.000000Z","updated_at":"2025-03-17T21:27:56.000000Z","normalized_code":"393207A"},{"id":4496315,"change_date":"2023-07-28 21:40:00","inspection_id":"78489441","insp_violation_id":"254334548","seq_no":"6","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"196241896","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:56.000000Z","updated_at":"2025-03-17T21:27:56.000000Z","normalized_code":"3965B"},{"id":4496316,"change_date":"2023-07-28 21:40:00","inspection_id":"78489441","insp_violation_id":"254334549","seq_no":"7","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"196241896","insp_violation_category_id":"18","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:27:56.000000Z","updated_at":"2025-03-17T21:27:56.000000Z","normalized_code":"3963A1"},{"id":4496317,"change_date":"2023-07-28 21:40:00","inspection_id":"78489441","insp_violation_id":"254334550","seq_no":"8","part_no":"392","part_no_section":"9(a)(2)","insp_viol_unit":"1","insp_unit_id":"196241896","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:27:56.000000Z","updated_at":"2025-03-17T21:27:56.000000Z","normalized_code":"3929A2"},{"id":4496318,"change_date":"2023-07-28 21:40:00","inspection_id":"78489441","insp_violation_id":"254334551","seq_no":"9","part_no":"393","part_no_section":"80","insp_viol_unit":"1","insp_unit_id":"196241896","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:56.000000Z","updated_at":"2025-03-17T21:27:56.000000Z","normalized_code":"39380"},{"id":4496319,"change_date":"2023-07-28 21:40:00","inspection_id":"78489441","insp_violation_id":"254334552","seq_no":"10","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"196241896","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:27:56.000000Z","updated_at":"2025-03-17T21:27:56.000000Z","normalized_code":"39375A3"},{"id":4496320,"change_date":"2023-07-28 21:40:00","inspection_id":"78489441","insp_violation_id":"254334553","seq_no":"11","part_no":"393","part_no_section":"47(a)","insp_viol_unit":"1","insp_unit_id":"196241896","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:27:56.000000Z","updated_at":"2025-03-17T21:27:56.000000Z","normalized_code":"39347A"},{"id":4496321,"change_date":"2023-07-28 21:40:00","inspection_id":"78489441","insp_violation_id":"254334554","seq_no":"12","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196241896","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:56.000000Z","updated_at":"2025-03-17T21:27:56.000000Z","normalized_code":"3939A"},{"id":4496322,"change_date":"2023-07-28 21:40:00","inspection_id":"78489441","insp_violation_id":"254334555","seq_no":"13","part_no":"393","part_no_section":"25(a)","insp_viol_unit":"1","insp_unit_id":"196241896","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:56.000000Z","updated_at":"2025-03-17T21:27:56.000000Z","normalized_code":"39325A"},{"id":4496323,"change_date":"2023-07-28 21:40:00","inspection_id":"78489441","insp_violation_id":"254334556","seq_no":"14","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"196241896","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:56.000000Z","updated_at":"2025-03-17T21:27:56.000000Z","normalized_code":"39311"},{"id":4496324,"change_date":"2023-07-28 21:40:00","inspection_id":"78489441","insp_violation_id":"254334557","seq_no":"15","part_no":"391","part_no_section":"11(b)(5)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:56.000000Z","updated_at":"2025-03-17T21:27:56.000000Z","normalized_code":"39111B5"},{"id":4496325,"change_date":"2023-07-28 21:40:00","inspection_id":"78489441","insp_violation_id":"254334558","seq_no":"16","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:27:56.000000Z","updated_at":"2025-03-17T21:27:56.000000Z","normalized_code":"39141A1"}],"inspection_per_units":[{"id":4711013,"change_date":"2023-07-28 21:40:00","inspection_id":"78489441","insp_unit_id":"196241896","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"71348","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"1FDUF5HT3GEB56506","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:09.000000Z","updated_at":"2025-03-17T22:40:09.000000Z"}]},{"id":1897930,"change_date":"2022-12-08 21:40:00","inspection_id":"77314987","dot_number":"633956","report_state":"MA","report_number":"CT00001676","insp_date":"2022-11-15 00:00:00","insp_start_time":"1103","insp_end_time":"1215","registration_date":null,"region":"ET","ci_status_code":"C","location":"294H","location_desc":"H-SEEKONK","county_code_state":"MA","county_code":"005","insp_level_id":"1","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":"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":"2022-12-08 21:40:00","post_acc_ind":"Y","gross_comb_veh_wt":"26000","viol_total":"9","oos_total":"1","driver_viol_total":"4","driver_oos_total":"1","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"456127","transaction_code":"A","transaction_date":"2022-12-08 00:00:00","upload_date":"2022-12-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00633956","upload_search_indicator":"M","census_search_date":"2022-12-08 21:40:00","snet_input_date":"2022-11-15 00:00:00","source_office":"1MAS001","mcmis_add_date":"2022-12-08 21:40:00","insp_carrier_name":"MIKES PROFESSIONAL TREE SERVICE INC","insp_carrier_street":"17A RESERVOIR ROAD","insp_carrier_city":"COVENTRY","insp_carrier_state":"RI","insp_carrier_zip_code":"02816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:01:32.000000Z","updated_at":"2025-03-17T19:01:32.000000Z","inspection_violations":[{"id":2953449,"change_date":"2022-12-08 21:40:00","inspection_id":"77314987","insp_violation_id":"249984595","seq_no":"1","part_no":"391","part_no_section":"11(b)(5)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:03.000000Z","updated_at":"2025-03-17T21:21:03.000000Z","normalized_code":"39111B5"},{"id":2953450,"change_date":"2022-12-08 21:40:00","inspection_id":"77314987","insp_violation_id":"249984596","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:21:03.000000Z","updated_at":"2025-03-17T21:21:03.000000Z","normalized_code":"39141A"},{"id":2953451,"change_date":"2022-12-08 21:40:00","inspection_id":"77314987","insp_violation_id":"249984597","seq_no":"3","part_no":"391","part_no_section":"11(b)(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:21:03.000000Z","updated_at":"2025-03-17T21:21:03.000000Z","normalized_code":"39111B2"},{"id":2953452,"change_date":"2022-12-08 21:40:00","inspection_id":"77314987","insp_violation_id":"249984598","seq_no":"4","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":"678210AB","created_at":"2025-03-17T21:21:03.000000Z","updated_at":"2025-03-17T21:21:03.000000Z","normalized_code":"3922"},{"id":2953453,"change_date":"2022-12-08 21:40:00","inspection_id":"77314987","insp_violation_id":"249984599","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"192318628","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"678243AB","created_at":"2025-03-17T21:21:03.000000Z","updated_at":"2025-03-17T21:21:03.000000Z","normalized_code":"3922"},{"id":2953454,"change_date":"2022-12-08 21:40:00","inspection_id":"77314987","insp_violation_id":"249984600","seq_no":"6","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"192318628","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:03.000000Z","updated_at":"2025-03-17T21:21:03.000000Z","normalized_code":"39617C"},{"id":2953455,"change_date":"2022-12-08 21:40:00","inspection_id":"77314987","insp_violation_id":"249984601","seq_no":"7","part_no":"393","part_no_section":"203(c)","insp_viol_unit":"1","insp_unit_id":"192318628","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:03.000000Z","updated_at":"2025-03-17T21:21:03.000000Z","normalized_code":"393203C"},{"id":2953456,"change_date":"2022-12-08 21:40:00","inspection_id":"77314987","insp_violation_id":"249984602","seq_no":"8","part_no":"393","part_no_section":"203(a)","insp_viol_unit":"1","insp_unit_id":"192318628","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:03.000000Z","updated_at":"2025-03-17T21:21:03.000000Z","normalized_code":"393203A"},{"id":2953457,"change_date":"2022-12-08 21:40:00","inspection_id":"77314987","insp_violation_id":"249984603","seq_no":"9","part_no":"393","part_no_section":"24(c)","insp_viol_unit":"1","insp_unit_id":"192318628","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:03.000000Z","updated_at":"2025-03-17T21:21:03.000000Z","normalized_code":"39324C"}],"inspection_per_units":[{"id":3054367,"change_date":"2022-12-08 21:40:00","inspection_id":"77314987","insp_unit_id":"192318628","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"46421","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"1FDWF7DC2MDF08616","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:54.000000Z","updated_at":"2025-03-17T22:27:54.000000Z"}]},{"id":1454301,"change_date":"2022-11-16 21:40:00","inspection_id":"76805557","dot_number":"633956","report_state":"RI","report_number":"00CB003024","insp_date":"2022-08-02 00:00:00","insp_start_time":"0834","insp_end_time":"0856","registration_date":null,"region":"CT","ci_status_code":"C","location":"86","location_desc":"RT 295S @ EXIT 6 (RT 14)","county_code_state":"RI","county_code":"007","insp_level_id":"3","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":"SAME","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":"Y","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-10-06 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"72000","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":"78221","transaction_code":"C","transaction_date":"2022-11-16 00:00:00","upload_date":"2022-11-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00633956","upload_search_indicator":"M","census_search_date":"2022-10-06 21:39:00","snet_input_date":"2022-10-03 00:00:00","source_office":"1RIS001","mcmis_add_date":"2022-10-06 21:39:00","insp_carrier_name":"MIKES PROFESSIONAL TREE SERVICE INC","insp_carrier_street":"17A RESERVOIR ROAD","insp_carrier_city":"COVENTRY","insp_carrier_state":"RI","insp_carrier_zip_code":"02816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:53:27.000000Z","updated_at":"2025-03-17T18:53:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2341211,"change_date":"2022-11-16 21:40:00","inspection_id":"76805557","insp_unit_id":"191979152","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":null,"insp_unit_license":"1BW290","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"5KKHAVDV2MLMN8743","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:03.000000Z","updated_at":"2025-03-17T22:23:03.000000Z"}]},{"id":274665,"change_date":"2022-06-24 21:39:00","inspection_id":"75420620","dot_number":"633956","report_state":"RI","report_number":"00CB002892","insp_date":"2022-04-27 00:00:00","insp_start_time":"0804","insp_end_time":"0849","registration_date":null,"region":"CT","ci_status_code":"C","location":"84","location_desc":"RT 295S @ EXIT 3 (RT 37)","county_code_state":"RI","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":"SAME","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":"I","final_status_date":"2022-04-28 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"76554","transaction_code":"C","transaction_date":"2022-06-24 00:00:00","upload_date":"2022-06-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00633956","upload_search_indicator":"M","census_search_date":"2022-04-28 21:39:00","snet_input_date":"2022-04-28 00:00:00","source_office":"1RIS001","mcmis_add_date":"2022-04-28 21:39:00","insp_carrier_name":"MIKES PROFESSIONAL TREE SERVICE INC","insp_carrier_street":"17A RESERVOIR ROAD","insp_carrier_city":"COVENTRY","insp_carrier_state":"RI","insp_carrier_zip_code":"02816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:32:16.000000Z","updated_at":"2025-03-17T18:32:16.000000Z","inspection_violations":[{"id":425973,"change_date":"2022-06-24 21:39:00","inspection_id":"75420620","insp_violation_id":"246702071","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":"3","citation_number":null,"created_at":"2025-03-17T21:09:04.000000Z","updated_at":"2025-03-17T21:09:04.000000Z","normalized_code":"38323A2"}],"inspection_per_units":[{"id":444612,"change_date":"2022-06-24 21:39:00","inspection_id":"75420620","insp_unit_id":"189444948","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"46421","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"1FDWF7DC2MDF08616","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:55.000000Z","updated_at":"2025-03-17T22:10:55.000000Z"}]},{"id":220807,"change_date":"2022-04-21 21:40:00","inspection_id":"75356336","dot_number":"633956","report_state":"MA","report_number":"BK00011025","insp_date":"2022-04-20 00:00:00","insp_start_time":"0744","insp_end_time":"0805","registration_date":null,"region":"ET","ci_status_code":"C","location":"294H","location_desc":"H-SEEKONK","county_code_state":"MA","county_code":"005","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":"Y","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-04-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"198000","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":"444911","transaction_code":"A","transaction_date":"2022-04-21 00:00:00","upload_date":"2022-04-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00633956","upload_search_indicator":"M","census_search_date":"2022-04-21 21:40:00","snet_input_date":"2022-04-20 00:00:00","source_office":"1MAS001","mcmis_add_date":"2022-04-21 21:40:00","insp_carrier_name":"MIKES PROFESSIONAL TREE SERVICE INC","insp_carrier_street":"17A RESERVOIR ROAD","insp_carrier_city":"COVENTRY","insp_carrier_state":"RI","insp_carrier_zip_code":"02816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:31:31.000000Z","updated_at":"2025-03-17T18:31:31.000000Z","inspection_violations":[{"id":339229,"change_date":"2022-04-21 21:40:00","inspection_id":"75356336","insp_violation_id":"245284964","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"188263058","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"T0804559","created_at":"2025-03-17T21:08:38.000000Z","updated_at":"2025-03-17T21:08:38.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":358052,"change_date":"2022-04-21 21:40:00","inspection_id":"75356336","insp_unit_id":"188263057","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"93150","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"1M1PN4GY6LM005204","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:19.000000Z","updated_at":"2025-03-17T22:10:19.000000Z"},{"id":358053,"change_date":"2022-04-21 21:40:00","inspection_id":"75356336","insp_unit_id":"188263058","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRIL","insp_unit_company":null,"insp_unit_license":"31617","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"1T9DS26B591066853","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:19.000000Z","updated_at":"2025-03-17T22:10:19.000000Z"}]},{"id":220821,"change_date":"2022-04-21 21:40:00","inspection_id":"75356352","dot_number":"633956","report_state":"MA","report_number":"CQ00001909","insp_date":"2022-04-20 00:00:00","insp_start_time":"0755","insp_end_time":"0816","registration_date":null,"region":"ET","ci_status_code":"C","location":"294H","location_desc":"H-SEEKONK","county_code_state":"MA","county_code":"005","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":"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":"2022-04-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"140320","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":"444913","transaction_code":"A","transaction_date":"2022-04-21 00:00:00","upload_date":"2022-04-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00633956","upload_search_indicator":"M","census_search_date":"2022-04-21 21:40:00","snet_input_date":"2022-04-20 00:00:00","source_office":"1MAS001","mcmis_add_date":"2022-04-21 21:40:00","insp_carrier_name":"MIKES PROFESSIONAL TREE SERVICE INC","insp_carrier_street":"17A RESERVOIR ROAD","insp_carrier_city":"COVENTRY","insp_carrier_state":"RI","insp_carrier_zip_code":"02816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:31:31.000000Z","updated_at":"2025-03-17T18:31:31.000000Z","inspection_violations":[{"id":339250,"change_date":"2022-04-21 21:40:00","inspection_id":"75356352","insp_violation_id":"245284997","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"188263078","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"389265AB","created_at":"2025-03-17T21:08:38.000000Z","updated_at":"2025-03-17T21:08:38.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":358068,"change_date":"2022-04-21 21:40:00","inspection_id":"75356352","insp_unit_id":"188263078","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"93227","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"1M1PN4GYXLM004900","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:19.000000Z","updated_at":"2025-03-17T22:10:19.000000Z"},{"id":358069,"change_date":"2022-04-21 21:40:00","inspection_id":"75356352","insp_unit_id":"188263079","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"PALM","insp_unit_company":null,"insp_unit_license":"3155570","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1P926FS27GA003299","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:19.000000Z","updated_at":"2025-03-17T22:10:19.000000Z"}]},{"id":142610,"change_date":"2022-06-20 21:35:00","inspection_id":"75262859","dot_number":"633956","report_state":"RI","report_number":"00SP002216","insp_date":"2022-04-09 00:00:00","insp_start_time":"0920","insp_end_time":"0940","registration_date":null,"region":"ET","ci_status_code":"C","location":"25","location_desc":"RT 95N @ EXIT 14 (RT 37)","county_code_state":"RI","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"4","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":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-04-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"76318","transaction_code":"C","transaction_date":"2022-06-20 00:00:00","upload_date":"2022-06-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00633956","upload_search_indicator":"M","census_search_date":"2022-04-11 21:40:00","snet_input_date":"2022-04-11 00:00:00","source_office":"1RIS001","mcmis_add_date":"2022-04-11 21:40:00","insp_carrier_name":"MIKES PROFESSIONAL TREE SERVICE INC","insp_carrier_street":"17A RESERVOIR ROAD","insp_carrier_city":"COVENTRY","insp_carrier_state":"RI","insp_carrier_zip_code":"02816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:30:07.000000Z","updated_at":"2025-03-17T18:30:07.000000Z","inspection_violations":[{"id":211102,"change_date":"2022-06-20 21:35:00","inspection_id":"75262859","insp_violation_id":"246579738","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:01.000000Z","updated_at":"2025-03-17T21:08:01.000000Z","normalized_code":"3922"},{"id":211103,"change_date":"2022-06-20 21:35:00","inspection_id":"75262859","insp_violation_id":"246579739","seq_no":"2","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:08:01.000000Z","updated_at":"2025-03-17T21:08:01.000000Z","normalized_code":"39141A1"}],"inspection_per_units":[{"id":230642,"change_date":"2022-06-20 21:35:00","inspection_id":"75262859","insp_unit_id":"189343241","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"89715","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"1FDUF5HT5KDA11157","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:36.000000Z","updated_at":"2025-03-17T22:09:36.000000Z"}]}],"first_page_url":"https:\/\/www.searchcarriers.com\/company\/633956\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/www.searchcarriers.com\/company\/633956\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/www.searchcarriers.com\/company\/633956\/inspections?page=1","label":"1","page":1,"active":true},{"url":null,"label":"Next »","page":null,"active":false}],"next_page_url":null,"path":"https:\/\/www.searchcarriers.com\/company\/633956\/inspections","per_page":100,"prev_page_url":null,"to":22,"total":22}