{"current_page":1,"data":[{"id":12025832,"change_date":"2026-05-27 21:40:00","inspection_id":"87965673","dot_number":"807537","report_state":"NE","report_number":"T557002298","insp_date":"2026-05-27 00:00:00","insp_start_time":"0704","insp_end_time":"0712","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"FREMONT NE","county_code_state":"NE","county_code":"053","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"NONE","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"86780","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":"3408758","transaction_code":"A","transaction_date":"2026-05-27 00:00:00","upload_date":"2026-05-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00807537","upload_search_indicator":null,"census_search_date":"2026-05-27 21:40:00","snet_input_date":"2026-05-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-27 21:40:00","insp_carrier_name":"MIDWEST COATINGS COMPANY INC","insp_carrier_street":"1425 280TH STREET","insp_carrier_city":"MODALE","insp_carrier_state":"IA","insp_carrier_zip_code":"51556","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-30T09:39:28.000000Z","updated_at":"2026-06-07T09:30:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20903465,"change_date":"2026-05-27 21:40:00","inspection_id":"87965673","insp_unit_id":"213768726","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH M","insp_unit_company":"T11","insp_unit_license":"FA2787","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1NKZX4TX6KJ257971","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-30T09:17:31.000000Z","updated_at":"2026-06-07T09:01:59.000000Z"}]},{"id":11961129,"change_date":"2026-05-19 21:40:00","inspection_id":"87897283","dot_number":"807537","report_state":"NE","report_number":"T143000849","insp_date":"2026-05-19 00:00:00","insp_start_time":"0815","insp_end_time":"0843","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"ROSALIE NE","county_code_state":"NE","county_code":"021","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":"U","pen_cen_match":"I","final_status_date":"2026-05-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"77020","viol_total":"6","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3360708","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":"00807537","upload_search_indicator":null,"census_search_date":"2026-05-19 21:40:00","snet_input_date":"2026-05-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-19 21:40:00","insp_carrier_name":"MIDWEST COATINGS COMPANY INC","insp_carrier_street":"1425 280TH STREET","insp_carrier_city":"MODALE","insp_carrier_state":"IA","insp_carrier_zip_code":"51556","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-22T09:41:10.000000Z","updated_at":"2026-05-30T09:30:38.000000Z","inspection_violations":[{"id":20805168,"change_date":"2026-05-19 21:40:00","inspection_id":"87897283","insp_violation_id":"274363041","seq_no":"3","part_no":"393","part_no_section":"9A-LFTSI","insp_viol_unit":"1","insp_unit_id":"213641781","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-22T10:01:25.000000Z","updated_at":"2026-05-30T09:40:49.000000Z","normalized_code":"3939ALFTSI"},{"id":20805169,"change_date":"2026-05-19 21:40:00","inspection_id":"87897283","insp_violation_id":"274363042","seq_no":"4","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"213641781","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-22T10:01:25.000000Z","updated_at":"2026-05-30T09:40:49.000000Z","normalized_code":"3939ALHLI"},{"id":20805170,"change_date":"2026-05-19 21:40:00","inspection_id":"87897283","insp_violation_id":"274363043","seq_no":"5","part_no":"393","part_no_section":"9A-HLLH","insp_viol_unit":"1","insp_unit_id":"213641781","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-22T10:01:25.000000Z","updated_at":"2026-05-30T09:40:49.000000Z","normalized_code":"3939AHLLH"},{"id":20805171,"change_date":"2026-05-19 21:40:00","inspection_id":"87897283","insp_violation_id":"274363044","seq_no":"6","part_no":"393","part_no_section":"19","insp_viol_unit":"1","insp_unit_id":"213641781","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-22T10:01:25.000000Z","updated_at":"2026-05-30T09:40:49.000000Z","normalized_code":"39319"},{"id":20805166,"change_date":"2026-05-19 21:40:00","inspection_id":"87897283","insp_violation_id":"274363039","seq_no":"1","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"213641781","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"EA5501648","created_at":"2026-05-22T10:01:25.000000Z","updated_at":"2026-05-30T09:40:49.000000Z","normalized_code":"39375A3TAOL"},{"id":20805167,"change_date":"2026-05-19 21:40:00","inspection_id":"87897283","insp_violation_id":"274363040","seq_no":"2","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"213641781","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"EA5501648","created_at":"2026-05-22T10:01:25.000000Z","updated_at":"2026-05-30T09:40:49.000000Z","normalized_code":"39375A3TAOL"}],"inspection_per_units":[{"id":20797358,"change_date":"2026-05-19 21:40:00","inspection_id":"87897283","insp_unit_id":"213641781","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WESTERN ST","insp_unit_company":"T4","insp_unit_license":"DH1599","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5KKMAVDV1GPHJ2635","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-22T09:21:39.000000Z","updated_at":"2026-05-30T09:02:41.000000Z"}]},{"id":11907635,"change_date":"2026-05-14 21:42:00","inspection_id":"87846751","dot_number":"807537","report_state":"NE","report_number":"T498000755","insp_date":"2026-05-14 00:00:00","insp_start_time":"0728","insp_end_time":"0750","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"BLAIR NE","county_code_state":"NE","county_code":"177","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAME AS CARRIER","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"3322493","transaction_code":"A","transaction_date":"2026-05-14 00:00:00","upload_date":"2026-05-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00807537","upload_search_indicator":null,"census_search_date":"2026-05-14 21:42:00","snet_input_date":"2026-05-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-14 21:42:00","insp_carrier_name":"MIDWEST COATINGS COMPANY INC","insp_carrier_street":"1425 280TH STREET","insp_carrier_city":"MODALE","insp_carrier_state":"IA","insp_carrier_zip_code":"51556","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-16T13:32:52.000000Z","updated_at":"2026-05-25T09:31:14.000000Z","inspection_violations":[{"id":20713814,"change_date":"2026-05-14 21:42:00","inspection_id":"87846751","insp_violation_id":"274255486","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":"ET4402029","created_at":"2026-05-16T13:13:03.000000Z","updated_at":"2026-05-25T09:43:18.000000Z","normalized_code":"3922SLLEWG3"}],"inspection_per_units":[{"id":20701213,"change_date":"2026-05-14 21:42:00","inspection_id":"87846751","insp_unit_id":"213549962","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"6","insp_unit_license":"VA3464","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"2NP3LJ0XXEM227156","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-16T12:44:47.000000Z","updated_at":"2026-05-25T09:03:38.000000Z"}]},{"id":11897145,"change_date":"2026-05-13 21:42:00","inspection_id":"87835682","dot_number":"807537","report_state":"SD","report_number":"0470000520","insp_date":"2026-05-13 00:00:00","insp_start_time":"1255","insp_end_time":"1430","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"JEFFERSON SD","county_code_state":"SD","county_code":"127","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SPENCER QUARRIES, INC","shipping_paper_number":"811765","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":"U","pen_cen_match":"I","final_status_date":"2026-05-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"75200","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":"3315049","transaction_code":"A","transaction_date":"2026-05-13 00:00:00","upload_date":"2026-05-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00807537","upload_search_indicator":null,"census_search_date":"2026-05-13 21:42:00","snet_input_date":"2026-05-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-13 21:42:00","insp_carrier_name":"MIDWEST COATINGS COMPANY INC","insp_carrier_street":"1425 280TH STREET","insp_carrier_city":"MODALE","insp_carrier_state":"IA","insp_carrier_zip_code":"51556","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-15T12:26:55.000000Z","updated_at":"2026-05-24T09:31:22.000000Z","inspection_violations":[{"id":20693768,"change_date":"2026-05-13 21:42:00","inspection_id":"87835682","insp_violation_id":"274227581","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"B1271045","created_at":"2026-05-15T12:59:16.000000Z","updated_at":"2026-05-24T09:45:02.000000Z","normalized_code":"3922SLLEWA2"}],"inspection_per_units":[{"id":20684207,"change_date":"2026-05-13 21:42:00","inspection_id":"87835682","insp_unit_id":"213527879","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"T10","insp_unit_license":"FY1157","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1M1PN4GY9LM006153","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-15T12:14:34.000000Z","updated_at":"2026-05-24T09:04:31.000000Z"},{"id":20684208,"change_date":"2026-05-13 21:42:00","inspection_id":"87835682","insp_unit_id":"213527880","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ETNYRE & C","insp_unit_company":"T2","insp_unit_license":"DH1600","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1E9V19029FE111232","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-15T12:14:34.000000Z","updated_at":"2026-05-24T09:04:31.000000Z"}]},{"id":11776661,"change_date":"2026-04-29 21:39:00","inspection_id":"87707707","dot_number":"807537","report_state":"SD","report_number":"5430002540","insp_date":"2026-04-28 00:00:00","insp_start_time":"1247","insp_end_time":"1340","registration_date":null,"region":"CD","ci_status_code":"C","location":"MIDWAY","location_desc":"MIDWAY SD","county_code_state":"SD","county_code":"135","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SPENCER QUARRIES","shipping_paper_number":"809850","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":"U","pen_cen_match":"I","final_status_date":"2026-04-29 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"126000","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":"3229668","transaction_code":"A","transaction_date":"2026-04-29 00:00:00","upload_date":"2026-04-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00807537","upload_search_indicator":null,"census_search_date":"2026-04-29 21:39:00","snet_input_date":"2026-04-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-29 21:39:00","insp_carrier_name":"MIDWEST COATINGS COMPANY INC","insp_carrier_street":"1425 280TH STREET","insp_carrier_city":"MODALE","insp_carrier_state":"IA","insp_carrier_zip_code":"51556","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-02T09:40:56.000000Z","updated_at":"2026-05-10T09:30:26.000000Z","inspection_violations":[{"id":20478817,"change_date":"2026-04-29 21:39:00","inspection_id":"87707707","insp_violation_id":"273923301","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"B1381618","created_at":"2026-05-02T10:02:12.000000Z","updated_at":"2026-05-10T09:40:16.000000Z","normalized_code":"3922SLLEWA1"}],"inspection_per_units":[{"id":20487602,"change_date":"2026-04-29 21:39:00","inspection_id":"87707707","insp_unit_id":"213281328","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"T-10","insp_unit_license":"FY1157","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1M1PN4GY9LM006153","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-02T09:19:06.000000Z","updated_at":"2026-05-10T09:02:37.000000Z"},{"id":20487603,"change_date":"2026-04-29 21:39:00","inspection_id":"87707707","insp_unit_id":"213281329","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":"TR-04","insp_unit_license":"FY9797","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1E9V29120SE111089","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-02T09:19:06.000000Z","updated_at":"2026-05-10T09:02:37.000000Z"}]},{"id":11710480,"change_date":"2026-04-21 21:39:00","inspection_id":"87637410","dot_number":"807537","report_state":"IA","report_number":"000P12JPCX","insp_date":"2026-04-13 00:00:00","insp_start_time":"0725","insp_end_time":"0750","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"I29SB","county_code_state":"IA","county_code":"129","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"OWN","shipping_paper_number":"368664","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":"Y","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":"33000","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1397082","transaction_code":"A","transaction_date":"2026-04-13 00:00:00","upload_date":"2026-04-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00807537","upload_search_indicator":null,"census_search_date":"2026-04-21 21:39:00","snet_input_date":"2026-04-13 00:00:00","source_office":"3IAS001","mcmis_add_date":"2026-04-21 21:39:00","insp_carrier_name":"MIDWEST COATINGS COMPANY INC","insp_carrier_street":"1425 280TH STREET","insp_carrier_city":"MODALE","insp_carrier_state":"IA","insp_carrier_zip_code":"51556","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-27T09:37:58.000000Z","updated_at":"2026-05-02T09:31:02.000000Z","inspection_violations":[{"id":20352173,"change_date":"2026-04-21 21:39:00","inspection_id":"87637410","insp_violation_id":"273751315","seq_no":"1","part_no":"390","part_no_section":"21TB","insp_viol_unit":"1","insp_unit_id":"213139943","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:55:27.000000Z","updated_at":"2026-05-02T09:43:09.000000Z","normalized_code":"39021TB"},{"id":20352174,"change_date":"2026-04-21 21:39:00","inspection_id":"87637410","insp_violation_id":"273751316","seq_no":"2","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"213139943","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:55:27.000000Z","updated_at":"2026-05-02T09:43:09.000000Z","normalized_code":"39395A"},{"id":20352175,"change_date":"2026-04-21 21:39:00","inspection_id":"87637410","insp_violation_id":"273751317","seq_no":"3","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"213139943","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:55:27.000000Z","updated_at":"2026-05-02T09:43:09.000000Z","normalized_code":"3922RG"},{"id":20352176,"change_date":"2026-04-21 21:39:00","inspection_id":"87637410","insp_violation_id":"273751318","seq_no":"4","part_no":"392","part_no_section":"2IN","insp_viol_unit":"1","insp_unit_id":"213139943","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:55:27.000000Z","updated_at":"2026-05-02T09:43:09.000000Z","normalized_code":"3922IN"}],"inspection_per_units":[{"id":20378573,"change_date":"2026-04-21 21:39:00","inspection_id":"87637410","insp_unit_id":"213139943","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"3816","insp_unit_license":"YCJ3329","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1HTEUMMN6TS243816","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:14:24.000000Z","updated_at":"2026-05-02T09:03:29.000000Z"}]},{"id":10399103,"change_date":"2025-12-16 21:38:00","inspection_id":"86529269","dot_number":"807537","report_state":"IA","report_number":"000P12JP4B","insp_date":"2025-12-09 00:00:00","insp_start_time":"1815","insp_end_time":"1855","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"AUSTIN AVE","county_code_state":"IA","county_code":"085","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"OW","shipping_paper_number":"DOZER","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-12-10 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"162000","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":"1383939","transaction_code":"C","transaction_date":"2025-12-10 00:00:00","upload_date":"2025-12-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00807537","upload_search_indicator":"M","census_search_date":"2025-12-10 21:38:00","snet_input_date":"2025-12-09 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-12-10 21:38:00","insp_carrier_name":"MIDWEST COATINGS COMPANY INC","insp_carrier_street":"1425 280TH STREET","insp_carrier_city":"MODALE","insp_carrier_state":"IA","insp_carrier_zip_code":"51556","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-13T10:31:38.000000Z","updated_at":"2025-12-27T10:30:36.000000Z","inspection_violations":[{"id":17522612,"change_date":"2025-12-16 21:38:00","inspection_id":"86529269","insp_violation_id":"270715440","seq_no":"1","part_no":"392","part_no_section":"2DIM","insp_viol_unit":"2","insp_unit_id":"210639413","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"7WEL25120918510","created_at":"2025-12-19T10:32:37.000000Z","updated_at":"2025-12-27T10:30:54.000000Z","normalized_code":"3922DIM"}],"inspection_per_units":[{"id":17480520,"change_date":"2025-12-16 21:38:00","inspection_id":"86529269","insp_unit_id":"210639412","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"T-15","insp_unit_license":"FY4815","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKZP4TX5RJ372707","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-19T10:01:58.000000Z","updated_at":"2025-12-27T10:00:41.000000Z"},{"id":17480521,"change_date":"2025-12-16 21:38:00","inspection_id":"86529269","insp_unit_id":"210639413","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"TR-01","insp_unit_license":"FW2091","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1TKJ05339PM101802","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-19T10:01:58.000000Z","updated_at":"2025-12-27T10:00:41.000000Z"}]},{"id":10178254,"change_date":"2025-11-12 21:41:00","inspection_id":"86297960","dot_number":"807537","report_state":"IA","report_number":"000P14ZMP0","insp_date":"2025-11-11 00:00:00","insp_start_time":"0915","insp_end_time":"1000","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 31 AND HWY 175","county_code_state":"IA","county_code":"161","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MIDWEST COATING","shipping_paper_number":"MACHINERY","cargo_tank":null,"hazmat_placard_req":"N","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-11-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"32499","viol_total":"11","oos_total":"5","driver_viol_total":"3","driver_oos_total":"2","vehicle_viol_total":"8","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1380200","transaction_code":"A","transaction_date":"2025-11-12 00:00:00","upload_date":"2025-11-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00807537","upload_search_indicator":"M","census_search_date":"2025-11-12 21:41:00","snet_input_date":"2025-11-11 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-11-12 21:41:00","insp_carrier_name":"MIDWEST COATINGS COMPANY INC","insp_carrier_street":"1425 280TH STREET","insp_carrier_city":"MODALE","insp_carrier_state":"IA","insp_carrier_zip_code":"51556","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-15T10:30:48.000000Z","updated_at":"2025-11-16T10:30:57.000000Z","inspection_violations":[{"id":16904204,"change_date":"2025-11-12 21:41:00","inspection_id":"86297960","insp_violation_id":"269893969","seq_no":"1","part_no":"393","part_no_section":"25E","insp_viol_unit":"2","insp_unit_id":"209977785","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-15T10:31:05.000000Z","updated_at":"2025-11-16T10:31:41.000000Z","normalized_code":"39325E"},{"id":16904205,"change_date":"2025-11-12 21:41:00","inspection_id":"86297960","insp_violation_id":"269893970","seq_no":"2","part_no":"393","part_no_section":"9TS","insp_viol_unit":"2","insp_unit_id":"209977785","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"4HAN25111109362","created_at":"2025-11-15T10:31:05.000000Z","updated_at":"2025-11-16T10:31:41.000000Z","normalized_code":"3939TS"},{"id":16904206,"change_date":"2025-11-12 21:41:00","inspection_id":"86297960","insp_violation_id":"269893971","seq_no":"3","part_no":"393","part_no_section":"9T","insp_viol_unit":"2","insp_unit_id":"209977785","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-15T10:31:05.000000Z","updated_at":"2025-11-16T10:31:41.000000Z","normalized_code":"3939T"},{"id":16904207,"change_date":"2025-11-12 21:41:00","inspection_id":"86297960","insp_violation_id":"269893972","seq_no":"4","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"209977785","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-15T10:31:05.000000Z","updated_at":"2025-11-16T10:31:41.000000Z","normalized_code":"3939"},{"id":16904208,"change_date":"2025-11-12 21:41:00","inspection_id":"86297960","insp_violation_id":"269893973","seq_no":"5","part_no":"393","part_no_section":"100B-C","insp_viol_unit":"1","insp_unit_id":"209977784","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"4HAN25111109373","created_at":"2025-11-15T10:31:05.000000Z","updated_at":"2025-11-16T10:31:41.000000Z","normalized_code":"393100BC"},{"id":16904209,"change_date":"2025-11-12 21:41:00","inspection_id":"86297960","insp_violation_id":"269893974","seq_no":"6","part_no":"393","part_no_section":"43D","insp_viol_unit":"2","insp_unit_id":"209977785","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-11-15T10:31:05.000000Z","updated_at":"2025-11-16T10:31:41.000000Z","normalized_code":"39343D"},{"id":16904210,"change_date":"2025-11-12 21:41:00","inspection_id":"86297960","insp_violation_id":"269893975","seq_no":"7","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"209977784","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-15T10:31:05.000000Z","updated_at":"2025-11-16T10:31:41.000000Z","normalized_code":"3939"},{"id":16904211,"change_date":"2025-11-12 21:41:00","inspection_id":"86297960","insp_violation_id":"269893976","seq_no":"8","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"209977784","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-15T10:31:05.000000Z","updated_at":"2025-11-16T10:31:41.000000Z","normalized_code":"39395A"},{"id":16904212,"change_date":"2025-11-12 21:41:00","inspection_id":"86297960","insp_violation_id":"269893977","seq_no":"9","part_no":"383","part_no_section":"23A2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"4HAN25111109393","created_at":"2025-11-15T10:31:05.000000Z","updated_at":"2025-11-16T10:31:41.000000Z","normalized_code":"38323A2"},{"id":16904213,"change_date":"2025-11-12 21:41:00","inspection_id":"86297960","insp_violation_id":"269893978","seq_no":"10","part_no":"391","part_no_section":"49J","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-11-15T10:31:05.000000Z","updated_at":"2025-11-16T10:31:41.000000Z","normalized_code":"39149J"},{"id":16904214,"change_date":"2025-11-12 21:41:00","inspection_id":"86297960","insp_violation_id":"269893979","seq_no":"11","part_no":"392","part_no_section":"7A","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-11-15T10:31:05.000000Z","updated_at":"2025-11-16T10:31:41.000000Z","normalized_code":"3927A"}],"inspection_per_units":[{"id":16952097,"change_date":"2025-11-12 21:41:00","inspection_id":"86297960","insp_unit_id":"209977784","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":"T29","insp_unit_license":"KRL608","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1HTKHPVK3LH333130","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-15T10:00:39.000000Z","updated_at":"2025-11-16T10:01:16.000000Z"},{"id":16952098,"change_date":"2025-11-12 21:41:00","inspection_id":"86297960","insp_unit_id":"209977785","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"PJTM","insp_unit_company":"TR19","insp_unit_license":"KNA374","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"4P5H42228K1299208","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-15T10:00:39.000000Z","updated_at":"2025-11-16T10:01:16.000000Z"}]},{"id":10118973,"change_date":"2025-11-04 21:40:00","inspection_id":"86235430","dot_number":"807537","report_state":"NE","report_number":"T557001934","insp_date":"2025-11-04 00:00:00","insp_start_time":"0709","insp_end_time":"0735","registration_date":null,"region":"CT","ci_status_code":"C","location":"3","location_desc":"FREMONT SCALE","county_code_state":"NE","county_code":"053","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"MIDWEST COATINGS","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":"2025-11-04 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"31500","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":"828694","transaction_code":"A","transaction_date":"2025-11-04 00:00:00","upload_date":"2025-11-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00807537","upload_search_indicator":"M","census_search_date":"2025-11-04 21:40:00","snet_input_date":"2025-11-04 00:00:00","source_office":"3NES001","mcmis_add_date":"2025-11-04 21:40:00","insp_carrier_name":"MIDWEST COATINGS COMPANY INC","insp_carrier_street":"1425 280TH STREET","insp_carrier_city":"MODALE","insp_carrier_state":"IA","insp_carrier_zip_code":"51556","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-07T10:31:46.000000Z","updated_at":"2025-11-08T10:31:18.000000Z","inspection_violations":[{"id":16775672,"change_date":"2025-11-04 21:40:00","inspection_id":"86235430","insp_violation_id":"269724006","seq_no":"1","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"209835693","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"ET5304091","created_at":"2025-11-07T10:31:42.000000Z","updated_at":"2025-11-08T10:31:49.000000Z","normalized_code":"3922SLLIFTA"},{"id":16775673,"change_date":"2025-11-04 21:40:00","inspection_id":"86235430","insp_violation_id":"269724007","seq_no":"2","part_no":"392","part_no_section":"2-SLLIRP","insp_viol_unit":"1","insp_unit_id":"209835693","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-07T10:31:42.000000Z","updated_at":"2025-11-08T10:31:49.000000Z","normalized_code":"3922SLLIRP"}],"inspection_per_units":[{"id":16837198,"change_date":"2025-11-04 21:40:00","inspection_id":"86235430","insp_unit_id":"209835693","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"T22","insp_unit_license":"JTZ553","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"2NKHHJ7X9MM439855","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-07T10:01:39.000000Z","updated_at":"2025-11-08T10:01:39.000000Z"}]},{"id":9986919,"change_date":"2025-10-20 21:39:00","inspection_id":"86096480","dot_number":"807537","report_state":"NE","report_number":"T337000757","insp_date":"2025-10-20 00:00:00","insp_start_time":"1410","insp_end_time":"1425","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ON 558TH AVE, 1802 FEET SOUTH","county_code_state":"NE","county_code":"119","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MIDWEST COATINGS","shipping_paper_number":"795774","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":"2025-10-20 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"68000","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":"827488","transaction_code":"A","transaction_date":"2025-10-20 00:00:00","upload_date":"2025-10-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00807537","upload_search_indicator":"M","census_search_date":"2025-10-20 21:39:00","snet_input_date":"2025-10-20 00:00:00","source_office":"3NES001","mcmis_add_date":"2025-10-20 21:39:00","insp_carrier_name":"MIDWEST COATINGS COMPANY INC","insp_carrier_street":"1425 280TH STREET","insp_carrier_city":"MODALE","insp_carrier_state":"IA","insp_carrier_zip_code":"51556","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-23T10:00:42.000000Z","updated_at":"2025-10-24T10:01:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16583948,"change_date":"2025-10-20 21:39:00","inspection_id":"86096480","insp_unit_id":"209557884","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"T30","insp_unit_license":"FR1035","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1NKZX4EX1NJ481408","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-23T09:45:45.000000Z","updated_at":"2025-10-24T09:46:16.000000Z"}]},{"id":9877830,"change_date":"2025-10-07 21:41:00","inspection_id":"85981151","dot_number":"807537","report_state":"IA","report_number":"000P12723D","insp_date":"2025-10-06 00:00:00","insp_start_time":"0920","insp_end_time":"0945","registration_date":null,"region":"CT","ci_status_code":"C","location":"37","location_desc":"37 - I29 SB MM 132 SALIX","county_code_state":"IA","county_code":"193","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":"N","pen_cen_match":null,"final_status_date":"2025-10-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1376984","transaction_code":"A","transaction_date":"2025-10-07 00:00:00","upload_date":"2025-10-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00807537","upload_search_indicator":"M","census_search_date":"2025-10-07 21:41:00","snet_input_date":"2025-10-06 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-10-07 21:41:00","insp_carrier_name":"MIDWEST COATINGS COMPANY INC","insp_carrier_street":"1425 280TH STREET","insp_carrier_city":"MODALE","insp_carrier_state":"IA","insp_carrier_zip_code":"51556","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-10T10:02:26.000000Z","updated_at":"2025-10-11T10:01:01.000000Z","inspection_violations":[{"id":16282633,"change_date":"2025-10-07 21:41:00","inspection_id":"85981151","insp_violation_id":"269153082","seq_no":"1","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"209344439","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-10T10:18:39.000000Z","updated_at":"2025-10-11T10:16:54.000000Z","normalized_code":"39395A"},{"id":16282634,"change_date":"2025-10-07 21:41:00","inspection_id":"85981151","insp_violation_id":"269153083","seq_no":"2","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"209344439","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-10T10:18:39.000000Z","updated_at":"2025-10-11T10:16:54.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":16387443,"change_date":"2025-10-07 21:41:00","inspection_id":"85981151","insp_unit_id":"209344439","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"2221","insp_unit_license":"YCG4318","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"3HAEUMMN2SL022221","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-10T09:47:48.000000Z","updated_at":"2025-10-11T09:46:20.000000Z"}]},{"id":8989846,"change_date":"2025-06-26 21:40:00","inspection_id":"85048263","dot_number":"807537","report_state":"IA","report_number":"000P1685GS","insp_date":"2025-06-25 00:00:00","insp_start_time":"1418","insp_end_time":"1429","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"I 29 NB AND MM 142","county_code_state":"IA","county_code":"193","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MIDWEST COATINGS CO","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"135000","viol_total":"3","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1365125","transaction_code":"A","transaction_date":"2025-06-26 00:00:00","upload_date":"2025-06-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00807537","upload_search_indicator":"M","census_search_date":"2025-06-26 21:40:00","snet_input_date":"2025-06-25 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-06-26 21:40:00","insp_carrier_name":"MIDWEST COATINGS COMPANY INC","insp_carrier_street":"1425 280TH STREET","insp_carrier_city":"MODALE","insp_carrier_state":"IA","insp_carrier_zip_code":"51556","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-30T10:00:55.000000Z","updated_at":"2025-06-30T10:00:55.000000Z","inspection_violations":[{"id":14455445,"change_date":"2025-06-26 21:40:00","inspection_id":"85048263","insp_violation_id":"267057749","seq_no":"1","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"207564832","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-29T10:16:37.000000Z","updated_at":"2025-06-30T10:17:27.000000Z","normalized_code":"39360C"},{"id":14455446,"change_date":"2025-06-26 21:40:00","inspection_id":"85048263","insp_violation_id":"267057750","seq_no":"2","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":"8ROD25062514295","created_at":"2025-06-29T10:16:37.000000Z","updated_at":"2025-06-30T10:17:27.000000Z","normalized_code":"3922SLLEWG3"},{"id":14455447,"change_date":"2025-06-26 21:40:00","inspection_id":"85048263","insp_violation_id":"267057751","seq_no":"3","part_no":"392","part_no_section":"2DIM","insp_viol_unit":"2","insp_unit_id":"207564833","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"8ROD25062514310","created_at":"2025-06-29T10:16:37.000000Z","updated_at":"2025-06-30T10:17:27.000000Z","normalized_code":"3922DIM"}],"inspection_per_units":[{"id":14742924,"change_date":"2025-06-26 21:40:00","inspection_id":"85048263","insp_unit_id":"207564832","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"T-15","insp_unit_license":"FY4815","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKZP4TX5RJ372707","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-29T09:46:13.000000Z","updated_at":"2025-07-01T09:47:16.000000Z"},{"id":14742925,"change_date":"2025-06-26 21:40:00","inspection_id":"85048263","insp_unit_id":"207564833","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"TR-01","insp_unit_license":"FW2091","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1TKJ05339PM101802","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-29T09:46:13.000000Z","updated_at":"2025-07-01T09:47:16.000000Z"}]},{"id":8963540,"change_date":"2025-06-23 21:41:00","inspection_id":"85020397","dot_number":"807537","report_state":"NE","report_number":"T557001622","insp_date":"2025-06-23 00:00:00","insp_start_time":"0715","insp_end_time":"0735","registration_date":null,"region":"CT","ci_status_code":"C","location":"3","location_desc":"FREMONT SCALE","county_code_state":"NE","county_code":"053","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"NONE","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"165500","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":"818133","transaction_code":"A","transaction_date":"2025-06-23 00:00:00","upload_date":"2025-06-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00807537","upload_search_indicator":"M","census_search_date":"2025-06-23 21:41:00","snet_input_date":"2025-06-23 00:00:00","source_office":"3NES001","mcmis_add_date":"2025-06-23 21:41:00","insp_carrier_name":"MIDWEST COATINGS COMPANY INC","insp_carrier_street":"1425 280TH STREET","insp_carrier_city":"MODALE","insp_carrier_state":"IA","insp_carrier_zip_code":"51556","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-28T10:00:37.000000Z","updated_at":"2025-06-28T10:00:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14693996,"change_date":"2025-06-23 21:41:00","inspection_id":"85020397","insp_unit_id":"207511280","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"T15","insp_unit_license":"FY4815","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKZP4TX5RJ372707","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-26T09:45:39.000000Z","updated_at":"2025-06-27T09:46:13.000000Z"},{"id":14693997,"change_date":"2025-06-23 21:41:00","inspection_id":"85020397","insp_unit_id":"207511281","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"FW2091","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1TKJ05339PM101802","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-26T09:45:39.000000Z","updated_at":"2025-06-27T09:46:13.000000Z"}]},{"id":8758674,"change_date":"2025-05-28 21:43:00","inspection_id":"84802913","dot_number":"807537","report_state":"NE","report_number":"T478001420","insp_date":"2025-05-28 00:00:00","insp_start_time":"1220","insp_end_time":"1238","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ON STATE HWY 13, 763 FEET EAST","county_code_state":"NE","county_code":"139","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MIDWEST COATINGS COMPANY INC","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":"2025-05-28 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"134220","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":"815992","transaction_code":"A","transaction_date":"2025-05-28 00:00:00","upload_date":"2025-05-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00807537","upload_search_indicator":"M","census_search_date":"2025-05-28 21:43:00","snet_input_date":"2025-05-28 00:00:00","source_office":"3NES001","mcmis_add_date":"2025-05-28 21:43:00","insp_carrier_name":"MIDWEST COATINGS COMPANY INC","insp_carrier_street":"1425 280TH STREET","insp_carrier_city":"MODALE","insp_carrier_state":"IA","insp_carrier_zip_code":"51556","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-31T10:01:38.000000Z","updated_at":"2025-06-01T10:00:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14325995,"change_date":"2025-05-28 21:43:00","inspection_id":"84802913","insp_unit_id":"207109560","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"T-03","insp_unit_license":"FY1155","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1M1PN4GY7LM006152","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-31T09:46:53.000000Z","updated_at":"2025-06-01T09:47:44.000000Z"},{"id":14325996,"change_date":"2025-05-28 21:43:00","inspection_id":"84802913","insp_unit_id":"207109561","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"FY9798","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1E9V29136SE111090","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-31T09:46:53.000000Z","updated_at":"2025-06-01T09:47:44.000000Z"}]},{"id":8179528,"change_date":"2025-03-21 21:40:00","inspection_id":"84192680","dot_number":"807537","report_state":"NE","report_number":"T478001278","insp_date":"2025-03-21 00:00:00","insp_start_time":"0724","insp_end_time":"0746","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ON US HWY 81, 488 FEET NORTH O","county_code_state":"NE","county_code":"119","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MIDWEST COATINGS COMPANY INC","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":"2025-03-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"810977","transaction_code":"A","transaction_date":"2025-03-21 00:00:00","upload_date":"2025-03-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00807537","upload_search_indicator":"M","census_search_date":"2025-03-21 21:40:00","snet_input_date":"2025-03-21 00:00:00","source_office":"3NES001","mcmis_add_date":"2025-03-21 21:40:00","insp_carrier_name":"MIDWEST COATINGS COMPANY INC","insp_carrier_street":"1425 280TH STREET","insp_carrier_city":"MODALE","insp_carrier_state":"IA","insp_carrier_zip_code":"51556","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-24T10:28:02.000000Z","updated_at":"2025-03-25T10:11:01.000000Z","inspection_violations":[{"id":12819369,"change_date":"2025-03-21 21:40:00","inspection_id":"84192680","insp_violation_id":"265186474","seq_no":"1","part_no":"392","part_no_section":"2-SLLUCR","insp_viol_unit":"1","insp_unit_id":"205929885","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"EE59V0005130","created_at":"2025-03-23T11:39:27.000000Z","updated_at":"2025-03-25T10:31:55.000000Z","normalized_code":"3922SLLUCR"}],"inspection_per_units":[{"id":13221803,"change_date":"2025-03-21 21:40:00","inspection_id":"84192680","insp_unit_id":"205929885","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"T-07","insp_unit_license":"FW2197","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKDD49X4DJ353357","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-24T10:18:06.000000Z","updated_at":"2025-03-25T10:00:32.000000Z"},{"id":13221804,"change_date":"2025-03-21 21:40:00","inspection_id":"84192680","insp_unit_id":"205929886","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"FJ1974","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1DAFLD032MP023294","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-24T10:18:06.000000Z","updated_at":"2025-03-25T10:00:32.000000Z"}]},{"id":8175954,"change_date":"2025-03-21 21:40:00","inspection_id":"84188897","dot_number":"807537","report_state":"SD","report_number":"5630001054","insp_date":"2025-03-18 00:00:00","insp_start_time":"1105","insp_end_time":"1136","registration_date":null,"region":"CD","ci_status_code":"C","location":"MIDWAY","location_desc":"MIDWAY SD","county_code_state":"SD","county_code":"135","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SPENCER QUARRIES","shipping_paper_number":"N\/A","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":"U","pen_cen_match":"I","final_status_date":"2025-03-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1498307","transaction_code":"A","transaction_date":"2025-03-21 00:00:00","upload_date":"2025-03-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00807537","upload_search_indicator":null,"census_search_date":"2025-03-21 21:40:00","snet_input_date":"2025-03-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-21 21:40:00","insp_carrier_name":"MIDWEST COATINGS COMPANY INC","insp_carrier_street":"1425 280TH STREET","insp_carrier_city":"MODALE","insp_carrier_state":"IA","insp_carrier_zip_code":"51556","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-24T10:27:48.000000Z","updated_at":"2025-03-25T10:10:22.000000Z","inspection_violations":[{"id":12813954,"change_date":"2025-03-21 21:40:00","inspection_id":"84188897","insp_violation_id":"265178804","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"B1237427","created_at":"2025-03-23T11:35:33.000000Z","updated_at":"2025-03-25T10:26:14.000000Z","normalized_code":"3922SLLEWA2"}],"inspection_per_units":[{"id":13216014,"change_date":"2025-03-21 21:40:00","inspection_id":"84188897","insp_unit_id":"205922545","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"T-07","insp_unit_license":"FW2197","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKDD49X4DJ353357","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-24T10:13:07.000000Z","updated_at":"2025-03-25T09:54:10.000000Z"},{"id":13216015,"change_date":"2025-03-21 21:40:00","inspection_id":"84188897","insp_unit_id":"205922546","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DAKOTA MFG","insp_unit_company":"TR13","insp_unit_license":"FJ6558","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1DAFLD032MP023294","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-24T10:13:07.000000Z","updated_at":"2025-03-25T09:54:10.000000Z"}]},{"id":7329277,"change_date":"2024-12-03 21:40:00","inspection_id":"83299352","dot_number":"807537","report_state":"NE","report_number":"T143000439","insp_date":"2024-12-03 00:00:00","insp_start_time":"0850","insp_end_time":"0935","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ON UNNAMED STREET, 60 FEET NOR","county_code_state":"NE","county_code":"021","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MIDWEST COATINGS COMPANY","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":"2024-12-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"86780","viol_total":"5","oos_total":"2","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"803330","transaction_code":"A","transaction_date":"2024-12-03 00:00:00","upload_date":"2024-12-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00807537","upload_search_indicator":"M","census_search_date":"2024-12-03 21:40:00","snet_input_date":"2024-12-03 00:00:00","source_office":"3NES001","mcmis_add_date":"2024-12-03 21:40:00","insp_carrier_name":"MIDWEST COATINGS COMPANY INC","insp_carrier_street":"1425 280TH STREET","insp_carrier_city":"MODALE","insp_carrier_state":"IA","insp_carrier_zip_code":"51556","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:48:59.000000Z","updated_at":"2025-03-17T20:48:59.000000Z","inspection_violations":[{"id":11459835,"change_date":"2024-12-03 21:40:00","inspection_id":"83299352","insp_violation_id":"263197638","seq_no":"1","part_no":"392","part_no_section":"82A1","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-17T22:01:41.000000Z","updated_at":"2025-03-17T22:01:41.000000Z","normalized_code":"39282A1"},{"id":11459836,"change_date":"2024-12-03 21:40:00","inspection_id":"83299352","insp_violation_id":"263197639","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":"EA5501516","created_at":"2025-03-17T22:01:41.000000Z","updated_at":"2025-03-17T22:01:41.000000Z","normalized_code":"3922SLLEWA3"},{"id":11459837,"change_date":"2024-12-03 21:40:00","inspection_id":"83299352","insp_violation_id":"263197640","seq_no":"3","part_no":"391","part_no_section":"11B4-DEN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"EA5501516","created_at":"2025-03-17T22:01:41.000000Z","updated_at":"2025-03-17T22:01:41.000000Z","normalized_code":"39111B4DEN"},{"id":11459838,"change_date":"2024-12-03 21:40:00","inspection_id":"83299352","insp_violation_id":"263197641","seq_no":"4","part_no":"391","part_no_section":"41A1-NPH","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:41.000000Z","updated_at":"2025-03-17T22:01:41.000000Z","normalized_code":"39141A1NPH"},{"id":11459839,"change_date":"2024-12-03 21:40:00","inspection_id":"83299352","insp_violation_id":"263197642","seq_no":"5","part_no":"393","part_no_section":"75A","insp_viol_unit":"1","insp_unit_id":"204154339","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"EA5501516","created_at":"2025-03-17T22:01:41.000000Z","updated_at":"2025-03-17T22:01:41.000000Z","normalized_code":"39375A"}],"inspection_per_units":[{"id":11823465,"change_date":"2024-12-03 21:40:00","inspection_id":"83299352","insp_unit_id":"204154339","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"T11","insp_unit_license":"FA2787","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1NKZX4TX6KJ257971","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:33.000000Z","updated_at":"2025-03-17T23:45:33.000000Z"}]},{"id":7329304,"change_date":"2024-12-03 21:40:00","inspection_id":"83299379","dot_number":"807537","report_state":"NE","report_number":"T409000318","insp_date":"2024-12-03 00:00:00","insp_start_time":"0840","insp_end_time":"0855","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ON US HWY 275, 1518 FEET NORTH","county_code_state":"NE","county_code":"039","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MIDWEST COATINGS","shipping_paper_number":"D3240693","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-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"127250","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":"803332","transaction_code":"A","transaction_date":"2024-12-03 00:00:00","upload_date":"2024-12-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00807537","upload_search_indicator":"M","census_search_date":"2024-12-03 21:40:00","snet_input_date":"2024-12-03 00:00:00","source_office":"3NES001","mcmis_add_date":"2024-12-03 21:40:00","insp_carrier_name":"MIDWEST COATINGS COMPANY INC","insp_carrier_street":"1425 280TH STREET","insp_carrier_city":"MODALE","insp_carrier_state":"IA","insp_carrier_zip_code":"51556","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:48:59.000000Z","updated_at":"2025-03-17T20:48:59.000000Z","inspection_violations":[{"id":11459864,"change_date":"2024-12-03 21:40:00","inspection_id":"83299379","insp_violation_id":"263197670","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":"2025-03-17T22:01:41.000000Z","updated_at":"2025-03-17T22:01:41.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":11823504,"change_date":"2024-12-03 21:40:00","inspection_id":"83299379","insp_unit_id":"204154382","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"T17","insp_unit_license":"DD8410","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XP5DU9X13D593722","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:33.000000Z","updated_at":"2025-03-17T23:45:33.000000Z"},{"id":11823505,"change_date":"2024-12-03 21:40:00","inspection_id":"83299379","insp_unit_id":"204154383","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"TR23","insp_unit_license":"FT0642","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1TKL04124NW077746","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:33.000000Z","updated_at":"2025-03-17T23:45:33.000000Z"}]},{"id":7230418,"change_date":"2024-11-19 21:40:00","inspection_id":"83195052","dot_number":"807537","report_state":"NE","report_number":"T337000485","insp_date":"2024-11-19 00:00:00","insp_start_time":"0910","insp_end_time":"0921","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ON US HWY 275, 2533 FEET EAST","county_code_state":"NE","county_code":"167","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MIDWEST COATINGS","shipping_paper_number":"252631","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-11-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"77020","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":"802393","transaction_code":"A","transaction_date":"2024-11-19 00:00:00","upload_date":"2024-11-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00807537","upload_search_indicator":"M","census_search_date":"2024-11-19 21:40:00","snet_input_date":"2024-11-19 00:00:00","source_office":"3NES001","mcmis_add_date":"2024-11-19 21:40:00","insp_carrier_name":"MIDWEST COATINGS COMPANY INC","insp_carrier_street":"1425 280TH STREET","insp_carrier_city":"MODALE","insp_carrier_state":"IA","insp_carrier_zip_code":"51556","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:46:50.000000Z","updated_at":"2025-03-17T20:46:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11662488,"change_date":"2024-11-19 21:40:00","inspection_id":"83195052","insp_unit_id":"203954352","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"T-4","insp_unit_license":"DH1599","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5KKMAVDV1GPHJ2635","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:52.000000Z","updated_at":"2025-03-17T23:43:52.000000Z"}]},{"id":6749203,"change_date":"2024-09-17 21:46:00","inspection_id":"82683814","dot_number":"807537","report_state":"NE","report_number":"T034000600","insp_date":"2024-09-17 00:00:00","insp_start_time":"1130","insp_end_time":"1150","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ON 205TH ST, 73 FEET WEST FROM","county_code_state":"NE","county_code":"141","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-09-17 21:46:00","post_acc_ind":"N","gross_comb_veh_wt":"78000","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":"797674","transaction_code":"A","transaction_date":"2024-09-17 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00807537","upload_search_indicator":"M","census_search_date":"2024-09-17 21:46:00","snet_input_date":"2024-09-17 00:00:00","source_office":"3NES001","mcmis_add_date":"2024-09-17 21:46:00","insp_carrier_name":"MIDWEST COATINGS COMPANY INC","insp_carrier_street":"1425 280TH STREET","insp_carrier_city":"MODALE","insp_carrier_state":"IA","insp_carrier_zip_code":"51556","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:36:56.000000Z","updated_at":"2025-03-17T20:36:56.000000Z","inspection_violations":[{"id":10509056,"change_date":"2024-09-17 21:46:00","inspection_id":"82683814","insp_violation_id":"261875376","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:56:54.000000Z","updated_at":"2025-03-17T21:56:54.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10883114,"change_date":"2024-09-17 21:46:00","inspection_id":"82683814","insp_unit_id":"202988278","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"FY7052","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1NKZX4TX0LJ381249","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:43.000000Z","updated_at":"2025-03-17T23:35:43.000000Z"}]},{"id":6735474,"change_date":"2024-09-16 21:42:00","inspection_id":"82669300","dot_number":"807537","report_state":"IA","report_number":"000P1271D4","insp_date":"2024-09-13 00:00:00","insp_start_time":"2000","insp_end_time":"2012","registration_date":null,"region":"CT","ci_status_code":"C","location":"37","location_desc":"37 - I29 SB MM 132 SALIX","county_code_state":"IA","county_code":"193","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"MIDWEST COATINGS","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-09-16 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"76000","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":"1329496","transaction_code":"A","transaction_date":"2024-09-16 00:00:00","upload_date":"2024-09-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00807537","upload_search_indicator":"M","census_search_date":"2024-09-16 21:42:00","snet_input_date":"2024-09-13 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-09-16 21:42:00","insp_carrier_name":"MIDWEST COATINGS COMPANY INC","insp_carrier_street":"1425 280TH STREET","insp_carrier_city":"MODALE","insp_carrier_state":"IA","insp_carrier_zip_code":"51556","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:36:33.000000Z","updated_at":"2025-03-17T20:36:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10860922,"change_date":"2024-09-16 21:42:00","inspection_id":"82669300","insp_unit_id":"202941990","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"T-30","insp_unit_license":"FR1035","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1NKZX4EX1NJ481408","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:31.000000Z","updated_at":"2025-03-17T23:35:31.000000Z"}]},{"id":6632329,"change_date":"2024-09-03 21:42:00","inspection_id":"82559748","dot_number":"807537","report_state":"NE","report_number":"T557001041","insp_date":"2024-09-03 00:00:00","insp_start_time":"0820","insp_end_time":"0850","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ON US HWY 30, 62 FEET NORTH OF","county_code_state":"NE","county_code":"177","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MIDWEST COATINGS","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":"2024-09-03 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"140000","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":"796181","transaction_code":"A","transaction_date":"2024-09-03 00:00:00","upload_date":"2024-09-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00807537","upload_search_indicator":"M","census_search_date":"2024-09-03 21:42:00","snet_input_date":"2024-09-03 00:00:00","source_office":"3NES001","mcmis_add_date":"2024-09-03 21:42:00","insp_carrier_name":"MIDWEST COATINGS COMPANY INC","insp_carrier_street":"1425 280TH STREET","insp_carrier_city":"MODALE","insp_carrier_state":"IA","insp_carrier_zip_code":"51556","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:34:28.000000Z","updated_at":"2025-03-17T20:34:28.000000Z","inspection_violations":[{"id":10316243,"change_date":"2024-09-03 21:42:00","inspection_id":"82559748","insp_violation_id":"261574312","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"202727412","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"ET5303894","created_at":"2025-03-17T21:55:57.000000Z","updated_at":"2025-03-17T21:55:57.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10692945,"change_date":"2024-09-03 21:42:00","inspection_id":"82559748","insp_unit_id":"202727411","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"T21","insp_unit_license":"FY7052","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1NKZX4TX0LJ381249","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:44.000000Z","updated_at":"2025-03-17T23:33:44.000000Z"},{"id":10692946,"change_date":"2024-09-03 21:42:00","inspection_id":"82559748","insp_unit_id":"202727412","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAI","insp_unit_company":null,"insp_unit_license":"FH9452","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1DASFF430MP023144","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:44.000000Z","updated_at":"2025-03-17T23:33:44.000000Z"}]},{"id":6597647,"change_date":"2024-08-29 21:43:00","inspection_id":"82522844","dot_number":"807537","report_state":"NE","report_number":"T337000424","insp_date":"2024-08-29 00:00:00","insp_start_time":"0715","insp_end_time":"0727","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ON N 1ST ST, 1039 FEET SOUTH F","county_code_state":"NE","county_code":"119","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"NORFOLK CRUSH","shipping_paper_number":"6548","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-08-29 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"68000","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":"795965","transaction_code":"A","transaction_date":"2024-08-29 00:00:00","upload_date":"2024-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00807537","upload_search_indicator":"M","census_search_date":"2024-08-29 21:43:00","snet_input_date":"2024-08-29 00:00:00","source_office":"3NES001","mcmis_add_date":"2024-08-29 21:43:00","insp_carrier_name":"MIDWEST COATINGS COMPANY INC","insp_carrier_street":"1425 280TH STREET","insp_carrier_city":"MODALE","insp_carrier_state":"IA","insp_carrier_zip_code":"51556","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:33:42.000000Z","updated_at":"2025-03-17T20:33:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10636608,"change_date":"2024-08-29 21:43:00","inspection_id":"82522844","insp_unit_id":"202656699","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"T-30","insp_unit_license":"FR1035","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1NKZX4EX1NJ481408","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:10.000000Z","updated_at":"2025-03-17T23:33:10.000000Z"}]},{"id":6457420,"change_date":"2024-08-13 21:42:00","inspection_id":"82373248","dot_number":"807537","report_state":"NE","report_number":"T025001259","insp_date":"2024-08-13 00:00:00","insp_start_time":"0550","insp_end_time":"0615","registration_date":null,"region":"CT","ci_status_code":"C","location":"3","location_desc":"FREMONT SCALE","county_code_state":"NE","county_code":"053","insp_level_id":"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":"N","pen_cen_match":null,"final_status_date":"2024-08-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"58000","viol_total":"4","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":"794496","transaction_code":"A","transaction_date":"2024-08-13 00:00:00","upload_date":"2024-08-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00807537","upload_search_indicator":"M","census_search_date":"2024-08-13 21:42:00","snet_input_date":"2024-08-13 00:00:00","source_office":"3NES001","mcmis_add_date":"2024-08-13 21:42:00","insp_carrier_name":"MIDWEST COATINGS COMPANY INC","insp_carrier_street":"1425 280TH STREET","insp_carrier_city":"MODALE","insp_carrier_state":"IA","insp_carrier_zip_code":"51556","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:30:44.000000Z","updated_at":"2025-03-17T20:30:44.000000Z","inspection_violations":[{"id":10027884,"change_date":"2024-08-13 21:42:00","inspection_id":"82373248","insp_violation_id":"261167724","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202371139","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:32.000000Z","updated_at":"2025-03-17T21:54:32.000000Z","normalized_code":"3939A"},{"id":10027885,"change_date":"2024-08-13 21:42:00","inspection_id":"82373248","insp_violation_id":"261167725","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"202371139","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:32.000000Z","updated_at":"2025-03-17T21:54:32.000000Z","normalized_code":"39311"},{"id":10027886,"change_date":"2024-08-13 21:42:00","inspection_id":"82373248","insp_violation_id":"261167726","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202371139","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:32.000000Z","updated_at":"2025-03-17T21:54:32.000000Z","normalized_code":"3922"},{"id":10027887,"change_date":"2024-08-13 21:42:00","inspection_id":"82373248","insp_violation_id":"261167727","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202371139","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:32.000000Z","updated_at":"2025-03-17T21:54:32.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10408251,"change_date":"2024-08-13 21:42:00","inspection_id":"82373248","insp_unit_id":"202371139","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"T-14","insp_unit_license":"FW2198","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1M2AX04C0JM038919","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:51.000000Z","updated_at":"2025-03-17T23:30:51.000000Z"}]},{"id":6261547,"change_date":"2024-07-19 21:37:00","inspection_id":"82163598","dot_number":"807537","report_state":"NE","report_number":"T033000426","insp_date":"2024-07-19 00:00:00","insp_start_time":"0738","insp_end_time":"0800","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ON US HWY 75, 248 FEET SOUTH O","county_code_state":"NE","county_code":"177","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MARTIN MARIETTA","shipping_paper_number":"49176766","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-07-19 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","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":"792462","transaction_code":"A","transaction_date":"2024-07-19 00:00:00","upload_date":"2024-07-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00807537","upload_search_indicator":"M","census_search_date":"2024-07-19 21:37:00","snet_input_date":"2024-07-19 00:00:00","source_office":"3NES001","mcmis_add_date":"2024-07-19 21:37:00","insp_carrier_name":"MIDWEST COATINGS COMPANY INC","insp_carrier_street":"1425 280TH STREET","insp_carrier_city":"MODALE","insp_carrier_state":"IA","insp_carrier_zip_code":"51556","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:26:58.000000Z","updated_at":"2025-03-17T20:26:58.000000Z","inspection_violations":[{"id":9725875,"change_date":"2024-07-19 21:37:00","inspection_id":"82163598","insp_violation_id":"260736981","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"201972296","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:53:04.000000Z","updated_at":"2025-03-17T21:53:04.000000Z","normalized_code":"3922"},{"id":9725876,"change_date":"2024-07-19 21:37:00","inspection_id":"82163598","insp_violation_id":"260736982","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"201972296","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:53:04.000000Z","updated_at":"2025-03-17T21:53:04.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10088499,"change_date":"2024-07-19 21:37:00","inspection_id":"82163598","insp_unit_id":"201972296","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"T-21","insp_unit_license":"FJ0609","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1NKZX4TX0LJ381249","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:32.000000Z","updated_at":"2025-03-17T23:27:32.000000Z"}]},{"id":5920514,"change_date":"2024-06-05 21:42:00","inspection_id":"81796113","dot_number":"807537","report_state":"NE","report_number":"T557000870","insp_date":"2024-06-05 00:00:00","insp_start_time":"1025","insp_end_time":"1059","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ON US HWY 275, 1233 FEET WEST","county_code_state":"NE","county_code":"053","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MIDWEST COATINGS","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-05 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"136000","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":"789258","transaction_code":"A","transaction_date":"2024-06-05 00:00:00","upload_date":"2024-06-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00807537","upload_search_indicator":"M","census_search_date":"2024-06-05 21:42:00","snet_input_date":"2024-06-05 00:00:00","source_office":"3NES001","mcmis_add_date":"2024-06-05 21:42:00","insp_carrier_name":"MIDWEST COATINGS COMPANY INC","insp_carrier_street":"1425 280TH STREET","insp_carrier_city":"MODALE","insp_carrier_state":"IA","insp_carrier_zip_code":"51556","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:20:13.000000Z","updated_at":"2025-03-17T20:20:13.000000Z","inspection_violations":[{"id":9180253,"change_date":"2024-06-05 21:42:00","inspection_id":"81796113","insp_violation_id":"259921188","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:50:25.000000Z","updated_at":"2025-03-17T21:50:25.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9536053,"change_date":"2024-06-05 21:42:00","inspection_id":"81796113","insp_unit_id":"201249595","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"T24","insp_unit_license":"FT7130","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKZP40X1LJ422210","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:55.000000Z","updated_at":"2025-03-17T23:21:55.000000Z"},{"id":9536054,"change_date":"2024-06-05 21:42:00","inspection_id":"81796113","insp_unit_id":"201249596","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"TR01","insp_unit_license":"FW2091","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1TKJ05339PM101802","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:55.000000Z","updated_at":"2025-03-17T23:21:55.000000Z"}]},{"id":4165562,"change_date":"2023-10-10 21:42:00","inspection_id":"79876657","dot_number":"807537","report_state":"SD","report_number":"A003037154","insp_date":"2023-10-09 00:00:00","insp_start_time":"0735","insp_end_time":"0757","registration_date":null,"region":"CT","ci_status_code":"C","location":"JPOE","location_desc":"JEFFERSON PORT OF ENTRY","county_code_state":"SD","county_code":"127","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"MIDWEST COATINGS COMPANY INC","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":"I","final_status_date":"2023-10-10 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"0","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":"653632","transaction_code":"A","transaction_date":"2023-10-09 00:00:00","upload_date":"2023-10-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00807537","upload_search_indicator":null,"census_search_date":"2023-10-10 21:42:00","snet_input_date":"2023-10-10 00:00:00","source_office":"4SDS001","mcmis_add_date":"2023-10-10 21:42:00","insp_carrier_name":"MIDWEST COATINGS COMPANY INC","insp_carrier_street":"1425 280TH STREET","insp_carrier_city":"MODALE","insp_carrier_state":"IA","insp_carrier_zip_code":"51556","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:45:27.000000Z","updated_at":"2025-03-17T19:45:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6698392,"change_date":"2023-10-10 21:42:00","inspection_id":"79876657","insp_unit_id":"197484451","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"T-21","insp_unit_license":"FJ0609","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1NKZX4TX0LJ381249","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:09.000000Z","updated_at":"2025-03-17T22:56:09.000000Z"},{"id":6698393,"change_date":"2023-10-10 21:42:00","inspection_id":"79876657","insp_unit_id":"197484452","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRIM","insp_unit_company":"TR-12","insp_unit_license":"FH9452","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1DASFF430MP023144","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:09.000000Z","updated_at":"2025-03-17T22:56:09.000000Z"}]},{"id":4165611,"change_date":"2023-10-10 21:42:00","inspection_id":"79876713","dot_number":"807537","report_state":"SD","report_number":"031A006074","insp_date":"2023-10-07 00:00:00","insp_start_time":"1032","insp_end_time":"1119","registration_date":null,"region":"CT","ci_status_code":"C","location":"JOE","location_desc":"JEFFERSON PORT OF ENTRY","county_code_state":"SD","county_code":"127","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"F","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-10-10 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"653618","transaction_code":"A","transaction_date":"2023-10-07 00:00:00","upload_date":"2023-10-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00807537","upload_search_indicator":null,"census_search_date":"2023-10-10 21:42:00","snet_input_date":"2023-10-10 00:00:00","source_office":"4SDS001","mcmis_add_date":"2023-10-10 21:42:00","insp_carrier_name":"MIDWEST COATINGS COMPANY INC","insp_carrier_street":"1425 280TH STREET","insp_carrier_city":"MODALE","insp_carrier_state":"IA","insp_carrier_zip_code":"51556","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:45:27.000000Z","updated_at":"2025-03-17T19:45:27.000000Z","inspection_violations":[{"id":6446924,"change_date":"2023-10-10 21:42:00","inspection_id":"79876713","insp_violation_id":"255753041","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":"B1039000","created_at":"2025-03-17T21:37:05.000000Z","updated_at":"2025-03-17T21:37:05.000000Z","normalized_code":"3922"},{"id":6446925,"change_date":"2023-10-10 21:42:00","inspection_id":"79876713","insp_violation_id":"255753042","seq_no":"2","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:37:05.000000Z","updated_at":"2025-03-17T21:37:05.000000Z","normalized_code":"38323A2"}],"inspection_per_units":[{"id":6698471,"change_date":"2023-10-10 21:42:00","inspection_id":"79876713","insp_unit_id":"197484543","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"T-07","insp_unit_license":"FW21097","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKDD49X4DJ353357","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:09.000000Z","updated_at":"2025-03-17T22:56:09.000000Z"},{"id":6698472,"change_date":"2023-10-10 21:42:00","inspection_id":"79876713","insp_unit_id":"197484544","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DAKO","insp_unit_company":"TR13","insp_unit_license":"FJ6558","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1DAFLD032MP023294","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:09.000000Z","updated_at":"2025-03-17T22:56:09.000000Z"}]},{"id":3859540,"change_date":"2023-08-29 21:42:00","inspection_id":"79536613","dot_number":"807537","report_state":"NE","report_number":"T557000403","insp_date":"2023-08-29 00:00:00","insp_start_time":"0740","insp_end_time":"0759","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ON US HWY 75, 1690 FEET SOUTH","county_code_state":"NE","county_code":"021","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MIDWEST COATINGS","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-08-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"137650","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":"768711","transaction_code":"A","transaction_date":"2023-08-29 00:00:00","upload_date":"2023-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00807537","upload_search_indicator":null,"census_search_date":"2023-08-29 21:42:00","snet_input_date":"2023-08-29 00:00:00","source_office":"3NES001","mcmis_add_date":"2023-08-29 21:42:00","insp_carrier_name":"MIDWEST COATINGS COMPANY INC","insp_carrier_street":"1425 280TH STREET","insp_carrier_city":"MODALE","insp_carrier_state":"IA","insp_carrier_zip_code":"51556","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:38:59.000000Z","updated_at":"2025-03-17T19:38:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6205049,"change_date":"2023-08-29 21:42:00","inspection_id":"79536613","insp_unit_id":"196791409","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"T11","insp_unit_license":"FA2787","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1NKZX4TX6KJ257971","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:09.000000Z","updated_at":"2025-03-17T22:52:09.000000Z"},{"id":6205050,"change_date":"2023-08-29 21:42:00","inspection_id":"79536613","insp_unit_id":"196791410","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLK","insp_unit_company":"TK50RB","insp_unit_license":"DZ9066","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":null,"insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:09.000000Z","updated_at":"2025-03-17T22:52:09.000000Z"}]},{"id":1728829,"change_date":"2022-11-14 21:42:00","inspection_id":"77121720","dot_number":"807537","report_state":"IA","report_number":"000TT7KFB9","insp_date":"2022-11-10 00:00:00","insp_start_time":"0855","insp_end_time":"0910","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 71 SB","county_code_state":"IA","county_code":"137","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"OWN","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"64000","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1250862","transaction_code":"A","transaction_date":"2022-11-14 00:00:00","upload_date":"2022-11-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00807537","upload_search_indicator":"M","census_search_date":"2022-11-14 21:42:00","snet_input_date":"2022-11-10 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-11-14 21:42:00","insp_carrier_name":"MIDWEST COATINGS COMPANY INC","insp_carrier_street":"1425 280TH STREET","insp_carrier_city":"MODALE","insp_carrier_state":"IA","insp_carrier_zip_code":"51556","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:58:33.000000Z","updated_at":"2025-03-17T18:58:33.000000Z","inspection_violations":[{"id":2706516,"change_date":"2022-11-14 21:42:00","inspection_id":"77121720","insp_violation_id":"249570234","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:19:45.000000Z","updated_at":"2025-03-17T21:19:45.000000Z","normalized_code":"3922"},{"id":2706517,"change_date":"2022-11-14 21:42:00","inspection_id":"77121720","insp_violation_id":"249570235","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"191931001","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:45.000000Z","updated_at":"2025-03-17T21:19:45.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":2781363,"change_date":"2022-11-14 21:42:00","inspection_id":"77121720","insp_unit_id":"191931001","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"T-13","insp_unit_license":"FP6532","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5KKSALCV65PU51493","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:02.000000Z","updated_at":"2025-03-17T22:26:02.000000Z"}]},{"id":1645900,"change_date":"2022-11-01 21:40:00","inspection_id":"77026510","dot_number":"807537","report_state":"IA","report_number":"000TT884SK","insp_date":"2022-10-26 00:00:00","insp_start_time":"1329","insp_end_time":"1355","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 71 AND 185TH ST","county_code_state":"IA","county_code":"137","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"HENNINGSEN CONSTRUCTION","shipping_paper_number":"238111","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-11-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"86780","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":"1248845","transaction_code":"A","transaction_date":"2022-10-31 00:00:00","upload_date":"2022-10-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00807537","upload_search_indicator":"M","census_search_date":"2022-11-01 21:40:00","snet_input_date":"2022-10-26 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-11-01 21:40:00","insp_carrier_name":"MIDWEST COATINGS COMPANY INC","insp_carrier_street":"1425 280TH STREET","insp_carrier_city":"MODALE","insp_carrier_state":"IA","insp_carrier_zip_code":"51556","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:57:02.000000Z","updated_at":"2025-03-17T18:57:02.000000Z","inspection_violations":[{"id":2582897,"change_date":"2022-11-01 21:40:00","inspection_id":"77026510","insp_violation_id":"249366230","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":"T28622102613402","created_at":"2025-03-17T21:19:11.000000Z","updated_at":"2025-03-17T21:19:11.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2648136,"change_date":"2022-11-01 21:40:00","inspection_id":"77026510","insp_unit_id":"191745363","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"T-21","insp_unit_license":"FJ0609","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1NKZX4TX0LJ381249","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:09.000000Z","updated_at":"2025-03-17T22:25:09.000000Z"}]},{"id":1230843,"change_date":"2022-09-07 21:40:00","inspection_id":"76546302","dot_number":"807537","report_state":"NE","report_number":"ZU00002652","insp_date":"2022-09-06 00:00:00","insp_start_time":"1637","insp_end_time":"1654","registration_date":null,"region":"CT","ci_status_code":"C","location":"FREMNT","location_desc":"FREMONT SCALE","county_code_state":"NE","county_code":"053","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"F","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":"2022-09-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"56000","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":"740513","transaction_code":"A","transaction_date":"2022-09-06 00:00:00","upload_date":"2022-09-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00807537","upload_search_indicator":null,"census_search_date":"2022-09-07 21:40:00","snet_input_date":"2022-09-07 00:00:00","source_office":"3NES001","mcmis_add_date":"2022-09-07 21:40:00","insp_carrier_name":"MIDWEST COATINGS COMPANY INC","insp_carrier_street":"1425 280TH STREET","insp_carrier_city":"MODALE","insp_carrier_state":"IA","insp_carrier_zip_code":"51556","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:49:20.000000Z","updated_at":"2025-03-17T18:49:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1980694,"change_date":"2022-09-07 21:40:00","inspection_id":"76546302","insp_unit_id":"190767606","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"T-23","insp_unit_license":"FJ3488","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"2NKHLJ9X5MM439329","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:37.000000Z","updated_at":"2025-03-17T22:20:37.000000Z"}]},{"id":658956,"change_date":"2022-06-21 21:42:00","inspection_id":"75878268","dot_number":"807537","report_state":"IA","report_number":"000TT7FM9K","insp_date":"2022-06-17 00:00:00","insp_start_time":"0927","insp_end_time":"0951","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 175 EB TURIN","county_code_state":"IA","county_code":"133","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MIDWEST COATING","shipping_paper_number":"20220272","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-21 21:42: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":"1229660","transaction_code":"A","transaction_date":"2022-06-21 00:00:00","upload_date":"2022-06-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00807537","upload_search_indicator":"M","census_search_date":"2022-06-21 21:42:00","snet_input_date":"2022-06-17 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-06-21 21:42:00","insp_carrier_name":"MIDWEST COATINGS COMPANY INC","insp_carrier_street":"1425 280TH STREET","insp_carrier_city":"MODALE","insp_carrier_state":"IA","insp_carrier_zip_code":"51556","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:39:13.000000Z","updated_at":"2025-03-17T18:39:13.000000Z","inspection_violations":[{"id":1037158,"change_date":"2022-06-21 21:42:00","inspection_id":"75878268","insp_violation_id":"246617348","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":"T22422061709410","created_at":"2025-03-17T21:11:50.000000Z","updated_at":"2025-03-17T21:11:50.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1059053,"change_date":"2022-06-21 21:42:00","inspection_id":"75878268","insp_unit_id":"189375865","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"6431","insp_unit_license":"YCB3785","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1FVACXFC0NHNS9337","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:42.000000Z","updated_at":"2025-03-17T22:14:42.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/807537\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/807537\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/807537\/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\/807537\/inspections","per_page":100,"prev_page_url":null,"to":33,"total":33}