{"current_page":1,"data":[{"id":12748910,"change_date":"2026-08-18 21:41:00","inspection_id":"88719117","dot_number":"2514675","report_state":"TX","report_number":"V262530676","insp_date":"2026-08-12 00:00:00","insp_start_time":"0910","insp_end_time":"0942","registration_date":null,"region":"CS","ci_status_code":"C","location":"F","location_desc":"TX","county_code_state":"TX","county_code":"047","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-08-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"4003543","transaction_code":"C","transaction_date":"2026-08-18 00:00:00","upload_date":"2026-08-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02514675","upload_search_indicator":null,"census_search_date":"2026-08-17 21:41:00","snet_input_date":"2026-08-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-08-17 21:41:00","insp_carrier_name":"EARTH AGGREGATES LLC","insp_carrier_street":"\\S1900 E 28TH ST STE \\S","insp_carrier_city":"WESLACO","insp_carrier_state":"TX","insp_carrier_zip_code":"78596","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-08-22T09:39:17.000000Z","updated_at":"2026-08-29T09:30:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":22128334,"change_date":"2026-08-18 21:41:00","inspection_id":"88719117","insp_unit_id":"215202308","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":null,"insp_unit_company":"114","insp_unit_license":"1M21438","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4V4WC9EH1LN252307","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-20T09:14:24.000000Z","updated_at":"2026-08-29T09:01:12.000000Z"}]},{"id":12708060,"change_date":"2026-08-12 21:43:00","inspection_id":"88682949","dot_number":"2514675","report_state":"TX","report_number":"V262516997","insp_date":"2026-08-11 00:00:00","insp_start_time":"1536","insp_end_time":"1606","registration_date":null,"region":"CT","ci_status_code":"C","location":"3C201","location_desc":"US77 RIVIERA SCALE","county_code_state":"TX","county_code":"273","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SELF","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-08-12 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"52350","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":"10068327","transaction_code":"A","transaction_date":"2026-08-12 00:00:00","upload_date":"2026-08-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02514675","upload_search_indicator":"M","census_search_date":"2026-08-12 21:43:00","snet_input_date":"2026-08-11 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-08-12 21:43:00","insp_carrier_name":"EARTH AGGREGATES LLC","insp_carrier_street":"1900 E 28TH ST STE Z","insp_carrier_city":"WESLACO","insp_carrier_state":"TX","insp_carrier_zip_code":"78596","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0876273","created_at":"2026-08-15T09:41:41.000000Z","updated_at":"2026-08-23T09:31:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":22054415,"change_date":"2026-08-12 21:43:00","inspection_id":"88682949","insp_unit_id":"215123473","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"115","insp_unit_license":"1M99034","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4V4WC9EH5PN625841","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-15T09:18:34.000000Z","updated_at":"2026-08-23T09:03:08.000000Z"}]},{"id":12831187,"change_date":"2026-08-26 21:56:00","inspection_id":"88807713","dot_number":"2514675","report_state":"TX","report_number":"V262516997","insp_date":"2026-08-11 00:00:00","insp_start_time":"1436","insp_end_time":"1506","registration_date":null,"region":"CS","ci_status_code":"C","location":"F","location_desc":"TX","county_code_state":"TX","county_code":"273","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SELF","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":"U","pen_cen_match":"I","final_status_date":"2026-08-26 21:56:00","post_acc_ind":"N","gross_comb_veh_wt":"52350","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":"4002479","transaction_code":"A","transaction_date":"2026-08-26 00:00:00","upload_date":"2026-08-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02514675","upload_search_indicator":null,"census_search_date":"2026-08-26 21:56:00","snet_input_date":"2026-08-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-08-26 21:56:00","insp_carrier_name":"EARTH AGGREGATES LLC","insp_carrier_street":"\\S1900 E 28TH ST STE \\S","insp_carrier_city":"WESLACO","insp_carrier_state":"TX","insp_carrier_zip_code":"78596","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-08-29T09:39:47.000000Z","updated_at":"2026-09-02T09:35:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":22267363,"change_date":"2026-08-26 21:56:00","inspection_id":"88807713","insp_unit_id":"215366976","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":null,"insp_unit_company":"115","insp_unit_license":"1M99034","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4V4WC9EH5PN625841","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-29T09:16:18.000000Z","updated_at":"2026-09-02T09:09:11.000000Z"}]},{"id":12707254,"change_date":"2026-08-12 21:43:00","inspection_id":"88682098","dot_number":"2514675","report_state":"TX","report_number":"V262524413","insp_date":"2026-08-10 00:00:00","insp_start_time":"1054","insp_end_time":"1122","registration_date":null,"region":"CT","ci_status_code":"C","location":"3C201","location_desc":"US77 RIVIERA SCALE","county_code_state":"TX","county_code":"273","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-08-12 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"127500","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":"10067049","transaction_code":"A","transaction_date":"2026-08-12 00:00:00","upload_date":"2026-08-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02514675","upload_search_indicator":"M","census_search_date":"2026-08-12 21:43:00","snet_input_date":"2026-08-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-08-12 21:43:00","insp_carrier_name":"EARTH AGGREGATES LLC","insp_carrier_street":"1900 E 28TH ST STE Z","insp_carrier_city":"WESLACO","insp_carrier_state":"TX","insp_carrier_zip_code":"78596","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0876273","created_at":"2026-08-15T09:41:39.000000Z","updated_at":"2026-08-23T09:31:25.000000Z","inspection_violations":[{"id":22121616,"change_date":"2026-08-12 21:43:00","inspection_id":"88682098","insp_violation_id":"276088495","seq_no":"2","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"215121756","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-15T10:02:31.000000Z","updated_at":"2026-08-23T09:41:44.000000Z","normalized_code":"3922RG"},{"id":22121615,"change_date":"2026-08-12 21:43:00","inspection_id":"88682098","insp_violation_id":"276088494","seq_no":"1","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"215121756","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-15T10:02:31.000000Z","updated_at":"2026-08-23T09:41:44.000000Z","normalized_code":"39360C"}],"inspection_per_units":[{"id":22052951,"change_date":"2026-08-12 21:43:00","inspection_id":"88682098","insp_unit_id":"215121757","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"SMIT","insp_unit_company":"ESD-1","insp_unit_license":"233C040","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1S9SS4025SL476121","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-15T09:18:30.000000Z","updated_at":"2026-08-23T09:03:02.000000Z"},{"id":22052950,"change_date":"2026-08-12 21:43:00","inspection_id":"88682098","insp_unit_id":"215121756","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"116","insp_unit_license":"1N46224","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4V4WC9EG4RN659523","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-15T09:18:30.000000Z","updated_at":"2026-08-23T09:03:02.000000Z"}]},{"id":12708602,"change_date":"2026-08-12 21:43:00","inspection_id":"88683506","dot_number":"2514675","report_state":"TX","report_number":"V262531975","insp_date":"2026-08-10 00:00:00","insp_start_time":"1030","insp_end_time":"1114","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"6301 US77","county_code_state":"TX","county_code":"273","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"REALITOS 2","shipping_paper_number":"2047125","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-08-12 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"10068147","transaction_code":"A","transaction_date":"2026-08-12 00:00:00","upload_date":"2026-08-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02514675","upload_search_indicator":"M","census_search_date":"2026-08-12 21:43:00","snet_input_date":"2026-08-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-08-12 21:43:00","insp_carrier_name":"EARTH AGGREGATES LLC","insp_carrier_street":"1900 E 28TH ST STE Z","insp_carrier_city":"WESLACO","insp_carrier_state":"TX","insp_carrier_zip_code":"78596","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0876273","created_at":"2026-08-15T09:41:42.000000Z","updated_at":"2026-08-23T09:31:33.000000Z","inspection_violations":[{"id":22125857,"change_date":"2026-08-12 21:43:00","inspection_id":"88683506","insp_violation_id":"276093677","seq_no":"2","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"1","insp_unit_id":"215124563","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-15T10:02:43.000000Z","updated_at":"2026-08-23T09:42:09.000000Z","normalized_code":"39345DB"},{"id":22125856,"change_date":"2026-08-12 21:43:00","inspection_id":"88683506","insp_violation_id":"276093676","seq_no":"1","part_no":"392","part_no_section":"9A-DFSL","insp_viol_unit":"2","insp_unit_id":"215124564","insp_violation_category_id":"55","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-08-15T10:02:43.000000Z","updated_at":"2026-08-23T09:42:09.000000Z","normalized_code":"3929ADFSL"}],"inspection_per_units":[{"id":22055394,"change_date":"2026-08-12 21:43:00","inspection_id":"88683506","insp_unit_id":"215124563","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"113","insp_unit_license":"1N66441","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4V4WC9EHXLN252306","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-15T09:18:36.000000Z","updated_at":"2026-08-23T09:03:24.000000Z"},{"id":22055395,"change_date":"2026-08-12 21:43:00","inspection_id":"88683506","insp_unit_id":"215124564","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CLEM","insp_unit_company":"350","insp_unit_license":"143C350","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5C2CD40B9FM008482","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-15T09:18:36.000000Z","updated_at":"2026-08-23T09:03:24.000000Z"}]},{"id":12625382,"change_date":"2026-08-03 21:40:00","inspection_id":"88596226","dot_number":"2514675","report_state":"TX","report_number":"V262498657","insp_date":"2026-07-31 00:00:00","insp_start_time":"0716","insp_end_time":"0747","registration_date":null,"region":"CT","ci_status_code":"C","location":"3C201","location_desc":"US77 RIVIERA SCALE","county_code_state":"TX","county_code":"273","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"J3 YARD","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-08-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","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":"10054480","transaction_code":"A","transaction_date":"2026-08-03 00:00:00","upload_date":"2026-08-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02514675","upload_search_indicator":"M","census_search_date":"2026-08-03 21:40:00","snet_input_date":"2026-07-31 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-08-03 21:40:00","insp_carrier_name":"EARTH AGGREGATES LLC","insp_carrier_street":"1900 E 28TH ST STE Z","insp_carrier_city":"WESLACO","insp_carrier_state":"TX","insp_carrier_zip_code":"78596","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0876273","created_at":"2026-08-06T09:41:22.000000Z","updated_at":"2026-08-14T09:31:24.000000Z","inspection_violations":[{"id":21980020,"change_date":"2026-08-03 21:40:00","inspection_id":"88596226","insp_violation_id":"275904134","seq_no":"5","part_no":"393","part_no_section":"45DLUV","insp_viol_unit":"2","insp_unit_id":"214964096","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-06T10:01:10.000000Z","updated_at":"2026-08-14T09:43:34.000000Z","normalized_code":"39345DLUV"},{"id":21980016,"change_date":"2026-08-03 21:40:00","inspection_id":"88596226","insp_violation_id":"275904130","seq_no":"1","part_no":"393","part_no_section":"11TU","insp_viol_unit":"1","insp_unit_id":"214964095","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-06T10:01:10.000000Z","updated_at":"2026-08-14T09:43:34.000000Z","normalized_code":"39311TU"},{"id":21980017,"change_date":"2026-08-03 21:40:00","inspection_id":"88596226","insp_violation_id":"275904131","seq_no":"2","part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"2","insp_unit_id":"214964096","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-06T10:01:10.000000Z","updated_at":"2026-08-14T09:43:34.000000Z","normalized_code":"39345B2UV"},{"id":21980018,"change_date":"2026-08-03 21:40:00","inspection_id":"88596226","insp_violation_id":"275904132","seq_no":"3","part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"2","insp_unit_id":"214964096","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-08-06T10:01:10.000000Z","updated_at":"2026-08-14T09:43:34.000000Z","normalized_code":"39345B2UV"},{"id":21980019,"change_date":"2026-08-03 21:40:00","inspection_id":"88596226","insp_violation_id":"275904133","seq_no":"4","part_no":"393","part_no_section":"45DLUV","insp_viol_unit":"2","insp_unit_id":"214964096","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-06T10:01:10.000000Z","updated_at":"2026-08-14T09:43:34.000000Z","normalized_code":"39345DLUV"},{"id":21980021,"change_date":"2026-08-03 21:40:00","inspection_id":"88596226","insp_violation_id":"275904135","seq_no":"6","part_no":"393","part_no_section":"55E","insp_viol_unit":"2","insp_unit_id":"214964096","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-06T10:01:10.000000Z","updated_at":"2026-08-14T09:43:34.000000Z","normalized_code":"39355E"},{"id":21980022,"change_date":"2026-08-03 21:40:00","inspection_id":"88596226","insp_violation_id":"275904136","seq_no":"7","part_no":"396","part_no_section":"3A1","insp_viol_unit":"1","insp_unit_id":"214964095","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-06T10:01:10.000000Z","updated_at":"2026-08-14T09:43:34.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":21917318,"change_date":"2026-08-03 21:40:00","inspection_id":"88596226","insp_unit_id":"214964095","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"113","insp_unit_license":"1N66441","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4V4WC9EHXLN252306","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-06T09:18:51.000000Z","updated_at":"2026-08-14T09:03:14.000000Z"},{"id":21917319,"change_date":"2026-08-03 21:40:00","inspection_id":"88596226","insp_unit_id":"214964096","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CLEM","insp_unit_company":null,"insp_unit_license":"143C350","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5C2CD40B9FM008482","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-06T09:18:51.000000Z","updated_at":"2026-08-14T09:03:14.000000Z"}]},{"id":12625474,"change_date":"2026-08-03 21:40:00","inspection_id":"88596321","dot_number":"2514675","report_state":"TX","report_number":"V262493052","insp_date":"2026-07-30 00:00:00","insp_start_time":"0724","insp_end_time":"0756","registration_date":null,"region":"CT","ci_status_code":"C","location":"3C201","location_desc":"US77 RIVIERA SCALE","county_code_state":"TX","county_code":"273","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"PORT","shipping_paper_number":"26191255","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-08-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"123200","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":"10053989","transaction_code":"A","transaction_date":"2026-08-03 00:00:00","upload_date":"2026-08-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02514675","upload_search_indicator":"M","census_search_date":"2026-08-03 21:40:00","snet_input_date":"2026-07-30 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-08-03 21:40:00","insp_carrier_name":"EARTH AGGREGATES LLC","insp_carrier_street":"1900 E 28TH ST STE Z","insp_carrier_city":"WESLACO","insp_carrier_state":"TX","insp_carrier_zip_code":"78596","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0876273","created_at":"2026-08-06T09:41:22.000000Z","updated_at":"2026-08-14T09:31:28.000000Z","inspection_violations":[{"id":21980300,"change_date":"2026-08-03 21:40:00","inspection_id":"88596321","insp_violation_id":"275904464","seq_no":"1","part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"2","insp_unit_id":"214964278","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-06T10:01:11.000000Z","updated_at":"2026-08-14T09:43:34.000000Z","normalized_code":"39345B2UV"},{"id":21980301,"change_date":"2026-08-03 21:40:00","inspection_id":"88596321","insp_violation_id":"275904465","seq_no":"2","part_no":"393","part_no_section":"55E","insp_viol_unit":"2","insp_unit_id":"214964278","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-06T10:01:11.000000Z","updated_at":"2026-08-14T09:43:34.000000Z","normalized_code":"39355E"}],"inspection_per_units":[{"id":21917487,"change_date":"2026-08-03 21:40:00","inspection_id":"88596321","insp_unit_id":"214964277","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"117","insp_unit_license":"1N99093","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4V4WC9EH7TN708181","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-06T09:18:51.000000Z","updated_at":"2026-08-14T09:03:14.000000Z"},{"id":21917488,"change_date":"2026-08-03 21:40:00","inspection_id":"88596321","insp_unit_id":"214964278","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"300","insp_unit_license":"128B200","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5HTSN422757T10138","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-06T09:18:51.000000Z","updated_at":"2026-08-14T09:03:14.000000Z"}]},{"id":12450118,"change_date":"2026-07-14 21:42:00","inspection_id":"88410140","dot_number":"2514675","report_state":"TX","report_number":"V262485389","insp_date":"2026-07-13 00:00:00","insp_start_time":"0737","insp_end_time":"0754","registration_date":null,"region":"CT","ci_status_code":"C","location":"3C201","location_desc":"US77 RIVIERA SCALE","county_code_state":"TX","county_code":"273","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"LOCATION","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-07-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"115350","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"10030255","transaction_code":"A","transaction_date":"2026-07-14 00:00:00","upload_date":"2026-07-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02514675","upload_search_indicator":"M","census_search_date":"2026-07-14 21:42:00","snet_input_date":"2026-07-13 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-07-14 21:42:00","insp_carrier_name":"EARTH AGGREGATES LLC","insp_carrier_street":"1900 E 28TH ST STE Z","insp_carrier_city":"WESLACO","insp_carrier_state":"TX","insp_carrier_zip_code":"78596","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0876273","created_at":"2026-07-17T09:41:24.000000Z","updated_at":"2026-07-25T09:31:43.000000Z","inspection_violations":[{"id":21676258,"change_date":"2026-07-14 21:42:00","inspection_id":"88410140","insp_violation_id":"275507882","seq_no":"1","part_no":"393","part_no_section":"11TL","insp_viol_unit":"1","insp_unit_id":"214616213","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-17T10:04:26.000000Z","updated_at":"2026-07-25T09:45:05.000000Z","normalized_code":"39311TL"},{"id":21676259,"change_date":"2026-07-14 21:42:00","inspection_id":"88410140","insp_violation_id":"275507883","seq_no":"2","part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"1","insp_unit_id":"214616213","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-07-17T10:04:26.000000Z","updated_at":"2026-07-25T09:45:05.000000Z","normalized_code":"39345B2UV"},{"id":21676260,"change_date":"2026-07-14 21:42:00","inspection_id":"88410140","insp_violation_id":"275507884","seq_no":"3","part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"1","insp_unit_id":"214616213","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-17T10:04:26.000000Z","updated_at":"2026-07-25T09:45:05.000000Z","normalized_code":"39345B2UV"}],"inspection_per_units":[{"id":21625945,"change_date":"2026-07-14 21:42:00","inspection_id":"88410140","insp_unit_id":"214616213","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"116","insp_unit_license":"1N46224","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4V4WC9EG4RN659523","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-17T09:19:32.000000Z","updated_at":"2026-07-25T09:03:54.000000Z"},{"id":21625946,"change_date":"2026-07-14 21:42:00","inspection_id":"88410140","insp_unit_id":"214616214","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"SMIT","insp_unit_company":"ESD1","insp_unit_license":"233C040","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1S9SS4025SL476121","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-17T09:19:32.000000Z","updated_at":"2026-07-25T09:03:54.000000Z"}]},{"id":12406442,"change_date":"2026-07-09 21:43:00","inspection_id":"88364288","dot_number":"2514675","report_state":"TX","report_number":"V262434189","insp_date":"2026-07-03 00:00:00","insp_start_time":"0952","insp_end_time":"1017","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"118 FM665 WB","county_code_state":"TX","county_code":"355","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"VOLVO","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-07-09 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"122350","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":"10022695","transaction_code":"A","transaction_date":"2026-07-09 00:00:00","upload_date":"2026-07-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02514675","upload_search_indicator":"M","census_search_date":"2026-07-09 21:43:00","snet_input_date":"2026-07-03 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-07-09 21:43:00","insp_carrier_name":"EARTH AGGREGATES LLC","insp_carrier_street":"1900 E 28TH ST STE Z","insp_carrier_city":"WESLACO","insp_carrier_state":"TX","insp_carrier_zip_code":"78596","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0876273","created_at":"2026-07-13T09:39:37.000000Z","updated_at":"2026-07-20T09:31:57.000000Z","inspection_violations":[{"id":21590711,"change_date":"2026-07-09 21:43:00","inspection_id":"88364288","insp_violation_id":"275397275","seq_no":"1","part_no":"393","part_no_section":"11TU","insp_viol_unit":"1","insp_unit_id":"214529172","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-13T09:56:44.000000Z","updated_at":"2026-07-20T09:47:10.000000Z","normalized_code":"39311TU"},{"id":21590712,"change_date":"2026-07-09 21:43:00","inspection_id":"88364288","insp_violation_id":"275397276","seq_no":"2","part_no":"393","part_no_section":"55D3","insp_viol_unit":"2","insp_unit_id":"214529173","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-13T09:56:44.000000Z","updated_at":"2026-07-20T09:47:10.000000Z","normalized_code":"39355D3"},{"id":21590713,"change_date":"2026-07-09 21:43:00","inspection_id":"88364288","insp_violation_id":"275397277","seq_no":"3","part_no":"393","part_no_section":"55E","insp_viol_unit":"2","insp_unit_id":"214529173","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-13T09:56:44.000000Z","updated_at":"2026-07-20T09:47:10.000000Z","normalized_code":"39355E"}],"inspection_per_units":[{"id":21552497,"change_date":"2026-07-09 21:43:00","inspection_id":"88364288","insp_unit_id":"214529172","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"114","insp_unit_license":"1M21438","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4V4WC9EH1LN252307","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-13T09:17:04.000000Z","updated_at":"2026-07-20T09:03:52.000000Z"},{"id":21552498,"change_date":"2026-07-09 21:43:00","inspection_id":"88364288","insp_unit_id":"214529173","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CLEM","insp_unit_company":"NA","insp_unit_license":"249B509","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5C2CB40B6EM008746","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-13T09:17:04.000000Z","updated_at":"2026-07-20T09:03:52.000000Z"}]},{"id":12409268,"change_date":"2026-07-09 21:43:00","inspection_id":"88367224","dot_number":"2514675","report_state":"TX","report_number":"V262453497","insp_date":"2026-07-01 00:00:00","insp_start_time":"0942","insp_end_time":"1013","registration_date":null,"region":"CT","ci_status_code":"C","location":"3C201","location_desc":"US77 RIVIERA SCALE","county_code_state":"TX","county_code":"273","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CEMENT PLANT","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-07-09 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"127350","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":"10017963","transaction_code":"A","transaction_date":"2026-07-09 00:00:00","upload_date":"2026-07-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02514675","upload_search_indicator":"M","census_search_date":"2026-07-09 21:43:00","snet_input_date":"2026-07-01 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-07-09 21:43:00","insp_carrier_name":"EARTH AGGREGATES LLC","insp_carrier_street":"1900 E 28TH ST STE Z","insp_carrier_city":"WESLACO","insp_carrier_state":"TX","insp_carrier_zip_code":"78596","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0876273","created_at":"2026-07-13T09:39:43.000000Z","updated_at":"2026-07-20T09:32:18.000000Z","inspection_violations":[{"id":21598317,"change_date":"2026-07-09 21:43:00","inspection_id":"88367224","insp_violation_id":"275405913","seq_no":"1","part_no":"393","part_no_section":"55E","insp_viol_unit":"2","insp_unit_id":"214534645","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-13T09:57:01.000000Z","updated_at":"2026-07-20T09:48:11.000000Z","normalized_code":"39355E"},{"id":21598318,"change_date":"2026-07-09 21:43:00","inspection_id":"88367224","insp_violation_id":"275405914","seq_no":"2","part_no":"393","part_no_section":"75C","insp_viol_unit":"1","insp_unit_id":"214534644","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-13T09:57:01.000000Z","updated_at":"2026-07-20T09:48:11.000000Z","normalized_code":"39375C"},{"id":21598319,"change_date":"2026-07-09 21:43:00","inspection_id":"88367224","insp_violation_id":"275405915","seq_no":"3","part_no":"393","part_no_section":"75C","insp_viol_unit":"2","insp_unit_id":"214534645","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-13T09:57:01.000000Z","updated_at":"2026-07-20T09:48:11.000000Z","normalized_code":"39375C"},{"id":21598320,"change_date":"2026-07-09 21:43:00","inspection_id":"88367224","insp_violation_id":"275405916","seq_no":"4","part_no":"393","part_no_section":"75C","insp_viol_unit":"2","insp_unit_id":"214534645","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-13T09:57:01.000000Z","updated_at":"2026-07-20T09:48:11.000000Z","normalized_code":"39375C"}],"inspection_per_units":[{"id":21557545,"change_date":"2026-07-09 21:43:00","inspection_id":"88367224","insp_unit_id":"214534644","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"113","insp_unit_license":"1N66441","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4V4WC9EHXLN252306","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-13T09:17:13.000000Z","updated_at":"2026-07-20T09:04:27.000000Z"},{"id":21557546,"change_date":"2026-07-09 21:43:00","inspection_id":"88367224","insp_unit_id":"214534645","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CLEM","insp_unit_company":"T-113","insp_unit_license":"143C350","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5C2CD40B9FM008482","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-13T09:17:13.000000Z","updated_at":"2026-07-20T09:04:27.000000Z"}]},{"id":12283643,"change_date":"2026-06-25 21:51:00","inspection_id":"88243525","dot_number":"2514675","report_state":"TX","report_number":"V262431235","insp_date":"2026-06-24 00:00:00","insp_start_time":"1007","insp_end_time":"1041","registration_date":null,"region":"CT","ci_status_code":"C","location":"3C201","location_desc":"US77 RIVIERA SCALE","county_code_state":"TX","county_code":"273","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-06-25 21:51:00","post_acc_ind":"N","gross_comb_veh_wt":"127670","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":"10007181","transaction_code":"A","transaction_date":"2026-06-25 00:00:00","upload_date":"2026-06-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02514675","upload_search_indicator":"M","census_search_date":"2026-06-25 21:51:00","snet_input_date":"2026-06-24 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-06-25 21:51:00","insp_carrier_name":"EARTH AGGREGATES LLC","insp_carrier_street":"1900 E 28TH ST STE Z","insp_carrier_city":"WESLACO","insp_carrier_state":"TX","insp_carrier_zip_code":"78596","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0876273","created_at":"2026-06-28T09:39:55.000000Z","updated_at":"2026-07-06T09:32:56.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21329291,"change_date":"2026-06-25 21:51:00","inspection_id":"88243525","insp_unit_id":"214291532","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"118","insp_unit_license":"1N99094","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4V4WC9EH7TN708178","insp_unit_decal":"Y","insp_unit_decal_number":"36267384","created_at":"2026-06-28T09:15:38.000000Z","updated_at":"2026-07-06T09:05:17.000000Z"},{"id":21329292,"change_date":"2026-06-25 21:51:00","inspection_id":"88243525","insp_unit_id":"214291533","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"SMIH","insp_unit_company":"ESD-2","insp_unit_license":"272B560","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1S9SS4026TL476050","insp_unit_decal":"Y","insp_unit_decal_number":"36267385","created_at":"2026-06-28T09:15:38.000000Z","updated_at":"2026-07-06T09:05:17.000000Z"}]},{"id":12177817,"change_date":"2026-06-16 21:40:00","inspection_id":"88132931","dot_number":"2514675","report_state":"TX","report_number":"V262399120","insp_date":"2026-06-10 00:00:00","insp_start_time":"0838","insp_end_time":"0912","registration_date":null,"region":"CT","ci_status_code":"C","location":"3C201","location_desc":"US77 RIVIERA SCALE","county_code_state":"TX","county_code":"273","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-06-12 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"118250","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":"9990856","transaction_code":"C","transaction_date":"2026-06-16 00:00:00","upload_date":"2026-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02514675","upload_search_indicator":"M","census_search_date":"2026-06-12 21:42:00","snet_input_date":"2026-06-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-06-12 21:42:00","insp_carrier_name":"EARTH AGGREGATES LLC","insp_carrier_street":"1900 E 28TH ST STE Z","insp_carrier_city":"WESLACO","insp_carrier_state":"TX","insp_carrier_zip_code":"78596","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0876273","created_at":"2026-06-16T09:43:44.000000Z","updated_at":"2026-06-27T09:30:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21152527,"change_date":"2026-06-16 21:40:00","inspection_id":"88132931","insp_unit_id":"214139925","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"115","insp_unit_license":"1M99034","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4V4WC9EH5PN625841","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-16T09:20:53.000000Z","updated_at":"2026-06-27T09:01:00.000000Z"},{"id":21152528,"change_date":"2026-06-16 21:40:00","inspection_id":"88132931","insp_unit_id":"214139926","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CLEM","insp_unit_company":"T115","insp_unit_license":"223C106","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5C2CD40B0FM008483","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-16T09:20:53.000000Z","updated_at":"2026-06-27T09:01:00.000000Z"}]},{"id":12154996,"change_date":"2026-06-10 21:45:00","inspection_id":"88104542","dot_number":"2514675","report_state":"TX","report_number":"V262368401","insp_date":"2026-06-05 00:00:00","insp_start_time":"0730","insp_end_time":"0742","registration_date":null,"region":"CT","ci_status_code":"C","location":"3C201","location_desc":"US77 RIVIERA SCALE","county_code_state":"TX","county_code":"273","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"YARD","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-06-10 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"128350","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":"9987812","transaction_code":"A","transaction_date":"2026-06-10 00:00:00","upload_date":"2026-06-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02514675","upload_search_indicator":"M","census_search_date":"2026-06-10 21:45:00","snet_input_date":"2026-06-05 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-06-10 21:45:00","insp_carrier_name":"EARTH AGGREGATES LLC","insp_carrier_street":"1900 E 28TH ST STE Z","insp_carrier_city":"WESLACO","insp_carrier_state":"TX","insp_carrier_zip_code":"78596","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0876273","created_at":"2026-06-13T09:41:37.000000Z","updated_at":"2026-06-21T09:32:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21114359,"change_date":"2026-06-10 21:45:00","inspection_id":"88104542","insp_unit_id":"214028888","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"119","insp_unit_license":"1N99097","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4V4WC9EH5TN708180","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-13T09:18:12.000000Z","updated_at":"2026-06-21T09:03:49.000000Z"},{"id":21114360,"change_date":"2026-06-10 21:45:00","inspection_id":"88104542","insp_unit_id":"214028889","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"SMIT","insp_unit_company":"ESD3","insp_unit_license":"276C962","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1S9SS4029SL476333","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-13T09:18:12.000000Z","updated_at":"2026-06-21T09:03:49.000000Z"}]},{"id":12420469,"change_date":"2026-07-10 21:42:00","inspection_id":"88379021","dot_number":"2514675","report_state":"TX","report_number":"V262398626","insp_date":"2026-06-02 00:00:00","insp_start_time":"0735","insp_end_time":"0905","registration_date":null,"region":"CT","ci_status_code":"C","location":"3C201","location_desc":"US77 RIVIERA SCALE","county_code_state":"TX","county_code":"273","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"J 3","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-07-10 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","viol_total":"6","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"10027017","transaction_code":"A","transaction_date":"2026-07-10 00:00:00","upload_date":"2026-07-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02514675","upload_search_indicator":"M","census_search_date":"2026-07-10 21:42:00","snet_input_date":"2026-06-02 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-07-10 21:42:00","insp_carrier_name":"EARTH AGGREGATES LLC","insp_carrier_street":"1900 E 28TH ST STE Z","insp_carrier_city":"WESLACO","insp_carrier_state":"TX","insp_carrier_zip_code":"78596","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0876273","created_at":"2026-07-14T09:40:51.000000Z","updated_at":"2026-07-21T09:31:48.000000Z","inspection_violations":[{"id":21620484,"change_date":"2026-07-10 21:42:00","inspection_id":"88379021","insp_violation_id":"275435910","seq_no":"1","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"214558524","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-14T10:00:57.000000Z","updated_at":"2026-07-21T09:46:22.000000Z","normalized_code":"39347E"},{"id":21620485,"change_date":"2026-07-10 21:42:00","inspection_id":"88379021","insp_violation_id":"275435911","seq_no":"2","part_no":"393","part_no_section":"50D","insp_viol_unit":"1","insp_unit_id":"214558523","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-14T10:00:57.000000Z","updated_at":"2026-07-21T09:46:22.000000Z","normalized_code":"39350D"},{"id":21620486,"change_date":"2026-07-10 21:42:00","inspection_id":"88379021","insp_violation_id":"275435912","seq_no":"3","part_no":"393","part_no_section":"53B","insp_viol_unit":"2","insp_unit_id":"214558524","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-14T10:00:57.000000Z","updated_at":"2026-07-21T09:46:22.000000Z","normalized_code":"39353B"},{"id":21620488,"change_date":"2026-07-10 21:42:00","inspection_id":"88379021","insp_violation_id":"275435914","seq_no":"5","part_no":"396","part_no_section":"3A1","insp_viol_unit":"2","insp_unit_id":"214558524","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-14T10:00:57.000000Z","updated_at":"2026-07-21T09:46:22.000000Z","normalized_code":"3963A1"},{"id":21620489,"change_date":"2026-07-10 21:42:00","inspection_id":"88379021","insp_violation_id":"275435915","seq_no":"6","part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"1","insp_unit_id":"214558523","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-07-14T10:00:57.000000Z","updated_at":"2026-07-21T09:46:22.000000Z","normalized_code":"3963A1BOS"},{"id":21620487,"change_date":"2026-07-10 21:42:00","inspection_id":"88379021","insp_violation_id":"275435913","seq_no":"4","part_no":"396","part_no_section":"3A1B","insp_viol_unit":"1","insp_unit_id":"214558523","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-14T10:00:57.000000Z","updated_at":"2026-07-21T09:46:22.000000Z","normalized_code":"3963A1B"}],"inspection_per_units":[{"id":21576269,"change_date":"2026-07-10 21:42:00","inspection_id":"88379021","insp_unit_id":"214558523","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"117","insp_unit_license":"1M21438","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4V4WC9EH1LN252307","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-14T09:17:42.000000Z","updated_at":"2026-07-21T09:04:51.000000Z"},{"id":21576270,"change_date":"2026-07-10 21:42:00","inspection_id":"88379021","insp_unit_id":"214558524","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CLEM","insp_unit_company":"T116","insp_unit_license":"249B509","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5C2CB40B6EM008746","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-14T09:17:42.000000Z","updated_at":"2026-07-21T09:04:51.000000Z"}]},{"id":12850506,"change_date":"2026-08-27 21:48:00","inspection_id":"88828245","dot_number":"2514675","report_state":"TX","report_number":"V262398626","insp_date":"2026-06-02 00:00:00","insp_start_time":"0635","insp_end_time":"0805","registration_date":null,"region":"CS","ci_status_code":"C","location":"F","location_desc":"TX","county_code_state":"TX","county_code":"273","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"J 3","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-08-27 21:48:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","viol_total":"6","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"4108249","transaction_code":"A","transaction_date":"2026-08-27 00:00:00","upload_date":"2026-08-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02514675","upload_search_indicator":null,"census_search_date":"2026-08-27 21:48:00","snet_input_date":"2026-07-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-08-27 21:48:00","insp_carrier_name":"EARTH AGGREGATES LLC","insp_carrier_street":"\\S1900 E 28TH ST STE \\S","insp_carrier_city":"WESLACO","insp_carrier_state":"TX","insp_carrier_zip_code":"78596","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-08-30T09:41:04.000000Z","updated_at":"2026-09-02T09:37:58.000000Z","inspection_violations":[{"id":22376946,"change_date":"2026-08-27 21:48:00","inspection_id":"88828245","insp_violation_id":"276427530","seq_no":"1","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"215406650","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-30T10:01:05.000000Z","updated_at":"2026-09-02T09:54:56.000000Z","normalized_code":"39347E"},{"id":22376947,"change_date":"2026-08-27 21:48:00","inspection_id":"88828245","insp_violation_id":"276427531","seq_no":"2","part_no":"393","part_no_section":"50D-B","insp_viol_unit":"1","insp_unit_id":"215406649","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-30T10:01:05.000000Z","updated_at":"2026-09-02T09:54:56.000000Z","normalized_code":"39350DB"},{"id":22376949,"change_date":"2026-08-27 21:48:00","inspection_id":"88828245","insp_violation_id":"276427533","seq_no":"4","part_no":"396","part_no_section":"3A1-BALAC","insp_viol_unit":"1","insp_unit_id":"215406649","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-30T10:01:05.000000Z","updated_at":"2026-09-02T09:54:56.000000Z","normalized_code":"3963A1BALAC"},{"id":22376950,"change_date":"2026-08-27 21:48:00","inspection_id":"88828245","insp_violation_id":"276427534","seq_no":"5","part_no":"396","part_no_section":"3A1-ALBV","insp_viol_unit":"2","insp_unit_id":"215406650","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-30T10:01:05.000000Z","updated_at":"2026-09-02T09:54:56.000000Z","normalized_code":"3963A1ALBV"},{"id":22376951,"change_date":"2026-08-27 21:48:00","inspection_id":"88828245","insp_violation_id":"276427535","seq_no":"6","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"1","insp_unit_id":"215406649","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-08-30T10:01:05.000000Z","updated_at":"2026-09-02T09:54:56.000000Z","normalized_code":"3963A1BOS"},{"id":22376948,"change_date":"2026-08-27 21:48:00","inspection_id":"88828245","insp_violation_id":"276427532","seq_no":"3","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"2","insp_unit_id":"215406650","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-30T10:01:05.000000Z","updated_at":"2026-09-02T09:54:56.000000Z","normalized_code":"39353BB"}],"inspection_per_units":[{"id":22300033,"change_date":"2026-08-27 21:48:00","inspection_id":"88828245","insp_unit_id":"215406650","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":null,"insp_unit_company":"T116","insp_unit_license":"249B509","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5C2CB40B6EM008746","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-30T09:18:00.000000Z","updated_at":"2026-09-02T09:12:35.000000Z"},{"id":22300032,"change_date":"2026-08-27 21:48:00","inspection_id":"88828245","insp_unit_id":"215406649","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":null,"insp_unit_company":"117","insp_unit_license":"1M21438","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4V4WC9EH1LN252307","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-30T09:18:00.000000Z","updated_at":"2026-09-02T09:12:35.000000Z"}]},{"id":11697822,"change_date":"2026-04-20 21:38:00","inspection_id":"87624226","dot_number":"2514675","report_state":"TX","report_number":"V262270373","insp_date":"2026-04-10 00:00:00","insp_start_time":"0810","insp_end_time":"0833","registration_date":null,"region":"CT","ci_status_code":"C","location":"3C201","location_desc":"US77 RIVIERA SCALE","county_code_state":"TX","county_code":"273","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"NONE","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-04-20 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"9924643","transaction_code":"A","transaction_date":"2026-04-20 00:00:00","upload_date":"2026-04-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02514675","upload_search_indicator":"M","census_search_date":"2026-04-20 21:38:00","snet_input_date":"2026-04-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-04-20 21:38:00","insp_carrier_name":"EARTH AGGREGATES LLC","insp_carrier_street":"1900 E 28TH ST STE Z","insp_carrier_city":"WESLACO","insp_carrier_state":"TX","insp_carrier_zip_code":"78596","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0876273","created_at":"2026-04-27T09:36:06.000000Z","updated_at":"2026-05-01T09:31:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20357884,"change_date":"2026-04-20 21:38:00","inspection_id":"87624226","insp_unit_id":"213116413","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"115","insp_unit_license":"1M99034","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4V4WC9EH5PN625841","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:11:32.000000Z","updated_at":"2026-05-01T09:04:05.000000Z"},{"id":20357885,"change_date":"2026-04-20 21:38:00","inspection_id":"87624226","insp_unit_id":"213116414","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CLEM","insp_unit_company":"T115","insp_unit_license":"223C106","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5C2CD40B0FM008483","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:11:32.000000Z","updated_at":"2026-05-01T09:04:05.000000Z"}]},{"id":11633963,"change_date":"2026-04-13 21:38:00","inspection_id":"87562746","dot_number":"2514675","report_state":"TX","report_number":"V262292435","insp_date":"2026-04-09 00:00:00","insp_start_time":"0825","insp_end_time":"0841","registration_date":null,"region":"CT","ci_status_code":"C","location":"3C201","location_desc":"US77 RIVIERA SCALE","county_code_state":"TX","county_code":"273","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"PLANT","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-04-13 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","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":"9915512","transaction_code":"A","transaction_date":"2026-04-13 00:00:00","upload_date":"2026-04-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02514675","upload_search_indicator":"M","census_search_date":"2026-04-13 21:38:00","snet_input_date":"2026-04-09 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-04-13 21:38:00","insp_carrier_name":"EARTH AGGREGATES LLC","insp_carrier_street":"1900 E 28TH ST STE Z","insp_carrier_city":"WESLACO","insp_carrier_state":"TX","insp_carrier_zip_code":"78596","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0876273","created_at":"2026-04-24T09:31:16.000000Z","updated_at":"2026-04-24T09:31:16.000000Z","inspection_violations":[{"id":20194827,"change_date":"2026-04-13 21:38:00","inspection_id":"87562746","insp_violation_id":"273570925","seq_no":"1","part_no":"393","part_no_section":"45DLUV","insp_viol_unit":"2","insp_unit_id":"212990689","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-24T09:43:49.000000Z","updated_at":"2026-04-24T09:43:49.000000Z","normalized_code":"39345DLUV"}],"inspection_per_units":[{"id":20235650,"change_date":"2026-04-13 21:38:00","inspection_id":"87562746","insp_unit_id":"212990688","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"114","insp_unit_license":"1M21438","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4V4WC9EH1LN252307","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-24T09:04:02.000000Z","updated_at":"2026-04-24T09:04:02.000000Z"},{"id":20235651,"change_date":"2026-04-13 21:38:00","inspection_id":"87562746","insp_unit_id":"212990689","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CLEM","insp_unit_company":"116","insp_unit_license":"249B509","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5C2CB40B6EM008746","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-24T09:04:02.000000Z","updated_at":"2026-04-24T09:04:02.000000Z"}]},{"id":11556356,"change_date":"2026-04-07 21:39:00","inspection_id":"87479510","dot_number":"2514675","report_state":"TX","report_number":"V262296835","insp_date":"2026-04-01 00:00:00","insp_start_time":"1105","insp_end_time":"1150","registration_date":null,"region":"CT","ci_status_code":"C","location":"3C201","location_desc":"US77 RIVIERA SCALE","county_code_state":"TX","county_code":"273","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-04-02 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"5","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9906257","transaction_code":"C","transaction_date":"2026-04-07 00:00:00","upload_date":"2026-04-07 00:00:00","upload_first_byte":"0","upload_dot_number":"02514675","upload_search_indicator":"M","census_search_date":"2026-04-02 21:39:00","snet_input_date":"2026-04-01 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-04-02 21:39:00","insp_carrier_name":"EARTH AGGREGATES LLC","insp_carrier_street":"1900 E 28TH ST STE Z","insp_carrier_city":"WESLACO","insp_carrier_state":"TX","insp_carrier_zip_code":"78596","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0876273","created_at":"2026-04-05T09:57:02.000000Z","updated_at":"2026-04-17T09:55:08.000000Z","inspection_violations":[{"id":19592214,"change_date":"2026-04-07 21:39:00","inspection_id":"87479510","insp_violation_id":"272924127","seq_no":"1","part_no":"393","part_no_section":"45PC","insp_viol_unit":"1","insp_unit_id":"212590878","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-04-09T10:16:49.000000Z","updated_at":"2026-04-18T10:44:01.000000Z","normalized_code":"39345PC"},{"id":19592215,"change_date":"2026-04-07 21:39:00","inspection_id":"87479510","insp_violation_id":"272924128","seq_no":"2","part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"1","insp_unit_id":"212590878","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-09T10:16:49.000000Z","updated_at":"2026-04-18T10:44:01.000000Z","normalized_code":"39345B2UV"},{"id":19592216,"change_date":"2026-04-07 21:39:00","inspection_id":"87479510","insp_violation_id":"272924129","seq_no":"3","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"212590879","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-09T10:16:49.000000Z","updated_at":"2026-04-18T10:44:01.000000Z","normalized_code":"39347E"},{"id":19592217,"change_date":"2026-04-07 21:39:00","inspection_id":"87479510","insp_violation_id":"272924130","seq_no":"4","part_no":"393","part_no_section":"48A","insp_viol_unit":"2","insp_unit_id":"212590879","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-09T10:16:49.000000Z","updated_at":"2026-04-18T10:44:01.000000Z","normalized_code":"39348A"},{"id":19592218,"change_date":"2026-04-07 21:39:00","inspection_id":"87479510","insp_violation_id":"272924131","seq_no":"5","part_no":"393","part_no_section":"53B","insp_viol_unit":"2","insp_unit_id":"212590879","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-09T10:16:49.000000Z","updated_at":"2026-04-18T10:44:01.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":19859333,"change_date":"2026-04-07 21:39:00","inspection_id":"87479510","insp_unit_id":"212590879","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CLEM","insp_unit_company":"T113","insp_unit_license":"143C350","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5C2CD40B9FM008482","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-10T09:22:28.000000Z","updated_at":"2026-04-18T09:30:27.000000Z"},{"id":19859332,"change_date":"2026-04-07 21:39:00","inspection_id":"87479510","insp_unit_id":"212590878","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"113","insp_unit_license":"1N66441","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4V4WC9EHXLN252306","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-10T09:22:28.000000Z","updated_at":"2026-04-18T09:30:27.000000Z"}]},{"id":11310947,"change_date":"2026-03-12 21:40:00","inspection_id":"87227127","dot_number":"2514675","report_state":"TX","report_number":"V262241401","insp_date":"2026-03-05 00:00:00","insp_start_time":"0838","insp_end_time":"0903","registration_date":null,"region":"CT","ci_status_code":"C","location":"3C201","location_desc":"US77 RIVIERA SCALE","county_code_state":"TX","county_code":"273","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"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":"Y","pen_cen_match":null,"final_status_date":"2026-03-06 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"127500","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9876173","transaction_code":"C","transaction_date":"2026-03-12 00:00:00","upload_date":"2026-03-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02514675","upload_search_indicator":"M","census_search_date":"2026-03-06 21:42:00","snet_input_date":"2026-03-05 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-03-06 21:42:00","insp_carrier_name":"EARTH AGGREGATES LLC","insp_carrier_street":"1900 E 28TH ST STE Z","insp_carrier_city":"WESLACO","insp_carrier_state":"TX","insp_carrier_zip_code":"78596","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0876273","created_at":"2026-03-09T09:42:40.000000Z","updated_at":"2026-03-23T09:32:24.000000Z","inspection_violations":[{"id":19133540,"change_date":"2026-03-12 21:40:00","inspection_id":"87227127","insp_violation_id":"272372615","seq_no":"1","part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"1","insp_unit_id":"212109818","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-03-15T10:03:37.000000Z","updated_at":"2026-03-23T09:51:16.000000Z","normalized_code":"39345B2UV"}],"inspection_per_units":[{"id":19436128,"change_date":"2026-03-12 21:40:00","inspection_id":"87227127","insp_unit_id":"212109818","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"116","insp_unit_license":"1N46224","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4V4WC9EG4RN659523","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-15T09:19:42.000000Z","updated_at":"2026-03-23T09:10:43.000000Z"},{"id":19436129,"change_date":"2026-03-12 21:40:00","inspection_id":"87227127","insp_unit_id":"212109819","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"SMIT","insp_unit_company":"ESD-1","insp_unit_license":"233C040","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1S9SS4025SL476121","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-15T09:19:42.000000Z","updated_at":"2026-03-23T09:10:43.000000Z"}]},{"id":11268954,"change_date":"2026-03-04 21:41:00","inspection_id":"87183154","dot_number":"2514675","report_state":"TX","report_number":"V262241382","insp_date":"2026-02-27 00:00:00","insp_start_time":"0816","insp_end_time":"0835","registration_date":null,"region":"CT","ci_status_code":"C","location":"3C201","location_desc":"US77 RIVIERA SCALE","county_code_state":"TX","county_code":"273","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"YARD","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-03-02 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","viol_total":"3","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9868678","transaction_code":"C","transaction_date":"2026-03-04 00:00:00","upload_date":"2026-03-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02514675","upload_search_indicator":"M","census_search_date":"2026-03-02 21:38:00","snet_input_date":"2026-02-27 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-03-02 21:38:00","insp_carrier_name":"EARTH AGGREGATES LLC","insp_carrier_street":"1900 E 28TH ST STE Z","insp_carrier_city":"WESLACO","insp_carrier_state":"TX","insp_carrier_zip_code":"78596","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0876273","created_at":"2026-03-05T10:39:05.000000Z","updated_at":"2026-03-15T09:30:52.000000Z","inspection_violations":[{"id":18979423,"change_date":"2026-03-04 21:41:00","inspection_id":"87183154","insp_violation_id":"272201493","seq_no":"1","part_no":"393","part_no_section":"45","insp_viol_unit":"2","insp_unit_id":"211971369","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-03-07T10:57:43.000000Z","updated_at":"2026-03-15T09:41:57.000000Z","normalized_code":"39345"},{"id":18979424,"change_date":"2026-03-04 21:41:00","inspection_id":"87183154","insp_violation_id":"272201494","seq_no":"2","part_no":"393","part_no_section":"45B2PC","insp_viol_unit":"1","insp_unit_id":"211971368","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-03-07T10:57:43.000000Z","updated_at":"2026-03-15T09:41:57.000000Z","normalized_code":"39345B2PC"},{"id":18979425,"change_date":"2026-03-04 21:41:00","inspection_id":"87183154","insp_violation_id":"272201495","seq_no":"3","part_no":"396","part_no_section":"3A1","insp_viol_unit":"1","insp_unit_id":"211971368","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-07T10:57:43.000000Z","updated_at":"2026-03-15T09:41:57.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":19303934,"change_date":"2026-03-04 21:41:00","inspection_id":"87183154","insp_unit_id":"211971369","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CLEM","insp_unit_company":"223C106","insp_unit_license":"223C106","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5C2CD40B0FM008483","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-07T10:15:44.000000Z","updated_at":"2026-03-15T09:04:30.000000Z"},{"id":19303933,"change_date":"2026-03-04 21:41:00","inspection_id":"87183154","insp_unit_id":"211971368","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"115","insp_unit_license":"1M99034","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4V4WC9EH5PN625841","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-07T10:15:44.000000Z","updated_at":"2026-03-15T09:04:30.000000Z"}]},{"id":11277757,"change_date":"2026-03-03 21:36:00","inspection_id":"87192320","dot_number":"2514675","report_state":"TX","report_number":"V262222591","insp_date":"2026-02-20 00:00:00","insp_start_time":"1120","insp_end_time":"1142","registration_date":null,"region":"CT","ci_status_code":"C","location":"3C201","location_desc":"US77 RIVIERA SCALE","county_code_state":"TX","county_code":"273","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"YARD RIVERA","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-03-03 21:36:00","post_acc_ind":"N","gross_comb_veh_wt":"102350","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":"9871285","transaction_code":"A","transaction_date":"2026-03-03 00:00:00","upload_date":"2026-03-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02514675","upload_search_indicator":"M","census_search_date":"2026-03-03 21:36:00","snet_input_date":"2026-02-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-03-03 21:36:00","insp_carrier_name":"EARTH AGGREGATES LLC","insp_carrier_street":"1900 E 28TH ST STE Z","insp_carrier_city":"WESLACO","insp_carrier_state":"TX","insp_carrier_zip_code":"78596","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0876273","created_at":"2026-03-06T10:39:44.000000Z","updated_at":"2026-03-14T09:30:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19287473,"change_date":"2026-03-03 21:36:00","inspection_id":"87192320","insp_unit_id":"211945258","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"114","insp_unit_license":"1M21438","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4V4WC9EH1LN252307","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-06T10:17:08.000000Z","updated_at":"2026-03-14T09:03:31.000000Z"},{"id":19287474,"change_date":"2026-03-03 21:36:00","inspection_id":"87192320","insp_unit_id":"211945259","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CLEM","insp_unit_company":"116","insp_unit_license":"249B509","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5C2CB40B6EM008746","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-06T10:17:08.000000Z","updated_at":"2026-03-14T09:03:31.000000Z"}]},{"id":10508815,"change_date":"2025-12-23 21:39:00","inspection_id":"86643944","dot_number":"2514675","report_state":"TX","report_number":"V252117573","insp_date":"2025-12-19 00:00:00","insp_start_time":"0903","insp_end_time":"0939","registration_date":null,"region":"CT","ci_status_code":"C","location":"3C201","location_desc":"US77 RIVIERA SCALE","county_code_state":"TX","county_code":"273","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"NONE","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-12-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"9795659","transaction_code":"A","transaction_date":"2025-12-23 00:00:00","upload_date":"2025-12-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02514675","upload_search_indicator":"M","census_search_date":"2025-12-23 21:39:00","snet_input_date":"2025-12-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-12-23 21:39:00","insp_carrier_name":"EARTH AGGREGATES LLC","insp_carrier_street":"1900 E 28TH ST STE Z","insp_carrier_city":"WESLACO","insp_carrier_state":"TX","insp_carrier_zip_code":"78596","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0876273","created_at":"2025-12-26T10:38:39.000000Z","updated_at":"2026-01-03T10:30:52.000000Z","inspection_violations":[{"id":17642320,"change_date":"2025-12-23 21:39:00","inspection_id":"86643944","insp_violation_id":"270877857","seq_no":"1","part_no":"393","part_no_section":"13C1","insp_viol_unit":"1","insp_unit_id":"210784903","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-26T10:44:36.000000Z","updated_at":"2026-01-03T10:31:38.000000Z","normalized_code":"39313C1"},{"id":17642321,"change_date":"2025-12-23 21:39:00","inspection_id":"86643944","insp_violation_id":"270877858","seq_no":"2","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"210784903","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-26T10:44:36.000000Z","updated_at":"2026-01-03T10:31:38.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":17598721,"change_date":"2025-12-23 21:39:00","inspection_id":"86643944","insp_unit_id":"210784903","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"113","insp_unit_license":"1N66441","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4V4WC9EHXLN252306","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-26T10:09:33.000000Z","updated_at":"2026-01-03T10:01:01.000000Z"},{"id":17598722,"change_date":"2025-12-23 21:39:00","inspection_id":"86643944","insp_unit_id":"210784904","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CLEM","insp_unit_company":"T-113","insp_unit_license":"143C350","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5C2CD40B9FM008482","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-26T10:09:33.000000Z","updated_at":"2026-01-03T10:01:01.000000Z"}]},{"id":10380522,"change_date":"2025-12-10 21:38:00","inspection_id":"86509856","dot_number":"2514675","report_state":"TX","report_number":"V252139838","insp_date":"2025-12-05 00:00:00","insp_start_time":"1055","insp_end_time":"1130","registration_date":null,"region":"CT","ci_status_code":"C","location":"3C201","location_desc":"US77 RIVIERA SCALE","county_code_state":"TX","county_code":"273","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"RIVIERA JOB SITE UNLOADING","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-12-08 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","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":"9779032","transaction_code":"C","transaction_date":"2025-12-10 00:00:00","upload_date":"2025-12-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02514675","upload_search_indicator":"M","census_search_date":"2025-12-08 21:39:00","snet_input_date":"2025-12-05 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-12-08 21:39:00","insp_carrier_name":"EARTH AGGREGATES LLC","insp_carrier_street":"1900 E 28TH ST STE Z","insp_carrier_city":"WESLACO","insp_carrier_state":"TX","insp_carrier_zip_code":"78596","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0876273","created_at":"2025-12-11T10:30:37.000000Z","updated_at":"2025-12-14T10:30:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17379996,"change_date":"2025-12-10 21:38:00","inspection_id":"86509856","insp_unit_id":"210530538","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"113","insp_unit_license":"1N66441","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4V4WC9EHXLN252306","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-13T10:01:45.000000Z","updated_at":"2025-12-14T10:00:30.000000Z"},{"id":17379997,"change_date":"2025-12-10 21:38:00","inspection_id":"86509856","insp_unit_id":"210530539","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CLEM","insp_unit_company":"T113","insp_unit_license":"143C350","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5C2CD40B9FM008482","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-13T10:01:45.000000Z","updated_at":"2025-12-14T10:00:30.000000Z"}]},{"id":10166457,"change_date":"2025-11-12 21:41:00","inspection_id":"86285511","dot_number":"2514675","report_state":"TX","report_number":"V252104914","insp_date":"2025-11-06 00:00:00","insp_start_time":"0834","insp_end_time":"0856","registration_date":null,"region":"CT","ci_status_code":"C","location":"3C201","location_desc":"US77 RIVIERA SCALE","county_code_state":"TX","county_code":"273","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","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-11-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"125500","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":"9752396","transaction_code":"C","transaction_date":"2025-11-12 00:00:00","upload_date":"2025-11-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02514675","upload_search_indicator":"M","census_search_date":"2025-11-10 21:40:00","snet_input_date":"2025-11-06 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-11-10 21:40:00","insp_carrier_name":"EARTH AGGREGATES LLC","insp_carrier_street":"1900 E 28TH ST STE Z","insp_carrier_city":"WESLACO","insp_carrier_state":"TX","insp_carrier_zip_code":"78596","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0876273","created_at":"2025-11-13T10:30:46.000000Z","updated_at":"2025-11-16T10:30:52.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16950210,"change_date":"2025-11-12 21:41:00","inspection_id":"86285511","insp_unit_id":"209987407","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"116","insp_unit_license":"1N46224","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4V4WC9EG4RN659523","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-15T10:00:38.000000Z","updated_at":"2025-11-16T10:01:06.000000Z"},{"id":16950211,"change_date":"2025-11-12 21:41:00","inspection_id":"86285511","insp_unit_id":"209987408","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"SMIT","insp_unit_company":"ESD1","insp_unit_license":"233C040","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1S9SS4025SL476121","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-15T10:00:38.000000Z","updated_at":"2025-11-16T10:01:06.000000Z"}]},{"id":9839420,"change_date":"2025-10-02 21:42:00","inspection_id":"85940840","dot_number":"2514675","report_state":"TX","report_number":"V252002069","insp_date":"2025-09-30 00:00:00","insp_start_time":"1248","insp_end_time":"1308","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"S US281","county_code_state":"TX","county_code":"249","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"EARTH AGGREGATES LLC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-10-02 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","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":"9713197","transaction_code":"A","transaction_date":"2025-10-02 00:00:00","upload_date":"2025-10-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02514675","upload_search_indicator":"M","census_search_date":"2025-10-02 21:42:00","snet_input_date":"2025-09-30 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-10-02 21:42:00","insp_carrier_name":"EARTH AGGREGATES LLC","insp_carrier_street":"1900 E 28TH ST STE Z","insp_carrier_city":"WESLACO","insp_carrier_state":"TX","insp_carrier_zip_code":"78596","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0876273","created_at":"2025-10-05T10:01:57.000000Z","updated_at":"2025-10-05T10:01:57.000000Z","inspection_violations":[{"id":16202977,"change_date":"2025-10-02 21:42:00","inspection_id":"85940840","insp_violation_id":"269063434","seq_no":"1","part_no":"393","part_no_section":"11S","insp_viol_unit":"2","insp_unit_id":"209267827","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-05T10:17:44.000000Z","updated_at":"2025-10-05T10:17:44.000000Z","normalized_code":"39311S"},{"id":16202978,"change_date":"2025-10-02 21:42:00","inspection_id":"85940840","insp_violation_id":"269063435","seq_no":"2","part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"2","insp_unit_id":"209267827","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-05T10:17:44.000000Z","updated_at":"2025-10-05T10:17:44.000000Z","normalized_code":"39345B2UV"},{"id":16202979,"change_date":"2025-10-02 21:42:00","inspection_id":"85940840","insp_violation_id":"269063436","seq_no":"3","part_no":"393","part_no_section":"53B","insp_viol_unit":"2","insp_unit_id":"209267827","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-05T10:17:44.000000Z","updated_at":"2025-10-05T10:17:44.000000Z","normalized_code":"39353B"},{"id":16202980,"change_date":"2025-10-02 21:42:00","inspection_id":"85940840","insp_violation_id":"269063437","seq_no":"4","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"209267827","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-05T10:17:44.000000Z","updated_at":"2025-10-05T10:17:44.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":16316449,"change_date":"2025-10-02 21:42:00","inspection_id":"85940840","insp_unit_id":"209267826","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"115","insp_unit_license":"1M99034","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4V4WC9EH5PN625841","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-05T09:47:00.000000Z","updated_at":"2025-10-05T09:47:00.000000Z"},{"id":16316450,"change_date":"2025-10-02 21:42:00","inspection_id":"85940840","insp_unit_id":"209267827","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CLEM","insp_unit_company":"T115","insp_unit_license":"223C106","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5C2CD40B0FM008483","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-05T09:47:00.000000Z","updated_at":"2025-10-05T09:47:00.000000Z"}]},{"id":9745894,"change_date":"2025-09-22 21:39:00","inspection_id":"85842920","dot_number":"2514675","report_state":"TX","report_number":"V252024942","insp_date":"2025-09-16 00:00:00","insp_start_time":"1030","insp_end_time":"1110","registration_date":null,"region":"CT","ci_status_code":"C","location":"3C201","location_desc":"US77 RIVIERA SCALE","county_code_state":"TX","county_code":"273","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"J-III CONCRETE","shipping_paper_number":"32300","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":"120350","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":"9703218","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":"02514675","upload_search_indicator":"M","census_search_date":"2025-09-22 21:39:00","snet_input_date":"2025-09-16 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-09-22 21:39:00","insp_carrier_name":"EARTH AGGREGATES LLC","insp_carrier_street":"1900 E 28TH ST STE Z","insp_carrier_city":"WESLACO","insp_carrier_state":"TX","insp_carrier_zip_code":"78596","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0876273","created_at":"2025-09-25T10:00:28.000000Z","updated_at":"2025-09-25T10:00:28.000000Z","inspection_violations":[{"id":16011255,"change_date":"2025-09-22 21:39:00","inspection_id":"85842920","insp_violation_id":"268848561","seq_no":"1","part_no":"393","part_no_section":"83G","insp_viol_unit":"1","insp_unit_id":"209079842","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-25T10:15:44.000000Z","updated_at":"2025-09-26T10:16:16.000000Z","normalized_code":"39383G"},{"id":16011256,"change_date":"2025-09-22 21:39:00","inspection_id":"85842920","insp_violation_id":"268848562","seq_no":"2","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"209079842","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-25T10:15:44.000000Z","updated_at":"2025-09-26T10:16:16.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":16141697,"change_date":"2025-09-22 21:39:00","inspection_id":"85842920","insp_unit_id":"209079842","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"113","insp_unit_license":"1N66441","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4V4WC9EHXLN252306","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-25T09:45:28.000000Z","updated_at":"2025-09-26T09:45:48.000000Z"},{"id":16141698,"change_date":"2025-09-22 21:39:00","inspection_id":"85842920","insp_unit_id":"209079843","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CLEM","insp_unit_company":"T113","insp_unit_license":"143C350","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5C2CD40B9FM008482","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-25T09:45:28.000000Z","updated_at":"2025-09-26T09:45:48.000000Z"}]},{"id":9380854,"change_date":"2025-08-14 21:40:00","inspection_id":"85459332","dot_number":"2514675","report_state":"TX","report_number":"V251953126","insp_date":"2025-08-07 00:00:00","insp_start_time":"1040","insp_end_time":"1100","registration_date":null,"region":"CT","ci_status_code":"C","location":"3C201","location_desc":"US77 RIVIERA SCALE","county_code_state":"TX","county_code":"273","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"J I EARTH AGGREGATES LLC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-08-11 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"125500","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":"9661079","transaction_code":"C","transaction_date":"2025-08-14 00:00:00","upload_date":"2025-08-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02514675","upload_search_indicator":"M","census_search_date":"2025-08-11 21:38:00","snet_input_date":"2025-08-07 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-08-11 21:38:00","insp_carrier_name":"EARTH AGGREGATES LLC","insp_carrier_street":"1900 E 28TH ST STE Z","insp_carrier_city":"WESLACO","insp_carrier_state":"TX","insp_carrier_zip_code":"78596","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0876273","created_at":"2025-08-14T10:42:29.000000Z","updated_at":"2025-08-20T10:43:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15510519,"change_date":"2025-08-14 21:40:00","inspection_id":"85459332","insp_unit_id":"208404783","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"116","insp_unit_license":"1N46224","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4V4WC9EG4RN659523","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-17T09:46:23.000000Z","updated_at":"2025-08-18T09:45:33.000000Z"},{"id":15510520,"change_date":"2025-08-14 21:40:00","inspection_id":"85459332","insp_unit_id":"208404784","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"SMIT","insp_unit_company":"ESD-1","insp_unit_license":"233C040","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1S9SS4025SL476121","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-17T09:46:23.000000Z","updated_at":"2025-08-18T09:45:33.000000Z"}]},{"id":8559728,"change_date":"2025-05-06 21:40:00","inspection_id":"84593225","dot_number":"2514675","report_state":"TX","report_number":"V251841221","insp_date":"2025-04-30 00:00:00","insp_start_time":"0812","insp_end_time":"0848","registration_date":null,"region":"CT","ci_status_code":"C","location":"3C201","location_desc":"US77 RIVIERA SCALE","county_code_state":"TX","county_code":"273","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","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-05-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9570654","transaction_code":"A","transaction_date":"2025-05-06 00:00:00","upload_date":"2025-05-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02514675","upload_search_indicator":"M","census_search_date":"2025-05-06 21:40:00","snet_input_date":"2025-04-30 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-05-06 21:40:00","insp_carrier_name":"EARTH AGGREGATES LLC","insp_carrier_street":"1900 E 28TH ST STE Z","insp_carrier_city":"WESLACO","insp_carrier_state":"TX","insp_carrier_zip_code":"78596","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0876273","created_at":"2025-05-09T10:26:08.000000Z","updated_at":"2025-05-10T10:52:10.000000Z","inspection_violations":[{"id":13568414,"change_date":"2025-05-06 21:40:00","inspection_id":"84593225","insp_violation_id":"266036742","seq_no":"1","part_no":"393","part_no_section":"45B2PC","insp_viol_unit":"1","insp_unit_id":"206667305","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-09T10:58:35.000000Z","updated_at":"2025-05-09T11:07:20.000000Z","normalized_code":"39345B2PC"},{"id":13568415,"change_date":"2025-05-06 21:40:00","inspection_id":"84593225","insp_violation_id":"266036743","seq_no":"2","part_no":"393","part_no_section":"55E","insp_viol_unit":"2","insp_unit_id":"206667306","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-09T10:58:35.000000Z","updated_at":"2025-05-09T11:07:20.000000Z","normalized_code":"39355E"}],"inspection_per_units":[{"id":13922683,"change_date":"2025-05-06 21:40:00","inspection_id":"84593225","insp_unit_id":"206667305","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"115","insp_unit_license":"1M99034","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4V4WC9EH5PN625841","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-09T10:15:14.000000Z","updated_at":"2025-05-10T10:03:34.000000Z"},{"id":13922684,"change_date":"2025-05-06 21:40:00","inspection_id":"84593225","insp_unit_id":"206667306","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CLEM","insp_unit_company":"T115","insp_unit_license":"223C106","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5C2CD40B0FM008483","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-09T10:15:14.000000Z","updated_at":"2025-05-10T10:03:34.000000Z"}]},{"id":8356396,"change_date":"2025-04-11 21:41:00","inspection_id":"84378868","dot_number":"2514675","report_state":"TX","report_number":"V251841231","insp_date":"2025-04-09 00:00:00","insp_start_time":"0715","insp_end_time":"0750","registration_date":null,"region":"CT","ci_status_code":"C","location":"3C201","location_desc":"US77 RIVIERA SCALE","county_code_state":"TX","county_code":"273","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"JIII COMPANY YARD","shipping_paper_number":"N\/A","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-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","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":"9548364","transaction_code":"A","transaction_date":"2025-04-11 00:00:00","upload_date":"2025-04-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02514675","upload_search_indicator":"M","census_search_date":"2025-04-11 21:41:00","snet_input_date":"2025-04-09 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-04-11 21:41:00","insp_carrier_name":"EARTH AGGREGATES LLC","insp_carrier_street":"1900 E 28TH ST STE Z","insp_carrier_city":"WESLACO","insp_carrier_state":"TX","insp_carrier_zip_code":"78596","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0876273","created_at":"2025-04-14T10:29:52.000000Z","updated_at":"2025-04-15T10:16:09.000000Z","inspection_violations":[{"id":13164237,"change_date":"2025-04-11 21:41:00","inspection_id":"84378868","insp_violation_id":"265579058","seq_no":"1","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"206274837","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-13T11:07:15.000000Z","updated_at":"2025-04-15T10:39:06.000000Z","normalized_code":"39617C"},{"id":13164238,"change_date":"2025-04-11 21:41:00","inspection_id":"84378868","insp_violation_id":"265579059","seq_no":"2","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"206274837","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-13T11:07:15.000000Z","updated_at":"2025-04-15T10:39:06.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":13558867,"change_date":"2025-04-11 21:41:00","inspection_id":"84378868","insp_unit_id":"206274837","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"113","insp_unit_license":"1M21437","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4V4WC9EHXLN252306","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-14T10:19:47.000000Z","updated_at":"2025-04-15T10:06:19.000000Z"},{"id":13558868,"change_date":"2025-04-11 21:41:00","inspection_id":"84378868","insp_unit_id":"206274838","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CLEM","insp_unit_company":"T113","insp_unit_license":"143C350","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5C2CD40B9FM008482","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-14T10:19:47.000000Z","updated_at":"2025-04-15T10:06:19.000000Z"}]},{"id":7996911,"change_date":"2025-02-28 21:42:00","inspection_id":"84000453","dot_number":"2514675","report_state":"TX","report_number":"V251797186","insp_date":"2025-02-25 00:00:00","insp_start_time":"1050","insp_end_time":"1110","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US281 SB","county_code_state":"TX","county_code":"047","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SELF","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-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"125500","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":"9510539","transaction_code":"A","transaction_date":"2025-02-28 00:00:00","upload_date":"2025-02-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02514675","upload_search_indicator":"M","census_search_date":"2025-02-28 21:42:00","snet_input_date":"2025-02-25 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-02-28 21:42:00","insp_carrier_name":"EARTH AGGREGATES LLC","insp_carrier_street":"1900 E 28TH ST STE Z","insp_carrier_city":"WESLACO","insp_carrier_state":"TX","insp_carrier_zip_code":"78596","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0876273","created_at":"2025-03-17T21:04:07.000000Z","updated_at":"2025-03-17T21:04:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12910191,"change_date":"2025-02-28 21:42:00","inspection_id":"84000453","insp_unit_id":"205570484","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"116","insp_unit_license":"1N46224","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4V4WC9EG4RN659523","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:37.000000Z","updated_at":"2025-03-17T23:57:37.000000Z"},{"id":12910192,"change_date":"2025-02-28 21:42:00","inspection_id":"84000453","insp_unit_id":"205570485","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":null,"insp_unit_company":"ESD-1","insp_unit_license":"7133G72","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1S9SS4025SL476121","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:37.000000Z","updated_at":"2025-03-17T23:57:37.000000Z"}]},{"id":7558386,"change_date":"2025-01-08 21:39:00","inspection_id":"83540059","dot_number":"2514675","report_state":"TX","report_number":"V251736779","insp_date":"2025-01-02 00:00:00","insp_start_time":"1229","insp_end_time":"1245","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US281 BUS NB","county_code_state":"TX","county_code":"249","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"J-III","shipping_paper_number":"1005662","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-01-06 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"122350","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":"9466357","transaction_code":"C","transaction_date":"2025-01-08 00:00:00","upload_date":"2025-01-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02514675","upload_search_indicator":"M","census_search_date":"2025-01-06 21:39:00","snet_input_date":"2025-01-02 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-01-06 21:39:00","insp_carrier_name":"EARTH AGGREGATES LLC","insp_carrier_street":"1900 E 28TH ST STE Z","insp_carrier_city":"WESLACO","insp_carrier_state":"TX","insp_carrier_zip_code":"78596","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0876273","created_at":"2025-03-17T20:54:57.000000Z","updated_at":"2025-03-17T20:54:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12195640,"change_date":"2025-01-08 21:39:00","inspection_id":"83540059","insp_unit_id":"204712428","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"115","insp_unit_license":"1M99034","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4V4WC9EH5PN625841","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:39.000000Z","updated_at":"2025-03-17T23:49:39.000000Z"},{"id":12195641,"change_date":"2025-01-08 21:39:00","inspection_id":"83540059","insp_unit_id":"204712429","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CLEM","insp_unit_company":"T115","insp_unit_license":"223C106","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5C2CD40B0FM008483","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:39.000000Z","updated_at":"2025-03-17T23:49:39.000000Z"}]},{"id":5333335,"change_date":"2024-03-20 21:43:00","inspection_id":"81157053","dot_number":"2514675","report_state":"TX","report_number":"V241366577","insp_date":"2024-03-19 00:00:00","insp_start_time":"0555","insp_end_time":"0623","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"LAT:27   10' 57.3N","county_code_state":"TX","county_code":"047","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","shipping_paper_number":"N\/A","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-20 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"9228456","transaction_code":"A","transaction_date":"2024-03-20 00:00:00","upload_date":"2024-03-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02514675","upload_search_indicator":"M","census_search_date":"2024-03-20 21:43:00","snet_input_date":"2024-03-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-03-20 21:43:00","insp_carrier_name":"EARTH AGGREGATES LLC","insp_carrier_street":"1900 E 28TH ST STE Z","insp_carrier_city":"WESLACO","insp_carrier_state":"TX","insp_carrier_zip_code":"78596","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0876273","created_at":"2025-03-17T20:08:18.000000Z","updated_at":"2025-03-17T20:08:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8589019,"change_date":"2024-03-20 21:43:00","inspection_id":"81157053","insp_unit_id":"200014168","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"114","insp_unit_license":"1M21438","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4V4WC9EH1LN252307","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:53.000000Z","updated_at":"2025-03-17T23:12:53.000000Z"},{"id":8589020,"change_date":"2024-03-20 21:43:00","inspection_id":"81157053","insp_unit_id":"200014169","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CLEM","insp_unit_company":"T-116","insp_unit_license":"064B694","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5C2CB40B6EM008746","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:53.000000Z","updated_at":"2025-03-17T23:12:53.000000Z"}]},{"id":5289589,"change_date":"2024-03-14 21:42:00","inspection_id":"81109275","dot_number":"2514675","report_state":"TX","report_number":"V241359101","insp_date":"2024-03-11 00:00:00","insp_start_time":"0955","insp_end_time":"1127","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ENTRY RAMP AT US281","county_code_state":"TX","county_code":"249","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"EARTH AGGREGATES","shipping_paper_number":"6420439","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-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9222039","transaction_code":"A","transaction_date":"2024-03-14 00:00:00","upload_date":"2024-03-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02514675","upload_search_indicator":"M","census_search_date":"2024-03-14 21:42:00","snet_input_date":"2024-03-11 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-03-14 21:42:00","insp_carrier_name":"EARTH AGGREGATES LLC","insp_carrier_street":"1900 E 28TH ST STE Z","insp_carrier_city":"WESLACO","insp_carrier_state":"TX","insp_carrier_zip_code":"78596","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0876273","created_at":"2025-03-17T20:07:29.000000Z","updated_at":"2025-03-17T20:07:29.000000Z","inspection_violations":[{"id":8157308,"change_date":"2024-03-14 21:42:00","inspection_id":"81109275","insp_violation_id":"258393646","seq_no":"1","part_no":"393","part_no_section":"23","insp_viol_unit":"2","insp_unit_id":"199922205","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2025-03-17T21:45:24.000000Z","updated_at":"2025-03-17T21:45:24.000000Z","normalized_code":"39323"},{"id":8157309,"change_date":"2024-03-14 21:42:00","inspection_id":"81109275","insp_violation_id":"258393647","seq_no":"2","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"199922205","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:24.000000Z","updated_at":"2025-03-17T21:45:24.000000Z","normalized_code":"39348A"},{"id":8157310,"change_date":"2024-03-14 21:42:00","inspection_id":"81109275","insp_violation_id":"258393648","seq_no":"3","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"199922205","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:24.000000Z","updated_at":"2025-03-17T21:45:24.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":8518292,"change_date":"2024-03-14 21:42:00","inspection_id":"81109275","insp_unit_id":"199922204","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"115","insp_unit_license":"1M99034","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4V4WC9EH5PN625841","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:12.000000Z","updated_at":"2025-03-17T23:12:12.000000Z"},{"id":8518293,"change_date":"2024-03-14 21:42:00","inspection_id":"81109275","insp_unit_id":"199922205","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CLEM","insp_unit_company":"T115","insp_unit_license":"223C106","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5C2CD40B0FM008483","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:12.000000Z","updated_at":"2025-03-17T23:12:12.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2514675\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2514675\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2514675\/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\/2514675\/inspections","per_page":100,"prev_page_url":null,"to":33,"total":33}