{"current_page":1,"data":[{"id":11289124,"change_date":"2026-03-04 21:41:00","inspection_id":"87204306","dot_number":"470443","report_state":"TX","report_number":"7DCH9DHZ6P","insp_date":"2026-02-25 00:00:00","insp_start_time":"1750","insp_end_time":"1820","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"300  MERCURY","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"PHIILLIPS 66","shipping_paper_number":"918940","cargo_tank":"406","hazmat_placard_req":"N","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-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"116000","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":"1","hazmat_oos_total":"0","snet_sequence_id":"9872348","transaction_code":"A","transaction_date":"2026-03-04 00:00:00","upload_date":"2026-03-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00470443","upload_search_indicator":"M","census_search_date":"2026-03-04 21:41:00","snet_input_date":"2026-02-25 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-03-04 21:41:00","insp_carrier_name":"ALEXANDER TRUCKING COMPANY","insp_carrier_street":"2993 TX 123 BYPASS","insp_carrier_city":"SEGUIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78155","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0090478","created_at":"2026-03-07T10:39:13.000000Z","updated_at":"2026-03-15T09:31:08.000000Z","inspection_violations":[{"id":18982909,"change_date":"2026-03-04 21:41:00","inspection_id":"87204306","insp_violation_id":"272197558","seq_no":"1","part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"1","insp_unit_id":"211969494","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-07T10:57:50.000000Z","updated_at":"2026-03-15T09:42:15.000000Z","normalized_code":"39345B2UV"},{"id":18982910,"change_date":"2026-03-04 21:41:00","inspection_id":"87204306","insp_violation_id":"272197559","seq_no":"2","part_no":"172","part_no_section":"201A2","insp_viol_unit":"1","insp_unit_id":"211969494","insp_violation_category_id":"31","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-07T10:57:50.000000Z","updated_at":"2026-03-15T09:42:15.000000Z","normalized_code":"172201A2"}],"inspection_per_units":[{"id":19308765,"change_date":"2026-03-04 21:41:00","inspection_id":"87204306","insp_unit_id":"211969494","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"583","insp_unit_license":"1M76327","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJBBCK47LY00583","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-07T10:15:47.000000Z","updated_at":"2026-03-15T09:04:57.000000Z"},{"id":19308766,"change_date":"2026-03-04 21:41:00","inspection_id":"87204306","insp_unit_id":"211969495","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"PT170Y9","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"558MEBN20MK005988","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-07T10:15:47.000000Z","updated_at":"2026-03-15T09:04:57.000000Z"}]},{"id":10589823,"change_date":"2026-01-07 21:38:00","inspection_id":"86728615","dot_number":"470443","report_state":"TX","report_number":"V262159218","insp_date":"2026-01-05 00:00:00","insp_start_time":"1103","insp_end_time":"1147","registration_date":null,"region":"CT","ci_status_code":"C","location":"6A401","location_desc":"IH35 SB SAN MARCOS SCALE","county_code_state":"TX","county_code":"209","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"FUEL WISE","shipping_paper_number":null,"cargo_tank":"406","hazmat_placard_req":"Y","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-01-07 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"116350","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":"9809968","transaction_code":"A","transaction_date":"2026-01-07 00:00:00","upload_date":"2026-01-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00470443","upload_search_indicator":"M","census_search_date":"2026-01-07 21:38:00","snet_input_date":"2026-01-05 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-01-07 21:38:00","insp_carrier_name":"ALEXANDER TRUCKING COMPANY","insp_carrier_street":"2993 TX 123 BYPASS","insp_carrier_city":"SEGUIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78155","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0090478","created_at":"2026-01-10T10:34:41.000000Z","updated_at":"2026-01-18T10:31:55.000000Z","inspection_violations":[{"id":17799306,"change_date":"2026-01-07 21:38:00","inspection_id":"86728615","insp_violation_id":"271065515","seq_no":"1","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"210958365","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-10T10:38:59.000000Z","updated_at":"2026-01-18T10:32:04.000000Z","normalized_code":"39360C"}],"inspection_per_units":[{"id":17751253,"change_date":"2026-01-07 21:38:00","inspection_id":"86728615","insp_unit_id":"210958365","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"118","insp_unit_license":"1N32856","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3HSDZAPR9PN739118","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-10T10:06:11.000000Z","updated_at":"2026-01-18T10:01:30.000000Z"},{"id":17751254,"change_date":"2026-01-07 21:38:00","inspection_id":"86728615","insp_unit_id":"210958366","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"8245","insp_unit_license":"247C700","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"558MSB321SK008245","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-10T10:06:11.000000Z","updated_at":"2026-01-18T10:01:30.000000Z"}]},{"id":10499295,"change_date":"2025-12-22 21:39:00","inspection_id":"86634077","dot_number":"470443","report_state":"TX","report_number":"V252155546","insp_date":"2025-12-18 00:00:00","insp_start_time":"0902","insp_end_time":"0936","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH 35 SB @ MM 206","county_code_state":"TX","county_code":"209","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ALEXANDER OIL","shipping_paper_number":"431977","cargo_tank":"406","hazmat_placard_req":"Y","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-22 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"116000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9794188","transaction_code":"A","transaction_date":"2025-12-22 00:00:00","upload_date":"2025-12-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00470443","upload_search_indicator":"M","census_search_date":"2025-12-22 21:39:00","snet_input_date":"2025-12-18 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-12-22 21:39:00","insp_carrier_name":"ALEXANDER TRUCKING COMPANY","insp_carrier_street":"2993 TX 123 BYPASS","insp_carrier_city":"SEGUIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78155","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0090478","created_at":"2025-12-25T10:37:48.000000Z","updated_at":"2026-01-02T10:31:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17580653,"change_date":"2025-12-22 21:39:00","inspection_id":"86634077","insp_unit_id":"210759941","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"117","insp_unit_license":"1N32857","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3HSDZAPR7PN739117","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-25T10:08:45.000000Z","updated_at":"2026-01-02T10:01:10.000000Z"},{"id":17580654,"change_date":"2025-12-22 21:39:00","inspection_id":"86634077","insp_unit_id":"210759942","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"215B749","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"558MSB321PK007121","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-25T10:08:45.000000Z","updated_at":"2026-01-02T10:01:10.000000Z"}]},{"id":10571071,"change_date":"2026-01-06 21:39:00","inspection_id":"86708965","dot_number":"470443","report_state":"TX","report_number":"7BEC9DCJ7F","insp_date":"2025-12-17 00:00:00","insp_start_time":"1221","insp_end_time":"1242","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"400 E LOOP N","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MARATHON PETROL","shipping_paper_number":"4227095","cargo_tank":"406","hazmat_placard_req":"Y","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-01-05 21:37: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":"9805667","transaction_code":"C","transaction_date":"2026-01-06 00:00:00","upload_date":"2026-01-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00470443","upload_search_indicator":"M","census_search_date":"2026-01-05 21:37:00","snet_input_date":"2025-12-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-01-05 21:37:00","insp_carrier_name":"ALEXANDER TRUCKING COMPANY","insp_carrier_street":"2993 TX 123 BYPASS","insp_carrier_city":"SEGUIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78155","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0090478","created_at":"2026-01-08T10:34:20.000000Z","updated_at":"2026-01-17T10:30:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17725368,"change_date":"2026-01-06 21:39:00","inspection_id":"86708965","insp_unit_id":"210931201","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"108","insp_unit_license":"1M17559","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CK19LAD3108","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-09T10:05:53.000000Z","updated_at":"2026-01-17T10:00:49.000000Z"},{"id":17725369,"change_date":"2026-01-06 21:39:00","inspection_id":"86708965","insp_unit_id":"210931202","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"MACL","insp_unit_company":null,"insp_unit_license":"136C134","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"558MEBN25KK004736","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-09T10:05:53.000000Z","updated_at":"2026-01-17T10:00:49.000000Z"}]},{"id":10165887,"change_date":"2025-11-12 21:41:00","inspection_id":"86284918","dot_number":"470443","report_state":"TX","report_number":"7A969DAY09","insp_date":"2025-11-06 00:00:00","insp_start_time":"0647","insp_end_time":"0722","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0290 IN HARRIS CO. (706-738","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"GLOBAL","shipping_paper_number":"0004208992","cargo_tank":"406","hazmat_placard_req":"Y","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:39:00","post_acc_ind":"N","gross_comb_veh_wt":"0","viol_total":"5","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9752130","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":"00470443","upload_search_indicator":"M","census_search_date":"2025-11-10 21:39:00","snet_input_date":"2025-11-06 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-11-10 21:39:00","insp_carrier_name":"ALEXANDER TRUCKING COMPANY","insp_carrier_street":"2993 TX 123 BYPASS","insp_carrier_city":"SEGUIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78155","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0090478","created_at":"2025-11-13T10:30:45.000000Z","updated_at":"2025-11-16T10:30:51.000000Z","inspection_violations":[{"id":16902442,"change_date":"2025-11-12 21:41:00","inspection_id":"86284918","insp_violation_id":"269901480","seq_no":"1","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"209983351","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-15T10:31:02.000000Z","updated_at":"2025-11-16T10:31:30.000000Z","normalized_code":"3965B"},{"id":16902443,"change_date":"2025-11-12 21:41:00","inspection_id":"86284918","insp_violation_id":"269901481","seq_no":"2","part_no":"393","part_no_section":"55D2","insp_viol_unit":"1","insp_unit_id":"209983351","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-15T10:31:02.000000Z","updated_at":"2025-11-16T10:31:30.000000Z","normalized_code":"39355D2"},{"id":16902444,"change_date":"2025-11-12 21:41:00","inspection_id":"86284918","insp_violation_id":"269901482","seq_no":"3","part_no":"393","part_no_section":"55E","insp_viol_unit":"2","insp_unit_id":"209983352","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-15T10:31:02.000000Z","updated_at":"2025-11-16T10:31:30.000000Z","normalized_code":"39355E"},{"id":16902445,"change_date":"2025-11-12 21:41:00","inspection_id":"86284918","insp_violation_id":"269901483","seq_no":"4","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"209983351","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-15T10:31:02.000000Z","updated_at":"2025-11-16T10:31:30.000000Z","normalized_code":"39347E"},{"id":16902446,"change_date":"2025-11-12 21:41:00","inspection_id":"86284918","insp_violation_id":"269901484","seq_no":"5","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"209983351","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-15T10:31:02.000000Z","updated_at":"2025-11-16T10:31:30.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":16950155,"change_date":"2025-11-12 21:41:00","inspection_id":"86284918","insp_unit_id":"209983351","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"108","insp_unit_license":"1M17559","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CK19LAD3108","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":16950156,"change_date":"2025-11-12 21:41:00","inspection_id":"86284918","insp_unit_id":"209983352","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"4736","insp_unit_license":"136C134","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"558MEBN25KK004736","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":9771758,"change_date":"2025-09-24 21:42:00","inspection_id":"85869717","dot_number":"470443","report_state":"TX","report_number":"V252029916","insp_date":"2025-09-23 00:00:00","insp_start_time":"0501","insp_end_time":"0548","registration_date":null,"region":"CT","ci_status_code":"C","location":"6A101","location_desc":"IH10 EB KINGSBURY SCALE","county_code_state":"TX","county_code":"187","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ALEXANDER TRUCKING COMPANY","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-09-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"53200","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":"9706516","transaction_code":"A","transaction_date":"2025-09-24 00:00:00","upload_date":"2025-09-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00470443","upload_search_indicator":"M","census_search_date":"2025-09-24 21:42:00","snet_input_date":"2025-09-23 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-09-24 21:42:00","insp_carrier_name":"ALEXANDER TRUCKING COMPANY","insp_carrier_street":"2993 TX 123 BYPASS","insp_carrier_city":"SEGUIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78155","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0090478","created_at":"2025-09-26T10:01:17.000000Z","updated_at":"2025-09-28T10:00:46.000000Z","inspection_violations":[{"id":16061884,"change_date":"2025-09-24 21:42:00","inspection_id":"85869717","insp_violation_id":"268904295","seq_no":"1","part_no":"393","part_no_section":"11TL","insp_viol_unit":"1","insp_unit_id":"209129814","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-27T10:17:10.000000Z","updated_at":"2025-09-28T10:16:17.000000Z","normalized_code":"39311TL"}],"inspection_per_units":[{"id":16188608,"change_date":"2025-09-24 21:42:00","inspection_id":"85869717","insp_unit_id":"209129814","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"9923118","insp_unit_license":"1N86157","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPBDP9X5KD494548","insp_unit_decal":"Y","insp_unit_decal_number":"35398802","created_at":"2025-09-27T09:46:24.000000Z","updated_at":"2025-09-29T09:46:16.000000Z"}]},{"id":9760043,"change_date":"2025-09-23 21:43:00","inspection_id":"85857432","dot_number":"470443","report_state":"TX","report_number":"V252012355","insp_date":"2025-09-22 00:00:00","insp_start_time":"0950","insp_end_time":"1025","registration_date":null,"region":"CT","ci_status_code":"C","location":"6A202","location_desc":"IH35 NB DEVINE SCALE","county_code_state":"TX","county_code":"325","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"GLOBAL","shipping_paper_number":"0001095866","cargo_tank":"406","hazmat_placard_req":"Y","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-23 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"116350","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":"9705456","transaction_code":"A","transaction_date":"2025-09-23 00:00:00","upload_date":"2025-09-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00470443","upload_search_indicator":"M","census_search_date":"2025-09-23 21:43:00","snet_input_date":"2025-09-22 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-09-23 21:43:00","insp_carrier_name":"ALEXANDER TRUCKING COMPANY","insp_carrier_street":"2993 TX 123 BYPASS","insp_carrier_city":"SEGUIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78155","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0090478","created_at":"2025-09-25T10:00:51.000000Z","updated_at":"2025-09-26T10:00:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16167559,"change_date":"2025-09-23 21:43:00","inspection_id":"85857432","insp_unit_id":"209107307","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"117","insp_unit_license":"1N32857","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3HSDZAPR7PN739117","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-26T09:46:11.000000Z","updated_at":"2025-09-27T09:46:07.000000Z"},{"id":16167560,"change_date":"2025-09-23 21:43:00","inspection_id":"85857432","insp_unit_id":"209107308","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MACL","insp_unit_company":"6941","insp_unit_license":"202C348","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"558MSB325NK006941","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-26T09:46:11.000000Z","updated_at":"2025-09-27T09:46:07.000000Z"}]},{"id":8964378,"change_date":"2025-06-23 21:41:00","inspection_id":"85021302","dot_number":"470443","report_state":"TX","report_number":"V251836051","insp_date":"2025-06-20 00:00:00","insp_start_time":"0729","insp_end_time":"0758","registration_date":null,"region":"CT","ci_status_code":"C","location":"3C302","location_desc":"US281 SB FALFURRIAS SCALE","county_code_state":"TX","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"FLINTHILS","shipping_paper_number":"247672","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-06-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"116350","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":"9614322","transaction_code":"A","transaction_date":"2025-06-23 00:00:00","upload_date":"2025-06-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00470443","upload_search_indicator":"M","census_search_date":"2025-06-23 21:41:00","snet_input_date":"2025-06-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-06-23 21:41:00","insp_carrier_name":"ALEXANDER TRUCKING COMPANY","insp_carrier_street":"2993 TX 123 BYPASS","insp_carrier_city":"SEGUIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78155","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0090478","created_at":"2025-06-28T10:00:38.000000Z","updated_at":"2025-06-28T10:00:38.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18734146,"change_date":null,"inspection_id":"85021302","insp_unit_id":"1","insp_unit_type_id":"6","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"1N32857","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3HSDZAPR7PN739117","insp_unit_decal":null,"insp_unit_decal_number":"35111921","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18817571,"change_date":null,"inspection_id":"85021302","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"215B749","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"558MSB321PK007121","insp_unit_decal":null,"insp_unit_decal_number":"35111922","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":8829176,"change_date":"2025-06-05 21:41:00","inspection_id":"84877651","dot_number":"470443","report_state":"TX","report_number":"V251893170","insp_date":"2025-06-04 00:00:00","insp_start_time":"0645","insp_end_time":"0725","registration_date":null,"region":"CT","ci_status_code":"C","location":"6A201","location_desc":"IH35 SB DEVINE SCALE","county_code_state":"TX","county_code":"325","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SAN ANTONIO SOUTH","shipping_paper_number":"0019423","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-06-05 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"116350","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":"9600074","transaction_code":"A","transaction_date":"2025-06-05 00:00:00","upload_date":"2025-06-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00470443","upload_search_indicator":"M","census_search_date":"2025-06-05 21:41:00","snet_input_date":"2025-06-04 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-06-05 21:41:00","insp_carrier_name":"ALEXANDER TRUCKING COMPANY","insp_carrier_street":"2993 TX 123 BYPASS","insp_carrier_city":"SEGUIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78155","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0090478","created_at":"2025-06-09T10:01:08.000000Z","updated_at":"2025-06-09T10:01:08.000000Z","inspection_violations":[{"id":18454809,"change_date":null,"inspection_id":"84877651","insp_violation_id":null,"seq_no":null,"part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":18732281,"change_date":null,"inspection_id":"84877651","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"1N32857","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3HSDZAPR7PN739117","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18815522,"change_date":null,"inspection_id":"84877651","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"215B749","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"558MSB321PK007121","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":9963149,"change_date":"2025-10-16 21:40:00","inspection_id":"86071347","dot_number":"470443","report_state":"TX","report_number":"756A9DCB4T","insp_date":"2025-05-07 00:00:00","insp_start_time":"1023","insp_end_time":"1051","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"14700  BUXLEY","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":"406","hazmat_placard_req":"Y","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-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9727939","transaction_code":"A","transaction_date":"2025-10-16 00:00:00","upload_date":"2025-10-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00470443","upload_search_indicator":"M","census_search_date":"2025-10-16 21:40:00","snet_input_date":"2025-05-07 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-10-16 21:40:00","insp_carrier_name":"ALEXANDER TRUCKING COMPANY","insp_carrier_street":"2993 TX 123 BYPASS","insp_carrier_city":"SEGUIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78155","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0090478","created_at":"2025-10-19T10:01:48.000000Z","updated_at":"2025-10-20T10:01:18.000000Z","inspection_violations":[{"id":16453848,"change_date":"2025-10-16 21:40:00","inspection_id":"86071347","insp_violation_id":"269347728","seq_no":"1","part_no":"393","part_no_section":"209E","insp_viol_unit":"1","insp_unit_id":"209512001","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-19T10:17:50.000000Z","updated_at":"2025-10-20T10:16:59.000000Z","normalized_code":"393209E"}],"inspection_per_units":[{"id":16541782,"change_date":"2025-10-16 21:40:00","inspection_id":"86071347","insp_unit_id":"209512001","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"831","insp_unit_license":"1M35168","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3HSCUAPR4BN185831","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-19T09:47:01.000000Z","updated_at":"2025-10-20T09:46:31.000000Z"},{"id":16541783,"change_date":"2025-10-16 21:40:00","inspection_id":"86071347","insp_unit_id":"209512002","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"4732","insp_unit_license":"144B364","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"558MEBN28KK004732","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-19T09:47:01.000000Z","updated_at":"2025-10-20T09:46:31.000000Z"}]},{"id":8395303,"change_date":"2025-04-16 21:41:00","inspection_id":"84419875","dot_number":"470443","report_state":"TX","report_number":"V251821188","insp_date":"2025-04-10 00:00:00","insp_start_time":"1048","insp_end_time":"1232","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-16 AND SH-97","county_code_state":"TX","county_code":"013","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SUNOCO LP","shipping_paper_number":"0012574","cargo_tank":"406","hazmat_placard_req":"Y","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":"2025-04-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"116000","viol_total":"9","oos_total":"1","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9552272","transaction_code":"A","transaction_date":"2025-04-16 00:00:00","upload_date":"2025-04-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00470443","upload_search_indicator":"M","census_search_date":"2025-04-16 21:41:00","snet_input_date":"2025-04-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-04-16 21:41:00","insp_carrier_name":"ALEXANDER TRUCKING COMPANY","insp_carrier_street":"2993 TX 123 BYPASS","insp_carrier_city":"SEGUIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78155","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0090478","created_at":"2025-04-19T10:19:33.000000Z","updated_at":"2025-04-20T10:26:27.000000Z","inspection_violations":[{"id":18447156,"change_date":null,"inspection_id":"84419875","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"11TU","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39311TU"},{"id":18447157,"change_date":null,"inspection_id":"84419875","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"45","insp_viol_unit":"2","insp_unit_id":"2","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39345"},{"id":18447158,"change_date":null,"inspection_id":"84419875","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"45DLUV","insp_viol_unit":"2","insp_unit_id":"2","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39345DLUV"},{"id":18447159,"change_date":null,"inspection_id":"84419875","insp_violation_id":null,"seq_no":null,"part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"2","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39617C"},{"id":18447160,"change_date":null,"inspection_id":"84419875","insp_violation_id":null,"seq_no":null,"part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":18726618,"change_date":null,"inspection_id":"84419875","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"1N14566","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CKX7LX77644","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18809353,"change_date":null,"inspection_id":"84419875","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"191B692","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"558MSB323NK006906","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7970997,"change_date":"2025-02-27 21:41:00","inspection_id":"83973298","dot_number":"470443","report_state":"TX","report_number":"73189DAY4X","insp_date":"2025-02-19 00:00:00","insp_start_time":"0830","insp_end_time":"0856","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"18700  KICKAPOO RD","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MARATHON PETROL","shipping_paper_number":"4095183","cargo_tank":"406","hazmat_placard_req":"Y","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-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"0","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9507567","transaction_code":"C","transaction_date":"2025-02-27 00:00:00","upload_date":"2025-02-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00470443","upload_search_indicator":"M","census_search_date":"2025-02-26 21:42:00","snet_input_date":"2025-02-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-02-26 21:42:00","insp_carrier_name":"ALEXANDER TRUCKING COMPANY","insp_carrier_street":"2993 TX 123 BYPASS","insp_carrier_city":"SEGUIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78155","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0090478","created_at":"2025-03-17T21:03:39.000000Z","updated_at":"2025-03-17T21:03:39.000000Z","inspection_violations":[{"id":18440095,"change_date":null,"inspection_id":"83973298","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"55(d)(2)","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39355D2"},{"id":18440096,"change_date":null,"inspection_id":"83973298","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"2","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39355E"},{"id":18440097,"change_date":null,"inspection_id":"83973298","insp_violation_id":null,"seq_no":null,"part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":18721025,"change_date":null,"inspection_id":"83973298","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"1M17559","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CK19LAD3108","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18803160,"change_date":null,"inspection_id":"83973298","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"136C134","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"558MEBN25KK004736","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7574911,"change_date":"2025-01-08 21:39:00","inspection_id":"83557476","dot_number":"470443","report_state":"TX","report_number":"V251614658","insp_date":"2025-01-06 00:00:00","insp_start_time":"1143","insp_end_time":"1227","registration_date":null,"region":"CT","ci_status_code":"C","location":"6A101","location_desc":"IH10 EB KINGSBURY SCALE","county_code_state":"TX","county_code":"187","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"FLINT HILLS RESOURCES","shipping_paper_number":"1709786","cargo_tank":"406","hazmat_placard_req":"Y","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-08 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117200","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":"9468763","transaction_code":"A","transaction_date":"2025-01-08 00:00:00","upload_date":"2025-01-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00470443","upload_search_indicator":"M","census_search_date":"2025-01-08 21:39:00","snet_input_date":"2025-01-06 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-01-08 21:39:00","insp_carrier_name":"ALEXANDER TRUCKING COMPANY","insp_carrier_street":"2993 TX 123 BYPASS","insp_carrier_city":"SEGUIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78155","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0090478","created_at":"2025-03-17T20:55:18.000000Z","updated_at":"2025-03-17T20:55:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18715784,"change_date":null,"inspection_id":"83557476","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"1M92720","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKZDP9X1LJ413794","insp_unit_decal":null,"insp_unit_decal_number":"34863149","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18797390,"change_date":null,"inspection_id":"83557476","insp_unit_id":"2","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"MACL","insp_unit_company":null,"insp_unit_license":"215B749","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"558MSB321PK007121","insp_unit_decal":null,"insp_unit_decal_number":"34863150","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7558424,"change_date":"2025-01-08 21:39:00","inspection_id":"83540103","dot_number":"470443","report_state":"TX","report_number":"V251742812","insp_date":"2025-01-04 00:00:00","insp_start_time":"1422","insp_end_time":"1518","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH69 SB \/ FM 762","county_code_state":"TX","county_code":"157","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MOTIVA ENTERPRISES","shipping_paper_number":"0001937358","cargo_tank":"406","hazmat_placard_req":"Y","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":"118300","viol_total":"7","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"1","hazmat_viol_total":"1","hazmat_oos_total":"0","snet_sequence_id":"9466754","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":"00470443","upload_search_indicator":"M","census_search_date":"2025-01-06 21:39:00","snet_input_date":"2025-01-04 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-01-06 21:39:00","insp_carrier_name":"ALEXANDER TRUCKING COMPANY","insp_carrier_street":"2993 TX 123 BYPASS","insp_carrier_city":"SEGUIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78155","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0090478","created_at":"2025-03-17T20:54:57.000000Z","updated_at":"2025-03-17T20:54:57.000000Z","inspection_violations":[{"id":18433629,"change_date":null,"inspection_id":"83540103","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"19","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39319"},{"id":18433630,"change_date":null,"inspection_id":"83540103","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"45DLPC","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39345DLPC"},{"id":18433631,"change_date":null,"inspection_id":"83540103","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"2","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39375A3"},{"id":18433632,"change_date":null,"inspection_id":"83540103","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3939"},{"id":18433633,"change_date":null,"inspection_id":"83540103","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9TS","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3939TS"},{"id":18433634,"change_date":null,"inspection_id":"83540103","insp_violation_id":null,"seq_no":null,"part_no":"397","part_no_section":"13","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39713"}],"inspection_per_units":[{"id":18637821,"change_date":null,"inspection_id":"83540103","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"1L42336","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJGLD53GSGP1193","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18797119,"change_date":null,"inspection_id":"83540103","insp_unit_id":"2","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"MACL","insp_unit_company":null,"insp_unit_license":"202C348","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"558MSB325NK006941","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7520183,"change_date":"2024-12-30 21:39:00","inspection_id":"83499947","dot_number":"470443","report_state":"TX","report_number":"71C89DBC6Q","insp_date":"2024-12-20 00:00:00","insp_start_time":"0749","insp_end_time":"0810","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0290 IN HARRIS CO. (706-738","county_code_state":"TX","county_code":"201","insp_level_id":"4","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MAGELLAN","shipping_paper_number":"2279350","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-12-30 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"0","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9460790","transaction_code":"A","transaction_date":"2024-12-30 00:00:00","upload_date":"2024-12-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00470443","upload_search_indicator":"M","census_search_date":"2024-12-30 21:39:00","snet_input_date":"2024-12-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-12-30 21:39:00","insp_carrier_name":"ALEXANDER TRUCKING COMPANY","insp_carrier_street":"2993 TX 123 BYPASS","insp_carrier_city":"SEGUIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78155","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0090478","created_at":"2025-03-17T20:53:08.000000Z","updated_at":"2025-03-17T20:53:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18637268,"change_date":null,"inspection_id":"83499947","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"1M78027","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJGBDV2FSGJ9899","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18796437,"change_date":null,"inspection_id":"83499947","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":null,"insp_unit_license":"082B948","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5HTAB442657H68287","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7049920,"change_date":"2024-10-25 21:41:00","inspection_id":"83003865","dot_number":"470443","report_state":"TX","report_number":"V241632943","insp_date":"2024-10-10 00:00:00","insp_start_time":"0900","insp_end_time":"0944","registration_date":null,"region":"CT","ci_status_code":"C","location":"6A202","location_desc":"IH35 NB DEVINE SCALE","county_code_state":"TX","county_code":"325","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"BIG'S 304 - TX","shipping_paper_number":"NONE","cargo_tank":"407","hazmat_placard_req":"Y","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-10-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"116350","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":"9411728","transaction_code":"A","transaction_date":"2024-10-25 00:00:00","upload_date":"2024-10-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00470443","upload_search_indicator":"M","census_search_date":"2024-10-25 21:41:00","snet_input_date":"2024-10-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-10-25 21:41:00","insp_carrier_name":"ALEXANDER TRUCKING COMPANY","insp_carrier_street":"2993 TX 123 BYPASS","insp_carrier_city":"SEGUIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78155","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0090478","created_at":"2025-03-17T20:43:01.000000Z","updated_at":"2025-03-17T20:43:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18708480,"change_date":null,"inspection_id":"83003865","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"1N32857","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3HSDZAPR7PN739117","insp_unit_decal":null,"insp_unit_decal_number":"34548735","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18789407,"change_date":null,"inspection_id":"83003865","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"215B749","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"558MSB321PK007121","insp_unit_decal":null,"insp_unit_decal_number":"34248736","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6829360,"change_date":"2024-09-26 21:41:00","inspection_id":"82769476","dot_number":"470443","report_state":"TX","report_number":"V241559085","insp_date":"2024-09-24 00:00:00","insp_start_time":"0937","insp_end_time":"1025","registration_date":null,"region":"CT","ci_status_code":"C","location":"6A202","location_desc":"IH35 NB DEVINE SCALE","county_code_state":"TX","county_code":"325","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SHELL; IH35","shipping_paper_number":"0001047618","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-09-26 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"0","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":"1","hazmat_oos_total":"0","snet_sequence_id":"9387999","transaction_code":"A","transaction_date":"2024-09-26 00:00:00","upload_date":"2024-09-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00470443","upload_search_indicator":"M","census_search_date":"2024-09-26 21:41:00","snet_input_date":"2024-09-24 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-09-26 21:41:00","insp_carrier_name":"ALEXANDER TRUCKING COMPANY","insp_carrier_street":"2993 TX 123 BYPASS","insp_carrier_city":"SEGUIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78155","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0090478","created_at":"2025-03-17T20:38:36.000000Z","updated_at":"2025-03-17T20:38:36.000000Z","inspection_violations":[{"id":18421390,"change_date":null,"inspection_id":"82769476","insp_violation_id":null,"seq_no":null,"part_no":"177","part_no_section":"817(e)","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"177817E"},{"id":18421391,"change_date":null,"inspection_id":"82769476","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9TS","insp_viol_unit":"2","insp_unit_id":"2","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3939TS"},{"id":18421392,"change_date":null,"inspection_id":"82769476","insp_violation_id":null,"seq_no":null,"part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":18627727,"change_date":null,"inspection_id":"82769476","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"1M64713","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKZDP9X1KJ257772","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18786100,"change_date":null,"inspection_id":"82769476","insp_unit_id":"2","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"215B749","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"558MSB321PK007121","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6244048,"change_date":"2024-07-17 21:42:00","inspection_id":"82144974","dot_number":"470443","report_state":"TX","report_number":"V241477193","insp_date":"2024-07-15 00:00:00","insp_start_time":"0918","insp_end_time":"0940","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH35 SB","county_code_state":"TX","county_code":"209","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"AUSTIN PRODUCTS","shipping_paper_number":"1069415","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-07-17 21:42: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":"9328818","transaction_code":"A","transaction_date":"2024-07-17 00:00:00","upload_date":"2024-07-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00470443","upload_search_indicator":"M","census_search_date":"2024-07-17 21:42:00","snet_input_date":"2024-07-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-07-17 21:42:00","insp_carrier_name":"ALEXANDER TRUCKING COMPANY","insp_carrier_street":"2993 TX 123 BYPASS","insp_carrier_city":"SEGUIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78155","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0090478","created_at":"2025-03-17T20:26:35.000000Z","updated_at":"2025-03-17T20:26:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18619822,"change_date":null,"inspection_id":"82144974","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"1N32857","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3HSDZAPR7PN739117","insp_unit_decal":null,"insp_unit_decal_number":"34248625","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18777504,"change_date":null,"inspection_id":"82144974","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"215B749","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"558MSB321PK007121","insp_unit_decal":null,"insp_unit_decal_number":"34248626","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5227438,"change_date":"2024-10-25 21:41:00","inspection_id":"81041267","dot_number":"470443","report_state":"TX","report_number":"V241315703","insp_date":"2024-03-02 00:00:00","insp_start_time":"0723","insp_end_time":"0809","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"LAT:29  47'09.37\"N L","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ALEXANDER TRUCKING","shipping_paper_number":"000","cargo_tank":"406","hazmat_placard_req":"Y","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-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"1","hazmat_oos_total":"0","snet_sequence_id":"9216318","transaction_code":"C","transaction_date":"2024-10-25 00:00:00","upload_date":"2024-10-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00470443","upload_search_indicator":"M","census_search_date":"2024-03-06 21:40:00","snet_input_date":"2024-03-02 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-03-06 21:40:00","insp_carrier_name":"ALEXANDER TRUCKING COMPANY","insp_carrier_street":"2993 TX 123 BYPASS","insp_carrier_city":"SEGUIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78155","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0090478","created_at":"2025-03-17T20:06:12.000000Z","updated_at":"2025-03-17T20:06:12.000000Z","inspection_violations":[{"id":18390116,"change_date":null,"inspection_id":"81041267","insp_violation_id":null,"seq_no":null,"part_no":"177","part_no_section":"817(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"177817A"}],"inspection_per_units":[{"id":18682998,"change_date":null,"inspection_id":"81041267","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"1N32857","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3HSDZAPR7PN739117","insp_unit_decal":null,"insp_unit_decal_number":"33594317","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18761639,"change_date":null,"inspection_id":"81041267","insp_unit_id":"2","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":null,"insp_unit_license":"X59284","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5HTAB442427H66193","insp_unit_decal":null,"insp_unit_decal_number":"33594318","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":4933806,"change_date":"2024-01-30 21:42:00","inspection_id":"80720757","dot_number":"470443","report_state":"TX","report_number":"6S3F9DCKUR","insp_date":"2024-01-22 00:00:00","insp_start_time":"1505","insp_end_time":"1525","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"300  MERCURY","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-01-30 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9183391","transaction_code":"A","transaction_date":"2024-01-30 00:00:00","upload_date":"2024-01-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00470443","upload_search_indicator":"M","census_search_date":"2024-01-30 21:42:00","snet_input_date":"2024-01-22 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-01-30 21:42:00","insp_carrier_name":"ALEXANDER TRUCKING COMPANY","insp_carrier_street":"2993 TX 123 BYPASS","insp_carrier_city":"SEGUIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78155","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0090478","created_at":"2025-03-17T20:00:29.000000Z","updated_at":"2025-03-17T20:00:29.000000Z","inspection_violations":[{"id":18384621,"change_date":null,"inspection_id":"80720757","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"11TT","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39311TT"}],"inspection_per_units":[{"id":18678777,"change_date":null,"inspection_id":"80720757","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"1M76327","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJBBCK47LY00583","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":4877737,"change_date":"2024-01-22 21:44:00","inspection_id":"80659575","dot_number":"470443","report_state":"TX","report_number":"6S249DCNJ7","insp_date":"2024-01-21 00:00:00","insp_start_time":"0435","insp_end_time":"0458","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"1500  N LOOP W SERVI","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"KINDAL MORGAN","shipping_paper_number":"3923442","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-01-22 21:44: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":"9178479","transaction_code":"A","transaction_date":"2024-01-22 00:00:00","upload_date":"2024-01-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00470443","upload_search_indicator":"M","census_search_date":"2024-01-22 21:44:00","snet_input_date":"2024-01-21 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-01-22 21:44:00","insp_carrier_name":"ALEXANDER TRUCKING COMPANY","insp_carrier_street":"2993 TX 123 BYPASS","insp_carrier_city":"SEGUIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78155","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0090478","created_at":"2025-03-17T19:59:17.000000Z","updated_at":"2025-03-17T19:59:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18677956,"change_date":null,"inspection_id":"80659575","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"1N32856","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3HSDZAPR9PN739118","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18755986,"change_date":null,"inspection_id":"80659575","insp_unit_id":"2","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":null,"insp_unit_license":"137C077","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"558MEBN26KK004275","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":4896731,"change_date":"2024-01-24 21:45:00","inspection_id":"80680304","dot_number":"470443","report_state":"TX","report_number":"V241283570","insp_date":"2024-01-17 00:00:00","insp_start_time":"1350","insp_end_time":"1417","registration_date":null,"region":"CT","ci_status_code":"C","location":"6A201","location_desc":"IH 35 SOUTHBOUND DEVINE","county_code_state":"TX","county_code":"325","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ALEXANDER TRUCKING COMPANY","shipping_paper_number":"0056897","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-01-24 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"117200","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":"9180545","transaction_code":"A","transaction_date":"2024-01-24 00:00:00","upload_date":"2024-01-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00470443","upload_search_indicator":"M","census_search_date":"2024-01-24 21:45:00","snet_input_date":"2024-01-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-01-24 21:45:00","insp_carrier_name":"ALEXANDER TRUCKING COMPANY","insp_carrier_street":"2993 TX 123 BYPASS","insp_carrier_city":"SEGUIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78155","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0090478","created_at":"2025-03-17T19:59:39.000000Z","updated_at":"2025-03-17T19:59:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18678199,"change_date":null,"inspection_id":"80680304","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"1M64713","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKZDP9X1KJ257772","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18756262,"change_date":null,"inspection_id":"80680304","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"215B749","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"558MSB321PK007121","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":4850716,"change_date":"2024-01-17 21:44:00","inspection_id":"80629911","dot_number":"470443","report_state":"TX","report_number":"V241271983","insp_date":"2024-01-12 00:00:00","insp_start_time":"0620","insp_end_time":"0735","registration_date":null,"region":"CT","ci_status_code":"C","location":"6A201","location_desc":"IH 35 SOUTHBOUND DEVINE","county_code_state":"TX","county_code":"325","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MOTIVA ENTERPRISES LLC","shipping_paper_number":"0001014739","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-01-17 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"114351","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9175184","transaction_code":"A","transaction_date":"2024-01-17 00:00:00","upload_date":"2024-01-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00470443","upload_search_indicator":"M","census_search_date":"2024-01-17 21:44:00","snet_input_date":"2024-01-12 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-01-17 21:44:00","insp_carrier_name":"ALEXANDER TRUCKING COMPANY","insp_carrier_street":"2993 TX 123 BYPASS","insp_carrier_city":"SEGUIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78155","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0090478","created_at":"2025-03-17T19:58:50.000000Z","updated_at":"2025-03-17T19:58:50.000000Z","inspection_violations":[{"id":18383177,"change_date":null,"inspection_id":"80629911","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"45","insp_viol_unit":"2","insp_unit_id":"2","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39345"},{"id":18383178,"change_date":null,"inspection_id":"80629911","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39345B2UV"},{"id":18383179,"change_date":null,"inspection_id":"80629911","insp_violation_id":null,"seq_no":null,"part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3963A1"},{"id":18383180,"change_date":null,"inspection_id":"80629911","insp_violation_id":null,"seq_no":null,"part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":18599825,"change_date":null,"inspection_id":"80629911","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"1M98340","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4V4NC9TG55N385029","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18755569,"change_date":null,"inspection_id":"80629911","insp_unit_id":"2","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"MACL","insp_unit_company":null,"insp_unit_license":"163B804","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"558MEBN20MK005988","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":4788146,"change_date":"2024-01-08 21:45:00","inspection_id":"80561549","dot_number":"470443","report_state":"TX","report_number":"V241268341","insp_date":"2024-01-03 00:00:00","insp_start_time":"0830","insp_end_time":"0938","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"LAT:30   31' 28.86N","county_code_state":"TX","county_code":"471","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"KINDER MORGAN","shipping_paper_number":"3916504","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-01-08 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"8","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9168217","transaction_code":"A","transaction_date":"2024-01-08 00:00:00","upload_date":"2024-01-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00470443","upload_search_indicator":"M","census_search_date":"2024-01-08 21:45:00","snet_input_date":"2024-01-03 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-01-08 21:45:00","insp_carrier_name":"ALEXANDER TRUCKING COMPANY","insp_carrier_street":"2993 TX 123 BYPASS","insp_carrier_city":"SEGUIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78155","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0090478","created_at":"2025-03-17T19:57:38.000000Z","updated_at":"2025-03-17T19:57:38.000000Z","inspection_violations":[{"id":18382089,"change_date":null,"inspection_id":"80561549","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39347E"},{"id":18382090,"change_date":null,"inspection_id":"80561549","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"48(a)","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39348A"},{"id":18382091,"change_date":null,"inspection_id":"80561549","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39353B"},{"id":18382092,"change_date":null,"inspection_id":"80561549","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3939"},{"id":18382093,"change_date":null,"inspection_id":"80561549","insp_violation_id":null,"seq_no":null,"part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3963A1BOS"},{"id":18382094,"change_date":null,"inspection_id":"80561549","insp_violation_id":null,"seq_no":null,"part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":18598918,"change_date":null,"inspection_id":"80561549","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"1M05764","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPHDU9X2BD117250","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18754557,"change_date":null,"inspection_id":"80561549","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":null,"insp_unit_license":"X59393","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5HTAB442247H67507","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":4712604,"change_date":"2024-12-09 21:41:00","inspection_id":"80479293","dot_number":"470443","report_state":"TX","report_number":"6QXA9DDA1I","insp_date":"2023-12-11 00:00:00","insp_start_time":"1026","insp_end_time":"1051","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"200  SAM HOUSTON PAR","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-12-27 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"90200","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":"9155613","transaction_code":"C","transaction_date":"2024-12-09 00:00:00","upload_date":"2024-12-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00470443","upload_search_indicator":"M","census_search_date":"2023-12-27 21:42:00","snet_input_date":"2023-12-11 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-12-27 21:42:00","insp_carrier_name":"ALEXANDER TRUCKING COMPANY","insp_carrier_street":"2993 TX 123 BYPASS","insp_carrier_city":"SEGUIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78155","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0090478","created_at":"2025-03-17T19:56:11.000000Z","updated_at":"2025-03-17T19:56:11.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3849246,"change_date":"2023-08-28 21:42:00","inspection_id":"79525197","dot_number":"470443","report_state":"TX","report_number":"V231130798","insp_date":"2023-08-25 00:00:00","insp_start_time":"1412","insp_end_time":"1448","registration_date":null,"region":"CT","ci_status_code":"C","location":"6A102","location_desc":"IH 10 WESTBOUND KINGSBURY","county_code_state":"TX","county_code":"187","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"RIGHT CHOICE","shipping_paper_number":"0335583","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-08-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","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":"1","hazmat_oos_total":"0","snet_sequence_id":"9062716","transaction_code":"A","transaction_date":"2023-08-28 00:00:00","upload_date":"2023-08-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00470443","upload_search_indicator":"M","census_search_date":"2023-08-28 21:42:00","snet_input_date":"2023-08-25 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-08-28 21:42:00","insp_carrier_name":"ALEXANDER TRUCKING COMPANY","insp_carrier_street":"2993 TX 123 BYPASS","insp_carrier_city":"SEGUIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78155","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0090478","created_at":"2025-03-17T19:38:55.000000Z","updated_at":"2025-03-17T19:38:55.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3623972,"change_date":"2023-08-07 21:43:00","inspection_id":"79273232","dot_number":"470443","report_state":"TX","report_number":"V231081664","insp_date":"2023-07-26 00:00:00","insp_start_time":"0947","insp_end_time":"1019","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH 36 NB 558 MP","county_code_state":"TX","county_code":"051","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ALEXANDER","shipping_paper_number":"123386","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-07-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"34000","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":"9040224","transaction_code":"C","transaction_date":"2023-08-07 00:00:00","upload_date":"2023-08-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00470443","upload_search_indicator":"M","census_search_date":"2023-07-28 21:42:00","snet_input_date":"2023-07-26 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-07-28 21:42:00","insp_carrier_name":"ALEXANDER TRUCKING COMPANY","insp_carrier_street":"2993 TX 123 BYPASS","insp_carrier_city":"SEGUIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78155","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0090478","created_at":"2025-03-17T19:34:32.000000Z","updated_at":"2025-03-17T19:34:32.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3482589,"change_date":"2023-07-11 21:42:00","inspection_id":"79114719","dot_number":"470443","report_state":"TX","report_number":"6MJF9DCKIE","insp_date":"2023-07-06 00:00:00","insp_start_time":"1556","insp_end_time":"1633","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"300  MERCURY","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-07-11 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9025818","transaction_code":"A","transaction_date":"2023-07-11 00:00:00","upload_date":"2023-07-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00470443","upload_search_indicator":"M","census_search_date":"2023-07-11 21:42:00","snet_input_date":"2023-07-06 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-07-11 21:42:00","insp_carrier_name":"ALEXANDER TRUCKING COMPANY","insp_carrier_street":"2993 TX 123 BYPASS","insp_carrier_city":"SEGUIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78155","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0090478","created_at":"2025-03-17T19:32:02.000000Z","updated_at":"2025-03-17T19:32:02.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3460498,"change_date":"2023-07-18 21:43:00","inspection_id":"79089981","dot_number":"470443","report_state":"TX","report_number":"V231063085","insp_date":"2023-07-03 00:00:00","insp_start_time":"1249","insp_end_time":"1329","registration_date":"2023-07-18 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"LAT:30   31' 28.86N","county_code_state":"TX","county_code":"471","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MARATHON PETROL","shipping_paper_number":"38354493","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-07-07 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"6","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9024301","transaction_code":"C","transaction_date":"2023-07-18 00:00:00","upload_date":"2023-07-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00470443","upload_search_indicator":"M","census_search_date":"2023-07-07 21:42:00","snet_input_date":"2023-07-03 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-07-07 21:42:00","insp_carrier_name":"ALEXANDER TRUCKING COMPANY","insp_carrier_street":"2993 TX 123 BYPASS","insp_carrier_city":"SEGUIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78155","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0090478","created_at":"2025-03-17T19:31:38.000000Z","updated_at":"2025-03-17T19:31:38.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3046724,"change_date":"2023-05-15 21:42:00","inspection_id":"78623579","dot_number":"470443","report_state":"TX","report_number":"6KX59DBETJ","insp_date":"2023-05-09 00:00:00","insp_start_time":"0515","insp_end_time":"0535","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0290 IN HARRIS CO. (706-738","county_code_state":"TX","county_code":"201","insp_level_id":"4","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"KENDLE MORGAN","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-05-15 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"0","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8978244","transaction_code":"A","transaction_date":"2023-05-15 00:00:00","upload_date":"2023-05-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00470443","upload_search_indicator":"M","census_search_date":"2023-05-15 21:42:00","snet_input_date":"2023-05-09 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-05-15 21:42:00","insp_carrier_name":"ALEXANDER TRUCKING COMPANY","insp_carrier_street":"2993 TX 123 BYPASS","insp_carrier_city":"SEGUIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78155","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0090478","created_at":"2025-03-17T19:23:22.000000Z","updated_at":"2025-03-17T19:23:22.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2920456,"change_date":"2023-04-28 21:39:00","inspection_id":"78480993","dot_number":"470443","report_state":"TX","report_number":"6KK70ALLG8","insp_date":"2023-04-26 00:00:00","insp_start_time":"0650","insp_end_time":"0755","registration_date":null,"region":"CT","ci_status_code":"C","location":"6A202","location_desc":"IH 35 NORTHBOUND DEVINE","county_code_state":"TX","county_code":"325","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"BIG'S 304-TX","shipping_paper_number":"0021007","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-04-28 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"116350","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":"1","hazmat_oos_total":"0","snet_sequence_id":"8966204","transaction_code":"A","transaction_date":"2023-04-28 00:00:00","upload_date":"2023-04-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00470443","upload_search_indicator":"M","census_search_date":"2023-04-28 21:39:00","snet_input_date":"2023-04-26 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-04-28 21:39:00","insp_carrier_name":"ALEXANDER TRUCKING COMPANY","insp_carrier_street":"2993 TX 123 BYPASS","insp_carrier_city":"SEGUIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78155","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0090478","created_at":"2025-03-17T19:20:52.000000Z","updated_at":"2025-03-17T19:20:52.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2902078,"change_date":"2023-04-26 21:42:00","inspection_id":"78460147","dot_number":"470443","report_state":"TX","report_number":"6KJ60ALLG5","insp_date":"2023-04-25 00:00:00","insp_start_time":"0558","insp_end_time":"0653","registration_date":null,"region":"CT","ci_status_code":"C","location":"6A202","location_desc":"IH 35 NORTHBOUND DEVINE","county_code_state":"TX","county_code":"325","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"VALERO","shipping_paper_number":"0020772","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-04-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"116350","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":"8964740","transaction_code":"A","transaction_date":"2023-04-26 00:00:00","upload_date":"2023-04-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00470443","upload_search_indicator":"M","census_search_date":"2023-04-26 21:42:00","snet_input_date":"2023-04-25 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-04-26 21:42:00","insp_carrier_name":"ALEXANDER TRUCKING COMPANY","insp_carrier_street":"2993 TX 123 BYPASS","insp_carrier_city":"SEGUIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78155","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0090478","created_at":"2025-03-17T19:20:24.000000Z","updated_at":"2025-03-17T19:20:24.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2536345,"change_date":"2023-03-08 21:41:00","inspection_id":"78044030","dot_number":"470443","report_state":"TX","report_number":"6J390AQS2C","insp_date":"2023-03-04 00:00:00","insp_start_time":"0917","insp_end_time":"0945","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0036 IN WASHINGTON CO. (560","county_code_state":"TX","county_code":"477","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ALEXANDER OIL","shipping_paper_number":"0000552452","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","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":"8924101","transaction_code":"A","transaction_date":"2023-03-08 00:00:00","upload_date":"2023-03-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00470443","upload_search_indicator":"M","census_search_date":"2023-03-08 21:41:00","snet_input_date":"2023-03-04 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-03-08 21:41:00","insp_carrier_name":"ALEXANDER TRUCKING COMPANY","insp_carrier_street":"2993 TX 123 BYPASS","insp_carrier_city":"SEGUIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78155","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0090478","created_at":"2025-03-17T19:13:22.000000Z","updated_at":"2025-03-17T19:13:22.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2517003,"change_date":"2023-03-06 21:41:00","inspection_id":"78022176","dot_number":"470443","report_state":"TX","report_number":"6IZJ9DGTRA","insp_date":"2023-02-28 00:00:00","insp_start_time":"1906","insp_end_time":"2001","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"5400  MESA DR","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-03-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8921134","transaction_code":"A","transaction_date":"2023-03-06 00:00:00","upload_date":"2023-03-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00470443","upload_search_indicator":"M","census_search_date":"2023-03-06 21:41:00","snet_input_date":"2023-03-01 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-03-06 21:41:00","insp_carrier_name":"ALEXANDER TRUCKING COMPANY","insp_carrier_street":"2993 TX 123 BYPASS","insp_carrier_city":"SEGUIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78155","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0090478","created_at":"2025-03-17T19:12:58.000000Z","updated_at":"2025-03-17T19:12:58.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2426166,"change_date":"2023-02-22 21:40:00","inspection_id":"77919096","dot_number":"470443","report_state":"TX","report_number":"6ISA0AQS1L","insp_date":"2023-02-21 00:00:00","insp_start_time":"0951","insp_end_time":"1024","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0290 IN WASHINGTON CO. (656","county_code_state":"TX","county_code":"477","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"KINDER MORGAN","shipping_paper_number":"3773629","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8911904","transaction_code":"A","transaction_date":"2023-02-22 00:00:00","upload_date":"2023-02-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00470443","upload_search_indicator":"M","census_search_date":"2023-02-22 21:40:00","snet_input_date":"2023-02-21 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-02-22 21:40:00","insp_carrier_name":"ALEXANDER TRUCKING COMPANY","insp_carrier_street":"2993 TX 123 BYPASS","insp_carrier_city":"SEGUIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78155","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0090478","created_at":"2025-03-17T19:11:25.000000Z","updated_at":"2025-03-17T19:11:25.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2516613,"change_date":"2023-03-06 21:41:00","inspection_id":"78021717","dot_number":"470443","report_state":"TX","report_number":"6IS70XSVEI","insp_date":"2023-02-21 00:00:00","insp_start_time":"0729","insp_end_time":"0813","registration_date":null,"region":"CT","ci_status_code":"C","location":"6A202","location_desc":"IH 35 NORTHBOUND DEVINE","county_code_state":"TX","county_code":"325","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"NUSTAR","shipping_paper_number":"0012773","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117200","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":"8920640","transaction_code":"A","transaction_date":"2023-03-06 00:00:00","upload_date":"2023-03-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00470443","upload_search_indicator":"M","census_search_date":"2023-03-06 21:41:00","snet_input_date":"2023-02-21 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-03-06 21:41:00","insp_carrier_name":"ALEXANDER TRUCKING COMPANY","insp_carrier_street":"2993 TX 123 BYPASS","insp_carrier_city":"SEGUIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78155","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0090478","created_at":"2025-03-17T19:12:58.000000Z","updated_at":"2025-03-17T19:12:58.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2276345,"change_date":"2023-02-01 21:41:00","inspection_id":"77747983","dot_number":"470443","report_state":"TX","report_number":"6I350AKMF5","insp_date":"2023-01-27 00:00:00","insp_start_time":"0526","insp_end_time":"0630","registration_date":null,"region":"CT","ci_status_code":"C","location":"6A201","location_desc":"IH 35 SOUTHBOUND DEVINE","county_code_state":"TX","county_code":"325","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"NUSTAR LOGISTICS-SAN ANTONIO","shipping_paper_number":"0010459","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-01 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117200","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":"8895053","transaction_code":"A","transaction_date":"2023-02-01 00:00:00","upload_date":"2023-02-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00470443","upload_search_indicator":"M","census_search_date":"2023-02-01 21:41:00","snet_input_date":"2023-01-27 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-02-01 21:41:00","insp_carrier_name":"ALEXANDER TRUCKING COMPANY","insp_carrier_street":"2993 TX 123 BYPASS","insp_carrier_city":"SEGUIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78155","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0090478","created_at":"2025-03-17T19:08:32.000000Z","updated_at":"2025-03-17T19:08:32.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2258869,"change_date":"2023-01-30 21:44:00","inspection_id":"77728230","dot_number":"470443","report_state":"TX","report_number":"6I2A0XMHKC","insp_date":"2023-01-26 00:00:00","insp_start_time":"1015","insp_end_time":"1035","registration_date":null,"region":"CT","ci_status_code":"C","location":"2D001","location_desc":"SH 288 NB ANGLETON","county_code_state":"TX","county_code":"039","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"XX","shipping_paper_number":"3762070","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-30 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8891584","transaction_code":"A","transaction_date":"2023-01-30 00:00:00","upload_date":"2023-01-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00470443","upload_search_indicator":"M","census_search_date":"2023-01-30 21:44:00","snet_input_date":"2023-01-26 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-01-30 21:44:00","insp_carrier_name":"ALEXANDER TRUCKING COMPANY","insp_carrier_street":"2993 TX 123 BYPASS","insp_carrier_city":"SEGUIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78155","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0090478","created_at":"2025-03-17T19:08:10.000000Z","updated_at":"2025-03-17T19:08:10.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":1872463,"change_date":"2022-12-05 21:40:00","inspection_id":"77286177","dot_number":"470443","report_state":"TX","report_number":"6GG79DBH3K","insp_date":"2022-11-29 00:00:00","insp_start_time":"0730","insp_end_time":"0832","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0290 IN HARRIS CO. (706-738","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"KINDER MORGAN","shipping_paper_number":"50016010","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2022-12-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","viol_total":"10","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"10","vehicle_oos_total":"1","hazmat_viol_total":"1","hazmat_oos_total":"0","snet_sequence_id":"8841849","transaction_code":"A","transaction_date":"2022-12-05 00:00:00","upload_date":"2022-12-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00470443","upload_search_indicator":"M","census_search_date":"2022-12-05 21:40:00","snet_input_date":"2022-11-29 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-12-05 21:40:00","insp_carrier_name":"ALEXANDER TRUCKING COMPANY","insp_carrier_street":"2993 TX 123 BYPASS","insp_carrier_city":"SEGUIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78155","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0090478","created_at":"2025-03-17T19:01:07.000000Z","updated_at":"2025-03-17T19:01:07.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":1520104,"change_date":"2022-10-14 21:39:00","inspection_id":"76881934","dot_number":"470443","report_state":"TX","report_number":"6EYE9DAZX1","insp_date":"2022-10-06 00:00:00","insp_start_time":"1405","insp_end_time":"1445","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0290 IN HARRIS CO. (706-738","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"0001733029","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2022-10-14 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"5","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8800699","transaction_code":"A","transaction_date":"2022-10-14 00:00:00","upload_date":"2022-10-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00470443","upload_search_indicator":"M","census_search_date":"2022-10-14 21:39:00","snet_input_date":"2022-10-06 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-10-14 21:39:00","insp_carrier_name":"ALEXANDER TRUCKING COMPANY","insp_carrier_street":"2993 TX 123 BYPASS","insp_carrier_city":"SEGUIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78155","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0090478","created_at":"2025-03-17T18:54:47.000000Z","updated_at":"2025-03-17T18:54:47.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":1461645,"change_date":"2022-10-06 21:40:00","inspection_id":"76814285","dot_number":"470443","report_state":"TX","report_number":"6EVD0ADZXR","insp_date":"2022-10-03 00:00:00","insp_start_time":"1330","insp_end_time":"1347","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM-0060 IN BURLESON CO. (594-6","county_code_state":"TX","county_code":"051","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-10-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","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":"8792745","transaction_code":"A","transaction_date":"2022-10-06 00:00:00","upload_date":"2022-10-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00470443","upload_search_indicator":"M","census_search_date":"2022-10-06 21:40:00","snet_input_date":"2022-10-03 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-10-06 21:40:00","insp_carrier_name":"ALEXANDER TRUCKING COMPANY","insp_carrier_street":"2993 TX 123 BYPASS","insp_carrier_city":"SEGUIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78155","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0090478","created_at":"2025-03-17T18:53:44.000000Z","updated_at":"2025-03-17T18:53:44.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":1338973,"change_date":"2022-09-21 21:39:00","inspection_id":"76671908","dot_number":"470443","report_state":"TX","report_number":"6E389DBZ5Z","insp_date":"2022-09-05 00:00:00","insp_start_time":"0829","insp_end_time":"0851","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"500  E LOOP N","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MARATHON PETROL","shipping_paper_number":"3702975","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2022-09-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8778007","transaction_code":"A","transaction_date":"2022-09-21 00:00:00","upload_date":"2022-09-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00470443","upload_search_indicator":"M","census_search_date":"2022-09-21 21:39:00","snet_input_date":"2022-09-05 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-09-21 21:39:00","insp_carrier_name":"ALEXANDER TRUCKING COMPANY","insp_carrier_street":"2993 TX 123 BYPASS","insp_carrier_city":"SEGUIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78155","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0090478","created_at":"2025-03-17T18:51:17.000000Z","updated_at":"2025-03-17T18:51:17.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":1150808,"change_date":"2022-08-26 21:41:00","inspection_id":"76453605","dot_number":"470443","report_state":"TX","report_number":"6DS60AKRCA","insp_date":"2022-08-25 00:00:00","insp_start_time":"0555","insp_end_time":"0645","registration_date":null,"region":"CT","ci_status_code":"C","location":"6A202","location_desc":"IH 35 NORTHBOUND DEVINE","county_code_state":"TX","county_code":"325","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ALEXANDER TRUCKING COMPANY","shipping_paper_number":"NONE","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-26 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117200","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":"8755664","transaction_code":"A","transaction_date":"2022-08-26 00:00:00","upload_date":"2022-08-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00470443","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-08-25 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-08-26 21:41:00","insp_carrier_name":"ALEXANDER TRUCKING COMPANY","insp_carrier_street":"2993 TX 123 BYPASS","insp_carrier_city":"SEGUIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78155","insp_colonia":null,"docket_number":"485994","insp_interstate":"N","insp_carrier_state_id":"0090478","created_at":"2025-03-17T18:47:55.000000Z","updated_at":"2025-03-17T18:47:55.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":1028530,"change_date":"2022-08-12 21:40:00","inspection_id":"76310756","dot_number":"470443","report_state":"TX","report_number":"6DEB0AKNOU","insp_date":"2022-08-11 00:00:00","insp_start_time":"1124","insp_end_time":"1205","registration_date":null,"region":"CT","ci_status_code":"C","location":"6A201","location_desc":"IH 35 SOUTHBOUND DEVINE","county_code_state":"TX","county_code":"325","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SAN ANTONIO REFINERY","shipping_paper_number":"0292048","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117200","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":"8741640","transaction_code":"A","transaction_date":"2022-08-12 00:00:00","upload_date":"2022-08-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00470443","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-08-11 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-08-12 21:40:00","insp_carrier_name":"ALEXANDER TRUCKING COMPANY","insp_carrier_street":"2993 TX 123 BYPASS","insp_carrier_city":"SEGUIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78155","insp_colonia":null,"docket_number":"485994","insp_interstate":"N","insp_carrier_state_id":"0090478","created_at":"2025-03-17T18:45:48.000000Z","updated_at":"2025-03-17T18:45:48.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":1047765,"change_date":"2022-08-16 21:39:00","inspection_id":"76333048","dot_number":"470443","report_state":"TX","report_number":"6DC59DGQ21","insp_date":"2022-08-09 00:00:00","insp_start_time":"0503","insp_end_time":"0528","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"4700  NORTH FWY","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"KINDER MORGAN","shipping_paper_number":"3691139","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2022-08-16 21:39: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":"8743544","transaction_code":"A","transaction_date":"2022-08-16 00:00:00","upload_date":"2022-08-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00470443","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-08-09 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-08-16 21:39:00","insp_carrier_name":"ALEXANDER TRUCKING COMPANY","insp_carrier_street":"2993 TX 123 BYPASS","insp_carrier_city":"SEGUIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78155","insp_colonia":null,"docket_number":"485994","insp_interstate":"N","insp_carrier_state_id":"0090478","created_at":"2025-03-17T18:46:10.000000Z","updated_at":"2025-03-17T18:46:10.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":1065982,"change_date":"2022-08-17 21:40:00","inspection_id":"76354712","dot_number":"470443","report_state":"TX","report_number":"6CO59DGQ0X","insp_date":"2022-07-16 00:00:00","insp_start_time":"0534","insp_end_time":"0552","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"8400  N HOUSTON ROSS","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"KINDER MORGAN","shipping_paper_number":null,"cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2022-08-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120200","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":"8745398","transaction_code":"A","transaction_date":"2022-08-17 00:00:00","upload_date":"2022-08-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00470443","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-07-16 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-08-17 21:40:00","insp_carrier_name":"ALEXANDER TRUCKING COMPANY","insp_carrier_street":"2993 TX 123 BYPASS","insp_carrier_city":"SEGUIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78155","insp_colonia":null,"docket_number":"485994","insp_interstate":"N","insp_carrier_state_id":"0090478","created_at":"2025-03-17T18:46:31.000000Z","updated_at":"2025-03-17T18:46:31.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":1065784,"change_date":"2022-08-17 21:40:00","inspection_id":"76354483","dot_number":"470443","report_state":"TX","report_number":"6CN49DGQ0T","insp_date":"2022-07-15 00:00:00","insp_start_time":"0440","insp_end_time":"0502","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"8900  NORTH FWY","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"KINDER MORGAN","shipping_paper_number":"3678918","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2022-08-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8745390","transaction_code":"A","transaction_date":"2022-08-17 00:00:00","upload_date":"2022-08-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00470443","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-07-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-08-17 21:40:00","insp_carrier_name":"ALEXANDER TRUCKING COMPANY","insp_carrier_street":"2993 TX 123 BYPASS","insp_carrier_city":"SEGUIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78155","insp_colonia":null,"docket_number":"485994","insp_interstate":"N","insp_carrier_state_id":"0090478","created_at":"2025-03-17T18:46:31.000000Z","updated_at":"2025-03-17T18:46:31.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":690355,"change_date":"2022-06-24 21:39:00","inspection_id":"75915117","dot_number":"470443","report_state":"TX","report_number":"6BM49DCNHP","insp_date":"2022-06-08 00:00:00","insp_start_time":"0405","insp_end_time":"0445","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0610 IN HARRIS CO. (0-37)","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ALEXANDER","shipping_paper_number":null,"cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2022-06-24 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"1","hazmat_oos_total":"0","snet_sequence_id":"8694279","transaction_code":"A","transaction_date":"2022-06-24 00:00:00","upload_date":"2022-06-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00470443","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-06-08 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-06-24 21:39:00","insp_carrier_name":"ALEXANDER TRUCKING COMPANY","insp_carrier_street":"2993 TX 123 BYPASS","insp_carrier_city":"SEGUIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78155","insp_colonia":null,"docket_number":"485994","insp_interstate":"N","insp_carrier_state_id":"0090478","created_at":"2025-03-17T18:39:50.000000Z","updated_at":"2025-03-17T18:39:50.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":752677,"change_date":"2022-07-05 21:42:00","inspection_id":"75988558","dot_number":"470443","report_state":"TX","report_number":"6BL49DJWRF","insp_date":"2022-06-07 00:00:00","insp_start_time":"0427","insp_end_time":"0449","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"18100  TOMBALL PKWY","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"KINDER MORGAN","shipping_paper_number":"3659252","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2022-07-05 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8701743","transaction_code":"A","transaction_date":"2022-07-05 00:00:00","upload_date":"2022-07-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00470443","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-06-07 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-07-05 21:42:00","insp_carrier_name":"ALEXANDER TRUCKING COMPANY","insp_carrier_street":"2993 TX 123 BYPASS","insp_carrier_city":"SEGUIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78155","insp_colonia":null,"docket_number":"485994","insp_interstate":"N","insp_carrier_state_id":"0090478","created_at":"2025-03-17T18:40:54.000000Z","updated_at":"2025-03-17T18:40:54.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":609546,"change_date":"2022-06-14 21:43:00","inspection_id":"75819644","dot_number":"470443","report_state":"TX","report_number":"6BH80XSR7B","insp_date":"2022-06-03 00:00:00","insp_start_time":"0754","insp_end_time":"0830","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0019 IN WALKER CO. (422-434","county_code_state":"TX","county_code":"471","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"GLOBAL OIL","shipping_paper_number":"3657485","cargo_tank":"306","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-14 21:43: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":"8679562","transaction_code":"A","transaction_date":"2022-06-14 00:00:00","upload_date":"2022-06-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00470443","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-06-03 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-06-14 21:43:00","insp_carrier_name":"ALEXANDER TRUCKING COMPANY","insp_carrier_street":"2993 TX 123 BYPASS","insp_carrier_city":"SEGUIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78155","insp_colonia":null,"docket_number":"485994","insp_interstate":"N","insp_carrier_state_id":"0090478","created_at":"2025-03-17T18:38:26.000000Z","updated_at":"2025-03-17T18:38:26.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":476033,"change_date":"2022-06-08 21:41:00","inspection_id":"75660837","dot_number":"470443","report_state":"TX","report_number":"6B270XUJTA","insp_date":"2022-05-19 00:00:00","insp_start_time":"0713","insp_end_time":"0744","registration_date":"2022-06-08 00:00:00","region":"CT","ci_status_code":"C","location":"6A202","location_desc":"IH 35 NORTHBOUND DEVINE","county_code_state":"TX","county_code":"325","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"WFS\/BIG'S","shipping_paper_number":"0078578","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-24 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"115351","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":"8664949","transaction_code":"C","transaction_date":"2022-05-24 00:00:00","upload_date":"2022-06-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00470443","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-05-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-05-24 21:44:00","insp_carrier_name":"ALEXANDER TRUCKING COMPANY","insp_carrier_street":"2993 TX 123 BYPASS","insp_carrier_city":"SEGUIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78155","insp_colonia":null,"docket_number":"485994","insp_interstate":"N","insp_carrier_state_id":"0090478","created_at":"2025-03-17T18:36:00.000000Z","updated_at":"2025-03-17T18:36:00.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":270578,"change_date":"2022-04-27 21:40:00","inspection_id":"75415948","dot_number":"470443","report_state":"TX","report_number":"6A9A0XEG2E","insp_date":"2022-04-20 00:00:00","insp_start_time":"1020","insp_end_time":"1044","registration_date":null,"region":"CT","ci_status_code":"C","location":"6A101","location_desc":"IH 10 EASTBOUND KINGSBURY","county_code_state":"TX","county_code":"187","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MUSTANG RIDGE FUELS","shipping_paper_number":"391361","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117200","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":"8636671","transaction_code":"A","transaction_date":"2022-04-27 00:00:00","upload_date":"2022-04-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00470443","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-04-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-04-27 21:40:00","insp_carrier_name":"ALEXANDER TRUCKING COMPANY","insp_carrier_street":"2993 TX 123 BYPASS","insp_carrier_city":"SEGUIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78155","insp_colonia":null,"docket_number":"485994","insp_interstate":"N","insp_carrier_state_id":"0090478","created_at":"2025-03-17T18:32:14.000000Z","updated_at":"2025-03-17T18:32:14.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":181096,"change_date":"2022-05-04 21:42:00","inspection_id":"75309135","dot_number":"470443","report_state":"TX","report_number":"6A2B0WIAXQ","insp_date":"2022-04-13 00:00:00","insp_start_time":"1109","insp_end_time":"1156","registration_date":"2022-05-04 00:00:00","region":"CT","ci_status_code":"C","location":"6A201","location_desc":"IH 35 SOUTHBOUND DEVINE","county_code_state":"TX","county_code":"325","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"NUSTAR","shipping_paper_number":"0072971","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-14 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"117200","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8622556","transaction_code":"C","transaction_date":"2022-04-14 00:00:00","upload_date":"2022-05-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00470443","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-04-13 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-04-14 21:43:00","insp_carrier_name":"ALEXANDER TRUCKING COMPANY","insp_carrier_street":"2993 TX 123 BYPASS","insp_carrier_city":"SEGUIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78155","insp_colonia":null,"docket_number":"485994","insp_interstate":"N","insp_carrier_state_id":"0090478","created_at":"2025-03-17T18:30:49.000000Z","updated_at":"2025-03-17T18:30:49.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":84947,"change_date":"2022-03-31 21:41:00","inspection_id":"75192050","dot_number":"470443","report_state":"TX","report_number":"69GD0VBQ12","insp_date":"2022-03-22 00:00:00","insp_start_time":"1256","insp_end_time":"1328","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0090 IN CALDWELL CO. (688-6","county_code_state":"TX","county_code":"055","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MOTIVA","shipping_paper_number":"928267","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-03-31 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"114351","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":"8606781","transaction_code":"A","transaction_date":"2022-03-31 00:00:00","upload_date":"2022-03-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00470443","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-03-22 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-03-31 21:41:00","insp_carrier_name":"ALEXANDER TRUCKING COMPANY","insp_carrier_street":"2993 TX 123 BYPASS","insp_carrier_city":"SEGUIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78155","insp_colonia":null,"docket_number":"485994","insp_interstate":"N","insp_carrier_state_id":"0090478","created_at":"2025-03-17T18:29:07.000000Z","updated_at":"2025-03-17T18:29:07.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":21689,"change_date":"2022-03-22 21:32:00","inspection_id":"75110361","dot_number":"470443","report_state":"TX","report_number":"69CA0AIT8T","insp_date":"2022-03-18 00:00:00","insp_start_time":"1005","insp_end_time":"1050","registration_date":null,"region":"CT","ci_status_code":"C","location":"6A201","location_desc":"IH 35 SOUTHBOUND DEVINE","county_code_state":"TX","county_code":"325","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MOTIVA","shipping_paper_number":"0000927688","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-03-22 21:32:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","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":"8598954","transaction_code":"A","transaction_date":"2022-03-22 00:00:00","upload_date":"2022-03-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00470443","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-03-18 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-03-22 21:32:00","insp_carrier_name":"ALEXANDER TRUCKING COMPANY","insp_carrier_street":"2993 TX 123 BYPASS","insp_carrier_city":"SEGUIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78155","insp_colonia":null,"docket_number":"485994","insp_interstate":"N","insp_carrier_state_id":"0090478","created_at":"2025-03-17T18:28:03.000000Z","updated_at":"2025-03-17T18:28:03.000000Z","inspection_violations":[],"inspection_per_units":[]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/470443\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/470443\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/470443\/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\/470443\/inspections","per_page":100,"prev_page_url":null,"to":55,"total":55}