{"current_page":1,"data":[{"id":8212703,"change_date":"2025-03-26 21:40:00","inspection_id":"84228235","dot_number":"200274","report_state":"IA","report_number":"000P14WDM0","insp_date":"2025-03-25 00:00:00","insp_start_time":"1315","insp_end_time":"1334","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 18 EB\/E OF HWY 69","county_code_state":"IA","county_code":"081","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"EMPTY","shipping_paper_number":"1234","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1354102","transaction_code":"A","transaction_date":"2025-03-26 00:00:00","upload_date":"2025-03-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00200274","upload_search_indicator":"M","census_search_date":"2025-03-26 21:40:00","snet_input_date":"2025-03-25 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-03-26 21:40:00","insp_carrier_name":"UNITED BEVERAGE INC","insp_carrier_street":"2604 W AIRLINE HWY","insp_carrier_city":"WATERLOO","insp_carrier_state":"IA","insp_carrier_zip_code":"50703-9606","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-29T10:21:17.000000Z","updated_at":"2025-03-30T10:35:52.000000Z","inspection_violations":[{"id":12882161,"change_date":"2025-03-26 21:40:00","inspection_id":"84228235","insp_violation_id":"265259654","seq_no":"1","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"205994691","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-28T10:58:02.000000Z","updated_at":"2025-03-29T10:39:12.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":13280251,"change_date":"2025-03-26 21:40:00","inspection_id":"84228235","insp_unit_id":"205994692","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HESS","insp_unit_company":null,"insp_unit_license":"JE9949","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":null,"insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-29T10:08:32.000000Z","updated_at":"2025-03-30T10:04:37.000000Z"},{"id":13280250,"change_date":"2025-03-26 21:40:00","inspection_id":"84228235","insp_unit_id":"205994691","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"KU0276","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":null,"insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-29T10:08:32.000000Z","updated_at":"2025-03-30T10:04:37.000000Z"}]},{"id":7955655,"change_date":"2025-02-25 21:40:00","inspection_id":"83957200","dot_number":"200274","report_state":"IA","report_number":"000P123G0T","insp_date":"2025-02-21 00:00:00","insp_start_time":"1055","insp_end_time":"1109","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HIGHWAY 65 SB","county_code_state":"IA","county_code":"033","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"UNITED BEVERAGE","shipping_paper_number":"152651","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-02-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"83000","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":"1350558","transaction_code":"A","transaction_date":"2025-02-24 00:00:00","upload_date":"2025-02-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00200274","upload_search_indicator":"M","census_search_date":"2025-02-25 21:40:00","snet_input_date":"2025-02-21 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-02-25 21:40:00","insp_carrier_name":"UNITED BEVERAGE INC","insp_carrier_street":"2604 W AIRLINE HWY","insp_carrier_city":"WATERLOO","insp_carrier_state":"IA","insp_carrier_zip_code":"50703-9606","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T21:03:18.000000Z","updated_at":"2025-03-17T21:03:18.000000Z","inspection_violations":[{"id":12430673,"change_date":"2025-02-25 21:40:00","inspection_id":"83957200","insp_violation_id":"264688085","seq_no":"1","part_no":"392","part_no_section":"16","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:44.000000Z","updated_at":"2025-03-17T22:06:44.000000Z","normalized_code":"39216"}],"inspection_per_units":[{"id":12842630,"change_date":"2025-02-25 21:40:00","inspection_id":"83957200","insp_unit_id":"205489188","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"C2303","insp_unit_license":"IX3880","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3AKBCXFE6PDUC9399","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:56:52.000000Z","updated_at":"2025-03-17T23:56:52.000000Z"},{"id":12842631,"change_date":"2025-02-25 21:40:00","inspection_id":"83957200","insp_unit_id":"205489189","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HACKNEY","insp_unit_company":null,"insp_unit_license":"CR7554","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1HHDMT210WM000835","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:56:52.000000Z","updated_at":"2025-03-17T23:56:52.000000Z"}]},{"id":7759125,"change_date":"2025-01-31 21:40:00","inspection_id":"83750883","dot_number":"200274","report_state":"IA","report_number":"000P118HQ3","insp_date":"2025-01-30 00:00:00","insp_start_time":"1042","insp_end_time":"1059","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"S. FEDERAL AVE AND 19TH ST SE","county_code_state":"IA","county_code":"033","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"UNITED BEVERAGE INC","shipping_paper_number":"152007","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":"114000","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":"1347888","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":"00200274","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":"UNITED BEVERAGE INC","insp_carrier_street":"2604 W AIRLINE HWY","insp_carrier_city":"WATERLOO","insp_carrier_state":"IA","insp_carrier_zip_code":"50703-9606","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:59:11.000000Z","updated_at":"2025-03-17T20:59:11.000000Z","inspection_violations":[{"id":12123231,"change_date":"2025-01-31 21:40:00","inspection_id":"83750883","insp_violation_id":"264280253","seq_no":"1","part_no":"392","part_no_section":"16","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"4GRE25013010464","created_at":"2025-03-17T22:05:10.000000Z","updated_at":"2025-03-17T22:05:10.000000Z","normalized_code":"39216"},{"id":12123232,"change_date":"2025-01-31 21:40:00","inspection_id":"83750883","insp_violation_id":"264280254","seq_no":"2","part_no":"390","part_no_section":"21TB","insp_viol_unit":"1","insp_unit_id":"205104301","insp_violation_category_id":"30","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":"39021TB"}],"inspection_per_units":[{"id":12521415,"change_date":"2025-01-31 21:40:00","inspection_id":"83750883","insp_unit_id":"205104301","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"885095","insp_unit_license":"HT5724","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3AKBCXD22LDLN0187","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":12521416,"change_date":"2025-01-31 21:40:00","inspection_id":"83750883","insp_unit_id":"205104302","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MICKEY","insp_unit_company":"T9802","insp_unit_license":"KU0394","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1M9RC1717WH043566","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":7093936,"change_date":"2024-10-31 21:42:00","inspection_id":"83050456","dot_number":"200274","report_state":"IA","report_number":"000P15ND2L","insp_date":"2024-10-30 00:00:00","insp_start_time":"1342","insp_end_time":"1400","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 63\/","county_code_state":"IA","county_code":"013","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"UNITED BEVERAGE","shipping_paper_number":"1","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-31 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"73000","viol_total":"4","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1335586","transaction_code":"A","transaction_date":"2024-10-31 00:00:00","upload_date":"2024-10-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00200274","upload_search_indicator":"M","census_search_date":"2024-10-31 21:42:00","snet_input_date":"2024-10-30 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-10-31 21:42:00","insp_carrier_name":"UNITED BEVERAGE INC","insp_carrier_street":"2604 W AIRLINE HWY","insp_carrier_city":"WATERLOO","insp_carrier_state":"IA","insp_carrier_zip_code":"50703-9606","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:43:53.000000Z","updated_at":"2025-03-17T20:43:53.000000Z","inspection_violations":[{"id":11076074,"change_date":"2024-10-31 21:42:00","inspection_id":"83050456","insp_violation_id":"262664925","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-17T21:59:44.000000Z","updated_at":"2025-03-17T21:59:44.000000Z","normalized_code":"3922SLLS2"},{"id":11076075,"change_date":"2024-10-31 21:42:00","inspection_id":"83050456","insp_violation_id":"262664926","seq_no":"2","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"203681864","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:44.000000Z","updated_at":"2025-03-17T21:59:44.000000Z","normalized_code":"39617C"},{"id":11076076,"change_date":"2024-10-31 21:42:00","inspection_id":"83050456","insp_violation_id":"262664927","seq_no":"3","part_no":"396","part_no_section":"17C","insp_viol_unit":"2","insp_unit_id":"203681865","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:44.000000Z","updated_at":"2025-03-17T21:59:44.000000Z","normalized_code":"39617C"},{"id":11076077,"change_date":"2024-10-31 21:42:00","inspection_id":"83050456","insp_violation_id":"262664928","seq_no":"4","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"203681865","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:44.000000Z","updated_at":"2025-03-17T21:59:44.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":11441111,"change_date":"2024-10-31 21:42:00","inspection_id":"83050456","insp_unit_id":"203681864","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1902","insp_unit_license":"ET8110","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3AKBCXFE4KDKH2657","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:30.000000Z","updated_at":"2025-03-17T23:41:30.000000Z"},{"id":11441112,"change_date":"2024-10-31 21:42:00","inspection_id":"83050456","insp_unit_id":"203681865","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HACKNEY","insp_unit_company":"TO906","insp_unit_license":"GM5940","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1HHRTX2139M000297","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:30.000000Z","updated_at":"2025-03-17T23:41:30.000000Z"}]},{"id":6197662,"change_date":"2024-07-11 21:41:00","inspection_id":"82095136","dot_number":"200274","report_state":"IA","report_number":"000P123D18","insp_date":"2024-07-10 00:00:00","insp_start_time":"1315","insp_end_time":"1332","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"255TH\/KILLDEER EB","county_code_state":"IA","county_code":"033","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-07-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"98000","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":"1320538","transaction_code":"A","transaction_date":"2024-07-11 00:00:00","upload_date":"2024-07-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00200274","upload_search_indicator":"M","census_search_date":"2024-07-11 21:41:00","snet_input_date":"2024-07-10 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-07-11 21:41:00","insp_carrier_name":"UNITED BEVERAGE INC","insp_carrier_street":"2604 W AIRLINE HWY","insp_carrier_city":"WATERLOO","insp_carrier_state":"IA","insp_carrier_zip_code":"50703-9606","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:25:25.000000Z","updated_at":"2025-03-17T20:25:25.000000Z","inspection_violations":[{"id":9624652,"change_date":"2024-07-11 21:41:00","inspection_id":"82095136","insp_violation_id":"260591853","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"1LOP24071013254","created_at":"2025-03-17T21:52:36.000000Z","updated_at":"2025-03-17T21:52:36.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":9984344,"change_date":"2024-07-11 21:41:00","inspection_id":"82095136","insp_unit_id":"201841636","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"8041","insp_unit_license":"KV9664","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"2XP2AJ7XXKM268041","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:27.000000Z","updated_at":"2025-03-17T23:26:27.000000Z"},{"id":9984345,"change_date":"2024-07-11 21:41:00","inspection_id":"82095136","insp_unit_id":"201841637","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"C1310","insp_unit_license":"KV9589","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1UYVS240XDG507704","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:27.000000Z","updated_at":"2025-03-17T23:26:27.000000Z"}]},{"id":3456757,"change_date":"2023-07-07 21:41:00","inspection_id":"79085712","dot_number":"200274","report_state":"IA","report_number":"000TT6ZVVW","insp_date":"2023-07-05 00:00:00","insp_start_time":"1140","insp_end_time":"1200","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"FEDERAL AND 12TH MASON CITY","county_code_state":"IA","county_code":"033","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SELF","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-07-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"1280285","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":"00200274","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":"UNITED BEVERAGE INC","insp_carrier_street":"2604 W AIRLINE HWY","insp_carrier_city":"WATERLOO","insp_carrier_state":"IA","insp_carrier_zip_code":"50703-9606","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:31:22.000000Z","updated_at":"2025-03-17T19:31:22.000000Z","inspection_violations":[{"id":5329281,"change_date":"2023-07-07 21:41:00","inspection_id":"79085712","insp_violation_id":"253929576","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"9DAN23070511484","created_at":"2025-03-17T21:31:44.000000Z","updated_at":"2025-03-17T21:31:44.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":5558304,"change_date":"2023-07-07 21:41:00","inspection_id":"79085712","insp_unit_id":"195882272","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"NONE","insp_unit_license":"HE6513","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3AKBCXFE1MDMS6832","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":5558305,"change_date":"2023-07-07 21:41:00","inspection_id":"79085712","insp_unit_id":"195882273","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRIU","insp_unit_company":"101","insp_unit_license":"EH7524","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1T9BA34191C178963","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":2766043,"change_date":"2023-04-12 21:40:00","inspection_id":"78305925","dot_number":"200274","report_state":"IA","report_number":"000TT6CX8W","insp_date":"2023-04-04 00:00:00","insp_start_time":"1151","insp_end_time":"1222","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 17 NB\/120TH ST","county_code_state":"IA","county_code":"081","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"MISC","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-04-11 12:04:00","post_acc_ind":"N","gross_comb_veh_wt":"74500","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1269669","transaction_code":"C","transaction_date":"2023-04-11 00:00:00","upload_date":"2023-04-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00200274","upload_search_indicator":"M","census_search_date":"2023-04-11 12:04:00","snet_input_date":"2023-04-04 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-04-11 12:04:00","insp_carrier_name":"UNITED BEVERAGE INC","insp_carrier_street":"2604 W AIRLINE HWY","insp_carrier_city":"WATERLOO","insp_carrier_state":"IA","insp_carrier_zip_code":"50703-9606","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:17:40.000000Z","updated_at":"2025-03-17T19:17:40.000000Z","inspection_violations":[{"id":4243928,"change_date":"2023-04-12 21:40:00","inspection_id":"78305925","insp_violation_id":"252174838","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:26:52.000000Z","updated_at":"2025-03-17T21:26:52.000000Z","normalized_code":"3922"},{"id":4243929,"change_date":"2023-04-12 21:40:00","inspection_id":"78305925","insp_violation_id":"252174839","seq_no":"2","part_no":"391","part_no_section":"41(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"T22523040412100","created_at":"2025-03-17T21:26:52.000000Z","updated_at":"2025-03-17T21:26:52.000000Z","normalized_code":"39141A1"}],"inspection_per_units":[{"id":4451810,"change_date":"2023-04-12 21:40:00","inspection_id":"78305925","insp_unit_id":"194346107","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"80","insp_unit_license":"IX3880","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3AKBCXFE6PDUC9399","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:03.000000Z","updated_at":"2025-03-17T22:38:03.000000Z"},{"id":4451811,"change_date":"2023-04-12 21:40:00","inspection_id":"78305925","insp_unit_id":"194346108","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CUSM","insp_unit_company":"23","insp_unit_license":"IT7223","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"2P9SNA6A69G027773","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:03.000000Z","updated_at":"2025-03-17T22:38:03.000000Z"}]},{"id":394202,"change_date":"2022-05-16 21:43:00","inspection_id":"75563433","dot_number":"200274","report_state":"IA","report_number":"000TT7DKMK","insp_date":"2022-05-13 00:00:00","insp_start_time":"1410","insp_end_time":"1435","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 150 AND SUFICOOL HAZLETON","county_code_state":"IA","county_code":"019","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"UNITED BEVERAGE INC","shipping_paper_number":"BEVERAGES","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-16 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"71000","viol_total":"6","oos_total":"0","driver_viol_total":"4","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1224990","transaction_code":"A","transaction_date":"2022-05-16 00:00:00","upload_date":"2022-05-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00200274","upload_search_indicator":"M","census_search_date":"2022-05-16 21:43:00","snet_input_date":"2022-05-13 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-05-16 21:43:00","insp_carrier_name":"UNITED BEVERAGE INC","insp_carrier_street":"2604 W AIRLINE HWY","insp_carrier_city":"WATERLOO","insp_carrier_state":"IA","insp_carrier_zip_code":"50703-9606","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:34:27.000000Z","updated_at":"2025-03-17T18:34:27.000000Z","inspection_violations":[{"id":615597,"change_date":"2022-05-16 21:43:00","inspection_id":"75563433","insp_violation_id":"245800522","seq_no":"1","part_no":"383","part_no_section":"71(h)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:54.000000Z","updated_at":"2025-03-17T21:09:54.000000Z","normalized_code":"38371H"},{"id":615598,"change_date":"2022-05-16 21:43:00","inspection_id":"75563433","insp_violation_id":"245800523","seq_no":"2","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:54.000000Z","updated_at":"2025-03-17T21:09:54.000000Z","normalized_code":"39216A"},{"id":615599,"change_date":"2022-05-16 21:43:00","inspection_id":"75563433","insp_violation_id":"245800524","seq_no":"3","part_no":"392","part_no_section":"16(b)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:54.000000Z","updated_at":"2025-03-17T21:09:54.000000Z","normalized_code":"39216B"},{"id":615600,"change_date":"2022-05-16 21:43:00","inspection_id":"75563433","insp_violation_id":"245800525","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"188694309","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:54.000000Z","updated_at":"2025-03-17T21:09:54.000000Z","normalized_code":"3922"},{"id":615601,"change_date":"2022-05-16 21:43:00","inspection_id":"75563433","insp_violation_id":"245800526","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"188694309","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:54.000000Z","updated_at":"2025-03-17T21:09:54.000000Z","normalized_code":"3922"},{"id":615602,"change_date":"2022-05-16 21:43:00","inspection_id":"75563433","insp_violation_id":"245800527","seq_no":"6","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:09:54.000000Z","updated_at":"2025-03-17T21:09:54.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":636818,"change_date":"2022-05-16 21:43:00","inspection_id":"75563433","insp_unit_id":"188694309","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"2001","insp_unit_license":"GS6620","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3AKBCXFE7LDLZ8551","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:06.000000Z","updated_at":"2025-03-17T22:12:06.000000Z"},{"id":636819,"change_date":"2022-05-16 21:43:00","inspection_id":"75563433","insp_unit_id":"188694310","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MICKEY","insp_unit_company":"T9501","insp_unit_license":"BM4765","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1M9RC181XSH043196","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:06.000000Z","updated_at":"2025-03-17T22:12:06.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/200274\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/200274\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/200274\/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\/200274\/inspections","per_page":100,"prev_page_url":null,"to":8,"total":8}