{"current_page":1,"data":[{"id":12141352,"change_date":"2026-06-09 21:42:00","inspection_id":"88089720","dot_number":"2634654","report_state":"TX","report_number":"7FW79DBEBQ","insp_date":"2026-05-28 00:00:00","insp_start_time":"0745","insp_end_time":"0830","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":"CAL-TEX","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-06-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"0","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":"9985535","transaction_code":"A","transaction_date":"2026-06-09 00:00:00","upload_date":"2026-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02634654","upload_search_indicator":"M","census_search_date":"2026-06-09 21:42:00","snet_input_date":"2026-05-28 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-06-09 21:42:00","insp_carrier_name":"CAL-TEX EXCAVATION INC","insp_carrier_street":"922 STONE PORCH LANE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77064","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0092716","created_at":"2026-06-12T09:40:09.000000Z","updated_at":"2026-06-20T09:33:24.000000Z","inspection_violations":[{"id":21130961,"change_date":"2026-06-09 21:42:00","inspection_id":"88089720","insp_violation_id":"274798646","seq_no":"1","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"214001925","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-12T09:59:51.000000Z","updated_at":"2026-06-19T09:48:40.000000Z","normalized_code":"3939"},{"id":21130962,"change_date":"2026-06-09 21:42:00","inspection_id":"88089720","insp_violation_id":"274798647","seq_no":"2","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"214001925","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-12T09:59:51.000000Z","updated_at":"2026-06-19T09:48:40.000000Z","normalized_code":"3939"},{"id":21130963,"change_date":"2026-06-09 21:42:00","inspection_id":"88089720","insp_violation_id":"274798648","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"214001925","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-12T09:59:51.000000Z","updated_at":"2026-06-19T09:48:40.000000Z","normalized_code":"39378"},{"id":21130964,"change_date":"2026-06-09 21:42:00","inspection_id":"88089720","insp_violation_id":"274798649","seq_no":"4","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"214001925","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-12T09:59:51.000000Z","updated_at":"2026-06-19T09:48:40.000000Z","normalized_code":"3939"},{"id":21130966,"change_date":"2026-06-09 21:42:00","inspection_id":"88089720","insp_violation_id":"274798651","seq_no":"6","part_no":"393","part_no_section":"55D1","insp_viol_unit":"1","insp_unit_id":"214001925","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-12T09:59:51.000000Z","updated_at":"2026-06-19T09:48:40.000000Z","normalized_code":"39355D1"},{"id":21130965,"change_date":"2026-06-09 21:42:00","inspection_id":"88089720","insp_violation_id":"274798650","seq_no":"5","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"214001925","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-12T09:59:51.000000Z","updated_at":"2026-06-19T09:48:40.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":21093108,"change_date":"2026-06-09 21:42:00","inspection_id":"88089720","insp_unit_id":"214001925","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"9","insp_unit_license":"1N51762","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKDL08X57R183524","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-12T09:16:04.000000Z","updated_at":"2026-06-20T09:05:38.000000Z"}]},{"id":11794175,"change_date":"2026-04-30 21:41:00","inspection_id":"87727003","dot_number":"2634654","report_state":"TX","report_number":"V262290715","insp_date":"2026-04-28 00:00:00","insp_start_time":"0813","insp_end_time":"0836","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"E FM1097 RD AT BUSIN","county_code_state":"TX","county_code":"339","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CAL TEX EXCAVATION","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-04-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"77900","viol_total":"10","oos_total":"6","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"9","vehicle_oos_total":"5","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9938552","transaction_code":"A","transaction_date":"2026-04-30 00:00:00","upload_date":"2026-04-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02634654","upload_search_indicator":"M","census_search_date":"2026-04-30 21:41:00","snet_input_date":"2026-04-28 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-04-30 21:41:00","insp_carrier_name":"CAL-TEX EXCAVATION INC","insp_carrier_street":"922 STONE PORCH LANE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77064","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0092716","created_at":"2026-05-03T09:40:58.000000Z","updated_at":"2026-05-11T09:31:25.000000Z","inspection_violations":[{"id":20508520,"change_date":"2026-04-30 21:41:00","inspection_id":"87727003","insp_violation_id":"273965900","seq_no":"1","part_no":"391","part_no_section":"11B2-Q","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"54","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-03T10:01:58.000000Z","updated_at":"2026-05-11T09:42:29.000000Z","normalized_code":"39111B2Q"},{"id":20508521,"change_date":"2026-04-30 21:41:00","inspection_id":"87727003","insp_violation_id":"273965901","seq_no":"2","part_no":"393","part_no_section":"104A","insp_viol_unit":"2","insp_unit_id":"213318058","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-03T10:01:58.000000Z","updated_at":"2026-05-11T09:42:29.000000Z","normalized_code":"393104A"},{"id":20508522,"change_date":"2026-04-30 21:41:00","inspection_id":"87727003","insp_violation_id":"273965902","seq_no":"3","part_no":"393","part_no_section":"106B","insp_viol_unit":"1","insp_unit_id":"213318057","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-05-03T10:01:58.000000Z","updated_at":"2026-05-11T09:42:29.000000Z","normalized_code":"393106B"},{"id":20508523,"change_date":"2026-04-30 21:41:00","inspection_id":"87727003","insp_violation_id":"273965903","seq_no":"4","part_no":"393","part_no_section":"118","insp_viol_unit":"2","insp_unit_id":"213318058","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-05-03T10:01:58.000000Z","updated_at":"2026-05-11T09:42:29.000000Z","normalized_code":"393118"},{"id":20508524,"change_date":"2026-04-30 21:41:00","inspection_id":"87727003","insp_violation_id":"273965904","seq_no":"5","part_no":"393","part_no_section":"45PC","insp_viol_unit":"2","insp_unit_id":"213318058","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-05-03T10:01:58.000000Z","updated_at":"2026-05-11T09:42:29.000000Z","normalized_code":"39345PC"},{"id":20508525,"change_date":"2026-04-30 21:41:00","inspection_id":"87727003","insp_violation_id":"273965905","seq_no":"6","part_no":"393","part_no_section":"51","insp_viol_unit":"1","insp_unit_id":"213318057","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-05-03T10:01:58.000000Z","updated_at":"2026-05-11T09:42:29.000000Z","normalized_code":"39351"},{"id":20508526,"change_date":"2026-04-30 21:41:00","inspection_id":"87727003","insp_violation_id":"273965906","seq_no":"7","part_no":"393","part_no_section":"55C2","insp_viol_unit":"1","insp_unit_id":"213318057","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-03T10:01:58.000000Z","updated_at":"2026-05-11T09:42:29.000000Z","normalized_code":"39355C2"},{"id":20508527,"change_date":"2026-04-30 21:41:00","inspection_id":"87727003","insp_violation_id":"273965907","seq_no":"8","part_no":"393","part_no_section":"55D3","insp_viol_unit":"2","insp_unit_id":"213318058","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-03T10:01:58.000000Z","updated_at":"2026-05-11T09:42:29.000000Z","normalized_code":"39355D3"},{"id":20508528,"change_date":"2026-04-30 21:41:00","inspection_id":"87727003","insp_violation_id":"273965908","seq_no":"9","part_no":"393","part_no_section":"75A3","insp_viol_unit":"2","insp_unit_id":"213318058","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-05-03T10:01:58.000000Z","updated_at":"2026-05-11T09:42:29.000000Z","normalized_code":"39375A3"},{"id":20508529,"change_date":"2026-04-30 21:41:00","inspection_id":"87727003","insp_violation_id":"273965909","seq_no":"10","part_no":"393","part_no_section":"75C","insp_viol_unit":"2","insp_unit_id":"213318058","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-03T10:01:58.000000Z","updated_at":"2026-05-11T09:42:29.000000Z","normalized_code":"39375C"}],"inspection_per_units":[{"id":20516418,"change_date":"2026-04-30 21:41:00","inspection_id":"87727003","insp_unit_id":"213318057","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"13","insp_unit_license":"1M36616","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD49X5BJ269211","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-03T09:17:58.000000Z","updated_at":"2026-05-11T09:04:00.000000Z"},{"id":20516419,"change_date":"2026-04-30 21:41:00","inspection_id":"87727003","insp_unit_id":"213318058","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"INTT","insp_unit_company":null,"insp_unit_license":"884581K","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1JKDTA200JM016367","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-03T09:17:58.000000Z","updated_at":"2026-05-11T09:04:00.000000Z"}]},{"id":11598804,"change_date":"2026-04-15 21:39:00","inspection_id":"87525623","dot_number":"2634654","report_state":"TX","report_number":"V262290688","insp_date":"2026-04-07 00:00:00","insp_start_time":"0712","insp_end_time":"0757","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"20165  TX105 W","county_code_state":"TX","county_code":"339","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CAL TEX","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-04-08 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"6","oos_total":"2","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9912067","transaction_code":"C","transaction_date":"2026-04-15 00:00:00","upload_date":"2026-04-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02634654","upload_search_indicator":"M","census_search_date":"2026-04-08 21:38:00","snet_input_date":"2026-04-07 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-04-08 21:38:00","insp_carrier_name":"CAL-TEX EXCAVATION INC","insp_carrier_street":"922 STONE PORCH LANE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77064","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0092716","created_at":"2026-04-26T09:30:04.000000Z","updated_at":"2026-04-26T09:30:04.000000Z","inspection_violations":[{"id":20233366,"change_date":"2026-04-15 21:39:00","inspection_id":"87525623","insp_violation_id":"273626473","seq_no":"3","part_no":"393","part_no_section":"75A3","insp_viol_unit":"1","insp_unit_id":"213036151","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-04-26T09:42:06.000000Z","updated_at":"2026-04-26T09:42:06.000000Z","normalized_code":"39375A3"},{"id":20233367,"change_date":"2026-04-15 21:39:00","inspection_id":"87525623","insp_violation_id":"273626474","seq_no":"4","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"213036151","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-26T09:42:06.000000Z","updated_at":"2026-04-26T09:42:06.000000Z","normalized_code":"3939"},{"id":20233368,"change_date":"2026-04-15 21:39:00","inspection_id":"87525623","insp_violation_id":"273626475","seq_no":"5","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"213036151","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-26T09:42:06.000000Z","updated_at":"2026-04-26T09:42:06.000000Z","normalized_code":"3939"},{"id":20233369,"change_date":"2026-04-15 21:39:00","inspection_id":"87525623","insp_violation_id":"273626476","seq_no":"6","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"213036151","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-26T09:42:06.000000Z","updated_at":"2026-04-26T09:42:06.000000Z","normalized_code":"3922RG"},{"id":20233370,"change_date":"2026-04-15 21:39:00","inspection_id":"87525623","insp_violation_id":"273626477","seq_no":"1","part_no":"383","part_no_section":"23A2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-26T09:42:06.000000Z","updated_at":"2026-04-26T09:42:06.000000Z","normalized_code":"38323A2"},{"id":20233371,"change_date":"2026-04-15 21:39:00","inspection_id":"87525623","insp_violation_id":"273626478","seq_no":"2","part_no":"393","part_no_section":"55C2","insp_viol_unit":"1","insp_unit_id":"213036151","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-26T09:42:06.000000Z","updated_at":"2026-04-26T09:42:06.000000Z","normalized_code":"39355C2"}],"inspection_per_units":[{"id":20268818,"change_date":"2026-04-15 21:39:00","inspection_id":"87525623","insp_unit_id":"213036151","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"05","insp_unit_license":"NKK5468","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD48XXDJ345090","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-26T09:02:14.000000Z","updated_at":"2026-04-26T09:02:14.000000Z"}]},{"id":11238783,"change_date":"2026-02-26 21:41:00","inspection_id":"87151382","dot_number":"2634654","report_state":"TX","report_number":"7DA99DFI66","insp_date":"2026-02-23 00:00:00","insp_start_time":"0835","insp_end_time":"1000","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0290 IN TRAVIS CO. (564-606","county_code_state":"TX","county_code":"453","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":"2026-02-26 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"75900","viol_total":"6","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9861819","transaction_code":"A","transaction_date":"2026-02-26 00:00:00","upload_date":"2026-02-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02634654","upload_search_indicator":"M","census_search_date":"2026-02-26 21:41:00","snet_input_date":"2026-02-23 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-02-26 21:41:00","insp_carrier_name":"CAL-TEX EXCAVATION INC","insp_carrier_street":"922 STONE PORCH LANE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77064","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0092716","created_at":"2026-03-01T10:39:03.000000Z","updated_at":"2026-03-09T09:31:54.000000Z","inspection_violations":[{"id":18870420,"change_date":"2026-02-26 21:41:00","inspection_id":"87151382","insp_violation_id":"272060247","seq_no":"1","part_no":"393","part_no_section":"209D","insp_viol_unit":"1","insp_unit_id":"211858055","insp_violation_category_id":"21","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2026-03-01T10:56:49.000000Z","updated_at":"2026-03-09T09:45:29.000000Z","normalized_code":"393209D"},{"id":18870421,"change_date":"2026-02-26 21:41:00","inspection_id":"87151382","insp_violation_id":"272060248","seq_no":"2","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"211858055","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2026-03-01T10:56:49.000000Z","updated_at":"2026-03-09T09:45:29.000000Z","normalized_code":"39375A3TAOL"},{"id":18870422,"change_date":"2026-02-26 21:41:00","inspection_id":"87151382","insp_violation_id":"272060249","seq_no":"3","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"211858055","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-01T10:56:49.000000Z","updated_at":"2026-03-09T09:45:29.000000Z","normalized_code":"39375A3TAOL"},{"id":18870423,"change_date":"2026-02-26 21:41:00","inspection_id":"87151382","insp_violation_id":"272060250","seq_no":"4","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"2","insp_unit_id":"211858056","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2026-03-01T10:56:49.000000Z","updated_at":"2026-03-09T09:45:29.000000Z","normalized_code":"39375A3TAOL"},{"id":18870424,"change_date":"2026-02-26 21:41:00","inspection_id":"87151382","insp_violation_id":"272060251","seq_no":"5","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"211858056","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-01T10:56:49.000000Z","updated_at":"2026-03-09T09:45:29.000000Z","normalized_code":"3922RG"},{"id":18870425,"change_date":"2026-02-26 21:41:00","inspection_id":"87151382","insp_violation_id":"272060252","seq_no":"6","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"211858055","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-01T10:56:49.000000Z","updated_at":"2026-03-09T09:45:29.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":19212244,"change_date":"2026-02-26 21:41:00","inspection_id":"87151382","insp_unit_id":"211858055","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"003","insp_unit_license":"LTR7440","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDB9X8RJ632080","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-01T10:15:45.000000Z","updated_at":"2026-03-09T09:09:45.000000Z"},{"id":19212245,"change_date":"2026-02-26 21:41:00","inspection_id":"87151382","insp_unit_id":"211858056","insp_unit_type_id":"10","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"540809K","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1JKDTA20XKM017303","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-01T10:15:45.000000Z","updated_at":"2026-03-09T09:09:45.000000Z"}]},{"id":11241048,"change_date":"2026-02-26 21:41:00","inspection_id":"87153756","dot_number":"2634654","report_state":"TX","report_number":"V262231148","insp_date":"2026-02-21 00:00:00","insp_start_time":"1648","insp_end_time":"1731","registration_date":null,"region":"CT","ci_status_code":"C","location":"2A403","location_desc":"IH10 WB WINNIE SCALE","county_code_state":"TX","county_code":"071","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"JOB SITE AT 4416 INDIAN VALLEY","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-02-26 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","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":"9863143","transaction_code":"A","transaction_date":"2026-02-26 00:00:00","upload_date":"2026-02-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02634654","upload_search_indicator":"M","census_search_date":"2026-02-26 21:41:00","snet_input_date":"2026-02-21 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-02-26 21:41:00","insp_carrier_name":"CAL-TEX EXCAVATION INC","insp_carrier_street":"922 STONE PORCH LANE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77064","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0092716","created_at":"2026-03-01T10:39:06.000000Z","updated_at":"2026-03-09T09:32:10.000000Z","inspection_violations":[{"id":18878212,"change_date":"2026-02-26 21:41:00","inspection_id":"87153756","insp_violation_id":"272070305","seq_no":"4","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"211862826","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-01T10:57:06.000000Z","updated_at":"2026-03-09T09:46:33.000000Z","normalized_code":"3965B"},{"id":18878213,"change_date":"2026-02-26 21:41:00","inspection_id":"87153756","insp_violation_id":"272070306","seq_no":"3","part_no":"396","part_no_section":"5B-HWSLIW","insp_viol_unit":"1","insp_unit_id":"211862826","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-01T10:57:06.000000Z","updated_at":"2026-03-09T09:46:33.000000Z","normalized_code":"3965BHWSLIW"},{"id":18878214,"change_date":"2026-02-26 21:41:00","inspection_id":"87153756","insp_violation_id":"272070307","seq_no":"1","part_no":"396","part_no_section":"5B-HWSLIW","insp_viol_unit":"1","insp_unit_id":"211862826","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2026-03-01T10:57:06.000000Z","updated_at":"2026-03-09T09:46:33.000000Z","normalized_code":"3965BHWSLIW"},{"id":18878215,"change_date":"2026-02-26 21:41:00","inspection_id":"87153756","insp_violation_id":"272070308","seq_no":"2","part_no":"396","part_no_section":"5B-HWSLIW","insp_viol_unit":"1","insp_unit_id":"211862826","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-01T10:57:06.000000Z","updated_at":"2026-03-09T09:46:33.000000Z","normalized_code":"3965BHWSLIW"}],"inspection_per_units":[{"id":19216162,"change_date":"2026-02-26 21:41:00","inspection_id":"87153756","insp_unit_id":"211862826","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"003","insp_unit_license":"LTR7440","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDB9X8RJ632080","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-01T10:15:48.000000Z","updated_at":"2026-03-09T09:10:08.000000Z"}]},{"id":9851458,"change_date":"2025-10-03 21:40:00","inspection_id":"85953309","dot_number":"2634654","report_state":"TX","report_number":"799A9DJZ40","insp_date":"2025-10-01 00:00:00","insp_start_time":"1024","insp_end_time":"1103","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM-1314 IN MONTGOMERY CO. (430","county_code_state":"TX","county_code":"339","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CAL TEX","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-10-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"7","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9714301","transaction_code":"A","transaction_date":"2025-10-03 00:00:00","upload_date":"2025-10-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02634654","upload_search_indicator":"M","census_search_date":"2025-10-03 21:40:00","snet_input_date":"2025-10-01 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-10-03 21:40:00","insp_carrier_name":"CAL-TEX EXCAVATION INC","insp_carrier_street":"922 STONE PORCH LANE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77064","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0092716","created_at":"2025-10-05T10:02:25.000000Z","updated_at":"2025-10-08T10:01:09.000000Z","inspection_violations":[{"id":16225520,"change_date":"2025-10-03 21:40:00","inspection_id":"85953309","insp_violation_id":"269089148","seq_no":"2","part_no":"393","part_no_section":"47B","insp_viol_unit":"1","insp_unit_id":"209291216","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-10-05T10:18:21.000000Z","updated_at":"2025-10-08T10:17:00.000000Z","normalized_code":"39347B"},{"id":16225521,"change_date":"2025-10-03 21:40:00","inspection_id":"85953309","insp_violation_id":"269089149","seq_no":"3","part_no":"396","part_no_section":"3A1B","insp_viol_unit":"1","insp_unit_id":"209291216","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-05T10:18:21.000000Z","updated_at":"2025-10-08T10:17:00.000000Z","normalized_code":"3963A1B"},{"id":16225522,"change_date":"2025-10-03 21:40:00","inspection_id":"85953309","insp_violation_id":"269089150","seq_no":"4","part_no":"393","part_no_section":"207F","insp_viol_unit":"1","insp_unit_id":"209291216","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-05T10:18:21.000000Z","updated_at":"2025-10-08T10:17:00.000000Z","normalized_code":"393207F"},{"id":16225523,"change_date":"2025-10-03 21:40:00","inspection_id":"85953309","insp_violation_id":"269089151","seq_no":"5","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"209291216","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-05T10:18:21.000000Z","updated_at":"2025-10-08T10:17:00.000000Z","normalized_code":"3965B"},{"id":16225524,"change_date":"2025-10-03 21:40:00","inspection_id":"85953309","insp_violation_id":"269089152","seq_no":"6","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"209291216","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-05T10:18:21.000000Z","updated_at":"2025-10-08T10:17:00.000000Z","normalized_code":"39395A"},{"id":16225525,"change_date":"2025-10-03 21:40:00","inspection_id":"85953309","insp_violation_id":"269089153","seq_no":"7","part_no":"393","part_no_section":"203B","insp_viol_unit":"1","insp_unit_id":"209291216","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-05T10:18:21.000000Z","updated_at":"2025-10-08T10:17:00.000000Z","normalized_code":"393203B"},{"id":16225526,"change_date":"2025-10-03 21:40:00","inspection_id":"85953309","insp_violation_id":"269089154","seq_no":"8","part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"1","insp_unit_id":"209291216","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-10-05T10:18:21.000000Z","updated_at":"2025-10-08T10:17:00.000000Z","normalized_code":"3963A1BOS"}],"inspection_per_units":[{"id":16338003,"change_date":"2025-10-03 21:40:00","inspection_id":"85953309","insp_unit_id":"209291216","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"03","insp_unit_license":"FTG9783","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD69X1RR625516","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-05T09:47:17.000000Z","updated_at":"2025-10-08T09:46:24.000000Z"}]},{"id":9686861,"change_date":"2025-09-15 21:41:00","inspection_id":"85780914","dot_number":"2634654","report_state":"TX","report_number":"78PC9DBE3V","insp_date":"2025-09-11 00:00:00","insp_start_time":"1235","insp_end_time":"1320","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":"CAL TEX","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-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"0","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":"9695473","transaction_code":"A","transaction_date":"2025-09-15 00:00:00","upload_date":"2025-09-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02634654","upload_search_indicator":"M","census_search_date":"2025-09-15 21:41:00","snet_input_date":"2025-09-11 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-09-15 21:41:00","insp_carrier_name":"CAL-TEX EXCAVATION INC","insp_carrier_street":"922 STONE PORCH LANE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77064","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0092716","created_at":"2025-09-18T10:00:40.000000Z","updated_at":"2025-09-18T10:00:40.000000Z","inspection_violations":[{"id":15886365,"change_date":"2025-09-15 21:41:00","inspection_id":"85780914","insp_violation_id":"268706328","seq_no":"1","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"208962810","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:21:01.000000Z","updated_at":"2025-09-18T10:21:01.000000Z","normalized_code":"39360C"},{"id":15886366,"change_date":"2025-09-15 21:41:00","inspection_id":"85780914","insp_violation_id":"268706329","seq_no":"3","part_no":"393","part_no_section":"28","insp_viol_unit":"1","insp_unit_id":"208962810","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:21:01.000000Z","updated_at":"2025-09-18T10:21:01.000000Z","normalized_code":"39328"},{"id":15886367,"change_date":"2025-09-15 21:41:00","inspection_id":"85780914","insp_violation_id":"268706330","seq_no":"4","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"208962810","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:21:01.000000Z","updated_at":"2025-09-18T10:21:01.000000Z","normalized_code":"39347E"},{"id":15886368,"change_date":"2025-09-15 21:41:00","inspection_id":"85780914","insp_violation_id":"268706331","seq_no":"5","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"208962810","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:21:01.000000Z","updated_at":"2025-09-18T10:21:01.000000Z","normalized_code":"3965B"},{"id":15886369,"change_date":"2025-09-15 21:41:00","inspection_id":"85780914","insp_violation_id":"268706332","seq_no":"6","part_no":"393","part_no_section":"209E","insp_viol_unit":"1","insp_unit_id":"208962810","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:21:01.000000Z","updated_at":"2025-09-18T10:21:01.000000Z","normalized_code":"393209E"},{"id":15886370,"change_date":"2025-09-15 21:41:00","inspection_id":"85780914","insp_violation_id":"268706333","seq_no":"7","part_no":"396","part_no_section":"3A1B","insp_viol_unit":"1","insp_unit_id":"208962810","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:21:01.000000Z","updated_at":"2025-09-18T10:21:01.000000Z","normalized_code":"3963A1B"}],"inspection_per_units":[{"id":16033187,"change_date":"2025-09-15 21:41:00","inspection_id":"85780914","insp_unit_id":"208962810","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"1","insp_unit_license":"FTG9783","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD69X1RR625516","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-18T09:45:33.000000Z","updated_at":"2025-09-18T09:45:33.000000Z"}]},{"id":9606113,"change_date":"2025-09-05 21:39:00","inspection_id":"85696235","dot_number":"2634654","report_state":"TX","report_number":"78H99DCH05","insp_date":"2025-09-03 00:00:00","insp_start_time":"0850","insp_end_time":"0920","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0288 IN HARRIS CO. (472-484","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"JOB SITE","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-09-05 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9687756","transaction_code":"A","transaction_date":"2025-09-05 00:00:00","upload_date":"2025-09-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02634654","upload_search_indicator":"M","census_search_date":"2025-09-05 21:39:00","snet_input_date":"2025-09-03 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-09-05 21:39:00","insp_carrier_name":"CAL-TEX EXCAVATION INC","insp_carrier_street":"922 STONE PORCH LANE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77064","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0092716","created_at":"2025-09-10T10:45:49.000000Z","updated_at":"2025-09-10T10:45:49.000000Z","inspection_violations":[{"id":15705472,"change_date":"2025-09-05 21:39:00","inspection_id":"85696235","insp_violation_id":"268494556","seq_no":"2","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"208774786","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-10T10:48:44.000000Z","updated_at":"2025-09-10T10:48:44.000000Z","normalized_code":"3922RG"},{"id":15705473,"change_date":"2025-09-05 21:39:00","inspection_id":"85696235","insp_violation_id":"268494557","seq_no":"3","part_no":"393","part_no_section":"9H","insp_viol_unit":"1","insp_unit_id":"208774786","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-10T10:48:44.000000Z","updated_at":"2025-09-10T10:48:44.000000Z","normalized_code":"3939H"},{"id":15705474,"change_date":"2025-09-05 21:39:00","inspection_id":"85696235","insp_violation_id":"268494558","seq_no":"4","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"208774786","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-10T10:48:44.000000Z","updated_at":"2025-09-10T10:48:44.000000Z","normalized_code":"39395A"},{"id":15705475,"change_date":"2025-09-05 21:39:00","inspection_id":"85696235","insp_violation_id":"268494559","seq_no":"5","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"208774786","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-10T10:48:44.000000Z","updated_at":"2025-09-10T10:48:44.000000Z","normalized_code":"39360C"}],"inspection_per_units":[{"id":15862219,"change_date":"2025-09-05 21:39:00","inspection_id":"85696235","insp_unit_id":"208774786","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"FTG9783","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD69X1RR625516","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-10T09:46:30.000000Z","updated_at":"2025-09-10T09:46:30.000000Z"}]},{"id":9686605,"change_date":"2025-09-15 21:41:00","inspection_id":"85780609","dot_number":"2634654","report_state":"TX","report_number":"77N69DAX0J","insp_date":"2025-08-04 00:00:00","insp_start_time":"0640","insp_end_time":"0745","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0249 IN HARRIS CO. (450-470","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ALL-TEX","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-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"0","viol_total":"13","oos_total":"4","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"12","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9695010","transaction_code":"A","transaction_date":"2025-09-15 00:00:00","upload_date":"2025-09-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02634654","upload_search_indicator":"M","census_search_date":"2025-09-15 21:41:00","snet_input_date":"2025-08-04 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-09-15 21:41:00","insp_carrier_name":"CAL-TEX EXCAVATION INC","insp_carrier_street":"922 STONE PORCH LANE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77064","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0092716","created_at":"2025-09-18T10:00:40.000000Z","updated_at":"2025-09-18T10:00:40.000000Z","inspection_violations":[{"id":15885114,"change_date":"2025-09-15 21:41:00","inspection_id":"85780609","insp_violation_id":"268704543","seq_no":"1","part_no":"383","part_no_section":"23A2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:21:00.000000Z","updated_at":"2025-09-18T10:21:00.000000Z","normalized_code":"38323A2"},{"id":15885115,"change_date":"2025-09-15 21:41:00","inspection_id":"85780609","insp_violation_id":"268704544","seq_no":"2","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"208962337","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:21:00.000000Z","updated_at":"2025-09-18T10:21:00.000000Z","normalized_code":"39021A"},{"id":15885116,"change_date":"2025-09-15 21:41:00","inspection_id":"85780609","insp_violation_id":"268704545","seq_no":"3","part_no":"393","part_no_section":"130","insp_viol_unit":"2","insp_unit_id":"208962338","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-09-18T10:21:00.000000Z","updated_at":"2025-09-18T10:21:00.000000Z","normalized_code":"393130"},{"id":15885117,"change_date":"2025-09-15 21:41:00","inspection_id":"85780609","insp_violation_id":"268704546","seq_no":"4","part_no":"393","part_no_section":"110B","insp_viol_unit":"2","insp_unit_id":"208962338","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-09-18T10:21:00.000000Z","updated_at":"2025-09-18T10:21:00.000000Z","normalized_code":"393110B"},{"id":15885118,"change_date":"2025-09-15 21:41:00","inspection_id":"85780609","insp_violation_id":"268704547","seq_no":"5","part_no":"393","part_no_section":"104B","insp_viol_unit":"2","insp_unit_id":"208962338","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:21:00.000000Z","updated_at":"2025-09-18T10:21:00.000000Z","normalized_code":"393104B"},{"id":15885119,"change_date":"2025-09-15 21:41:00","inspection_id":"85780609","insp_violation_id":"268704548","seq_no":"7","part_no":"393","part_no_section":"11LR","insp_viol_unit":"2","insp_unit_id":"208962338","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:21:00.000000Z","updated_at":"2025-09-18T10:21:00.000000Z","normalized_code":"39311LR"},{"id":15885120,"change_date":"2025-09-15 21:41:00","inspection_id":"85780609","insp_violation_id":"268704549","seq_no":"8","part_no":"393","part_no_section":"11S","insp_viol_unit":"2","insp_unit_id":"208962338","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:21:00.000000Z","updated_at":"2025-09-18T10:21:00.000000Z","normalized_code":"39311S"},{"id":15885121,"change_date":"2025-09-15 21:41:00","inspection_id":"85780609","insp_violation_id":"268704550","seq_no":"9","part_no":"393","part_no_section":"55E","insp_viol_unit":"2","insp_unit_id":"208962338","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:21:00.000000Z","updated_at":"2025-09-18T10:21:00.000000Z","normalized_code":"39355E"},{"id":15885122,"change_date":"2025-09-15 21:41:00","inspection_id":"85780609","insp_violation_id":"268704551","seq_no":"10","part_no":"393","part_no_section":"45B2PC","insp_viol_unit":"2","insp_unit_id":"208962338","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-09-18T10:21:00.000000Z","updated_at":"2025-09-18T10:21:00.000000Z","normalized_code":"39345B2PC"},{"id":15885123,"change_date":"2025-09-15 21:41:00","inspection_id":"85780609","insp_violation_id":"268704552","seq_no":"11","part_no":"393","part_no_section":"84","insp_viol_unit":"2","insp_unit_id":"208962338","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:21:00.000000Z","updated_at":"2025-09-18T10:21:00.000000Z","normalized_code":"39384"},{"id":15885124,"change_date":"2025-09-15 21:41:00","inspection_id":"85780609","insp_violation_id":"268704553","seq_no":"12","part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"1","insp_unit_id":"208962337","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:21:00.000000Z","updated_at":"2025-09-18T10:21:00.000000Z","normalized_code":"39345B2UV"},{"id":15885125,"change_date":"2025-09-15 21:41:00","inspection_id":"85780609","insp_violation_id":"268704554","seq_no":"13","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"208962337","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:21:00.000000Z","updated_at":"2025-09-18T10:21:00.000000Z","normalized_code":"3965B"},{"id":15885126,"change_date":"2025-09-15 21:41:00","inspection_id":"85780609","insp_violation_id":"268704555","seq_no":"14","part_no":"393","part_no_section":"209E","insp_viol_unit":"1","insp_unit_id":"208962337","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:21:00.000000Z","updated_at":"2025-09-18T10:21:00.000000Z","normalized_code":"393209E"}],"inspection_per_units":[{"id":16032810,"change_date":"2025-09-15 21:41:00","inspection_id":"85780609","insp_unit_id":"208962337","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"09","insp_unit_license":"JFC2904","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPCD68X8RD357453","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-18T09:45:33.000000Z","updated_at":"2025-09-18T09:45:33.000000Z"},{"id":16032811,"change_date":"2025-09-15 21:41:00","inspection_id":"85780609","insp_unit_id":"208962338","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MTD","insp_unit_company":null,"insp_unit_license":"958071K","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"17YBP25242B023132","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-18T09:45:33.000000Z","updated_at":"2025-09-18T09:45:33.000000Z"}]},{"id":9226663,"change_date":"2025-07-23 21:42:00","inspection_id":"85297260","dot_number":"2634654","report_state":"TX","report_number":"V251945926","insp_date":"2025-07-21 00:00:00","insp_start_time":"1015","insp_end_time":"1100","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US 290 AT KICKAPOO","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CAL-TEX EXCAVATING","shipping_paper_number":"03","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-07-23 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"68000","viol_total":"7","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9646242","transaction_code":"A","transaction_date":"2025-07-23 00:00:00","upload_date":"2025-07-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02634654","upload_search_indicator":"M","census_search_date":"2025-07-23 21:42:00","snet_input_date":"2025-07-21 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-07-23 21:42:00","insp_carrier_name":"CAL-TEX EXCAVATION INC","insp_carrier_street":"922 STONE PORCH LANE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77064","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0092716","created_at":"2025-07-27T10:41:38.000000Z","updated_at":"2025-07-27T10:41:38.000000Z","inspection_violations":[{"id":14932340,"change_date":"2025-07-23 21:42:00","inspection_id":"85297260","insp_violation_id":"267603273","seq_no":"3","part_no":"393","part_no_section":"79","insp_viol_unit":"1","insp_unit_id":"208038544","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-26T10:43:37.000000Z","updated_at":"2025-07-27T10:43:30.000000Z","normalized_code":"39379"},{"id":14932341,"change_date":"2025-07-23 21:42:00","inspection_id":"85297260","insp_violation_id":"267603274","seq_no":"4","part_no":"393","part_no_section":"9H","insp_viol_unit":"1","insp_unit_id":"208038544","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-26T10:43:37.000000Z","updated_at":"2025-07-27T10:43:30.000000Z","normalized_code":"3939H"},{"id":14932342,"change_date":"2025-07-23 21:42:00","inspection_id":"85297260","insp_violation_id":"267603275","seq_no":"5","part_no":"393","part_no_section":"95B","insp_viol_unit":"1","insp_unit_id":"208038544","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-26T10:43:37.000000Z","updated_at":"2025-07-27T10:43:30.000000Z","normalized_code":"39395B"},{"id":14932343,"change_date":"2025-07-23 21:42:00","inspection_id":"85297260","insp_violation_id":"267603276","seq_no":"6","part_no":"392","part_no_section":"2W","insp_viol_unit":"1","insp_unit_id":"208038544","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-26T10:43:37.000000Z","updated_at":"2025-07-27T10:43:30.000000Z","normalized_code":"3922W"},{"id":14932344,"change_date":"2025-07-23 21:42:00","inspection_id":"85297260","insp_violation_id":"267603277","seq_no":"7","part_no":"392","part_no_section":"2W","insp_viol_unit":"1","insp_unit_id":"208038544","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-26T10:43:37.000000Z","updated_at":"2025-07-27T10:43:30.000000Z","normalized_code":"3922W"},{"id":14932345,"change_date":"2025-07-23 21:42:00","inspection_id":"85297260","insp_violation_id":"267603278","seq_no":"1","part_no":"393","part_no_section":"104C","insp_viol_unit":"1","insp_unit_id":"208038544","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-26T10:43:37.000000Z","updated_at":"2025-07-27T10:43:30.000000Z","normalized_code":"393104C"},{"id":14932346,"change_date":"2025-07-23 21:42:00","inspection_id":"85297260","insp_violation_id":"267603279","seq_no":"2","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"208038544","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-26T10:43:37.000000Z","updated_at":"2025-07-27T10:43:30.000000Z","normalized_code":"39360C"}],"inspection_per_units":[{"id":15180413,"change_date":"2025-07-23 21:42:00","inspection_id":"85297260","insp_unit_id":"208038544","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"03","insp_unit_license":"FTG9783","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD69X1RR625516","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-26T09:46:31.000000Z","updated_at":"2025-07-27T09:46:10.000000Z"}]},{"id":8431469,"change_date":"2025-04-21 21:40:00","inspection_id":"84458092","dot_number":"2634654","report_state":"TX","report_number":"V251801891","insp_date":"2025-04-17 00:00:00","insp_start_time":"1456","insp_end_time":"1525","registration_date":null,"region":"CT","ci_status_code":"C","location":"2A403","location_desc":"IH10 WB WINNIE SCALE","county_code_state":"TX","county_code":"071","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"POOL BUILDER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-04-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9556014","transaction_code":"A","transaction_date":"2025-04-21 00:00:00","upload_date":"2025-04-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02634654","upload_search_indicator":"M","census_search_date":"2025-04-21 21:40:00","snet_input_date":"2025-04-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-04-21 21:40:00","insp_carrier_name":"CAL-TEX EXCAVATION INC","insp_carrier_street":"922 STONE PORCH LANE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77064","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0092716","created_at":"2025-04-24T10:03:14.000000Z","updated_at":"2025-04-26T10:25:09.000000Z","inspection_violations":[{"id":13311640,"change_date":"2025-04-21 21:40:00","inspection_id":"84458092","insp_violation_id":"265745120","seq_no":"1","part_no":"393","part_no_section":"55C1","insp_viol_unit":"1","insp_unit_id":"206418683","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-24T10:28:42.000000Z","updated_at":"2025-04-25T10:44:29.000000Z","normalized_code":"39355C1"}],"inspection_per_units":[{"id":13691678,"change_date":"2025-04-21 21:40:00","inspection_id":"84458092","insp_unit_id":"206418683","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"NKK5468","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD48XXDJ345090","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-24T09:57:48.000000Z","updated_at":"2025-04-25T10:02:04.000000Z"}]},{"id":8431816,"change_date":"2025-04-21 21:40:00","inspection_id":"84458458","dot_number":"2634654","report_state":"TX","report_number":"V251819165","insp_date":"2025-04-17 00:00:00","insp_start_time":"1541","insp_end_time":"1631","registration_date":null,"region":"CT","ci_status_code":"C","location":"2A403","location_desc":"IH10 WB WINNIE SCALE","county_code_state":"TX","county_code":"071","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CUSTOMER JOB","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-04-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"67220","viol_total":"6","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9556023","transaction_code":"A","transaction_date":"2025-04-21 00:00:00","upload_date":"2025-04-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02634654","upload_search_indicator":"M","census_search_date":"2025-04-21 21:40:00","snet_input_date":"2025-04-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-04-21 21:40:00","insp_carrier_name":"CAL-TEX EXCAVATION INC","insp_carrier_street":"922 STONE PORCH LANE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77064","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0092716","created_at":"2025-04-24T10:03:15.000000Z","updated_at":"2025-04-26T10:25:19.000000Z","inspection_violations":[{"id":13312765,"change_date":"2025-04-21 21:40:00","inspection_id":"84458458","insp_violation_id":"265746454","seq_no":"1","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"206419339","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-24T10:29:20.000000Z","updated_at":"2025-04-25T10:45:58.000000Z","normalized_code":"39347E"},{"id":13312766,"change_date":"2025-04-21 21:40:00","inspection_id":"84458458","insp_violation_id":"265746455","seq_no":"2","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"206419339","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-24T10:29:20.000000Z","updated_at":"2025-04-25T10:45:58.000000Z","normalized_code":"39347E"},{"id":13312767,"change_date":"2025-04-21 21:40:00","inspection_id":"84458458","insp_violation_id":"265746456","seq_no":"3","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"206419339","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-24T10:29:20.000000Z","updated_at":"2025-04-25T10:45:58.000000Z","normalized_code":"39347E"},{"id":13312768,"change_date":"2025-04-21 21:40:00","inspection_id":"84458458","insp_violation_id":"265746457","seq_no":"4","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"206419339","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-24T10:29:20.000000Z","updated_at":"2025-04-25T10:45:58.000000Z","normalized_code":"39347E"},{"id":13312769,"change_date":"2025-04-21 21:40:00","inspection_id":"84458458","insp_violation_id":"265746458","seq_no":"5","part_no":"393","part_no_section":"53B","insp_viol_unit":"2","insp_unit_id":"206419339","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-24T10:29:20.000000Z","updated_at":"2025-04-25T10:45:58.000000Z","normalized_code":"39353B"},{"id":13312770,"change_date":"2025-04-21 21:40:00","inspection_id":"84458458","insp_violation_id":"265746459","seq_no":"6","part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"2","insp_unit_id":"206419339","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-04-24T10:29:20.000000Z","updated_at":"2025-04-25T10:45:58.000000Z","normalized_code":"3963A1BOS"}],"inspection_per_units":[{"id":13692250,"change_date":"2025-04-21 21:40:00","inspection_id":"84458458","insp_unit_id":"206419338","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"09","insp_unit_license":"JFC2904","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPCD68X8RD357453","insp_unit_decal":"Y","insp_unit_decal_number":"35106705","created_at":"2025-04-24T09:58:10.000000Z","updated_at":"2025-04-25T10:02:57.000000Z"},{"id":13692251,"change_date":"2025-04-21 21:40:00","inspection_id":"84458458","insp_unit_id":"206419339","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"AMER","insp_unit_company":"T1","insp_unit_license":"958071K","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"17YBP25242B023132","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-24T09:58:10.000000Z","updated_at":"2025-04-25T10:02:57.000000Z"}]},{"id":7740773,"change_date":"2025-01-29 21:41:00","inspection_id":"83731430","dot_number":"2634654","report_state":"TX","report_number":"V251754476","insp_date":"2025-01-23 00:00:00","insp_start_time":"1705","insp_end_time":"1733","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SAM HOUSTON SR NEAR","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CAL TEX EXCAVATION","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-01-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9486454","transaction_code":"A","transaction_date":"2025-01-29 00:00:00","upload_date":"2025-01-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02634654","upload_search_indicator":"M","census_search_date":"2025-01-29 21:41:00","snet_input_date":"2025-01-23 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-01-29 21:41:00","insp_carrier_name":"CAL-TEX EXCAVATION INC","insp_carrier_street":"922 STONE PORCH LANE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77064","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0092716","created_at":"2025-03-17T20:59:05.000000Z","updated_at":"2025-03-17T20:59:05.000000Z","inspection_violations":[{"id":12094776,"change_date":"2025-01-29 21:41:00","inspection_id":"83731430","insp_violation_id":"264241541","seq_no":"1","part_no":"393","part_no_section":"209D","insp_viol_unit":"1","insp_unit_id":"205068550","insp_violation_category_id":"21","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:04:58.000000Z","updated_at":"2025-03-17T22:04:58.000000Z","normalized_code":"393209D"},{"id":12094777,"change_date":"2025-01-29 21:41:00","inspection_id":"83731430","insp_violation_id":"264241542","seq_no":"2","part_no":"396","part_no_section":"5B-HLIW","insp_viol_unit":"1","insp_unit_id":"205068550","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:58.000000Z","updated_at":"2025-03-17T22:04:58.000000Z","normalized_code":"3965BHLIW"}],"inspection_per_units":[{"id":12491715,"change_date":"2025-01-29 21:41:00","inspection_id":"83731430","insp_unit_id":"205068550","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"01","insp_unit_license":"PRN0921","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDD69X3MS561994","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:51.000000Z","updated_at":"2025-03-17T23:52:51.000000Z"}]},{"id":7546030,"change_date":"2025-01-03 21:39:00","inspection_id":"83527025","dot_number":"2634654","report_state":"TX","report_number":"V241522113","insp_date":"2024-12-19 00:00:00","insp_start_time":"1458","insp_end_time":"1623","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"RED CLOUD TRL AT HAR","county_code_state":"TX","county_code":"157","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"DEWALT SAND PIT","shipping_paper_number":"407423","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-01-03 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"58000","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":"9464770","transaction_code":"A","transaction_date":"2025-01-03 00:00:00","upload_date":"2025-01-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02634654","upload_search_indicator":"M","census_search_date":"2025-01-03 21:39:00","snet_input_date":"2024-12-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-01-03 21:39:00","insp_carrier_name":"CAL-TEX EXCAVATION INC","insp_carrier_street":"922 STONE PORCH LANE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77064","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0092716","created_at":"2025-03-17T20:54:53.000000Z","updated_at":"2025-03-17T20:54:53.000000Z","inspection_violations":[{"id":11793395,"change_date":"2025-01-03 21:39:00","inspection_id":"83527025","insp_violation_id":"263750563","seq_no":"1","part_no":"393","part_no_section":"209E","insp_viol_unit":"1","insp_unit_id":"204647118","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:27.000000Z","updated_at":"2025-03-17T22:03:27.000000Z","normalized_code":"393209E"},{"id":11793396,"change_date":"2025-01-03 21:39:00","inspection_id":"83527025","insp_violation_id":"263750564","seq_no":"2","part_no":"393","part_no_section":"83G","insp_viol_unit":"1","insp_unit_id":"204647118","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:27.000000Z","updated_at":"2025-03-17T22:03:27.000000Z","normalized_code":"39383G"},{"id":11793397,"change_date":"2025-01-03 21:39:00","inspection_id":"83527025","insp_violation_id":"263750565","seq_no":"3","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"204647118","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:27.000000Z","updated_at":"2025-03-17T22:03:27.000000Z","normalized_code":"3939"},{"id":11793398,"change_date":"2025-01-03 21:39:00","inspection_id":"83527025","insp_violation_id":"263750566","seq_no":"4","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"204647118","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:27.000000Z","updated_at":"2025-03-17T22:03:27.000000Z","normalized_code":"39395A"},{"id":11793399,"change_date":"2025-01-03 21:39:00","inspection_id":"83527025","insp_violation_id":"263750567","seq_no":"5","part_no":"393","part_no_section":"95B","insp_viol_unit":"1","insp_unit_id":"204647118","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:27.000000Z","updated_at":"2025-03-17T22:03:27.000000Z","normalized_code":"39395B"},{"id":11793400,"change_date":"2025-01-03 21:39:00","inspection_id":"83527025","insp_violation_id":"263750568","seq_no":"6","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"204647118","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:27.000000Z","updated_at":"2025-03-17T22:03:27.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":12175034,"change_date":"2025-01-03 21:39:00","inspection_id":"83527025","insp_unit_id":"204647118","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"512","insp_unit_license":"MVP9373","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2XKDDB9XXLM547886","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:26.000000Z","updated_at":"2025-03-17T23:49:26.000000Z"}]},{"id":6771075,"change_date":"2024-09-19 21:42:00","inspection_id":"82707284","dot_number":"2634654","report_state":"TX","report_number":"6YQ79DGPBY","insp_date":"2024-09-17 00:00:00","insp_start_time":"0717","insp_end_time":"0747","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"13500  EAST FWY","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-09-19 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"46000","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":"9381211","transaction_code":"A","transaction_date":"2024-09-19 00:00:00","upload_date":"2024-09-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02634654","upload_search_indicator":"M","census_search_date":"2024-09-19 21:42:00","snet_input_date":"2024-09-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-09-19 21:42:00","insp_carrier_name":"CAL-TEX EXCAVATION INC","insp_carrier_street":"922 STONE PORCH LANE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77064","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0092716","created_at":"2025-03-17T20:37:21.000000Z","updated_at":"2025-03-17T20:37:21.000000Z","inspection_violations":[{"id":10544842,"change_date":"2024-09-19 21:42:00","inspection_id":"82707284","insp_violation_id":"261927603","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"203033307","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:04.000000Z","updated_at":"2025-03-17T21:57:04.000000Z","normalized_code":"39617C"},{"id":10544843,"change_date":"2024-09-19 21:42:00","inspection_id":"82707284","insp_violation_id":"261927604","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"203033307","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:04.000000Z","updated_at":"2025-03-17T21:57:04.000000Z","normalized_code":"3939A"},{"id":10544844,"change_date":"2024-09-19 21:42:00","inspection_id":"82707284","insp_violation_id":"261927605","seq_no":"3","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"203033307","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:04.000000Z","updated_at":"2025-03-17T21:57:04.000000Z","normalized_code":"39311"},{"id":10544845,"change_date":"2024-09-19 21:42:00","inspection_id":"82707284","insp_violation_id":"261927606","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"203033307","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:04.000000Z","updated_at":"2025-03-17T21:57:04.000000Z","normalized_code":"3939A"},{"id":10544846,"change_date":"2024-09-19 21:42:00","inspection_id":"82707284","insp_violation_id":"261927607","seq_no":"5","part_no":"393","part_no_section":"19","insp_viol_unit":"1","insp_unit_id":"203033307","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:04.000000Z","updated_at":"2025-03-17T21:57:04.000000Z","normalized_code":"39319"},{"id":10544847,"change_date":"2024-09-19 21:42:00","inspection_id":"82707284","insp_violation_id":"261927608","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"203033307","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:04.000000Z","updated_at":"2025-03-17T21:57:04.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":10918784,"change_date":"2024-09-19 21:42:00","inspection_id":"82707284","insp_unit_id":"203033307","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"05","insp_unit_license":"NKK5468","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD48XXDJ345090","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:06.000000Z","updated_at":"2025-03-17T23:36:06.000000Z"}]},{"id":5859560,"change_date":"2024-05-28 21:44:00","inspection_id":"81729794","dot_number":"2634654","report_state":"TX","report_number":"V241436593","insp_date":"2024-05-24 00:00:00","insp_start_time":"0704","insp_end_time":"0753","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH 105 MP 678","county_code_state":"TX","county_code":"339","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CAL-TEX EXCAVATION","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-05-28 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"75900","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9286377","transaction_code":"A","transaction_date":"2024-05-28 00:00:00","upload_date":"2024-05-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02634654","upload_search_indicator":"M","census_search_date":"2024-05-28 21:44:00","snet_input_date":"2024-05-24 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-05-28 21:44:00","insp_carrier_name":"CAL-TEX EXCAVATION INC","insp_carrier_street":"922 STONE PORCH LANE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77064","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0092716","created_at":"2025-03-17T20:18:43.000000Z","updated_at":"2025-03-17T20:18:43.000000Z","inspection_violations":[{"id":9084886,"change_date":"2024-05-28 21:44:00","inspection_id":"81729794","insp_violation_id":"259772775","seq_no":"1","part_no":"393","part_no_section":"110(b)","insp_viol_unit":"2","insp_unit_id":"201120699","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:49:55.000000Z","updated_at":"2025-03-17T21:49:55.000000Z","normalized_code":"393110B"},{"id":9084887,"change_date":"2024-05-28 21:44:00","inspection_id":"81729794","insp_violation_id":"259772776","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"201120699","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:55.000000Z","updated_at":"2025-03-17T21:49:55.000000Z","normalized_code":"3939A"},{"id":9084888,"change_date":"2024-05-28 21:44:00","inspection_id":"81729794","insp_violation_id":"259772777","seq_no":"3","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"201120698","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:55.000000Z","updated_at":"2025-03-17T21:49:55.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":9437582,"change_date":"2024-05-28 21:44:00","inspection_id":"81729794","insp_unit_id":"201120698","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"13","insp_unit_license":"1M36616","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD49X5BJ269211","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:55.000000Z","updated_at":"2025-03-17T23:20:55.000000Z"},{"id":9437583,"change_date":"2024-05-28 21:44:00","inspection_id":"81729794","insp_unit_id":"201120699","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"INTE","insp_unit_company":"0","insp_unit_license":"178B337","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1JKDTA20XJM016084","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:55.000000Z","updated_at":"2025-03-17T23:20:55.000000Z"}]},{"id":5011290,"change_date":"2024-02-08 21:43:00","inspection_id":"80805790","dot_number":"2634654","report_state":"TX","report_number":"V241289959","insp_date":"2024-02-06 00:00:00","insp_start_time":"1048","insp_end_time":"1203","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"LAT:29  34'17.59\"N L","county_code_state":"TX","county_code":"157","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"NONE","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-02-08 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"46000","viol_total":"8","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9191871","transaction_code":"A","transaction_date":"2024-02-08 00:00:00","upload_date":"2024-02-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02634654","upload_search_indicator":"M","census_search_date":"2024-02-08 21:43:00","snet_input_date":"2024-02-06 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-02-08 21:43:00","insp_carrier_name":"CAL-TEX EXCAVATION INC","insp_carrier_street":"922 STONE PORCH LANE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77064","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0092716","created_at":"2025-03-17T20:02:02.000000Z","updated_at":"2025-03-17T20:02:02.000000Z","inspection_violations":[{"id":7719816,"change_date":"2024-02-08 21:43:00","inspection_id":"80805790","insp_violation_id":"257744475","seq_no":"1","part_no":"393","part_no_section":"19","insp_viol_unit":"1","insp_unit_id":"199340447","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:16.000000Z","updated_at":"2025-03-17T21:43:16.000000Z","normalized_code":"39319"},{"id":7719817,"change_date":"2024-02-08 21:43:00","inspection_id":"80805790","insp_violation_id":"257744476","seq_no":"2","part_no":"393","part_no_section":"209(d)","insp_viol_unit":"1","insp_unit_id":"199340447","insp_violation_category_id":"21","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:43:16.000000Z","updated_at":"2025-03-17T21:43:16.000000Z","normalized_code":"393209D"},{"id":7719818,"change_date":"2024-02-08 21:43:00","inspection_id":"80805790","insp_violation_id":"257744477","seq_no":"3","part_no":"393","part_no_section":"55(c)(2)","insp_viol_unit":"1","insp_unit_id":"199340447","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:16.000000Z","updated_at":"2025-03-17T21:43:16.000000Z","normalized_code":"39355C2"},{"id":7719819,"change_date":"2024-02-08 21:43:00","inspection_id":"80805790","insp_violation_id":"257744478","seq_no":"4","part_no":"393","part_no_section":"75(a)(4)","insp_viol_unit":"1","insp_unit_id":"199340447","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:16.000000Z","updated_at":"2025-03-17T21:43:16.000000Z","normalized_code":"39375A4"},{"id":7719820,"change_date":"2024-02-08 21:43:00","inspection_id":"80805790","insp_violation_id":"257744479","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199340447","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:16.000000Z","updated_at":"2025-03-17T21:43:16.000000Z","normalized_code":"3939A"},{"id":7719821,"change_date":"2024-02-08 21:43:00","inspection_id":"80805790","insp_violation_id":"257744480","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199340447","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:16.000000Z","updated_at":"2025-03-17T21:43:16.000000Z","normalized_code":"3939A"},{"id":7719822,"change_date":"2024-02-08 21:43:00","inspection_id":"80805790","insp_violation_id":"257744481","seq_no":"7","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"199340447","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:43:16.000000Z","updated_at":"2025-03-17T21:43:16.000000Z","normalized_code":"3963A1"},{"id":7719823,"change_date":"2024-02-08 21:43:00","inspection_id":"80805790","insp_violation_id":"257744482","seq_no":"8","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"199340447","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:16.000000Z","updated_at":"2025-03-17T21:43:16.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":8065902,"change_date":"2024-02-08 21:43:00","inspection_id":"80805790","insp_unit_id":"199340447","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"05","insp_unit_license":"NKK5468","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD48XXDJ345090","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:06.000000Z","updated_at":"2025-03-17T23:08:06.000000Z"}]},{"id":4989770,"change_date":"2024-02-06 21:42:00","inspection_id":"80782147","dot_number":"2634654","report_state":"TX","report_number":"6SB99DAW85","insp_date":"2024-01-30 00:00:00","insp_start_time":"0911","insp_end_time":"0943","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2200 W PARKWOOD AVE","county_code_state":"TX","county_code":"167","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-02-06 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9189222","transaction_code":"A","transaction_date":"2024-02-06 00:00:00","upload_date":"2024-02-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02634654","upload_search_indicator":"M","census_search_date":"2024-02-06 21:42:00","snet_input_date":"2024-01-30 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-02-06 21:42:00","insp_carrier_name":"CAL-TEX EXCAVATION INC","insp_carrier_street":"922 STONE PORCH LANE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77064","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0092716","created_at":"2025-03-17T20:01:38.000000Z","updated_at":"2025-03-17T20:01:38.000000Z","inspection_violations":[{"id":7684863,"change_date":"2024-02-06 21:42:00","inspection_id":"80782147","insp_violation_id":"257693432","seq_no":"1","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"199295424","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:08.000000Z","updated_at":"2025-03-17T21:43:08.000000Z","normalized_code":"39021A"},{"id":7684864,"change_date":"2024-02-06 21:42:00","inspection_id":"80782147","insp_violation_id":"257693433","seq_no":"2","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"199295424","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:08.000000Z","updated_at":"2025-03-17T21:43:08.000000Z","normalized_code":"39395A"},{"id":7684865,"change_date":"2024-02-06 21:42:00","inspection_id":"80782147","insp_violation_id":"257693434","seq_no":"3","part_no":"393","part_no_section":"209(e)","insp_viol_unit":"1","insp_unit_id":"199295424","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:08.000000Z","updated_at":"2025-03-17T21:43:08.000000Z","normalized_code":"393209E"},{"id":7684866,"change_date":"2024-02-06 21:42:00","inspection_id":"80782147","insp_violation_id":"257693435","seq_no":"4","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"199295424","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:08.000000Z","updated_at":"2025-03-17T21:43:08.000000Z","normalized_code":"39347E"}],"inspection_per_units":[{"id":8031003,"change_date":"2024-02-06 21:42:00","inspection_id":"80782147","insp_unit_id":"199295424","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"MVP9373","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2XKDDB9XXLM547886","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:48.000000Z","updated_at":"2025-03-17T23:07:48.000000Z"}]},{"id":3936372,"change_date":"2023-09-08 21:41:00","inspection_id":"79622200","dot_number":"2634654","report_state":"TX","report_number":"6O8H9DCOQS","insp_date":"2023-09-05 00:00:00","insp_start_time":"1716","insp_end_time":"1735","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"6600  MILLPORT ST","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CAL TEX EXCAVATION","shipping_paper_number":"03","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-09-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"8","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9071016","transaction_code":"A","transaction_date":"2023-09-08 00:00:00","upload_date":"2023-09-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02634654","upload_search_indicator":"M","census_search_date":"2023-09-08 21:41:00","snet_input_date":"2023-09-05 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-09-08 21:41:00","insp_carrier_name":"CAL-TEX EXCAVATION INC","insp_carrier_street":"922 STONE PORCH LANE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77064","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0092716","created_at":"2025-03-17T19:40:30.000000Z","updated_at":"2025-03-17T19:40:30.000000Z","inspection_violations":[{"id":6084923,"change_date":"2023-09-08 21:41:00","inspection_id":"79622200","insp_violation_id":"255172285","seq_no":"1","part_no":"393","part_no_section":"51","insp_viol_unit":"1","insp_unit_id":"196973836","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:35:26.000000Z","updated_at":"2025-03-17T21:35:26.000000Z","normalized_code":"39351"},{"id":6084924,"change_date":"2023-09-08 21:41:00","inspection_id":"79622200","insp_violation_id":"255172286","seq_no":"2","part_no":"393","part_no_section":"82","insp_viol_unit":"1","insp_unit_id":"196973836","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:26.000000Z","updated_at":"2025-03-17T21:35:26.000000Z","normalized_code":"39382"},{"id":6084925,"change_date":"2023-09-08 21:41:00","inspection_id":"79622200","insp_violation_id":"255172287","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196973836","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:26.000000Z","updated_at":"2025-03-17T21:35:26.000000Z","normalized_code":"3939A"},{"id":6084926,"change_date":"2023-09-08 21:41:00","inspection_id":"79622200","insp_violation_id":"255172288","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196973836","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:26.000000Z","updated_at":"2025-03-17T21:35:26.000000Z","normalized_code":"3939A"},{"id":6084927,"change_date":"2023-09-08 21:41:00","inspection_id":"79622200","insp_violation_id":"255172289","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196973836","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:35:26.000000Z","updated_at":"2025-03-17T21:35:26.000000Z","normalized_code":"3939A"},{"id":6084928,"change_date":"2023-09-08 21:41:00","inspection_id":"79622200","insp_violation_id":"255172290","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196973836","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:26.000000Z","updated_at":"2025-03-17T21:35:26.000000Z","normalized_code":"3939A"},{"id":6084929,"change_date":"2023-09-08 21:41:00","inspection_id":"79622200","insp_violation_id":"255172291","seq_no":"7","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"196973836","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:35:26.000000Z","updated_at":"2025-03-17T21:35:26.000000Z","normalized_code":"3965B"},{"id":6084930,"change_date":"2023-09-08 21:41:00","inspection_id":"79622200","insp_violation_id":"255172292","seq_no":"8","part_no":"393","part_no_section":"19","insp_viol_unit":"1","insp_unit_id":"196973836","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:26.000000Z","updated_at":"2025-03-17T21:35:26.000000Z","normalized_code":"39319"}],"inspection_per_units":[{"id":6329514,"change_date":"2023-09-08 21:41:00","inspection_id":"79622200","insp_unit_id":"196973836","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"03","insp_unit_license":"LTR7440","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDB9X8RJ632080","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:09.000000Z","updated_at":"2025-03-17T22:53:09.000000Z"}]},{"id":3758603,"change_date":"2023-08-16 21:39:00","inspection_id":"79423603","dot_number":"2634654","report_state":"TX","report_number":"V231094216","insp_date":"2023-08-11 00:00:00","insp_start_time":"0702","insp_end_time":"0735","registration_date":"2023-08-16 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"SH 288 MP 500","county_code_state":"TX","county_code":"039","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CAL TEX EXCAVATION","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-08-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"79900","viol_total":"5","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9054504","transaction_code":"A","transaction_date":"2023-08-16 00:00:00","upload_date":"2023-08-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02634654","upload_search_indicator":"M","census_search_date":"2023-08-16 21:39:00","snet_input_date":"2023-08-11 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-08-16 21:39:00","insp_carrier_name":"CAL-TEX EXCAVATION INC","insp_carrier_street":"922 STONE PORCH LANE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77064","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0092716","created_at":"2025-03-17T19:36:57.000000Z","updated_at":"2025-03-17T19:36:57.000000Z","inspection_violations":[{"id":5796892,"change_date":"2023-08-16 21:39:00","inspection_id":"79423603","insp_violation_id":"254693796","seq_no":"1","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"196566952","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:33:49.000000Z","updated_at":"2025-03-17T21:33:49.000000Z","normalized_code":"39345"},{"id":5796893,"change_date":"2023-08-16 21:39:00","inspection_id":"79423603","insp_violation_id":"254693797","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"196566952","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:49.000000Z","updated_at":"2025-03-17T21:33:49.000000Z","normalized_code":"39378"},{"id":5796894,"change_date":"2023-08-16 21:39:00","inspection_id":"79423603","insp_violation_id":"254693798","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"196566953","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:33:49.000000Z","updated_at":"2025-03-17T21:33:49.000000Z","normalized_code":"3939A"},{"id":5796895,"change_date":"2023-08-16 21:39:00","inspection_id":"79423603","insp_violation_id":"254693799","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196566952","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:49.000000Z","updated_at":"2025-03-17T21:33:49.000000Z","normalized_code":"3939A"},{"id":5796896,"change_date":"2023-08-16 21:39:00","inspection_id":"79423603","insp_violation_id":"254693800","seq_no":"5","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"196566952","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:33:49.000000Z","updated_at":"2025-03-17T21:33:49.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":6043896,"change_date":"2023-08-16 21:39:00","inspection_id":"79423603","insp_unit_id":"196566952","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"T76","insp_unit_license":"1M19163","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDR9X4YR833841","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:47.000000Z","updated_at":"2025-03-17T22:50:47.000000Z"},{"id":6043897,"change_date":"2023-08-16 21:39:00","inspection_id":"79423603","insp_unit_id":"196566953","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"INTE","insp_unit_company":"76T","insp_unit_license":"540809K","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1JKDTA20XKM017303","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:47.000000Z","updated_at":"2025-03-17T22:50:47.000000Z"}]},{"id":3645063,"change_date":"2023-08-01 21:42:00","inspection_id":"79296855","dot_number":"2634654","report_state":"TX","report_number":"6N4A9DCKJY","insp_date":"2023-07-27 00:00:00","insp_start_time":"1030","insp_end_time":"1055","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2300  EDWARDS ST","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"UNK","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-08-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"46000","viol_total":"2","oos_total":"2","driver_viol_total":"2","driver_oos_total":"2","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9041772","transaction_code":"A","transaction_date":"2023-08-01 00:00:00","upload_date":"2023-08-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02634654","upload_search_indicator":"M","census_search_date":"2023-08-01 21:42:00","snet_input_date":"2023-07-27 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-08-01 21:42:00","insp_carrier_name":"CAL-TEX EXCAVATION INC","insp_carrier_street":"922 STONE PORCH LANE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77064","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0092716","created_at":"2025-03-17T19:34:54.000000Z","updated_at":"2025-03-17T19:34:54.000000Z","inspection_violations":[{"id":5620717,"change_date":"2023-08-01 21:42:00","inspection_id":"79296855","insp_violation_id":"254405084","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:05.000000Z","updated_at":"2025-03-17T21:33:05.000000Z","normalized_code":"38323A2"},{"id":5620718,"change_date":"2023-08-01 21:42:00","inspection_id":"79296855","insp_violation_id":"254405085","seq_no":"2","part_no":"391","part_no_section":"11(b)(4)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:05.000000Z","updated_at":"2025-03-17T21:33:05.000000Z","normalized_code":"39111B4"}],"inspection_per_units":[{"id":5861020,"change_date":"2023-08-01 21:42:00","inspection_id":"79296855","insp_unit_id":"196307429","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"JFC2904","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPCD68X8RD357453","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:17.000000Z","updated_at":"2025-03-17T22:49:17.000000Z"}]},{"id":3204299,"change_date":"2023-06-02 21:42:00","inspection_id":"78801271","dot_number":"2634654","report_state":"TX","report_number":"6L769DBEUI","insp_date":"2023-05-19 00:00:00","insp_start_time":"0630","insp_end_time":"0730","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":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-06-02 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"0","viol_total":"8","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8994600","transaction_code":"A","transaction_date":"2023-06-02 00:00:00","upload_date":"2023-06-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02634654","upload_search_indicator":"M","census_search_date":"2023-06-02 21:42:00","snet_input_date":"2023-05-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-06-02 21:42:00","insp_carrier_name":"CAL-TEX EXCAVATION INC","insp_carrier_street":"922 STONE PORCH LANE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77064","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0092716","created_at":"2025-03-17T19:26:27.000000Z","updated_at":"2025-03-17T19:26:27.000000Z","inspection_violations":[{"id":4936805,"change_date":"2023-06-02 21:42:00","inspection_id":"78801271","insp_violation_id":"253246161","seq_no":"1","part_no":"393","part_no_section":"100(a)","insp_viol_unit":"2","insp_unit_id":"195287054","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:29:57.000000Z","updated_at":"2025-03-17T21:29:57.000000Z","normalized_code":"393100A"},{"id":4936806,"change_date":"2023-06-02 21:42:00","inspection_id":"78801271","insp_violation_id":"253246162","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"195287054","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:57.000000Z","updated_at":"2025-03-17T21:29:57.000000Z","normalized_code":"3939A"},{"id":4936807,"change_date":"2023-06-02 21:42:00","inspection_id":"78801271","insp_violation_id":"253246163","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"195287054","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:57.000000Z","updated_at":"2025-03-17T21:29:57.000000Z","normalized_code":"3922"},{"id":4936808,"change_date":"2023-06-02 21:42:00","inspection_id":"78801271","insp_violation_id":"253246164","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195287053","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:57.000000Z","updated_at":"2025-03-17T21:29:57.000000Z","normalized_code":"3939A"},{"id":4936809,"change_date":"2023-06-02 21:42:00","inspection_id":"78801271","insp_violation_id":"253246165","seq_no":"5","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"195287053","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:57.000000Z","updated_at":"2025-03-17T21:29:57.000000Z","normalized_code":"3965B"},{"id":4936810,"change_date":"2023-06-02 21:42:00","inspection_id":"78801271","insp_violation_id":"253246166","seq_no":"6","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"195287053","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:57.000000Z","updated_at":"2025-03-17T21:29:57.000000Z","normalized_code":"39345B2"},{"id":4936811,"change_date":"2023-06-02 21:42:00","inspection_id":"78801271","insp_violation_id":"253246167","seq_no":"7","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"195287053","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:29:57.000000Z","updated_at":"2025-03-17T21:29:57.000000Z","normalized_code":"3963A1"},{"id":4936812,"change_date":"2023-06-02 21:42:00","inspection_id":"78801271","insp_violation_id":"253246168","seq_no":"8","part_no":"393","part_no_section":"51","insp_viol_unit":"1","insp_unit_id":"195287053","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:29:57.000000Z","updated_at":"2025-03-17T21:29:57.000000Z","normalized_code":"39351"}],"inspection_per_units":[{"id":5153824,"change_date":"2023-06-02 21:42:00","inspection_id":"78801271","insp_unit_id":"195287053","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"1M19163","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDR9X4YR833841","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:36.000000Z","updated_at":"2025-03-17T22:43:36.000000Z"},{"id":5153825,"change_date":"2023-06-02 21:42:00","inspection_id":"78801271","insp_unit_id":"195287054","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"INTP","insp_unit_company":null,"insp_unit_license":"540809K","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1JKDTA20XKM017303","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:36.000000Z","updated_at":"2025-03-17T22:43:36.000000Z"}]},{"id":2822473,"change_date":"2023-06-02 21:42:00","inspection_id":"78369807","dot_number":"2634654","report_state":"TX","report_number":"V231010794","insp_date":"2023-04-12 00:00:00","insp_start_time":"1009","insp_end_time":"1033","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"RIDGE LAKE DR AT FIS","county_code_state":"TX","county_code":"339","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"GILBERTO PENA","shipping_paper_number":"NULL","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-04-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8956447","transaction_code":"C","transaction_date":"2023-06-02 00:00:00","upload_date":"2023-06-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02634654","upload_search_indicator":"M","census_search_date":"2023-04-17 21:41:00","snet_input_date":"2023-04-12 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-04-17 21:41:00","insp_carrier_name":"CAL-TEX EXCAVATION INC","insp_carrier_street":"922 STONE PORCH LANE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77064","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0092716","created_at":"2025-03-17T19:18:52.000000Z","updated_at":"2025-03-17T19:18:52.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4543133,"change_date":"2023-06-02 21:42:00","inspection_id":"78369807","insp_unit_id":"195296929","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"01","insp_unit_license":"PRN0921","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDD69X3MS561994","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:49.000000Z","updated_at":"2025-03-17T22:38:49.000000Z"}]},{"id":2246344,"change_date":"2023-01-27 21:41:00","inspection_id":"77714101","dot_number":"2634654","report_state":"TX","report_number":"6HV79DAXLG","insp_date":"2023-01-19 00:00:00","insp_start_time":"0645","insp_end_time":"0735","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"20100  CHASEWOOD PAR","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CAL-TEX","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-01-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"0","viol_total":"9","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"9","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8890084","transaction_code":"A","transaction_date":"2023-01-27 00:00:00","upload_date":"2023-01-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02634654","upload_search_indicator":"M","census_search_date":"2023-01-27 21:41:00","snet_input_date":"2023-01-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-01-27 21:41:00","insp_carrier_name":"CAL-TEX EXCAVATION INC","insp_carrier_street":"922 STONE PORCH LANE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77064","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0092716","created_at":"2025-03-17T19:08:06.000000Z","updated_at":"2025-03-17T19:08:06.000000Z","inspection_violations":[{"id":3469749,"change_date":"2023-01-27 21:41:00","inspection_id":"77714101","insp_violation_id":"250827921","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193110191","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:24.000000Z","updated_at":"2025-03-17T21:23:24.000000Z","normalized_code":"3939A"},{"id":3469750,"change_date":"2023-01-27 21:41:00","inspection_id":"77714101","insp_violation_id":"250827922","seq_no":"3","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"193110192","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:24.000000Z","updated_at":"2025-03-17T21:23:24.000000Z","normalized_code":"39355E"},{"id":3469751,"change_date":"2023-01-27 21:41:00","inspection_id":"77714101","insp_violation_id":"250827923","seq_no":"4","part_no":"393","part_no_section":"55(c)(2)","insp_viol_unit":"2","insp_unit_id":"193110192","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:24.000000Z","updated_at":"2025-03-17T21:23:24.000000Z","normalized_code":"39355C2"},{"id":3469752,"change_date":"2023-01-27 21:41:00","inspection_id":"77714101","insp_violation_id":"250827924","seq_no":"5","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"193110192","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:24.000000Z","updated_at":"2025-03-17T21:23:24.000000Z","normalized_code":"39311"},{"id":3469753,"change_date":"2023-01-27 21:41:00","inspection_id":"77714101","insp_violation_id":"250827925","seq_no":"6","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"2","insp_unit_id":"193110192","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:24.000000Z","updated_at":"2025-03-17T21:23:24.000000Z","normalized_code":"3965B"},{"id":3469754,"change_date":"2023-01-27 21:41:00","inspection_id":"77714101","insp_violation_id":"250827926","seq_no":"7","part_no":"393","part_no_section":"110(b)","insp_viol_unit":"2","insp_unit_id":"193110192","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:23:24.000000Z","updated_at":"2025-03-17T21:23:24.000000Z","normalized_code":"393110B"},{"id":3469755,"change_date":"2023-01-27 21:41:00","inspection_id":"77714101","insp_violation_id":"250827927","seq_no":"8","part_no":"393","part_no_section":"209(e)","insp_viol_unit":"1","insp_unit_id":"193110191","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:24.000000Z","updated_at":"2025-03-17T21:23:24.000000Z","normalized_code":"393209E"},{"id":3469756,"change_date":"2023-01-27 21:41:00","inspection_id":"77714101","insp_violation_id":"250827928","seq_no":"9","part_no":"393","part_no_section":"43(a)","insp_viol_unit":"1","insp_unit_id":"193110191","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:23:24.000000Z","updated_at":"2025-03-17T21:23:24.000000Z","normalized_code":"39343A"},{"id":3469757,"change_date":"2023-01-27 21:41:00","inspection_id":"77714101","insp_violation_id":"250827929","seq_no":"10","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193110191","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:24.000000Z","updated_at":"2025-03-17T21:23:24.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3615704,"change_date":"2023-01-27 21:41:00","inspection_id":"77714101","insp_unit_id":"193110191","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"13","insp_unit_license":"1M36616","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD49X5BJ269211","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:56.000000Z","updated_at":"2025-03-17T22:31:56.000000Z"},{"id":3615705,"change_date":"2023-01-27 21:41:00","inspection_id":"77714101","insp_unit_id":"193110192","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"INTT","insp_unit_company":null,"insp_unit_license":"178B337","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1JKDTA20XJM016084","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:56.000000Z","updated_at":"2025-03-17T22:31:56.000000Z"}]},{"id":2720696,"change_date":"2023-04-03 21:40:00","inspection_id":"78254730","dot_number":"2634654","report_state":"TX","report_number":"6HLD9DCODC","insp_date":"2023-01-09 00:00:00","insp_start_time":"1323","insp_end_time":"1345","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"6700  RANKIN RD","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-04-03 21:40: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":"8943100","transaction_code":"A","transaction_date":"2023-04-03 00:00:00","upload_date":"2023-04-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02634654","upload_search_indicator":"M","census_search_date":"2023-04-03 21:40:00","snet_input_date":"2023-01-09 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-04-03 21:40:00","insp_carrier_name":"CAL-TEX EXCAVATION INC","insp_carrier_street":"922 STONE PORCH LANE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77064","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0092716","created_at":"2025-03-17T19:16:55.000000Z","updated_at":"2025-03-17T19:16:55.000000Z","inspection_violations":[{"id":4178940,"change_date":"2023-04-03 21:40:00","inspection_id":"78254730","insp_violation_id":"252018430","seq_no":"1","part_no":"393","part_no_section":"203(a)","insp_viol_unit":"1","insp_unit_id":"194199446","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:32.000000Z","updated_at":"2025-03-17T21:26:32.000000Z","normalized_code":"393203A"},{"id":4178941,"change_date":"2023-04-03 21:40:00","inspection_id":"78254730","insp_violation_id":"252018431","seq_no":"2","part_no":"393","part_no_section":"79","insp_viol_unit":"1","insp_unit_id":"194199446","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:32.000000Z","updated_at":"2025-03-17T21:26:32.000000Z","normalized_code":"39379"},{"id":4178942,"change_date":"2023-04-03 21:40:00","inspection_id":"78254730","insp_violation_id":"252018432","seq_no":"3","part_no":"393","part_no_section":"95(b)","insp_viol_unit":"1","insp_unit_id":"194199446","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:32.000000Z","updated_at":"2025-03-17T21:26:32.000000Z","normalized_code":"39395B"},{"id":4178943,"change_date":"2023-04-03 21:40:00","inspection_id":"78254730","insp_violation_id":"252018433","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"194199446","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:32.000000Z","updated_at":"2025-03-17T21:26:32.000000Z","normalized_code":"3939A"},{"id":4178944,"change_date":"2023-04-03 21:40:00","inspection_id":"78254730","insp_violation_id":"252018434","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"194199447","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:32.000000Z","updated_at":"2025-03-17T21:26:32.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":4379448,"change_date":"2023-04-03 21:40:00","inspection_id":"78254730","insp_unit_id":"194199446","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"KPF7120","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD69X3YJ831417","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:28.000000Z","updated_at":"2025-03-17T22:37:28.000000Z"},{"id":4379449,"change_date":"2023-04-03 21:40:00","inspection_id":"78254730","insp_unit_id":"194199447","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"958071K","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"17YBP25242B023132","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:28.000000Z","updated_at":"2025-03-17T22:37:28.000000Z"}]},{"id":1641610,"change_date":"2022-10-31 21:41:00","inspection_id":"77021562","dot_number":"2634654","report_state":"TX","report_number":"6FJC0AHGTM","insp_date":"2022-10-27 00:00:00","insp_start_time":"1224","insp_end_time":"1243","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM-1314 IN MONTGOMERY CO. (430","county_code_state":"TX","county_code":"339","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CAL-TEX EXCAVATION","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":"N","pen_cen_match":null,"final_status_date":"2022-10-31 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","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":"8815350","transaction_code":"A","transaction_date":"2022-10-31 00:00:00","upload_date":"2022-10-31 00:00:00","upload_first_byte":"0","upload_dot_number":"02634654","upload_search_indicator":"M","census_search_date":"2022-10-31 21:41:00","snet_input_date":"2022-10-27 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-10-31 21:41:00","insp_carrier_name":"CAL-TEX EXCAVATION INC","insp_carrier_street":"922 STONE PORCH LANE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77064","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0092716","created_at":"2025-03-17T18:57:01.000000Z","updated_at":"2025-03-17T18:57:01.000000Z","inspection_violations":[{"id":2576976,"change_date":"2022-10-31 21:41:00","inspection_id":"77021562","insp_violation_id":"249355739","seq_no":"1","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"191735411","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:08.000000Z","updated_at":"2025-03-17T21:19:08.000000Z","normalized_code":"39345D"}],"inspection_per_units":[{"id":2641268,"change_date":"2022-10-31 21:41:00","inspection_id":"77021562","insp_unit_id":"191735411","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"01","insp_unit_license":"PRN0921","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDD69X3MS561994","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:07.000000Z","updated_at":"2025-03-17T22:25:07.000000Z"}]},{"id":1606462,"change_date":"2022-10-26 21:39:00","inspection_id":"76981197","dot_number":"2634654","report_state":"TX","report_number":"6FAE0ZGT6I","insp_date":"2022-10-18 00:00:00","insp_start_time":"1415","insp_end_time":"1438","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"BINION","county_code_state":"TX","county_code":"157","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":"N","pen_cen_match":null,"final_status_date":"2022-10-26 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"5","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8811280","transaction_code":"A","transaction_date":"2022-10-26 00:00:00","upload_date":"2022-10-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02634654","upload_search_indicator":"M","census_search_date":"2022-10-26 21:39:00","snet_input_date":"2022-10-18 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-10-26 21:39:00","insp_carrier_name":"CAL-TEX EXCAVATION INC","insp_carrier_street":"922 STONE PORCH LANE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77064","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0092716","created_at":"2025-03-17T18:56:17.000000Z","updated_at":"2025-03-17T18:56:17.000000Z","inspection_violations":[{"id":2525380,"change_date":"2022-10-26 21:39:00","inspection_id":"76981197","insp_violation_id":"249269033","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"191656066","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:53.000000Z","updated_at":"2025-03-17T21:18:53.000000Z","normalized_code":"39378"},{"id":2525381,"change_date":"2022-10-26 21:39:00","inspection_id":"76981197","insp_violation_id":"249269034","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191656066","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:53.000000Z","updated_at":"2025-03-17T21:18:53.000000Z","normalized_code":"3939A"},{"id":2525382,"change_date":"2022-10-26 21:39:00","inspection_id":"76981197","insp_violation_id":"249269035","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191656066","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:53.000000Z","updated_at":"2025-03-17T21:18:53.000000Z","normalized_code":"3939A"},{"id":2525383,"change_date":"2022-10-26 21:39:00","inspection_id":"76981197","insp_violation_id":"249269036","seq_no":"4","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"191656066","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:53.000000Z","updated_at":"2025-03-17T21:18:53.000000Z","normalized_code":"39345D"},{"id":2525384,"change_date":"2022-10-26 21:39:00","inspection_id":"76981197","insp_violation_id":"249269037","seq_no":"5","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"191656066","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:18:53.000000Z","updated_at":"2025-03-17T21:18:53.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":2585141,"change_date":"2022-10-26 21:39:00","inspection_id":"76981197","insp_unit_id":"191656066","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"KPF7120","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD69X3YJ831417","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:44.000000Z","updated_at":"2025-03-17T22:24:44.000000Z"}]},{"id":1150579,"change_date":"2022-08-31 21:43:00","inspection_id":"76453352","dot_number":"2634654","report_state":"TX","report_number":"6DRE9DJVDF","insp_date":"2022-08-24 00:00:00","insp_start_time":"1403","insp_end_time":"1433","registration_date":"2022-08-30 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"6500  GREENS RD","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2022-08-26 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"72000","viol_total":"8","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8755625","transaction_code":"C","transaction_date":"2022-08-26 00:00:00","upload_date":"2022-08-31 00:00:00","upload_first_byte":"0","upload_dot_number":"02634654","upload_search_indicator":"M","census_search_date":"2022-08-26 21:41:00","snet_input_date":"2022-08-24 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-08-26 21:41:00","insp_carrier_name":"CAL-TEX EXCAVATION INC","insp_carrier_street":"922 STONE PORCH LANE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77064","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0092716","created_at":"2025-03-17T18:47:55.000000Z","updated_at":"2025-03-17T18:47:55.000000Z","inspection_violations":[{"id":1824340,"change_date":"2022-08-31 21:43:00","inspection_id":"76453352","insp_violation_id":"248138568","seq_no":"1","part_no":"393","part_no_section":"51","insp_viol_unit":"1","insp_unit_id":"190656572","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:15:28.000000Z","updated_at":"2025-03-17T21:15:28.000000Z","normalized_code":"39351"},{"id":1824341,"change_date":"2022-08-31 21:43:00","inspection_id":"76453352","insp_violation_id":"248138569","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190656572","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:28.000000Z","updated_at":"2025-03-17T21:15:28.000000Z","normalized_code":"3939A"},{"id":1824342,"change_date":"2022-08-31 21:43:00","inspection_id":"76453352","insp_violation_id":"248138570","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190656572","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:28.000000Z","updated_at":"2025-03-17T21:15:28.000000Z","normalized_code":"3939A"},{"id":1824343,"change_date":"2022-08-31 21:43:00","inspection_id":"76453352","insp_violation_id":"248138571","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190656572","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:28.000000Z","updated_at":"2025-03-17T21:15:28.000000Z","normalized_code":"3939A"},{"id":1824344,"change_date":"2022-08-31 21:43:00","inspection_id":"76453352","insp_violation_id":"248138572","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"190656573","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:28.000000Z","updated_at":"2025-03-17T21:15:28.000000Z","normalized_code":"3939A"},{"id":1824345,"change_date":"2022-08-31 21:43:00","inspection_id":"76453352","insp_violation_id":"248138573","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"190656573","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:15:28.000000Z","updated_at":"2025-03-17T21:15:28.000000Z","normalized_code":"3939A"},{"id":1824346,"change_date":"2022-08-31 21:43:00","inspection_id":"76453352","insp_violation_id":"248138574","seq_no":"8","part_no":"393","part_no_section":"130","insp_viol_unit":"2","insp_unit_id":"190656573","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:15:28.000000Z","updated_at":"2025-03-17T21:15:28.000000Z","normalized_code":"393130"},{"id":1824347,"change_date":"2022-08-31 21:43:00","inspection_id":"76453352","insp_violation_id":"248138575","seq_no":"9","part_no":"393","part_no_section":"104(b)","insp_viol_unit":"2","insp_unit_id":"190656573","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:28.000000Z","updated_at":"2025-03-17T21:15:28.000000Z","normalized_code":"393104B"}],"inspection_per_units":[{"id":1850013,"change_date":"2022-08-31 21:43:00","inspection_id":"76453352","insp_unit_id":"190656572","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"1M19163","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDR9X4YR833841","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:45.000000Z","updated_at":"2025-03-17T22:19:45.000000Z"},{"id":1850014,"change_date":"2022-08-31 21:43:00","inspection_id":"76453352","insp_unit_id":"190656573","insp_unit_type_id":"10","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"540809K","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1JKDTA20XKM017303","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:45.000000Z","updated_at":"2025-03-17T22:19:45.000000Z"}]},{"id":1103493,"change_date":"2022-08-23 21:42:00","inspection_id":"76398488","dot_number":"2634654","report_state":"TX","report_number":"6DJ99DGAIG","insp_date":"2022-08-16 00:00:00","insp_start_time":"0943","insp_end_time":"1032","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM-1266 IN GALVESTON CO. (484-","county_code_state":"TX","county_code":"167","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2022-08-22 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"8749019","transaction_code":"C","transaction_date":"2022-08-23 00:00:00","upload_date":"2022-08-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02634654","upload_search_indicator":"M","census_search_date":"2022-08-22 21:43:00","snet_input_date":"2022-08-16 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-08-22 21:43:00","insp_carrier_name":"CAL-TEX EXCAVATION INC","insp_carrier_street":"922 STONE PORCH LANE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77064","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0092716","created_at":"2025-03-17T18:47:12.000000Z","updated_at":"2025-03-17T18:47:12.000000Z","inspection_violations":[{"id":1738944,"change_date":"2022-08-23 21:42:00","inspection_id":"76398488","insp_violation_id":"247944245","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"190502705","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:04.000000Z","updated_at":"2025-03-17T21:15:04.000000Z","normalized_code":"39395A"},{"id":1738945,"change_date":"2022-08-23 21:42:00","inspection_id":"76398488","insp_violation_id":"247944246","seq_no":"2","part_no":"393","part_no_section":"83(g)","insp_viol_unit":"1","insp_unit_id":"190502705","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:04.000000Z","updated_at":"2025-03-17T21:15:04.000000Z","normalized_code":"39383G"},{"id":1738946,"change_date":"2022-08-23 21:42:00","inspection_id":"76398488","insp_violation_id":"247944247","seq_no":"3","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"190502705","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:04.000000Z","updated_at":"2025-03-17T21:15:04.000000Z","normalized_code":"3965B"},{"id":1738947,"change_date":"2022-08-23 21:42:00","inspection_id":"76398488","insp_violation_id":"247944248","seq_no":"4","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"190502705","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:15:04.000000Z","updated_at":"2025-03-17T21:15:04.000000Z","normalized_code":"39345"}],"inspection_per_units":[{"id":1775244,"change_date":"2022-08-23 21:42:00","inspection_id":"76398488","insp_unit_id":"190502705","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"V-516","insp_unit_license":"FTG9783","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD69X1RR625516","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:13.000000Z","updated_at":"2025-03-17T22:19:13.000000Z"}]},{"id":1048545,"change_date":"2022-08-18 21:40:00","inspection_id":"76333947","dot_number":"2634654","report_state":"TX","report_number":"6DE69DBAMV","insp_date":"2022-08-11 00:00:00","insp_start_time":"0615","insp_end_time":"0630","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0045 IN HARRIS CO. (24-72)","county_code_state":"TX","county_code":"201","insp_level_id":"4","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CAL-TEX EXCAVATION","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2022-08-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8744361","transaction_code":"C","transaction_date":"2022-08-18 00:00:00","upload_date":"2022-08-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02634654","upload_search_indicator":"M","census_search_date":"2022-08-16 21:39:00","snet_input_date":"2022-08-11 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-08-16 21:39:00","insp_carrier_name":"CAL-TEX EXCAVATION INC","insp_carrier_street":"922 STONE PORCH LANE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77064","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0092716","created_at":"2025-03-17T18:46:10.000000Z","updated_at":"2025-03-17T18:46:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1687280,"change_date":"2022-08-18 21:40:00","inspection_id":"76333947","insp_unit_id":"190414240","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"003","insp_unit_license":"LTR7440","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDB9X8RJ632080","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:38.000000Z","updated_at":"2025-03-17T22:18:38.000000Z"}]},{"id":450338,"change_date":"2022-05-20 21:42:00","inspection_id":"75629849","dot_number":"2634654","report_state":"TX","report_number":"6AU70XMNWQ","insp_date":"2022-05-11 00:00:00","insp_start_time":"0655","insp_end_time":"0730","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0288 IN BRAZORIA CO. (486-5","county_code_state":"TX","county_code":"039","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CAL-TEX","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":"N","pen_cen_match":null,"final_status_date":"2022-05-20 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"0","viol_total":"7","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8660771","transaction_code":"A","transaction_date":"2022-05-20 00:00:00","upload_date":"2022-05-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02634654","upload_search_indicator":"M","census_search_date":"2022-05-20 21:42:00","snet_input_date":"2022-05-11 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-05-20 21:42:00","insp_carrier_name":"CAL-TEX EXCAVATION INC","insp_carrier_street":"922 STONE PORCH LANE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77064","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0092716","created_at":"2025-03-17T18:35:38.000000Z","updated_at":"2025-03-17T18:35:38.000000Z","inspection_violations":[{"id":713883,"change_date":"2022-05-20 21:42:00","inspection_id":"75629849","insp_violation_id":"245973678","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"188830838","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:21.000000Z","updated_at":"2025-03-17T21:10:21.000000Z","normalized_code":"3939A"},{"id":713884,"change_date":"2022-05-20 21:42:00","inspection_id":"75629849","insp_violation_id":"245973679","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"188830837","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:21.000000Z","updated_at":"2025-03-17T21:10:21.000000Z","normalized_code":"3939A"},{"id":713885,"change_date":"2022-05-20 21:42:00","inspection_id":"75629849","insp_violation_id":"245973680","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"188830838","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:21.000000Z","updated_at":"2025-03-17T21:10:21.000000Z","normalized_code":"3939A"},{"id":713886,"change_date":"2022-05-20 21:42:00","inspection_id":"75629849","insp_violation_id":"245973681","seq_no":"4","part_no":"393","part_no_section":"104(f)(3)","insp_viol_unit":"2","insp_unit_id":"188830838","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:10:21.000000Z","updated_at":"2025-03-17T21:10:21.000000Z","normalized_code":"393104F3"},{"id":713887,"change_date":"2022-05-20 21:42:00","inspection_id":"75629849","insp_violation_id":"245973682","seq_no":"5","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"188830838","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:10:21.000000Z","updated_at":"2025-03-17T21:10:21.000000Z","normalized_code":"39375A3"},{"id":713888,"change_date":"2022-05-20 21:42:00","inspection_id":"75629849","insp_violation_id":"245973683","seq_no":"6","part_no":"393","part_no_section":"130","insp_viol_unit":"2","insp_unit_id":"188830838","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:10:21.000000Z","updated_at":"2025-03-17T21:10:21.000000Z","normalized_code":"393130"},{"id":713889,"change_date":"2022-05-20 21:42:00","inspection_id":"75629849","insp_violation_id":"245973684","seq_no":"7","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"188830837","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:21.000000Z","updated_at":"2025-03-17T21:10:21.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":726027,"change_date":"2022-05-20 21:42:00","inspection_id":"75629849","insp_unit_id":"188830837","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"9","insp_unit_license":"JFC2904","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPCD68X8RD357453","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:40.000000Z","updated_at":"2025-03-17T22:12:40.000000Z"},{"id":726028,"change_date":"2022-05-20 21:42:00","inspection_id":"75629849","insp_unit_id":"188830838","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"INTE","insp_unit_company":"9T","insp_unit_license":"884581K","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1JKDTA200JM016367","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:40.000000Z","updated_at":"2025-03-17T22:12:40.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2634654\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2634654\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2634654\/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\/2634654\/inspections","per_page":100,"prev_page_url":null,"to":31,"total":31}