{"current_page":1,"data":[{"id":11531489,"change_date":"2026-03-31 21:40:00","inspection_id":"87453265","dot_number":"200275","report_state":"IA","report_number":"000P14PHMM","insp_date":"2026-03-27 00:00:00","insp_start_time":"0743","insp_end_time":"0810","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 24 NEW HAMPTON","county_code_state":"IA","county_code":"037","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SELF","shipping_paper_number":"102","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-31 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"73000","viol_total":"5","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1395539","transaction_code":"A","transaction_date":"2026-03-31 00:00:00","upload_date":"2026-03-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00200275","upload_search_indicator":"M","census_search_date":"2026-03-31 21:40:00","snet_input_date":"2026-03-27 00:00:00","source_office":"3IAS001","mcmis_add_date":"2026-03-31 21:40:00","insp_carrier_name":"UNITEDBEVERAGE 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":"2026-04-03T09:46:20.000000Z","updated_at":"2026-04-11T09:31:21.000000Z","inspection_violations":[{"id":19482062,"change_date":"2026-03-31 21:40:00","inspection_id":"87453265","insp_violation_id":"272771889","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":"2026-04-03T10:12:35.000000Z","updated_at":"2026-04-11T09:45:19.000000Z","normalized_code":"39216"},{"id":19482063,"change_date":"2026-03-31 21:40:00","inspection_id":"87453265","insp_violation_id":"272771890","seq_no":"2","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":"2026-04-03T10:12:35.000000Z","updated_at":"2026-04-11T09:45:19.000000Z","normalized_code":"39216B"},{"id":19482064,"change_date":"2026-03-31 21:40:00","inspection_id":"87453265","insp_violation_id":"272771891","seq_no":"3","part_no":"392","part_no_section":"82DUMT","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":"2026-04-03T10:12:35.000000Z","updated_at":"2026-04-11T09:45:19.000000Z","normalized_code":"39282DUMT"},{"id":19482065,"change_date":"2026-03-31 21:40:00","inspection_id":"87453265","insp_violation_id":"272771892","seq_no":"4","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"212453448","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-03T10:12:35.000000Z","updated_at":"2026-04-11T09:45:19.000000Z","normalized_code":"3922RG"},{"id":19482066,"change_date":"2026-03-31 21:40:00","inspection_id":"87453265","insp_violation_id":"272771893","seq_no":"5","part_no":"396","part_no_section":"17C","insp_viol_unit":"2","insp_unit_id":"212453448","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-03T10:12:35.000000Z","updated_at":"2026-04-11T09:45:19.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":19756982,"change_date":"2026-03-31 21:40:00","inspection_id":"87453265","insp_unit_id":"212453447","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"278965","insp_unit_license":"GT8369","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3AKBCXFE9LDLZ8552","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-03T09:24:40.000000Z","updated_at":"2026-04-11T09:04:11.000000Z"},{"id":19756983,"change_date":"2026-03-31 21:40:00","inspection_id":"87453265","insp_unit_id":"212453448","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HESSE","insp_unit_company":"CT0904","insp_unit_license":"IT7224","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"2P9SNA6A89G027774","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-03T09:24:40.000000Z","updated_at":"2026-04-11T09:04:11.000000Z"}]},{"id":11500622,"change_date":"2026-03-27 21:40:00","inspection_id":"87420679","dot_number":"200275","report_state":"IA","report_number":"000P14PHMH","insp_date":"2026-03-26 00:00:00","insp_start_time":"1018","insp_end_time":"1100","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 18 MARQUETTE","county_code_state":"IA","county_code":"043","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SELF","shipping_paper_number":"231","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-03-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"73000","viol_total":"6","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1395197","transaction_code":"A","transaction_date":"2026-03-27 00:00:00","upload_date":"2026-03-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00200275","upload_search_indicator":"M","census_search_date":"2026-03-27 21:40:00","snet_input_date":"2026-03-26 00:00:00","source_office":"3IAS001","mcmis_add_date":"2026-03-27 21:40:00","insp_carrier_name":"UNITEDBEVERAGE 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":"2026-03-30T09:51:44.000000Z","updated_at":"2026-04-07T09:32:19.000000Z","inspection_violations":[{"id":19419421,"change_date":"2026-03-27 21:40:00","inspection_id":"87420679","insp_violation_id":"272689619","seq_no":"1","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"212381889","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-30T10:20:05.000000Z","updated_at":"2026-04-07T09:48:35.000000Z","normalized_code":"3922RG"},{"id":19419422,"change_date":"2026-03-27 21:40:00","inspection_id":"87420679","insp_violation_id":"272689620","seq_no":"2","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"212381889","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-30T10:20:05.000000Z","updated_at":"2026-04-07T09:48:35.000000Z","normalized_code":"3922RG"},{"id":19419423,"change_date":"2026-03-27 21:40:00","inspection_id":"87420679","insp_violation_id":"272689621","seq_no":"3","part_no":"393","part_no_section":"9TS","insp_viol_unit":"1","insp_unit_id":"212381889","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-30T10:20:05.000000Z","updated_at":"2026-04-07T09:48:35.000000Z","normalized_code":"3939TS"},{"id":19419424,"change_date":"2026-03-27 21:40:00","inspection_id":"87420679","insp_violation_id":"272689622","seq_no":"4","part_no":"393","part_no_section":"9TS","insp_viol_unit":"1","insp_unit_id":"212381889","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-30T10:20:05.000000Z","updated_at":"2026-04-07T09:48:35.000000Z","normalized_code":"3939TS"},{"id":19419425,"change_date":"2026-03-27 21:40:00","inspection_id":"87420679","insp_violation_id":"272689623","seq_no":"5","part_no":"393","part_no_section":"9TS","insp_viol_unit":"1","insp_unit_id":"212381889","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-30T10:20:05.000000Z","updated_at":"2026-04-07T09:48:35.000000Z","normalized_code":"3939TS"},{"id":19419426,"change_date":"2026-03-27 21:40:00","inspection_id":"87420679","insp_violation_id":"272689624","seq_no":"6","part_no":"393","part_no_section":"9A-LSLI","insp_viol_unit":"1","insp_unit_id":"212381889","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-30T10:20:05.000000Z","updated_at":"2026-04-07T09:48:35.000000Z","normalized_code":"3939ALSLI"}],"inspection_per_units":[{"id":19702039,"change_date":"2026-03-27 21:40:00","inspection_id":"87420679","insp_unit_id":"212381889","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"C2304","insp_unit_license":"IY7891","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FUBCXFE4PHUA6729","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-30T09:33:24.000000Z","updated_at":"2026-04-07T09:08:42.000000Z"},{"id":19702040,"change_date":"2026-03-27 21:40:00","inspection_id":"87420679","insp_unit_id":"212381890","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRIPLEB","insp_unit_company":"8989","insp_unit_license":"GM5771","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1T9BA34132C178989","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-30T09:33:24.000000Z","updated_at":"2026-04-07T09:08:42.000000Z"}]},{"id":11047138,"change_date":"2026-02-04 21:39:00","inspection_id":"86956805","dot_number":"200275","report_state":"IA","report_number":"000P151W8Z","insp_date":"2026-02-03 00:00:00","insp_start_time":"0614","insp_end_time":"0650","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 18 WB WEST SIDE OF BRITT","county_code_state":"IA","county_code":"081","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"UNITEDBEVERAGE INC","shipping_paper_number":"RT 103","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-02-04 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"66350","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1389141","transaction_code":"A","transaction_date":"2026-02-04 00:00:00","upload_date":"2026-02-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00200275","upload_search_indicator":"M","census_search_date":"2026-02-04 21:39:00","snet_input_date":"2026-02-03 00:00:00","source_office":"3IAS001","mcmis_add_date":"2026-02-04 21:39:00","insp_carrier_name":"UNITEDBEVERAGE 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":"2026-02-08T10:37:00.000000Z","updated_at":"2026-02-15T10:30:45.000000Z","inspection_violations":[{"id":18302009,"change_date":"2026-02-04 21:39:00","inspection_id":"86956805","insp_violation_id":"271593839","seq_no":"1","part_no":"393","part_no_section":"23PT","insp_viol_unit":"2","insp_unit_id":"211439570","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-02-07T10:45:36.000000Z","updated_at":"2026-02-15T10:40:10.000000Z","normalized_code":"39323PT"}],"inspection_per_units":[{"id":18374996,"change_date":"2026-02-04 21:39:00","inspection_id":"86956805","insp_unit_id":"211439569","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"0672447","insp_unit_license":"KU0276","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"2XP8AJ8XXRM686148","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-07T10:11:01.000000Z","updated_at":"2026-02-15T10:05:24.000000Z"},{"id":18374997,"change_date":"2026-02-04 21:39:00","inspection_id":"86956805","insp_unit_id":"211439570","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HMDE","insp_unit_company":"CT9301","insp_unit_license":"JE9949","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1H9RA1215PK008702","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-07T10:11:01.000000Z","updated_at":"2026-02-15T10:05:24.000000Z"}]},{"id":10506725,"change_date":"2025-12-23 21:38:00","inspection_id":"86641765","dot_number":"200275","report_state":"IA","report_number":"000P120FFB","insp_date":"2025-12-22 00:00:00","insp_start_time":"1006","insp_end_time":"1030","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"N 13TH ST \/ HWY 9 OSAGE","county_code_state":"IA","county_code":"131","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"UNITEDBEVERAGE INC","shipping_paper_number":"104","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-12-23 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"71500","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":"1385189","transaction_code":"A","transaction_date":"2025-12-23 00:00:00","upload_date":"2025-12-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00200275","upload_search_indicator":"M","census_search_date":"2025-12-23 21:38:00","snet_input_date":"2025-12-22 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-12-23 21:38:00","insp_carrier_name":"UNITEDBEVERAGE 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-12-26T10:38:36.000000Z","updated_at":"2026-01-03T10:30:38.000000Z","inspection_violations":[{"id":17636802,"change_date":"2025-12-23 21:38:00","inspection_id":"86641765","insp_violation_id":"270870838","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-12-26T10:44:25.000000Z","updated_at":"2026-01-03T10:31:06.000000Z","normalized_code":"39216B"}],"inspection_per_units":[{"id":17594806,"change_date":"2025-12-23 21:38:00","inspection_id":"86641765","insp_unit_id":"210779844","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CUSM","insp_unit_company":"CT0903","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-12-26T10:09:30.000000Z","updated_at":"2026-01-03T10:00:45.000000Z"},{"id":17594805,"change_date":"2025-12-23 21:38:00","inspection_id":"86641765","insp_unit_id":"210779843","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"2006","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-12-26T10:09:30.000000Z","updated_at":"2026-01-03T10:00:45.000000Z"}]},{"id":7556076,"change_date":"2025-01-06 21:39:00","inspection_id":"83537634","dot_number":"200275","report_state":"IA","report_number":"000P11H5ZJ","insp_date":"2025-01-03 00:00:00","insp_start_time":"1228","insp_end_time":"1234","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 3 AND CEDAR RIVER PKY","county_code_state":"IA","county_code":"017","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"UNITED BEVERAGE","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-01-06 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"71302","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":"1344600","transaction_code":"A","transaction_date":"2025-01-06 00:00:00","upload_date":"2025-01-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00200275","upload_search_indicator":"M","census_search_date":"2025-01-06 21:39:00","snet_input_date":"2025-01-03 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-01-06 21:39:00","insp_carrier_name":"UNITED BEVERAGES INC","insp_carrier_street":"2604 W AIRLINE HWY","insp_carrier_city":"WATERLOO","insp_carrier_state":"IA","insp_carrier_zip_code":"50703","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:54:56.000000Z","updated_at":"2025-03-17T20:54:56.000000Z","inspection_violations":[{"id":11810433,"change_date":"2025-01-06 21:39:00","inspection_id":"83537634","insp_violation_id":"263771854","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:03:33.000000Z","updated_at":"2025-03-17T22:03:33.000000Z","normalized_code":"39216B"}],"inspection_per_units":[{"id":12191666,"change_date":"2025-01-06 21:39:00","inspection_id":"83537634","insp_unit_id":"204666663","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"2302","insp_unit_license":"IY7781","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FUBCXFE2PHUA6728","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:35.000000Z","updated_at":"2025-03-17T23:49:35.000000Z"},{"id":12191667,"change_date":"2025-01-06 21:39:00","inspection_id":"83537634","insp_unit_id":"204666664","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"KZ1126","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GRAA9624DT578580","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:35.000000Z","updated_at":"2025-03-17T23:49:35.000000Z"}]},{"id":7535047,"change_date":"2025-01-02 21:39:00","inspection_id":"83515536","dot_number":"200275","report_state":"IA","report_number":"000P151VCM","insp_date":"2024-12-31 00:00:00","insp_start_time":"1214","insp_end_time":"1245","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 18 EB BRITT","county_code_state":"IA","county_code":"081","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"UNITED BEVERAGE","shipping_paper_number":"ROUTE 103","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-02 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"71430","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1344205","transaction_code":"A","transaction_date":"2025-01-02 00:00:00","upload_date":"2025-01-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00200275","upload_search_indicator":"M","census_search_date":"2025-01-02 21:39:00","snet_input_date":"2024-12-31 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-01-02 21:39:00","insp_carrier_name":"UNITEDBEVERAGE 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":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:53:13.000000Z","updated_at":"2025-03-17T20:53:13.000000Z","inspection_violations":[{"id":11775867,"change_date":"2025-01-02 21:39:00","inspection_id":"83515536","insp_violation_id":"263727347","seq_no":"1","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"204624713","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:22.000000Z","updated_at":"2025-03-17T22:03:22.000000Z","normalized_code":"3922RG"},{"id":11775868,"change_date":"2025-01-02 21:39:00","inspection_id":"83515536","insp_violation_id":"263727348","seq_no":"2","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"204624713","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:22.000000Z","updated_at":"2025-03-17T22:03:22.000000Z","normalized_code":"39617C"},{"id":11775869,"change_date":"2025-01-02 21:39:00","inspection_id":"83515536","insp_violation_id":"263727349","seq_no":"3","part_no":"392","part_no_section":"2IN","insp_viol_unit":"1","insp_unit_id":"204624713","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:22.000000Z","updated_at":"2025-03-17T22:03:22.000000Z","normalized_code":"3922IN"},{"id":11775870,"change_date":"2025-01-02 21:39:00","inspection_id":"83515536","insp_violation_id":"263727350","seq_no":"4","part_no":"396","part_no_section":"17C","insp_viol_unit":"2","insp_unit_id":"204624714","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"0NEL24123112383","created_at":"2025-03-17T22:03:22.000000Z","updated_at":"2025-03-17T22:03:22.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":12156436,"change_date":"2025-01-02 21:39:00","inspection_id":"83515536","insp_unit_id":"204624713","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"86148","insp_unit_license":"KU0276","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"2XP8AJ8XXRM686148","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:13.000000Z","updated_at":"2025-03-17T23:49:13.000000Z"},{"id":12156437,"change_date":"2025-01-02 21:39:00","inspection_id":"83515536","insp_unit_id":"204624714","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HMDE","insp_unit_company":"CT9301","insp_unit_license":"JE9949","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1H9RA1215PK008702","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:13.000000Z","updated_at":"2025-03-17T23:49:13.000000Z"}]},{"id":7340093,"change_date":"2024-12-04 21:41:00","inspection_id":"83310731","dot_number":"200275","report_state":"IA","report_number":"000P14PH4K","insp_date":"2024-12-03 00:00:00","insp_start_time":"0645","insp_end_time":"0710","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"LOCUST RD DECORAH","county_code_state":"IA","county_code":"191","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SELF","shipping_paper_number":"150512","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-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"73000","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":"1340550","transaction_code":"A","transaction_date":"2024-12-04 00:00:00","upload_date":"2024-12-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00200275","upload_search_indicator":"M","census_search_date":"2024-12-04 21:41:00","snet_input_date":"2024-12-03 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-12-04 21:41:00","insp_carrier_name":"UNITEDBEVERAGE 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":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:49:21.000000Z","updated_at":"2025-03-17T20:49:21.000000Z","inspection_violations":[{"id":11474954,"change_date":"2024-12-04 21:41:00","inspection_id":"83310731","insp_violation_id":"263229354","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":"2WIC24120307000","created_at":"2025-03-17T22:01:49.000000Z","updated_at":"2025-03-17T22:01:49.000000Z","normalized_code":"3922SLLS3"},{"id":11474955,"change_date":"2024-12-04 21:41:00","inspection_id":"83310731","insp_violation_id":"263229355","seq_no":"2","part_no":"393","part_no_section":"9TS","insp_viol_unit":"1","insp_unit_id":"204181736","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:49.000000Z","updated_at":"2025-03-17T22:01:49.000000Z","normalized_code":"3939TS"},{"id":11474956,"change_date":"2024-12-04 21:41:00","inspection_id":"83310731","insp_violation_id":"263229356","seq_no":"3","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"204181737","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:49.000000Z","updated_at":"2025-03-17T22:01:49.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":11840593,"change_date":"2024-12-04 21:41:00","inspection_id":"83310731","insp_unit_id":"204181736","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"500177","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-17T23:45:45.000000Z","updated_at":"2025-03-17T23:45:45.000000Z"},{"id":11840594,"change_date":"2024-12-04 21:41:00","inspection_id":"83310731","insp_unit_id":"204181737","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HACKNEY","insp_unit_company":"CT0805","insp_unit_license":"GG5448","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1HHDMT2198M000268","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:45.000000Z","updated_at":"2025-03-17T23:45:45.000000Z"}]},{"id":7025534,"change_date":"2024-10-23 21:42:00","inspection_id":"82978017","dot_number":"200275","report_state":"IA","report_number":"000P12Q7F8","insp_date":"2024-10-21 00:00:00","insp_start_time":"1300","insp_end_time":"1325","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"200TH AVE AND 150TH ST MANCHES","county_code_state":"IA","county_code":"055","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"UNITED BEVERAGE","shipping_paper_number":"149357","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-23 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"53000","viol_total":"3","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1333857","transaction_code":"A","transaction_date":"2024-10-23 00:00:00","upload_date":"2024-10-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00200275","upload_search_indicator":"M","census_search_date":"2024-10-23 21:42:00","snet_input_date":"2024-10-21 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-10-23 21:42:00","insp_carrier_name":"UNITEDBEVERAGE 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":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:42:37.000000Z","updated_at":"2025-03-17T20:42:37.000000Z","inspection_violations":[{"id":10964901,"change_date":"2024-10-23 21:42:00","inspection_id":"82978017","insp_violation_id":"262513859","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":"2DRI24102113094","created_at":"2025-03-17T21:59:11.000000Z","updated_at":"2025-03-17T21:59:11.000000Z","normalized_code":"39216"},{"id":10964902,"change_date":"2024-10-23 21:42:00","inspection_id":"82978017","insp_violation_id":"262513860","seq_no":"2","part_no":"391","part_no_section":"41A","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"2DRI24102113112","created_at":"2025-03-17T21:59:11.000000Z","updated_at":"2025-03-17T21:59:11.000000Z","normalized_code":"39141A"},{"id":10964903,"change_date":"2024-10-23 21:42:00","inspection_id":"82978017","insp_violation_id":"262513861","seq_no":"3","part_no":"383","part_no_section":"71H","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:59:11.000000Z","updated_at":"2025-03-17T21:59:11.000000Z","normalized_code":"38371H"}],"inspection_per_units":[{"id":11330679,"change_date":"2024-10-23 21:42:00","inspection_id":"82978017","insp_unit_id":"203547734","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"2305","insp_unit_license":"JR7149","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3AKBCXFE6PDUN3223","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:21.000000Z","updated_at":"2025-03-17T23:40:21.000000Z"},{"id":11330680,"change_date":"2024-10-23 21:42:00","inspection_id":"82978017","insp_unit_id":"203547735","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MICKEY","insp_unit_company":"T9501","insp_unit_license":"KU0392","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1M9RC181XSH043196","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:21.000000Z","updated_at":"2025-03-17T23:40:21.000000Z"}]},{"id":6574923,"change_date":"2024-08-27 21:42:00","inspection_id":"82498406","dot_number":"200275","report_state":"IA","report_number":"000P15NCW0","insp_date":"2024-08-26 00:00:00","insp_start_time":"1650","insp_end_time":"1705","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"AIRLINE HIGHWAY\/AIRPORT  BLVD","county_code_state":"IA","county_code":"013","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"NONE","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":"2024-08-27 21:42: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":"1326926","transaction_code":"A","transaction_date":"2024-08-27 00:00:00","upload_date":"2024-08-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00200275","upload_search_indicator":"M","census_search_date":"2024-08-27 21:42:00","snet_input_date":"2024-08-26 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-08-27 21:42:00","insp_carrier_name":"UNITED BEVERAGES 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":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:33:13.000000Z","updated_at":"2025-03-17T20:33:13.000000Z","inspection_violations":[{"id":10218699,"change_date":"2024-08-27 21:42:00","inspection_id":"82498406","insp_violation_id":"261436841","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":"0LEE24082616574","created_at":"2025-03-17T21:55:26.000000Z","updated_at":"2025-03-17T21:55:26.000000Z","normalized_code":"39216A"},{"id":10218700,"change_date":"2024-08-27 21:42:00","inspection_id":"82498406","insp_violation_id":"261436842","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"202608640","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:26.000000Z","updated_at":"2025-03-17T21:55:26.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":10599692,"change_date":"2024-08-27 21:42:00","inspection_id":"82498406","insp_unit_id":"202608640","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1506","insp_unit_license":"LXS136","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3ALACWDT6FDGF5057","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:47.000000Z","updated_at":"2025-03-17T23:32:47.000000Z"}]},{"id":6487740,"change_date":"2024-08-16 21:39:00","inspection_id":"82405559","dot_number":"200275","report_state":"IA","report_number":"000P14PGVH","insp_date":"2024-08-14 00:00:00","insp_start_time":"0744","insp_end_time":"0800","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 150 CALMAR","county_code_state":"IA","county_code":"191","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SELF","shipping_paper_number":"147516","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"73000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1325279","transaction_code":"A","transaction_date":"2024-08-16 00:00:00","upload_date":"2024-08-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00200275","upload_search_indicator":"M","census_search_date":"2024-08-16 21:39:00","snet_input_date":"2024-08-14 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-08-16 21:39:00","insp_carrier_name":"UNITED BEVERAGES 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":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:31:34.000000Z","updated_at":"2025-03-17T20:31:34.000000Z","inspection_violations":[{"id":10075193,"change_date":"2024-08-16 21:39:00","inspection_id":"82405559","insp_violation_id":"261235345","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":"2WIC24081407545","created_at":"2025-03-17T21:54:44.000000Z","updated_at":"2025-03-17T21:54:44.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":10457662,"change_date":"2024-08-16 21:39:00","inspection_id":"82405559","insp_unit_id":"202433281","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"C2304","insp_unit_license":"IY7891","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FUBCXFE4PHUA6729","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:21.000000Z","updated_at":"2025-03-17T23:31:21.000000Z"},{"id":10457663,"change_date":"2024-08-16 21:39:00","inspection_id":"82405559","insp_unit_id":"202433282","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRIPLEB","insp_unit_company":"8989","insp_unit_license":"GM5771","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1T9BA34132C178989","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:21.000000Z","updated_at":"2025-03-17T23:31:21.000000Z"}]},{"id":6118022,"change_date":"2024-07-01 21:44:00","inspection_id":"82009538","dot_number":"200275","report_state":"IA","report_number":"000P123D09","insp_date":"2024-06-28 00:00:00","insp_start_time":"0944","insp_end_time":"1029","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HIGHWAY 18 WB","county_code_state":"IA","county_code":"033","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"UNITED BEVERAGE","shipping_paper_number":"OWN","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-07-01 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"68000","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":"1319094","transaction_code":"A","transaction_date":"2024-07-01 00:00:00","upload_date":"2024-07-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00200275","upload_search_indicator":"M","census_search_date":"2024-07-01 21:44:00","snet_input_date":"2024-06-28 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-07-01 21:44:00","insp_carrier_name":"UNITEDBEVERAGE 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":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:23:49.000000Z","updated_at":"2025-03-17T20:23:49.000000Z","inspection_violations":[{"id":9497870,"change_date":"2024-07-01 21:44:00","inspection_id":"82009538","insp_violation_id":"260409041","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"201677503","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:56.000000Z","updated_at":"2025-03-17T21:51:56.000000Z","normalized_code":"39311"},{"id":9497871,"change_date":"2024-07-01 21:44:00","inspection_id":"82009538","insp_violation_id":"260409042","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:56.000000Z","updated_at":"2025-03-17T21:51:56.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":9854401,"change_date":"2024-07-01 21:44:00","inspection_id":"82009538","insp_unit_id":"201677503","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"C2006","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:25:05.000000Z","updated_at":"2025-03-17T23:25:05.000000Z"},{"id":9854402,"change_date":"2024-07-01 21:44:00","inspection_id":"82009538","insp_unit_id":"201677504","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:25:05.000000Z","updated_at":"2025-03-17T23:25:05.000000Z"}]},{"id":5551284,"change_date":"2024-04-23 21:41:00","inspection_id":"81395000","dot_number":"200275","report_state":"IA","report_number":"000P11H5P7","insp_date":"2024-04-18 00:00:00","insp_start_time":"0827","insp_end_time":"0838","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"57 AND ICE HOUSE","county_code_state":"IA","county_code":"013","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"UNITED BEVERAGE","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-04-19 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"72000","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":"1310034","transaction_code":"C","transaction_date":"2024-04-23 00:00:00","upload_date":"2024-04-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00200275","upload_search_indicator":"M","census_search_date":"2024-04-19 21:39:00","snet_input_date":"2024-04-18 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-04-19 21:39:00","insp_carrier_name":"UNITED BEVERAGES INC","insp_carrier_street":"2604 W AIRLINE HWY","insp_carrier_city":"WATERLOO","insp_carrier_state":"IA","insp_carrier_zip_code":"50703","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:12:46.000000Z","updated_at":"2025-03-17T20:12:46.000000Z","inspection_violations":[{"id":8578550,"change_date":"2024-04-23 21:41:00","inspection_id":"81395000","insp_violation_id":"259081731","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:32.000000Z","updated_at":"2025-03-17T21:47:32.000000Z","normalized_code":"39216A"},{"id":8578551,"change_date":"2024-04-23 21:41:00","inspection_id":"81395000","insp_violation_id":"259081732","seq_no":"2","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"200529943","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:32.000000Z","updated_at":"2025-03-17T21:47:32.000000Z","normalized_code":"39395A"},{"id":8578552,"change_date":"2024-04-23 21:41:00","inspection_id":"81395000","insp_violation_id":"259081733","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"200529944","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:32.000000Z","updated_at":"2025-03-17T21:47:32.000000Z","normalized_code":"3939A"},{"id":8578553,"change_date":"2024-04-23 21:41:00","inspection_id":"81395000","insp_violation_id":"259081734","seq_no":"4","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"200529943","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:32.000000Z","updated_at":"2025-03-17T21:47:32.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":8941691,"change_date":"2024-04-23 21:41:00","inspection_id":"81395000","insp_unit_id":"200529943","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"2001","insp_unit_license":"IY7742","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3AKBCXFE7LDLZ8551","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:12.000000Z","updated_at":"2025-03-17T23:16:12.000000Z"},{"id":8941692,"change_date":"2024-04-23 21:41:00","inspection_id":"81395000","insp_unit_id":"200529944","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CUSM","insp_unit_company":"T0906","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:16:12.000000Z","updated_at":"2025-03-17T23:16:12.000000Z"}]},{"id":4919903,"change_date":"2024-01-29 21:39:00","inspection_id":"80705545","dot_number":"200275","report_state":"IA","report_number":"000P12Q6ZD","insp_date":"2024-01-26 00:00:00","insp_start_time":"0710","insp_end_time":"0735","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"14TH AND INDUSTRIAL OELWEIN","county_code_state":"IA","county_code":"065","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"UNITED BEVERAGE","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":"2024-01-29 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"71000","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":"1300890","transaction_code":"A","transaction_date":"2024-01-29 00:00:00","upload_date":"2024-01-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00200275","upload_search_indicator":"M","census_search_date":"2024-01-29 21:39:00","snet_input_date":"2024-01-26 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-01-29 21:39:00","insp_carrier_name":"UNITEDBEVERAGE 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":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:00:05.000000Z","updated_at":"2025-03-17T20:00:05.000000Z","inspection_violations":[{"id":7578730,"change_date":"2024-01-29 21:39:00","inspection_id":"80705545","insp_violation_id":"257535643","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"46","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:33.000000Z","updated_at":"2025-03-17T21:42:33.000000Z","normalized_code":"3922"},{"id":7578731,"change_date":"2024-01-29 21:39:00","inspection_id":"80705545","insp_violation_id":"257535644","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"199147523","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:33.000000Z","updated_at":"2025-03-17T21:42:33.000000Z","normalized_code":"39617C"},{"id":7578732,"change_date":"2024-01-29 21:39:00","inspection_id":"80705545","insp_violation_id":"257535645","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199147522","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"2DRI24012607260","created_at":"2025-03-17T21:42:33.000000Z","updated_at":"2025-03-17T21:42:33.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7917104,"change_date":"2024-01-29 21:39:00","inspection_id":"80705545","insp_unit_id":"199147522","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"2302","insp_unit_license":"IY7781","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FUBCXFE2PHUA6728","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:46.000000Z","updated_at":"2025-03-17T23:06:46.000000Z"},{"id":7917105,"change_date":"2024-01-29 21:39:00","inspection_id":"80705545","insp_unit_id":"199147523","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MICK","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-17T23:06:46.000000Z","updated_at":"2025-03-17T23:06:46.000000Z"}]},{"id":4684682,"change_date":"2023-12-21 21:39:00","inspection_id":"80448800","dot_number":"200275","report_state":"IA","report_number":"000P123B2V","insp_date":"2023-12-15 00:00:00","insp_start_time":"1202","insp_end_time":"1217","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HIGHWAY 18","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":"2023-12-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"74500","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":"1297637","transaction_code":"A","transaction_date":"2023-12-20 00:00:00","upload_date":"2023-12-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00200275","upload_search_indicator":"M","census_search_date":"2023-12-21 21:39:00","snet_input_date":"2023-12-15 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-12-21 21:39:00","insp_carrier_name":"UNITEDBEVERAGE 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":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:55:45.000000Z","updated_at":"2025-03-17T19:55:45.000000Z","inspection_violations":[{"id":7238698,"change_date":"2023-12-21 21:39:00","inspection_id":"80448800","insp_violation_id":"257010628","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":"1LOP23121512082","created_at":"2025-03-17T21:40:56.000000Z","updated_at":"2025-03-17T21:40:56.000000Z","normalized_code":"39216A"},{"id":7238699,"change_date":"2023-12-21 21:39:00","inspection_id":"80448800","insp_violation_id":"257010629","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"198622562","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:56.000000Z","updated_at":"2025-03-17T21:40:56.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":7534861,"change_date":"2023-12-21 21:39:00","inspection_id":"80448800","insp_unit_id":"198622561","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"2303","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:03:20.000000Z","updated_at":"2025-03-17T23:03:20.000000Z"},{"id":7534862,"change_date":"2023-12-21 21:39:00","inspection_id":"80448800","insp_unit_id":"198622562","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HESS","insp_unit_company":"CT0903","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-17T23:03:20.000000Z","updated_at":"2025-03-17T23:03:20.000000Z"}]},{"id":2954475,"change_date":"2023-05-03 21:41:00","inspection_id":"78518978","dot_number":"200275","report_state":"IA","report_number":"000TT87GRX","insp_date":"2023-05-02 00:00:00","insp_start_time":"0915","insp_end_time":"0940","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 150\/165TH ST FAYETTE","county_code_state":"IA","county_code":"065","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"UNITED BEVERAGE LLC","shipping_paper_number":"BEVERAGE","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-05-03 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"69000","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":"1273489","transaction_code":"A","transaction_date":"2023-05-03 00:00:00","upload_date":"2023-05-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00200275","upload_search_indicator":"M","census_search_date":"2023-05-03 21:41:00","snet_input_date":"2023-05-02 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-05-03 21:41:00","insp_carrier_name":"UNITEDBEVERAGE 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":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:21:24.000000Z","updated_at":"2025-03-17T19:21:24.000000Z","inspection_violations":[{"id":4534645,"change_date":"2023-05-03 21:41:00","inspection_id":"78518978","insp_violation_id":"252592280","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:28:07.000000Z","updated_at":"2025-03-17T21:28:07.000000Z","normalized_code":"3922"},{"id":4534646,"change_date":"2023-05-03 21:41:00","inspection_id":"78518978","insp_violation_id":"252592281","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"194725210","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:07.000000Z","updated_at":"2025-03-17T21:28:07.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":4753937,"change_date":"2023-05-03 21:41:00","inspection_id":"78518978","insp_unit_id":"194725209","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"C2304","insp_unit_license":"IY7891","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FUBCXFE4PHUA6729","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:28.000000Z","updated_at":"2025-03-17T22:40:28.000000Z"},{"id":4753938,"change_date":"2023-05-03 21:41:00","inspection_id":"78518978","insp_unit_id":"194725210","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRIPLEB","insp_unit_company":"CTCT0201","insp_unit_license":"GM5771","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1T9BA34132C178989","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:28.000000Z","updated_at":"2025-03-17T22:40:28.000000Z"}]},{"id":1696397,"change_date":"2022-11-08 21:38:00","inspection_id":"77084286","dot_number":"200275","report_state":"IA","report_number":"000TT8BC77","insp_date":"2022-11-02 00:00:00","insp_start_time":"1039","insp_end_time":"1100","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 14 NB\/270TH ST","county_code_state":"IA","county_code":"067","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"UNITED BEVERAGE","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":"2022-11-08 21:38: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":"1250207","transaction_code":"A","transaction_date":"2022-11-08 00:00:00","upload_date":"2022-11-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00200275","upload_search_indicator":"M","census_search_date":"2022-11-08 21:38:00","snet_input_date":"2022-11-02 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-11-08 21:38:00","insp_carrier_name":"UNITED BEVERAGE LLC","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":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:57:48.000000Z","updated_at":"2025-03-17T18:57:48.000000Z","inspection_violations":[{"id":2658770,"change_date":"2022-11-08 21:38:00","inspection_id":"77084286","insp_violation_id":"249490106","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:30.000000Z","updated_at":"2025-03-17T21:19:30.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2729183,"change_date":"2022-11-08 21:38:00","inspection_id":"77084286","insp_unit_id":"191858603","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"IY7746","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3AKBCXFE7PDUC7743","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:41.000000Z","updated_at":"2025-03-17T22:25:41.000000Z"},{"id":2729184,"change_date":"2022-11-08 21:38:00","inspection_id":"77084286","insp_unit_id":"191858604","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"T0905","insp_unit_license":"GZ3951","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GRAA96239B702867","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:41.000000Z","updated_at":"2025-03-17T22:25:41.000000Z"}]},{"id":604020,"change_date":"2022-06-14 21:42:00","inspection_id":"75813181","dot_number":"200275","report_state":"IA","report_number":"000TT83KPQ","insp_date":"2022-06-13 00:00:00","insp_start_time":"1304","insp_end_time":"1320","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"B-20 EB 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":"UNITED BEVERAGE LLC","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":"2022-06-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"4","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1228849","transaction_code":"A","transaction_date":"2022-06-14 00:00:00","upload_date":"2022-06-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00200275","upload_search_indicator":"M","census_search_date":"2022-06-14 21:42:00","snet_input_date":"2022-06-13 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-06-14 21:42:00","insp_carrier_name":"UNITED BEVERAGE LLC","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":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:38:25.000000Z","updated_at":"2025-03-17T18:38:25.000000Z","inspection_violations":[{"id":948251,"change_date":"2022-06-14 21:42:00","inspection_id":"75813181","insp_violation_id":"246444564","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:11:27.000000Z","updated_at":"2025-03-17T21:11:27.000000Z","normalized_code":"3922"},{"id":948252,"change_date":"2022-06-14 21:42:00","inspection_id":"75813181","insp_violation_id":"246444565","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"189233752","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:27.000000Z","updated_at":"2025-03-17T21:11:27.000000Z","normalized_code":"39617C"},{"id":948253,"change_date":"2022-06-14 21:42:00","inspection_id":"75813181","insp_violation_id":"246444566","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:27.000000Z","updated_at":"2025-03-17T21:11:27.000000Z","normalized_code":"3922"},{"id":948254,"change_date":"2022-06-14 21:42:00","inspection_id":"75813181","insp_violation_id":"246444567","seq_no":"4","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"189233752","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:27.000000Z","updated_at":"2025-03-17T21:11:27.000000Z","normalized_code":"39021TB"}],"inspection_per_units":[{"id":970905,"change_date":"2022-06-14 21:42:00","inspection_id":"75813181","insp_unit_id":"189233752","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"C1102","insp_unit_license":"FB0521","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3HSCUAPR6BN186303","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:10.000000Z","updated_at":"2025-03-17T22:14:10.000000Z"},{"id":970906,"change_date":"2022-06-14 21:42:00","inspection_id":"75813181","insp_unit_id":"189233753","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"487003","insp_unit_license":"PT0345V","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"1UYVS2531DM581006","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:10.000000Z","updated_at":"2025-03-17T22:14:10.000000Z"}]},{"id":563927,"change_date":"2022-06-08 21:40:00","inspection_id":"75765077","dot_number":"200275","report_state":"IA","report_number":"000TT71S73","insp_date":"2022-06-07 00:00:00","insp_start_time":"1325","insp_end_time":"1334","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 3 AND 218 SOUTH","county_code_state":"IA","county_code":"017","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":"2022-06-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"101000","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":"1228315","transaction_code":"A","transaction_date":"2022-06-08 00:00:00","upload_date":"2022-06-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00200275","upload_search_indicator":"M","census_search_date":"2022-06-08 21:40:00","snet_input_date":"2022-06-07 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-06-08 21:40:00","insp_carrier_name":"UNITED BEVERAGE LLC","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":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:37:44.000000Z","updated_at":"2025-03-17T18:37:44.000000Z","inspection_violations":[{"id":885888,"change_date":"2022-06-08 21:40:00","inspection_id":"75765077","insp_violation_id":"246302089","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:11.000000Z","updated_at":"2025-03-17T21:11:11.000000Z","normalized_code":"39216A"},{"id":885889,"change_date":"2022-06-08 21:40:00","inspection_id":"75765077","insp_violation_id":"246302090","seq_no":"2","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:11:11.000000Z","updated_at":"2025-03-17T21:11:11.000000Z","normalized_code":"39216B"}],"inspection_per_units":[{"id":907228,"change_date":"2022-06-08 21:40:00","inspection_id":"75765077","insp_unit_id":"189115756","insp_unit_type_id":"9","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"IV3902","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3AKBCXFE7PDUC7743","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:47.000000Z","updated_at":"2025-03-17T22:13:47.000000Z"},{"id":907229,"change_date":"2022-06-08 21:40:00","inspection_id":"75765077","insp_unit_id":"189115757","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"GZ3951","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GRAA96239B702867","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:47.000000Z","updated_at":"2025-03-17T22:13:47.000000Z"}]},{"id":277086,"change_date":"2022-04-28 21:39:00","inspection_id":"75423595","dot_number":"200275","report_state":"IA","report_number":"000TT71S3M","insp_date":"2022-04-27 00:00:00","insp_start_time":"0646","insp_end_time":"0655","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"LINCON ST AND LEVERSEE RD","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":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-28 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"101000","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":"1222529","transaction_code":"A","transaction_date":"2022-04-28 00:00:00","upload_date":"2022-04-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00200275","upload_search_indicator":"M","census_search_date":"2022-04-28 21:39:00","snet_input_date":"2022-04-27 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-04-28 21:39:00","insp_carrier_name":"UNITED BEVERAGE LLC","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":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:32:16.000000Z","updated_at":"2025-03-17T18:32:16.000000Z","inspection_violations":[{"id":429176,"change_date":"2022-04-28 21:39:00","inspection_id":"75423595","insp_violation_id":"245441990","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"188396703","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:05.000000Z","updated_at":"2025-03-17T21:09:05.000000Z","normalized_code":"3922"},{"id":429177,"change_date":"2022-04-28 21:39:00","inspection_id":"75423595","insp_violation_id":"245441991","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"188396703","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:05.000000Z","updated_at":"2025-03-17T21:09:05.000000Z","normalized_code":"3922"},{"id":429178,"change_date":"2022-04-28 21:39:00","inspection_id":"75423595","insp_violation_id":"245441992","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"188396704","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:05.000000Z","updated_at":"2025-03-17T21:09:05.000000Z","normalized_code":"39617C"},{"id":429179,"change_date":"2022-04-28 21:39:00","inspection_id":"75423595","insp_violation_id":"245441993","seq_no":"4","part_no":"391","part_no_section":"45(b)","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:05.000000Z","updated_at":"2025-03-17T21:09:05.000000Z","normalized_code":"39145B"}],"inspection_per_units":[{"id":448535,"change_date":"2022-04-28 21:39:00","inspection_id":"75423595","insp_unit_id":"188396703","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"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:10:57.000000Z","updated_at":"2025-03-17T22:10:57.000000Z"},{"id":448536,"change_date":"2022-04-28 21:39:00","inspection_id":"75423595","insp_unit_id":"188396704","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"GZ3951","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GRAA96239B702867","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:57.000000Z","updated_at":"2025-03-17T22:10:57.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/200275\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/200275\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/200275\/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\/200275\/inspections","per_page":100,"prev_page_url":null,"to":19,"total":19}