{"current_page":1,"data":[{"id":11365709,"change_date":"2026-03-13 21:37:00","inspection_id":"87279074","dot_number":"1362229","report_state":"WI","report_number":"2687006637","insp_date":"2026-03-10 00:00:00","insp_start_time":"1109","insp_end_time":"1126","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"CHILTON WI","county_code_state":"WI","county_code":"015","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":"U","pen_cen_match":"I","final_status_date":"2026-03-13 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"64000","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":"2999251","transaction_code":"A","transaction_date":"2026-03-12 00:00:00","upload_date":"2026-03-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01362229","upload_search_indicator":null,"census_search_date":"2026-03-13 21:37:00","snet_input_date":"2026-03-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-13 21:37:00","insp_carrier_name":"C SPIELVOGEL & SONS EXCAVATING INC","insp_carrier_street":"1810 NORTH 44TH STREET","insp_carrier_city":"SHEBOYGAN","insp_carrier_state":"WI","insp_carrier_zip_code":"53083","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-16T09:39:08.000000Z","updated_at":"2026-03-24T09:30:15.000000Z","inspection_violations":[{"id":19151805,"change_date":"2026-03-13 21:37:00","inspection_id":"87279074","insp_violation_id":"272380449","seq_no":"1","part_no":"392","part_no_section":"16-D","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"BL877749-5","created_at":"2026-03-16T10:00:59.000000Z","updated_at":"2026-03-24T09:42:56.000000Z","normalized_code":"39216D"}],"inspection_per_units":[{"id":19461606,"change_date":"2026-03-13 21:37:00","inspection_id":"87279074","insp_unit_id":"212115649","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"RB36923","insp_unit_license_state":"WI","insp_unit_vehicle_id_number":"1M2GR4GC8MM023130","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-16T09:16:51.000000Z","updated_at":"2026-03-24T09:03:29.000000Z"}]},{"id":9854106,"change_date":"2025-10-04 21:33:00","inspection_id":"85956063","dot_number":"1362229","report_state":"WI","report_number":"2556002685","insp_date":"2025-10-01 00:00:00","insp_start_time":"1448","insp_end_time":"1459","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"GREENBUSH WI","county_code_state":"WI","county_code":"117","insp_level_id":"2","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":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-10-04 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"32500","viol_total":"5","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":"2363728","transaction_code":"A","transaction_date":"2025-10-03 00:00:00","upload_date":"2025-10-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01362229","upload_search_indicator":null,"census_search_date":"2025-10-04 21:33:00","snet_input_date":"2025-10-01 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-04 21:33:00","insp_carrier_name":"C SPIELVOGEL & SONS EXCAVATING INC","insp_carrier_street":"1810 NORTH 44TH STREET","insp_carrier_city":"SHEBOYGAN","insp_carrier_state":"WI","insp_carrier_zip_code":"53083","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-08T10:01:23.000000Z","updated_at":"2025-10-08T10:01:23.000000Z","inspection_violations":[{"id":16230151,"change_date":"2025-10-04 21:33:00","inspection_id":"85956063","insp_violation_id":"269094494","seq_no":"1","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"209296010","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-08T10:17:28.000000Z","updated_at":"2025-10-08T10:17:28.000000Z","normalized_code":"39021TB1MC"},{"id":16230152,"change_date":"2025-10-04 21:33:00","inspection_id":"85956063","insp_violation_id":"269094495","seq_no":"2","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"209296010","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-08T10:17:28.000000Z","updated_at":"2025-10-08T10:17:28.000000Z","normalized_code":"39021TB2DOT"},{"id":16230153,"change_date":"2025-10-04 21:33:00","inspection_id":"85956063","insp_violation_id":"269094496","seq_no":"3","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"209296010","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-08T10:17:28.000000Z","updated_at":"2025-10-08T10:17:28.000000Z","normalized_code":"39395A1"},{"id":16230154,"change_date":"2025-10-04 21:33:00","inspection_id":"85956063","insp_violation_id":"269094497","seq_no":"4","part_no":"393","part_no_section":"95F","insp_viol_unit":"2","insp_unit_id":"209296011","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-08T10:17:28.000000Z","updated_at":"2025-10-08T10:17:28.000000Z","normalized_code":"39395F"},{"id":16230155,"change_date":"2025-10-04 21:33:00","inspection_id":"85956063","insp_violation_id":"269094498","seq_no":"5","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"209296010","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-08T10:17:28.000000Z","updated_at":"2025-10-08T10:17:28.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":16342368,"change_date":"2025-10-04 21:33:00","inspection_id":"85956063","insp_unit_id":"209296010","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"LL9254","insp_unit_license_state":"WI","insp_unit_vehicle_id_number":"1FT8W3BT3EEB86847","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-08T09:46:43.000000Z","updated_at":"2025-10-08T09:46:43.000000Z"},{"id":16342369,"change_date":"2025-10-04 21:33:00","inspection_id":"85956063","insp_unit_id":"209296011","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"UNKNOWN","insp_unit_company":null,"insp_unit_license":"FR32942","insp_unit_license_state":"WI","insp_unit_vehicle_id_number":"4ZECH2431P1291968","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-08T09:46:43.000000Z","updated_at":"2025-10-08T09:46:43.000000Z"}]},{"id":9799499,"change_date":"2025-09-28 21:33:00","inspection_id":"85898847","dot_number":"1362229","report_state":"WI","report_number":"2280016428","insp_date":"2025-09-25 00:00:00","insp_start_time":"1400","insp_end_time":"1440","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"NEWTON WI","county_code_state":"WI","county_code":"071","insp_level_id":"2","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":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-09-28 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"162000","viol_total":"9","oos_total":"4","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"4","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2337949","transaction_code":"A","transaction_date":"2025-09-27 00:00:00","upload_date":"2025-09-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01362229","upload_search_indicator":null,"census_search_date":"2025-09-28 21:33:00","snet_input_date":"2025-09-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-28 21:33:00","insp_carrier_name":"C SPIELVOGEL & SONS EXCAVATING INC","insp_carrier_street":"1810 NORTH 44TH STREET","insp_carrier_city":"SHEBOYGAN","insp_carrier_state":"WI","insp_carrier_zip_code":"53083","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-01T10:00:18.000000Z","updated_at":"2025-10-02T10:00:07.000000Z","inspection_violations":[{"id":16116368,"change_date":"2025-09-28 21:33:00","inspection_id":"85898847","insp_violation_id":"268965947","seq_no":"1","part_no":"393","part_no_section":"104F3-C","insp_viol_unit":"2","insp_unit_id":"209186244","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-01T10:15:24.000000Z","updated_at":"2025-10-02T10:15:09.000000Z","normalized_code":"393104F3C"},{"id":16116369,"change_date":"2025-09-28 21:33:00","inspection_id":"85898847","insp_violation_id":"268965948","seq_no":"2","part_no":"393","part_no_section":"11A1-CSLRR","insp_viol_unit":"1","insp_unit_id":"209186245","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-01T10:15:24.000000Z","updated_at":"2025-10-02T10:15:09.000000Z","normalized_code":"39311A1CSLRR"},{"id":16116370,"change_date":"2025-09-28 21:33:00","inspection_id":"85898847","insp_violation_id":"268965949","seq_no":"3","part_no":"393","part_no_section":"130C-CHVE","insp_viol_unit":"2","insp_unit_id":"209186244","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-10-01T10:15:24.000000Z","updated_at":"2025-10-02T10:15:09.000000Z","normalized_code":"393130CCHVE"},{"id":16116371,"change_date":"2025-09-28 21:33:00","inspection_id":"85898847","insp_violation_id":"268965950","seq_no":"4","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"209186245","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-01T10:15:24.000000Z","updated_at":"2025-10-02T10:15:09.000000Z","normalized_code":"3939ALCL"},{"id":16116372,"change_date":"2025-09-28 21:33:00","inspection_id":"85898847","insp_violation_id":"268965951","seq_no":"5","part_no":"396","part_no_section":"3A1-BALR","insp_viol_unit":"1","insp_unit_id":"209186245","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-10-01T10:15:24.000000Z","updated_at":"2025-10-02T10:15:09.000000Z","normalized_code":"3963A1BALR"},{"id":16116373,"change_date":"2025-09-28 21:33:00","inspection_id":"85898847","insp_violation_id":"268965952","seq_no":"6","part_no":"393","part_no_section":"45B2-BHTD","insp_viol_unit":"2","insp_unit_id":"209186244","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-10-01T10:15:24.000000Z","updated_at":"2025-10-02T10:15:09.000000Z","normalized_code":"39345B2BHTD"},{"id":16116374,"change_date":"2025-09-28 21:33:00","inspection_id":"85898847","insp_violation_id":"268965953","seq_no":"7","part_no":"393","part_no_section":"45D-BHDB","insp_viol_unit":"2","insp_unit_id":"209186244","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-10-01T10:15:24.000000Z","updated_at":"2025-10-02T10:15:09.000000Z","normalized_code":"39345DBHDB"},{"id":16116375,"change_date":"2025-09-28 21:33:00","inspection_id":"85898847","insp_violation_id":"268965954","seq_no":"8","part_no":"392","part_no_section":"2-SLLSIV","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-01T10:15:24.000000Z","updated_at":"2025-10-02T10:15:09.000000Z","normalized_code":"3922SLLSIV"},{"id":16116376,"change_date":"2025-09-28 21:33:00","inspection_id":"85898847","insp_violation_id":"268965955","seq_no":"9","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-01T10:15:24.000000Z","updated_at":"2025-10-02T10:15:09.000000Z","normalized_code":"3922SLL"}],"inspection_per_units":[{"id":16240584,"change_date":"2025-09-28 21:33:00","inspection_id":"85898847","insp_unit_id":"209186244","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAIL KING","insp_unit_company":null,"insp_unit_license":"857615","insp_unit_license_state":"WI","insp_unit_vehicle_id_number":"1TKJ05337DM041627","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-01T09:45:19.000000Z","updated_at":"2025-10-02T09:45:09.000000Z"},{"id":16240585,"change_date":"2025-09-28 21:33:00","inspection_id":"85898847","insp_unit_id":"209186245","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WESTERN ST","insp_unit_company":"341","insp_unit_license":"TS50138","insp_unit_license_state":"WI","insp_unit_vehicle_id_number":"2WKRDDJHX1K967384","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-01T09:45:19.000000Z","updated_at":"2025-10-02T09:45:09.000000Z"}]},{"id":9360743,"change_date":"2025-08-08 21:39:00","inspection_id":"85438246","dot_number":"1362229","report_state":"WI","report_number":"2556002596","insp_date":"2025-08-05 00:00:00","insp_start_time":"1728","insp_end_time":"1738","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"GREENBUSH WI","county_code_state":"WI","county_code":"117","insp_level_id":"2","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":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-08-08 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"31000","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":"2099763","transaction_code":"A","transaction_date":"2025-08-07 00:00:00","upload_date":"2025-08-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01362229","upload_search_indicator":null,"census_search_date":"2025-08-08 21:39:00","snet_input_date":"2025-08-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-08 21:39:00","insp_carrier_name":"C SPIELVOGEL & SONS EXCAVATING INC","insp_carrier_street":"1810 NORTH 44TH STREET","insp_carrier_city":"SHEBOYGAN","insp_carrier_state":"WI","insp_carrier_zip_code":"53083","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-12T10:44:10.000000Z","updated_at":"2025-08-12T10:44:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15422175,"change_date":"2025-08-08 21:39:00","inspection_id":"85438246","insp_unit_id":"208297937","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"DG84188","insp_unit_license_state":"WI","insp_unit_vehicle_id_number":"1FT7X2BT2BEC16242","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-11T09:46:22.000000Z","updated_at":"2025-08-12T09:45:34.000000Z"},{"id":15422176,"change_date":"2025-08-08 21:39:00","inspection_id":"85438246","insp_unit_id":"208297938","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"UNKNOWN","insp_unit_company":null,"insp_unit_license":"FR20314","insp_unit_license_state":"WI","insp_unit_vehicle_id_number":"4ZECH2431P1291968","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-11T09:46:22.000000Z","updated_at":"2025-08-12T09:45:34.000000Z"}]},{"id":9192672,"change_date":"2025-07-19 21:33:00","inspection_id":"85261317","dot_number":"1362229","report_state":"WI","report_number":"2556002571","insp_date":"2025-07-16 00:00:00","insp_start_time":"0752","insp_end_time":"0802","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"KIEL WI","county_code_state":"WI","county_code":"071","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":"U","pen_cen_match":"I","final_status_date":"2025-07-19 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"62400","viol_total":"2","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":"2013147","transaction_code":"A","transaction_date":"2025-07-18 00:00:00","upload_date":"2025-07-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01362229","upload_search_indicator":null,"census_search_date":"2025-07-19 21:33:00","snet_input_date":"2025-07-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-19 21:33:00","insp_carrier_name":"C SPIELVOGEL & SONS EXCAVATING INC","insp_carrier_street":"1810 NORTH 44TH STREET","insp_carrier_city":"SHEBOYGAN","insp_carrier_state":"WI","insp_carrier_zip_code":"53083","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-22T10:45:29.000000Z","updated_at":"2025-07-23T10:40:26.000000Z","inspection_violations":[{"id":14850018,"change_date":"2025-07-19 21:33:00","inspection_id":"85261317","insp_violation_id":"267509065","seq_no":"1","part_no":"392","part_no_section":"2-SLLFC","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-22T10:46:57.000000Z","updated_at":"2025-07-23T10:40:47.000000Z","normalized_code":"3922SLLFC"},{"id":14850019,"change_date":"2025-07-19 21:33:00","inspection_id":"85261317","insp_violation_id":"267509066","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"207959762","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-22T10:46:57.000000Z","updated_at":"2025-07-23T10:40:47.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":15107520,"change_date":"2025-07-19 21:33:00","inspection_id":"85261317","insp_unit_id":"207959762","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"208","insp_unit_license":"RB22811","insp_unit_license_state":"WI","insp_unit_vehicle_id_number":"1XPALE0X4TN415754","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-22T09:46:11.000000Z","updated_at":"2025-07-23T09:45:06.000000Z"}]},{"id":6417582,"change_date":"2024-08-08 21:41:00","inspection_id":"82330688","dot_number":"1362229","report_state":"WI","report_number":"2556001855","insp_date":"2024-08-02 00:00:00","insp_start_time":"0921","insp_end_time":"0936","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"SHEBOYGAN FALLS WI","county_code_state":"WI","county_code":"117","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":"U","pen_cen_match":"I","final_status_date":"2024-08-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"727803","transaction_code":"A","transaction_date":"2024-08-08 00:00:00","upload_date":"2024-08-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01362229","upload_search_indicator":null,"census_search_date":"2024-08-08 21:41:00","snet_input_date":"2024-08-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-08 21:41:00","insp_carrier_name":"C SPIELVOGEL & SONS EXCAVATING INC","insp_carrier_street":"1810 NORTH 44TH STREET","insp_carrier_city":"SHEBOYGAN","insp_carrier_state":"WI","insp_carrier_zip_code":"53083","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:29:55.000000Z","updated_at":"2025-03-17T20:29:55.000000Z","inspection_violations":[{"id":9964808,"change_date":"2024-08-08 21:41:00","inspection_id":"82330688","insp_violation_id":"261078285","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:13.000000Z","updated_at":"2025-03-17T21:54:13.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10342884,"change_date":"2024-08-08 21:41:00","inspection_id":"82330688","insp_unit_id":"202290242","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"339","insp_unit_license":"TS40469","insp_unit_license_state":"WI","insp_unit_vehicle_id_number":"1M1AK06Y47N017408","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:10.000000Z","updated_at":"2025-03-17T23:30:10.000000Z"},{"id":10342885,"change_date":"2024-08-08 21:41:00","inspection_id":"82330688","insp_unit_id":"202290243","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAILSTAR","insp_unit_company":null,"insp_unit_license":"427435","insp_unit_license_state":"WI","insp_unit_vehicle_id_number":"1T9DS28C8K1066521","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:10.000000Z","updated_at":"2025-03-17T23:30:10.000000Z"}]},{"id":6126033,"change_date":"2025-11-22 21:48:00","inspection_id":"82018048","dot_number":"1362229","report_state":"WI","report_number":"2638004004","insp_date":"2024-06-26 00:00:00","insp_start_time":"1608","insp_end_time":"1240","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"GRAFTON WI","county_code_state":"WI","county_code":"089","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"B&B METALS","shipping_paper_number":"32455","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":"2024-07-02 21:41:00","post_acc_ind":"Y","gross_comb_veh_wt":"132000","viol_total":"12","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"619913","transaction_code":"C","transaction_date":"2024-07-02 00:00:00","upload_date":"2025-11-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01362229","upload_search_indicator":null,"census_search_date":"2024-07-02 21:41:00","snet_input_date":"2024-06-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-07-02 21:41:00","insp_carrier_name":"C SPIELVOGEL & SONS EXCAVATING INC","insp_carrier_street":"1810 NORTH 44TH STREET","insp_carrier_city":"SHEBOYGAN","insp_carrier_state":"WI","insp_carrier_zip_code":"53083","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:24:11.000000Z","updated_at":"2025-11-26T10:30:28.000000Z","inspection_violations":[{"id":17101687,"change_date":"2025-11-22 21:48:00","inspection_id":"82018048","insp_violation_id":"270181945","seq_no":"1","part_no":"392","part_no_section":"9AA1","insp_viol_unit":"1","insp_unit_id":"210197934","insp_violation_category_id":"51","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-11-25T10:32:19.000000Z","updated_at":"2025-11-26T10:32:32.000000Z","normalized_code":"3929AA1"},{"id":17101688,"change_date":"2025-11-22 21:48:00","inspection_id":"82018048","insp_violation_id":"270181946","seq_no":"2","part_no":"393","part_no_section":"9A-LSML","insp_viol_unit":"2","insp_unit_id":"210197935","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-25T10:32:19.000000Z","updated_at":"2025-11-26T10:32:32.000000Z","normalized_code":"3939ALSML"},{"id":17101689,"change_date":"2025-11-22 21:48:00","inspection_id":"82018048","insp_violation_id":"270181947","seq_no":"3","part_no":"392","part_no_section":"14-D","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"BJ826484","created_at":"2025-11-25T10:32:19.000000Z","updated_at":"2025-11-26T10:32:32.000000Z","normalized_code":"39214D"},{"id":17101690,"change_date":"2025-11-22 21:48:00","inspection_id":"82018048","insp_violation_id":"270181948","seq_no":"4","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"210197934","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-25T10:32:19.000000Z","updated_at":"2025-11-26T10:32:32.000000Z","normalized_code":"39360C"},{"id":17101691,"change_date":"2025-11-22 21:48:00","inspection_id":"82018048","insp_violation_id":"270181949","seq_no":"5","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"210197934","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-25T10:32:19.000000Z","updated_at":"2025-11-26T10:32:32.000000Z","normalized_code":"39360D"},{"id":17101692,"change_date":"2025-11-22 21:48:00","inspection_id":"82018048","insp_violation_id":"270181950","seq_no":"6","part_no":"393","part_no_section":"45B2-B","insp_viol_unit":"1","insp_unit_id":"210197934","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-25T10:32:19.000000Z","updated_at":"2025-11-26T10:32:32.000000Z","normalized_code":"39345B2B"},{"id":17101693,"change_date":"2025-11-22 21:48:00","inspection_id":"82018048","insp_violation_id":"270181951","seq_no":"7","part_no":"393","part_no_section":"203C-CBP","insp_viol_unit":"1","insp_unit_id":"210197934","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-25T10:32:19.000000Z","updated_at":"2025-11-26T10:32:32.000000Z","normalized_code":"393203CCBP"},{"id":17101694,"change_date":"2025-11-22 21:48:00","inspection_id":"82018048","insp_violation_id":"270181952","seq_no":"8","part_no":"393","part_no_section":"55E-B","insp_viol_unit":"2","insp_unit_id":"210197935","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-25T10:32:19.000000Z","updated_at":"2025-11-26T10:32:32.000000Z","normalized_code":"39355EB"},{"id":17101695,"change_date":"2025-11-22 21:48:00","inspection_id":"82018048","insp_violation_id":"270181953","seq_no":"9","part_no":"393","part_no_section":"11A1-LIL","insp_viol_unit":"2","insp_unit_id":"210197935","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-25T10:32:19.000000Z","updated_at":"2025-11-26T10:32:32.000000Z","normalized_code":"39311A1LIL"},{"id":17101696,"change_date":"2025-11-22 21:48:00","inspection_id":"82018048","insp_violation_id":"270181954","seq_no":"10","part_no":"387","part_no_section":"301A","insp_viol_unit":"1","insp_unit_id":"210197934","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-25T10:32:19.000000Z","updated_at":"2025-11-26T10:32:32.000000Z","normalized_code":"387301A"},{"id":17101697,"change_date":"2025-11-22 21:48:00","inspection_id":"82018048","insp_violation_id":"270181955","seq_no":"11","part_no":"393","part_no_section":"201C-FR","insp_viol_unit":"2","insp_unit_id":"210197935","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-25T10:32:19.000000Z","updated_at":"2025-11-26T10:32:32.000000Z","normalized_code":"393201CFR"},{"id":17101698,"change_date":"2025-11-22 21:48:00","inspection_id":"82018048","insp_violation_id":"270181956","seq_no":"12","part_no":"393","part_no_section":"100B-C","insp_viol_unit":"2","insp_unit_id":"210197935","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-11-25T10:32:19.000000Z","updated_at":"2025-11-26T10:32:32.000000Z","normalized_code":"393100BC"}],"inspection_per_units":[{"id":17118838,"change_date":"2025-11-22 21:48:00","inspection_id":"82018048","insp_unit_id":"210197934","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"342","insp_unit_license":"45588Z","insp_unit_license_state":"WI","insp_unit_vehicle_id_number":"1XKZDP9X2FJ466136","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-25T10:01:21.000000Z","updated_at":"2025-11-26T10:00:34.000000Z"},{"id":17118839,"change_date":"2025-11-22 21:48:00","inspection_id":"82018048","insp_unit_id":"210197935","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"812442","insp_unit_license_state":"WI","insp_unit_vehicle_id_number":"5C2BR40B5NM012119","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-25T10:01:21.000000Z","updated_at":"2025-11-26T10:00:34.000000Z"}]},{"id":5507088,"change_date":"2024-04-15 21:40:00","inspection_id":"81346764","dot_number":"1362229","report_state":"WI","report_number":"2259008164","insp_date":"2024-04-09 00:00:00","insp_start_time":"0756","insp_end_time":"0817","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"TOWN SHEBOYGAN FALLS WI","county_code_state":"WI","county_code":"117","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":"U","pen_cen_match":"I","final_status_date":"2024-04-15 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"397883","transaction_code":"A","transaction_date":"2024-04-15 00:00:00","upload_date":"2024-04-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01362229","upload_search_indicator":null,"census_search_date":"2024-04-15 21:40:00","snet_input_date":"2024-04-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-04-15 21:40:00","insp_carrier_name":"C SPIELVOGEL & SONS EXCAVATING INC","insp_carrier_street":"1810 NORTH 44TH STREET","insp_carrier_city":"SHEBOYGAN","insp_carrier_state":"WI","insp_carrier_zip_code":"53083","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:11:56.000000Z","updated_at":"2025-03-17T20:11:56.000000Z","inspection_violations":[{"id":8508007,"change_date":"2024-04-15 21:40:00","inspection_id":"81346764","insp_violation_id":"258921418","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:14.000000Z","updated_at":"2025-03-17T21:47:14.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8871121,"change_date":"2024-04-15 21:40:00","inspection_id":"81346764","insp_unit_id":"200388261","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"339","insp_unit_license":"TS40449","insp_unit_license_state":"WI","insp_unit_vehicle_id_number":"1M1AK06Y47N017408","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:32.000000Z","updated_at":"2025-03-17T23:15:32.000000Z"},{"id":8871122,"change_date":"2024-04-15 21:40:00","inspection_id":"81346764","insp_unit_id":"200388262","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAGER BEAV","insp_unit_company":null,"insp_unit_license":"798638","insp_unit_license_state":"WI","insp_unit_vehicle_id_number":"112HGB335HS500092","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:32.000000Z","updated_at":"2025-03-17T23:15:32.000000Z"}]},{"id":5240678,"change_date":"2024-03-08 21:39:00","inspection_id":"81055975","dot_number":"1362229","report_state":"WI","report_number":"2259008101","insp_date":"2024-03-01 00:00:00","insp_start_time":"1041","insp_end_time":"1106","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"TOWN EMPIRE WI","county_code_state":"WI","county_code":"039","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":"2024-03-08 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"173680","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":"299897","transaction_code":"A","transaction_date":"2024-03-07 00:00:00","upload_date":"2024-03-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01362229","upload_search_indicator":null,"census_search_date":"2024-03-08 21:39:00","snet_input_date":"2024-03-01 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-03-08 21:39:00","insp_carrier_name":"C SPIELVOGEL & SONS EXCAVATING INC","insp_carrier_street":"1810 NORTH 44TH STREET","insp_carrier_city":"SHEBOYGAN","insp_carrier_state":"WI","insp_carrier_zip_code":"53083","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:06:38.000000Z","updated_at":"2025-03-17T20:06:38.000000Z","inspection_violations":[{"id":8080198,"change_date":"2024-03-08 21:39:00","inspection_id":"81055975","insp_violation_id":"258274883","seq_no":"1","part_no":"392","part_no_section":"2-SLLED","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:05.000000Z","updated_at":"2025-03-17T21:45:05.000000Z","normalized_code":"3922SLLED"},{"id":8080199,"change_date":"2024-03-08 21:39:00","inspection_id":"81055975","insp_violation_id":"258274884","seq_no":"2","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"199816886","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:05.000000Z","updated_at":"2025-03-17T21:45:05.000000Z","normalized_code":"3939ALIL"},{"id":8080200,"change_date":"2024-03-08 21:39:00","inspection_id":"81055975","insp_violation_id":"258274885","seq_no":"3","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"199816885","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:05.000000Z","updated_at":"2025-03-17T21:45:05.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":8438867,"change_date":"2024-03-08 21:39:00","inspection_id":"81055975","insp_unit_id":"199816885","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"339","insp_unit_license":"TS40469","insp_unit_license_state":"WI","insp_unit_vehicle_id_number":"1M1AK06Y47N017408","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:27.000000Z","updated_at":"2025-03-17T23:11:27.000000Z"},{"id":8438868,"change_date":"2024-03-08 21:39:00","inspection_id":"81055975","insp_unit_id":"199816886","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAGER BEAV","insp_unit_company":null,"insp_unit_license":"798638","insp_unit_license_state":"WI","insp_unit_vehicle_id_number":"112HGB335HS500092","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:27.000000Z","updated_at":"2025-03-17T23:11:27.000000Z"}]},{"id":4863247,"change_date":"2024-01-19 21:43:00","inspection_id":"80643657","dot_number":"1362229","report_state":"WI","report_number":"2556001421","insp_date":"2024-01-18 00:00:00","insp_start_time":"1105","insp_end_time":"1119","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"TOWN OF GREENBUSH WI","county_code_state":"WI","county_code":"117","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":"2024-01-19 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"32000","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":"184943","transaction_code":"A","transaction_date":"2024-01-19 00:00:00","upload_date":"2024-01-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01362229","upload_search_indicator":null,"census_search_date":"2024-01-19 21:43:00","snet_input_date":"2024-01-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-01-19 21:43:00","insp_carrier_name":"C SPIELVOGEL & SONS EXCAVATING INC","insp_carrier_street":"1810 NORTH 44TH STREET","insp_carrier_city":"SHEBOYGAN","insp_carrier_state":"WI","insp_carrier_zip_code":"53083","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:59:12.000000Z","updated_at":"2025-03-17T19:59:12.000000Z","inspection_violations":[{"id":7496620,"change_date":"2024-01-19 21:43:00","inspection_id":"80643657","insp_violation_id":"257408502","seq_no":"1","part_no":"393","part_no_section":"100C-C","insp_viol_unit":"2","insp_unit_id":"199024847","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:09.000000Z","updated_at":"2025-03-17T21:42:09.000000Z","normalized_code":"393100CC"},{"id":7496621,"change_date":"2024-01-19 21:43:00","inspection_id":"80643657","insp_violation_id":"257408503","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"199024846","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:09.000000Z","updated_at":"2025-03-17T21:42:09.000000Z","normalized_code":"3922SLLSR"},{"id":7496622,"change_date":"2024-01-19 21:43:00","inspection_id":"80643657","insp_violation_id":"257408504","seq_no":"3","part_no":"392","part_no_section":"71A-D","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:09.000000Z","updated_at":"2025-03-17T21:42:09.000000Z","normalized_code":"39271AD"}],"inspection_per_units":[{"id":7824609,"change_date":"2024-01-19 21:43:00","inspection_id":"80643657","insp_unit_id":"199024846","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"DH10782","insp_unit_license_state":"WI","insp_unit_vehicle_id_number":"1FT7W2B68HEE69104","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:54.000000Z","updated_at":"2025-03-17T23:05:54.000000Z"},{"id":7824610,"change_date":"2024-01-19 21:43:00","inspection_id":"80643657","insp_unit_id":"199024847","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"UNKNOWN","insp_unit_company":null,"insp_unit_license":"FR21668","insp_unit_license_state":"WI","insp_unit_vehicle_id_number":"5JWBT2525PA111681","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:54.000000Z","updated_at":"2025-03-17T23:05:54.000000Z"}]},{"id":4626677,"change_date":"2023-12-14 21:42:00","inspection_id":"80385142","dot_number":"1362229","report_state":"WI","report_number":"2280014794","insp_date":"2023-12-14 00:00:00","insp_start_time":"0842","insp_end_time":"0857","registration_date":null,"region":"CS","ci_status_code":"C","location":"S35","location_desc":"NEWTON WI","county_code_state":"WI","county_code":"071","insp_level_id":"3","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":"2023-12-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"173680","viol_total":"2","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":"131507","transaction_code":"A","transaction_date":"2023-12-14 00:00:00","upload_date":"2023-12-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01362229","upload_search_indicator":null,"census_search_date":"2023-12-14 21:42:00","snet_input_date":"2023-12-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-12-14 21:42:00","insp_carrier_name":"C SPIELVOGEL & SONS EXCAVATING INC","insp_carrier_street":"1810 NORTH 44TH STREET","insp_carrier_city":"SHEBOYGAN","insp_carrier_state":"WI","insp_carrier_zip_code":"53083","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:54:32.000000Z","updated_at":"2025-03-17T19:54:32.000000Z","inspection_violations":[{"id":7151901,"change_date":"2023-12-14 21:42:00","inspection_id":"80385142","insp_violation_id":"256875269","seq_no":"1","part_no":"392","part_no_section":"2-SLLED","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:32.000000Z","updated_at":"2025-03-17T21:40:32.000000Z","normalized_code":"3922SLLED"},{"id":7151902,"change_date":"2023-12-14 21:42:00","inspection_id":"80385142","insp_violation_id":"256875270","seq_no":"2","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:32.000000Z","updated_at":"2025-03-17T21:40:32.000000Z","normalized_code":"3922SLLEQP"}],"inspection_per_units":[{"id":7441553,"change_date":"2023-12-14 21:42:00","inspection_id":"80385142","insp_unit_id":"198498447","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"339","insp_unit_license":"TS40469","insp_unit_license_state":"WI","insp_unit_vehicle_id_number":"1M1AK06Y47N017408","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:34.000000Z","updated_at":"2025-03-17T23:02:34.000000Z"},{"id":7441554,"change_date":"2023-12-14 21:42:00","inspection_id":"80385142","insp_unit_id":"198498448","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAGER BEAV","insp_unit_company":null,"insp_unit_license":"798638","insp_unit_license_state":"WI","insp_unit_vehicle_id_number":"112HGB335HS500092","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:34.000000Z","updated_at":"2025-03-17T23:02:34.000000Z"}]},{"id":4103492,"change_date":"2023-10-02 21:41:00","inspection_id":"79808017","dot_number":"1362229","report_state":"WI","report_number":"2228000793","insp_date":"2023-09-29 00:00:00","insp_start_time":"1050","insp_end_time":"1101","registration_date":null,"region":"CT","ci_status_code":"C","location":"58(44)","location_desc":"APPLETON (CITY)","county_code_state":"WI","county_code":"087","insp_level_id":"3","service_center":"MW","census_source_id":"4","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":"I","final_status_date":"2023-10-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"73000","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":"908333","transaction_code":"A","transaction_date":"2023-10-02 00:00:00","upload_date":"2023-10-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01362229","upload_search_indicator":"M","census_search_date":"2023-10-02 21:41:00","snet_input_date":"2023-10-02 00:00:00","source_office":"3WIS001","mcmis_add_date":"2023-10-02 21:41:00","insp_carrier_name":"C SPIELVOGEL & SONS EXCAVATING INC","insp_carrier_street":"1810 NORTH 44TH STREET","insp_carrier_city":"SHEBOYGAN","insp_carrier_state":"WI","insp_carrier_zip_code":"53083","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:44:01.000000Z","updated_at":"2025-03-17T19:44:01.000000Z","inspection_violations":[{"id":6348289,"change_date":"2023-10-02 21:41:00","inspection_id":"79808017","insp_violation_id":"255598136","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:37.000000Z","updated_at":"2025-03-17T21:36:37.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6597574,"change_date":"2023-10-02 21:41:00","inspection_id":"79808017","insp_unit_id":"197347098","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"207","insp_unit_license":"RB34946","insp_unit_license_state":"WI","insp_unit_vehicle_id_number":"1M2AD62C5XW009136","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:21.000000Z","updated_at":"2025-03-17T22:55:21.000000Z"}]},{"id":3435154,"change_date":"2023-07-05 21:42:00","inspection_id":"79061095","dot_number":"1362229","report_state":"WI","report_number":"2556000828","insp_date":"2023-06-30 00:00:00","insp_start_time":"0627","insp_end_time":"0633","registration_date":null,"region":"CT","ci_status_code":"C","location":"01(59)","location_desc":"GREEN BUSH (TOWN)","county_code_state":"WI","county_code":"117","insp_level_id":"2","service_center":"MW","census_source_id":"4","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":"I","final_status_date":"2023-07-05 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"32000","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":"898970","transaction_code":"A","transaction_date":"2023-07-05 00:00:00","upload_date":"2023-07-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01362229","upload_search_indicator":"M","census_search_date":"2023-07-05 21:42:00","snet_input_date":"2023-07-05 00:00:00","source_office":"3WIS001","mcmis_add_date":"2023-07-05 21:42:00","insp_carrier_name":"C SPIELVOGEL & SONS EXCAVATING INC","insp_carrier_street":"1810 NORTH 44TH STREET","insp_carrier_city":"SHEBOYGAN","insp_carrier_state":"WI","insp_carrier_zip_code":"53083","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:30:58.000000Z","updated_at":"2025-03-17T19:30:58.000000Z","inspection_violations":[{"id":5294696,"change_date":"2023-07-05 21:42:00","inspection_id":"79061095","insp_violation_id":"253870980","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"195831546","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:34.000000Z","updated_at":"2025-03-17T21:31:34.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":5523408,"change_date":"2023-07-05 21:42:00","inspection_id":"79061095","insp_unit_id":"195831546","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"DG84188","insp_unit_license_state":"WI","insp_unit_vehicle_id_number":"1FT7X2BT2BEC16242","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:35.000000Z","updated_at":"2025-03-17T22:46:35.000000Z"},{"id":5523409,"change_date":"2023-07-05 21:42:00","inspection_id":"79061095","insp_unit_id":"195831547","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"FR21668","insp_unit_license_state":"WI","insp_unit_vehicle_id_number":"5JWBT2525PA111681","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:35.000000Z","updated_at":"2025-03-17T22:46:35.000000Z"}]},{"id":3296093,"change_date":"2023-06-15 21:42:00","inspection_id":"78904983","dot_number":"1362229","report_state":"WI","report_number":"2556000769","insp_date":"2023-06-12 00:00:00","insp_start_time":"1419","insp_end_time":"1429","registration_date":null,"region":"CT","ci_status_code":"C","location":"05(59)","location_desc":"LYNDON (TOWN)","county_code_state":"WI","county_code":"117","insp_level_id":"2","service_center":"MW","census_source_id":"4","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":"I","final_status_date":"2023-06-15 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"19200","viol_total":"5","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"897273","transaction_code":"A","transaction_date":"2023-06-14 00:00:00","upload_date":"2023-06-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01362229","upload_search_indicator":"M","census_search_date":"2023-06-15 21:42:00","snet_input_date":"2023-06-14 00:00:00","source_office":"3WIS001","mcmis_add_date":"2023-06-15 21:42:00","insp_carrier_name":"C SPIELVOGEL & SONS EXCAVATING INC","insp_carrier_street":"1810 NORTH 44TH STREET","insp_carrier_city":"SHEBOYGAN","insp_carrier_state":"WI","insp_carrier_zip_code":"53083","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:28:11.000000Z","updated_at":"2025-03-17T19:28:11.000000Z","inspection_violations":[{"id":5083059,"change_date":"2023-06-15 21:42:00","inspection_id":"78904983","insp_violation_id":"253533612","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"195523474","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:39.000000Z","updated_at":"2025-03-17T21:30:39.000000Z","normalized_code":"39395A"},{"id":5083060,"change_date":"2023-06-15 21:42:00","inspection_id":"78904983","insp_violation_id":"253533613","seq_no":"2","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"195523474","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:39.000000Z","updated_at":"2025-03-17T21:30:39.000000Z","normalized_code":"39395F"},{"id":5083061,"change_date":"2023-06-15 21:42:00","inspection_id":"78904983","insp_violation_id":"253533614","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"195523474","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:39.000000Z","updated_at":"2025-03-17T21:30:39.000000Z","normalized_code":"39617C"},{"id":5083062,"change_date":"2023-06-15 21:42:00","inspection_id":"78904983","insp_violation_id":"253533615","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195523474","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:39.000000Z","updated_at":"2025-03-17T21:30:39.000000Z","normalized_code":"3922"},{"id":5083063,"change_date":"2023-06-15 21:42:00","inspection_id":"78904983","insp_violation_id":"253533616","seq_no":"5","part_no":"393","part_no_section":"43","insp_viol_unit":"2","insp_unit_id":"195523475","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:30:39.000000Z","updated_at":"2025-03-17T21:30:39.000000Z","normalized_code":"39343"}],"inspection_per_units":[{"id":5299316,"change_date":"2023-06-15 21:42:00","inspection_id":"78904983","insp_unit_id":"195523474","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"RY2011","insp_unit_license_state":"WI","insp_unit_vehicle_id_number":"1GCHK29255E220581","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:47.000000Z","updated_at":"2025-03-17T22:44:47.000000Z"},{"id":5299317,"change_date":"2023-06-15 21:42:00","inspection_id":"78904983","insp_unit_id":"195523475","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"XR50799","insp_unit_license_state":"WI","insp_unit_vehicle_id_number":"5L8TD202841001502","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:47.000000Z","updated_at":"2025-03-17T22:44:47.000000Z"}]},{"id":3119116,"change_date":"2023-05-23 21:42:00","inspection_id":"78705168","dot_number":"1362229","report_state":"WI","report_number":"L017000107","insp_date":"2023-05-22 00:00:00","insp_start_time":"1308","insp_end_time":"1400","registration_date":null,"region":"CT","ci_status_code":"C","location":"54(05)","location_desc":"DE PERE (CITY)","county_code_state":"WI","county_code":"009","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"SELF","shipping_paper_number":"NO BOL","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":"I","final_status_date":"2023-05-23 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"177000","viol_total":"5","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"895215","transaction_code":"A","transaction_date":"2023-05-23 00:00:00","upload_date":"2023-05-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01362229","upload_search_indicator":"M","census_search_date":"2023-05-23 21:42:00","snet_input_date":"2023-05-23 00:00:00","source_office":"3WIS001","mcmis_add_date":"2023-05-23 21:42:00","insp_carrier_name":"C SPIELVOGEL & SONS EXCAVATING INC","insp_carrier_street":"1810 NORTH 44TH STREET","insp_carrier_city":"SHEBOYGAN","insp_carrier_state":"WI","insp_carrier_zip_code":"53083","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:24:38.000000Z","updated_at":"2025-03-17T19:24:38.000000Z","inspection_violations":[{"id":4801499,"change_date":"2023-05-23 21:42:00","inspection_id":"78705168","insp_violation_id":"253023999","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195094277","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"BD993659","created_at":"2025-03-17T21:29:22.000000Z","updated_at":"2025-03-17T21:29:22.000000Z","normalized_code":"3922"},{"id":4801500,"change_date":"2023-05-23 21:42:00","inspection_id":"78705168","insp_violation_id":"253024000","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"195094277","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:22.000000Z","updated_at":"2025-03-17T21:29:22.000000Z","normalized_code":"39617C"},{"id":4801501,"change_date":"2023-05-23 21:42:00","inspection_id":"78705168","insp_violation_id":"253024001","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"195094278","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:22.000000Z","updated_at":"2025-03-17T21:29:22.000000Z","normalized_code":"39617C"},{"id":4801502,"change_date":"2023-05-23 21:42:00","inspection_id":"78705168","insp_violation_id":"253024002","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"195094278","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:22.000000Z","updated_at":"2025-03-17T21:29:22.000000Z","normalized_code":"3939A"},{"id":4801503,"change_date":"2023-05-23 21:42:00","inspection_id":"78705168","insp_violation_id":"253024003","seq_no":"5","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"195094277","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:22.000000Z","updated_at":"2025-03-17T21:29:22.000000Z","normalized_code":"39360C"}],"inspection_per_units":[{"id":5017036,"change_date":"2023-05-23 21:42:00","inspection_id":"78705168","insp_unit_id":"195094277","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"339","insp_unit_license":"TS40469","insp_unit_license_state":"WI","insp_unit_vehicle_id_number":"1M1AK06Y47N017408","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:33.000000Z","updated_at":"2025-03-17T22:42:33.000000Z"},{"id":5017037,"change_date":"2023-05-23 21:42:00","inspection_id":"78705168","insp_unit_id":"195094278","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAGB","insp_unit_company":null,"insp_unit_license":"798638","insp_unit_license_state":"WI","insp_unit_vehicle_id_number":"112HGB335HS500092","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:33.000000Z","updated_at":"2025-03-17T22:42:33.000000Z"}]},{"id":2389561,"change_date":"2023-02-16 21:42:00","inspection_id":"77877179","dot_number":"1362229","report_state":"WI","report_number":"2556000502","insp_date":"2023-02-15 00:00:00","insp_start_time":"1447","insp_end_time":"1456","registration_date":null,"region":"CT","ci_status_code":"C","location":"02(36)","location_desc":"CENTERVILLE (TOWN)","county_code_state":"WI","county_code":"071","insp_level_id":"3","service_center":"MW","census_source_id":"4","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-02-16 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"112400","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":"886056","transaction_code":"A","transaction_date":"2023-02-16 00:00:00","upload_date":"2023-02-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01362229","upload_search_indicator":"M","census_search_date":"2023-02-16 21:42:00","snet_input_date":"2023-02-16 00:00:00","source_office":"3WIS001","mcmis_add_date":"2023-02-16 21:42:00","insp_carrier_name":"C SPIELVOGEL & SONS EXCAVATING INC","insp_carrier_street":"1810 NORTH 44TH STREET","insp_carrier_city":"SHEBOYGAN","insp_carrier_state":"WI","insp_carrier_zip_code":"53083","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:10:43.000000Z","updated_at":"2025-03-17T19:10:43.000000Z","inspection_violations":[{"id":3679083,"change_date":"2023-02-16 21:42:00","inspection_id":"77877179","insp_violation_id":"251184534","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:24:19.000000Z","updated_at":"2025-03-17T21:24:19.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3845014,"change_date":"2023-02-16 21:42:00","inspection_id":"77877179","insp_unit_id":"193441623","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"203","insp_unit_license":"RB30436","insp_unit_license_state":"WI","insp_unit_vehicle_id_number":"1XPALB0X9TN415215","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:33.000000Z","updated_at":"2025-03-17T22:33:33.000000Z"}]},{"id":1197052,"change_date":"2022-09-01 21:41:00","inspection_id":"76507221","dot_number":"1362229","report_state":"WI","report_number":"2280013363","insp_date":"2022-08-31 00:00:00","insp_start_time":"1056","insp_end_time":"1130","registration_date":null,"region":"CT","ci_status_code":"C","location":"12(59)","location_desc":"SHEBOYGAN (TOWN)","county_code_state":"WI","county_code":"117","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-09-01 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"8","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"871023","transaction_code":"A","transaction_date":"2022-09-01 00:00:00","upload_date":"2022-09-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01362229","upload_search_indicator":"M","census_search_date":"2022-09-01 21:41:00","snet_input_date":"2022-09-01 00:00:00","source_office":"3WIS001","mcmis_add_date":"2022-09-01 21:41:00","insp_carrier_name":"C SPIELVOGEL & SONS EXCAVATING INC","insp_carrier_street":"1810 NORTH 44TH STREET","insp_carrier_city":"SHEBOYGAN","insp_carrier_state":"WI","insp_carrier_zip_code":"53083","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:48:40.000000Z","updated_at":"2025-03-17T18:48:40.000000Z","inspection_violations":[{"id":1897323,"change_date":"2022-09-01 21:41:00","inspection_id":"76507221","insp_violation_id":"248172410","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"190688146","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:44.000000Z","updated_at":"2025-03-17T21:15:44.000000Z","normalized_code":"3922"},{"id":1897324,"change_date":"2022-09-01 21:41:00","inspection_id":"76507221","insp_violation_id":"248172411","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"190688146","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:44.000000Z","updated_at":"2025-03-17T21:15:44.000000Z","normalized_code":"39617C"},{"id":1897325,"change_date":"2022-09-01 21:41:00","inspection_id":"76507221","insp_violation_id":"248172412","seq_no":"3","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"190688146","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:44.000000Z","updated_at":"2025-03-17T21:15:44.000000Z","normalized_code":"39021TB"},{"id":1897326,"change_date":"2022-09-01 21:41:00","inspection_id":"76507221","insp_violation_id":"248172413","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190688146","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:44.000000Z","updated_at":"2025-03-17T21:15:44.000000Z","normalized_code":"3939A"},{"id":1897327,"change_date":"2022-09-01 21:41:00","inspection_id":"76507221","insp_violation_id":"248172414","seq_no":"5","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"190688146","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:44.000000Z","updated_at":"2025-03-17T21:15:44.000000Z","normalized_code":"39311"},{"id":1897328,"change_date":"2022-09-01 21:41:00","inspection_id":"76507221","insp_violation_id":"248172415","seq_no":"6","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"190688147","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:44.000000Z","updated_at":"2025-03-17T21:15:44.000000Z","normalized_code":"39617C"},{"id":1897329,"change_date":"2022-09-01 21:41:00","inspection_id":"76507221","insp_violation_id":"248172416","seq_no":"7","part_no":"396","part_no_section":"9(d)(2)","insp_viol_unit":"1","insp_unit_id":"190688146","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:44.000000Z","updated_at":"2025-03-17T21:15:44.000000Z","normalized_code":"3969D2"},{"id":1897330,"change_date":"2022-09-01 21:41:00","inspection_id":"76507221","insp_violation_id":"248172417","seq_no":"8","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"190688147","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:44.000000Z","updated_at":"2025-03-17T21:15:44.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1924835,"change_date":"2022-09-01 21:41:00","inspection_id":"76507221","insp_unit_id":"190688146","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"339","insp_unit_license":"TS40469","insp_unit_license_state":"WI","insp_unit_vehicle_id_number":"1M1AK06Y47N017408","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:13.000000Z","updated_at":"2025-03-17T22:20:13.000000Z"},{"id":1924836,"change_date":"2022-09-01 21:41:00","inspection_id":"76507221","insp_unit_id":"190688147","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"552873","insp_unit_license_state":"WI","insp_unit_vehicle_id_number":"1BCA028263D2X1021","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:13.000000Z","updated_at":"2025-03-17T22:20:13.000000Z"}]},{"id":884365,"change_date":"2022-07-25 21:39:00","inspection_id":"76142089","dot_number":"1362229","report_state":"WI","report_number":"2280013242","insp_date":"2022-07-22 00:00:00","insp_start_time":"0743","insp_end_time":"0813","registration_date":null,"region":"CT","ci_status_code":"C","location":"S35","location_desc":"NEWTON SWEF","county_code_state":"WI","county_code":"071","insp_level_id":"2","service_center":"MW","census_source_id":"4","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":"N","pen_cen_match":"I","final_status_date":"2022-07-25 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"125000","viol_total":"9","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"866760","transaction_code":"A","transaction_date":"2022-07-25 00:00:00","upload_date":"2022-07-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01362229","upload_search_indicator":"M","census_search_date":"2022-07-25 21:39:00","snet_input_date":"2022-07-25 00:00:00","source_office":"3WIS001","mcmis_add_date":"2022-07-25 21:39:00","insp_carrier_name":"C SPIELVOGEL & SONS EXCAVATING INC","insp_carrier_street":"1810 NORTH 44TH STREET","insp_carrier_city":"SHEBOYGAN","insp_carrier_state":"WI","insp_carrier_zip_code":"53083","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:43:21.000000Z","updated_at":"2025-03-17T18:43:21.000000Z","inspection_violations":[{"id":1391169,"change_date":"2022-07-25 21:39:00","inspection_id":"76142089","insp_violation_id":"247282405","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"189942676","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:33.000000Z","updated_at":"2025-03-17T21:13:33.000000Z","normalized_code":"3922"},{"id":1391170,"change_date":"2022-07-25 21:39:00","inspection_id":"76142089","insp_violation_id":"247282406","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"189942676","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:33.000000Z","updated_at":"2025-03-17T21:13:33.000000Z","normalized_code":"39617C"},{"id":1391171,"change_date":"2022-07-25 21:39:00","inspection_id":"76142089","insp_violation_id":"247282407","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189942676","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:33.000000Z","updated_at":"2025-03-17T21:13:33.000000Z","normalized_code":"3939A"},{"id":1391172,"change_date":"2022-07-25 21:39:00","inspection_id":"76142089","insp_violation_id":"247282408","seq_no":"4","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"189942677","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:33.000000Z","updated_at":"2025-03-17T21:13:33.000000Z","normalized_code":"39617C"},{"id":1391173,"change_date":"2022-07-25 21:39:00","inspection_id":"76142089","insp_violation_id":"247282409","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"189942677","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:33.000000Z","updated_at":"2025-03-17T21:13:33.000000Z","normalized_code":"3939A"},{"id":1391174,"change_date":"2022-07-25 21:39:00","inspection_id":"76142089","insp_violation_id":"247282410","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"189942677","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:33.000000Z","updated_at":"2025-03-17T21:13:33.000000Z","normalized_code":"3939A"},{"id":1391175,"change_date":"2022-07-25 21:39:00","inspection_id":"76142089","insp_violation_id":"247282411","seq_no":"7","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"189942676","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:33.000000Z","updated_at":"2025-03-17T21:13:33.000000Z","normalized_code":"39021TB"},{"id":1391176,"change_date":"2022-07-25 21:39:00","inspection_id":"76142089","insp_violation_id":"247282412","seq_no":"8","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:33.000000Z","updated_at":"2025-03-17T21:13:33.000000Z","normalized_code":"3922"},{"id":1391177,"change_date":"2022-07-25 21:39:00","inspection_id":"76142089","insp_violation_id":"247282413","seq_no":"9","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"189942676","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:33.000000Z","updated_at":"2025-03-17T21:13:33.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1423681,"change_date":"2022-07-25 21:39:00","inspection_id":"76142089","insp_unit_id":"189942676","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"339","insp_unit_license":"TS40469","insp_unit_license_state":"WI","insp_unit_vehicle_id_number":"1M1AK06Y47N017408","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:56.000000Z","updated_at":"2025-03-17T22:16:56.000000Z"},{"id":1423682,"change_date":"2022-07-25 21:39:00","inspection_id":"76142089","insp_unit_id":"189942677","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAGB","insp_unit_company":null,"insp_unit_license":"798638","insp_unit_license_state":"WI","insp_unit_vehicle_id_number":"112HGB335HS500092","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:56.000000Z","updated_at":"2025-03-17T22:16:56.000000Z"}]},{"id":359206,"change_date":"2022-05-10 21:40:00","inspection_id":"75521353","dot_number":"1362229","report_state":"WI","report_number":"2280013045","insp_date":"2022-05-09 00:00:00","insp_start_time":"0711","insp_end_time":"0800","registration_date":null,"region":"CT","ci_status_code":"C","location":"02(36)","location_desc":"CENTERVILLE (TOWN)","county_code_state":"WI","county_code":"071","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"SELF","shipping_paper_number":"NO BOL","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-05-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"5","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"859906","transaction_code":"A","transaction_date":"2022-05-09 00:00:00","upload_date":"2022-05-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01362229","upload_search_indicator":null,"census_search_date":"2022-05-10 21:40:00","snet_input_date":"2022-05-10 00:00:00","source_office":"3WIS001","mcmis_add_date":"2022-05-10 21:40:00","insp_carrier_name":"C SPIELVOGEL & SONS EXCAVATING INC","insp_carrier_street":"1810 NORTH 44TH STREET","insp_carrier_city":"SHEBOYGAN","insp_carrier_state":"WI","insp_carrier_zip_code":"53083","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:33:42.000000Z","updated_at":"2025-03-17T18:33:42.000000Z","inspection_violations":[{"id":562511,"change_date":"2022-05-10 21:40:00","inspection_id":"75521353","insp_violation_id":"245698303","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"188606624","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"BG620945-3","created_at":"2025-03-17T21:09:42.000000Z","updated_at":"2025-03-17T21:09:42.000000Z","normalized_code":"3922"},{"id":562512,"change_date":"2022-05-10 21:40:00","inspection_id":"75521353","insp_violation_id":"245698304","seq_no":"2","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"188606624","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:09:42.000000Z","updated_at":"2025-03-17T21:09:42.000000Z","normalized_code":"39375A3"},{"id":562513,"change_date":"2022-05-10 21:40:00","inspection_id":"75521353","insp_violation_id":"245698305","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"188606624","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:42.000000Z","updated_at":"2025-03-17T21:09:42.000000Z","normalized_code":"3922"},{"id":562514,"change_date":"2022-05-10 21:40:00","inspection_id":"75521353","insp_violation_id":"245698306","seq_no":"4","part_no":"393","part_no_section":"75(g)","insp_viol_unit":"1","insp_unit_id":"188606624","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:09:42.000000Z","updated_at":"2025-03-17T21:09:42.000000Z","normalized_code":"39375G"},{"id":562515,"change_date":"2022-05-10 21:40:00","inspection_id":"75521353","insp_violation_id":"245698307","seq_no":"5","part_no":"393","part_no_section":"75(g)","insp_viol_unit":"1","insp_unit_id":"188606624","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:09:42.000000Z","updated_at":"2025-03-17T21:09:42.000000Z","normalized_code":"39375G"}],"inspection_per_units":[{"id":580924,"change_date":"2022-05-10 21:40:00","inspection_id":"75521353","insp_unit_id":"188606624","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"203","insp_unit_license":"KB5075","insp_unit_license_state":"WI","insp_unit_vehicle_id_number":"1HTWDAAR03J070536","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:46.000000Z","updated_at":"2025-03-17T22:11:46.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1362229\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1362229\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1362229\/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\/1362229\/inspections","per_page":100,"prev_page_url":null,"to":19,"total":19}