{"current_page":1,"data":[{"id":8120699,"change_date":"2025-03-14 21:40:00","inspection_id":"84130743","dot_number":"1045757","report_state":"IA","report_number":"000P11H61M","insp_date":"2025-03-13 00:00:00","insp_start_time":"1117","insp_end_time":"1130","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 63SB AND HWY 93","county_code_state":"IA","county_code":"017","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"RAYS EXCAVATING","shipping_paper_number":"264009","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-03-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"8","oos_total":"2","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1352763","transaction_code":"A","transaction_date":"2025-03-14 00:00:00","upload_date":"2025-03-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01045757","upload_search_indicator":"M","census_search_date":"2025-03-14 21:40:00","snet_input_date":"2025-03-13 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-03-14 21:40:00","insp_carrier_name":"RAY'S EXCAVATING LLC","insp_carrier_street":"404 E UNION ST","insp_carrier_city":"EDGEWOOD","insp_carrier_state":"IA","insp_carrier_zip_code":"52042","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T21:07:02.000000Z","updated_at":"2025-03-17T21:07:02.000000Z","inspection_violations":[{"id":12698762,"change_date":"2025-03-14 21:40:00","inspection_id":"84130743","insp_violation_id":"265048744","seq_no":"1","part_no":"393","part_no_section":"23PT","insp_viol_unit":"2","insp_unit_id":"205809700","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:08:10.000000Z","updated_at":"2025-03-17T22:08:10.000000Z","normalized_code":"39323PT"},{"id":12698763,"change_date":"2025-03-14 21:40:00","inspection_id":"84130743","insp_violation_id":"265048745","seq_no":"2","part_no":"393","part_no_section":"100B-C","insp_viol_unit":"2","insp_unit_id":"205809700","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"2HUI25031311240","created_at":"2025-03-17T22:08:10.000000Z","updated_at":"2025-03-17T22:08:10.000000Z","normalized_code":"393100BC"},{"id":12698764,"change_date":"2025-03-14 21:40:00","inspection_id":"84130743","insp_violation_id":"265048746","seq_no":"3","part_no":"393","part_no_section":"11TL","insp_viol_unit":"1","insp_unit_id":"205809699","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:08:10.000000Z","updated_at":"2025-03-17T22:08:10.000000Z","normalized_code":"39311TL"},{"id":12698765,"change_date":"2025-03-14 21:40:00","inspection_id":"84130743","insp_violation_id":"265048747","seq_no":"4","part_no":"393","part_no_section":"45D","insp_viol_unit":"1","insp_unit_id":"205809699","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:08:10.000000Z","updated_at":"2025-03-17T22:08:10.000000Z","normalized_code":"39345D"},{"id":12698766,"change_date":"2025-03-14 21:40:00","inspection_id":"84130743","insp_violation_id":"265048748","seq_no":"5","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"205809699","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:08:10.000000Z","updated_at":"2025-03-17T22:08:10.000000Z","normalized_code":"3965B"},{"id":12698767,"change_date":"2025-03-14 21:40:00","inspection_id":"84130743","insp_violation_id":"265048749","seq_no":"6","part_no":"392","part_no_section":"2-SLLEWA3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"2HUI25031311271","created_at":"2025-03-17T22:08:10.000000Z","updated_at":"2025-03-17T22:08:10.000000Z","normalized_code":"3922SLLEWA3"},{"id":12698768,"change_date":"2025-03-14 21:40:00","inspection_id":"84130743","insp_violation_id":"265048750","seq_no":"7","part_no":"392","part_no_section":"2-SLLEWA2","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-17T22:08:10.000000Z","updated_at":"2025-03-17T22:08:10.000000Z","normalized_code":"3922SLLEWA2"},{"id":12698769,"change_date":"2025-03-14 21:40:00","inspection_id":"84130743","insp_violation_id":"265048751","seq_no":"8","part_no":"392","part_no_section":"2-SLLEWA1","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-17T22:08:10.000000Z","updated_at":"2025-03-17T22:08:10.000000Z","normalized_code":"3922SLLEWA1"}],"inspection_per_units":[{"id":13111666,"change_date":"2025-03-14 21:40:00","inspection_id":"84130743","insp_unit_id":"205809699","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"30","insp_unit_license":"IY8374","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKDDB9X95R095571","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:57.000000Z","updated_at":"2025-03-17T23:59:57.000000Z"},{"id":13111667,"change_date":"2025-03-14 21:40:00","inspection_id":"84130743","insp_unit_id":"205809700","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CUSM","insp_unit_company":"1005","insp_unit_license":"HT3398","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1D9FS4028BP688561","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:57.000000Z","updated_at":"2025-03-17T23:59:57.000000Z"}]},{"id":7404836,"change_date":"2024-12-12 21:41:00","inspection_id":"83378765","dot_number":"1045757","report_state":"IA","report_number":"000P12Q7NB","insp_date":"2024-12-10 00:00:00","insp_start_time":"0930","insp_end_time":"1010","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"N LOCUST ST AND HWY 3 EDGEWOOD","county_code_state":"IA","county_code":"043","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"RAY'S EXCAVATING","shipping_paper_number":"BLACKTOP MILLIN","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-12-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"6","oos_total":"0","driver_viol_total":"6","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1341557","transaction_code":"A","transaction_date":"2024-12-12 00:00:00","upload_date":"2024-12-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01045757","upload_search_indicator":"M","census_search_date":"2024-12-12 21:41:00","snet_input_date":"2024-12-10 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-12-12 21:41:00","insp_carrier_name":"RAY'S EXCAVATING LLC","insp_carrier_street":"404 E UNION ST","insp_carrier_city":"EDGEWOOD","insp_carrier_state":"IA","insp_carrier_zip_code":"52042","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:50:44.000000Z","updated_at":"2025-03-17T20:50:44.000000Z","inspection_violations":[{"id":11570324,"change_date":"2024-12-12 21:41:00","inspection_id":"83378765","insp_violation_id":"263419302","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"2DRI24121009541","created_at":"2025-03-17T22:02:20.000000Z","updated_at":"2025-03-17T22:02:20.000000Z","normalized_code":"3922SLLEWA1"},{"id":11570325,"change_date":"2024-12-12 21:41:00","inspection_id":"83378765","insp_violation_id":"263419303","seq_no":"2","part_no":"392","part_no_section":"2-SLLEWA1","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-17T22:02:20.000000Z","updated_at":"2025-03-17T22:02:20.000000Z","normalized_code":"3922SLLEWA1"},{"id":11570326,"change_date":"2024-12-12 21:41:00","inspection_id":"83378765","insp_violation_id":"263419304","seq_no":"3","part_no":"392","part_no_section":"2-SLLEWA3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"2DRI24121009554","created_at":"2025-03-17T22:02:20.000000Z","updated_at":"2025-03-17T22:02:20.000000Z","normalized_code":"3922SLLEWA3"},{"id":11570327,"change_date":"2024-12-12 21:41:00","inspection_id":"83378765","insp_violation_id":"263419305","seq_no":"4","part_no":"392","part_no_section":"2-SLLEWA3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"2DRI24121009573","created_at":"2025-03-17T22:02:20.000000Z","updated_at":"2025-03-17T22:02:20.000000Z","normalized_code":"3922SLLEWA3"},{"id":11570328,"change_date":"2024-12-12 21:41:00","inspection_id":"83378765","insp_violation_id":"263419306","seq_no":"5","part_no":"392","part_no_section":"2-SLLEWA1","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-17T22:02:20.000000Z","updated_at":"2025-03-17T22:02:20.000000Z","normalized_code":"3922SLLEWA1"},{"id":11570329,"change_date":"2024-12-12 21:41:00","inspection_id":"83378765","insp_violation_id":"263419307","seq_no":"6","part_no":"392","part_no_section":"2-SLLEWG3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"2DRI24121009583","created_at":"2025-03-17T22:02:20.000000Z","updated_at":"2025-03-17T22:02:20.000000Z","normalized_code":"3922SLLEWG3"}],"inspection_per_units":[{"id":11945392,"change_date":"2024-12-12 21:41:00","inspection_id":"83378765","insp_unit_id":"204347360","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"22","insp_unit_license":"KE7127","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XP5DB9X13D803370","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:54.000000Z","updated_at":"2025-03-17T23:46:54.000000Z"},{"id":11945393,"change_date":"2024-12-12 21:41:00","inspection_id":"83378765","insp_unit_id":"204347361","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"SIDUMPR","insp_unit_company":"1","insp_unit_license":"HT3398","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1D9FS4028BP688561","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:54.000000Z","updated_at":"2025-03-17T23:46:54.000000Z"}]},{"id":6310835,"change_date":"2024-07-25 21:44:00","inspection_id":"82216518","dot_number":"1045757","report_state":"IA","report_number":"000P15V99B","insp_date":"2024-07-24 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 13 SB MARION","county_code_state":"IA","county_code":"113","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","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":"N","pen_cen_match":null,"final_status_date":"2024-07-25 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1322364","transaction_code":"A","transaction_date":"2024-07-25 00:00:00","upload_date":"2024-07-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01045757","upload_search_indicator":"M","census_search_date":"2024-07-25 21:44:00","snet_input_date":"2024-07-24 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-07-25 21:44:00","insp_carrier_name":"RAY'S EXCAVATING LLC","insp_carrier_street":"404 E UNION ST","insp_carrier_city":"EDGEWOOD","insp_carrier_state":"IA","insp_carrier_zip_code":"52042","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:27:51.000000Z","updated_at":"2025-03-17T20:27:51.000000Z","inspection_violations":[{"id":9798304,"change_date":"2024-07-25 21:44:00","inspection_id":"82216518","insp_violation_id":"260842812","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"202072872","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:22.000000Z","updated_at":"2025-03-17T21:53:22.000000Z","normalized_code":"3922"},{"id":9798305,"change_date":"2024-07-25 21:44:00","inspection_id":"82216518","insp_violation_id":"260842813","seq_no":"2","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"202072871","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:22.000000Z","updated_at":"2025-03-17T21:53:22.000000Z","normalized_code":"39395A"},{"id":9798306,"change_date":"2024-07-25 21:44:00","inspection_id":"82216518","insp_violation_id":"260842814","seq_no":"3","part_no":"393","part_no_section":"104(f)(3)","insp_viol_unit":"2","insp_unit_id":"202072872","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:22.000000Z","updated_at":"2025-03-17T21:53:22.000000Z","normalized_code":"393104F3"},{"id":9798307,"change_date":"2024-07-25 21:44:00","inspection_id":"82216518","insp_violation_id":"260842815","seq_no":"4","part_no":"393","part_no_section":"130","insp_viol_unit":"2","insp_unit_id":"202072872","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:53:22.000000Z","updated_at":"2025-03-17T21:53:22.000000Z","normalized_code":"393130"},{"id":9798308,"change_date":"2024-07-25 21:44:00","inspection_id":"82216518","insp_violation_id":"260842816","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202072871","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:22.000000Z","updated_at":"2025-03-17T21:53:22.000000Z","normalized_code":"3939A"},{"id":9798309,"change_date":"2024-07-25 21:44:00","inspection_id":"82216518","insp_violation_id":"260842817","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202072871","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:22.000000Z","updated_at":"2025-03-17T21:53:22.000000Z","normalized_code":"3939A"},{"id":9798310,"change_date":"2024-07-25 21:44:00","inspection_id":"82216518","insp_violation_id":"260842818","seq_no":"7","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"202072871","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:22.000000Z","updated_at":"2025-03-17T21:53:22.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":10168480,"change_date":"2024-07-25 21:44:00","inspection_id":"82216518","insp_unit_id":"202072871","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"16","insp_unit_license":"GJ3171","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XP5D49X04D815751","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:19.000000Z","updated_at":"2025-03-17T23:28:19.000000Z"},{"id":10168481,"change_date":"2024-07-25 21:44:00","inspection_id":"82216518","insp_unit_id":"202072872","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LOAK","insp_unit_company":"LOWBOY1","insp_unit_license":"EN8643","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5LKL5335181027027","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:19.000000Z","updated_at":"2025-03-17T23:28:19.000000Z"}]},{"id":3201522,"change_date":"2023-06-02 21:41:00","inspection_id":"78798075","dot_number":"1045757","report_state":"IA","report_number":"000TT7D7FD","insp_date":"2023-06-01 00:00:00","insp_start_time":"1435","insp_end_time":"1500","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 13 AND 350TH STRAWBERRY PO","county_code_state":"IA","county_code":"043","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"RAY'S EXCAVATING","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":"2023-06-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"56000","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":"1277782","transaction_code":"A","transaction_date":"2023-06-02 00:00:00","upload_date":"2023-06-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01045757","upload_search_indicator":"M","census_search_date":"2023-06-02 21:41:00","snet_input_date":"2023-06-01 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-06-02 21:41:00","insp_carrier_name":"RAY'S EXCAVATING LLC","insp_carrier_street":"404 E UNION ST","insp_carrier_city":"EDGEWOOD","insp_carrier_state":"IA","insp_carrier_zip_code":"52042","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:26:26.000000Z","updated_at":"2025-03-17T19:26:26.000000Z","inspection_violations":[{"id":4931648,"change_date":"2023-06-02 21:41:00","inspection_id":"78798075","insp_violation_id":"253236872","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:56.000000Z","updated_at":"2025-03-17T21:29:56.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":5149279,"change_date":"2023-06-02 21:41:00","inspection_id":"78798075","insp_unit_id":"195279599","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"312","insp_unit_license":"MQA013","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1M2P267C4VM032179","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:34.000000Z","updated_at":"2025-03-17T22:43:34.000000Z"}]},{"id":1344084,"change_date":"2022-09-22 21:40:00","inspection_id":"76678000","dot_number":"1045757","report_state":"IA","report_number":"000TT6JGWQ","insp_date":"2022-09-21 00:00:00","insp_start_time":"0755","insp_end_time":"0800","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 218 NB","county_code_state":"IA","county_code":"011","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","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":"N","pen_cen_match":null,"final_status_date":"2022-09-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1243324","transaction_code":"A","transaction_date":"2022-09-22 00:00:00","upload_date":"2022-09-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01045757","upload_search_indicator":"M","census_search_date":"2022-09-22 21:40:00","snet_input_date":"2022-09-21 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-09-22 21:40:00","insp_carrier_name":"RAY'S EXCAVATING LLC","insp_carrier_street":"404 E UNION ST","insp_carrier_city":"EDGEWOOD","insp_carrier_state":"IA","insp_carrier_zip_code":"52042","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:51:36.000000Z","updated_at":"2025-03-17T18:51:36.000000Z","inspection_violations":[{"id":2128803,"change_date":"2022-09-22 21:40:00","inspection_id":"76678000","insp_violation_id":"248584744","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:16:45.000000Z","updated_at":"2025-03-17T21:16:45.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2164110,"change_date":"2022-09-22 21:40:00","inspection_id":"76678000","insp_unit_id":"191042769","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"1","insp_unit_license":"GP5977","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3HSDJSNR1GN261342","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:48.000000Z","updated_at":"2025-03-17T22:21:48.000000Z"},{"id":2164111,"change_date":"2022-09-22 21:40:00","inspection_id":"76678000","insp_unit_id":"191042770","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MATE","insp_unit_company":"2","insp_unit_license":"GF5906","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"19BEF1411HCA17104","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:48.000000Z","updated_at":"2025-03-17T22:21:48.000000Z"}]},{"id":1204870,"change_date":"2022-09-02 21:38:00","inspection_id":"76516205","dot_number":"1045757","report_state":"IA","report_number":"000TT6JGV8","insp_date":"2022-09-01 00:00:00","insp_start_time":"0745","insp_end_time":"0810","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"W 3RD ST","county_code_state":"IA","county_code":"011","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"WENDLING QUARRIES","shipping_paper_number":"39825","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-09-02 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"9","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"9","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1240448","transaction_code":"A","transaction_date":"2022-09-02 00:00:00","upload_date":"2022-09-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01045757","upload_search_indicator":"M","census_search_date":"2022-09-02 21:38:00","snet_input_date":"2022-09-01 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-09-02 21:38:00","insp_carrier_name":"RAY'S EXCAVATING LLC","insp_carrier_street":"404 E UNION ST","insp_carrier_city":"EDGEWOOD","insp_carrier_state":"IA","insp_carrier_zip_code":"52042","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:48:57.000000Z","updated_at":"2025-03-17T18:48:57.000000Z","inspection_violations":[{"id":1910945,"change_date":"2022-09-02 21:38:00","inspection_id":"76516205","insp_violation_id":"248195343","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190706567","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:49.000000Z","updated_at":"2025-03-17T21:15:49.000000Z","normalized_code":"3939A"},{"id":1910946,"change_date":"2022-09-02 21:38:00","inspection_id":"76516205","insp_violation_id":"248195344","seq_no":"2","part_no":"393","part_no_section":"19","insp_viol_unit":"1","insp_unit_id":"190706567","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:49.000000Z","updated_at":"2025-03-17T21:15:49.000000Z","normalized_code":"39319"},{"id":1910947,"change_date":"2022-09-02 21:38:00","inspection_id":"76516205","insp_violation_id":"248195345","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190706567","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:49.000000Z","updated_at":"2025-03-17T21:15:49.000000Z","normalized_code":"3939A"},{"id":1910948,"change_date":"2022-09-02 21:38:00","inspection_id":"76516205","insp_violation_id":"248195346","seq_no":"4","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"190706567","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:49.000000Z","updated_at":"2025-03-17T21:15:49.000000Z","normalized_code":"39311"},{"id":1910949,"change_date":"2022-09-02 21:38:00","inspection_id":"76516205","insp_violation_id":"248195347","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"190706568","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:49.000000Z","updated_at":"2025-03-17T21:15:49.000000Z","normalized_code":"3922"},{"id":1910950,"change_date":"2022-09-02 21:38:00","inspection_id":"76516205","insp_violation_id":"248195348","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"190706568","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:49.000000Z","updated_at":"2025-03-17T21:15:49.000000Z","normalized_code":"3939A"},{"id":1910951,"change_date":"2022-09-02 21:38:00","inspection_id":"76516205","insp_violation_id":"248195349","seq_no":"7","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"190706568","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:49.000000Z","updated_at":"2025-03-17T21:15:49.000000Z","normalized_code":"39348A"},{"id":1910952,"change_date":"2022-09-02 21:38:00","inspection_id":"76516205","insp_violation_id":"248195350","seq_no":"8","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"190706568","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:49.000000Z","updated_at":"2025-03-17T21:15:49.000000Z","normalized_code":"3963A1"},{"id":1910953,"change_date":"2022-09-02 21:38:00","inspection_id":"76516205","insp_violation_id":"248195351","seq_no":"9","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"190706568","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"T31622090108041","created_at":"2025-03-17T21:15:49.000000Z","updated_at":"2025-03-17T21:15:49.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":1937571,"change_date":"2022-09-02 21:38:00","inspection_id":"76516205","insp_unit_id":"190706567","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"1","insp_unit_license":"GP5977","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3HSDJSNR1GN261342","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:19.000000Z","updated_at":"2025-03-17T22:20:19.000000Z"},{"id":1937572,"change_date":"2022-09-02 21:38:00","inspection_id":"76516205","insp_unit_id":"190706568","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MATE","insp_unit_company":"1","insp_unit_license":"GE5906","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1M9B39228HH036693","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:19.000000Z","updated_at":"2025-03-17T22:20:19.000000Z"}]},{"id":943092,"change_date":"2022-08-02 21:40:00","inspection_id":"76211195","dot_number":"1045757","report_state":"IA","report_number":"000TT7D6Q6","insp_date":"2022-08-01 00:00:00","insp_start_time":"0915","insp_end_time":"0945","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 150 AND KLOCK RD FAYETTE","county_code_state":"IA","county_code":"065","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"RAY'S EXCAVATING","shipping_paper_number":"DIRT","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-08-02 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"56000","viol_total":"4","oos_total":"0","driver_viol_total":"4","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1235717","transaction_code":"A","transaction_date":"2022-08-02 00:00:00","upload_date":"2022-08-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01045757","upload_search_indicator":"M","census_search_date":"2022-08-02 21:40:00","snet_input_date":"2022-08-01 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-08-02 21:40:00","insp_carrier_name":"RAY'S EXCAVATING LLC","insp_carrier_street":"404 E UNION ST","insp_carrier_city":"EDGEWOOD","insp_carrier_state":"IA","insp_carrier_zip_code":"52042","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:44:22.000000Z","updated_at":"2025-03-17T18:44:22.000000Z","inspection_violations":[{"id":1486946,"change_date":"2022-08-02 21:40:00","inspection_id":"76211195","insp_violation_id":"247455958","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":"T11822080109312","created_at":"2025-03-17T21:14:04.000000Z","updated_at":"2025-03-17T21:14:04.000000Z","normalized_code":"3922"},{"id":1486947,"change_date":"2022-08-02 21:40:00","inspection_id":"76211195","insp_violation_id":"247455959","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":"T11822080109321","created_at":"2025-03-17T21:14:04.000000Z","updated_at":"2025-03-17T21:14:04.000000Z","normalized_code":"3922"},{"id":1486948,"change_date":"2022-08-02 21:40:00","inspection_id":"76211195","insp_violation_id":"247455960","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":"T11822080109331","created_at":"2025-03-17T21:14:04.000000Z","updated_at":"2025-03-17T21:14:04.000000Z","normalized_code":"3922"},{"id":1486949,"change_date":"2022-08-02 21:40:00","inspection_id":"76211195","insp_violation_id":"247455961","seq_no":"4","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:14:04.000000Z","updated_at":"2025-03-17T21:14:04.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1518365,"change_date":"2022-08-02 21:40:00","inspection_id":"76211195","insp_unit_id":"190085577","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"32","insp_unit_license":"GDK444","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FVHCYCS64HM16183","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:33.000000Z","updated_at":"2025-03-17T22:17:33.000000Z"}]},{"id":943074,"change_date":"2022-08-02 21:39:00","inspection_id":"76211171","dot_number":"1045757","report_state":"IA","report_number":"000TT7D6Q2","insp_date":"2022-07-29 00:00:00","insp_start_time":"0750","insp_end_time":"0815","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"CEDAR RD AND 147TH WADENA","county_code_state":"IA","county_code":"065","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"RAY'S EXCAVATING","shipping_paper_number":"EXCAVATOR","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-08-02 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"140000","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":"1235834","transaction_code":"A","transaction_date":"2022-08-02 00:00:00","upload_date":"2022-08-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01045757","upload_search_indicator":"M","census_search_date":"2022-08-02 21:39:00","snet_input_date":"2022-07-29 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-08-02 21:39:00","insp_carrier_name":"RAY'S EXCAVATING LLC","insp_carrier_street":"404 E UNION ST","insp_carrier_city":"EDGEWOOD","insp_carrier_state":"IA","insp_carrier_zip_code":"52042","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:44:22.000000Z","updated_at":"2025-03-17T18:44:22.000000Z","inspection_violations":[{"id":1486912,"change_date":"2022-08-02 21:39:00","inspection_id":"76211171","insp_violation_id":"247455901","seq_no":"1","part_no":"393","part_no_section":"87(a)","insp_viol_unit":"2","insp_unit_id":"190085538","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:14:04.000000Z","updated_at":"2025-03-17T21:14:04.000000Z","normalized_code":"39387A"},{"id":1486913,"change_date":"2022-08-02 21:39:00","inspection_id":"76211171","insp_violation_id":"247455902","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190085537","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:04.000000Z","updated_at":"2025-03-17T21:14:04.000000Z","normalized_code":"3939A"},{"id":1486914,"change_date":"2022-08-02 21:39:00","inspection_id":"76211171","insp_violation_id":"247455903","seq_no":"3","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"190085538","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:04.000000Z","updated_at":"2025-03-17T21:14:04.000000Z","normalized_code":"39345B2"},{"id":1486915,"change_date":"2022-08-02 21:39:00","inspection_id":"76211171","insp_violation_id":"247455904","seq_no":"4","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"190085537","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:04.000000Z","updated_at":"2025-03-17T21:14:04.000000Z","normalized_code":"39395A"},{"id":1486916,"change_date":"2022-08-02 21:39:00","inspection_id":"76211171","insp_violation_id":"247455905","seq_no":"5","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"190085537","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:04.000000Z","updated_at":"2025-03-17T21:14:04.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":1518335,"change_date":"2022-08-02 21:39:00","inspection_id":"76211171","insp_unit_id":"190085537","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"16","insp_unit_license":"GJ3171","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XP5D49X04D815751","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:33.000000Z","updated_at":"2025-03-17T22:17:33.000000Z"},{"id":1518336,"change_date":"2022-08-02 21:39:00","inspection_id":"76211171","insp_unit_id":"190085538","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LOAK","insp_unit_company":"LOWBOY","insp_unit_license":"EN8643","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5LKL5335181027027","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:33.000000Z","updated_at":"2025-03-17T22:17:33.000000Z"}]},{"id":582649,"change_date":"2022-06-10 21:40:00","inspection_id":"75787198","dot_number":"1045757","report_state":"IA","report_number":"000TT7DKPR","insp_date":"2022-06-09 00:00:00","insp_start_time":"1325","insp_end_time":"1410","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"WASHINGTON ST AND 5TH ST GUTTE","county_code_state":"IA","county_code":"043","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"RAY'S EXCAVATING","shipping_paper_number":"142629","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-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"56000","viol_total":"11","oos_total":"0","driver_viol_total":"9","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1228506","transaction_code":"A","transaction_date":"2022-06-10 00:00:00","upload_date":"2022-06-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01045757","upload_search_indicator":"M","census_search_date":"2022-06-10 21:40:00","snet_input_date":"2022-06-09 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-06-10 21:40:00","insp_carrier_name":"RAY'S EXCAVATING LLC","insp_carrier_street":"404 E UNION ST","insp_carrier_city":"EDGEWOOD","insp_carrier_state":"IA","insp_carrier_zip_code":"52042","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:38:03.000000Z","updated_at":"2025-03-17T18:38:03.000000Z","inspection_violations":[{"id":911071,"change_date":"2022-06-10 21:40:00","inspection_id":"75787198","insp_violation_id":"246373078","seq_no":"9","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:11:17.000000Z","updated_at":"2025-03-17T21:11:17.000000Z","normalized_code":"3922"},{"id":911072,"change_date":"2022-06-10 21:40:00","inspection_id":"75787198","insp_violation_id":"246373079","seq_no":"10","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:11:17.000000Z","updated_at":"2025-03-17T21:11:17.000000Z","normalized_code":"3922"},{"id":911073,"change_date":"2022-06-10 21:40:00","inspection_id":"75787198","insp_violation_id":"246373080","seq_no":"11","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"189176403","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:17.000000Z","updated_at":"2025-03-17T21:11:17.000000Z","normalized_code":"3922"},{"id":911074,"change_date":"2022-06-10 21:40:00","inspection_id":"75787198","insp_violation_id":"246373081","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:17.000000Z","updated_at":"2025-03-17T21:11:17.000000Z","normalized_code":"39216A"},{"id":911075,"change_date":"2022-06-10 21:40:00","inspection_id":"75787198","insp_violation_id":"246373082","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"189176403","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:17.000000Z","updated_at":"2025-03-17T21:11:17.000000Z","normalized_code":"3922"},{"id":911076,"change_date":"2022-06-10 21:40:00","inspection_id":"75787198","insp_violation_id":"246373083","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":"T11822060913502","created_at":"2025-03-17T21:11:17.000000Z","updated_at":"2025-03-17T21:11:17.000000Z","normalized_code":"3922"},{"id":911077,"change_date":"2022-06-10 21:40:00","inspection_id":"75787198","insp_violation_id":"246373084","seq_no":"4","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":"T11822060913510","created_at":"2025-03-17T21:11:17.000000Z","updated_at":"2025-03-17T21:11:17.000000Z","normalized_code":"3922"},{"id":911078,"change_date":"2022-06-10 21:40:00","inspection_id":"75787198","insp_violation_id":"246373085","seq_no":"5","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:11:17.000000Z","updated_at":"2025-03-17T21:11:17.000000Z","normalized_code":"3922"},{"id":911079,"change_date":"2022-06-10 21:40:00","inspection_id":"75787198","insp_violation_id":"246373086","seq_no":"6","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:11:17.000000Z","updated_at":"2025-03-17T21:11:17.000000Z","normalized_code":"3922"},{"id":911080,"change_date":"2022-06-10 21:40:00","inspection_id":"75787198","insp_violation_id":"246373087","seq_no":"7","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:11:17.000000Z","updated_at":"2025-03-17T21:11:17.000000Z","normalized_code":"3922"},{"id":911081,"change_date":"2022-06-10 21:40:00","inspection_id":"75787198","insp_violation_id":"246373088","seq_no":"8","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:11:17.000000Z","updated_at":"2025-03-17T21:11:17.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":935969,"change_date":"2022-06-10 21:40:00","inspection_id":"75787198","insp_unit_id":"189176403","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"32","insp_unit_license":"GDK444","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FVHCYCS64HM16183","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:58.000000Z","updated_at":"2025-03-17T22:13:58.000000Z"}]},{"id":309150,"change_date":"2022-05-03 21:39:00","inspection_id":"75462040","dot_number":"1045757","report_state":"IA","report_number":"000TT6JGJ6","insp_date":"2022-05-02 00:00:00","insp_start_time":"1230","insp_end_time":"1255","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 63 NB TRAER","county_code_state":"IA","county_code":"171","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"BULLDOZER","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":"8","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1223267","transaction_code":"A","transaction_date":"2022-05-03 00:00:00","upload_date":"2022-05-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01045757","upload_search_indicator":"M","census_search_date":"2022-05-03 21:39:00","snet_input_date":"2022-05-02 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-05-03 21:39:00","insp_carrier_name":"RAY'S EXCAVATING LLC","insp_carrier_street":"404 E UNION ST","insp_carrier_city":"EDGEWOOD","insp_carrier_state":"IA","insp_carrier_zip_code":"52042","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:32:57.000000Z","updated_at":"2025-03-17T18:32:57.000000Z","inspection_violations":[{"id":480129,"change_date":"2022-05-03 21:39:00","inspection_id":"75462040","insp_violation_id":"245535549","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"188475972","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:21.000000Z","updated_at":"2025-03-17T21:09:21.000000Z","normalized_code":"3922"},{"id":480130,"change_date":"2022-05-03 21:39:00","inspection_id":"75462040","insp_violation_id":"245535550","seq_no":"2","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"188475972","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:21.000000Z","updated_at":"2025-03-17T21:09:21.000000Z","normalized_code":"39395A"},{"id":480131,"change_date":"2022-05-03 21:39:00","inspection_id":"75462040","insp_violation_id":"245535551","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"188475972","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:21.000000Z","updated_at":"2025-03-17T21:09:21.000000Z","normalized_code":"3939A"},{"id":480132,"change_date":"2022-05-03 21:39:00","inspection_id":"75462040","insp_violation_id":"245535552","seq_no":"4","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"188475972","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:21.000000Z","updated_at":"2025-03-17T21:09:21.000000Z","normalized_code":"39311"},{"id":480133,"change_date":"2022-05-03 21:39:00","inspection_id":"75462040","insp_violation_id":"245535553","seq_no":"5","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"188475972","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:21.000000Z","updated_at":"2025-03-17T21:09:21.000000Z","normalized_code":"39345B2"},{"id":480134,"change_date":"2022-05-03 21:39:00","inspection_id":"75462040","insp_violation_id":"245535554","seq_no":"6","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"188475973","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:21.000000Z","updated_at":"2025-03-17T21:09:21.000000Z","normalized_code":"39345B2"},{"id":480135,"change_date":"2022-05-03 21:39:00","inspection_id":"75462040","insp_violation_id":"245535555","seq_no":"7","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"188475973","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:21.000000Z","updated_at":"2025-03-17T21:09:21.000000Z","normalized_code":"3963A1"},{"id":480136,"change_date":"2022-05-03 21:39:00","inspection_id":"75462040","insp_violation_id":"245535556","seq_no":"8","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"188475973","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:21.000000Z","updated_at":"2025-03-17T21:09:21.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":500138,"change_date":"2022-05-03 21:39:00","inspection_id":"75462040","insp_unit_id":"188475972","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"1","insp_unit_license":"GJ3171","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XP5D49X04D815751","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:17.000000Z","updated_at":"2025-03-17T22:11:17.000000Z"},{"id":500139,"change_date":"2022-05-03 21:39:00","inspection_id":"75462040","insp_unit_id":"188475973","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LOAK","insp_unit_company":"1","insp_unit_license":"EN8643","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5LKL5335181027027","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:17.000000Z","updated_at":"2025-03-17T22:11:17.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1045757\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1045757\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1045757\/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\/1045757\/inspections","per_page":100,"prev_page_url":null,"to":10,"total":10}