{"current_page":1,"data":[{"id":4933773,"change_date":"2024-01-30 21:42:00","inspection_id":"80720716","dot_number":"3505848","report_state":"TX","report_number":"6S6B9DAZFZ","insp_date":"2024-01-25 00:00:00","insp_start_time":"1035","insp_end_time":"1235","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0290 IN HARRIS CO. (706-738","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"AXIS PIPE & TUBE","shipping_paper_number":"60072187","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-01-30 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"136000","viol_total":"23","oos_total":"5","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"23","vehicle_oos_total":"5","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9183462","transaction_code":"A","transaction_date":"2024-01-30 00:00:00","upload_date":"2024-01-30 00:00:00","upload_first_byte":"0","upload_dot_number":"03505848","upload_search_indicator":"M","census_search_date":"2024-01-30 21:42:00","snet_input_date":"2024-01-25 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-01-30 21:42:00","insp_carrier_name":"BRAZOS VALLEY TRANSPORTATION LLC","insp_carrier_street":"7823 WHISPERING WOOD LN","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77086-2432","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1016358","created_at":"2025-03-17T20:00:29.000000Z","updated_at":"2025-03-17T20:00:29.000000Z","inspection_violations":[{"id":7598147,"change_date":"2024-01-30 21:42:00","inspection_id":"80720716","insp_violation_id":"257564057","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199176945","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:39.000000Z","updated_at":"2025-03-17T21:42:39.000000Z","normalized_code":"3922"},{"id":7598148,"change_date":"2024-01-30 21:42:00","inspection_id":"80720716","insp_violation_id":"257564058","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"199176946","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:39.000000Z","updated_at":"2025-03-17T21:42:39.000000Z","normalized_code":"3922"},{"id":7598149,"change_date":"2024-01-30 21:42:00","inspection_id":"80720716","insp_violation_id":"257564059","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"199176946","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:39.000000Z","updated_at":"2025-03-17T21:42:39.000000Z","normalized_code":"3922"},{"id":7598150,"change_date":"2024-01-30 21:42:00","inspection_id":"80720716","insp_violation_id":"257564060","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199176945","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:39.000000Z","updated_at":"2025-03-17T21:42:39.000000Z","normalized_code":"3922"},{"id":7598151,"change_date":"2024-01-30 21:42:00","inspection_id":"80720716","insp_violation_id":"257564061","seq_no":"5","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"199176945","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:39.000000Z","updated_at":"2025-03-17T21:42:39.000000Z","normalized_code":"39378"},{"id":7598152,"change_date":"2024-01-30 21:42:00","inspection_id":"80720716","insp_violation_id":"257564062","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199176945","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:39.000000Z","updated_at":"2025-03-17T21:42:39.000000Z","normalized_code":"3939A"},{"id":7598153,"change_date":"2024-01-30 21:42:00","inspection_id":"80720716","insp_violation_id":"257564063","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199176945","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:39.000000Z","updated_at":"2025-03-17T21:42:39.000000Z","normalized_code":"3939A"},{"id":7598154,"change_date":"2024-01-30 21:42:00","inspection_id":"80720716","insp_violation_id":"257564064","seq_no":"8","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"199176946","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:39.000000Z","updated_at":"2025-03-17T21:42:39.000000Z","normalized_code":"3939A"},{"id":7598155,"change_date":"2024-01-30 21:42:00","inspection_id":"80720716","insp_violation_id":"257564065","seq_no":"9","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"199176946","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:39.000000Z","updated_at":"2025-03-17T21:42:39.000000Z","normalized_code":"3939A"},{"id":7598156,"change_date":"2024-01-30 21:42:00","inspection_id":"80720716","insp_violation_id":"257564066","seq_no":"10","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"199176946","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:42:39.000000Z","updated_at":"2025-03-17T21:42:39.000000Z","normalized_code":"3939A"},{"id":7598157,"change_date":"2024-01-30 21:42:00","inspection_id":"80720716","insp_violation_id":"257564067","seq_no":"11","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"199176946","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:39.000000Z","updated_at":"2025-03-17T21:42:39.000000Z","normalized_code":"39311"},{"id":7598158,"change_date":"2024-01-30 21:42:00","inspection_id":"80720716","insp_violation_id":"257564068","seq_no":"12","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"199176946","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:39.000000Z","updated_at":"2025-03-17T21:42:39.000000Z","normalized_code":"39375C"},{"id":7598159,"change_date":"2024-01-30 21:42:00","inspection_id":"80720716","insp_violation_id":"257564069","seq_no":"13","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"199176946","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:42:39.000000Z","updated_at":"2025-03-17T21:42:39.000000Z","normalized_code":"3939A"},{"id":7598160,"change_date":"2024-01-30 21:42:00","inspection_id":"80720716","insp_violation_id":"257564070","seq_no":"14","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"199176946","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:39.000000Z","updated_at":"2025-03-17T21:42:39.000000Z","normalized_code":"3939A"},{"id":7598161,"change_date":"2024-01-30 21:42:00","inspection_id":"80720716","insp_violation_id":"257564071","seq_no":"15","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"199176945","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:39.000000Z","updated_at":"2025-03-17T21:42:39.000000Z","normalized_code":"39375C"},{"id":7598162,"change_date":"2024-01-30 21:42:00","inspection_id":"80720716","insp_violation_id":"257564072","seq_no":"16","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199176945","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:39.000000Z","updated_at":"2025-03-17T21:42:39.000000Z","normalized_code":"3939A"},{"id":7598163,"change_date":"2024-01-30 21:42:00","inspection_id":"80720716","insp_violation_id":"257564073","seq_no":"17","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"199176945","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:39.000000Z","updated_at":"2025-03-17T21:42:39.000000Z","normalized_code":"3965B"},{"id":7598164,"change_date":"2024-01-30 21:42:00","inspection_id":"80720716","insp_violation_id":"257564074","seq_no":"18","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"199176945","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:42:39.000000Z","updated_at":"2025-03-17T21:42:39.000000Z","normalized_code":"39345B2"},{"id":7598165,"change_date":"2024-01-30 21:42:00","inspection_id":"80720716","insp_violation_id":"257564075","seq_no":"19","part_no":"393","part_no_section":"75(b)","insp_viol_unit":"1","insp_unit_id":"199176945","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:42:39.000000Z","updated_at":"2025-03-17T21:42:39.000000Z","normalized_code":"39375B"},{"id":7598166,"change_date":"2024-01-30 21:42:00","inspection_id":"80720716","insp_violation_id":"257564076","seq_no":"20","part_no":"393","part_no_section":"51","insp_viol_unit":"1","insp_unit_id":"199176945","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:42:39.000000Z","updated_at":"2025-03-17T21:42:39.000000Z","normalized_code":"39351"},{"id":7598167,"change_date":"2024-01-30 21:42:00","inspection_id":"80720716","insp_violation_id":"257564077","seq_no":"21","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"199176945","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:39.000000Z","updated_at":"2025-03-17T21:42:39.000000Z","normalized_code":"39360C"},{"id":7598168,"change_date":"2024-01-30 21:42:00","inspection_id":"80720716","insp_violation_id":"257564078","seq_no":"22","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"199176946","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:39.000000Z","updated_at":"2025-03-17T21:42:39.000000Z","normalized_code":"39355E"},{"id":7598169,"change_date":"2024-01-30 21:42:00","inspection_id":"80720716","insp_violation_id":"257564079","seq_no":"23","part_no":"393","part_no_section":"104(b)","insp_viol_unit":"2","insp_unit_id":"199176946","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:39.000000Z","updated_at":"2025-03-17T21:42:39.000000Z","normalized_code":"393104B"}],"inspection_per_units":[{"id":7939768,"change_date":"2024-01-30 21:42:00","inspection_id":"80720716","insp_unit_id":"199176945","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"NONE","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP5DB8XXTD367037","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:57.000000Z","updated_at":"2025-03-17T23:06:57.000000Z"},{"id":7939769,"change_date":"2024-01-30 21:42:00","inspection_id":"80720716","insp_unit_id":"199176946","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"REIT","insp_unit_company":"50","insp_unit_license":"138C501","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1RNF48A2XYR006257","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:57.000000Z","updated_at":"2025-03-17T23:06:57.000000Z"}]},{"id":4522590,"change_date":"2023-11-29 21:43:00","inspection_id":"80270763","dot_number":"3505848","report_state":"TX","report_number":"V231222393","insp_date":"2023-11-15 00:00:00","insp_start_time":"1008","insp_end_time":"1043","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH 6 MP 608","county_code_state":"TX","county_code":"041","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"AXIS PIPE","shipping_paper_number":"60070189","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-11-29 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"140000","viol_total":"13","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"13","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9135754","transaction_code":"A","transaction_date":"2023-11-29 00:00:00","upload_date":"2023-11-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03505848","upload_search_indicator":"M","census_search_date":"2023-11-29 21:43:00","snet_input_date":"2023-11-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-11-29 21:43:00","insp_carrier_name":"BRAZOS VALLEY TRANSPORTATION LLC","insp_carrier_street":"7823 WHISPERING WOOD LN","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77086-2432","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1016358","created_at":"2025-03-17T19:52:32.000000Z","updated_at":"2025-03-17T19:52:32.000000Z","inspection_violations":[{"id":6998363,"change_date":"2023-11-29 21:43:00","inspection_id":"80270763","insp_violation_id":"256629282","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"198273376","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:44.000000Z","updated_at":"2025-03-17T21:39:44.000000Z","normalized_code":"39311"},{"id":6998364,"change_date":"2023-11-29 21:43:00","inspection_id":"80270763","insp_violation_id":"256629283","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"198273376","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:44.000000Z","updated_at":"2025-03-17T21:39:44.000000Z","normalized_code":"39311"},{"id":6998365,"change_date":"2023-11-29 21:43:00","inspection_id":"80270763","insp_violation_id":"256629284","seq_no":"3","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"198273376","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:44.000000Z","updated_at":"2025-03-17T21:39:44.000000Z","normalized_code":"39345B2"},{"id":6998366,"change_date":"2023-11-29 21:43:00","inspection_id":"80270763","insp_violation_id":"256629285","seq_no":"4","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"198273376","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:44.000000Z","updated_at":"2025-03-17T21:39:44.000000Z","normalized_code":"39378"},{"id":6998367,"change_date":"2023-11-29 21:43:00","inspection_id":"80270763","insp_violation_id":"256629286","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198273376","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:44.000000Z","updated_at":"2025-03-17T21:39:44.000000Z","normalized_code":"3939A"},{"id":6998368,"change_date":"2023-11-29 21:43:00","inspection_id":"80270763","insp_violation_id":"256629287","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"198273377","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:44.000000Z","updated_at":"2025-03-17T21:39:44.000000Z","normalized_code":"3939A"},{"id":6998369,"change_date":"2023-11-29 21:43:00","inspection_id":"80270763","insp_violation_id":"256629288","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"198273377","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:39:44.000000Z","updated_at":"2025-03-17T21:39:44.000000Z","normalized_code":"3939A"},{"id":6998370,"change_date":"2023-11-29 21:43:00","inspection_id":"80270763","insp_violation_id":"256629289","seq_no":"8","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198273376","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:44.000000Z","updated_at":"2025-03-17T21:39:44.000000Z","normalized_code":"3939A"},{"id":6998371,"change_date":"2023-11-29 21:43:00","inspection_id":"80270763","insp_violation_id":"256629290","seq_no":"9","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"198273377","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:44.000000Z","updated_at":"2025-03-17T21:39:44.000000Z","normalized_code":"39617C"},{"id":6998372,"change_date":"2023-11-29 21:43:00","inspection_id":"80270763","insp_violation_id":"256629291","seq_no":"10","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"198273376","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:44.000000Z","updated_at":"2025-03-17T21:39:44.000000Z","normalized_code":"39617C"},{"id":6998373,"change_date":"2023-11-29 21:43:00","inspection_id":"80270763","insp_violation_id":"256629292","seq_no":"11","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"198273376","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:39:44.000000Z","updated_at":"2025-03-17T21:39:44.000000Z","normalized_code":"3963A1"},{"id":6998374,"change_date":"2023-11-29 21:43:00","inspection_id":"80270763","insp_violation_id":"256629293","seq_no":"12","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198273376","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:44.000000Z","updated_at":"2025-03-17T21:39:44.000000Z","normalized_code":"3922"},{"id":6998375,"change_date":"2023-11-29 21:43:00","inspection_id":"80270763","insp_violation_id":"256629294","seq_no":"13","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"198273377","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:44.000000Z","updated_at":"2025-03-17T21:39:44.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7273690,"change_date":"2023-11-29 21:43:00","inspection_id":"80270763","insp_unit_id":"198273376","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"01","insp_unit_license":"1M18329","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKWDB9X4YR844208","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:05.000000Z","updated_at":"2025-03-17T23:01:05.000000Z"},{"id":7273691,"change_date":"2023-11-29 21:43:00","inspection_id":"80270763","insp_unit_id":"198273377","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"REIT","insp_unit_company":"50","insp_unit_license":"138C501","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1RNF48A2XYR006257","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:05.000000Z","updated_at":"2025-03-17T23:01:05.000000Z"}]},{"id":1565837,"change_date":"2022-10-20 21:41:00","inspection_id":"76934625","dot_number":"3505848","report_state":"TX","report_number":"6F589DCPK4","insp_date":"2022-10-13 00:00:00","insp_start_time":"0830","insp_end_time":"0910","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"12200  EAST FWY NORT","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2022-10-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"90100","viol_total":"21","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"21","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8805826","transaction_code":"A","transaction_date":"2022-10-20 00:00:00","upload_date":"2022-10-20 00:00:00","upload_first_byte":"0","upload_dot_number":"03505848","upload_search_indicator":"M","census_search_date":"2022-10-20 21:41:00","snet_input_date":"2022-10-13 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-10-20 21:41:00","insp_carrier_name":"BRAZOS VALLEY TRANSPORTATION LLC","insp_carrier_street":"7823 WHISPERING WOOD LN","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77086-2432","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1016358","created_at":"2025-03-17T18:55:34.000000Z","updated_at":"2025-03-17T18:55:34.000000Z","inspection_violations":[{"id":2461625,"change_date":"2022-10-20 21:41:00","inspection_id":"76934625","insp_violation_id":"249161384","seq_no":"13","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"191561348","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:33.000000Z","updated_at":"2025-03-17T21:18:33.000000Z","normalized_code":"39345B2"},{"id":2461626,"change_date":"2022-10-20 21:41:00","inspection_id":"76934625","insp_violation_id":"249161385","seq_no":"14","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"191561348","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:33.000000Z","updated_at":"2025-03-17T21:18:33.000000Z","normalized_code":"39345B2"},{"id":2461627,"change_date":"2022-10-20 21:41:00","inspection_id":"76934625","insp_violation_id":"249161386","seq_no":"15","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"191561347","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:33.000000Z","updated_at":"2025-03-17T21:18:33.000000Z","normalized_code":"3963A1"},{"id":2461628,"change_date":"2022-10-20 21:41:00","inspection_id":"76934625","insp_violation_id":"249161387","seq_no":"16","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191561347","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:33.000000Z","updated_at":"2025-03-17T21:18:33.000000Z","normalized_code":"3922"},{"id":2461629,"change_date":"2022-10-20 21:41:00","inspection_id":"76934625","insp_violation_id":"249161388","seq_no":"17","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"191561348","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:33.000000Z","updated_at":"2025-03-17T21:18:33.000000Z","normalized_code":"39617C"},{"id":2461630,"change_date":"2022-10-20 21:41:00","inspection_id":"76934625","insp_violation_id":"249161389","seq_no":"18","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191561347","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:33.000000Z","updated_at":"2025-03-17T21:18:33.000000Z","normalized_code":"3922"},{"id":2461631,"change_date":"2022-10-20 21:41:00","inspection_id":"76934625","insp_violation_id":"249161390","seq_no":"19","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"191561348","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:33.000000Z","updated_at":"2025-03-17T21:18:33.000000Z","normalized_code":"39617C"},{"id":2461632,"change_date":"2022-10-20 21:41:00","inspection_id":"76934625","insp_violation_id":"249161391","seq_no":"20","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191561347","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:33.000000Z","updated_at":"2025-03-17T21:18:33.000000Z","normalized_code":"3922"},{"id":2461633,"change_date":"2022-10-20 21:41:00","inspection_id":"76934625","insp_violation_id":"249161392","seq_no":"21","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"191561347","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:18:33.000000Z","updated_at":"2025-03-17T21:18:33.000000Z","normalized_code":"3963A1"},{"id":2461634,"change_date":"2022-10-20 21:41:00","inspection_id":"76934625","insp_violation_id":"249161393","seq_no":"1","part_no":"393","part_no_section":"203(a)","insp_viol_unit":"1","insp_unit_id":"191561347","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:33.000000Z","updated_at":"2025-03-17T21:18:33.000000Z","normalized_code":"393203A"},{"id":2461635,"change_date":"2022-10-20 21:41:00","inspection_id":"76934625","insp_violation_id":"249161394","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"191561347","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:33.000000Z","updated_at":"2025-03-17T21:18:33.000000Z","normalized_code":"39378"},{"id":2461636,"change_date":"2022-10-20 21:41:00","inspection_id":"76934625","insp_violation_id":"249161395","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"191561347","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:33.000000Z","updated_at":"2025-03-17T21:18:33.000000Z","normalized_code":"39378"},{"id":2461637,"change_date":"2022-10-20 21:41:00","inspection_id":"76934625","insp_violation_id":"249161396","seq_no":"4","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"191561347","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:33.000000Z","updated_at":"2025-03-17T21:18:33.000000Z","normalized_code":"39311"},{"id":2461638,"change_date":"2022-10-20 21:41:00","inspection_id":"76934625","insp_violation_id":"249161397","seq_no":"5","part_no":"393","part_no_section":"45(a)","insp_viol_unit":"1","insp_unit_id":"191561347","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:18:33.000000Z","updated_at":"2025-03-17T21:18:33.000000Z","normalized_code":"39345A"},{"id":2461639,"change_date":"2022-10-20 21:41:00","inspection_id":"76934625","insp_violation_id":"249161398","seq_no":"6","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"191561347","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:33.000000Z","updated_at":"2025-03-17T21:18:33.000000Z","normalized_code":"39347E"},{"id":2461640,"change_date":"2022-10-20 21:41:00","inspection_id":"76934625","insp_violation_id":"249161399","seq_no":"7","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"191561348","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:33.000000Z","updated_at":"2025-03-17T21:18:33.000000Z","normalized_code":"39347E"},{"id":2461641,"change_date":"2022-10-20 21:41:00","inspection_id":"76934625","insp_violation_id":"249161400","seq_no":"8","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"191561347","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:33.000000Z","updated_at":"2025-03-17T21:18:33.000000Z","normalized_code":"39353B"},{"id":2461642,"change_date":"2022-10-20 21:41:00","inspection_id":"76934625","insp_violation_id":"249161401","seq_no":"9","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"191561348","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:18:33.000000Z","updated_at":"2025-03-17T21:18:33.000000Z","normalized_code":"3939A"},{"id":2461643,"change_date":"2022-10-20 21:41:00","inspection_id":"76934625","insp_violation_id":"249161402","seq_no":"10","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"191561348","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:33.000000Z","updated_at":"2025-03-17T21:18:33.000000Z","normalized_code":"39375C"},{"id":2461644,"change_date":"2022-10-20 21:41:00","inspection_id":"76934625","insp_violation_id":"249161403","seq_no":"11","part_no":"393","part_no_section":"75(a)(1)","insp_viol_unit":"2","insp_unit_id":"191561348","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:33.000000Z","updated_at":"2025-03-17T21:18:33.000000Z","normalized_code":"39375A1"},{"id":2461645,"change_date":"2022-10-20 21:41:00","inspection_id":"76934625","insp_violation_id":"249161404","seq_no":"12","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"191561347","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:33.000000Z","updated_at":"2025-03-17T21:18:33.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":2520223,"change_date":"2022-10-20 21:41:00","inspection_id":"76934625","insp_unit_id":"191561347","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"1M18329","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKWDB9X4YR844208","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:17.000000Z","updated_at":"2025-03-17T22:24:17.000000Z"},{"id":2520224,"change_date":"2022-10-20 21:41:00","inspection_id":"76934625","insp_unit_id":"191561348","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"REIT","insp_unit_company":null,"insp_unit_license":"138C501","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1RNF48A2XYR006257","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:17.000000Z","updated_at":"2025-03-17T22:24:17.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3505848\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3505848\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3505848\/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\/3505848\/inspections","per_page":100,"prev_page_url":null,"to":3,"total":3}