{"current_page":1,"data":[{"id":11841497,"change_date":"2026-05-06 21:41:00","inspection_id":"87777088","dot_number":"1031889","report_state":"IA","report_number":"000P1102LD","insp_date":"2026-05-04 00:00:00","insp_start_time":"0730","insp_end_time":"0750","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 18 EB AT EAGLE","county_code_state":"IA","county_code":"167","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"VALLEY SAND AND 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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-05-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"127000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1399488","transaction_code":"A","transaction_date":"2026-05-06 00:00:00","upload_date":"2026-05-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01031889","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2026-05-04 00:00:00","source_office":"3IAS001","mcmis_add_date":"2026-05-06 21:41:00","insp_carrier_name":"VALLEY SAND & GRAVEL INC","insp_carrier_street":"2015 N MAIN","insp_carrier_city":"ROCK VALLEY","insp_carrier_state":"IA","insp_carrier_zip_code":"51247","insp_colonia":null,"docket_number":"435489","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-09T09:40:20.000000Z","updated_at":"2026-05-16T13:24:34.000000Z","inspection_violations":[{"id":20592650,"change_date":"2026-05-06 21:41:00","inspection_id":"87777088","insp_violation_id":"274089185","seq_no":"1","part_no":"392","part_no_section":"16","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"1DYK26050407423","created_at":"2026-05-09T10:01:14.000000Z","updated_at":"2026-05-16T12:56:46.000000Z","normalized_code":"39216"}],"inspection_per_units":[{"id":20593189,"change_date":"2026-05-06 21:41:00","inspection_id":"87777088","insp_unit_id":"213416354","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"81","insp_unit_license":"VC4262","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XPWDP9X2CD168466","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-09T09:18:32.000000Z","updated_at":"2026-05-16T12:32:12.000000Z"},{"id":20593190,"change_date":"2026-05-06 21:41:00","inspection_id":"87777088","insp_unit_id":"213416355","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MANAC","insp_unit_company":"T15","insp_unit_license":"LM9739","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5MC424211S3232388","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-09T09:18:32.000000Z","updated_at":"2026-05-16T12:32:12.000000Z"}]},{"id":11489097,"change_date":"2026-03-26 21:40:00","inspection_id":"87408690","dot_number":"1031889","report_state":"IA","report_number":"000P1102KT","insp_date":"2026-03-25 00:00:00","insp_start_time":"1355","insp_end_time":"1415","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 18 EB AT EAGLE","county_code_state":"IA","county_code":"167","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"VALLEY SAND AND 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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"142000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1395040","transaction_code":"A","transaction_date":"2026-03-26 00:00:00","upload_date":"2026-03-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01031889","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2026-03-25 00:00:00","source_office":"3IAS001","mcmis_add_date":"2026-03-26 21:40:00","insp_carrier_name":"VALLEY SAND & GRAVEL INC","insp_carrier_street":"2015 N MAIN","insp_carrier_city":"ROCK VALLEY","insp_carrier_state":"IA","insp_carrier_zip_code":"51247","insp_colonia":null,"docket_number":"435489","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-29T09:54:18.000000Z","updated_at":"2026-04-06T09:33:08.000000Z","inspection_violations":[{"id":19397855,"change_date":"2026-03-26 21:40:00","inspection_id":"87408690","insp_violation_id":"272664006","seq_no":"1","part_no":"392","part_no_section":"16","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"1DYK26032514083","created_at":"2026-03-29T10:23:30.000000Z","updated_at":"2026-04-06T09:54:16.000000Z","normalized_code":"39216"}],"inspection_per_units":[{"id":19681259,"change_date":"2026-03-26 21:40:00","inspection_id":"87408690","insp_unit_id":"212358372","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"64A","insp_unit_license":"VF3070","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XPBD49X5LD633657","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-29T09:51:02.000000Z","updated_at":"2026-04-06T09:12:46.000000Z"},{"id":19681260,"change_date":"2026-03-26 21:40:00","inspection_id":"87408690","insp_unit_id":"212358373","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MANAC","insp_unit_company":"LH7853","insp_unit_license":"LH7853","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5MC424214T3233861","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-29T09:51:02.000000Z","updated_at":"2026-04-06T09:12:46.000000Z"}]},{"id":8962430,"change_date":"2025-06-23 21:41:00","inspection_id":"85019214","dot_number":"1031889","report_state":"IA","report_number":"000P1102F7","insp_date":"2025-06-19 00:00:00","insp_start_time":"1420","insp_end_time":"1440","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"K30 SB AT HWY 18","county_code_state":"IA","county_code":"167","insp_level_id":"3","service_center":"MW","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"130000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1364713","transaction_code":"A","transaction_date":"2025-06-23 00:00:00","upload_date":"2025-06-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01031889","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-06-19 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-06-23 21:41:00","insp_carrier_name":"VALLEY SAND & GRAVEL INC","insp_carrier_street":"2015 N MAIN","insp_carrier_city":"ROCK VALLEY","insp_carrier_state":"IA","insp_carrier_zip_code":"51247","insp_colonia":null,"docket_number":"435489","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-28T10:00:36.000000Z","updated_at":"2025-06-28T10:00:36.000000Z","inspection_violations":[{"id":14394741,"change_date":"2025-06-23 21:41:00","inspection_id":"85019214","insp_violation_id":"266987423","seq_no":"1","part_no":"392","part_no_section":"16","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"1DYK25061914330","created_at":"2025-06-26T10:15:57.000000Z","updated_at":"2025-06-27T10:17:51.000000Z","normalized_code":"39216"}],"inspection_per_units":[{"id":14692076,"change_date":"2025-06-23 21:41:00","inspection_id":"85019214","insp_unit_id":"207509121","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"44A","insp_unit_license":"VF3068","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XPCDP9X0LD663445","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-26T09:45:38.000000Z","updated_at":"2025-06-27T09:46:07.000000Z"},{"id":14692077,"change_date":"2025-06-23 21:41:00","inspection_id":"85019214","insp_unit_id":"207509122","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"JET","insp_unit_company":"T11","insp_unit_license":"JP6493","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5JNSS4534GH000462","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-26T09:45:38.000000Z","updated_at":"2025-06-27T09:46:07.000000Z"}]},{"id":6989868,"change_date":"2024-10-18 21:42:00","inspection_id":"82940086","dot_number":"1031889","report_state":"IA","report_number":"000P110282","insp_date":"2024-10-17 00:00:00","insp_start_time":"1345","insp_end_time":"1405","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 18 EB AT K24","county_code_state":"IA","county_code":"167","insp_level_id":"3","service_center":"MW","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"127000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1333507","transaction_code":"A","transaction_date":"2024-10-18 00:00:00","upload_date":"2024-10-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01031889","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-10-17 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-10-18 21:42:00","insp_carrier_name":"VALLEY SAND & GRAVEL INC","insp_carrier_street":"2015 N MAIN","insp_carrier_city":"ROCK VALLEY","insp_carrier_state":"IA","insp_carrier_zip_code":"51247","insp_colonia":null,"docket_number":"435489","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:41:48.000000Z","updated_at":"2025-03-17T20:41:48.000000Z","inspection_violations":[{"id":10904006,"change_date":"2024-10-18 21:42:00","inspection_id":"82940086","insp_violation_id":"262427399","seq_no":"1","part_no":"392","part_no_section":"16","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"1DYK24101713580","created_at":"2025-03-17T21:58:54.000000Z","updated_at":"2025-03-17T21:58:54.000000Z","normalized_code":"39216"}],"inspection_per_units":[{"id":11274106,"change_date":"2024-10-18 21:42:00","inspection_id":"82940086","insp_unit_id":"203474868","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"81","insp_unit_license":"VC4262","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XPWDP9X2CD168466","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:42.000000Z","updated_at":"2025-03-17T23:39:42.000000Z"},{"id":11274107,"change_date":"2024-10-18 21:42:00","inspection_id":"82940086","insp_unit_id":"203474869","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MANAC","insp_unit_company":"CX6211","insp_unit_license":"CX6211","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5MC424211S3232388","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:42.000000Z","updated_at":"2025-03-17T23:39:42.000000Z"}]},{"id":6759246,"change_date":"2024-09-18 21:42:00","inspection_id":"82694619","dot_number":"1031889","report_state":"NE","report_number":"T498000326","insp_date":"2024-09-18 00:00:00","insp_start_time":"1027","insp_end_time":"1045","registration_date":null,"region":"CT","ci_status_code":"C","location":"3","location_desc":"FREMONT SCALE","county_code_state":"NE","county_code":"053","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"VALLEY SAND & GRAVEL","shipping_paper_number":"392922","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":"2024-09-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"797787","transaction_code":"A","transaction_date":"2024-09-18 00:00:00","upload_date":"2024-09-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01031889","upload_search_indicator":null,"census_search_date":"2024-09-18 21:42:00","snet_input_date":"2024-09-18 00:00:00","source_office":"3NES001","mcmis_add_date":"2024-09-18 21:42:00","insp_carrier_name":"VALLEY SAND & GRAVEL INC","insp_carrier_street":"PO BOX 9","insp_carrier_city":"ROCK VALLEY","insp_carrier_state":"IA","insp_carrier_zip_code":"512470009","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:36:59.000000Z","updated_at":"2025-03-17T20:36:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10899566,"change_date":"2024-09-18 21:42:00","inspection_id":"82694619","insp_unit_id":"203008835","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"42","insp_unit_license":"VF3067","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XPCD49XXND763067","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:52.000000Z","updated_at":"2025-03-17T23:35:52.000000Z"},{"id":10899567,"change_date":"2024-09-18 21:42:00","inspection_id":"82694619","insp_unit_id":"203008836","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"JETC","insp_unit_company":null,"insp_unit_license":"CX6092","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5JNSS4538GH000478","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:52.000000Z","updated_at":"2025-03-17T23:35:52.000000Z"}]},{"id":6732756,"change_date":"2024-09-16 21:42:00","inspection_id":"82666402","dot_number":"1031889","report_state":"SD","report_number":"5430000895","insp_date":"2024-09-16 00:00:00","insp_start_time":"0951","insp_end_time":"1017","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"CANTON SD","county_code_state":"SD","county_code":"083","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-09-16 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"124000","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":"851956","transaction_code":"A","transaction_date":"2024-09-16 00:00:00","upload_date":"2024-09-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01031889","upload_search_indicator":null,"census_search_date":"2024-09-16 21:42:00","snet_input_date":"2024-09-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-09-16 21:42:00","insp_carrier_name":"VALLEY SAND & GRAVEL INC","insp_carrier_street":"2015 N MAIN","insp_carrier_city":"ROCK VALLEY","insp_carrier_state":"IA","insp_carrier_zip_code":"51247","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:36:32.000000Z","updated_at":"2025-03-17T20:36:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10856653,"change_date":"2024-09-16 21:42:00","inspection_id":"82666402","insp_unit_id":"202935953","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"31","insp_unit_license":"FJ1943","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XPBDP9X2FD306445","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:28.000000Z","updated_at":"2025-03-17T23:35:28.000000Z"},{"id":10856654,"change_date":"2024-09-16 21:42:00","inspection_id":"82666402","insp_unit_id":"202935954","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"BR5162","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5MC424210F3147368","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:28.000000Z","updated_at":"2025-03-17T23:35:28.000000Z"}]},{"id":6592553,"change_date":"2024-08-29 21:42:00","inspection_id":"82517089","dot_number":"1031889","report_state":"SD","report_number":"HP10600022","insp_date":"2024-08-29 00:00:00","insp_start_time":"0958","insp_end_time":"1008","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"SIOUX FALLS SD","county_code_state":"SD","county_code":"083","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"KNIFE RIVER","shipping_paper_number":"32260922","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-08-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"114000","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":"796181","transaction_code":"A","transaction_date":"2024-08-29 00:00:00","upload_date":"2024-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01031889","upload_search_indicator":null,"census_search_date":"2024-08-29 21:42:00","snet_input_date":"2024-08-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-29 21:42:00","insp_carrier_name":"VALLEY SAND & GRAVEL INC","insp_carrier_street":"2015 N MAIN","insp_carrier_city":"ROCK VALLEY","insp_carrier_state":"IA","insp_carrier_zip_code":"51247","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:33:40.000000Z","updated_at":"2025-03-17T20:33:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10628604,"change_date":"2024-08-29 21:42:00","inspection_id":"82517089","insp_unit_id":"202645488","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"44","insp_unit_license":"VF3068","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XPCDP9X0LD663445","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:04.000000Z","updated_at":"2025-03-17T23:33:04.000000Z"},{"id":10628605,"change_date":"2024-08-29 21:42:00","inspection_id":"82517089","insp_unit_id":"202645489","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"JET STREAM","insp_unit_company":"T11","insp_unit_license":"JP6493","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5JNSS4534GH000462","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:04.000000Z","updated_at":"2025-03-17T23:33:04.000000Z"}]},{"id":6007911,"change_date":"2024-06-17 21:43:00","inspection_id":"81891061","dot_number":"1031889","report_state":"IA","report_number":"000P13DL9Q","insp_date":"2024-06-14 00:00:00","insp_start_time":"0850","insp_end_time":"0925","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 18 & COOLIDGE AVE - EB","county_code_state":"IA","county_code":"167","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"VALLEY SAND & GRAVEL","shipping_paper_number":"NA","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":"N","pen_cen_match":null,"final_status_date":"2024-06-17 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"130000","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1316948","transaction_code":"A","transaction_date":"2024-06-17 00:00:00","upload_date":"2024-06-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01031889","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-06-14 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-06-17 21:43:00","insp_carrier_name":"VALLEY SAND & GRAVEL INC","insp_carrier_street":"2015 N MAIN","insp_carrier_city":"ROCK VALLEY","insp_carrier_state":"IA","insp_carrier_zip_code":"51247","insp_colonia":null,"docket_number":"435489","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:21:51.000000Z","updated_at":"2025-03-17T20:21:51.000000Z","inspection_violations":[{"id":9320565,"change_date":"2024-06-17 21:43:00","inspection_id":"81891061","insp_violation_id":"260123277","seq_no":"1","part_no":"392","part_no_section":"82(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:07.000000Z","updated_at":"2025-03-17T21:51:07.000000Z","normalized_code":"39282A1"},{"id":9320566,"change_date":"2024-06-17 21:43:00","inspection_id":"81891061","insp_violation_id":"260123278","seq_no":"2","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":"7HIL24061409100","created_at":"2025-03-17T21:51:07.000000Z","updated_at":"2025-03-17T21:51:07.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9676610,"change_date":"2024-06-17 21:43:00","inspection_id":"81891061","insp_unit_id":"201429156","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"34A","insp_unit_license":"FW2884","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XPCD49X0KD262166","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:18.000000Z","updated_at":"2025-03-17T23:23:18.000000Z"},{"id":9676611,"change_date":"2024-06-17 21:43:00","inspection_id":"81891061","insp_unit_id":"201429157","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"JETCO","insp_unit_company":"T10","insp_unit_license":"EM4523","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5JNSS4530GH000488","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:18.000000Z","updated_at":"2025-03-17T23:23:18.000000Z"}]},{"id":5598478,"change_date":"2024-04-25 21:43:00","inspection_id":"81446310","dot_number":"1031889","report_state":"IA","report_number":"000P15PGQP","insp_date":"2024-04-24 00:00:00","insp_start_time":"0926","insp_end_time":"0946","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 3 & 180TH NB AKRON","county_code_state":"IA","county_code":"149","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"VSG","shipping_paper_number":"EMPTY","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":"N","pen_cen_match":null,"final_status_date":"2024-04-25 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"1310682","transaction_code":"A","transaction_date":"2024-04-25 00:00:00","upload_date":"2024-04-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01031889","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-04-24 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-04-25 21:43:00","insp_carrier_name":"VALLEY SAND & GRAVEL INC","insp_carrier_street":"2015 N MAIN","insp_carrier_city":"ROCK VALLEY","insp_carrier_state":"IA","insp_carrier_zip_code":"51247","insp_colonia":null,"docket_number":"435489","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:13:33.000000Z","updated_at":"2025-03-17T20:13:33.000000Z","inspection_violations":[{"id":8655669,"change_date":"2024-04-25 21:43:00","inspection_id":"81446310","insp_violation_id":"259144537","seq_no":"1","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:47:53.000000Z","updated_at":"2025-03-17T21:47:53.000000Z","normalized_code":"3922"},{"id":8655670,"change_date":"2024-04-25 21:43:00","inspection_id":"81446310","insp_violation_id":"259144538","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"200578645","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:53.000000Z","updated_at":"2025-03-17T21:47:53.000000Z","normalized_code":"39311"},{"id":8655671,"change_date":"2024-04-25 21:43:00","inspection_id":"81446310","insp_violation_id":"259144539","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"200578646","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:53.000000Z","updated_at":"2025-03-17T21:47:53.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":9017830,"change_date":"2024-04-25 21:43:00","inspection_id":"81446310","insp_unit_id":"200578645","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"58","insp_unit_license":"VA7257","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XPWDP9X4DD183116","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:54.000000Z","updated_at":"2025-03-17T23:16:54.000000Z"},{"id":9017831,"change_date":"2024-04-25 21:43:00","inspection_id":"81446310","insp_unit_id":"200578646","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CUSM","insp_unit_company":"T8","insp_unit_license":"CX6092","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5JNSS4538GH000478","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:54.000000Z","updated_at":"2025-03-17T23:16:54.000000Z"}]},{"id":4669440,"change_date":"2023-12-20 21:41:00","inspection_id":"80432008","dot_number":"1031889","report_state":"SD","report_number":"5310000154","insp_date":"2023-12-20 00:00:00","insp_start_time":"0856","insp_end_time":"0905","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"CANTON SD","county_code_state":"SD","county_code":"083","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","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":"U","pen_cen_match":"I","final_status_date":"2023-12-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"58470","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":"138390","transaction_code":"A","transaction_date":"2023-12-20 00:00:00","upload_date":"2023-12-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01031889","upload_search_indicator":null,"census_search_date":"2023-12-20 21:41:00","snet_input_date":"2023-12-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-12-20 21:41:00","insp_carrier_name":"VALLEY SAND & GRAVEL INC","insp_carrier_street":"2015 N MAIN","insp_carrier_city":"ROCK VALLEY","insp_carrier_state":"IA","insp_carrier_zip_code":"51247","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:55:23.000000Z","updated_at":"2025-03-17T19:55:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7510234,"change_date":"2023-12-20 21:41:00","inspection_id":"80432008","insp_unit_id":"198588011","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"27A","insp_unit_license":"VE8261","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"2NP3LN0X4EM218038","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:09.000000Z","updated_at":"2025-03-17T23:03:09.000000Z"}]},{"id":4527741,"change_date":"2023-11-30 21:38:00","inspection_id":"80276431","dot_number":"1031889","report_state":"IA","report_number":"000P11021Q","insp_date":"2023-11-29 00:00:00","insp_start_time":"1025","insp_end_time":"1040","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 75 NB AT 300TH","county_code_state":"IA","county_code":"167","insp_level_id":"3","service_center":"MW","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-30 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"134000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1295213","transaction_code":"A","transaction_date":"2023-11-30 00:00:00","upload_date":"2023-11-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01031889","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-11-29 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-11-30 21:38:00","insp_carrier_name":"VALLEY SAND & GRAVEL INC","insp_carrier_street":"2015 N MAIN","insp_carrier_city":"ROCK VALLEY","insp_carrier_state":"IA","insp_carrier_zip_code":"51247","insp_colonia":null,"docket_number":"435489","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:52:34.000000Z","updated_at":"2025-03-17T19:52:34.000000Z","inspection_violations":[{"id":7005574,"change_date":"2023-11-30 21:38:00","inspection_id":"80276431","insp_violation_id":"256640641","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:48.000000Z","updated_at":"2025-03-17T21:39:48.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7281889,"change_date":"2023-11-30 21:38:00","inspection_id":"80276431","insp_unit_id":"198284272","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"64A","insp_unit_license":"VF3070","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XPBD49X5LD633657","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:10.000000Z","updated_at":"2025-03-17T23:01:10.000000Z"},{"id":7281890,"change_date":"2023-11-30 21:38:00","inspection_id":"80276431","insp_unit_id":"198284273","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MANAC","insp_unit_company":"26","insp_unit_license":"JP6491","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5MC424213H3167598","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:10.000000Z","updated_at":"2025-03-17T23:01:10.000000Z"}]},{"id":2337042,"change_date":"2023-02-09 21:40:00","inspection_id":"77817009","dot_number":"1031889","report_state":"IA","report_number":"000TT87SRG","insp_date":"2023-02-08 00:00:00","insp_start_time":"0951","insp_end_time":"1018","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 18 WB AND 290TH ST","county_code_state":"IA","county_code":"167","insp_level_id":"3","service_center":"MW","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":"2023-02-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"55000","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1262050","transaction_code":"A","transaction_date":"2023-02-09 00:00:00","upload_date":"2023-02-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01031889","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-02-08 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-02-09 21:40:00","insp_carrier_name":"VALLEY SAND & GRAVEL INC","insp_carrier_street":"2015 N MAIN","insp_carrier_city":"ROCK VALLEY","insp_carrier_state":"IA","insp_carrier_zip_code":"51247","insp_colonia":null,"docket_number":"435489","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:09:40.000000Z","updated_at":"2025-03-17T19:09:40.000000Z","inspection_violations":[{"id":3599945,"change_date":"2023-02-09 21:40:00","inspection_id":"77817009","insp_violation_id":"251048559","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:23:57.000000Z","updated_at":"2025-03-17T21:23:57.000000Z","normalized_code":"3922"},{"id":3599946,"change_date":"2023-02-09 21:40:00","inspection_id":"77817009","insp_violation_id":"251048560","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":"T10823020810075","created_at":"2025-03-17T21:23:57.000000Z","updated_at":"2025-03-17T21:23:57.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3760412,"change_date":"2023-02-09 21:40:00","inspection_id":"77817009","insp_unit_id":"193319490","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"46","insp_unit_license":"VC6505","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"2NP3LJ0X0KM268214","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:57.000000Z","updated_at":"2025-03-17T22:32:57.000000Z"}]},{"id":1100592,"change_date":"2022-08-22 21:42:00","inspection_id":"76395274","dot_number":"1031889","report_state":"SD","report_number":"HP19204390","insp_date":"2022-08-17 00:00:00","insp_start_time":"1530","insp_end_time":"1540","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"SD","county_code":"083","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"N\/A","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-08-22 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"124000","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":"624720","transaction_code":"A","transaction_date":"2022-08-22 00:00:00","upload_date":"2022-08-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01031889","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-08-22 00:00:00","source_office":"4SDS001","mcmis_add_date":"2022-08-22 21:42:00","insp_carrier_name":"VALLEY SAND & GRAVEL INC","insp_carrier_street":"2015 N MAIN","insp_carrier_city":"ROCK VALLEY","insp_carrier_state":"IA","insp_carrier_zip_code":"51247","insp_colonia":null,"docket_number":"435489","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:47:11.000000Z","updated_at":"2025-03-17T18:47:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1770373,"change_date":"2022-08-22 21:42:00","inspection_id":"76395274","insp_unit_id":"190461566","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETR","insp_unit_company":"32A","insp_unit_license":"VF3065","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XPWD49X18D758390","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:11.000000Z","updated_at":"2025-03-17T22:19:11.000000Z"},{"id":1770374,"change_date":"2022-08-22 21:42:00","inspection_id":"76395274","insp_unit_id":"190461567","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"JETS","insp_unit_company":"NONE","insp_unit_license":"CH7797","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5JNSS4536GH00048","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:11.000000Z","updated_at":"2025-03-17T22:19:11.000000Z"}]},{"id":721549,"change_date":"2022-06-29 21:42:00","inspection_id":"75952038","dot_number":"1031889","report_state":"SD","report_number":"022A011422","insp_date":"2022-06-29 00:00:00","insp_start_time":"1404","insp_end_time":"1428","registration_date":null,"region":"CT","ci_status_code":"C","location":"CANTON","location_desc":"CANTON PULL OFF","county_code_state":"SD","county_code":"083","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"VALLEY SAND AND GRAVEL","shipping_paper_number":"G357902","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":"I","final_status_date":"2022-06-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"621028","transaction_code":"A","transaction_date":"2022-06-29 00:00:00","upload_date":"2022-06-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01031889","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-06-29 00:00:00","source_office":"4SDS001","mcmis_add_date":"2022-06-29 21:42:00","insp_carrier_name":"VALLEY SAND & GRAVEL INC","insp_carrier_street":"2015 N MAIN","insp_carrier_city":"ROCK VALLEY","insp_carrier_state":"IA","insp_carrier_zip_code":"51247","insp_colonia":null,"docket_number":"435489","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:40:29.000000Z","updated_at":"2025-03-17T18:40:29.000000Z","inspection_violations":[{"id":1135339,"change_date":"2022-06-29 21:42:00","inspection_id":"75952038","insp_violation_id":"246801935","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"189531298","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"B877694","created_at":"2025-03-17T21:12:17.000000Z","updated_at":"2025-03-17T21:12:17.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1159885,"change_date":"2022-06-29 21:42:00","inspection_id":"75952038","insp_unit_id":"189531298","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"VE4377","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"2NP3LN0X6DM189253","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:19.000000Z","updated_at":"2025-03-17T22:15:19.000000Z"}]},{"id":718164,"change_date":"2022-06-29 21:41:00","inspection_id":"75948046","dot_number":"1031889","report_state":"IA","report_number":"000P13DKZ9","insp_date":"2022-06-24 00:00:00","insp_start_time":"1310","insp_end_time":"1408","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 18 EB JWO JAY AVE. - BOYDE","county_code_state":"IA","county_code":"167","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"VALLEY SAND & GRAVEL","shipping_paper_number":"NA","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":"N","pen_cen_match":null,"final_status_date":"2022-06-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"142000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1230669","transaction_code":"A","transaction_date":"2022-06-29 00:00:00","upload_date":"2022-06-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01031889","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-06-24 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-06-29 21:41:00","insp_carrier_name":"VALLEY SAND & GRAVEL INC","insp_carrier_street":"2015 N MAIN","insp_carrier_city":"ROCK VALLEY","insp_carrier_state":"IA","insp_carrier_zip_code":"51247","insp_colonia":null,"docket_number":"435489","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:40:14.000000Z","updated_at":"2025-03-17T18:40:14.000000Z","inspection_violations":[{"id":1127844,"change_date":"2022-06-29 21:41:00","inspection_id":"75948046","insp_violation_id":"246790116","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"43","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"7HIL22062413593","created_at":"2025-03-17T21:12:17.000000Z","updated_at":"2025-03-17T21:12:17.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1154280,"change_date":"2022-06-29 21:41:00","inspection_id":"75948046","insp_unit_id":"189523164","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"54A","insp_unit_license":"SG9831","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XPCPP0XXKD608889","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:17.000000Z","updated_at":"2025-03-17T22:15:17.000000Z"},{"id":1154281,"change_date":"2022-06-29 21:41:00","inspection_id":"75948046","insp_unit_id":"189523165","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"JETCO","insp_unit_company":"T17","insp_unit_license":"CT4439","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5JNSS4532GH000461","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:17.000000Z","updated_at":"2025-03-17T22:15:17.000000Z"}]},{"id":193403,"change_date":"2022-04-18 21:41:00","inspection_id":"75323677","dot_number":"1031889","report_state":"IA","report_number":"000TT6P01G","insp_date":"2022-04-15 00:00:00","insp_start_time":"1105","insp_end_time":"1150","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"L22 AND 370TH","county_code_state":"IA","county_code":"167","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"VALLEY SAND AND GRAVEL","shipping_paper_number":"SAND","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":"N","pen_cen_match":null,"final_status_date":"2022-04-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"138460","viol_total":"3","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1220413","transaction_code":"A","transaction_date":"2022-04-18 00:00:00","upload_date":"2022-04-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01031889","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-04-15 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-04-18 21:41:00","insp_carrier_name":"VALLEY SAND & GRAVEL INC","insp_carrier_street":"2015 N MAIN","insp_carrier_city":"ROCK VALLEY","insp_carrier_state":"IA","insp_carrier_zip_code":"51247","insp_colonia":null,"docket_number":"435489","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:30:53.000000Z","updated_at":"2025-03-17T18:30:53.000000Z","inspection_violations":[{"id":295143,"change_date":"2022-04-18 21:41:00","inspection_id":"75323677","insp_violation_id":"245207266","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":"T40422041511384","created_at":"2025-03-17T21:08:23.000000Z","updated_at":"2025-03-17T21:08:23.000000Z","normalized_code":"3922"},{"id":295144,"change_date":"2022-04-18 21:41:00","inspection_id":"75323677","insp_violation_id":"245207267","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":"T40422041511392","created_at":"2025-03-17T21:08:23.000000Z","updated_at":"2025-03-17T21:08:23.000000Z","normalized_code":"3922"},{"id":295145,"change_date":"2022-04-18 21:41:00","inspection_id":"75323677","insp_violation_id":"245207268","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:23.000000Z","updated_at":"2025-03-17T21:08:23.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":313246,"change_date":"2022-04-18 21:41:00","inspection_id":"75323677","insp_unit_id":"188195875","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"34","insp_unit_license":"VF3066","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XPHP49X6AD102434","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:04.000000Z","updated_at":"2025-03-17T22:10:04.000000Z"},{"id":313247,"change_date":"2022-04-18 21:41:00","inspection_id":"75323677","insp_unit_id":"188195876","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"JETC","insp_unit_company":"T10","insp_unit_license":"EM4523","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5JNSS4530GH000488","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:04.000000Z","updated_at":"2025-03-17T22:10:04.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1031889\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1031889\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1031889\/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\/1031889\/inspections","per_page":100,"prev_page_url":null,"to":16,"total":16}