{"current_page":1,"data":[{"id":10904947,"change_date":"2026-02-02 21:38:00","inspection_id":"86936593","dot_number":"437159","report_state":"MS","report_number":"MC00512459","insp_date":"2026-01-28 00:00:00","insp_start_time":"0839","insp_end_time":"0911","registration_date":null,"region":"ET","ci_status_code":"C","location":"75","location_desc":"I-20 W","county_code_state":"MS","county_code":"149","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"CAPITOL CITY BEVERAGE COMPANY INC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-02-02 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":null,"viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1137680","transaction_code":"A","transaction_date":"2026-01-28 00:00:00","upload_date":"2026-02-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00437159","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-02-02 00:00:00","source_office":"2MSS002","mcmis_add_date":"2026-02-02 21:38:00","insp_carrier_name":"CAPITOL CITY BEVERAGE COMPANY INC","insp_carrier_street":"920 W COUNTY LINE RD.","insp_carrier_city":"JACKSON","insp_carrier_state":"MS","insp_carrier_zip_code":"39213","insp_colonia":null,"docket_number":"518251","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-05T10:35:41.000000Z","updated_at":"2026-02-13T10:30:30.000000Z","inspection_violations":[{"id":18264225,"change_date":"2026-02-02 21:38:00","inspection_id":"86936593","insp_violation_id":"271545612","seq_no":"1","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"211393491","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-05T10:45:19.000000Z","updated_at":"2026-02-13T10:38:50.000000Z","normalized_code":"39021TB1MC"},{"id":18264226,"change_date":"2026-02-02 21:38:00","inspection_id":"86936593","insp_violation_id":"271545613","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"211393491","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-05T10:45:19.000000Z","updated_at":"2026-02-13T10:38:50.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":18336636,"change_date":"2026-02-02 21:38:00","inspection_id":"86936593","insp_unit_id":"211393491","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"B2628451","insp_unit_license_state":"MS","insp_unit_vehicle_id_number":"54DK6S1F1SSA02397","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-05T10:08:40.000000Z","updated_at":"2026-02-13T10:05:03.000000Z"}]},{"id":9511877,"change_date":"2025-08-26 21:40:00","inspection_id":"85597165","dot_number":"437159","report_state":"MI","report_number":"POWEL04010","insp_date":"2025-08-26 00:00:00","insp_start_time":"0520","insp_end_time":"0551","registration_date":null,"region":"ET","ci_status_code":"C","location":"121","location_desc":"FOWLERVILLE SCALE E\/B","county_code_state":"MI","county_code":"093","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAME","shipping_paper_number":"88645","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-08-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":"1238196","transaction_code":"A","transaction_date":"2025-08-26 00:00:00","upload_date":"2025-08-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00437159","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-08-26 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-08-26 21:40:00","insp_carrier_name":"CAPITOL BEVERAGE COMPANY INC","insp_carrier_street":"5500 AURELIUS RD","insp_carrier_city":"LANSING","insp_carrier_state":"MI","insp_carrier_zip_code":"48911","insp_colonia":null,"docket_number":"518251","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-29T10:43:07.000000Z","updated_at":"2025-09-05T10:46:46.000000Z","inspection_violations":[{"id":15516288,"change_date":"2025-08-26 21:40:00","inspection_id":"85597165","insp_violation_id":"268261443","seq_no":"1","part_no":"393","part_no_section":"11A1-LRLM","insp_viol_unit":"1","insp_unit_id":"208593628","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-05T10:49:52.000000Z","updated_at":"2025-09-05T10:49:52.000000Z","normalized_code":"39311A1LRLM"}],"inspection_per_units":[{"id":15696045,"change_date":"2025-08-26 21:40:00","inspection_id":"85597165","insp_unit_id":"208593628","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"520","insp_unit_license":"RB98700","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJAXFM8LPLV7574","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-29T09:46:42.000000Z","updated_at":"2025-09-05T09:46:09.000000Z"},{"id":15696046,"change_date":"2025-08-26 21:40:00","inspection_id":"85597165","insp_unit_id":"208593629","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRIM","insp_unit_company":null,"insp_unit_license":"D576365","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2MN01JAH441007078","insp_unit_decal":"Y","insp_unit_decal_number":"35457189","created_at":"2025-08-29T09:46:42.000000Z","updated_at":"2025-09-05T09:46:09.000000Z"}]},{"id":8034962,"change_date":"2025-03-05 21:40:00","inspection_id":"84040562","dot_number":"437159","report_state":"MI","report_number":"BURGM06563","insp_date":"2025-03-03 00:00:00","insp_start_time":"1325","insp_end_time":"1402","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"PACKRD HWY","county_code_state":"MI","county_code":"045","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"1224418","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1211873","transaction_code":"A","transaction_date":"2025-03-03 00:00:00","upload_date":"2025-03-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00437159","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-03-03 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-03-05 21:40:00","insp_carrier_name":"CAPITOL BEVERAGE COMPANY INC","insp_carrier_street":"5500 AURELIUS RD","insp_carrier_city":"LANSING","insp_carrier_state":"MI","insp_carrier_zip_code":"48911","insp_colonia":null,"docket_number":"518251","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:04:58.000000Z","updated_at":"2025-03-17T21:04:58.000000Z","inspection_violations":[{"id":12556507,"change_date":"2025-03-05 21:40:00","inspection_id":"84040562","insp_violation_id":"264849592","seq_no":"1","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"205642211","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:22.000000Z","updated_at":"2025-03-17T22:07:22.000000Z","normalized_code":"3939ALIL"},{"id":12556508,"change_date":"2025-03-05 21:40:00","inspection_id":"84040562","insp_violation_id":"264849593","seq_no":"2","part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"1","insp_unit_id":"205642211","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:22.000000Z","updated_at":"2025-03-17T22:07:22.000000Z","normalized_code":"3939ALRLI"},{"id":12556509,"change_date":"2025-03-05 21:40:00","inspection_id":"84040562","insp_violation_id":"264849594","seq_no":"3","part_no":"393","part_no_section":"25A-L","insp_viol_unit":"1","insp_unit_id":"205642211","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:22.000000Z","updated_at":"2025-03-17T22:07:22.000000Z","normalized_code":"39325AL"}],"inspection_per_units":[{"id":12971904,"change_date":"2025-03-05 21:40:00","inspection_id":"84040562","insp_unit_id":"205642211","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"BK505","insp_unit_license":"BC95332","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FUJA6CK25LN37565","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:58:18.000000Z","updated_at":"2025-03-17T23:58:18.000000Z"},{"id":12971905,"change_date":"2025-03-05 21:40:00","inspection_id":"84040562","insp_unit_id":"205642212","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STRI","insp_unit_company":"48120","insp_unit_license":"E165213","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1S12E9488LE542625","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:58:18.000000Z","updated_at":"2025-03-17T23:58:18.000000Z"}]},{"id":7535375,"change_date":"2025-01-14 21:55:00","inspection_id":"83515895","dot_number":"437159","report_state":"MI","report_number":"HICKG02785","insp_date":"2024-12-31 00:00:00","insp_start_time":"0905","insp_end_time":"0920","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M-21 @ MAIN STREET","county_code_state":"MI","county_code":"037","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"001","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-02 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"102000","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":"1205438","transaction_code":"C","transaction_date":"2024-12-31 00:00:00","upload_date":"2025-01-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00437159","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-12-31 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-01-02 21:39:00","insp_carrier_name":"CAPITOL BEVERAGE COMPANY INC","insp_carrier_street":"5500 AURELIUS RD","insp_carrier_city":"LANSING","insp_carrier_state":"MI","insp_carrier_zip_code":"48911","insp_colonia":null,"docket_number":"518251","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":11776463,"change_date":"2025-01-14 21:55:00","inspection_id":"83515895","insp_violation_id":"263995996","seq_no":"1","part_no":"392","part_no_section":"2-SLLTCD","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:22.000000Z","updated_at":"2025-03-17T22:03:22.000000Z","normalized_code":"3922SLLTCD"}],"inspection_per_units":[{"id":12157005,"change_date":"2025-01-14 21:55:00","inspection_id":"83515895","insp_unit_id":"204828778","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BD12224","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FUBCYBSXDHBW9927","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":12157006,"change_date":"2025-01-14 21:55:00","inspection_id":"83515895","insp_unit_id":"204828779","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HACK","insp_unit_company":null,"insp_unit_license":"E185169","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"526114622D100014","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":6539118,"change_date":"2024-09-17 21:45:00","inspection_id":"82460251","dot_number":"437159","report_state":"MI","report_number":"POWEL03679","insp_date":"2024-08-20 00:00:00","insp_start_time":"0745","insp_end_time":"0810","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"GRANDRIVER RD@ M-59","county_code_state":"MI","county_code":"093","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-22 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"118200","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":"1191287","transaction_code":"C","transaction_date":"2024-08-20 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00437159","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-08-20 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-08-22 21:42:00","insp_carrier_name":"CAPITOL BEVERAGE COMPANY INC","insp_carrier_street":"5500 AURELIUS RD","insp_carrier_city":"LANSING","insp_carrier_state":"MI","insp_carrier_zip_code":"48911","insp_colonia":null,"docket_number":"518251","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:32:24.000000Z","updated_at":"2025-03-17T20:32:24.000000Z","inspection_violations":[{"id":10158214,"change_date":"2024-09-17 21:45:00","inspection_id":"82460251","insp_violation_id":"261870933","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202984810","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:07.000000Z","updated_at":"2025-03-17T21:55:07.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":10541501,"change_date":"2024-09-17 21:45:00","inspection_id":"82460251","insp_unit_id":"202984810","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"520","insp_unit_license":"RB98700","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJAXFM8LPLV7574","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:11.000000Z","updated_at":"2025-03-17T23:32:11.000000Z"},{"id":10541502,"change_date":"2024-09-17 21:45:00","inspection_id":"82460251","insp_unit_id":"202984811","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRIM","insp_unit_company":null,"insp_unit_license":"D576365","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2MN01JAH441007078","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:11.000000Z","updated_at":"2025-03-17T23:32:11.000000Z"}]},{"id":6084273,"change_date":"2024-06-26 21:43:00","inspection_id":"81973300","dot_number":"437159","report_state":"MI","report_number":"MOREM05350","insp_date":"2024-06-25 00:00:00","insp_start_time":"1652","insp_end_time":"1725","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"DAVIS HWY","county_code_state":"MI","county_code":"045","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"TRENTON BREWERY","shipping_paper_number":"0503463528","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-26 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1183783","transaction_code":"A","transaction_date":"2024-06-25 00:00:00","upload_date":"2024-06-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00437159","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-06-25 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-06-26 21:43:00","insp_carrier_name":"CAPITOL BEVERAGE COMPANY INC","insp_carrier_street":"5500 AURELIUS RD","insp_carrier_city":"LANSING","insp_carrier_state":"MI","insp_carrier_zip_code":"48911","insp_colonia":null,"docket_number":"518251","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:23:21.000000Z","updated_at":"2025-03-17T20:23:21.000000Z","inspection_violations":[{"id":9442068,"change_date":"2024-06-26 21:43:00","inspection_id":"81973300","insp_violation_id":"260329385","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:43.000000Z","updated_at":"2025-03-17T21:51:43.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9799705,"change_date":"2024-06-26 21:43:00","inspection_id":"81973300","insp_unit_id":"201607240","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"916","insp_unit_license":"RC24459","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKYD49X0GJ117133","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:28.000000Z","updated_at":"2025-03-17T23:24:28.000000Z"},{"id":9799706,"change_date":"2024-06-26 21:43:00","inspection_id":"81973300","insp_unit_id":"201607241","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"53119","insp_unit_license":"D980448","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532C3KR770005","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:28.000000Z","updated_at":"2025-03-17T23:24:28.000000Z"}]},{"id":6586605,"change_date":"2024-08-28 21:43:00","inspection_id":"82510791","dot_number":"437159","report_state":"MI","report_number":"SILKS04072","insp_date":"2024-06-18 00:00:00","insp_start_time":"1305","insp_end_time":"1335","registration_date":null,"region":"ET","ci_status_code":"C","location":"591","location_desc":"COLDWATER SCALE","county_code_state":"MI","county_code":"023","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-28 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1192508","transaction_code":"A","transaction_date":"2024-06-18 00:00:00","upload_date":"2024-08-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00437159","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-06-18 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-08-28 21:43:00","insp_carrier_name":"CAPITOL BEVERAGE COMPANY INC","insp_carrier_street":"5500 AURELIUS RD","insp_carrier_city":"LANSING","insp_carrier_state":"MI","insp_carrier_zip_code":"48911","insp_colonia":null,"docket_number":"518251","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:33:38.000000Z","updated_at":"2025-03-17T20:33:38.000000Z","inspection_violations":[{"id":10240545,"change_date":"2024-08-28 21:43:00","inspection_id":"82510791","insp_violation_id":"261467823","seq_no":"1","part_no":"393","part_no_section":"75(a)","insp_viol_unit":"1","insp_unit_id":"202633188","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:55:36.000000Z","updated_at":"2025-03-17T21:55:36.000000Z","normalized_code":"39375A"}],"inspection_per_units":[{"id":10618786,"change_date":"2024-08-28 21:43:00","inspection_id":"82510791","insp_unit_id":"202633188","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"RC26764","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKYD49X0RJ328268","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:58.000000Z","updated_at":"2025-03-17T23:32:58.000000Z"},{"id":10618787,"change_date":"2024-08-28 21:43:00","inspection_id":"82510791","insp_unit_id":"202633189","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":null,"insp_unit_license":"E329968","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1JJV532D8CL570041","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:58.000000Z","updated_at":"2025-03-17T23:32:58.000000Z"}]},{"id":5248642,"change_date":"2024-03-09 21:31:00","inspection_id":"81064564","dot_number":"437159","report_state":"OH","report_number":"1516012728","insp_date":"2024-03-08 00:00:00","insp_start_time":"0820","insp_end_time":"0844","registration_date":null,"region":"ET","ci_status_code":"C","location":"06375","location_desc":"FINDLAY SCALES","county_code_state":"OH","county_code":"063","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"O & W INC","shipping_paper_number":"118183785","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2024-03-09 21:31:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1710500","transaction_code":"A","transaction_date":"2024-03-08 00:00:00","upload_date":"2024-03-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00437159","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-03-09 00:00:00","source_office":"3OHS001","mcmis_add_date":"2024-03-09 21:31:00","insp_carrier_name":"CAPITOL BEVERAGE COMPANY INC","insp_carrier_street":"5500 AURELIUS RD","insp_carrier_city":"LANSING","insp_carrier_state":"MI","insp_carrier_zip_code":"48911-4120","insp_colonia":null,"docket_number":"518251","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:06:40.000000Z","updated_at":"2025-03-17T20:06:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8451589,"change_date":"2024-03-09 21:31:00","inspection_id":"81064564","insp_unit_id":"199832653","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"524","insp_unit_license":"RC26764","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKYD49X0RJ328268","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:35.000000Z","updated_at":"2025-03-17T23:11:35.000000Z"},{"id":8451590,"change_date":"2024-03-09 21:31:00","inspection_id":"81064564","insp_unit_id":"199832654","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"274085","insp_unit_license":"E329969","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1JJV532D7CL570046","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:35.000000Z","updated_at":"2025-03-17T23:11:35.000000Z"}]},{"id":5089397,"change_date":"2024-02-20 21:42:00","inspection_id":"80891111","dot_number":"437159","report_state":"MI","report_number":"LULAN02279","insp_date":"2024-02-19 00:00:00","insp_start_time":"0910","insp_end_time":"0940","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"S\/B US-23 @ MICHIGAN","county_code_state":"MI","county_code":"161","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MOLSON COORS BEVERAGE COMPANY","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-20 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1165367","transaction_code":"A","transaction_date":"2024-02-19 00:00:00","upload_date":"2024-02-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00437159","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-02-19 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-02-20 21:42:00","insp_carrier_name":"CAPITOL BEVERAGE COMPANY INC","insp_carrier_street":"5500 AURELIUS RD","insp_carrier_city":"LANSING","insp_carrier_state":"MI","insp_carrier_zip_code":"48911","insp_colonia":null,"docket_number":"518251","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:03:28.000000Z","updated_at":"2025-03-17T20:03:28.000000Z","inspection_violations":[{"id":7845198,"change_date":"2024-02-20 21:42:00","inspection_id":"80891111","insp_violation_id":"257925090","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"41","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4335645","created_at":"2025-03-17T21:43:56.000000Z","updated_at":"2025-03-17T21:43:56.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8193498,"change_date":"2024-02-20 21:42:00","inspection_id":"80891111","insp_unit_id":"199502091","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"916","insp_unit_license":"RC24459","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKYD49X0GJ117133","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:15.000000Z","updated_at":"2025-03-17T23:09:15.000000Z"},{"id":8193499,"change_date":"2024-02-20 21:42:00","inspection_id":"80891111","insp_unit_id":"199502092","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"53119","insp_unit_license":"D980448","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532C3KR770005","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:15.000000Z","updated_at":"2025-03-17T23:09:15.000000Z"}]},{"id":4998043,"change_date":"2024-02-07 21:41:00","inspection_id":"80791202","dot_number":"437159","report_state":"MI","report_number":"MOREM05018","insp_date":"2024-02-06 00:00:00","insp_start_time":"1418","insp_end_time":"1448","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"DAVIS HWY","county_code_state":"MI","county_code":"045","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MOLSON COORS","shipping_paper_number":"12149168","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-02-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","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":"1163602","transaction_code":"A","transaction_date":"2024-02-06 00:00:00","upload_date":"2024-02-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00437159","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-02-06 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-02-07 21:41:00","insp_carrier_name":"CAPITOL BEVERAGE COMPANY INC","insp_carrier_street":"5500 AURELIUS RD","insp_carrier_city":"LANSING","insp_carrier_state":"MI","insp_carrier_zip_code":"48911","insp_colonia":null,"docket_number":"518251","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:01:41.000000Z","updated_at":"2025-03-17T20:01:41.000000Z","inspection_violations":[{"id":7698426,"change_date":"2024-02-07 21:41:00","inspection_id":"80791202","insp_violation_id":"257712429","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":"X4332968","created_at":"2025-03-17T21:43:09.000000Z","updated_at":"2025-03-17T21:43:09.000000Z","normalized_code":"3922"},{"id":7698427,"change_date":"2024-02-07 21:41:00","inspection_id":"80791202","insp_violation_id":"257712430","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:09.000000Z","updated_at":"2025-03-17T21:43:09.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8044578,"change_date":"2024-02-07 21:41:00","inspection_id":"80791202","insp_unit_id":"199312568","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"524","insp_unit_license":"RC26764","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKYD49X0RJ328268","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:53.000000Z","updated_at":"2025-03-17T23:07:53.000000Z"},{"id":8044579,"change_date":"2024-02-07 21:41:00","inspection_id":"80791202","insp_unit_id":"199312569","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"274077","insp_unit_license":"E329967","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1JJV532D8CL570038","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:53.000000Z","updated_at":"2025-03-17T23:07:53.000000Z"}]},{"id":3974415,"change_date":"2023-09-14 21:41:00","inspection_id":"79664427","dot_number":"437159","report_state":"MI","report_number":"DELMT00780","insp_date":"2023-09-13 00:00:00","insp_start_time":"1710","insp_end_time":"1850","registration_date":null,"region":"ET","ci_status_code":"C","location":"132","location_desc":"GRASS LAKE SCALE W\/B","county_code_state":"MI","county_code":"075","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"TRENTON BREWERY","shipping_paper_number":"12011072","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-09-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"7","oos_total":"3","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1145921","transaction_code":"A","transaction_date":"2023-09-13 00:00:00","upload_date":"2023-09-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00437159","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-09-13 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-09-14 21:41:00","insp_carrier_name":"CAPITOL BEVERAGE COMPANY INC","insp_carrier_street":"5500 AURELIUS RD","insp_carrier_city":"LANSING","insp_carrier_state":"MI","insp_carrier_zip_code":"48911","insp_colonia":null,"docket_number":"518251","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:41:14.000000Z","updated_at":"2025-03-17T19:41:14.000000Z","inspection_violations":[{"id":6146658,"change_date":"2023-09-14 21:41:00","inspection_id":"79664427","insp_violation_id":"255270642","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:35:43.000000Z","updated_at":"2025-03-17T21:35:43.000000Z","normalized_code":"38371H"},{"id":6146659,"change_date":"2023-09-14 21:41:00","inspection_id":"79664427","insp_violation_id":"255270643","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"197057757","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4271630","created_at":"2025-03-17T21:35:43.000000Z","updated_at":"2025-03-17T21:35:43.000000Z","normalized_code":"3963A1"},{"id":6146660,"change_date":"2023-09-14 21:41:00","inspection_id":"79664427","insp_violation_id":"255270644","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"197057757","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4271630","created_at":"2025-03-17T21:35:43.000000Z","updated_at":"2025-03-17T21:35:43.000000Z","normalized_code":"3963A1"},{"id":6146661,"change_date":"2023-09-14 21:41:00","inspection_id":"79664427","insp_violation_id":"255270645","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"197057757","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4271630","created_at":"2025-03-17T21:35:43.000000Z","updated_at":"2025-03-17T21:35:43.000000Z","normalized_code":"3963A1"},{"id":6146662,"change_date":"2023-09-14 21:41:00","inspection_id":"79664427","insp_violation_id":"255270646","seq_no":"5","part_no":"393","part_no_section":"75(a)(2)","insp_viol_unit":"2","insp_unit_id":"197057757","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:43.000000Z","updated_at":"2025-03-17T21:35:43.000000Z","normalized_code":"39375A2"},{"id":6146663,"change_date":"2023-09-14 21:41:00","inspection_id":"79664427","insp_violation_id":"255270647","seq_no":"6","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"197057757","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:43.000000Z","updated_at":"2025-03-17T21:35:43.000000Z","normalized_code":"39311"},{"id":6146664,"change_date":"2023-09-14 21:41:00","inspection_id":"79664427","insp_violation_id":"255270648","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197057756","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:43.000000Z","updated_at":"2025-03-17T21:35:43.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":6390728,"change_date":"2023-09-14 21:41:00","inspection_id":"79664427","insp_unit_id":"197057756","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"916","insp_unit_license":"RC24459","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKYD49X0GJ117133","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:41.000000Z","updated_at":"2025-03-17T22:53:41.000000Z"},{"id":6390729,"change_date":"2023-09-14 21:41:00","inspection_id":"79664427","insp_unit_id":"197057757","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"53104","insp_unit_license":"B595516","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1DW1A53254B678906","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:41.000000Z","updated_at":"2025-03-17T22:53:41.000000Z"}]},{"id":2141624,"change_date":"2023-01-13 21:40:00","inspection_id":"77593997","dot_number":"437159","report_state":"OH","report_number":"3270014366","insp_date":"2023-01-13 00:00:00","insp_start_time":"0822","insp_end_time":"0843","registration_date":null,"region":"ET","ci_status_code":"C","location":"06375","location_desc":"FINDLAY SCALES","county_code_state":"OH","county_code":"063","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"O W INC","shipping_paper_number":"112331143","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-01-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1635008","transaction_code":"A","transaction_date":"2023-01-13 00:00:00","upload_date":"2023-01-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00437159","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-01-13 00:00:00","source_office":"3OHS001","mcmis_add_date":"2023-01-13 21:40:00","insp_carrier_name":"CAPITOL BEVERAGE COMPANY INC","insp_carrier_street":"5500 AURELIUS RD","insp_carrier_city":"LANSING","insp_carrier_state":"MI","insp_carrier_zip_code":"48911-4120","insp_colonia":null,"docket_number":"518251","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:06:13.000000Z","updated_at":"2025-03-17T19:06:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3446616,"change_date":"2023-01-13 21:40:00","inspection_id":"77593997","insp_unit_id":"192869293","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"816","insp_unit_license":"RB29322","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKYD49X9GJ117132","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:42.000000Z","updated_at":"2025-03-17T22:30:42.000000Z"},{"id":3446617,"change_date":"2023-01-13 21:40:00","inspection_id":"77593997","insp_unit_id":"192869294","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"1","insp_unit_license":"D980449","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532C0KR770009","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:42.000000Z","updated_at":"2025-03-17T22:30:42.000000Z"}]},{"id":922347,"change_date":"2022-07-29 21:39:00","inspection_id":"76186940","dot_number":"437159","report_state":"OH","report_number":"1516011992","insp_date":"2022-07-29 00:00:00","insp_start_time":"0820","insp_end_time":"0841","registration_date":null,"region":"ET","ci_status_code":"C","location":"06375","location_desc":"FINDLAY SCALES","county_code_state":"OH","county_code":"063","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"O & W INC","shipping_paper_number":"110763274","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-07-29 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1609152","transaction_code":"A","transaction_date":"2022-07-29 00:00:00","upload_date":"2022-07-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00437159","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-07-29 00:00:00","source_office":"3OHS001","mcmis_add_date":"2022-07-29 21:39:00","insp_carrier_name":"CAPITOL BEVERAGE COMPANY INC","insp_carrier_street":"5500 AURELIUS RD","insp_carrier_city":"LANSING","insp_carrier_state":"MI","insp_carrier_zip_code":"48911-4120","insp_colonia":null,"docket_number":"518251","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:44:01.000000Z","updated_at":"2025-03-17T18:44:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1484871,"change_date":"2022-07-29 21:39:00","inspection_id":"76186940","insp_unit_id":"190037179","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"816","insp_unit_license":"RB29322","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKYD49X9GJ117132","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:19.000000Z","updated_at":"2025-03-17T22:17:19.000000Z"},{"id":1484872,"change_date":"2022-07-29 21:39:00","inspection_id":"76186940","insp_unit_id":"190037180","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"53219","insp_unit_license":"D980449","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532C0KR770009","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:19.000000Z","updated_at":"2025-03-17T22:17:19.000000Z"}]},{"id":627782,"change_date":"2022-06-16 21:43:00","inspection_id":"75841281","dot_number":"437159","report_state":"MI","report_number":"POWEL02643","insp_date":"2022-06-15 00:00:00","insp_start_time":"0850","insp_end_time":"0907","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"GRANDRIVER @ BURKHART","county_code_state":"MI","county_code":"093","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","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":"2022-06-16 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"118200","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":"1080218","transaction_code":"A","transaction_date":"2022-06-15 00:00:00","upload_date":"2022-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00437159","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-06-15 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-06-16 21:43:00","insp_carrier_name":"CAPITOL BEVERAGE COMPANY INC","insp_carrier_street":"5500 AURELIUS RD","insp_carrier_city":"LANSING","insp_carrier_state":"MI","insp_carrier_zip_code":"48911","insp_colonia":null,"docket_number":"518251","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:38:48.000000Z","updated_at":"2025-03-17T18:38:48.000000Z","inspection_violations":[{"id":984353,"change_date":"2022-06-16 21:43:00","inspection_id":"75841281","insp_violation_id":"246516141","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"189294978","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:37.000000Z","updated_at":"2025-03-17T21:11:37.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1008985,"change_date":"2022-06-16 21:43:00","inspection_id":"75841281","insp_unit_id":"189294978","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"220","insp_unit_license":"BC44607","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FUBCYFE7LHLJ6625","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:23.000000Z","updated_at":"2025-03-17T22:14:23.000000Z"},{"id":1008986,"change_date":"2022-06-16 21:43:00","inspection_id":"75841281","insp_unit_id":"189294979","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HACK","insp_unit_company":"113","insp_unit_license":"E185114","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"526114625D1000431","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:23.000000Z","updated_at":"2025-03-17T22:14:23.000000Z"}]},{"id":516467,"change_date":"2022-05-31 21:42:00","inspection_id":"75708962","dot_number":"437159","report_state":"OH","report_number":"3259012109","insp_date":"2022-05-30 00:00:00","insp_start_time":"0809","insp_end_time":"0839","registration_date":null,"region":"ET","ci_status_code":"C","location":"06375","location_desc":"FINDLAY SCALES","county_code_state":"OH","county_code":"063","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"CAPITOL BEVERAGE CO","shipping_paper_number":"110627106","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-05-31 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1599849","transaction_code":"A","transaction_date":"2022-05-30 00:00:00","upload_date":"2022-05-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00437159","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-05-31 00:00:00","source_office":"3OHS001","mcmis_add_date":"2022-05-31 21:42:00","insp_carrier_name":"CAPITOL BEVERAGE COMPANY INC","insp_carrier_street":"5500 AURELIUS RD","insp_carrier_city":"LANSING","insp_carrier_state":"MI","insp_carrier_zip_code":"48911-4120","insp_colonia":null,"docket_number":"518251","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:36:43.000000Z","updated_at":"2025-03-17T18:36:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":831297,"change_date":"2022-05-31 21:42:00","inspection_id":"75708962","insp_unit_id":"188994199","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"916","insp_unit_license":"RB29323","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKYD49X0GJ117133","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:20.000000Z","updated_at":"2025-03-17T22:13:20.000000Z"},{"id":831298,"change_date":"2022-05-31 21:42:00","inspection_id":"75708962","insp_unit_id":"188994200","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":null,"insp_unit_license":"B624834","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"DW1A53224B657107","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:20.000000Z","updated_at":"2025-03-17T22:13:20.000000Z"}]},{"id":53420,"change_date":"2022-03-28 21:41:00","inspection_id":"75153552","dot_number":"437159","report_state":"OH","report_number":"3259011941","insp_date":"2022-03-28 00:00:00","insp_start_time":"0750","insp_end_time":"0820","registration_date":null,"region":"ET","ci_status_code":"C","location":"06375","location_desc":"FINDLAY SCALES","county_code_state":"OH","county_code":"063","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-03-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1588211","transaction_code":"A","transaction_date":"2022-03-28 00:00:00","upload_date":"2022-03-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00437159","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-03-28 00:00:00","source_office":"3OHS001","mcmis_add_date":"2022-03-28 21:41:00","insp_carrier_name":"CAPITOL BEVERAGE COMPANY INC","insp_carrier_street":"5500 AURELIUS RD","insp_carrier_city":"LANSING","insp_carrier_state":"MI","insp_carrier_zip_code":"48911-4120","insp_colonia":null,"docket_number":"518251","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:28:27.000000Z","updated_at":"2025-03-17T18:28:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":86474,"change_date":"2022-03-28 21:41:00","inspection_id":"75153552","insp_unit_id":"187850025","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"816","insp_unit_license":"RB29322","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKYD49X9GJ117132","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:47.000000Z","updated_at":"2025-03-17T22:08:47.000000Z"},{"id":86475,"change_date":"2022-03-28 21:41:00","inspection_id":"75153552","insp_unit_id":"187850026","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"53214","insp_unit_license":"D014139","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532C0ET073088","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:47.000000Z","updated_at":"2025-03-17T22:08:47.000000Z"}]},{"id":27993,"change_date":"2022-04-25 21:41:00","inspection_id":"75120585","dot_number":"437159","report_state":"MI","report_number":"MOREM03965","insp_date":"2022-03-22 00:00:00","insp_start_time":"0758","insp_end_time":"0820","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"HOWE RD W","county_code_state":"MI","county_code":"037","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"MULTIPLE","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-03-23 21:32:00","post_acc_ind":"N","gross_comb_veh_wt":"88000","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":"1068757","transaction_code":"C","transaction_date":"2022-04-21 00:00:00","upload_date":"2022-04-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00437159","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-03-22 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-03-23 21:32:00","insp_carrier_name":"CAPITOL BEVERAGE COMPANY INC","insp_carrier_street":"5500 AURELIUS RD","insp_carrier_city":"LANSING","insp_carrier_state":"MI","insp_carrier_zip_code":"48911","insp_colonia":null,"docket_number":"518251","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:28:05.000000Z","updated_at":"2025-03-17T18:28:05.000000Z","inspection_violations":[{"id":39810,"change_date":"2022-04-25 21:41:00","inspection_id":"75120585","insp_violation_id":"245344390","seq_no":"1","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:16.000000Z","updated_at":"2025-03-17T21:07:16.000000Z","normalized_code":"39141A"},{"id":39811,"change_date":"2022-04-25 21:41:00","inspection_id":"75120585","insp_violation_id":"245344391","seq_no":"2","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:07:16.000000Z","updated_at":"2025-03-17T21:07:16.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":44985,"change_date":"2022-04-25 21:41:00","inspection_id":"75120585","insp_unit_id":"188316266","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"RT9510","insp_unit_license":"AC91234","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2XKHAM7X7AM261502","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:32.000000Z","updated_at":"2025-03-17T22:08:32.000000Z"},{"id":44986,"change_date":"2022-04-25 21:41:00","inspection_id":"75120585","insp_unit_id":"188316267","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRIB","insp_unit_company":"108","insp_unit_license":"B687626","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1T9BA42277C178129","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:32.000000Z","updated_at":"2025-03-17T22:08:32.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/437159\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/437159\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/437159\/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\/437159\/inspections","per_page":100,"prev_page_url":null,"to":17,"total":17}