{"current_page":1,"data":[{"id":11890488,"change_date":"2026-05-26 21:39:00","inspection_id":"87828589","dot_number":"887516","report_state":"CT","report_number":"3029003835","insp_date":"2026-05-13 00:00:00","insp_start_time":"1056","insp_end_time":"1159","registration_date":"2026-05-26 00:00:00","region":"ET","ci_status_code":"C","location":"084","location_desc":"MILFORD","county_code_state":"CT","county_code":"009","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"LAPIERRE EXCAVATING LLC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-05-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"138240","viol_total":"11","oos_total":"6","driver_viol_total":"2","driver_oos_total":"2","vehicle_viol_total":"9","vehicle_oos_total":"4","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"772686","transaction_code":"C","transaction_date":"2026-05-13 00:00:00","upload_date":"2026-05-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00887516","upload_search_indicator":null,"census_search_date":"2026-05-13 21:41:00","snet_input_date":"2026-05-13 00:00:00","source_office":"1CTS001","mcmis_add_date":"2026-05-13 21:41:00","insp_carrier_name":"LAPIERRE EXCAVATING LLC","insp_carrier_street":"123 ROCK RD","insp_carrier_city":"BURLINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06013","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-05-15T12:26:43.000000Z","updated_at":"2026-06-06T09:30:40.000000Z","inspection_violations":[{"id":20682458,"change_date":"2026-05-26 21:39:00","inspection_id":"87828589","insp_violation_id":"274483804","seq_no":"6","part_no":"393","part_no_section":"9A-LSLIWR","insp_viol_unit":"2","insp_unit_id":"213738438","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-05-15T12:58:34.000000Z","updated_at":"2026-06-06T09:41:50.000000Z","normalized_code":"3939ALSLIWR"},{"id":20682462,"change_date":"2026-05-26 21:39:00","inspection_id":"87828589","insp_violation_id":"274483808","seq_no":"10","part_no":"393","part_no_section":"47A-BCFSBD-SA","insp_viol_unit":"1","insp_unit_id":"213738437","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-05-15T12:58:34.000000Z","updated_at":"2026-06-06T09:41:50.000000Z","normalized_code":"39347ABCFSBDSA"},{"id":20682456,"change_date":"2026-05-26 21:39:00","inspection_id":"87828589","insp_violation_id":"274483802","seq_no":"4","part_no":"393","part_no_section":"9A-LSML","insp_viol_unit":"1","insp_unit_id":"213738437","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-15T12:58:34.000000Z","updated_at":"2026-06-06T09:41:50.000000Z","normalized_code":"3939ALSML"},{"id":20682461,"change_date":"2026-05-26 21:39:00","inspection_id":"87828589","insp_violation_id":"274483807","seq_no":"9","part_no":"393","part_no_section":"9A-LSML","insp_viol_unit":"2","insp_unit_id":"213738438","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-15T12:58:34.000000Z","updated_at":"2026-06-06T09:41:50.000000Z","normalized_code":"3939ALSML"},{"id":20682463,"change_date":"2026-05-26 21:39:00","inspection_id":"87828589","insp_violation_id":"274483809","seq_no":"11","part_no":"396","part_no_section":"5B-HWSL","insp_viol_unit":"1","insp_unit_id":"213738437","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-05-15T12:58:34.000000Z","updated_at":"2026-06-06T09:41:50.000000Z","normalized_code":"3965BHWSL"},{"id":20682454,"change_date":"2026-05-26 21:39:00","inspection_id":"87828589","insp_violation_id":"274483800","seq_no":"2","part_no":"383","part_no_section":"23A2-LCDLN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-15T12:58:34.000000Z","updated_at":"2026-06-06T09:41:50.000000Z","normalized_code":"38323A2LCDLN"},{"id":20682455,"change_date":"2026-05-26 21:39:00","inspection_id":"87828589","insp_violation_id":"274483801","seq_no":"3","part_no":"391","part_no_section":"41A-MCPVI","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":"2026-05-15T12:58:34.000000Z","updated_at":"2026-06-06T09:41:50.000000Z","normalized_code":"39141AMCPVI"},{"id":20682453,"change_date":"2026-05-26 21:39:00","inspection_id":"87828589","insp_violation_id":"274483799","seq_no":"1","part_no":"393","part_no_section":"110B2I-C","insp_viol_unit":"1","insp_unit_id":"213738437","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"V138683-1","created_at":"2026-05-15T12:58:34.000000Z","updated_at":"2026-06-06T09:41:50.000000Z","normalized_code":"393110B2IC"},{"id":20682457,"change_date":"2026-05-26 21:39:00","inspection_id":"87828589","insp_violation_id":"274483803","seq_no":"5","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"213738437","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-15T12:58:34.000000Z","updated_at":"2026-06-06T09:41:50.000000Z","normalized_code":"3939ALCL"},{"id":20682459,"change_date":"2026-05-26 21:39:00","inspection_id":"87828589","insp_violation_id":"274483805","seq_no":"7","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"2","insp_unit_id":"213738438","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-15T12:58:34.000000Z","updated_at":"2026-06-06T09:41:50.000000Z","normalized_code":"3939ALCL"},{"id":20682460,"change_date":"2026-05-26 21:39:00","inspection_id":"87828589","insp_violation_id":"274483806","seq_no":"8","part_no":"393","part_no_section":"11A1-LLPL","insp_viol_unit":"2","insp_unit_id":"213738438","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-15T12:58:34.000000Z","updated_at":"2026-06-06T09:41:50.000000Z","normalized_code":"39311A1LLPL"}],"inspection_per_units":[{"id":20673484,"change_date":"2026-05-26 21:39:00","inspection_id":"87828589","insp_unit_id":"213738437","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"AB19199","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1NKDX4EX2FJ460532","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-15T12:12:47.000000Z","updated_at":"2026-06-06T09:02:02.000000Z"},{"id":20673485,"change_date":"2026-05-26 21:39:00","inspection_id":"87828589","insp_unit_id":"213738438","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TOWR","insp_unit_company":null,"insp_unit_license":"AJ76104","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"4KNTT24314L162624","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-15T12:12:47.000000Z","updated_at":"2026-06-06T09:02:02.000000Z"}]},{"id":11869298,"change_date":"2026-05-13 21:41:00","inspection_id":"87806269","dot_number":"887516","report_state":"CT","report_number":"0511000865","insp_date":"2026-05-09 00:00:00","insp_start_time":"0650","insp_end_time":"0717","registration_date":"2026-05-13 00:00:00","region":"ET","ci_status_code":"C","location":"061","location_desc":"HADDAM","county_code_state":"CT","county_code":"007","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"LAPIERRE EXCAVATING","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-05-11 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"31500","viol_total":"9","oos_total":"2","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"8","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"772325","transaction_code":"C","transaction_date":"2026-05-09 00:00:00","upload_date":"2026-05-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00887516","upload_search_indicator":null,"census_search_date":"2026-05-11 21:38:00","snet_input_date":"2026-05-09 00:00:00","source_office":"1CTS001","mcmis_add_date":"2026-05-11 21:38:00","insp_carrier_name":"LAPIERRE EXCAVATING LLC","insp_carrier_street":"123 ROCK RD","insp_carrier_city":"BURLINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06013","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-05-13T13:15:15.000000Z","updated_at":"2026-05-24T09:30:16.000000Z","inspection_violations":[{"id":20644771,"change_date":"2026-05-13 21:41:00","inspection_id":"87806269","insp_violation_id":"274211370","seq_no":"9","part_no":"383","part_no_section":"91A-LCDL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-13T13:32:16.000000Z","updated_at":"2026-05-24T09:43:06.000000Z","normalized_code":"38391ALCDL"},{"id":20644763,"change_date":"2026-05-13 21:41:00","inspection_id":"87806269","insp_violation_id":"274211362","seq_no":"1","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"213513667","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-13T13:32:16.000000Z","updated_at":"2026-05-24T09:43:06.000000Z","normalized_code":"3939ALCL"},{"id":20644764,"change_date":"2026-05-13 21:41:00","inspection_id":"87806269","insp_violation_id":"274211363","seq_no":"2","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"1","insp_unit_id":"213513667","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-13T13:32:16.000000Z","updated_at":"2026-05-24T09:43:06.000000Z","normalized_code":"3939ALLPL"},{"id":20644765,"change_date":"2026-05-13 21:41:00","inspection_id":"87806269","insp_violation_id":"274211364","seq_no":"3","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"213513667","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-13T13:32:16.000000Z","updated_at":"2026-05-24T09:43:06.000000Z","normalized_code":"3939ALIL"},{"id":20644766,"change_date":"2026-05-13 21:41:00","inspection_id":"87806269","insp_violation_id":"274211365","seq_no":"4","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"213513667","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-13T13:32:16.000000Z","updated_at":"2026-05-24T09:43:06.000000Z","normalized_code":"3922SLLIFTA"},{"id":20644767,"change_date":"2026-05-13 21:41:00","inspection_id":"87806269","insp_violation_id":"274211366","seq_no":"5","part_no":"393","part_no_section":"40F-BNPB","insp_viol_unit":"1","insp_unit_id":"213513667","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-05-13T13:32:16.000000Z","updated_at":"2026-05-24T09:43:06.000000Z","normalized_code":"39340FBNPB"},{"id":20644768,"change_date":"2026-05-13 21:41:00","inspection_id":"87806269","insp_violation_id":"274211367","seq_no":"6","part_no":"393","part_no_section":"11A1-LLPL","insp_viol_unit":"2","insp_unit_id":"213513668","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-13T13:32:16.000000Z","updated_at":"2026-05-24T09:43:06.000000Z","normalized_code":"39311A1LLPL"},{"id":20644769,"change_date":"2026-05-13 21:41:00","inspection_id":"87806269","insp_violation_id":"274211368","seq_no":"7","part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"2","insp_unit_id":"213513668","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-13T13:32:16.000000Z","updated_at":"2026-05-24T09:43:06.000000Z","normalized_code":"3939ALRLI"},{"id":20644770,"change_date":"2026-05-13 21:41:00","inspection_id":"87806269","insp_violation_id":"274211369","seq_no":"8","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"213513668","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-13T13:32:16.000000Z","updated_at":"2026-05-24T09:43:06.000000Z","normalized_code":"3939ALIL"}],"inspection_per_units":[{"id":20638608,"change_date":"2026-05-13 21:41:00","inspection_id":"87806269","insp_unit_id":"213513667","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"AE22496","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FD0W5HT2GEB63302","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-13T13:04:49.000000Z","updated_at":"2026-05-24T09:02:34.000000Z"},{"id":20638609,"change_date":"2026-05-13 21:41:00","inspection_id":"87806269","insp_unit_id":"213513668","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CAM","insp_unit_company":null,"insp_unit_license":"AZ84029","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"5JPBU2528FP038889","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-13T13:04:49.000000Z","updated_at":"2026-05-24T09:02:34.000000Z"}]},{"id":5443157,"change_date":"2024-04-05 21:39:00","inspection_id":"81276618","dot_number":"887516","report_state":"CT","report_number":"3090003869","insp_date":"2024-04-05 00:00:00","insp_start_time":"0841","insp_end_time":"0859","registration_date":null,"region":"ET","ci_status_code":"C","location":"017","location_desc":"BRISTOL","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SELF","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-05 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"704215","transaction_code":"A","transaction_date":"2024-04-05 00:00:00","upload_date":"2024-04-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00887516","upload_search_indicator":null,"census_search_date":"2024-04-05 21:39:00","snet_input_date":"2024-04-05 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-04-05 21:39:00","insp_carrier_name":"LAPIERRE EXCAVATING LLC","insp_carrier_street":"123 ROCK RD","insp_carrier_city":"BURLINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06013","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:10:39.000000Z","updated_at":"2025-03-17T20:10:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8767608,"change_date":"2024-04-05 21:39:00","inspection_id":"81276618","insp_unit_id":"200253008","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"L26679","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"2NPLHD7XX5M849975","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:33.000000Z","updated_at":"2025-03-17T23:14:33.000000Z"}]},{"id":5001474,"change_date":"2024-02-09 21:40:00","inspection_id":"80794946","dot_number":"887516","report_state":"CT","report_number":"3090003759","insp_date":"2024-02-08 00:00:00","insp_start_time":"1020","insp_end_time":"1052","registration_date":"2024-02-09 00:00:00","region":"ET","ci_status_code":"C","location":"017","location_desc":"BRISTOL","county_code_state":"CT","county_code":"003","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SELF","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-08 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"76500","viol_total":"4","oos_total":"1","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"699207","transaction_code":"C","transaction_date":"2024-02-08 00:00:00","upload_date":"2024-02-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00887516","upload_search_indicator":null,"census_search_date":"2024-02-08 21:42:00","snet_input_date":"2024-02-08 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-02-08 21:42:00","insp_carrier_name":"LAPIERRE EXCAVATING LLC","insp_carrier_street":"123 ROCK RD","insp_carrier_city":"BURLINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06013","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:01:59.000000Z","updated_at":"2025-03-17T20:01:59.000000Z","inspection_violations":[{"id":7704300,"change_date":"2024-02-09 21:40:00","inspection_id":"80794946","insp_violation_id":"257748944","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:43:14.000000Z","updated_at":"2025-03-17T21:43:14.000000Z","normalized_code":"3922"},{"id":7704301,"change_date":"2024-02-09 21:40:00","inspection_id":"80794946","insp_violation_id":"257748945","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:43:14.000000Z","updated_at":"2025-03-17T21:43:14.000000Z","normalized_code":"39141A1"},{"id":7704302,"change_date":"2024-02-09 21:40:00","inspection_id":"80794946","insp_violation_id":"257748946","seq_no":"3","part_no":"393","part_no_section":"100(b)","insp_viol_unit":"1","insp_unit_id":"199344336","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:43:14.000000Z","updated_at":"2025-03-17T21:43:14.000000Z","normalized_code":"393100B"},{"id":7704303,"change_date":"2024-02-09 21:40:00","inspection_id":"80794946","insp_violation_id":"257748947","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199344336","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:14.000000Z","updated_at":"2025-03-17T21:43:14.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":8049999,"change_date":"2024-02-09 21:40:00","inspection_id":"80794946","insp_unit_id":"199344336","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"AB19199","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"2NKDX6TXXRM633225","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:56.000000Z","updated_at":"2025-03-17T23:07:56.000000Z"}]},{"id":2610008,"change_date":"2023-03-20 21:40:00","inspection_id":"78128068","dot_number":"887516","report_state":"CT","report_number":"3076002264","insp_date":"2023-03-20 00:00:00","insp_start_time":"0656","insp_end_time":"0742","registration_date":null,"region":"ET","ci_status_code":"C","location":"153","location_desc":"WATERTOWN","county_code_state":"CT","county_code":"005","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"669742","transaction_code":"A","transaction_date":"2023-03-20 00:00:00","upload_date":"2023-03-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00887516","upload_search_indicator":null,"census_search_date":"2023-03-20 21:40:00","snet_input_date":"2023-03-20 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-03-20 21:40:00","insp_carrier_name":"LAPIERRE EXCAVATING LLC","insp_carrier_street":"123 ROCK RD","insp_carrier_city":"BURLINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06013","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:14:51.000000Z","updated_at":"2025-03-17T19:14:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4201467,"change_date":"2023-03-20 21:40:00","inspection_id":"78128068","insp_unit_id":"193947809","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"66284","insp_unit_license":"L26679","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"2NPLHD7XX5M849975","insp_unit_decal":"Y","insp_unit_decal_number":"32380668","created_at":"2025-03-17T22:36:08.000000Z","updated_at":"2025-03-17T22:36:08.000000Z"}]},{"id":2363635,"change_date":"2023-02-22 21:39:00","inspection_id":"77847274","dot_number":"887516","report_state":"CT","report_number":"3070004310","insp_date":"2023-02-11 00:00:00","insp_start_time":"0745","insp_end_time":"0818","registration_date":"2023-02-21 00:00:00","region":"ET","ci_status_code":"C","location":"131","location_desc":"SOUTHINGTON","county_code_state":"CT","county_code":"003","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"0","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"666493","transaction_code":"C","transaction_date":"2023-02-11 00:00:00","upload_date":"2023-02-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00887516","upload_search_indicator":null,"census_search_date":"2023-02-14 21:40:00","snet_input_date":"2023-02-11 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-02-14 21:40:00","insp_carrier_name":"LAPIERRE EXCAVATING LLC","insp_carrier_street":"123 ROCK RD","insp_carrier_city":"BURLINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06013","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:10:18.000000Z","updated_at":"2025-03-17T19:10:18.000000Z","inspection_violations":[{"id":3640675,"change_date":"2023-02-22 21:39:00","inspection_id":"77847274","insp_violation_id":"251260694","seq_no":"1","part_no":"393","part_no_section":"134","insp_viol_unit":"1","insp_unit_id":"193510070","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:24:12.000000Z","updated_at":"2025-03-17T21:24:12.000000Z","normalized_code":"393134"}],"inspection_per_units":[{"id":3804018,"change_date":"2023-02-22 21:39:00","inspection_id":"77847274","insp_unit_id":"193510070","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"L26679","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"2NPLHD7XX5M849975","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:14.000000Z","updated_at":"2025-03-17T22:33:14.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/887516\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/887516\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/887516\/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\/887516\/inspections","per_page":100,"prev_page_url":null,"to":6,"total":6}