{"current_page":1,"data":[{"id":11905921,"change_date":"2026-05-14 21:42:00","inspection_id":"87844940","dot_number":"937927","report_state":"SD","report_number":"5450003334","insp_date":"2026-05-13 00:00:00","insp_start_time":"1520","insp_end_time":"1611","registration_date":null,"region":"CD","ci_status_code":"C","location":"SUFLSW","location_desc":"VALLEY SPRINGS SD","county_code_state":"SD","county_code":"099","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ELECTRIC PUMP INC","shipping_paper_number":"NONE","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":"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":"15500","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":"1","hazmat_oos_total":"0","snet_sequence_id":"3321195","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":"00937927","upload_search_indicator":null,"census_search_date":"2026-05-14 21:42:00","snet_input_date":"2026-05-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-14 21:42:00","insp_carrier_name":"ELECTRIC PUMP","insp_carrier_street":"4280 NE 14TH","insp_carrier_city":"DES MOINES","insp_carrier_state":"IA","insp_carrier_zip_code":"50313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-16T13:32:50.000000Z","updated_at":"2026-05-25T09:30:59.000000Z","inspection_violations":[{"id":20710541,"change_date":"2026-05-14 21:42:00","inspection_id":"87844940","insp_violation_id":"274250766","seq_no":"2","part_no":"172","part_no_section":"602C-HMER","insp_viol_unit":"1","insp_unit_id":"213546281","insp_violation_category_id":"38","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2026-05-16T13:12:48.000000Z","updated_at":"2026-05-25T09:42:44.000000Z","normalized_code":"172602CHMER"},{"id":20710540,"change_date":"2026-05-14 21:42:00","inspection_id":"87844940","insp_violation_id":"274250765","seq_no":"1","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"213546281","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2026-05-16T13:12:48.000000Z","updated_at":"2026-05-25T09:42:44.000000Z","normalized_code":"39395F"}],"inspection_per_units":[{"id":20698418,"change_date":"2026-05-14 21:42:00","inspection_id":"87844940","insp_unit_id":"213546281","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":"36","insp_unit_license":"85517C","insp_unit_license_state":"SD","insp_unit_vehicle_id_number":"1HTKJPVM3LH590732","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-16T12:44:44.000000Z","updated_at":"2026-05-25T09:03:19.000000Z"}]},{"id":11965875,"change_date":"2026-05-19 21:41:00","inspection_id":"87902310","dot_number":"937927","report_state":"IA","report_number":"000P13X6LX","insp_date":"2026-05-11 00:00:00","insp_start_time":"0955","insp_end_time":"1020","registration_date":null,"region":"CT","ci_status_code":"C","location":"44","location_desc":"44 - JCT HWY 71\/20 EARLY","county_code_state":"IA","county_code":"161","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"ELECTRIC PUMP","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":"2026-05-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"1400572","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":"00937927","upload_search_indicator":"M","census_search_date":"2026-05-19 21:41:00","snet_input_date":"2026-05-11 00:00:00","source_office":"3IAS001","mcmis_add_date":"2026-05-19 21:41:00","insp_carrier_name":"ELECTRIC PUMP","insp_carrier_street":"4280 NE 14TH","insp_carrier_city":"DES MOINES","insp_carrier_state":"IA","insp_carrier_zip_code":"50313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-22T09:41:17.000000Z","updated_at":"2026-05-30T09:31:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20804899,"change_date":"2026-05-19 21:41:00","inspection_id":"87902310","insp_unit_id":"213650572","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":null,"insp_unit_license":"AMX831","insp_unit_license_state":"NE","insp_unit_vehicle_id_number":"3C7WRMBL1JG304517","insp_unit_decal":"Y","insp_unit_decal_number":"36426567","created_at":"2026-05-22T09:21:55.000000Z","updated_at":"2026-05-30T09:03:43.000000Z"}]},{"id":11101003,"change_date":"2026-02-11 21:38:00","inspection_id":"87013036","dot_number":"937927","report_state":"MN","report_number":"1675000782","insp_date":"2026-02-04 00:00:00","insp_start_time":"1048","insp_end_time":"1140","registration_date":null,"region":"CS","ci_status_code":"C","location":"CLKGVN","location_desc":"CLARKS GROVE MN","county_code_state":"MN","county_code":"047","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"ELECTRIC PUMP","shipping_paper_number":"511140","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-02-11 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"22000","viol_total":"5","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2871231","transaction_code":"A","transaction_date":"2026-02-10 00:00:00","upload_date":"2026-02-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00937927","upload_search_indicator":null,"census_search_date":"2026-02-11 21:38:00","snet_input_date":"2026-02-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-11 21:38:00","insp_carrier_name":"ELECTRIC PUMP","insp_carrier_street":"4280 NE 14TH","insp_carrier_city":"DES MOINES","insp_carrier_state":"IA","insp_carrier_zip_code":"50313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-14T10:37:30.000000Z","updated_at":"2026-02-22T10:30:16.000000Z","inspection_violations":[{"id":18589879,"change_date":"2026-02-11 21:38:00","inspection_id":"87013036","insp_violation_id":"271722293","seq_no":"5","part_no":"393","part_no_section":"9A-LSML","insp_viol_unit":"2","insp_unit_id":"211554588","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-14T10:52:05.000000Z","updated_at":"2026-02-22T10:38:46.000000Z","normalized_code":"3939ALSML"},{"id":18589878,"change_date":"2026-02-11 21:38:00","inspection_id":"87013036","insp_violation_id":"271722292","seq_no":"4","part_no":"393","part_no_section":"95A3","insp_viol_unit":"1","insp_unit_id":"211554587","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-14T10:52:05.000000Z","updated_at":"2026-02-22T10:38:46.000000Z","normalized_code":"39395A3"},{"id":18589875,"change_date":"2026-02-11 21:38:00","inspection_id":"87013036","insp_violation_id":"271722289","seq_no":"1","part_no":"393","part_no_section":"43DBMA","insp_viol_unit":"2","insp_unit_id":"211554588","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-02-14T10:52:05.000000Z","updated_at":"2026-02-22T10:38:46.000000Z","normalized_code":"39343DBMA"},{"id":18589876,"change_date":"2026-02-11 21:38:00","inspection_id":"87013036","insp_violation_id":"271722290","seq_no":"2","part_no":"393","part_no_section":"43D-B","insp_viol_unit":"2","insp_unit_id":"211554588","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-02-14T10:52:05.000000Z","updated_at":"2026-02-22T10:38:46.000000Z","normalized_code":"39343DB"},{"id":18589877,"change_date":"2026-02-11 21:38:00","inspection_id":"87013036","insp_violation_id":"271722291","seq_no":"3","part_no":"393","part_no_section":"9A-LSML","insp_viol_unit":"2","insp_unit_id":"211554588","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-14T10:52:05.000000Z","updated_at":"2026-02-22T10:38:46.000000Z","normalized_code":"3939ALSML"}],"inspection_per_units":[{"id":18931644,"change_date":"2026-02-11 21:38:00","inspection_id":"87013036","insp_unit_id":"211554587","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":"52","insp_unit_license":"NVU869","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GC2YLE74PF230219","insp_unit_decal":"Y","insp_unit_decal_number":"36073858","created_at":"2026-02-14T10:15:28.000000Z","updated_at":"2026-02-22T10:02:29.000000Z"},{"id":18931645,"change_date":"2026-02-11 21:38:00","inspection_id":"87013036","insp_unit_id":"211554588","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FABRIQUE P","insp_unit_company":"NA","insp_unit_license":"LG3404","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5JWFF222XSN601760","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-14T10:15:28.000000Z","updated_at":"2026-02-22T10:02:29.000000Z"}]},{"id":10635710,"change_date":"2026-01-13 21:39:00","inspection_id":"86776845","dot_number":"937927","report_state":"IA","report_number":"000P13NDK3","insp_date":"2026-01-12 00:00:00","insp_start_time":"0957","insp_end_time":"1001","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 30 AND HWY 71","county_code_state":"IA","county_code":"027","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"ELECTRIC PUMP","shipping_paper_number":"EQUIPMENT","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-01-13 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"1387222","transaction_code":"A","transaction_date":"2026-01-13 00:00:00","upload_date":"2026-01-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00937927","upload_search_indicator":"M","census_search_date":"2026-01-13 21:39:00","snet_input_date":"2026-01-12 00:00:00","source_office":"3IAS001","mcmis_add_date":"2026-01-13 21:39:00","insp_carrier_name":"ELECTRIC PUMP","insp_carrier_street":"4280 NE 14TH","insp_carrier_city":"DES MOINES","insp_carrier_state":"IA","insp_carrier_zip_code":"50313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-16T10:36:01.000000Z","updated_at":"2026-01-24T10:30:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17838494,"change_date":"2026-01-13 21:39:00","inspection_id":"86776845","insp_unit_id":"211051629","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"1","insp_unit_license":"YWT198","insp_unit_license_state":"NE","insp_unit_vehicle_id_number":"1FDNF7DCXNDF01538","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-16T10:08:38.000000Z","updated_at":"2026-01-24T10:02:10.000000Z"}]},{"id":10290675,"change_date":"2025-11-26 21:37:00","inspection_id":"86415882","dot_number":"937927","report_state":"ND","report_number":"TR80002066","insp_date":"2025-11-24 00:00:00","insp_start_time":"1230","insp_end_time":"1304","registration_date":null,"region":"CS","ci_status_code":"C","location":"MOORTN","location_desc":"MOORETON ND","county_code_state":"ND","county_code":"077","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SAME AS CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-11-26 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"20000","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":"2587304","transaction_code":"A","transaction_date":"2025-11-25 00:00:00","upload_date":"2025-11-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00937927","upload_search_indicator":null,"census_search_date":"2025-11-26 21:37:00","snet_input_date":"2025-11-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-11-26 21:37:00","insp_carrier_name":"ELECTRIC PUMP","insp_carrier_street":"4280 NE 14TH","insp_carrier_city":"DES MOINES","insp_carrier_state":"IA","insp_carrier_zip_code":"50313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-29T10:31:20.000000Z","updated_at":"2025-11-30T10:30:07.000000Z","inspection_violations":[{"id":17210764,"change_date":"2025-11-26 21:37:00","inspection_id":"86415882","insp_violation_id":"270300698","seq_no":"1","part_no":"395","part_no_section":"8A","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"0007480479","created_at":"2025-11-29T10:32:19.000000Z","updated_at":"2025-11-30T10:30:11.000000Z","normalized_code":"3958A"}],"inspection_per_units":[{"id":17182707,"change_date":"2025-11-26 21:37:00","inspection_id":"86415882","insp_unit_id":"210268819","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":"36","insp_unit_license":"85517C","insp_unit_license_state":"SD","insp_unit_vehicle_id_number":"1HTKJPVM3LH590732","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-29T10:01:30.000000Z","updated_at":"2025-11-30T10:00:08.000000Z"}]},{"id":9926806,"change_date":"2025-10-13 21:37:00","inspection_id":"86032581","dot_number":"937927","report_state":"IA","report_number":"000P15H739","insp_date":"2025-10-10 00:00:00","insp_start_time":"1522","insp_end_time":"1550","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"I80 WB @ 303MM","county_code_state":"IA","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"EMPTY","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-13 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"1377335","transaction_code":"A","transaction_date":"2025-10-13 00:00:00","upload_date":"2025-10-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00937927","upload_search_indicator":"M","census_search_date":"2025-10-13 21:37:00","snet_input_date":"2025-10-10 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-10-13 21:37:00","insp_carrier_name":"ELECTRIC PUMP","insp_carrier_street":"4280 NE 14TH","insp_carrier_city":"DES MOINES","insp_carrier_state":"IA","insp_carrier_zip_code":"50313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-16T10:00:40.000000Z","updated_at":"2025-10-17T10:00:52.000000Z","inspection_violations":[{"id":16381162,"change_date":"2025-10-13 21:37:00","inspection_id":"86032581","insp_violation_id":"269264439","seq_no":"1","part_no":"392","part_no_section":"2-SLLS3","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-10-16T10:15:59.000000Z","updated_at":"2025-10-17T10:16:13.000000Z","normalized_code":"3922SLLS3"},{"id":16381163,"change_date":"2025-10-13 21:37:00","inspection_id":"86032581","insp_violation_id":"269264440","seq_no":"2","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":"99","citation_number":"6SMI25101015344","created_at":"2025-10-16T10:15:59.000000Z","updated_at":"2025-10-17T10:16:13.000000Z","normalized_code":"39111B4DEN"}],"inspection_per_units":[{"id":16475672,"change_date":"2025-10-13 21:37:00","inspection_id":"86032581","insp_unit_id":"209439503","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"26","insp_unit_license":"LTX088","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FDNF7DE9KDF00328","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-16T09:45:56.000000Z","updated_at":"2025-10-17T09:45:58.000000Z"}]},{"id":9771035,"change_date":"2025-09-24 21:42:00","inspection_id":"85868959","dot_number":"937927","report_state":"NE","report_number":"T409000550","insp_date":"2025-09-24 00:00:00","insp_start_time":"0840","insp_end_time":"0900","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ON US HWY 275, 2142 FEET WEST","county_code_state":"NE","county_code":"039","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"EP (WT)","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-09-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"825855","transaction_code":"A","transaction_date":"2025-09-24 00:00:00","upload_date":"2025-09-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00937927","upload_search_indicator":"M","census_search_date":"2025-09-24 21:42:00","snet_input_date":"2025-09-24 00:00:00","source_office":"3NES001","mcmis_add_date":"2025-09-24 21:42:00","insp_carrier_name":"ELECTRIC PUMP","insp_carrier_street":"4280 NE 14TH","insp_carrier_city":"DES MOINES","insp_carrier_state":"IA","insp_carrier_zip_code":"50313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-26T10:01:17.000000Z","updated_at":"2025-09-28T10:00:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16187509,"change_date":"2025-09-24 21:42:00","inspection_id":"85868959","insp_unit_id":"209128275","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"OLP768","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FD0X5HT3REC63280","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-27T09:46:24.000000Z","updated_at":"2025-09-29T09:46:13.000000Z"}]},{"id":9473262,"change_date":"2025-08-21 21:41:00","inspection_id":"85556608","dot_number":"937927","report_state":"NE","report_number":"T498000447","insp_date":"2025-08-21 00:00:00","insp_start_time":"1205","insp_end_time":"1218","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":"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":"N","pen_cen_match":null,"final_status_date":"2025-08-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"823043","transaction_code":"A","transaction_date":"2025-08-21 00:00:00","upload_date":"2025-08-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00937927","upload_search_indicator":"M","census_search_date":"2025-08-21 21:41:00","snet_input_date":"2025-08-21 00:00:00","source_office":"3NES001","mcmis_add_date":"2025-08-21 21:41:00","insp_carrier_name":"ELECTRIC PUMP","insp_carrier_street":"4280 NE 14TH","insp_carrier_city":"DES MOINES","insp_carrier_state":"IA","insp_carrier_zip_code":"50313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-25T10:42:55.000000Z","updated_at":"2025-08-25T10:42:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15625254,"change_date":"2025-08-21 21:41:00","inspection_id":"85556608","insp_unit_id":"208517007","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"YWT198","insp_unit_license_state":"NE","insp_unit_vehicle_id_number":"1FDNF7DCXNDF01538","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-24T09:46:43.000000Z","updated_at":"2025-08-25T09:46:09.000000Z"}]},{"id":8989847,"change_date":"2025-06-26 21:40:00","inspection_id":"85048264","dot_number":"937927","report_state":"IA","report_number":"000P169MZZ","insp_date":"2025-06-25 00:00:00","insp_start_time":"1400","insp_end_time":"1420","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"I80 W TO US 69 SB","county_code_state":"IA","county_code":"153","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","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":"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":"14000","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":"1365127","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":"00937927","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":"ELECTRIC PUMP","insp_carrier_street":"4280 NE 14TH","insp_carrier_city":"DES MOINES","insp_carrier_state":"IA","insp_carrier_zip_code":"50313","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":14455448,"change_date":"2025-06-26 21:40:00","inspection_id":"85048264","insp_violation_id":"267057752","seq_no":"1","part_no":"392","part_no_section":"2C","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-06-29T10:16:37.000000Z","updated_at":"2025-06-30T10:17:27.000000Z","normalized_code":"3922C"},{"id":14455449,"change_date":"2025-06-26 21:40:00","inspection_id":"85048264","insp_violation_id":"267057753","seq_no":"2","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"207564834","insp_violation_category_id":"29","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":"39617C"},{"id":14455450,"change_date":"2025-06-26 21:40:00","inspection_id":"85048264","insp_violation_id":"267057754","seq_no":"3","part_no":"392","part_no_section":"2IN","insp_viol_unit":"1","insp_unit_id":"207564834","insp_violation_category_id":"51","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":"3922IN"}],"inspection_per_units":[{"id":14742926,"change_date":"2025-06-26 21:40:00","inspection_id":"85048264","insp_unit_id":"207564834","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"18","insp_unit_license":"ECE003","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3C7WRTAL6GG204062","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":8735886,"change_date":"2025-05-26 21:33:00","inspection_id":"84778942","dot_number":"937927","report_state":"MN","report_number":"0025000433","insp_date":"2025-05-19 00:00:00","insp_start_time":"0836","insp_end_time":"0854","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"BROOKLYN PARK MN","county_code_state":"MN","county_code":"053","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-05-26 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"1781515","transaction_code":"A","transaction_date":"2025-05-26 00:00:00","upload_date":"2025-05-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00937927","upload_search_indicator":null,"census_search_date":"2025-05-26 21:33:00","snet_input_date":"2025-05-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-26 21:33:00","insp_carrier_name":"ELECTRIC PUMP","insp_carrier_street":"4280 NE 14TH","insp_carrier_city":"DES MOINES","insp_carrier_state":"IA","insp_carrier_zip_code":"50313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-29T10:00:25.000000Z","updated_at":"2025-05-30T10:00:10.000000Z","inspection_violations":[{"id":13940201,"change_date":"2025-05-26 21:33:00","inspection_id":"84778942","insp_violation_id":"266470937","seq_no":"1","part_no":"392","part_no_section":"2-SLLS3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-29T10:15:31.000000Z","updated_at":"2025-05-30T10:15:16.000000Z","normalized_code":"3922SLLS3"}],"inspection_per_units":[{"id":14282223,"change_date":"2025-05-26 21:33:00","inspection_id":"84778942","insp_unit_id":"207062995","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"AEO9476","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1FD0X5HT1REE67298","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-29T09:45:32.000000Z","updated_at":"2025-05-30T09:45:14.000000Z"}]},{"id":8630948,"change_date":"2025-05-14 21:41:00","inspection_id":"84668207","dot_number":"937927","report_state":"IA","report_number":"000P13X5T3","insp_date":"2025-05-13 00:00:00","insp_start_time":"1152","insp_end_time":"1215","registration_date":null,"region":"CT","ci_status_code":"C","location":"44","location_desc":"44 - JCT HWY 71\/20 EARLY","county_code_state":"IA","county_code":"161","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"ELECTRIC PUMP","shipping_paper_number":null,"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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1360162","transaction_code":"A","transaction_date":"2025-05-14 00:00:00","upload_date":"2025-05-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00937927","upload_search_indicator":"M","census_search_date":"2025-05-14 21:41:00","snet_input_date":"2025-05-13 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-05-14 21:41:00","insp_carrier_name":"ELECTRIC PUMP","insp_carrier_street":"4280 NE 14TH","insp_carrier_city":"DES MOINES","insp_carrier_state":"IA","insp_carrier_zip_code":"50313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-17T10:05:09.000000Z","updated_at":"2025-05-18T10:05:46.000000Z","inspection_violations":[{"id":13723864,"change_date":"2025-05-14 21:41:00","inspection_id":"84668207","insp_violation_id":"266218576","seq_no":"1","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"206855514","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-18T10:26:47.000000Z","updated_at":"2025-05-18T10:32:58.000000Z","normalized_code":"39395A"},{"id":13723865,"change_date":"2025-05-14 21:41:00","inspection_id":"84668207","insp_violation_id":"266218577","seq_no":"2","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"206855514","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-18T10:26:47.000000Z","updated_at":"2025-05-18T10:32:58.000000Z","normalized_code":"39395F"},{"id":13723866,"change_date":"2025-05-14 21:41:00","inspection_id":"84668207","insp_violation_id":"266218578","seq_no":"3","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"206855514","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-18T10:26:47.000000Z","updated_at":"2025-05-18T10:32:58.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":14093088,"change_date":"2025-05-14 21:41:00","inspection_id":"84668207","insp_unit_id":"206855514","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"NEY672","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FD0X5HT4NEF33207","insp_unit_decal":"Y","insp_unit_decal_number":"35250542","created_at":"2025-05-17T09:49:10.000000Z","updated_at":"2025-05-18T09:51:18.000000Z"}]},{"id":8382781,"change_date":"2025-04-15 21:41:00","inspection_id":"84406747","dot_number":"937927","report_state":"NE","report_number":"T311000997","insp_date":"2025-04-15 00:00:00","insp_start_time":"0935","insp_end_time":"1006","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ON STATE HWY 92, 30 FEET NORTH","county_code_state":"NE","county_code":"143","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"ELECTRIC PUMP LLC","shipping_paper_number":null,"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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"812605","transaction_code":"A","transaction_date":"2025-04-15 00:00:00","upload_date":"2025-04-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00937927","upload_search_indicator":"M","census_search_date":"2025-04-15 21:41:00","snet_input_date":"2025-04-15 00:00:00","source_office":"3NES001","mcmis_add_date":"2025-04-15 21:41:00","insp_carrier_name":"ELECTRIC PUMP","insp_carrier_street":"4280 NE 14TH","insp_carrier_city":"DES MOINES","insp_carrier_state":"IA","insp_carrier_zip_code":"50313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-18T10:26:37.000000Z","updated_at":"2025-04-19T10:17:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13606378,"change_date":"2025-04-15 21:41:00","inspection_id":"84406747","insp_unit_id":"206325882","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"OLP768","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FD0X5HT3REC63280","insp_unit_decal":"Y","insp_unit_decal_number":"35243255","created_at":"2025-04-18T10:14:50.000000Z","updated_at":"2025-04-19T10:01:04.000000Z"}]},{"id":7759056,"change_date":"2025-01-31 21:40:00","inspection_id":"83750807","dot_number":"937927","report_state":"IA","report_number":"000P15V9TD","insp_date":"2025-01-30 00:00:00","insp_start_time":"1325","insp_end_time":"1330","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 218 SB WATERLOO","county_code_state":"IA","county_code":"013","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-01-31 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"1347876","transaction_code":"A","transaction_date":"2025-01-31 00:00:00","upload_date":"2025-01-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00937927","upload_search_indicator":"M","census_search_date":"2025-01-31 21:40:00","snet_input_date":"2025-01-30 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-01-31 21:40:00","insp_carrier_name":"ELECTRIC PUMP","insp_carrier_street":"4280 NE 14TH","insp_carrier_city":"DES MOINES","insp_carrier_state":"IA","insp_carrier_zip_code":"50313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:59:11.000000Z","updated_at":"2025-03-17T20:59:11.000000Z","inspection_violations":[{"id":12123093,"change_date":"2025-01-31 21:40:00","inspection_id":"83750807","insp_violation_id":"264280095","seq_no":"1","part_no":"392","part_no_section":"16B","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:05:10.000000Z","updated_at":"2025-03-17T22:05:10.000000Z","normalized_code":"39216B"},{"id":12123094,"change_date":"2025-01-31 21:40:00","inspection_id":"83750807","insp_violation_id":"264280096","seq_no":"2","part_no":"392","part_no_section":"2IN","insp_viol_unit":"1","insp_unit_id":"205104159","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:10.000000Z","updated_at":"2025-03-17T22:05:10.000000Z","normalized_code":"3922IN"}],"inspection_per_units":[{"id":12521294,"change_date":"2025-01-31 21:40:00","inspection_id":"83750807","insp_unit_id":"205104159","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"36","insp_unit_license":"LBH974","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1HTKJPVM3LH590732","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:53:14.000000Z","updated_at":"2025-03-17T23:53:14.000000Z"}]},{"id":7759132,"change_date":"2025-01-31 21:40:00","inspection_id":"83750890","dot_number":"937927","report_state":"IA","report_number":"000P13X5K0","insp_date":"2025-01-30 00:00:00","insp_start_time":"1049","insp_end_time":"1115","registration_date":null,"region":"CT","ci_status_code":"C","location":"44","location_desc":"44 - JCT HWY 71\/20 EARLY","county_code_state":"IA","county_code":"161","insp_level_id":"1","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-01-31 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"22500","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":"1347866","transaction_code":"A","transaction_date":"2025-01-31 00:00:00","upload_date":"2025-01-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00937927","upload_search_indicator":"M","census_search_date":"2025-01-31 21:40:00","snet_input_date":"2025-01-30 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-01-31 21:40:00","insp_carrier_name":"ELECTRIC PUMP","insp_carrier_street":"4280 NE 14TH","insp_carrier_city":"DES MOINES","insp_carrier_state":"IA","insp_carrier_zip_code":"50313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:59:11.000000Z","updated_at":"2025-03-17T20:59:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12521428,"change_date":"2025-01-31 21:40:00","inspection_id":"83750890","insp_unit_id":"205104314","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"OTA163","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1HTKJPVM2PH465033","insp_unit_decal":"Y","insp_unit_decal_number":"34983851","created_at":"2025-03-17T23:53:14.000000Z","updated_at":"2025-03-17T23:53:14.000000Z"}]},{"id":7526554,"change_date":"2024-12-31 21:37:00","inspection_id":"83506596","dot_number":"937927","report_state":"IA","report_number":"000P14RPZ3","insp_date":"2024-12-17 00:00:00","insp_start_time":"0820","insp_end_time":"0835","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 61 GRANDVIEW","county_code_state":"IA","county_code":"115","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"ELECTRIC PUMP","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-12-31 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"1343840","transaction_code":"A","transaction_date":"2024-12-31 00:00:00","upload_date":"2024-12-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00937927","upload_search_indicator":"M","census_search_date":"2024-12-31 21:37:00","snet_input_date":"2024-12-17 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-12-31 21:37:00","insp_carrier_name":"ELECTRIC PUMP","insp_carrier_street":"4280 NE 14TH","insp_carrier_city":"DES MOINES","insp_carrier_state":"IA","insp_carrier_zip_code":"50313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:53:10.000000Z","updated_at":"2025-03-17T20:53:10.000000Z","inspection_violations":[{"id":11763741,"change_date":"2024-12-31 21:37:00","inspection_id":"83506596","insp_violation_id":"263710199","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:03:21.000000Z","updated_at":"2025-03-17T22:03:21.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":12142580,"change_date":"2024-12-31 21:37:00","inspection_id":"83506596","insp_unit_id":"204607144","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"YCD4782","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"3ALACWDT2GDGP3500","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:03.000000Z","updated_at":"2025-03-17T23:49:03.000000Z"}]},{"id":6689871,"change_date":"2024-09-10 21:40:00","inspection_id":"82620867","dot_number":"937927","report_state":"IA","report_number":"000P12X2Q9","insp_date":"2024-09-09 00:00:00","insp_start_time":"0740","insp_end_time":"0800","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"115 EB I-80 VAN METER, IA","county_code_state":"IA","county_code":"049","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","shipping_paper_number":"01","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-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"1328764","transaction_code":"A","transaction_date":"2024-09-10 00:00:00","upload_date":"2024-09-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00937927","upload_search_indicator":"M","census_search_date":"2024-09-10 21:40:00","snet_input_date":"2024-09-09 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-09-10 21:40:00","insp_carrier_name":"ELECTRIC PUMP","insp_carrier_street":"4280 NE 14TH","insp_carrier_city":"DES MOINES","insp_carrier_state":"IA","insp_carrier_zip_code":"50313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:35:40.000000Z","updated_at":"2025-03-17T20:35:40.000000Z","inspection_violations":[{"id":10412656,"change_date":"2024-09-10 21:40:00","inspection_id":"82620867","insp_violation_id":"261712215","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"202846690","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:25.000000Z","updated_at":"2025-03-17T21:56:25.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":10786702,"change_date":"2024-09-10 21:40:00","inspection_id":"82620867","insp_unit_id":"202846690","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"26","insp_unit_license":"YWT198","insp_unit_license_state":"NE","insp_unit_vehicle_id_number":"1FDNF7DCXNDF01538","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:41.000000Z","updated_at":"2025-03-17T23:34:41.000000Z"}]},{"id":6585827,"change_date":"2024-08-28 21:42:00","inspection_id":"82509942","dot_number":"937927","report_state":"IA","report_number":"000P16FP5P","insp_date":"2024-08-27 00:00:00","insp_start_time":"1500","insp_end_time":"1615","registration_date":null,"region":"CT","ci_status_code":"C","location":"01","location_desc":"01 - I80 WB MM 151 MITCHELLVIL","county_code_state":"IA","county_code":"099","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"ELECTRIC PUMP INC","shipping_paper_number":"GASOLN ACETYLN","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"23000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"2","hazmat_oos_total":"1","snet_sequence_id":"1327031","transaction_code":"A","transaction_date":"2024-08-28 00:00:00","upload_date":"2024-08-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00937927","upload_search_indicator":"M","census_search_date":"2024-08-28 21:42:00","snet_input_date":"2024-08-27 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-08-28 21:42:00","insp_carrier_name":"ELECTRIC PUMP","insp_carrier_street":"4280 NE 14TH","insp_carrier_city":"DES MOINES","insp_carrier_state":"IA","insp_carrier_zip_code":"50313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:33:38.000000Z","updated_at":"2025-03-17T20:33:38.000000Z","inspection_violations":[{"id":10239111,"change_date":"2024-08-28 21:42:00","inspection_id":"82509942","insp_violation_id":"261464958","seq_no":"1","part_no":"177","part_no_section":"834(a)","insp_viol_unit":"1","insp_unit_id":"202631003","insp_violation_category_id":"34","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:55:32.000000Z","updated_at":"2025-03-17T21:55:32.000000Z","normalized_code":"177834A"},{"id":10239112,"change_date":"2024-08-28 21:42:00","inspection_id":"82509942","insp_violation_id":"261464959","seq_no":"2","part_no":"172","part_no_section":"301(a)(1)","insp_viol_unit":"1","insp_unit_id":"202631003","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:32.000000Z","updated_at":"2025-03-17T21:55:32.000000Z","normalized_code":"172301A1"}],"inspection_per_units":[{"id":10617507,"change_date":"2024-08-28 21:42:00","inspection_id":"82509942","insp_unit_id":"202631003","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"36","insp_unit_license":"LBH974","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1HTKJPVM3LH590732","insp_unit_decal":"Y","insp_unit_decal_number":"34352782","created_at":"2025-03-17T23:32:58.000000Z","updated_at":"2025-03-17T23:32:58.000000Z"}]},{"id":6237041,"change_date":"2024-07-17 21:40:00","inspection_id":"82137396","dot_number":"937927","report_state":"MN","report_number":"0128000182","insp_date":"2024-07-11 00:00:00","insp_start_time":"1023","insp_end_time":"1102","registration_date":null,"region":"CD","ci_status_code":"C","location":"CRLTNN","location_desc":"CLOQUET MN","county_code_state":"MN","county_code":"017","insp_level_id":"1","service_center":"MW","census_source_id":"5","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":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-07-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"661269","transaction_code":"A","transaction_date":"2024-07-17 00:00:00","upload_date":"2024-07-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00937927","upload_search_indicator":null,"census_search_date":"2024-07-17 21:40:00","snet_input_date":"2024-07-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-07-17 21:40:00","insp_carrier_name":"ELECTRIC PUMP","insp_carrier_street":"4280 NE 14TH","insp_carrier_city":"DES MOINES","insp_carrier_state":"IA","insp_carrier_zip_code":"50313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:26:15.000000Z","updated_at":"2025-03-17T20:26:15.000000Z","inspection_violations":[{"id":9688477,"change_date":"2024-07-17 21:40:00","inspection_id":"82137396","insp_violation_id":"260683161","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:52:54.000000Z","updated_at":"2025-03-17T21:52:54.000000Z","normalized_code":"3922"},{"id":9688478,"change_date":"2024-07-17 21:40:00","inspection_id":"82137396","insp_violation_id":"260683162","seq_no":"2","part_no":"395","part_no_section":"8(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:54.000000Z","updated_at":"2025-03-17T21:52:54.000000Z","normalized_code":"3958A"}],"inspection_per_units":[{"id":10049162,"change_date":"2024-07-17 21:40:00","inspection_id":"82137396","insp_unit_id":"201922282","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"44","insp_unit_license":"YCE0256","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1FD0X5HT0NEF33205","insp_unit_decal":"Y","insp_unit_decal_number":"34364001","created_at":"2025-03-17T23:27:06.000000Z","updated_at":"2025-03-17T23:27:06.000000Z"}]},{"id":6125629,"change_date":"2024-07-02 21:41:00","inspection_id":"82017610","dot_number":"937927","report_state":"IL","report_number":"0124000240","insp_date":"2024-06-26 00:00:00","insp_start_time":"1528","insp_end_time":"1611","registration_date":null,"region":"CD","ci_status_code":"C","location":"IDOT12","location_desc":"MOLINE IL","county_code_state":"IL","county_code":"161","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-07-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"619471","transaction_code":"A","transaction_date":"2024-07-02 00:00:00","upload_date":"2024-07-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00937927","upload_search_indicator":null,"census_search_date":"2024-07-02 21:41:00","snet_input_date":"2024-06-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-07-02 21:41:00","insp_carrier_name":"ELECTRIC PUMP","insp_carrier_street":"4280 NE 14TH","insp_carrier_city":"DES MOINES","insp_carrier_state":"IA","insp_carrier_zip_code":"50313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:24:11.000000Z","updated_at":"2025-03-17T20:24:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9866847,"change_date":"2024-07-02 21:41:00","inspection_id":"82017610","insp_unit_id":"201692138","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"17","insp_unit_license":"YCD4782","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"3ALACWDT2GDGP3500","insp_unit_decal":"Y","insp_unit_decal_number":"33999149","created_at":"2025-03-17T23:25:14.000000Z","updated_at":"2025-03-17T23:25:14.000000Z"}]},{"id":5854713,"change_date":"2024-05-28 21:43:00","inspection_id":"81724547","dot_number":"937927","report_state":"IA","report_number":"000P120CQS","insp_date":"2024-05-23 00:00:00","insp_start_time":"0845","insp_end_time":"0905","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 18 EB","county_code_state":"IA","county_code":"033","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"ELECTRIC PUMP","shipping_paper_number":"SELF","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-05-28 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1314345","transaction_code":"A","transaction_date":"2024-05-28 00:00:00","upload_date":"2024-05-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00937927","upload_search_indicator":"M","census_search_date":"2024-05-28 21:43:00","snet_input_date":"2024-05-23 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-05-28 21:43:00","insp_carrier_name":"ELECTRIC PUMP","insp_carrier_street":"4280 NE 14TH","insp_carrier_city":"DES MOINES","insp_carrier_state":"IA","insp_carrier_zip_code":"50313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:18:42.000000Z","updated_at":"2025-03-17T20:18:42.000000Z","inspection_violations":[{"id":9073276,"change_date":"2024-05-28 21:43:00","inspection_id":"81724547","insp_violation_id":"259755305","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:49:50.000000Z","updated_at":"2025-03-17T21:49:50.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9429427,"change_date":"2024-05-28 21:43:00","inspection_id":"81724547","insp_unit_id":"201109229","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"3207","insp_unit_license":"NEY672","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FD0X5HT4NEF33207","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:50.000000Z","updated_at":"2025-03-17T23:20:50.000000Z"}]},{"id":5789008,"change_date":"2024-05-20 21:41:00","inspection_id":"81653195","dot_number":"937927","report_state":"SD","report_number":"5290001682","insp_date":"2024-05-20 00:00:00","insp_start_time":"1357","insp_end_time":"1412","registration_date":null,"region":"CD","ci_status_code":"C","location":"SUFLSW","location_desc":"VALLEY SPRINGS SD","county_code_state":"SD","county_code":"099","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SELF","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":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-05-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"497243","transaction_code":"A","transaction_date":"2024-05-20 00:00:00","upload_date":"2024-05-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00937927","upload_search_indicator":null,"census_search_date":"2024-05-20 21:41:00","snet_input_date":"2024-05-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-05-20 21:41:00","insp_carrier_name":"ELECTRIC PUMP","insp_carrier_street":"4280 NE 14TH","insp_carrier_city":"DES MOINES","insp_carrier_state":"IA","insp_carrier_zip_code":"50313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:17:30.000000Z","updated_at":"2025-03-17T20:17:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9324108,"change_date":"2024-05-20 21:41:00","inspection_id":"81653195","insp_unit_id":"200974199","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":null,"insp_unit_license":"35900C","insp_unit_license_state":"SD","insp_unit_vehicle_id_number":"3C7WRNBL2LG253294","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:48.000000Z","updated_at":"2025-03-17T23:19:48.000000Z"}]},{"id":5518461,"change_date":"2024-04-16 21:41:00","inspection_id":"81359082","dot_number":"937927","report_state":"MN","report_number":"1783000044","insp_date":"2024-04-10 00:00:00","insp_start_time":"1432","insp_end_time":"1448","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"MOORHEAD MN","county_code_state":"MN","county_code":"027","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-04-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"401440","transaction_code":"A","transaction_date":"2024-04-16 00:00:00","upload_date":"2024-04-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00937927","upload_search_indicator":null,"census_search_date":"2024-04-16 21:41:00","snet_input_date":"2024-04-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-04-16 21:41:00","insp_carrier_name":"ELECTRIC PUMP","insp_carrier_street":"4280 NE 14TH","insp_carrier_city":"DES MOINES","insp_carrier_state":"IA","insp_carrier_zip_code":"50313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:11:59.000000Z","updated_at":"2025-03-17T20:11:59.000000Z","inspection_violations":[{"id":8526050,"change_date":"2024-04-16 21:41:00","inspection_id":"81359082","insp_violation_id":"258947019","seq_no":"1","part_no":"391","part_no_section":"41(a)","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-17T21:47:20.000000Z","updated_at":"2025-03-17T21:47:20.000000Z","normalized_code":"39141A"},{"id":8526051,"change_date":"2024-04-16 21:41:00","inspection_id":"81359082","insp_violation_id":"258947020","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:20.000000Z","updated_at":"2025-03-17T21:47:20.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8889102,"change_date":"2024-04-16 21:41:00","inspection_id":"81359082","insp_unit_id":"200410891","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":"23","insp_unit_license":"076BHZ","insp_unit_license_state":"ND","insp_unit_vehicle_id_number":"3C7WRNBL7FG601885","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:42.000000Z","updated_at":"2025-03-17T23:15:42.000000Z"}]},{"id":4579962,"change_date":"2023-12-07 21:40:00","inspection_id":"80333893","dot_number":"937927","report_state":"NE","report_number":"T445000027","insp_date":"2023-12-07 00:00:00","insp_start_time":"1333","insp_end_time":"1344","registration_date":null,"region":"CT","ci_status_code":"C","location":"13","location_desc":"WAVERLY RT 6 SCALE","county_code_state":"NE","county_code":"109","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"ELECTRIC PUMP","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-12-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"777529","transaction_code":"A","transaction_date":"2023-12-07 00:00:00","upload_date":"2023-12-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00937927","upload_search_indicator":null,"census_search_date":"2023-12-07 21:40:00","snet_input_date":"2023-12-07 00:00:00","source_office":"3NES001","mcmis_add_date":"2023-12-07 21:40:00","insp_carrier_name":"ELECTRIC PUMP","insp_carrier_street":"4280 NE 14TH","insp_carrier_city":"DES MOINES","insp_carrier_state":"IA","insp_carrier_zip_code":"50313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:53:27.000000Z","updated_at":"2025-03-17T19:53:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7366556,"change_date":"2023-12-07 21:40:00","inspection_id":"80333893","insp_unit_id":"198399944","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"12","insp_unit_license":"WDK607","insp_unit_license_state":"NE","insp_unit_vehicle_id_number":"3C7WRMBL1JG304517","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:55.000000Z","updated_at":"2025-03-17T23:01:55.000000Z"}]},{"id":4070501,"change_date":"2023-09-27 21:41:00","inspection_id":"79771255","dot_number":"937927","report_state":"IA","report_number":"000TT4X4J4","insp_date":"2023-09-26 00:00:00","insp_start_time":"1700","insp_end_time":"1725","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"US 65 S AND LINCOLN ST SE","county_code_state":"IA","county_code":"153","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"ELECTRIC PUMP INC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"15500","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":"1290180","transaction_code":"A","transaction_date":"2023-09-27 00:00:00","upload_date":"2023-09-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00937927","upload_search_indicator":"M","census_search_date":"2023-09-27 21:41:00","snet_input_date":"2023-09-26 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-09-27 21:41:00","insp_carrier_name":"ELECTRIC PUMP","insp_carrier_street":"4280 NE 14TH","insp_carrier_city":"DES MOINES","insp_carrier_state":"IA","insp_carrier_zip_code":"50313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:43:12.000000Z","updated_at":"2025-03-17T19:43:12.000000Z","inspection_violations":[{"id":6301587,"change_date":"2023-09-27 21:41:00","inspection_id":"79771255","insp_violation_id":"255520428","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:36:25.000000Z","updated_at":"2025-03-17T21:36:25.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6544638,"change_date":"2023-09-27 21:41:00","inspection_id":"79771255","insp_unit_id":"197271126","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"36","insp_unit_license":"LBH974","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1HTKJPVM3LH590732","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:55.000000Z","updated_at":"2025-03-17T22:54:55.000000Z"}]},{"id":3456731,"change_date":"2023-07-07 21:41:00","inspection_id":"79085682","dot_number":"937927","report_state":"IA","report_number":"000TT6HS16","insp_date":"2023-07-05 00:00:00","insp_start_time":"1320","insp_end_time":"1340","registration_date":null,"region":"CT","ci_status_code":"C","location":"02","location_desc":"02 - I80 EB MM 115 VAN METER","county_code_state":"IA","county_code":"099","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SELF","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"23000","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":"1280168","transaction_code":"A","transaction_date":"2023-07-07 00:00:00","upload_date":"2023-07-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00937927","upload_search_indicator":"M","census_search_date":"2023-07-07 21:41:00","snet_input_date":"2023-07-05 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-07-07 21:41:00","insp_carrier_name":"ELECTRIC PUMP","insp_carrier_street":"4280 NE 14TH","insp_carrier_city":"DES MOINES","insp_carrier_state":"IA","insp_carrier_zip_code":"50313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:31:22.000000Z","updated_at":"2025-03-17T19:31:22.000000Z","inspection_violations":[{"id":5329238,"change_date":"2023-07-07 21:41:00","inspection_id":"79085682","insp_violation_id":"253929523","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"195882220","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:44.000000Z","updated_at":"2025-03-17T21:31:44.000000Z","normalized_code":"39617C"},{"id":5329239,"change_date":"2023-07-07 21:41:00","inspection_id":"79085682","insp_violation_id":"253929524","seq_no":"2","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"195882220","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:44.000000Z","updated_at":"2025-03-17T21:31:44.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":5558260,"change_date":"2023-07-07 21:41:00","inspection_id":"79085682","insp_unit_id":"195882220","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"36","insp_unit_license":"LBH974","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1HTKJPVM3LH590732","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:53.000000Z","updated_at":"2025-03-17T22:46:53.000000Z"}]},{"id":3142343,"change_date":"2023-05-25 21:42:00","inspection_id":"78731089","dot_number":"937927","report_state":"MN","report_number":"00ZI006120","insp_date":"2023-05-25 00:00:00","insp_start_time":"0823","insp_end_time":"0857","registration_date":null,"region":"CT","ci_status_code":"C","location":"RDRVR","location_desc":"RED RIVER WEIGH STATION","county_code_state":"MN","county_code":"027","insp_level_id":"1","service_center":"MW","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-05-25 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"3","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1389136","transaction_code":"A","transaction_date":"2023-05-25 00:00:00","upload_date":"2023-05-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00937927","upload_search_indicator":null,"census_search_date":"2023-05-25 21:42:00","snet_input_date":"2023-05-25 00:00:00","source_office":"3MNS001","mcmis_add_date":"2023-05-25 21:42:00","insp_carrier_name":"ELECTRIC PUMP","insp_carrier_street":"4280 NE 14TH","insp_carrier_city":"DES MOINES","insp_carrier_state":"IA","insp_carrier_zip_code":"50313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:25:19.000000Z","updated_at":"2025-03-17T19:25:19.000000Z","inspection_violations":[{"id":4837403,"change_date":"2023-05-25 21:42:00","inspection_id":"78731089","insp_violation_id":"253081696","seq_no":"1","part_no":"395","part_no_section":"8(f)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:29.000000Z","updated_at":"2025-03-17T21:29:29.000000Z","normalized_code":"3958F1"},{"id":4837404,"change_date":"2023-05-25 21:42:00","inspection_id":"78731089","insp_violation_id":"253081697","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:29.000000Z","updated_at":"2025-03-17T21:29:29.000000Z","normalized_code":"3922"},{"id":4837405,"change_date":"2023-05-25 21:42:00","inspection_id":"78731089","insp_violation_id":"253081698","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195145624","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:29.000000Z","updated_at":"2025-03-17T21:29:29.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5054076,"change_date":"2023-05-25 21:42:00","inspection_id":"78731089","insp_unit_id":"195145624","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"23","insp_unit_license":"076BHZ","insp_unit_license_state":"ND","insp_unit_vehicle_id_number":"3C7WRNBL7FG601885","insp_unit_decal":"Y","insp_unit_decal_number":"32721549","created_at":"2025-03-17T22:42:50.000000Z","updated_at":"2025-03-17T22:42:50.000000Z"}]},{"id":3097465,"change_date":"2023-05-19 21:43:00","inspection_id":"78680558","dot_number":"937927","report_state":"SD","report_number":"MCE2000119","insp_date":"2023-05-18 00:00:00","insp_start_time":"1129","insp_end_time":"1152","registration_date":null,"region":"CT","ci_status_code":"C","location":"MC20","location_desc":"SIOUX FALLS PORT OF ENTRY","county_code_state":"SD","county_code":"099","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"SELF","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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-05-19 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"643221","transaction_code":"A","transaction_date":"2023-05-18 00:00:00","upload_date":"2023-05-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00937927","upload_search_indicator":null,"census_search_date":"2023-05-19 21:43:00","snet_input_date":"2023-05-19 00:00:00","source_office":"4SDS001","mcmis_add_date":"2023-05-19 21:43:00","insp_carrier_name":"ELECTRIC PUMP","insp_carrier_street":"4280 NE 14TH","insp_carrier_city":"DES MOINES","insp_carrier_state":"IA","insp_carrier_zip_code":"50313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:24:13.000000Z","updated_at":"2025-03-17T19:24:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4982602,"change_date":"2023-05-19 21:43:00","inspection_id":"78680558","insp_unit_id":"195046416","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"35","insp_unit_license":"95087V","insp_unit_license_state":"SD","insp_unit_vehicle_id_number":"3C7WRNBL2LG253294","insp_unit_decal":"Y","insp_unit_decal_number":"32767124","created_at":"2025-03-17T22:42:17.000000Z","updated_at":"2025-03-17T22:42:17.000000Z"}]},{"id":2687199,"change_date":"2023-03-29 21:42:00","inspection_id":"78216175","dot_number":"937927","report_state":"NE","report_number":"CF00005006","insp_date":"2023-03-28 00:00:00","insp_start_time":"1435","insp_end_time":"1512","registration_date":null,"region":"CT","ci_status_code":"C","location":"STROMS","location_desc":"STROMSBURG","county_code_state":"NE","county_code":"143","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"ELECTRIC PUMP","shipping_paper_number":"NONE","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":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-03-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"756258","transaction_code":"A","transaction_date":"2023-03-28 00:00:00","upload_date":"2023-03-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00937927","upload_search_indicator":null,"census_search_date":"2023-03-29 21:42:00","snet_input_date":"2023-03-28 00:00:00","source_office":"3NES001","mcmis_add_date":"2023-03-29 21:42:00","insp_carrier_name":"ELECTRIC PUMP INC","insp_carrier_street":"4280 NE 14TH","insp_carrier_city":"DES MOINES","insp_carrier_state":"IA","insp_carrier_zip_code":"50313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:16:13.000000Z","updated_at":"2025-03-17T19:16:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4326204,"change_date":"2023-03-29 21:42:00","inspection_id":"78216175","insp_unit_id":"194124108","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"WVM304","insp_unit_license_state":"NE","insp_unit_vehicle_id_number":"1FDNF7DCXNDF01538","insp_unit_decal":"Y","insp_unit_decal_number":"32365689","created_at":"2025-03-17T22:37:05.000000Z","updated_at":"2025-03-17T22:37:05.000000Z"}]},{"id":658713,"change_date":"2022-06-21 21:42:00","inspection_id":"75877966","dot_number":"937927","report_state":"IA","report_number":"000TT6NFM6","insp_date":"2022-06-16 00:00:00","insp_start_time":"1045","insp_end_time":"1400","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 20 EB","county_code_state":"IA","county_code":"187","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"ELECTRIC PUMP","shipping_paper_number":"SELF","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":"N","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":"26000","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":"1229756","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":"00937927","upload_search_indicator":"M","census_search_date":"2022-06-21 21:42:00","snet_input_date":"2022-06-16 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-06-21 21:42:00","insp_carrier_name":"ELECTRIC PUMP INC","insp_carrier_street":"4280 NE 14TH","insp_carrier_city":"DES MOINES","insp_carrier_state":"IA","insp_carrier_zip_code":"50313","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":[],"inspection_per_units":[{"id":1058623,"change_date":"2022-06-21 21:42:00","inspection_id":"75877966","insp_unit_id":"189375307","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"0328","insp_unit_license":"LTX088","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FDNF7DE9KDF00328","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"}]},{"id":432109,"change_date":"2022-05-19 21:42:00","inspection_id":"75608353","dot_number":"937927","report_state":"IA","report_number":"000TT6DVHZ","insp_date":"2022-05-18 00:00:00","insp_start_time":"1404","insp_end_time":"1445","registration_date":null,"region":"CT","ci_status_code":"C","location":"02","location_desc":"02 - I80 EB MM 115 VAN METER","county_code_state":"IA","county_code":"049","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"ELECTRIC PUMP INC","shipping_paper_number":"TOOLS","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-19 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"37000","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":"1225627","transaction_code":"A","transaction_date":"2022-05-19 00:00:00","upload_date":"2022-05-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00937927","upload_search_indicator":"M","census_search_date":"2022-05-19 21:42:00","snet_input_date":"2022-05-18 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-05-19 21:42:00","insp_carrier_name":"ELECTRIC PUMP INC","insp_carrier_street":"4280 NE 14TH","insp_carrier_city":"DES MOINES","insp_carrier_state":"IA","insp_carrier_zip_code":"50313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:35:10.000000Z","updated_at":"2025-03-17T18:35:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":696746,"change_date":"2022-05-19 21:42:00","inspection_id":"75608353","insp_unit_id":"188788681","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"10","insp_unit_license":"GGP076","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"2NKHHJ8XXJM199628","insp_unit_decal":"Y","insp_unit_decal_number":"31386034","created_at":"2025-03-17T22:12:29.000000Z","updated_at":"2025-03-17T22:12:29.000000Z"}]},{"id":330987,"change_date":"2022-05-05 21:42:00","inspection_id":"75487949","dot_number":"937927","report_state":"SD","report_number":"HP43003207","insp_date":"2022-05-04 00:00:00","insp_start_time":"1536","insp_end_time":"1545","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SIOUX FALLS PORT OF ENTRY","county_code_state":"SD","county_code":"099","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-05-05 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"616391","transaction_code":"A","transaction_date":"2022-05-05 00:00:00","upload_date":"2022-05-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00937927","upload_search_indicator":"M","census_search_date":"2022-05-05 21:42:00","snet_input_date":"2022-05-05 00:00:00","source_office":"4SDS001","mcmis_add_date":"2022-05-05 21:42:00","insp_carrier_name":"ELECTRIC PUMP & TOOL INC","insp_carrier_street":"4280 NE 14TH","insp_carrier_city":"DES MOINES","insp_carrier_state":"IA","insp_carrier_zip_code":"50313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:33:20.000000Z","updated_at":"2025-03-17T18:33:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":535503,"change_date":"2022-05-05 21:42:00","inspection_id":"75487949","insp_unit_id":"188534324","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"95097V","insp_unit_license_state":"SD","insp_unit_vehicle_id_number":"3C7WRNBL2LG253294","insp_unit_decal":"Y","insp_unit_decal_number":"31392360","created_at":"2025-03-17T22:11:30.000000Z","updated_at":"2025-03-17T22:11:30.000000Z"}]},{"id":225206,"change_date":"2022-04-21 21:41:00","inspection_id":"75361702","dot_number":"937927","report_state":"MN","report_number":"0ADV000724","insp_date":"2022-04-20 00:00:00","insp_start_time":"0905","insp_end_time":"0920","registration_date":null,"region":"CT","ci_status_code":"C","location":"MPLGV","location_desc":"MAPLE GROVE","county_code_state":"MN","county_code":"053","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-04-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","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":"1324756","transaction_code":"A","transaction_date":"2022-04-20 00:00:00","upload_date":"2022-04-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00937927","upload_search_indicator":null,"census_search_date":"2022-04-21 21:41:00","snet_input_date":"2022-04-21 00:00:00","source_office":"3MNS001","mcmis_add_date":"2022-04-21 21:41:00","insp_carrier_name":"ELECTRIC PUMP & TOOL INC","insp_carrier_street":"4280 NE 14TH","insp_carrier_city":"DES MOINES","insp_carrier_state":"IA","insp_carrier_zip_code":"50313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:31:32.000000Z","updated_at":"2025-03-17T18:31:32.000000Z","inspection_violations":[{"id":345050,"change_date":"2022-04-21 21:41:00","inspection_id":"75361702","insp_violation_id":"245295231","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:43.000000Z","updated_at":"2025-03-17T21:08:43.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":365163,"change_date":"2022-04-21 21:41:00","inspection_id":"75361702","insp_unit_id":"188273266","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"22","insp_unit_license":"YBN6486","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"3C7WRTBL5GG221336","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:28.000000Z","updated_at":"2025-03-17T22:10:28.000000Z"}]}],"first_page_url":"https:\/\/www.searchcarriers.com\/company\/937927\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/www.searchcarriers.com\/company\/937927\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/www.searchcarriers.com\/company\/937927\/inspections?page=1","label":"1","page":1,"active":true},{"url":null,"label":"Next »","page":null,"active":false}],"next_page_url":null,"path":"https:\/\/www.searchcarriers.com\/company\/937927\/inspections","per_page":100,"prev_page_url":null,"to":32,"total":32}