{"current_page":1,"data":[{"id":12646793,"change_date":"2026-08-05 21:43:00","inspection_id":"88618714","dot_number":"1953973","report_state":"TX","report_number":"V262520070","insp_date":"2026-08-03 00:00:00","insp_start_time":"0643","insp_end_time":"0703","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"3716 US259 BUS NB","county_code_state":"TX","county_code":"401","insp_level_id":"2","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":"2026-08-05 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"121220","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":"10058153","transaction_code":"A","transaction_date":"2026-08-05 00:00:00","upload_date":"2026-08-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01953973","upload_search_indicator":"M","census_search_date":"2026-08-05 21:43:00","snet_input_date":"2026-08-03 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-08-05 21:43:00","insp_carrier_name":"CROCKETT SAND & GRAVEL INC","insp_carrier_street":"PO BOX 389","insp_carrier_city":"CROCKETT","insp_carrier_state":"TX","insp_carrier_zip_code":"75835","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0004727","created_at":"2026-08-08T09:41:25.000000Z","updated_at":"2026-08-16T09:31:44.000000Z","inspection_violations":[{"id":22017759,"change_date":"2026-08-05 21:43:00","inspection_id":"88618714","insp_violation_id":"275954839","seq_no":"1","part_no":"393","part_no_section":"203A","insp_viol_unit":"1","insp_unit_id":"215005612","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-08T10:01:21.000000Z","updated_at":"2026-08-16T09:43:59.000000Z","normalized_code":"393203A"}],"inspection_per_units":[{"id":21952620,"change_date":"2026-08-05 21:43:00","inspection_id":"88618714","insp_unit_id":"215005612","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"00","insp_unit_license":"1M85428","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1PN4GY7MM008064","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-08T09:19:13.000000Z","updated_at":"2026-08-16T09:04:01.000000Z"},{"id":21952621,"change_date":"2026-08-05 21:43:00","inspection_id":"88618714","insp_unit_id":"215005613","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAV","insp_unit_company":"00","insp_unit_license":"Z05652","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"48XFF3925F1009407","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-08T09:19:13.000000Z","updated_at":"2026-08-16T09:04:01.000000Z"}]},{"id":11889875,"change_date":"2026-05-12 21:40:00","inspection_id":"87827950","dot_number":"1953973","report_state":"TX","report_number":"V262354872","insp_date":"2026-05-08 00:00:00","insp_start_time":"0845","insp_end_time":"0943","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-155","county_code_state":"TX","county_code":"001","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CROCKETT SAND & GRAVEL","shipping_paper_number":"539082","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-05-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","viol_total":"3","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9951979","transaction_code":"A","transaction_date":"2026-05-12 00:00:00","upload_date":"2026-05-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01953973","upload_search_indicator":"M","census_search_date":"2026-05-12 21:40:00","snet_input_date":"2026-05-08 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-05-12 21:40:00","insp_carrier_name":"CROCKETT SAND & GRAVEL INC","insp_carrier_street":"PO BOX 389","insp_carrier_city":"CROCKETT","insp_carrier_state":"TX","insp_carrier_zip_code":"75835","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0004727","created_at":"2026-05-14T12:39:36.000000Z","updated_at":"2026-05-23T09:31:31.000000Z","inspection_violations":[{"id":20680275,"change_date":"2026-05-12 21:40:00","inspection_id":"87827950","insp_violation_id":"274208942","seq_no":"1","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"213512602","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-14T12:59:26.000000Z","updated_at":"2026-05-23T09:45:58.000000Z","normalized_code":"39360C"},{"id":20680276,"change_date":"2026-05-12 21:40:00","inspection_id":"87827950","insp_violation_id":"274208943","seq_no":"2","part_no":"396","part_no_section":"17C","insp_viol_unit":"2","insp_unit_id":"213512603","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-14T12:59:26.000000Z","updated_at":"2026-05-23T09:45:58.000000Z","normalized_code":"39617C"},{"id":20680277,"change_date":"2026-05-12 21:40:00","inspection_id":"87827950","insp_violation_id":"274208944","seq_no":"3","part_no":"392","part_no_section":"2W","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-14T12:59:26.000000Z","updated_at":"2026-05-23T09:45:58.000000Z","normalized_code":"3922W"}],"inspection_per_units":[{"id":20672479,"change_date":"2026-05-12 21:40:00","inspection_id":"87827950","insp_unit_id":"213512603","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRVS","insp_unit_company":"9","insp_unit_license":"Z05642","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"48XFF3921F1010084","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-14T12:01:44.000000Z","updated_at":"2026-05-23T09:04:34.000000Z"},{"id":20672478,"change_date":"2026-05-12 21:40:00","inspection_id":"87827950","insp_unit_id":"213512602","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"1235","insp_unit_license":"1M85419","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2PN4GY5KM001235","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-14T12:01:44.000000Z","updated_at":"2026-05-23T09:04:34.000000Z"}]},{"id":11418429,"change_date":"2026-03-19 21:39:00","inspection_id":"87334186","dot_number":"1953973","report_state":"TX","report_number":"V262236209","insp_date":"2026-03-16 00:00:00","insp_start_time":"0906","insp_end_time":"0916","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"1020 US79 EB","county_code_state":"TX","county_code":"001","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"NONE","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-03-19 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"122320","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":"9889833","transaction_code":"A","transaction_date":"2026-03-19 00:00:00","upload_date":"2026-03-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01953973","upload_search_indicator":"M","census_search_date":"2026-03-19 21:39:00","snet_input_date":"2026-03-16 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-03-19 21:39:00","insp_carrier_name":"CROCKETT SAND & GRAVEL INC","insp_carrier_street":"PO BOX 389","insp_carrier_city":"CROCKETT","insp_carrier_state":"TX","insp_carrier_zip_code":"75835","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0004727","created_at":"2026-03-22T09:50:53.000000Z","updated_at":"2026-03-30T09:32:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19559347,"change_date":"2026-03-19 21:39:00","inspection_id":"87334186","insp_unit_id":"212223093","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"5786","insp_unit_license":"1M92790","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1PN4GY7SM015786","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-22T09:32:32.000000Z","updated_at":"2026-03-30T09:06:46.000000Z"},{"id":19559348,"change_date":"2026-03-19 21:39:00","inspection_id":"87334186","insp_unit_id":"212223094","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":"7102","insp_unit_license":"270C125","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5MADN3820RK077102","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-22T09:32:32.000000Z","updated_at":"2026-03-30T09:06:46.000000Z"}]},{"id":11069433,"change_date":"2026-02-06 21:39:00","inspection_id":"86980014","dot_number":"1953973","report_state":"TX","report_number":"V262183856","insp_date":"2026-02-04 00:00:00","insp_start_time":"0730","insp_end_time":"0800","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"TX315","county_code_state":"TX","county_code":"365","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CROCKETT SAND & GRAVEL","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-06 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"121220","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":"9841366","transaction_code":"A","transaction_date":"2026-02-06 00:00:00","upload_date":"2026-02-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01953973","upload_search_indicator":"M","census_search_date":"2026-02-06 21:39:00","snet_input_date":"2026-02-04 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-02-06 21:39:00","insp_carrier_name":"CROCKETT SAND & GRAVEL INC","insp_carrier_street":"PO BOX 389","insp_carrier_city":"CROCKETT","insp_carrier_state":"TX","insp_carrier_zip_code":"75835","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0004727","created_at":"2026-02-10T10:37:23.000000Z","updated_at":"2026-02-17T10:31:02.000000Z","inspection_violations":[{"id":18526900,"change_date":"2026-02-06 21:39:00","inspection_id":"86980014","insp_violation_id":"271647688","seq_no":"1","part_no":"393","part_no_section":"9T","insp_viol_unit":"1","insp_unit_id":"211490299","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-10T10:50:57.000000Z","updated_at":"2026-02-17T10:39:28.000000Z","normalized_code":"3939T"}],"inspection_per_units":[{"id":18874738,"change_date":"2026-02-06 21:39:00","inspection_id":"86980014","insp_unit_id":"211490299","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"8096","insp_unit_license":"1M85434","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1PN4GY9MM008096","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-09T10:11:33.000000Z","updated_at":"2026-02-17T10:04:16.000000Z"},{"id":18874739,"change_date":"2026-02-06 21:39:00","inspection_id":"86980014","insp_unit_id":"211490300","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRVS","insp_unit_company":"20","insp_unit_license":"Z05651","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"48XFF3927F1009408","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-09T10:11:33.000000Z","updated_at":"2026-02-17T10:04:16.000000Z"}]},{"id":10839091,"change_date":"2026-01-22 21:40:00","inspection_id":"86867497","dot_number":"1953973","report_state":"TX","report_number":"V262190384","insp_date":"2026-01-20 00:00:00","insp_start_time":"1025","insp_end_time":"1041","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"10381  US79 NB","county_code_state":"TX","county_code":"001","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CROCKETT SAND","shipping_paper_number":"534287","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-01-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"121220","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":"9827851","transaction_code":"A","transaction_date":"2026-01-22 00:00:00","upload_date":"2026-01-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01953973","upload_search_indicator":"M","census_search_date":"2026-01-22 21:40:00","snet_input_date":"2026-01-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-01-22 21:40:00","insp_carrier_name":"CROCKETT SAND & GRAVEL INC","insp_carrier_street":"PO BOX 389","insp_carrier_city":"CROCKETT","insp_carrier_state":"TX","insp_carrier_zip_code":"75835","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0004727","created_at":"2026-01-25T10:37:05.000000Z","updated_at":"2026-02-02T10:31:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18210332,"change_date":"2026-01-22 21:40:00","inspection_id":"86867497","insp_unit_id":"211245837","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAV","insp_unit_company":"4455","insp_unit_license":"142C449","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"48XFF3923L1014455","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-25T10:09:23.000000Z","updated_at":"2026-02-02T10:03:36.000000Z"},{"id":18210331,"change_date":"2026-01-22 21:40:00","inspection_id":"86867497","insp_unit_id":"211245836","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"9753","insp_unit_license":"1M92765","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1PN4GY0NM009753","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-25T10:09:23.000000Z","updated_at":"2026-02-02T10:03:36.000000Z"}]},{"id":9809814,"change_date":"2025-09-29 21:39:00","inspection_id":"85909751","dot_number":"1953973","report_state":"TX","report_number":"V252040829","insp_date":"2025-09-26 00:00:00","insp_start_time":"0805","insp_end_time":"0820","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US 175","county_code_state":"TX","county_code":"001","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CROCKETT SAND","shipping_paper_number":"529170","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-29 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9709864","transaction_code":"A","transaction_date":"2025-09-29 00:00:00","upload_date":"2025-09-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01953973","upload_search_indicator":"M","census_search_date":"2025-09-29 21:39:00","snet_input_date":"2025-09-26 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-09-29 21:39:00","insp_carrier_name":"CROCKETT SAND & GRAVEL INC","insp_carrier_street":"PO BOX 389","insp_carrier_city":"CROCKETT","insp_carrier_state":"TX","insp_carrier_zip_code":"75835","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0004727","created_at":"2025-10-02T10:00:25.000000Z","updated_at":"2025-10-03T10:01:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16259891,"change_date":"2025-09-29 21:39:00","inspection_id":"85909751","insp_unit_id":"209207149","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"9749","insp_unit_license":"1M92766","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1PN4GY9NM009749","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-02T09:45:24.000000Z","updated_at":"2025-10-03T09:46:47.000000Z"},{"id":16259892,"change_date":"2025-09-29 21:39:00","inspection_id":"85909751","insp_unit_id":"209207150","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAV","insp_unit_company":"4","insp_unit_license":"Z05615","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"48XFF3922G1010595","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-02T09:45:24.000000Z","updated_at":"2025-10-03T09:46:47.000000Z"}]},{"id":9239723,"change_date":"2025-07-24 21:41:00","inspection_id":"85310902","dot_number":"1953973","report_state":"TX","report_number":"V251906322","insp_date":"2025-07-18 00:00:00","insp_start_time":"0800","insp_end_time":"0830","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US79","county_code_state":"TX","county_code":"001","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"NONE","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-07-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"121220","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":"9647505","transaction_code":"A","transaction_date":"2025-07-24 00:00:00","upload_date":"2025-07-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01953973","upload_search_indicator":"M","census_search_date":"2025-07-24 21:41:00","snet_input_date":"2025-07-18 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-07-24 21:41:00","insp_carrier_name":"CROCKETT SAND & GRAVEL INC","insp_carrier_street":"PO BOX 389","insp_carrier_city":"CROCKETT","insp_carrier_state":"TX","insp_carrier_zip_code":"75835","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0004727","created_at":"2025-07-27T10:41:57.000000Z","updated_at":"2025-07-30T10:00:58.000000Z","inspection_violations":[{"id":14960140,"change_date":"2025-07-24 21:41:00","inspection_id":"85310902","insp_violation_id":"267635060","seq_no":"1","part_no":"393","part_no_section":"205A","insp_viol_unit":"1","insp_unit_id":"208064099","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-07-27T10:44:20.000000Z","updated_at":"2025-07-28T10:49:08.000000Z","normalized_code":"393205A"},{"id":14960141,"change_date":"2025-07-24 21:41:00","inspection_id":"85310902","insp_violation_id":"267635061","seq_no":"2","part_no":"393","part_no_section":"55E","insp_viol_unit":"2","insp_unit_id":"208064100","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-27T10:44:20.000000Z","updated_at":"2025-07-28T10:49:08.000000Z","normalized_code":"39355E"},{"id":14960142,"change_date":"2025-07-24 21:41:00","inspection_id":"85310902","insp_violation_id":"267635062","seq_no":"3","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"208064099","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-27T10:44:20.000000Z","updated_at":"2025-07-28T10:49:08.000000Z","normalized_code":"39360C"}],"inspection_per_units":[{"id":15204154,"change_date":"2025-07-24 21:41:00","inspection_id":"85310902","insp_unit_id":"208064099","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"9749","insp_unit_license":"1M92766","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1PN4GY9NM009749","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-27T09:46:33.000000Z","updated_at":"2025-07-28T09:46:15.000000Z"},{"id":15204155,"change_date":"2025-07-24 21:41:00","inspection_id":"85310902","insp_unit_id":"208064100","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAV","insp_unit_company":"0084","insp_unit_license":"Z05642","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"48XFF3921F1010084","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-27T09:46:33.000000Z","updated_at":"2025-07-28T09:46:15.000000Z"}]},{"id":8940428,"change_date":"2025-06-19 21:37:00","inspection_id":"84995773","dot_number":"1953973","report_state":"TX","report_number":"V251883557","insp_date":"2025-06-18 00:00:00","insp_start_time":"0850","insp_end_time":"0922","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US 59","county_code_state":"TX","county_code":"365","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CROCKETT SAND","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-06-19 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"122320","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":"9612019","transaction_code":"A","transaction_date":"2025-06-19 00:00:00","upload_date":"2025-06-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01953973","upload_search_indicator":"M","census_search_date":"2025-06-19 21:37:00","snet_input_date":"2025-06-18 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-06-19 21:37:00","insp_carrier_name":"CROCKETT SAND & GRAVEL INC","insp_carrier_street":"PO BOX 389","insp_carrier_city":"CROCKETT","insp_carrier_state":"TX","insp_carrier_zip_code":"75835","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0004727","created_at":"2025-06-22T10:01:16.000000Z","updated_at":"2025-06-23T10:00:35.000000Z","inspection_violations":[{"id":14350831,"change_date":"2025-06-19 21:37:00","inspection_id":"84995773","insp_violation_id":"266938849","seq_no":"1","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"207467111","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-22T10:16:52.000000Z","updated_at":"2025-06-23T10:15:56.000000Z","normalized_code":"39347E"},{"id":14350832,"change_date":"2025-06-19 21:37:00","inspection_id":"84995773","insp_violation_id":"266938850","seq_no":"2","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"207467111","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-22T10:16:52.000000Z","updated_at":"2025-06-23T10:15:56.000000Z","normalized_code":"39347E"},{"id":14350833,"change_date":"2025-06-19 21:37:00","inspection_id":"84995773","insp_violation_id":"266938851","seq_no":"3","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"207467111","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-22T10:16:52.000000Z","updated_at":"2025-06-23T10:15:56.000000Z","normalized_code":"39347E"},{"id":14350834,"change_date":"2025-06-19 21:37:00","inspection_id":"84995773","insp_violation_id":"266938852","seq_no":"4","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"207467111","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-22T10:16:52.000000Z","updated_at":"2025-06-23T10:15:56.000000Z","normalized_code":"39353B"},{"id":14350835,"change_date":"2025-06-19 21:37:00","inspection_id":"84995773","insp_violation_id":"266938853","seq_no":"5","part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"1","insp_unit_id":"207467111","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2025-06-22T10:16:52.000000Z","updated_at":"2025-06-23T10:15:56.000000Z","normalized_code":"3963A1BOS"}],"inspection_per_units":[{"id":14652716,"change_date":"2025-06-19 21:37:00","inspection_id":"84995773","insp_unit_id":"207467111","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"9961","insp_unit_license":"1M85407","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AN07Y8FM019961","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-22T09:46:29.000000Z","updated_at":"2025-06-23T09:45:42.000000Z"},{"id":14652717,"change_date":"2025-06-19 21:37:00","inspection_id":"84995773","insp_unit_id":"207467112","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VNTG","insp_unit_company":"5454","insp_unit_license":"096C176","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4E7AA3928GATA5454","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-22T09:46:29.000000Z","updated_at":"2025-06-23T09:45:42.000000Z"}]},{"id":8395305,"change_date":"2025-04-16 21:41:00","inspection_id":"84419877","dot_number":"1953973","report_state":"TX","report_number":"V251825515","insp_date":"2025-04-15 00:00:00","insp_start_time":"0718","insp_end_time":"0805","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US59 SB","county_code_state":"TX","county_code":"365","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CROCKETT SAND & GRAVEL","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-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","viol_total":"7","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9552981","transaction_code":"A","transaction_date":"2025-04-16 00:00:00","upload_date":"2025-04-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01953973","upload_search_indicator":"M","census_search_date":"2025-04-16 21:41:00","snet_input_date":"2025-04-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-04-16 21:41:00","insp_carrier_name":"CROCKETT SAND & GRAVEL INC","insp_carrier_street":"PO BOX 389","insp_carrier_city":"CROCKETT","insp_carrier_state":"TX","insp_carrier_zip_code":"75835","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0004727","created_at":"2025-04-19T10:19:33.000000Z","updated_at":"2025-04-20T10:26:28.000000Z","inspection_violations":[{"id":13241043,"change_date":"2025-04-16 21:41:00","inspection_id":"84419877","insp_violation_id":"265665317","seq_no":"1","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"206349436","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-18T11:19:42.000000Z","updated_at":"2025-04-20T10:49:13.000000Z","normalized_code":"39347E"},{"id":13241044,"change_date":"2025-04-16 21:41:00","inspection_id":"84419877","insp_violation_id":"265665318","seq_no":"2","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"206349436","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-18T11:19:42.000000Z","updated_at":"2025-04-20T10:49:13.000000Z","normalized_code":"39347E"},{"id":13241045,"change_date":"2025-04-16 21:41:00","inspection_id":"84419877","insp_violation_id":"265665319","seq_no":"3","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"206349436","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-18T11:19:42.000000Z","updated_at":"2025-04-20T10:49:13.000000Z","normalized_code":"39347E"},{"id":13241046,"change_date":"2025-04-16 21:41:00","inspection_id":"84419877","insp_violation_id":"265665320","seq_no":"4","part_no":"393","part_no_section":"48A","insp_viol_unit":"1","insp_unit_id":"206349436","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-18T11:19:42.000000Z","updated_at":"2025-04-20T10:49:13.000000Z","normalized_code":"39348A"},{"id":13241047,"change_date":"2025-04-16 21:41:00","inspection_id":"84419877","insp_violation_id":"265665321","seq_no":"5","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"206349436","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-18T11:19:42.000000Z","updated_at":"2025-04-20T10:49:13.000000Z","normalized_code":"39353B"},{"id":13241048,"change_date":"2025-04-16 21:41:00","inspection_id":"84419877","insp_violation_id":"265665322","seq_no":"6","part_no":"396","part_no_section":"3A1B","insp_viol_unit":"1","insp_unit_id":"206349436","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-18T11:19:42.000000Z","updated_at":"2025-04-20T10:49:13.000000Z","normalized_code":"3963A1B"},{"id":13241049,"change_date":"2025-04-16 21:41:00","inspection_id":"84419877","insp_violation_id":"265665323","seq_no":"7","part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"1","insp_unit_id":"206349436","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2025-04-18T11:19:42.000000Z","updated_at":"2025-04-20T10:49:13.000000Z","normalized_code":"3963A1BOS"}],"inspection_per_units":[{"id":13627798,"change_date":"2025-04-16 21:41:00","inspection_id":"84419877","insp_unit_id":"206349436","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"1302","insp_unit_license":"1M85408","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AN07Y5FM021302","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-19T10:11:28.000000Z","updated_at":"2025-04-20T10:03:36.000000Z"},{"id":13627799,"change_date":"2025-04-16 21:41:00","inspection_id":"84419877","insp_unit_id":"206349437","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRVS","insp_unit_company":"1302 T","insp_unit_license":"195B186","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"48XFF3720L1014156","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-19T10:11:28.000000Z","updated_at":"2025-04-20T10:03:36.000000Z"}]},{"id":8355275,"change_date":"2025-04-11 21:41:00","inspection_id":"84367484","dot_number":"1953973","report_state":"TX","report_number":"V251838766","insp_date":"2025-04-09 00:00:00","insp_start_time":"1005","insp_end_time":"1015","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"678M TX456 LOOP","county_code_state":"TX","county_code":"073","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CROCKETT SAND","shipping_paper_number":"519995","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-10 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"121220","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":"9547109","transaction_code":"C","transaction_date":"2025-04-11 00:00:00","upload_date":"2025-04-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01953973","upload_search_indicator":"M","census_search_date":"2025-04-10 21:42:00","snet_input_date":"2025-04-09 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-04-10 21:42:00","insp_carrier_name":"CROCKETT SAND & GRAVEL INC","insp_carrier_street":"PO BOX 389","insp_carrier_city":"CROCKETT","insp_carrier_state":"TX","insp_carrier_zip_code":"75835","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0004727","created_at":"2025-04-14T10:29:47.000000Z","updated_at":"2025-04-15T10:15:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13556906,"change_date":"2025-04-11 21:41:00","inspection_id":"84367484","insp_unit_id":"206273175","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"8096","insp_unit_license":"1M85434","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1PN4GY9MM008096","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-14T10:18:12.000000Z","updated_at":"2025-04-15T10:04:21.000000Z"},{"id":13556907,"change_date":"2025-04-11 21:41:00","inspection_id":"84367484","insp_unit_id":"206273176","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRVS","insp_unit_company":"2011","insp_unit_license":"Z05699","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"48XFF3922H1012011","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-14T10:18:12.000000Z","updated_at":"2025-04-15T10:04:21.000000Z"}]},{"id":8281279,"change_date":"2025-04-03 21:41:00","inspection_id":"84296244","dot_number":"1953973","report_state":"TX","report_number":"V251821006","insp_date":"2025-04-01 00:00:00","insp_start_time":"0701","insp_end_time":"0725","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US59 NB AT CR414","county_code_state":"TX","county_code":"365","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CROCKET SAND AND GRAVEL","shipping_paper_number":"519454","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-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"121220","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9539775","transaction_code":"C","transaction_date":"2025-04-03 00:00:00","upload_date":"2025-04-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01953973","upload_search_indicator":"M","census_search_date":"2025-04-02 21:41:00","snet_input_date":"2025-04-01 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-04-02 21:41:00","insp_carrier_name":"CROCKETT SAND & GRAVEL INC","insp_carrier_street":"PO BOX 389","insp_carrier_city":"CROCKETT","insp_carrier_state":"TX","insp_carrier_zip_code":"75835","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0004727","created_at":"2025-04-06T10:24:37.000000Z","updated_at":"2025-04-07T10:17:16.000000Z","inspection_violations":[{"id":13018206,"change_date":"2025-04-03 21:41:00","inspection_id":"84296244","insp_violation_id":"265429113","seq_no":"1","part_no":"393","part_no_section":"45","insp_viol_unit":"2","insp_unit_id":"206143933","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-05T10:48:16.000000Z","updated_at":"2025-04-07T10:31:05.000000Z","normalized_code":"39345"},{"id":13018207,"change_date":"2025-04-03 21:41:00","inspection_id":"84296244","insp_violation_id":"265429114","seq_no":"2","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"206143932","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-05T10:48:16.000000Z","updated_at":"2025-04-07T10:31:05.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":13410635,"change_date":"2025-04-03 21:41:00","inspection_id":"84296244","insp_unit_id":"206143932","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"1235","insp_unit_license":"1M85419","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2PN4GY5KM001235","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-06T10:05:53.000000Z","updated_at":"2025-04-07T09:52:36.000000Z"},{"id":13410636,"change_date":"2025-04-03 21:41:00","inspection_id":"84296244","insp_unit_id":"206143933","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRVS","insp_unit_company":"9405","insp_unit_license":"Z05654","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"48XFF3921F1009405","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-06T10:05:53.000000Z","updated_at":"2025-04-07T09:52:36.000000Z"}]},{"id":8298834,"change_date":"2025-04-04 21:41:00","inspection_id":"84318290","dot_number":"1953973","report_state":"TX","report_number":"V251817624","insp_date":"2025-04-01 00:00:00","insp_start_time":"0954","insp_end_time":"1019","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"10987 TX19 SB","county_code_state":"TX","county_code":"225","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CROCKETT SAND & GRAVEL INC","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-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120320","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":"9541568","transaction_code":"A","transaction_date":"2025-04-04 00:00:00","upload_date":"2025-04-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01953973","upload_search_indicator":"M","census_search_date":"2025-04-04 21:41:00","snet_input_date":"2025-04-01 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-04-04 21:41:00","insp_carrier_name":"CROCKETT SAND & GRAVEL INC","insp_carrier_street":"PO BOX 389","insp_carrier_city":"CROCKETT","insp_carrier_state":"TX","insp_carrier_zip_code":"75835","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0004727","created_at":"2025-04-07T10:22:20.000000Z","updated_at":"2025-04-08T10:09:55.000000Z","inspection_violations":[{"id":13050548,"change_date":"2025-04-04 21:41:00","inspection_id":"84318290","insp_violation_id":"265450561","seq_no":"1","part_no":"393","part_no_section":"48A","insp_viol_unit":"1","insp_unit_id":"206163312","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-07T10:53:15.000000Z","updated_at":"2025-04-07T11:01:42.000000Z","normalized_code":"39348A"},{"id":13050549,"change_date":"2025-04-04 21:41:00","inspection_id":"84318290","insp_violation_id":"265450562","seq_no":"2","part_no":"393","part_no_section":"48A","insp_viol_unit":"2","insp_unit_id":"206163313","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-07T10:53:15.000000Z","updated_at":"2025-04-07T11:01:42.000000Z","normalized_code":"39348A"},{"id":13050550,"change_date":"2025-04-04 21:41:00","inspection_id":"84318290","insp_violation_id":"265450563","seq_no":"3","part_no":"393","part_no_section":"53B","insp_viol_unit":"2","insp_unit_id":"206163313","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-07T10:53:15.000000Z","updated_at":"2025-04-07T11:01:42.000000Z","normalized_code":"39353B"},{"id":13050551,"change_date":"2025-04-04 21:41:00","inspection_id":"84318290","insp_violation_id":"265450564","seq_no":"4","part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"2","insp_unit_id":"206163313","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-04-07T10:53:15.000000Z","updated_at":"2025-04-07T11:01:42.000000Z","normalized_code":"3963A1BOS"}],"inspection_per_units":[{"id":13455689,"change_date":"2025-04-04 21:41:00","inspection_id":"84318290","insp_unit_id":"206163312","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"9961","insp_unit_license":"1M85407","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AN07Y8FM019961","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-07T10:13:23.000000Z","updated_at":"2025-04-08T10:02:02.000000Z"},{"id":13455690,"change_date":"2025-04-04 21:41:00","inspection_id":"84318290","insp_unit_id":"206163313","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VNTG","insp_unit_company":"5454","insp_unit_license":"096C176","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4E7AA3928GATA5454","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-07T10:13:23.000000Z","updated_at":"2025-04-08T10:02:02.000000Z"}]},{"id":7537425,"change_date":"2025-01-02 21:39:00","inspection_id":"83518040","dot_number":"1953973","report_state":"TX","report_number":"V241737961","insp_date":"2024-12-30 00:00:00","insp_start_time":"0930","insp_end_time":"0946","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH 7","county_code_state":"TX","county_code":"289","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CROCKETT SAND & GRAVEL INC","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-02 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"116220","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":"9462629","transaction_code":"A","transaction_date":"2025-01-02 00:00:00","upload_date":"2025-01-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01953973","upload_search_indicator":"M","census_search_date":"2025-01-02 21:39:00","snet_input_date":"2024-12-30 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-01-02 21:39:00","insp_carrier_name":"CROCKETT SAND & GRAVEL INC","insp_carrier_street":"PO BOX 389","insp_carrier_city":"CROCKETT","insp_carrier_state":"TX","insp_carrier_zip_code":"75835","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0004727","created_at":"2025-03-17T20:53:14.000000Z","updated_at":"2025-03-17T20:53:14.000000Z","inspection_violations":[{"id":11781222,"change_date":"2025-01-02 21:39:00","inspection_id":"83518040","insp_violation_id":"263734061","seq_no":"1","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"204629650","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:26.000000Z","updated_at":"2025-03-17T22:03:26.000000Z","normalized_code":"39021A"}],"inspection_per_units":[{"id":12160529,"change_date":"2025-01-02 21:39:00","inspection_id":"83518040","insp_unit_id":"204629650","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"1137","insp_unit_license":"1M85436","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AN07Y9GM021137","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:16.000000Z","updated_at":"2025-03-17T23:49:16.000000Z"},{"id":12160530,"change_date":"2025-01-02 21:39:00","inspection_id":"83518040","insp_unit_id":"204629651","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAV","insp_unit_company":"N\/A","insp_unit_license":"195B167","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"48XFF3928D1008118","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:16.000000Z","updated_at":"2025-03-17T23:49:16.000000Z"}]},{"id":7536927,"change_date":"2025-01-02 21:39:00","inspection_id":"83517519","dot_number":"1953973","report_state":"TX","report_number":"V241714676","insp_date":"2024-12-27 00:00:00","insp_start_time":"0900","insp_end_time":"0924","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US79 WB AT WOODRIDGE","county_code_state":"TX","county_code":"001","insp_level_id":"2","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":"2025-01-02 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"133220","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":"9462509","transaction_code":"A","transaction_date":"2025-01-02 00:00:00","upload_date":"2025-01-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01953973","upload_search_indicator":"M","census_search_date":"2025-01-02 21:39:00","snet_input_date":"2024-12-27 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-01-02 21:39:00","insp_carrier_name":"CROCKETT SAND & GRAVEL INC","insp_carrier_street":"PO BOX 389","insp_carrier_city":"CROCKETT","insp_carrier_state":"TX","insp_carrier_zip_code":"75835","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0004727","created_at":"2025-03-17T20:53:13.000000Z","updated_at":"2025-03-17T20:53:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12159626,"change_date":"2025-01-02 21:39:00","inspection_id":"83517519","insp_unit_id":"204628652","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"9749","insp_unit_license":"1M92766","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1PN4GY9NM009749","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:13.000000Z","updated_at":"2025-03-17T23:49:13.000000Z"},{"id":12159627,"change_date":"2025-01-02 21:39:00","inspection_id":"83517519","insp_unit_id":"204628653","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":"7093","insp_unit_license":"252C850","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5MADN3823RK077093","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:13.000000Z","updated_at":"2025-03-17T23:49:13.000000Z"}]},{"id":6924670,"change_date":"2024-10-09 21:42:00","inspection_id":"82870719","dot_number":"1953973","report_state":"TX","report_number":"V241563499","insp_date":"2024-10-08 00:00:00","insp_start_time":"1435","insp_end_time":"1455","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"181 FM2497","county_code_state":"TX","county_code":"005","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CROCKETT SAND & GRAVEL","shipping_paper_number":"509774","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-10-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"131220","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":"9398228","transaction_code":"A","transaction_date":"2024-10-09 00:00:00","upload_date":"2024-10-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01953973","upload_search_indicator":"M","census_search_date":"2024-10-09 21:42:00","snet_input_date":"2024-10-08 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-10-09 21:42:00","insp_carrier_name":"CROCKETT SAND & GRAVEL INC","insp_carrier_street":"PO BOX 389","insp_carrier_city":"CROCKETT","insp_carrier_state":"TX","insp_carrier_zip_code":"75835","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0004727","created_at":"2025-03-17T20:40:37.000000Z","updated_at":"2025-03-17T20:40:37.000000Z","inspection_violations":[{"id":10792717,"change_date":"2024-10-09 21:42:00","inspection_id":"82870719","insp_violation_id":"262272652","seq_no":"1","part_no":"393","part_no_section":"70(b)(1)(ii)","insp_viol_unit":"2","insp_unit_id":"203341693","insp_violation_category_id":"17","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:58:16.000000Z","updated_at":"2025-03-17T21:58:16.000000Z","normalized_code":"39370B1II"},{"id":10792718,"change_date":"2024-10-09 21:42:00","inspection_id":"82870719","insp_violation_id":"262272653","seq_no":"2","part_no":"393","part_no_section":"70(b)(1)(ii)","insp_viol_unit":"2","insp_unit_id":"203341693","insp_violation_category_id":"17","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:16.000000Z","updated_at":"2025-03-17T21:58:16.000000Z","normalized_code":"39370B1II"},{"id":10792719,"change_date":"2024-10-09 21:42:00","inspection_id":"82870719","insp_violation_id":"262272654","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"203341692","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:16.000000Z","updated_at":"2025-03-17T21:58:16.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":11167923,"change_date":"2024-10-09 21:42:00","inspection_id":"82870719","insp_unit_id":"203341692","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"3734","insp_unit_license":"1M85442","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1PN4GY5KM003734","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:39.000000Z","updated_at":"2025-03-17T23:38:39.000000Z"},{"id":11167924,"change_date":"2024-10-09 21:42:00","inspection_id":"82870719","insp_unit_id":"203341693","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRVS","insp_unit_company":"T4","insp_unit_license":"Z05615","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"48XFF3922G1010595","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:39.000000Z","updated_at":"2025-03-17T23:38:39.000000Z"}]},{"id":6659330,"change_date":"2024-09-05 21:43:00","inspection_id":"82588382","dot_number":"1953973","report_state":"TX","report_number":"V241515239","insp_date":"2024-09-03 00:00:00","insp_start_time":"1010","insp_end_time":"1040","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"TX571 LOOP AT FM13","county_code_state":"TX","county_code":"401","insp_level_id":"2","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-09-05 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"121220","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":"9370243","transaction_code":"A","transaction_date":"2024-09-05 00:00:00","upload_date":"2024-09-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01953973","upload_search_indicator":"M","census_search_date":"2024-09-05 21:43:00","snet_input_date":"2024-09-03 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-09-05 21:43:00","insp_carrier_name":"CROCKETT SAND & GRAVEL INC","insp_carrier_street":"PO BOX 389","insp_carrier_city":"CROCKETT","insp_carrier_state":"TX","insp_carrier_zip_code":"75835","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0004727","created_at":"2025-03-17T20:34:54.000000Z","updated_at":"2025-03-17T20:34:54.000000Z","inspection_violations":[{"id":10362606,"change_date":"2024-09-05 21:43:00","inspection_id":"82588382","insp_violation_id":"261642622","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"202784594","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:13.000000Z","updated_at":"2025-03-17T21:56:13.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":10736786,"change_date":"2024-09-05 21:43:00","inspection_id":"82588382","insp_unit_id":"202784594","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"1319","insp_unit_license":"1M85441","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2PN4GY0KM001319","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:11.000000Z","updated_at":"2025-03-17T23:34:11.000000Z"},{"id":10736787,"change_date":"2024-09-05 21:43:00","inspection_id":"82588382","insp_unit_id":"202784595","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRVS","insp_unit_company":"3","insp_unit_license":"100B701","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"48XFF3924H1012009","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:11.000000Z","updated_at":"2025-03-17T23:34:11.000000Z"}]},{"id":5931925,"change_date":"2024-08-08 21:42:00","inspection_id":"81808620","dot_number":"1953973","report_state":"TX","report_number":"V241411202","insp_date":"2024-06-04 00:00:00","insp_start_time":"1240","insp_end_time":"1314","registration_date":null,"region":"CT","ci_status_code":"C","location":"2A601","location_desc":"US59 SB DIBOLL SCALE","county_code_state":"TX","county_code":"005","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SACYR","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":"2024-06-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"133220","viol_total":"6","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9293894","transaction_code":"C","transaction_date":"2024-08-08 00:00:00","upload_date":"2024-08-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01953973","upload_search_indicator":"M","census_search_date":"2024-06-06 21:41:00","snet_input_date":"2024-06-04 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-06-06 21:41:00","insp_carrier_name":"CROCKETT SAND & GRAVEL INC","insp_carrier_street":"PO BOX 389","insp_carrier_city":"CROCKETT","insp_carrier_state":"TX","insp_carrier_zip_code":"75835","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0004727","created_at":"2025-03-17T20:20:16.000000Z","updated_at":"2025-03-17T20:20:16.000000Z","inspection_violations":[{"id":9200197,"change_date":"2024-08-08 21:42:00","inspection_id":"81808620","insp_violation_id":"261097498","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"202307049","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:31.000000Z","updated_at":"2025-03-17T21:50:31.000000Z","normalized_code":"39395A"},{"id":9200198,"change_date":"2024-08-08 21:42:00","inspection_id":"81808620","insp_violation_id":"261097499","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"202307050","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:31.000000Z","updated_at":"2025-03-17T21:50:31.000000Z","normalized_code":"3963A1"},{"id":9200199,"change_date":"2024-08-08 21:42:00","inspection_id":"81808620","insp_violation_id":"261097500","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"202307049","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:31.000000Z","updated_at":"2025-03-17T21:50:31.000000Z","normalized_code":"3963A1"},{"id":9200200,"change_date":"2024-08-08 21:42:00","inspection_id":"81808620","insp_violation_id":"261097501","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"202307049","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:31.000000Z","updated_at":"2025-03-17T21:50:31.000000Z","normalized_code":"3963A1"},{"id":9200201,"change_date":"2024-08-08 21:42:00","inspection_id":"81808620","insp_violation_id":"261097502","seq_no":"5","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"202307049","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:50:31.000000Z","updated_at":"2025-03-17T21:50:31.000000Z","normalized_code":"3963A1"},{"id":9200202,"change_date":"2024-08-08 21:42:00","inspection_id":"81808620","insp_violation_id":"261097503","seq_no":"6","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:31.000000Z","updated_at":"2025-03-17T21:50:31.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9554504,"change_date":"2024-08-08 21:42:00","inspection_id":"81808620","insp_unit_id":"202307049","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"5643","insp_unit_license":"1M85421","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1PN4GYXLM005643","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:04.000000Z","updated_at":"2025-03-17T23:22:04.000000Z"},{"id":9554505,"change_date":"2024-08-08 21:42:00","inspection_id":"81808620","insp_unit_id":"202307050","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAV","insp_unit_company":"9407","insp_unit_license":"Z05652","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"48XFF3925F1009407","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:04.000000Z","updated_at":"2025-03-17T23:22:04.000000Z"}]},{"id":4956910,"change_date":"2024-02-01 21:44:00","inspection_id":"80746228","dot_number":"1953973","report_state":"TX","report_number":"V241313979","insp_date":"2024-01-29 00:00:00","insp_start_time":"1337","insp_end_time":"1421","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-287 MP # 618","county_code_state":"TX","county_code":"001","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"NONE","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-02-01 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"121220","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":"9185925","transaction_code":"A","transaction_date":"2024-02-01 00:00:00","upload_date":"2024-02-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01953973","upload_search_indicator":"M","census_search_date":"2024-02-01 21:44:00","snet_input_date":"2024-01-29 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-02-01 21:44:00","insp_carrier_name":"CROCKETT SAND & GRAVEL INC","insp_carrier_street":"PO BOX 389","insp_carrier_city":"CROCKETT","insp_carrier_state":"TX","insp_carrier_zip_code":"75835","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0004727","created_at":"2025-03-17T20:00:52.000000Z","updated_at":"2025-03-17T20:00:52.000000Z","inspection_violations":[{"id":7635133,"change_date":"2024-02-01 21:44:00","inspection_id":"80746228","insp_violation_id":"257620136","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"199227330","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2025-03-17T21:42:51.000000Z","updated_at":"2025-03-17T21:42:51.000000Z","normalized_code":"3939A"},{"id":7635134,"change_date":"2024-02-01 21:44:00","inspection_id":"80746228","insp_violation_id":"257620137","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"199227330","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:51.000000Z","updated_at":"2025-03-17T21:42:51.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7977558,"change_date":"2024-02-01 21:44:00","inspection_id":"80746228","insp_unit_id":"199227329","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"5643","insp_unit_license":"1M85421","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1PN4GYXLM005643","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:18.000000Z","updated_at":"2025-03-17T23:07:18.000000Z"},{"id":7977559,"change_date":"2024-02-01 21:44:00","inspection_id":"80746228","insp_unit_id":"199227330","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAV","insp_unit_company":"9407","insp_unit_license":"039B161","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"48XFF3925F1009407","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:18.000000Z","updated_at":"2025-03-17T23:07:18.000000Z"}]},{"id":4127598,"change_date":"2023-10-04 21:41:00","inspection_id":"79834711","dot_number":"1953973","report_state":"TX","report_number":"V231147366","insp_date":"2023-09-19 00:00:00","insp_start_time":"0820","insp_end_time":"0859","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US 59 MM 398","county_code_state":"TX","county_code":"005","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CROCKETT SAND AND GRAVEL","shipping_paper_number":"484615","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":"2023-10-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9092623","transaction_code":"A","transaction_date":"2023-10-04 00:00:00","upload_date":"2023-10-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01953973","upload_search_indicator":"M","census_search_date":"2023-10-04 21:41:00","snet_input_date":"2023-09-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-10-04 21:41:00","insp_carrier_name":"CROCKETT SAND & GRAVEL INC","insp_carrier_street":"PO BOX 389","insp_carrier_city":"CROCKETT","insp_carrier_state":"TX","insp_carrier_zip_code":"75835","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0004727","created_at":"2025-03-17T19:44:26.000000Z","updated_at":"2025-03-17T19:44:26.000000Z","inspection_violations":[{"id":6388908,"change_date":"2023-10-04 21:41:00","inspection_id":"79834711","insp_violation_id":"255664249","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"197402642","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:48.000000Z","updated_at":"2025-03-17T21:36:48.000000Z","normalized_code":"39311"},{"id":6388909,"change_date":"2023-10-04 21:41:00","inspection_id":"79834711","insp_violation_id":"255664250","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:48.000000Z","updated_at":"2025-03-17T21:36:48.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6636665,"change_date":"2023-10-04 21:41:00","inspection_id":"79834711","insp_unit_id":"197402642","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"6708","insp_unit_license":"1M85437","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AN07Y5EM016708","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:41.000000Z","updated_at":"2025-03-17T22:55:41.000000Z"},{"id":6636666,"change_date":"2023-10-04 21:41:00","inspection_id":"79834711","insp_unit_id":"197402643","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":null,"insp_unit_company":null,"insp_unit_license":"172B300","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"48XFF3724M1014937","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:41.000000Z","updated_at":"2025-03-17T22:55:41.000000Z"}]},{"id":3848690,"change_date":"2023-09-12 21:40:00","inspection_id":"79524600","dot_number":"1953973","report_state":"TX","report_number":"V231118042","insp_date":"2023-08-24 00:00:00","insp_start_time":"0710","insp_end_time":"0732","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US 59","county_code_state":"TX","county_code":"365","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":"2023-08-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"9062847","transaction_code":"C","transaction_date":"2023-09-12 00:00:00","upload_date":"2023-09-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01953973","upload_search_indicator":"M","census_search_date":"2023-08-28 21:42:00","snet_input_date":"2023-08-24 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-08-28 21:42:00","insp_carrier_name":"CROCKETT SAND & GRAVEL INC","insp_carrier_street":"PO BOX 389","insp_carrier_city":"CROCKETT","insp_carrier_state":"TX","insp_carrier_zip_code":"75835","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0004727","created_at":"2025-03-17T19:38:55.000000Z","updated_at":"2025-03-17T19:38:55.000000Z","inspection_violations":[{"id":5946549,"change_date":"2023-09-12 21:40:00","inspection_id":"79524600","insp_violation_id":"255228224","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"197020286","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:48.000000Z","updated_at":"2025-03-17T21:34:48.000000Z","normalized_code":"39347E"},{"id":5946550,"change_date":"2023-09-12 21:40:00","inspection_id":"79524600","insp_violation_id":"255228225","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"197020286","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:48.000000Z","updated_at":"2025-03-17T21:34:48.000000Z","normalized_code":"39347E"},{"id":5946551,"change_date":"2023-09-12 21:40:00","inspection_id":"79524600","insp_violation_id":"255228226","seq_no":"3","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"197020286","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:48.000000Z","updated_at":"2025-03-17T21:34:48.000000Z","normalized_code":"39347E"},{"id":5946552,"change_date":"2023-09-12 21:40:00","inspection_id":"79524600","insp_violation_id":"255228227","seq_no":"4","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"197020286","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:48.000000Z","updated_at":"2025-03-17T21:34:48.000000Z","normalized_code":"39353B"},{"id":5946553,"change_date":"2023-09-12 21:40:00","inspection_id":"79524600","insp_violation_id":"255228228","seq_no":"5","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"197020286","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2025-03-17T21:34:48.000000Z","updated_at":"2025-03-17T21:34:48.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":6188278,"change_date":"2023-09-12 21:40:00","inspection_id":"79524600","insp_unit_id":"197020286","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"1319","insp_unit_license":"1M85441","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2PN4GY0KM001319","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:59.000000Z","updated_at":"2025-03-17T22:51:59.000000Z"},{"id":6188279,"change_date":"2023-09-12 21:40:00","inspection_id":"79524600","insp_unit_id":"197020287","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRVS","insp_unit_company":null,"insp_unit_license":"040B651","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"48XFF3921F1010084","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:59.000000Z","updated_at":"2025-03-17T22:51:59.000000Z"}]},{"id":2920416,"change_date":"2023-06-16 21:41:00","inspection_id":"78480949","dot_number":"1953973","report_state":"TX","report_number":"6KJ90YLA4U","insp_date":"2023-04-25 00:00:00","insp_start_time":"0854","insp_end_time":"0919","registration_date":null,"region":"CT","ci_status_code":"C","location":"2A601","location_desc":"US 59 SOUTHBOUND 1 MILE SOUTH","county_code_state":"TX","county_code":"005","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SACYR","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-04-28 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8966102","transaction_code":"C","transaction_date":"2023-06-16 00:00:00","upload_date":"2023-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01953973","upload_search_indicator":"M","census_search_date":"2023-04-28 21:39:00","snet_input_date":"2023-04-25 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-04-28 21:39:00","insp_carrier_name":"CROCKETT SAND & GRAVEL INC","insp_carrier_street":"PO BOX 389","insp_carrier_city":"CROCKETT","insp_carrier_state":"TX","insp_carrier_zip_code":"75835","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0004727","created_at":"2025-03-17T19:20:52.000000Z","updated_at":"2025-03-17T19:20:52.000000Z","inspection_violations":[{"id":4482195,"change_date":"2023-06-16 21:41:00","inspection_id":"78480949","insp_violation_id":"253564899","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195549058","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:55.000000Z","updated_at":"2025-03-17T21:27:55.000000Z","normalized_code":"3939A"},{"id":4482196,"change_date":"2023-06-16 21:41:00","inspection_id":"78480949","insp_violation_id":"253564900","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"195549059","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:55.000000Z","updated_at":"2025-03-17T21:27:55.000000Z","normalized_code":"3963A1"},{"id":4482197,"change_date":"2023-06-16 21:41:00","inspection_id":"78480949","insp_violation_id":"253564901","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"195549059","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:55.000000Z","updated_at":"2025-03-17T21:27:55.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":4698602,"change_date":"2023-06-16 21:41:00","inspection_id":"78480949","insp_unit_id":"195549058","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"5643","insp_unit_license":"1M85421","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1PN4GYXLM005643","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:02.000000Z","updated_at":"2025-03-17T22:40:02.000000Z"},{"id":4698603,"change_date":"2023-06-16 21:41:00","inspection_id":"78480949","insp_unit_id":"195549059","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":"25036","insp_unit_license":"195B151","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5MADN4020DC025036","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:02.000000Z","updated_at":"2025-03-17T22:40:02.000000Z"}]},{"id":2417640,"change_date":"2023-02-21 21:42:00","inspection_id":"77909306","dot_number":"1953973","report_state":"TX","report_number":"6IM90SJP32","insp_date":"2023-02-15 00:00:00","insp_start_time":"0912","insp_end_time":"0934","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0079 IN ANDERSON CO. (386-4","county_code_state":"TX","county_code":"001","insp_level_id":"3","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":"2023-02-21 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"60220","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8908901","transaction_code":"A","transaction_date":"2023-02-21 00:00:00","upload_date":"2023-02-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01953973","upload_search_indicator":"M","census_search_date":"2023-02-21 21:42:00","snet_input_date":"2023-02-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-02-21 21:42:00","insp_carrier_name":"CROCKETT SAND & GRAVEL INC","insp_carrier_street":"1200 S 4TH STREET","insp_carrier_city":"CROCKETT","insp_carrier_state":"TX","insp_carrier_zip_code":"75835","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0004727","created_at":"2025-03-17T19:11:06.000000Z","updated_at":"2025-03-17T19:11:06.000000Z","inspection_violations":[{"id":3722247,"change_date":"2023-02-21 21:42:00","inspection_id":"77909306","insp_violation_id":"251254894","seq_no":"1","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"1","insp_unit_id":"193506453","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2025-03-17T21:24:34.000000Z","updated_at":"2025-03-17T21:24:34.000000Z","normalized_code":"393207A"}],"inspection_per_units":[{"id":3891023,"change_date":"2023-02-21 21:42:00","inspection_id":"77909306","insp_unit_id":"193506453","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"3734","insp_unit_license":"1M85442","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1PN4GY5KM003734","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:52.000000Z","updated_at":"2025-03-17T22:33:52.000000Z"},{"id":3891024,"change_date":"2023-02-21 21:42:00","inspection_id":"77909306","insp_unit_id":"193506454","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAV","insp_unit_company":"4","insp_unit_license":"Z05612","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"48XFF3921F1009646","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:52.000000Z","updated_at":"2025-03-17T22:33:52.000000Z"}]},{"id":2391086,"change_date":"2023-02-16 21:42:00","inspection_id":"77878921","dot_number":"1953973","report_state":"TX","report_number":"6IK80ANW8V","insp_date":"2023-02-13 00:00:00","insp_start_time":"0755","insp_end_time":"0832","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0079 IN RUSK CO. (326-354)","county_code_state":"TX","county_code":"401","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CROCKETT SAND & GRAVEL","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-16 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8906584","transaction_code":"A","transaction_date":"2023-02-16 00:00:00","upload_date":"2023-02-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01953973","upload_search_indicator":"M","census_search_date":"2023-02-16 21:42:00","snet_input_date":"2023-02-13 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-02-16 21:42:00","insp_carrier_name":"CROCKETT SAND & GRAVEL INC","insp_carrier_street":"1200 S 4TH STREET","insp_carrier_city":"CROCKETT","insp_carrier_state":"TX","insp_carrier_zip_code":"75835","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0004727","created_at":"2025-03-17T19:10:44.000000Z","updated_at":"2025-03-17T19:10:44.000000Z","inspection_violations":[{"id":3681632,"change_date":"2023-02-16 21:42:00","inspection_id":"77878921","insp_violation_id":"251188361","seq_no":"1","part_no":"390","part_no_section":"3(e)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"8","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:23.000000Z","updated_at":"2025-03-17T21:24:23.000000Z","normalized_code":"3903E"},{"id":3681633,"change_date":"2023-02-16 21:42:00","inspection_id":"77878921","insp_violation_id":"251188362","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:23.000000Z","updated_at":"2025-03-17T21:24:23.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3847752,"change_date":"2023-02-16 21:42:00","inspection_id":"77878921","insp_unit_id":"193445296","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"9465","insp_unit_license":"1L49344","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AW09Y9GM059465","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:33.000000Z","updated_at":"2025-03-17T22:33:33.000000Z"},{"id":3847753,"change_date":"2023-02-16 21:42:00","inspection_id":"77878921","insp_unit_id":"193445297","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRVS","insp_unit_company":null,"insp_unit_license":"195B186","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"48XFF3720L1014156","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:33.000000Z","updated_at":"2025-03-17T22:33:33.000000Z"}]},{"id":2229616,"change_date":"2023-01-25 21:43:00","inspection_id":"77694891","dot_number":"1953973","report_state":"TX","report_number":"6HVD0KKL7X","insp_date":"2023-01-19 00:00:00","insp_start_time":"1252","insp_end_time":"1335","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0007 IN LEON CO. (620-660)","county_code_state":"TX","county_code":"289","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"FROST CRUSHED STONE","shipping_paper_number":"816118","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":"N","pen_cen_match":null,"final_status_date":"2023-01-25 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"119200","viol_total":"3","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8888005","transaction_code":"A","transaction_date":"2023-01-25 00:00:00","upload_date":"2023-01-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01953973","upload_search_indicator":"M","census_search_date":"2023-01-25 21:43:00","snet_input_date":"2023-01-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-01-25 21:43:00","insp_carrier_name":"CROCKETT SAND & GRAVEL INC","insp_carrier_street":"1200 S 4TH STREET","insp_carrier_city":"CROCKETT","insp_carrier_state":"TX","insp_carrier_zip_code":"75835","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0004727","created_at":"2025-03-17T19:07:45.000000Z","updated_at":"2025-03-17T19:07:45.000000Z","inspection_violations":[{"id":3445379,"change_date":"2023-01-25 21:43:00","inspection_id":"77694891","insp_violation_id":"250786512","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"193071967","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:18.000000Z","updated_at":"2025-03-17T21:23:18.000000Z","normalized_code":"39311"},{"id":3445380,"change_date":"2023-01-25 21:43:00","inspection_id":"77694891","insp_violation_id":"250786513","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"193071967","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:18.000000Z","updated_at":"2025-03-17T21:23:18.000000Z","normalized_code":"39311"},{"id":3445381,"change_date":"2023-01-25 21:43:00","inspection_id":"77694891","insp_violation_id":"250786514","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:18.000000Z","updated_at":"2025-03-17T21:23:18.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3588910,"change_date":"2023-01-25 21:43:00","inspection_id":"77694891","insp_unit_id":"193071967","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"3734","insp_unit_license":"1M85442","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1PN4GY5KM003734","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:43.000000Z","updated_at":"2025-03-17T22:31:43.000000Z"},{"id":3588911,"change_date":"2023-01-25 21:43:00","inspection_id":"77694891","insp_unit_id":"193071968","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRVS","insp_unit_company":"9646","insp_unit_license":"Z05612","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"48XFF3921F1009646","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:43.000000Z","updated_at":"2025-03-17T22:31:43.000000Z"}]},{"id":1883730,"change_date":"2022-12-06 21:40:00","inspection_id":"77299141","dot_number":"1953973","report_state":"TX","report_number":"6GFE0XSRPO","insp_date":"2022-11-28 00:00:00","insp_start_time":"1501","insp_end_time":"1530","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0019 IN TRINITY CO. (404-42","county_code_state":"TX","county_code":"455","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CROCKETT SAND AND GRAVEL","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-12-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"121220","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":"8842918","transaction_code":"A","transaction_date":"2022-12-06 00:00:00","upload_date":"2022-12-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01953973","upload_search_indicator":"M","census_search_date":"2022-12-06 21:40:00","snet_input_date":"2022-11-28 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-12-06 21:40:00","insp_carrier_name":"CROCKETT SAND & GRAVEL INC","insp_carrier_street":"1200 S 4TH STREET","insp_carrier_city":"CROCKETT","insp_carrier_state":"TX","insp_carrier_zip_code":"75835","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0004727","created_at":"2025-03-17T19:01:27.000000Z","updated_at":"2025-03-17T19:01:27.000000Z","inspection_violations":[{"id":2931058,"change_date":"2022-12-06 21:40:00","inspection_id":"77299141","insp_violation_id":"249951508","seq_no":"1","part_no":"393","part_no_section":"55(d)(3)","insp_viol_unit":"2","insp_unit_id":"192289044","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:58.000000Z","updated_at":"2025-03-17T21:20:58.000000Z","normalized_code":"39355D3"}],"inspection_per_units":[{"id":3031660,"change_date":"2022-12-06 21:40:00","inspection_id":"77299141","insp_unit_id":"192289043","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"5643","insp_unit_license":"1M85421","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1PN4GYXLM005643","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:46.000000Z","updated_at":"2025-03-17T22:27:46.000000Z"},{"id":3031661,"change_date":"2022-12-06 21:40:00","inspection_id":"77299141","insp_unit_id":"192289044","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"53220","insp_unit_license":"195B151","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5MADN4020DC025036","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:46.000000Z","updated_at":"2025-03-17T22:27:46.000000Z"}]},{"id":1511139,"change_date":"2022-10-13 21:40:00","inspection_id":"76871359","dot_number":"1953973","report_state":"TX","report_number":"6EZ70XSRLE","insp_date":"2022-10-07 00:00:00","insp_start_time":"0731","insp_end_time":"0800","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0019 IN WALKER CO. (422-434","county_code_state":"TX","county_code":"471","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CROCKETT SAND","shipping_paper_number":"464144","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-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"121220","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":"8798714","transaction_code":"A","transaction_date":"2022-10-13 00:00:00","upload_date":"2022-10-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01953973","upload_search_indicator":"M","census_search_date":"2022-10-13 21:40:00","snet_input_date":"2022-10-07 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-10-13 21:40:00","insp_carrier_name":"CROCKETT SAND & GRAVEL INC","insp_carrier_street":"1200 S 4TH STREET","insp_carrier_city":"CROCKETT","insp_carrier_state":"TX","insp_carrier_zip_code":"75835","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0004727","created_at":"2025-03-17T18:54:30.000000Z","updated_at":"2025-03-17T18:54:30.000000Z","inspection_violations":[{"id":2378702,"change_date":"2022-10-13 21:40:00","inspection_id":"76871359","insp_violation_id":"249019372","seq_no":"1","part_no":"393","part_no_section":"55(d)(3)","insp_viol_unit":"2","insp_unit_id":"191433431","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:53.000000Z","updated_at":"2025-03-17T21:17:53.000000Z","normalized_code":"39355D3"}],"inspection_per_units":[{"id":2432436,"change_date":"2022-10-13 21:40:00","inspection_id":"76871359","insp_unit_id":"191433430","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"5643","insp_unit_license":"1M85421","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1PN4GYXLM005643","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:40.000000Z","updated_at":"2025-03-17T22:23:40.000000Z"},{"id":2432437,"change_date":"2022-10-13 21:40:00","inspection_id":"76871359","insp_unit_id":"191433431","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"888","insp_unit_license":"195B151","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5MADN4020DC025036","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:40.000000Z","updated_at":"2025-03-17T22:23:40.000000Z"}]},{"id":1163700,"change_date":"2022-09-08 21:39:00","inspection_id":"76468603","dot_number":"1953973","report_state":"TX","report_number":"6DTE0AGEOS","insp_date":"2022-08-26 00:00:00","insp_start_time":"1254","insp_end_time":"1435","registration_date":"2022-09-08 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0287 IN ANDERSON CO. (570-6","county_code_state":"TX","county_code":"001","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-29 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"72900","viol_total":"6","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8756469","transaction_code":"C","transaction_date":"2022-08-29 00:00:00","upload_date":"2022-09-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01953973","upload_search_indicator":"M","census_search_date":"2022-08-29 21:43:00","snet_input_date":"2022-08-26 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-08-29 21:43:00","insp_carrier_name":"CROCKETT SAND & GRAVEL INC","insp_carrier_street":"1200 S 4TH STREET","insp_carrier_city":"CROCKETT","insp_carrier_state":"TX","insp_carrier_zip_code":"75835","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0004727","created_at":"2025-03-17T18:48:16.000000Z","updated_at":"2025-03-17T18:48:16.000000Z","inspection_violations":[{"id":1846314,"change_date":"2022-09-08 21:39:00","inspection_id":"76468603","insp_violation_id":"248293607","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:33.000000Z","updated_at":"2025-03-17T21:15:33.000000Z","normalized_code":"3922"},{"id":1846315,"change_date":"2022-09-08 21:39:00","inspection_id":"76468603","insp_violation_id":"248293608","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:33.000000Z","updated_at":"2025-03-17T21:15:33.000000Z","normalized_code":"3922"},{"id":1846316,"change_date":"2022-09-08 21:39:00","inspection_id":"76468603","insp_violation_id":"248293609","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"190795610","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:33.000000Z","updated_at":"2025-03-17T21:15:33.000000Z","normalized_code":"3922"},{"id":1846317,"change_date":"2022-09-08 21:39:00","inspection_id":"76468603","insp_violation_id":"248293610","seq_no":"5","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"190795610","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:33.000000Z","updated_at":"2025-03-17T21:15:33.000000Z","normalized_code":"39617C"},{"id":1846318,"change_date":"2022-09-08 21:39:00","inspection_id":"76468603","insp_violation_id":"248293611","seq_no":"6","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"190795610","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:33.000000Z","updated_at":"2025-03-17T21:15:33.000000Z","normalized_code":"39375C"},{"id":1846319,"change_date":"2022-09-08 21:39:00","inspection_id":"76468603","insp_violation_id":"248293612","seq_no":"7","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"190795610","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:33.000000Z","updated_at":"2025-03-17T21:15:33.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":1871483,"change_date":"2022-09-08 21:39:00","inspection_id":"76468603","insp_unit_id":"190795609","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"5181","insp_unit_license":"1M97387","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3ALXFBCG7FDGB5181","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:53.000000Z","updated_at":"2025-03-17T22:19:53.000000Z"},{"id":1871484,"change_date":"2022-09-08 21:39:00","inspection_id":"76468603","insp_unit_id":"190795610","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WITZ","insp_unit_company":"0","insp_unit_license":"X94694","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1W8A11E39WS000528","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:53.000000Z","updated_at":"2025-03-17T22:19:53.000000Z"}]},{"id":780524,"change_date":"2022-07-08 21:41:00","inspection_id":"76020868","dot_number":"1953973","report_state":"TX","report_number":"6CFD0XJDAE","insp_date":"2022-07-07 00:00:00","insp_start_time":"1304","insp_end_time":"1322","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0019 IN WALKER CO. (422-434","county_code_state":"TX","county_code":"471","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"XX","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-07-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"125000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8708689","transaction_code":"A","transaction_date":"2022-07-08 00:00:00","upload_date":"2022-07-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01953973","upload_search_indicator":"M","census_search_date":"2022-07-08 21:41:00","snet_input_date":"2022-07-07 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-07-08 21:41:00","insp_carrier_name":"CROCKETT SAND & GRAVEL INC","insp_carrier_street":"1200 S 4TH STREET","insp_carrier_city":"CROCKETT","insp_carrier_state":"TX","insp_carrier_zip_code":"75835","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0004727","created_at":"2025-03-17T18:41:33.000000Z","updated_at":"2025-03-17T18:41:33.000000Z","inspection_violations":[{"id":1233872,"change_date":"2022-07-08 21:41:00","inspection_id":"76020868","insp_violation_id":"246983640","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189680523","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:46.000000Z","updated_at":"2025-03-17T21:12:46.000000Z","normalized_code":"3939A"},{"id":1233873,"change_date":"2022-07-08 21:41:00","inspection_id":"76020868","insp_violation_id":"246983641","seq_no":"2","part_no":"393","part_no_section":"19","insp_viol_unit":"1","insp_unit_id":"189680523","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:46.000000Z","updated_at":"2025-03-17T21:12:46.000000Z","normalized_code":"39319"},{"id":1233874,"change_date":"2022-07-08 21:41:00","inspection_id":"76020868","insp_violation_id":"246983642","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189680523","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:46.000000Z","updated_at":"2025-03-17T21:12:46.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":1256027,"change_date":"2022-07-08 21:41:00","inspection_id":"76020868","insp_unit_id":"189680523","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"9467","insp_unit_license":"1L49346","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AW09Y2GM059467","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:55.000000Z","updated_at":"2025-03-17T22:15:55.000000Z"},{"id":1256028,"change_date":"2022-07-08 21:41:00","inspection_id":"76020868","insp_unit_id":"189680524","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRVS","insp_unit_company":"201107","insp_unit_license":"100B703","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"48XFF3922H1012011","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:55.000000Z","updated_at":"2025-03-17T22:15:55.000000Z"}]},{"id":764290,"change_date":"2022-07-18 21:42:00","inspection_id":"76001870","dot_number":"1953973","report_state":"TX","report_number":"6C5F0XSRAP","insp_date":"2022-06-27 00:00:00","insp_start_time":"1522","insp_end_time":"1553","registration_date":"2022-07-18 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0019 IN TRINITY CO. (404-42","county_code_state":"TX","county_code":"455","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CROCKETT SAND AND GRAVEL","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-07-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8704579","transaction_code":"C","transaction_date":"2022-07-06 00:00:00","upload_date":"2022-07-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01953973","upload_search_indicator":"M","census_search_date":"2022-07-06 21:41:00","snet_input_date":"2022-06-27 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-07-06 21:41:00","insp_carrier_name":"CROCKETT SAND & GRAVEL INC","insp_carrier_street":"1200 S 4TH STREET","insp_carrier_city":"CROCKETT","insp_carrier_state":"TX","insp_carrier_zip_code":"75835","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0004727","created_at":"2025-03-17T18:41:12.000000Z","updated_at":"2025-03-17T18:41:12.000000Z","inspection_violations":[{"id":1205105,"change_date":"2022-07-18 21:42:00","inspection_id":"76001870","insp_violation_id":"247163624","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"189837640","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:40.000000Z","updated_at":"2025-03-17T21:12:40.000000Z","normalized_code":"39311"},{"id":1205106,"change_date":"2022-07-18 21:42:00","inspection_id":"76001870","insp_violation_id":"247163625","seq_no":"2","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"189837640","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:40.000000Z","updated_at":"2025-03-17T21:12:40.000000Z","normalized_code":"39360C"}],"inspection_per_units":[{"id":1229469,"change_date":"2022-07-18 21:42:00","inspection_id":"76001870","insp_unit_id":"189837640","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"9465","insp_unit_license":"1L49344","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AW09Y9GM059465","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:44.000000Z","updated_at":"2025-03-17T22:15:44.000000Z"},{"id":1229470,"change_date":"2022-07-18 21:42:00","inspection_id":"76001870","insp_unit_id":"189837641","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRVS","insp_unit_company":"T9465","insp_unit_license":"195B186","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"48XFF3720L1014156","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:44.000000Z","updated_at":"2025-03-17T22:15:44.000000Z"}]},{"id":312199,"change_date":"2022-05-16 21:43:00","inspection_id":"75465638","dot_number":"1953973","report_state":"TX","report_number":"6AFF0XSR2O","insp_date":"2022-04-26 00:00:00","insp_start_time":"1541","insp_end_time":"1611","registration_date":"2022-05-13 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0019 IN TRINITY CO. (404-42","county_code_state":"TX","county_code":"455","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CROCKETT SAND","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-03 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8642548","transaction_code":"C","transaction_date":"2022-05-04 00:00:00","upload_date":"2022-05-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01953973","upload_search_indicator":"M","census_search_date":"2022-05-03 21:39:00","snet_input_date":"2022-04-26 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-05-03 21:39:00","insp_carrier_name":"CROCKETT SAND & GRAVEL INC","insp_carrier_street":"1200 S 4TH STREET","insp_carrier_city":"CROCKETT","insp_carrier_state":"TX","insp_carrier_zip_code":"75835","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0004727","created_at":"2025-03-17T18:32:58.000000Z","updated_at":"2025-03-17T18:32:58.000000Z","inspection_violations":[{"id":486921,"change_date":"2022-05-16 21:43:00","inspection_id":"75465638","insp_violation_id":"245812425","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"188704682","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:22.000000Z","updated_at":"2025-03-17T21:09:22.000000Z","normalized_code":"3939A"},{"id":486922,"change_date":"2022-05-16 21:43:00","inspection_id":"75465638","insp_violation_id":"245812426","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"188704683","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:09:22.000000Z","updated_at":"2025-03-17T21:09:22.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":505239,"change_date":"2022-05-16 21:43:00","inspection_id":"75465638","insp_unit_id":"188704682","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"7980","insp_unit_license":"1L49324","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AN07Y2FM017980","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:19.000000Z","updated_at":"2025-03-17T22:11:19.000000Z"},{"id":505240,"change_date":"2022-05-16 21:43:00","inspection_id":"75465638","insp_unit_id":"188704683","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAV","insp_unit_company":"9646","insp_unit_license":"Z05612","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"48XFF3921F1009646","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:19.000000Z","updated_at":"2025-03-17T22:11:19.000000Z"}]},{"id":258487,"change_date":"2022-04-29 21:41:00","inspection_id":"75401727","dot_number":"1953973","report_state":"TX","report_number":"6A7F0XSR0Y","insp_date":"2022-04-18 00:00:00","insp_start_time":"1501","insp_end_time":"1531","registration_date":"2022-04-29 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0019 IN TRINITY CO. (404-42","county_code_state":"TX","county_code":"455","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CROCKETT SAND AND GRAVEL","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"121220","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":"8633696","transaction_code":"C","transaction_date":"2022-04-25 00:00:00","upload_date":"2022-04-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01953973","upload_search_indicator":"M","census_search_date":"2022-04-26 21:42:00","snet_input_date":"2022-04-18 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-04-26 21:42:00","insp_carrier_name":"CROCKETT SAND & GRAVEL INC","insp_carrier_street":"1200 S 4TH STREET","insp_carrier_city":"CROCKETT","insp_carrier_state":"TX","insp_carrier_zip_code":"75835","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0004727","created_at":"2025-03-17T18:31:56.000000Z","updated_at":"2025-03-17T18:31:56.000000Z","inspection_violations":[{"id":397298,"change_date":"2022-04-29 21:41:00","inspection_id":"75401727","insp_violation_id":"245494095","seq_no":"1","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"188436552","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:55.000000Z","updated_at":"2025-03-17T21:08:55.000000Z","normalized_code":"39375C"}],"inspection_per_units":[{"id":418589,"change_date":"2022-04-29 21:41:00","inspection_id":"75401727","insp_unit_id":"188436551","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"8064","insp_unit_license":"1M85428","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1PN4GY7MM008064","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:46.000000Z","updated_at":"2025-03-17T22:10:46.000000Z"},{"id":418590,"change_date":"2022-04-29 21:41:00","inspection_id":"75401727","insp_unit_id":"188436552","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAV","insp_unit_company":"9405","insp_unit_license":"039B163","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"48XFF3921F1009405","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:46.000000Z","updated_at":"2025-03-17T22:10:46.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1953973\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1953973\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1953973\/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\/1953973\/inspections","per_page":100,"prev_page_url":null,"to":31,"total":31}