{"current_page":1,"data":[{"id":12019382,"change_date":"2026-05-26 21:40:00","inspection_id":"87958908","dot_number":"402330","report_state":"IA","report_number":"000P12XJB9","insp_date":"2026-05-22 00:00:00","insp_start_time":"1510","insp_end_time":"1516","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"US HWY 52","county_code_state":"IA","county_code":"061","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"TSCHIGGFRIE","shipping_paper_number":"ROCK","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":"2026-05-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"51350","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":"1402492","transaction_code":"A","transaction_date":"2026-05-26 00:00:00","upload_date":"2026-05-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00402330","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2026-05-22 00:00:00","source_office":"3IAS001","mcmis_add_date":"2026-05-26 21:40:00","insp_carrier_name":"TSCHIGGFRIE EXCAVATING","insp_carrier_street":"425 JULIEN DUBUQUE DRIVE","insp_carrier_city":"DUBUQUE","insp_carrier_state":"IA","insp_carrier_zip_code":"52003-7936","insp_colonia":null,"docket_number":"354630","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-29T09:40:00.000000Z","updated_at":"2026-06-06T09:32:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20892371,"change_date":"2026-05-26 21:40:00","inspection_id":"87958908","insp_unit_id":"213755280","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"13297","insp_unit_license":"FX3880","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"2FVNFMCB1VA824792","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-29T09:17:37.000000Z","updated_at":"2026-06-06T09:04:16.000000Z"}]},{"id":11965159,"change_date":"2026-05-19 21:41:00","inspection_id":"87901547","dot_number":"402330","report_state":"IA","report_number":"000P12XJ94","insp_date":"2026-05-08 00:00:00","insp_start_time":"0945","insp_end_time":"1021","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 136","county_code_state":"IA","county_code":"061","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-05-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"53000","viol_total":"5","oos_total":"0","driver_viol_total":"5","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1400198","transaction_code":"A","transaction_date":"2026-05-19 00:00:00","upload_date":"2026-05-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00402330","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2026-05-08 00:00:00","source_office":"3IAS001","mcmis_add_date":"2026-05-19 21:41:00","insp_carrier_name":"TSCHIGGFRIE EXCAVATING","insp_carrier_street":"425 JULIEN DUBUQUE DRIVE","insp_carrier_city":"DUBUQUE","insp_carrier_state":"IA","insp_carrier_zip_code":"52003-7936","insp_colonia":null,"docket_number":"354630","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-22T09:41:16.000000Z","updated_at":"2026-05-30T09:31:10.000000Z","inspection_violations":[{"id":20811923,"change_date":"2026-05-19 21:41:00","inspection_id":"87901547","insp_violation_id":"274371676","seq_no":"1","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":"9JOH26050810112","created_at":"2026-05-22T10:01:41.000000Z","updated_at":"2026-05-30T09:41:44.000000Z","normalized_code":"3922SLLEWG3"},{"id":20811925,"change_date":"2026-05-19 21:41:00","inspection_id":"87901547","insp_violation_id":"274371678","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":"9JOH26050810122","created_at":"2026-05-22T10:01:41.000000Z","updated_at":"2026-05-30T09:41:44.000000Z","normalized_code":"3922SLLEWA3"},{"id":20811927,"change_date":"2026-05-19 21:41:00","inspection_id":"87901547","insp_violation_id":"274371680","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":"2026-05-22T10:01:41.000000Z","updated_at":"2026-05-30T09:41:44.000000Z","normalized_code":"3922SLLEWA1"},{"id":20811924,"change_date":"2026-05-19 21:41:00","inspection_id":"87901547","insp_violation_id":"274371677","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":"2026-05-22T10:01:41.000000Z","updated_at":"2026-05-30T09:41:44.000000Z","normalized_code":"3922SLLEWA1"},{"id":20811926,"change_date":"2026-05-19 21:41:00","inspection_id":"87901547","insp_violation_id":"274371679","seq_no":"4","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":"2026-05-22T10:01:41.000000Z","updated_at":"2026-05-30T09:41:44.000000Z","normalized_code":"3922SLLEWA1"}],"inspection_per_units":[{"id":20803671,"change_date":"2026-05-19 21:41:00","inspection_id":"87901547","insp_unit_id":"213649235","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"92721","insp_unit_license":"MX1485","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5KKMAVFM7MPLZ9359","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-22T09:21:53.000000Z","updated_at":"2026-05-30T09:03:31.000000Z"}]},{"id":11711459,"change_date":"2026-04-21 21:39:00","inspection_id":"87638486","dot_number":"402330","report_state":"IA","report_number":"000P1557D5","insp_date":"2026-04-15 00:00:00","insp_start_time":"1627","insp_end_time":"1640","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 64 E\/CHAMBER DR","county_code_state":"IA","county_code":"105","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"TSCHIGGFRIE EXCAVATING","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-04-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","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":"1397340","transaction_code":"A","transaction_date":"2026-04-15 00:00:00","upload_date":"2026-04-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00402330","upload_search_indicator":null,"census_search_date":"2026-04-21 21:39:00","snet_input_date":"2026-04-15 00:00:00","source_office":"3IAS001","mcmis_add_date":"2026-04-21 21:39:00","insp_carrier_name":"TSCHIGGFRIE EXCAVATING","insp_carrier_street":"425 JULIEN DUBUQUE DRIVE","insp_carrier_city":"DUBUQUE","insp_carrier_state":"IA","insp_carrier_zip_code":"520037936","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-27T09:38:08.000000Z","updated_at":"2026-05-02T09:31:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20380268,"change_date":"2026-04-21 21:39:00","inspection_id":"87638486","insp_unit_id":"213141818","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"2132","insp_unit_license":"NON336","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GB4YTEY4RF112132","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:14:37.000000Z","updated_at":"2026-05-02T09:03:44.000000Z"}]},{"id":11465695,"change_date":"2026-03-24 21:40:00","inspection_id":"87383994","dot_number":"402330","report_state":"IA","report_number":"000P13V956","insp_date":"2026-03-23 00:00:00","insp_start_time":"0815","insp_end_time":"0845","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY","county_code_state":"IA","county_code":"043","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"TSCHIGGFRIE EXCAVATING","shipping_paper_number":"OWN","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-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"67500","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":"1394784","transaction_code":"A","transaction_date":"2026-03-24 00:00:00","upload_date":"2026-03-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00402330","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2026-03-23 00:00:00","source_office":"3IAS001","mcmis_add_date":"2026-03-24 21:40:00","insp_carrier_name":"TSCHIGGFRIE EXCAVATING","insp_carrier_street":"425 JULIEN DUBUQUE DRIVE","insp_carrier_city":"DUBUQUE","insp_carrier_state":"IA","insp_carrier_zip_code":"52003-7936","insp_colonia":null,"docket_number":"354630","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-27T09:45:26.000000Z","updated_at":"2026-04-04T09:31:18.000000Z","inspection_violations":[{"id":19349480,"change_date":"2026-03-24 21:40:00","inspection_id":"87383994","insp_violation_id":"272607859","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","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":"2026-03-27T10:10:15.000000Z","updated_at":"2026-04-03T09:54:53.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":19638467,"change_date":"2026-03-24 21:40:00","inspection_id":"87383994","insp_unit_id":"212310087","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"92721","insp_unit_license":"MX1485","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5KKMAVFM7MPLZ9359","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-27T09:23:03.000000Z","updated_at":"2026-04-04T09:04:53.000000Z"}]},{"id":11143021,"change_date":"2026-02-16 21:35:00","inspection_id":"87057147","dot_number":"402330","report_state":"IA","report_number":"000P15NFNG","insp_date":"2026-02-13 00:00:00","insp_start_time":"1138","insp_end_time":"1150","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 52","county_code_state":"IA","county_code":"061","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SELF","shipping_paper_number":"MISC","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-02-16 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"17950","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":"1390450","transaction_code":"A","transaction_date":"2026-02-16 00:00:00","upload_date":"2026-02-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00402330","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2026-02-13 00:00:00","source_office":"3IAS001","mcmis_add_date":"2026-02-16 21:35:00","insp_carrier_name":"TSCHIGGFRIE EXCAVATING","insp_carrier_street":"425 JULIEN DUBUQUE DRIVE","insp_carrier_city":"DUBUQUE","insp_carrier_state":"IA","insp_carrier_zip_code":"52003-7936","insp_colonia":null,"docket_number":"354630","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-19T10:37:12.000000Z","updated_at":"2026-02-27T10:30:28.000000Z","inspection_violations":[{"id":18669142,"change_date":"2026-02-16 21:35:00","inspection_id":"87057147","insp_violation_id":"271824105","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","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":"2026-02-19T10:51:20.000000Z","updated_at":"2026-02-27T10:39:08.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":19008483,"change_date":"2026-02-16 21:35:00","inspection_id":"87057147","insp_unit_id":"211646633","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"778-08","insp_unit_license":"FNL374","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FDAW57R58EC55595","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-19T10:12:53.000000Z","updated_at":"2026-02-27T10:02:50.000000Z"}]},{"id":9739545,"change_date":"2025-09-22 21:38:00","inspection_id":"85836073","dot_number":"402330","report_state":"WI","report_number":"2346000206","insp_date":"2025-09-19 00:00:00","insp_start_time":"1050","insp_end_time":"1115","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"HAZEL GREEN WI","county_code_state":"WI","county_code":"043","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SELF","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":"U","pen_cen_match":"I","final_status_date":"2025-09-22 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2307112","transaction_code":"A","transaction_date":"2025-09-21 00:00:00","upload_date":"2025-09-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00402330","upload_search_indicator":null,"census_search_date":"2025-09-22 21:38:00","snet_input_date":"2025-09-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-22 21:38:00","insp_carrier_name":"TSCHIGGFRIE EXCAVATING","insp_carrier_street":"425 JULIEN DUBUQUE DRIVE","insp_carrier_city":"DUBUQUE","insp_carrier_state":"IA","insp_carrier_zip_code":"52003-7936","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-25T10:00:14.000000Z","updated_at":"2025-09-25T10:00:14.000000Z","inspection_violations":[{"id":15993865,"change_date":"2025-09-22 21:38:00","inspection_id":"85836073","insp_violation_id":"268829284","seq_no":"1","part_no":"393","part_no_section":"9A-LSML","insp_viol_unit":"1","insp_unit_id":"209065886","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-25T10:15:21.000000Z","updated_at":"2025-09-26T10:15:13.000000Z","normalized_code":"3939ALSML"},{"id":15993866,"change_date":"2025-09-22 21:38:00","inspection_id":"85836073","insp_violation_id":"268829285","seq_no":"2","part_no":"391","part_no_section":"41APC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-25T10:15:21.000000Z","updated_at":"2025-09-26T10:15:13.000000Z","normalized_code":"39141APC"},{"id":15993867,"change_date":"2025-09-22 21:38:00","inspection_id":"85836073","insp_violation_id":"268829286","seq_no":"3","part_no":"392","part_no_section":"2-SLLTCD","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-09-25T10:15:21.000000Z","updated_at":"2025-09-26T10:15:13.000000Z","normalized_code":"3922SLLTCD"}],"inspection_per_units":[{"id":16128709,"change_date":"2025-09-22 21:38:00","inspection_id":"85836073","insp_unit_id":"209065886","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"NON101","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FD0W5GT6BEB78170","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-25T09:45:18.000000Z","updated_at":"2025-09-26T09:45:09.000000Z"}]},{"id":9685032,"change_date":"2025-09-15 21:40:00","inspection_id":"85778926","dot_number":"402330","report_state":"IA","report_number":"000P10B0K0","insp_date":"2025-09-12 00:00:00","insp_start_time":"0613","insp_end_time":"0630","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"US 151 S MM 49 (FARIVIEW)","county_code_state":"IA","county_code":"105","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"TSCHIGGFRIE EXCAVATING","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":"2025-09-15 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","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":"1374323","transaction_code":"A","transaction_date":"2025-09-15 00:00:00","upload_date":"2025-09-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00402330","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-09-12 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-09-15 21:40:00","insp_carrier_name":"TSCHIGGFRIE EXCAVATING","insp_carrier_street":"425 JULIEN DUBUQUE DRIVE","insp_carrier_city":"DUBUQUE","insp_carrier_state":"IA","insp_carrier_zip_code":"52003-7936","insp_colonia":null,"docket_number":"354630","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-18T10:00:38.000000Z","updated_at":"2025-09-18T10:00:38.000000Z","inspection_violations":[{"id":15880706,"change_date":"2025-09-15 21:40:00","inspection_id":"85778926","insp_violation_id":"268699390","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"7ALL25091206222","created_at":"2025-09-18T10:20:49.000000Z","updated_at":"2025-09-18T10:20:49.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":16029583,"change_date":"2025-09-15 21:40:00","inspection_id":"85778926","insp_unit_id":"208958892","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"1048-19","insp_unit_license":"NDR698","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FD0W4HT4KED43660","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-18T09:45:32.000000Z","updated_at":"2025-09-18T09:45:32.000000Z"}]},{"id":9546348,"change_date":"2025-08-29 21:40:00","inspection_id":"85633752","dot_number":"402330","report_state":"IA","report_number":"000P1556VB","insp_date":"2025-08-27 00:00:00","insp_start_time":"0953","insp_end_time":"1030","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"EAST MAIN ST\/HUBER ST-ANAMOSA","county_code_state":"IA","county_code":"105","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"TSCHIGGFRIE EXCAVATING","shipping_paper_number":"ROCK","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":"2025-08-29 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"79740","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":"1372267","transaction_code":"A","transaction_date":"2025-08-29 00:00:00","upload_date":"2025-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00402330","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-08-27 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-08-29 21:40:00","insp_carrier_name":"TSCHIGGFRIE EXCAVATING","insp_carrier_street":"425 JULIEN DUBUQUE DRIVE","insp_carrier_city":"DUBUQUE","insp_carrier_state":"IA","insp_carrier_zip_code":"52003-7936","insp_colonia":null,"docket_number":"354630","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-06T10:42:31.000000Z","updated_at":"2025-09-06T10:42:31.000000Z","inspection_violations":[{"id":15584468,"change_date":"2025-08-29 21:40:00","inspection_id":"85633752","insp_violation_id":"268345167","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWG1","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-09-06T10:46:18.000000Z","updated_at":"2025-09-06T10:46:18.000000Z","normalized_code":"3922SLLEWG1"},{"id":15584469,"change_date":"2025-08-29 21:40:00","inspection_id":"85633752","insp_violation_id":"268345168","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-09-06T10:46:18.000000Z","updated_at":"2025-09-06T10:46:18.000000Z","normalized_code":"3922SLLEWA1"}],"inspection_per_units":[{"id":15756540,"change_date":"2025-08-29 21:40:00","inspection_id":"85633752","insp_unit_id":"208659702","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"106324","insp_unit_license":"FW7749","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5KKSBPDV0RLUZ9801","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:46:52.000000Z","updated_at":"2025-09-09T09:46:52.000000Z"}]},{"id":9557649,"change_date":"2025-09-01 21:33:00","inspection_id":"85645774","dot_number":"402330","report_state":"GA","report_number":"0065000125","insp_date":"2025-08-25 00:00:00","insp_start_time":"1120","insp_end_time":"1230","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"TUNNEL HILL GA","county_code_state":"GA","county_code":"047","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","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":"2025-09-01 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"39000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2205273","transaction_code":"A","transaction_date":"2025-08-31 00:00:00","upload_date":"2025-09-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00402330","upload_search_indicator":null,"census_search_date":"2025-09-01 21:33:00","snet_input_date":"2025-08-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-01 21:33:00","insp_carrier_name":"TSCHIGGFRIE EXCAVATING","insp_carrier_street":"425 JULIEN DUBUQUE DRIVE","insp_carrier_city":"DUBUQUE","insp_carrier_state":"IA","insp_carrier_zip_code":"52003-7936","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-06T10:42:45.000000Z","updated_at":"2025-09-06T10:42:45.000000Z","inspection_violations":[{"id":15606873,"change_date":"2025-09-01 21:33:00","inspection_id":"85645774","insp_violation_id":"268374985","seq_no":"1","part_no":"395","part_no_section":"8A1-HOSP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-06T10:46:53.000000Z","updated_at":"2025-09-06T10:46:53.000000Z","normalized_code":"3958A1HOSP"}],"inspection_per_units":[{"id":15775274,"change_date":"2025-09-01 21:33:00","inspection_id":"85645774","insp_unit_id":"208680695","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":"969","insp_unit_license":"LSW368","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1HTKHPVK6LH606903","insp_unit_decal":"Y","insp_unit_decal_number":"35439146","created_at":"2025-09-09T09:47:04.000000Z","updated_at":"2025-09-09T09:47:04.000000Z"},{"id":15775275,"change_date":"2025-09-01 21:33:00","inspection_id":"85645774","insp_unit_id":"208680696","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"B & B TRAI","insp_unit_company":"973-2","insp_unit_license":"IL2070","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"4L5ST2722NF057916","insp_unit_decal":"Y","insp_unit_decal_number":"35439149","created_at":"2025-09-09T09:47:04.000000Z","updated_at":"2025-09-09T09:47:04.000000Z"}]},{"id":9348800,"change_date":"2025-08-07 21:39:00","inspection_id":"85425706","dot_number":"402330","report_state":"WI","report_number":"2346000035","insp_date":"2025-08-04 00:00:00","insp_start_time":"1310","insp_end_time":"1330","registration_date":null,"region":"CD","ci_status_code":"C","location":"S11","location_desc":"HAZEL GREEN WI","county_code_state":"WI","county_code":"043","insp_level_id":"2","service_center":"MW","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":"2025-08-07 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"68000","viol_total":"1","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":"2095828","transaction_code":"A","transaction_date":"2025-08-06 00:00:00","upload_date":"2025-08-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00402330","upload_search_indicator":null,"census_search_date":"2025-08-07 21:39:00","snet_input_date":"2025-08-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-07 21:39:00","insp_carrier_name":"TSCHIGGFRIE EXCAVATING","insp_carrier_street":"425 JULIEN DUBUQUE DRIVE","insp_carrier_city":"DUBUQUE","insp_carrier_state":"IA","insp_carrier_zip_code":"52003-7936","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-12T10:42:30.000000Z","updated_at":"2025-08-12T10:42:30.000000Z","inspection_violations":[{"id":15181926,"change_date":"2025-08-07 21:39:00","inspection_id":"85425706","insp_violation_id":"267883318","seq_no":"1","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"208274968","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-10T10:44:31.000000Z","updated_at":"2025-08-11T10:43:56.000000Z","normalized_code":"39021TB1MC"}],"inspection_per_units":[{"id":15400703,"change_date":"2025-08-07 21:39:00","inspection_id":"85425706","insp_unit_id":"208274968","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"FR5857","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1NKDLU0X83J704165","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-10T09:46:16.000000Z","updated_at":"2025-08-11T09:45:19.000000Z"}]},{"id":9123416,"change_date":"2025-07-11 21:39:00","inspection_id":"85188755","dot_number":"402330","report_state":"IA","report_number":"000P168X28","insp_date":"2025-07-10 00:00:00","insp_start_time":"0944","insp_end_time":"1000","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 151 SB","county_code_state":"IA","county_code":"061","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"OWN","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-07-11 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"79740","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":"1366997","transaction_code":"A","transaction_date":"2025-07-11 00:00:00","upload_date":"2025-07-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00402330","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-07-10 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-07-11 21:39:00","insp_carrier_name":"TSCHIGGFRIE EXCAVATING","insp_carrier_street":"425 JULIEN DUBUQUE DRIVE","insp_carrier_city":"DUBUQUE","insp_carrier_state":"IA","insp_carrier_zip_code":"52003-7936","insp_colonia":null,"docket_number":"354630","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-14T10:47:04.000000Z","updated_at":"2025-07-16T10:44:44.000000Z","inspection_violations":[{"id":14708636,"change_date":"2025-07-11 21:39:00","inspection_id":"85188755","insp_violation_id":"267346929","seq_no":"1","part_no":"392","part_no_section":"2P","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-07-14T10:48:47.000000Z","updated_at":"2025-07-16T10:46:01.000000Z","normalized_code":"3922P"}],"inspection_per_units":[{"id":14979290,"change_date":"2025-07-11 21:39:00","inspection_id":"85188755","insp_unit_id":"207821255","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"1069","insp_unit_license":"OWM185","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5KKSBPDV8RPVE2639","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-14T09:46:07.000000Z","updated_at":"2025-07-15T09:45:47.000000Z"}]},{"id":9118836,"change_date":"2025-07-11 21:39:00","inspection_id":"85183895","dot_number":"402330","report_state":"WI","report_number":"2346009969","insp_date":"2025-07-08 00:00:00","insp_start_time":"1000","insp_end_time":"1040","registration_date":null,"region":"CD","ci_status_code":"C","location":"S11","location_desc":"HAZEL GREEN WI","county_code_state":"WI","county_code":"043","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SELF","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":"2025-07-11 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"84000","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1977096","transaction_code":"A","transaction_date":"2025-07-10 00:00:00","upload_date":"2025-07-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00402330","upload_search_indicator":null,"census_search_date":"2025-07-11 21:39:00","snet_input_date":"2025-07-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-11 21:39:00","insp_carrier_name":"TSCHIGGFRIE EXCAVATING","insp_carrier_street":"425 JULIEN DUBUQUE DRIVE","insp_carrier_city":"DUBUQUE","insp_carrier_state":"IA","insp_carrier_zip_code":"52003-7936","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-14T10:46:58.000000Z","updated_at":"2025-07-16T10:44:24.000000Z","inspection_violations":[{"id":14701154,"change_date":"2025-07-11 21:39:00","inspection_id":"85183895","insp_violation_id":"267337195","seq_no":"1","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"207812285","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"BD720204-2","created_at":"2025-07-14T10:48:37.000000Z","updated_at":"2025-07-16T10:45:31.000000Z","normalized_code":"39021TB1MC"},{"id":14701155,"change_date":"2025-07-11 21:39:00","inspection_id":"85183895","insp_violation_id":"267337196","seq_no":"2","part_no":"393","part_no_section":"55D1-B","insp_viol_unit":"1","insp_unit_id":"207812285","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-14T10:48:37.000000Z","updated_at":"2025-07-16T10:45:31.000000Z","normalized_code":"39355D1B"},{"id":14701156,"change_date":"2025-07-11 21:39:00","inspection_id":"85183895","insp_violation_id":"267337197","seq_no":"3","part_no":"393","part_no_section":"43DBMA","insp_viol_unit":"2","insp_unit_id":"207812286","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-07-14T10:48:37.000000Z","updated_at":"2025-07-16T10:45:31.000000Z","normalized_code":"39343DBMA"}],"inspection_per_units":[{"id":14971745,"change_date":"2025-07-11 21:39:00","inspection_id":"85183895","insp_unit_id":"207812285","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"FP6955","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FVHGNDV8CDBE9337","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-14T09:46:03.000000Z","updated_at":"2025-07-15T09:45:18.000000Z"},{"id":14971746,"change_date":"2025-07-11 21:39:00","inspection_id":"85183895","insp_unit_id":"207812286","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"BEHNKE","insp_unit_company":null,"insp_unit_license":"LS1340","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"990418019FB8X25PT","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-14T09:46:03.000000Z","updated_at":"2025-07-15T09:45:18.000000Z"}]},{"id":9062803,"change_date":"2025-07-05 21:35:00","inspection_id":"85124637","dot_number":"402330","report_state":"WI","report_number":"2346009946","insp_date":"2025-07-01 00:00:00","insp_start_time":"1555","insp_end_time":"1620","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"HAZEL GREEN WI","county_code_state":"WI","county_code":"043","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SELF","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":"U","pen_cen_match":"I","final_status_date":"2025-07-05 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"3","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":"1949922","transaction_code":"A","transaction_date":"2025-07-04 00:00:00","upload_date":"2025-07-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00402330","upload_search_indicator":null,"census_search_date":"2025-07-05 21:35:00","snet_input_date":"2025-07-01 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-05 21:35:00","insp_carrier_name":"TSCHIGGFRIE EXCAVATING","insp_carrier_street":"425 JULIEN DUBUQUE DRIVE","insp_carrier_city":"DUBUQUE","insp_carrier_state":"IA","insp_carrier_zip_code":"52003-7936","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-09T10:00:16.000000Z","updated_at":"2025-07-09T10:00:16.000000Z","inspection_violations":[{"id":14586527,"change_date":"2025-07-05 21:35:00","inspection_id":"85124637","insp_violation_id":"267205245","seq_no":"1","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"207701843","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-08T10:15:25.000000Z","updated_at":"2025-07-09T10:42:34.000000Z","normalized_code":"39021TB1MC"},{"id":14586528,"change_date":"2025-07-05 21:35:00","inspection_id":"85124637","insp_violation_id":"267205246","seq_no":"2","part_no":"392","part_no_section":"2-SLLTCD","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-07-08T10:15:25.000000Z","updated_at":"2025-07-09T10:42:34.000000Z","normalized_code":"3922SLLTCD"},{"id":14586529,"change_date":"2025-07-05 21:35:00","inspection_id":"85124637","insp_violation_id":"267205247","seq_no":"3","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"1","insp_unit_id":"207701843","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-08T10:15:25.000000Z","updated_at":"2025-07-09T10:42:34.000000Z","normalized_code":"3939ALLPL"}],"inspection_per_units":[{"id":14870321,"change_date":"2025-07-05 21:35:00","inspection_id":"85124637","insp_unit_id":"207701843","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":null,"insp_unit_license":"LJJ647","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3C7WRNFL0MG546686","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-08T09:45:19.000000Z","updated_at":"2025-07-09T09:45:05.000000Z"}]},{"id":8689798,"change_date":"2025-05-20 21:41:00","inspection_id":"84730022","dot_number":"402330","report_state":"IA","report_number":"000P14XHZM","insp_date":"2025-05-19 00:00:00","insp_start_time":"0830","insp_end_time":"0900","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"EB HWY 20 AT THEISENS","county_code_state":"IA","county_code":"061","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"TSCHIGGFRIE","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":"2025-05-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"3","oos_total":"2","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1361075","transaction_code":"A","transaction_date":"2025-05-20 00:00:00","upload_date":"2025-05-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00402330","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-05-19 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-05-20 21:41:00","insp_carrier_name":"TSCHIGGFRIE EXCAVATING","insp_carrier_street":"425 JULIEN DUBUQUE DRIVE","insp_carrier_city":"DUBUQUE","insp_carrier_state":"IA","insp_carrier_zip_code":"52003-7936","insp_colonia":null,"docket_number":"354630","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-23T10:04:20.000000Z","updated_at":"2025-05-24T10:05:46.000000Z","inspection_violations":[{"id":13845784,"change_date":"2025-05-20 21:41:00","inspection_id":"84730022","insp_violation_id":"266352930","seq_no":"1","part_no":"392","part_no_section":"5A2-DETECT","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"10","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"1DOE25051908481","created_at":"2025-05-23T10:36:21.000000Z","updated_at":"2025-05-24T10:25:51.000000Z","normalized_code":"3925A2DETECT"},{"id":13845785,"change_date":"2025-05-20 21:41:00","inspection_id":"84730022","insp_violation_id":"266352931","seq_no":"2","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"206968050","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-23T10:36:21.000000Z","updated_at":"2025-05-24T10:25:51.000000Z","normalized_code":"39395A"},{"id":13845786,"change_date":"2025-05-20 21:41:00","inspection_id":"84730022","insp_violation_id":"266352932","seq_no":"3","part_no":"393","part_no_section":"9A-LSLIWR","insp_viol_unit":"1","insp_unit_id":"206968050","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"1DOE25051908493","created_at":"2025-05-23T10:36:21.000000Z","updated_at":"2025-05-24T10:25:51.000000Z","normalized_code":"3939ALSLIWR"}],"inspection_per_units":[{"id":14198315,"change_date":"2025-05-20 21:41:00","inspection_id":"84730022","insp_unit_id":"206968050","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"957-11","insp_unit_license":"KCK457","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3FRXF7FCXBV077270","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-23T09:49:12.000000Z","updated_at":"2025-05-24T09:51:13.000000Z"}]},{"id":8504595,"change_date":"2025-04-30 21:51:00","inspection_id":"84535102","dot_number":"402330","report_state":"WI","report_number":"2346009694","insp_date":"2025-04-24 00:00:00","insp_start_time":"1310","insp_end_time":"1350","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"HAZEL GREEN WI","county_code_state":"WI","county_code":"043","insp_level_id":"1","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":"U","pen_cen_match":"I","final_status_date":"2025-04-30 21:51:00","post_acc_ind":"N","gross_comb_veh_wt":"11400","viol_total":"12","oos_total":"4","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1660966","transaction_code":"A","transaction_date":"2025-04-29 00:00:00","upload_date":"2025-04-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00402330","upload_search_indicator":null,"census_search_date":"2025-04-30 21:51:00","snet_input_date":"2025-04-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-30 21:51:00","insp_carrier_name":"TSCHIGGFRIE EXCAVATING","insp_carrier_street":"425 JULIEN DUBUQUE DRIVE","insp_carrier_city":"DUBUQUE","insp_carrier_state":"IA","insp_carrier_zip_code":"52003-7936","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-02T13:50:03.000000Z","updated_at":"2025-05-04T10:36:04.000000Z","inspection_violations":[{"id":13456595,"change_date":"2025-04-30 21:51:00","inspection_id":"84535102","insp_violation_id":"265909481","seq_no":"1","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"206558872","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-02T11:14:58.000000Z","updated_at":"2025-05-03T10:59:04.000000Z","normalized_code":"39021TB1MC"},{"id":13456596,"change_date":"2025-04-30 21:51:00","inspection_id":"84535102","insp_violation_id":"265909482","seq_no":"2","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"206558872","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-02T11:14:58.000000Z","updated_at":"2025-05-03T10:59:04.000000Z","normalized_code":"39021TB2DOT"},{"id":13456597,"change_date":"2025-04-30 21:51:00","inspection_id":"84535102","insp_violation_id":"265909483","seq_no":"3","part_no":"391","part_no_section":"41APC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-02T11:14:58.000000Z","updated_at":"2025-05-03T10:59:04.000000Z","normalized_code":"39141APC"},{"id":13456598,"change_date":"2025-04-30 21:51:00","inspection_id":"84535102","insp_violation_id":"265909484","seq_no":"4","part_no":"392","part_no_section":"2-SLLTCD","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-05-02T11:14:58.000000Z","updated_at":"2025-05-03T10:59:04.000000Z","normalized_code":"3922SLLTCD"},{"id":13456599,"change_date":"2025-04-30 21:51:00","inspection_id":"84535102","insp_violation_id":"265909485","seq_no":"5","part_no":"393","part_no_section":"11A1-LLPL","insp_viol_unit":"1","insp_unit_id":"206558872","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-02T11:14:58.000000Z","updated_at":"2025-05-03T10:59:04.000000Z","normalized_code":"39311A1LLPL"},{"id":13456600,"change_date":"2025-04-30 21:51:00","inspection_id":"84535102","insp_violation_id":"265909486","seq_no":"6","part_no":"393","part_no_section":"41-BNPB","insp_viol_unit":"1","insp_unit_id":"206558872","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-05-02T11:14:58.000000Z","updated_at":"2025-05-03T10:59:04.000000Z","normalized_code":"39341BNPB"},{"id":13456601,"change_date":"2025-04-30 21:51:00","inspection_id":"84535102","insp_violation_id":"265909487","seq_no":"7","part_no":"393","part_no_section":"45B2-BHHC","insp_viol_unit":"1","insp_unit_id":"206558872","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-05-02T11:14:58.000000Z","updated_at":"2025-05-03T10:59:04.000000Z","normalized_code":"39345B2BHHC"},{"id":13456602,"change_date":"2025-04-30 21:51:00","inspection_id":"84535102","insp_violation_id":"265909488","seq_no":"8","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"206558872","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-05-02T11:14:58.000000Z","updated_at":"2025-05-03T10:59:04.000000Z","normalized_code":"39375A3TAOL"},{"id":13456603,"change_date":"2025-04-30 21:51:00","inspection_id":"84535102","insp_violation_id":"265909489","seq_no":"9","part_no":"393","part_no_section":"75C-TAOTD-LT2\/32","insp_viol_unit":"1","insp_unit_id":"206558872","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-02T11:14:58.000000Z","updated_at":"2025-05-03T10:59:04.000000Z","normalized_code":"39375CTAOTDLT2\/32"},{"id":13456604,"change_date":"2025-04-30 21:51:00","inspection_id":"84535102","insp_violation_id":"265909490","seq_no":"10","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"206558872","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-02T11:14:58.000000Z","updated_at":"2025-05-03T10:59:04.000000Z","normalized_code":"39395A1"},{"id":13456605,"change_date":"2025-04-30 21:51:00","inspection_id":"84535102","insp_violation_id":"265909491","seq_no":"11","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"206558872","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-02T11:14:58.000000Z","updated_at":"2025-05-03T10:59:04.000000Z","normalized_code":"3939ALIL"},{"id":13456606,"change_date":"2025-04-30 21:51:00","inspection_id":"84535102","insp_violation_id":"265909492","seq_no":"12","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"206558872","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-02T11:14:58.000000Z","updated_at":"2025-05-03T10:59:04.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":13822548,"change_date":"2025-04-30 21:51:00","inspection_id":"84535102","insp_unit_id":"206558872","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":null,"insp_unit_license":"DHM249","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GBJC33254F244308","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-03T10:17:10.000000Z","updated_at":"2025-05-04T09:58:46.000000Z"}]},{"id":7318999,"change_date":"2024-12-02 21:39:00","inspection_id":"83288541","dot_number":"402330","report_state":"IA","report_number":"000P10WRG4","insp_date":"2024-11-26 00:00:00","insp_start_time":"0749","insp_end_time":"0800","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 52","county_code_state":"IA","county_code":"061","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-12-02 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"63000","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":"1339516","transaction_code":"A","transaction_date":"2024-12-02 00:00:00","upload_date":"2024-12-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00402330","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-11-26 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-12-02 21:39:00","insp_carrier_name":"TSCHIGGFRIE EXCAVATING","insp_carrier_street":"425 JULIEN DUBUQUE DRIVE","insp_carrier_city":"DUBUQUE","insp_carrier_state":"IA","insp_carrier_zip_code":"52003-7936","insp_colonia":null,"docket_number":"354630","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:48:37.000000Z","updated_at":"2025-03-17T20:48:37.000000Z","inspection_violations":[{"id":11440608,"change_date":"2024-12-02 21:39:00","inspection_id":"83288541","insp_violation_id":"263172198","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":null,"created_at":"2025-03-17T22:01:40.000000Z","updated_at":"2025-03-17T22:01:40.000000Z","normalized_code":"39216"}],"inspection_per_units":[{"id":11806482,"change_date":"2024-12-02 21:39:00","inspection_id":"83288541","insp_unit_id":"204133690","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"72202","insp_unit_license":"FX3893","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XP5DR0X22D572872","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:23.000000Z","updated_at":"2025-03-17T23:45:23.000000Z"}]},{"id":7204268,"change_date":"2024-11-15 21:42:00","inspection_id":"83167318","dot_number":"402330","report_state":"IA","report_number":"000P12XHXG","insp_date":"2024-11-13 00:00:00","insp_start_time":"1031","insp_end_time":"1120","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 61\/ DUBUQUE DOT","county_code_state":"IA","county_code":"061","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"TSCHIGGFRIE EXCAVATING","shipping_paper_number":"BROKEN CONCRETE","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":"2024-11-15 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"53000","viol_total":"5","oos_total":"0","driver_viol_total":"5","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1337439","transaction_code":"A","transaction_date":"2024-11-14 00:00:00","upload_date":"2024-11-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00402330","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-11-13 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-11-15 21:42:00","insp_carrier_name":"TSCHIGGFRIE EXCAVATING","insp_carrier_street":"425 JULIEN DUBUQUE DRIVE","insp_carrier_city":"DUBUQUE","insp_carrier_state":"IA","insp_carrier_zip_code":"52003-7936","insp_colonia":null,"docket_number":"354630","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:46:25.000000Z","updated_at":"2025-03-17T20:46:25.000000Z","inspection_violations":[{"id":11258319,"change_date":"2024-11-15 21:42:00","inspection_id":"83167318","insp_violation_id":"262919840","seq_no":"1","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":"9JOH24111311085","created_at":"2025-03-17T22:00:37.000000Z","updated_at":"2025-03-17T22:00:37.000000Z","normalized_code":"3922SLLEWG3"},{"id":11258320,"change_date":"2024-11-15 21:42:00","inspection_id":"83167318","insp_violation_id":"262919841","seq_no":"2","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":"9JOH24111311102","created_at":"2025-03-17T22:00:37.000000Z","updated_at":"2025-03-17T22:00:37.000000Z","normalized_code":"3922SLLEWA3"},{"id":11258321,"change_date":"2024-11-15 21:42:00","inspection_id":"83167318","insp_violation_id":"262919842","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":"9JOH24111311110","created_at":"2025-03-17T22:00:37.000000Z","updated_at":"2025-03-17T22:00:37.000000Z","normalized_code":"3922SLLEWA3"},{"id":11258322,"change_date":"2024-11-15 21:42:00","inspection_id":"83167318","insp_violation_id":"262919843","seq_no":"4","part_no":"392","part_no_section":"2-SLLEWG1","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:00:37.000000Z","updated_at":"2025-03-17T22:00:37.000000Z","normalized_code":"3922SLLEWG1"},{"id":11258323,"change_date":"2024-11-15 21:42:00","inspection_id":"83167318","insp_violation_id":"262919844","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:00:37.000000Z","updated_at":"2025-03-17T22:00:37.000000Z","normalized_code":"3922SLLEWA1"}],"inspection_per_units":[{"id":11620453,"change_date":"2024-11-15 21:42:00","inspection_id":"83167318","insp_unit_id":"203903033","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"12088","insp_unit_license":"FX3876","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1M2P198C4JW002861","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:26.000000Z","updated_at":"2025-03-17T23:43:26.000000Z"}]},{"id":7048267,"change_date":"2024-10-25 21:41:00","inspection_id":"83002129","dot_number":"402330","report_state":"IA","report_number":"000P12XHTS","insp_date":"2024-10-21 00:00:00","insp_start_time":"0721","insp_end_time":"0735","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 61","county_code_state":"IA","county_code":"061","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"EMPTY","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-10-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1334570","transaction_code":"A","transaction_date":"2024-10-25 00:00:00","upload_date":"2024-10-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00402330","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-10-21 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-10-25 21:41:00","insp_carrier_name":"TSCHIGGFRIE EXCAVATING","insp_carrier_street":"425 JULIEN DUBUQUE DRIVE","insp_carrier_city":"DUBUQUE","insp_carrier_state":"IA","insp_carrier_zip_code":"52003-7936","insp_colonia":null,"docket_number":"354630","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:43:01.000000Z","updated_at":"2025-03-17T20:43:01.000000Z","inspection_violations":[{"id":11000952,"change_date":"2024-10-25 21:41:00","inspection_id":"83002129","insp_violation_id":"262563037","seq_no":"1","part_no":"392","part_no_section":"2FC","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:59:23.000000Z","updated_at":"2025-03-17T21:59:23.000000Z","normalized_code":"3922FC"}],"inspection_per_units":[{"id":11367317,"change_date":"2024-10-25 21:41:00","inspection_id":"83002129","insp_unit_id":"203591892","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"13597","insp_unit_license":"FX3882","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"2FVNFMCB7VA824795","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:42.000000Z","updated_at":"2025-03-17T23:40:42.000000Z"}]},{"id":6711799,"change_date":"2024-09-12 21:42:00","inspection_id":"82644162","dot_number":"402330","report_state":"IA","report_number":"000P14XHRG","insp_date":"2024-09-11 00:00:00","insp_start_time":"1150","insp_end_time":"1210","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"DODGE AND OLD 20","county_code_state":"IA","county_code":"061","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"TSCHIGGFRIE EXCAVATING","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-09-12 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"53000","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":"1329169","transaction_code":"A","transaction_date":"2024-09-12 00:00:00","upload_date":"2024-09-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00402330","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-09-11 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-09-12 21:42:00","insp_carrier_name":"TSCHIGGFRIE EXCAVATING","insp_carrier_street":"425 JULIEN DUBUQUE DRIVE","insp_carrier_city":"DUBUQUE","insp_carrier_state":"IA","insp_carrier_zip_code":"52003-7936","insp_colonia":null,"docket_number":"354630","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:36:06.000000Z","updated_at":"2025-03-17T20:36:06.000000Z","inspection_violations":[{"id":10448228,"change_date":"2024-09-12 21:42:00","inspection_id":"82644162","insp_violation_id":"261767124","seq_no":"1","part_no":"392","part_no_section":"16(a)","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:56:36.000000Z","updated_at":"2025-03-17T21:56:36.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":10822494,"change_date":"2024-09-12 21:42:00","inspection_id":"82644162","insp_unit_id":"202893535","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"957-11","insp_unit_license":"KCK457","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3FRXF7FCXBV077270","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:03.000000Z","updated_at":"2025-03-17T23:35:03.000000Z"},{"id":10822495,"change_date":"2024-09-12 21:42:00","inspection_id":"82644162","insp_unit_id":"202893536","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KANDK","insp_unit_company":"1052-21","insp_unit_license":"KP8287","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"KK836FAQJ92001430","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:03.000000Z","updated_at":"2025-03-17T23:35:03.000000Z"}]},{"id":6288399,"change_date":"2024-07-23 21:42:00","inspection_id":"82192445","dot_number":"402330","report_state":"IA","report_number":"000P15561V","insp_date":"2024-07-18 00:00:00","insp_start_time":"1750","insp_end_time":"1815","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 151 NB\/AMBER RD","county_code_state":"IA","county_code":"105","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"TSCHIGGFRIE EXCAVATING","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-07-23 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"18000","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1321879","transaction_code":"A","transaction_date":"2024-07-23 00:00:00","upload_date":"2024-07-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00402330","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-07-18 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-07-23 21:42:00","insp_carrier_name":"TSCHIGGFRIE EXCAVATING","insp_carrier_street":"425 JULIEN DUBUQUE DRIVE","insp_carrier_city":"DUBUQUE","insp_carrier_state":"IA","insp_carrier_zip_code":"52003-7936","insp_colonia":null,"docket_number":"354630","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:27:23.000000Z","updated_at":"2025-03-17T20:27:23.000000Z","inspection_violations":[{"id":9767170,"change_date":"2024-07-23 21:42:00","inspection_id":"82192445","insp_violation_id":"260797306","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":"9MCM24071818002","created_at":"2025-03-17T21:53:15.000000Z","updated_at":"2025-03-17T21:53:15.000000Z","normalized_code":"3922"},{"id":9767171,"change_date":"2024-07-23 21:42:00","inspection_id":"82192445","insp_violation_id":"260797307","seq_no":"2","part_no":"393","part_no_section":"41","insp_viol_unit":"1","insp_unit_id":"202027290","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:53:15.000000Z","updated_at":"2025-03-17T21:53:15.000000Z","normalized_code":"39341"}],"inspection_per_units":[{"id":10132423,"change_date":"2024-07-23 21:42:00","inspection_id":"82192445","insp_unit_id":"202027290","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"60-16","insp_unit_license":"ECX768","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3C7WRNFL5GG231998","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:58.000000Z","updated_at":"2025-03-17T23:27:58.000000Z"}]},{"id":6007959,"change_date":"2024-06-17 21:43:00","inspection_id":"81891116","dot_number":"402330","report_state":"IA","report_number":"000P168W6G","insp_date":"2024-06-13 00:00:00","insp_start_time":"1059","insp_end_time":"1105","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 52 SB\/ SETTLERS LANE","county_code_state":"IA","county_code":"061","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"OWN","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-17 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"56500","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":"1316941","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":"00402330","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-06-13 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-06-17 21:43:00","insp_carrier_name":"TSCHIGGFRIE EXCAVATING","insp_carrier_street":"425 JULIEN DUBUQUE DRIVE","insp_carrier_city":"DUBUQUE","insp_carrier_state":"IA","insp_carrier_zip_code":"52003-7936","insp_colonia":null,"docket_number":"354630","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":9320675,"change_date":"2024-06-17 21:43:00","inspection_id":"81891116","insp_violation_id":"260123874","seq_no":"1","part_no":"392","part_no_section":"16(a)","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:51:07.000000Z","updated_at":"2025-03-17T21:51:07.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":9676698,"change_date":"2024-06-17 21:43:00","inspection_id":"81891116","insp_unit_id":"201429377","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"95312","insp_unit_license":"FP6955","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FVHGNDV8CDBE9337","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":3662976,"change_date":"2023-08-03 21:40:00","inspection_id":"79317126","dot_number":"402330","report_state":"IA","report_number":"000TT87H10","insp_date":"2023-08-02 00:00:00","insp_start_time":"1700","insp_end_time":"1720","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 20\/RACINE AVE WINTHROP","county_code_state":"IA","county_code":"019","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"TSCHIGGFRIE EXCAVATING","shipping_paper_number":"TOOLS","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-08-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"1283431","transaction_code":"A","transaction_date":"2023-08-03 00:00:00","upload_date":"2023-08-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00402330","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-08-02 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-08-03 21:40:00","insp_carrier_name":"TSCHIGGFRIE EXCAVATING","insp_carrier_street":"425 JULIEN DUBUQUE DRIVE","insp_carrier_city":"DUBUQUE","insp_carrier_state":"IA","insp_carrier_zip_code":"52003-7936","insp_colonia":null,"docket_number":"354630","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:35:15.000000Z","updated_at":"2025-03-17T19:35:15.000000Z","inspection_violations":[{"id":5646843,"change_date":"2023-08-03 21:40:00","inspection_id":"79317126","insp_violation_id":"254447940","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:33:11.000000Z","updated_at":"2025-03-17T21:33:11.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5889359,"change_date":"2023-08-03 21:40:00","inspection_id":"79317126","insp_unit_id":"196347187","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"44-15","insp_unit_license":"DPY475","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3C7WRMFLXFG620788","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:30.000000Z","updated_at":"2025-03-17T22:49:30.000000Z"}]},{"id":3619143,"change_date":"2023-07-28 21:41:00","inspection_id":"79267804","dot_number":"402330","report_state":"IA","report_number":"000TT8CGKK","insp_date":"2023-07-26 00:00:00","insp_start_time":"1330","insp_end_time":"1410","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"CORAL RIDGE AVE\/CORALVILLE","county_code_state":"IA","county_code":"103","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"TSCHIGGFRIE EXCAVATING","shipping_paper_number":"ROCK","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-07-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"1282410","transaction_code":"A","transaction_date":"2023-07-28 00:00:00","upload_date":"2023-07-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00402330","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-07-26 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-07-28 21:41:00","insp_carrier_name":"TSCHIGGFRIE EXCAVATING","insp_carrier_street":"425 JULIEN DUBUQUE DRIVE","insp_carrier_city":"DUBUQUE","insp_carrier_state":"IA","insp_carrier_zip_code":"52003-7936","insp_colonia":null,"docket_number":"354630","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:34:16.000000Z","updated_at":"2025-03-17T19:34:16.000000Z","inspection_violations":[{"id":5580888,"change_date":"2023-07-28 21:41:00","inspection_id":"79267804","insp_violation_id":"254340375","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":"9MCM23072613564","created_at":"2025-03-17T21:32:54.000000Z","updated_at":"2025-03-17T21:32:54.000000Z","normalized_code":"3922"},{"id":5580889,"change_date":"2023-07-28 21:41:00","inspection_id":"79267804","insp_violation_id":"254340376","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":"9MCM23072613573","created_at":"2025-03-17T21:32:54.000000Z","updated_at":"2025-03-17T21:32:54.000000Z","normalized_code":"3922"},{"id":5580890,"change_date":"2023-07-28 21:41:00","inspection_id":"79267804","insp_violation_id":"254340377","seq_no":"3","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:32:54.000000Z","updated_at":"2025-03-17T21:32:54.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":5818713,"change_date":"2023-07-28 21:41:00","inspection_id":"79267804","insp_unit_id":"196248964","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"12088","insp_unit_license":"SF5992","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1M2P198C4JW002861","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:56.000000Z","updated_at":"2025-03-17T22:48:56.000000Z"}]},{"id":3619365,"change_date":"2023-07-28 21:41:00","inspection_id":"79268064","dot_number":"402330","report_state":"IA","report_number":"000TT87H02","insp_date":"2023-07-26 00:00:00","insp_start_time":"0633","insp_end_time":"0645","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 20\/BUFFALO CREEK BLVD WINT","county_code_state":"IA","county_code":"019","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"TSCHIGGFRIE EXCAVATING","shipping_paper_number":"TOOLS","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-07-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"1282823","transaction_code":"A","transaction_date":"2023-07-28 00:00:00","upload_date":"2023-07-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00402330","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-07-26 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-07-28 21:41:00","insp_carrier_name":"TSCHIGGFRIE EXCAVATING","insp_carrier_street":"425 JULIEN DUBUQUE DRIVE","insp_carrier_city":"DUBUQUE","insp_carrier_state":"IA","insp_carrier_zip_code":"52003-7936","insp_colonia":null,"docket_number":"354630","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:34:16.000000Z","updated_at":"2025-03-17T19:34:16.000000Z","inspection_violations":[{"id":5581388,"change_date":"2023-07-28 21:41:00","inspection_id":"79268064","insp_violation_id":"254341084","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:32:54.000000Z","updated_at":"2025-03-17T21:32:54.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5819097,"change_date":"2023-07-28 21:41:00","inspection_id":"79268064","insp_unit_id":"196249446","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"44-15","insp_unit_license":"DPY475","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3C7WRMFLXFG620788","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:56.000000Z","updated_at":"2025-03-17T22:48:56.000000Z"}]},{"id":3354208,"change_date":"2023-06-23 21:40:00","inspection_id":"78970446","dot_number":"402330","report_state":"WI","report_number":"2346008130","insp_date":"2023-06-22 00:00:00","insp_start_time":"1250","insp_end_time":"1315","registration_date":null,"region":"CT","ci_status_code":"C","location":"S11","location_desc":"DICKEYVILLE SWEF","county_code_state":"WI","county_code":"043","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"IVERSON","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-06-23 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"73000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"898208","transaction_code":"A","transaction_date":"2023-06-23 00:00:00","upload_date":"2023-06-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00402330","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-06-23 00:00:00","source_office":"3WIS001","mcmis_add_date":"2023-06-23 21:40:00","insp_carrier_name":"TSCHIGGFRIE EXCAVATING","insp_carrier_street":"425 JULIEN DUBUQUE DRIVE","insp_carrier_city":"DUBUQUE","insp_carrier_state":"IA","insp_carrier_zip_code":"52003-7936","insp_colonia":null,"docket_number":"354630","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:29:23.000000Z","updated_at":"2025-03-17T19:29:23.000000Z","inspection_violations":[{"id":5172270,"change_date":"2023-06-23 21:40:00","inspection_id":"78970446","insp_violation_id":"253673604","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195650250","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:00.000000Z","updated_at":"2025-03-17T21:31:00.000000Z","normalized_code":"3922"},{"id":5172271,"change_date":"2023-06-23 21:40:00","inspection_id":"78970446","insp_violation_id":"253673605","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"195650250","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:00.000000Z","updated_at":"2025-03-17T21:31:00.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":5392149,"change_date":"2023-06-23 21:40:00","inspection_id":"78970446","insp_unit_id":"195650250","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"PP4046","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"2FVNFMCB7VA824795","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:32.000000Z","updated_at":"2025-03-17T22:45:32.000000Z"}]},{"id":3066837,"change_date":"2023-05-17 21:43:00","inspection_id":"78646017","dot_number":"402330","report_state":"IA","report_number":"000TT7106X","insp_date":"2023-05-16 00:00:00","insp_start_time":"1239","insp_end_time":"1305","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HJWY 151 SB","county_code_state":"IA","county_code":"061","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"OWN","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-17 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","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":"1275461","transaction_code":"A","transaction_date":"2023-05-17 00:00:00","upload_date":"2023-05-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00402330","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-05-16 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-05-17 21:43:00","insp_carrier_name":"TSCHIGGFRIE EXCAVATING","insp_carrier_street":"425 JULIEN DUBUQUE DRIVE","insp_carrier_city":"DUBUQUE","insp_carrier_state":"IA","insp_carrier_zip_code":"52003-7936","insp_colonia":null,"docket_number":"354630","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:23:45.000000Z","updated_at":"2025-03-17T19:23:45.000000Z","inspection_violations":[{"id":4711634,"change_date":"2023-05-17 21:43:00","inspection_id":"78646017","insp_violation_id":"252886861","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"194980509","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:57.000000Z","updated_at":"2025-03-17T21:28:57.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":4933596,"change_date":"2023-05-17 21:43:00","inspection_id":"78646017","insp_unit_id":"194980509","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"78898","insp_unit_license":"GGE191","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FV6HJBA0WHA02198","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:53.000000Z","updated_at":"2025-03-17T22:41:53.000000Z"},{"id":4933597,"change_date":"2023-05-17 21:43:00","inspection_id":"78646017","insp_unit_id":"194980510","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DELM","insp_unit_company":null,"insp_unit_license":"HA0062","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"4MWFS20289N024590","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:53.000000Z","updated_at":"2025-03-17T22:41:53.000000Z"}]},{"id":2955565,"change_date":"2023-05-03 21:42:00","inspection_id":"78520231","dot_number":"402330","report_state":"MI","report_number":"HOLLM03342","insp_date":"2023-05-02 00:00:00","insp_start_time":"2000","insp_end_time":"2030","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-94 W\/B @ RACE RD","county_code_state":"MI","county_code":"075","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-03 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1124538","transaction_code":"A","transaction_date":"2023-05-02 00:00:00","upload_date":"2023-05-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00402330","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-05-02 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-05-03 21:42:00","insp_carrier_name":"TSCHIGGFRIE EXCAVATING","insp_carrier_street":"425 JULIEN DUBUQUE DRIVE","insp_carrier_city":"DUBUQUE","insp_carrier_state":"IA","insp_carrier_zip_code":"52003","insp_colonia":null,"docket_number":"354630","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:21:25.000000Z","updated_at":"2025-03-17T19:21:25.000000Z","inspection_violations":[{"id":4536113,"change_date":"2023-05-03 21:42:00","inspection_id":"78520231","insp_violation_id":"252594485","seq_no":"1","part_no":"395","part_no_section":"8(f)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:07.000000Z","updated_at":"2025-03-17T21:28:07.000000Z","normalized_code":"3958F1"},{"id":4536114,"change_date":"2023-05-03 21:42:00","inspection_id":"78520231","insp_violation_id":"252594486","seq_no":"2","part_no":"392","part_no_section":"9(a)(2)","insp_viol_unit":"2","insp_unit_id":"194727540","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:28:07.000000Z","updated_at":"2025-03-17T21:28:07.000000Z","normalized_code":"3929A2"}],"inspection_per_units":[{"id":4755766,"change_date":"2023-05-03 21:42:00","inspection_id":"78520231","insp_unit_id":"194727539","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"PU3336","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKAD29X8TR680013","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:30.000000Z","updated_at":"2025-03-17T22:40:30.000000Z"},{"id":4755767,"change_date":"2023-05-03 21:42:00","inspection_id":"78520231","insp_unit_id":"194727540","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONT","insp_unit_company":null,"insp_unit_license":"IW7981","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"4LF4S4834S3503765","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:30.000000Z","updated_at":"2025-03-17T22:40:30.000000Z"}]},{"id":1860877,"change_date":"2022-12-02 21:41:00","inspection_id":"77272893","dot_number":"402330","report_state":"IA","report_number":"000TT7L9WW","insp_date":"2022-11-30 00:00:00","insp_start_time":"0830","insp_end_time":"0850","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HURTSVILLE AND ROCKDALE","county_code_state":"IA","county_code":"097","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"TSCHIGGFRIE EXCAVATING","shipping_paper_number":"ROCK","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-12-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"36000","viol_total":"4","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1253117","transaction_code":"A","transaction_date":"2022-12-02 00:00:00","upload_date":"2022-12-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00402330","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-11-30 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-12-02 21:41:00","insp_carrier_name":"TSCHIGGFRIE EXCAVATING","insp_carrier_street":"425 JULIEN DUBUQUE DRIVE","insp_carrier_city":"DUBUQUE","insp_carrier_state":"IA","insp_carrier_zip_code":"52003-7936","insp_colonia":null,"docket_number":"354630","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:01:04.000000Z","updated_at":"2025-03-17T19:01:04.000000Z","inspection_violations":[{"id":2899010,"change_date":"2022-12-02 21:41:00","inspection_id":"77272893","insp_violation_id":"249891824","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"192234265","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:48.000000Z","updated_at":"2025-03-17T21:20:48.000000Z","normalized_code":"3939A"},{"id":2899011,"change_date":"2022-12-02 21:41:00","inspection_id":"77272893","insp_violation_id":"249891825","seq_no":"2","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"192234265","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:48.000000Z","updated_at":"2025-03-17T21:20:48.000000Z","normalized_code":"39395F"},{"id":2899012,"change_date":"2022-12-02 21:41:00","inspection_id":"77272893","insp_violation_id":"249891826","seq_no":"3","part_no":"393","part_no_section":"110(c)","insp_viol_unit":"1","insp_unit_id":"192234265","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:20:48.000000Z","updated_at":"2025-03-17T21:20:48.000000Z","normalized_code":"393110C"},{"id":2899013,"change_date":"2022-12-02 21:41:00","inspection_id":"77272893","insp_violation_id":"249891827","seq_no":"4","part_no":"392","part_no_section":"16(b)","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:20:48.000000Z","updated_at":"2025-03-17T21:20:48.000000Z","normalized_code":"39216B"}],"inspection_per_units":[{"id":2994617,"change_date":"2022-12-02 21:41:00","inspection_id":"77272893","insp_unit_id":"192234265","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"STRG","insp_unit_company":"1022-05","insp_unit_license":"MBJ793","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"2FZAAYCV15AN29978","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:29.000000Z","updated_at":"2025-03-17T22:27:29.000000Z"}]},{"id":1303029,"change_date":"2022-09-16 21:40:00","inspection_id":"76630219","dot_number":"402330","report_state":"IA","report_number":"000TT7D6VN","insp_date":"2022-09-15 00:00:00","insp_start_time":"1500","insp_end_time":"1515","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"330TH AND IOWA AVE BRANDON","county_code_state":"IA","county_code":"019","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"TSCHIGGFRIE EXCAVATING","shipping_paper_number":"2511856","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-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"62000","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":"1242565","transaction_code":"A","transaction_date":"2022-09-16 00:00:00","upload_date":"2022-09-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00402330","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-09-15 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-09-16 21:40:00","insp_carrier_name":"TSCHIGGFRIE EXCAVATING","insp_carrier_street":"425 JULIEN DUBUQUE DRIVE","insp_carrier_city":"DUBUQUE","insp_carrier_state":"IA","insp_carrier_zip_code":"52003-7936","insp_colonia":null,"docket_number":"354630","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:50:48.000000Z","updated_at":"2025-03-17T18:50:48.000000Z","inspection_violations":[{"id":2061543,"change_date":"2022-09-16 21:40:00","inspection_id":"76630219","insp_violation_id":"248466383","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:28.000000Z","updated_at":"2025-03-17T21:16:28.000000Z","normalized_code":"3922"},{"id":2061544,"change_date":"2022-09-16 21:40:00","inspection_id":"76630219","insp_violation_id":"248466384","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:28.000000Z","updated_at":"2025-03-17T21:16:28.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2097055,"change_date":"2022-09-16 21:40:00","inspection_id":"76630219","insp_unit_id":"190942555","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"13397","insp_unit_license":"PP4044","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"2FVNFMCB3VA824793","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:23.000000Z","updated_at":"2025-03-17T22:21:23.000000Z"}]},{"id":1294281,"change_date":"2022-09-15 21:40:00","inspection_id":"76619642","dot_number":"402330","report_state":"IA","report_number":"000TT7D6VJ","insp_date":"2022-09-14 00:00:00","insp_start_time":"1600","insp_end_time":"1615","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"4TH AVE AND 1ST ST NE INDEPEND","county_code_state":"IA","county_code":"019","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"TSCHIGGFRIE EXCAVATING","shipping_paper_number":"MINI CRAWLER","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-15 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"45700","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":"1242336","transaction_code":"A","transaction_date":"2022-09-15 00:00:00","upload_date":"2022-09-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00402330","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-09-14 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-09-15 21:40:00","insp_carrier_name":"TSCHIGGFRIE EXCAVATING","insp_carrier_street":"425 JULIEN DUBUQUE DRIVE","insp_carrier_city":"DUBUQUE","insp_carrier_state":"IA","insp_carrier_zip_code":"52003-7936","insp_colonia":null,"docket_number":"354630","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:50:30.000000Z","updated_at":"2025-03-17T18:50:30.000000Z","inspection_violations":[{"id":2047877,"change_date":"2022-09-15 21:40:00","inspection_id":"76619642","insp_violation_id":"248438263","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"190920333","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:24.000000Z","updated_at":"2025-03-17T21:16:24.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":2083251,"change_date":"2022-09-15 21:40:00","inspection_id":"76619642","insp_unit_id":"190920333","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"44-15","insp_unit_license":"DPY475","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3C7WRMFLXFG620788","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:17.000000Z","updated_at":"2025-03-17T22:21:17.000000Z"},{"id":2083252,"change_date":"2022-09-15 21:40:00","inspection_id":"76619642","insp_unit_id":"190920334","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLK","insp_unit_company":"534-14","insp_unit_license":"CA4153","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1TKC02427FR105846","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:17.000000Z","updated_at":"2025-03-17T22:21:17.000000Z"}]},{"id":1146250,"change_date":"2022-08-26 21:40:00","inspection_id":"76448374","dot_number":"402330","report_state":"IA","report_number":"000TT66GJ4","insp_date":"2022-08-23 00:00:00","insp_start_time":"1155","insp_end_time":"1300","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"EB, BRANDON","county_code_state":"IA","county_code":"019","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"BRUENING","shipping_paper_number":"2648587","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-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"137740","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":"1239511","transaction_code":"A","transaction_date":"2022-08-26 00:00:00","upload_date":"2022-08-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00402330","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-08-23 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-08-26 21:40:00","insp_carrier_name":"TSCHIGGFRIE EXCAVATING","insp_carrier_street":"425 JULIEN DUBUQUE DRIVE","insp_carrier_city":"DUBUQUE","insp_carrier_state":"IA","insp_carrier_zip_code":"52003-7936","insp_colonia":null,"docket_number":"354630","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:47:54.000000Z","updated_at":"2025-03-17T18:47:54.000000Z","inspection_violations":[{"id":1814356,"change_date":"2022-08-26 21:40:00","inspection_id":"76448374","insp_violation_id":"248027995","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:15:25.000000Z","updated_at":"2025-03-17T21:15:25.000000Z","normalized_code":"3922"},{"id":1814357,"change_date":"2022-08-26 21:40:00","inspection_id":"76448374","insp_violation_id":"248027996","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":"T28922082312510","created_at":"2025-03-17T21:15:25.000000Z","updated_at":"2025-03-17T21:15:25.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1842524,"change_date":"2022-08-26 21:40:00","inspection_id":"76448374","insp_unit_id":"190566912","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"16402","insp_unit_license":"SC6204","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKWDB0X62J889864","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:42.000000Z","updated_at":"2025-03-17T22:19:42.000000Z"},{"id":1842525,"change_date":"2022-08-26 21:40:00","inspection_id":"76448374","insp_unit_id":"190566913","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"SMITH","insp_unit_company":"51307","insp_unit_license":"CA4217","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1S9SS50217L476422","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:42.000000Z","updated_at":"2025-03-17T22:19:42.000000Z"}]},{"id":1146476,"change_date":"2022-08-26 21:40:00","inspection_id":"76448642","dot_number":"402330","report_state":"IA","report_number":"000TT7L9R0","insp_date":"2022-08-23 00:00:00","insp_start_time":"0810","insp_end_time":"0845","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"SB 61","county_code_state":"IA","county_code":"061","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"TSCHIGGFRIE EXCAVATING","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":"2022-08-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"20200","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1239460","transaction_code":"A","transaction_date":"2022-08-26 00:00:00","upload_date":"2022-08-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00402330","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-08-23 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-08-26 21:40:00","insp_carrier_name":"TSCHIGGFRIE EXCAVATING","insp_carrier_street":"425 JULIEN DUBUQUE DRIVE","insp_carrier_city":"DUBUQUE","insp_carrier_state":"IA","insp_carrier_zip_code":"52003-7936","insp_colonia":null,"docket_number":"354630","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:47:54.000000Z","updated_at":"2025-03-17T18:47:54.000000Z","inspection_violations":[{"id":1814815,"change_date":"2022-08-26 21:40:00","inspection_id":"76448642","insp_violation_id":"248028632","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"190567390","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:25.000000Z","updated_at":"2025-03-17T21:15:25.000000Z","normalized_code":"3939A"},{"id":1814816,"change_date":"2022-08-26 21:40:00","inspection_id":"76448642","insp_violation_id":"248028633","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"190567390","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:15:25.000000Z","updated_at":"2025-03-17T21:15:25.000000Z","normalized_code":"3939A"},{"id":1814817,"change_date":"2022-08-26 21:40:00","inspection_id":"76448642","insp_violation_id":"248028634","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"190567390","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:25.000000Z","updated_at":"2025-03-17T21:15:25.000000Z","normalized_code":"3939A"},{"id":1814818,"change_date":"2022-08-26 21:40:00","inspection_id":"76448642","insp_violation_id":"248028635","seq_no":"4","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"190567389","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:25.000000Z","updated_at":"2025-03-17T21:15:25.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":1842908,"change_date":"2022-08-26 21:40:00","inspection_id":"76448642","insp_unit_id":"190567389","insp_unit_type_id":"9","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":"866-19","insp_unit_license":"IJC665","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GB4KVCY7KF181208","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:42.000000Z","updated_at":"2025-03-17T22:19:42.000000Z"},{"id":1842909,"change_date":"2022-08-26 21:40:00","inspection_id":"76448642","insp_unit_id":"190567390","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"SPECIALLY","insp_unit_company":"410-92","insp_unit_license":"9779PB","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"NO VIN","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:42.000000Z","updated_at":"2025-03-17T22:19:42.000000Z"}]},{"id":406856,"change_date":"2022-05-17 21:43:00","inspection_id":"75578379","dot_number":"402330","report_state":"IA","report_number":"000TT7L9J7","insp_date":"2022-05-16 00:00:00","insp_start_time":"0800","insp_end_time":"0820","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"NORTH MAIN AND PERSHING","county_code_state":"IA","county_code":"097","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"TSCHIGGFRIE 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-05-17 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"34500","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":"1225134","transaction_code":"A","transaction_date":"2022-05-17 00:00:00","upload_date":"2022-05-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00402330","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-05-16 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-05-17 21:43:00","insp_carrier_name":"TSCHIGGFRIE EXCAVATING","insp_carrier_street":"425 JULIEN DUBUQUE DRIVE","insp_carrier_city":"DUBUQUE","insp_carrier_state":"IA","insp_carrier_zip_code":"52003-7936","insp_colonia":null,"docket_number":"354630","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:34:46.000000Z","updated_at":"2025-03-17T18:34:46.000000Z","inspection_violations":[{"id":636092,"change_date":"2022-05-17 21:43:00","inspection_id":"75578379","insp_violation_id":"245835550","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:09:58.000000Z","updated_at":"2025-03-17T21:09:58.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":656877,"change_date":"2022-05-17 21:43:00","inspection_id":"75578379","insp_unit_id":"188724040","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"88-98","insp_unit_license":"CSX587","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"4VGJBAPE9WN862786","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:14.000000Z","updated_at":"2025-03-17T22:12:14.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/402330\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/402330\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/402330\/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\/402330\/inspections","per_page":100,"prev_page_url":null,"to":33,"total":33}