{"current_page":1,"data":[{"id":12043767,"change_date":"2026-05-28 21:42:00","inspection_id":"87984491","dot_number":"2253297","report_state":"TX","report_number":"7FB99DDD0B","insp_date":"2026-05-07 00:00:00","insp_start_time":"0935","insp_end_time":"0952","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"3300  BAYPORT BLVD","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"DORSETT","shipping_paper_number":"879910","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-05-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"125200","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":"9971781","transaction_code":"A","transaction_date":"2026-05-28 00:00:00","upload_date":"2026-05-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02253297","upload_search_indicator":"M","census_search_date":"2026-05-28 21:42:00","snet_input_date":"2026-05-07 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-05-28 21:42:00","insp_carrier_name":"ER TRUCKING SERVICES LLC","insp_carrier_street":"2617 BISBEE STREET","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0247612","created_at":"2026-06-01T09:40:03.000000Z","updated_at":"2026-06-08T09:31:48.000000Z","inspection_violations":[{"id":20955884,"change_date":"2026-05-28 21:42:00","inspection_id":"87984491","insp_violation_id":"274563663","seq_no":"1","part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"1","insp_unit_id":"213805076","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-01T09:59:46.000000Z","updated_at":"2026-06-08T09:44:08.000000Z","normalized_code":"39345B2UV"},{"id":20955885,"change_date":"2026-05-28 21:42:00","inspection_id":"87984491","insp_violation_id":"274563664","seq_no":"2","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"213805077","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-01T09:59:46.000000Z","updated_at":"2026-06-08T09:44:08.000000Z","normalized_code":"39347E"},{"id":20955886,"change_date":"2026-05-28 21:42:00","inspection_id":"87984491","insp_violation_id":"274563665","seq_no":"3","part_no":"393","part_no_section":"53B","insp_viol_unit":"2","insp_unit_id":"213805077","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-01T09:59:46.000000Z","updated_at":"2026-06-08T09:44:08.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":20932916,"change_date":"2026-05-28 21:42:00","inspection_id":"87984491","insp_unit_id":"213805076","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"675","insp_unit_license":"1L33778","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD49X3EJ400544","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-01T09:17:22.000000Z","updated_at":"2026-06-08T09:04:05.000000Z"},{"id":20932917,"change_date":"2026-05-28 21:42:00","inspection_id":"87984491","insp_unit_id":"213805077","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CLEM","insp_unit_company":"675","insp_unit_license":"205C676","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5C2BB32B0EM008880","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-01T09:17:22.000000Z","updated_at":"2026-06-08T09:04:05.000000Z"}]},{"id":12227098,"change_date":"2026-06-18 21:42:00","inspection_id":"88185165","dot_number":"2253297","report_state":"TX","report_number":"7F989DDC1F","insp_date":"2026-05-05 00:00:00","insp_start_time":"0825","insp_end_time":"0843","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"5500  BAYPORT BLVD","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"1248326","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-06-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"127000","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":"9998014","transaction_code":"A","transaction_date":"2026-06-18 00:00:00","upload_date":"2026-06-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02253297","upload_search_indicator":"M","census_search_date":"2026-06-18 21:42:00","snet_input_date":"2026-05-05 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-06-18 21:42:00","insp_carrier_name":"ER TRUCKING SERVICES LLC","insp_carrier_street":"2617 BISBEE STREET","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0247612","created_at":"2026-06-21T09:43:46.000000Z","updated_at":"2026-06-27T09:34:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21234359,"change_date":"2026-06-18 21:42:00","inspection_id":"88185165","insp_unit_id":"214181222","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"679","insp_unit_license":"1N67088","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDP40X57J160675","insp_unit_decal":"Y","insp_unit_decal_number":"36289046","created_at":"2026-06-21T09:19:39.000000Z","updated_at":"2026-06-27T09:07:55.000000Z"},{"id":21234360,"change_date":"2026-06-18 21:42:00","inspection_id":"88185165","insp_unit_id":"214181223","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BRAZ","insp_unit_company":"679","insp_unit_license":"DX2814","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"4B9BKDG20SH054801","insp_unit_decal":"Y","insp_unit_decal_number":"36289047","created_at":"2026-06-21T09:19:39.000000Z","updated_at":"2026-06-27T09:07:55.000000Z"}]},{"id":11503501,"change_date":"2026-03-27 21:40:00","inspection_id":"87423700","dot_number":"2253297","report_state":"TX","report_number":"7E399DDAJS","insp_date":"2026-03-24 00:00:00","insp_start_time":"0914","insp_end_time":"0936","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"5700  OLD HWY 146","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-03-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"9897861","transaction_code":"A","transaction_date":"2026-03-27 00:00:00","upload_date":"2026-03-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02253297","upload_search_indicator":"M","census_search_date":"2026-03-27 21:40:00","snet_input_date":"2026-03-24 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-03-27 21:40:00","insp_carrier_name":"ER TRUCKING SERVICES LLC","insp_carrier_street":"2617 BISBEE STREET","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0247612","created_at":"2026-03-30T09:51:48.000000Z","updated_at":"2026-04-07T09:32:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19706990,"change_date":"2026-03-27 21:40:00","inspection_id":"87423700","insp_unit_id":"212390586","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"678","insp_unit_license":"VCT8265","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2XKDDB9X97M184695","insp_unit_decal":"Y","insp_unit_decal_number":"35978229","created_at":"2026-03-30T09:33:29.000000Z","updated_at":"2026-04-07T09:09:27.000000Z"}]},{"id":9889939,"change_date":"2025-10-08 21:41:00","inspection_id":"85993873","dot_number":"2253297","report_state":"TX","report_number":"79BA9DGX0W","insp_date":"2025-10-03 00:00:00","insp_start_time":"1001","insp_end_time":"1053","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"10000  RED BLUFF S\/B","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"GULF COAST LIMESTONE","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-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"125200","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":"9718851","transaction_code":"A","transaction_date":"2025-10-08 00:00:00","upload_date":"2025-10-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02253297","upload_search_indicator":"M","census_search_date":"2025-10-08 21:41:00","snet_input_date":"2025-10-03 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-10-08 21:41:00","insp_carrier_name":"ER TRUCKING SERVICES LLC","insp_carrier_street":"2617 BISBEE STREET","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0247612","created_at":"2025-10-11T10:01:51.000000Z","updated_at":"2025-10-12T10:01:16.000000Z","inspection_violations":[{"id":16309048,"change_date":"2025-10-08 21:41:00","inspection_id":"85993873","insp_violation_id":"269183290","seq_no":"1","part_no":"392","part_no_section":"2W","insp_viol_unit":"1","insp_unit_id":"209368119","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-11T10:18:13.000000Z","updated_at":"2025-10-12T10:16:41.000000Z","normalized_code":"3922W"},{"id":16309049,"change_date":"2025-10-08 21:41:00","inspection_id":"85993873","insp_violation_id":"269183291","seq_no":"2","part_no":"392","part_no_section":"2W","insp_viol_unit":"2","insp_unit_id":"209368120","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-11T10:18:13.000000Z","updated_at":"2025-10-12T10:16:41.000000Z","normalized_code":"3922W"},{"id":16309050,"change_date":"2025-10-08 21:41:00","inspection_id":"85993873","insp_violation_id":"269183292","seq_no":"3","part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"2","insp_unit_id":"209368120","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-11T10:18:13.000000Z","updated_at":"2025-10-12T10:16:41.000000Z","normalized_code":"39345B2UV"}],"inspection_per_units":[{"id":16409191,"change_date":"2025-10-08 21:41:00","inspection_id":"85993873","insp_unit_id":"209368119","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"675","insp_unit_license":"1L33778","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD49X3EJ400544","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-11T09:47:15.000000Z","updated_at":"2025-10-12T09:46:37.000000Z"},{"id":16409192,"change_date":"2025-10-08 21:41:00","inspection_id":"85993873","insp_unit_id":"209368120","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CLEM","insp_unit_company":null,"insp_unit_license":"205C676","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5C2BB32B0EM008880","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-11T09:47:15.000000Z","updated_at":"2025-10-12T09:46:37.000000Z"}]},{"id":9744660,"change_date":"2025-09-22 21:39:00","inspection_id":"85841528","dot_number":"2253297","report_state":"TX","report_number":"78XA9DDAAX","insp_date":"2025-09-19 00:00:00","insp_start_time":"1026","insp_end_time":"1104","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"5700  OLD HWY 146","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-09-22 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"140570","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":"9702196","transaction_code":"A","transaction_date":"2025-09-22 00:00:00","upload_date":"2025-09-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02253297","upload_search_indicator":"M","census_search_date":"2025-09-22 21:39:00","snet_input_date":"2025-09-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-09-22 21:39:00","insp_carrier_name":"ER TRUCKING SERVICES LLC","insp_carrier_street":"2617 BISBEE STREET","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0247612","created_at":"2025-09-25T10:00:26.000000Z","updated_at":"2025-09-25T10:00:26.000000Z","inspection_violations":[{"id":16007499,"change_date":"2025-09-22 21:39:00","inspection_id":"85841528","insp_violation_id":"268844234","seq_no":"1","part_no":"393","part_no_section":"83G","insp_viol_unit":"1","insp_unit_id":"209077276","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-25T10:15:40.000000Z","updated_at":"2025-09-26T10:16:03.000000Z","normalized_code":"39383G"},{"id":16007500,"change_date":"2025-09-22 21:39:00","inspection_id":"85841528","insp_violation_id":"268844235","seq_no":"2","part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"1","insp_unit_id":"209077276","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-25T10:15:40.000000Z","updated_at":"2025-09-26T10:16:03.000000Z","normalized_code":"39345B2UV"},{"id":16007501,"change_date":"2025-09-22 21:39:00","inspection_id":"85841528","insp_violation_id":"268844236","seq_no":"3","part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"1","insp_unit_id":"209077276","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-25T10:15:40.000000Z","updated_at":"2025-09-26T10:16:03.000000Z","normalized_code":"39345B2UV"}],"inspection_per_units":[{"id":16139388,"change_date":"2025-09-22 21:39:00","inspection_id":"85841528","insp_unit_id":"209077277","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BRAZ","insp_unit_company":"679","insp_unit_license":"DK9961","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"4B9BKDG20SH054801","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-25T09:45:27.000000Z","updated_at":"2025-09-26T09:45:42.000000Z"},{"id":16139387,"change_date":"2025-09-22 21:39:00","inspection_id":"85841528","insp_unit_id":"209077276","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"679","insp_unit_license":"1N67088","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDP40X57J160675","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-25T09:45:27.000000Z","updated_at":"2025-09-26T09:45:42.000000Z"}]},{"id":9548342,"change_date":"2025-08-29 21:41:00","inspection_id":"85635893","dot_number":"2253297","report_state":"TX","report_number":"788A9DGT44","insp_date":"2025-08-25 00:00:00","insp_start_time":"1025","insp_end_time":"1055","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"1300  FEDERAL","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"LOAD SITE","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-08-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"9680200","transaction_code":"A","transaction_date":"2025-08-29 00:00:00","upload_date":"2025-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02253297","upload_search_indicator":"M","census_search_date":"2025-08-29 21:41:00","snet_input_date":"2025-08-25 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-08-29 21:41:00","insp_carrier_name":"ER TRUCKING SERVICES LLC","insp_carrier_street":"2617 BISBEE STREET","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0247612","created_at":"2025-09-06T10:42:35.000000Z","updated_at":"2025-09-06T10:42:35.000000Z","inspection_violations":[{"id":15589765,"change_date":"2025-08-29 21:41:00","inspection_id":"85635893","insp_violation_id":"268352502","seq_no":"2","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"208663991","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-06T10:46:26.000000Z","updated_at":"2025-09-06T10:46:26.000000Z","normalized_code":"39395F"}],"inspection_per_units":[{"id":15760113,"change_date":"2025-08-29 21:41:00","inspection_id":"85635893","insp_unit_id":"208663991","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"678","insp_unit_license":"VCT8265","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2XKDDB9X97M184695","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:46:55.000000Z","updated_at":"2025-09-09T09:46:55.000000Z"}]},{"id":9584360,"change_date":"2025-09-03 21:40:00","inspection_id":"85673200","dot_number":"2253297","report_state":"TX","report_number":"782B9DDA9S","insp_date":"2025-08-19 00:00:00","insp_start_time":"1112","insp_end_time":"1142","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"1600  BAYPORT BLVD","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-09-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"9684763","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":"02253297","upload_search_indicator":"M","census_search_date":"2025-09-03 21:40:00","snet_input_date":"2025-08-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-09-03 21:40:00","insp_carrier_name":"ER TRUCKING SERVICES LLC","insp_carrier_street":"2617 BISBEE STREET","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0247612","created_at":"2025-09-06T10:43:30.000000Z","updated_at":"2025-09-10T10:44:58.000000Z","inspection_violations":[{"id":15656671,"change_date":"2025-09-03 21:40:00","inspection_id":"85673200","insp_violation_id":"268437988","seq_no":"1","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"208731607","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-06T10:48:13.000000Z","updated_at":"2025-09-06T10:48:13.000000Z","normalized_code":"3939"},{"id":15656672,"change_date":"2025-09-03 21:40:00","inspection_id":"85673200","insp_violation_id":"268437989","seq_no":"2","part_no":"393","part_no_section":"201A","insp_viol_unit":"1","insp_unit_id":"208731607","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-06T10:48:13.000000Z","updated_at":"2025-09-06T10:48:13.000000Z","normalized_code":"393201A"},{"id":15656673,"change_date":"2025-09-03 21:40:00","inspection_id":"85673200","insp_violation_id":"268437990","seq_no":"3","part_no":"393","part_no_section":"45DLUV","insp_viol_unit":"1","insp_unit_id":"208731607","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-06T10:48:13.000000Z","updated_at":"2025-09-06T10:48:13.000000Z","normalized_code":"39345DLUV"}],"inspection_per_units":[{"id":15822608,"change_date":"2025-09-03 21:40:00","inspection_id":"85673200","insp_unit_id":"208731607","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"876","insp_unit_license":"VCT8265","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2XKDDB9X97M184695","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":9336161,"change_date":"2025-08-05 21:39:00","inspection_id":"85412302","dot_number":"2253297","report_state":"TX","report_number":"77JF9DGX12","insp_date":"2025-07-31 00:00:00","insp_start_time":"1513","insp_end_time":"1543","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"9000  BAY AREA BLVD","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":"2025-08-05 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"140570","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":"9656676","transaction_code":"A","transaction_date":"2025-08-05 00:00:00","upload_date":"2025-08-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02253297","upload_search_indicator":"M","census_search_date":"2025-08-05 21:39:00","snet_input_date":"2025-07-31 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-08-05 21:39:00","insp_carrier_name":"ER TRUCKING SERVICES LLC","insp_carrier_street":"2617 BISBEE STREET","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0247612","created_at":"2025-08-08T10:01:23.000000Z","updated_at":"2025-08-12T10:42:02.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15377155,"change_date":"2025-08-05 21:39:00","inspection_id":"85412302","insp_unit_id":"208250670","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"679","insp_unit_license":"1N67088","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDP40X57J160675","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-08T09:46:35.000000Z","updated_at":"2025-08-09T09:46:04.000000Z"},{"id":15377156,"change_date":"2025-08-05 21:39:00","inspection_id":"85412302","insp_unit_id":"208250671","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BRAZ","insp_unit_company":null,"insp_unit_license":"DK9961","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"4B9BKDG20SH054801","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-08T09:46:35.000000Z","updated_at":"2025-08-09T09:46:04.000000Z"}]},{"id":8898762,"change_date":"2025-06-13 21:41:00","inspection_id":"84951464","dot_number":"2253297","report_state":"TX","report_number":"V251911424","insp_date":"2025-06-10 00:00:00","insp_start_time":"1210","insp_end_time":"1249","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SAM HOUSTON TOLLWAY","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"VARIOUS","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-06-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","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":"9606531","transaction_code":"A","transaction_date":"2025-06-13 00:00:00","upload_date":"2025-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02253297","upload_search_indicator":"M","census_search_date":"2025-06-13 21:41:00","snet_input_date":"2025-06-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-06-13 21:41:00","insp_carrier_name":"ER TRUCKING SERVICES LLC","insp_carrier_street":"2617 BISBEE STREET","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0247612","created_at":"2025-06-16T10:01:16.000000Z","updated_at":"2025-06-17T10:00:48.000000Z","inspection_violations":[{"id":14266669,"change_date":"2025-06-13 21:41:00","inspection_id":"84951464","insp_violation_id":"266843268","seq_no":"1","part_no":"393","part_no_section":"55C1","insp_viol_unit":"1","insp_unit_id":"207385430","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-17T10:17:51.000000Z","updated_at":"2025-06-17T10:21:16.000000Z","normalized_code":"39355C1"},{"id":14266670,"change_date":"2025-06-13 21:41:00","inspection_id":"84951464","insp_violation_id":"266843269","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"207385430","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-17T10:17:51.000000Z","updated_at":"2025-06-17T10:21:16.000000Z","normalized_code":"39378"},{"id":14266671,"change_date":"2025-06-13 21:41:00","inspection_id":"84951464","insp_violation_id":"266843270","seq_no":"3","part_no":"393","part_no_section":"79","insp_viol_unit":"1","insp_unit_id":"207385430","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-17T10:17:51.000000Z","updated_at":"2025-06-17T10:21:16.000000Z","normalized_code":"39379"}],"inspection_per_units":[{"id":14578668,"change_date":"2025-06-13 21:41:00","inspection_id":"84951464","insp_unit_id":"207385430","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"676","insp_unit_license":"TZN1636","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP5DB9X36N876626","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-16T09:46:43.000000Z","updated_at":"2025-06-17T09:46:05.000000Z"}]},{"id":8321169,"change_date":"2025-04-08 21:40:00","inspection_id":"84341768","dot_number":"2253297","report_state":"TX","report_number":"749F9DAPOU","insp_date":"2025-04-04 00:00:00","insp_start_time":"1510","insp_end_time":"1530","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"200 E SAM HOUSTON PK","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-04-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"125200","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":"9543720","transaction_code":"A","transaction_date":"2025-04-08 00:00:00","upload_date":"2025-04-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02253297","upload_search_indicator":"M","census_search_date":"2025-04-08 21:40:00","snet_input_date":"2025-04-04 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-04-08 21:40:00","insp_carrier_name":"ER TRUCKING SERVICES LLC","insp_carrier_street":"2617 BISBEE STREET","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0247612","created_at":"2025-04-11T10:12:23.000000Z","updated_at":"2025-04-12T10:22:27.000000Z","inspection_violations":[{"id":13095724,"change_date":"2025-04-08 21:40:00","inspection_id":"84341768","insp_violation_id":"265501430","seq_no":"1","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"206206347","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-11T10:40:39.000000Z","updated_at":"2025-04-11T10:49:18.000000Z","normalized_code":"39360C"}],"inspection_per_units":[{"id":13495618,"change_date":"2025-04-08 21:40:00","inspection_id":"84341768","insp_unit_id":"206206347","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"675","insp_unit_license":"1L33778","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD49X3EJ400544","insp_unit_decal":"Y","insp_unit_decal_number":"35129854","created_at":"2025-04-11T10:06:05.000000Z","updated_at":"2025-04-12T10:01:15.000000Z"},{"id":13495619,"change_date":"2025-04-08 21:40:00","inspection_id":"84341768","insp_unit_id":"206206348","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CLEM","insp_unit_company":null,"insp_unit_license":"205C676","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5C2BB32B0EM008880","insp_unit_decal":"Y","insp_unit_decal_number":"35129855","created_at":"2025-04-11T10:06:05.000000Z","updated_at":"2025-04-12T10:01:15.000000Z"}]},{"id":8169460,"change_date":"2025-03-20 21:42:00","inspection_id":"84182095","dot_number":"2253297","report_state":"TX","report_number":"73S99DJV3Y","insp_date":"2025-03-18 00:00:00","insp_start_time":"0932","insp_end_time":"1005","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":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-03-20 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"9527744","transaction_code":"A","transaction_date":"2025-03-20 00:00:00","upload_date":"2025-03-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02253297","upload_search_indicator":"M","census_search_date":"2025-03-20 21:42:00","snet_input_date":"2025-03-18 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-03-20 21:42:00","insp_carrier_name":"ER TRUCKING SERVICES LLC","insp_carrier_street":"2617 BISBEE STREET","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0247612","created_at":"2025-03-23T10:52:51.000000Z","updated_at":"2025-03-24T10:26:26.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13203689,"change_date":"2025-03-20 21:42:00","inspection_id":"84182095","insp_unit_id":"205910603","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"678","insp_unit_license":"VCT8265","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2XKDDB9X97M184695","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-23T10:17:27.000000Z","updated_at":"2025-03-24T10:06:26.000000Z"}]},{"id":8024316,"change_date":"2025-03-04 21:39:00","inspection_id":"84029299","dot_number":"2253297","report_state":"TX","report_number":"737B9DNO03","insp_date":"2025-02-25 00:00:00","insp_start_time":"1112","insp_end_time":"1147","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0225 IN HARRIS CO. (686-700","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-03-04 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","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":"9512910","transaction_code":"A","transaction_date":"2025-03-04 00:00:00","upload_date":"2025-03-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02253297","upload_search_indicator":"M","census_search_date":"2025-03-04 21:39:00","snet_input_date":"2025-02-25 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-03-04 21:39:00","insp_carrier_name":"ER TRUCKING SERVICES LLC","insp_carrier_street":"2617 BISBEE STREET","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0247612","created_at":"2025-03-17T21:04:55.000000Z","updated_at":"2025-03-17T21:04:55.000000Z","inspection_violations":[{"id":12539097,"change_date":"2025-03-04 21:39:00","inspection_id":"84029299","insp_violation_id":"264827029","seq_no":"1","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"205622039","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:16.000000Z","updated_at":"2025-03-17T22:07:16.000000Z","normalized_code":"39347E"},{"id":12539098,"change_date":"2025-03-04 21:39:00","inspection_id":"84029299","insp_violation_id":"264827030","seq_no":"2","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"205622039","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:16.000000Z","updated_at":"2025-03-17T22:07:16.000000Z","normalized_code":"39353B"},{"id":12539099,"change_date":"2025-03-04 21:39:00","inspection_id":"84029299","insp_violation_id":"264827031","seq_no":"3","part_no":"393","part_no_section":"55D1","insp_viol_unit":"1","insp_unit_id":"205622039","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:16.000000Z","updated_at":"2025-03-17T22:07:16.000000Z","normalized_code":"39355D1"},{"id":12539100,"change_date":"2025-03-04 21:39:00","inspection_id":"84029299","insp_violation_id":"264827032","seq_no":"4","part_no":"396","part_no_section":"3A1","insp_viol_unit":"1","insp_unit_id":"205622039","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:16.000000Z","updated_at":"2025-03-17T22:07:16.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":12954643,"change_date":"2025-03-04 21:39:00","inspection_id":"84029299","insp_unit_id":"205622039","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"676","insp_unit_license":"TZN1636","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP5DB9X36N876626","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:58:05.000000Z","updated_at":"2025-03-17T23:58:05.000000Z"}]},{"id":7846379,"change_date":"2025-02-12 21:39:00","inspection_id":"83842691","dot_number":"2253297","report_state":"TX","report_number":"V251777357","insp_date":"2025-02-05 00:00:00","insp_start_time":"0920","insp_end_time":"0944","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"TX242 TX242","county_code_state":"TX","county_code":"339","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HEIDELBERG","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-02-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9495137","transaction_code":"C","transaction_date":"2025-02-12 00:00:00","upload_date":"2025-02-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02253297","upload_search_indicator":"M","census_search_date":"2025-02-11 21:40:00","snet_input_date":"2025-02-05 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-02-11 21:40:00","insp_carrier_name":"ER TRUCKING SERVICES LLC","insp_carrier_street":"2617 BISBEE STREET","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0247612","created_at":"2025-03-17T21:01:10.000000Z","updated_at":"2025-03-17T21:01:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12663500,"change_date":"2025-02-12 21:39:00","inspection_id":"83842691","insp_unit_id":"205295112","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"675","insp_unit_license":"1L33778","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD49X3EJ400544","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:52.000000Z","updated_at":"2025-03-17T23:54:52.000000Z"},{"id":12663501,"change_date":"2025-02-12 21:39:00","inspection_id":"83842691","insp_unit_id":"205295113","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CLEM","insp_unit_company":"T675","insp_unit_license":"205C676","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5C2BB32B0EM008880","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:52.000000Z","updated_at":"2025-03-17T23:54:52.000000Z"}]},{"id":7785445,"change_date":"2025-02-05 21:40:00","inspection_id":"83778689","dot_number":"2253297","report_state":"TX","report_number":"72IA9DNOYN","insp_date":"2025-01-31 00:00:00","insp_start_time":"1002","insp_end_time":"1025","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0225 IN HARRIS CO. (686-700","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"OXY","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-02-04 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"6","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9489110","transaction_code":"C","transaction_date":"2025-02-05 00:00:00","upload_date":"2025-02-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02253297","upload_search_indicator":"M","census_search_date":"2025-02-04 21:40:00","snet_input_date":"2025-01-31 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-02-04 21:40:00","insp_carrier_name":"ER TRUCKING SERVICES LLC","insp_carrier_street":"2617 BISBEE STREET","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0247612","created_at":"2025-03-17T20:59:54.000000Z","updated_at":"2025-03-17T20:59:54.000000Z","inspection_violations":[{"id":12165751,"change_date":"2025-02-05 21:40:00","inspection_id":"83778689","insp_violation_id":"264358173","seq_no":"1","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"205175324","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:22.000000Z","updated_at":"2025-03-17T22:05:22.000000Z","normalized_code":"39347E"},{"id":12165752,"change_date":"2025-02-05 21:40:00","inspection_id":"83778689","insp_violation_id":"264358174","seq_no":"2","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"205175324","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:22.000000Z","updated_at":"2025-03-17T22:05:22.000000Z","normalized_code":"39353B"},{"id":12165753,"change_date":"2025-02-05 21:40:00","inspection_id":"83778689","insp_violation_id":"264358175","seq_no":"3","part_no":"393","part_no_section":"9TS","insp_viol_unit":"1","insp_unit_id":"205175324","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:22.000000Z","updated_at":"2025-03-17T22:05:22.000000Z","normalized_code":"3939TS"},{"id":12165754,"change_date":"2025-02-05 21:40:00","inspection_id":"83778689","insp_violation_id":"264358176","seq_no":"4","part_no":"393","part_no_section":"19","insp_viol_unit":"1","insp_unit_id":"205175324","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:22.000000Z","updated_at":"2025-03-17T22:05:22.000000Z","normalized_code":"39319"},{"id":12165755,"change_date":"2025-02-05 21:40:00","inspection_id":"83778689","insp_violation_id":"264358177","seq_no":"5","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"205175324","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:22.000000Z","updated_at":"2025-03-17T22:05:22.000000Z","normalized_code":"3939"},{"id":12165756,"change_date":"2025-02-05 21:40:00","inspection_id":"83778689","insp_violation_id":"264358178","seq_no":"6","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"205175324","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:22.000000Z","updated_at":"2025-03-17T22:05:22.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":12564457,"change_date":"2025-02-05 21:40:00","inspection_id":"83778689","insp_unit_id":"205175324","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"678","insp_unit_license":"VCT8265","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2XKDDB9X97M184695","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:53:45.000000Z","updated_at":"2025-03-17T23:53:45.000000Z"}]},{"id":7520271,"change_date":"2024-12-30 21:39:00","inspection_id":"83500040","dot_number":"2253297","report_state":"TX","report_number":"71AB9DFP2C","insp_date":"2024-12-18 00:00:00","insp_start_time":"1120","insp_end_time":"1210","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"200 E SAM HOUSTON PK","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HEIDELBERG MATERIALS","shipping_paper_number":"1997519707","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-12-30 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","viol_total":"6","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9460692","transaction_code":"A","transaction_date":"2024-12-30 00:00:00","upload_date":"2024-12-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02253297","upload_search_indicator":"M","census_search_date":"2024-12-30 21:39:00","snet_input_date":"2024-12-18 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-12-30 21:39:00","insp_carrier_name":"ER TRUCKING SERVICES LLC","insp_carrier_street":"2617 BISBEE STREET","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0247612","created_at":"2025-03-17T20:53:08.000000Z","updated_at":"2025-03-17T20:53:08.000000Z","inspection_violations":[{"id":11753893,"change_date":"2024-12-30 21:39:00","inspection_id":"83500040","insp_violation_id":"263697797","seq_no":"1","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"204595337","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:16.000000Z","updated_at":"2025-03-17T22:03:16.000000Z","normalized_code":"39347E"},{"id":11753894,"change_date":"2024-12-30 21:39:00","inspection_id":"83500040","insp_violation_id":"263697798","seq_no":"2","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"204595337","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:16.000000Z","updated_at":"2025-03-17T22:03:16.000000Z","normalized_code":"39347E"},{"id":11753895,"change_date":"2024-12-30 21:39:00","inspection_id":"83500040","insp_violation_id":"263697799","seq_no":"3","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"204595337","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:16.000000Z","updated_at":"2025-03-17T22:03:16.000000Z","normalized_code":"39353B"},{"id":11753896,"change_date":"2024-12-30 21:39:00","inspection_id":"83500040","insp_violation_id":"263697800","seq_no":"4","part_no":"393","part_no_section":"55D1","insp_viol_unit":"1","insp_unit_id":"204595337","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:16.000000Z","updated_at":"2025-03-17T22:03:16.000000Z","normalized_code":"39355D1"},{"id":11753897,"change_date":"2024-12-30 21:39:00","inspection_id":"83500040","insp_violation_id":"263697801","seq_no":"5","part_no":"393","part_no_section":"207G","insp_viol_unit":"1","insp_unit_id":"204595337","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:16.000000Z","updated_at":"2025-03-17T22:03:16.000000Z","normalized_code":"393207G"},{"id":11753898,"change_date":"2024-12-30 21:39:00","inspection_id":"83500040","insp_violation_id":"263697802","seq_no":"6","part_no":"392","part_no_section":"2W","insp_viol_unit":"1","insp_unit_id":"204595337","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:16.000000Z","updated_at":"2025-03-17T22:03:16.000000Z","normalized_code":"3922W"}],"inspection_per_units":[{"id":12132495,"change_date":"2024-12-30 21:39:00","inspection_id":"83500040","insp_unit_id":"204595337","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"676","insp_unit_license":"TZN1636","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP5DB9X36N876626","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:48:57.000000Z","updated_at":"2025-03-17T23:48:57.000000Z"}]},{"id":6713373,"change_date":"2024-09-12 21:42:00","inspection_id":"82645859","dot_number":"2253297","report_state":"TX","report_number":"6YJ79DGPBM","insp_date":"2024-09-10 00:00:00","insp_start_time":"0712","insp_end_time":"0747","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"13500  EAST FWY","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-09-12 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","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":"9375797","transaction_code":"A","transaction_date":"2024-09-12 00:00:00","upload_date":"2024-09-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02253297","upload_search_indicator":"M","census_search_date":"2024-09-12 21:42:00","snet_input_date":"2024-09-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-09-12 21:42:00","insp_carrier_name":"ER TRUCKING SERVICES LLC","insp_carrier_street":"2617 BISBEE STREET","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0247612","created_at":"2025-03-17T20:36:07.000000Z","updated_at":"2025-03-17T20:36:07.000000Z","inspection_violations":[{"id":10450429,"change_date":"2024-09-12 21:42:00","inspection_id":"82645859","insp_violation_id":"261770297","seq_no":"1","part_no":"393","part_no_section":"55(c)(2)","insp_viol_unit":"1","insp_unit_id":"202896795","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:37.000000Z","updated_at":"2025-03-17T21:56:37.000000Z","normalized_code":"39355C2"},{"id":10450430,"change_date":"2024-09-12 21:42:00","inspection_id":"82645859","insp_violation_id":"261770298","seq_no":"2","part_no":"393","part_no_section":"83(g)","insp_viol_unit":"1","insp_unit_id":"202896795","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:37.000000Z","updated_at":"2025-03-17T21:56:37.000000Z","normalized_code":"39383G"}],"inspection_per_units":[{"id":10825122,"change_date":"2024-09-12 21:42:00","inspection_id":"82645859","insp_unit_id":"202896795","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"676","insp_unit_license":"TZN1636","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP5DB9X36N876626","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:07.000000Z","updated_at":"2025-03-17T23:35:07.000000Z"}]},{"id":6119552,"change_date":"2024-07-01 21:44:00","inspection_id":"82011181","dot_number":"2253297","report_state":"TX","report_number":"6WBB9DNJ08","insp_date":"2024-06-22 00:00:00","insp_start_time":"1046","insp_end_time":"1115","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0225 IN HARRIS CO. (686-700","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":"2024-07-01 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","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":"9313234","transaction_code":"A","transaction_date":"2024-07-01 00:00:00","upload_date":"2024-07-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02253297","upload_search_indicator":"M","census_search_date":"2024-07-01 21:44:00","snet_input_date":"2024-06-22 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-07-01 21:44:00","insp_carrier_name":"ER TRUCKING SERVICES LLC","insp_carrier_street":"2617 BISBEE STREET","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0247612","created_at":"2025-03-17T20:23:49.000000Z","updated_at":"2025-03-17T20:23:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9857008,"change_date":"2024-07-01 21:44:00","inspection_id":"82011181","insp_unit_id":"201680922","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"676","insp_unit_license":"TZN1636","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP5DB9X36N876626","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:08.000000Z","updated_at":"2025-03-17T23:25:08.000000Z"}]},{"id":5634173,"change_date":"2024-04-30 21:42:00","inspection_id":"81485335","dot_number":"2253297","report_state":"TX","report_number":"6UTE9DJVBR","insp_date":"2024-04-29 00:00:00","insp_start_time":"1406","insp_end_time":"1434","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":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":"2024-04-30 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9261045","transaction_code":"A","transaction_date":"2024-04-30 00:00:00","upload_date":"2024-04-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02253297","upload_search_indicator":"M","census_search_date":"2024-04-30 21:42:00","snet_input_date":"2024-04-29 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-04-30 21:42:00","insp_carrier_name":"ER TRUCKING SERVICES LLC","insp_carrier_street":"2617 BISBEE STREET","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0247612","created_at":"2025-03-17T20:14:19.000000Z","updated_at":"2025-03-17T20:14:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9075376,"change_date":"2024-04-30 21:42:00","inspection_id":"81485335","insp_unit_id":"200653738","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"675","insp_unit_license":"1L33778","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD49X3EJ400544","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:27.000000Z","updated_at":"2025-03-17T23:17:27.000000Z"},{"id":9075377,"change_date":"2024-04-30 21:42:00","inspection_id":"81485335","insp_unit_id":"200653739","insp_unit_type_id":"10","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"205C676","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5C2BB32B0EM008880","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:27.000000Z","updated_at":"2025-03-17T23:17:27.000000Z"}]},{"id":5461429,"change_date":"2024-04-08 21:44:00","inspection_id":"81296708","dot_number":"2253297","report_state":"TX","report_number":"6U3C9DJZIO","insp_date":"2024-04-03 00:00:00","insp_start_time":"1240","insp_end_time":"1255","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SL-0336 IN MONTGOMERY CO. (674","county_code_state":"TX","county_code":"339","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ER TRUCKING SERVICES LLC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-04-08 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"70000","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":"9241313","transaction_code":"A","transaction_date":"2024-04-08 00:00:00","upload_date":"2024-04-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02253297","upload_search_indicator":"M","census_search_date":"2024-04-08 21:44:00","snet_input_date":"2024-04-03 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-04-08 21:44:00","insp_carrier_name":"ER TRUCKING SERVICES LLC","insp_carrier_street":"2617 BISBEE STREET","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0247612","created_at":"2025-03-17T20:11:07.000000Z","updated_at":"2025-03-17T20:11:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8797268,"change_date":"2024-04-08 21:44:00","inspection_id":"81296708","insp_unit_id":"200292331","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"TZN1636","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP5DB9X36N876626","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:49.000000Z","updated_at":"2025-03-17T23:14:49.000000Z"}]},{"id":5309289,"change_date":"2024-03-18 21:39:00","inspection_id":"81130820","dot_number":"2253297","report_state":"TX","report_number":"V241354028","insp_date":"2024-03-15 00:00:00","insp_start_time":"1307","insp_end_time":"1329","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"8443 FM1464 NB","county_code_state":"TX","county_code":"157","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HEIDELBERG","shipping_paper_number":"1150857","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-03-18 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"70000","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":"9225776","transaction_code":"A","transaction_date":"2024-03-18 00:00:00","upload_date":"2024-03-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02253297","upload_search_indicator":"M","census_search_date":"2024-03-18 21:39:00","snet_input_date":"2024-03-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-03-18 21:39:00","insp_carrier_name":"ER TRUCKING SERVICES LLC","insp_carrier_street":"2617 BISBEE STREET","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0247612","created_at":"2025-03-17T20:07:53.000000Z","updated_at":"2025-03-17T20:07:53.000000Z","inspection_violations":[{"id":8189624,"change_date":"2024-03-18 21:39:00","inspection_id":"81130820","insp_violation_id":"258441595","seq_no":"1","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"199964360","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:35.000000Z","updated_at":"2025-03-17T21:45:35.000000Z","normalized_code":"39345D"},{"id":8189625,"change_date":"2024-03-18 21:39:00","inspection_id":"81130820","insp_violation_id":"258441596","seq_no":"2","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"199964360","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:35.000000Z","updated_at":"2025-03-17T21:45:35.000000Z","normalized_code":"39345D"},{"id":8189626,"change_date":"2024-03-18 21:39:00","inspection_id":"81130820","insp_violation_id":"258441597","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199964360","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:35.000000Z","updated_at":"2025-03-17T21:45:35.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":8550559,"change_date":"2024-03-18 21:39:00","inspection_id":"81130820","insp_unit_id":"199964360","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"678","insp_unit_license":"JMC9372","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2XKDDB9X97M184695","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:31.000000Z","updated_at":"2025-03-17T23:12:31.000000Z"}]},{"id":4529962,"change_date":"2023-11-30 21:39:00","inspection_id":"80278865","dot_number":"2253297","report_state":"TX","report_number":"6QLE9DJVW1","insp_date":"2023-11-29 00:00:00","insp_start_time":"1404","insp_end_time":"1429","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"3000  COLLINGSWORTH","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-11-30 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","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":"9136947","transaction_code":"A","transaction_date":"2023-11-30 00:00:00","upload_date":"2023-11-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02253297","upload_search_indicator":null,"census_search_date":"2023-11-30 21:39:00","snet_input_date":"2023-11-29 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-11-30 21:39:00","insp_carrier_name":"EDILBERTO RAMIREZ","insp_carrier_street":"8926 EDGEBROOK DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77075","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0247612","created_at":"2025-03-17T19:52:35.000000Z","updated_at":"2025-03-17T19:52:35.000000Z","inspection_violations":[{"id":7009191,"change_date":"2023-11-30 21:39:00","inspection_id":"80278865","insp_violation_id":"256646780","seq_no":"1","part_no":"393","part_no_section":"55(c)(2)","insp_viol_unit":"1","insp_unit_id":"198289335","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:48.000000Z","updated_at":"2025-03-17T21:39:48.000000Z","normalized_code":"39355C2"},{"id":7009192,"change_date":"2023-11-30 21:39:00","inspection_id":"80278865","insp_violation_id":"256646781","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198289335","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:48.000000Z","updated_at":"2025-03-17T21:39:48.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":7285580,"change_date":"2023-11-30 21:39:00","inspection_id":"80278865","insp_unit_id":"198289335","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"676","insp_unit_license":"JSY2944","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP5DB9X36N876626","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:13.000000Z","updated_at":"2025-03-17T23:01:13.000000Z"}]},{"id":4562828,"change_date":"2023-12-05 21:43:00","inspection_id":"80315148","dot_number":"2253297","report_state":"TX","report_number":"6QK89DGAV8","insp_date":"2023-11-28 00:00:00","insp_start_time":"0825","insp_end_time":"0856","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0003 IN GALVESTON CO. (492-","county_code_state":"TX","county_code":"167","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-12-05 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"70000","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":"9139503","transaction_code":"A","transaction_date":"2023-12-05 00:00:00","upload_date":"2023-12-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02253297","upload_search_indicator":null,"census_search_date":"2023-12-05 21:43:00","snet_input_date":"2023-11-28 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-12-05 21:43:00","insp_carrier_name":"EDILBERTO RAMIREZ","insp_carrier_street":"8926 EDGEBROOK DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77075","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0247612","created_at":"2025-03-17T19:53:22.000000Z","updated_at":"2025-03-17T19:53:22.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7338665,"change_date":"2023-12-05 21:43:00","inspection_id":"80315148","insp_unit_id":"198361163","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"V-695","insp_unit_license":"JMC9372","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2XKDDB9X97M184695","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:39.000000Z","updated_at":"2025-03-17T23:01:39.000000Z"}]},{"id":4229622,"change_date":"2023-10-18 21:42:00","inspection_id":"79947314","dot_number":"2253297","report_state":"TX","report_number":"6PDA9DGPX2","insp_date":"2023-10-16 00:00:00","insp_start_time":"0944","insp_end_time":"1028","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"13500  EAST FWY","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"GULF COAST LIMESTONE","shipping_paper_number":"1119958","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-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","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":"9103826","transaction_code":"A","transaction_date":"2023-10-18 00:00:00","upload_date":"2023-10-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02253297","upload_search_indicator":null,"census_search_date":"2023-10-18 21:42:00","snet_input_date":"2023-10-16 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-10-18 21:42:00","insp_carrier_name":"EDILBERTO RAMIREZ","insp_carrier_street":"8926 EDGEBROOK DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77075","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0247612","created_at":"2025-03-17T19:46:37.000000Z","updated_at":"2025-03-17T19:46:37.000000Z","inspection_violations":[{"id":6548860,"change_date":"2023-10-18 21:42:00","inspection_id":"79947314","insp_violation_id":"255918566","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"197628825","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:34.000000Z","updated_at":"2025-03-17T21:37:34.000000Z","normalized_code":"39347E"},{"id":6548861,"change_date":"2023-10-18 21:42:00","inspection_id":"79947314","insp_violation_id":"255918567","seq_no":"2","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"197628825","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:34.000000Z","updated_at":"2025-03-17T21:37:34.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":6802215,"change_date":"2023-10-18 21:42:00","inspection_id":"79947314","insp_unit_id":"197628825","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"676","insp_unit_license":"JSY2944","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP5DB9X36N876626","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:01.000000Z","updated_at":"2025-03-17T22:57:01.000000Z"}]},{"id":2957257,"change_date":"2023-05-03 21:42:00","inspection_id":"78522206","dot_number":"2253297","report_state":"TX","report_number":"6KI79DMF6H","insp_date":"2023-04-24 00:00:00","insp_start_time":"0716","insp_end_time":"0750","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0225 IN HARRIS CO. (686-700","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-05-03 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"133200","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":"8968900","transaction_code":"A","transaction_date":"2023-05-03 00:00:00","upload_date":"2023-05-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02253297","upload_search_indicator":null,"census_search_date":"2023-05-03 21:42:00","snet_input_date":"2023-04-24 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-05-03 21:42:00","insp_carrier_name":"EDILBERTO RAMIREZ","insp_carrier_street":"8926 EDGEBROOK DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77075","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0247612","created_at":"2025-03-17T19:21:25.000000Z","updated_at":"2025-03-17T19:21:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4758697,"change_date":"2023-05-03 21:42:00","inspection_id":"78522206","insp_unit_id":"194732771","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"675","insp_unit_license":"1L33778","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD49X3EJ400544","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:30.000000Z","updated_at":"2025-03-17T22:40:30.000000Z"},{"id":4758698,"change_date":"2023-05-03 21:42:00","inspection_id":"78522206","insp_unit_id":"194732772","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CLEM","insp_unit_company":null,"insp_unit_license":"205C676","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5C2BB32B0EM008880","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:30.000000Z","updated_at":"2025-03-17T22:40:30.000000Z"}]},{"id":3003860,"change_date":"2023-05-09 21:42:00","inspection_id":"78575082","dot_number":"2253297","report_state":"TX","report_number":"6KIE9DBTKJ","insp_date":"2023-04-24 00:00:00","insp_start_time":"1421","insp_end_time":"1440","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0090 IN HARRIS CO. (806-862","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-05-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","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":"8973678","transaction_code":"A","transaction_date":"2023-05-09 00:00:00","upload_date":"2023-05-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02253297","upload_search_indicator":null,"census_search_date":"2023-05-09 21:42:00","snet_input_date":"2023-04-24 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-05-09 21:42:00","insp_carrier_name":"EDILBERTO RAMIREZ","insp_carrier_street":"8926 EDGEBROOK DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77075","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0247612","created_at":"2025-03-17T19:22:35.000000Z","updated_at":"2025-03-17T19:22:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4833232,"change_date":"2023-05-09 21:42:00","inspection_id":"78575082","insp_unit_id":"194838231","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"2","insp_unit_license":"JSY2944","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP5DB9X36N876626","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:04.000000Z","updated_at":"2025-03-17T22:41:04.000000Z"}]},{"id":1370918,"change_date":"2022-09-26 21:40:00","inspection_id":"76708931","dot_number":"2253297","report_state":"TX","report_number":"6EK99DCO6C","insp_date":"2022-09-22 00:00:00","insp_start_time":"0902","insp_end_time":"0915","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2100  GENOA RED BLUF","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-09-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"8782203","transaction_code":"A","transaction_date":"2022-09-26 00:00:00","upload_date":"2022-09-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02253297","upload_search_indicator":"M","census_search_date":"2022-09-26 21:40:00","snet_input_date":"2022-09-22 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-09-26 21:40:00","insp_carrier_name":"EDILBERTO RAMIREZ","insp_carrier_street":"8926 EDGEBROOK DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77075","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0247612","created_at":"2025-03-17T18:51:59.000000Z","updated_at":"2025-03-17T18:51:59.000000Z","inspection_violations":[{"id":2169059,"change_date":"2022-09-26 21:40:00","inspection_id":"76708931","insp_violation_id":"248656757","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191107288","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:56.000000Z","updated_at":"2025-03-17T21:16:56.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":2207834,"change_date":"2022-09-26 21:40:00","inspection_id":"76708931","insp_unit_id":"191107288","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"678","insp_unit_license":"JMC9372","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2XKDDB9X97M184695","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:07.000000Z","updated_at":"2025-03-17T22:22:07.000000Z"}]},{"id":987174,"change_date":"2022-08-08 21:40:00","inspection_id":"76262692","dot_number":"2253297","report_state":"TX","report_number":"6D489DBZ3Y","insp_date":"2022-08-01 00:00:00","insp_start_time":"0808","insp_end_time":"0821","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"6700  NAVIGATION","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"PICK UP SITE","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-08-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","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":"8735731","transaction_code":"A","transaction_date":"2022-08-08 00:00:00","upload_date":"2022-08-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02253297","upload_search_indicator":"M","census_search_date":"2022-08-08 21:40:00","snet_input_date":"2022-08-01 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-08-08 21:40:00","insp_carrier_name":"EDILBERTO RAMIREZ","insp_carrier_street":"8926 EDGEBROOK DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77075","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0247612","created_at":"2025-03-17T18:45:05.000000Z","updated_at":"2025-03-17T18:45:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1589056,"change_date":"2022-08-08 21:40:00","inspection_id":"76262692","insp_unit_id":"190192307","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"JSY2944","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP5DB9X36N876626","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:00.000000Z","updated_at":"2025-03-17T22:18:00.000000Z"}]},{"id":683332,"change_date":"2022-06-23 21:40:00","inspection_id":"75906752","dot_number":"2253297","report_state":"TX","report_number":"6BNA9DBU3M","insp_date":"2022-06-09 00:00:00","insp_start_time":"1001","insp_end_time":"1017","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"13500  EAST FWY S SR","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"VULCAN MATERIALS CO","shipping_paper_number":"56461366","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-23 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"70000","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":"8693184","transaction_code":"A","transaction_date":"2022-06-23 00:00:00","upload_date":"2022-06-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02253297","upload_search_indicator":"M","census_search_date":"2022-06-23 21:40:00","snet_input_date":"2022-06-09 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-06-23 21:40:00","insp_carrier_name":"EDILBERTO RAMIREZ","insp_carrier_street":"8926 EDGEBROOK DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77075","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0247612","created_at":"2025-03-17T18:39:48.000000Z","updated_at":"2025-03-17T18:39:48.000000Z","inspection_violations":[{"id":1074986,"change_date":"2022-06-23 21:40:00","inspection_id":"75906752","insp_violation_id":"246686507","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"189435380","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:02.000000Z","updated_at":"2025-03-17T21:12:02.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":1098159,"change_date":"2022-06-23 21:40:00","inspection_id":"75906752","insp_unit_id":"189435380","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"678","insp_unit_license":"JMC9372","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2XKDDB9X97M184695","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:57.000000Z","updated_at":"2025-03-17T22:14:57.000000Z"}]},{"id":312048,"change_date":"2022-05-03 21:39:00","inspection_id":"75465462","dot_number":"2253297","report_state":"TX","report_number":"6AG89DGAG7","insp_date":"2022-04-27 00:00:00","insp_start_time":"0815","insp_end_time":"0845","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":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"VULCAN","shipping_paper_number":"5645508","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-03 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","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":"8642779","transaction_code":"A","transaction_date":"2022-05-03 00:00:00","upload_date":"2022-05-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02253297","upload_search_indicator":"M","census_search_date":"2022-05-03 21:39:00","snet_input_date":"2022-04-27 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-05-03 21:39:00","insp_carrier_name":"EDILBERTO RAMIREZ","insp_carrier_street":"8926 EDGEBROOK DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77075","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0247612","created_at":"2025-03-17T18:32:58.000000Z","updated_at":"2025-03-17T18:32:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":504990,"change_date":"2022-05-03 21:39:00","inspection_id":"75465462","insp_unit_id":"188485615","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"V-626","insp_unit_license":"JSY2944","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP5DB9X36N876626","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:17.000000Z","updated_at":"2025-03-17T22:11:17.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2253297\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2253297\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2253297\/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\/2253297\/inspections","per_page":100,"prev_page_url":null,"to":29,"total":29}