{"current_page":1,"data":[{"id":4522421,"change_date":"2023-11-29 21:43:00","inspection_id":"80270583","dot_number":"1939276","report_state":"TX","report_number":"6QE89DBA2C","insp_date":"2023-11-22 00:00:00","insp_start_time":"0811","insp_end_time":"0841","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0045 IN HARRIS CO. (24-72)","county_code_state":"TX","county_code":"201","insp_level_id":"4","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"E H JUNIORS TRUCKING LLC","shipping_paper_number":"NON","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-11-29 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"9135190","transaction_code":"A","transaction_date":"2023-11-29 00:00:00","upload_date":"2023-11-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01939276","upload_search_indicator":"M","census_search_date":"2023-11-29 21:43:00","snet_input_date":"2023-11-22 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-11-29 21:43:00","insp_carrier_name":"E H JUNIORS TRUCKING LLC","insp_carrier_street":"2441 PRESIT DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77093","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0190870","created_at":"2025-03-17T19:52:32.000000Z","updated_at":"2025-03-17T19:52:32.000000Z","inspection_violations":[{"id":6997897,"change_date":"2023-11-29 21:43:00","inspection_id":"80270583","insp_violation_id":"256628656","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198273046","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:44.000000Z","updated_at":"2025-03-17T21:39:44.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7273416,"change_date":"2023-11-29 21:43:00","inspection_id":"80270583","insp_unit_id":"198273046","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"104","insp_unit_license":"1M77525","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKADR9X21J867316","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:05.000000Z","updated_at":"2025-03-17T23:01:05.000000Z"},{"id":7273417,"change_date":"2023-11-29 21:43:00","inspection_id":"80270583","insp_unit_id":"198273047","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CTSI","insp_unit_company":null,"insp_unit_license":"138B583","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5TU343220FS000300","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:05.000000Z","updated_at":"2025-03-17T23:01:05.000000Z"}]},{"id":3698500,"change_date":"2023-08-08 21:42:00","inspection_id":"79356822","dot_number":"1939276","report_state":"TX","report_number":"6N9F9DNH0K","insp_date":"2023-08-01 00:00:00","insp_start_time":"1542","insp_end_time":"1605","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0146 IN HARRIS CO. (482-500","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-08-08 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","viol_total":"7","oos_total":"2","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9047222","transaction_code":"A","transaction_date":"2023-08-08 00:00:00","upload_date":"2023-08-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01939276","upload_search_indicator":"M","census_search_date":"2023-08-08 21:42:00","snet_input_date":"2023-08-01 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-08-08 21:42:00","insp_carrier_name":"E H JUNIORS TRUCKING LLC","insp_carrier_street":"2 GOODSON DR #","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77060","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0190870","created_at":"2025-03-17T19:35:44.000000Z","updated_at":"2025-03-17T19:35:44.000000Z","inspection_violations":[{"id":5702943,"change_date":"2023-08-08 21:42:00","inspection_id":"79356822","insp_violation_id":"254540501","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:26.000000Z","updated_at":"2025-03-17T21:33:26.000000Z","normalized_code":"38323A2"},{"id":5702944,"change_date":"2023-08-08 21:42:00","inspection_id":"79356822","insp_violation_id":"254540502","seq_no":"2","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"196430067","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:33:26.000000Z","updated_at":"2025-03-17T21:33:26.000000Z","normalized_code":"39375A3"},{"id":5702945,"change_date":"2023-08-08 21:42:00","inspection_id":"79356822","insp_violation_id":"254540503","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196430067","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:26.000000Z","updated_at":"2025-03-17T21:33:26.000000Z","normalized_code":"3939A"},{"id":5702946,"change_date":"2023-08-08 21:42:00","inspection_id":"79356822","insp_violation_id":"254540504","seq_no":"4","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"196430067","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:26.000000Z","updated_at":"2025-03-17T21:33:26.000000Z","normalized_code":"3965B"},{"id":5702947,"change_date":"2023-08-08 21:42:00","inspection_id":"79356822","insp_violation_id":"254540505","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196430067","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:26.000000Z","updated_at":"2025-03-17T21:33:26.000000Z","normalized_code":"3939A"},{"id":5702948,"change_date":"2023-08-08 21:42:00","inspection_id":"79356822","insp_violation_id":"254540506","seq_no":"6","part_no":"393","part_no_section":"205(c)","insp_viol_unit":"1","insp_unit_id":"196430067","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:26.000000Z","updated_at":"2025-03-17T21:33:26.000000Z","normalized_code":"393205C"},{"id":5702949,"change_date":"2023-08-08 21:42:00","inspection_id":"79356822","insp_violation_id":"254540507","seq_no":"9","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:26.000000Z","updated_at":"2025-03-17T21:33:26.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":5946678,"change_date":"2023-08-08 21:42:00","inspection_id":"79356822","insp_unit_id":"196430067","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"104","insp_unit_license":"1M77525","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKADR9X21J867316","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:59.000000Z","updated_at":"2025-03-17T22:49:59.000000Z"},{"id":5946679,"change_date":"2023-08-08 21:42:00","inspection_id":"79356822","insp_unit_id":"196430068","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"138B583","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5TU343220FS000300","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:59.000000Z","updated_at":"2025-03-17T22:49:59.000000Z"}]},{"id":3676784,"change_date":"2023-08-04 21:41:00","inspection_id":"79332698","dot_number":"1939276","report_state":"TX","report_number":"6N899DNAW4","insp_date":"2023-07-31 00:00:00","insp_start_time":"0830","insp_end_time":"0915","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"500  CANE ISLAND PKW","county_code_state":"TX","county_code":"473","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"UNKNOWN","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-08-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"0","viol_total":"5","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9044625","transaction_code":"A","transaction_date":"2023-08-04 00:00:00","upload_date":"2023-08-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01939276","upload_search_indicator":"M","census_search_date":"2023-08-04 21:41:00","snet_input_date":"2023-07-31 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-08-04 21:41:00","insp_carrier_name":"E H JUNIORS TRUCKING LLC","insp_carrier_street":"2 GOODSON DR #","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77060","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0190870","created_at":"2025-03-17T19:35:20.000000Z","updated_at":"2025-03-17T19:35:20.000000Z","inspection_violations":[{"id":5668523,"change_date":"2023-08-04 21:41:00","inspection_id":"79332698","insp_violation_id":"254485145","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196378936","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:16.000000Z","updated_at":"2025-03-17T21:33:16.000000Z","normalized_code":"3939A"},{"id":5668524,"change_date":"2023-08-04 21:41:00","inspection_id":"79332698","insp_violation_id":"254485146","seq_no":"2","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"196378936","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:16.000000Z","updated_at":"2025-03-17T21:33:16.000000Z","normalized_code":"39345B2"},{"id":5668525,"change_date":"2023-08-04 21:41:00","inspection_id":"79332698","insp_violation_id":"254485147","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"196378937","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:16.000000Z","updated_at":"2025-03-17T21:33:16.000000Z","normalized_code":"3939A"},{"id":5668526,"change_date":"2023-08-04 21:41:00","inspection_id":"79332698","insp_violation_id":"254485148","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"196378937","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:16.000000Z","updated_at":"2025-03-17T21:33:16.000000Z","normalized_code":"3939A"},{"id":5668527,"change_date":"2023-08-04 21:41:00","inspection_id":"79332698","insp_violation_id":"254485149","seq_no":"5","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"196378937","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:16.000000Z","updated_at":"2025-03-17T21:33:16.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":5911549,"change_date":"2023-08-04 21:41:00","inspection_id":"79332698","insp_unit_id":"196378936","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"779","insp_unit_license":"1M20263","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP5DB9XXSD351532","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:42.000000Z","updated_at":"2025-03-17T22:49:42.000000Z"},{"id":5911550,"change_date":"2023-08-04 21:41:00","inspection_id":"79332698","insp_unit_id":"196378937","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CTSI","insp_unit_company":null,"insp_unit_license":"138B584","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5TU343226FS000642","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:42.000000Z","updated_at":"2025-03-17T22:49:42.000000Z"}]},{"id":3390758,"change_date":"2023-06-28 21:43:00","inspection_id":"79011398","dot_number":"1939276","report_state":"TX","report_number":"6M6F9DCOLJ","insp_date":"2023-06-23 00:00:00","insp_start_time":"1510","insp_end_time":"1530","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"3500 E CROSSTIMBERS","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"GULF COAST","shipping_paper_number":"779","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-28 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","viol_total":"12","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"12","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9015675","transaction_code":"A","transaction_date":"2023-06-28 00:00:00","upload_date":"2023-06-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01939276","upload_search_indicator":"M","census_search_date":"2023-06-28 21:43:00","snet_input_date":"2023-06-23 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-06-28 21:43:00","insp_carrier_name":"E H JUNIORS TRUCKING LLC","insp_carrier_street":"2 GOODSON DR #","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77060","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0190870","created_at":"2025-03-17T19:30:10.000000Z","updated_at":"2025-03-17T19:30:10.000000Z","inspection_violations":[{"id":5228238,"change_date":"2023-06-28 21:43:00","inspection_id":"79011398","insp_violation_id":"253763808","seq_no":"1","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"195732829","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:16.000000Z","updated_at":"2025-03-17T21:31:16.000000Z","normalized_code":"39395F"},{"id":5228239,"change_date":"2023-06-28 21:43:00","inspection_id":"79011398","insp_violation_id":"253763809","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195732829","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:16.000000Z","updated_at":"2025-03-17T21:31:16.000000Z","normalized_code":"3939A"},{"id":5228240,"change_date":"2023-06-28 21:43:00","inspection_id":"79011398","insp_violation_id":"253763810","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195732829","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:16.000000Z","updated_at":"2025-03-17T21:31:16.000000Z","normalized_code":"3939A"},{"id":5228241,"change_date":"2023-06-28 21:43:00","inspection_id":"79011398","insp_violation_id":"253763811","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195732829","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:16.000000Z","updated_at":"2025-03-17T21:31:16.000000Z","normalized_code":"3939A"},{"id":5228242,"change_date":"2023-06-28 21:43:00","inspection_id":"79011398","insp_violation_id":"253763812","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195732829","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:16.000000Z","updated_at":"2025-03-17T21:31:16.000000Z","normalized_code":"3939A"},{"id":5228243,"change_date":"2023-06-28 21:43:00","inspection_id":"79011398","insp_violation_id":"253763813","seq_no":"6","part_no":"393","part_no_section":"19","insp_viol_unit":"1","insp_unit_id":"195732829","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:16.000000Z","updated_at":"2025-03-17T21:31:16.000000Z","normalized_code":"39319"},{"id":5228244,"change_date":"2023-06-28 21:43:00","inspection_id":"79011398","insp_violation_id":"253763814","seq_no":"7","part_no":"393","part_no_section":"203(a)","insp_viol_unit":"1","insp_unit_id":"195732829","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:16.000000Z","updated_at":"2025-03-17T21:31:16.000000Z","normalized_code":"393203A"},{"id":5228245,"change_date":"2023-06-28 21:43:00","inspection_id":"79011398","insp_violation_id":"253763815","seq_no":"8","part_no":"393","part_no_section":"209(b)","insp_viol_unit":"1","insp_unit_id":"195732829","insp_violation_category_id":"21","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:31:16.000000Z","updated_at":"2025-03-17T21:31:16.000000Z","normalized_code":"393209B"},{"id":5228246,"change_date":"2023-06-28 21:43:00","inspection_id":"79011398","insp_violation_id":"253763816","seq_no":"9","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"195732830","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:16.000000Z","updated_at":"2025-03-17T21:31:16.000000Z","normalized_code":"39617C"},{"id":5228247,"change_date":"2023-06-28 21:43:00","inspection_id":"79011398","insp_violation_id":"253763817","seq_no":"10","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"195732830","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:31:16.000000Z","updated_at":"2025-03-17T21:31:16.000000Z","normalized_code":"3939A"},{"id":5228248,"change_date":"2023-06-28 21:43:00","inspection_id":"79011398","insp_violation_id":"253763818","seq_no":"11","part_no":"393","part_no_section":"19","insp_viol_unit":"2","insp_unit_id":"195732830","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:16.000000Z","updated_at":"2025-03-17T21:31:16.000000Z","normalized_code":"39319"},{"id":5228249,"change_date":"2023-06-28 21:43:00","inspection_id":"79011398","insp_violation_id":"253763819","seq_no":"12","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"195732830","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:16.000000Z","updated_at":"2025-03-17T21:31:16.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5451602,"change_date":"2023-06-28 21:43:00","inspection_id":"79011398","insp_unit_id":"195732829","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"779","insp_unit_license":"1M20263","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP5DB9XXSD351532","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:01.000000Z","updated_at":"2025-03-17T22:46:01.000000Z"},{"id":5451603,"change_date":"2023-06-28 21:43:00","inspection_id":"79011398","insp_unit_id":"195732830","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CTSI","insp_unit_company":null,"insp_unit_license":"138B584","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5TU343226FS000642","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:01.000000Z","updated_at":"2025-03-17T22:46:01.000000Z"}]},{"id":1845053,"change_date":"2022-12-01 21:42:00","inspection_id":"77254779","dot_number":"1939276","report_state":"TX","report_number":"6EHE9DBBK9","insp_date":"2022-09-19 00:00:00","insp_start_time":"1349","insp_end_time":"1459","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":"DEANCO","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-11-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"8839350","transaction_code":"C","transaction_date":"2022-12-01 00:00:00","upload_date":"2022-12-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01939276","upload_search_indicator":"M","census_search_date":"2022-11-30 21:40:00","snet_input_date":"2022-09-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-11-30 21:40:00","insp_carrier_name":"E H JUNIORS TRUCKING LLC","insp_carrier_street":"2 GOODSON DR #","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77060","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0190870","created_at":"2025-03-17T19:00:43.000000Z","updated_at":"2025-03-17T19:00:43.000000Z","inspection_violations":[{"id":2877855,"change_date":"2022-12-01 21:42:00","inspection_id":"77254779","insp_violation_id":"249880031","seq_no":"1","part_no":"393","part_no_section":"79","insp_viol_unit":"1","insp_unit_id":"192221421","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:40.000000Z","updated_at":"2025-03-17T21:20:40.000000Z","normalized_code":"39379"},{"id":2877856,"change_date":"2022-12-01 21:42:00","inspection_id":"77254779","insp_violation_id":"249880032","seq_no":"2","part_no":"393","part_no_section":"203","insp_viol_unit":"1","insp_unit_id":"192221421","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:40.000000Z","updated_at":"2025-03-17T21:20:40.000000Z","normalized_code":"393203"},{"id":2877857,"change_date":"2022-12-01 21:42:00","inspection_id":"77254779","insp_violation_id":"249880033","seq_no":"3","part_no":"393","part_no_section":"47(g)","insp_viol_unit":"1","insp_unit_id":"192221421","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:40.000000Z","updated_at":"2025-03-17T21:20:40.000000Z","normalized_code":"39347G"},{"id":2877858,"change_date":"2022-12-01 21:42:00","inspection_id":"77254779","insp_violation_id":"249880034","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"192221422","insp_violation_category_id":"17","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:20:40.000000Z","updated_at":"2025-03-17T21:20:40.000000Z","normalized_code":"3963A1"},{"id":2877859,"change_date":"2022-12-01 21:42:00","inspection_id":"77254779","insp_violation_id":"249880035","seq_no":"5","part_no":"393","part_no_section":"47(g)","insp_viol_unit":"2","insp_unit_id":"192221422","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:40.000000Z","updated_at":"2025-03-17T21:20:40.000000Z","normalized_code":"39347G"},{"id":2877860,"change_date":"2022-12-01 21:42:00","inspection_id":"77254779","insp_violation_id":"249880036","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"192221422","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:40.000000Z","updated_at":"2025-03-17T21:20:40.000000Z","normalized_code":"3939A"},{"id":2877861,"change_date":"2022-12-01 21:42:00","inspection_id":"77254779","insp_violation_id":"249880037","seq_no":"7","part_no":"393","part_no_section":"47(g)","insp_viol_unit":"2","insp_unit_id":"192221422","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:40.000000Z","updated_at":"2025-03-17T21:20:40.000000Z","normalized_code":"39347G"},{"id":2877862,"change_date":"2022-12-01 21:42:00","inspection_id":"77254779","insp_violation_id":"249880038","seq_no":"8","part_no":"393","part_no_section":"47(g)","insp_viol_unit":"1","insp_unit_id":"192221421","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:40.000000Z","updated_at":"2025-03-17T21:20:40.000000Z","normalized_code":"39347G"}],"inspection_per_units":[{"id":2968858,"change_date":"2022-12-01 21:42:00","inspection_id":"77254779","insp_unit_id":"192221421","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"427730G","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKADR9X21J867316","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:19.000000Z","updated_at":"2025-03-17T22:27:19.000000Z"},{"id":2968859,"change_date":"2022-12-01 21:42:00","inspection_id":"77254779","insp_unit_id":"192221422","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"427705G","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5TU2343220FS00030","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:19.000000Z","updated_at":"2025-03-17T22:27:19.000000Z"}]},{"id":703238,"change_date":"2022-06-30 21:42:00","inspection_id":"75930484","dot_number":"1939276","report_state":"TX","report_number":"6C2B9DCC6B","insp_date":"2022-06-24 00:00:00","insp_start_time":"1120","insp_end_time":"1206","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"300  MERCURY DR","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-06-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"101000","viol_total":"10","oos_total":"3","driver_viol_total":"2","driver_oos_total":"2","vehicle_viol_total":"8","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8696583","transaction_code":"C","transaction_date":"2022-06-30 00:00:00","upload_date":"2022-06-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01939276","upload_search_indicator":"M","census_search_date":"2022-06-27 21:41:00","snet_input_date":"2022-06-24 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-06-27 21:41:00","insp_carrier_name":"ERNESTO HERNANDEZ BERNAL","insp_carrier_street":"4707 MARABEL","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77022","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0190870","created_at":"2025-03-17T18:40:09.000000Z","updated_at":"2025-03-17T18:40:09.000000Z","inspection_violations":[{"id":1106245,"change_date":"2022-06-30 21:42:00","inspection_id":"75930484","insp_violation_id":"246839997","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:11.000000Z","updated_at":"2025-03-17T21:12:11.000000Z","normalized_code":"38323A2"},{"id":1106246,"change_date":"2022-06-30 21:42:00","inspection_id":"75930484","insp_violation_id":"246839998","seq_no":"2","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:11.000000Z","updated_at":"2025-03-17T21:12:11.000000Z","normalized_code":"39141A"},{"id":1106247,"change_date":"2022-06-30 21:42:00","inspection_id":"75930484","insp_violation_id":"246839999","seq_no":"3","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"189560029","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:11.000000Z","updated_at":"2025-03-17T21:12:11.000000Z","normalized_code":"39375C"},{"id":1106248,"change_date":"2022-06-30 21:42:00","inspection_id":"75930484","insp_violation_id":"246840000","seq_no":"4","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"189560029","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:11.000000Z","updated_at":"2025-03-17T21:12:11.000000Z","normalized_code":"39375C"},{"id":1106249,"change_date":"2022-06-30 21:42:00","inspection_id":"75930484","insp_violation_id":"246840001","seq_no":"5","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"189560029","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:11.000000Z","updated_at":"2025-03-17T21:12:11.000000Z","normalized_code":"39375C"},{"id":1106250,"change_date":"2022-06-30 21:42:00","inspection_id":"75930484","insp_violation_id":"246840002","seq_no":"6","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"189560029","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:11.000000Z","updated_at":"2025-03-17T21:12:11.000000Z","normalized_code":"39375C"},{"id":1106251,"change_date":"2022-06-30 21:42:00","inspection_id":"75930484","insp_violation_id":"246840003","seq_no":"7","part_no":"393","part_no_section":"201(a)","insp_viol_unit":"2","insp_unit_id":"189560029","insp_violation_category_id":"19","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:12:11.000000Z","updated_at":"2025-03-17T21:12:11.000000Z","normalized_code":"393201A"},{"id":1106252,"change_date":"2022-06-30 21:42:00","inspection_id":"75930484","insp_violation_id":"246840004","seq_no":"8","part_no":"393","part_no_section":"201(a)","insp_viol_unit":"2","insp_unit_id":"189560029","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:11.000000Z","updated_at":"2025-03-17T21:12:11.000000Z","normalized_code":"393201A"},{"id":1106253,"change_date":"2022-06-30 21:42:00","inspection_id":"75930484","insp_violation_id":"246840005","seq_no":"9","part_no":"393","part_no_section":"83(g)","insp_viol_unit":"1","insp_unit_id":"189560028","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:11.000000Z","updated_at":"2025-03-17T21:12:11.000000Z","normalized_code":"39383G"},{"id":1106254,"change_date":"2022-06-30 21:42:00","inspection_id":"75930484","insp_violation_id":"246840006","seq_no":"10","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"189560028","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:11.000000Z","updated_at":"2025-03-17T21:12:11.000000Z","normalized_code":"39345D"}],"inspection_per_units":[{"id":1130613,"change_date":"2022-06-30 21:42:00","inspection_id":"75930484","insp_unit_id":"189560028","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"104","insp_unit_license":"273803G","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKADR9X21J867316","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:09.000000Z","updated_at":"2025-03-17T22:15:09.000000Z"},{"id":1130614,"change_date":"2022-06-30 21:42:00","inspection_id":"75930484","insp_unit_id":"189560029","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CTSI","insp_unit_company":null,"insp_unit_license":"274467G","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKADR9X21J867316","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:09.000000Z","updated_at":"2025-03-17T22:15:09.000000Z"}]},{"id":493455,"change_date":"2022-06-10 21:41:00","inspection_id":"75681716","dot_number":"1939276","report_state":"TX","report_number":"6B289DNF0P","insp_date":"2022-05-19 00:00:00","insp_start_time":"0807","insp_end_time":"0909","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0045 IN GALVESTON CO. (0-23","county_code_state":"TX","county_code":"167","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2022-05-26 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"9","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"9","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8668076","transaction_code":"C","transaction_date":"2022-06-10 00:00:00","upload_date":"2022-06-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01939276","upload_search_indicator":"M","census_search_date":"2022-05-26 21:43:00","snet_input_date":"2022-05-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-05-26 21:43:00","insp_carrier_name":"ERNESTO HERNANDEZ BERNAL","insp_carrier_street":"4707 MARABEL","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77022","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0190870","created_at":"2025-03-17T18:36:21.000000Z","updated_at":"2025-03-17T18:36:21.000000Z","inspection_violations":[{"id":784042,"change_date":"2022-06-10 21:41:00","inspection_id":"75681716","insp_violation_id":"246380501","seq_no":"1","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"189182089","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:46.000000Z","updated_at":"2025-03-17T21:10:46.000000Z","normalized_code":"39360D"},{"id":784043,"change_date":"2022-06-10 21:41:00","inspection_id":"75681716","insp_violation_id":"246380502","seq_no":"2","part_no":"393","part_no_section":"75(a)(2)","insp_viol_unit":"1","insp_unit_id":"189182089","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:46.000000Z","updated_at":"2025-03-17T21:10:46.000000Z","normalized_code":"39375A2"},{"id":784044,"change_date":"2022-06-10 21:41:00","inspection_id":"75681716","insp_violation_id":"246380503","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189182089","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:46.000000Z","updated_at":"2025-03-17T21:10:46.000000Z","normalized_code":"3939A"},{"id":784045,"change_date":"2022-06-10 21:41:00","inspection_id":"75681716","insp_violation_id":"246380504","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"189182089","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:10:46.000000Z","updated_at":"2025-03-17T21:10:46.000000Z","normalized_code":"3963A1"},{"id":784046,"change_date":"2022-06-10 21:41:00","inspection_id":"75681716","insp_violation_id":"246380505","seq_no":"5","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"189182089","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:46.000000Z","updated_at":"2025-03-17T21:10:46.000000Z","normalized_code":"39345B2"},{"id":784047,"change_date":"2022-06-10 21:41:00","inspection_id":"75681716","insp_violation_id":"246380506","seq_no":"6","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"189182090","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:10:46.000000Z","updated_at":"2025-03-17T21:10:46.000000Z","normalized_code":"39375A3"},{"id":784048,"change_date":"2022-06-10 21:41:00","inspection_id":"75681716","insp_violation_id":"246380507","seq_no":"7","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"189182089","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:46.000000Z","updated_at":"2025-03-17T21:10:46.000000Z","normalized_code":"3965B"},{"id":784049,"change_date":"2022-06-10 21:41:00","inspection_id":"75681716","insp_violation_id":"246380508","seq_no":"8","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"189182089","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:46.000000Z","updated_at":"2025-03-17T21:10:46.000000Z","normalized_code":"39353B"},{"id":784050,"change_date":"2022-06-10 21:41:00","inspection_id":"75681716","insp_violation_id":"246380509","seq_no":"9","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"1","insp_unit_id":"189182089","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:46.000000Z","updated_at":"2025-03-17T21:10:46.000000Z","normalized_code":"39348A"}],"inspection_per_units":[{"id":793494,"change_date":"2022-06-10 21:41:00","inspection_id":"75681716","insp_unit_id":"189182089","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"104","insp_unit_license":"151572G","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKADR9X21J867316","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:05.000000Z","updated_at":"2025-03-17T22:13:05.000000Z"},{"id":793495,"change_date":"2022-06-10 21:41:00","inspection_id":"75681716","insp_unit_id":"189182090","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"NA","insp_unit_license":"136636G","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5TU2343220FS00030","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:05.000000Z","updated_at":"2025-03-17T22:13:05.000000Z"}]},{"id":505941,"change_date":"2022-05-27 21:41:00","inspection_id":"75696524","dot_number":"1939276","report_state":"TX","report_number":"6B1D9DAWMA","insp_date":"2022-05-18 00:00:00","insp_start_time":"1332","insp_end_time":"1432","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0045 IN GALVESTON CO. (0-23","county_code_state":"TX","county_code":"167","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2022-05-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"113000","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":"8669627","transaction_code":"A","transaction_date":"2022-05-27 00:00:00","upload_date":"2022-05-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01939276","upload_search_indicator":"M","census_search_date":"2022-05-27 21:41:00","snet_input_date":"2022-05-18 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-05-27 21:41:00","insp_carrier_name":"ERNESTO HERNANDEZ BERNAL","insp_carrier_street":"4707 MARABEL","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77022","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0190870","created_at":"2025-03-17T18:36:40.000000Z","updated_at":"2025-03-17T18:36:40.000000Z","inspection_violations":[{"id":804256,"change_date":"2022-05-27 21:41:00","inspection_id":"75696524","insp_violation_id":"246144263","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"188969820","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:50.000000Z","updated_at":"2025-03-17T21:10:50.000000Z","normalized_code":"39311"},{"id":804257,"change_date":"2022-05-27 21:41:00","inspection_id":"75696524","insp_violation_id":"246144264","seq_no":"2","part_no":"393","part_no_section":"47(d)","insp_viol_unit":"2","insp_unit_id":"188969821","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:50.000000Z","updated_at":"2025-03-17T21:10:50.000000Z","normalized_code":"39347D"},{"id":804258,"change_date":"2022-05-27 21:41:00","inspection_id":"75696524","insp_violation_id":"246144265","seq_no":"3","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"188969821","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:50.000000Z","updated_at":"2025-03-17T21:10:50.000000Z","normalized_code":"39375C"},{"id":804259,"change_date":"2022-05-27 21:41:00","inspection_id":"75696524","insp_violation_id":"246144266","seq_no":"4","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"188969821","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:50.000000Z","updated_at":"2025-03-17T21:10:50.000000Z","normalized_code":"39347E"},{"id":804260,"change_date":"2022-05-27 21:41:00","inspection_id":"75696524","insp_violation_id":"246144267","seq_no":"5","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"188969821","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:10:50.000000Z","updated_at":"2025-03-17T21:10:50.000000Z","normalized_code":"3963A1"},{"id":804261,"change_date":"2022-05-27 21:41:00","inspection_id":"75696524","insp_violation_id":"246144268","seq_no":"6","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"188969821","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:50.000000Z","updated_at":"2025-03-17T21:10:50.000000Z","normalized_code":"39353B"},{"id":804262,"change_date":"2022-05-27 21:41:00","inspection_id":"75696524","insp_violation_id":"246144269","seq_no":"7","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"188969820","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:50.000000Z","updated_at":"2025-03-17T21:10:50.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":813722,"change_date":"2022-05-27 21:41:00","inspection_id":"75696524","insp_unit_id":"188969820","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"539","insp_unit_license":"151561G","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CK97LZ20504","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:13.000000Z","updated_at":"2025-03-17T22:13:13.000000Z"},{"id":813723,"change_date":"2022-05-27 21:41:00","inspection_id":"75696524","insp_unit_id":"188969821","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CNST","insp_unit_company":null,"insp_unit_license":"136664G","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5TU343220ES000232","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:13.000000Z","updated_at":"2025-03-17T22:13:13.000000Z"}]},{"id":323457,"change_date":"2022-05-04 21:41:00","inspection_id":"75478807","dot_number":"1939276","report_state":"TX","report_number":"6ALF0AMWJF","insp_date":"2022-05-02 00:00:00","insp_start_time":"1505","insp_end_time":"1539","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"HARLEM RD","county_code_state":"TX","county_code":"157","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"GRAND MCKAY","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"9","oos_total":"2","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"7","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8644923","transaction_code":"A","transaction_date":"2022-05-04 00:00:00","upload_date":"2022-05-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01939276","upload_search_indicator":"M","census_search_date":"2022-05-04 21:41:00","snet_input_date":"2022-05-02 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-05-04 21:41:00","insp_carrier_name":"ERNESTO HERNANDEZ BERNAL","insp_carrier_street":"4707 MARABEL","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77022","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0190870","created_at":"2025-03-17T18:33:18.000000Z","updated_at":"2025-03-17T18:33:18.000000Z","inspection_violations":[{"id":505784,"change_date":"2022-05-04 21:41:00","inspection_id":"75478807","insp_violation_id":"245585857","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:27.000000Z","updated_at":"2025-03-17T21:09:27.000000Z","normalized_code":"38323A2"},{"id":505785,"change_date":"2022-05-04 21:41:00","inspection_id":"75478807","insp_violation_id":"245585858","seq_no":"2","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:27.000000Z","updated_at":"2025-03-17T21:09:27.000000Z","normalized_code":"39141A"},{"id":505786,"change_date":"2022-05-04 21:41:00","inspection_id":"75478807","insp_violation_id":"245585859","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"188513353","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:27.000000Z","updated_at":"2025-03-17T21:09:27.000000Z","normalized_code":"3922"},{"id":505787,"change_date":"2022-05-04 21:41:00","inspection_id":"75478807","insp_violation_id":"245585860","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"188513354","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:27.000000Z","updated_at":"2025-03-17T21:09:27.000000Z","normalized_code":"3939A"},{"id":505788,"change_date":"2022-05-04 21:41:00","inspection_id":"75478807","insp_violation_id":"245585861","seq_no":"6","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"188513353","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:09:27.000000Z","updated_at":"2025-03-17T21:09:27.000000Z","normalized_code":"39375A3"},{"id":505789,"change_date":"2022-05-04 21:41:00","inspection_id":"75478807","insp_violation_id":"245585862","seq_no":"7","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"188513353","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:27.000000Z","updated_at":"2025-03-17T21:09:27.000000Z","normalized_code":"3965B"},{"id":505790,"change_date":"2022-05-04 21:41:00","inspection_id":"75478807","insp_violation_id":"245585863","seq_no":"8","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"188513353","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:27.000000Z","updated_at":"2025-03-17T21:09:27.000000Z","normalized_code":"39347E"},{"id":505791,"change_date":"2022-05-04 21:41:00","inspection_id":"75478807","insp_violation_id":"245585864","seq_no":"9","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"188513353","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:27.000000Z","updated_at":"2025-03-17T21:09:27.000000Z","normalized_code":"39353B"},{"id":505792,"change_date":"2022-05-04 21:41:00","inspection_id":"75478807","insp_violation_id":"245585865","seq_no":"10","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"188513353","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:27.000000Z","updated_at":"2025-03-17T21:09:27.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":523432,"change_date":"2022-05-04 21:41:00","inspection_id":"75478807","insp_unit_id":"188513353","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"184","insp_unit_license":"977522F","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKADR9X21J867316","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:24.000000Z","updated_at":"2025-03-17T22:11:24.000000Z"},{"id":523433,"change_date":"2022-05-04 21:41:00","inspection_id":"75478807","insp_unit_id":"188513354","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CTSI","insp_unit_company":null,"insp_unit_license":"110014G","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5TU2343220FS00030","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:24.000000Z","updated_at":"2025-03-17T22:11:24.000000Z"}]},{"id":282383,"change_date":"2022-04-28 21:40:00","inspection_id":"75430199","dot_number":"1939276","report_state":"TX","report_number":"6AB99DCPA0","insp_date":"2022-04-22 00:00:00","insp_start_time":"0950","insp_end_time":"1015","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"9400  WALLISVILLE","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-04-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"148000","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":"8638946","transaction_code":"A","transaction_date":"2022-04-28 00:00:00","upload_date":"2022-04-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01939276","upload_search_indicator":"M","census_search_date":"2022-04-28 21:40:00","snet_input_date":"2022-04-22 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-04-28 21:40:00","insp_carrier_name":"ERNESTO HERNANDEZ BERNAL","insp_carrier_street":"4707 MARABEL","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77022","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0190870","created_at":"2025-03-17T18:32:33.000000Z","updated_at":"2025-03-17T18:32:33.000000Z","inspection_violations":[{"id":438560,"change_date":"2022-04-28 21:40:00","inspection_id":"75430199","insp_violation_id":"245459659","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"188410886","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:05.000000Z","updated_at":"2025-03-17T21:09:05.000000Z","normalized_code":"39378"},{"id":438561,"change_date":"2022-04-28 21:40:00","inspection_id":"75430199","insp_violation_id":"245459660","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"188410886","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:05.000000Z","updated_at":"2025-03-17T21:09:05.000000Z","normalized_code":"3939A"},{"id":438562,"change_date":"2022-04-28 21:40:00","inspection_id":"75430199","insp_violation_id":"245459661","seq_no":"3","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"188410886","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:05.000000Z","updated_at":"2025-03-17T21:09:05.000000Z","normalized_code":"39345"},{"id":438563,"change_date":"2022-04-28 21:40:00","inspection_id":"75430199","insp_violation_id":"245459662","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"188410886","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:05.000000Z","updated_at":"2025-03-17T21:09:05.000000Z","normalized_code":"3939A"},{"id":438564,"change_date":"2022-04-28 21:40:00","inspection_id":"75430199","insp_violation_id":"245459663","seq_no":"5","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"188410886","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:05.000000Z","updated_at":"2025-03-17T21:09:05.000000Z","normalized_code":"39375C"},{"id":438565,"change_date":"2022-04-28 21:40:00","inspection_id":"75430199","insp_violation_id":"245459664","seq_no":"6","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"188410887","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:05.000000Z","updated_at":"2025-03-17T21:09:05.000000Z","normalized_code":"39375C"},{"id":438566,"change_date":"2022-04-28 21:40:00","inspection_id":"75430199","insp_violation_id":"245459665","seq_no":"7","part_no":"393","part_no_section":"75(a)","insp_viol_unit":"1","insp_unit_id":"188410886","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:09:05.000000Z","updated_at":"2025-03-17T21:09:05.000000Z","normalized_code":"39375A"}],"inspection_per_units":[{"id":457197,"change_date":"2022-04-28 21:40:00","inspection_id":"75430199","insp_unit_id":"188410886","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"949000F","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKADR9X21J867316","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:00.000000Z","updated_at":"2025-03-17T22:11:00.000000Z"},{"id":457198,"change_date":"2022-04-28 21:40:00","inspection_id":"75430199","insp_unit_id":"188410887","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CTSI","insp_unit_company":null,"insp_unit_license":"970064F","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5TU2343220FS00030","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:00.000000Z","updated_at":"2025-03-17T22:11:00.000000Z"}]},{"id":180121,"change_date":"2022-04-19 21:44:00","inspection_id":"75308074","dot_number":"1939276","report_state":"TX","report_number":"6A099DCP8V","insp_date":"2022-04-11 00:00:00","insp_start_time":"0910","insp_end_time":"0945","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"300  MERCURY","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-04-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"8623175","transaction_code":"C","transaction_date":"2022-04-19 00:00:00","upload_date":"2022-04-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01939276","upload_search_indicator":"M","census_search_date":"2022-04-14 21:42:00","snet_input_date":"2022-04-11 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-04-14 21:42:00","insp_carrier_name":"ERNESTO HERNANDEZ BERNAL","insp_carrier_street":"4707 MARABEL","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77022","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0190870","created_at":"2025-03-17T18:30:48.000000Z","updated_at":"2025-03-17T18:30:48.000000Z","inspection_violations":[{"id":273783,"change_date":"2022-04-19 21:44:00","inspection_id":"75308074","insp_violation_id":"245245826","seq_no":"1","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"188230701","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:17.000000Z","updated_at":"2025-03-17T21:08:17.000000Z","normalized_code":"39375C"},{"id":273784,"change_date":"2022-04-19 21:44:00","inspection_id":"75308074","insp_violation_id":"245245827","seq_no":"2","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"188230701","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:17.000000Z","updated_at":"2025-03-17T21:08:17.000000Z","normalized_code":"39375C"},{"id":273785,"change_date":"2022-04-19 21:44:00","inspection_id":"75308074","insp_violation_id":"245245828","seq_no":"3","part_no":"393","part_no_section":"75(b)","insp_viol_unit":"1","insp_unit_id":"188230701","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:17.000000Z","updated_at":"2025-03-17T21:08:17.000000Z","normalized_code":"39375B"},{"id":273786,"change_date":"2022-04-19 21:44:00","inspection_id":"75308074","insp_violation_id":"245245829","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"188230701","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:17.000000Z","updated_at":"2025-03-17T21:08:17.000000Z","normalized_code":"3939A"},{"id":273787,"change_date":"2022-04-19 21:44:00","inspection_id":"75308074","insp_violation_id":"245245830","seq_no":"5","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"188230701","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:17.000000Z","updated_at":"2025-03-17T21:08:17.000000Z","normalized_code":"39378"},{"id":273788,"change_date":"2022-04-19 21:44:00","inspection_id":"75308074","insp_violation_id":"245245831","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"188230701","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:17.000000Z","updated_at":"2025-03-17T21:08:17.000000Z","normalized_code":"3939A"},{"id":273789,"change_date":"2022-04-19 21:44:00","inspection_id":"75308074","insp_violation_id":"245245832","seq_no":"7","part_no":"393","part_no_section":"203(c)","insp_viol_unit":"1","insp_unit_id":"188230701","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:17.000000Z","updated_at":"2025-03-17T21:08:17.000000Z","normalized_code":"393203C"},{"id":273790,"change_date":"2022-04-19 21:44:00","inspection_id":"75308074","insp_violation_id":"245245833","seq_no":"8","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"188230701","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:17.000000Z","updated_at":"2025-03-17T21:08:17.000000Z","normalized_code":"3965B"},{"id":273791,"change_date":"2022-04-19 21:44:00","inspection_id":"75308074","insp_violation_id":"245245834","seq_no":"9","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"188230701","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:17.000000Z","updated_at":"2025-03-17T21:08:17.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":291968,"change_date":"2022-04-19 21:44:00","inspection_id":"75308074","insp_unit_id":"188230701","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"881070F","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKADR9X21J867316","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:57.000000Z","updated_at":"2025-03-17T22:09:57.000000Z"},{"id":291969,"change_date":"2022-04-19 21:44:00","inspection_id":"75308074","insp_unit_id":"188230702","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CTSI","insp_unit_company":null,"insp_unit_license":"946791F","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5TU2343220FS00030","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:57.000000Z","updated_at":"2025-03-17T22:09:57.000000Z"}]},{"id":139236,"change_date":"2022-04-08 21:39:00","inspection_id":"75258994","dot_number":"1939276","report_state":"TX","report_number":"69MB0AMWF1","insp_date":"2022-03-28 00:00:00","insp_start_time":"1100","insp_end_time":"1134","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"HARLEM RD","county_code_state":"TX","county_code":"157","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"JOSE CONSTRUCTION","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-08 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","viol_total":"9","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"9","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8614383","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":"01939276","upload_search_indicator":"M","census_search_date":"2022-04-08 21:39:00","snet_input_date":"2022-03-28 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-04-08 21:39:00","insp_carrier_name":"ERNESTO HERNANDEZ BERNAL","insp_carrier_street":"4707 MARABEL","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77022","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0190870","created_at":"2025-03-17T18:29:52.000000Z","updated_at":"2025-03-17T18:29:52.000000Z","inspection_violations":[{"id":207003,"change_date":"2022-04-08 21:39:00","inspection_id":"75258994","insp_violation_id":"245056704","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"188066514","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":207004,"change_date":"2022-04-08 21:39:00","inspection_id":"75258994","insp_violation_id":"245056705","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"188066514","insp_violation_category_id":"20","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":"3939A"},{"id":207005,"change_date":"2022-04-08 21:39:00","inspection_id":"75258994","insp_violation_id":"245056706","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"188066514","insp_violation_category_id":"20","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":"3939A"},{"id":207006,"change_date":"2022-04-08 21:39:00","inspection_id":"75258994","insp_violation_id":"245056707","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"188066514","insp_violation_category_id":"20","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":"3939A"},{"id":207007,"change_date":"2022-04-08 21:39:00","inspection_id":"75258994","insp_violation_id":"245056708","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"188066514","insp_violation_category_id":"20","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":"3939A"},{"id":207008,"change_date":"2022-04-08 21:39:00","inspection_id":"75258994","insp_violation_id":"245056709","seq_no":"6","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"188066514","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:08:01.000000Z","updated_at":"2025-03-17T21:08:01.000000Z","normalized_code":"39345"},{"id":207009,"change_date":"2022-04-08 21:39:00","inspection_id":"75258994","insp_violation_id":"245056710","seq_no":"7","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"188066515","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:08:01.000000Z","updated_at":"2025-03-17T21:08:01.000000Z","normalized_code":"39375A3"},{"id":207010,"change_date":"2022-04-08 21:39:00","inspection_id":"75258994","insp_violation_id":"245056711","seq_no":"8","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"188066515","insp_violation_category_id":"20","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":"3939A"},{"id":207011,"change_date":"2022-04-08 21:39:00","inspection_id":"75258994","insp_violation_id":"245056712","seq_no":"9","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"188066514","insp_violation_category_id":"20","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":"3939A"}],"inspection_per_units":[{"id":225474,"change_date":"2022-04-08 21:39:00","inspection_id":"75258994","insp_unit_id":"188066514","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"779","insp_unit_license":"888524F","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP5DB9XXSD351532","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:34.000000Z","updated_at":"2025-03-17T22:09:34.000000Z"},{"id":225475,"change_date":"2022-04-08 21:39:00","inspection_id":"75258994","insp_unit_id":"188066515","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CTSI","insp_unit_company":null,"insp_unit_license":"888538F","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5TU343226FS000642","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:34.000000Z","updated_at":"2025-03-17T22:09:34.000000Z"}]},{"id":103246,"change_date":"2022-04-04 21:41:00","inspection_id":"75214335","dot_number":"1939276","report_state":"TX","report_number":"69FE9DIAOQ","insp_date":"2022-03-21 00:00:00","insp_start_time":"1427","insp_end_time":"1501","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"300  MERCURY","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-04-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"127000","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":"8608683","transaction_code":"A","transaction_date":"2022-04-04 00:00:00","upload_date":"2022-04-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01939276","upload_search_indicator":"M","census_search_date":"2022-04-04 21:41:00","snet_input_date":"2022-03-21 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-04-04 21:41:00","insp_carrier_name":"ERNESTO HERNANDEZ BERNAL","insp_carrier_street":"4707 MARABEL","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77022","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0190870","created_at":"2025-03-17T18:29:26.000000Z","updated_at":"2025-03-17T18:29:26.000000Z","inspection_violations":[{"id":152160,"change_date":"2022-04-04 21:41:00","inspection_id":"75214335","insp_violation_id":"244949753","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"187974856","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:46.000000Z","updated_at":"2025-03-17T21:07:46.000000Z","normalized_code":"39378"},{"id":152161,"change_date":"2022-04-04 21:41:00","inspection_id":"75214335","insp_violation_id":"244949754","seq_no":"2","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"187974856","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:46.000000Z","updated_at":"2025-03-17T21:07:46.000000Z","normalized_code":"39360C"},{"id":152162,"change_date":"2022-04-04 21:41:00","inspection_id":"75214335","insp_violation_id":"244949755","seq_no":"3","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"187974856","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:46.000000Z","updated_at":"2025-03-17T21:07:46.000000Z","normalized_code":"39311"},{"id":152163,"change_date":"2022-04-04 21:41:00","inspection_id":"75214335","insp_violation_id":"244949756","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"187974856","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:46.000000Z","updated_at":"2025-03-17T21:07:46.000000Z","normalized_code":"3939A"},{"id":152164,"change_date":"2022-04-04 21:41:00","inspection_id":"75214335","insp_violation_id":"244949757","seq_no":"5","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"187974856","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:46.000000Z","updated_at":"2025-03-17T21:07:46.000000Z","normalized_code":"3965B"},{"id":152165,"change_date":"2022-04-04 21:41:00","inspection_id":"75214335","insp_violation_id":"244949758","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"187974856","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:46.000000Z","updated_at":"2025-03-17T21:07:46.000000Z","normalized_code":"3939A"},{"id":152166,"change_date":"2022-04-04 21:41:00","inspection_id":"75214335","insp_violation_id":"244949759","seq_no":"7","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"187974855","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:46.000000Z","updated_at":"2025-03-17T21:07:46.000000Z","normalized_code":"39617C"},{"id":152167,"change_date":"2022-04-04 21:41:00","inspection_id":"75214335","insp_violation_id":"244949760","seq_no":"8","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"187974855","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:46.000000Z","updated_at":"2025-03-17T21:07:46.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":167423,"change_date":"2022-04-04 21:41:00","inspection_id":"75214335","insp_unit_id":"187974855","insp_unit_type_id":"10","insp_unit_number":"2","insp_unit_make":"CTSI","insp_unit_company":null,"insp_unit_license":"857155F","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5TU2343220FS00030","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:14.000000Z","updated_at":"2025-03-17T22:09:14.000000Z"},{"id":167424,"change_date":"2022-04-04 21:41:00","inspection_id":"75214335","insp_unit_id":"187974856","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"104","insp_unit_license":"821137F","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKADR9X21J867316","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:14.000000Z","updated_at":"2025-03-17T22:09:14.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1939276\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1939276\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1939276\/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\/1939276\/inspections","per_page":100,"prev_page_url":null,"to":13,"total":13}