{"current_page":1,"data":[{"id":12142867,"change_date":"2026-06-09 21:43:00","inspection_id":"88091306","dot_number":"3039958","report_state":"TX","report_number":"V262418121","insp_date":"2026-06-08 00:00:00","insp_start_time":"1002","insp_end_time":"1033","registration_date":null,"region":"CT","ci_status_code":"C","location":"TX302","location_desc":"TX302 MENTONE SCALE","county_code_state":"TX","county_code":"301","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"YARD","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-06-09 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"7","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9986522","transaction_code":"A","transaction_date":"2026-06-09 00:00:00","upload_date":"2026-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03039958","upload_search_indicator":"M","census_search_date":"2026-06-09 21:43:00","snet_input_date":"2026-06-08 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-06-09 21:43:00","insp_carrier_name":"CLEARWELL LLC","insp_carrier_street":"2434 ROBINHOOD STREET UNIT B","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77005","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0972779","created_at":"2026-06-12T09:40:11.000000Z","updated_at":"2026-06-20T09:33:36.000000Z","inspection_violations":[{"id":21134954,"change_date":"2026-06-09 21:43:00","inspection_id":"88091306","insp_violation_id":"274803344","seq_no":"1","part_no":"393","part_no_section":"11TL","insp_viol_unit":"1","insp_unit_id":"214005004","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-12T09:59:59.000000Z","updated_at":"2026-06-19T09:49:16.000000Z","normalized_code":"39311TL"},{"id":21134955,"change_date":"2026-06-09 21:43:00","inspection_id":"88091306","insp_violation_id":"274803345","seq_no":"2","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"214005004","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-12T09:59:59.000000Z","updated_at":"2026-06-19T09:49:16.000000Z","normalized_code":"39347E"},{"id":21134956,"change_date":"2026-06-09 21:43:00","inspection_id":"88091306","insp_violation_id":"274803346","seq_no":"3","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"214005004","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-12T09:59:59.000000Z","updated_at":"2026-06-19T09:49:16.000000Z","normalized_code":"39353B"},{"id":21134957,"change_date":"2026-06-09 21:43:00","inspection_id":"88091306","insp_violation_id":"274803347","seq_no":"4","part_no":"393","part_no_section":"75A3","insp_viol_unit":"1","insp_unit_id":"214005004","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-06-12T09:59:59.000000Z","updated_at":"2026-06-19T09:49:16.000000Z","normalized_code":"39375A3"},{"id":21134958,"change_date":"2026-06-09 21:43:00","inspection_id":"88091306","insp_violation_id":"274803348","seq_no":"5","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"214005004","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-12T09:59:59.000000Z","updated_at":"2026-06-19T09:49:16.000000Z","normalized_code":"3939"},{"id":21134959,"change_date":"2026-06-09 21:43:00","inspection_id":"88091306","insp_violation_id":"274803349","seq_no":"6","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"214005004","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-12T09:59:59.000000Z","updated_at":"2026-06-19T09:49:16.000000Z","normalized_code":"3939"},{"id":21134960,"change_date":"2026-06-09 21:43:00","inspection_id":"88091306","insp_violation_id":"274803350","seq_no":"7","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"214005004","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-12T09:59:59.000000Z","updated_at":"2026-06-19T09:49:16.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":21095761,"change_date":"2026-06-09 21:43:00","inspection_id":"88091306","insp_unit_id":"214005004","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"152A","insp_unit_license":"1L36231","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2HSCEAPR36C205328","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-12T09:16:08.000000Z","updated_at":"2026-06-20T09:05:59.000000Z"},{"id":21095762,"change_date":"2026-06-09 21:43:00","inspection_id":"88091306","insp_unit_id":"214005005","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"152B","insp_unit_license":"205C392","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1P9VN36257K359412","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-12T09:16:08.000000Z","updated_at":"2026-06-20T09:05:59.000000Z"}]},{"id":12022132,"change_date":"2026-05-26 21:41:00","inspection_id":"87961764","dot_number":"3039958","report_state":"TX","report_number":"V262382303","insp_date":"2026-05-21 00:00:00","insp_start_time":"1344","insp_end_time":"1426","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH10 WB MP 497","county_code_state":"TX","county_code":"171","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CLEARWELL","shipping_paper_number":"0591","cargo_tank":"OTH","hazmat_placard_req":"Y","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-26 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"36400","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9968627","transaction_code":"A","transaction_date":"2026-05-26 00:00:00","upload_date":"2026-05-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03039958","upload_search_indicator":"M","census_search_date":"2026-05-26 21:41:00","snet_input_date":"2026-05-21 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-05-26 21:41:00","insp_carrier_name":"CLEARWELL LLC","insp_carrier_street":"2434 ROBINHOOD STREET UNIT B","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77005","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0972779","created_at":"2026-05-29T09:40:04.000000Z","updated_at":"2026-06-06T09:32:24.000000Z","inspection_violations":[{"id":20919385,"change_date":"2026-05-26 21:41:00","inspection_id":"87961764","insp_violation_id":"274513114","seq_no":"1","part_no":"395","part_no_section":"8F01","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-29T09:59:58.000000Z","updated_at":"2026-06-06T09:45:23.000000Z","normalized_code":"3958F01"},{"id":20919386,"change_date":"2026-05-26 21:41:00","inspection_id":"87961764","insp_violation_id":"274513115","seq_no":"2","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"213761512","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-29T09:59:58.000000Z","updated_at":"2026-06-06T09:45:23.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":20897221,"change_date":"2026-05-26 21:41:00","inspection_id":"87961764","insp_unit_id":"213761512","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"22","insp_unit_license":"17U327N","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FT8W3BT2NEF88178","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-29T09:17:48.000000Z","updated_at":"2026-06-06T09:04:51.000000Z"},{"id":20897222,"change_date":"2026-05-26 21:41:00","inspection_id":"87961764","insp_unit_id":"213761513","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"ZP08642","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X6KJ226947","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-29T09:17:48.000000Z","updated_at":"2026-06-06T09:04:51.000000Z"}]},{"id":10532625,"change_date":"2025-12-29 21:38:00","inspection_id":"86668797","dot_number":"3039958","report_state":"TX","report_number":"V252161037","insp_date":"2025-12-24 00:00:00","insp_start_time":"1314","insp_end_time":"1330","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"3608  US87 BUS NB","county_code_state":"TX","county_code":"227","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CLEARWELL","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-12-29 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"64740","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":"9800434","transaction_code":"A","transaction_date":"2025-12-29 00:00:00","upload_date":"2025-12-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03039958","upload_search_indicator":"M","census_search_date":"2025-12-29 21:38:00","snet_input_date":"2025-12-24 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-12-29 21:38:00","insp_carrier_name":"CLEARWELL LLC","insp_carrier_street":"2434 ROBINHOOD STREET UNIT B","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77005","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0972779","created_at":"2026-01-01T10:34:47.000000Z","updated_at":"2026-01-09T10:30:56.000000Z","inspection_violations":[{"id":17688713,"change_date":"2025-12-29 21:38:00","inspection_id":"86668797","insp_violation_id":"270937504","seq_no":"1","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"210836918","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-01T10:38:28.000000Z","updated_at":"2026-01-09T10:31:59.000000Z","normalized_code":"3939"},{"id":17688714,"change_date":"2025-12-29 21:38:00","inspection_id":"86668797","insp_violation_id":"270937505","seq_no":"2","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"210836918","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-01T10:38:28.000000Z","updated_at":"2026-01-09T10:31:59.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":17641359,"change_date":"2025-12-29 21:38:00","inspection_id":"86668797","insp_unit_id":"210836918","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"196","insp_unit_license":"XGK1378","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKDL40X6FJ431196","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-01T10:08:49.000000Z","updated_at":"2026-01-09T10:01:11.000000Z"}]},{"id":9731543,"change_date":"2025-09-19 21:39:00","inspection_id":"85827712","dot_number":"3039958","report_state":"TX","report_number":"78MA9DMBOM","insp_date":"2025-09-08 00:00:00","insp_start_time":"1040","insp_end_time":"1053","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM-1788 IN MIDLAND CO. (316-34","county_code_state":"TX","county_code":"329","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"2784","cargo_tank":"OTH","hazmat_placard_req":"Y","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-19 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","viol_total":"5","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"2","hazmat_viol_total":"3","hazmat_oos_total":"2","snet_sequence_id":"9700699","transaction_code":"A","transaction_date":"2025-09-19 00:00:00","upload_date":"2025-09-19 00:00:00","upload_first_byte":"0","upload_dot_number":"03039958","upload_search_indicator":"M","census_search_date":"2025-09-19 21:39:00","snet_input_date":"2025-09-08 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-09-19 21:39:00","insp_carrier_name":"CLEARWELL LLC","insp_carrier_street":"2434 ROBINHOOD STREET UNIT B","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77005","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0972779","created_at":"2025-09-23T10:02:46.000000Z","updated_at":"2025-09-23T10:02:46.000000Z","inspection_violations":[{"id":15979467,"change_date":"2025-09-19 21:39:00","inspection_id":"85827712","insp_violation_id":"268813187","seq_no":"1","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"209051776","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-22T10:18:36.000000Z","updated_at":"2025-09-23T10:16:52.000000Z","normalized_code":"3922RG"},{"id":15979468,"change_date":"2025-09-19 21:39:00","inspection_id":"85827712","insp_violation_id":"268813188","seq_no":"2","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"209051776","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-22T10:18:36.000000Z","updated_at":"2025-09-23T10:16:52.000000Z","normalized_code":"39360D"},{"id":15979469,"change_date":"2025-09-19 21:39:00","inspection_id":"85827712","insp_violation_id":"268813189","seq_no":"3","part_no":"172","part_no_section":"504A","insp_viol_unit":"1","insp_unit_id":"209051776","insp_violation_category_id":"32","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-09-22T10:18:36.000000Z","updated_at":"2025-09-23T10:16:52.000000Z","normalized_code":"172504A"},{"id":15979470,"change_date":"2025-09-19 21:39:00","inspection_id":"85827712","insp_violation_id":"268813190","seq_no":"4","part_no":"172","part_no_section":"332","insp_viol_unit":"1","insp_unit_id":"209051776","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-22T10:18:36.000000Z","updated_at":"2025-09-23T10:16:52.000000Z","normalized_code":"172332"},{"id":15979471,"change_date":"2025-09-19 21:39:00","inspection_id":"85827712","insp_violation_id":"268813191","seq_no":"5","part_no":"172","part_no_section":"334","insp_viol_unit":"1","insp_unit_id":"209051776","insp_violation_category_id":"39","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-09-22T10:18:36.000000Z","updated_at":"2025-09-23T10:16:52.000000Z","normalized_code":"172334"}],"inspection_per_units":[{"id":16115462,"change_date":"2025-09-19 21:39:00","inspection_id":"85827712","insp_unit_id":"209051776","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"VPG8256","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FT8W3DT8NED88483","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-22T09:47:07.000000Z","updated_at":"2025-09-23T09:46:16.000000Z"}]},{"id":9298701,"change_date":"2025-07-31 21:41:00","inspection_id":"85373109","dot_number":"3039958","report_state":"NM","report_number":"9093P5VGRF","insp_date":"2025-07-30 00:00:00","insp_start_time":"1305","insp_end_time":"1335","registration_date":null,"region":"MT","ci_status_code":"C","location":null,"location_desc":"CLAYTON PORT OF ENTRY","county_code_state":"NM","county_code":"059","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CLEARWELL","shipping_paper_number":"0064","cargo_tank":null,"hazmat_placard_req":"Y","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":"2025-07-31 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"38000","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":"2206442","transaction_code":"A","transaction_date":"2025-07-30 00:00:00","upload_date":"2025-07-31 00:00:00","upload_first_byte":"0","upload_dot_number":"03039958","upload_search_indicator":null,"census_search_date":"2025-07-31 21:41:00","snet_input_date":"2025-07-31 00:00:00","source_office":"2NMS001","mcmis_add_date":"2025-07-31 21:41:00","insp_carrier_name":"CLEARWELL LLC","insp_carrier_street":"4550 POST OAK PLACE SUITE 119","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77027","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-04T10:01:33.000000Z","updated_at":"2025-08-04T10:01:33.000000Z","inspection_violations":[{"id":15081226,"change_date":"2025-07-31 21:41:00","inspection_id":"85373109","insp_violation_id":"267770096","seq_no":"1","part_no":"395","part_no_section":"8F01","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-03T10:45:03.000000Z","updated_at":"2025-08-04T10:45:24.000000Z","normalized_code":"3958F01"}],"inspection_per_units":[{"id":15311649,"change_date":"2025-07-31 21:41:00","inspection_id":"85373109","insp_unit_id":"208179362","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TEXAS PRID","insp_unit_company":"UNIT 1513","insp_unit_license":"907273M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"17XFG2023R1241513","insp_unit_decal":"Y","insp_unit_decal_number":"35443626","created_at":"2025-08-03T09:46:25.000000Z","updated_at":"2025-08-04T09:46:01.000000Z"},{"id":15311650,"change_date":"2025-07-31 21:41:00","inspection_id":"85373109","insp_unit_id":"208179363","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"UNIT 01","insp_unit_license":"TRV2064","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FT8W3DT8NED88483","insp_unit_decal":"Y","insp_unit_decal_number":"35443625","created_at":"2025-08-03T09:46:25.000000Z","updated_at":"2025-08-04T09:46:01.000000Z"}]},{"id":8098719,"change_date":"2025-03-12 21:41:00","inspection_id":"84107639","dot_number":"3039958","report_state":"TX","report_number":"V251788832","insp_date":"2025-03-11 00:00:00","insp_start_time":"0912","insp_end_time":"0924","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"TX214","county_code_state":"TX","county_code":"501","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CLEARWELL","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"Y","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-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"64740","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":"9521443","transaction_code":"A","transaction_date":"2025-03-12 00:00:00","upload_date":"2025-03-12 00:00:00","upload_first_byte":"0","upload_dot_number":"03039958","upload_search_indicator":"M","census_search_date":"2025-03-12 21:41:00","snet_input_date":"2025-03-11 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-03-12 21:41:00","insp_carrier_name":"CLEARWELL LLC","insp_carrier_street":"4550 POST OAK PLACE SUITE 119","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77027","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0972779","created_at":"2025-03-17T21:06:20.000000Z","updated_at":"2025-03-17T21:06:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13075971,"change_date":"2025-03-12 21:41:00","inspection_id":"84107639","insp_unit_id":"205764683","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"12","insp_unit_license":"K184162","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKDL40X1CJ296401","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:34.000000Z","updated_at":"2025-03-17T23:59:34.000000Z"}]},{"id":8111904,"change_date":"2025-03-13 21:44:00","inspection_id":"84121503","dot_number":"3039958","report_state":"TX","report_number":"V251759091","insp_date":"2025-03-11 00:00:00","insp_start_time":"1010","insp_end_time":"1138","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"LAT:29   37' 31.44N","county_code_state":"TX","county_code":"329","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HP RIG 650","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-03-13 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"115000","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":"9522526","transaction_code":"A","transaction_date":"2025-03-13 00:00:00","upload_date":"2025-03-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03039958","upload_search_indicator":"M","census_search_date":"2025-03-13 21:44:00","snet_input_date":"2025-03-11 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-03-13 21:44:00","insp_carrier_name":"CLEARWELL LLC","insp_carrier_street":"4550 POST OAK PLACE SUITE 119","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77027","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0972779","created_at":"2025-03-17T21:06:52.000000Z","updated_at":"2025-03-17T21:06:52.000000Z","inspection_violations":[{"id":12684492,"change_date":"2025-03-13 21:44:00","inspection_id":"84121503","insp_violation_id":"265030499","seq_no":"1","part_no":"393","part_no_section":"11TU","insp_viol_unit":"2","insp_unit_id":"205793025","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:08:08.000000Z","updated_at":"2025-03-17T22:08:08.000000Z","normalized_code":"39311TU"},{"id":12684493,"change_date":"2025-03-13 21:44:00","inspection_id":"84121503","insp_violation_id":"265030500","seq_no":"2","part_no":"392","part_no_section":"2W","insp_viol_unit":"1","insp_unit_id":"205793024","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:08:08.000000Z","updated_at":"2025-03-17T22:08:08.000000Z","normalized_code":"3922W"}],"inspection_per_units":[{"id":13097465,"change_date":"2025-03-13 21:44:00","inspection_id":"84121503","insp_unit_id":"205793024","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"154","insp_unit_license":"TXD4576","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP7D49X79D791626","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:48.000000Z","updated_at":"2025-03-17T23:59:48.000000Z"},{"id":13097466,"change_date":"2025-03-13 21:44:00","inspection_id":"84121503","insp_unit_id":"205793025","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"154A","insp_unit_license":"700415M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3R9R4TM20DM001835","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:48.000000Z","updated_at":"2025-03-17T23:59:48.000000Z"}]},{"id":7775357,"change_date":"2025-02-03 21:40:00","inspection_id":"83768069","dot_number":"3039958","report_state":"TX","report_number":"V251714156","insp_date":"2025-01-29 00:00:00","insp_start_time":"1022","insp_end_time":"1056","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH 349 MM 320","county_code_state":"TX","county_code":"317","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CLEARWELL 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":"Y","pen_cen_match":null,"final_status_date":"2025-02-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"64740","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":"9488432","transaction_code":"A","transaction_date":"2025-02-03 00:00:00","upload_date":"2025-02-03 00:00:00","upload_first_byte":"0","upload_dot_number":"03039958","upload_search_indicator":"M","census_search_date":"2025-02-03 21:40:00","snet_input_date":"2025-01-29 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-02-03 21:40:00","insp_carrier_name":"CLEARWELL LLC","insp_carrier_street":"4550 POST OAK PLACE SUITE 119","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77027","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0972779","created_at":"2025-03-17T20:59:34.000000Z","updated_at":"2025-03-17T20:59:34.000000Z","inspection_violations":[{"id":12150140,"change_date":"2025-02-03 21:40:00","inspection_id":"83768069","insp_violation_id":"264314634","seq_no":"1","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"205136038","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:16.000000Z","updated_at":"2025-03-17T22:05:16.000000Z","normalized_code":"39395A"},{"id":12150141,"change_date":"2025-02-03 21:40:00","inspection_id":"83768069","insp_violation_id":"264314635","seq_no":"2","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"205136038","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:16.000000Z","updated_at":"2025-03-17T22:05:16.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":12548514,"change_date":"2025-02-03 21:40:00","inspection_id":"83768069","insp_unit_id":"205136038","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"11","insp_unit_license":"JJY6960","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKDL40XXFJ426700","insp_unit_decal":"Y","insp_unit_decal_number":"34855941","created_at":"2025-03-17T23:53:35.000000Z","updated_at":"2025-03-17T23:53:35.000000Z"}]},{"id":4604146,"change_date":"2024-12-05 21:38:00","inspection_id":"80360499","dot_number":"3039958","report_state":"TX","report_number":"V231256420","insp_date":"2023-12-06 00:00:00","insp_start_time":"1630","insp_end_time":"1654","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM866","county_code_state":"TX","county_code":"135","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CLEARWELL","shipping_paper_number":"0812","cargo_tank":"OTH","hazmat_placard_req":"Y","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-12-11 21:42: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":"9145409","transaction_code":"C","transaction_date":"2024-12-05 00:00:00","upload_date":"2024-12-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03039958","upload_search_indicator":"M","census_search_date":"2023-12-11 21:42:00","snet_input_date":"2023-12-06 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-12-11 21:42:00","insp_carrier_name":"CLEARWELL LLC","insp_carrier_street":"4550 POST OAK PLACE SUITE 119","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77027","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0972779","created_at":"2025-03-17T19:54:09.000000Z","updated_at":"2025-03-17T19:54:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7405529,"change_date":"2024-12-05 21:38:00","inspection_id":"80360499","insp_unit_id":"204211409","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"16","insp_unit_license":"K184053","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3HAWCTAN3KL261606","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:16.000000Z","updated_at":"2025-03-17T23:02:16.000000Z"}]},{"id":3726071,"change_date":"2023-08-11 21:39:00","inspection_id":"79387525","dot_number":"3039958","report_state":"TX","report_number":"6NHH0XAN63","insp_date":"2023-08-09 00:00:00","insp_start_time":"1653","insp_end_time":"1727","registration_date":null,"region":"CT","ci_status_code":"C","location":"4A106","location_desc":"IH 20 EASTBOUND ODESSA","county_code_state":"TX","county_code":"135","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"NONE","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-08-11 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"10","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"10","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9050352","transaction_code":"A","transaction_date":"2023-08-11 00:00:00","upload_date":"2023-08-11 00:00:00","upload_first_byte":"0","upload_dot_number":"03039958","upload_search_indicator":"M","census_search_date":"2023-08-11 21:39:00","snet_input_date":"2023-08-09 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-08-11 21:39:00","insp_carrier_name":"CLEARWELL LLC","insp_carrier_street":"4550 POST OAK PLACE SUITE 119","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77027","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0972779","created_at":"2025-03-17T19:36:29.000000Z","updated_at":"2025-03-17T19:36:29.000000Z","inspection_violations":[{"id":5746840,"change_date":"2023-08-11 21:39:00","inspection_id":"79387525","insp_violation_id":"254613721","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196494787","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:37.000000Z","updated_at":"2025-03-17T21:33:37.000000Z","normalized_code":"3939A"},{"id":5746841,"change_date":"2023-08-11 21:39:00","inspection_id":"79387525","insp_violation_id":"254613722","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196494787","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:37.000000Z","updated_at":"2025-03-17T21:33:37.000000Z","normalized_code":"3939A"},{"id":5746842,"change_date":"2023-08-11 21:39:00","inspection_id":"79387525","insp_violation_id":"254613723","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"196494787","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:37.000000Z","updated_at":"2025-03-17T21:33:37.000000Z","normalized_code":"3963A1"},{"id":5746843,"change_date":"2023-08-11 21:39:00","inspection_id":"79387525","insp_violation_id":"254613724","seq_no":"4","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"196494788","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:37.000000Z","updated_at":"2025-03-17T21:33:37.000000Z","normalized_code":"39355E"},{"id":5746844,"change_date":"2023-08-11 21:39:00","inspection_id":"79387525","insp_violation_id":"254613725","seq_no":"5","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"196494788","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:33:37.000000Z","updated_at":"2025-03-17T21:33:37.000000Z","normalized_code":"39375A3"},{"id":5746845,"change_date":"2023-08-11 21:39:00","inspection_id":"79387525","insp_violation_id":"254613726","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"196494788","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:37.000000Z","updated_at":"2025-03-17T21:33:37.000000Z","normalized_code":"3939A"},{"id":5746846,"change_date":"2023-08-11 21:39:00","inspection_id":"79387525","insp_violation_id":"254613727","seq_no":"7","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"196494788","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:37.000000Z","updated_at":"2025-03-17T21:33:37.000000Z","normalized_code":"39345B2"},{"id":5746847,"change_date":"2023-08-11 21:39:00","inspection_id":"79387525","insp_violation_id":"254613728","seq_no":"8","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"196494788","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:37.000000Z","updated_at":"2025-03-17T21:33:37.000000Z","normalized_code":"39345B2"},{"id":5746848,"change_date":"2023-08-11 21:39:00","inspection_id":"79387525","insp_violation_id":"254613729","seq_no":"9","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"196494788","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:37.000000Z","updated_at":"2025-03-17T21:33:37.000000Z","normalized_code":"39345B2"},{"id":5746849,"change_date":"2023-08-11 21:39:00","inspection_id":"79387525","insp_violation_id":"254613730","seq_no":"10","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"196494788","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:37.000000Z","updated_at":"2025-03-17T21:33:37.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":5991250,"change_date":"2023-08-11 21:39:00","inspection_id":"79387525","insp_unit_id":"196494787","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"152","insp_unit_license":"1L36231","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2HSCEAPR36C205328","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:21.000000Z","updated_at":"2025-03-17T22:50:21.000000Z"},{"id":5991251,"change_date":"2023-08-11 21:39:00","inspection_id":"79387525","insp_unit_id":"196494788","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":"152B","insp_unit_license":"12R203","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1H2P04523MW050904","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:21.000000Z","updated_at":"2025-03-17T22:50:21.000000Z"}]},{"id":3110404,"change_date":"2023-05-22 21:41:00","inspection_id":"78695117","dot_number":"3039958","report_state":"TX","report_number":"6L7E0XEQ1W","insp_date":"2023-05-19 00:00:00","insp_start_time":"1330","insp_end_time":"1430","registration_date":null,"region":"CT","ci_status_code":"C","location":"4A106","location_desc":"IH 20 EASTBOUND ODESSA","county_code_state":"TX","county_code":"135","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"APACHE","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54800","viol_total":"8","oos_total":"3","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"7","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8984619","transaction_code":"A","transaction_date":"2023-05-22 00:00:00","upload_date":"2023-05-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03039958","upload_search_indicator":"M","census_search_date":"2023-05-22 21:41:00","snet_input_date":"2023-05-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-05-22 21:41:00","insp_carrier_name":"CLEARWELL LLC","insp_carrier_street":"4550 POST OAK PLACE SUITE 119","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77027","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0972779","created_at":"2025-03-17T19:24:35.000000Z","updated_at":"2025-03-17T19:24:35.000000Z","inspection_violations":[{"id":4786664,"change_date":"2023-05-22 21:41:00","inspection_id":"78695117","insp_violation_id":"253000222","seq_no":"1","part_no":"391","part_no_section":"11(b)(5)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:17.000000Z","updated_at":"2025-03-17T21:29:17.000000Z","normalized_code":"39111B5"},{"id":4786665,"change_date":"2023-05-22 21:41:00","inspection_id":"78695117","insp_violation_id":"253000223","seq_no":"2","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"195075150","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:17.000000Z","updated_at":"2025-03-17T21:29:17.000000Z","normalized_code":"39021A"},{"id":4786666,"change_date":"2023-05-22 21:41:00","inspection_id":"78695117","insp_violation_id":"253000224","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195075150","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:29:17.000000Z","updated_at":"2025-03-17T21:29:17.000000Z","normalized_code":"3939A"},{"id":4786667,"change_date":"2023-05-22 21:41:00","inspection_id":"78695117","insp_violation_id":"253000225","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195075150","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:17.000000Z","updated_at":"2025-03-17T21:29:17.000000Z","normalized_code":"3939A"},{"id":4786668,"change_date":"2023-05-22 21:41:00","inspection_id":"78695117","insp_violation_id":"253000226","seq_no":"5","part_no":"393","part_no_section":"19","insp_viol_unit":"1","insp_unit_id":"195075150","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:17.000000Z","updated_at":"2025-03-17T21:29:17.000000Z","normalized_code":"39319"},{"id":4786669,"change_date":"2023-05-22 21:41:00","inspection_id":"78695117","insp_violation_id":"253000227","seq_no":"6","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"195075150","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:17.000000Z","updated_at":"2025-03-17T21:29:17.000000Z","normalized_code":"39345D"},{"id":4786670,"change_date":"2023-05-22 21:41:00","inspection_id":"78695117","insp_violation_id":"253000228","seq_no":"7","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"195075150","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:29:17.000000Z","updated_at":"2025-03-17T21:29:17.000000Z","normalized_code":"3965B"},{"id":4786671,"change_date":"2023-05-22 21:41:00","inspection_id":"78695117","insp_violation_id":"253000229","seq_no":"8","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"195075150","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:17.000000Z","updated_at":"2025-03-17T21:29:17.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":5003252,"change_date":"2023-05-22 21:41:00","inspection_id":"78695117","insp_unit_id":"195075150","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"07","insp_unit_license":"JJY5083","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NPGL09X94D818176","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:26.000000Z","updated_at":"2025-03-17T22:42:26.000000Z"}]},{"id":3088618,"change_date":"2023-06-06 21:44:00","inspection_id":"78670642","dot_number":"3039958","report_state":"TX","report_number":"V231025447","insp_date":"2023-05-16 00:00:00","insp_start_time":"0715","insp_end_time":"0811","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH 349 MM 322 (TOM C","county_code_state":"TX","county_code":"317","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CLEARWELL ENERGY SERVICES","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-05-18 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"102000","viol_total":"9","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"9","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8982138","transaction_code":"C","transaction_date":"2023-06-06 00:00:00","upload_date":"2023-06-06 00:00:00","upload_first_byte":"0","upload_dot_number":"03039958","upload_search_indicator":"M","census_search_date":"2023-05-18 21:44:00","snet_input_date":"2023-05-16 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-05-18 21:44:00","insp_carrier_name":"CLEARWELL LLC","insp_carrier_street":"4550 POST OAK PLACE SUITE 119","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77027","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0972779","created_at":"2025-03-17T19:24:10.000000Z","updated_at":"2025-03-17T19:24:10.000000Z","inspection_violations":[{"id":4749969,"change_date":"2023-06-06 21:44:00","inspection_id":"78670642","insp_violation_id":"253334368","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"195355082","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:08.000000Z","updated_at":"2025-03-17T21:29:08.000000Z","normalized_code":"39347E"},{"id":4749970,"change_date":"2023-06-06 21:44:00","inspection_id":"78670642","insp_violation_id":"253334369","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"195355083","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:08.000000Z","updated_at":"2025-03-17T21:29:08.000000Z","normalized_code":"39347E"},{"id":4749971,"change_date":"2023-06-06 21:44:00","inspection_id":"78670642","insp_violation_id":"253334370","seq_no":"3","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"195355083","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:08.000000Z","updated_at":"2025-03-17T21:29:08.000000Z","normalized_code":"39347E"},{"id":4749972,"change_date":"2023-06-06 21:44:00","inspection_id":"78670642","insp_violation_id":"253334371","seq_no":"4","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"195355082","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:08.000000Z","updated_at":"2025-03-17T21:29:08.000000Z","normalized_code":"39347E"},{"id":4749973,"change_date":"2023-06-06 21:44:00","inspection_id":"78670642","insp_violation_id":"253334372","seq_no":"5","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"195355083","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:08.000000Z","updated_at":"2025-03-17T21:29:08.000000Z","normalized_code":"39353B"},{"id":4749974,"change_date":"2023-06-06 21:44:00","inspection_id":"78670642","insp_violation_id":"253334373","seq_no":"6","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"195355082","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:08.000000Z","updated_at":"2025-03-17T21:29:08.000000Z","normalized_code":"39353B"},{"id":4749975,"change_date":"2023-06-06 21:44:00","inspection_id":"78670642","insp_violation_id":"253334374","seq_no":"7","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"195355082","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:29:08.000000Z","updated_at":"2025-03-17T21:29:08.000000Z","normalized_code":"3963A1"},{"id":4749976,"change_date":"2023-06-06 21:44:00","inspection_id":"78670642","insp_violation_id":"253334375","seq_no":"8","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"195355083","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:08.000000Z","updated_at":"2025-03-17T21:29:08.000000Z","normalized_code":"3922"},{"id":4749977,"change_date":"2023-06-06 21:44:00","inspection_id":"78670642","insp_violation_id":"253334376","seq_no":"9","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"195355083","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:08.000000Z","updated_at":"2025-03-17T21:29:08.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4968552,"change_date":"2023-06-06 21:44:00","inspection_id":"78670642","insp_unit_id":"195355082","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"150","insp_unit_license":"49P111M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2HSCEAPR75C205217","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:10.000000Z","updated_at":"2025-03-17T22:42:10.000000Z"},{"id":4968553,"change_date":"2023-06-06 21:44:00","inspection_id":"78670642","insp_unit_id":"195355083","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LEE","insp_unit_company":"106","insp_unit_license":"115R29","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"56GVT50H7C1000015","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:10.000000Z","updated_at":"2025-03-17T22:42:10.000000Z"}]},{"id":2462021,"change_date":"2023-02-27 21:42:00","inspection_id":"77959638","dot_number":"3039958","report_state":"TX","report_number":"6ISA0XRLYC","insp_date":"2023-02-21 00:00:00","insp_start_time":"1047","insp_end_time":"1100","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0385 IN ECTOR CO. (338-370)","county_code_state":"TX","county_code":"135","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CLEARWELL CHEMICALS","shipping_paper_number":"9459","cargo_tank":"OTH","hazmat_placard_req":"Y","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-27 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"24400","viol_total":"7","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8914458","transaction_code":"A","transaction_date":"2023-02-27 00:00:00","upload_date":"2023-02-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03039958","upload_search_indicator":"M","census_search_date":"2023-02-27 21:42:00","snet_input_date":"2023-02-21 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-02-27 21:42:00","insp_carrier_name":"CLEARWELL LLC","insp_carrier_street":"4550 POST OAK PLACE SUITE 119","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77027","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0972779","created_at":"2025-03-17T19:12:06.000000Z","updated_at":"2025-03-17T19:12:06.000000Z","inspection_violations":[{"id":3791293,"change_date":"2023-02-27 21:42:00","inspection_id":"77959638","insp_violation_id":"251368556","seq_no":"1","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"193607326","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:50.000000Z","updated_at":"2025-03-17T21:24:50.000000Z","normalized_code":"39348A"},{"id":3791294,"change_date":"2023-02-27 21:42:00","inspection_id":"77959638","insp_violation_id":"251368557","seq_no":"2","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"193607326","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:50.000000Z","updated_at":"2025-03-17T21:24:50.000000Z","normalized_code":"39348A"},{"id":3791295,"change_date":"2023-02-27 21:42:00","inspection_id":"77959638","insp_violation_id":"251368558","seq_no":"3","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"193607326","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:50.000000Z","updated_at":"2025-03-17T21:24:50.000000Z","normalized_code":"39348A"},{"id":3791296,"change_date":"2023-02-27 21:42:00","inspection_id":"77959638","insp_violation_id":"251368559","seq_no":"4","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"193607326","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:50.000000Z","updated_at":"2025-03-17T21:24:50.000000Z","normalized_code":"39348A"},{"id":3791297,"change_date":"2023-02-27 21:42:00","inspection_id":"77959638","insp_violation_id":"251368560","seq_no":"5","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"193607326","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:24:50.000000Z","updated_at":"2025-03-17T21:24:50.000000Z","normalized_code":"3963A1"},{"id":3791298,"change_date":"2023-02-27 21:42:00","inspection_id":"77959638","insp_violation_id":"251368561","seq_no":"6","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"193607325","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:50.000000Z","updated_at":"2025-03-17T21:24:50.000000Z","normalized_code":"39617C"},{"id":3791299,"change_date":"2023-02-27 21:42:00","inspection_id":"77959638","insp_violation_id":"251368562","seq_no":"7","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"193607326","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:50.000000Z","updated_at":"2025-03-17T21:24:50.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":3962600,"change_date":"2023-02-27 21:42:00","inspection_id":"77959638","insp_unit_id":"193607325","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"25","insp_unit_license":"RXP4892","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FT8W2BTXNEE36109","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:23.000000Z","updated_at":"2025-03-17T22:34:23.000000Z"},{"id":3962601,"change_date":"2023-02-27 21:42:00","inspection_id":"77959638","insp_unit_id":"193607326","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":null,"insp_unit_company":null,"insp_unit_license":"475156M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"17XFT1323P1114646","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:23.000000Z","updated_at":"2025-03-17T22:34:23.000000Z"}]},{"id":2159317,"change_date":"2023-01-17 21:42:00","inspection_id":"77614836","dot_number":"3039958","report_state":"TX","report_number":"6HLD0XTCZ3","insp_date":"2023-01-09 00:00:00","insp_start_time":"1305","insp_end_time":"1339","registration_date":"2023-01-17 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0176 IN HOWARD CO. (304-316","county_code_state":"TX","county_code":"227","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CLEARWELL ENERGY SERVICES","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-01-17 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"8878056","transaction_code":"A","transaction_date":"2023-01-17 00:00:00","upload_date":"2023-01-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03039958","upload_search_indicator":"M","census_search_date":"2023-01-17 21:42:00","snet_input_date":"2023-01-09 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-01-17 21:42:00","insp_carrier_name":"CLEARWELL LLC","insp_carrier_street":"4550 POST OAK PLACE SUITE 119","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77027","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0972779","created_at":"2025-03-17T19:06:18.000000Z","updated_at":"2025-03-17T19:06:18.000000Z","inspection_violations":[{"id":3337528,"change_date":"2023-01-17 21:42:00","inspection_id":"77614836","insp_violation_id":"250611542","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"192909390","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:46.000000Z","updated_at":"2025-03-17T21:22:46.000000Z","normalized_code":"3939A"},{"id":3337529,"change_date":"2023-01-17 21:42:00","inspection_id":"77614836","insp_violation_id":"250611543","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"192909390","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:46.000000Z","updated_at":"2025-03-17T21:22:46.000000Z","normalized_code":"3939A"},{"id":3337530,"change_date":"2023-01-17 21:42:00","inspection_id":"77614836","insp_violation_id":"250611544","seq_no":"3","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"192909390","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:46.000000Z","updated_at":"2025-03-17T21:22:46.000000Z","normalized_code":"39345D"},{"id":3337531,"change_date":"2023-01-17 21:42:00","inspection_id":"77614836","insp_violation_id":"250611545","seq_no":"4","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"192909390","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:46.000000Z","updated_at":"2025-03-17T21:22:46.000000Z","normalized_code":"39347E"},{"id":3337532,"change_date":"2023-01-17 21:42:00","inspection_id":"77614836","insp_violation_id":"250611546","seq_no":"5","part_no":"393","part_no_section":"13(c)(3)","insp_viol_unit":"2","insp_unit_id":"192909391","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:46.000000Z","updated_at":"2025-03-17T21:22:46.000000Z","normalized_code":"39313C3"}],"inspection_per_units":[{"id":3475189,"change_date":"2023-01-17 21:42:00","inspection_id":"77614836","insp_unit_id":"192909390","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"150","insp_unit_license":"114E94","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2HSCEAPR75C205217","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:56.000000Z","updated_at":"2025-03-17T22:30:56.000000Z"},{"id":3475190,"change_date":"2023-01-17 21:42:00","inspection_id":"77614836","insp_unit_id":"192909391","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LEE","insp_unit_company":"015","insp_unit_license":"115R29","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"56GVT50H7C1000015","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:56.000000Z","updated_at":"2025-03-17T22:30:56.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3039958\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3039958\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3039958\/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\/3039958\/inspections","per_page":100,"prev_page_url":null,"to":14,"total":14}