{"current_page":1,"data":[{"id":12504111,"change_date":"2026-07-20 21:40:00","inspection_id":"88468041","dot_number":"1485979","report_state":"TX","report_number":"V262475403","insp_date":"2026-07-19 00:00:00","insp_start_time":"0830","insp_end_time":"0852","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH 35 SB @ REST AREA","county_code_state":"TX","county_code":"283","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"DROP","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-07-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"135973","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":"10038577","transaction_code":"A","transaction_date":"2026-07-20 00:00:00","upload_date":"2026-07-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01485979","upload_search_indicator":null,"census_search_date":"2026-07-20 21:40:00","snet_input_date":"2026-07-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-07-20 21:40:00","insp_carrier_name":"CLEARWELL WELL SERVICES LLC","insp_carrier_street":"3091 UNIVERSITY DR E #330","insp_carrier_city":"BRYAN","insp_carrier_state":"TX","insp_carrier_zip_code":"77802","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0095005","created_at":"2026-07-23T09:41:25.000000Z","updated_at":"2026-07-31T09:31:36.000000Z","inspection_violations":[{"id":21769615,"change_date":"2026-07-20 21:40:00","inspection_id":"88468041","insp_violation_id":"275629993","seq_no":"2","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"214727079","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-23T10:02:09.000000Z","updated_at":"2026-07-31T09:44:58.000000Z","normalized_code":"3922RG"},{"id":21769614,"change_date":"2026-07-20 21:40:00","inspection_id":"88468041","insp_violation_id":"275629992","seq_no":"1","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"214727078","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-23T10:02:09.000000Z","updated_at":"2026-07-31T09:44:58.000000Z","normalized_code":"39360D"}],"inspection_per_units":[{"id":21716290,"change_date":"2026-07-20 21:40:00","inspection_id":"88468041","insp_unit_id":"214727078","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"191","insp_unit_license":"1M55612","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPXP4EX5GD315398","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-23T09:18:18.000000Z","updated_at":"2026-07-31T09:03:20.000000Z"},{"id":21716291,"change_date":"2026-07-20 21:40:00","inspection_id":"88468041","insp_unit_id":"214727079","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DRAG","insp_unit_company":"197","insp_unit_license":"280B071","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UNSF4532BL063151","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-23T09:18:18.000000Z","updated_at":"2026-07-31T09:03:20.000000Z"}]},{"id":12472058,"change_date":"2026-07-16 21:42:00","inspection_id":"88433269","dot_number":"1485979","report_state":"TX","report_number":"V262414878","insp_date":"2026-07-15 00:00:00","insp_start_time":"1354","insp_end_time":"1425","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"1709 TX85","county_code_state":"TX","county_code":"127","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"LOCATIOIN SITE","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-07-16 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"131000","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":"10034416","transaction_code":"A","transaction_date":"2026-07-16 00:00:00","upload_date":"2026-07-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01485979","upload_search_indicator":"M","census_search_date":"2026-07-16 21:42:00","snet_input_date":"2026-07-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-07-16 21:42:00","insp_carrier_name":"CLEARWELL WELL SERVICES LLC","insp_carrier_street":"1250 NE LOOP 410 #1000","insp_carrier_city":"SAN ANTONIO","insp_carrier_state":"TX","insp_carrier_zip_code":"78209","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0095005","created_at":"2026-07-19T09:41:20.000000Z","updated_at":"2026-07-27T09:31:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21662235,"change_date":"2026-07-16 21:42:00","inspection_id":"88433269","insp_unit_id":"214658281","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"DRAG","insp_unit_company":"145","insp_unit_license":"64P512","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1215","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-19T09:20:48.000000Z","updated_at":"2026-07-27T09:03:28.000000Z"}]},{"id":11880406,"change_date":"2026-05-11 21:39:00","inspection_id":"87817950","dot_number":"1485979","report_state":"TX","report_number":"V262354625","insp_date":"2026-05-08 00:00:00","insp_start_time":"0830","insp_end_time":"0913","registration_date":null,"region":"CT","ci_status_code":"C","location":"6A303","location_desc":"US59 SB EL TORO SCALE","county_code_state":"TX","county_code":"239","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-05-11 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"162000","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":"9949388","transaction_code":"A","transaction_date":"2026-05-11 00:00:00","upload_date":"2026-05-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01485979","upload_search_indicator":"M","census_search_date":"2026-05-11 21:39:00","snet_input_date":"2026-05-08 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-05-11 21:39:00","insp_carrier_name":"CLEARWELL WELL SERVICES LLC","insp_carrier_street":"1250 NE LOOP 410 #1000","insp_carrier_city":"SAN ANTONIO","insp_carrier_state":"TX","insp_carrier_zip_code":"78209","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0095005","created_at":"2026-05-13T13:15:35.000000Z","updated_at":"2026-05-22T09:31:39.000000Z","inspection_violations":[{"id":20662748,"change_date":"2026-05-11 21:39:00","inspection_id":"87817950","insp_violation_id":"274184088","seq_no":"1","part_no":"396","part_no_section":"17C","insp_viol_unit":"2","insp_unit_id":"213493235","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-13T13:33:20.000000Z","updated_at":"2026-05-22T09:43:50.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":20656908,"change_date":"2026-05-11 21:39:00","inspection_id":"87817950","insp_unit_id":"213493234","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"215","insp_unit_license":"1M39074","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPWD49X8AD795443","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-13T13:05:28.000000Z","updated_at":"2026-05-22T09:04:38.000000Z"},{"id":20656909,"change_date":"2026-05-11 21:39:00","inspection_id":"87817950","insp_unit_id":"213493235","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DOON","insp_unit_company":"212A","insp_unit_license":"244C183","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1D9BG5335D1609105","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-13T13:05:28.000000Z","updated_at":"2026-05-22T09:04:38.000000Z"}]},{"id":11219170,"change_date":"2026-02-26 21:41:00","inspection_id":"87130857","dot_number":"1485979","report_state":"TX","report_number":"V262236516","insp_date":"2026-02-20 00:00:00","insp_start_time":"0925","insp_end_time":"0947","registration_date":null,"region":"CT","ci_status_code":"C","location":"6A102","location_desc":"IH10 WB KINGSBURY SCALE","county_code_state":"TX","county_code":"187","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"YARD","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-02-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"203400","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":"9861248","transaction_code":"C","transaction_date":"2026-02-26 00:00:00","upload_date":"2026-02-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01485979","upload_search_indicator":"M","census_search_date":"2026-02-24 21:40:00","snet_input_date":"2026-02-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-02-24 21:40:00","insp_carrier_name":"CLEARWELL WELL SERVICES LLC","insp_carrier_street":"1250 NE LOOP 410 #1000","insp_carrier_city":"SAN ANTONIO","insp_carrier_state":"TX","insp_carrier_zip_code":"78209","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0095005","created_at":"2026-02-27T10:38:08.000000Z","updated_at":"2026-03-09T09:31:34.000000Z","inspection_violations":[{"id":18866000,"change_date":"2026-02-26 21:41:00","inspection_id":"87130857","insp_violation_id":"272068787","seq_no":"1","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"211861831","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-01T10:56:39.000000Z","updated_at":"2026-03-09T09:44:20.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":19206621,"change_date":"2026-02-26 21:41:00","inspection_id":"87130857","insp_unit_id":"211861831","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"191","insp_unit_license":"1M55612","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPXP4EX5GD315398","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-01T10:15:42.000000Z","updated_at":"2026-03-09T09:07:42.000000Z"},{"id":19206622,"change_date":"2026-02-26 21:41:00","inspection_id":"87130857","insp_unit_id":"211861832","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DESP","insp_unit_company":"197","insp_unit_license":"117B306","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UNSF4532BL063151","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-01T10:15:42.000000Z","updated_at":"2026-03-09T09:07:42.000000Z"}]},{"id":10508471,"change_date":"2025-12-23 21:39:00","inspection_id":"86643583","dot_number":"1485979","report_state":"TX","report_number":"7BAB9DIOPJ","insp_date":"2025-12-13 00:00:00","insp_start_time":"1158","insp_end_time":"1219","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0035 IN HILL CO. (357-370)","county_code_state":"TX","county_code":"217","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-12-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"39900","viol_total":"3","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9795006","transaction_code":"A","transaction_date":"2025-12-23 00:00:00","upload_date":"2025-12-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01485979","upload_search_indicator":"M","census_search_date":"2025-12-23 21:39:00","snet_input_date":"2025-12-13 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-12-23 21:39:00","insp_carrier_name":"CLEARWELL WELL SERVICES LLC","insp_carrier_street":"1250 NE LOOP 410 #1000","insp_carrier_city":"SAN ANTONIO","insp_carrier_state":"TX","insp_carrier_zip_code":"78209","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0095005","created_at":"2025-12-26T10:38:39.000000Z","updated_at":"2026-01-03T10:30:50.000000Z","inspection_violations":[{"id":17641170,"change_date":"2025-12-23 21:39:00","inspection_id":"86643583","insp_violation_id":"270876247","seq_no":"1","part_no":"393","part_no_section":"43D","insp_viol_unit":"1","insp_unit_id":"210784146","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-12-26T10:44:34.000000Z","updated_at":"2026-01-03T10:31:32.000000Z","normalized_code":"39343D"},{"id":17641171,"change_date":"2025-12-23 21:39:00","inspection_id":"86643583","insp_violation_id":"270876248","seq_no":"2","part_no":"393","part_no_section":"48A","insp_viol_unit":"2","insp_unit_id":"210784147","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-26T10:44:34.000000Z","updated_at":"2026-01-03T10:31:32.000000Z","normalized_code":"39348A"},{"id":17641172,"change_date":"2025-12-23 21:39:00","inspection_id":"86643583","insp_violation_id":"270876249","seq_no":"3","part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"2","insp_unit_id":"210784147","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2025-12-26T10:44:34.000000Z","updated_at":"2026-01-03T10:31:32.000000Z","normalized_code":"3963A1BOS"}],"inspection_per_units":[{"id":17598155,"change_date":"2025-12-23 21:39:00","inspection_id":"86643583","insp_unit_id":"210784146","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"R02-001056","insp_unit_license":"TYD3076","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FD0W5HT7REC69375","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-26T10:09:33.000000Z","updated_at":"2026-01-03T10:00:58.000000Z"},{"id":17598156,"change_date":"2025-12-23 21:39:00","inspection_id":"86643583","insp_unit_id":"210784147","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"PJTM","insp_unit_company":"R06-000193","insp_unit_license":"657392M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4P53F4926R1405641","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-26T10:09:33.000000Z","updated_at":"2026-01-03T10:00:58.000000Z"}]},{"id":9336655,"change_date":"2025-08-05 21:39:00","inspection_id":"85412815","dot_number":"1485979","report_state":"TX","report_number":"V251969515","insp_date":"2025-07-30 00:00:00","insp_start_time":"1014","insp_end_time":"1045","registration_date":null,"region":"CT","ci_status_code":"C","location":"6A201","location_desc":"IH35 SB DEVINE SCALE","county_code_state":"TX","county_code":"325","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"TERMINAL","shipping_paper_number":"EMPTY","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-08-05 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"210000","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":"9657134","transaction_code":"A","transaction_date":"2025-08-05 00:00:00","upload_date":"2025-08-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01485979","upload_search_indicator":"M","census_search_date":"2025-08-05 21:39:00","snet_input_date":"2025-07-30 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-08-05 21:39:00","insp_carrier_name":"CLEARWELL WELL SERVICES LLC","insp_carrier_street":"3091 UNIVERSITY DR E #330","insp_carrier_city":"BRYAN","insp_carrier_state":"TX","insp_carrier_zip_code":"77802","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0095005","created_at":"2025-08-08T10:01:24.000000Z","updated_at":"2025-08-12T10:42:04.000000Z","inspection_violations":[{"id":15154954,"change_date":"2025-08-05 21:39:00","inspection_id":"85412815","insp_violation_id":"267854624","seq_no":"1","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"208251678","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-08T10:44:59.000000Z","updated_at":"2025-08-09T10:44:51.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":15378000,"change_date":"2025-08-05 21:39:00","inspection_id":"85412815","insp_unit_id":"208251678","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"6751","insp_unit_license":"1L10841","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKDX4TX9DJ356751","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-08T09:46:36.000000Z","updated_at":"2025-08-09T09:46:06.000000Z"},{"id":15378001,"change_date":"2025-08-05 21:39:00","inspection_id":"85412815","insp_unit_id":"208251679","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"PITT","insp_unit_company":"214A","insp_unit_license":"Y92397","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5JYLB6046DP130795","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-08T09:46:36.000000Z","updated_at":"2025-08-09T09:46:06.000000Z"}]},{"id":9166972,"change_date":"2025-07-16 21:41:00","inspection_id":"85234381","dot_number":"1485979","report_state":"TX","report_number":"V251828850","insp_date":"2025-07-13 00:00:00","insp_start_time":"0850","insp_end_time":"0909","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH 35 MM 59 NORTH","county_code_state":"TX","county_code":"283","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CLEAR WELL DYNAMICS","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-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"188001","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":"9640010","transaction_code":"A","transaction_date":"2025-07-16 00:00:00","upload_date":"2025-07-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01485979","upload_search_indicator":"M","census_search_date":"2025-07-16 21:41:00","snet_input_date":"2025-07-13 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-07-16 21:41:00","insp_carrier_name":"CLEARWELL WELL SERVICES LLC","insp_carrier_street":"3091 UNIVERSITY DR E #330","insp_carrier_city":"BRYAN","insp_carrier_state":"TX","insp_carrier_zip_code":"77802","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0095005","created_at":"2025-07-19T10:42:43.000000Z","updated_at":"2025-07-21T10:42:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15059546,"change_date":"2025-07-16 21:41:00","inspection_id":"85234381","insp_unit_id":"207907763","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"219","insp_unit_license":"1M84946","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDP4TX2LR375888","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-19T09:46:20.000000Z","updated_at":"2025-07-20T09:46:05.000000Z"},{"id":15059547,"change_date":"2025-07-16 21:41:00","inspection_id":"85234381","insp_unit_id":"207907764","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLN","insp_unit_company":"207A","insp_unit_license":"743484M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1T9DL5338VT447650","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-19T09:46:20.000000Z","updated_at":"2025-07-20T09:46:05.000000Z"}]},{"id":8550616,"change_date":"2025-05-05 21:40:00","inspection_id":"84583736","dot_number":"1485979","report_state":"TX","report_number":"V251850533","insp_date":"2025-05-01 00:00:00","insp_start_time":"1130","insp_end_time":"1154","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"TX6 AT OLD BRYAN HWY","county_code_state":"TX","county_code":"395","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"XX","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-05-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"60600","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":"9568733","transaction_code":"A","transaction_date":"2025-05-05 00:00:00","upload_date":"2025-05-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01485979","upload_search_indicator":"M","census_search_date":"2025-05-05 21:40:00","snet_input_date":"2025-05-01 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-05-05 21:40:00","insp_carrier_name":"CLEARWELL WELL SERVICES LLC","insp_carrier_street":"3091 UNIVERSITY DR E #330","insp_carrier_city":"BRYAN","insp_carrier_state":"TX","insp_carrier_zip_code":"77802","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0095005","created_at":"2025-05-08T10:03:47.000000Z","updated_at":"2025-05-09T10:23:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13905876,"change_date":"2025-05-05 21:40:00","inspection_id":"84583736","insp_unit_id":"206649386","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"R03-00184","insp_unit_license":"1N31833","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NPTL40X7DD198446","insp_unit_decal":"Y","insp_unit_decal_number":"35107619","created_at":"2025-05-08T09:58:07.000000Z","updated_at":"2025-05-09T10:05:12.000000Z"}]},{"id":7896736,"change_date":"2025-02-18 21:40:00","inspection_id":"83895496","dot_number":"1485979","report_state":"TX","report_number":"V251761507","insp_date":"2025-02-12 00:00:00","insp_start_time":"1105","insp_end_time":"1137","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"TX44","county_code_state":"TX","county_code":"479","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CLEARWELL DYNAMICS","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-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"35900","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":"9500248","transaction_code":"A","transaction_date":"2025-02-18 00:00:00","upload_date":"2025-02-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01485979","upload_search_indicator":"M","census_search_date":"2025-02-18 21:40:00","snet_input_date":"2025-02-12 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-02-18 21:40:00","insp_carrier_name":"CLEARWELL WELL SERVICES LLC","insp_carrier_street":"3091 UNIVERSITY DR E #330","insp_carrier_city":"BRYAN","insp_carrier_state":"TX","insp_carrier_zip_code":"77802","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0095005","created_at":"2025-03-17T21:02:01.000000Z","updated_at":"2025-03-17T21:02:01.000000Z","inspection_violations":[{"id":12339155,"change_date":"2025-02-18 21:40:00","inspection_id":"83895496","insp_violation_id":"264569714","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"205376188","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:13.000000Z","updated_at":"2025-03-17T22:06:13.000000Z","normalized_code":"39378"}],"inspection_per_units":[{"id":12746570,"change_date":"2025-02-18 21:40:00","inspection_id":"83895496","insp_unit_id":"205376188","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"116","insp_unit_license":"MZL4906","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1GC1KVC89CF148128","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:50.000000Z","updated_at":"2025-03-17T23:55:50.000000Z"},{"id":12746571,"change_date":"2025-02-18 21:40:00","inspection_id":"83895496","insp_unit_id":"205376189","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"PJTM","insp_unit_company":"194","insp_unit_license":"459324M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4P53F4920R1408440","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:50.000000Z","updated_at":"2025-03-17T23:55:50.000000Z"}]},{"id":7567441,"change_date":"2025-01-07 21:40:00","inspection_id":"83549621","dot_number":"1485979","report_state":"TX","report_number":"V251735524","insp_date":"2025-01-01 00:00:00","insp_start_time":"1247","insp_end_time":"1307","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH10 MP 378","county_code_state":"TX","county_code":"105","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CLEARWELL DYMAMICS","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-01-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"169000","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":"9468069","transaction_code":"A","transaction_date":"2025-01-07 00:00:00","upload_date":"2025-01-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01485979","upload_search_indicator":"M","census_search_date":"2025-01-07 21:40:00","snet_input_date":"2025-01-01 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-01-07 21:40:00","insp_carrier_name":"CLEARWELL WELL SERVICES LLC","insp_carrier_street":"3091 UNIVERSITY DR E #330","insp_carrier_city":"BRYAN","insp_carrier_state":"TX","insp_carrier_zip_code":"77802","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0095005","created_at":"2025-03-17T20:55:16.000000Z","updated_at":"2025-03-17T20:55:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12209984,"change_date":"2025-01-07 21:40:00","inspection_id":"83549621","insp_unit_id":"204693263","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"218","insp_unit_license":"1M84945","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDP4TX3FJ437141","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:46.000000Z","updated_at":"2025-03-17T23:49:46.000000Z"},{"id":12209985,"change_date":"2025-01-07 21:40:00","inspection_id":"83549621","insp_unit_id":"204693264","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"2030","insp_unit_license":"203C980","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1TTE4820871082459","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:46.000000Z","updated_at":"2025-03-17T23:49:46.000000Z"}]},{"id":7630756,"change_date":"2025-01-15 21:42:00","inspection_id":"83616054","dot_number":"1485979","report_state":"TX","report_number":"V251735525","insp_date":"2025-01-01 00:00:00","insp_start_time":"1357","insp_end_time":"1414","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH163 MP 524","county_code_state":"TX","county_code":"105","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"STEP ENERGY","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-15 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"134320","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":"9474418","transaction_code":"A","transaction_date":"2025-01-15 00:00:00","upload_date":"2025-01-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01485979","upload_search_indicator":"M","census_search_date":"2025-01-15 21:42:00","snet_input_date":"2025-01-01 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-01-15 21:42:00","insp_carrier_name":"CLEARWELL WELL SERVICES LLC","insp_carrier_street":"3091 UNIVERSITY DR E #330","insp_carrier_city":"BRYAN","insp_carrier_state":"TX","insp_carrier_zip_code":"77802","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0095005","created_at":"2025-03-17T20:56:32.000000Z","updated_at":"2025-03-17T20:56:32.000000Z","inspection_violations":[{"id":11925790,"change_date":"2025-01-15 21:42:00","inspection_id":"83616054","insp_violation_id":"264022861","seq_no":"1","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"204856646","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:07.000000Z","updated_at":"2025-03-17T22:04:07.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":12312799,"change_date":"2025-01-15 21:42:00","inspection_id":"83616054","insp_unit_id":"204856645","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"22FIT19A","insp_unit_license":"R656726","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5KJJALD62GPHS0036","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:53.000000Z","updated_at":"2025-03-17T23:50:53.000000Z"},{"id":12312800,"change_date":"2025-01-15 21:42:00","inspection_id":"83616054","insp_unit_id":"204856646","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONA","insp_unit_company":"32UF20","insp_unit_license":"231B452","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"13N248203K1530707","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:53.000000Z","updated_at":"2025-03-17T23:50:53.000000Z"}]},{"id":7566965,"change_date":"2025-01-07 21:40:00","inspection_id":"83549125","dot_number":"1485979","report_state":"TX","report_number":"V241739107","insp_date":"2024-12-31 00:00:00","insp_start_time":"1359","insp_end_time":"1414","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US190","county_code_state":"TX","county_code":"105","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CLEARWELL DYNAMICS","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-01-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"45400","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":"9467905","transaction_code":"A","transaction_date":"2025-01-07 00:00:00","upload_date":"2025-01-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01485979","upload_search_indicator":"M","census_search_date":"2025-01-07 21:40:00","snet_input_date":"2024-12-31 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-01-07 21:40:00","insp_carrier_name":"CLEARWELL WELL SERVICES LLC","insp_carrier_street":"3091 UNIVERSITY DR E #330","insp_carrier_city":"BRYAN","insp_carrier_state":"TX","insp_carrier_zip_code":"77802","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0095005","created_at":"2025-03-17T20:55:16.000000Z","updated_at":"2025-03-17T20:55:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12209160,"change_date":"2025-01-07 21:40:00","inspection_id":"83549125","insp_unit_id":"204691301","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"R02001056","insp_unit_license":"TYD3076","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FD0W5HT7REC69375","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:46.000000Z","updated_at":"2025-03-17T23:49:46.000000Z"},{"id":12209161,"change_date":"2025-01-07 21:40:00","inspection_id":"83549125","insp_unit_id":"204691302","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"R06000193","insp_unit_license":"657392M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4P53F4926R1405641","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:46.000000Z","updated_at":"2025-03-17T23:49:46.000000Z"}]},{"id":7393596,"change_date":"2024-12-12 21:42:00","inspection_id":"83367009","dot_number":"1485979","report_state":"TX","report_number":"V241614998","insp_date":"2024-12-05 00:00:00","insp_start_time":"1000","insp_end_time":"1036","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-10 MP-402","county_code_state":"TX","county_code":"435","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CLEARWELL WELL SERVICES 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":"2024-12-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"168000","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9446784","transaction_code":"C","transaction_date":"2024-12-12 00:00:00","upload_date":"2024-12-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01485979","upload_search_indicator":"M","census_search_date":"2024-12-11 21:41:00","snet_input_date":"2024-12-05 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-12-11 21:41:00","insp_carrier_name":"CLEARWELL WELL SERVICES LLC","insp_carrier_street":"3091 UNIVERSITY DR E #330","insp_carrier_city":"BRYAN","insp_carrier_state":"TX","insp_carrier_zip_code":"77802","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0095005","created_at":"2025-03-17T20:50:19.000000Z","updated_at":"2025-03-17T20:50:19.000000Z","inspection_violations":[{"id":11551674,"change_date":"2024-12-12 21:42:00","inspection_id":"83367009","insp_violation_id":"263426830","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"204352715","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:13.000000Z","updated_at":"2025-03-17T22:02:13.000000Z","normalized_code":"39311"},{"id":11551675,"change_date":"2024-12-12 21:42:00","inspection_id":"83367009","insp_violation_id":"263426831","seq_no":"2","part_no":"393","part_no_section":"11TL","insp_viol_unit":"1","insp_unit_id":"204352714","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:13.000000Z","updated_at":"2025-03-17T22:02:13.000000Z","normalized_code":"39311TL"},{"id":11551676,"change_date":"2024-12-12 21:42:00","inspection_id":"83367009","insp_violation_id":"263426832","seq_no":"3","part_no":"393","part_no_section":"9TS","insp_viol_unit":"2","insp_unit_id":"204352715","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:02:13.000000Z","updated_at":"2025-03-17T22:02:13.000000Z","normalized_code":"3939TS"}],"inspection_per_units":[{"id":11927082,"change_date":"2024-12-12 21:42:00","inspection_id":"83367009","insp_unit_id":"204352714","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"218","insp_unit_license":"1M84945","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDP4TX3FJ437141","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:41.000000Z","updated_at":"2025-03-17T23:46:41.000000Z"},{"id":11927083,"change_date":"2024-12-12 21:42:00","inspection_id":"83367009","insp_unit_id":"204352715","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"2030","insp_unit_license":"203C980","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1TTE4820871082459","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:41.000000Z","updated_at":"2025-03-17T23:46:41.000000Z"}]},{"id":7394122,"change_date":"2024-12-19 21:41:00","inspection_id":"83367558","dot_number":"1485979","report_state":"TX","report_number":"V241640334","insp_date":"2024-12-05 00:00:00","insp_start_time":"1515","insp_end_time":"1545","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH10 EB","county_code_state":"TX","county_code":"105","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CLEARWELL WELL SERVICES 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":"2024-12-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"9448127","transaction_code":"C","transaction_date":"2024-12-19 00:00:00","upload_date":"2024-12-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01485979","upload_search_indicator":"M","census_search_date":"2024-12-11 21:41:00","snet_input_date":"2024-12-05 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-12-11 21:41:00","insp_carrier_name":"CLEARWELL WELL SERVICES LLC","insp_carrier_street":"3091 UNIVERSITY DR E #330","insp_carrier_city":"BRYAN","insp_carrier_state":"TX","insp_carrier_zip_code":"77802","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0095005","created_at":"2025-03-17T20:50:20.000000Z","updated_at":"2025-03-17T20:50:20.000000Z","inspection_violations":[{"id":11552984,"change_date":"2024-12-19 21:41:00","inspection_id":"83367558","insp_violation_id":"263580414","seq_no":"1","part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"1","insp_unit_id":"204484808","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:13.000000Z","updated_at":"2025-03-17T22:02:13.000000Z","normalized_code":"39345B2UV"},{"id":11552985,"change_date":"2024-12-19 21:41:00","inspection_id":"83367558","insp_violation_id":"263580415","seq_no":"2","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"204484808","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:13.000000Z","updated_at":"2025-03-17T22:02:13.000000Z","normalized_code":"39395F"}],"inspection_per_units":[{"id":11928009,"change_date":"2024-12-19 21:41:00","inspection_id":"83367558","insp_unit_id":"204484808","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"210","insp_unit_license":"1L51749","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AD64Y96M001673","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:41.000000Z","updated_at":"2025-03-17T23:46:41.000000Z"},{"id":11928010,"change_date":"2024-12-19 21:41:00","inspection_id":"83367558","insp_unit_id":"204484809","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"AZTC","insp_unit_company":"219A","insp_unit_license":"120C331","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1AZBG1A20B1011706","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:41.000000Z","updated_at":"2025-03-17T23:46:41.000000Z"}]},{"id":7394395,"change_date":"2024-12-13 21:41:00","inspection_id":"83367842","dot_number":"1485979","report_state":"TX","report_number":"V241689420","insp_date":"2024-12-05 00:00:00","insp_start_time":"0957","insp_end_time":"1101","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH 10 MP 403","county_code_state":"TX","county_code":"435","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":"2024-12-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"125600","viol_total":"5","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9446787","transaction_code":"C","transaction_date":"2024-12-13 00:00:00","upload_date":"2024-12-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01485979","upload_search_indicator":"M","census_search_date":"2024-12-11 21:41:00","snet_input_date":"2024-12-05 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-12-11 21:41:00","insp_carrier_name":"CLEARWELL WELL SERVICES LLC","insp_carrier_street":"3091 UNIVERSITY DR E #330","insp_carrier_city":"BRYAN","insp_carrier_state":"TX","insp_carrier_zip_code":"77802","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0095005","created_at":"2025-03-17T20:50:20.000000Z","updated_at":"2025-03-17T20:50:20.000000Z","inspection_violations":[{"id":11553628,"change_date":"2024-12-13 21:41:00","inspection_id":"83367842","insp_violation_id":"263457697","seq_no":"1","part_no":"393","part_no_section":"104B","insp_viol_unit":"2","insp_unit_id":"204378250","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:13.000000Z","updated_at":"2025-03-17T22:02:13.000000Z","normalized_code":"393104B"},{"id":11553629,"change_date":"2024-12-13 21:41:00","inspection_id":"83367842","insp_violation_id":"263457698","seq_no":"2","part_no":"393","part_no_section":"104F4\/R","insp_viol_unit":"2","insp_unit_id":"204378250","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:13.000000Z","updated_at":"2025-03-17T22:02:13.000000Z","normalized_code":"393104F4\/R"},{"id":11553630,"change_date":"2024-12-13 21:41:00","inspection_id":"83367842","insp_violation_id":"263457699","seq_no":"3","part_no":"393","part_no_section":"11TU","insp_viol_unit":"1","insp_unit_id":"204378249","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:13.000000Z","updated_at":"2025-03-17T22:02:13.000000Z","normalized_code":"39311TU"},{"id":11553631,"change_date":"2024-12-13 21:41:00","inspection_id":"83367842","insp_violation_id":"263457700","seq_no":"4","part_no":"393","part_no_section":"75A4","insp_viol_unit":"2","insp_unit_id":"204378250","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:13.000000Z","updated_at":"2025-03-17T22:02:13.000000Z","normalized_code":"39375A4"},{"id":11553632,"change_date":"2024-12-13 21:41:00","inspection_id":"83367842","insp_violation_id":"263457701","seq_no":"5","part_no":"396","part_no_section":"5B-HLOW","insp_viol_unit":"2","insp_unit_id":"204378250","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:02:13.000000Z","updated_at":"2025-03-17T22:02:13.000000Z","normalized_code":"3965BHLOW"}],"inspection_per_units":[{"id":11928496,"change_date":"2024-12-13 21:41:00","inspection_id":"83367842","insp_unit_id":"204378249","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"184","insp_unit_license":"1N31833","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NPTL40X7DD198446","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:41.000000Z","updated_at":"2025-03-17T23:46:41.000000Z"},{"id":11928497,"change_date":"2024-12-13 21:41:00","inspection_id":"83367842","insp_unit_id":"204378250","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"191","insp_unit_license":"202C175","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M9LR534311435134","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:41.000000Z","updated_at":"2025-03-17T23:46:41.000000Z"}]},{"id":7027142,"change_date":"2024-10-24 21:42:00","inspection_id":"82979721","dot_number":"1485979","report_state":"TX","report_number":"V241549445","insp_date":"2024-10-21 00:00:00","insp_start_time":"1155","insp_end_time":"1216","registration_date":null,"region":"CT","ci_status_code":"C","location":"6A304","location_desc":"US59 SB FANNIN SCALE","county_code_state":"TX","county_code":"175","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CLEAR WELL","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-10-23 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"0","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9410363","transaction_code":"C","transaction_date":"2024-10-24 00:00:00","upload_date":"2024-10-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01485979","upload_search_indicator":"M","census_search_date":"2024-10-23 21:42:00","snet_input_date":"2024-10-21 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-10-23 21:42:00","insp_carrier_name":"CLEARWELL WELL SERVICES LLC","insp_carrier_street":"3091 UNIVERSITY DR E #330","insp_carrier_city":"BRYAN","insp_carrier_state":"TX","insp_carrier_zip_code":"77802","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0095005","created_at":"2025-03-17T20:42:38.000000Z","updated_at":"2025-03-17T20:42:38.000000Z","inspection_violations":[{"id":10968292,"change_date":"2024-10-24 21:42:00","inspection_id":"82979721","insp_violation_id":"262545485","seq_no":"1","part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"1","insp_unit_id":"203576506","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:11.000000Z","updated_at":"2025-03-17T21:59:11.000000Z","normalized_code":"39345B2UV"},{"id":10968293,"change_date":"2024-10-24 21:42:00","inspection_id":"82979721","insp_violation_id":"262545486","seq_no":"2","part_no":"393","part_no_section":"45DLPC","insp_viol_unit":"1","insp_unit_id":"203576506","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:11.000000Z","updated_at":"2025-03-17T21:59:11.000000Z","normalized_code":"39345DLPC"},{"id":10968294,"change_date":"2024-10-24 21:42:00","inspection_id":"82979721","insp_violation_id":"262545487","seq_no":"3","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"203576506","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:11.000000Z","updated_at":"2025-03-17T21:59:11.000000Z","normalized_code":"39360C"},{"id":10968295,"change_date":"2024-10-24 21:42:00","inspection_id":"82979721","insp_violation_id":"262545488","seq_no":"4","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"203576507","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:11.000000Z","updated_at":"2025-03-17T21:59:11.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":11333402,"change_date":"2024-10-24 21:42:00","inspection_id":"82979721","insp_unit_id":"203576506","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"207","insp_unit_license":"1L10510","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AX04C08M003291","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:21.000000Z","updated_at":"2025-03-17T23:40:21.000000Z"},{"id":11333403,"change_date":"2024-10-24 21:42:00","inspection_id":"82979721","insp_unit_id":"203576507","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DOON","insp_unit_company":"212A","insp_unit_license":"244C183","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1D9BG5335D1609105","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:21.000000Z","updated_at":"2025-03-17T23:40:21.000000Z"}]},{"id":5976518,"change_date":"2024-06-12 21:42:00","inspection_id":"81857021","dot_number":"1485979","report_state":"TX","report_number":"V241446218","insp_date":"2024-06-10 00:00:00","insp_start_time":"1034","insp_end_time":"1103","registration_date":null,"region":"CT","ci_status_code":"C","location":"6A305","location_desc":"US59 NB FANNIN SCALE","county_code_state":"TX","county_code":"175","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CLEAR WATER DYNAMICS","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-06-12 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"0","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":"9299242","transaction_code":"A","transaction_date":"2024-06-12 00:00:00","upload_date":"2024-06-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01485979","upload_search_indicator":"M","census_search_date":"2024-06-12 21:42:00","snet_input_date":"2024-06-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-06-12 21:42:00","insp_carrier_name":"CLEARWELL WELL SERVICES LLC","insp_carrier_street":"3091 UNIVERSITY DR E #330","insp_carrier_city":"BRYAN","insp_carrier_state":"TX","insp_carrier_zip_code":"77802","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0095005","created_at":"2025-03-17T20:21:07.000000Z","updated_at":"2025-03-17T20:21:07.000000Z","inspection_violations":[{"id":9271683,"change_date":"2024-06-12 21:42:00","inspection_id":"81857021","insp_violation_id":"260053208","seq_no":"1","part_no":"393","part_no_section":"87(a)","insp_viol_unit":"2","insp_unit_id":"201364941","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:51.000000Z","updated_at":"2025-03-17T21:50:51.000000Z","normalized_code":"39387A"}],"inspection_per_units":[{"id":9626585,"change_date":"2024-06-12 21:42:00","inspection_id":"81857021","insp_unit_id":"201364940","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"HS3","insp_unit_license":"STX6570","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FD0X5GT8HEB37903","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:47.000000Z","updated_at":"2025-03-17T23:22:47.000000Z"},{"id":9626586,"change_date":"2024-06-12 21:42:00","inspection_id":"81857021","insp_unit_id":"201364941","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"PJTM","insp_unit_company":"R0600194","insp_unit_license":"459324M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4P53F4920R1408440","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:47.000000Z","updated_at":"2025-03-17T23:22:47.000000Z"}]},{"id":5242325,"change_date":"2024-03-08 21:39:00","inspection_id":"81057754","dot_number":"1485979","report_state":"ND","report_number":"HP44001469","insp_date":"2024-03-01 00:00:00","insp_start_time":"1057","insp_end_time":"1109","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"WILLISTON ND","county_code_state":"ND","county_code":"105","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-03-08 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","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":"299936","transaction_code":"A","transaction_date":"2024-03-07 00:00:00","upload_date":"2024-03-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01485979","upload_search_indicator":null,"census_search_date":"2024-03-08 21:39:00","snet_input_date":"2024-03-01 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-03-08 21:39:00","insp_carrier_name":"CLEARWELL WELL SERVICES LLC","insp_carrier_street":"3091 UNIVERSITY DR E #330","insp_carrier_city":"BRYAN","insp_carrier_state":"TX","insp_carrier_zip_code":"77802","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:06:38.000000Z","updated_at":"2025-03-17T20:06:38.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8441625,"change_date":"2024-03-08 21:39:00","inspection_id":"81057754","insp_unit_id":"199820013","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"LOADCRAFT","insp_unit_company":null,"insp_unit_license":"EXEMPT","insp_unit_license_state":"ND","insp_unit_vehicle_id_number":"0140230","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:30.000000Z","updated_at":"2025-03-17T23:11:30.000000Z"}]},{"id":3445274,"change_date":"2023-07-06 21:42:00","inspection_id":"79072373","dot_number":"1485979","report_state":"LA","report_number":"LANV001702","insp_date":"2023-06-27 00:00:00","insp_start_time":"0906","insp_end_time":"0941","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"LA","county_code":"019","insp_level_id":"2","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-07-06 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"115000","viol_total":"3","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1172977","transaction_code":"A","transaction_date":"2023-07-05 00:00:00","upload_date":"2023-07-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01485979","upload_search_indicator":"M","census_search_date":"2023-07-06 21:42:00","snet_input_date":"2023-07-05 00:00:00","source_office":"2LAS001","mcmis_add_date":"2023-07-06 21:42:00","insp_carrier_name":"CLEARWELL WELL SERVICES LLC","insp_carrier_street":"3091 UNIVERSITY DR E #330","insp_carrier_city":"BRYAN","insp_carrier_state":"TX","insp_carrier_zip_code":"77802","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:31:18.000000Z","updated_at":"2025-03-17T19:31:18.000000Z","inspection_violations":[{"id":5312595,"change_date":"2023-07-06 21:42:00","inspection_id":"79072373","insp_violation_id":"253898471","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195853564","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:39.000000Z","updated_at":"2025-03-17T21:31:39.000000Z","normalized_code":"3922"},{"id":5312596,"change_date":"2023-07-06 21:42:00","inspection_id":"79072373","insp_violation_id":"253898472","seq_no":"2","part_no":"393","part_no_section":"87(b)","insp_viol_unit":"1","insp_unit_id":"195853564","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:39.000000Z","updated_at":"2025-03-17T21:31:39.000000Z","normalized_code":"39387B"},{"id":5312597,"change_date":"2023-07-06 21:42:00","inspection_id":"79072373","insp_violation_id":"253898473","seq_no":"3","part_no":"395","part_no_section":"8(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:39.000000Z","updated_at":"2025-03-17T21:31:39.000000Z","normalized_code":"3958A1"}],"inspection_per_units":[{"id":5539970,"change_date":"2023-07-06 21:42:00","inspection_id":"79072373","insp_unit_id":"195853564","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"OTHR","insp_unit_company":"1215","insp_unit_license":"52P873","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1215","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:43.000000Z","updated_at":"2025-03-17T22:46:43.000000Z"}]},{"id":2778346,"change_date":"2023-04-11 21:40:00","inspection_id":"78320003","dot_number":"1485979","report_state":"TX","report_number":"6JZ80ADZ5I","insp_date":"2023-04-05 00:00:00","insp_start_time":"0751","insp_end_time":"0813","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0036 IN WASHINGTON CO. (560","county_code_state":"TX","county_code":"477","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":"N","pen_cen_match":null,"final_status_date":"2023-04-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"8950695","transaction_code":"A","transaction_date":"2023-04-11 00:00:00","upload_date":"2023-04-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01485979","upload_search_indicator":"M","census_search_date":"2023-04-11 21:40:00","snet_input_date":"2023-04-05 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-04-11 21:40:00","insp_carrier_name":"CLEARWELL WELL SERVICES LLC","insp_carrier_street":"3091 UNIVERSITY DR E #330","insp_carrier_city":"BRYAN","insp_carrier_state":"TX","insp_carrier_zip_code":"77802","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0095005","created_at":"2025-03-17T19:17:44.000000Z","updated_at":"2025-03-17T19:17:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4472542,"change_date":"2023-04-11 21:40:00","inspection_id":"78320003","insp_unit_id":"194329301","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"219","insp_unit_license":"1M84946","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDP4TX2LR375888","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:14.000000Z","updated_at":"2025-03-17T22:38:14.000000Z"},{"id":4472543,"change_date":"2023-04-11 21:40:00","inspection_id":"78320003","insp_unit_id":"194329302","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"207-A","insp_unit_license":"057755H","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1T9DL5338VT447650","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:14.000000Z","updated_at":"2025-03-17T22:38:14.000000Z"}]},{"id":2567617,"change_date":"2023-08-03 21:41:00","inspection_id":"78079980","dot_number":"1485979","report_state":"ND","report_number":"HP44000318","insp_date":"2023-03-02 00:00:00","insp_start_time":"0948","insp_end_time":"1026","registration_date":"2023-08-01 00:00:00","region":"CT","ci_status_code":"C","location":"1","location_desc":"PANGER","county_code_state":"ND","county_code":"053","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-03-13 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"105500","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":"368529","transaction_code":"C","transaction_date":"2023-03-08 00:00:00","upload_date":"2023-08-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01485979","upload_search_indicator":"M","census_search_date":"2023-03-13 21:43:00","snet_input_date":"2023-03-07 00:00:00","source_office":"4NDS001","mcmis_add_date":"2023-03-13 21:43:00","insp_carrier_name":"CLEARWELL WELL SERVICES LLC","insp_carrier_street":"3091 UNIVERSITY DR E #330","insp_carrier_city":"BRYAN","insp_carrier_state":"TX","insp_carrier_zip_code":"77802","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:14:04.000000Z","updated_at":"2025-03-17T19:14:04.000000Z","inspection_violations":[{"id":3949280,"change_date":"2023-08-03 21:41:00","inspection_id":"78079980","insp_violation_id":"254453441","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:31.000000Z","updated_at":"2025-03-17T21:25:31.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4132482,"change_date":"2023-08-03 21:41:00","inspection_id":"78079980","insp_unit_id":"196351964","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"OTHR","insp_unit_company":"122","insp_unit_license":"NONE","insp_unit_license_state":"ND","insp_unit_vehicle_id_number":"00150008","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:37.000000Z","updated_at":"2025-03-17T22:35:37.000000Z"}]},{"id":2233602,"change_date":"2023-02-03 21:41:00","inspection_id":"77699337","dot_number":"1485979","report_state":"LA","report_number":"LADR007533","insp_date":"2023-01-25 00:00:00","insp_start_time":"1122","insp_end_time":"1146","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"LA","county_code":"001","insp_level_id":"2","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-01-26 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"116260","viol_total":"3","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1155929","transaction_code":"C","transaction_date":"2023-02-03 00:00:00","upload_date":"2023-02-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01485979","upload_search_indicator":"M","census_search_date":"2023-01-26 21:41:00","snet_input_date":"2023-01-26 00:00:00","source_office":"2LAS001","mcmis_add_date":"2023-01-26 21:41:00","insp_carrier_name":"CLEARWELL WELL SERVICES LLC","insp_carrier_street":"3091 UNIVERSITY DR E #330","insp_carrier_city":"BRYAN","insp_carrier_state":"TX","insp_carrier_zip_code":"77802","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:07:46.000000Z","updated_at":"2025-03-17T19:07:46.000000Z","inspection_violations":[{"id":3451041,"change_date":"2023-02-03 21:41:00","inspection_id":"77699337","insp_violation_id":"250941468","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193217626","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:19.000000Z","updated_at":"2025-03-17T21:23:19.000000Z","normalized_code":"3922"},{"id":3451042,"change_date":"2023-02-03 21:41:00","inspection_id":"77699337","insp_violation_id":"250941469","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193217626","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:23:19.000000Z","updated_at":"2025-03-17T21:23:19.000000Z","normalized_code":"3939A"},{"id":3451043,"change_date":"2023-02-03 21:41:00","inspection_id":"77699337","insp_violation_id":"250941470","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193217626","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:23:19.000000Z","updated_at":"2025-03-17T21:23:19.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":3595072,"change_date":"2023-02-03 21:41:00","inspection_id":"77699337","insp_unit_id":"193217626","insp_unit_type_id":"6","insp_unit_number":"1","insp_unit_make":"OTHR","insp_unit_company":"137","insp_unit_license":"50P400","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1515","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:47.000000Z","updated_at":"2025-03-17T22:31:47.000000Z"}]},{"id":2720759,"change_date":"2023-04-03 21:40:00","inspection_id":"78254796","dot_number":"1485979","report_state":"TX","report_number":"6HMD0ADZ3E","insp_date":"2023-01-10 00:00:00","insp_start_time":"1247","insp_end_time":"1317","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0021 IN BURLESON CO. (610-6","county_code_state":"TX","county_code":"051","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":"N","pen_cen_match":null,"final_status_date":"2023-04-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"156001","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":"8943287","transaction_code":"A","transaction_date":"2023-04-03 00:00:00","upload_date":"2023-04-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01485979","upload_search_indicator":"M","census_search_date":"2023-04-03 21:40:00","snet_input_date":"2023-01-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-04-03 21:40:00","insp_carrier_name":"CLEARWELL WELL SERVICES LLC","insp_carrier_street":"3091 UNIVERSITY DR E #330","insp_carrier_city":"BRYAN","insp_carrier_state":"TX","insp_carrier_zip_code":"77802","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0095005","created_at":"2025-03-17T19:16:55.000000Z","updated_at":"2025-03-17T19:16:55.000000Z","inspection_violations":[{"id":4179118,"change_date":"2023-04-03 21:40:00","inspection_id":"78254796","insp_violation_id":"252018619","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"194199564","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:32.000000Z","updated_at":"2025-03-17T21:26:32.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4379555,"change_date":"2023-04-03 21:40:00","inspection_id":"78254796","insp_unit_id":"194199563","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"219","insp_unit_license":"1M84946","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDP4TX2LR375888","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:28.000000Z","updated_at":"2025-03-17T22:37:28.000000Z"},{"id":4379556,"change_date":"2023-04-03 21:40:00","inspection_id":"78254796","insp_unit_id":"194199564","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"AZTC","insp_unit_company":"219A","insp_unit_license":"120C331","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1AZBG1A20B1011706","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:28.000000Z","updated_at":"2025-03-17T22:37:28.000000Z"}]},{"id":2118290,"change_date":"2023-01-11 21:43:00","inspection_id":"77567313","dot_number":"1485979","report_state":"TX","report_number":"6HL90AHO8M","insp_date":"2023-01-09 00:00:00","insp_start_time":"0922","insp_end_time":"1000","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0059 IN WHARTON CO. (560-59","county_code_state":"TX","county_code":"481","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"X","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-11 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"8874632","transaction_code":"A","transaction_date":"2023-01-11 00:00:00","upload_date":"2023-01-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01485979","upload_search_indicator":null,"census_search_date":"2023-01-11 21:43:00","snet_input_date":"2023-01-09 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-01-11 21:43:00","insp_carrier_name":"PIONEER WELL SERVICES LLC","insp_carrier_street":"401 N MECHANIC  2ND FLOOR","insp_carrier_city":"EL CAMPO","insp_carrier_state":"TX","insp_carrier_zip_code":"77437","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0095005","created_at":"2025-03-17T19:05:34.000000Z","updated_at":"2025-03-17T19:05:34.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3409557,"change_date":"2023-01-11 21:43:00","inspection_id":"77567313","insp_unit_id":"192818144","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"215","insp_unit_license":"1M39074","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPWD49X8AD795443","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:25.000000Z","updated_at":"2025-03-17T22:30:25.000000Z"},{"id":3409558,"change_date":"2023-01-11 21:43:00","inspection_id":"77567313","insp_unit_id":"192818145","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAN","insp_unit_company":"2068","insp_unit_license":"198C490","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1TTE5330981084267","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:25.000000Z","updated_at":"2025-03-17T22:30:25.000000Z"}]},{"id":2018805,"change_date":"2022-12-27 21:40:00","inspection_id":"77453555","dot_number":"1485979","report_state":"TX","report_number":"6H1C0XMNAX","insp_date":"2022-12-20 00:00:00","insp_start_time":"1227","insp_end_time":"1301","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0035 IN BRAZORIA CO. (482-5","county_code_state":"TX","county_code":"039","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"PIONEER WELL 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":"2022-12-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"0","viol_total":"4","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8860724","transaction_code":"A","transaction_date":"2022-12-27 00:00:00","upload_date":"2022-12-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01485979","upload_search_indicator":null,"census_search_date":"2022-12-27 21:40:00","snet_input_date":"2022-12-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-12-27 21:40:00","insp_carrier_name":"PIONEER WELL SERVICES LLC","insp_carrier_street":"401 N MECHANIC  2ND FLOOR","insp_carrier_city":"EL CAMPO","insp_carrier_state":"TX","insp_carrier_zip_code":"77437","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0095005","created_at":"2025-03-17T19:03:43.000000Z","updated_at":"2025-03-17T19:03:43.000000Z","inspection_violations":[{"id":3131693,"change_date":"2022-12-27 21:40:00","inspection_id":"77453555","insp_violation_id":"250275262","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"192590132","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:50.000000Z","updated_at":"2025-03-17T21:21:50.000000Z","normalized_code":"39378"},{"id":3131694,"change_date":"2022-12-27 21:40:00","inspection_id":"77453555","insp_violation_id":"250275263","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"192590133","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:50.000000Z","updated_at":"2025-03-17T21:21:50.000000Z","normalized_code":"3939A"},{"id":3131695,"change_date":"2022-12-27 21:40:00","inspection_id":"77453555","insp_violation_id":"250275264","seq_no":"3","part_no":"393","part_no_section":"110(b)","insp_viol_unit":"2","insp_unit_id":"192590133","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:21:50.000000Z","updated_at":"2025-03-17T21:21:50.000000Z","normalized_code":"393110B"},{"id":3131696,"change_date":"2022-12-27 21:40:00","inspection_id":"77453555","insp_violation_id":"250275265","seq_no":"4","part_no":"393","part_no_section":"104(f)(3)","insp_viol_unit":"2","insp_unit_id":"192590133","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:21:50.000000Z","updated_at":"2025-03-17T21:21:50.000000Z","normalized_code":"393104F3"}],"inspection_per_units":[{"id":3248285,"change_date":"2022-12-27 21:40:00","inspection_id":"77453555","insp_unit_id":"192590132","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"215","insp_unit_license":"1M39074","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPWD49X8AD795443","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:14.000000Z","updated_at":"2025-03-17T22:29:14.000000Z"},{"id":3248286,"change_date":"2022-12-27 21:40:00","inspection_id":"77453555","insp_unit_id":"192590133","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAO","insp_unit_company":"206","insp_unit_license":"198C490","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1TTE5330981084267","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:14.000000Z","updated_at":"2025-03-17T22:29:14.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1485979\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1485979\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1485979\/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\/1485979\/inspections","per_page":100,"prev_page_url":null,"to":25,"total":25}