{"current_page":1,"data":[{"id":12339867,"change_date":"2026-07-14 21:41:00","inspection_id":"88299231","dot_number":"3887700","report_state":"TX","report_number":"V262448906","insp_date":"2026-06-27 00:00:00","insp_start_time":"1810","insp_end_time":"1833","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"19853 BAUER HOCKLEY","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"C & E EXCAVATION 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":"Y","pen_cen_match":null,"final_status_date":"2026-07-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"35000","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"10014342","transaction_code":"C","transaction_date":"2026-07-14 00:00:00","upload_date":"2026-07-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03887700","upload_search_indicator":"M","census_search_date":"2026-07-01 21:42:00","snet_input_date":"2026-06-27 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-07-01 21:42:00","insp_carrier_name":"C & E EXCAVATION INC","insp_carrier_street":"20020 ANGELI DR","insp_carrier_city":"TOMBALL","insp_carrier_state":"TX","insp_carrier_zip_code":"77377","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1053557","created_at":"2026-07-04T09:42:00.000000Z","updated_at":"2026-07-25T09:30:11.000000Z","inspection_violations":[{"id":21478300,"change_date":"2026-07-14 21:41:00","inspection_id":"88299231","insp_violation_id":"275506965","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"214615605","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-04T10:02:38.000000Z","updated_at":"2026-07-25T09:44:58.000000Z","normalized_code":"39378"},{"id":21478301,"change_date":"2026-07-14 21:41:00","inspection_id":"88299231","insp_violation_id":"275506966","seq_no":"2","part_no":"393","part_no_section":"83G","insp_viol_unit":"1","insp_unit_id":"214615605","insp_violation_category_id":"27","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-07-04T10:02:38.000000Z","updated_at":"2026-07-25T09:44:58.000000Z","normalized_code":"39383G"},{"id":21478302,"change_date":"2026-07-14 21:41:00","inspection_id":"88299231","insp_violation_id":"275506967","seq_no":"3","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"214615605","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-04T10:02:38.000000Z","updated_at":"2026-07-25T09:44:58.000000Z","normalized_code":"3922RG"},{"id":21478303,"change_date":"2026-07-14 21:41:00","inspection_id":"88299231","insp_violation_id":"275506968","seq_no":"4","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"214615605","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-04T10:02:38.000000Z","updated_at":"2026-07-25T09:44:58.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":21429793,"change_date":"2026-07-14 21:41:00","inspection_id":"88299231","insp_unit_id":"214615605","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"RZW8045","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AA08Y81W024542","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-05T09:19:20.000000Z","updated_at":"2026-07-25T09:01:19.000000Z"}]},{"id":11900708,"change_date":"2026-05-13 21:42:00","inspection_id":"87839456","dot_number":"3887700","report_state":"TX","report_number":"7F399DGTHZ","insp_date":"2026-04-29 00:00:00","insp_start_time":"0900","insp_end_time":"0929","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0045 IN HARRIS CO. (24-72)","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","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":"Y","pen_cen_match":null,"final_status_date":"2026-05-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9952393","transaction_code":"A","transaction_date":"2026-05-13 00:00:00","upload_date":"2026-05-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03887700","upload_search_indicator":"M","census_search_date":"2026-05-13 21:42:00","snet_input_date":"2026-04-29 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-05-13 21:42:00","insp_carrier_name":"C & E EXCAVATION INC","insp_carrier_street":"20020 ANGELI DR","insp_carrier_city":"TOMBALL","insp_carrier_state":"TX","insp_carrier_zip_code":"77377","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1053557","created_at":"2026-05-15T12:27:01.000000Z","updated_at":"2026-05-24T09:31:53.000000Z","inspection_violations":[{"id":20698720,"change_date":"2026-05-13 21:42:00","inspection_id":"87839456","insp_violation_id":"274234570","seq_no":"1","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"213534858","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-15T12:59:33.000000Z","updated_at":"2026-05-24T09:45:51.000000Z","normalized_code":"3939"},{"id":20698721,"change_date":"2026-05-13 21:42:00","inspection_id":"87839456","insp_violation_id":"274234571","seq_no":"2","part_no":"393","part_no_section":"83G","insp_viol_unit":"1","insp_unit_id":"213534858","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-15T12:59:33.000000Z","updated_at":"2026-05-24T09:45:51.000000Z","normalized_code":"39383G"}],"inspection_per_units":[{"id":20689789,"change_date":"2026-05-13 21:42:00","inspection_id":"87839456","insp_unit_id":"213534858","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"178","insp_unit_license":"KDG1630","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AA08X3YW017595","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-15T12:14:55.000000Z","updated_at":"2026-05-24T09:05:16.000000Z"}]},{"id":11782254,"change_date":"2026-04-29 21:40:00","inspection_id":"87713610","dot_number":"3887700","report_state":"TX","report_number":"7EUB9DBCHC","insp_date":"2026-04-20 00:00:00","insp_start_time":"1114","insp_end_time":"1151","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"24202  WEST RD","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"C & E EXCAVATOR","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":"Y","pen_cen_match":null,"final_status_date":"2026-04-29 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"0","viol_total":"9","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"9","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9936205","transaction_code":"A","transaction_date":"2026-04-29 00:00:00","upload_date":"2026-04-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03887700","upload_search_indicator":"M","census_search_date":"2026-04-29 21:40:00","snet_input_date":"2026-04-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-04-29 21:40:00","insp_carrier_name":"C & E EXCAVATION INC","insp_carrier_street":"20020 ANGELI DR","insp_carrier_city":"TOMBALL","insp_carrier_state":"TX","insp_carrier_zip_code":"77377","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1053557","created_at":"2026-05-02T09:41:05.000000Z","updated_at":"2026-05-10T09:31:09.000000Z","inspection_violations":[{"id":20488225,"change_date":"2026-04-29 21:40:00","inspection_id":"87713610","insp_violation_id":"273937029","seq_no":"1","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"213292875","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-02T10:02:49.000000Z","updated_at":"2026-05-10T09:41:45.000000Z","normalized_code":"39395A"},{"id":20488227,"change_date":"2026-04-29 21:40:00","inspection_id":"87713610","insp_violation_id":"273937031","seq_no":"3","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"213292875","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-02T10:02:49.000000Z","updated_at":"2026-05-10T09:41:45.000000Z","normalized_code":"39311"},{"id":20488228,"change_date":"2026-04-29 21:40:00","inspection_id":"87713610","insp_violation_id":"273937032","seq_no":"4","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"213292875","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-02T10:02:49.000000Z","updated_at":"2026-05-10T09:41:45.000000Z","normalized_code":"3939"},{"id":20488229,"change_date":"2026-04-29 21:40:00","inspection_id":"87713610","insp_violation_id":"273937033","seq_no":"5","part_no":"393","part_no_section":"205C","insp_viol_unit":"1","insp_unit_id":"213292875","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-02T10:02:49.000000Z","updated_at":"2026-05-10T09:41:45.000000Z","normalized_code":"393205C"},{"id":20488230,"change_date":"2026-04-29 21:40:00","inspection_id":"87713610","insp_violation_id":"273937034","seq_no":"6","part_no":"396","part_no_section":"5B-HWSLIW","insp_viol_unit":"1","insp_unit_id":"213292875","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-02T10:02:49.000000Z","updated_at":"2026-05-10T09:41:45.000000Z","normalized_code":"3965BHWSLIW"},{"id":20488231,"change_date":"2026-04-29 21:40:00","inspection_id":"87713610","insp_violation_id":"273937035","seq_no":"7","part_no":"393","part_no_section":"45UV","insp_viol_unit":"1","insp_unit_id":"213292875","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-02T10:02:49.000000Z","updated_at":"2026-05-10T09:41:45.000000Z","normalized_code":"39345UV"},{"id":20488232,"change_date":"2026-04-29 21:40:00","inspection_id":"87713610","insp_violation_id":"273937036","seq_no":"8","part_no":"393","part_no_section":"47A","insp_viol_unit":"1","insp_unit_id":"213292875","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-02T10:02:49.000000Z","updated_at":"2026-05-10T09:41:45.000000Z","normalized_code":"39347A"},{"id":20488233,"change_date":"2026-04-29 21:40:00","inspection_id":"87713610","insp_violation_id":"273937037","seq_no":"9","part_no":"393","part_no_section":"28","insp_viol_unit":"1","insp_unit_id":"213292875","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-02T10:02:49.000000Z","updated_at":"2026-05-10T09:41:45.000000Z","normalized_code":"39328"},{"id":20488226,"change_date":"2026-04-29 21:40:00","inspection_id":"87713610","insp_violation_id":"273937030","seq_no":"2","part_no":"393","part_no_section":"60E-WS","insp_viol_unit":"1","insp_unit_id":"213292875","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-02T10:02:49.000000Z","updated_at":"2026-05-10T09:41:45.000000Z","normalized_code":"39360EWS"}],"inspection_per_units":[{"id":20496830,"change_date":"2026-04-29 21:40:00","inspection_id":"87713610","insp_unit_id":"213292875","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"FPR7386","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AA13Y41W136185","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-02T09:19:21.000000Z","updated_at":"2026-05-10T09:03:50.000000Z"}]},{"id":9670216,"change_date":"2025-09-12 21:49:00","inspection_id":"85763257","dot_number":"3887700","report_state":"TX","report_number":"V252006435","insp_date":"2025-09-10 00:00:00","insp_start_time":"0612","insp_end_time":"0642","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US290 WB","county_code_state":"TX","county_code":"473","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"C&E EXCAVATION","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":"Y","pen_cen_match":null,"final_status_date":"2025-09-12 21:49:00","post_acc_ind":"N","gross_comb_veh_wt":"57001","viol_total":"4","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9694142","transaction_code":"A","transaction_date":"2025-09-12 00:00:00","upload_date":"2025-09-12 00:00:00","upload_first_byte":"0","upload_dot_number":"03887700","upload_search_indicator":"M","census_search_date":"2025-09-12 21:49:00","snet_input_date":"2025-09-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-09-12 21:49:00","insp_carrier_name":"C & E EXCAVATION INC","insp_carrier_street":"20020 ANGELI DR","insp_carrier_city":"TOMBALL","insp_carrier_state":"TX","insp_carrier_zip_code":"77377","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1053557","created_at":"2025-09-16T10:48:17.000000Z","updated_at":"2025-09-16T10:48:17.000000Z","inspection_violations":[{"id":15848709,"change_date":"2025-09-12 21:49:00","inspection_id":"85763257","insp_violation_id":"268663615","seq_no":"1","part_no":"393","part_no_section":"130","insp_viol_unit":"2","insp_unit_id":"208922305","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-09-14T11:58:06.000000Z","updated_at":"2025-09-16T10:51:26.000000Z","normalized_code":"393130"},{"id":15848710,"change_date":"2025-09-12 21:49:00","inspection_id":"85763257","insp_violation_id":"268663616","seq_no":"2","part_no":"393","part_no_section":"43D","insp_viol_unit":"2","insp_unit_id":"208922305","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-09-14T11:58:06.000000Z","updated_at":"2025-09-16T10:51:26.000000Z","normalized_code":"39343D"},{"id":15848711,"change_date":"2025-09-12 21:49:00","inspection_id":"85763257","insp_violation_id":"268663617","seq_no":"3","part_no":"393","part_no_section":"48A","insp_viol_unit":"2","insp_unit_id":"208922305","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-14T11:58:06.000000Z","updated_at":"2025-09-16T10:51:26.000000Z","normalized_code":"39348A"},{"id":15848712,"change_date":"2025-09-12 21:49:00","inspection_id":"85763257","insp_violation_id":"268663618","seq_no":"4","part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"2","insp_unit_id":"208922305","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-09-14T11:58:06.000000Z","updated_at":"2025-09-16T10:51:26.000000Z","normalized_code":"3963A1BOS"}],"inspection_per_units":[{"id":15995454,"change_date":"2025-09-12 21:49:00","inspection_id":"85763257","insp_unit_id":"208922304","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"RZW8045","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AA08Y81W024542","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-15T09:53:59.000000Z","updated_at":"2025-09-16T09:56:10.000000Z"},{"id":15995455,"change_date":"2025-09-12 21:49:00","inspection_id":"85763257","insp_unit_id":"208922305","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"858526M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"17YBP2420XB018194","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-15T09:53:59.000000Z","updated_at":"2025-09-16T09:56:10.000000Z"}]},{"id":9125391,"change_date":"2025-07-11 21:39:00","inspection_id":"85190838","dot_number":"3887700","report_state":"TX","report_number":"V251908919","insp_date":"2025-06-07 00:00:00","insp_start_time":"1500","insp_end_time":"1533","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US 99 N\/B @ CUMBERLA","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"VARIOUS","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":"Y","pen_cen_match":null,"final_status_date":"2025-07-11 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"35000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9634283","transaction_code":"A","transaction_date":"2025-07-11 00:00:00","upload_date":"2025-07-11 00:00:00","upload_first_byte":"0","upload_dot_number":"03887700","upload_search_indicator":"M","census_search_date":"2025-07-11 21:39:00","snet_input_date":"2025-06-07 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-07-11 21:39:00","insp_carrier_name":"C & E EXCAVATION INC","insp_carrier_street":"20020 ANGELI DR","insp_carrier_city":"TOMBALL","insp_carrier_state":"TX","insp_carrier_zip_code":"77377","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1053557","created_at":"2025-07-14T10:47:06.000000Z","updated_at":"2025-07-16T10:44:52.000000Z","inspection_violations":[{"id":14712743,"change_date":"2025-07-11 21:39:00","inspection_id":"85190838","insp_violation_id":"267352474","seq_no":"1","part_no":"393","part_no_section":"55C1","insp_viol_unit":"1","insp_unit_id":"207825382","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-14T10:48:52.000000Z","updated_at":"2025-07-16T10:46:18.000000Z","normalized_code":"39355C1"},{"id":14712744,"change_date":"2025-07-11 21:39:00","inspection_id":"85190838","insp_violation_id":"267352475","seq_no":"2","part_no":"393","part_no_section":"75A3","insp_viol_unit":"1","insp_unit_id":"207825382","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-07-14T10:48:52.000000Z","updated_at":"2025-07-16T10:46:18.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":14982680,"change_date":"2025-07-11 21:39:00","inspection_id":"85190838","insp_unit_id":"207825382","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"01","insp_unit_license":"RZW8045","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AA08Y81W024542","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-14T09:46:09.000000Z","updated_at":"2025-07-15T09:46:00.000000Z"}]},{"id":8086999,"change_date":"2025-03-11 21:41:00","inspection_id":"84095309","dot_number":"3887700","report_state":"TX","report_number":"73HB9DKYD5","insp_date":"2025-03-07 00:00:00","insp_start_time":"1153","insp_end_time":"1222","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2000  LAGO MAR BLVD","county_code_state":"TX","county_code":"167","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"OPEN","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":"Y","pen_cen_match":null,"final_status_date":"2025-03-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9517995","transaction_code":"A","transaction_date":"2025-03-10 00:00:00","upload_date":"2025-03-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03887700","upload_search_indicator":"M","census_search_date":"2025-03-11 21:41:00","snet_input_date":"2025-03-07 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-03-11 21:41:00","insp_carrier_name":"C & E EXCAVATION INC","insp_carrier_street":"11431 BOTTLEBRUSH LN","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77095-3864","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1053557","created_at":"2025-03-17T21:06:16.000000Z","updated_at":"2025-03-17T21:06:16.000000Z","inspection_violations":[{"id":12640382,"change_date":"2025-03-11 21:41:00","inspection_id":"84095309","insp_violation_id":"264957025","seq_no":"2","part_no":"392","part_no_section":"2W","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:07:55.000000Z","updated_at":"2025-03-17T22:07:55.000000Z","normalized_code":"3922W"}],"inspection_per_units":[{"id":13056891,"change_date":"2025-03-11 21:41:00","inspection_id":"84095309","insp_unit_id":"205741956","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"003","insp_unit_license":"RZW8045","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AA08Y81W024542","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:21.000000Z","updated_at":"2025-03-17T23:59:21.000000Z"}]},{"id":8011272,"change_date":"2025-03-03 21:38:00","inspection_id":"84015641","dot_number":"3887700","report_state":"TX","report_number":"73989DGA8E","insp_date":"2025-02-27 00:00:00","insp_start_time":"0853","insp_end_time":"0922","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM-1266 IN GALVESTON CO. (484-","county_code_state":"TX","county_code":"167","insp_level_id":"2","service_center":"WE","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":"Y","pen_cen_match":null,"final_status_date":"2025-03-03 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"35000","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":"9511010","transaction_code":"A","transaction_date":"2025-03-03 00:00:00","upload_date":"2025-03-03 00:00:00","upload_first_byte":"0","upload_dot_number":"03887700","upload_search_indicator":"M","census_search_date":"2025-03-03 21:38:00","snet_input_date":"2025-02-27 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-03-03 21:38:00","insp_carrier_name":"C & E EXCAVATION INC","insp_carrier_street":"11431 BOTTLEBRUSH LN","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77095-3864","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1053557","created_at":"2025-03-17T21:04:30.000000Z","updated_at":"2025-03-17T21:04:30.000000Z","inspection_violations":[{"id":12518728,"change_date":"2025-03-03 21:38:00","inspection_id":"84015641","insp_violation_id":"264801194","seq_no":"2","part_no":"393","part_no_section":"9TS","insp_viol_unit":"1","insp_unit_id":"205597603","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:09.000000Z","updated_at":"2025-03-17T22:07:09.000000Z","normalized_code":"3939TS"}],"inspection_per_units":[{"id":12933819,"change_date":"2025-03-03 21:38:00","inspection_id":"84015641","insp_unit_id":"205597603","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"V-542","insp_unit_license":"RZW8045","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AA08Y81W024542","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:51.000000Z","updated_at":"2025-03-17T23:57:51.000000Z"}]},{"id":7718906,"change_date":"2025-01-27 21:40:00","inspection_id":"83708548","dot_number":"3887700","report_state":"TX","report_number":"72BE9DAWMM","insp_date":"2025-01-24 00:00:00","insp_start_time":"1429","insp_end_time":"1534","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"1700 W PARKWOOD AVE","county_code_state":"TX","county_code":"167","insp_level_id":"1","service_center":"WE","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":"Y","pen_cen_match":null,"final_status_date":"2025-01-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"12","oos_total":"5","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"12","vehicle_oos_total":"5","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9483207","transaction_code":"A","transaction_date":"2025-01-27 00:00:00","upload_date":"2025-01-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03887700","upload_search_indicator":"M","census_search_date":"2025-01-27 21:40:00","snet_input_date":"2025-01-24 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-01-27 21:40:00","insp_carrier_name":"C & E EXCAVATION INC","insp_carrier_street":"11431 BOTTLEBRUSH LN","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77095-3864","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1053557","created_at":"2025-03-17T20:58:21.000000Z","updated_at":"2025-03-17T20:58:21.000000Z","inspection_violations":[{"id":12059538,"change_date":"2025-01-27 21:40:00","inspection_id":"83708548","insp_violation_id":"264196428","seq_no":"2","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"205026517","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:46.000000Z","updated_at":"2025-03-17T22:04:46.000000Z","normalized_code":"3922RG"},{"id":12059539,"change_date":"2025-01-27 21:40:00","inspection_id":"83708548","insp_violation_id":"264196429","seq_no":"3","part_no":"393","part_no_section":"51","insp_viol_unit":"1","insp_unit_id":"205026517","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T22:04:46.000000Z","updated_at":"2025-03-17T22:04:46.000000Z","normalized_code":"39351"},{"id":12059540,"change_date":"2025-01-27 21:40:00","inspection_id":"83708548","insp_violation_id":"264196430","seq_no":"4","part_no":"393","part_no_section":"28","insp_viol_unit":"1","insp_unit_id":"205026517","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:46.000000Z","updated_at":"2025-03-17T22:04:46.000000Z","normalized_code":"39328"},{"id":12059541,"change_date":"2025-01-27 21:40:00","inspection_id":"83708548","insp_violation_id":"264196431","seq_no":"5","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"205026517","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:46.000000Z","updated_at":"2025-03-17T22:04:46.000000Z","normalized_code":"3939"},{"id":12059542,"change_date":"2025-01-27 21:40:00","inspection_id":"83708548","insp_violation_id":"264196432","seq_no":"6","part_no":"393","part_no_section":"75C","insp_viol_unit":"1","insp_unit_id":"205026517","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:46.000000Z","updated_at":"2025-03-17T22:04:46.000000Z","normalized_code":"39375C"},{"id":12059543,"change_date":"2025-01-27 21:40:00","inspection_id":"83708548","insp_violation_id":"264196433","seq_no":"7","part_no":"393","part_no_section":"207A","insp_viol_unit":"1","insp_unit_id":"205026517","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:04:46.000000Z","updated_at":"2025-03-17T22:04:46.000000Z","normalized_code":"393207A"},{"id":12059544,"change_date":"2025-01-27 21:40:00","inspection_id":"83708548","insp_violation_id":"264196434","seq_no":"8","part_no":"393","part_no_section":"209D","insp_viol_unit":"1","insp_unit_id":"205026517","insp_violation_category_id":"21","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:04:46.000000Z","updated_at":"2025-03-17T22:04:46.000000Z","normalized_code":"393209D"},{"id":12059545,"change_date":"2025-01-27 21:40:00","inspection_id":"83708548","insp_violation_id":"264196435","seq_no":"9","part_no":"396","part_no_section":"3A1-TC","insp_viol_unit":"1","insp_unit_id":"205026517","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:04:46.000000Z","updated_at":"2025-03-17T22:04:46.000000Z","normalized_code":"3963A1TC"},{"id":12059546,"change_date":"2025-01-27 21:40:00","inspection_id":"83708548","insp_violation_id":"264196436","seq_no":"10","part_no":"393","part_no_section":"209B","insp_viol_unit":"1","insp_unit_id":"205026517","insp_violation_category_id":"21","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:04:46.000000Z","updated_at":"2025-03-17T22:04:46.000000Z","normalized_code":"393209B"},{"id":12059547,"change_date":"2025-01-27 21:40:00","inspection_id":"83708548","insp_violation_id":"264196437","seq_no":"11","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"205026517","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:46.000000Z","updated_at":"2025-03-17T22:04:46.000000Z","normalized_code":"3965B"},{"id":12059548,"change_date":"2025-01-27 21:40:00","inspection_id":"83708548","insp_violation_id":"264196438","seq_no":"12","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"205026517","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:46.000000Z","updated_at":"2025-03-17T22:04:46.000000Z","normalized_code":"39347E"},{"id":12059549,"change_date":"2025-01-27 21:40:00","inspection_id":"83708548","insp_violation_id":"264196439","seq_no":"13","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"205026517","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:46.000000Z","updated_at":"2025-03-17T22:04:46.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":12456251,"change_date":"2025-01-27 21:40:00","inspection_id":"83708548","insp_unit_id":"205026517","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"PCW6990","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AA18Y3YW129392","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:27.000000Z","updated_at":"2025-03-17T23:52:27.000000Z"}]},{"id":7673709,"change_date":"2025-01-21 21:40:00","inspection_id":"83661250","dot_number":"3887700","report_state":"TX","report_number":"724D9DAWMI","insp_date":"2025-01-17 00:00:00","insp_start_time":"1304","insp_end_time":"1322","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"1500 W PARKWOOD AVE","county_code_state":"TX","county_code":"167","insp_level_id":"2","service_center":"WE","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":"Y","pen_cen_match":null,"final_status_date":"2025-01-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","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":"9477821","transaction_code":"A","transaction_date":"2025-01-21 00:00:00","upload_date":"2025-01-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03887700","upload_search_indicator":"M","census_search_date":"2025-01-21 21:40:00","snet_input_date":"2025-01-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-01-21 21:40:00","insp_carrier_name":"C & E EXCAVATION INC","insp_carrier_street":"11431 BOTTLEBRUSH LN","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77095-3864","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1053557","created_at":"2025-03-17T20:57:28.000000Z","updated_at":"2025-03-17T20:57:28.000000Z","inspection_violations":[{"id":11990112,"change_date":"2025-01-21 21:40:00","inspection_id":"83661250","insp_violation_id":"264104756","seq_no":"1","part_no":"393","part_no_section":"75A3","insp_viol_unit":"1","insp_unit_id":"204938394","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T22:04:25.000000Z","updated_at":"2025-03-17T22:04:25.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":12382514,"change_date":"2025-01-21 21:40:00","inspection_id":"83661250","insp_unit_id":"204938394","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"FPR7386","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AA13Y41W136185","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:39.000000Z","updated_at":"2025-03-17T23:51:39.000000Z"}]},{"id":7073790,"change_date":"2024-10-29 21:42:00","inspection_id":"83029105","dot_number":"3887700","report_state":"TX","report_number":"6ZRB9DAWJ8","insp_date":"2024-10-24 00:00:00","insp_start_time":"1110","insp_end_time":"1131","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"1700 W PARKWOOD AVE","county_code_state":"TX","county_code":"167","insp_level_id":"2","service_center":"WE","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":"Y","pen_cen_match":null,"final_status_date":"2024-10-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"2","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9413606","transaction_code":"A","transaction_date":"2024-10-29 00:00:00","upload_date":"2024-10-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03887700","upload_search_indicator":"M","census_search_date":"2024-10-29 21:42:00","snet_input_date":"2024-10-24 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-10-29 21:42:00","insp_carrier_name":"C & E EXCAVATION INC","insp_carrier_street":"11431 BOTTLEBRUSH LN","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77095-3864","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1053557","created_at":"2025-03-17T20:43:28.000000Z","updated_at":"2025-03-17T20:43:28.000000Z","inspection_violations":[{"id":11042920,"change_date":"2024-10-29 21:42:00","inspection_id":"83029105","insp_violation_id":"262620218","seq_no":"1","part_no":"396","part_no_section":"3A1BL","insp_viol_unit":"1","insp_unit_id":"203642061","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:59:36.000000Z","updated_at":"2025-03-17T21:59:36.000000Z","normalized_code":"3963A1BL"},{"id":11042921,"change_date":"2024-10-29 21:42:00","inspection_id":"83029105","insp_violation_id":"262620219","seq_no":"2","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"203642061","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:59:36.000000Z","updated_at":"2025-03-17T21:59:36.000000Z","normalized_code":"39345"}],"inspection_per_units":[{"id":11408333,"change_date":"2024-10-29 21:42:00","inspection_id":"83029105","insp_unit_id":"203642061","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"KDG1630","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AA08X3YW017595","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:07.000000Z","updated_at":"2025-03-17T23:41:07.000000Z"}]},{"id":6904584,"change_date":"2024-10-07 21:41:00","inspection_id":"82849440","dot_number":"3887700","report_state":"TX","report_number":"6Z6D9DIARR","insp_date":"2024-10-03 00:00:00","insp_start_time":"1324","insp_end_time":"1410","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2100  REED RD","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","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":"Y","pen_cen_match":null,"final_status_date":"2024-10-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","viol_total":"6","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9394826","transaction_code":"A","transaction_date":"2024-10-07 00:00:00","upload_date":"2024-10-07 00:00:00","upload_first_byte":"0","upload_dot_number":"03887700","upload_search_indicator":"M","census_search_date":"2024-10-07 21:41:00","snet_input_date":"2024-10-03 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-10-07 21:41:00","insp_carrier_name":"C & E EXCAVATION INC","insp_carrier_street":"11431 BOTTLEBRUSH LN","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77095-3864","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1053557","created_at":"2025-03-17T20:40:12.000000Z","updated_at":"2025-03-17T20:40:12.000000Z","inspection_violations":[{"id":10759067,"change_date":"2024-10-07 21:41:00","inspection_id":"82849440","insp_violation_id":"262226916","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"203301976","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:58:04.000000Z","updated_at":"2025-03-17T21:58:04.000000Z","normalized_code":"3963A1"},{"id":10759068,"change_date":"2024-10-07 21:41:00","inspection_id":"82849440","insp_violation_id":"262226917","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"203301976","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:04.000000Z","updated_at":"2025-03-17T21:58:04.000000Z","normalized_code":"39347E"},{"id":10759069,"change_date":"2024-10-07 21:41:00","inspection_id":"82849440","insp_violation_id":"262226918","seq_no":"3","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"203301976","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:04.000000Z","updated_at":"2025-03-17T21:58:04.000000Z","normalized_code":"39347E"},{"id":10759070,"change_date":"2024-10-07 21:41:00","inspection_id":"82849440","insp_violation_id":"262226919","seq_no":"4","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"203301976","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:04.000000Z","updated_at":"2025-03-17T21:58:04.000000Z","normalized_code":"39347E"},{"id":10759071,"change_date":"2024-10-07 21:41:00","inspection_id":"82849440","insp_violation_id":"262226920","seq_no":"5","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"203301976","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:04.000000Z","updated_at":"2025-03-17T21:58:04.000000Z","normalized_code":"39353B"},{"id":10759072,"change_date":"2024-10-07 21:41:00","inspection_id":"82849440","insp_violation_id":"262226921","seq_no":"6","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"203301976","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:58:04.000000Z","updated_at":"2025-03-17T21:58:04.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":11135611,"change_date":"2024-10-07 21:41:00","inspection_id":"82849440","insp_unit_id":"203301976","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"531","insp_unit_license":"PCW6990","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AA18Y3YW129392","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:21.000000Z","updated_at":"2025-03-17T23:38:21.000000Z"}]},{"id":4989809,"change_date":"2024-02-07 21:41:00","inspection_id":"80782194","dot_number":"3887700","report_state":"TX","report_number":"6SC99DGAWL","insp_date":"2024-01-31 00:00:00","insp_start_time":"0953","insp_end_time":"1025","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0045 IN GALVESTON CO. (0-23","county_code_state":"TX","county_code":"167","insp_level_id":"2","service_center":"WE","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":"Y","pen_cen_match":null,"final_status_date":"2024-02-06 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"9189286","transaction_code":"C","transaction_date":"2024-02-07 00:00:00","upload_date":"2024-02-07 00:00:00","upload_first_byte":"0","upload_dot_number":"03887700","upload_search_indicator":"M","census_search_date":"2024-02-06 21:42:00","snet_input_date":"2024-01-31 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-02-06 21:42:00","insp_carrier_name":"C & E EXCAVATION INC","insp_carrier_street":"11431 BOTTLEBRUSH LN","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77095-3864","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1053557","created_at":"2025-03-17T20:01:38.000000Z","updated_at":"2025-03-17T20:01:38.000000Z","inspection_violations":[{"id":7684982,"change_date":"2024-02-07 21:41:00","inspection_id":"80782194","insp_violation_id":"257715929","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"199315189","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:08.000000Z","updated_at":"2025-03-17T21:43:08.000000Z","normalized_code":"39378"}],"inspection_per_units":[{"id":8031055,"change_date":"2024-02-07 21:41:00","inspection_id":"80782194","insp_unit_id":"199315189","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"V-542","insp_unit_license":"RZW8045","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AA08Y81W024542","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:48.000000Z","updated_at":"2025-03-17T23:07:48.000000Z"}]},{"id":4877653,"change_date":"2024-01-22 21:44:00","inspection_id":"80659484","dot_number":"3887700","report_state":"TX","report_number":"6S0E9DAW7M","insp_date":"2024-01-19 00:00:00","insp_start_time":"1409","insp_end_time":"1435","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2400 W PARKWOOD AVE","county_code_state":"TX","county_code":"167","insp_level_id":"2","service_center":"WE","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":"Y","pen_cen_match":null,"final_status_date":"2024-01-22 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"6","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9177836","transaction_code":"A","transaction_date":"2024-01-22 00:00:00","upload_date":"2024-01-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03887700","upload_search_indicator":"M","census_search_date":"2024-01-22 21:44:00","snet_input_date":"2024-01-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-01-22 21:44:00","insp_carrier_name":"C & E EXCAVATION INC","insp_carrier_street":"11431 BOTTLEBRUSH LN","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77095-3864","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1053557","created_at":"2025-03-17T19:59:17.000000Z","updated_at":"2025-03-17T19:59:17.000000Z","inspection_violations":[{"id":7516213,"change_date":"2024-01-22 21:44:00","inspection_id":"80659484","insp_violation_id":"257439260","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"199056297","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:14.000000Z","updated_at":"2025-03-17T21:42:14.000000Z","normalized_code":"39347E"},{"id":7516214,"change_date":"2024-01-22 21:44:00","inspection_id":"80659484","insp_violation_id":"257439261","seq_no":"2","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"199056297","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:14.000000Z","updated_at":"2025-03-17T21:42:14.000000Z","normalized_code":"39353B"},{"id":7516215,"change_date":"2024-01-22 21:44:00","inspection_id":"80659484","insp_violation_id":"257439262","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"199056297","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:14.000000Z","updated_at":"2025-03-17T21:42:14.000000Z","normalized_code":"39378"},{"id":7516216,"change_date":"2024-01-22 21:44:00","inspection_id":"80659484","insp_violation_id":"257439263","seq_no":"4","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"199056297","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:14.000000Z","updated_at":"2025-03-17T21:42:14.000000Z","normalized_code":"3965B"},{"id":7516217,"change_date":"2024-01-22 21:44:00","inspection_id":"80659484","insp_violation_id":"257439264","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199056297","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:14.000000Z","updated_at":"2025-03-17T21:42:14.000000Z","normalized_code":"3939A"},{"id":7516218,"change_date":"2024-01-22 21:44:00","inspection_id":"80659484","insp_violation_id":"257439265","seq_no":"6","part_no":"392","part_no_section":"9(a)(2)","insp_viol_unit":"1","insp_unit_id":"199056297","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:42:14.000000Z","updated_at":"2025-03-17T21:42:14.000000Z","normalized_code":"3929A2"}],"inspection_per_units":[{"id":7848126,"change_date":"2024-01-22 21:44:00","inspection_id":"80659484","insp_unit_id":"199056297","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"PCW6990","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AA18Y3YW129392","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:08.000000Z","updated_at":"2025-03-17T23:06:08.000000Z"}]},{"id":4757381,"change_date":"2024-12-06 21:44:00","inspection_id":"80527887","dot_number":"3887700","report_state":"TX","report_number":"6R199DBEZ6","insp_date":"2023-12-15 00:00:00","insp_start_time":"0935","insp_end_time":"1020","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"4830  WILSON RD","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"C&E EXCAVATION","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":"Y","pen_cen_match":null,"final_status_date":"2024-01-03 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"0","viol_total":"5","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9164334","transaction_code":"C","transaction_date":"2024-12-06 00:00:00","upload_date":"2024-12-06 00:00:00","upload_first_byte":"0","upload_dot_number":"03887700","upload_search_indicator":"M","census_search_date":"2024-01-03 21:44:00","snet_input_date":"2023-12-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-01-03 21:44:00","insp_carrier_name":"C & E EXCAVATION INC","insp_carrier_street":"11431 BOTTLEBRUSH LN","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77095-3864","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1053557","created_at":"2025-03-17T19:56:56.000000Z","updated_at":"2025-03-17T19:56:56.000000Z","inspection_violations":[{"id":7341411,"change_date":"2024-12-06 21:44:00","inspection_id":"80527887","insp_violation_id":"263293456","seq_no":"5","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"204235378","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:29.000000Z","updated_at":"2025-03-17T21:41:29.000000Z","normalized_code":"39311"},{"id":7341412,"change_date":"2024-12-06 21:44:00","inspection_id":"80527887","insp_violation_id":"263293457","seq_no":"6","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"204235378","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:29.000000Z","updated_at":"2025-03-17T21:41:29.000000Z","normalized_code":"3939"},{"id":7341413,"change_date":"2024-12-06 21:44:00","inspection_id":"80527887","insp_violation_id":"263293458","seq_no":"7","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"204235378","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:29.000000Z","updated_at":"2025-03-17T21:41:29.000000Z","normalized_code":"3939"},{"id":7341414,"change_date":"2024-12-06 21:44:00","inspection_id":"80527887","insp_violation_id":"263293459","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"204235378","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:29.000000Z","updated_at":"2025-03-17T21:41:29.000000Z","normalized_code":"39378"},{"id":7341415,"change_date":"2024-12-06 21:44:00","inspection_id":"80527887","insp_violation_id":"263293460","seq_no":"4","part_no":"393","part_no_section":"83G","insp_viol_unit":"1","insp_unit_id":"204235378","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:29.000000Z","updated_at":"2025-03-17T21:41:29.000000Z","normalized_code":"39383G"}],"inspection_per_units":[{"id":7653294,"change_date":"2024-12-06 21:44:00","inspection_id":"80527887","insp_unit_id":"204235378","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"004","insp_unit_license":"FPR7386","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AA13Y41W136185","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:24.000000Z","updated_at":"2025-03-17T23:04:24.000000Z"}]},{"id":4465710,"change_date":"2023-11-20 21:41:00","inspection_id":"80208301","dot_number":"3887700","report_state":"TX","report_number":"6Q8B9DAW5L","insp_date":"2023-11-16 00:00:00","insp_start_time":"1144","insp_end_time":"1225","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"1700 W PARKWOOD AVE","county_code_state":"TX","county_code":"167","insp_level_id":"2","service_center":"WE","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":"Y","pen_cen_match":null,"final_status_date":"2023-11-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"8","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9128452","transaction_code":"A","transaction_date":"2023-11-20 00:00:00","upload_date":"2023-11-20 00:00:00","upload_first_byte":"0","upload_dot_number":"03887700","upload_search_indicator":"M","census_search_date":"2023-11-20 21:41:00","snet_input_date":"2023-11-16 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-11-20 21:41:00","insp_carrier_name":"C & E EXCAVATION INC","insp_carrier_street":"11431 BOTTLEBRUSH LN","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77095-3864","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1053557","created_at":"2025-03-17T19:51:24.000000Z","updated_at":"2025-03-17T19:51:24.000000Z","inspection_violations":[{"id":6912337,"change_date":"2023-11-20 21:41:00","inspection_id":"80208301","insp_violation_id":"256496150","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"198150977","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:39:20.000000Z","updated_at":"2025-03-17T21:39:20.000000Z","normalized_code":"3963A1"},{"id":6912338,"change_date":"2023-11-20 21:41:00","inspection_id":"80208301","insp_violation_id":"256496151","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"198150977","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:20.000000Z","updated_at":"2025-03-17T21:39:20.000000Z","normalized_code":"3963A1"},{"id":6912339,"change_date":"2023-11-20 21:41:00","inspection_id":"80208301","insp_violation_id":"256496152","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198150977","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:20.000000Z","updated_at":"2025-03-17T21:39:20.000000Z","normalized_code":"3939A"},{"id":6912340,"change_date":"2023-11-20 21:41:00","inspection_id":"80208301","insp_violation_id":"256496153","seq_no":"4","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"198150977","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:20.000000Z","updated_at":"2025-03-17T21:39:20.000000Z","normalized_code":"39347E"},{"id":6912341,"change_date":"2023-11-20 21:41:00","inspection_id":"80208301","insp_violation_id":"256496154","seq_no":"5","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"198150977","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:20.000000Z","updated_at":"2025-03-17T21:39:20.000000Z","normalized_code":"39353B"},{"id":6912342,"change_date":"2023-11-20 21:41:00","inspection_id":"80208301","insp_violation_id":"256496155","seq_no":"6","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"198150977","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:39:20.000000Z","updated_at":"2025-03-17T21:39:20.000000Z","normalized_code":"39375A3"},{"id":6912343,"change_date":"2023-11-20 21:41:00","inspection_id":"80208301","insp_violation_id":"256496156","seq_no":"7","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"198150977","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:20.000000Z","updated_at":"2025-03-17T21:39:20.000000Z","normalized_code":"39375A3"},{"id":6912344,"change_date":"2023-11-20 21:41:00","inspection_id":"80208301","insp_violation_id":"256496157","seq_no":"8","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"198150977","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:20.000000Z","updated_at":"2025-03-17T21:39:20.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":7182080,"change_date":"2023-11-20 21:41:00","inspection_id":"80208301","insp_unit_id":"198150977","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"178","insp_unit_license":"KDG1630","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AA08X3YW017595","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:19.000000Z","updated_at":"2025-03-17T23:00:19.000000Z"}]},{"id":3780473,"change_date":"2023-08-23 21:41:00","inspection_id":"79448117","dot_number":"3887700","report_state":"TX","report_number":"V231107423","insp_date":"2023-08-16 00:00:00","insp_start_time":"0933","insp_end_time":"1000","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"S LASALLE ST, NAVASO","county_code_state":"TX","county_code":"185","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SUNSHINE FUN","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":"Y","pen_cen_match":null,"final_status_date":"2023-08-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9055657","transaction_code":"C","transaction_date":"2023-08-22 00:00:00","upload_date":"2023-08-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03887700","upload_search_indicator":"M","census_search_date":"2023-08-18 21:42:00","snet_input_date":"2023-08-16 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-08-18 21:42:00","insp_carrier_name":"C & E EXCAVATION INC","insp_carrier_street":"11431 BOTTLEBRUSH LN","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77095-3864","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1053557","created_at":"2025-03-17T19:37:38.000000Z","updated_at":"2025-03-17T19:37:38.000000Z","inspection_violations":[{"id":5832922,"change_date":"2023-08-23 21:41:00","inspection_id":"79448117","insp_violation_id":"254843512","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"196695141","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:04.000000Z","updated_at":"2025-03-17T21:34:04.000000Z","normalized_code":"39347E"},{"id":5832923,"change_date":"2023-08-23 21:41:00","inspection_id":"79448117","insp_violation_id":"254843513","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"196695141","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:04.000000Z","updated_at":"2025-03-17T21:34:04.000000Z","normalized_code":"39347E"},{"id":5832924,"change_date":"2023-08-23 21:41:00","inspection_id":"79448117","insp_violation_id":"254843514","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"196695141","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:04.000000Z","updated_at":"2025-03-17T21:34:04.000000Z","normalized_code":"39378"},{"id":5832925,"change_date":"2023-08-23 21:41:00","inspection_id":"79448117","insp_violation_id":"254843515","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"196695141","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:34:04.000000Z","updated_at":"2025-03-17T21:34:04.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":6078587,"change_date":"2023-08-23 21:41:00","inspection_id":"79448117","insp_unit_id":"196695141","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"178","insp_unit_license":"KDG1630","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AA08X3YW017595","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:04.000000Z","updated_at":"2025-03-17T22:51:04.000000Z"}]},{"id":3184144,"change_date":"2023-05-31 21:43:00","inspection_id":"78778583","dot_number":"3887700","report_state":"TX","report_number":"6LD89DAWZ4","insp_date":"2023-05-25 00:00:00","insp_start_time":"0816","insp_end_time":"0842","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"100 W PARKWOOD AVE","county_code_state":"TX","county_code":"167","insp_level_id":"2","service_center":"WE","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":"Y","pen_cen_match":null,"final_status_date":"2023-05-31 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"8","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8993332","transaction_code":"A","transaction_date":"2023-05-31 00:00:00","upload_date":"2023-05-31 00:00:00","upload_first_byte":"0","upload_dot_number":"03887700","upload_search_indicator":"M","census_search_date":"2023-05-31 21:43:00","snet_input_date":"2023-05-25 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-05-31 21:43:00","insp_carrier_name":"C & E EXCAVATION INC","insp_carrier_street":"11431 BOTTLEBRUSH LN","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77095-3864","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1053557","created_at":"2025-03-17T19:26:04.000000Z","updated_at":"2025-03-17T19:26:04.000000Z","inspection_violations":[{"id":4907069,"change_date":"2023-05-31 21:43:00","inspection_id":"78778583","insp_violation_id":"253194864","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"195240734","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:51.000000Z","updated_at":"2025-03-17T21:29:51.000000Z","normalized_code":"39378"},{"id":4907070,"change_date":"2023-05-31 21:43:00","inspection_id":"78778583","insp_violation_id":"253194865","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195240734","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:51.000000Z","updated_at":"2025-03-17T21:29:51.000000Z","normalized_code":"3939A"},{"id":4907071,"change_date":"2023-05-31 21:43:00","inspection_id":"78778583","insp_violation_id":"253194866","seq_no":"3","part_no":"393","part_no_section":"19","insp_viol_unit":"1","insp_unit_id":"195240734","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:51.000000Z","updated_at":"2025-03-17T21:29:51.000000Z","normalized_code":"39319"},{"id":4907072,"change_date":"2023-05-31 21:43:00","inspection_id":"78778583","insp_violation_id":"253194867","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195240734","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:51.000000Z","updated_at":"2025-03-17T21:29:51.000000Z","normalized_code":"3939A"},{"id":4907073,"change_date":"2023-05-31 21:43:00","inspection_id":"78778583","insp_violation_id":"253194868","seq_no":"5","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"195240734","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:51.000000Z","updated_at":"2025-03-17T21:29:51.000000Z","normalized_code":"39347E"},{"id":4907074,"change_date":"2023-05-31 21:43:00","inspection_id":"78778583","insp_violation_id":"253194869","seq_no":"6","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"195240734","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:51.000000Z","updated_at":"2025-03-17T21:29:51.000000Z","normalized_code":"39347E"},{"id":4907075,"change_date":"2023-05-31 21:43:00","inspection_id":"78778583","insp_violation_id":"253194870","seq_no":"7","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"195240734","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:51.000000Z","updated_at":"2025-03-17T21:29:51.000000Z","normalized_code":"39353B"},{"id":4907076,"change_date":"2023-05-31 21:43:00","inspection_id":"78778583","insp_violation_id":"253194871","seq_no":"8","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"195240734","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:29:51.000000Z","updated_at":"2025-03-17T21:29:51.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":5122027,"change_date":"2023-05-31 21:43:00","inspection_id":"78778583","insp_unit_id":"195240734","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"KDG1630","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AA08X3YW017595","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:22.000000Z","updated_at":"2025-03-17T22:43:22.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3887700\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3887700\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3887700\/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\/3887700\/inspections","per_page":100,"prev_page_url":null,"to":17,"total":17}