{"current_page":1,"data":[{"id":8696764,"change_date":"2025-05-21 21:41:00","inspection_id":"84737377","dot_number":"1134723","report_state":"NY","report_number":"SPC3040211","insp_date":"2025-05-14 00:00:00","insp_start_time":"1555","insp_end_time":"1638","registration_date":null,"region":"ED","ci_status_code":"C","location":"30690M","location_desc":"PREBLE NY","county_code_state":"NY","county_code":"023","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"QUARRYCUT","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-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"39900","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":"1759797","transaction_code":"A","transaction_date":"2025-05-21 00:00:00","upload_date":"2025-05-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01134723","upload_search_indicator":null,"census_search_date":"2025-05-21 21:41:00","snet_input_date":"2025-05-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-21 21:41:00","insp_carrier_name":"PERRAS EXCAVATING INC","insp_carrier_street":"1909 STATE HIGHWAY 420","insp_carrier_city":"MASSENA","insp_carrier_state":"NY","insp_carrier_zip_code":"13662","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-05-24T10:03:44.000000Z","updated_at":"2025-05-25T10:04:28.000000Z","inspection_violations":[{"id":13859131,"change_date":"2025-05-21 21:41:00","inspection_id":"84737377","insp_violation_id":"266369692","seq_no":"1","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"206981672","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-24T10:26:29.000000Z","updated_at":"2025-05-25T10:20:26.000000Z","normalized_code":"39395A4EEUS"},{"id":13859132,"change_date":"2025-05-21 21:41:00","inspection_id":"84737377","insp_violation_id":"266369693","seq_no":"2","part_no":"392","part_no_section":"2-SLLUCR","insp_viol_unit":"1","insp_unit_id":"206981672","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-24T10:26:29.000000Z","updated_at":"2025-05-25T10:20:26.000000Z","normalized_code":"3922SLLUCR"},{"id":13859133,"change_date":"2025-05-21 21:41:00","inspection_id":"84737377","insp_violation_id":"266369694","seq_no":"3","part_no":"393","part_no_section":"104F3-C","insp_viol_unit":"2","insp_unit_id":"206981673","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-24T10:26:29.000000Z","updated_at":"2025-05-25T10:20:26.000000Z","normalized_code":"393104F3C"},{"id":13859134,"change_date":"2025-05-21 21:41:00","inspection_id":"84737377","insp_violation_id":"266369695","seq_no":"4","part_no":"390","part_no_section":"19TG","insp_viol_unit":"1","insp_unit_id":"206981672","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-24T10:26:29.000000Z","updated_at":"2025-05-25T10:20:26.000000Z","normalized_code":"39019TG"},{"id":13859135,"change_date":"2025-05-21 21:41:00","inspection_id":"84737377","insp_violation_id":"266369696","seq_no":"5","part_no":"395","part_no_section":"8A","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-24T10:26:29.000000Z","updated_at":"2025-05-25T10:20:26.000000Z","normalized_code":"3958A"}],"inspection_per_units":[{"id":14210274,"change_date":"2025-05-21 21:41:00","inspection_id":"84737377","insp_unit_id":"206981672","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":null,"insp_unit_license":"47937NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3C63RRGL4JG268545","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-24T09:49:29.000000Z","updated_at":"2025-05-25T09:49:37.000000Z"},{"id":14210275,"change_date":"2025-05-21 21:41:00","inspection_id":"84737377","insp_unit_id":"206981673","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIG TEX","insp_unit_company":null,"insp_unit_license":"CD49520","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"16V3F3823P6242361","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-24T09:49:29.000000Z","updated_at":"2025-05-25T09:49:37.000000Z"}]},{"id":8457975,"change_date":"2025-04-24 21:38:00","inspection_id":"84485983","dot_number":"1134723","report_state":"NY","report_number":"SPC3010683","insp_date":"2025-04-17 00:00:00","insp_start_time":"0921","insp_end_time":"0943","registration_date":null,"region":"ED","ci_status_code":"C","location":"70877S","location_desc":"WATERTOWN NY","county_code_state":"NY","county_code":"045","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-04-24 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"29820","viol_total":"1","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":"1637657","transaction_code":"A","transaction_date":"2025-04-24 00:00:00","upload_date":"2025-04-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01134723","upload_search_indicator":null,"census_search_date":"2025-04-24 21:38:00","snet_input_date":"2025-04-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-24 21:38:00","insp_carrier_name":"PERRAS EXCAVATING INC","insp_carrier_street":"1909 STATE HIGHWAY 420","insp_carrier_city":"MASSENA","insp_carrier_state":"NY","insp_carrier_zip_code":"13662","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-04-27T10:28:18.000000Z","updated_at":"2025-04-28T10:10:29.000000Z","inspection_violations":[{"id":13368907,"change_date":"2025-04-24 21:38:00","inspection_id":"84485983","insp_violation_id":"265806781","seq_no":"1","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"2","insp_unit_id":"206469129","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-04-26T11:01:28.000000Z","updated_at":"2025-04-28T10:24:22.000000Z","normalized_code":"39375A3TAOL"}],"inspection_per_units":[{"id":13740900,"change_date":"2025-04-24 21:38:00","inspection_id":"84485983","insp_unit_id":"206469128","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":null,"insp_unit_license":"47937NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3C63RRGL4JG268545","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-27T10:12:48.000000Z","updated_at":"2025-04-28T09:53:31.000000Z"},{"id":13740901,"change_date":"2025-04-24 21:38:00","inspection_id":"84485983","insp_unit_id":"206469129","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"BL48056","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4KNTT162XHL160682","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-27T10:12:48.000000Z","updated_at":"2025-04-28T09:53:31.000000Z"}]},{"id":6594822,"change_date":"2024-08-29 21:42:00","inspection_id":"82519533","dot_number":"1134723","report_state":"NY","report_number":"SPB0343090","insp_date":"2024-08-28 00:00:00","insp_start_time":"1010","insp_end_time":"1026","registration_date":null,"region":"ET","ci_status_code":"C","location":"70485A","location_desc":"LOUISVILLE","county_code_state":"NY","county_code":"089","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":"2024-08-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"39900","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":"2947746","transaction_code":"A","transaction_date":"2024-08-29 00:00:00","upload_date":"2024-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01134723","upload_search_indicator":"M","census_search_date":"2024-08-29 21:42:00","snet_input_date":"2024-08-29 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-08-29 21:42:00","insp_carrier_name":"PERRAS EXCAVATING INC","insp_carrier_street":"1909 STATE HIGHWAY 420","insp_carrier_city":"MASSENA","insp_carrier_state":"NY","insp_carrier_zip_code":"13662","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:33:41.000000Z","updated_at":"2025-03-17T20:33:41.000000Z","inspection_violations":[{"id":10255934,"change_date":"2024-08-29 21:42:00","inspection_id":"82519533","insp_violation_id":"261490017","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:55:37.000000Z","updated_at":"2025-03-17T21:55:37.000000Z","normalized_code":"39141A1"},{"id":10255935,"change_date":"2024-08-29 21:42:00","inspection_id":"82519533","insp_violation_id":"261490018","seq_no":"3","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:55:37.000000Z","updated_at":"2025-03-17T21:55:37.000000Z","normalized_code":"38323A2"},{"id":10255936,"change_date":"2024-08-29 21:42:00","inspection_id":"82519533","insp_violation_id":"261490019","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:55:37.000000Z","updated_at":"2025-03-17T21:55:37.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10631987,"change_date":"2024-08-29 21:42:00","inspection_id":"82519533","insp_unit_id":"202649924","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"47937NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3C63RRGL4JG268545","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:07.000000Z","updated_at":"2025-03-17T23:33:07.000000Z"},{"id":10631988,"change_date":"2024-08-29 21:42:00","inspection_id":"82519533","insp_unit_id":"202649925","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":null,"insp_unit_license":"CD49520","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"16V3F3823P6242361","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:07.000000Z","updated_at":"2025-03-17T23:33:07.000000Z"}]},{"id":6345753,"change_date":"2024-07-30 21:43:00","inspection_id":"82253688","dot_number":"1134723","report_state":"NY","report_number":"SPB0402765","insp_date":"2024-07-29 00:00:00","insp_start_time":"1515","insp_end_time":"1537","registration_date":null,"region":"ET","ci_status_code":"C","location":"70486","location_desc":"LOUISVILLE","county_code_state":"NY","county_code":"089","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":"2024-07-30 21:43:00","post_acc_ind":"Y","gross_comb_veh_wt":"65626","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2941312","transaction_code":"A","transaction_date":"2024-07-30 00:00:00","upload_date":"2024-07-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01134723","upload_search_indicator":"M","census_search_date":"2024-07-30 21:43:00","snet_input_date":"2024-07-30 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-07-30 21:43:00","insp_carrier_name":"PERRAS EXCAVATING INC","insp_carrier_street":"1909 STATE HIGHWAY 420","insp_carrier_city":"MASSENA","insp_carrier_state":"NY","insp_carrier_zip_code":"13662","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:28:40.000000Z","updated_at":"2025-03-17T20:28:40.000000Z","inspection_violations":[{"id":9852426,"change_date":"2024-07-30 21:43:00","inspection_id":"82253688","insp_violation_id":"260916154","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202143276","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:39.000000Z","updated_at":"2025-03-17T21:53:39.000000Z","normalized_code":"3939A"},{"id":9852427,"change_date":"2024-07-30 21:43:00","inspection_id":"82253688","insp_violation_id":"260916155","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202143276","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:39.000000Z","updated_at":"2025-03-17T21:53:39.000000Z","normalized_code":"3939A"},{"id":9852428,"change_date":"2024-07-30 21:43:00","inspection_id":"82253688","insp_violation_id":"260916156","seq_no":"3","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"202143276","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:53:39.000000Z","updated_at":"2025-03-17T21:53:39.000000Z","normalized_code":"39375A3"},{"id":9852429,"change_date":"2024-07-30 21:43:00","inspection_id":"82253688","insp_violation_id":"260916157","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"202143276","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:53:39.000000Z","updated_at":"2025-03-17T21:53:39.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":10225598,"change_date":"2024-07-30 21:43:00","inspection_id":"82253688","insp_unit_id":"202143276","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KNNW","insp_unit_company":null,"insp_unit_license":"85992JZ","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NKDXUEX26J133595","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:57.000000Z","updated_at":"2025-03-17T23:28:57.000000Z"}]},{"id":4692444,"change_date":"2023-12-28 21:44:00","inspection_id":"80457243","dot_number":"1134723","report_state":"NY","report_number":"SPB0342548","insp_date":"2023-12-21 00:00:00","insp_start_time":"1120","insp_end_time":"1139","registration_date":null,"region":"ET","ci_status_code":"C","location":"70519","location_desc":"MASSENA","county_code_state":"NY","county_code":"089","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":"N","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-12-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"12000","viol_total":"7","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2895365","transaction_code":"C","transaction_date":"2023-12-28 00:00:00","upload_date":"2023-12-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01134723","upload_search_indicator":"M","census_search_date":"2023-12-22 21:41:00","snet_input_date":"2023-12-22 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-12-22 21:41:00","insp_carrier_name":"PERRAS EXCAVATING INC","insp_carrier_street":"1909 STATE HIGHWAY 420","insp_carrier_city":"MASSENA","insp_carrier_state":"NY","insp_carrier_zip_code":"13662","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:55:47.000000Z","updated_at":"2025-03-17T19:55:47.000000Z","inspection_violations":[{"id":7251857,"change_date":"2023-12-28 21:44:00","inspection_id":"80457243","insp_violation_id":"257086375","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:41:01.000000Z","updated_at":"2025-03-17T21:41:01.000000Z","normalized_code":"3922"},{"id":7251858,"change_date":"2023-12-28 21:44:00","inspection_id":"80457243","insp_violation_id":"257086376","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:41:01.000000Z","updated_at":"2025-03-17T21:41:01.000000Z","normalized_code":"39141A1"},{"id":7251859,"change_date":"2023-12-28 21:44:00","inspection_id":"80457243","insp_violation_id":"257086377","seq_no":"3","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:41:01.000000Z","updated_at":"2025-03-17T21:41:01.000000Z","normalized_code":"3922"},{"id":7251860,"change_date":"2023-12-28 21:44:00","inspection_id":"80457243","insp_violation_id":"257086378","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198701452","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"0HJCX8T","created_at":"2025-03-17T21:41:01.000000Z","updated_at":"2025-03-17T21:41:01.000000Z","normalized_code":"3939A"},{"id":7251861,"change_date":"2023-12-28 21:44:00","inspection_id":"80457243","insp_violation_id":"257086379","seq_no":"5","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"198701452","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"0HJCXFH","created_at":"2025-03-17T21:41:01.000000Z","updated_at":"2025-03-17T21:41:01.000000Z","normalized_code":"39395A"},{"id":7251862,"change_date":"2023-12-28 21:44:00","inspection_id":"80457243","insp_violation_id":"257086380","seq_no":"6","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"198701452","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"0HJCXGZ","created_at":"2025-03-17T21:41:01.000000Z","updated_at":"2025-03-17T21:41:01.000000Z","normalized_code":"39395F"},{"id":7251863,"change_date":"2023-12-28 21:44:00","inspection_id":"80457243","insp_violation_id":"257086381","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198701452","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:01.000000Z","updated_at":"2025-03-17T21:41:01.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":7547622,"change_date":"2023-12-28 21:44:00","inspection_id":"80457243","insp_unit_id":"198701452","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"28993MH","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GBJG31U241238679","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:28.000000Z","updated_at":"2025-03-17T23:03:28.000000Z"}]},{"id":3207568,"change_date":"2023-06-05 21:42:00","inspection_id":"78804827","dot_number":"1134723","report_state":"NY","report_number":"SPB0332596","insp_date":"2023-05-30 00:00:00","insp_start_time":"1313","insp_end_time":"1408","registration_date":null,"region":"ET","ci_status_code":"C","location":"70148","location_desc":"CABOT CHEESE PARKING LOT","county_code_state":"NY","county_code":"033","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"PERRAS EXCAVATING","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-05 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"196000","viol_total":"7","oos_total":"2","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2831728","transaction_code":"A","transaction_date":"2023-05-30 00:00:00","upload_date":"2023-06-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01134723","upload_search_indicator":null,"census_search_date":"2023-06-05 21:42:00","snet_input_date":"2023-06-05 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-06-05 21:42:00","insp_carrier_name":"PERRAS EXCAVATING INC","insp_carrier_street":"1909 STATE HIGHWAY 420","insp_carrier_city":"MASSENA","insp_carrier_state":"NY","insp_carrier_zip_code":"13662","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:26:28.000000Z","updated_at":"2025-03-17T19:26:28.000000Z","inspection_violations":[{"id":4942191,"change_date":"2023-06-05 21:42:00","inspection_id":"78804827","insp_violation_id":"253270482","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:30:02.000000Z","updated_at":"2025-03-17T21:30:02.000000Z","normalized_code":"39216A"},{"id":4942192,"change_date":"2023-06-05 21:42:00","inspection_id":"78804827","insp_violation_id":"253270483","seq_no":"2","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"195305149","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:02.000000Z","updated_at":"2025-03-17T21:30:02.000000Z","normalized_code":"39345B2"},{"id":4942193,"change_date":"2023-06-05 21:42:00","inspection_id":"78804827","insp_violation_id":"253270484","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"195305150","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:02.000000Z","updated_at":"2025-03-17T21:30:02.000000Z","normalized_code":"3922"},{"id":4942194,"change_date":"2023-06-05 21:42:00","inspection_id":"78804827","insp_violation_id":"253270485","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"195305150","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:02.000000Z","updated_at":"2025-03-17T21:30:02.000000Z","normalized_code":"3922"},{"id":4942195,"change_date":"2023-06-05 21:42:00","inspection_id":"78804827","insp_violation_id":"253270486","seq_no":"5","part_no":"393","part_no_section":"130","insp_viol_unit":"2","insp_unit_id":"195305150","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:30:02.000000Z","updated_at":"2025-03-17T21:30:02.000000Z","normalized_code":"393130"},{"id":4942196,"change_date":"2023-06-05 21:42:00","inspection_id":"78804827","insp_violation_id":"253270487","seq_no":"6","part_no":"393","part_no_section":"130(b)","insp_viol_unit":"2","insp_unit_id":"195305150","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:30:02.000000Z","updated_at":"2025-03-17T21:30:02.000000Z","normalized_code":"393130B"},{"id":4942197,"change_date":"2023-06-05 21:42:00","inspection_id":"78804827","insp_violation_id":"253270488","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"195305150","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"0GSJ7T6","created_at":"2025-03-17T21:30:02.000000Z","updated_at":"2025-03-17T21:30:02.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":5158633,"change_date":"2023-06-05 21:42:00","inspection_id":"78804827","insp_unit_id":"195305149","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":null,"insp_unit_license":"26817TC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5KJNAEFG0LPKX5158","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:38.000000Z","updated_at":"2025-03-17T22:43:38.000000Z"},{"id":5158634,"change_date":"2023-06-05 21:42:00","inspection_id":"78804827","insp_unit_id":"195305150","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TALB","insp_unit_company":null,"insp_unit_license":"BK13777","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"40FSK5235G1034699","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:38.000000Z","updated_at":"2025-03-17T22:43:38.000000Z"}]},{"id":2793970,"change_date":"2023-04-13 21:42:00","inspection_id":"78337310","dot_number":"1134723","report_state":"NY","report_number":"SPWB061059","insp_date":"2023-04-12 00:00:00","insp_start_time":"0635","insp_end_time":"0703","registration_date":null,"region":"ET","ci_status_code":"C","location":"70485","location_desc":"LOUISVILLE WEST ROADSIDE","county_code_state":"NY","county_code":"089","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-04-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"21000","viol_total":"5","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2815247","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":"01134723","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":"PERRAS EXCAVATING INC","insp_carrier_street":"1909 STATE HIGHWAY 420","insp_carrier_city":"MASSENA","insp_carrier_state":"NY","insp_carrier_zip_code":"13662","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":[{"id":4287031,"change_date":"2023-04-13 21:42:00","inspection_id":"78337310","insp_violation_id":"252193606","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:27:03.000000Z","updated_at":"2025-03-17T21:27:03.000000Z","normalized_code":"39141A1"},{"id":4287032,"change_date":"2023-04-13 21:42:00","inspection_id":"78337310","insp_violation_id":"252193607","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194361167","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:03.000000Z","updated_at":"2025-03-17T21:27:03.000000Z","normalized_code":"3922"},{"id":4287033,"change_date":"2023-04-13 21:42:00","inspection_id":"78337310","insp_violation_id":"252193608","seq_no":"3","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"194361167","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"6GMCPZT","created_at":"2025-03-17T21:27:03.000000Z","updated_at":"2025-03-17T21:27:03.000000Z","normalized_code":"39395F"},{"id":4287034,"change_date":"2023-04-13 21:42:00","inspection_id":"78337310","insp_violation_id":"252193609","seq_no":"4","part_no":"393","part_no_section":"23","insp_viol_unit":"2","insp_unit_id":"194361168","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"6GMCQ2S","created_at":"2025-03-17T21:27:03.000000Z","updated_at":"2025-03-17T21:27:03.000000Z","normalized_code":"39323"},{"id":4287035,"change_date":"2023-04-13 21:42:00","inspection_id":"78337310","insp_violation_id":"252193610","seq_no":"5","part_no":"393","part_no_section":"43","insp_viol_unit":"2","insp_unit_id":"194361168","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:27:03.000000Z","updated_at":"2025-03-17T21:27:03.000000Z","normalized_code":"39343"}],"inspection_per_units":[{"id":4496503,"change_date":"2023-04-13 21:42:00","inspection_id":"78337310","insp_unit_id":"194361167","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"62342JT","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FTBF2B60EEA70371","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":4496504,"change_date":"2023-04-13 21:42:00","inspection_id":"78337310","insp_unit_id":"194361168","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"BL48056","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4KNTT162XHL160682","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":2331256,"change_date":"2023-02-09 21:39:00","inspection_id":"77810048","dot_number":"1134723","report_state":"NY","report_number":"SPB0401405","insp_date":"2023-02-08 00:00:00","insp_start_time":"1135","insp_end_time":"1206","registration_date":null,"region":"ET","ci_status_code":"C","location":"70863","location_desc":"WADDINGTON ROADSIDE","county_code_state":"NY","county_code":"089","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":"N","pen_cen_match":null,"final_status_date":"2023-02-09 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2797404","transaction_code":"A","transaction_date":"2023-02-09 00:00:00","upload_date":"2023-02-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01134723","upload_search_indicator":"M","census_search_date":"2023-02-09 21:39:00","snet_input_date":"2023-02-09 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-02-09 21:39:00","insp_carrier_name":"PERRAS EXCAVATING INC","insp_carrier_street":"1909 STATE HIGHWAY 420","insp_carrier_city":"MASSENA","insp_carrier_state":"NY","insp_carrier_zip_code":"13662","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:09:38.000000Z","updated_at":"2025-03-17T19:09:38.000000Z","inspection_violations":[{"id":3591062,"change_date":"2023-02-09 21:39:00","inspection_id":"77810048","insp_violation_id":"251033274","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:23:56.000000Z","updated_at":"2025-03-17T21:23:56.000000Z","normalized_code":"38323A2"},{"id":3591063,"change_date":"2023-02-09 21:39:00","inspection_id":"77810048","insp_violation_id":"251033275","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193306839","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:56.000000Z","updated_at":"2025-03-17T21:23:56.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3751546,"change_date":"2023-02-09 21:39:00","inspection_id":"77810048","insp_unit_id":"193306839","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"NONE","insp_unit_license_state":"OT","insp_unit_vehicle_id_number":"A30EV72117","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:52.000000Z","updated_at":"2025-03-17T22:32:52.000000Z"}]},{"id":1631643,"change_date":"2022-10-31 21:40:00","inspection_id":"77010035","dot_number":"1134723","report_state":"NY","report_number":"SPB0401217","insp_date":"2022-10-28 00:00:00","insp_start_time":"0835","insp_end_time":"0900","registration_date":null,"region":"ET","ci_status_code":"C","location":"70519","location_desc":"MASSENA ROADSIDE","county_code_state":"NY","county_code":"089","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-10-31 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"39950","viol_total":"7","oos_total":"3","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"5","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2764272","transaction_code":"A","transaction_date":"2022-10-31 00:00:00","upload_date":"2022-10-31 00:00:00","upload_first_byte":"0","upload_dot_number":"01134723","upload_search_indicator":"M","census_search_date":"2022-10-31 21:40:00","snet_input_date":"2022-10-31 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-10-31 21:40:00","insp_carrier_name":"PERRAS EXCAVATING INC","insp_carrier_street":"1909 STATE HIGHWAY 420","insp_carrier_city":"MASSENA","insp_carrier_state":"NY","insp_carrier_zip_code":"13662","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:56:41.000000Z","updated_at":"2025-03-17T18:56:41.000000Z","inspection_violations":[{"id":2561336,"change_date":"2022-10-31 21:40:00","inspection_id":"77010035","insp_violation_id":"249327465","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:19:06.000000Z","updated_at":"2025-03-17T21:19:06.000000Z","normalized_code":"38323A2"},{"id":2561337,"change_date":"2022-10-31 21:40:00","inspection_id":"77010035","insp_violation_id":"249327466","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:19:06.000000Z","updated_at":"2025-03-17T21:19:06.000000Z","normalized_code":"39141A"},{"id":2561338,"change_date":"2022-10-31 21:40:00","inspection_id":"77010035","insp_violation_id":"249327467","seq_no":"3","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"191710380","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:19:06.000000Z","updated_at":"2025-03-17T21:19:06.000000Z","normalized_code":"39375A3"},{"id":2561339,"change_date":"2022-10-31 21:40:00","inspection_id":"77010035","insp_violation_id":"249327468","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"191710380","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:19:06.000000Z","updated_at":"2025-03-17T21:19:06.000000Z","normalized_code":"3939A"},{"id":2561340,"change_date":"2022-10-31 21:40:00","inspection_id":"77010035","insp_violation_id":"249327469","seq_no":"5","part_no":"393","part_no_section":"25(f)","insp_viol_unit":"2","insp_unit_id":"191710380","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"9G1N531","created_at":"2025-03-17T21:19:06.000000Z","updated_at":"2025-03-17T21:19:06.000000Z","normalized_code":"39325F"},{"id":2561341,"change_date":"2022-10-31 21:40:00","inspection_id":"77010035","insp_violation_id":"249327470","seq_no":"6","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"191710380","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:06.000000Z","updated_at":"2025-03-17T21:19:06.000000Z","normalized_code":"3922"},{"id":2561342,"change_date":"2022-10-31 21:40:00","inspection_id":"77010035","insp_violation_id":"249327471","seq_no":"7","part_no":"393","part_no_section":"55(d)(1)","insp_viol_unit":"1","insp_unit_id":"191710381","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:06.000000Z","updated_at":"2025-03-17T21:19:06.000000Z","normalized_code":"39355D1"}],"inspection_per_units":[{"id":2624573,"change_date":"2022-10-31 21:40:00","inspection_id":"77010035","insp_unit_id":"191710380","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"AM61752","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5NHUHD22051002829","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:59.000000Z","updated_at":"2025-03-17T22:24:59.000000Z"},{"id":2624574,"change_date":"2022-10-31 21:40:00","inspection_id":"77010035","insp_unit_id":"191710381","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"32125MC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GBJ7C1306F432091","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:59.000000Z","updated_at":"2025-03-17T22:24:59.000000Z"}]},{"id":316077,"change_date":"2022-05-04 21:40:00","inspection_id":"75470065","dot_number":"1134723","report_state":"NY","report_number":"0322003040","insp_date":"2022-05-03 00:00:00","insp_start_time":"0956","insp_end_time":"1028","registration_date":null,"region":"ET","ci_status_code":"C","location":"70877M","location_desc":"WATERTOWN REST AREA (SB)","county_code_state":"NY","county_code":"045","insp_level_id":"1","service_center":"EA","census_source_id":"4","insp_facility":"F","shipper_name":"PERRAS EXCAVATING INC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-05-04 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"27740","viol_total":"4","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2702645","transaction_code":"A","transaction_date":"2022-05-04 00:00:00","upload_date":"2022-05-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01134723","upload_search_indicator":"M","census_search_date":"2022-05-04 21:40:00","snet_input_date":"2022-05-04 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-05-04 21:40:00","insp_carrier_name":"PERRAS EXCAVATING INC","insp_carrier_street":"1909 STATE HIGHWAY 420","insp_carrier_city":"MASSENA","insp_carrier_state":"NY","insp_carrier_zip_code":"13662","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:32:59.000000Z","updated_at":"2025-03-17T18:32:59.000000Z","inspection_violations":[{"id":492730,"change_date":"2022-05-04 21:40:00","inspection_id":"75470065","insp_violation_id":"245561313","seq_no":"1","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"188493583","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:09:22.000000Z","updated_at":"2025-03-17T21:09:22.000000Z","normalized_code":"39348A"},{"id":492731,"change_date":"2022-05-04 21:40:00","inspection_id":"75470065","insp_violation_id":"245561314","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"188493583","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:09:22.000000Z","updated_at":"2025-03-17T21:09:22.000000Z","normalized_code":"3939A"},{"id":492732,"change_date":"2022-05-04 21:40:00","inspection_id":"75470065","insp_violation_id":"245561315","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"188493583","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:22.000000Z","updated_at":"2025-03-17T21:09:22.000000Z","normalized_code":"3939A"},{"id":492733,"change_date":"2022-05-04 21:40:00","inspection_id":"75470065","insp_violation_id":"245561316","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"188493582","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:22.000000Z","updated_at":"2025-03-17T21:09:22.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":511056,"change_date":"2022-05-04 21:40:00","inspection_id":"75470065","insp_unit_id":"188493582","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"86534MJ","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3C7WRDAJ1HG580612","insp_unit_decal":"Y","insp_unit_decal_number":"31441938","created_at":"2025-03-17T22:11:20.000000Z","updated_at":"2025-03-17T22:11:20.000000Z"},{"id":511057,"change_date":"2022-05-04 21:40:00","inspection_id":"75470065","insp_unit_id":"188493583","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"BF25060","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4KNTT1626EL161288","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:20.000000Z","updated_at":"2025-03-17T22:11:20.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1134723\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1134723\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1134723\/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\/1134723\/inspections","per_page":100,"prev_page_url":null,"to":10,"total":10}