{"current_page":1,"data":[{"id":12634178,"change_date":"2026-08-04 21:40:00","inspection_id":"88605466","dot_number":"1952957","report_state":"TX","report_number":"7HK79DAZZK","insp_date":"2026-07-27 00:00:00","insp_start_time":"0710","insp_end_time":"0725","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":"4","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-08-04 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"10056186","transaction_code":"A","transaction_date":"2026-08-04 00:00:00","upload_date":"2026-08-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01952957","upload_search_indicator":"M","census_search_date":"2026-08-04 21:40:00","snet_input_date":"2026-07-27 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-08-04 21:40:00","insp_carrier_name":"CARLOS A HERNANDEZ","insp_carrier_street":"400 HWY 3013 W","insp_carrier_city":"EAGLE LAKE","insp_carrier_state":"TX","insp_carrier_zip_code":"77434","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0192065","created_at":"2026-08-07T09:39:55.000000Z","updated_at":"2026-08-15T09:31:32.000000Z","inspection_violations":[{"id":21995244,"change_date":"2026-08-04 21:40:00","inspection_id":"88605466","insp_violation_id":"275924917","seq_no":"1","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"214981397","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-07T09:57:54.000000Z","updated_at":"2026-08-15T09:43:54.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":21931727,"change_date":"2026-08-04 21:40:00","inspection_id":"88605466","insp_unit_id":"214981396","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"923","insp_unit_license":"1L42486","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CK95LN37580","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-07T09:18:50.000000Z","updated_at":"2026-08-15T09:02:59.000000Z"},{"id":21931728,"change_date":"2026-08-04 21:40:00","inspection_id":"88605466","insp_unit_id":"214981397","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"105B905","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1T9FC39B7M1066871","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-07T09:18:50.000000Z","updated_at":"2026-08-15T09:02:59.000000Z"}]},{"id":11400337,"change_date":"2026-03-17 21:40:00","inspection_id":"87315343","dot_number":"1952957","report_state":"TX","report_number":"V262250314","insp_date":"2026-03-13 00:00:00","insp_start_time":"1406","insp_end_time":"1452","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"18155 KICKAPOO RD AT","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"VIKING AGGREGATES","shipping_paper_number":"1076312","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-03-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"114000","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9887184","transaction_code":"A","transaction_date":"2026-03-17 00:00:00","upload_date":"2026-03-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01952957","upload_search_indicator":"M","census_search_date":"2026-03-17 21:40:00","snet_input_date":"2026-03-13 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-03-17 21:40:00","insp_carrier_name":"CARLOS A HERNANDEZ","insp_carrier_street":"400 HWY 3013 W","insp_carrier_city":"EAGLE LAKE","insp_carrier_state":"TX","insp_carrier_zip_code":"77434","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0192065","created_at":"2026-03-20T09:42:46.000000Z","updated_at":"2026-03-28T09:31:43.000000Z","inspection_violations":[{"id":19220578,"change_date":"2026-03-17 21:40:00","inspection_id":"87315343","insp_violation_id":"272459972","seq_no":"1","part_no":"393","part_no_section":"75A3","insp_viol_unit":"1","insp_unit_id":"212186641","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2026-03-20T10:03:57.000000Z","updated_at":"2026-03-28T09:48:01.000000Z","normalized_code":"39375A3"},{"id":19220579,"change_date":"2026-03-17 21:40:00","inspection_id":"87315343","insp_violation_id":"272459973","seq_no":"2","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"212186641","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-20T10:03:57.000000Z","updated_at":"2026-03-28T09:48:01.000000Z","normalized_code":"3939"},{"id":19220580,"change_date":"2026-03-17 21:40:00","inspection_id":"87315343","insp_violation_id":"272459974","seq_no":"3","part_no":"393","part_no_section":"9TS","insp_viol_unit":"1","insp_unit_id":"212186641","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-20T10:03:57.000000Z","updated_at":"2026-03-28T09:48:01.000000Z","normalized_code":"3939TS"},{"id":19220581,"change_date":"2026-03-17 21:40:00","inspection_id":"87315343","insp_violation_id":"272459975","seq_no":"4","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"212186642","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-20T10:03:57.000000Z","updated_at":"2026-03-28T09:48:01.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":19525727,"change_date":"2026-03-17 21:40:00","inspection_id":"87315343","insp_unit_id":"212186641","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"921","insp_unit_license":"1N87305","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKADB8X85J091983","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-20T09:19:33.000000Z","updated_at":"2026-03-28T09:06:17.000000Z"},{"id":19525728,"change_date":"2026-03-17 21:40:00","inspection_id":"87315343","insp_unit_id":"212186642","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"USTS","insp_unit_company":"921","insp_unit_license":"075B554","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1U9FA3825Y1051897","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-20T09:19:33.000000Z","updated_at":"2026-03-28T09:06:17.000000Z"}]},{"id":10201383,"change_date":"2025-11-14 21:40:00","inspection_id":"86322270","dot_number":"1952957","report_state":"TX","report_number":"7AFE9DBZ4Z","insp_date":"2025-11-12 00:00:00","insp_start_time":"1421","insp_end_time":"1448","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"1000  BARKER CYPRESS","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CEMEX","shipping_paper_number":"1025206018","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-11-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"128000","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":"9757114","transaction_code":"A","transaction_date":"2025-11-14 00:00:00","upload_date":"2025-11-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01952957","upload_search_indicator":"M","census_search_date":"2025-11-14 21:40:00","snet_input_date":"2025-11-12 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-11-14 21:40:00","insp_carrier_name":"CARLOS A HERNANDEZ","insp_carrier_street":"7241 FM 1094","insp_carrier_city":"SEALY","insp_carrier_state":"TX","insp_carrier_zip_code":"77474","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0192065","created_at":"2025-11-17T10:31:29.000000Z","updated_at":"2025-11-18T10:30:54.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16993576,"change_date":"2025-11-14 21:40:00","inspection_id":"86322270","insp_unit_id":"210034452","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"922","insp_unit_license":"1N75349","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD69X41J865050","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-17T10:01:23.000000Z","updated_at":"2025-11-18T10:01:20.000000Z"},{"id":16993577,"change_date":"2025-11-14 21:40:00","inspection_id":"86322270","insp_unit_id":"210034453","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"156C142","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5MADN3928MH059211","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-17T10:01:23.000000Z","updated_at":"2025-11-18T10:01:20.000000Z"}]},{"id":9879470,"change_date":"2025-10-07 21:41:00","inspection_id":"85982889","dot_number":"1952957","report_state":"TX","report_number":"V252030011","insp_date":"2025-09-30 00:00:00","insp_start_time":"1120","insp_end_time":"1150","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"18155 KICKAPOO RD AT","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HALLET MATERIALS","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-10-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9717401","transaction_code":"A","transaction_date":"2025-10-07 00:00:00","upload_date":"2025-10-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01952957","upload_search_indicator":"M","census_search_date":"2025-10-07 21:41:00","snet_input_date":"2025-09-30 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-10-07 21:41:00","insp_carrier_name":"CARLOS A HERNANDEZ","insp_carrier_street":"7241 FM 1094","insp_carrier_city":"SEALY","insp_carrier_state":"TX","insp_carrier_zip_code":"77474","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0192065","created_at":"2025-10-10T10:02:28.000000Z","updated_at":"2025-10-11T10:01:13.000000Z","inspection_violations":[{"id":16286260,"change_date":"2025-10-07 21:41:00","inspection_id":"85982889","insp_violation_id":"269158144","seq_no":"1","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"209347953","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-10T10:18:45.000000Z","updated_at":"2025-10-11T10:17:17.000000Z","normalized_code":"3939"},{"id":16286261,"change_date":"2025-10-07 21:41:00","inspection_id":"85982889","insp_violation_id":"269158145","seq_no":"2","part_no":"393","part_no_section":"95B","insp_viol_unit":"1","insp_unit_id":"209347953","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-10T10:18:45.000000Z","updated_at":"2025-10-11T10:17:17.000000Z","normalized_code":"39395B"},{"id":16286262,"change_date":"2025-10-07 21:41:00","inspection_id":"85982889","insp_violation_id":"269158146","seq_no":"3","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"209347953","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-10T10:18:45.000000Z","updated_at":"2025-10-11T10:17:17.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":16390291,"change_date":"2025-10-07 21:41:00","inspection_id":"85982889","insp_unit_id":"209347953","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"925","insp_unit_license":"1N50994","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CG03LK63906","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-10T09:47:51.000000Z","updated_at":"2025-10-11T09:46:36.000000Z"},{"id":16390292,"change_date":"2025-10-07 21:41:00","inspection_id":"85982889","insp_unit_id":"209347954","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAV","insp_unit_company":"T850","insp_unit_license":"230B102","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1T91F3922X1247074","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-10T09:47:51.000000Z","updated_at":"2025-10-11T09:46:37.000000Z"}]},{"id":9584825,"change_date":"2025-09-03 21:40:00","inspection_id":"85673695","dot_number":"1952957","report_state":"TX","report_number":"78C99DNAB5","insp_date":"2025-08-29 00:00:00","insp_start_time":"0845","insp_end_time":"0930","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0090 IN FORT BEND CO. (804-","county_code_state":"TX","county_code":"157","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CEMEX","shipping_paper_number":"1025200833","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-09-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"0","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9685307","transaction_code":"A","transaction_date":"2025-09-03 00:00:00","upload_date":"2025-09-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01952957","upload_search_indicator":"M","census_search_date":"2025-09-03 21:40:00","snet_input_date":"2025-08-29 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-09-03 21:40:00","insp_carrier_name":"CARLOS A HERNANDEZ","insp_carrier_street":"7241 FM 1094","insp_carrier_city":"SEALY","insp_carrier_state":"TX","insp_carrier_zip_code":"77474","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0192065","created_at":"2025-09-06T10:43:31.000000Z","updated_at":"2025-09-10T10:45:01.000000Z","inspection_violations":[{"id":15658396,"change_date":"2025-09-03 21:40:00","inspection_id":"85673695","insp_violation_id":"268440188","seq_no":"1","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"208732449","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-06T10:48:15.000000Z","updated_at":"2025-09-06T10:48:15.000000Z","normalized_code":"3939"},{"id":15658397,"change_date":"2025-09-03 21:40:00","inspection_id":"85673695","insp_violation_id":"268440189","seq_no":"2","part_no":"393","part_no_section":"75C","insp_viol_unit":"2","insp_unit_id":"208732450","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-06T10:48:15.000000Z","updated_at":"2025-09-06T10:48:15.000000Z","normalized_code":"39375C"},{"id":15658398,"change_date":"2025-09-03 21:40:00","inspection_id":"85673695","insp_violation_id":"268440190","seq_no":"3","part_no":"393","part_no_section":"83G","insp_viol_unit":"1","insp_unit_id":"208732449","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-06T10:48:15.000000Z","updated_at":"2025-09-06T10:48:15.000000Z","normalized_code":"39383G"}],"inspection_per_units":[{"id":15823352,"change_date":"2025-09-03 21:40:00","inspection_id":"85673695","insp_unit_id":"208732449","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"923","insp_unit_license":"1L42486","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CK95LN37580","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:47:37.000000Z","updated_at":"2025-09-09T09:47:37.000000Z"},{"id":15823353,"change_date":"2025-09-03 21:40:00","inspection_id":"85673695","insp_unit_id":"208732450","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRST","insp_unit_company":"252","insp_unit_license":"105B905","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1T9FC39B7M1066871","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:47:37.000000Z","updated_at":"2025-09-09T09:47:37.000000Z"}]},{"id":9103047,"change_date":"2025-07-09 21:43:00","inspection_id":"85154938","dot_number":"1952957","report_state":"TX","report_number":"V251930683","insp_date":"2025-07-03 00:00:00","insp_start_time":"1156","insp_end_time":"1226","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"5611 FM1161 WB","county_code_state":"TX","county_code":"481","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HEIDELBERG","shipping_paper_number":"1995047949","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-09 08:53:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"6","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9630097","transaction_code":"C","transaction_date":"2025-07-09 00:00:00","upload_date":"2025-07-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01952957","upload_search_indicator":"M","census_search_date":"2025-07-09 08:53:00","snet_input_date":"2025-07-03 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-07-09 08:53:00","insp_carrier_name":"CARLOS A HERNANDEZ","insp_carrier_street":"7241 FM 1094","insp_carrier_city":"SEALY","insp_carrier_state":"TX","insp_carrier_zip_code":"77474","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0192065","created_at":"2025-07-12T10:45:26.000000Z","updated_at":"2025-07-14T10:46:17.000000Z","inspection_violations":[{"id":14668831,"change_date":"2025-07-09 21:43:00","inspection_id":"85154938","insp_violation_id":"267307451","seq_no":"1","part_no":"393","part_no_section":"11TL","insp_viol_unit":"1","insp_unit_id":"207786498","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-13T10:49:13.000000Z","updated_at":"2025-07-13T10:49:13.000000Z","normalized_code":"39311TL"},{"id":14668832,"change_date":"2025-07-09 21:43:00","inspection_id":"85154938","insp_violation_id":"267307452","seq_no":"2","part_no":"393","part_no_section":"11TU","insp_viol_unit":"1","insp_unit_id":"207786498","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-13T10:49:13.000000Z","updated_at":"2025-07-13T10:49:13.000000Z","normalized_code":"39311TU"},{"id":14668833,"change_date":"2025-07-09 21:43:00","inspection_id":"85154938","insp_violation_id":"267307453","seq_no":"3","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"207786498","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-13T10:49:13.000000Z","updated_at":"2025-07-13T10:49:13.000000Z","normalized_code":"39360C"},{"id":14668834,"change_date":"2025-07-09 21:43:00","inspection_id":"85154938","insp_violation_id":"267307454","seq_no":"4","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"207786498","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-13T10:49:13.000000Z","updated_at":"2025-07-13T10:49:13.000000Z","normalized_code":"3939"},{"id":14668835,"change_date":"2025-07-09 21:43:00","inspection_id":"85154938","insp_violation_id":"267307455","seq_no":"5","part_no":"393","part_no_section":"9H","insp_viol_unit":"1","insp_unit_id":"207786498","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-13T10:49:13.000000Z","updated_at":"2025-07-13T10:49:13.000000Z","normalized_code":"3939H"},{"id":14668836,"change_date":"2025-07-09 21:43:00","inspection_id":"85154938","insp_violation_id":"267307456","seq_no":"6","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"207786499","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-07-13T10:49:13.000000Z","updated_at":"2025-07-13T10:49:13.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":14942876,"change_date":"2025-07-09 21:43:00","inspection_id":"85154938","insp_unit_id":"207786498","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"925","insp_unit_license":"1N50994","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CG03LK63906","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-12T09:45:55.000000Z","updated_at":"2025-07-13T09:46:24.000000Z"},{"id":14942877,"change_date":"2025-07-09 21:43:00","inspection_id":"85154938","insp_unit_id":"207786499","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAV","insp_unit_company":"925","insp_unit_license":"230B102","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1T91F3922X1247074","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-12T09:45:55.000000Z","updated_at":"2025-07-13T09:46:24.000000Z"}]},{"id":8704157,"change_date":"2025-05-21 21:42:00","inspection_id":"84745220","dot_number":"1952957","report_state":"TX","report_number":"75869DBC14","insp_date":"2025-05-09 00:00:00","insp_start_time":"0650","insp_end_time":"0701","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":"4","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CEMEX","shipping_paper_number":"1025192964","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-05-21 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"0","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9585270","transaction_code":"A","transaction_date":"2025-05-21 00:00:00","upload_date":"2025-05-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01952957","upload_search_indicator":"M","census_search_date":"2025-05-21 21:42:00","snet_input_date":"2025-05-09 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-05-21 21:42:00","insp_carrier_name":"CARLOS A HERNANDEZ","insp_carrier_street":"7241 FM 1094","insp_carrier_city":"SEALY","insp_carrier_state":"TX","insp_carrier_zip_code":"77474","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0192065","created_at":"2025-05-24T10:04:31.000000Z","updated_at":"2025-05-25T10:06:59.000000Z","inspection_violations":[{"id":13874074,"change_date":"2025-05-21 21:42:00","inspection_id":"84745220","insp_violation_id":"266386725","seq_no":"1","part_no":"392","part_no_section":"2-SLLS1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-24T10:28:25.000000Z","updated_at":"2025-05-25T10:26:25.000000Z","normalized_code":"3922SLLS1"},{"id":13874075,"change_date":"2025-05-21 21:42:00","inspection_id":"84745220","insp_violation_id":"266386726","seq_no":"2","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"206996366","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-24T10:28:25.000000Z","updated_at":"2025-05-25T10:26:25.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":14223755,"change_date":"2025-05-21 21:42:00","inspection_id":"84745220","insp_unit_id":"206996365","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"922","insp_unit_license":"1L35683","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD69X41J865050","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-24T09:49:54.000000Z","updated_at":"2025-05-25T09:52:47.000000Z"},{"id":14223756,"change_date":"2025-05-21 21:42:00","inspection_id":"84745220","insp_unit_id":"206996366","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MACL","insp_unit_company":null,"insp_unit_license":"156C142","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5MADN3928MH059211","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-24T09:49:54.000000Z","updated_at":"2025-05-25T09:52:47.000000Z"}]},{"id":8493363,"change_date":"2025-04-29 21:49:00","inspection_id":"84523146","dot_number":"1952957","report_state":"TX","report_number":"74F89DBH1O","insp_date":"2025-04-10 00:00:00","insp_start_time":"0847","insp_end_time":"0923","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":"CEMEX","shipping_paper_number":"1025191276","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-04-29 21:49:00","post_acc_ind":"N","gross_comb_veh_wt":"121860","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9563161","transaction_code":"A","transaction_date":"2025-04-29 00:00:00","upload_date":"2025-04-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01952957","upload_search_indicator":"M","census_search_date":"2025-04-29 21:49:00","snet_input_date":"2025-04-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-04-29 21:49:00","insp_carrier_name":"CARLOS A HERNANDEZ","insp_carrier_street":"7241 FM 1094","insp_carrier_city":"SEALY","insp_carrier_state":"TX","insp_carrier_zip_code":"77474","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0192065","created_at":"2025-05-02T10:27:01.000000Z","updated_at":"2025-05-02T13:50:50.000000Z","inspection_violations":[{"id":13435933,"change_date":"2025-04-29 21:49:00","inspection_id":"84523146","insp_violation_id":"265885635","seq_no":"1","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"206538730","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-02T11:00:41.000000Z","updated_at":"2025-05-02T11:21:50.000000Z","normalized_code":"3922RG"},{"id":13435934,"change_date":"2025-04-29 21:49:00","inspection_id":"84523146","insp_violation_id":"265885636","seq_no":"2","part_no":"393","part_no_section":"45B2PC","insp_viol_unit":"1","insp_unit_id":"206538729","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-02T11:00:41.000000Z","updated_at":"2025-05-02T11:21:50.000000Z","normalized_code":"39345B2PC"},{"id":13435935,"change_date":"2025-04-29 21:49:00","inspection_id":"84523146","insp_violation_id":"265885637","seq_no":"3","part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"2","insp_unit_id":"206538730","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-02T11:00:41.000000Z","updated_at":"2025-05-02T11:21:50.000000Z","normalized_code":"39345B2UV"}],"inspection_per_units":[{"id":13804113,"change_date":"2025-04-29 21:49:00","inspection_id":"84523146","insp_unit_id":"206538729","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"925","insp_unit_license":"1L35682","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDD69X2SJ663421","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-02T10:17:44.000000Z","updated_at":"2025-05-03T10:08:13.000000Z"},{"id":13804114,"change_date":"2025-04-29 21:49:00","inspection_id":"84523146","insp_unit_id":"206538730","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CLEM","insp_unit_company":null,"insp_unit_license":"029B814","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1C9BB38B6SM110115","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-02T10:17:44.000000Z","updated_at":"2025-05-03T10:08:13.000000Z"}]},{"id":6702769,"change_date":"2024-09-11 21:41:00","inspection_id":"82634575","dot_number":"1952957","report_state":"TX","report_number":"6YJA9DNA4W","insp_date":"2024-09-10 00:00:00","insp_start_time":"1025","insp_end_time":"1110","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0090 IN WALLER CO. (794-804","county_code_state":"TX","county_code":"473","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"XX","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-09-11 21:41: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":"9374793","transaction_code":"A","transaction_date":"2024-09-11 00:00:00","upload_date":"2024-09-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01952957","upload_search_indicator":"M","census_search_date":"2024-09-11 21:41:00","snet_input_date":"2024-09-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-09-11 21:41:00","insp_carrier_name":"CARLOS A HERNANDEZ","insp_carrier_street":"7241 FM 1094","insp_carrier_city":"SEALY","insp_carrier_state":"TX","insp_carrier_zip_code":"77474","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0192065","created_at":"2025-03-17T20:36:04.000000Z","updated_at":"2025-03-17T20:36:04.000000Z","inspection_violations":[{"id":10433619,"change_date":"2024-09-11 21:41:00","inspection_id":"82634575","insp_violation_id":"261746970","seq_no":"1","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"202875828","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:31.000000Z","updated_at":"2025-03-17T21:56:31.000000Z","normalized_code":"39360C"}],"inspection_per_units":[{"id":10807875,"change_date":"2024-09-11 21:41:00","inspection_id":"82634575","insp_unit_id":"202875828","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"924","insp_unit_license":"1M19082","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJBBCK96LU15437","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:53.000000Z","updated_at":"2025-03-17T23:34:53.000000Z"},{"id":10807876,"change_date":"2024-09-11 21:41:00","inspection_id":"82634575","insp_unit_id":"202875829","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"USTS","insp_unit_company":null,"insp_unit_license":"075B554","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1U9FA3825Y1051897","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:53.000000Z","updated_at":"2025-03-17T23:34:53.000000Z"}]},{"id":6371285,"change_date":"2024-08-01 21:41:00","inspection_id":"82281097","dot_number":"1952957","report_state":"TX","report_number":"6XDA9DCIW3","insp_date":"2024-07-30 00:00:00","insp_start_time":"1055","insp_end_time":"1120","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0010 IN HARRIS CO. (742-797","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HEIDELBERG MATERIALS","shipping_paper_number":"1992512597","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-08-01 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9339233","transaction_code":"A","transaction_date":"2024-08-01 00:00:00","upload_date":"2024-08-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01952957","upload_search_indicator":"M","census_search_date":"2024-08-01 21:41:00","snet_input_date":"2024-07-30 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-08-01 21:41:00","insp_carrier_name":"CARLOS A HERNANDEZ","insp_carrier_street":"7241 FM 1094","insp_carrier_city":"SEALY","insp_carrier_state":"TX","insp_carrier_zip_code":"77474","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0192065","created_at":"2025-03-17T20:29:06.000000Z","updated_at":"2025-03-17T20:29:06.000000Z","inspection_violations":[{"id":9891613,"change_date":"2024-08-01 21:41:00","inspection_id":"82281097","insp_violation_id":"260974541","seq_no":"1","part_no":"393","part_no_section":"55(d)(1)","insp_viol_unit":"1","insp_unit_id":"202197523","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:51.000000Z","updated_at":"2025-03-17T21:53:51.000000Z","normalized_code":"39355D1"},{"id":9891614,"change_date":"2024-08-01 21:41:00","inspection_id":"82281097","insp_violation_id":"260974542","seq_no":"3","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"202197524","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:51.000000Z","updated_at":"2025-03-17T21:53:51.000000Z","normalized_code":"39375C"},{"id":9891615,"change_date":"2024-08-01 21:41:00","inspection_id":"82281097","insp_violation_id":"260974543","seq_no":"4","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"202197524","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:51.000000Z","updated_at":"2025-03-17T21:53:51.000000Z","normalized_code":"39375C"}],"inspection_per_units":[{"id":10267239,"change_date":"2024-08-01 21:41:00","inspection_id":"82281097","insp_unit_id":"202197523","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"1L42486","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CK95LN37580","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:22.000000Z","updated_at":"2025-03-17T23:29:22.000000Z"},{"id":10267240,"change_date":"2024-08-01 21:41:00","inspection_id":"82281097","insp_unit_id":"202197524","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"105B905","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1T9FC39B7M1066871","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:22.000000Z","updated_at":"2025-03-17T23:29:22.000000Z"}]},{"id":6177890,"change_date":"2024-07-09 21:43:00","inspection_id":"82074047","dot_number":"1952957","report_state":"TX","report_number":"6WLA9DNA3K","insp_date":"2024-07-02 00:00:00","insp_start_time":"0930","insp_end_time":"1030","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0090 IN WALLER CO. (794-804","county_code_state":"TX","county_code":"473","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"XX","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-07-09 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"0","viol_total":"7","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9320969","transaction_code":"A","transaction_date":"2024-07-09 00:00:00","upload_date":"2024-07-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01952957","upload_search_indicator":"M","census_search_date":"2024-07-09 21:43:00","snet_input_date":"2024-07-02 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-07-09 21:43:00","insp_carrier_name":"CARLOS A HERNANDEZ","insp_carrier_street":"7241 FM 1094","insp_carrier_city":"SEALY","insp_carrier_state":"TX","insp_carrier_zip_code":"77474","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0192065","created_at":"2025-03-17T20:25:03.000000Z","updated_at":"2025-03-17T20:25:03.000000Z","inspection_violations":[{"id":9593781,"change_date":"2024-07-09 21:43:00","inspection_id":"82074047","insp_violation_id":"260547413","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"201801400","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:52:24.000000Z","updated_at":"2025-03-17T21:52:24.000000Z","normalized_code":"3963A1"},{"id":9593782,"change_date":"2024-07-09 21:43:00","inspection_id":"82074047","insp_violation_id":"260547414","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201801400","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:24.000000Z","updated_at":"2025-03-17T21:52:24.000000Z","normalized_code":"3939A"},{"id":9593783,"change_date":"2024-07-09 21:43:00","inspection_id":"82074047","insp_violation_id":"260547415","seq_no":"3","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"201801400","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:24.000000Z","updated_at":"2025-03-17T21:52:24.000000Z","normalized_code":"39395A"},{"id":9593784,"change_date":"2024-07-09 21:43:00","inspection_id":"82074047","insp_violation_id":"260547416","seq_no":"4","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"201801400","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:24.000000Z","updated_at":"2025-03-17T21:52:24.000000Z","normalized_code":"39345B2"},{"id":9593785,"change_date":"2024-07-09 21:43:00","inspection_id":"82074047","insp_violation_id":"260547417","seq_no":"5","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"201801401","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:24.000000Z","updated_at":"2025-03-17T21:52:24.000000Z","normalized_code":"39345B2"},{"id":9593786,"change_date":"2024-07-09 21:43:00","inspection_id":"82074047","insp_violation_id":"260547418","seq_no":"6","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"201801400","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:24.000000Z","updated_at":"2025-03-17T21:52:24.000000Z","normalized_code":"39353B"},{"id":9593787,"change_date":"2024-07-09 21:43:00","inspection_id":"82074047","insp_violation_id":"260547419","seq_no":"7","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"201801401","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:24.000000Z","updated_at":"2025-03-17T21:52:24.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":9952331,"change_date":"2024-07-09 21:43:00","inspection_id":"82074047","insp_unit_id":"201801400","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"921","insp_unit_license":"1L35682","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDD69X2SJ663421","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:08.000000Z","updated_at":"2025-03-17T23:26:08.000000Z"},{"id":9952332,"change_date":"2024-07-09 21:43:00","inspection_id":"82074047","insp_unit_id":"201801401","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CLEM","insp_unit_company":null,"insp_unit_license":"092B814","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1C9BB38B6SM110115","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:08.000000Z","updated_at":"2025-03-17T23:26:08.000000Z"}]},{"id":5600912,"change_date":"2024-04-25 21:43:00","inspection_id":"81448961","dot_number":"1952957","report_state":"TX","report_number":"V241364512","insp_date":"2024-04-23 00:00:00","insp_start_time":"0921","insp_end_time":"1040","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"KELLEY ST AT TX6 NB","county_code_state":"TX","county_code":"473","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CEMEX","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-04-25 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"8","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9257546","transaction_code":"A","transaction_date":"2024-04-25 00:00:00","upload_date":"2024-04-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01952957","upload_search_indicator":"M","census_search_date":"2024-04-25 21:43:00","snet_input_date":"2024-04-23 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-04-25 21:43:00","insp_carrier_name":"CARLOS A HERNANDEZ","insp_carrier_street":"7241 FM 1094","insp_carrier_city":"SEALY","insp_carrier_state":"TX","insp_carrier_zip_code":"77474","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0192065","created_at":"2025-03-17T20:13:50.000000Z","updated_at":"2025-03-17T20:13:50.000000Z","inspection_violations":[{"id":8660702,"change_date":"2024-04-25 21:43:00","inspection_id":"81448961","insp_violation_id":"259153229","seq_no":"1","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"1","insp_unit_id":"200584397","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:47:58.000000Z","updated_at":"2025-03-17T21:47:58.000000Z","normalized_code":"393207A"},{"id":8660703,"change_date":"2024-04-25 21:43:00","inspection_id":"81448961","insp_violation_id":"259153230","seq_no":"2","part_no":"393","part_no_section":"209(e)","insp_viol_unit":"1","insp_unit_id":"200584397","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:58.000000Z","updated_at":"2025-03-17T21:47:58.000000Z","normalized_code":"393209E"},{"id":8660704,"change_date":"2024-04-25 21:43:00","inspection_id":"81448961","insp_violation_id":"259153231","seq_no":"3","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"200584398","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:58.000000Z","updated_at":"2025-03-17T21:47:58.000000Z","normalized_code":"39345B2"},{"id":8660705,"change_date":"2024-04-25 21:43:00","inspection_id":"81448961","insp_violation_id":"259153232","seq_no":"4","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"200584397","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:58.000000Z","updated_at":"2025-03-17T21:47:58.000000Z","normalized_code":"39345B2"},{"id":8660706,"change_date":"2024-04-25 21:43:00","inspection_id":"81448961","insp_violation_id":"259153233","seq_no":"5","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"200584397","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:58.000000Z","updated_at":"2025-03-17T21:47:58.000000Z","normalized_code":"39345B2"},{"id":8660707,"change_date":"2024-04-25 21:43:00","inspection_id":"81448961","insp_violation_id":"259153234","seq_no":"6","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"200584397","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:58.000000Z","updated_at":"2025-03-17T21:47:58.000000Z","normalized_code":"39347E"},{"id":8660708,"change_date":"2024-04-25 21:43:00","inspection_id":"81448961","insp_violation_id":"259153235","seq_no":"7","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"200584398","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:58.000000Z","updated_at":"2025-03-17T21:47:58.000000Z","normalized_code":"39617C"},{"id":8660709,"change_date":"2024-04-25 21:43:00","inspection_id":"81448961","insp_violation_id":"259153236","seq_no":"8","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"200584397","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:58.000000Z","updated_at":"2025-03-17T21:47:58.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":9021877,"change_date":"2024-04-25 21:43:00","inspection_id":"81448961","insp_unit_id":"200584397","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"925","insp_unit_license":"1M16265","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD29X4WR759098","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:57.000000Z","updated_at":"2025-03-17T23:16:57.000000Z"},{"id":9021878,"change_date":"2024-04-25 21:43:00","inspection_id":"81448961","insp_unit_id":"200584398","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRVS","insp_unit_company":null,"insp_unit_license":"179B693","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1T91F3922X1247074","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:57.000000Z","updated_at":"2025-03-17T23:16:57.000000Z"}]},{"id":4656366,"change_date":"2024-12-06 21:44:00","inspection_id":"80417773","dot_number":"1952957","report_state":"TX","report_number":"6R0C9DLX0P","insp_date":"2023-12-14 00:00:00","insp_start_time":"1205","insp_end_time":"1247","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0069 IN FORT BEND CO. (95-1","county_code_state":"TX","county_code":"157","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":"2023-12-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9151280","transaction_code":"C","transaction_date":"2024-12-06 00:00:00","upload_date":"2024-12-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01952957","upload_search_indicator":"M","census_search_date":"2023-12-18 21:42:00","snet_input_date":"2023-12-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-12-18 21:42:00","insp_carrier_name":"CARLOS A HERNANDEZ","insp_carrier_street":"7241 FM 1094","insp_carrier_city":"SEALY","insp_carrier_state":"TX","insp_carrier_zip_code":"77474","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0192065","created_at":"2025-03-17T19:55:00.000000Z","updated_at":"2025-03-17T19:55:00.000000Z","inspection_violations":[{"id":7199028,"change_date":"2024-12-06 21:44:00","inspection_id":"80417773","insp_violation_id":"263291885","seq_no":"1","part_no":"396","part_no_section":"5B-HWSLOW","insp_viol_unit":"1","insp_unit_id":"204234709","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:45.000000Z","updated_at":"2025-03-17T21:40:45.000000Z","normalized_code":"3965BHWSLOW"},{"id":7199029,"change_date":"2024-12-06 21:44:00","inspection_id":"80417773","insp_violation_id":"263291886","seq_no":"2","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"204234709","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:45.000000Z","updated_at":"2025-03-17T21:40:45.000000Z","normalized_code":"3965B"},{"id":7199030,"change_date":"2024-12-06 21:44:00","inspection_id":"80417773","insp_violation_id":"263291887","seq_no":"3","part_no":"396","part_no_section":"3A1","insp_viol_unit":"2","insp_unit_id":"204234710","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:45.000000Z","updated_at":"2025-03-17T21:40:45.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":7489343,"change_date":"2024-12-06 21:44:00","inspection_id":"80417773","insp_unit_id":"204234709","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"923","insp_unit_license":"1L42486","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CK95LN37580","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:57.000000Z","updated_at":"2025-03-17T23:02:57.000000Z"},{"id":7489344,"change_date":"2024-12-06 21:44:00","inspection_id":"80417773","insp_unit_id":"204234710","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRST","insp_unit_company":"252","insp_unit_license":"105B905","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1T9FC39B7M1066871","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:57.000000Z","updated_at":"2025-03-17T23:02:57.000000Z"}]},{"id":4065092,"change_date":"2023-09-26 21:43:00","inspection_id":"79765228","dot_number":"1952957","report_state":"TX","report_number":"6OT59DCC6X","insp_date":"2023-09-26 00:00:00","insp_start_time":"0506","insp_end_time":"0527","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"17759  TOMBALL PKWY","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HALLETT - HEMPSTEAD PLANT","shipping_paper_number":"5002241","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-09-26 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"128000","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":"9086289","transaction_code":"A","transaction_date":"2023-09-26 00:00:00","upload_date":"2023-09-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01952957","upload_search_indicator":"M","census_search_date":"2023-09-26 21:43:00","snet_input_date":"2023-09-26 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-09-26 21:43:00","insp_carrier_name":"CARLOS A HERNANDEZ","insp_carrier_street":"7241 FM 1094","insp_carrier_city":"SEALY","insp_carrier_state":"TX","insp_carrier_zip_code":"77474","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0192065","created_at":"2025-03-17T19:43:10.000000Z","updated_at":"2025-03-17T19:43:10.000000Z","inspection_violations":[{"id":6293283,"change_date":"2023-09-26 21:43:00","inspection_id":"79765228","insp_violation_id":"255507080","seq_no":"1","part_no":"999","part_no_section":null,"insp_viol_unit":"1","insp_unit_id":"197259150","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:20.000000Z","updated_at":"2025-03-17T21:36:20.000000Z","normalized_code":"999"},{"id":6293284,"change_date":"2023-09-26 21:43:00","inspection_id":"79765228","insp_violation_id":"255507081","seq_no":"2","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"197259150","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:20.000000Z","updated_at":"2025-03-17T21:36:20.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":6536098,"change_date":"2023-09-26 21:43:00","inspection_id":"79765228","insp_unit_id":"197259150","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"922","insp_unit_license":"1L35683","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD69X41J865050","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:52.000000Z","updated_at":"2025-03-17T22:54:52.000000Z"},{"id":6536099,"change_date":"2023-09-26 21:43:00","inspection_id":"79765228","insp_unit_id":"197259151","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"156C142","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5MADN3928MH059211","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:52.000000Z","updated_at":"2025-03-17T22:54:52.000000Z"}]},{"id":3986310,"change_date":"2023-09-15 21:41:00","inspection_id":"79677603","dot_number":"1952957","report_state":"TX","report_number":"V231127416","insp_date":"2023-09-13 00:00:00","insp_start_time":"1000","insp_end_time":"1039","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"3031 AT E. STATE ST.","county_code_state":"TX","county_code":"089","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HEIDELBERG MATERIALS","shipping_paper_number":"707144983","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-09-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"124860","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":"9076139","transaction_code":"A","transaction_date":"2023-09-15 00:00:00","upload_date":"2023-09-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01952957","upload_search_indicator":"M","census_search_date":"2023-09-15 21:41:00","snet_input_date":"2023-09-13 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-09-15 21:41:00","insp_carrier_name":"CARLOS A HERNANDEZ","insp_carrier_street":"7241 FM 1094","insp_carrier_city":"SEALY","insp_carrier_state":"TX","insp_carrier_zip_code":"77474","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0192065","created_at":"2025-03-17T19:41:37.000000Z","updated_at":"2025-03-17T19:41:37.000000Z","inspection_violations":[{"id":6166303,"change_date":"2023-09-15 21:41:00","inspection_id":"79677603","insp_violation_id":"255305782","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"197086198","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:48.000000Z","updated_at":"2025-03-17T21:35:48.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":6409885,"change_date":"2023-09-15 21:41:00","inspection_id":"79677603","insp_unit_id":"197086198","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"921","insp_unit_license":"1L35682","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDD69X2SJ663421","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:48.000000Z","updated_at":"2025-03-17T22:53:48.000000Z"},{"id":6409886,"change_date":"2023-09-15 21:41:00","inspection_id":"79677603","insp_unit_id":"197086199","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CLEM","insp_unit_company":"0","insp_unit_license":"076B643","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1C9BB38B9XM110066","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:48.000000Z","updated_at":"2025-03-17T22:53:48.000000Z"}]},{"id":4295963,"change_date":"2023-10-26 21:42:00","inspection_id":"80020834","dot_number":"1952957","report_state":"TX","report_number":"6MU89DAY2B","insp_date":"2023-07-17 00:00:00","insp_start_time":"0750","insp_end_time":"0940","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"18000  KICKAPOO RD","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HALLETT MATERIALS","shipping_paper_number":"1017151","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-10-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"0","viol_total":"18","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"18","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9110492","transaction_code":"A","transaction_date":"2023-10-26 00:00:00","upload_date":"2023-10-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01952957","upload_search_indicator":"M","census_search_date":"2023-10-26 21:42:00","snet_input_date":"2023-07-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-10-26 21:42:00","insp_carrier_name":"CARLOS A HERNANDEZ","insp_carrier_street":"7241 FM 1094","insp_carrier_city":"SEALY","insp_carrier_state":"TX","insp_carrier_zip_code":"77474","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0192065","created_at":"2025-03-17T19:47:54.000000Z","updated_at":"2025-03-17T19:47:54.000000Z","inspection_violations":[{"id":6645270,"change_date":"2023-10-26 21:42:00","inspection_id":"80020834","insp_violation_id":"256072328","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197771806","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:01.000000Z","updated_at":"2025-03-17T21:38:01.000000Z","normalized_code":"3939A"},{"id":6645271,"change_date":"2023-10-26 21:42:00","inspection_id":"80020834","insp_violation_id":"256072329","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"197771806","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:01.000000Z","updated_at":"2025-03-17T21:38:01.000000Z","normalized_code":"39311"},{"id":6645272,"change_date":"2023-10-26 21:42:00","inspection_id":"80020834","insp_violation_id":"256072330","seq_no":"3","part_no":"393","part_no_section":"201(a)","insp_viol_unit":"2","insp_unit_id":"197771807","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:01.000000Z","updated_at":"2025-03-17T21:38:01.000000Z","normalized_code":"393201A"},{"id":6645273,"change_date":"2023-10-26 21:42:00","inspection_id":"80020834","insp_violation_id":"256072331","seq_no":"4","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"197771807","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:38:01.000000Z","updated_at":"2025-03-17T21:38:01.000000Z","normalized_code":"39375A3"},{"id":6645274,"change_date":"2023-10-26 21:42:00","inspection_id":"80020834","insp_violation_id":"256072332","seq_no":"5","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"197771806","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:01.000000Z","updated_at":"2025-03-17T21:38:01.000000Z","normalized_code":"3965B"},{"id":6645275,"change_date":"2023-10-26 21:42:00","inspection_id":"80020834","insp_violation_id":"256072333","seq_no":"6","part_no":"393","part_no_section":"83(g)","insp_viol_unit":"1","insp_unit_id":"197771806","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:01.000000Z","updated_at":"2025-03-17T21:38:01.000000Z","normalized_code":"39383G"},{"id":6645276,"change_date":"2023-10-26 21:42:00","inspection_id":"80020834","insp_violation_id":"256072334","seq_no":"7","part_no":"393","part_no_section":"28","insp_viol_unit":"1","insp_unit_id":"197771806","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:01.000000Z","updated_at":"2025-03-17T21:38:01.000000Z","normalized_code":"39328"},{"id":6645277,"change_date":"2023-10-26 21:42:00","inspection_id":"80020834","insp_violation_id":"256072335","seq_no":"8","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"197771806","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:01.000000Z","updated_at":"2025-03-17T21:38:01.000000Z","normalized_code":"39345B2"},{"id":6645278,"change_date":"2023-10-26 21:42:00","inspection_id":"80020834","insp_violation_id":"256072336","seq_no":"9","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"197771806","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:01.000000Z","updated_at":"2025-03-17T21:38:01.000000Z","normalized_code":"39347E"},{"id":6645279,"change_date":"2023-10-26 21:42:00","inspection_id":"80020834","insp_violation_id":"256072337","seq_no":"10","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"197771807","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:01.000000Z","updated_at":"2025-03-17T21:38:01.000000Z","normalized_code":"39347E"},{"id":6645280,"change_date":"2023-10-26 21:42:00","inspection_id":"80020834","insp_violation_id":"256072338","seq_no":"11","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"197771806","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:01.000000Z","updated_at":"2025-03-17T21:38:01.000000Z","normalized_code":"39353B"},{"id":6645281,"change_date":"2023-10-26 21:42:00","inspection_id":"80020834","insp_violation_id":"256072339","seq_no":"12","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"197771806","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:38:01.000000Z","updated_at":"2025-03-17T21:38:01.000000Z","normalized_code":"3963A1"},{"id":6645282,"change_date":"2023-10-26 21:42:00","inspection_id":"80020834","insp_violation_id":"256072340","seq_no":"13","part_no":"393","part_no_section":"47(g)","insp_viol_unit":"1","insp_unit_id":"197771806","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:01.000000Z","updated_at":"2025-03-17T21:38:01.000000Z","normalized_code":"39347G"},{"id":6645283,"change_date":"2023-10-26 21:42:00","inspection_id":"80020834","insp_violation_id":"256072341","seq_no":"14","part_no":"393","part_no_section":"47(g)","insp_viol_unit":"2","insp_unit_id":"197771807","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:01.000000Z","updated_at":"2025-03-17T21:38:01.000000Z","normalized_code":"39347G"},{"id":6645284,"change_date":"2023-10-26 21:42:00","inspection_id":"80020834","insp_violation_id":"256072342","seq_no":"15","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"197771807","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:01.000000Z","updated_at":"2025-03-17T21:38:01.000000Z","normalized_code":"39345B2"},{"id":6645285,"change_date":"2023-10-26 21:42:00","inspection_id":"80020834","insp_violation_id":"256072343","seq_no":"16","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"197771806","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:38:01.000000Z","updated_at":"2025-03-17T21:38:01.000000Z","normalized_code":"3963A1"},{"id":6645286,"change_date":"2023-10-26 21:42:00","inspection_id":"80020834","insp_violation_id":"256072344","seq_no":"17","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"197771806","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:01.000000Z","updated_at":"2025-03-17T21:38:01.000000Z","normalized_code":"39375C"},{"id":6645287,"change_date":"2023-10-26 21:42:00","inspection_id":"80020834","insp_violation_id":"256072345","seq_no":"18","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"197771806","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:01.000000Z","updated_at":"2025-03-17T21:38:01.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":6909128,"change_date":"2023-10-26 21:42:00","inspection_id":"80020834","insp_unit_id":"197771806","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"923","insp_unit_license":"1M33708","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP7DB9X33D809180","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:55.000000Z","updated_at":"2025-03-17T22:57:55.000000Z"},{"id":6909129,"change_date":"2023-10-26 21:42:00","inspection_id":"80020834","insp_unit_id":"197771807","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRST","insp_unit_company":"3","insp_unit_license":"105B905","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1T9FC39B7M1066871","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:55.000000Z","updated_at":"2025-03-17T22:57:55.000000Z"}]},{"id":3204534,"change_date":"2023-06-07 21:43:00","inspection_id":"78801530","dot_number":"1952957","report_state":"TX","report_number":"V231038446","insp_date":"2023-05-31 00:00:00","insp_start_time":"0740","insp_end_time":"0759","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH36 SB","county_code_state":"TX","county_code":"015","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HALLETT MATERIALS","shipping_paper_number":"1012182","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-06-02 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"8994968","transaction_code":"C","transaction_date":"2023-06-07 00:00:00","upload_date":"2023-06-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01952957","upload_search_indicator":"M","census_search_date":"2023-06-02 21:42:00","snet_input_date":"2023-05-31 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-06-02 21:42:00","insp_carrier_name":"CARLOS A HERNANDEZ","insp_carrier_street":"7241 FM 1094","insp_carrier_city":"SEALY","insp_carrier_state":"TX","insp_carrier_zip_code":"77474","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0192065","created_at":"2025-03-17T19:26:27.000000Z","updated_at":"2025-03-17T19:26:27.000000Z","inspection_violations":[{"id":4937371,"change_date":"2023-06-07 21:43:00","inspection_id":"78801530","insp_violation_id":"253374361","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195385813","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:57.000000Z","updated_at":"2025-03-17T21:29:57.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":5154187,"change_date":"2023-06-07 21:43:00","inspection_id":"78801530","insp_unit_id":"195385813","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"924","insp_unit_license":"1M19082","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJBBCK96LU15437","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:36.000000Z","updated_at":"2025-03-17T22:43:36.000000Z"},{"id":5154188,"change_date":"2023-06-07 21:43:00","inspection_id":"78801530","insp_unit_id":"195385814","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"USTS","insp_unit_company":"924","insp_unit_license":"075B554","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1U9FA3825Y1051897","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:36.000000Z","updated_at":"2025-03-17T22:43:36.000000Z"}]},{"id":2864971,"change_date":"2023-06-05 21:43:00","inspection_id":"78417806","dot_number":"1952957","report_state":"TX","report_number":"V231016079","insp_date":"2023-04-19 00:00:00","insp_start_time":"0612","insp_end_time":"0633","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH159","county_code_state":"TX","county_code":"473","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HALLETT MATERIALS","shipping_paper_number":"1008195","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-04-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"116000","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":"8960699","transaction_code":"C","transaction_date":"2023-06-05 00:00:00","upload_date":"2023-06-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01952957","upload_search_indicator":"M","census_search_date":"2023-04-21 21:41:00","snet_input_date":"2023-04-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-04-21 21:41:00","insp_carrier_name":"CARLOS A HERNANDEZ","insp_carrier_street":"7241 FM 1094","insp_carrier_city":"SEALY","insp_carrier_state":"TX","insp_carrier_zip_code":"77474","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0192065","created_at":"2025-03-17T19:19:39.000000Z","updated_at":"2025-03-17T19:19:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4609817,"change_date":"2023-06-05 21:43:00","inspection_id":"78417806","insp_unit_id":"195326234","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"925","insp_unit_license":"1M16265","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD29X4WR759098","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:20.000000Z","updated_at":"2025-03-17T22:39:20.000000Z"},{"id":4609818,"change_date":"2023-06-05 21:43:00","inspection_id":"78417806","insp_unit_id":"195326235","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRVS","insp_unit_company":"925","insp_unit_license":"2691FR","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1T91F3922X1247074","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:20.000000Z","updated_at":"2025-03-17T22:39:20.000000Z"}]},{"id":2658886,"change_date":"2023-03-24 21:41:00","inspection_id":"78183290","dot_number":"1952957","report_state":"TX","report_number":"6JM99DBTIL","insp_date":"2023-03-23 00:00:00","insp_start_time":"0950","insp_end_time":"1015","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"6600  NAVIGATION BLV","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-03-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"148000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8937507","transaction_code":"A","transaction_date":"2023-03-24 00:00:00","upload_date":"2023-03-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01952957","upload_search_indicator":"M","census_search_date":"2023-03-24 21:41:00","snet_input_date":"2023-03-23 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-03-24 21:41:00","insp_carrier_name":"CARLOS A HERNANDEZ","insp_carrier_street":"7241 FM 1094","insp_carrier_city":"SEALY","insp_carrier_state":"TX","insp_carrier_zip_code":"77474","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0192065","created_at":"2025-03-17T19:15:35.000000Z","updated_at":"2025-03-17T19:15:35.000000Z","inspection_violations":[{"id":4087480,"change_date":"2023-03-24 21:41:00","inspection_id":"78183290","insp_violation_id":"251865702","seq_no":"1","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"194060386","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:08.000000Z","updated_at":"2025-03-17T21:26:08.000000Z","normalized_code":"39375C"},{"id":4087481,"change_date":"2023-03-24 21:41:00","inspection_id":"78183290","insp_violation_id":"251865703","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"194060385","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:08.000000Z","updated_at":"2025-03-17T21:26:08.000000Z","normalized_code":"39617C"},{"id":4087482,"change_date":"2023-03-24 21:41:00","inspection_id":"78183290","insp_violation_id":"251865704","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"194060386","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:08.000000Z","updated_at":"2025-03-17T21:26:08.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":4280861,"change_date":"2023-03-24 21:41:00","inspection_id":"78183290","insp_unit_id":"194060385","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"1M16265","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD29X4WR759098","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:43.000000Z","updated_at":"2025-03-17T22:36:43.000000Z"},{"id":4280862,"change_date":"2023-03-24 21:41:00","inspection_id":"78183290","insp_unit_id":"194060386","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRVS","insp_unit_company":null,"insp_unit_license":"2691FR","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1T91F3922X1247074","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:43.000000Z","updated_at":"2025-03-17T22:36:43.000000Z"}]},{"id":2417218,"change_date":"2023-02-21 21:42:00","inspection_id":"77908844","dot_number":"1952957","report_state":"TX","report_number":"6IM79DBCBY","insp_date":"2023-02-15 00:00:00","insp_start_time":"0704","insp_end_time":"0752","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":"CEMEX (CUTTEN RD)","shipping_paper_number":"3835","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-02-21 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"0","viol_total":"9","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"9","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8908738","transaction_code":"A","transaction_date":"2023-02-21 00:00:00","upload_date":"2023-02-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01952957","upload_search_indicator":"M","census_search_date":"2023-02-21 21:42:00","snet_input_date":"2023-02-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-02-21 21:42:00","insp_carrier_name":"CARLOS A HERNANDEZ","insp_carrier_street":"7241 FM 1094","insp_carrier_city":"SEALY","insp_carrier_state":"TX","insp_carrier_zip_code":"77474","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0192065","created_at":"2025-03-17T19:11:06.000000Z","updated_at":"2025-03-17T19:11:06.000000Z","inspection_violations":[{"id":3720941,"change_date":"2023-02-21 21:42:00","inspection_id":"77908844","insp_violation_id":"251253247","seq_no":"1","part_no":"393","part_no_section":"55(d)(1)","insp_viol_unit":"1","insp_unit_id":"193505588","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:34.000000Z","updated_at":"2025-03-17T21:24:34.000000Z","normalized_code":"39355D1"},{"id":3720942,"change_date":"2023-02-21 21:42:00","inspection_id":"77908844","insp_violation_id":"251253248","seq_no":"2","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"193505588","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:34.000000Z","updated_at":"2025-03-17T21:24:34.000000Z","normalized_code":"39345B2"},{"id":3720943,"change_date":"2023-02-21 21:42:00","inspection_id":"77908844","insp_violation_id":"251253249","seq_no":"3","part_no":"393","part_no_section":"47(g)","insp_viol_unit":"1","insp_unit_id":"193505588","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:34.000000Z","updated_at":"2025-03-17T21:24:34.000000Z","normalized_code":"39347G"},{"id":3720944,"change_date":"2023-02-21 21:42:00","inspection_id":"77908844","insp_violation_id":"251253250","seq_no":"4","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"193505588","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:34.000000Z","updated_at":"2025-03-17T21:24:34.000000Z","normalized_code":"39345B2"},{"id":3720945,"change_date":"2023-02-21 21:42:00","inspection_id":"77908844","insp_violation_id":"251253251","seq_no":"5","part_no":"393","part_no_section":"47(g)","insp_viol_unit":"2","insp_unit_id":"193505589","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:34.000000Z","updated_at":"2025-03-17T21:24:34.000000Z","normalized_code":"39347G"},{"id":3720946,"change_date":"2023-02-21 21:42:00","inspection_id":"77908844","insp_violation_id":"251253252","seq_no":"6","part_no":"393","part_no_section":"47(g)","insp_viol_unit":"2","insp_unit_id":"193505589","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:34.000000Z","updated_at":"2025-03-17T21:24:34.000000Z","normalized_code":"39347G"},{"id":3720947,"change_date":"2023-02-21 21:42:00","inspection_id":"77908844","insp_violation_id":"251253253","seq_no":"7","part_no":"393","part_no_section":"47(g)","insp_viol_unit":"1","insp_unit_id":"193505588","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:34.000000Z","updated_at":"2025-03-17T21:24:34.000000Z","normalized_code":"39347G"},{"id":3720948,"change_date":"2023-02-21 21:42:00","inspection_id":"77908844","insp_violation_id":"251253254","seq_no":"8","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"193505588","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:34.000000Z","updated_at":"2025-03-17T21:24:34.000000Z","normalized_code":"3965B"},{"id":3720949,"change_date":"2023-02-21 21:42:00","inspection_id":"77908844","insp_violation_id":"251253255","seq_no":"9","part_no":"393","part_no_section":"83(g)","insp_viol_unit":"1","insp_unit_id":"193505588","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:34.000000Z","updated_at":"2025-03-17T21:24:34.000000Z","normalized_code":"39383G"}],"inspection_per_units":[{"id":3890302,"change_date":"2023-02-21 21:42:00","inspection_id":"77908844","insp_unit_id":"193505588","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"922","insp_unit_license":"1L35683","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD69X41J865050","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:52.000000Z","updated_at":"2025-03-17T22:33:52.000000Z"},{"id":3890303,"change_date":"2023-02-21 21:42:00","inspection_id":"77908844","insp_unit_id":"193505589","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MACL","insp_unit_company":"922","insp_unit_license":"156C142","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5MADN3928MH059211","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:52.000000Z","updated_at":"2025-03-17T22:33:52.000000Z"}]},{"id":2228798,"change_date":"2023-01-25 21:43:00","inspection_id":"77693963","dot_number":"1952957","report_state":"TX","report_number":"6HS69DBB0E","insp_date":"2023-01-16 00:00:00","insp_start_time":"0635","insp_end_time":"0708","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"6500 N ELDRIDGE PKWY","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HANSON","shipping_paper_number":"6100101170","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-01-25 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"103000","viol_total":"4","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8887541","transaction_code":"A","transaction_date":"2023-01-25 00:00:00","upload_date":"2023-01-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01952957","upload_search_indicator":"M","census_search_date":"2023-01-25 21:43:00","snet_input_date":"2023-01-16 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-01-25 21:43:00","insp_carrier_name":"CARLOS A HERNANDEZ","insp_carrier_street":"7241 FM 1094","insp_carrier_city":"SEALY","insp_carrier_state":"TX","insp_carrier_zip_code":"77474","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0192065","created_at":"2025-03-17T19:07:44.000000Z","updated_at":"2025-03-17T19:07:44.000000Z","inspection_violations":[{"id":3443174,"change_date":"2023-01-25 21:43:00","inspection_id":"77693963","insp_violation_id":"250783278","seq_no":"3","part_no":"393","part_no_section":"79","insp_viol_unit":"1","insp_unit_id":"193069938","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:18.000000Z","updated_at":"2025-03-17T21:23:18.000000Z","normalized_code":"39379"},{"id":3443175,"change_date":"2023-01-25 21:43:00","inspection_id":"77693963","insp_violation_id":"250783279","seq_no":"4","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"193069939","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:23:18.000000Z","updated_at":"2025-03-17T21:23:18.000000Z","normalized_code":"39348A"},{"id":3443176,"change_date":"2023-01-25 21:43:00","inspection_id":"77693963","insp_violation_id":"250783280","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:18.000000Z","updated_at":"2025-03-17T21:23:18.000000Z","normalized_code":"3922"},{"id":3443177,"change_date":"2023-01-25 21:43:00","inspection_id":"77693963","insp_violation_id":"250783281","seq_no":"2","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"193069938","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:18.000000Z","updated_at":"2025-03-17T21:23:18.000000Z","normalized_code":"39360C"}],"inspection_per_units":[{"id":3587484,"change_date":"2023-01-25 21:43:00","inspection_id":"77693963","insp_unit_id":"193069938","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"1M33708","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP7DB9X33D809180","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:43.000000Z","updated_at":"2025-03-17T22:31:43.000000Z"},{"id":3587485,"change_date":"2023-01-25 21:43:00","inspection_id":"77693963","insp_unit_id":"193069939","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"105B905","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1T9FC39B7M1066871","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:43.000000Z","updated_at":"2025-03-17T22:31:43.000000Z"}]},{"id":2218970,"change_date":"2023-01-24 21:43:00","inspection_id":"77682743","dot_number":"1952957","report_state":"TX","report_number":"6HI89DBC8X","insp_date":"2023-01-06 00:00:00","insp_start_time":"0855","insp_end_time":"0909","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":"4","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HALLETT MATERIALS","shipping_paper_number":"37445","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-01-24 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"0","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":"8885105","transaction_code":"A","transaction_date":"2023-01-24 00:00:00","upload_date":"2023-01-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01952957","upload_search_indicator":"M","census_search_date":"2023-01-24 21:43:00","snet_input_date":"2023-01-06 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-01-24 21:43:00","insp_carrier_name":"CARLOS A HERNANDEZ","insp_carrier_street":"7241 FM 1094","insp_carrier_city":"SEALY","insp_carrier_state":"TX","insp_carrier_zip_code":"77474","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0192065","created_at":"2025-03-17T19:07:24.000000Z","updated_at":"2025-03-17T19:07:24.000000Z","inspection_violations":[{"id":3427264,"change_date":"2023-01-24 21:43:00","inspection_id":"77682743","insp_violation_id":"250756528","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:13.000000Z","updated_at":"2025-03-17T21:23:13.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3571508,"change_date":"2023-01-24 21:43:00","inspection_id":"77682743","insp_unit_id":"193045018","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"921","insp_unit_license":"1L35682","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDD69X2SJ663421","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:37.000000Z","updated_at":"2025-03-17T22:31:37.000000Z"},{"id":3571509,"change_date":"2023-01-24 21:43:00","inspection_id":"77682743","insp_unit_id":"193045019","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CLEM","insp_unit_company":null,"insp_unit_license":"076B643","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1C9BB38B9XM110066","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:37.000000Z","updated_at":"2025-03-17T22:31:37.000000Z"}]},{"id":1746197,"change_date":"2022-11-15 21:40:00","inspection_id":"77141421","dot_number":"1952957","report_state":"TX","report_number":"6FYA9DBH3F","insp_date":"2022-11-11 00:00:00","insp_start_time":"1011","insp_end_time":"1045","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":"HALLETT MATERIALS","shipping_paper_number":"33772","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-11-15 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","viol_total":"8","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8828031","transaction_code":"A","transaction_date":"2022-11-15 00:00:00","upload_date":"2022-11-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01952957","upload_search_indicator":"M","census_search_date":"2022-11-15 21:40:00","snet_input_date":"2022-11-11 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-11-15 21:40:00","insp_carrier_name":"CARLOS A HERNANDEZ","insp_carrier_street":"7241 FM 1094","insp_carrier_city":"SEALY","insp_carrier_state":"TX","insp_carrier_zip_code":"77474","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0192065","created_at":"2025-03-17T18:58:55.000000Z","updated_at":"2025-03-17T18:58:55.000000Z","inspection_violations":[{"id":2735241,"change_date":"2022-11-15 21:40:00","inspection_id":"77141421","insp_violation_id":"249616626","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"191970651","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:52.000000Z","updated_at":"2025-03-17T21:19:52.000000Z","normalized_code":"3922"},{"id":2735242,"change_date":"2022-11-15 21:40:00","inspection_id":"77141421","insp_violation_id":"249616627","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191970650","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:52.000000Z","updated_at":"2025-03-17T21:19:52.000000Z","normalized_code":"3939A"},{"id":2735243,"change_date":"2022-11-15 21:40:00","inspection_id":"77141421","insp_violation_id":"249616628","seq_no":"3","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"191970650","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:52.000000Z","updated_at":"2025-03-17T21:19:52.000000Z","normalized_code":"39360C"},{"id":2735244,"change_date":"2022-11-15 21:40:00","inspection_id":"77141421","insp_violation_id":"249616629","seq_no":"5","part_no":"393","part_no_section":"28","insp_viol_unit":"2","insp_unit_id":"191970651","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:52.000000Z","updated_at":"2025-03-17T21:19:52.000000Z","normalized_code":"39328"},{"id":2735245,"change_date":"2022-11-15 21:40:00","inspection_id":"77141421","insp_violation_id":"249616630","seq_no":"6","part_no":"393","part_no_section":"83(g)","insp_viol_unit":"1","insp_unit_id":"191970650","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:52.000000Z","updated_at":"2025-03-17T21:19:52.000000Z","normalized_code":"39383G"},{"id":2735246,"change_date":"2022-11-15 21:40:00","inspection_id":"77141421","insp_violation_id":"249616631","seq_no":"7","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"191970650","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:52.000000Z","updated_at":"2025-03-17T21:19:52.000000Z","normalized_code":"3965B"},{"id":2735247,"change_date":"2022-11-15 21:40:00","inspection_id":"77141421","insp_violation_id":"249616632","seq_no":"8","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"191970650","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:52.000000Z","updated_at":"2025-03-17T21:19:52.000000Z","normalized_code":"39345B2"},{"id":2735248,"change_date":"2022-11-15 21:40:00","inspection_id":"77141421","insp_violation_id":"249616633","seq_no":"4","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"191970651","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:52.000000Z","updated_at":"2025-03-17T21:19:52.000000Z","normalized_code":"39355E"}],"inspection_per_units":[{"id":2809973,"change_date":"2022-11-15 21:40:00","inspection_id":"77141421","insp_unit_id":"191970650","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"925","insp_unit_license":"1M16265","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD29X4WR759098","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:13.000000Z","updated_at":"2025-03-17T22:26:13.000000Z"},{"id":2809974,"change_date":"2022-11-15 21:40:00","inspection_id":"77141421","insp_unit_id":"191970651","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRVS","insp_unit_company":"T850","insp_unit_license":"2691FR","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1T91F3922X1247074","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:13.000000Z","updated_at":"2025-03-17T22:26:13.000000Z"}]},{"id":1710612,"change_date":"2022-11-09 21:41:00","inspection_id":"77100702","dot_number":"1952957","report_state":"TX","report_number":"6FU39DAXJK","insp_date":"2022-11-07 00:00:00","insp_start_time":"0345","insp_end_time":"0400","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":"4","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"G J TRUCKING","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":"Y","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2022-11-09 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"0","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":"8823464","transaction_code":"A","transaction_date":"2022-11-09 00:00:00","upload_date":"2022-11-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01952957","upload_search_indicator":"M","census_search_date":"2022-11-09 21:41:00","snet_input_date":"2022-11-07 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-11-09 21:41:00","insp_carrier_name":"CARLOS A HERNANDEZ","insp_carrier_street":"7241 FM 1094","insp_carrier_city":"SEALY","insp_carrier_state":"TX","insp_carrier_zip_code":"77474","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0192065","created_at":"2025-03-17T18:58:12.000000Z","updated_at":"2025-03-17T18:58:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2752014,"change_date":"2022-11-09 21:41:00","inspection_id":"77100702","insp_unit_id":"191890828","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"921","insp_unit_license":"1L35682","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDD69X2SJ663421","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:50.000000Z","updated_at":"2025-03-17T22:25:50.000000Z"},{"id":2752015,"change_date":"2022-11-09 21:41:00","inspection_id":"77100702","insp_unit_id":"191890829","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CLEM","insp_unit_company":"921","insp_unit_license":"076B643","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1C9BB38B9XM110066","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:50.000000Z","updated_at":"2025-03-17T22:25:50.000000Z"}]},{"id":1650093,"change_date":"2022-11-04 21:38:00","inspection_id":"77031355","dot_number":"1952957","report_state":"TX","report_number":"6FN90XVRJZ","insp_date":"2022-10-31 00:00:00","insp_start_time":"0849","insp_end_time":"0921","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM-2920 IN HARRIS CO. (646-676","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HALETT MATERIALS","shipping_paper_number":"32619","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-11-01 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8816467","transaction_code":"C","transaction_date":"2022-11-04 00:00:00","upload_date":"2022-11-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01952957","upload_search_indicator":"M","census_search_date":"2022-11-01 21:41:00","snet_input_date":"2022-10-31 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-11-01 21:41:00","insp_carrier_name":"CARLOS A HERNANDEZ","insp_carrier_street":"7241 FM 1094","insp_carrier_city":"SEALY","insp_carrier_state":"TX","insp_carrier_zip_code":"77474","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0192065","created_at":"2025-03-17T18:57:04.000000Z","updated_at":"2025-03-17T18:57:04.000000Z","inspection_violations":[{"id":2590799,"change_date":"2022-11-04 21:38:00","inspection_id":"77031355","insp_violation_id":"249449541","seq_no":"1","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"191820772","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:12.000000Z","updated_at":"2025-03-17T21:19:12.000000Z","normalized_code":"39375C"},{"id":2590800,"change_date":"2022-11-04 21:38:00","inspection_id":"77031355","insp_violation_id":"249449542","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"191820772","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:12.000000Z","updated_at":"2025-03-17T21:19:12.000000Z","normalized_code":"3922"},{"id":2590801,"change_date":"2022-11-04 21:38:00","inspection_id":"77031355","insp_violation_id":"249449543","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191820771","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:12.000000Z","updated_at":"2025-03-17T21:19:12.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":2655312,"change_date":"2022-11-04 21:38:00","inspection_id":"77031355","insp_unit_id":"191820771","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"925","insp_unit_license":"1M16265","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD29X4WR759098","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:13.000000Z","updated_at":"2025-03-17T22:25:13.000000Z"},{"id":2655313,"change_date":"2022-11-04 21:38:00","inspection_id":"77031355","insp_unit_id":"191820772","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRVS","insp_unit_company":"850","insp_unit_license":"2691FR","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1T91F3922X1247074","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:13.000000Z","updated_at":"2025-03-17T22:25:13.000000Z"}]},{"id":1554543,"change_date":"2022-10-19 21:41:00","inspection_id":"76921583","dot_number":"1952957","report_state":"TX","report_number":"6F6B9DBC50","insp_date":"2022-10-14 00:00:00","insp_start_time":"1148","insp_end_time":"1205","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":"4","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HALLETT MATERIALS","shipping_paper_number":"30847","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2022-10-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"0","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":"8805284","transaction_code":"A","transaction_date":"2022-10-19 00:00:00","upload_date":"2022-10-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01952957","upload_search_indicator":"M","census_search_date":"2022-10-19 21:41:00","snet_input_date":"2022-10-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-10-19 21:41:00","insp_carrier_name":"CARLOS A HERNANDEZ","insp_carrier_street":"7241 FM 1094","insp_carrier_city":"SEALY","insp_carrier_state":"TX","insp_carrier_zip_code":"77474","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0192065","created_at":"2025-03-17T18:55:14.000000Z","updated_at":"2025-03-17T18:55:14.000000Z","inspection_violations":[{"id":2445347,"change_date":"2022-10-19 21:41:00","inspection_id":"76921583","insp_violation_id":"249133370","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:27.000000Z","updated_at":"2025-03-17T21:18:27.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2501558,"change_date":"2022-10-19 21:41:00","inspection_id":"76921583","insp_unit_id":"191534515","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"921","insp_unit_license":"1L35682","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDD69X2SJ663421","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:09.000000Z","updated_at":"2025-03-17T22:24:09.000000Z"},{"id":2501559,"change_date":"2022-10-19 21:41:00","inspection_id":"76921583","insp_unit_id":"191534516","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CLEM","insp_unit_company":null,"insp_unit_license":"076B643","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1C9BB38B9XM110066","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:09.000000Z","updated_at":"2025-03-17T22:24:09.000000Z"}]},{"id":1440971,"change_date":"2022-10-04 21:41:00","inspection_id":"76790034","dot_number":"1952957","report_state":"TX","report_number":"6ES69DBC3Q","insp_date":"2022-09-30 00:00:00","insp_start_time":"0632","insp_end_time":"0643","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":"4","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CEMEX ( CUTTEN RD )","shipping_paper_number":"28829","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2022-10-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"0","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":"8789941","transaction_code":"A","transaction_date":"2022-10-04 00:00:00","upload_date":"2022-10-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01952957","upload_search_indicator":"M","census_search_date":"2022-10-04 21:41:00","snet_input_date":"2022-09-30 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-10-04 21:41:00","insp_carrier_name":"CARLOS A HERNANDEZ","insp_carrier_street":"7241 FM 1094","insp_carrier_city":"SEALY","insp_carrier_state":"TX","insp_carrier_zip_code":"77474","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0192065","created_at":"2025-03-17T18:53:22.000000Z","updated_at":"2025-03-17T18:53:22.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2319843,"change_date":"2022-10-04 21:41:00","inspection_id":"76790034","insp_unit_id":"191269075","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"922","insp_unit_license":"1L35683","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD69X41J865050","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:52.000000Z","updated_at":"2025-03-17T22:22:52.000000Z"},{"id":2319844,"change_date":"2022-10-04 21:41:00","inspection_id":"76790034","insp_unit_id":"191269076","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MACL","insp_unit_company":null,"insp_unit_license":"156C142","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5MADN3928MH059211","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:52.000000Z","updated_at":"2025-03-17T22:22:52.000000Z"}]},{"id":1520087,"change_date":"2022-10-14 21:39:00","inspection_id":"76881912","dot_number":"1952957","report_state":"TX","report_number":"6EO79DBC36","insp_date":"2022-09-26 00:00:00","insp_start_time":"0751","insp_end_time":"0908","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM-0529 IN HARRIS CO. (658-672","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HANSON","shipping_paper_number":"685087287","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-14 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"0","viol_total":"11","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"11","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8800100","transaction_code":"A","transaction_date":"2022-10-14 00:00:00","upload_date":"2022-10-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01952957","upload_search_indicator":"M","census_search_date":"2022-10-14 21:39:00","snet_input_date":"2022-09-26 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-10-14 21:39:00","insp_carrier_name":"CARLOS A HERNANDEZ","insp_carrier_street":"7241 FM 1094","insp_carrier_city":"SEALY","insp_carrier_state":"TX","insp_carrier_zip_code":"77474","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0192065","created_at":"2025-03-17T18:54:47.000000Z","updated_at":"2025-03-17T18:54:47.000000Z","inspection_violations":[{"id":2394814,"change_date":"2022-10-14 21:39:00","inspection_id":"76881912","insp_violation_id":"249046056","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"191453579","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:02.000000Z","updated_at":"2025-03-17T21:18:02.000000Z","normalized_code":"39347E"},{"id":2394815,"change_date":"2022-10-14 21:39:00","inspection_id":"76881912","insp_violation_id":"249046057","seq_no":"2","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"191453579","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:02.000000Z","updated_at":"2025-03-17T21:18:02.000000Z","normalized_code":"39353B"},{"id":2394816,"change_date":"2022-10-14 21:39:00","inspection_id":"76881912","insp_violation_id":"249046058","seq_no":"3","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"191453579","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:02.000000Z","updated_at":"2025-03-17T21:18:02.000000Z","normalized_code":"39360C"},{"id":2394817,"change_date":"2022-10-14 21:39:00","inspection_id":"76881912","insp_violation_id":"249046059","seq_no":"5","part_no":"393","part_no_section":"83(g)","insp_viol_unit":"1","insp_unit_id":"191453579","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:02.000000Z","updated_at":"2025-03-17T21:18:02.000000Z","normalized_code":"39383G"},{"id":2394818,"change_date":"2022-10-14 21:39:00","inspection_id":"76881912","insp_violation_id":"249046060","seq_no":"6","part_no":"393","part_no_section":"83(h)","insp_viol_unit":"1","insp_unit_id":"191453579","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:02.000000Z","updated_at":"2025-03-17T21:18:02.000000Z","normalized_code":"39383H"},{"id":2394819,"change_date":"2022-10-14 21:39:00","inspection_id":"76881912","insp_violation_id":"249046061","seq_no":"7","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"191453579","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:18:02.000000Z","updated_at":"2025-03-17T21:18:02.000000Z","normalized_code":"39345B2"},{"id":2394820,"change_date":"2022-10-14 21:39:00","inspection_id":"76881912","insp_violation_id":"249046062","seq_no":"8","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"191453579","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:02.000000Z","updated_at":"2025-03-17T21:18:02.000000Z","normalized_code":"39345"},{"id":2394821,"change_date":"2022-10-14 21:39:00","inspection_id":"76881912","insp_violation_id":"249046063","seq_no":"9","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"191453580","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:18:02.000000Z","updated_at":"2025-03-17T21:18:02.000000Z","normalized_code":"39345B2"},{"id":2394822,"change_date":"2022-10-14 21:39:00","inspection_id":"76881912","insp_violation_id":"249046064","seq_no":"10","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"191453580","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:02.000000Z","updated_at":"2025-03-17T21:18:02.000000Z","normalized_code":"39345B2"},{"id":2394823,"change_date":"2022-10-14 21:39:00","inspection_id":"76881912","insp_violation_id":"249046065","seq_no":"11","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"191453580","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:02.000000Z","updated_at":"2025-03-17T21:18:02.000000Z","normalized_code":"3939A"},{"id":2394824,"change_date":"2022-10-14 21:39:00","inspection_id":"76881912","insp_violation_id":"249046066","seq_no":"12","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"191453579","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:02.000000Z","updated_at":"2025-03-17T21:18:02.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":2446422,"change_date":"2022-10-14 21:39:00","inspection_id":"76881912","insp_unit_id":"191453579","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"923","insp_unit_license":"1M33708","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP7DB9X33D809180","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:46.000000Z","updated_at":"2025-03-17T22:23:46.000000Z"},{"id":2446423,"change_date":"2022-10-14 21:39:00","inspection_id":"76881912","insp_unit_id":"191453580","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRST","insp_unit_company":"252","insp_unit_license":"105B905","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1T9FC39B7M1066871","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:46.000000Z","updated_at":"2025-03-17T22:23:46.000000Z"}]},{"id":1469062,"change_date":"2022-10-07 21:39:00","inspection_id":"76822876","dot_number":"1952957","report_state":"TX","report_number":"6EIC9DGPD7","insp_date":"2022-09-20 00:00:00","insp_start_time":"1157","insp_end_time":"1220","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"100  SORTERS MCCLELL","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2022-10-07 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8793188","transaction_code":"A","transaction_date":"2022-10-07 00:00:00","upload_date":"2022-10-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01952957","upload_search_indicator":"M","census_search_date":"2022-10-07 21:39:00","snet_input_date":"2022-09-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-10-07 21:39:00","insp_carrier_name":"CARLOS A HERNANDEZ","insp_carrier_street":"7241 FM 1094","insp_carrier_city":"SEALY","insp_carrier_state":"TX","insp_carrier_zip_code":"77474","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0192065","created_at":"2025-03-17T18:53:47.000000Z","updated_at":"2025-03-17T18:53:47.000000Z","inspection_violations":[{"id":2314303,"change_date":"2022-10-07 21:39:00","inspection_id":"76822876","insp_violation_id":"248907031","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"191335094","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:36.000000Z","updated_at":"2025-03-17T21:17:36.000000Z","normalized_code":"39378"},{"id":2314304,"change_date":"2022-10-07 21:39:00","inspection_id":"76822876","insp_violation_id":"248907032","seq_no":"2","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"191335094","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:36.000000Z","updated_at":"2025-03-17T21:17:36.000000Z","normalized_code":"39021A"},{"id":2314305,"change_date":"2022-10-07 21:39:00","inspection_id":"76822876","insp_violation_id":"248907033","seq_no":"3","part_no":"393","part_no_section":"203(c)","insp_viol_unit":"1","insp_unit_id":"191335094","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:36.000000Z","updated_at":"2025-03-17T21:17:36.000000Z","normalized_code":"393203C"}],"inspection_per_units":[{"id":2365323,"change_date":"2022-10-07 21:39:00","inspection_id":"76822876","insp_unit_id":"191335094","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"922","insp_unit_license":"1L35683","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD69X41J865050","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:13.000000Z","updated_at":"2025-03-17T22:23:13.000000Z"},{"id":2365324,"change_date":"2022-10-07 21:39:00","inspection_id":"76822876","insp_unit_id":"191335095","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"156C142","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5MADN3928MH059211","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:13.000000Z","updated_at":"2025-03-17T22:23:13.000000Z"}]},{"id":1338342,"change_date":"2022-09-21 21:39:00","inspection_id":"76671172","dot_number":"1952957","report_state":"TX","report_number":"6E479DBC22","insp_date":"2022-09-06 00:00:00","insp_start_time":"0706","insp_end_time":"0819","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":"CEMEX (CUTTEN RD)","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":"2022-09-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"0","viol_total":"15","oos_total":"4","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"15","vehicle_oos_total":"4","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8778033","transaction_code":"A","transaction_date":"2022-09-21 00:00:00","upload_date":"2022-09-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01952957","upload_search_indicator":"M","census_search_date":"2022-09-21 21:39:00","snet_input_date":"2022-09-06 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-09-21 21:39:00","insp_carrier_name":"CARLOS A HERNANDEZ","insp_carrier_street":"7241 FM 1094","insp_carrier_city":"SEALY","insp_carrier_state":"TX","insp_carrier_zip_code":"77474","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0192065","created_at":"2025-03-17T18:51:17.000000Z","updated_at":"2025-03-17T18:51:17.000000Z","inspection_violations":[{"id":2118276,"change_date":"2022-09-21 21:39:00","inspection_id":"76671172","insp_violation_id":"248564999","seq_no":"11","part_no":"393","part_no_section":"83(g)","insp_viol_unit":"1","insp_unit_id":"191028225","insp_violation_category_id":"27","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:16:40.000000Z","updated_at":"2025-03-17T21:16:40.000000Z","normalized_code":"39383G"},{"id":2118277,"change_date":"2022-09-21 21:39:00","inspection_id":"76671172","insp_violation_id":"248565000","seq_no":"12","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"191028226","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:40.000000Z","updated_at":"2025-03-17T21:16:40.000000Z","normalized_code":"39617C"},{"id":2118278,"change_date":"2022-09-21 21:39:00","inspection_id":"76671172","insp_violation_id":"248565001","seq_no":"13","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"191028226","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:40.000000Z","updated_at":"2025-03-17T21:16:40.000000Z","normalized_code":"3922"},{"id":2118279,"change_date":"2022-09-21 21:39:00","inspection_id":"76671172","insp_violation_id":"248565002","seq_no":"14","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"191028225","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:40.000000Z","updated_at":"2025-03-17T21:16:40.000000Z","normalized_code":"3963A1"},{"id":2118280,"change_date":"2022-09-21 21:39:00","inspection_id":"76671172","insp_violation_id":"248565003","seq_no":"15","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"191028226","insp_violation_category_id":"17","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:16:40.000000Z","updated_at":"2025-03-17T21:16:40.000000Z","normalized_code":"3963A1"},{"id":2118281,"change_date":"2022-09-21 21:39:00","inspection_id":"76671172","insp_violation_id":"248565004","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"191028225","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:16:40.000000Z","updated_at":"2025-03-17T21:16:40.000000Z","normalized_code":"3963A1"},{"id":2118282,"change_date":"2022-09-21 21:39:00","inspection_id":"76671172","insp_violation_id":"248565005","seq_no":"2","part_no":"393","part_no_section":"55(d)(1)","insp_viol_unit":"1","insp_unit_id":"191028225","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:40.000000Z","updated_at":"2025-03-17T21:16:40.000000Z","normalized_code":"39355D1"},{"id":2118283,"change_date":"2022-09-21 21:39:00","inspection_id":"76671172","insp_violation_id":"248565006","seq_no":"3","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"191028225","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:40.000000Z","updated_at":"2025-03-17T21:16:40.000000Z","normalized_code":"3965B"},{"id":2118284,"change_date":"2022-09-21 21:39:00","inspection_id":"76671172","insp_violation_id":"248565007","seq_no":"4","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"191028225","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:40.000000Z","updated_at":"2025-03-17T21:16:40.000000Z","normalized_code":"39395A"},{"id":2118285,"change_date":"2022-09-21 21:39:00","inspection_id":"76671172","insp_violation_id":"248565008","seq_no":"5","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"191028225","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:40.000000Z","updated_at":"2025-03-17T21:16:40.000000Z","normalized_code":"39345B2"},{"id":2118286,"change_date":"2022-09-21 21:39:00","inspection_id":"76671172","insp_violation_id":"248565009","seq_no":"6","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"191028225","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:40.000000Z","updated_at":"2025-03-17T21:16:40.000000Z","normalized_code":"39345B2"},{"id":2118287,"change_date":"2022-09-21 21:39:00","inspection_id":"76671172","insp_violation_id":"248565010","seq_no":"7","part_no":"393","part_no_section":"203(e)","insp_viol_unit":"1","insp_unit_id":"191028225","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:40.000000Z","updated_at":"2025-03-17T21:16:40.000000Z","normalized_code":"393203E"},{"id":2118288,"change_date":"2022-09-21 21:39:00","inspection_id":"76671172","insp_violation_id":"248565011","seq_no":"8","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"191028225","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:16:40.000000Z","updated_at":"2025-03-17T21:16:40.000000Z","normalized_code":"3963A1"},{"id":2118289,"change_date":"2022-09-21 21:39:00","inspection_id":"76671172","insp_violation_id":"248565012","seq_no":"9","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"191028225","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:40.000000Z","updated_at":"2025-03-17T21:16:40.000000Z","normalized_code":"39345"},{"id":2118290,"change_date":"2022-09-21 21:39:00","inspection_id":"76671172","insp_violation_id":"248565013","seq_no":"10","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"191028225","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:40.000000Z","updated_at":"2025-03-17T21:16:40.000000Z","normalized_code":"39345"}],"inspection_per_units":[{"id":2154956,"change_date":"2022-09-21 21:39:00","inspection_id":"76671172","insp_unit_id":"191028225","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"924","insp_unit_license":"1L35681","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP5D88X2VN441600","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:44.000000Z","updated_at":"2025-03-17T22:21:44.000000Z"},{"id":2154957,"change_date":"2022-09-21 21:39:00","inspection_id":"76671172","insp_unit_id":"191028226","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"USTS","insp_unit_company":null,"insp_unit_license":"075B554","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1U9FA3825Y1051897","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:44.000000Z","updated_at":"2025-03-17T22:21:44.000000Z"}]},{"id":664403,"change_date":"2022-06-21 21:42:00","inspection_id":"75884643","dot_number":"1952957","report_state":"TX","report_number":"6BT79DAXCC","insp_date":"2022-06-15 00:00:00","insp_start_time":"0740","insp_end_time":"0755","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":"4","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HALLETT MATERIALS","shipping_paper_number":"17343","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2022-06-21 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"0","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":"8690668","transaction_code":"A","transaction_date":"2022-06-21 00:00:00","upload_date":"2022-06-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01952957","upload_search_indicator":"M","census_search_date":"2022-06-21 21:42:00","snet_input_date":"2022-06-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-06-21 21:42:00","insp_carrier_name":"CARLOS A HERNANDEZ","insp_carrier_street":"7241 FM 1094","insp_carrier_city":"SEALY","insp_carrier_state":"TX","insp_carrier_zip_code":"77474","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0192065","created_at":"2025-03-17T18:39:29.000000Z","updated_at":"2025-03-17T18:39:29.000000Z","inspection_violations":[{"id":1046406,"change_date":"2022-06-21 21:42:00","inspection_id":"75884643","insp_violation_id":"246633795","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:55.000000Z","updated_at":"2025-03-17T21:11:55.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1068069,"change_date":"2022-06-21 21:42:00","inspection_id":"75884643","insp_unit_id":"189389518","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"921","insp_unit_license":"1L35682","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDD69X2SJ663421","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:46.000000Z","updated_at":"2025-03-17T22:14:46.000000Z"},{"id":1068070,"change_date":"2022-06-21 21:42:00","inspection_id":"75884643","insp_unit_id":"189389519","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MACL","insp_unit_company":null,"insp_unit_license":"156C142","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5MADN3928MH059211","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:46.000000Z","updated_at":"2025-03-17T22:14:46.000000Z"}]},{"id":673994,"change_date":"2022-06-22 21:41:00","inspection_id":"75895863","dot_number":"1952957","report_state":"TX","report_number":"6BTC9DBCW7","insp_date":"2022-06-15 00:00:00","insp_start_time":"1229","insp_end_time":"1246","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":"4","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HALLET MATERIALS","shipping_paper_number":"17383","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2022-06-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"0","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":"8692441","transaction_code":"A","transaction_date":"2022-06-22 00:00:00","upload_date":"2022-06-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01952957","upload_search_indicator":"M","census_search_date":"2022-06-22 21:41:00","snet_input_date":"2022-06-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-06-22 21:41:00","insp_carrier_name":"CARLOS A HERNANDEZ","insp_carrier_street":"7241 FM 1094","insp_carrier_city":"SEALY","insp_carrier_state":"TX","insp_carrier_zip_code":"77474","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0192065","created_at":"2025-03-17T18:39:32.000000Z","updated_at":"2025-03-17T18:39:32.000000Z","inspection_violations":[{"id":1061524,"change_date":"2022-06-22 21:41:00","inspection_id":"75895863","insp_violation_id":"246662026","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:00.000000Z","updated_at":"2025-03-17T21:12:00.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1083343,"change_date":"2022-06-22 21:41:00","inspection_id":"75895863","insp_unit_id":"189413523","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"923","insp_unit_license":"1M33708","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP7DB9X33D809180","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:51.000000Z","updated_at":"2025-03-17T22:14:51.000000Z"},{"id":1083344,"change_date":"2022-06-22 21:41:00","inspection_id":"75895863","insp_unit_id":"189413524","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLM","insp_unit_company":null,"insp_unit_license":"105B905","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1T9FC39B7M1066871","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:51.000000Z","updated_at":"2025-03-17T22:14:51.000000Z"}]},{"id":283359,"change_date":"2022-05-09 21:42:00","inspection_id":"75431352","dot_number":"1952957","report_state":"TX","report_number":"6AG99DCI0C","insp_date":"2022-04-27 00:00:00","insp_start_time":"0950","insp_end_time":"1020","registration_date":"2022-05-09 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"4200 N ELDRIDGE PKWY","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HANSON","shipping_paper_number":"685066970","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-04-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"128000","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":"8639499","transaction_code":"C","transaction_date":"2022-04-28 00:00:00","upload_date":"2022-05-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01952957","upload_search_indicator":"M","census_search_date":"2022-04-28 21:40:00","snet_input_date":"2022-04-27 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-04-28 21:40:00","insp_carrier_name":"CARLOS A HERNANDEZ","insp_carrier_street":"7241 FM 1094","insp_carrier_city":"SEALY","insp_carrier_state":"TX","insp_carrier_zip_code":"77474","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0192065","created_at":"2025-03-17T18:32:33.000000Z","updated_at":"2025-03-17T18:32:33.000000Z","inspection_violations":[{"id":442043,"change_date":"2022-05-09 21:42:00","inspection_id":"75431352","insp_violation_id":"245679628","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"188587419","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:10.000000Z","updated_at":"2025-03-17T21:09:10.000000Z","normalized_code":"39347E"},{"id":442044,"change_date":"2022-05-09 21:42:00","inspection_id":"75431352","insp_violation_id":"245679629","seq_no":"2","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"188587419","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:10.000000Z","updated_at":"2025-03-17T21:09:10.000000Z","normalized_code":"39353B"},{"id":442045,"change_date":"2022-05-09 21:42:00","inspection_id":"75431352","insp_violation_id":"245679630","seq_no":"3","part_no":"393","part_no_section":"55(d)(1)","insp_viol_unit":"1","insp_unit_id":"188587419","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:10.000000Z","updated_at":"2025-03-17T21:09:10.000000Z","normalized_code":"39355D1"},{"id":442046,"change_date":"2022-05-09 21:42:00","inspection_id":"75431352","insp_violation_id":"245679631","seq_no":"4","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"188587419","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:10.000000Z","updated_at":"2025-03-17T21:09:10.000000Z","normalized_code":"39375C"}],"inspection_per_units":[{"id":458896,"change_date":"2022-05-09 21:42:00","inspection_id":"75431352","insp_unit_id":"188587419","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"1M33708","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP7DB9X33D809180","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:01.000000Z","updated_at":"2025-03-17T22:11:01.000000Z"},{"id":458897,"change_date":"2022-05-09 21:42:00","inspection_id":"75431352","insp_unit_id":"188587420","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"105B905","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1T9FC39B7M1066871","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:01.000000Z","updated_at":"2025-03-17T22:11:01.000000Z"}]},{"id":138795,"change_date":"2022-04-08 21:39:00","inspection_id":"75258483","dot_number":"1952957","report_state":"TX","report_number":"69N99DGRQW","insp_date":"2022-03-29 00:00:00","insp_start_time":"0950","insp_end_time":"1025","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0010 IN HARRIS CO. (742-797","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HANSON","shipping_paper_number":"707080207","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-04-08 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"128000","viol_total":"7","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8614454","transaction_code":"A","transaction_date":"2022-04-08 00:00:00","upload_date":"2022-04-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01952957","upload_search_indicator":"M","census_search_date":"2022-04-08 21:39:00","snet_input_date":"2022-03-29 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-04-08 21:39:00","insp_carrier_name":"CARLOS A HERNANDEZ","insp_carrier_street":"7241 FM 1094","insp_carrier_city":"SEALY","insp_carrier_state":"TX","insp_carrier_zip_code":"77474","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0192065","created_at":"2025-03-17T18:29:52.000000Z","updated_at":"2025-03-17T18:29:52.000000Z","inspection_violations":[{"id":205391,"change_date":"2022-04-08 21:39:00","inspection_id":"75258483","insp_violation_id":"245054038","seq_no":"1","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"188065356","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:01.000000Z","updated_at":"2025-03-17T21:08:01.000000Z","normalized_code":"39021A"},{"id":205392,"change_date":"2022-04-08 21:39:00","inspection_id":"75258483","insp_violation_id":"245054039","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"188065356","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:01.000000Z","updated_at":"2025-03-17T21:08:01.000000Z","normalized_code":"39378"},{"id":205393,"change_date":"2022-04-08 21:39:00","inspection_id":"75258483","insp_violation_id":"245054040","seq_no":"4","part_no":"393","part_no_section":"83(g)","insp_viol_unit":"1","insp_unit_id":"188065356","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:01.000000Z","updated_at":"2025-03-17T21:08:01.000000Z","normalized_code":"39383G"},{"id":205394,"change_date":"2022-04-08 21:39:00","inspection_id":"75258483","insp_violation_id":"245054041","seq_no":"5","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"188065356","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:01.000000Z","updated_at":"2025-03-17T21:08:01.000000Z","normalized_code":"39345B2"},{"id":205395,"change_date":"2022-04-08 21:39:00","inspection_id":"75258483","insp_violation_id":"245054042","seq_no":"6","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"188065356","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:01.000000Z","updated_at":"2025-03-17T21:08:01.000000Z","normalized_code":"39345B2"},{"id":205396,"change_date":"2022-04-08 21:39:00","inspection_id":"75258483","insp_violation_id":"245054043","seq_no":"7","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"188065357","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:01.000000Z","updated_at":"2025-03-17T21:08:01.000000Z","normalized_code":"39375C"},{"id":205397,"change_date":"2022-04-08 21:39:00","inspection_id":"75258483","insp_violation_id":"245054044","seq_no":"8","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"188065357","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:01.000000Z","updated_at":"2025-03-17T21:08:01.000000Z","normalized_code":"39375C"}],"inspection_per_units":[{"id":224744,"change_date":"2022-04-08 21:39:00","inspection_id":"75258483","insp_unit_id":"188065356","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"1L35683","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD69X41J865050","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:33.000000Z","updated_at":"2025-03-17T22:09:33.000000Z"},{"id":224745,"change_date":"2022-04-08 21:39:00","inspection_id":"75258483","insp_unit_id":"188065357","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"156C142","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5MADN3928MH059211","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:33.000000Z","updated_at":"2025-03-17T22:09:33.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1952957\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1952957\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1952957\/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\/1952957\/inspections","per_page":100,"prev_page_url":null,"to":34,"total":34}